APPS.MSC_ATP_DB_UTILS dependencies on MSC_ATP_PF

Line 646: MSC_ATP_PF.Add_PF_Bucketed_Demands(

642: IF l_time_phased_atp = 'Y' THEN
643: IF PG_DEBUG in ('Y', 'C') THEN
644: msc_sch_wb.atp_debug('Add_Mat_Demand: Time phased ATP = '|| l_time_phased_atp);
645: END IF;
646: MSC_ATP_PF.Add_PF_Bucketed_Demands(
647: p_atp_rec,
648: p_plan_id,
649: x_demand_id,
650: p_atp_rec.refresh_number,

Line 2979: MSC_ATP_PF.Update_PF_Rollup_Supplies(

2975: END IF;
2976:
2977: -- time_phased_atp
2978: IF (p_mem_item_id <> p_pf_item_id) and (l_atf_date is not null) THEN
2979: MSC_ATP_PF.Update_PF_Rollup_Supplies(
2980: p_plan_id,
2981: l_transaction_id,
2982: p_mem_item_id,
2983: p_pf_item_id,

Line 3225: MSC_ATP_PF.Update_PF_Bucketed_Demands(

3221: END IF;
3222:
3223: -- time_phased_atp
3224: IF ((p_mem_item_id <> p_pf_item_id) and (l_atf_date is not null)) THEN
3225: MSC_ATP_PF.Update_PF_Bucketed_Demands(
3226: l_plan_id,
3227: l_demand_id,
3228: l_sd_date,
3229: l_atf_date,

Line 3356: l_bucketed_demands_rec MSC_ATP_PF.Bucketed_Demands_Rec;

3352: l_demand_id number;
3353: l_summary_flag varchar2(1);
3354:
3355: -- time_phased_atp
3356: l_bucketed_demands_rec MSC_ATP_PF.Bucketed_Demands_Rec;
3357: l_return_status varchar2(1);
3358: l_alloc_atp VARCHAR2(1) := MSC_ATP_PVT.G_ALLOCATED_ATP; --ALLOC ATP CHANGES, 12973673
3359:
3360: BEGIN

Line 3646: MSC_ATP_PF.Move_PF_Bucketed_Demands(

3642: returning inventory_item_id, organization_id into l_inventory_item_id, l_org_id ;
3643:
3644: -- time_phased_atp changes begin
3645: IF p_atf_date is not null THEN
3646: MSC_ATP_PF.Move_PF_Bucketed_Demands(
3647: p_plan_id,
3648: l_demand_id,
3649: p_old_demand_date,
3650: p_supply_demand_date,

Line 5130: MSC_ATP_PF.Add_PF_Rollup_Supplies(

5126: RETURNING transaction_id INTO p_supply_rec_type.transaction_id;
5127:
5128: -- time_phased_atp
5129: IF (p_supply_rec_type.inventory_item_id <> p_supply_rec_type.request_item_id) AND (p_supply_rec_type.atf_date is not null) THEN
5130: MSC_ATP_PF.Add_PF_Rollup_Supplies(
5131: p_supply_rec_type.plan_id,
5132: p_supply_rec_type.request_item_id,
5133: p_supply_rec_type.inventory_item_id,
5134: p_supply_rec_type.organization_id,

Line 5388: l_old_pf_item_id := MSC_ATP_PF.Get_PF_Atp_Item_Id(p_instance_id,

5384: -- of reschedulling
5385: ----Subst: Get pf id for old inv item if
5386: IF NVL(p_atp_table.old_inventory_item_id(m), p_atp_table.inventory_item_id(m))
5387: = p_atp_table.inventory_item_id(m) THEN
5388: l_old_pf_item_id := MSC_ATP_PF.Get_PF_Atp_Item_Id(p_instance_id,
5389: l_plan_id,
5390: p_atp_table.inventory_item_id(m),
5391: p_atp_table.old_source_organization_id(m));
5392: ELSE

Line 5393: l_old_pf_item_id := MSC_ATP_PF.Get_PF_Atp_Item_Id(p_instance_id,

5389: l_plan_id,
5390: p_atp_table.inventory_item_id(m),
5391: p_atp_table.old_source_organization_id(m));
5392: ELSE
5393: l_old_pf_item_id := MSC_ATP_PF.Get_PF_Atp_Item_Id(p_instance_id,
5394: l_plan_id,
5395: p_atp_table.old_inventory_item_id(m),
5396: p_atp_table.old_source_organization_id(m));
5397: END IF;

Line 5406: MSC_ATP_PF.Get_PF_Plan_Info(

5402: IF MSC_ATP_PVT.G_INV_CTP = 4 THEN --3720018, moved from above
5403: /* time_phased_atp changes begin
5404: Call new procedure Get_PF_Plan_Info*/
5405: IF p_atp_table.old_source_organization_id(m) IS NOT NULL THEN
5406: MSC_ATP_PF.Get_PF_Plan_Info(
5407: p_instance_id,
5408: NVL(p_atp_table.old_inventory_item_id(m), p_atp_table.inventory_item_id(m)),
5409: l_old_pf_item_id,
5410: p_atp_table.old_source_organization_id(m),