DBA Data[Home] [Help]

APPS.WSMPLOAD dependencies on DUAL

Line 670: select wsm_sm_txn_int_group_s.nextval into l_internal_group_id from dual;

666: WSMPJUPD.g_copy_mode := p_copy_flag; -- Make copies based on p_copy_flag
667: END IF;
668:
669: l_stmt_num := 10;
670: select wsm_sm_txn_int_group_s.nextval into l_internal_group_id from dual;
671:
672: /* do you need this ... global variable.... */
673: WSMPLOAD.G_GROUP_ID := l_internal_group_id; -- WLTEnh add
674:

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: