APPS.OE_OE_AVAILABILITY dependencies on DUAL

Line 277: FROM DUAL;

273: END IF;
274:
275: /*SELECT OE_ORDER_LINES_S.NEXTVAL
276: INTO l_line_id
277: FROM DUAL;
278: */
279: IF l_debug_level > 0 THEN
280: oe_debug_pub.add( 'LINE_ID='||G_ATP_LINE_ID ) ;
281: END IF;

Line 315: FROM dual;

311: in_atp_rec.atp_lead_time(I) := 0;
312:
313: SELECT mrp_atp_schedule_temp_s.nextval
314: INTO l_session_id
315: FROM dual;
316:
317: -- Call ATP
318:
319: IF l_debug_level > 0 THEN

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

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

Line 4841: FROM dual;

4837:
4838:
4839: SELECT mrp_atp_schedule_temp_s.nextval
4840: INTO l_session_id
4841: FROM dual;
4842:
4843: x_return_status := 'S';
4844:
4845: IF in_customer_site_id is not null and in_customer_id is not null then

Line 5472: FROM dual;

5468: BEGIN
5469:
5470: SELECT mrp_atp_schedule_temp_s.nextval
5471: INTO l_session_id
5472: FROM dual;
5473:
5474: SELECT ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
5475: INTO l_mrp_dir
5476: FROM v$parameter