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 131: l_layer_qty_table := CSTPLMWI.LayerQtyRecTable();

127: IF(l_item_exp_flag = 1) THEN
128: /* Expense Item */
129:
130: l_stmt_num := 25;
131: l_layer_qty_table := CSTPLMWI.LayerQtyRecTable();
132: l_layer_qty_table.EXTEND;
133: l_layer_qty_table( l_layer_qty_table.FIRST ).layer_id := -1;
134: l_layer_qty_table( l_layer_qty_table.FIRST ).layer_qty := -1 * i_txn_qty;
135: /*

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

147: -- populate the layer_qty_table from MCLACD
148:
149: l_stmt_num := 30;
150: l_total_txn_qty := 0;
151: l_layer_qty_table := CSTPLMWI.LayerQtyRecTable();
152: FOR l_layer_qty_rec in layer_qty_cursor LOOP
153: l_layer_qty_table.EXTEND;
154:
155: l_layer_qty_table( l_layer_qty_table.LAST ).layer_id :=

Line 175: l_wip_layer_id := CSTPLMWI.wip_layer_create

171:
172:
173: l_stmt_num := 40;
174:
175: l_wip_layer_id := CSTPLMWI.wip_layer_create
176: (
177: i_wip_entity_id,
178: i_op_seq_num,
179: i_inv_item_id,

Line 200: CSTPLMWI.init_wip_layers

196:
197: -- insert into WROCD if not already there
198: l_stmt_num := 50;
199:
200: CSTPLMWI.init_wip_layers
201: (
202: i_wip_entity_id,
203: i_op_seq_num,
204: i_inv_item_id,

Line 292: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;

288:
289: l_stmt_num NUMBER := 0;
290:
291: l_sql_stmt VARCHAR2(8000);
292: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;
293: l_layer cst_wip_layers%ROWTYPE;
294:
295: l_txn_qty_remaining NUMBER;
296: l_consumed_qty NUMBER;

Line 309: CSTPLMWI.init_wip_layers

305:
306: BEGIN
307:
308: l_stmt_num := 20;
309: CSTPLMWI.init_wip_layers
310: (
311: i_wip_entity_id,
312: i_op_seq_num,
313: i_inv_item_id,

Line 333: l_sql_stmt := CSTPLMWI.wip_layer_consume_sql

329:
330:
331: -- component returns consume WIP layer(s) in reverse
332: l_stmt_num := 30;
333: l_sql_stmt := CSTPLMWI.wip_layer_consume_sql
334: (
335: ' ( CWL.applied_matl_qty - ' ||
336: ' CWL.relieved_matl_comp_qty - ' ||
337: ' CWL.relieved_matl_scrap_qty - ' ||

Line 340: CSTPLMWI.REVERSE

336: ' CWL.relieved_matl_comp_qty - ' ||
337: ' CWL.relieved_matl_scrap_qty - ' ||
338: ' CWL.relieved_matl_final_comp_qty ) > 0 ',
339: i_cost_method_id,
340: CSTPLMWI.REVERSE
341: );
342:
343: l_stmt_num := 40;
344: open l_layer_cursor for l_sql_stmt

Line 359: l_layer := CSTPLMWI.get_last_layer

355:
356: l_stmt_num := 70;
357: IF l_layer_cursor%NOTFOUND THEN
358:
359: l_layer := CSTPLMWI.get_last_layer
360: (
361: i_wip_entity_id,
362: i_op_seq_num,
363: i_inv_item_id,