APPS.INV_TXN_MANAGER_PUB dependencies on DUAL

Line 465: FROM DUAL;

461: IF (p_current_index = l_count AND l_remaining_qty > 0)
462: THEN
463: SELECT mtl_material_transactions_s.NEXTVAL
464: INTO l_transaction_interface_id --J-dev
465: FROM DUAL;
466:
467: --shuld execute only once
468: IF (l_debug = 1)
469: THEN

Line 1020: FROM DUAL;

1016: l_rem_var_index := l_rem_serial_tbl.FIRST;
1017:
1018: SELECT mtl_material_transactions_s.NEXTVAL
1019: INTO l_sequence
1020: FROM DUAL;
1021:
1022: IF (l_debug = 1)
1023: THEN
1024: inv_log_util.TRACE ('l_breadcrumb 120'

Line 1840: FROM DUAL;

1836: l_old_hdr_id := p_txn_hdr_id;
1837:
1838: SELECT mtl_material_transactions_s.NEXTVAL
1839: INTO l_new_hdr_id
1840: FROM DUAL;
1841:
1842: p_txn_hdr_id := l_new_hdr_id;
1843:
1844: UPDATE mtl_material_transactions_temp

Line 1887: FROM DUAL;

1883: IS
1884: BEGIN
1885: SELECT fnd_profile.VALUE (p_prof)
1886: INTO x_ret
1887: FROM DUAL;
1888: END poget;
1889:
1890: /******************************************************************
1891: *