APPS.OE_OE_PRICING_AVAILABILITY dependencies on DUAL

Line 295: -- to give out individual messages for each line.

291: ELSIF p_atp_rec.Ship_Set_Name(J) is not null OR
292: p_atp_rec.Arrival_Set_Name(J) is not null THEN
293:
294: -- This line belongs to a scheduling group. We do not want
295: -- to give out individual messages for each line.
296: null;
297:
298: ELSE
299: IF l_debug_level > 0 THEN

Line 492: FROM DUAL;

488: END IF;
489:
490: /*SELECT OE_ORDER_LINES_S.NEXTVAL
491: INTO l_line_id
492: FROM DUAL;
493: */
494:
495: IF l_debug_level > 0 THEN
496: oe_debug_pub.add( 'LINE_ID='||G_ATP_LINE_ID ) ;

Line 531: FROM dual;

527: in_atp_rec.atp_lead_time(I) := 0;
528:
529: SELECT mrp_atp_schedule_temp_s.nextval
530: INTO l_session_id
531: FROM dual;
532:
533: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
534: AND MSC_ATP_GLOBAL.GET_APS_VERSION = 10 THEN
535: in_atp_rec.Included_item_flag(I) := 1; -- This has to be 1 since OM explodes included items before calling ATP.

Line 6452: FROM dual;

6448:
6449:
6450: SELECT mrp_atp_schedule_temp_s.nextval
6451: INTO l_session_id
6452: FROM dual;
6453:
6454: x_return_status := 'S';
6455:
6456: IF in_customer_site_id is not null and in_customer_id is not null then

Line 7097: FROM dual;

7093: BEGIN
7094:
7095: SELECT mrp_atp_schedule_temp_s.nextval
7096: INTO l_session_id
7097: FROM dual;
7098:
7099: SELECT ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
7100: INTO l_mrp_dir
7101: FROM v$parameter