[Home] [Help]
3302: if gbl_error_code = 0 then
3303:
3304: COMMIT;
3305:
3306: Fnd_Stats.GATHER_TABLE_STATS(ownname=>'FV',tabname=>'FV_FACTS1_FED_ACCOUNTS');
3307:
3308: /* check whether to call the Journal creation automatically
3309: if there are new accounts created , then call the journal creation process
3310: until the last period the journal creation process ran for that sob and year */
3320: if (l_period_num > 0) then
3321:
3322: /* Journal creation process already ran , so need to pikc journals for new a/c */
3323:
3324: select count(*) into l_no_new_accounts from fv_facts1_fed_accounts
3325: where set_of_books_id = gbl_set_of_books_id
3326: AND fiscal_year = gbl_fiscal_year
3327: and jc_flag = 'N';
3328:
3420:
3421: BEGIN
3422: SELECT fed_non_fed
3423: INTO vl_dummy
3424: FROM fv_facts1_fed_accounts
3425: WHERE account_number = vg_acct_number
3426: AND set_of_books_id = gbl_set_of_books_id
3427: AND fiscal_year = gbl_fiscal_year; --vg_sob_id;
3428:
3431:
3432: -- To handle if the child is already processed
3433: -- before parent.
3434: IF gbl_parent_flag = 'N' THEN
3435: UPDATE fv_facts1_fed_accounts
3436: SET fed_non_fed = vg_fed_nonfed
3437: WHERE account_number = vg_acct_number
3438: AND set_of_books_id = gbl_set_of_books_id
3439: AND fiscal_year = gbl_fiscal_year;
3459:
3460:
3461: EXCEPTION
3462: WHEN NO_DATA_FOUND THEN
3463: INSERT INTO fv_facts1_fed_accounts
3464: (account_number,
3465: sgl_account_number,
3466: set_of_books_id,
3467: fed_non_fed,