[Home] [Help]
5136:
5137: --move enh
5138: --bug 3615826 added the internal_scrap_txn_id column in WLMTI
5139: IF ((l_converted_txn_qty > 0) AND (l_converted_scrap_qty > 0)) THEN
5140: SELECT wip_transactions_s.nextval INTO l_scrap_txn_id from dual;
5141: END IF;
5142:
5143: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
5144: l_msg_tokens.delete;
6449: l_stmt_num := 60;
6450:
6451: SELECT wip_transactions_s.nextval
6452: INTO l_wmti_group_id
6453: FROM dual;
6454:
6455: ELSE
6456: l_stmt_num := 70;
6457: BEGIN
9072:
9073: IF (l_transaction_type = g_comp_txn) THEN
9074: SELECT mtl_material_transactions_s.nextval
9075: INTO l_cpl_txn_id
9076: FROM dual;
9077: END IF;
9078:
9079: IF ((l_primary_quantity > 0) and (l_to_intraoperation_step_type <> WIP_CONSTANTS.SCRAP)
9080: and (l_fm_intraoperation_step_type <> WIP_CONSTANTS.SCRAP)) THEN
9786: l_wltx_transactions_rec.ORGANIZATION_ID := l_organization_id;
9787:
9788: select wsm_split_merge_transactions_s.nextval
9789: into l_wltx_transactions_rec.TRANSACTION_ID
9790: from dual;
9791:
9792: l_wltx_starting_job_tbl(0).WIP_ENTITY_ID := l_wip_entity_id;
9793: l_wltx_starting_job_tbl(0).OPERATION_SEQ_NUM := l_job_to_op_seq_num;
9794:
12311: l_stmt_num := 90;
12312: BEGIN
12313: SELECT 1
12314: INTO x_show_secondary_quantities
12315: FROM dual
12316: WHERE EXISTS(
12317: SELECT 'secondary quantities exist'
12318: FROM WSM_OP_SECONDARY_QUANTITIES
12319: WHERE wip_entity_id = p_wip_entity_id
12378: l_stmt_num := 110;
12379: BEGIN
12380: SELECT 1
12381: INTO x_scrap_codes_defined
12382: FROM dual
12383: WHERE EXISTS(
12384: SELECT 'scrap codes exist'
12385: FROM WSM_OP_REASON_CODES
12386: WHERE wip_entity_id = p_wip_entity_id
12396: l_stmt_num := 120;
12397: BEGIN
12398: SELECT 1
12399: INTO x_bonus_codes_defined
12400: FROM dual
12401: WHERE EXISTS(
12402: SELECT 'bonus codes exist'
12403: FROM WSM_OP_REASON_CODES
12404: WHERE wip_entity_id = p_wip_entity_id
12478: --bug 5531107 check if next operation links exist
12479: BEGIN
12480: SELECT 1
12481: INTO l_next_links_exist
12482: FROM dual
12483: WHERE EXISTS
12484: (SELECT 'next_links_exist'
12485: FROM wsm_copy_op_networks wcon
12486: WHERE wcon.wip_entity_id = p_wip_entity_id
12784: SELECT decode(bitand(l_move_codemask, 65536), 65536, 1, 0),
12785: decode(bitand(l_move_codemask, 131072), 131072, 1, 0),
12786: decode(bitand(l_move_codemask, 262144), 262144, 1, 0)
12787: INTO x_show_move_in, x_show_move_out, x_show_move_to_next_op
12788: FROM dual;
12789:
12790: l_stmt_num := 50;
12791: BEGIN
12792: SELECT 1
12790: l_stmt_num := 50;
12791: BEGIN
12792: SELECT 1
12793: INTO x_show_scrap_codes
12794: FROM dual
12795: WHERE EXISTS(
12796: SELECT 'scrap codes exist'
12797: FROM WSM_OP_REASON_CODES
12798: WHERE wip_entity_id = p_wip_entity_id
12808: l_stmt_num := 60;
12809: BEGIN
12810: SELECT 1
12811: INTO x_show_bonus_codes
12812: FROM dual
12813: WHERE EXISTS(
12814: SELECT 'bonus codes exist'
12815: FROM WSM_OP_REASON_CODES
12816: WHERE wip_entity_id = p_wip_entity_id
12826: l_stmt_num := 70;
12827: BEGIN
12828: SELECT 1
12829: INTO x_show_secondary_quantities
12830: FROM dual
12831: WHERE EXISTS(
12832: SELECT 'secondary quantities exist'
12833: FROM WSM_OP_SECONDARY_QUANTITIES
12834: WHERE wip_entity_id = p_wip_entity_id