eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_FA_EXP_B_C dependencies on FII_FA_NEW_EXP_HDR_IDS

Line 504: FROM FII_FA_NEW_EXP_HDR_IDS;

500: g_phase := 'select min and max dist ids';
501:
502: SELECT NVL(max(record_id), 0), nvl(min(record_id),1)
503: INTO l_max_number, l_start_number
504: FROM FII_FA_NEW_EXP_HDR_IDS;
505:
506: WHILE (l_start_number <= l_max_number) LOOP
507: l_end_number:= l_start_number + g_child_process_size;
508: g_phase := 'Loop to insert into FII_FA_WORKER_JOBS: '

Line 784: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_NEW_EXP_HDR_IDS',

780: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_WORKER_JOBS',
781: P_RETCODE => l_ret_code);
782:
783: IF (g_truncate_id) THEN
784: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_NEW_EXP_HDR_IDS',
785: P_RETCODE => l_ret_code);
786: END IF;
787:
788: IF (g_truncate_stg) THEN

Line 825: -- table. Not all JE Header IDs in FII_FA_NEW_EXP_HDR_IDS are

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
829: -- tables, we actually filter data by both SOB and Company

Line 846: FROM fii_fa_new_exp_hdr_ids;

842: g_fii_user_id,
843: sysdate,
844: g_fii_login_id,
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;

Line 910: fii_fa_new_exp_hdr_ids

906:
907: -- NOTE FIX THIS - should probably put in stage then update later (update or new row?)
908:
909: insert into
910: fii_fa_new_exp_hdr_ids
911: (JE_HEADER_ID ,
912: AE_HEADER_ID ,
913: EVENT_TYPE_CODE ,
914: EVENT_ID ,

Line 977: ' JE header IDs into FII_FA_NEW_EXP_HDR_IDS for new entries');

973: l_number_of_rows := SQL%ROWCOUNT;
974:
975: if g_debug_flag = 'Y' then
976: FII_UTIL.put_line('Inserted '||l_number_of_rows||
977: ' JE header IDs into FII_FA_NEW_EXP_HDR_IDS for new entries');
978: FII_UTIL.stop_timer;
979: FII_UTIL.print_timer('Duration');
980: FII_UTIL.put_line('');
981: end if;

Line 1002: into fii_fa_new_exp_hdr_ids i

998: -- BUG# 4996218
999: -- remove reliance on group_id
1000:
1001: insert /*+ append parallel(i) */
1002: into fii_fa_new_exp_hdr_ids i
1003: (JE_HEADER_ID ,
1004: LEDGER_ID ,
1005: CREATION_DATE ,
1006: CREATED_BY ,

Line 1042: ' JE header IDs into FII_FA_NEW_EXP_HDR_IDS for main processing');

1038:
1039: l_number_of_rows := SQL%ROWCOUNT;
1040: if g_debug_flag = 'Y' then
1041: FII_UTIL.put_line('Inserted '||l_number_of_rows||
1042: ' JE header IDs into FII_FA_NEW_EXP_HDR_IDS for main processing');
1043: FII_UTIL.stop_timer;
1044: FII_UTIL.print_timer('Duration');
1045: FII_UTIL.put_line('');
1046: end if;

Line 1084: from fii_fa_new_exp_hdr_ids nid,

1080:
1081: delete from fii_fa_exp_f
1082: where xla_event_id in
1083: (select ev_dep.event_id
1084: from fii_fa_new_exp_hdr_ids nid,
1085: xla_events ev_rb,
1086: xla_events ev_dep
1087: where nid.record_id between p_start_range and p_end_range
1088: and nid.event_type_code = 'ROLLBACK_DEPRECIATION'

Line 1395: from fii_fa_new_exp_hdr_ids nid,

1391: g_fii_user_id,
1392: g_fii_login_id,
1393: nid.event_id,
1394: nid.ae_header_id
1395: from fii_fa_new_exp_hdr_ids nid,
1396: xla_ae_lines lines,
1397: fii_fa_acct_class_code_gt acls,
1398: fii_gl_ccid_dimensions ccid,
1399: gl_ledgers_public_v sob,

Line 1525: from fii_fa_new_exp_hdr_ids nid,

1521: g_fii_user_id,
1522: g_fii_login_id,
1523: nid.event_id,
1524: nid.ae_header_id
1525: from fii_fa_new_exp_hdr_ids nid,
1526: xla_ae_lines lines,
1527: fii_fa_acct_class_code_gt acls,
1528: fii_gl_ccid_dimensions ccid,
1529: gl_ledgers_public_v sob,

Line 1728: from fii_fa_new_exp_hdr_ids nid,

1724: g_fii_user_id,
1725: g_fii_login_id,
1726: headers.event_id,
1727: headers.ae_header_id
1728: from fii_fa_new_exp_hdr_ids nid,
1729: gl_import_references gir,
1730: fii_fa_acct_class_code_gt acls,
1731: xla_ae_lines lines,
1732: xla_ae_headers headers,

Line 1891: from fii_fa_new_exp_hdr_ids nid,

1887: g_fii_user_id,
1888: g_fii_login_id,
1889: headers.event_id,
1890: headers.ae_header_id
1891: from fii_fa_new_exp_hdr_ids nid,
1892: gl_import_references gir,
1893: fii_fa_acct_class_code_gt acls,
1894: xla_ae_lines lines,
1895: xla_ae_headers headers,

Line 2169: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_NEW_EXP_HDR_IDS',

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);
2171:
2172:
2173: COMMIT;

Line 2299: -- FII_FA_NEW_EXP_HDR_IDS

2295: g_truncate_id := FALSE;
2296:
2297: ---------------------------------------------------------------
2298: -- Call New_Journals routine to insert Journal header ids into
2299: -- FII_FA_NEW_EXP_HDR_IDS
2300: ----------------------------------------------------------------
2301: g_phase := 'Identify New Journal Headers to process';
2302: if g_debug_flag = 'Y' then
2303: FII_UTIL.put_line(g_phase);

Line 2318: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_NEW_EXP_HDR_IDS',

2314: l_period_end_date);
2315:
2316: IF (l_ids_count = 0) THEN
2317: -- purge the new ids table for deleted lines
2318: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_NEW_EXP_HDR_IDS',
2319: P_RETCODE => l_ret_code);
2320:
2321: if g_debug_flag = 'Y' then
2322: FII_UTIL.put_line('No Journal Entries to Process, exit.');