DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_ATP_PF

Line 635: l_pf_item_id(m) := MSC_ATP_PF.Get_PF_Atp_Item_Id(p_instance_id,

631: p_atp_table.Config_item_line_id(m));
632: END IF;
633: END IF;
634: IF p_atp_table.old_source_organization_id(m) IS NOT NULL THEN
635: l_pf_item_id(m) := MSC_ATP_PF.Get_PF_Atp_Item_Id(p_instance_id,
636: l_plan_id,
637: p_atp_table.inventory_item_id(m),
638: p_atp_table.old_source_organization_id(m));
639: --l_old_org_id(m) := l_atp_table.old_source_organization_id(m);

Line 1837: l_process_item_id := MSC_ATP_PF.Get_PF_Atp_Item_Id(p_instance_id,

1833: END IF;
1834: --- we get PF item id only if its a case of new schedulling
1835: -- if its a reschedulling then we mayalready have got the id just for deleting
1836: ---the previous order. For reschedulling we handel it in the elase part
1837: l_process_item_id := MSC_ATP_PF.Get_PF_Atp_Item_Id(p_instance_id,
1838: l_plan_id,
1839: l_requested_item_id,
1840: l_process_org_id);
1841: ELSE

Line 1916: l_match_item_family_id := MSC_ATP_PF.Get_PF_Atp_Item_Id(

1912: msc_sch_wb.atp_debug('Match Found, find plan for matched item');
1913: END IF;
1914:
1915: /* time_phased_atp changes begin*/
1916: l_match_item_family_id := MSC_ATP_PF.Get_PF_Atp_Item_Id(
1917: p_instance_id,
1918: l_plan_id,
1919: l_atp_table.match_item_id(i),
1920: l_process_org_id

Line 1924: MSC_ATP_PF.Get_PF_Plan_Info(

1920: l_process_org_id
1921: );
1922:
1923: /* Call new procedure Get_PF_Plan_Info*/
1924: MSC_ATP_PF.Get_PF_Plan_Info(
1925: p_instance_id,
1926: l_atp_table.match_item_id(i),
1927: l_match_item_family_id,
1928: l_process_org_id,

Line 1999: MSC_ATP_PF.Get_PF_Plan_Info(

1995: END IF;
1996: IF l_plan_found_for_match = 2 THEN
1997: /* time_phased_atp changes begin
1998: Call new procedure Get_PF_Plan_Info*/
1999: MSC_ATP_PF.Get_PF_Plan_Info(
2000: p_instance_id,
2001: l_requested_item_id,
2002: l_process_item_id,
2003: l_process_org_id,

Line 2200: /*l_process_item_id := MSC_ATP_PF.Get_PF_Atp_Item_Id(p_instance_id,

2196: END IF;
2197:
2198: END IF;
2199: --- bug 2152184: Retrival of PF item needs to be done on ODS data. Moved the call before plan is retrieved
2200: /*l_process_item_id := MSC_ATP_PF.Get_PF_Atp_Item_Id(p_instance_id,
2201: l_plan_id,
2202: l_requested_item_id,
2203: l_process_org_id); */
2204:

Line 2702: nvl(MSC_ATP_PF.Get_Atf_Days(

2698: /* time_phased_atp
2699: Substitution window should not be more than aggregate time fence days*/
2700: IF (l_pf_atp = 'Y' OR l_time_phased_atp = 'Y') THEN
2701: l_item_substitute_rec.substitution_window(l_count) := LEAST(MSC_ATP_PVT.G_ITEM_INFO_REC.substitution_window,
2702: nvl(MSC_ATP_PF.Get_Atf_Days(
2703: p_instance_id,
2704: l_inventory_item_id,
2705: l_atp_rec.organization_id
2706: ),

Line 6227: l_bucketed_demands_rec MSC_ATP_PF.Bucketed_Demands_Rec;

6223: l_mem_stealing_qty NUMBER;
6224: l_pf_stealing_qty NUMBER;
6225: l_sub_qty_before_atf NUMBER;
6226: l_sub_qty_after_atf NUMBER;
6227: l_bucketed_demands_rec MSC_ATP_PF.Bucketed_Demands_Rec;
6228: l_mat_atp_info_rec MSC_ATP_REQ.Atp_Info_Rec;
6229: l_atf_date_qty NUMBER;
6230: l_item_to_use NUMBER;
6231: l_used_available_quantity NUMBER; --bug3409973

Line 7095: MSC_ATP_PF.Set_Alloc_Rule_Variables(

7091: Modularize Item and Org Info */
7092:
7093: /* New allocation logic for time_phased_atp changes begin */
7094: IF l_time_phased_atp = 'Y' THEN
7095: MSC_ATP_PF.Set_Alloc_Rule_Variables(
7096: l_inv_item_id,
7097: PF_ITEM_INFO_REC.dest_inv_item_id,
7098: p_atp_record.organization_id,
7099: p_atp_record.instance_id,

Line 8558: MSC_ATP_PF.Increment_Bucketed_Demands_Qty(

8554: l_atp_insert_rec.quantity_ordered := l_atp_insert_rec.quantity_ordered - greatest(l_sub_requested_date_quantity, 0);
8555: l_atp_insert_rec.requested_date_quantity := l_atp_insert_rec.requested_date_quantity - greatest(l_sub_requested_date_quantity, 0);
8556: -- No need to change ATF date qty, let it be the same. Increment_Bucketed_Demands_Qty will take care of whether to use
8557: -- qty upto ATF completely.
8558: MSC_ATP_PF.Increment_Bucketed_Demands_Qty(
8559: l_atp_insert_rec,
8560: p_plan_id,
8561: l_demand_id,
8562: l_return_status

Line 8811: MSC_ATP_PF.Increment_Bucketed_Demands_Qty(

8807: --using the same insert rec we prepared earlier
8808: l_atp_insert_rec.quantity_ordered := p_atp_record.quantity_ordered;
8809: l_atp_insert_rec.requested_date_quantity := l_atp_insert_rec.requested_date_quantity + nvl(l_stealing_qty, 0);
8810: l_atp_insert_rec.atf_date_quantity := l_atp_insert_rec.atf_date_quantity + nvl(l_mem_stealing_qty, 0);
8811: MSC_ATP_PF.Increment_Bucketed_Demands_Qty(
8812: l_atp_insert_rec,
8813: p_plan_id,
8814: l_demand_id,
8815: l_return_status

Line 8992: MSC_ATP_PF.Increment_Bucketed_Demands_Qty(

8988: l_atp_insert_rec.requested_date_quantity := GREATEST(p_atp_record.requested_date_quantity, 0)
8989: + nvl(l_stealing_requested_date_qty, 0);
8990: l_atp_insert_rec.atf_date_quantity := NVL(p_atp_record.atf_date_quantity, 0);
8991:
8992: MSC_ATP_PF.Increment_Bucketed_Demands_Qty(
8993: l_atp_insert_rec,
8994: p_plan_id,
8995: l_demand_id,
8996: l_return_status

Line 9312: MSC_ATP_PF.Move_PF_Bucketed_Demands(

9308: ELSE
9309: l_bkwd_pass_atf_date_qty := p_atp_record.atf_date_quantity;
9310: END IF;
9311: --bug3397904 end
9312: MSC_ATP_PF.Move_PF_Bucketed_Demands(
9313: p_plan_id,
9314: l_demand_id,
9315: p_atp_record.requested_ship_date,
9316: l_atp_date_this_level,

Line 10685: l_atp_rec.inventory_item_id := MSC_ATP_PF.Get_PF_Atp_Item_Id(l_atp_rec.instance_id,

10681: l_atp_rec.organization_id,
10682: l_atp_rec.demand_class);*/
10683:
10684: --Bug4548245 When we call this procedure from schedule then we check in ODS data
10685: l_atp_rec.inventory_item_id := MSC_ATP_PF.Get_PF_Atp_Item_Id(l_atp_rec.instance_id,
10686: -1,
10687: l_atp_rec.request_item_id,
10688: l_atp_rec.organization_id);
10689: --set the correct family item value

Line 10693: MSC_ATP_PF.Get_PF_Plan_Info(

10689: --set the correct family item value
10690: --Bug4548245 end
10691: /* time_phased_atp changes begin
10692: Call new procedure Get_PF_Plan_Info*/
10693: MSC_ATP_PF.Get_PF_Plan_Info(
10694: l_atp_rec.instance_id,
10695: l_atp_rec.request_item_id,
10696: l_atp_rec.inventory_item_id,
10697: l_atp_rec.organization_id,

Line 12872: MSC_ATP_PF.Get_PF_Plan_Info(

12868: l_get_comp_info_rec.ship_date_this_level := p_atp_record.ship_date;
12869:
12870: --4501944, call get_pf_plan_info in make cases too.
12871: MSC_ATP_PVT.G_PLAN_INFO_REC.plan_id := NULL; --NULL the plan_id in global array so that get_plan_info gets called properly
12872: MSC_ATP_PF.Get_PF_Plan_Info(
12873: p_atp_record.instance_id,
12874: p_atp_record.request_item_id,
12875: p_atp_record.inventory_item_id,
12876: p_atp_record.organization_id,

Line 14911: MSC_ATP_PF.Increment_Bucketed_Demands_Qty(

14907: l_atp_insert_rec.quantity_ordered := p_atp_record.quantity_ordered - l_net_demand;
14908: l_atp_insert_rec.requested_date_quantity := l_atp_insert_rec.quantity_ordered;
14909: l_atp_insert_rec.atf_date_quantity := GREATEST(NVL(p_atp_record.atf_date_quantity,
14910: p_atp_record.requested_date_quantity), 0);
14911: MSC_ATP_PF.Increment_Bucketed_Demands_Qty(
14912: l_atp_insert_rec,
14913: p_plan_id,
14914: l_demand_id,
14915: l_return_status

Line 15033: MSC_ATP_PF.Increment_Bucketed_Demands_Qty(

15029: l_atp_insert_rec.quantity_ordered := p_atp_record.quantity_ordered;
15030: l_atp_insert_rec.requested_date_quantity := p_atp_record.combined_requested_date_qty;
15031: l_atp_insert_rec.atf_date_quantity := GREATEST(NVL(p_atp_record.atf_date_quantity,
15032: p_atp_record.combined_requested_date_qty), 0);
15033: MSC_ATP_PF.Increment_Bucketed_Demands_Qty(
15034: l_atp_insert_rec,
15035: p_plan_id,
15036: l_demand_id,
15037: l_return_status

Line 15120: MSC_ATP_PF.Update_PF_Bucketed_Demands(

15116:
15117: /* time_phased_atp
15118: Update PF Bucketed Demands to qty we could find in backward case*/
15119: IF l_time_phased_atp = 'Y' THEN
15120: MSC_ATP_PF.Update_PF_Bucketed_Demands(
15121: p_plan_id,
15122: l_demand_id,
15123: l_requested_ship_date,
15124: p_atp_record.atf_date,

Line 15285: MSC_ATP_PF.Move_PF_Bucketed_Demands(

15281: END IF;
15282:
15283: /* time_phased_atp*/
15284: IF l_time_phased_atp = 'Y' THEN
15285: MSC_ATP_PF.Move_PF_Bucketed_Demands(
15286: p_plan_id,
15287: l_demand_id,
15288: p_atp_record.requested_ship_date,
15289: p_atp_record.ship_date,