APPS.OE_OE_PRICING_AVAILABILITY dependencies on MRP_ATP_SCHEDULE_TEMP

Line 529: SELECT mrp_atp_schedule_temp_s.nextval

525: in_atp_rec.Error_Code(I) := null;
526: in_atp_rec.Message(I) := null;
527: in_atp_rec.atp_lead_time(I) := 0;
528:
529: SELECT mrp_atp_schedule_temp_s.nextval
530: INTO l_session_id
531: FROM dual;
532:
533: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'

Line 6369: FROM mrp_atp_schedule_temp

6365: sr_instance_id,
6366: ship_method,
6367: delivery_lead_time,
6368: freight_carrier
6369: FROM mrp_atp_schedule_temp
6370: WHERE session_id = in_session_id
6371: --AND status_flag = -99;
6372: AND status_flag = 22;
6373:

Line 6450: SELECT mrp_atp_schedule_temp_s.nextval

6446:
6447: ELSE -- if get_assignment_set was sucessful
6448:
6449:
6450: SELECT mrp_atp_schedule_temp_s.nextval
6451: INTO l_session_id
6452: FROM dual;
6453:
6454: x_return_status := 'S';

Line 6540: -- insert into mrp_atp_schedule_Temp

6536: ' ship_method='||l_ship_method
6537: );
6538: END IF;
6539:
6540: -- insert into mrp_atp_schedule_Temp
6541: INSERT INTO MRP_ATP_SCHEDULE_TEMP(
6542: sr_instance_id,
6543: session_id,
6544: inventory_item_id,

Line 6541: INSERT INTO MRP_ATP_SCHEDULE_TEMP(

6537: );
6538: END IF;
6539:
6540: -- insert into mrp_atp_schedule_Temp
6541: INSERT INTO MRP_ATP_SCHEDULE_TEMP(
6542: sr_instance_id,
6543: session_id,
6544: inventory_item_id,
6545: organization_id,

Line 6606: -- Read from mrp_atp_schedule_Temp

6602: IF l_debug_level > 0 THEN
6603: oe_debug_pub.add( ' SUCCESS IN CALL TO get_supply_sources_local');
6604: END IF;
6605:
6606: -- Read from mrp_atp_schedule_Temp
6607: -- Insert into l_sources_orgs_table org_id and instance_id
6608: -- delete from mrp_atp_schedule_temp
6609:
6610: FOR l_temp_rec in c_temp_table(l_session_id)

Line 6608: -- delete from mrp_atp_schedule_temp

6604: END IF;
6605:
6606: -- Read from mrp_atp_schedule_Temp
6607: -- Insert into l_sources_orgs_table org_id and instance_id
6608: -- delete from mrp_atp_schedule_temp
6609:
6610: FOR l_temp_rec in c_temp_table(l_session_id)
6611: LOOP
6612: IF l_debug_level > 0 THEN

Line 6660: DELETE mrp_atp_schedule_temp

6656:
6657: END IF; -- if get_supply_sources is not successful
6658:
6659: --deleting from the temp table
6660: DELETE mrp_atp_schedule_temp
6661: WHERE session_id = l_session_id;
6662:
6663: END IF; -- if the fetching of plan was successful
6664:

Line 7095: SELECT mrp_atp_schedule_temp_s.nextval

7091: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7092: --
7093: BEGIN
7094:
7095: SELECT mrp_atp_schedule_temp_s.nextval
7096: INTO l_session_id
7097: FROM dual;
7098:
7099: SELECT ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))