APPS.INV_RCV_STD_DELIVER_APIS dependencies on DUAL

Line 176: FROM SYS.DUAL;

172: -- If not, populate the item with get_interface_id function
173: --if l_rcv_transaction_rec.INTERFACE_transaction_id is null THEN
174: SELECT rcv_transactions_interface_s.NEXTVAL
175: INTO l_interface_transaction_id
176: FROM SYS.DUAL;
177:
178: l_rcv_transaction_rec.interface_transaction_id := l_interface_transaction_id;
179:
180: --else

Line 1696: FROM DUAL;

1692:
1693: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
1694: SELECT rcv_interface_groups_s.NEXTVAL
1695: INTO l_group_id
1696: FROM DUAL;
1697:
1698: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1699: ELSE
1700: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

Line 2193: FROM DUAL;

2189: -- default l_group_id ?? clear group id after done
2190: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
2191: SELECT rcv_interface_groups_s.NEXTVAL
2192: INTO l_group_id
2193: FROM DUAL;
2194:
2195: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2196: ELSE
2197: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

Line 2875: FROM DUAL;

2871: -- default l_group_id ?? clear group id after done
2872: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
2873: SELECT rcv_interface_groups_s.NEXTVAL
2874: INTO l_group_id
2875: FROM DUAL;
2876:
2877: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2878: ELSE
2879: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

Line 3595: FROM DUAL;

3591: -- default l_group_id ?? clear group id after done
3592: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
3593: SELECT rcv_interface_groups_s.NEXTVAL
3594: INTO l_group_id
3595: FROM DUAL;
3596:
3597: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
3598: ELSE
3599: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

Line 5321: FROM sys.dual;

5317: IF (l_txn_if_id IS NULL) THEN
5318: BEGIN
5319: SELECT mtl_material_transactions_s.NEXTVAL
5320: INTO l_txn_if_id
5321: FROM sys.dual;
5322: EXCEPTION
5323: WHEN OTHERS THEN
5324: IF (l_debug = 1) THEN
5325: print_debug('insert_mtli_helper: Error retrieving from seq.',1);

Line 5842: FROM dual;

5838: END IF;
5839:
5840: SELECT rcv_transactions_interface_s.NEXTVAL
5841: INTO l_new_intf_id
5842: FROM dual;
5843:
5844: IF (l_avail_prim_qty < l_remaining_prim_qty ) THEN
5845: IF (p_rcvtxn_uom_code <> l_rtv_rec.uom_code) THEN
5846: l_qty_to_insert := inv_convert.inv_um_convert( item_id => p_item_id,

Line 6139: FROM dual;

6135:
6136: ELSE
6137: SELECT rcv_transactions_interface_s.NEXTVAL
6138: INTO l_new_intf_id
6139: FROM dual;
6140:
6141: l_rti_tb(l_txn_id)(l_lot_num).rti_id := l_new_intf_id;
6142:
6143: IF (p_lot_number IS NOT NULL) THEN

Line 6148: into l_ser_txn_temp_id from dual;

6144:
6145: -- Generate the Serial Txn Temp Id
6146:
6147: select mtl_material_transactions_s.nextval
6148: into l_ser_txn_temp_id from dual;
6149:
6150: l_rti_tb(l_txn_id)(l_lot_num).lot_number := l_serial_rec.lot_num;
6151: l_rti_tb(l_txn_id)(l_lot_num).serial_intf_id := l_ser_txn_temp_id;
6152: ELSE