API to Validate accounts and Cross Validation Rules
I was wondering how does the API fnd_flex.get_ccid works, hence I was wondering whether you can share with me any example.
I have just the following information
You should code it like this:
ccid := FND_FLEX_EXT.GET_CCID
( 'SQLGL'
, 'GL#'
, '50332'
, fnd_date.date_to_canonical(SYSDATE)
, '<your vsegs'
);
Another example
DECLARE
-- pragma autonomous_transaction; -- if you need autonomy!
p_concat_segs VARCHAR2(1000) := '09411.96042.81000000.4230.00000.00000.0000';
l_keyval_status BOOLEAN;
l_coa_id NUMBER;
begin
begin
select chart_of_accounts_id
into l_coa_id
from gl_sets_of_books
where set_of_books_id = fnd_profile.value('GL_SET_OF_BKS_ID');