APPS.WSMPLBMI dependencies on WSM_OP_REASON_CODES

Line 9210: update wsm_op_reason_codes

9206: AND (p_scrap_codes_tbls(l_header_id).count > 0)) THEN
9207:
9208: l_stmt_num := 253.4;
9209: forall i in p_scrap_codes_tbls(l_header_id).first..p_scrap_codes_tbls(l_header_id).last
9210: update wsm_op_reason_codes
9211: set QUANTITY = p_scrap_code_qty_tbls(l_header_id)(i),
9212: LAST_UPDATE_DATE = sysdate,
9213: LAST_UPDATED_BY = g_user_id,
9214: LAST_UPDATED_LOGIN = g_login_id

Line 9255: update wsm_op_reason_codes

9251: END LOOP;
9252: END IF;
9253: l_stmt_num := 253.6;
9254: forall i in p_bonus_codes_tbls(l_header_id).first..p_bonus_codes_tbls(l_header_id).last
9255: update wsm_op_reason_codes
9256: set QUANTITY = p_bonus_code_qty_tbls(l_header_id)(i),
9257: LAST_UPDATE_DATE = sysdate,
9258: LAST_UPDATED_BY = g_user_id,
9259: LAST_UPDATED_LOGIN = g_login_id

Line 9657: update wsm_op_reason_codes

9653: LAST_UPDATE_DATE = sysdate,
9654: LAST_UPDATED_BY = g_user_id
9655: WHERE WJSQ.wip_entity_id = l_wip_entity_id;
9656:
9657: update wsm_op_reason_codes
9658: set QUANTITY = NULL,
9659: LAST_UPDATE_DATE = sysdate,
9660: LAST_UPDATED_BY = g_user_id,
9661: LAST_UPDATED_LOGIN = g_login_id

Line 12385: FROM WSM_OP_REASON_CODES

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
12387: --bug 5191223 Added the condition operation_seq_num = p_operation_seq_num
12388: AND operation_seq_num = p_operation_seq_num
12389: AND code_type = 1

Line 12403: FROM WSM_OP_REASON_CODES

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
12405: --bug 5191223 Added the condition operation_seq_num = p_operation_seq_num
12406: AND operation_seq_num = p_operation_seq_num
12407: AND code_type = 2

Line 12797: FROM WSM_OP_REASON_CODES

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
12799: --bug 5191223 Added the condition operation_seq_num = p_operation_seq_num
12800: AND operation_seq_num = p_operation_seq_num
12801: AND code_type = 1

Line 12815: FROM WSM_OP_REASON_CODES

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
12817: --bug 5191223 Added the condition operation_seq_num = p_operation_seq_num
12818: AND operation_seq_num = p_operation_seq_num
12819: AND code_type = 2