APPS.CSTPLCIR dependencies on CSTPLMWI

Line 41: l_layer_qty_table CSTPLMWI.LayerQtyRecTable;

37: group by
38: MCLACD.inv_layer_id;
39:
40:
41: l_layer_qty_table CSTPLMWI.LayerQtyRecTable;
42:
43: l_wip_layer_id NUMBER;
44:
45: l_err_code VARCHAR2(2000);

Line 146: l_layer_qty_table := CSTPLMWI.LayerQtyRecTable();

142: IF(l_exp_flag = 1) THEN
143: /* Expense - Expense Item or Issue from Expense Subinventory */
144:
145: l_stmt_num := 25;
146: l_layer_qty_table := CSTPLMWI.LayerQtyRecTable();
147: l_layer_qty_table.EXTEND;
148: l_layer_qty_table( l_layer_qty_table.FIRST ).layer_id := -1;
149: l_layer_qty_table( l_layer_qty_table.FIRST ).layer_qty := -1 * i_txn_qty;
150:

Line 157: l_layer_qty_table := CSTPLMWI.LayerQtyRecTable();

153: -- populate the layer_qty_table from MCLACD
154:
155: l_stmt_num := 30;
156: l_total_txn_qty := 0;
157: l_layer_qty_table := CSTPLMWI.LayerQtyRecTable();
158: FOR l_layer_qty_rec in layer_qty_cursor LOOP
159: l_layer_qty_table.EXTEND;
160:
161: l_layer_qty_table( l_layer_qty_table.LAST ).layer_id :=

Line 181: l_wip_layer_id := CSTPLMWI.wip_layer_create

177:
178:
179: l_stmt_num := 40;
180:
181: l_wip_layer_id := CSTPLMWI.wip_layer_create
182: (
183: i_wip_entity_id,
184: i_op_seq_num,
185: i_inv_item_id,

Line 206: CSTPLMWI.init_wip_layers

202:
203: -- insert into WROCD if not already there
204: l_stmt_num := 50;
205:
206: CSTPLMWI.init_wip_layers
207: (
208: i_wip_entity_id,
209: i_op_seq_num,
210: i_inv_item_id,

Line 298: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;

294:
295: l_stmt_num NUMBER := 0;
296:
297: l_sql_stmt VARCHAR2(8000);
298: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;
299: l_layer cst_wip_layers%ROWTYPE;
300:
301: l_txn_qty_remaining NUMBER;
302: l_consumed_qty NUMBER;

Line 315: CSTPLMWI.init_wip_layers

311:
312: BEGIN
313:
314: l_stmt_num := 20;
315: CSTPLMWI.init_wip_layers
316: (
317: i_wip_entity_id,
318: i_op_seq_num,
319: i_inv_item_id,

Line 339: l_sql_stmt := CSTPLMWI.wip_layer_consume_sql

335:
336:
337: -- component returns consume WIP layer(s) in reverse
338: l_stmt_num := 30;
339: l_sql_stmt := CSTPLMWI.wip_layer_consume_sql
340: (
341: ' ( CWL.applied_matl_qty - ' ||
342: ' CWL.relieved_matl_comp_qty - ' ||
343: ' CWL.relieved_matl_scrap_qty - ' ||

Line 346: CSTPLMWI.REVERSE

342: ' CWL.relieved_matl_comp_qty - ' ||
343: ' CWL.relieved_matl_scrap_qty - ' ||
344: ' CWL.relieved_matl_final_comp_qty ) > 0 ',
345: i_cost_method_id,
346: CSTPLMWI.REVERSE
347: );
348:
349: l_stmt_num := 40;
350: open l_layer_cursor for l_sql_stmt

Line 365: l_layer := CSTPLMWI.get_last_layer

361:
362: l_stmt_num := 70;
363: IF l_layer_cursor%NOTFOUND THEN
364:
365: l_layer := CSTPLMWI.get_last_layer
366: (
367: i_wip_entity_id,
368: i_op_seq_num,
369: i_inv_item_id,