APPS.WSMPLBMI dependencies on WSM_OP_REASON_CODES

Line 9208: update wsm_op_reason_codes

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

Line 9253: update wsm_op_reason_codes

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

Line 9655: update wsm_op_reason_codes

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

Line 12383: FROM WSM_OP_REASON_CODES

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

Line 12401: FROM WSM_OP_REASON_CODES

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

Line 12795: FROM WSM_OP_REASON_CODES

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

Line 12813: FROM WSM_OP_REASON_CODES

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