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 484: FROM DUAL;

480: END IF;
481:
482: /*SELECT OE_ORDER_LINES_S.NEXTVAL
483: INTO l_line_id
484: FROM DUAL;
485: */
486:
487: IF l_debug_level > 0 THEN
488: oe_debug_pub.add( 'LINE_ID='||G_ATP_LINE_ID ) ;

Line 535: FROM dual;

531: --end bug14222176
532:
533: SELECT mrp_atp_schedule_temp_s.nextval
534: INTO l_session_id
535: FROM dual;
536:
537: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
538: AND MSC_ATP_GLOBAL.GET_APS_VERSION = 10 THEN
539: in_atp_rec.Included_item_flag(I) := 1; -- This has to be 1 since OM explodes included items before calling ATP.

Line 6477: FROM dual;

6473:
6474:
6475: SELECT mrp_atp_schedule_temp_s.nextval
6476: INTO l_session_id
6477: FROM dual;
6478:
6479: x_return_status := 'S';
6480:
6481: IF in_customer_site_id is not null and in_customer_id is not null then

Line 7122: FROM dual;

7118: BEGIN
7119:
7120: SELECT mrp_atp_schedule_temp_s.nextval
7121: INTO l_session_id
7122: FROM dual;
7123:
7124: SELECT ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
7125: INTO l_mrp_dir
7126: FROM v$parameter