eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_AATP_PVT dependencies on MRP_ATP_PUB

Line 43: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ

39: END Print_Period_Qty;
40:
41:
42: PROCEDURE move_SD_plsql_into_SD_temp(
43: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ
44: ) IS
45: null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
46: -- ship_rec_cal
47: l_sysdate DATE := trunc(sysdate); --4135752

Line 45: null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

41:
42: PROCEDURE move_SD_plsql_into_SD_temp(
43: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ
44: ) IS
45: null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
46: -- ship_rec_cal
47: l_sysdate DATE := trunc(sysdate); --4135752
48: BEGIN
49: IF PG_DEBUG in ('Y', 'C') THEN

Line 143: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

139: p_itf IN DATE,
140: p_cal_code IN VARCHAR2,
141: p_cal_exc_set_id IN NUMBER,
142: p_sys_next_date IN DATE,
143: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
144: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
145: ) IS
146: BEGIN
147: IF PG_DEBUG in ('Y', 'C') THEN

Line 144: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

140: p_cal_code IN VARCHAR2,
141: p_cal_exc_set_id IN NUMBER,
142: p_sys_next_date IN DATE,
143: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
144: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
145: ) IS
146: BEGIN
147: IF PG_DEBUG in ('Y', 'C') THEN
148: msc_sch_wb.atp_debug('item_alloc_avail_opt: constrained plan: ' || p_plan_id);

Line 735: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

731: p_itf IN DATE,
732: p_cal_code IN VARCHAR2,
733: p_cal_exc_set_id IN NUMBER,
734: p_sys_next_date IN DATE, --bug3099066
735: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
736: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
737: ) IS
738: BEGIN
739: IF PG_DEBUG in ('Y', 'C') THEN

Line 736: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

732: p_cal_code IN VARCHAR2,
733: p_cal_exc_set_id IN NUMBER,
734: p_sys_next_date IN DATE, --bug3099066
735: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
736: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
737: ) IS
738: BEGIN
739: IF PG_DEBUG in ('Y', 'C') THEN
740: msc_sch_wb.atp_debug('item_alloc_avail_unopt: UNconstrained plan: ' || p_plan_id);

Line 1140: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

1136: p_itf IN DATE,
1137: p_cal_code IN VARCHAR2,
1138: p_cal_exc_set_id IN NUMBER,
1139: p_sys_next_date IN DATE, --bug3099066
1140: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1141: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
1142: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1143: ) IS
1144: BEGIN

Line 1141: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,

1137: p_cal_code IN VARCHAR2,
1138: p_cal_exc_set_id IN NUMBER,
1139: p_sys_next_date IN DATE, --bug3099066
1140: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1141: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
1142: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1143: ) IS
1144: BEGIN
1145: IF PG_DEBUG in ('Y', 'C') THEN

Line 1142: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr

1138: p_cal_exc_set_id IN NUMBER,
1139: p_sys_next_date IN DATE, --bug3099066
1140: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1141: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
1142: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1143: ) IS
1144: BEGIN
1145: IF PG_DEBUG in ('Y', 'C') THEN
1146: msc_sch_wb.atp_debug('item_alloc_avail_opt_unalloc: Get unallocated qtys as well. constrained plan: ' || p_plan_id);

Line 1676: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

1672: p_itf IN DATE,
1673: p_cal_code IN VARCHAR2,
1674: p_cal_exc_set_id IN NUMBER,
1675: p_sys_next_date IN DATE, --bug3099066
1676: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1677: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
1678: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1679: ) IS
1680: BEGIN

Line 1677: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,

1673: p_cal_code IN VARCHAR2,
1674: p_cal_exc_set_id IN NUMBER,
1675: p_sys_next_date IN DATE, --bug3099066
1676: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1677: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
1678: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1679: ) IS
1680: BEGIN
1681: IF PG_DEBUG in ('Y', 'C') THEN

Line 1678: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr

1674: p_cal_exc_set_id IN NUMBER,
1675: p_sys_next_date IN DATE, --bug3099066
1676: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1677: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
1678: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1679: ) IS
1680: BEGIN
1681: IF PG_DEBUG in ('Y', 'C') THEN
1682: msc_sch_wb.atp_debug('item_alloc_avail_unopt_unalloc: Get unallocated qtys as well. UNconstrained plan: ' || p_plan_id);

Line 3309: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

3305: p_itf IN DATE,
3306: p_cal_code IN VARCHAR2,
3307: p_cal_exc_set_id IN NUMBER,
3308: p_sys_next_date IN DATE, --bug3099066
3309: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
3310: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
3311: ) IS
3312: BEGIN
3313: IF PG_DEBUG in ('Y', 'C') THEN

Line 3310: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

3306: p_cal_code IN VARCHAR2,
3307: p_cal_exc_set_id IN NUMBER,
3308: p_sys_next_date IN DATE, --bug3099066
3309: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
3310: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
3311: ) IS
3312: BEGIN
3313: IF PG_DEBUG in ('Y', 'C') THEN
3314: msc_sch_wb.atp_debug('item_alloc_avail');

Line 3362: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

3358: p_itf IN DATE,
3359: p_cal_code IN VARCHAR2,
3360: p_cal_exc_set_id IN NUMBER,
3361: p_sys_next_date IN DATE, --bug3099066
3362: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
3363: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
3364: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
3365: ) IS
3366: BEGIN

Line 3363: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,

3359: p_cal_code IN VARCHAR2,
3360: p_cal_exc_set_id IN NUMBER,
3361: p_sys_next_date IN DATE, --bug3099066
3362: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
3363: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
3364: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
3365: ) IS
3366: BEGIN
3367: IF PG_DEBUG in ('Y', 'C') THEN

Line 3364: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr

3360: p_cal_exc_set_id IN NUMBER,
3361: p_sys_next_date IN DATE, --bug3099066
3362: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
3363: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
3364: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
3365: ) IS
3366: BEGIN
3367: IF PG_DEBUG in ('Y', 'C') THEN
3368: msc_sch_wb.atp_debug('item_alloc_avail_unalloc: Get unallocated qtys as well');

Line 3706: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

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
3710: p_atf_date IN DATE) -- For time_phased_atp

Line 3707: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,

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
3710: p_atf_date IN DATE) -- For time_phased_atp
3711: IS

Line 3733: l_demand_class_tab MRP_ATP_PUB.char80_arr

3729: ii PLS_INTEGER;
3730: jj PLS_INTEGER;
3731: j PLS_INTEGER;
3732: k PLS_INTEGER;
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;

Line 3734: := MRP_ATP_PUB.char80_arr();

3730: jj PLS_INTEGER;
3731: j PLS_INTEGER;
3732: k PLS_INTEGER;
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;

Line 3735: l_demand_class_priority_tab MRP_ATP_PUB.number_arr

3731: j PLS_INTEGER;
3732: k PLS_INTEGER;
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;

Line 3736: := MRP_ATP_PUB.number_arr();

3732: k PLS_INTEGER;
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;

Line 3747: l_fw_consume_tab MRP_ATP_PUB.number_arr

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();
3749: l_allocation_percent_tab MRP_ATP_PUB.number_arr
3750: := MRP_ATP_PUB.number_arr();
3751: l_next_fw_consume PLS_INTEGER := 0;

Line 3748: := MRP_ATP_PUB.number_arr();

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();
3749: l_allocation_percent_tab MRP_ATP_PUB.number_arr
3750: := MRP_ATP_PUB.number_arr();
3751: l_next_fw_consume PLS_INTEGER := 0;
3752: l_lowest_cust_priority NUMBER;

Line 3749: l_allocation_percent_tab MRP_ATP_PUB.number_arr

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();
3749: l_allocation_percent_tab MRP_ATP_PUB.number_arr
3750: := MRP_ATP_PUB.number_arr();
3751: l_next_fw_consume PLS_INTEGER := 0;
3752: l_lowest_cust_priority NUMBER;
3753: l_lowest_site_priority NUMBER;

Line 3750: := MRP_ATP_PUB.number_arr();

3746: l_lowest_priority NUMBER;
3747: l_fw_consume_tab MRP_ATP_PUB.number_arr
3748: := MRP_ATP_PUB.number_arr();
3749: l_allocation_percent_tab MRP_ATP_PUB.number_arr
3750: := MRP_ATP_PUB.number_arr();
3751: l_next_fw_consume PLS_INTEGER := 0;
3752: l_lowest_cust_priority NUMBER;
3753: l_lowest_site_priority NUMBER;
3754: -- AATP Forward Consumption rajjain end

Line 3757: l_class_tab MRP_ATP_PUB.char30_arr

3753: l_lowest_site_priority NUMBER;
3754: -- AATP Forward Consumption rajjain end
3755:
3756: -- 1680719
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;

Line 3758: := MRP_ATP_PUB.char30_arr();

3754: -- AATP Forward Consumption rajjain end
3755:
3756: -- 1680719
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;

Line 3759: l_partner_tab MRP_ATP_PUB.number_arr

3755:
3756: -- 1680719
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;

Line 3760: := MRP_ATP_PUB.number_arr();

3756: -- 1680719
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;

Line 3772: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

3768:
3769: -- krajan - 04/01/02 - Variable added for fsteal
3770: l_org_code VARCHAR2(7);
3771:
3772: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
3773: l_sysdate DATE := trunc(sysdate);--4135752
3774:
3775: -- time_phased_atp
3776: l_time_phased_atp VARCHAR2(1) := 'N';

Line 5719: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

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;
5723: l_default_atp_rule_id NUMBER;

Line 5720: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ)

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;
5723: l_default_atp_rule_id NUMBER;
5724: l_calendar_exception_set_id NUMBER;

Line 5743: l_demand_class_tab MRP_ATP_PUB.char80_arr

5739: ii PLS_INTEGER;
5740: jj PLS_INTEGER;
5741: j PLS_INTEGER;
5742: k PLS_INTEGER;
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;

Line 5744: := MRP_ATP_PUB.char80_arr();

5740: jj PLS_INTEGER;
5741: j PLS_INTEGER;
5742: k PLS_INTEGER;
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;

Line 5745: l_demand_class_priority_tab MRP_ATP_PUB.number_arr

5741: j PLS_INTEGER;
5742: k PLS_INTEGER;
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;

Line 5746: := MRP_ATP_PUB.number_arr();

5742: k PLS_INTEGER;
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;

Line 5755: l_class_tab MRP_ATP_PUB.char30_arr

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
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;

Line 5756: := MRP_ATP_PUB.char30_arr();

5752: l_optimized_plan PLS_INTEGER := 2;
5753:
5754: -- 1680719
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;

Line 5757: l_partner_tab MRP_ATP_PUB.number_arr

5753:
5754: -- 1680719
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;

Line 5758: := MRP_ATP_PUB.number_arr();

5754: -- 1680719
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;

Line 5774: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

5770: l_org_code VARCHAR2(7);
5771: l_plan_start_date date;
5772:
5773: -- dsting for s/d performance enh
5774: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
5775:
5776: -- ship_rec_cal
5777: l_sysdate DATE := trunc(sysdate); --4135752
5778: l_sys_next_date DATE; --bug3333114

Line 8624: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

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
8628: l_calendar_code VARCHAR2(14);

Line 8625: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ

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
8628: l_calendar_code VARCHAR2(14);
8629: l_calendar_exception_set_id NUMBER;

Line 8633: l_demand_class_tab MRP_ATP_PUB.char80_arr

8629: l_calendar_exception_set_id NUMBER;
8630: l_level_id NUMBER;
8631: l_priority NUMBER := 1;
8632: l_allocation_percent NUMBER := 100;
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;

Line 8634: := MRP_ATP_PUB.char80_arr();

8630: l_level_id NUMBER;
8631: l_priority NUMBER := 1;
8632: l_allocation_percent NUMBER := 100;
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;

Line 8635: l_demand_class_priority_tab MRP_ATP_PUB.number_arr

8631: l_priority NUMBER := 1;
8632: l_allocation_percent NUMBER := 100;
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;

Line 8636: := MRP_ATP_PUB.number_arr();

8632: l_allocation_percent NUMBER := 100;
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;

Line 8663: l_class_tab MRP_ATP_PUB.char30_arr

8659: l_postprocessing_lead_time NUMBER;
8660: l_cutoff_date DATE;
8661:
8662: -- 1680719
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;

Line 8664: := MRP_ATP_PUB.char30_arr();

8660: l_cutoff_date DATE;
8661:
8662: -- 1680719
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;

Line 8665: l_partner_tab MRP_ATP_PUB.number_arr

8661:
8662: -- 1680719
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;

Line 8666: := MRP_ATP_PUB.number_arr();

8662: -- 1680719
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;

Line 8676: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

8672: l_pos2 NUMBER;
8673: delim constant varchar2(1) := fnd_global.local_chr(13);
8674:
8675: -- dsting for s/d performance enh
8676: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
8677:
8678: --s_cto_rearch
8679: l_check_cap_model_flag number;
8680: --e_cto_arch

Line 10573: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

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;
10577: l_atp_supply_demand_null MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 10574: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

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;
10577: l_atp_supply_demand_null MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10578: l_batchable_flag NUMBER;

Line 10575: l_atp_rec MRP_ATP_PUB.atp_rec_typ;

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;
10577: l_atp_supply_demand_null MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10578: l_batchable_flag NUMBER;
10579: l_max_capacity NUMBER;

Line 10576: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

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;
10577: l_atp_supply_demand_null MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10578: l_batchable_flag NUMBER;
10579: l_max_capacity NUMBER;
10580: l_res_conversion_rate number :=1;

Line 10577: l_atp_supply_demand_null MRP_ATP_PUB.ATP_Supply_Demand_Typ;

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;
10577: l_atp_supply_demand_null MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10578: l_batchable_flag NUMBER;
10579: l_max_capacity NUMBER;
10580: l_res_conversion_rate number :=1;
10581: l_res_uom varchar2(3);

Line 11144: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

11140: p_plan_id IN NUMBER,
11141: p_net_demand IN OUT NoCopy NUMBER,
11142: x_total_mem_stealing_qty OUT NOCOPY NUMBER, -- For time_phased_atp
11143: x_total_pf_stealing_qty OUT NOCOPY NUMBER, -- For time_phased_atp
11144: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
11145: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
11146: x_return_status OUT NoCopy VARCHAR2,
11147: p_refresh_number IN NUMBER -- For summary enhancement
11148: )

Line 11145: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

11141: p_net_demand IN OUT NoCopy NUMBER,
11142: x_total_mem_stealing_qty OUT NOCOPY NUMBER, -- For time_phased_atp
11143: x_total_pf_stealing_qty OUT NOCOPY NUMBER, -- For time_phased_atp
11144: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
11145: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
11146: x_return_status OUT NoCopy VARCHAR2,
11147: p_refresh_number IN NUMBER -- For summary enhancement
11148: )
11149: IS

Line 11154: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

11150: l_requested_ship_date date;
11151: l_atp_date_this_level date;
11152: l_atp_date_quantity_this_level number;
11153: --l_requested_date_quantity number;
11154: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
11155: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
11156: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
11157: l_demand_class_tab MRP_ATP_PUB.char80_arr
11158: := MRP_ATP_PUB.char80_arr();

Line 11155: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

11151: l_atp_date_this_level date;
11152: l_atp_date_quantity_this_level number;
11153: --l_requested_date_quantity number;
11154: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
11155: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
11156: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
11157: l_demand_class_tab MRP_ATP_PUB.char80_arr
11158: := MRP_ATP_PUB.char80_arr();
11159: l_demand_class_tab_new MRP_ATP_PUB.char80_arr

Line 11157: l_demand_class_tab MRP_ATP_PUB.char80_arr

11153: --l_requested_date_quantity number;
11154: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
11155: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
11156: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
11157: l_demand_class_tab MRP_ATP_PUB.char80_arr
11158: := MRP_ATP_PUB.char80_arr();
11159: l_demand_class_tab_new MRP_ATP_PUB.char80_arr
11160: := MRP_ATP_PUB.char80_arr();--6359986
11161: l_demand_class_priority_tab MRP_ATP_PUB.number_arr

Line 11158: := MRP_ATP_PUB.char80_arr();

11154: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
11155: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
11156: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
11157: l_demand_class_tab MRP_ATP_PUB.char80_arr
11158: := MRP_ATP_PUB.char80_arr();
11159: l_demand_class_tab_new MRP_ATP_PUB.char80_arr
11160: := MRP_ATP_PUB.char80_arr();--6359986
11161: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
11162: := MRP_ATP_PUB.number_arr();

Line 11159: l_demand_class_tab_new MRP_ATP_PUB.char80_arr

11155: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
11156: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
11157: l_demand_class_tab MRP_ATP_PUB.char80_arr
11158: := MRP_ATP_PUB.char80_arr();
11159: l_demand_class_tab_new MRP_ATP_PUB.char80_arr
11160: := MRP_ATP_PUB.char80_arr();--6359986
11161: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
11162: := MRP_ATP_PUB.number_arr();
11163: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr

Line 11160: := MRP_ATP_PUB.char80_arr();--6359986

11156: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
11157: l_demand_class_tab MRP_ATP_PUB.char80_arr
11158: := MRP_ATP_PUB.char80_arr();
11159: l_demand_class_tab_new MRP_ATP_PUB.char80_arr
11160: := MRP_ATP_PUB.char80_arr();--6359986
11161: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
11162: := MRP_ATP_PUB.number_arr();
11163: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr
11164: := MRP_ATP_PUB.number_arr();

Line 11161: l_demand_class_priority_tab MRP_ATP_PUB.number_arr

11157: l_demand_class_tab MRP_ATP_PUB.char80_arr
11158: := MRP_ATP_PUB.char80_arr();
11159: l_demand_class_tab_new MRP_ATP_PUB.char80_arr
11160: := MRP_ATP_PUB.char80_arr();--6359986
11161: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
11162: := MRP_ATP_PUB.number_arr();
11163: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr
11164: := MRP_ATP_PUB.number_arr();
11165:

Line 11162: := MRP_ATP_PUB.number_arr();

11158: := MRP_ATP_PUB.char80_arr();
11159: l_demand_class_tab_new MRP_ATP_PUB.char80_arr
11160: := MRP_ATP_PUB.char80_arr();--6359986
11161: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
11162: := MRP_ATP_PUB.number_arr();
11163: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr
11164: := MRP_ATP_PUB.number_arr();
11165:
11166: l_allocation_percent_tab MRP_ATP_PUB.number_arr

Line 11163: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr

11159: l_demand_class_tab_new MRP_ATP_PUB.char80_arr
11160: := MRP_ATP_PUB.char80_arr();--6359986
11161: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
11162: := MRP_ATP_PUB.number_arr();
11163: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr
11164: := MRP_ATP_PUB.number_arr();
11165:
11166: l_allocation_percent_tab MRP_ATP_PUB.number_arr
11167: := MRP_ATP_PUB.number_arr();

Line 11164: := MRP_ATP_PUB.number_arr();

11160: := MRP_ATP_PUB.char80_arr();--6359986
11161: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
11162: := MRP_ATP_PUB.number_arr();
11163: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr
11164: := MRP_ATP_PUB.number_arr();
11165:
11166: l_allocation_percent_tab MRP_ATP_PUB.number_arr
11167: := MRP_ATP_PUB.number_arr();
11168: l_inv_item_id NUMBER;

Line 11166: l_allocation_percent_tab MRP_ATP_PUB.number_arr

11162: := MRP_ATP_PUB.number_arr();
11163: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr
11164: := MRP_ATP_PUB.number_arr();
11165:
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;

Line 11167: := MRP_ATP_PUB.number_arr();

11163: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr
11164: := MRP_ATP_PUB.number_arr();
11165:
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