APPS.FII_AP_INV_SUM_INIT dependencies on AP_DBI_LOG

Line 6965: --Get timestamps used to maintain ap_dbi_log.

6961: END IF;
6962:
6963: IF g_exp_imp_prof_flag = 'Y' THEN
6964: ------------------------------------------------------------
6965: --Get timestamps used to maintain ap_dbi_log.
6966: --g_timestamp1 - current timestamp.
6967: --g_timestamp2 - last Payables Operation/Expenses load.
6968: --g_timestamp3 - last Payables Expenses load.
6969: -------------------------------------------------------------

Line 6970: g_state := 'Defining timestamps to maintain ap_dbi_log.';

6966: --g_timestamp1 - current timestamp.
6967: --g_timestamp2 - last Payables Operation/Expenses load.
6968: --g_timestamp3 - last Payables Expenses load.
6969: -------------------------------------------------------------
6970: g_state := 'Defining timestamps to maintain ap_dbi_log.';
6971: IF g_debug_flag = 'Y' then
6972: FII_UTIL.put_line('');
6973: FII_UTIL.put_line(g_state);
6974: fii_util.put_line('');

Line 7011: g_state := 'Truncating AP_DBI_LOG.';

7007: g_act_part1 := MOD(TO_NUMBER(TO_CHAR(TRUNC(g_timestamp1), 'J')), 32);
7008: g_act_part2 := MOD(TO_NUMBER(TO_CHAR(TRUNC(g_timestamp1+1), 'J')), 32);
7009:
7010: ELSE --Payables Expenses is not implemented, so it is safe to truncate log table.
7011: g_state := 'Truncating AP_DBI_LOG.';
7012: EXECUTE IMMEDIATE('TRUNCATE TABLE ' || g_ap_schema || '.AP_DBI_LOG');
7013: END IF;
7014:
7015: if g_debug_flag = 'Y' then

Line 7012: EXECUTE IMMEDIATE('TRUNCATE TABLE ' || g_ap_schema || '.AP_DBI_LOG');

7008: g_act_part2 := MOD(TO_NUMBER(TO_CHAR(TRUNC(g_timestamp1+1), 'J')), 32);
7009:
7010: ELSE --Payables Expenses is not implemented, so it is safe to truncate log table.
7011: g_state := 'Truncating AP_DBI_LOG.';
7012: EXECUTE IMMEDIATE('TRUNCATE TABLE ' || g_ap_schema || '.AP_DBI_LOG');
7013: END IF;
7014:
7015: if g_debug_flag = 'Y' then
7016: FII_UTIL.put_line('Current Load Timestamp is: ' || to_char(g_timestamp1, 'YYYY/MM/DD HH24:MI:SS'));

Line 7165: FOR i IN 0..31 LOOP --i represents the partition of ap_dbi_log.

7161: g_retcode := 0;
7162:
7163:
7164: IF g_exp_imp_prof_flag = 'Y' THEN
7165: FOR i IN 0..31 LOOP --i represents the partition of ap_dbi_log.
7166:
7167: IF g_timestamp3 + 30 >= g_timestamp1 THEN --Copy records into Expense log table.
7168: INSERT INTO FII_AP_DBI_LOG_EXP_T(
7169: Table_Name,

Line 7168: INSERT INTO FII_AP_DBI_LOG_EXP_T(

7164: IF g_exp_imp_prof_flag = 'Y' THEN
7165: FOR i IN 0..31 LOOP --i represents the partition of ap_dbi_log.
7166:
7167: IF g_timestamp3 + 30 >= g_timestamp1 THEN --Copy records into Expense log table.
7168: INSERT INTO FII_AP_DBI_LOG_EXP_T(
7169: Table_Name,
7170: Operation_Flag,
7171: Key_Value1_ID,
7172: Key_Value2_ID,

Line 7187: FROM AP_DBI_LOG

7183: Last_Updated_By,
7184: Last_Update_Login,
7185: Creation_Date,
7186: Last_Update_Date
7187: FROM AP_DBI_LOG
7188: WHERE Partition_ID = i
7189: AND Creation_Date >= g_timestamp2
7190: AND Creation_Date < g_timestamp1;
7191: END IF;

Line 7194: EXECUTE IMMEDIATE 'ALTER TABLE ' || g_ap_schema || '.AP_DBI_LOG TRUNCATE PARTITION P' || to_char(i);

7190: AND Creation_Date < g_timestamp1;
7191: END IF;
7192:
7193: IF NOT (i = g_act_part1 OR i = g_act_part2) THEN --This is a non-active partition.
7194: EXECUTE IMMEDIATE 'ALTER TABLE ' || g_ap_schema || '.AP_DBI_LOG TRUNCATE PARTITION P' || to_char(i);
7195: END IF;
7196:
7197: END LOOP;
7198:

Line 7201: TRUNCATE_TABLE('FII_AP_DBI_LOG_PS_T');

7197: END LOOP;
7198:
7199: END IF;
7200:
7201: TRUNCATE_TABLE('FII_AP_DBI_LOG_PS_T');
7202:
7203:
7204: g_state := 'Truncating temp tables after used to populate base tables';
7205: TRUNCATE_TABLE('FII_AP_PAY_SCHED_TEMP');