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 1241: p_atp_rec IN MRP_ATP_PVT.AtpRec,

1237: | o This procedure inserts bucketed demand in msc_alloc_demands table
1238: | with origination type 51 (ATP Bucketed Demand).
1239: +-------------------------------------------------------------------------*/
1240: PROCEDURE Insert_Bucketed_Demand(
1241: p_atp_rec IN MRP_ATP_PVT.AtpRec,
1242: p_plan_id IN NUMBER,
1243: p_bucketed_demand_date IN DATE,
1244: p_bucketed_demand_qty IN NUMBER,
1245: p_display_flag IN NUMBER,

Line 7964: p_unallocated_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info,

7960: | also return unallocated quantities.
7961: +-------------------------------------------------------------------------*/
7962: PROCEDURE Get_Unalloc_Data_From_Sd_Temp(
7963: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
7964: p_unallocated_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info,
7965: x_return_status OUT NOCOPY VARCHAR2
7966: ) IS
7967: i NUMBER;
7968: j NUMBER;