DBA Data[Home] [Help]

APPS.MSC_ATP_PF dependencies on MRP_ATP_PVT

Line 29: p_atp_rec IN MRP_ATP_PVT.AtpRec,

25: x_return_status OUT NOCOPY VARCHAR2
26: );
27:
28: PROCEDURE Insert_Bucketed_Demand(
29: p_atp_rec IN MRP_ATP_PVT.AtpRec,
30: p_plan_id IN NUMBER,
31: p_bucketed_demand_date IN DATE,
32: p_bucketed_demand_qty IN NUMBER,
33: p_display_flag IN NUMBER,

Line 215: p_atp_rec IN MRP_ATP_PVT.AtpRec,

211: | o This procedure calls private procedure Insert_Bucketed_Demand to
212: | add the bucketed demands
213: +-------------------------------------------------------------------------*/
214: PROCEDURE Add_PF_Bucketed_Demands(
215: p_atp_rec IN MRP_ATP_PVT.AtpRec,
216: p_plan_id IN NUMBER,
217: p_parent_demand_id IN NUMBER,
218: p_refresh_number IN NUMBER,
219: x_return_status OUT NOCOPY VARCHAR2

Line 562: p_atp_rec IN OUT NOCOPY MRP_ATP_PVT.AtpRec,

558: | o This procedure calls private procedure Insert_Bucketed_Demand if
559: | there is no existing bucketed demand.
560: +-------------------------------------------------------------------------*/
561: PROCEDURE Increment_Bucketed_Demands_Qty(
562: p_atp_rec IN OUT NOCOPY MRP_ATP_PVT.AtpRec,
563: p_plan_id IN NUMBER,
564: p_parent_demand_id IN NUMBER,
565: -- p_mem_bd_increment_qty IN NUMBER,
566: -- p_pf_bd_increment_qty IN NUMBER,

Line 740: p_atp_rec IN MRP_ATP_PVT.AtpRec := NULL

736: p_atf_date IN DATE,
737: p_atf_date_qty IN NUMBER,
738: x_return_status OUT NOCOPY VARCHAR2,
739: p_bkwd_pass_atf_date_qty IN NUMBER, --bug3397904
740: p_atp_rec IN MRP_ATP_PVT.AtpRec := NULL
741: ) IS
742: -- local variables
743: l_update_mem_bd VARCHAR(1) :='N';
744: l_update_pf_bd VARCHAR(1) :='N';

Line 752: l_atp_rec MRP_ATP_PVT.AtpRec := p_atp_rec;

748: l_pf_bd_qty NUMBER :=0;--bug3397904
749: l_mem_display_flag NUMBER;
750: l_pf_display_flag NUMBER;
751: l_return_status VARCHAR2(1);
752: l_atp_rec MRP_ATP_PVT.AtpRec := p_atp_rec;
753: l_demand_qty NUMBER; --bug3397904
754: l_new_demand_date_qty NUMBER; --bug3397904
755: l_atf_date_qty NUMBER; --bug3397904
756:

Line 1234: p_atp_rec IN MRP_ATP_PVT.AtpRec,

1230: | o This procedure inserts bucketed demand in msc_alloc_demands table
1231: | with origination type 51 (ATP Bucketed Demand).
1232: +-------------------------------------------------------------------------*/
1233: PROCEDURE Insert_Bucketed_Demand(
1234: p_atp_rec IN MRP_ATP_PVT.AtpRec,
1235: p_plan_id IN NUMBER,
1236: p_bucketed_demand_date IN DATE,
1237: p_bucketed_demand_qty IN NUMBER,
1238: p_display_flag IN NUMBER,

Line 7938: p_unallocated_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info,

7934: | also return unallocated quantities.
7935: +-------------------------------------------------------------------------*/
7936: PROCEDURE Get_Unalloc_Data_From_Sd_Temp(
7937: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
7938: p_unallocated_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info,
7939: x_return_status OUT NOCOPY VARCHAR2
7940: ) IS
7941: i NUMBER;
7942: j NUMBER;