APPS.INV_RCV_STD_DELIVER_APIS dependencies on DUAL

Line 174: FROM SYS.DUAL;

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

Line 1662: FROM DUAL;

1658:
1659: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
1660: SELECT rcv_interface_groups_s.NEXTVAL
1661: INTO l_group_id
1662: FROM DUAL;
1663:
1664: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
1665: ELSE
1666: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

Line 2159: FROM DUAL;

2155: -- default l_group_id ?? clear group id after done
2156: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
2157: SELECT rcv_interface_groups_s.NEXTVAL
2158: INTO l_group_id
2159: FROM DUAL;
2160:
2161: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2162: ELSE
2163: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

Line 2840: FROM DUAL;

2836: -- default l_group_id ?? clear group id after done
2837: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
2838: SELECT rcv_interface_groups_s.NEXTVAL
2839: INTO l_group_id
2840: FROM DUAL;
2841:
2842: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2843: ELSE
2844: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

Line 3499: FROM DUAL;

3495: -- default l_group_id ?? clear group id after done
3496: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
3497: SELECT rcv_interface_groups_s.NEXTVAL
3498: INTO l_group_id
3499: FROM DUAL;
3500:
3501: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
3502: ELSE
3503: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

Line 5199: FROM sys.dual;

5195: IF (l_txn_if_id IS NULL) THEN
5196: BEGIN
5197: SELECT mtl_material_transactions_s.NEXTVAL
5198: INTO l_txn_if_id
5199: FROM sys.dual;
5200: EXCEPTION
5201: WHEN OTHERS THEN
5202: IF (l_debug = 1) THEN
5203: print_debug('insert_mtli_helper: Error retrieving from seq.',1);

Line 5707: FROM dual;

5703: END IF;
5704:
5705: SELECT rcv_transactions_interface_s.NEXTVAL
5706: INTO l_new_intf_id
5707: FROM dual;
5708:
5709: IF (l_avail_prim_qty < l_remaining_prim_qty ) THEN
5710: IF (p_rcvtxn_uom_code <> l_rtv_rec.uom_code) THEN
5711: l_qty_to_insert := inv_convert.inv_um_convert( item_id => p_item_id,

Line 5996: FROM dual;

5992:
5993: ELSE
5994: SELECT rcv_transactions_interface_s.NEXTVAL
5995: INTO l_new_intf_id
5996: FROM dual;
5997:
5998: l_rti_tb(l_txn_id)(l_lot_num).rti_id := l_new_intf_id;
5999:
6000: IF (p_lot_number IS NOT NULL) THEN

Line 6005: into l_ser_txn_temp_id from dual;

6001:
6002: -- Generate the Serial Txn Temp Id
6003:
6004: select mtl_material_transactions_s.nextval
6005: into l_ser_txn_temp_id from dual;
6006:
6007: l_rti_tb(l_txn_id)(l_lot_num).lot_number := l_serial_rec.lot_num;
6008: l_rti_tb(l_txn_id)(l_lot_num).serial_intf_id := l_ser_txn_temp_id;
6009: ELSE