[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
9070:
9071: IF (l_transaction_type = g_comp_txn) THEN
9072: SELECT mtl_material_transactions_s.nextval
9073: INTO l_cpl_txn_id
9074: FROM dual;
9075: END IF;
9076:
9077: IF ((l_primary_quantity > 0) and (l_to_intraoperation_step_type <> WIP_CONSTANTS.SCRAP)
9078: and (l_fm_intraoperation_step_type <> WIP_CONSTANTS.SCRAP)) THEN
9784: l_wltx_transactions_rec.ORGANIZATION_ID := l_organization_id;
9785:
9786: select wsm_split_merge_transactions_s.nextval
9787: into l_wltx_transactions_rec.TRANSACTION_ID
9788: from dual;
9789:
9790: l_wltx_starting_job_tbl(0).WIP_ENTITY_ID := l_wip_entity_id;
9791: l_wltx_starting_job_tbl(0).OPERATION_SEQ_NUM := l_job_to_op_seq_num;
9792:
12309: l_stmt_num := 90;
12310: BEGIN
12311: SELECT 1
12312: INTO x_show_secondary_quantities
12313: FROM dual
12314: WHERE EXISTS(
12315: SELECT 'secondary quantities exist'
12316: FROM WSM_OP_SECONDARY_QUANTITIES
12317: WHERE wip_entity_id = p_wip_entity_id
12376: l_stmt_num := 110;
12377: BEGIN
12378: SELECT 1
12379: INTO x_scrap_codes_defined
12380: FROM dual
12381: WHERE EXISTS(
12382: SELECT 'scrap codes exist'
12383: FROM WSM_OP_REASON_CODES
12384: WHERE wip_entity_id = p_wip_entity_id
12394: l_stmt_num := 120;
12395: BEGIN
12396: SELECT 1
12397: INTO x_bonus_codes_defined
12398: FROM dual
12399: WHERE EXISTS(
12400: SELECT 'bonus codes exist'
12401: FROM WSM_OP_REASON_CODES
12402: WHERE wip_entity_id = p_wip_entity_id
12476: --bug 5531107 check if next operation links exist
12477: BEGIN
12478: SELECT 1
12479: INTO l_next_links_exist
12480: FROM dual
12481: WHERE EXISTS
12482: (SELECT 'next_links_exist'
12483: FROM wsm_copy_op_networks wcon
12484: WHERE wcon.wip_entity_id = p_wip_entity_id
12782: SELECT decode(bitand(l_move_codemask, 65536), 65536, 1, 0),
12783: decode(bitand(l_move_codemask, 131072), 131072, 1, 0),
12784: decode(bitand(l_move_codemask, 262144), 262144, 1, 0)
12785: INTO x_show_move_in, x_show_move_out, x_show_move_to_next_op
12786: FROM dual;
12787:
12788: l_stmt_num := 50;
12789: BEGIN
12790: SELECT 1
12788: l_stmt_num := 50;
12789: BEGIN
12790: SELECT 1
12791: INTO x_show_scrap_codes
12792: FROM dual
12793: WHERE EXISTS(
12794: SELECT 'scrap codes exist'
12795: FROM WSM_OP_REASON_CODES
12796: WHERE wip_entity_id = p_wip_entity_id
12806: l_stmt_num := 60;
12807: BEGIN
12808: SELECT 1
12809: INTO x_show_bonus_codes
12810: FROM dual
12811: WHERE EXISTS(
12812: SELECT 'bonus codes exist'
12813: FROM WSM_OP_REASON_CODES
12814: WHERE wip_entity_id = p_wip_entity_id
12824: l_stmt_num := 70;
12825: BEGIN
12826: SELECT 1
12827: INTO x_show_secondary_quantities
12828: FROM dual
12829: WHERE EXISTS(
12830: SELECT 'secondary quantities exist'
12831: FROM WSM_OP_SECONDARY_QUANTITIES
12832: WHERE wip_entity_id = p_wip_entity_id