APPS.OE_RESERVE_CONC dependencies on DUAL

Line 52: -- dual UoM controlled item, we will convert secondary from primary to handle

48: --
49: BEGIN
50: -- Moving call to validate_quantity in this API so that derived_reserved_quantity
51: -- is checked for item indivisibility for all modes. If primary is truncated for a
52: -- dual UoM controlled item, we will convert secondary from primary to handle
53: -- deviation limits
54: IF l_debug_level > 0 THEN
55: OE_DEBUG_PUB.Add('Entering Validate_Derived_Quantities',1);
56: OE_DEBUG_PUB.Add('Before Calling validate_quantity ' ,1);

Line 511: SELECT oe_reservation_sets_s.nextval INTO g_set_id FROM dual;

507: WHEN OTHERS THEN
508: NULL;
509: END;
510: IF g_set_id IS NULL THEN
511: SELECT oe_reservation_sets_s.nextval INTO g_set_id FROM dual;
512: END IF;
513:
514: IF p_rsv_request_id IS NOT NULL THEN
515: l_process_flag := 'Y';

Line 2424: FROM DUAL;

2420: l_schedule_arrival_date_low,
2421: l_schedule_arrival_date_high,
2422: l_ordered_date_low,
2423: l_ordered_date_high
2424: FROM DUAL;
2425:
2426: -- Moac Start
2427: IF MO_GLOBAL.get_access_mode = 'S' THEN
2428: l_single_org := TRUE;