APPS.INV_RCV_STD_TRANSFER_APIS dependencies on DUAL

Line 69: FROM sys.DUAL;

65:
66: --Generate a new value for RTID from the sequence
67: SELECT rcv_transactions_interface_s.NEXTVAL
68: INTO l_interface_transaction_id
69: FROM sys.DUAL;
70:
71: l_parent_transaction_id := p_rcv_transaction_rec.rcv_transaction_id;
72:
73: BEGIN

Line 2496: FROM sys.dual;

2492:
2493: IF inv_rcv_common_apis.g_rcv_global_var.interface_group_id IS NULL THEN
2494: SELECT rcv_interface_groups_s.NEXTVAL
2495: INTO l_group_id
2496: FROM sys.dual;
2497: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := l_group_id;
2498: ELSE
2499: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
2500: END IF;

Line 2808: FROM sys.dual;

2804: IF (l_txn_if_id IS NULL) THEN
2805: BEGIN
2806: SELECT mtl_material_transactions_s.NEXTVAL
2807: INTO l_txn_if_id
2808: FROM sys.dual;
2809: EXCEPTION
2810: WHEN OTHERS THEN
2811: IF (l_debug = 1) THEN
2812: print_debug('insert_mtli_helper: Error retrieving from seq.',1);

Line 3375: FROM dual;

3371:
3372:
3373: SELECT rcv_transactions_interface_s.NEXTVAL
3374: INTO l_new_intf_id
3375: FROM dual;
3376:
3377: IF (l_avail_prim_qty < l_remaining_prim_qty ) THEN
3378: IF (p_transfer_uom_code <> l_rtv_rec.uom_code) THEN
3379: l_qty_to_insert := inv_convert.inv_um_convert( item_id => p_item_id,

Line 3653: SELECT 'Y' INTO l_rss_exist FROM DUAL

3649: L_RTI_REC_FOUND := FALSE;
3650:
3651: BEGIN
3652: --Added for bug 14269755
3653: SELECT 'Y' INTO l_rss_exist FROM DUAL
3654: WHERE EXISTS
3655: (SELECT 1
3656: FROM rcv_serials_supply rss,
3657: mtl_serial_numbers_interface msni

Line 3693: FROM dual;

3689:
3690: ELSE
3691: SELECT rcv_transactions_interface_s.NEXTVAL
3692: INTO l_new_intf_id
3693: FROM dual;
3694:
3695: l_rti_tb(l_txn_id)(l_lot_num).rti_id := l_new_intf_id;
3696:
3697: IF p_lot_control_code = 2 AND l_lot_num <> '@$#_' THEN -- bug 14269755 IF (p_lot_number IS NOT NULL) THEN

Line 3702: into l_ser_txn_temp_id from dual;

3698:
3699: -- Generate the Serial Txn Temp Id
3700:
3701: select mtl_material_transactions_s.nextval
3702: into l_ser_txn_temp_id from dual;
3703:
3704: l_rti_tb(l_txn_id)(l_lot_num).lot_number := l_serial_rec.lot_num;
3705: l_rti_tb(l_txn_id)(l_lot_num).serial_intf_id := l_ser_txn_temp_id;
3706: ELSE

Line 3807: FROM dual;

3803: ELSE
3804:
3805: SELECT rcv_transactions_interface_s.NEXTVAL
3806: INTO l_new_intf_id
3807: FROM dual;
3808:
3809: l_rti_tb(l_txn_id)(l_lot_num).rti_id := l_new_intf_id;
3810:
3811: IF p_lot_control_code = 2 AND l_lot_num <> '@$#_' THEN -- bug 14269755 IF (p_lot_number IS NOT NULL) THEN

Line 3816: into l_ser_txn_temp_id from dual;

3812:
3813: -- Generate the Serial Txn Temp Id
3814:
3815: select mtl_material_transactions_s.nextval
3816: into l_ser_txn_temp_id from dual;
3817:
3818: l_rti_tb(l_txn_id)(l_lot_num).lot_number := l_serial_rec.lot_num;
3819: l_rti_tb(l_txn_id)(l_lot_num).serial_intf_id := l_ser_txn_temp_id;
3820: ELSE