APPS.OE_OE_PRICING_AVAILABILITY dependencies on MRP_ATP_SCHEDULE_TEMP

Line 533: SELECT mrp_atp_schedule_temp_s.nextval

529: in_atp_rec.Insert_Flag(I) := 0;
530: END IF;
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'

Line 6394: FROM mrp_atp_schedule_temp

6390: sr_instance_id,
6391: ship_method,
6392: delivery_lead_time,
6393: freight_carrier
6394: FROM mrp_atp_schedule_temp
6395: WHERE session_id = in_session_id
6396: --AND status_flag = -99;
6397: AND status_flag = 22;
6398:

Line 6475: SELECT mrp_atp_schedule_temp_s.nextval

6471:
6472: ELSE -- if get_assignment_set was sucessful
6473:
6474:
6475: SELECT mrp_atp_schedule_temp_s.nextval
6476: INTO l_session_id
6477: FROM dual;
6478:
6479: x_return_status := 'S';

Line 6565: -- insert into mrp_atp_schedule_Temp

6561: ' ship_method='||l_ship_method
6562: );
6563: END IF;
6564:
6565: -- insert into mrp_atp_schedule_Temp
6566: INSERT INTO MRP_ATP_SCHEDULE_TEMP(
6567: sr_instance_id,
6568: session_id,
6569: inventory_item_id,

Line 6566: INSERT INTO MRP_ATP_SCHEDULE_TEMP(

6562: );
6563: END IF;
6564:
6565: -- insert into mrp_atp_schedule_Temp
6566: INSERT INTO MRP_ATP_SCHEDULE_TEMP(
6567: sr_instance_id,
6568: session_id,
6569: inventory_item_id,
6570: organization_id,

Line 6631: -- Read from mrp_atp_schedule_Temp

6627: IF l_debug_level > 0 THEN
6628: oe_debug_pub.add( ' SUCCESS IN CALL TO get_supply_sources_local');
6629: END IF;
6630:
6631: -- Read from mrp_atp_schedule_Temp
6632: -- Insert into l_sources_orgs_table org_id and instance_id
6633: -- delete from mrp_atp_schedule_temp
6634:
6635: FOR l_temp_rec in c_temp_table(l_session_id)

Line 6633: -- delete from mrp_atp_schedule_temp

6629: END IF;
6630:
6631: -- Read from mrp_atp_schedule_Temp
6632: -- Insert into l_sources_orgs_table org_id and instance_id
6633: -- delete from mrp_atp_schedule_temp
6634:
6635: FOR l_temp_rec in c_temp_table(l_session_id)
6636: LOOP
6637: IF l_debug_level > 0 THEN

Line 6685: DELETE mrp_atp_schedule_temp

6681:
6682: END IF; -- if get_supply_sources is not successful
6683:
6684: --deleting from the temp table
6685: DELETE mrp_atp_schedule_temp
6686: WHERE session_id = l_session_id;
6687:
6688: END IF; -- if the fetching of plan was successful
6689:

Line 7120: SELECT mrp_atp_schedule_temp_s.nextval

7116: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7117: --
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)))