DBA Data[Home] [Help]

APPS.MSC_AATP_PVT dependencies on MRP_ATP_PVT

Line 29: p_atp_info IN MRP_ATP_PVT.ATP_Info

25: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
26:
27: PROCEDURE Print_Period_Qty(
28: p_msg IN varchar2,
29: p_atp_info IN MRP_ATP_PVT.ATP_Info
30: ) IS
31: i PLS_INTEGER;
32: BEGIN
33: i := p_atp_info.atp_qty.FIRST;

Line 3473: p_current_atp IN OUT NoCopy MRP_ATP_PVT.ATP_Info,

3469:
3470: ---------------------------------------------------------------------------
3471:
3472: PROCEDURE Atp_Demand_Class_Consume(
3473: p_current_atp IN OUT NoCopy MRP_ATP_PVT.ATP_Info,
3474: p_steal_atp IN OUT NoCopy MRP_ATP_PVT.ATP_Info,
3475: p_atf_date IN DATE := NULL) -- time_phased_atp
3476: IS
3477: i NUMBER; -- index for p_steal_atp

Line 3474: p_steal_atp IN OUT NoCopy MRP_ATP_PVT.ATP_Info,

3470: ---------------------------------------------------------------------------
3471:
3472: PROCEDURE Atp_Demand_Class_Consume(
3473: p_current_atp IN OUT NoCopy MRP_ATP_PVT.ATP_Info,
3474: p_steal_atp IN OUT NoCopy MRP_ATP_PVT.ATP_Info,
3475: p_atf_date IN DATE := NULL) -- time_phased_atp
3476: IS
3477: i NUMBER; -- index for p_steal_atp
3478: j NUMBER; -- index for p_current_atp

Line 3588: p_current_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info,

3584: END Atp_Demand_Class_Consume;
3585:
3586:
3587: PROCEDURE Add_to_Next_Steal_Atp(
3588: p_current_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info,
3589: p_next_steal_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info)
3590: IS
3591: i PLS_INTEGER; -- index for p_current_atp
3592: j PLS_INTEGER; -- index for p_next_steal_atp

Line 3589: p_next_steal_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info)

3585:
3586:
3587: PROCEDURE Add_to_Next_Steal_Atp(
3588: p_current_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info,
3589: p_next_steal_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info)
3590: IS
3591: i PLS_INTEGER; -- index for p_current_atp
3592: j PLS_INTEGER; -- index for p_next_steal_atp
3593: k PLS_INTEGER; -- index for l_next_steal_atp

Line 3595: l_next_steal_atp MRP_ATP_PVT.ATP_Info; -- this will be the output

3591: i PLS_INTEGER; -- index for p_current_atp
3592: j PLS_INTEGER; -- index for p_next_steal_atp
3593: k PLS_INTEGER; -- index for l_next_steal_atp
3594: n PLS_INTEGER; -- starting point of p_next_steal_atp
3595: l_next_steal_atp MRP_ATP_PVT.ATP_Info; -- this will be the output
3596: l_processed BOOLEAN := FALSE ;
3597: BEGIN
3598:
3599: -- this procedure will combine p_current_atp and p_next_steal_atp to form

Line 3705: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,

3701: p_instance_id IN NUMBER,
3702: p_demand_class IN VARCHAR2,
3703: p_request_date IN DATE,
3704: p_insert_flag IN NUMBER,
3705: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
3706: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
3707: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
3708: p_get_mat_in_rec IN MSC_ATP_REQ.get_mat_in_rec,
3709: p_request_item_id IN NUMBER, -- For time_phased_atp

Line 3737: l_current_atp MRP_ATP_PVT.ATP_Info;

3733: l_demand_class_tab MRP_ATP_PUB.char80_arr
3734: := MRP_ATP_PUB.char80_arr();
3735: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
3736: := MRP_ATP_PUB.number_arr();
3737: l_current_atp MRP_ATP_PVT.ATP_Info;
3738: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
3739: l_current_steal_atp MRP_ATP_PVT.ATP_Info;
3740: l_temp_atp MRP_ATP_PVT.ATP_Info;
3741: l_null_steal_atp MRP_ATP_PVT.ATP_Info;

Line 3738: l_next_steal_atp MRP_ATP_PVT.ATP_Info;

3734: := MRP_ATP_PUB.char80_arr();
3735: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
3736: := MRP_ATP_PUB.number_arr();
3737: l_current_atp MRP_ATP_PVT.ATP_Info;
3738: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
3739: l_current_steal_atp MRP_ATP_PVT.ATP_Info;
3740: l_temp_atp MRP_ATP_PVT.ATP_Info;
3741: l_null_steal_atp MRP_ATP_PVT.ATP_Info;
3742:

Line 3739: l_current_steal_atp MRP_ATP_PVT.ATP_Info;

3735: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
3736: := MRP_ATP_PUB.number_arr();
3737: l_current_atp MRP_ATP_PVT.ATP_Info;
3738: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
3739: l_current_steal_atp MRP_ATP_PVT.ATP_Info;
3740: l_temp_atp MRP_ATP_PVT.ATP_Info;
3741: l_null_steal_atp MRP_ATP_PVT.ATP_Info;
3742:
3743: -- AATP Forward Consumption rajjain begin

Line 3740: l_temp_atp MRP_ATP_PVT.ATP_Info;

3736: := MRP_ATP_PUB.number_arr();
3737: l_current_atp MRP_ATP_PVT.ATP_Info;
3738: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
3739: l_current_steal_atp MRP_ATP_PVT.ATP_Info;
3740: l_temp_atp MRP_ATP_PVT.ATP_Info;
3741: l_null_steal_atp MRP_ATP_PVT.ATP_Info;
3742:
3743: -- AATP Forward Consumption rajjain begin
3744: l_unallocated_atp MRP_ATP_PVT.ATP_Info;

Line 3741: l_null_steal_atp MRP_ATP_PVT.ATP_Info;

3737: l_current_atp MRP_ATP_PVT.ATP_Info;
3738: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
3739: l_current_steal_atp MRP_ATP_PVT.ATP_Info;
3740: l_temp_atp MRP_ATP_PVT.ATP_Info;
3741: l_null_steal_atp MRP_ATP_PVT.ATP_Info;
3742:
3743: -- AATP Forward Consumption rajjain begin
3744: l_unallocated_atp MRP_ATP_PVT.ATP_Info;
3745: l_lowest_priority_demand_class VARCHAR2(80);

Line 3744: l_unallocated_atp MRP_ATP_PVT.ATP_Info;

3740: l_temp_atp MRP_ATP_PVT.ATP_Info;
3741: l_null_steal_atp MRP_ATP_PVT.ATP_Info;
3742:
3743: -- AATP Forward Consumption rajjain begin
3744: l_unallocated_atp MRP_ATP_PVT.ATP_Info;
3745: l_lowest_priority_demand_class VARCHAR2(80);
3746: l_lowest_priority NUMBER;
3747: l_fw_consume_tab MRP_ATP_PUB.number_arr
3748: := MRP_ATP_PUB.number_arr();

Line 3761: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;

3757: l_class_tab MRP_ATP_PUB.char30_arr
3758: := MRP_ATP_PUB.char30_arr();
3759: l_partner_tab MRP_ATP_PUB.number_arr
3760: := MRP_ATP_PUB.number_arr();
3761: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
3762: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
3763: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;
3764: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;
3765: l_pos1 NUMBER;

Line 3762: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;

3758: := MRP_ATP_PUB.char30_arr();
3759: l_partner_tab MRP_ATP_PUB.number_arr
3760: := MRP_ATP_PUB.number_arr();
3761: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
3762: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
3763: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;
3764: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;
3765: l_pos1 NUMBER;
3766: l_pos2 NUMBER;

Line 3763: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;

3759: l_partner_tab MRP_ATP_PUB.number_arr
3760: := MRP_ATP_PUB.number_arr();
3761: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
3762: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
3763: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;
3764: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;
3765: l_pos1 NUMBER;
3766: l_pos2 NUMBER;
3767: delim constant varchar2(1) := fnd_global.local_chr(13);

Line 3764: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;

3760: := MRP_ATP_PUB.number_arr();
3761: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
3762: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
3763: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;
3764: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;
3765: l_pos1 NUMBER;
3766: l_pos2 NUMBER;
3767: delim constant varchar2(1) := fnd_global.local_chr(13);
3768:

Line 5718: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,

5714: p_max_capacity IN NUMBER,
5715: p_batchable_flag IN NUMBER,
5716: p_res_conversion_rate IN NUMBER,
5717: p_res_uom_type IN NUMBER,
5718: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
5719: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
5720: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ)
5721: IS
5722: l_infinite_time_fence_date DATE;

Line 5747: l_current_atp MRP_ATP_PVT.ATP_Info;

5743: l_demand_class_tab MRP_ATP_PUB.char80_arr
5744: := MRP_ATP_PUB.char80_arr();
5745: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
5746: := MRP_ATP_PUB.number_arr();
5747: l_current_atp MRP_ATP_PVT.ATP_Info;
5748: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
5749: l_null_steal_atp MRP_ATP_PVT.ATP_Info;
5750: l_current_steal_atp MRP_ATP_PVT.ATP_Info;
5751: l_temp_atp MRP_ATP_PVT.ATP_Info;

Line 5748: l_next_steal_atp MRP_ATP_PVT.ATP_Info;

5744: := MRP_ATP_PUB.char80_arr();
5745: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
5746: := MRP_ATP_PUB.number_arr();
5747: l_current_atp MRP_ATP_PVT.ATP_Info;
5748: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
5749: l_null_steal_atp MRP_ATP_PVT.ATP_Info;
5750: l_current_steal_atp MRP_ATP_PVT.ATP_Info;
5751: l_temp_atp MRP_ATP_PVT.ATP_Info;
5752: l_optimized_plan PLS_INTEGER := 2;

Line 5749: l_null_steal_atp MRP_ATP_PVT.ATP_Info;

5745: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
5746: := MRP_ATP_PUB.number_arr();
5747: l_current_atp MRP_ATP_PVT.ATP_Info;
5748: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
5749: l_null_steal_atp MRP_ATP_PVT.ATP_Info;
5750: l_current_steal_atp MRP_ATP_PVT.ATP_Info;
5751: l_temp_atp MRP_ATP_PVT.ATP_Info;
5752: l_optimized_plan PLS_INTEGER := 2;
5753:

Line 5750: l_current_steal_atp MRP_ATP_PVT.ATP_Info;

5746: := MRP_ATP_PUB.number_arr();
5747: l_current_atp MRP_ATP_PVT.ATP_Info;
5748: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
5749: l_null_steal_atp MRP_ATP_PVT.ATP_Info;
5750: l_current_steal_atp MRP_ATP_PVT.ATP_Info;
5751: l_temp_atp MRP_ATP_PVT.ATP_Info;
5752: l_optimized_plan PLS_INTEGER := 2;
5753:
5754: -- 1680719

Line 5751: l_temp_atp MRP_ATP_PVT.ATP_Info;

5747: l_current_atp MRP_ATP_PVT.ATP_Info;
5748: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
5749: l_null_steal_atp MRP_ATP_PVT.ATP_Info;
5750: l_current_steal_atp MRP_ATP_PVT.ATP_Info;
5751: l_temp_atp MRP_ATP_PVT.ATP_Info;
5752: l_optimized_plan PLS_INTEGER := 2;
5753:
5754: -- 1680719
5755: l_class_tab MRP_ATP_PUB.char30_arr

Line 5759: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;

5755: l_class_tab MRP_ATP_PUB.char30_arr
5756: := MRP_ATP_PUB.char30_arr();
5757: l_partner_tab MRP_ATP_PUB.number_arr
5758: := MRP_ATP_PUB.number_arr();
5759: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
5760: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
5761: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;
5762: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;
5763: l_pos1 NUMBER;

Line 5760: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;

5756: := MRP_ATP_PUB.char30_arr();
5757: l_partner_tab MRP_ATP_PUB.number_arr
5758: := MRP_ATP_PUB.number_arr();
5759: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
5760: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
5761: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;
5762: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;
5763: l_pos1 NUMBER;
5764: l_pos2 NUMBER;

Line 5761: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;

5757: l_partner_tab MRP_ATP_PUB.number_arr
5758: := MRP_ATP_PUB.number_arr();
5759: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
5760: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
5761: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;
5762: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;
5763: l_pos1 NUMBER;
5764: l_pos2 NUMBER;
5765: delim constant varchar2(1) := fnd_global.local_chr(13);

Line 5762: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;

5758: := MRP_ATP_PUB.number_arr();
5759: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
5760: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
5761: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;
5762: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;
5763: l_pos1 NUMBER;
5764: l_pos2 NUMBER;
5765: delim constant varchar2(1) := fnd_global.local_chr(13);
5766: MSO_Batch_Flag VARCHAR2(1);

Line 8623: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,

8619: PROCEDURE Supplier_Alloc_Cum_Atp(
8620: p_sup_atp_info_rec IN MSC_ATP_REQ.ATP_Info_Rec,
8621: p_identifier IN NUMBER,
8622: p_request_date IN DATE,
8623: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
8624: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
8625: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ
8626: )
8627: IS

Line 8637: l_current_atp MRP_ATP_PVT.ATP_Info;

8633: l_demand_class_tab MRP_ATP_PUB.char80_arr
8634: := MRP_ATP_PUB.char80_arr();
8635: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
8636: := MRP_ATP_PUB.number_arr();
8637: l_current_atp MRP_ATP_PVT.ATP_Info;
8638: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
8639: l_null_steal_atp MRP_ATP_PVT.ATP_Info;
8640: l_current_steal_atp MRP_ATP_PVT.ATP_Info;
8641: l_temp_atp MRP_ATP_PVT.ATP_Info;

Line 8638: l_next_steal_atp MRP_ATP_PVT.ATP_Info;

8634: := MRP_ATP_PUB.char80_arr();
8635: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
8636: := MRP_ATP_PUB.number_arr();
8637: l_current_atp MRP_ATP_PVT.ATP_Info;
8638: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
8639: l_null_steal_atp MRP_ATP_PVT.ATP_Info;
8640: l_current_steal_atp MRP_ATP_PVT.ATP_Info;
8641: l_temp_atp MRP_ATP_PVT.ATP_Info;
8642: i PLS_INTEGER;

Line 8639: l_null_steal_atp MRP_ATP_PVT.ATP_Info;

8635: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
8636: := MRP_ATP_PUB.number_arr();
8637: l_current_atp MRP_ATP_PVT.ATP_Info;
8638: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
8639: l_null_steal_atp MRP_ATP_PVT.ATP_Info;
8640: l_current_steal_atp MRP_ATP_PVT.ATP_Info;
8641: l_temp_atp MRP_ATP_PVT.ATP_Info;
8642: i PLS_INTEGER;
8643: l_infinite_time_fence_date DATE;

Line 8640: l_current_steal_atp MRP_ATP_PVT.ATP_Info;

8636: := MRP_ATP_PUB.number_arr();
8637: l_current_atp MRP_ATP_PVT.ATP_Info;
8638: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
8639: l_null_steal_atp MRP_ATP_PVT.ATP_Info;
8640: l_current_steal_atp MRP_ATP_PVT.ATP_Info;
8641: l_temp_atp MRP_ATP_PVT.ATP_Info;
8642: i PLS_INTEGER;
8643: l_infinite_time_fence_date DATE;
8644: mm PLS_INTEGER;

Line 8641: l_temp_atp MRP_ATP_PVT.ATP_Info;

8637: l_current_atp MRP_ATP_PVT.ATP_Info;
8638: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
8639: l_null_steal_atp MRP_ATP_PVT.ATP_Info;
8640: l_current_steal_atp MRP_ATP_PVT.ATP_Info;
8641: l_temp_atp MRP_ATP_PVT.ATP_Info;
8642: i PLS_INTEGER;
8643: l_infinite_time_fence_date DATE;
8644: mm PLS_INTEGER;
8645: ii PLS_INTEGER;

Line 8667: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;

8663: l_class_tab MRP_ATP_PUB.char30_arr
8664: := MRP_ATP_PUB.char30_arr();
8665: l_partner_tab MRP_ATP_PUB.number_arr
8666: := MRP_ATP_PUB.number_arr();
8667: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
8668: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
8669: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;
8670: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;
8671: l_pos1 NUMBER;

Line 8668: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;

8664: := MRP_ATP_PUB.char30_arr();
8665: l_partner_tab MRP_ATP_PUB.number_arr
8666: := MRP_ATP_PUB.number_arr();
8667: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
8668: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
8669: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;
8670: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;
8671: l_pos1 NUMBER;
8672: l_pos2 NUMBER;

Line 8669: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;

8665: l_partner_tab MRP_ATP_PUB.number_arr
8666: := MRP_ATP_PUB.number_arr();
8667: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
8668: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
8669: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;
8670: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;
8671: l_pos1 NUMBER;
8672: l_pos2 NUMBER;
8673: delim constant varchar2(1) := fnd_global.local_chr(13);

Line 8670: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;

8666: := MRP_ATP_PUB.number_arr();
8667: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
8668: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
8669: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;
8670: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;
8671: l_pos1 NUMBER;
8672: l_pos2 NUMBER;
8673: delim constant varchar2(1) := fnd_global.local_chr(13);
8674:

Line 10572: l_atp_info MRP_ATP_PVT.ATP_Info;

10568: mm PLS_INTEGER;
10569: l_request_date DATE;
10570: l_return_status VARCHAR2(100);
10571: l_msg_data VARCHAR2(200);
10572: l_atp_info MRP_ATP_PVT.ATP_Info;
10573: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
10574: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10575: l_atp_rec MRP_ATP_PUB.atp_rec_typ;
10576: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 11135: p_atp_record IN OUT NoCopy MRP_ATP_PVT.AtpRec,

11131: END View_allocation;
11132:
11133:
11134: PROCEDURE Stealing (
11135: p_atp_record IN OUT NoCopy MRP_ATP_PVT.AtpRec,
11136: p_parent_pegging_id IN NUMBER,
11137: p_scenario_id IN NUMBER,
11138: p_level IN NUMBER,
11139: p_search IN NUMBER,

Line 11170: l_atp_insert_rec MRP_ATP_PVT.AtpRec;

11166: l_allocation_percent_tab MRP_ATP_PUB.number_arr
11167: := MRP_ATP_PUB.number_arr();
11168: l_inv_item_id NUMBER;
11169: l_demand_class VARCHAR2(30);
11170: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
11171: l_inv_item_name varchar2(250); --bug 2246200
11172: l_org_code varchar2(7);
11173: l_pegging_id number;
11174: l_atp_pegging_id number;