APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on DUAL

Line 1619: FROM DUAL;

1615:
1616: -- populate the transaction id to the record
1617: SELECT mtl_material_transactions_s.nextval
1618: INTO l_mtl_trx_tbl(i).transaction_id
1619: FROM DUAL;
1620:
1621: l_mtl_trx_tbl(i).transaction_batch_id := l_mtl_trx_tbl(1).transaction_id;
1622: l_mtl_trx_tbl(i).transaction_batch_seq := i;
1623:

Line 1671: FROM dual;

1667: l_progress := 120;
1668: -- populate transaction id
1669: SELECT mtl_material_transactions_s.nextval
1670: INTO l_mtl_trx_tbl(i).transaction_id
1671: FROM dual;
1672:
1673: l_progress := 130;
1674:
1675: -- If the record is parent transaction, populate transaction id to the

Line 2096: FROM dual;

2092:
2093: l_progress := 270;
2094: SELECT mtl_material_transactions_s.nextval
2095: INTO l_mtl_trx_tbl(1).transaction_id
2096: FROM dual;
2097:
2098: l_mtl_trx_tbl(1).transaction_batch_id := l_mtl_trx_tbl(1).transaction_id;
2099: l_mtl_trx_tbl(1).transaction_batch_seq := 1;
2100: -- end of updating the input(first) record of the pl/sql table

Line 2178: FROM dual;

2174:
2175: l_progress := 300;
2176: SELECT mtl_material_transactions_s.nextval
2177: INTO l_mtl_trx_tbl(1).transaction_id
2178: FROM dual;
2179:
2180: l_mtl_trx_tbl(1).parent_transaction_id := p_mtl_trx_tbl(1).transaction_id;
2181: l_mtl_trx_tbl(1).transaction_batch_id := p_mtl_trx_tbl(1).transaction_id;
2182: l_mtl_trx_tbl(1).transaction_batch_seq := 1;

Line 2832: FROM dual;

2828: -- populate transaction id
2829: l_progress := 400;
2830: SELECT mtl_material_transactions_s.nextval
2831: INTO l_mtl_trx_tbl(i).transaction_id
2832: FROM dual;
2833:
2834: -- populate the columns which has same value for all types of records
2835: l_mtl_trx_tbl(i).inventory_item_id := p_mtl_trx_tbl(1).inventory_item_id;
2836: l_mtl_trx_tbl(i).revision := p_mtl_trx_tbl(1).revision;