APPS.OE_OE_AVAILABILITY dependencies on MRP_ATP_SCHEDULE_TEMP

Line 316: SELECT mrp_atp_schedule_temp_s.nextval

312: in_atp_rec.Insert_Flag(I) := 0;
313: END IF;
314: --end bug14222176
315:
316: SELECT mrp_atp_schedule_temp_s.nextval
317: INTO l_session_id
318: FROM dual;
319:
320: -- Call ATP

Line 4782: FROM mrp_atp_schedule_temp

4778: sr_instance_id,
4779: ship_method,
4780: delivery_lead_time,
4781: freight_carrier
4782: FROM mrp_atp_schedule_temp
4783: WHERE session_id = in_session_id
4784: --AND status_flag = -99;
4785: AND status_flag = 22;
4786:

Line 4856: SELECT mrp_atp_schedule_temp_s.nextval

4852:
4853: ELSE -- if get_assignment_set was sucessful
4854:
4855:
4856: SELECT mrp_atp_schedule_temp_s.nextval
4857: INTO l_session_id
4858: FROM dual;
4859:
4860: x_return_status := 'S';

Line 4946: -- insert into mrp_atp_schedule_Temp

4942: ' ship_method='||l_ship_method
4943: );
4944: END IF;
4945:
4946: -- insert into mrp_atp_schedule_Temp
4947: INSERT INTO MRP_ATP_SCHEDULE_TEMP(
4948: sr_instance_id,
4949: session_id,
4950: inventory_item_id,

Line 4947: INSERT INTO MRP_ATP_SCHEDULE_TEMP(

4943: );
4944: END IF;
4945:
4946: -- insert into mrp_atp_schedule_Temp
4947: INSERT INTO MRP_ATP_SCHEDULE_TEMP(
4948: sr_instance_id,
4949: session_id,
4950: inventory_item_id,
4951: organization_id,

Line 5010: -- Read from mrp_atp_schedule_Temp

5006: IF l_debug_level > 0 THEN
5007: oe_debug_pub.add( ' SUCCESS IN CALL TO get_supply_sources_local');
5008: END IF;
5009:
5010: -- Read from mrp_atp_schedule_Temp
5011: -- Insert into l_sources_orgs_table org_id and instance_id
5012: -- delete from mrp_atp_schedule_temp
5013:
5014: FOR l_temp_rec in c_temp_table(l_session_id)

Line 5012: -- delete from mrp_atp_schedule_temp

5008: END IF;
5009:
5010: -- Read from mrp_atp_schedule_Temp
5011: -- Insert into l_sources_orgs_table org_id and instance_id
5012: -- delete from mrp_atp_schedule_temp
5013:
5014: FOR l_temp_rec in c_temp_table(l_session_id)
5015: LOOP
5016: IF l_debug_level > 0 THEN

Line 5064: DELETE mrp_atp_schedule_temp

5060:
5061: END IF; -- if get_supply_sources is not successful
5062:
5063: --deleting from the temp table
5064: DELETE mrp_atp_schedule_temp
5065: WHERE session_id = l_session_id;
5066:
5067: END IF; -- if the fetching of plan was successful
5068:

Line 5487: SELECT mrp_atp_schedule_temp_s.nextval

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