APPS.WSMPLOAD dependencies on WSM_SPLIT_MERGE_TRANSACTIONS_S

Line 731: transaction_id = wsm_split_merge_transactions_s.nextval

727: PROGRAM_ID = g_program_id,
728: LAST_UPDATE_DATE = sysdate,
729: LAST_UPDATED_BY = g_user_id,
730: LAST_UPDATE_LOGIN = g_user_login_id,
731: transaction_id = wsm_split_merge_transactions_s.nextval
732: where wsmti.header_id = l_header_id_tbl(l_cntr)
733: RETURNING transaction_id BULK COLLECT into l_txn_id_tbl;
734: END;
735: -- Completed setting the status...

Line 846: -- select wsm_split_merge_transactions_s.nextval into l_txn_header_rec.transaction_id from dual;

842: l_txn_header_rec.TRANSACTION_DATE := l_wsm_wtxn_hdr_tbl(l_txn_counter).TRANSACTION_DATE;
843: l_txn_header_rec.TRANSACTION_REFERENCE := l_wsm_wtxn_hdr_tbl(l_txn_counter).TRANSACTION_REFERENCE;
844: l_txn_header_rec.REASON_ID := l_wsm_wtxn_hdr_tbl(l_txn_counter).REASON_ID;
845:
846: -- select wsm_split_merge_transactions_s.nextval into l_txn_header_rec.transaction_id from dual;
847: l_txn_header_rec.transaction_id := l_txn_id_tbl(l_txn_counter);
848:
849: l_txn_header_rec.ORGANIZATION_ID := l_wsm_wtxn_hdr_tbl(l_txn_counter).ORGANIZATION_ID;
850: