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 672: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

668: p_itf IN DATE,
669: p_cal_code IN VARCHAR2,
670: p_cal_exc_set_id IN NUMBER,
671: p_sys_next_date IN DATE, --bug3099066
672: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
673: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
674: ) IS
675: BEGIN
676: IF PG_DEBUG in ('Y', 'C') THEN

Line 673: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

669: p_cal_code IN VARCHAR2,
670: p_cal_exc_set_id IN NUMBER,
671: p_sys_next_date IN DATE, --bug3099066
672: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
673: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
674: ) IS
675: BEGIN
676: IF PG_DEBUG in ('Y', 'C') THEN
677: msc_sch_wb.atp_debug('item_alloc_avail_unopt: UNconstrained plan: ' || p_plan_id);

Line 1051: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

1047: p_itf IN DATE,
1048: p_cal_code IN VARCHAR2,
1049: p_cal_exc_set_id IN NUMBER,
1050: p_sys_next_date IN DATE, --bug3099066
1051: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1052: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
1053: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1054: ) IS
1055: BEGIN

Line 1052: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,

1048: p_cal_code IN VARCHAR2,
1049: p_cal_exc_set_id IN NUMBER,
1050: p_sys_next_date IN DATE, --bug3099066
1051: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1052: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
1053: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1054: ) IS
1055: BEGIN
1056: IF PG_DEBUG in ('Y', 'C') THEN

Line 1053: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr

1049: p_cal_exc_set_id IN NUMBER,
1050: p_sys_next_date IN DATE, --bug3099066
1051: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1052: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
1053: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1054: ) IS
1055: BEGIN
1056: IF PG_DEBUG in ('Y', 'C') THEN
1057: msc_sch_wb.atp_debug('item_alloc_avail_opt_unalloc: Get unallocated qtys as well. constrained plan: ' || p_plan_id);

Line 1545: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

1541: p_itf IN DATE,
1542: p_cal_code IN VARCHAR2,
1543: p_cal_exc_set_id IN NUMBER,
1544: p_sys_next_date IN DATE, --bug3099066
1545: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1546: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
1547: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1548: ) IS
1549: BEGIN

Line 1546: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,

1542: p_cal_code IN VARCHAR2,
1543: p_cal_exc_set_id IN NUMBER,
1544: p_sys_next_date IN DATE, --bug3099066
1545: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1546: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
1547: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1548: ) IS
1549: BEGIN
1550: IF PG_DEBUG in ('Y', 'C') THEN

Line 1547: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr

1543: p_cal_exc_set_id IN NUMBER,
1544: p_sys_next_date IN DATE, --bug3099066
1545: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1546: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
1547: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1548: ) IS
1549: BEGIN
1550: IF PG_DEBUG in ('Y', 'C') THEN
1551: msc_sch_wb.atp_debug('item_alloc_avail_unopt_unalloc: Get unallocated qtys as well. UNconstrained plan: ' || p_plan_id);

Line 3085: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

3081: p_itf IN DATE,
3082: p_cal_code IN VARCHAR2,
3083: p_cal_exc_set_id IN NUMBER,
3084: p_sys_next_date IN DATE, --bug3099066
3085: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
3086: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
3087: ) IS
3088: BEGIN
3089: IF PG_DEBUG in ('Y', 'C') THEN

Line 3086: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

3082: p_cal_code IN VARCHAR2,
3083: p_cal_exc_set_id IN NUMBER,
3084: p_sys_next_date IN DATE, --bug3099066
3085: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
3086: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
3087: ) IS
3088: BEGIN
3089: IF PG_DEBUG in ('Y', 'C') THEN
3090: msc_sch_wb.atp_debug('item_alloc_avail');

Line 3138: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

3134: p_itf IN DATE,
3135: p_cal_code IN VARCHAR2,
3136: p_cal_exc_set_id IN NUMBER,
3137: p_sys_next_date IN DATE, --bug3099066
3138: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
3139: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
3140: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
3141: ) IS
3142: BEGIN

Line 3139: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,

3135: p_cal_code IN VARCHAR2,
3136: p_cal_exc_set_id IN NUMBER,
3137: p_sys_next_date IN DATE, --bug3099066
3138: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
3139: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
3140: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
3141: ) IS
3142: BEGIN
3143: IF PG_DEBUG in ('Y', 'C') THEN

Line 3140: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr

3136: p_cal_exc_set_id IN NUMBER,
3137: p_sys_next_date IN DATE, --bug3099066
3138: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
3139: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
3140: x_atp_unalloc_qtys OUT NoCopy MRP_ATP_PUB.number_arr
3141: ) IS
3142: BEGIN
3143: IF PG_DEBUG in ('Y', 'C') THEN
3144: msc_sch_wb.atp_debug('item_alloc_avail_unalloc: Get unallocated qtys as well');

Line 3482: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

3478: p_demand_class IN VARCHAR2,
3479: p_request_date IN DATE,
3480: p_insert_flag IN NUMBER,
3481: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
3482: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
3483: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
3484: p_get_mat_in_rec IN MSC_ATP_REQ.get_mat_in_rec,
3485: p_request_item_id IN NUMBER, -- For time_phased_atp
3486: p_atf_date IN DATE) -- For time_phased_atp

Line 3483: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,

3479: p_request_date IN DATE,
3480: p_insert_flag IN NUMBER,
3481: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
3482: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
3483: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
3484: p_get_mat_in_rec IN MSC_ATP_REQ.get_mat_in_rec,
3485: p_request_item_id IN NUMBER, -- For time_phased_atp
3486: p_atf_date IN DATE) -- For time_phased_atp
3487: IS

Line 3509: l_demand_class_tab MRP_ATP_PUB.char80_arr

3505: ii PLS_INTEGER;
3506: jj PLS_INTEGER;
3507: j PLS_INTEGER;
3508: k PLS_INTEGER;
3509: l_demand_class_tab MRP_ATP_PUB.char80_arr
3510: := MRP_ATP_PUB.char80_arr();
3511: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
3512: := MRP_ATP_PUB.number_arr();
3513: l_current_atp MRP_ATP_PVT.ATP_Info;

Line 3510: := MRP_ATP_PUB.char80_arr();

3506: jj PLS_INTEGER;
3507: j PLS_INTEGER;
3508: k PLS_INTEGER;
3509: l_demand_class_tab MRP_ATP_PUB.char80_arr
3510: := MRP_ATP_PUB.char80_arr();
3511: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
3512: := MRP_ATP_PUB.number_arr();
3513: l_current_atp MRP_ATP_PVT.ATP_Info;
3514: l_next_steal_atp MRP_ATP_PVT.ATP_Info;

Line 3511: l_demand_class_priority_tab MRP_ATP_PUB.number_arr

3507: j PLS_INTEGER;
3508: k PLS_INTEGER;
3509: l_demand_class_tab MRP_ATP_PUB.char80_arr
3510: := MRP_ATP_PUB.char80_arr();
3511: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
3512: := MRP_ATP_PUB.number_arr();
3513: l_current_atp MRP_ATP_PVT.ATP_Info;
3514: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
3515: l_current_steal_atp MRP_ATP_PVT.ATP_Info;

Line 3512: := MRP_ATP_PUB.number_arr();

3508: k PLS_INTEGER;
3509: l_demand_class_tab MRP_ATP_PUB.char80_arr
3510: := MRP_ATP_PUB.char80_arr();
3511: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
3512: := MRP_ATP_PUB.number_arr();
3513: l_current_atp MRP_ATP_PVT.ATP_Info;
3514: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
3515: l_current_steal_atp MRP_ATP_PVT.ATP_Info;
3516: l_temp_atp MRP_ATP_PVT.ATP_Info;

Line 3523: l_fw_consume_tab MRP_ATP_PUB.number_arr

3519: -- AATP Forward Consumption rajjain begin
3520: l_unallocated_atp MRP_ATP_PVT.ATP_Info;
3521: l_lowest_priority_demand_class VARCHAR2(80);
3522: l_lowest_priority NUMBER;
3523: l_fw_consume_tab MRP_ATP_PUB.number_arr
3524: := MRP_ATP_PUB.number_arr();
3525: l_allocation_percent_tab MRP_ATP_PUB.number_arr
3526: := MRP_ATP_PUB.number_arr();
3527: l_next_fw_consume PLS_INTEGER := 0;

Line 3524: := MRP_ATP_PUB.number_arr();

3520: l_unallocated_atp MRP_ATP_PVT.ATP_Info;
3521: l_lowest_priority_demand_class VARCHAR2(80);
3522: l_lowest_priority NUMBER;
3523: l_fw_consume_tab MRP_ATP_PUB.number_arr
3524: := MRP_ATP_PUB.number_arr();
3525: l_allocation_percent_tab MRP_ATP_PUB.number_arr
3526: := MRP_ATP_PUB.number_arr();
3527: l_next_fw_consume PLS_INTEGER := 0;
3528: l_lowest_cust_priority NUMBER;

Line 3525: l_allocation_percent_tab MRP_ATP_PUB.number_arr

3521: l_lowest_priority_demand_class VARCHAR2(80);
3522: l_lowest_priority NUMBER;
3523: l_fw_consume_tab MRP_ATP_PUB.number_arr
3524: := MRP_ATP_PUB.number_arr();
3525: l_allocation_percent_tab MRP_ATP_PUB.number_arr
3526: := MRP_ATP_PUB.number_arr();
3527: l_next_fw_consume PLS_INTEGER := 0;
3528: l_lowest_cust_priority NUMBER;
3529: l_lowest_site_priority NUMBER;

Line 3526: := MRP_ATP_PUB.number_arr();

3522: l_lowest_priority NUMBER;
3523: l_fw_consume_tab MRP_ATP_PUB.number_arr
3524: := MRP_ATP_PUB.number_arr();
3525: l_allocation_percent_tab MRP_ATP_PUB.number_arr
3526: := MRP_ATP_PUB.number_arr();
3527: l_next_fw_consume PLS_INTEGER := 0;
3528: l_lowest_cust_priority NUMBER;
3529: l_lowest_site_priority NUMBER;
3530: -- AATP Forward Consumption rajjain end

Line 3533: l_class_tab MRP_ATP_PUB.char30_arr

3529: l_lowest_site_priority NUMBER;
3530: -- AATP Forward Consumption rajjain end
3531:
3532: -- 1680719
3533: l_class_tab MRP_ATP_PUB.char30_arr
3534: := MRP_ATP_PUB.char30_arr();
3535: l_partner_tab MRP_ATP_PUB.number_arr
3536: := MRP_ATP_PUB.number_arr();
3537: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;

Line 3534: := MRP_ATP_PUB.char30_arr();

3530: -- AATP Forward Consumption rajjain end
3531:
3532: -- 1680719
3533: l_class_tab MRP_ATP_PUB.char30_arr
3534: := MRP_ATP_PUB.char30_arr();
3535: l_partner_tab MRP_ATP_PUB.number_arr
3536: := MRP_ATP_PUB.number_arr();
3537: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
3538: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;

Line 3535: l_partner_tab MRP_ATP_PUB.number_arr

3531:
3532: -- 1680719
3533: l_class_tab MRP_ATP_PUB.char30_arr
3534: := MRP_ATP_PUB.char30_arr();
3535: l_partner_tab MRP_ATP_PUB.number_arr
3536: := MRP_ATP_PUB.number_arr();
3537: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
3538: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
3539: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;

Line 3536: := MRP_ATP_PUB.number_arr();

3532: -- 1680719
3533: l_class_tab MRP_ATP_PUB.char30_arr
3534: := MRP_ATP_PUB.char30_arr();
3535: l_partner_tab MRP_ATP_PUB.number_arr
3536: := MRP_ATP_PUB.number_arr();
3537: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
3538: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
3539: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;
3540: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;

Line 3548: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

3544:
3545: -- krajan - 04/01/02 - Variable added for fsteal
3546: l_org_code VARCHAR2(7);
3547:
3548: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
3549: l_sysdate DATE := trunc(sysdate);--4135752
3550:
3551: -- time_phased_atp
3552: l_time_phased_atp VARCHAR2(1) := 'N';

Line 5489: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

5485: p_batchable_flag IN NUMBER,
5486: p_res_conversion_rate IN NUMBER,
5487: p_res_uom_type IN NUMBER,
5488: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
5489: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
5490: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ)
5491: IS
5492: l_infinite_time_fence_date DATE;
5493: l_default_atp_rule_id NUMBER;

Line 5490: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ)

5486: p_res_conversion_rate IN NUMBER,
5487: p_res_uom_type IN NUMBER,
5488: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
5489: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
5490: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ)
5491: IS
5492: l_infinite_time_fence_date DATE;
5493: l_default_atp_rule_id NUMBER;
5494: l_calendar_exception_set_id NUMBER;

Line 5513: l_demand_class_tab MRP_ATP_PUB.char80_arr

5509: ii PLS_INTEGER;
5510: jj PLS_INTEGER;
5511: j PLS_INTEGER;
5512: k PLS_INTEGER;
5513: l_demand_class_tab MRP_ATP_PUB.char80_arr
5514: := MRP_ATP_PUB.char80_arr();
5515: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
5516: := MRP_ATP_PUB.number_arr();
5517: l_current_atp MRP_ATP_PVT.ATP_Info;

Line 5514: := MRP_ATP_PUB.char80_arr();

5510: jj PLS_INTEGER;
5511: j PLS_INTEGER;
5512: k PLS_INTEGER;
5513: l_demand_class_tab MRP_ATP_PUB.char80_arr
5514: := MRP_ATP_PUB.char80_arr();
5515: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
5516: := MRP_ATP_PUB.number_arr();
5517: l_current_atp MRP_ATP_PVT.ATP_Info;
5518: l_next_steal_atp MRP_ATP_PVT.ATP_Info;

Line 5515: l_demand_class_priority_tab MRP_ATP_PUB.number_arr

5511: j PLS_INTEGER;
5512: k PLS_INTEGER;
5513: l_demand_class_tab MRP_ATP_PUB.char80_arr
5514: := MRP_ATP_PUB.char80_arr();
5515: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
5516: := MRP_ATP_PUB.number_arr();
5517: l_current_atp MRP_ATP_PVT.ATP_Info;
5518: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
5519: l_null_steal_atp MRP_ATP_PVT.ATP_Info;

Line 5516: := MRP_ATP_PUB.number_arr();

5512: k PLS_INTEGER;
5513: l_demand_class_tab MRP_ATP_PUB.char80_arr
5514: := MRP_ATP_PUB.char80_arr();
5515: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
5516: := MRP_ATP_PUB.number_arr();
5517: l_current_atp MRP_ATP_PVT.ATP_Info;
5518: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
5519: l_null_steal_atp MRP_ATP_PVT.ATP_Info;
5520: l_current_steal_atp MRP_ATP_PVT.ATP_Info;

Line 5525: l_class_tab MRP_ATP_PUB.char30_arr

5521: l_temp_atp MRP_ATP_PVT.ATP_Info;
5522: l_optimized_plan PLS_INTEGER := 2;
5523:
5524: -- 1680719
5525: l_class_tab MRP_ATP_PUB.char30_arr
5526: := MRP_ATP_PUB.char30_arr();
5527: l_partner_tab MRP_ATP_PUB.number_arr
5528: := MRP_ATP_PUB.number_arr();
5529: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;

Line 5526: := MRP_ATP_PUB.char30_arr();

5522: l_optimized_plan PLS_INTEGER := 2;
5523:
5524: -- 1680719
5525: l_class_tab MRP_ATP_PUB.char30_arr
5526: := MRP_ATP_PUB.char30_arr();
5527: l_partner_tab MRP_ATP_PUB.number_arr
5528: := MRP_ATP_PUB.number_arr();
5529: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
5530: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;

Line 5527: l_partner_tab MRP_ATP_PUB.number_arr

5523:
5524: -- 1680719
5525: l_class_tab MRP_ATP_PUB.char30_arr
5526: := MRP_ATP_PUB.char30_arr();
5527: l_partner_tab MRP_ATP_PUB.number_arr
5528: := MRP_ATP_PUB.number_arr();
5529: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
5530: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
5531: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;

Line 5528: := MRP_ATP_PUB.number_arr();

5524: -- 1680719
5525: l_class_tab MRP_ATP_PUB.char30_arr
5526: := MRP_ATP_PUB.char30_arr();
5527: l_partner_tab MRP_ATP_PUB.number_arr
5528: := MRP_ATP_PUB.number_arr();
5529: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
5530: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
5531: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;
5532: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;

Line 5544: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

5540: l_org_code VARCHAR2(7);
5541: l_plan_start_date date;
5542:
5543: -- dsting for s/d performance enh
5544: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
5545:
5546: -- ship_rec_cal
5547: l_sysdate DATE := trunc(sysdate); --4135752
5548: l_sys_next_date DATE; --bug3333114

Line 8394: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

8390: p_sup_atp_info_rec IN MSC_ATP_REQ.ATP_Info_Rec,
8391: p_identifier IN NUMBER,
8392: p_request_date IN DATE,
8393: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
8394: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
8395: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ
8396: )
8397: IS
8398: l_calendar_code VARCHAR2(14);

Line 8395: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ

8391: p_identifier IN NUMBER,
8392: p_request_date IN DATE,
8393: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
8394: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
8395: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ
8396: )
8397: IS
8398: l_calendar_code VARCHAR2(14);
8399: l_calendar_exception_set_id NUMBER;

Line 8403: l_demand_class_tab MRP_ATP_PUB.char80_arr

8399: l_calendar_exception_set_id NUMBER;
8400: l_level_id NUMBER;
8401: l_priority NUMBER := 1;
8402: l_allocation_percent NUMBER := 100;
8403: l_demand_class_tab MRP_ATP_PUB.char80_arr
8404: := MRP_ATP_PUB.char80_arr();
8405: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
8406: := MRP_ATP_PUB.number_arr();
8407: l_current_atp MRP_ATP_PVT.ATP_Info;

Line 8404: := MRP_ATP_PUB.char80_arr();

8400: l_level_id NUMBER;
8401: l_priority NUMBER := 1;
8402: l_allocation_percent NUMBER := 100;
8403: l_demand_class_tab MRP_ATP_PUB.char80_arr
8404: := MRP_ATP_PUB.char80_arr();
8405: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
8406: := MRP_ATP_PUB.number_arr();
8407: l_current_atp MRP_ATP_PVT.ATP_Info;
8408: l_next_steal_atp MRP_ATP_PVT.ATP_Info;

Line 8405: l_demand_class_priority_tab MRP_ATP_PUB.number_arr

8401: l_priority NUMBER := 1;
8402: l_allocation_percent NUMBER := 100;
8403: l_demand_class_tab MRP_ATP_PUB.char80_arr
8404: := MRP_ATP_PUB.char80_arr();
8405: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
8406: := MRP_ATP_PUB.number_arr();
8407: l_current_atp MRP_ATP_PVT.ATP_Info;
8408: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
8409: l_null_steal_atp MRP_ATP_PVT.ATP_Info;

Line 8406: := MRP_ATP_PUB.number_arr();

8402: l_allocation_percent NUMBER := 100;
8403: l_demand_class_tab MRP_ATP_PUB.char80_arr
8404: := MRP_ATP_PUB.char80_arr();
8405: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
8406: := MRP_ATP_PUB.number_arr();
8407: l_current_atp MRP_ATP_PVT.ATP_Info;
8408: l_next_steal_atp MRP_ATP_PVT.ATP_Info;
8409: l_null_steal_atp MRP_ATP_PVT.ATP_Info;
8410: l_current_steal_atp MRP_ATP_PVT.ATP_Info;

Line 8433: l_class_tab MRP_ATP_PUB.char30_arr

8429: l_postprocessing_lead_time NUMBER;
8430: l_cutoff_date DATE;
8431:
8432: -- 1680719
8433: l_class_tab MRP_ATP_PUB.char30_arr
8434: := MRP_ATP_PUB.char30_arr();
8435: l_partner_tab MRP_ATP_PUB.number_arr
8436: := MRP_ATP_PUB.number_arr();
8437: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;

Line 8434: := MRP_ATP_PUB.char30_arr();

8430: l_cutoff_date DATE;
8431:
8432: -- 1680719
8433: l_class_tab MRP_ATP_PUB.char30_arr
8434: := MRP_ATP_PUB.char30_arr();
8435: l_partner_tab MRP_ATP_PUB.number_arr
8436: := MRP_ATP_PUB.number_arr();
8437: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
8438: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;

Line 8435: l_partner_tab MRP_ATP_PUB.number_arr

8431:
8432: -- 1680719
8433: l_class_tab MRP_ATP_PUB.char30_arr
8434: := MRP_ATP_PUB.char30_arr();
8435: l_partner_tab MRP_ATP_PUB.number_arr
8436: := MRP_ATP_PUB.number_arr();
8437: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
8438: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
8439: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;

Line 8436: := MRP_ATP_PUB.number_arr();

8432: -- 1680719
8433: l_class_tab MRP_ATP_PUB.char30_arr
8434: := MRP_ATP_PUB.char30_arr();
8435: l_partner_tab MRP_ATP_PUB.number_arr
8436: := MRP_ATP_PUB.number_arr();
8437: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
8438: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;
8439: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;
8440: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;

Line 8446: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

8442: l_pos2 NUMBER;
8443: delim constant varchar2(1) := fnd_global.local_chr(13);
8444:
8445: -- dsting for s/d performance enh
8446: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
8447:
8448: --s_cto_rearch
8449: l_check_cap_model_flag number;
8450: --e_cto_arch

Line 10342: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

10338: l_request_date DATE;
10339: l_return_status VARCHAR2(100);
10340: l_msg_data VARCHAR2(200);
10341: l_atp_info MRP_ATP_PVT.ATP_Info;
10342: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
10343: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10344: l_atp_rec MRP_ATP_PUB.atp_rec_typ;
10345: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
10346: l_atp_supply_demand_null MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 10343: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

10339: l_return_status VARCHAR2(100);
10340: l_msg_data VARCHAR2(200);
10341: l_atp_info MRP_ATP_PVT.ATP_Info;
10342: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
10343: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10344: l_atp_rec MRP_ATP_PUB.atp_rec_typ;
10345: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
10346: l_atp_supply_demand_null MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10347: l_batchable_flag NUMBER;

Line 10344: l_atp_rec MRP_ATP_PUB.atp_rec_typ;

10340: l_msg_data VARCHAR2(200);
10341: l_atp_info MRP_ATP_PVT.ATP_Info;
10342: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
10343: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10344: l_atp_rec MRP_ATP_PUB.atp_rec_typ;
10345: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
10346: l_atp_supply_demand_null MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10347: l_batchable_flag NUMBER;
10348: l_max_capacity NUMBER;

Line 10345: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

10341: l_atp_info MRP_ATP_PVT.ATP_Info;
10342: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
10343: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10344: l_atp_rec MRP_ATP_PUB.atp_rec_typ;
10345: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
10346: l_atp_supply_demand_null MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10347: l_batchable_flag NUMBER;
10348: l_max_capacity NUMBER;
10349: l_res_conversion_rate number :=1;

Line 10346: l_atp_supply_demand_null MRP_ATP_PUB.ATP_Supply_Demand_Typ;

10342: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
10343: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10344: l_atp_rec MRP_ATP_PUB.atp_rec_typ;
10345: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
10346: l_atp_supply_demand_null MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10347: l_batchable_flag NUMBER;
10348: l_max_capacity NUMBER;
10349: l_res_conversion_rate number :=1;
10350: l_res_uom varchar2(3);

Line 10913: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

10909: p_plan_id IN NUMBER,
10910: p_net_demand IN OUT NoCopy NUMBER,
10911: x_total_mem_stealing_qty OUT NOCOPY NUMBER, -- For time_phased_atp
10912: x_total_pf_stealing_qty OUT NOCOPY NUMBER, -- For time_phased_atp
10913: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
10914: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
10915: x_return_status OUT NoCopy VARCHAR2,
10916: p_refresh_number IN NUMBER -- For summary enhancement
10917: )

Line 10914: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

10910: p_net_demand IN OUT NoCopy NUMBER,
10911: x_total_mem_stealing_qty OUT NOCOPY NUMBER, -- For time_phased_atp
10912: x_total_pf_stealing_qty OUT NOCOPY NUMBER, -- For time_phased_atp
10913: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
10914: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
10915: x_return_status OUT NoCopy VARCHAR2,
10916: p_refresh_number IN NUMBER -- For summary enhancement
10917: )
10918: IS

Line 10923: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

10919: l_requested_ship_date date;
10920: l_atp_date_this_level date;
10921: l_atp_date_quantity_this_level number;
10922: --l_requested_date_quantity number;
10923: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
10924: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10925: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
10926: l_demand_class_tab MRP_ATP_PUB.char80_arr
10927: := MRP_ATP_PUB.char80_arr();

Line 10924: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

10920: l_atp_date_this_level date;
10921: l_atp_date_quantity_this_level number;
10922: --l_requested_date_quantity number;
10923: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
10924: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10925: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
10926: l_demand_class_tab MRP_ATP_PUB.char80_arr
10927: := MRP_ATP_PUB.char80_arr();
10928: l_demand_class_tab_new MRP_ATP_PUB.char80_arr

Line 10926: l_demand_class_tab MRP_ATP_PUB.char80_arr

10922: --l_requested_date_quantity number;
10923: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
10924: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10925: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
10926: l_demand_class_tab MRP_ATP_PUB.char80_arr
10927: := MRP_ATP_PUB.char80_arr();
10928: l_demand_class_tab_new MRP_ATP_PUB.char80_arr
10929: := MRP_ATP_PUB.char80_arr();--6359986
10930: l_demand_class_priority_tab MRP_ATP_PUB.number_arr

Line 10927: := MRP_ATP_PUB.char80_arr();

10923: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
10924: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10925: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
10926: l_demand_class_tab MRP_ATP_PUB.char80_arr
10927: := MRP_ATP_PUB.char80_arr();
10928: l_demand_class_tab_new MRP_ATP_PUB.char80_arr
10929: := MRP_ATP_PUB.char80_arr();--6359986
10930: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
10931: := MRP_ATP_PUB.number_arr();

Line 10928: l_demand_class_tab_new MRP_ATP_PUB.char80_arr

10924: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
10925: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
10926: l_demand_class_tab MRP_ATP_PUB.char80_arr
10927: := MRP_ATP_PUB.char80_arr();
10928: l_demand_class_tab_new MRP_ATP_PUB.char80_arr
10929: := MRP_ATP_PUB.char80_arr();--6359986
10930: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
10931: := MRP_ATP_PUB.number_arr();
10932: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr

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

10925: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
10926: l_demand_class_tab MRP_ATP_PUB.char80_arr
10927: := MRP_ATP_PUB.char80_arr();
10928: l_demand_class_tab_new MRP_ATP_PUB.char80_arr
10929: := MRP_ATP_PUB.char80_arr();--6359986
10930: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
10931: := MRP_ATP_PUB.number_arr();
10932: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr
10933: := MRP_ATP_PUB.number_arr();

Line 10930: l_demand_class_priority_tab MRP_ATP_PUB.number_arr

10926: l_demand_class_tab MRP_ATP_PUB.char80_arr
10927: := MRP_ATP_PUB.char80_arr();
10928: l_demand_class_tab_new MRP_ATP_PUB.char80_arr
10929: := MRP_ATP_PUB.char80_arr();--6359986
10930: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
10931: := MRP_ATP_PUB.number_arr();
10932: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr
10933: := MRP_ATP_PUB.number_arr();
10934:

Line 10931: := MRP_ATP_PUB.number_arr();

10927: := MRP_ATP_PUB.char80_arr();
10928: l_demand_class_tab_new MRP_ATP_PUB.char80_arr
10929: := MRP_ATP_PUB.char80_arr();--6359986
10930: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
10931: := MRP_ATP_PUB.number_arr();
10932: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr
10933: := MRP_ATP_PUB.number_arr();
10934:
10935: l_allocation_percent_tab MRP_ATP_PUB.number_arr

Line 10932: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr

10928: l_demand_class_tab_new MRP_ATP_PUB.char80_arr
10929: := MRP_ATP_PUB.char80_arr();--6359986
10930: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
10931: := MRP_ATP_PUB.number_arr();
10932: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr
10933: := MRP_ATP_PUB.number_arr();
10934:
10935: l_allocation_percent_tab MRP_ATP_PUB.number_arr
10936: := MRP_ATP_PUB.number_arr();

Line 10933: := MRP_ATP_PUB.number_arr();

10929: := MRP_ATP_PUB.char80_arr();--6359986
10930: l_demand_class_priority_tab MRP_ATP_PUB.number_arr
10931: := MRP_ATP_PUB.number_arr();
10932: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr
10933: := MRP_ATP_PUB.number_arr();
10934:
10935: l_allocation_percent_tab MRP_ATP_PUB.number_arr
10936: := MRP_ATP_PUB.number_arr();
10937: l_inv_item_id NUMBER;

Line 10935: l_allocation_percent_tab MRP_ATP_PUB.number_arr

10931: := MRP_ATP_PUB.number_arr();
10932: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr
10933: := MRP_ATP_PUB.number_arr();
10934:
10935: l_allocation_percent_tab MRP_ATP_PUB.number_arr
10936: := MRP_ATP_PUB.number_arr();
10937: l_inv_item_id NUMBER;
10938: l_demand_class VARCHAR2(30);
10939: l_atp_insert_rec MRP_ATP_PVT.AtpRec;

Line 10936: := MRP_ATP_PUB.number_arr();

10932: l_dmd_class_priority_tab_new MRP_ATP_PUB.number_arr
10933: := MRP_ATP_PUB.number_arr();
10934:
10935: l_allocation_percent_tab MRP_ATP_PUB.number_arr
10936: := MRP_ATP_PUB.number_arr();
10937: l_inv_item_id NUMBER;
10938: l_demand_class VARCHAR2(30);
10939: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
10940: l_inv_item_name varchar2(250); --bug 2246200