APPS.MSC_ATP_DB_UTILS dependencies on MSC_ATP_PF

Line 502: MSC_ATP_PF.Add_PF_Bucketed_Demands(

498: IF l_time_phased_atp = 'Y' THEN
499: IF PG_DEBUG in ('Y', 'C') THEN
500: msc_sch_wb.atp_debug('Add_Mat_Demand: Time phased ATP = '|| l_time_phased_atp);
501: END IF;
502: MSC_ATP_PF.Add_PF_Bucketed_Demands(
503: p_atp_rec,
504: p_plan_id,
505: x_demand_id,
506: p_atp_rec.refresh_number,

Line 2817: MSC_ATP_PF.Update_PF_Rollup_Supplies(

2813: END IF;
2814:
2815: -- time_phased_atp
2816: IF (p_mem_item_id <> p_pf_item_id) and (l_atf_date is not null) THEN
2817: MSC_ATP_PF.Update_PF_Rollup_Supplies(
2818: p_plan_id,
2819: l_transaction_id,
2820: p_mem_item_id,
2821: p_pf_item_id,

Line 3063: MSC_ATP_PF.Update_PF_Bucketed_Demands(

3059: END IF;
3060:
3061: -- time_phased_atp
3062: IF ((p_mem_item_id <> p_pf_item_id) and (l_atf_date is not null)) THEN
3063: MSC_ATP_PF.Update_PF_Bucketed_Demands(
3064: l_plan_id,
3065: l_demand_id,
3066: l_sd_date,
3067: l_atf_date,

Line 3194: l_bucketed_demands_rec MSC_ATP_PF.Bucketed_Demands_Rec;

3190: l_demand_id number;
3191: l_summary_flag varchar2(1);
3192:
3193: -- time_phased_atp
3194: l_bucketed_demands_rec MSC_ATP_PF.Bucketed_Demands_Rec;
3195: l_return_status varchar2(1);
3196:
3197: BEGIN
3198:

Line 3479: MSC_ATP_PF.Move_PF_Bucketed_Demands(

3475: returning inventory_item_id, organization_id into l_inventory_item_id, l_org_id ;
3476:
3477: -- time_phased_atp changes begin
3478: IF p_atf_date is not null THEN
3479: MSC_ATP_PF.Move_PF_Bucketed_Demands(
3480: p_plan_id,
3481: l_demand_id,
3482: p_old_demand_date,
3483: p_supply_demand_date,

Line 4948: MSC_ATP_PF.Add_PF_Rollup_Supplies(

4944: RETURNING transaction_id INTO p_supply_rec_type.transaction_id;
4945:
4946: -- time_phased_atp
4947: 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
4948: MSC_ATP_PF.Add_PF_Rollup_Supplies(
4949: p_supply_rec_type.plan_id,
4950: p_supply_rec_type.request_item_id,
4951: p_supply_rec_type.inventory_item_id,
4952: p_supply_rec_type.organization_id,

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

5201: -- of reschedulling
5202: ----Subst: Get pf id for old inv item if
5203: IF NVL(p_atp_table.old_inventory_item_id(m), p_atp_table.inventory_item_id(m))
5204: = p_atp_table.inventory_item_id(m) THEN
5205: l_old_pf_item_id := MSC_ATP_PF.Get_PF_Atp_Item_Id(p_instance_id,
5206: l_plan_id,
5207: p_atp_table.inventory_item_id(m),
5208: p_atp_table.old_source_organization_id(m));
5209: ELSE

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

5206: l_plan_id,
5207: p_atp_table.inventory_item_id(m),
5208: p_atp_table.old_source_organization_id(m));
5209: ELSE
5210: l_old_pf_item_id := MSC_ATP_PF.Get_PF_Atp_Item_Id(p_instance_id,
5211: l_plan_id,
5212: p_atp_table.old_inventory_item_id(m),
5213: p_atp_table.old_source_organization_id(m));
5214: END IF;

Line 5223: MSC_ATP_PF.Get_PF_Plan_Info(

5219: IF MSC_ATP_PVT.G_INV_CTP = 4 THEN --3720018, moved from above
5220: /* time_phased_atp changes begin
5221: Call new procedure Get_PF_Plan_Info*/
5222: IF p_atp_table.old_source_organization_id(m) IS NOT NULL THEN
5223: MSC_ATP_PF.Get_PF_Plan_Info(
5224: p_instance_id,
5225: NVL(p_atp_table.old_inventory_item_id(m), p_atp_table.inventory_item_id(m)),
5226: l_old_pf_item_id,
5227: p_atp_table.old_source_organization_id(m),