APPS.WMS_RETURN_SV dependencies on DUAL

Line 3233: SELECT fnd_global.user_id INTO l_user_id FROM DUAL;

3229: IF (l_debug = 1) THEN
3230: print_debug('Inside CallUnpack for Partial Cancelation ' || p_lpn_id);
3231: END IF;
3232:
3233: SELECT fnd_global.user_id INTO l_user_id FROM DUAL;
3234: OPEN c_unpack_lpn ;
3235: LOOP
3236: FETCH c_unpack_lpn INTO l_unpack_rec ;
3237: EXIT

Line 3264: FROM dual; */

3260: AND ORGANIZATION_ID = l_org_id
3261: AND ROWNUM <2 ; */
3262: /* SELECT mtl_material_transactions_s.NEXTVAL
3263: INTO l_trx_header_id
3264: FROM dual; */
3265:
3266: IF (l_debug = 1) THEN
3267: print_debug('Inside CallUnpack for for lpn_content_id ' || l_unpack_rec.lpn_content_id);
3268: print_debug('Before call to inv_trx_util_pub.insert_line_trx ' || p_lpn_id);

Line 3435: SELECT mtl_material_transactions_s.NEXTVAL INTO l_trx_header_id FROM dual;

3431: print_debug('Enter cancel_return_order_RTV :Sum of RTi qty w.r.t LPN id: ' || l_lpnrti_rec.rti_qty);
3432: END IF;
3433:
3434: --Review Comments
3435: SELECT mtl_material_transactions_s.NEXTVAL INTO l_trx_header_id FROM dual;
3436: --Review Comments
3437:
3438: OPEN get_unpack_lpn(l_lpnrti_rec.transfer_lpn_id,l_lpnrti_rec.rti_qty);
3439: LOOP

Line 4103: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_groupid FROM DUAL;

4099: l_groupid NUMBER;
4100: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4101: BEGIN
4102: transaction_processor_value := GET_TRX_PROC_MODE;
4103: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_groupid FROM DUAL;
4104:
4105: group_id := l_groupid;
4106: EXCEPTION
4107: WHEN OTHERS THEN