APPS.OE_OE_AVAILABILITY dependencies on DUAL

Line 268: FROM DUAL;

264: END IF;
265:
266: /*SELECT OE_ORDER_LINES_S.NEXTVAL
267: INTO l_line_id
268: FROM DUAL;
269: */
270: IF l_debug_level > 0 THEN
271: oe_debug_pub.add( 'LINE_ID='||G_ATP_LINE_ID ) ;
272: END IF;

Line 318: FROM dual;

314: --end bug14222176
315:
316: SELECT mrp_atp_schedule_temp_s.nextval
317: INTO l_session_id
318: FROM dual;
319:
320: -- Call ATP
321:
322: IF l_debug_level > 0 THEN

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

937: ELSIF p_atp_rec.Ship_Set_Name(J) is not null OR
938: p_atp_rec.Arrival_Set_Name(J) is not null THEN
939:
940: -- This line belongs to a scheduling group. We do not want
941: -- to give out individual messages for each line.
942: null;
943:
944: ELSE
945: IF l_debug_level > 0 THEN

Line 4858: FROM dual;

4854:
4855:
4856: SELECT mrp_atp_schedule_temp_s.nextval
4857: INTO l_session_id
4858: FROM dual;
4859:
4860: x_return_status := 'S';
4861:
4862: IF in_customer_site_id is not null and in_customer_id is not null then

Line 5489: FROM dual;

5485: BEGIN
5486:
5487: SELECT mrp_atp_schedule_temp_s.nextval
5488: INTO l_session_id
5489: FROM dual;
5490:
5491: SELECT ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
5492: INTO l_mrp_dir
5493: FROM v$parameter