[Home] [Help]
3380: if gbl_error_code = 0 then
3381:
3382: COMMIT;
3383:
3384: Fnd_Stats.GATHER_TABLE_STATS(ownname=>'FV',tabname=>'FV_FACTS1_FED_ACCOUNTS');
3385:
3386: /* check whether to call the Journal creation automatically
3387: if there are new accounts created , then call the journal creation process
3388: until the last period the journal creation process ran for that sob and year */
3398: if (l_period_num > 0) then
3399:
3400: /* Journal creation process already ran , so need to pikc journals for new a/c */
3401:
3402: select count(*) into l_no_new_accounts from fv_facts1_fed_accounts
3403: where set_of_books_id = gbl_set_of_books_id
3404: AND fiscal_year = gbl_fiscal_year
3405: and jc_flag = 'N';
3406:
3498:
3499: BEGIN
3500: SELECT fed_non_fed
3501: INTO vl_dummy
3502: FROM fv_facts1_fed_accounts
3503: WHERE account_number = vg_acct_number
3504: AND set_of_books_id = gbl_set_of_books_id
3505: AND fiscal_year = gbl_fiscal_year; --vg_sob_id;
3506:
3509:
3510: -- To handle if the child is already processed
3511: -- before parent.
3512: IF gbl_parent_flag = 'N' THEN
3513: UPDATE fv_facts1_fed_accounts
3514: SET fed_non_fed = vg_fed_nonfed
3515: WHERE account_number = vg_acct_number
3516: AND set_of_books_id = gbl_set_of_books_id
3517: AND fiscal_year = gbl_fiscal_year;
3537:
3538:
3539: EXCEPTION
3540: WHEN NO_DATA_FOUND THEN
3541: INSERT INTO fv_facts1_fed_accounts
3542: (account_number,
3543: sgl_account_number,
3544: set_of_books_id,
3545: fed_non_fed,