APPS.CSTPLCAC dependencies on CSTPLMWI

Line 33: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;

29:
30: l_stmt_num NUMBER := 0;
31:
32: l_sql_stmt VARCHAR2(8000);
33: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;
34: l_layer cst_wip_layers%ROWTYPE;
35:
36: l_txn_qty_remaining NUMBER;
37: l_consumed_qty NUMBER;

Line 85: CSTPLMWI.reset_temp_columns

81: ----------------------------------------------------
82:
83: l_stmt_num := 10;
84:
85: CSTPLMWI.reset_temp_columns
86: (
87: i_wip_entity_id,
88: o_err_num,
89: o_err_msg

Line 450: CSTPLMWI.init_wip_layers

446:
447:
448: /* If item is not an expense item, create-consume layers */
449: IF ( l_exp_item <> 1 ) THEN
450: CSTPLMWI.init_wip_layers
451: (
452: i_wip_entity_id,
453: wro_rec.operation_seq_num,
454: wro_rec.inventory_item_id,

Line 474: l_sql_stmt := CSTPLMWI.wip_layer_consume_sql

470:
471: -- consume WIP layer(s)
472: -- assembly completions consume WIP in normal order
473: l_stmt_num := 120;
474: l_sql_stmt := CSTPLMWI.wip_layer_consume_sql
475: (
476: ' sign( CWL.applied_matl_qty - ' ||
477: ' CWL.relieved_matl_comp_qty - ' ||
478: ' CWL.relieved_matl_scrap_qty - ' ||

Line 482: CSTPLMWI.NORMAL

478: ' CWL.relieved_matl_scrap_qty - ' ||
479: ' CWL.relieved_matl_final_comp_qty ) = ' ||
480: ' sign( :quantity_per_assembly ) ',
481: i_cost_method_id,
482: CSTPLMWI.NORMAL
483: );
484:
485: l_stmt_num := 130;
486: open l_layer_cursor

Line 504: l_layer := CSTPLMWI.get_last_layer

500:
501: l_stmt_num := 150;
502: IF l_layer_cursor%NOTFOUND THEN
503:
504: l_layer := CSTPLMWI.get_last_layer
505: (
506: i_wip_entity_id,
507: wro_rec.operation_seq_num,
508: wro_rec.inventory_item_id,

Line 1147: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;

1143:
1144: l_stmt_num NUMBER := 0;
1145:
1146: l_sql_stmt VARCHAR2(8000);
1147: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;
1148: l_layer cst_wip_layers%ROWTYPE;
1149:
1150: l_txn_qty_remaining NUMBER;
1151: l_consumed_qty NUMBER;

Line 1223: CSTPLMWI.reset_temp_columns

1219: ----------------------------------------------------
1220:
1221: l_stmt_num := 10;
1222:
1223: CSTPLMWI.reset_temp_columns
1224: (
1225: i_wip_entity_id,
1226: o_err_num,
1227: o_err_msg

Line 1460: CSTPLMWI.init_wip_layers

1456:
1457: /* If item is not an expense item, create-consume layers */
1458: IF ( l_exp_item <> 1 ) THEN
1459:
1460: CSTPLMWI.init_wip_layers
1461: (
1462: i_wip_entity_id,
1463: wro_rec.operation_seq_num,
1464: wro_rec.inventory_item_id,

Line 1483: l_sql_stmt := CSTPLMWI.wip_layer_consume_sql

1479:
1480:
1481: -- assembly completions consume WIP layer(s) in reverse order
1482: l_stmt_num := 50;
1483: l_sql_stmt := CSTPLMWI.wip_layer_consume_sql
1484: (
1485: ' sign( CWL.relieved_matl_comp_qty ) = ' ||
1486: ' sign( :quantity_per_assembly ) ',
1487: i_cost_method_id,

Line 1488: CSTPLMWI.REVERSE

1484: (
1485: ' sign( CWL.relieved_matl_comp_qty ) = ' ||
1486: ' sign( :quantity_per_assembly ) ',
1487: i_cost_method_id,
1488: CSTPLMWI.REVERSE
1489: );
1490:
1491: l_stmt_num := 60;
1492: open l_layer_cursor

Line 1513: l_layer := CSTPLMWI.get_last_layer

1509: fetch l_layer_cursor into l_layer;
1510:
1511: l_stmt_num := 80;
1512: IF l_layer_cursor%NOTFOUND THEN
1513: l_layer := CSTPLMWI.get_last_layer
1514: (
1515: i_wip_entity_id,
1516: wro_rec.operation_seq_num,
1517: wro_rec.inventory_item_id,