APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on DUAL

Line 1636: FROM DUAL;

1632:
1633: -- populate the transaction id to the record
1634: SELECT mtl_material_transactions_s.nextval
1635: INTO l_mtl_trx_tbl(i).transaction_id
1636: FROM DUAL;
1637:
1638: l_mtl_trx_tbl(i).transaction_batch_id := l_mtl_trx_tbl(1).transaction_id;
1639: l_mtl_trx_tbl(i).transaction_batch_seq := i;
1640:

Line 1688: FROM dual;

1684: l_progress := 120;
1685: -- populate transaction id
1686: SELECT mtl_material_transactions_s.nextval
1687: INTO l_mtl_trx_tbl(i).transaction_id
1688: FROM dual;
1689:
1690: l_progress := 130;
1691:
1692: -- If the record is parent transaction, populate transaction id to the

Line 2113: FROM dual;

2109:
2110: l_progress := 270;
2111: SELECT mtl_material_transactions_s.nextval
2112: INTO l_mtl_trx_tbl(1).transaction_id
2113: FROM dual;
2114:
2115: l_mtl_trx_tbl(1).transaction_batch_id := l_mtl_trx_tbl(1).transaction_id;
2116: l_mtl_trx_tbl(1).transaction_batch_seq := 1;
2117: -- end of updating the input(first) record of the pl/sql table

Line 2195: FROM dual;

2191:
2192: l_progress := 300;
2193: SELECT mtl_material_transactions_s.nextval
2194: INTO l_mtl_trx_tbl(1).transaction_id
2195: FROM dual;
2196:
2197: l_mtl_trx_tbl(1).parent_transaction_id := p_mtl_trx_tbl(1).transaction_id;
2198: l_mtl_trx_tbl(1).transaction_batch_id := p_mtl_trx_tbl(1).transaction_id;
2199: l_mtl_trx_tbl(1).transaction_batch_seq := 1;

Line 2877: FROM dual;

2873: -- populate transaction id
2874: l_progress := 400;
2875: SELECT mtl_material_transactions_s.nextval
2876: INTO l_mtl_trx_tbl(i).transaction_id
2877: FROM dual;
2878:
2879: -- populate the columns which has same value for all types of records
2880: l_mtl_trx_tbl(i).inventory_item_id := p_mtl_trx_tbl(1).inventory_item_id;
2881: l_mtl_trx_tbl(i).revision := p_mtl_trx_tbl(1).revision;