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.CSTPPWAC dependencies on CSTPPINV

Line 2308: IF (CSTPPINV.l_item_start_index_tbl.EXISTS (i_item_id)) THEN

2304: BEGIN
2305: l_index := -1;
2306:
2307: -- Check if the item-cost_element_id-level_type combination exists
2308: IF (CSTPPINV.l_item_start_index_tbl.EXISTS (i_item_id)) THEN
2309: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))
2310: LOOP
2311: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND
2312: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND

Line 2309: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))

2305: l_index := -1;
2306:
2307: -- Check if the item-cost_element_id-level_type combination exists
2308: IF (CSTPPINV.l_item_start_index_tbl.EXISTS (i_item_id)) THEN
2309: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))
2310: LOOP
2311: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND
2312: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND
2313: CSTPPINV.l_level_type_tbl(l_count) = x.level_type) THEN

Line 2311: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND

2307: -- Check if the item-cost_element_id-level_type combination exists
2308: IF (CSTPPINV.l_item_start_index_tbl.EXISTS (i_item_id)) THEN
2309: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))
2310: LOOP
2311: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND
2312: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND
2313: CSTPPINV.l_level_type_tbl(l_count) = x.level_type) THEN
2314: l_index := l_count;
2315: END IF;

Line 2312: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND

2308: IF (CSTPPINV.l_item_start_index_tbl.EXISTS (i_item_id)) THEN
2309: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))
2310: LOOP
2311: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND
2312: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND
2313: CSTPPINV.l_level_type_tbl(l_count) = x.level_type) THEN
2314: l_index := l_count;
2315: END IF;
2316: END LOOP;

Line 2313: CSTPPINV.l_level_type_tbl(l_count) = x.level_type) THEN

2309: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))
2310: LOOP
2311: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND
2312: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND
2313: CSTPPINV.l_level_type_tbl(l_count) = x.level_type) THEN
2314: l_index := l_count;
2315: END IF;
2316: END LOOP;
2317: ELSE

Line 2318: CSTPPINV.l_item_start_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;

2314: l_index := l_count;
2315: END IF;
2316: END LOOP;
2317: ELSE
2318: CSTPPINV.l_item_start_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;
2319: CSTPPINV.l_item_end_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;
2320: END IF;
2321: IF (l_index = -1) THEN
2322: -- Combination not found: Insert intp PL/SQL table

Line 2319: CSTPPINV.l_item_end_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;

2315: END IF;
2316: END LOOP;
2317: ELSE
2318: CSTPPINV.l_item_start_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;
2319: CSTPPINV.l_item_end_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;
2320: END IF;
2321: IF (l_index = -1) THEN
2322: -- Combination not found: Insert intp PL/SQL table
2323: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;

Line 2323: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;

2319: CSTPPINV.l_item_end_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;
2320: END IF;
2321: IF (l_index = -1) THEN
2322: -- Combination not found: Insert intp PL/SQL table
2323: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;
2324: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
2325: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
2326: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
2327: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;

Line 2324: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;

2320: END IF;
2321: IF (l_index = -1) THEN
2322: -- Combination not found: Insert intp PL/SQL table
2323: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;
2324: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
2325: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
2326: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
2327: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
2328: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;

Line 2325: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;

2321: IF (l_index = -1) THEN
2322: -- Combination not found: Insert intp PL/SQL table
2323: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;
2324: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
2325: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
2326: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
2327: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
2328: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
2329: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;

Line 2326: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;

2322: -- Combination not found: Insert intp PL/SQL table
2323: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;
2324: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
2325: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
2326: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
2327: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
2328: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
2329: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
2330:

Line 2327: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;

2323: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;
2324: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
2325: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
2326: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
2327: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
2328: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
2329: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
2330:
2331: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost * i_txn_qty;

Line 2328: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;

2324: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
2325: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
2326: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
2327: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
2328: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
2329: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
2330:
2331: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost * i_txn_qty;
2332: CSTPPINV.l_make_balance_tbl(l_index) := x.actual_cost * i_make_qty;

Line 2329: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;

2325: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
2326: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
2327: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
2328: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
2329: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
2330:
2331: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost * i_txn_qty;
2332: CSTPPINV.l_make_balance_tbl(l_index) := x.actual_cost * i_make_qty;
2333: CSTPPINV.l_buy_balance_tbl(l_index) := x.actual_cost * i_buy_qty;

Line 2331: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost * i_txn_qty;

2327: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
2328: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
2329: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
2330:
2331: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost * i_txn_qty;
2332: CSTPPINV.l_make_balance_tbl(l_index) := x.actual_cost * i_make_qty;
2333: CSTPPINV.l_buy_balance_tbl(l_index) := x.actual_cost * i_buy_qty;
2334:
2335: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;

Line 2332: CSTPPINV.l_make_balance_tbl(l_index) := x.actual_cost * i_make_qty;

2328: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
2329: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
2330:
2331: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost * i_txn_qty;
2332: CSTPPINV.l_make_balance_tbl(l_index) := x.actual_cost * i_make_qty;
2333: CSTPPINV.l_buy_balance_tbl(l_index) := x.actual_cost * i_buy_qty;
2334:
2335: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;
2336: ELSE

Line 2333: CSTPPINV.l_buy_balance_tbl(l_index) := x.actual_cost * i_buy_qty;

2329: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
2330:
2331: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost * i_txn_qty;
2332: CSTPPINV.l_make_balance_tbl(l_index) := x.actual_cost * i_make_qty;
2333: CSTPPINV.l_buy_balance_tbl(l_index) := x.actual_cost * i_buy_qty;
2334:
2335: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;
2336: ELSE
2337: -- Combination found: Update balance in PL/SQL table.

Line 2335: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;

2331: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost * i_txn_qty;
2332: CSTPPINV.l_make_balance_tbl(l_index) := x.actual_cost * i_make_qty;
2333: CSTPPINV.l_buy_balance_tbl(l_index) := x.actual_cost * i_buy_qty;
2334:
2335: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;
2336: ELSE
2337: -- Combination found: Update balance in PL/SQL table.
2338: CSTPPINV.l_item_balance_tbl(l_index) := (x.actual_cost * i_txn_qty) + CSTPPINV.l_item_balance_tbl(l_index);
2339: CSTPPINV.l_make_balance_tbl(l_index) := (x.actual_cost * i_make_qty) + CSTPPINV.l_make_balance_tbl(l_index);

Line 2338: CSTPPINV.l_item_balance_tbl(l_index) := (x.actual_cost * i_txn_qty) + CSTPPINV.l_item_balance_tbl(l_index);

2334:
2335: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;
2336: ELSE
2337: -- Combination found: Update balance in PL/SQL table.
2338: CSTPPINV.l_item_balance_tbl(l_index) := (x.actual_cost * i_txn_qty) + CSTPPINV.l_item_balance_tbl(l_index);
2339: CSTPPINV.l_make_balance_tbl(l_index) := (x.actual_cost * i_make_qty) + CSTPPINV.l_make_balance_tbl(l_index);
2340: CSTPPINV.l_buy_balance_tbl(l_index) := (x.actual_cost * i_buy_qty) + CSTPPINV.l_buy_balance_tbl(l_index);
2341: END IF;
2342: END;

Line 2339: CSTPPINV.l_make_balance_tbl(l_index) := (x.actual_cost * i_make_qty) + CSTPPINV.l_make_balance_tbl(l_index);

2335: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;
2336: ELSE
2337: -- Combination found: Update balance in PL/SQL table.
2338: CSTPPINV.l_item_balance_tbl(l_index) := (x.actual_cost * i_txn_qty) + CSTPPINV.l_item_balance_tbl(l_index);
2339: CSTPPINV.l_make_balance_tbl(l_index) := (x.actual_cost * i_make_qty) + CSTPPINV.l_make_balance_tbl(l_index);
2340: CSTPPINV.l_buy_balance_tbl(l_index) := (x.actual_cost * i_buy_qty) + CSTPPINV.l_buy_balance_tbl(l_index);
2341: END IF;
2342: END;
2343: END LOOP;

Line 2340: CSTPPINV.l_buy_balance_tbl(l_index) := (x.actual_cost * i_buy_qty) + CSTPPINV.l_buy_balance_tbl(l_index);

2336: ELSE
2337: -- Combination found: Update balance in PL/SQL table.
2338: CSTPPINV.l_item_balance_tbl(l_index) := (x.actual_cost * i_txn_qty) + CSTPPINV.l_item_balance_tbl(l_index);
2339: CSTPPINV.l_make_balance_tbl(l_index) := (x.actual_cost * i_make_qty) + CSTPPINV.l_make_balance_tbl(l_index);
2340: CSTPPINV.l_buy_balance_tbl(l_index) := (x.actual_cost * i_buy_qty) + CSTPPINV.l_buy_balance_tbl(l_index);
2341: END IF;
2342: END;
2343: END LOOP;
2344:

Line 2346: IF CSTPPINV.l_item_quantity_tbl.EXISTS (i_item_id) THEN

2342: END;
2343: END LOOP;
2344:
2345: -- Insert/Update quantities in PL/SQL tables
2346: IF CSTPPINV.l_item_quantity_tbl.EXISTS (i_item_id) THEN
2347: CSTPPINV.l_item_quantity_tbl(i_item_id) := i_txn_qty + CSTPPINV.l_item_quantity_tbl(i_item_id);
2348: ELSE
2349: CSTPPINV.l_item_quantity_tbl(i_item_id):= i_txn_qty;
2350: END IF;

Line 2347: CSTPPINV.l_item_quantity_tbl(i_item_id) := i_txn_qty + CSTPPINV.l_item_quantity_tbl(i_item_id);

2343: END LOOP;
2344:
2345: -- Insert/Update quantities in PL/SQL tables
2346: IF CSTPPINV.l_item_quantity_tbl.EXISTS (i_item_id) THEN
2347: CSTPPINV.l_item_quantity_tbl(i_item_id) := i_txn_qty + CSTPPINV.l_item_quantity_tbl(i_item_id);
2348: ELSE
2349: CSTPPINV.l_item_quantity_tbl(i_item_id):= i_txn_qty;
2350: END IF;
2351:

Line 2349: CSTPPINV.l_item_quantity_tbl(i_item_id):= i_txn_qty;

2345: -- Insert/Update quantities in PL/SQL tables
2346: IF CSTPPINV.l_item_quantity_tbl.EXISTS (i_item_id) THEN
2347: CSTPPINV.l_item_quantity_tbl(i_item_id) := i_txn_qty + CSTPPINV.l_item_quantity_tbl(i_item_id);
2348: ELSE
2349: CSTPPINV.l_item_quantity_tbl(i_item_id):= i_txn_qty;
2350: END IF;
2351:
2352: IF CSTPPINV.l_make_quantity_tbl.EXISTS (i_item_id) THEN
2353: CSTPPINV.l_make_quantity_tbl(i_item_id) := i_make_qty + CSTPPINV.l_make_quantity_tbl(i_item_id);

Line 2352: IF CSTPPINV.l_make_quantity_tbl.EXISTS (i_item_id) THEN

2348: ELSE
2349: CSTPPINV.l_item_quantity_tbl(i_item_id):= i_txn_qty;
2350: END IF;
2351:
2352: IF CSTPPINV.l_make_quantity_tbl.EXISTS (i_item_id) THEN
2353: CSTPPINV.l_make_quantity_tbl(i_item_id) := i_make_qty + CSTPPINV.l_make_quantity_tbl(i_item_id);
2354: ELSE
2355: CSTPPINV.l_make_quantity_tbl(i_item_id):= i_make_qty;
2356: END IF;

Line 2353: CSTPPINV.l_make_quantity_tbl(i_item_id) := i_make_qty + CSTPPINV.l_make_quantity_tbl(i_item_id);

2349: CSTPPINV.l_item_quantity_tbl(i_item_id):= i_txn_qty;
2350: END IF;
2351:
2352: IF CSTPPINV.l_make_quantity_tbl.EXISTS (i_item_id) THEN
2353: CSTPPINV.l_make_quantity_tbl(i_item_id) := i_make_qty + CSTPPINV.l_make_quantity_tbl(i_item_id);
2354: ELSE
2355: CSTPPINV.l_make_quantity_tbl(i_item_id):= i_make_qty;
2356: END IF;
2357:

Line 2355: CSTPPINV.l_make_quantity_tbl(i_item_id):= i_make_qty;

2351:
2352: IF CSTPPINV.l_make_quantity_tbl.EXISTS (i_item_id) THEN
2353: CSTPPINV.l_make_quantity_tbl(i_item_id) := i_make_qty + CSTPPINV.l_make_quantity_tbl(i_item_id);
2354: ELSE
2355: CSTPPINV.l_make_quantity_tbl(i_item_id):= i_make_qty;
2356: END IF;
2357:
2358: IF CSTPPINV.l_issue_quantity_tbl.EXISTS (i_item_id) THEN
2359: CSTPPINV.l_issue_quantity_tbl (i_item_id):= i_issue_qty + CSTPPINV.l_issue_quantity_tbl(i_item_id);

Line 2358: IF CSTPPINV.l_issue_quantity_tbl.EXISTS (i_item_id) THEN

2354: ELSE
2355: CSTPPINV.l_make_quantity_tbl(i_item_id):= i_make_qty;
2356: END IF;
2357:
2358: IF CSTPPINV.l_issue_quantity_tbl.EXISTS (i_item_id) THEN
2359: CSTPPINV.l_issue_quantity_tbl (i_item_id):= i_issue_qty + CSTPPINV.l_issue_quantity_tbl(i_item_id);
2360: ELSE
2361: CSTPPINV.l_issue_quantity_tbl(i_item_id):= i_issue_qty;
2362: END IF;

Line 2359: CSTPPINV.l_issue_quantity_tbl (i_item_id):= i_issue_qty + CSTPPINV.l_issue_quantity_tbl(i_item_id);

2355: CSTPPINV.l_make_quantity_tbl(i_item_id):= i_make_qty;
2356: END IF;
2357:
2358: IF CSTPPINV.l_issue_quantity_tbl.EXISTS (i_item_id) THEN
2359: CSTPPINV.l_issue_quantity_tbl (i_item_id):= i_issue_qty + CSTPPINV.l_issue_quantity_tbl(i_item_id);
2360: ELSE
2361: CSTPPINV.l_issue_quantity_tbl(i_item_id):= i_issue_qty;
2362: END IF;
2363:

Line 2361: CSTPPINV.l_issue_quantity_tbl(i_item_id):= i_issue_qty;

2357:
2358: IF CSTPPINV.l_issue_quantity_tbl.EXISTS (i_item_id) THEN
2359: CSTPPINV.l_issue_quantity_tbl (i_item_id):= i_issue_qty + CSTPPINV.l_issue_quantity_tbl(i_item_id);
2360: ELSE
2361: CSTPPINV.l_issue_quantity_tbl(i_item_id):= i_issue_qty;
2362: END IF;
2363:
2364: IF CSTPPINV.l_buy_quantity_tbl.EXISTS (i_item_id) THEN
2365: CSTPPINV.l_buy_quantity_tbl (i_item_id):= i_buy_qty + CSTPPINV.l_buy_quantity_tbl(i_item_id);

Line 2364: IF CSTPPINV.l_buy_quantity_tbl.EXISTS (i_item_id) THEN

2360: ELSE
2361: CSTPPINV.l_issue_quantity_tbl(i_item_id):= i_issue_qty;
2362: END IF;
2363:
2364: IF CSTPPINV.l_buy_quantity_tbl.EXISTS (i_item_id) THEN
2365: CSTPPINV.l_buy_quantity_tbl (i_item_id):= i_buy_qty + CSTPPINV.l_buy_quantity_tbl(i_item_id);
2366: ELSE
2367: CSTPPINV.l_buy_quantity_tbl(i_item_id):= i_buy_qty;
2368: END IF;

Line 2365: CSTPPINV.l_buy_quantity_tbl (i_item_id):= i_buy_qty + CSTPPINV.l_buy_quantity_tbl(i_item_id);

2361: CSTPPINV.l_issue_quantity_tbl(i_item_id):= i_issue_qty;
2362: END IF;
2363:
2364: IF CSTPPINV.l_buy_quantity_tbl.EXISTS (i_item_id) THEN
2365: CSTPPINV.l_buy_quantity_tbl (i_item_id):= i_buy_qty + CSTPPINV.l_buy_quantity_tbl(i_item_id);
2366: ELSE
2367: CSTPPINV.l_buy_quantity_tbl(i_item_id):= i_buy_qty;
2368: END IF;
2369: end if;

Line 2367: CSTPPINV.l_buy_quantity_tbl(i_item_id):= i_buy_qty;

2363:
2364: IF CSTPPINV.l_buy_quantity_tbl.EXISTS (i_item_id) THEN
2365: CSTPPINV.l_buy_quantity_tbl (i_item_id):= i_buy_qty + CSTPPINV.l_buy_quantity_tbl(i_item_id);
2366: ELSE
2367: CSTPPINV.l_buy_quantity_tbl(i_item_id):= i_buy_qty;
2368: END IF;
2369: end if;
2370:
2371: /* --- start of auto log --- */

Line 2586: IF (CSTPPINV.l_item_start_index_tbl.EXISTS (i_item_id)) THEN /* item already exists */

2582: l_index NUMBER;
2583: l_count NUMBER;
2584: BEGIN
2585: l_index := -1;
2586: IF (CSTPPINV.l_item_start_index_tbl.EXISTS (i_item_id)) THEN /* item already exists */
2587: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))
2588: LOOP
2589: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND
2590: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND

Line 2587: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))

2583: l_count NUMBER;
2584: BEGIN
2585: l_index := -1;
2586: IF (CSTPPINV.l_item_start_index_tbl.EXISTS (i_item_id)) THEN /* item already exists */
2587: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))
2588: LOOP
2589: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND
2590: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND
2591: CSTPPINV.l_level_type_tbl(l_count) = x.level_type) THEN

Line 2589: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND

2585: l_index := -1;
2586: IF (CSTPPINV.l_item_start_index_tbl.EXISTS (i_item_id)) THEN /* item already exists */
2587: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))
2588: LOOP
2589: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND
2590: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND
2591: CSTPPINV.l_level_type_tbl(l_count) = x.level_type) THEN
2592: l_index := l_count;
2593: END IF;

Line 2590: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND

2586: IF (CSTPPINV.l_item_start_index_tbl.EXISTS (i_item_id)) THEN /* item already exists */
2587: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))
2588: LOOP
2589: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND
2590: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND
2591: CSTPPINV.l_level_type_tbl(l_count) = x.level_type) THEN
2592: l_index := l_count;
2593: END IF;
2594: END LOOP;

Line 2591: CSTPPINV.l_level_type_tbl(l_count) = x.level_type) THEN

2587: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))
2588: LOOP
2589: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND
2590: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND
2591: CSTPPINV.l_level_type_tbl(l_count) = x.level_type) THEN
2592: l_index := l_count;
2593: END IF;
2594: END LOOP;
2595: ELSE /* new item */

Line 2596: CSTPPINV.l_item_start_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;

2592: l_index := l_count;
2593: END IF;
2594: END LOOP;
2595: ELSE /* new item */
2596: CSTPPINV.l_item_start_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;
2597: CSTPPINV.l_item_end_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;
2598: END IF;
2599: IF (l_index = -1) THEN
2600:

Line 2597: CSTPPINV.l_item_end_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;

2593: END IF;
2594: END LOOP;
2595: ELSE /* new item */
2596: CSTPPINV.l_item_start_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;
2597: CSTPPINV.l_item_end_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;
2598: END IF;
2599: IF (l_index = -1) THEN
2600:
2601: /*********************************************************************

Line 2607: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;

2603: PL/SQL table. Quantity is maintained for each item, whereas all
2604: other tables are maintained for each item-cost_element-level_type
2605: **********************************************************************/
2606:
2607: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;
2608: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
2609: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
2610: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
2611: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;

Line 2608: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;

2604: other tables are maintained for each item-cost_element-level_type
2605: **********************************************************************/
2606:
2607: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;
2608: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
2609: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
2610: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
2611: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
2612: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;

Line 2609: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;

2605: **********************************************************************/
2606:
2607: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;
2608: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
2609: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
2610: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
2611: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
2612: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
2613: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;

Line 2610: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;

2606:
2607: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;
2608: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
2609: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
2610: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
2611: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
2612: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
2613: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
2614:

Line 2611: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;

2607: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;
2608: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
2609: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
2610: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
2611: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
2612: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
2613: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
2614:
2615: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost * i_txn_qty;

Line 2612: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;

2608: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
2609: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
2610: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
2611: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
2612: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
2613: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
2614:
2615: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost * i_txn_qty;
2616: CSTPPINV.l_make_balance_tbl(l_index) := x.actual_cost * i_make_qty;

Line 2613: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;

2609: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
2610: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
2611: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
2612: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
2613: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
2614:
2615: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost * i_txn_qty;
2616: CSTPPINV.l_make_balance_tbl(l_index) := x.actual_cost * i_make_qty;
2617: CSTPPINV.l_buy_balance_tbl(l_index) := x.actual_cost * i_buy_qty;

Line 2615: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost * i_txn_qty;

2611: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
2612: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
2613: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
2614:
2615: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost * i_txn_qty;
2616: CSTPPINV.l_make_balance_tbl(l_index) := x.actual_cost * i_make_qty;
2617: CSTPPINV.l_buy_balance_tbl(l_index) := x.actual_cost * i_buy_qty;
2618:
2619: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;

Line 2616: CSTPPINV.l_make_balance_tbl(l_index) := x.actual_cost * i_make_qty;

2612: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
2613: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
2614:
2615: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost * i_txn_qty;
2616: CSTPPINV.l_make_balance_tbl(l_index) := x.actual_cost * i_make_qty;
2617: CSTPPINV.l_buy_balance_tbl(l_index) := x.actual_cost * i_buy_qty;
2618:
2619: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;
2620: ELSE

Line 2617: CSTPPINV.l_buy_balance_tbl(l_index) := x.actual_cost * i_buy_qty;

2613: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
2614:
2615: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost * i_txn_qty;
2616: CSTPPINV.l_make_balance_tbl(l_index) := x.actual_cost * i_make_qty;
2617: CSTPPINV.l_buy_balance_tbl(l_index) := x.actual_cost * i_buy_qty;
2618:
2619: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;
2620: ELSE
2621:

Line 2619: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;

2615: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost * i_txn_qty;
2616: CSTPPINV.l_make_balance_tbl(l_index) := x.actual_cost * i_make_qty;
2617: CSTPPINV.l_buy_balance_tbl(l_index) := x.actual_cost * i_buy_qty;
2618:
2619: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;
2620: ELSE
2621:
2622: /*************************************************************************
2623: Update/Insert total quantity, make quantity, buy quantity for each item

Line 2626: CSTPPINV.l_item_balance_tbl(l_index) := (x.actual_cost * i_txn_qty) + CSTPPINV.l_item_balance_tbl(l_index);

2622: /*************************************************************************
2623: Update/Insert total quantity, make quantity, buy quantity for each item
2624: **************************************************************************/
2625:
2626: CSTPPINV.l_item_balance_tbl(l_index) := (x.actual_cost * i_txn_qty) + CSTPPINV.l_item_balance_tbl(l_index);
2627: CSTPPINV.l_make_balance_tbl(l_index) := (x.actual_cost * i_make_qty) + CSTPPINV.l_make_balance_tbl(l_index);
2628: CSTPPINV.l_buy_balance_tbl(l_index) := (x.actual_cost * i_buy_qty) + CSTPPINV.l_buy_balance_tbl(l_index);
2629: END IF;
2630: END;

Line 2627: CSTPPINV.l_make_balance_tbl(l_index) := (x.actual_cost * i_make_qty) + CSTPPINV.l_make_balance_tbl(l_index);

2623: Update/Insert total quantity, make quantity, buy quantity for each item
2624: **************************************************************************/
2625:
2626: CSTPPINV.l_item_balance_tbl(l_index) := (x.actual_cost * i_txn_qty) + CSTPPINV.l_item_balance_tbl(l_index);
2627: CSTPPINV.l_make_balance_tbl(l_index) := (x.actual_cost * i_make_qty) + CSTPPINV.l_make_balance_tbl(l_index);
2628: CSTPPINV.l_buy_balance_tbl(l_index) := (x.actual_cost * i_buy_qty) + CSTPPINV.l_buy_balance_tbl(l_index);
2629: END IF;
2630: END;
2631: END LOOP;

Line 2628: CSTPPINV.l_buy_balance_tbl(l_index) := (x.actual_cost * i_buy_qty) + CSTPPINV.l_buy_balance_tbl(l_index);

2624: **************************************************************************/
2625:
2626: CSTPPINV.l_item_balance_tbl(l_index) := (x.actual_cost * i_txn_qty) + CSTPPINV.l_item_balance_tbl(l_index);
2627: CSTPPINV.l_make_balance_tbl(l_index) := (x.actual_cost * i_make_qty) + CSTPPINV.l_make_balance_tbl(l_index);
2628: CSTPPINV.l_buy_balance_tbl(l_index) := (x.actual_cost * i_buy_qty) + CSTPPINV.l_buy_balance_tbl(l_index);
2629: END IF;
2630: END;
2631: END LOOP;
2632:

Line 2633: IF CSTPPINV.l_item_quantity_tbl.EXISTS (i_item_id) THEN

2629: END IF;
2630: END;
2631: END LOOP;
2632:
2633: IF CSTPPINV.l_item_quantity_tbl.EXISTS (i_item_id) THEN
2634: CSTPPINV.l_item_quantity_tbl(i_item_id) := i_txn_qty + CSTPPINV.l_item_quantity_tbl(i_item_id);
2635: ELSE
2636: CSTPPINV.l_item_quantity_tbl(i_item_id):= i_txn_qty;
2637: END IF;

Line 2634: CSTPPINV.l_item_quantity_tbl(i_item_id) := i_txn_qty + CSTPPINV.l_item_quantity_tbl(i_item_id);

2630: END;
2631: END LOOP;
2632:
2633: IF CSTPPINV.l_item_quantity_tbl.EXISTS (i_item_id) THEN
2634: CSTPPINV.l_item_quantity_tbl(i_item_id) := i_txn_qty + CSTPPINV.l_item_quantity_tbl(i_item_id);
2635: ELSE
2636: CSTPPINV.l_item_quantity_tbl(i_item_id):= i_txn_qty;
2637: END IF;
2638:

Line 2636: CSTPPINV.l_item_quantity_tbl(i_item_id):= i_txn_qty;

2632:
2633: IF CSTPPINV.l_item_quantity_tbl.EXISTS (i_item_id) THEN
2634: CSTPPINV.l_item_quantity_tbl(i_item_id) := i_txn_qty + CSTPPINV.l_item_quantity_tbl(i_item_id);
2635: ELSE
2636: CSTPPINV.l_item_quantity_tbl(i_item_id):= i_txn_qty;
2637: END IF;
2638:
2639: IF CSTPPINV.l_make_quantity_tbl.EXISTS (i_item_id) THEN
2640: CSTPPINV.l_make_quantity_tbl(i_item_id) := i_make_qty + CSTPPINV.l_make_quantity_tbl(i_item_id);

Line 2639: IF CSTPPINV.l_make_quantity_tbl.EXISTS (i_item_id) THEN

2635: ELSE
2636: CSTPPINV.l_item_quantity_tbl(i_item_id):= i_txn_qty;
2637: END IF;
2638:
2639: IF CSTPPINV.l_make_quantity_tbl.EXISTS (i_item_id) THEN
2640: CSTPPINV.l_make_quantity_tbl(i_item_id) := i_make_qty + CSTPPINV.l_make_quantity_tbl(i_item_id);
2641: ELSE
2642: CSTPPINV.l_make_quantity_tbl(i_item_id):= i_make_qty;
2643: END IF;

Line 2640: CSTPPINV.l_make_quantity_tbl(i_item_id) := i_make_qty + CSTPPINV.l_make_quantity_tbl(i_item_id);

2636: CSTPPINV.l_item_quantity_tbl(i_item_id):= i_txn_qty;
2637: END IF;
2638:
2639: IF CSTPPINV.l_make_quantity_tbl.EXISTS (i_item_id) THEN
2640: CSTPPINV.l_make_quantity_tbl(i_item_id) := i_make_qty + CSTPPINV.l_make_quantity_tbl(i_item_id);
2641: ELSE
2642: CSTPPINV.l_make_quantity_tbl(i_item_id):= i_make_qty;
2643: END IF;
2644:

Line 2642: CSTPPINV.l_make_quantity_tbl(i_item_id):= i_make_qty;

2638:
2639: IF CSTPPINV.l_make_quantity_tbl.EXISTS (i_item_id) THEN
2640: CSTPPINV.l_make_quantity_tbl(i_item_id) := i_make_qty + CSTPPINV.l_make_quantity_tbl(i_item_id);
2641: ELSE
2642: CSTPPINV.l_make_quantity_tbl(i_item_id):= i_make_qty;
2643: END IF;
2644:
2645: IF CSTPPINV.l_issue_quantity_tbl.EXISTS (i_item_id) THEN
2646: CSTPPINV.l_issue_quantity_tbl (i_item_id):= i_issue_qty + CSTPPINV.l_issue_quantity_tbl(i_item_id);

Line 2645: IF CSTPPINV.l_issue_quantity_tbl.EXISTS (i_item_id) THEN

2641: ELSE
2642: CSTPPINV.l_make_quantity_tbl(i_item_id):= i_make_qty;
2643: END IF;
2644:
2645: IF CSTPPINV.l_issue_quantity_tbl.EXISTS (i_item_id) THEN
2646: CSTPPINV.l_issue_quantity_tbl (i_item_id):= i_issue_qty + CSTPPINV.l_issue_quantity_tbl(i_item_id);
2647: ELSE
2648: CSTPPINV.l_issue_quantity_tbl(i_item_id):= i_issue_qty;
2649: END IF;

Line 2646: CSTPPINV.l_issue_quantity_tbl (i_item_id):= i_issue_qty + CSTPPINV.l_issue_quantity_tbl(i_item_id);

2642: CSTPPINV.l_make_quantity_tbl(i_item_id):= i_make_qty;
2643: END IF;
2644:
2645: IF CSTPPINV.l_issue_quantity_tbl.EXISTS (i_item_id) THEN
2646: CSTPPINV.l_issue_quantity_tbl (i_item_id):= i_issue_qty + CSTPPINV.l_issue_quantity_tbl(i_item_id);
2647: ELSE
2648: CSTPPINV.l_issue_quantity_tbl(i_item_id):= i_issue_qty;
2649: END IF;
2650:

Line 2648: CSTPPINV.l_issue_quantity_tbl(i_item_id):= i_issue_qty;

2644:
2645: IF CSTPPINV.l_issue_quantity_tbl.EXISTS (i_item_id) THEN
2646: CSTPPINV.l_issue_quantity_tbl (i_item_id):= i_issue_qty + CSTPPINV.l_issue_quantity_tbl(i_item_id);
2647: ELSE
2648: CSTPPINV.l_issue_quantity_tbl(i_item_id):= i_issue_qty;
2649: END IF;
2650:
2651: IF CSTPPINV.l_buy_quantity_tbl.EXISTS (i_item_id) THEN
2652: CSTPPINV.l_buy_quantity_tbl (i_item_id):= i_buy_qty + CSTPPINV.l_buy_quantity_tbl(i_item_id);

Line 2651: IF CSTPPINV.l_buy_quantity_tbl.EXISTS (i_item_id) THEN

2647: ELSE
2648: CSTPPINV.l_issue_quantity_tbl(i_item_id):= i_issue_qty;
2649: END IF;
2650:
2651: IF CSTPPINV.l_buy_quantity_tbl.EXISTS (i_item_id) THEN
2652: CSTPPINV.l_buy_quantity_tbl (i_item_id):= i_buy_qty + CSTPPINV.l_buy_quantity_tbl(i_item_id);
2653: ELSE
2654: CSTPPINV.l_buy_quantity_tbl(i_item_id):= i_buy_qty;
2655: END IF;

Line 2652: CSTPPINV.l_buy_quantity_tbl (i_item_id):= i_buy_qty + CSTPPINV.l_buy_quantity_tbl(i_item_id);

2648: CSTPPINV.l_issue_quantity_tbl(i_item_id):= i_issue_qty;
2649: END IF;
2650:
2651: IF CSTPPINV.l_buy_quantity_tbl.EXISTS (i_item_id) THEN
2652: CSTPPINV.l_buy_quantity_tbl (i_item_id):= i_buy_qty + CSTPPINV.l_buy_quantity_tbl(i_item_id);
2653: ELSE
2654: CSTPPINV.l_buy_quantity_tbl(i_item_id):= i_buy_qty;
2655: END IF;
2656:

Line 2654: CSTPPINV.l_buy_quantity_tbl(i_item_id):= i_buy_qty;

2650:
2651: IF CSTPPINV.l_buy_quantity_tbl.EXISTS (i_item_id) THEN
2652: CSTPPINV.l_buy_quantity_tbl (i_item_id):= i_buy_qty + CSTPPINV.l_buy_quantity_tbl(i_item_id);
2653: ELSE
2654: CSTPPINV.l_buy_quantity_tbl(i_item_id):= i_buy_qty;
2655: END IF;
2656:
2657: /* --- start of auto log --- */
2658: <>

Line 3212: IF (CSTPPINV.l_item_start_index_tbl.EXISTS (i_item_id)) THEN /* item already exists */

3208: l_count NUMBER;
3209: BEGIN
3210: l_stmt_num := 100;
3211: l_index := -1;
3212: IF (CSTPPINV.l_item_start_index_tbl.EXISTS (i_item_id)) THEN /* item already exists */
3213: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))
3214: LOOP
3215: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND
3216: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND

Line 3213: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))

3209: BEGIN
3210: l_stmt_num := 100;
3211: l_index := -1;
3212: IF (CSTPPINV.l_item_start_index_tbl.EXISTS (i_item_id)) THEN /* item already exists */
3213: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))
3214: LOOP
3215: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND
3216: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND
3217: CSTPPINV.l_level_type_tbl(l_count) = x.level_type) THEN

Line 3215: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND

3211: l_index := -1;
3212: IF (CSTPPINV.l_item_start_index_tbl.EXISTS (i_item_id)) THEN /* item already exists */
3213: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))
3214: LOOP
3215: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND
3216: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND
3217: CSTPPINV.l_level_type_tbl(l_count) = x.level_type) THEN
3218: l_index := l_count;
3219: END IF;

Line 3216: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND

3212: IF (CSTPPINV.l_item_start_index_tbl.EXISTS (i_item_id)) THEN /* item already exists */
3213: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))
3214: LOOP
3215: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND
3216: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND
3217: CSTPPINV.l_level_type_tbl(l_count) = x.level_type) THEN
3218: l_index := l_count;
3219: END IF;
3220: END LOOP;

Line 3217: CSTPPINV.l_level_type_tbl(l_count) = x.level_type) THEN

3213: FOR l_count IN (CSTPPINV.l_item_start_index_tbl(i_item_id))..(CSTPPINV.l_item_end_index_tbl(i_item_id))
3214: LOOP
3215: IF (CSTPPINV.l_item_id_tbl(l_count) = i_item_id AND
3216: CSTPPINV.l_cost_element_id_tbl(l_count) = x.cost_element_id AND
3217: CSTPPINV.l_level_type_tbl(l_count) = x.level_type) THEN
3218: l_index := l_count;
3219: END IF;
3220: END LOOP;
3221: ELSE /* new item */

Line 3222: CSTPPINV.l_item_start_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;

3218: l_index := l_count;
3219: END IF;
3220: END LOOP;
3221: ELSE /* new item */
3222: CSTPPINV.l_item_start_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;
3223: CSTPPINV.l_item_end_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;
3224: END IF;
3225: l_stmt_num := 110;
3226: IF (l_index = -1) THEN /* item-cost_element-level_type combination not found: Insert*/

Line 3223: CSTPPINV.l_item_end_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;

3219: END IF;
3220: END LOOP;
3221: ELSE /* new item */
3222: CSTPPINV.l_item_start_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;
3223: CSTPPINV.l_item_end_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;
3224: END IF;
3225: l_stmt_num := 110;
3226: IF (l_index = -1) THEN /* item-cost_element-level_type combination not found: Insert*/
3227: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;

Line 3227: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;

3223: CSTPPINV.l_item_end_index_tbl (i_item_id) := CSTPPINV.l_item_id_tbl.COUNT + 1;
3224: END IF;
3225: l_stmt_num := 110;
3226: IF (l_index = -1) THEN /* item-cost_element-level_type combination not found: Insert*/
3227: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;
3228: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
3229: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
3230: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
3231: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;

Line 3228: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;

3224: END IF;
3225: l_stmt_num := 110;
3226: IF (l_index = -1) THEN /* item-cost_element-level_type combination not found: Insert*/
3227: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;
3228: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
3229: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
3230: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
3231: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
3232: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;

Line 3229: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;

3225: l_stmt_num := 110;
3226: IF (l_index = -1) THEN /* item-cost_element-level_type combination not found: Insert*/
3227: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;
3228: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
3229: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
3230: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
3231: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
3232: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
3233: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;

Line 3230: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;

3226: IF (l_index = -1) THEN /* item-cost_element-level_type combination not found: Insert*/
3227: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;
3228: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
3229: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
3230: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
3231: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
3232: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
3233: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
3234:

Line 3231: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;

3227: l_index := CSTPPINV.l_item_id_tbl.COUNT + 1;
3228: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
3229: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
3230: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
3231: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
3232: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
3233: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
3234:
3235: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost;

Line 3232: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;

3228: CSTPPINV.l_item_id_tbl(l_index) := i_item_id;
3229: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
3230: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
3231: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
3232: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
3233: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
3234:
3235: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost;
3236: CSTPPINV.l_make_balance_tbl(l_index) := 0;

Line 3233: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;

3229: CSTPPINV.l_cost_layer_id_tbl(l_index) := i_cost_layer_id;
3230: CSTPPINV.l_qty_layer_id_tbl(l_index) := i_qty_layer_id;
3231: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
3232: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
3233: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
3234:
3235: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost;
3236: CSTPPINV.l_make_balance_tbl(l_index) := 0;
3237: CSTPPINV.l_buy_balance_tbl(l_index) := 0;

Line 3235: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost;

3231: CSTPPINV.l_cost_element_id_tbl(l_index) := x.cost_element_id;
3232: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
3233: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
3234:
3235: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost;
3236: CSTPPINV.l_make_balance_tbl(l_index) := 0;
3237: CSTPPINV.l_buy_balance_tbl(l_index) := 0;
3238:
3239: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;

Line 3236: CSTPPINV.l_make_balance_tbl(l_index) := 0;

3232: CSTPPINV.l_level_type_tbl(l_index) := x.level_type;
3233: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
3234:
3235: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost;
3236: CSTPPINV.l_make_balance_tbl(l_index) := 0;
3237: CSTPPINV.l_buy_balance_tbl(l_index) := 0;
3238:
3239: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;
3240: ELSE /* item-cost_element-level_type combination found: Update*/

Line 3237: CSTPPINV.l_buy_balance_tbl(l_index) := 0;

3233: CSTPPINV.l_txn_category_tbl (l_index) := i_txn_category;
3234:
3235: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost;
3236: CSTPPINV.l_make_balance_tbl(l_index) := 0;
3237: CSTPPINV.l_buy_balance_tbl(l_index) := 0;
3238:
3239: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;
3240: ELSE /* item-cost_element-level_type combination found: Update*/
3241: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost + CSTPPINV.l_item_balance_tbl(l_index);

Line 3239: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;

3235: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost;
3236: CSTPPINV.l_make_balance_tbl(l_index) := 0;
3237: CSTPPINV.l_buy_balance_tbl(l_index) := 0;
3238:
3239: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;
3240: ELSE /* item-cost_element-level_type combination found: Update*/
3241: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost + CSTPPINV.l_item_balance_tbl(l_index);
3242: END IF;
3243: END;

Line 3241: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost + CSTPPINV.l_item_balance_tbl(l_index);

3237: CSTPPINV.l_buy_balance_tbl(l_index) := 0;
3238:
3239: CSTPPINV.l_item_end_index_tbl (i_item_id) := l_index;
3240: ELSE /* item-cost_element-level_type combination found: Update*/
3241: CSTPPINV.l_item_balance_tbl(l_index) := x.actual_cost + CSTPPINV.l_item_balance_tbl(l_index);
3242: END IF;
3243: END;
3244: END LOOP;
3245:

Line 3553: l_new_qty_tbl CSTPPINV.t_item_quantity_tbl;

3549: o_err_code OUT NOCOPY VARCHAR2,
3550: o_err_msg OUT NOCOPY VARCHAR2)
3551: IS
3552: l_stmt_num NUMBER;
3553: l_new_qty_tbl CSTPPINV.t_item_quantity_tbl;
3554: l_new_buy_qty_tbl CSTPPINV.t_item_quantity_tbl;
3555: l_new_make_qty_tbl CSTPPINV.t_item_quantity_tbl;
3556: l_new_issue_qty_tbl CSTPPINV.t_item_quantity_tbl;
3557: l_category_qty_tbl CSTPPINV.t_item_quantity_tbl;

Line 3554: l_new_buy_qty_tbl CSTPPINV.t_item_quantity_tbl;

3550: o_err_msg OUT NOCOPY VARCHAR2)
3551: IS
3552: l_stmt_num NUMBER;
3553: l_new_qty_tbl CSTPPINV.t_item_quantity_tbl;
3554: l_new_buy_qty_tbl CSTPPINV.t_item_quantity_tbl;
3555: l_new_make_qty_tbl CSTPPINV.t_item_quantity_tbl;
3556: l_new_issue_qty_tbl CSTPPINV.t_item_quantity_tbl;
3557: l_category_qty_tbl CSTPPINV.t_item_quantity_tbl;
3558:

Line 3555: l_new_make_qty_tbl CSTPPINV.t_item_quantity_tbl;

3551: IS
3552: l_stmt_num NUMBER;
3553: l_new_qty_tbl CSTPPINV.t_item_quantity_tbl;
3554: l_new_buy_qty_tbl CSTPPINV.t_item_quantity_tbl;
3555: l_new_make_qty_tbl CSTPPINV.t_item_quantity_tbl;
3556: l_new_issue_qty_tbl CSTPPINV.t_item_quantity_tbl;
3557: l_category_qty_tbl CSTPPINV.t_item_quantity_tbl;
3558:
3559: /* --- start of auto log --- */

Line 3556: l_new_issue_qty_tbl CSTPPINV.t_item_quantity_tbl;

3552: l_stmt_num NUMBER;
3553: l_new_qty_tbl CSTPPINV.t_item_quantity_tbl;
3554: l_new_buy_qty_tbl CSTPPINV.t_item_quantity_tbl;
3555: l_new_make_qty_tbl CSTPPINV.t_item_quantity_tbl;
3556: l_new_issue_qty_tbl CSTPPINV.t_item_quantity_tbl;
3557: l_category_qty_tbl CSTPPINV.t_item_quantity_tbl;
3558:
3559: /* --- start of auto log --- */
3560: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_into_cppb';

Line 3557: l_category_qty_tbl CSTPPINV.t_item_quantity_tbl;

3553: l_new_qty_tbl CSTPPINV.t_item_quantity_tbl;
3554: l_new_buy_qty_tbl CSTPPINV.t_item_quantity_tbl;
3555: l_new_make_qty_tbl CSTPPINV.t_item_quantity_tbl;
3556: l_new_issue_qty_tbl CSTPPINV.t_item_quantity_tbl;
3557: l_category_qty_tbl CSTPPINV.t_item_quantity_tbl;
3558:
3559: /* --- start of auto log --- */
3560: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_into_cppb';
3561: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;

Line 3590: IF (CSTPPINV.l_item_id_tbl.COUNT > 0) THEN

3586: END IF;
3587: /* --- end of auto log --- */
3588:
3589: l_stmt_num := 10;
3590: IF (CSTPPINV.l_item_id_tbl.COUNT > 0) THEN
3591: FOR l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3592: LOOP
3593: IF (i_txn_category = 5 OR
3594: i_txn_category = 2.5) THEN

Line 3591: FOR l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST

3587: /* --- end of auto log --- */
3588:
3589: l_stmt_num := 10;
3590: IF (CSTPPINV.l_item_id_tbl.COUNT > 0) THEN
3591: FOR l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3592: LOOP
3593: IF (i_txn_category = 5 OR
3594: i_txn_category = 2.5) THEN
3595: -- Periodic Cost Update value change

Line 3607: WHERE cpic.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index);

3603: l_new_make_qty_tbl (l_index),
3604: l_new_issue_qty_tbl (l_index),
3605: l_category_qty_tbl (l_index)
3606: FROM cst_pac_item_costs cpic
3607: WHERE cpic.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index);
3608: ELSE
3609: SELECT cpic.total_layer_quantity + CSTPPINV.l_item_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3610: cpic.buy_quantity + CSTPPINV.l_buy_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3611: cpic.make_quantity + CSTPPINV.l_make_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),

Line 3609: SELECT cpic.total_layer_quantity + CSTPPINV.l_item_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),

3605: l_category_qty_tbl (l_index)
3606: FROM cst_pac_item_costs cpic
3607: WHERE cpic.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index);
3608: ELSE
3609: SELECT cpic.total_layer_quantity + CSTPPINV.l_item_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3610: cpic.buy_quantity + CSTPPINV.l_buy_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3611: cpic.make_quantity + CSTPPINV.l_make_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3612: cpic.issue_quantity + CSTPPINV.l_issue_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3613: CSTPPINV.l_item_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index))

Line 3610: cpic.buy_quantity + CSTPPINV.l_buy_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),

3606: FROM cst_pac_item_costs cpic
3607: WHERE cpic.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index);
3608: ELSE
3609: SELECT cpic.total_layer_quantity + CSTPPINV.l_item_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3610: cpic.buy_quantity + CSTPPINV.l_buy_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3611: cpic.make_quantity + CSTPPINV.l_make_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3612: cpic.issue_quantity + CSTPPINV.l_issue_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3613: CSTPPINV.l_item_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index))
3614: INTO l_new_qty_tbl (l_index),

Line 3611: cpic.make_quantity + CSTPPINV.l_make_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),

3607: WHERE cpic.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index);
3608: ELSE
3609: SELECT cpic.total_layer_quantity + CSTPPINV.l_item_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3610: cpic.buy_quantity + CSTPPINV.l_buy_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3611: cpic.make_quantity + CSTPPINV.l_make_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3612: cpic.issue_quantity + CSTPPINV.l_issue_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3613: CSTPPINV.l_item_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index))
3614: INTO l_new_qty_tbl (l_index),
3615: l_new_buy_qty_tbl (l_index),

Line 3612: cpic.issue_quantity + CSTPPINV.l_issue_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),

3608: ELSE
3609: SELECT cpic.total_layer_quantity + CSTPPINV.l_item_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3610: cpic.buy_quantity + CSTPPINV.l_buy_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3611: cpic.make_quantity + CSTPPINV.l_make_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3612: cpic.issue_quantity + CSTPPINV.l_issue_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3613: CSTPPINV.l_item_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index))
3614: INTO l_new_qty_tbl (l_index),
3615: l_new_buy_qty_tbl (l_index),
3616: l_new_make_qty_tbl (l_index),

Line 3613: CSTPPINV.l_item_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index))

3609: SELECT cpic.total_layer_quantity + CSTPPINV.l_item_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3610: cpic.buy_quantity + CSTPPINV.l_buy_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3611: cpic.make_quantity + CSTPPINV.l_make_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3612: cpic.issue_quantity + CSTPPINV.l_issue_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index)),
3613: CSTPPINV.l_item_quantity_tbl (CSTPPINV.l_item_id_tbl(l_index))
3614: INTO l_new_qty_tbl (l_index),
3615: l_new_buy_qty_tbl (l_index),
3616: l_new_make_qty_tbl (l_index),
3617: l_new_issue_qty_tbl (l_index),

Line 3620: WHERE cpic.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index);

3616: l_new_make_qty_tbl (l_index),
3617: l_new_issue_qty_tbl (l_index),
3618: l_category_qty_tbl (l_index)
3619: FROM cst_pac_item_costs cpic
3620: WHERE cpic.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index);
3621: END IF;
3622: END LOOP;
3623: END IF;
3624:

Line 3626: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST

3622: END LOOP;
3623: END IF;
3624:
3625: l_stmt_num := 20;
3626: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3627: MERGE INTO CST_PAC_PERIOD_BALANCES cppb
3628: USING (SELECT i_pac_period_id pac_period_id,
3629: i_cost_group_id cost_group_id,
3630: CSTPPINV.l_item_id_tbl(l_index) item_id,

Line 3630: CSTPPINV.l_item_id_tbl(l_index) item_id,

3626: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3627: MERGE INTO CST_PAC_PERIOD_BALANCES cppb
3628: USING (SELECT i_pac_period_id pac_period_id,
3629: i_cost_group_id cost_group_id,
3630: CSTPPINV.l_item_id_tbl(l_index) item_id,
3631: CSTPPINV.l_cost_layer_id_tbl(l_index) cost_layer_id,
3632: CSTPPINV.l_qty_layer_id_tbl(l_index) qty_layer_id,
3633: CSTPPINV.l_cost_element_id_tbl(l_index) cost_element_id,
3634: CSTPPINV.l_level_type_tbl(l_index) level_type,

Line 3631: CSTPPINV.l_cost_layer_id_tbl(l_index) cost_layer_id,

3627: MERGE INTO CST_PAC_PERIOD_BALANCES cppb
3628: USING (SELECT i_pac_period_id pac_period_id,
3629: i_cost_group_id cost_group_id,
3630: CSTPPINV.l_item_id_tbl(l_index) item_id,
3631: CSTPPINV.l_cost_layer_id_tbl(l_index) cost_layer_id,
3632: CSTPPINV.l_qty_layer_id_tbl(l_index) qty_layer_id,
3633: CSTPPINV.l_cost_element_id_tbl(l_index) cost_element_id,
3634: CSTPPINV.l_level_type_tbl(l_index) level_type,
3635: CSTPPINV.l_txn_category_tbl(l_index) txn_category,

Line 3632: CSTPPINV.l_qty_layer_id_tbl(l_index) qty_layer_id,

3628: USING (SELECT i_pac_period_id pac_period_id,
3629: i_cost_group_id cost_group_id,
3630: CSTPPINV.l_item_id_tbl(l_index) item_id,
3631: CSTPPINV.l_cost_layer_id_tbl(l_index) cost_layer_id,
3632: CSTPPINV.l_qty_layer_id_tbl(l_index) qty_layer_id,
3633: CSTPPINV.l_cost_element_id_tbl(l_index) cost_element_id,
3634: CSTPPINV.l_level_type_tbl(l_index) level_type,
3635: CSTPPINV.l_txn_category_tbl(l_index) txn_category,
3636: l_category_qty_tbl (l_index) category_quantity,

Line 3633: CSTPPINV.l_cost_element_id_tbl(l_index) cost_element_id,

3629: i_cost_group_id cost_group_id,
3630: CSTPPINV.l_item_id_tbl(l_index) item_id,
3631: CSTPPINV.l_cost_layer_id_tbl(l_index) cost_layer_id,
3632: CSTPPINV.l_qty_layer_id_tbl(l_index) qty_layer_id,
3633: CSTPPINV.l_cost_element_id_tbl(l_index) cost_element_id,
3634: CSTPPINV.l_level_type_tbl(l_index) level_type,
3635: CSTPPINV.l_txn_category_tbl(l_index) txn_category,
3636: l_category_qty_tbl (l_index) category_quantity,
3637: CSTPPINV.l_item_balance_tbl(l_index) category_balance

Line 3634: CSTPPINV.l_level_type_tbl(l_index) level_type,

3630: CSTPPINV.l_item_id_tbl(l_index) item_id,
3631: CSTPPINV.l_cost_layer_id_tbl(l_index) cost_layer_id,
3632: CSTPPINV.l_qty_layer_id_tbl(l_index) qty_layer_id,
3633: CSTPPINV.l_cost_element_id_tbl(l_index) cost_element_id,
3634: CSTPPINV.l_level_type_tbl(l_index) level_type,
3635: CSTPPINV.l_txn_category_tbl(l_index) txn_category,
3636: l_category_qty_tbl (l_index) category_quantity,
3637: CSTPPINV.l_item_balance_tbl(l_index) category_balance
3638: FROM dual) temp

Line 3635: CSTPPINV.l_txn_category_tbl(l_index) txn_category,

3631: CSTPPINV.l_cost_layer_id_tbl(l_index) cost_layer_id,
3632: CSTPPINV.l_qty_layer_id_tbl(l_index) qty_layer_id,
3633: CSTPPINV.l_cost_element_id_tbl(l_index) cost_element_id,
3634: CSTPPINV.l_level_type_tbl(l_index) level_type,
3635: CSTPPINV.l_txn_category_tbl(l_index) txn_category,
3636: l_category_qty_tbl (l_index) category_quantity,
3637: CSTPPINV.l_item_balance_tbl(l_index) category_balance
3638: FROM dual) temp
3639: ON ( cppb.pac_period_id = temp.pac_period_id

Line 3637: CSTPPINV.l_item_balance_tbl(l_index) category_balance

3633: CSTPPINV.l_cost_element_id_tbl(l_index) cost_element_id,
3634: CSTPPINV.l_level_type_tbl(l_index) level_type,
3635: CSTPPINV.l_txn_category_tbl(l_index) txn_category,
3636: l_category_qty_tbl (l_index) category_quantity,
3637: CSTPPINV.l_item_balance_tbl(l_index) category_balance
3638: FROM dual) temp
3639: ON ( cppb.pac_period_id = temp.pac_period_id
3640: AND cppb.cost_layer_id = temp.cost_layer_id
3641: AND cppb.cost_element_id = temp.cost_element_id

Line 3697: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST

3693: program_update_date = sysdate;
3694:
3695: l_stmt_num := 30;
3696: -- Update balance of existing rows in CPICD
3697: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3698: UPDATE CST_PAC_ITEM_COST_DETAILS cpicd
3699: SET item_balance = nvl(item_balance, 0) + CSTPPINV.l_item_balance_tbl (l_index),
3700: make_balance = nvl(make_balance, 0) + CSTPPINV.l_make_balance_tbl (l_index),
3701: buy_balance = nvl(buy_balance, 0) + CSTPPINV.l_buy_balance_tbl (l_index),

Line 3699: SET item_balance = nvl(item_balance, 0) + CSTPPINV.l_item_balance_tbl (l_index),

3695: l_stmt_num := 30;
3696: -- Update balance of existing rows in CPICD
3697: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3698: UPDATE CST_PAC_ITEM_COST_DETAILS cpicd
3699: SET item_balance = nvl(item_balance, 0) + CSTPPINV.l_item_balance_tbl (l_index),
3700: make_balance = nvl(make_balance, 0) + CSTPPINV.l_make_balance_tbl (l_index),
3701: buy_balance = nvl(buy_balance, 0) + CSTPPINV.l_buy_balance_tbl (l_index),
3702: last_update_date = sysdate,
3703: last_updated_by = i_user_id,

Line 3700: make_balance = nvl(make_balance, 0) + CSTPPINV.l_make_balance_tbl (l_index),

3696: -- Update balance of existing rows in CPICD
3697: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3698: UPDATE CST_PAC_ITEM_COST_DETAILS cpicd
3699: SET item_balance = nvl(item_balance, 0) + CSTPPINV.l_item_balance_tbl (l_index),
3700: make_balance = nvl(make_balance, 0) + CSTPPINV.l_make_balance_tbl (l_index),
3701: buy_balance = nvl(buy_balance, 0) + CSTPPINV.l_buy_balance_tbl (l_index),
3702: last_update_date = sysdate,
3703: last_updated_by = i_user_id,
3704: last_update_login = i_login_id,

Line 3701: buy_balance = nvl(buy_balance, 0) + CSTPPINV.l_buy_balance_tbl (l_index),

3697: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3698: UPDATE CST_PAC_ITEM_COST_DETAILS cpicd
3699: SET item_balance = nvl(item_balance, 0) + CSTPPINV.l_item_balance_tbl (l_index),
3700: make_balance = nvl(make_balance, 0) + CSTPPINV.l_make_balance_tbl (l_index),
3701: buy_balance = nvl(buy_balance, 0) + CSTPPINV.l_buy_balance_tbl (l_index),
3702: last_update_date = sysdate,
3703: last_updated_by = i_user_id,
3704: last_update_login = i_login_id,
3705: request_id = i_request_id,

Line 3709: WHERE cpicd.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index)

3705: request_id = i_request_id,
3706: program_application_id = i_prog_appl_id,
3707: program_id = i_prog_id,
3708: program_update_date = sysdate
3709: WHERE cpicd.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index)
3710: AND cpicd.cost_element_id = CSTPPINV.l_cost_element_id_tbl (l_index)
3711: AND cpicd.level_type = CSTPPINV.l_level_type_tbl (l_index);
3712:
3713: l_stmt_num := 40;

Line 3710: AND cpicd.cost_element_id = CSTPPINV.l_cost_element_id_tbl (l_index)

3706: program_application_id = i_prog_appl_id,
3707: program_id = i_prog_id,
3708: program_update_date = sysdate
3709: WHERE cpicd.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index)
3710: AND cpicd.cost_element_id = CSTPPINV.l_cost_element_id_tbl (l_index)
3711: AND cpicd.level_type = CSTPPINV.l_level_type_tbl (l_index);
3712:
3713: l_stmt_num := 40;
3714: -- Insert missing cost elements into CPICD

Line 3711: AND cpicd.level_type = CSTPPINV.l_level_type_tbl (l_index);

3707: program_id = i_prog_id,
3708: program_update_date = sysdate
3709: WHERE cpicd.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index)
3710: AND cpicd.cost_element_id = CSTPPINV.l_cost_element_id_tbl (l_index)
3711: AND cpicd.level_type = CSTPPINV.l_level_type_tbl (l_index);
3712:
3713: l_stmt_num := 40;
3714: -- Insert missing cost elements into CPICD
3715: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST

Line 3715: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST

3711: AND cpicd.level_type = CSTPPINV.l_level_type_tbl (l_index);
3712:
3713: l_stmt_num := 40;
3714: -- Insert missing cost elements into CPICD
3715: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3716: INSERT INTO CST_PAC_ITEM_COST_DETAILS cpicd
3717: (cost_layer_id,
3718: cost_element_id,
3719: level_type,

Line 3735: (SELECT CSTPPINV.l_cost_layer_id_tbl (l_index),

3731: item_make_cost,
3732: item_balance,
3733: make_balance,
3734: buy_balance)
3735: (SELECT CSTPPINV.l_cost_layer_id_tbl (l_index),
3736: CSTPPINV.l_cost_element_id_tbl (l_index),
3737: CSTPPINV.l_level_type_tbl (l_index),
3738: sysdate,
3739: i_user_id,

Line 3736: CSTPPINV.l_cost_element_id_tbl (l_index),

3732: item_balance,
3733: make_balance,
3734: buy_balance)
3735: (SELECT CSTPPINV.l_cost_layer_id_tbl (l_index),
3736: CSTPPINV.l_cost_element_id_tbl (l_index),
3737: CSTPPINV.l_level_type_tbl (l_index),
3738: sysdate,
3739: i_user_id,
3740: sysdate,

Line 3737: CSTPPINV.l_level_type_tbl (l_index),

3733: make_balance,
3734: buy_balance)
3735: (SELECT CSTPPINV.l_cost_layer_id_tbl (l_index),
3736: CSTPPINV.l_cost_element_id_tbl (l_index),
3737: CSTPPINV.l_level_type_tbl (l_index),
3738: sysdate,
3739: i_user_id,
3740: sysdate,
3741: i_user_id,

Line 3750: CSTPPINV.l_item_balance_tbl (l_index),

3746: sysdate,
3747: 0,
3748: 0,
3749: 0,
3750: CSTPPINV.l_item_balance_tbl (l_index),
3751: CSTPPINV.l_make_balance_tbl (l_index),
3752: CSTPPINV.l_buy_balance_tbl (l_index)
3753: FROM dual
3754: WHERE NOT EXISTS (SELECT 1

Line 3751: CSTPPINV.l_make_balance_tbl (l_index),

3747: 0,
3748: 0,
3749: 0,
3750: CSTPPINV.l_item_balance_tbl (l_index),
3751: CSTPPINV.l_make_balance_tbl (l_index),
3752: CSTPPINV.l_buy_balance_tbl (l_index)
3753: FROM dual
3754: WHERE NOT EXISTS (SELECT 1
3755: FROM cst_pac_item_cost_details cpicd1

Line 3752: CSTPPINV.l_buy_balance_tbl (l_index)

3748: 0,
3749: 0,
3750: CSTPPINV.l_item_balance_tbl (l_index),
3751: CSTPPINV.l_make_balance_tbl (l_index),
3752: CSTPPINV.l_buy_balance_tbl (l_index)
3753: FROM dual
3754: WHERE NOT EXISTS (SELECT 1
3755: FROM cst_pac_item_cost_details cpicd1
3756: WHERE cpicd1.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index)

Line 3756: WHERE cpicd1.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index)

3752: CSTPPINV.l_buy_balance_tbl (l_index)
3753: FROM dual
3754: WHERE NOT EXISTS (SELECT 1
3755: FROM cst_pac_item_cost_details cpicd1
3756: WHERE cpicd1.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index)
3757: AND cpicd1.cost_element_id = CSTPPINV.l_cost_element_id_tbl (l_index)
3758: AND cpicd1.level_type = CSTPPINV.l_level_type_tbl (l_index)));
3759:
3760: l_stmt_num := 50;

Line 3757: AND cpicd1.cost_element_id = CSTPPINV.l_cost_element_id_tbl (l_index)

3753: FROM dual
3754: WHERE NOT EXISTS (SELECT 1
3755: FROM cst_pac_item_cost_details cpicd1
3756: WHERE cpicd1.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index)
3757: AND cpicd1.cost_element_id = CSTPPINV.l_cost_element_id_tbl (l_index)
3758: AND cpicd1.level_type = CSTPPINV.l_level_type_tbl (l_index)));
3759:
3760: l_stmt_num := 50;
3761: /* Changing the query as per Bug5045692. Performance Fix */

Line 3758: AND cpicd1.level_type = CSTPPINV.l_level_type_tbl (l_index)));

3754: WHERE NOT EXISTS (SELECT 1
3755: FROM cst_pac_item_cost_details cpicd1
3756: WHERE cpicd1.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index)
3757: AND cpicd1.cost_element_id = CSTPPINV.l_cost_element_id_tbl (l_index)
3758: AND cpicd1.level_type = CSTPPINV.l_level_type_tbl (l_index)));
3759:
3760: l_stmt_num := 50;
3761: /* Changing the query as per Bug5045692. Performance Fix */
3762: /* update quantities and balance in CPIC */

Line 3763: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST

3759:
3760: l_stmt_num := 50;
3761: /* Changing the query as per Bug5045692. Performance Fix */
3762: /* update quantities and balance in CPIC */
3763: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3764: UPDATE cst_pac_item_costs cpic
3765: SET total_layer_quantity = l_new_qty_tbl (l_index),
3766: issue_quantity = l_new_issue_qty_tbl (l_index),
3767: buy_quantity = l_new_buy_qty_tbl(l_index),

Line 3776: WHERE cpic.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index);

3772: program_application_id = i_prog_appl_id,
3773: program_id = i_prog_id,
3774: program_update_date = sysdate,
3775: last_update_login = i_login_id
3776: WHERE cpic.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index);
3777:
3778: l_stmt_num := 60;
3779: /* Update CPQL quantity */
3780: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST

Line 3780: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST

3776: WHERE cpic.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index);
3777:
3778: l_stmt_num := 60;
3779: /* Update CPQL quantity */
3780: FORALL l_index IN CSTPPINV.l_item_id_tbl.FIRST..CSTPPINV.l_item_id_tbl.LAST
3781: UPDATE CST_PAC_QUANTITY_LAYERS cpql
3782: SET (last_updated_by,
3783: last_update_date,
3784: last_update_login,

Line 3799: WHERE cpql.quantity_layer_id = CSTPPINV.l_qty_layer_id_tbl (l_index)

3795: i_prog_id,
3796: sysdate,
3797: l_new_qty_tbl (l_index)
3798: FROM sys.dual)
3799: WHERE cpql.quantity_layer_id = CSTPPINV.l_qty_layer_id_tbl (l_index)
3800: AND EXISTS
3801: (SELECT 'there is a layer'
3802: FROM cst_pac_quantity_layers cpql
3803: WHERE cpql.quantity_layer_id = CSTPPINV.l_qty_layer_id_tbl (l_index));

Line 3803: WHERE cpql.quantity_layer_id = CSTPPINV.l_qty_layer_id_tbl (l_index));

3799: WHERE cpql.quantity_layer_id = CSTPPINV.l_qty_layer_id_tbl (l_index)
3800: AND EXISTS
3801: (SELECT 'there is a layer'
3802: FROM cst_pac_quantity_layers cpql
3803: WHERE cpql.quantity_layer_id = CSTPPINV.l_qty_layer_id_tbl (l_index));
3804:
3805: l_stmt_num := 70;
3806: /* Clear All PL/SQL tables */
3807: CSTPPINV.l_item_id_tbl.DELETE;

Line 3807: CSTPPINV.l_item_id_tbl.DELETE;

3803: WHERE cpql.quantity_layer_id = CSTPPINV.l_qty_layer_id_tbl (l_index));
3804:
3805: l_stmt_num := 70;
3806: /* Clear All PL/SQL tables */
3807: CSTPPINV.l_item_id_tbl.DELETE;
3808: CSTPPINV.l_cost_layer_id_tbl.DELETE;
3809: CSTPPINV.l_qty_layer_id_tbl.DELETE;
3810:
3811: CSTPPINV.l_cost_element_id_tbl.DELETE;

Line 3808: CSTPPINV.l_cost_layer_id_tbl.DELETE;

3804:
3805: l_stmt_num := 70;
3806: /* Clear All PL/SQL tables */
3807: CSTPPINV.l_item_id_tbl.DELETE;
3808: CSTPPINV.l_cost_layer_id_tbl.DELETE;
3809: CSTPPINV.l_qty_layer_id_tbl.DELETE;
3810:
3811: CSTPPINV.l_cost_element_id_tbl.DELETE;
3812: CSTPPINV.l_level_type_tbl.DELETE;

Line 3809: CSTPPINV.l_qty_layer_id_tbl.DELETE;

3805: l_stmt_num := 70;
3806: /* Clear All PL/SQL tables */
3807: CSTPPINV.l_item_id_tbl.DELETE;
3808: CSTPPINV.l_cost_layer_id_tbl.DELETE;
3809: CSTPPINV.l_qty_layer_id_tbl.DELETE;
3810:
3811: CSTPPINV.l_cost_element_id_tbl.DELETE;
3812: CSTPPINV.l_level_type_tbl.DELETE;
3813: CSTPPINV.l_txn_category_tbl.DELETE;

Line 3811: CSTPPINV.l_cost_element_id_tbl.DELETE;

3807: CSTPPINV.l_item_id_tbl.DELETE;
3808: CSTPPINV.l_cost_layer_id_tbl.DELETE;
3809: CSTPPINV.l_qty_layer_id_tbl.DELETE;
3810:
3811: CSTPPINV.l_cost_element_id_tbl.DELETE;
3812: CSTPPINV.l_level_type_tbl.DELETE;
3813: CSTPPINV.l_txn_category_tbl.DELETE;
3814:
3815: CSTPPINV.l_item_balance_tbl.DELETE;

Line 3812: CSTPPINV.l_level_type_tbl.DELETE;

3808: CSTPPINV.l_cost_layer_id_tbl.DELETE;
3809: CSTPPINV.l_qty_layer_id_tbl.DELETE;
3810:
3811: CSTPPINV.l_cost_element_id_tbl.DELETE;
3812: CSTPPINV.l_level_type_tbl.DELETE;
3813: CSTPPINV.l_txn_category_tbl.DELETE;
3814:
3815: CSTPPINV.l_item_balance_tbl.DELETE;
3816: CSTPPINV.l_make_balance_tbl.DELETE;

Line 3813: CSTPPINV.l_txn_category_tbl.DELETE;

3809: CSTPPINV.l_qty_layer_id_tbl.DELETE;
3810:
3811: CSTPPINV.l_cost_element_id_tbl.DELETE;
3812: CSTPPINV.l_level_type_tbl.DELETE;
3813: CSTPPINV.l_txn_category_tbl.DELETE;
3814:
3815: CSTPPINV.l_item_balance_tbl.DELETE;
3816: CSTPPINV.l_make_balance_tbl.DELETE;
3817: CSTPPINV.l_buy_balance_tbl.DELETE;

Line 3815: CSTPPINV.l_item_balance_tbl.DELETE;

3811: CSTPPINV.l_cost_element_id_tbl.DELETE;
3812: CSTPPINV.l_level_type_tbl.DELETE;
3813: CSTPPINV.l_txn_category_tbl.DELETE;
3814:
3815: CSTPPINV.l_item_balance_tbl.DELETE;
3816: CSTPPINV.l_make_balance_tbl.DELETE;
3817: CSTPPINV.l_buy_balance_tbl.DELETE;
3818:
3819: CSTPPINV.l_item_quantity_tbl.DELETE;

Line 3816: CSTPPINV.l_make_balance_tbl.DELETE;

3812: CSTPPINV.l_level_type_tbl.DELETE;
3813: CSTPPINV.l_txn_category_tbl.DELETE;
3814:
3815: CSTPPINV.l_item_balance_tbl.DELETE;
3816: CSTPPINV.l_make_balance_tbl.DELETE;
3817: CSTPPINV.l_buy_balance_tbl.DELETE;
3818:
3819: CSTPPINV.l_item_quantity_tbl.DELETE;
3820: CSTPPINV.l_make_quantity_tbl.DELETE;

Line 3817: CSTPPINV.l_buy_balance_tbl.DELETE;

3813: CSTPPINV.l_txn_category_tbl.DELETE;
3814:
3815: CSTPPINV.l_item_balance_tbl.DELETE;
3816: CSTPPINV.l_make_balance_tbl.DELETE;
3817: CSTPPINV.l_buy_balance_tbl.DELETE;
3818:
3819: CSTPPINV.l_item_quantity_tbl.DELETE;
3820: CSTPPINV.l_make_quantity_tbl.DELETE;
3821: CSTPPINV.l_buy_quantity_tbl.DELETE;

Line 3819: CSTPPINV.l_item_quantity_tbl.DELETE;

3815: CSTPPINV.l_item_balance_tbl.DELETE;
3816: CSTPPINV.l_make_balance_tbl.DELETE;
3817: CSTPPINV.l_buy_balance_tbl.DELETE;
3818:
3819: CSTPPINV.l_item_quantity_tbl.DELETE;
3820: CSTPPINV.l_make_quantity_tbl.DELETE;
3821: CSTPPINV.l_buy_quantity_tbl.DELETE;
3822: CSTPPINV.l_issue_quantity_tbl.DELETE;
3823:

Line 3820: CSTPPINV.l_make_quantity_tbl.DELETE;

3816: CSTPPINV.l_make_balance_tbl.DELETE;
3817: CSTPPINV.l_buy_balance_tbl.DELETE;
3818:
3819: CSTPPINV.l_item_quantity_tbl.DELETE;
3820: CSTPPINV.l_make_quantity_tbl.DELETE;
3821: CSTPPINV.l_buy_quantity_tbl.DELETE;
3822: CSTPPINV.l_issue_quantity_tbl.DELETE;
3823:
3824: CSTPPINV.l_item_start_index_tbl.DELETE;

Line 3821: CSTPPINV.l_buy_quantity_tbl.DELETE;

3817: CSTPPINV.l_buy_balance_tbl.DELETE;
3818:
3819: CSTPPINV.l_item_quantity_tbl.DELETE;
3820: CSTPPINV.l_make_quantity_tbl.DELETE;
3821: CSTPPINV.l_buy_quantity_tbl.DELETE;
3822: CSTPPINV.l_issue_quantity_tbl.DELETE;
3823:
3824: CSTPPINV.l_item_start_index_tbl.DELETE;
3825: CSTPPINV.l_item_end_index_tbl.DELETE;

Line 3822: CSTPPINV.l_issue_quantity_tbl.DELETE;

3818:
3819: CSTPPINV.l_item_quantity_tbl.DELETE;
3820: CSTPPINV.l_make_quantity_tbl.DELETE;
3821: CSTPPINV.l_buy_quantity_tbl.DELETE;
3822: CSTPPINV.l_issue_quantity_tbl.DELETE;
3823:
3824: CSTPPINV.l_item_start_index_tbl.DELETE;
3825: CSTPPINV.l_item_end_index_tbl.DELETE;
3826:

Line 3824: CSTPPINV.l_item_start_index_tbl.DELETE;

3820: CSTPPINV.l_make_quantity_tbl.DELETE;
3821: CSTPPINV.l_buy_quantity_tbl.DELETE;
3822: CSTPPINV.l_issue_quantity_tbl.DELETE;
3823:
3824: CSTPPINV.l_item_start_index_tbl.DELETE;
3825: CSTPPINV.l_item_end_index_tbl.DELETE;
3826:
3827: /* --- start of auto log --- */
3828: <>

Line 3825: CSTPPINV.l_item_end_index_tbl.DELETE;

3821: CSTPPINV.l_buy_quantity_tbl.DELETE;
3822: CSTPPINV.l_issue_quantity_tbl.DELETE;
3823:
3824: CSTPPINV.l_item_start_index_tbl.DELETE;
3825: CSTPPINV.l_item_end_index_tbl.DELETE;
3826:
3827: /* --- start of auto log --- */
3828: <>
3829:

Line 3886: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;

3882: TYPE t_txn_category_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.txn_category%TYPE
3883: INDEX BY BINARY_INTEGER;
3884: l_last_txn_id_tbl t_txn_id_tbl;
3885: l_txn_category_tbl t_txn_category_tbl;
3886: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;
3887:
3888: /* --- start of auto log --- */
3889: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_item_periodic_cost';
3890: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;

Line 4495: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;

4491: TYPE t_txn_category_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.txn_category%TYPE
4492: INDEX BY BINARY_INTEGER;
4493: l_last_txn_id_tbl t_txn_id_tbl;
4494: l_txn_category_tbl t_txn_category_tbl;
4495: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;
4496:
4497: /* --- start of auto log --- */
4498: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_periodic_cost';
4499: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;