[Home] [Help]
1945:
1946: Since we cannot insert and select from the same table at the same time we will
1947: select from the pay sched sum table and insert into the temp table */
1948:
1949: INSERT INTO FII_AP_PAY_SCHED_TEMP
1950: (Time_ID,
1951: Period_Type_ID,
1952: Action_Date,
1953: Action,
2172: AIP.Invoice_Payment_ID;
2173:
2174:
2175: if g_debug_flag = 'Y' then
2176: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' Last Payment records into FII_AP_PAY_SCHED_TEMP ');
2177: FII_UTIL.put_timestamp('End Timestamp');
2178: FII_UTIL.stop_timer;
2179: FII_UTIL.print_timer('Duration');
2180: FII_UTIL.put_line('');
2411: g_fii_login_id Last_Update_Login,
2412: TEMP.Inv_Pymt_Flag,
2413: TEMP.Unique_ID
2414: FROM FII_AP_Invoice_B AI,
2415: FII_AP_Pay_Sched_Temp TEMP,
2416: FII_AP_PS_Rates_Temp RATES,
2417: FII_AP_Func_Rates_Temp FRATES
2418: WHERE TEMP.Invoice_ID = AI.Invoice_ID
2419: AND AI.Invoice_ID BETWEEN g_start_range and g_end_range
7029: g_state := 'Truncating temp tables used to populate base tables';
7030: TRUNCATE_TABLE('FII_AP_PS_RATES_TEMP');
7031: TRUNCATE_TABLE('FII_AP_FUNC_RATES_TEMP');
7032: TRUNCATE_TABLE('FII_AP_PS_WORK_JOBS');
7033: TRUNCATE_TABLE('FII_AP_PAY_SCHED_TEMP');
7034: TRUNCATE_TABLE('FII_AP_WH_TAX_T');
7035: TRUNCATE_TABLE('FII_AP_PREPAY_T');
7036: TRUNCATE_TABLE('FII_AP_PAY_CHK_STG');
7037:
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');
7206: TRUNCATE_TABLE('FII_AP_WH_TAX_T');
7207: TRUNCATE_TABLE('FII_AP_PREPAY_T');
7208: TRUNCATE_TABLE('FII_AP_PS_WORK_JOBS');
7209: TRUNCATE_TABLE('FII_AP_PAY_CHK_STG');