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 1145: l_layer_cursor CSTPLMWI.REF_CURSOR_TYPE;

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

Line 1220: CSTPLMWI.reset_temp_columns

1216: ----------------------------------------------------
1217:
1218: l_stmt_num := 10;
1219:
1220: CSTPLMWI.reset_temp_columns
1221: (
1222: i_wip_entity_id,
1223: o_err_num,
1224: o_err_msg

Line 1457: CSTPLMWI.init_wip_layers

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

Line 1480: l_sql_stmt := CSTPLMWI.wip_layer_consume_sql

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

Line 1485: CSTPLMWI.REVERSE

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

Line 1510: l_layer := CSTPLMWI.get_last_layer

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