APPS.CSTPLCAS dependencies on CSTPLMWI

Line 28: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;

24:
25: l_stmt_num NUMBER := 0;
26:
27: l_sql_stmt VARCHAR2(8000);
28: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;
29: l_layer cst_wip_layers%ROWTYPE;
30:
31: l_txn_qty_remaining NUMBER;
32: l_consumed_qty NUMBER;

Line 68: CSTPLMWI.reset_temp_columns

64: ----------------------------------------------------*/
65:
66: l_stmt_num := 10;
67:
68: CSTPLMWI.reset_temp_columns
69: (
70: i_wip_entity_id,
71: o_err_num,
72: o_err_msg

Line 110: CSTPLMWI.init_wip_layers

106: l_stmt_num := 60;
107: FOR wro_rec IN wro_cursor( i_wip_entity_id, i_op_seq_num ) LOOP
108:
109: l_stmt_num := 70;
110: CSTPLMWI.init_wip_layers
111: (
112: i_wip_entity_id,
113: wro_rec.operation_seq_num,
114: wro_rec.inventory_item_id,

Line 135: l_sql_stmt := CSTPLMWI.wip_layer_consume_sql

131:
132: /* consume WIP layer(s)
133: scraps consume WIP in normal order */
134: l_stmt_num := 80;
135: l_sql_stmt := CSTPLMWI.wip_layer_consume_sql
136: (
137: ' sign( CWL.applied_matl_qty - ' ||
138: ' CWL.relieved_matl_comp_qty - ' ||
139: ' CWL.relieved_matl_scrap_qty - ' ||

Line 143: CSTPLMWI.NORMAL

139: ' CWL.relieved_matl_scrap_qty - ' ||
140: ' CWL.relieved_matl_final_comp_qty ) = ' ||
141: ' sign( :quantity_per_assembly ) ',
142: i_cost_method_id,
143: CSTPLMWI.NORMAL
144: );
145:
146: l_stmt_num := 90;
147: open l_layer_cursor

Line 165: l_layer := CSTPLMWI.get_last_layer

161:
162: l_stmt_num := 110;
163: IF l_layer_cursor%NOTFOUND THEN
164:
165: l_layer := CSTPLMWI.get_last_layer
166: (
167: i_wip_entity_id,
168: wro_rec.operation_seq_num,
169: wro_rec.inventory_item_id,

Line 713: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;

709:
710: l_stmt_num NUMBER := 0;
711:
712: l_sql_stmt VARCHAR2(8000);
713: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;
714: l_layer cst_wip_layers%ROWTYPE;
715:
716: l_txn_qty_remaining NUMBER;
717: l_consumed_qty NUMBER;

Line 760: CSTPLMWI.reset_temp_columns

756: --------------------------------------------------*/
757:
758: l_stmt_num := 10;
759:
760: CSTPLMWI.reset_temp_columns
761: (
762: i_wip_entity_id,
763: o_err_num,
764: o_err_msg

Line 801: CSTPLMWI.init_wip_layers

797:
798: l_stmt_num := 60;
799: FOR wro_rec IN wro_cursor LOOP
800:
801: CSTPLMWI.init_wip_layers
802: (
803: i_wip_entity_id,
804: wro_rec.operation_seq_num,
805: wro_rec.inventory_item_id,

Line 826: l_sql_stmt := CSTPLMWI.wip_layer_consume_sql

822:
823: /* replenish WIP layer(s)
824: scrap return replenishes WIP in reverse order */
825: l_stmt_num := 70;
826: l_sql_stmt := CSTPLMWI.wip_layer_consume_sql
827: (
828: ' sign( CWL.relieved_matl_scrap_qty ) = ' ||
829: ' sign( :quantity_per_assembly ) ',
830: i_cost_method_id,

Line 831: CSTPLMWI.REVERSE

827: (
828: ' sign( CWL.relieved_matl_scrap_qty ) = ' ||
829: ' sign( :quantity_per_assembly ) ',
830: i_cost_method_id,
831: CSTPLMWI.REVERSE
832: );
833:
834: l_stmt_num := 80;
835: open l_layer_cursor

Line 858: l_layer := CSTPLMWI.get_last_layer

854:
855: l_stmt_num := 100;
856: IF l_layer_cursor%NOTFOUND THEN
857:
858: l_layer := CSTPLMWI.get_last_layer
859: (
860: i_wip_entity_id,
861: wro_rec.operation_seq_num,
862: wro_rec.inventory_item_id,