APPS.WSMPLBMI dependencies on WSM_SPLIT_MERGE_TRANSACTIONS

Line 1104: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_split_merge_transactions');

1100: IF ( (l_res_rows > 0) OR (x_return_code <> 0) ) THEN
1101: x_return_code := 1;
1102:
1103: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
1104: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_split_merge_transactions');
1105: x_err_buf := FND_MESSAGE.GET;
1106:
1107: fnd_file.put_line(fnd_file.log, 'WSMPLBMI.custom_validation(stmt_num='||l_stmt_num||'): '||x_err_buf);
1108:

Line 5568: from wsm_split_merge_transactions wsmt,

5564: -- check if WLT exists after this move transaction
5565: BEGIN
5566: select max(wsmt.transaction_date)
5567: into l_wlt_time
5568: from wsm_split_merge_transactions wsmt,
5569: wsm_sm_starting_jobs wssj
5570: where wsmt.organization_id = p_org_id
5571: and wsmt.transaction_id = wssj.transaction_id
5572: and wssj.wip_entity_id = p_wip_entity_id;

Line 9788: select wsm_split_merge_transactions_s.nextval

9784: l_wltx_transactions_rec.REASON_ID := l_reason_id;
9785: l_wltx_transactions_rec.EMPLOYEE_ID := p_employee_id;
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;

Line 11066: FROM WSM_SPLIT_MERGE_TRANSACTIONS WSMT,

11062: AND NOT (
11063: (nvl(WO.quantity_waiting_to_move, 0) <> 0)
11064: AND
11065: (EXISTS (SELECT WSMT.ROWID
11066: FROM WSM_SPLIT_MERGE_TRANSACTIONS WSMT,
11067: WSM_SM_RESULTING_JOBS WSRJ
11068: WHERE WSRJ.wip_entity_id = WO.wip_entity_id
11069: AND WSRJ.starting_operation_seq_num = WO.operation_seq_num
11070: AND WSRJ.starting_intraoperation_step = g_tomove