APPS.OE_OE_AVAILABILITY dependencies on MRP_ATP_SCHEDULE_TEMP

Line 313: SELECT mrp_atp_schedule_temp_s.nextval

309: in_atp_rec.Error_Code(I) := null;
310: in_atp_rec.Message(I) := null;
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

Line 4765: FROM mrp_atp_schedule_temp

4761: sr_instance_id,
4762: ship_method,
4763: delivery_lead_time,
4764: freight_carrier
4765: FROM mrp_atp_schedule_temp
4766: WHERE session_id = in_session_id
4767: --AND status_flag = -99;
4768: AND status_flag = 22;
4769:

Line 4839: SELECT mrp_atp_schedule_temp_s.nextval

4835:
4836: ELSE -- if get_assignment_set was sucessful
4837:
4838:
4839: SELECT mrp_atp_schedule_temp_s.nextval
4840: INTO l_session_id
4841: FROM dual;
4842:
4843: x_return_status := 'S';

Line 4929: -- insert into mrp_atp_schedule_Temp

4925: ' ship_method='||l_ship_method
4926: );
4927: END IF;
4928:
4929: -- insert into mrp_atp_schedule_Temp
4930: INSERT INTO MRP_ATP_SCHEDULE_TEMP(
4931: sr_instance_id,
4932: session_id,
4933: inventory_item_id,

Line 4930: INSERT INTO MRP_ATP_SCHEDULE_TEMP(

4926: );
4927: END IF;
4928:
4929: -- insert into mrp_atp_schedule_Temp
4930: INSERT INTO MRP_ATP_SCHEDULE_TEMP(
4931: sr_instance_id,
4932: session_id,
4933: inventory_item_id,
4934: organization_id,

Line 4993: -- Read from mrp_atp_schedule_Temp

4989: IF l_debug_level > 0 THEN
4990: oe_debug_pub.add( ' SUCCESS IN CALL TO get_supply_sources_local');
4991: END IF;
4992:
4993: -- Read from mrp_atp_schedule_Temp
4994: -- Insert into l_sources_orgs_table org_id and instance_id
4995: -- delete from mrp_atp_schedule_temp
4996:
4997: FOR l_temp_rec in c_temp_table(l_session_id)

Line 4995: -- delete from mrp_atp_schedule_temp

4991: END IF;
4992:
4993: -- Read from mrp_atp_schedule_Temp
4994: -- Insert into l_sources_orgs_table org_id and instance_id
4995: -- delete from mrp_atp_schedule_temp
4996:
4997: FOR l_temp_rec in c_temp_table(l_session_id)
4998: LOOP
4999: IF l_debug_level > 0 THEN

Line 5047: DELETE mrp_atp_schedule_temp

5043:
5044: END IF; -- if get_supply_sources is not successful
5045:
5046: --deleting from the temp table
5047: DELETE mrp_atp_schedule_temp
5048: WHERE session_id = l_session_id;
5049:
5050: END IF; -- if the fetching of plan was successful
5051:

Line 5470: SELECT mrp_atp_schedule_temp_s.nextval

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