APPS.FII_AP_INV_SUM_INIT dependencies on FII_AP_INV_HOLDS_B

Line 1097: g_state := 'Deleting records from FII_AP_INV_HOLDS_B that are already existing';

1093: PROCEDURE POPULATE_HOLDS_SUM IS
1094:
1095: BEGIN
1096:
1097: g_state := 'Deleting records from FII_AP_INV_HOLDS_B that are already existing';
1098: if g_debug_flag = 'Y' then
1099: FII_UTIL.put_line('');
1100: FII_UTIL.put_line(g_state);
1101: end if;

Line 1105: TRUNCATE_TABLE('MLOG$_FII_AP_INV_HOLDS_B');

1101: end if;
1102:
1103: /* For Initial Load we will truncate the data in the holds summary table
1104: and re-populate this table */
1105: TRUNCATE_TABLE('MLOG$_FII_AP_INV_HOLDS_B');
1106: TRUNCATE_TABLE('FII_AP_INV_HOLDS_B');
1107:
1108:
1109: g_state := 'Populating FII_AP_INV_HOLDS_B FROM AP_HOLDS_ALL table';

Line 1106: TRUNCATE_TABLE('FII_AP_INV_HOLDS_B');

1102:
1103: /* For Initial Load we will truncate the data in the holds summary table
1104: and re-populate this table */
1105: TRUNCATE_TABLE('MLOG$_FII_AP_INV_HOLDS_B');
1106: TRUNCATE_TABLE('FII_AP_INV_HOLDS_B');
1107:
1108:
1109: g_state := 'Populating FII_AP_INV_HOLDS_B FROM AP_HOLDS_ALL table';
1110: if g_debug_flag = 'Y' then

Line 1109: g_state := 'Populating FII_AP_INV_HOLDS_B FROM AP_HOLDS_ALL table';

1105: TRUNCATE_TABLE('MLOG$_FII_AP_INV_HOLDS_B');
1106: TRUNCATE_TABLE('FII_AP_INV_HOLDS_B');
1107:
1108:
1109: g_state := 'Populating FII_AP_INV_HOLDS_B FROM AP_HOLDS_ALL table';
1110: if g_debug_flag = 'Y' then
1111: FII_UTIL.put_line(g_state);
1112: FII_UTIL.start_timer;
1113: FII_UTIL.put_line('');

Line 1116: INSERT /*+ append parallel(S) */ INTO FII_AP_INV_HOLDS_B S

1112: FII_UTIL.start_timer;
1113: FII_UTIL.put_line('');
1114: end if;
1115:
1116: INSERT /*+ append parallel(S) */ INTO FII_AP_INV_HOLDS_B S
1117: (Time_ID,
1118: Period_Type_ID,
1119: Org_ID,
1120: Supplier_ID,

Line 1180: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' records into FII_AP_INV_HOLDS_B');

1176: AND TRUNC(AH.Hold_Date) >= g_start_date
1177: AND TRUNC(AH.Hold_Date) + 0 <= g_end_date + 0.99999;
1178:
1179: if g_debug_flag = 'Y' then
1180: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' records into FII_AP_INV_HOLDS_B');
1181: FII_UTIL.put_line('');
1182: FII_UTIL.stop_timer;
1183: FII_UTIL.print_timer('Duration');
1184: end if;