[Home] [Help]
820: FII_UTIL.start_timer;
821: end if;
822:
823: ---------------------------------------------------------------------
824: -- Inserting processed JE Header IDs into FII_FA_EXP_HDR_IDS
825: -- table. Not all JE Header IDs in FII_FA_NEW_EXP_HDR_IDS are
826: -- processed. This is because when we select Header IDs to be
827: -- processed (refer to NEW_JOURNALS function), we only filter by SOB
828: -- in FII_COMPANY_SETS table, however when we extract data from OLTP
828: -- in FII_COMPANY_SETS table, however when we extract data from OLTP
829: -- tables, we actually filter data by both SOB and Company
830: ---------------------------------------------------------------------
831:
832: INSERT INTO fii_fa_exp_hdr_ids (
833: je_header_id,
834: creation_date,
835: created_by,
836: last_update_date,
845: g_fii_user_id
846: FROM fii_fa_new_exp_hdr_ids;
847:
848: if g_debug_flag = 'Y' then
849: FII_UTIL.put_line('Updated ' || SQL%ROWCOUNT || ' rows into FII_FA_EXP_HDR_IDS');
850: FII_UTIL.stop_timer;
851: FII_UTIL.print_timer('Duration');
852: end if;
853:
966: and glh.ledger_id = fset.ledger_id
967: and glh.ledger_id = xlah.ledger_id
968: and not exists
969: (select 1
970: from fii_fa_exp_hdr_ids faph
971: where faph.je_header_id = fiiglh.je_header_id)) nid;
972:
973: l_number_of_rows := SQL%ROWCOUNT;
974:
984:
985: else -- initial
986:
987: -- Fetch all rows from FA_JOURNAL_ENTRIES which are not rolled back
988: -- and insert into FII_FA_EXP_HDR_IDS table.
989:
990: -- R12: for efficiency, we will use group_id instead of ae_header_id
991: -- for access in initial mode
992:
2162:
2163: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_EXP_F',
2164: P_RETCODE => l_ret_code);
2165:
2166: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_EXP_HDR_IDS',
2167: P_RETCODE => l_ret_code);
2168:
2169: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_NEW_EXP_HDR_IDS',
2170: P_RETCODE => l_ret_code);