DBA Data[Home] [Help]

APPS.FII_AP_INV_DISTRIBUTIONS_B_C dependencies on FII_AP_DBI_LOG_PS_T

Line 818: g_state := 'Copying records from partition ' || i || ' into FII_AP_DBI_LOG_PS_T.';

814: FOR i IN 0..31 LOOP --i represents the partition of ap_dbi_log.
815:
816: IF g_timestamp3 + 30 >= g_timestamp1 AND g_oper_imp_prof_flag = 'Y' THEN --Copy records into Operations log table.
817:
818: g_state := 'Copying records from partition ' || i || ' into FII_AP_DBI_LOG_PS_T.';
819:
820: INSERT INTO FII_AP_DBI_LOG_PS_T(
821: Table_Name,
822: Operation_Flag,

Line 820: INSERT INTO FII_AP_DBI_LOG_PS_T(

816: IF g_timestamp3 + 30 >= g_timestamp1 AND g_oper_imp_prof_flag = 'Y' THEN --Copy records into Operations log table.
817:
818: g_state := 'Copying records from partition ' || i || ' into FII_AP_DBI_LOG_PS_T.';
819:
820: INSERT INTO FII_AP_DBI_LOG_PS_T(
821: Table_Name,
822: Operation_Flag,
823: Key_Value1_ID,
824: Key_Value2_ID,

Line 1387: INSERT INTO FII_AP_DBI_LOG_PS_T(

1383: IF g_oper_imp_prof_flag = 'Y' THEN
1384: FOR i IN 0..31 LOOP --i represents the partition of ap_dbi_log.
1385:
1386: IF g_timestamp3 + 30 >= g_timestamp1 THEN --Copy records into Operations log table.
1387: INSERT INTO FII_AP_DBI_LOG_PS_T(
1388: Table_Name,
1389: Operation_Flag,
1390: Key_Value1_ID,
1391: Key_Value2_ID,