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_ATP_REQ dependencies on MRP_ATP_PUB

Line 14: p_atp_dates IN MRP_ATP_PUB.date_arr,

10: -- adding the itf will be done elsewhere. Also, making sure all 3
11: -- output tables are populated is also done elsewhere.
12:
13: PROCEDURE Print_Dates_Qtys(
14: p_atp_dates IN MRP_ATP_PUB.date_arr,
15: p_atp_qtys IN MRP_ATP_PUB.number_arr
16: ) IS
17: BEGIN
18: IF PG_DEBUG in ('Y', 'C') THEN

Line 15: p_atp_qtys IN MRP_ATP_PUB.number_arr

11: -- output tables are populated is also done elsewhere.
12:
13: PROCEDURE Print_Dates_Qtys(
14: p_atp_dates IN MRP_ATP_PUB.date_arr,
15: p_atp_qtys IN MRP_ATP_PUB.number_arr
16: ) IS
17: BEGIN
18: IF PG_DEBUG in ('Y', 'C') THEN
19: for i in 1..p_atp_dates.count loop

Line 131: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

127: p_plan_start_date IN DATE,
128: p_dept_id IN NUMBER,
129: p_res_id IN NUMBER,
130: p_itf IN DATE,
131: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
132: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
133: ) IS
134: l_null_num NUMBER;
135: l_null_char VARCHAR2(1);

Line 132: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

128: p_dept_id IN NUMBER,
129: p_res_id IN NUMBER,
130: p_itf IN DATE,
131: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
132: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
133: ) IS
134: l_null_num NUMBER;
135: l_null_char VARCHAR2(1);
136: l_sysdate DATE := trunc(sysdate); --4135752

Line 241: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

237: p_res_id IN NUMBER,
238: p_itf IN DATE,
239: p_cal_code IN VARCHAR2,
240: p_cal_exc_set_id IN NUMBER,
241: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
242: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
243: ) IS
244: l_null_num NUMBER;
245: l_null_char VARCHAR2(1);

Line 242: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

238: p_itf IN DATE,
239: p_cal_code IN VARCHAR2,
240: p_cal_exc_set_id IN NUMBER,
241: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
242: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
243: ) IS
244: l_null_num NUMBER;
245: l_null_char VARCHAR2(1);
246: l_sysdate DATE := trunc(sysdate); --4135752

Line 350: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

346: p_itf IN DATE,
347: p_uom_type IN NUMBER,
348: p_max_capacity IN NUMBER,
349: p_res_conv_rate IN NUMBER,
350: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
351: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
352: ) IS
353: l_null_num NUMBER;
354: l_null_char VARCHAR2(1);

Line 351: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

347: p_uom_type IN NUMBER,
348: p_max_capacity IN NUMBER,
349: p_res_conv_rate IN NUMBER,
350: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
351: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
352: ) IS
353: l_null_num NUMBER;
354: l_null_char VARCHAR2(1);
355: l_sysdate DATE := trunc(sysdate);--4135752

Line 480: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

476: p_max_capacity IN NUMBER,
477: p_res_conv_rate IN NUMBER,
478: p_cal_code IN VARCHAR2,
479: p_cal_exc_set_id IN NUMBER,
480: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
481: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
482: ) IS
483: l_null_num NUMBER;
484: l_null_char VARCHAR2(1);

Line 481: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

477: p_res_conv_rate IN NUMBER,
478: p_cal_code IN VARCHAR2,
479: p_cal_exc_set_id IN NUMBER,
480: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
481: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
482: ) IS
483: l_null_num NUMBER;
484: l_null_char VARCHAR2(1);
485: l_sysdate DATE := trunc(sysdate);--4135752

Line 1465: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

1461: p_dept_id IN NUMBER,
1462: p_res_id IN NUMBER,
1463: p_itf IN DATE,
1464: p_refresh_number IN NUMBER, -- For summary enhancement
1465: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1466: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1467: ) IS
1468: BEGIN
1469: IF PG_DEBUG in ('Y', 'C') THEN

Line 1466: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

1462: p_res_id IN NUMBER,
1463: p_itf IN DATE,
1464: p_refresh_number IN NUMBER, -- For summary enhancement
1465: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1466: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1467: ) IS
1468: BEGIN
1469: IF PG_DEBUG in ('Y', 'C') THEN
1470: msc_sch_wb.atp_debug('get_res_avail_summ');

Line 1555: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

1551: p_max_capacity IN NUMBER,
1552: p_res_conv_rate IN NUMBER,
1553: p_cal_code IN VARCHAR2,
1554: p_cal_exc_set_id IN NUMBER,
1555: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1556: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1557: ) IS
1558: BEGIN
1559: IF PG_DEBUG in ('Y', 'C') THEN

Line 1556: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

1552: p_res_conv_rate IN NUMBER,
1553: p_cal_code IN VARCHAR2,
1554: p_cal_exc_set_id IN NUMBER,
1555: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1556: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1557: ) IS
1558: BEGIN
1559: IF PG_DEBUG in ('Y', 'C') THEN
1560: msc_sch_wb.atp_debug('get_res_avail');

Line 1652: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ

1648: p_scenario_id IN NUMBER,
1649: p_item_id IN NUMBER,
1650: p_cal_code IN VARCHAR2,
1651: p_cal_exc_set_id IN NUMBER,
1652: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ
1653: ) IS
1654: BEGIN
1655:
1656: MSC_ATP_DB_UTILS.Clear_SD_Details_temp();

Line 1759: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

1755: p_cal_code IN VARCHAR2,
1756: p_cal_exc_set_id IN NUMBER,
1757: p_summary_flag IN VARCHAR2, -- For summary enhancement
1758: p_refresh_number IN NUMBER, -- For summary enhancement
1759: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1760: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
1761: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ
1762: ) IS
1763: BEGIN

Line 1760: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,

1756: p_cal_exc_set_id IN NUMBER,
1757: p_summary_flag IN VARCHAR2, -- For summary enhancement
1758: p_refresh_number IN NUMBER, -- For summary enhancement
1759: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1760: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
1761: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ
1762: ) IS
1763: BEGIN
1764: IF nvl(p_insert_flag,0) = 1 THEN

Line 1761: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ

1757: p_summary_flag IN VARCHAR2, -- For summary enhancement
1758: p_refresh_number IN NUMBER, -- For summary enhancement
1759: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1760: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr,
1761: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ
1762: ) IS
1763: BEGIN
1764: IF nvl(p_insert_flag,0) = 1 THEN
1765: get_res_avail_dtls(

Line 1867: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

1863: p_demand_class IN VARCHAR2,
1864: p_default_atp_rule_id IN NUMBER,
1865: p_default_dmd_class IN VARCHAR2,
1866: p_itf IN DATE,
1867: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1868: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1869: ) IS
1870: BEGIN
1871: IF PG_DEBUG in ('Y', 'C') THEN

Line 1868: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

1864: p_default_atp_rule_id IN NUMBER,
1865: p_default_dmd_class IN VARCHAR2,
1866: p_itf IN DATE,
1867: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1868: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1869: ) IS
1870: BEGIN
1871: IF PG_DEBUG in ('Y', 'C') THEN
1872: msc_sch_wb.atp_debug('Begin get_mat_avail_ods_summ');

Line 1938: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

1934: p_instance_id IN NUMBER,
1935: p_plan_id IN NUMBER,
1936: p_itf IN DATE,
1937: p_refresh_number IN NUMBER, -- For summary enhancement
1938: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1939: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1940: ) IS
1941: BEGIN
1942: IF PG_DEBUG in ('Y', 'C') THEN

Line 1939: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

1935: p_plan_id IN NUMBER,
1936: p_itf IN DATE,
1937: p_refresh_number IN NUMBER, -- For summary enhancement
1938: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
1939: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
1940: ) IS
1941: BEGIN
1942: IF PG_DEBUG in ('Y', 'C') THEN
1943: msc_sch_wb.atp_debug('Begin get_mat_avail_summ');

Line 2031: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

2027: p_demand_class IN VARCHAR2,
2028: p_default_atp_rule_id IN NUMBER,
2029: p_default_dmd_class IN VARCHAR2,
2030: p_itf IN DATE,
2031: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
2032: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
2033: ) IS
2034: BEGIN
2035: IF PG_DEBUG in ('Y', 'C') THEN

Line 2032: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

2028: p_default_atp_rule_id IN NUMBER,
2029: p_default_dmd_class IN VARCHAR2,
2030: p_itf IN DATE,
2031: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
2032: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
2033: ) IS
2034: BEGIN
2035: IF PG_DEBUG in ('Y', 'C') THEN
2036: msc_sch_wb.atp_debug('Begin get_mat_avail_ods');

Line 2262: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

2258: p_org_id IN NUMBER,
2259: p_instance_id IN NUMBER,
2260: p_plan_id IN NUMBER,
2261: p_itf IN DATE,
2262: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
2263: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
2264: ) IS
2265: BEGIN
2266: IF PG_DEBUG in ('Y', 'C') THEN

Line 2263: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

2259: p_instance_id IN NUMBER,
2260: p_plan_id IN NUMBER,
2261: p_itf IN DATE,
2262: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
2263: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
2264: ) IS
2265: BEGIN
2266: IF PG_DEBUG in ('Y', 'C') THEN
2267: msc_sch_wb.atp_debug('Begin get_mat_avail_opt');

Line 2354: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

2350: p_plan_id IN NUMBER,
2351: p_cal_code IN VARCHAR2,
2352: p_cal_exc_set_id IN NUMBER,
2353: p_itf IN DATE,
2354: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
2355: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
2356: ) IS
2357: BEGIN
2358: IF PG_DEBUG in ('Y', 'C') THEN

Line 2355: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr

2351: p_cal_code IN VARCHAR2,
2352: p_cal_exc_set_id IN NUMBER,
2353: p_itf IN DATE,
2354: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,
2355: x_atp_qtys OUT NoCopy MRP_ATP_PUB.number_arr
2356: ) IS
2357: BEGIN
2358: IF PG_DEBUG in ('Y', 'C') THEN
2359: msc_sch_wb.atp_debug('Begin get_mat_avail_unopt');

Line 3309: x_atp_dates OUT NoCopy MRP_ATP_PUB.date_arr,

3305: p_default_atp_rule_id IN NUMBER,
3306: p_default_dmd_class IN VARCHAR2,
3307: p_itf IN DATE,
3308: p_refresh_number IN NUMBER, -- For summary enhancement
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_default_dmd_class IN VARCHAR2,
3307: p_itf IN DATE,
3308: p_refresh_number IN NUMBER, -- For summary enhancement
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('Begin get_mat_avail');

Line 3526: p_atp_period_tab IN MRP_ATP_PUB.Date_arr,

3522: | o Moved ATP dates and qty calculation code from Get_Material_Atp_Info
3523: | procedure to this procedure
3524: +-------------------------------------------------------------------------*/
3525: PROCEDURE Calculate_Atp_Dates_Qtys (
3526: p_atp_period_tab IN MRP_ATP_PUB.Date_arr,
3527: p_atp_qty_tab IN MRP_ATP_PUB.Number_arr,
3528: p_requested_date IN DATE,
3529: p_atf_date IN DATE,
3530: p_quantity_ordered IN NUMBER,

Line 3527: p_atp_qty_tab IN MRP_ATP_PUB.Number_arr,

3523: | procedure to this procedure
3524: +-------------------------------------------------------------------------*/
3525: PROCEDURE Calculate_Atp_Dates_Qtys (
3526: p_atp_period_tab IN MRP_ATP_PUB.Date_arr,
3527: p_atp_qty_tab IN MRP_ATP_PUB.Number_arr,
3528: p_requested_date IN DATE,
3529: p_atf_date IN DATE,
3530: p_quantity_ordered IN NUMBER,
3531: p_sys_next_date IN DATE,

Line 3860: l_supply_demand IN OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,

3856: p_inventory_item_id IN NUMBER,
3857: p_organization_id IN NUMBER,
3858: p_quantity IN NUMBER,
3859: l_net_demand IN OUT NoCopy NUMBER,
3860: l_supply_demand IN OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
3861: l_atp_period IN OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
3862: l_substitutes_rec OUT NoCopy MSC_ATP_REQ.get_subs_out_rec,--5216528
3863: l_return_status OUT NoCopy varchar2,
3864: p_refresh_number IN NUMBER) -- For summary enhancement

Line 3861: l_atp_period IN OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

3857: p_organization_id IN NUMBER,
3858: p_quantity IN NUMBER,
3859: l_net_demand IN OUT NoCopy NUMBER,
3860: l_supply_demand IN OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
3861: l_atp_period IN OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
3862: l_substitutes_rec OUT NoCopy MSC_ATP_REQ.get_subs_out_rec,--5216528
3863: l_return_status OUT NoCopy varchar2,
3864: p_refresh_number IN NUMBER) -- For summary enhancement
3865: IS

Line 4004: g_atp_period MRP_ATP_PUB.ATP_Period_Typ;

4000: l_usage number;
4001: l_demand_id number;
4002: g_atp_record MRP_ATP_PVT.AtpRec;
4003: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
4004: g_atp_period MRP_ATP_PUB.ATP_Period_Typ;
4005: g_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
4006: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
4007: l_pegging_id number;
4008: l_atp_pegging_id number;

Line 4005: g_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

4001: l_demand_id number;
4002: g_atp_record MRP_ATP_PVT.AtpRec;
4003: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
4004: g_atp_period MRP_ATP_PUB.ATP_Period_Typ;
4005: g_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
4006: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
4007: l_pegging_id number;
4008: l_atp_pegging_id number;
4009: l_atp_flag varchar2(1) := 'Y';

Line 4698: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

4694: /* time_phased_atp
4695: Grouped various input parameters to this procedure in a new record Atp_Info_Rec*/
4696: PROCEDURE Get_Material_Atp_Info (
4697: p_mat_atp_info_rec IN OUT NOCOPY Atp_Info_Rec,
4698: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4699: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
4700: x_return_status OUT NoCopy VARCHAR2
4701: )
4702: IS

Line 4699: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

4695: Grouped various input parameters to this procedure in a new record Atp_Info_Rec*/
4696: PROCEDURE Get_Material_Atp_Info (
4697: p_mat_atp_info_rec IN OUT NOCOPY Atp_Info_Rec,
4698: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4699: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
4700: x_return_status OUT NoCopy VARCHAR2
4701: )
4702: IS
4703: l_infinite_time_fence_date DATE;

Line 4708: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();

4704: l_sysdate_seq_num NUMBER;
4705: l_requested_date DATE;
4706: --l_atp_mat_atp_info_rec.requested_date DATE; -- time_phased_atp
4707: i PLS_INTEGER := 1;
4708: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
4709: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
4710: --l_next_period DATE; -- time_phased_atp
4711: l_return_status VARCHAR2(1);
4712: g_atp_record MRP_ATP_PVT.AtpRec;

Line 4709: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

4705: l_requested_date DATE;
4706: --l_atp_mat_atp_info_rec.requested_date DATE; -- time_phased_atp
4707: i PLS_INTEGER := 1;
4708: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
4709: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
4710: --l_next_period DATE; -- time_phased_atp
4711: l_return_status VARCHAR2(1);
4712: g_atp_record MRP_ATP_PVT.AtpRec;
4713: l_net_demand number;

Line 5334: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

5330: p_inventory_item_id IN NUMBER,
5331: p_organization_id IN NUMBER,
5332: p_demand_class IN VARCHAR2,
5333: p_insert_flag IN NUMBER,
5334: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
5335: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
5336: x_return_status OUT NoCopy VARCHAR2,
5337: p_get_mat_in_rec In MSC_ATP_REQ.get_mat_in_rec,
5338: p_atf_date IN DATE -- For time_phased_atp

Line 5335: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

5331: p_organization_id IN NUMBER,
5332: p_demand_class IN VARCHAR2,
5333: p_insert_flag IN NUMBER,
5334: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
5335: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
5336: x_return_status OUT NoCopy VARCHAR2,
5337: p_get_mat_in_rec In MSC_ATP_REQ.get_mat_in_rec,
5338: p_atf_date IN DATE -- For time_phased_atp
5339: )

Line 5604: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

5600: p_parent_ship_date IN DATE, -- Bug 2814872 Cut-off Date for Resource Check
5601: p_line_identifier IN NUMBER, -- CTO ODR Identifies the line being processed.
5602: x_avail_assembly_qty OUT NoCopy NUMBER,
5603: x_atp_date OUT NoCopy DATE,
5604: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
5605: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
5606: x_return_status OUT NoCopy VARCHAR2
5607: )
5608: IS

Line 5605: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

5601: p_line_identifier IN NUMBER, -- CTO ODR Identifies the line being processed.
5602: x_avail_assembly_qty OUT NoCopy NUMBER,
5603: x_atp_date OUT NoCopy DATE,
5604: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
5605: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
5606: x_return_status OUT NoCopy VARCHAR2
5607: )
5608: IS
5609: l_res_requirements MRP_ATP_PVT.Atp_Res_Typ;

Line 5610: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();

5606: x_return_status OUT NoCopy VARCHAR2
5607: )
5608: IS
5609: l_res_requirements MRP_ATP_PVT.Atp_Res_Typ;
5610: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
5611: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5612: l_requested_date_quantity number;
5613: l_resource_id number;
5614: l_department_id number;

Line 5611: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

5607: )
5608: IS
5609: l_res_requirements MRP_ATP_PVT.Atp_Res_Typ;
5610: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
5611: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5612: l_requested_date_quantity number;
5613: l_resource_id number;
5614: l_department_id number;
5615: l_requested_date date;

Line 5650: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

5646: -- Bug 3036513, Place holder for out parameter in get_infinite_time_fence_date.
5647: l_atp_rule_name VARCHAR2(80);
5648: -- End Bug 3036513
5649: l_return_status VARCHAR2(1);
5650: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
5651: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
5652: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
5653: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
5654: l_res_atp_date date;

Line 5651: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

5647: l_atp_rule_name VARCHAR2(80);
5648: -- End Bug 3036513
5649: l_return_status VARCHAR2(1);
5650: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
5651: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
5652: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
5653: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
5654: l_res_atp_date date;
5655: l_res_atp_qty number;

Line 5652: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;

5648: -- End Bug 3036513
5649: l_return_status VARCHAR2(1);
5650: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
5651: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
5652: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
5653: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
5654: l_res_atp_date date;
5655: l_res_atp_qty number;
5656: l_uom_code varchar2(10);

Line 5653: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

5649: l_return_status VARCHAR2(1);
5650: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
5651: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
5652: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
5653: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
5654: l_res_atp_date date;
5655: l_res_atp_qty number;
5656: l_uom_code varchar2(10);
5657: l_plan_id NUMBER;

Line 9111: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

9107: p_atf_date IN DATE, -- For time_phased_atp
9108: p_manufacturing_cal_code IN VARCHAR2, -- For ship_rec_cal
9109: x_avail_assembly_qty OUT NoCopy NUMBER,
9110: x_atp_date OUT NoCopy DATE,
9111: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
9112: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
9113: x_return_status OUT NoCopy VARCHAR2,
9114: p_comp_info_rec IN OUT NOCOPY MSC_ATP_REQ.get_comp_info_rec,
9115: p_order_number IN NUMBER := NULL,

Line 9112: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

9108: p_manufacturing_cal_code IN VARCHAR2, -- For ship_rec_cal
9109: x_avail_assembly_qty OUT NoCopy NUMBER,
9110: x_atp_date OUT NoCopy DATE,
9111: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
9112: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
9113: x_return_status OUT NoCopy VARCHAR2,
9114: p_comp_info_rec IN OUT NOCOPY MSC_ATP_REQ.get_comp_info_rec,
9115: p_order_number IN NUMBER := NULL,
9116: p_op_seq_id IN NUMBER --4570421

Line 9123: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();

9119: )
9120: IS
9121: l_comp_requirements MRP_ATP_PVT.Atp_Comp_Typ;
9122: l_explode_comp MRP_ATP_PVT.Atp_Comp_Typ;
9123: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
9124: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
9125: l_requested_date_quantity number;
9126: l_resource_id number;
9127: l_department_id number;

Line 9124: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

9120: IS
9121: l_comp_requirements MRP_ATP_PVT.Atp_Comp_Typ;
9122: l_explode_comp MRP_ATP_PVT.Atp_Comp_Typ;
9123: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
9124: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
9125: l_requested_date_quantity number;
9126: l_resource_id number;
9127: l_department_id number;
9128: l_requested_date date;

Line 9138: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

9134: i PLS_INTEGER;
9135: j PLS_INTEGER;
9136: l_requested_comp_qty number;
9137: l_atp_rec MRP_ATP_PVT.AtpRec;
9138: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
9139: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
9140:
9141: l_comp_item_id number;
9142: l_comp_usage number;

Line 9139: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

9135: j PLS_INTEGER;
9136: l_requested_comp_qty number;
9137: l_atp_rec MRP_ATP_PVT.AtpRec;
9138: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
9139: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
9140:
9141: l_comp_item_id number;
9142: l_comp_usage number;
9143: --4570421

Line 11117: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

11113: /* Spec changes as part of ship_rec_cal changes
11114: Various input output parameters grouped in the record Atp_Info_Rec*/
11115: PROCEDURE Get_Supplier_Atp_Info (
11116: p_sup_atp_info_rec IN OUT NOCOPY MSC_ATP_REQ.Atp_Info_Rec,
11117: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
11118: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
11119: x_return_status OUT NOCOPY VARCHAR2
11120: )
11121: IS

Line 11118: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

11114: Various input output parameters grouped in the record Atp_Info_Rec*/
11115: PROCEDURE Get_Supplier_Atp_Info (
11116: p_sup_atp_info_rec IN OUT NOCOPY MSC_ATP_REQ.Atp_Info_Rec,
11117: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
11118: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
11119: x_return_status OUT NOCOPY VARCHAR2
11120: )
11121: IS
11122:

Line 11132: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();

11128: l_atp_requested_date DATE;
11129: l_pre_process_date DATE;
11130: l_sysdate DATE;
11131:
11132: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
11133: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
11134: l_next_period DATE;
11135: l_null_num number := null;
11136: l_null_char varchar2(3) := null;

Line 11133: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

11129: l_pre_process_date DATE;
11130: l_sysdate DATE;
11131:
11132: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
11133: l_atp_qty_tab MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
11134: l_next_period DATE;
11135: l_null_num number := null;
11136: l_null_char varchar2(3) := null;
11137: l_plan_start_date DATE;

Line 12528: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

12524: p_parent_pegging_id IN NUMBER,
12525: x_requested_date_quantity OUT NoCopy NUMBER,
12526: x_atp_date_this_level OUT NoCopy DATE,
12527: x_atp_date_quantity_this_level OUT NoCopy NUMBER,
12528: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
12529: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
12530: x_return_status OUT NoCopy VARCHAR2
12531: )
12532: IS

Line 12529: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,

12525: x_requested_date_quantity OUT NoCopy NUMBER,
12526: x_atp_date_this_level OUT NoCopy DATE,
12527: x_atp_date_quantity_this_level OUT NoCopy NUMBER,
12528: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
12529: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
12530: x_return_status OUT NoCopy VARCHAR2
12531: )
12532: IS
12533:

Line 12539: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();

12535: l_requested_date DATE;
12536: l_unit_weight NUMBER;
12537: l_unit_volume NUMBER;
12538: l_available_quantity NUMBER;
12539: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
12540: l_atp_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
12541: l_atp_qty_tab2 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
12542: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
12543: l_atp_period2 MRP_ATP_PUB.ATP_Period_Typ;

Line 12540: l_atp_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

12536: l_unit_weight NUMBER;
12537: l_unit_volume NUMBER;
12538: l_available_quantity NUMBER;
12539: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
12540: l_atp_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
12541: l_atp_qty_tab2 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
12542: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
12543: l_atp_period2 MRP_ATP_PUB.ATP_Period_Typ;
12544: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 12541: l_atp_qty_tab2 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

12537: l_unit_volume NUMBER;
12538: l_available_quantity NUMBER;
12539: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
12540: l_atp_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
12541: l_atp_qty_tab2 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
12542: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
12543: l_atp_period2 MRP_ATP_PUB.ATP_Period_Typ;
12544: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
12545: l_atp_supply_demand2 MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 12542: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

12538: l_available_quantity NUMBER;
12539: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
12540: l_atp_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
12541: l_atp_qty_tab2 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
12542: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
12543: l_atp_period2 MRP_ATP_PUB.ATP_Period_Typ;
12544: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
12545: l_atp_supply_demand2 MRP_ATP_PUB.ATP_Supply_Demand_Typ;
12546: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 12543: l_atp_period2 MRP_ATP_PUB.ATP_Period_Typ;

12539: l_atp_period_tab MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
12540: l_atp_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
12541: l_atp_qty_tab2 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
12542: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
12543: l_atp_period2 MRP_ATP_PUB.ATP_Period_Typ;
12544: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
12545: l_atp_supply_demand2 MRP_ATP_PUB.ATP_Supply_Demand_Typ;
12546: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
12547: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 12544: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

12540: l_atp_qty_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
12541: l_atp_qty_tab2 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
12542: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
12543: l_atp_period2 MRP_ATP_PUB.ATP_Period_Typ;
12544: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
12545: l_atp_supply_demand2 MRP_ATP_PUB.ATP_Supply_Demand_Typ;
12546: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
12547: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
12548: m NUMBER;

Line 12545: l_atp_supply_demand2 MRP_ATP_PUB.ATP_Supply_Demand_Typ;

12541: l_atp_qty_tab2 MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
12542: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
12543: l_atp_period2 MRP_ATP_PUB.ATP_Period_Typ;
12544: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
12545: l_atp_supply_demand2 MRP_ATP_PUB.ATP_Supply_Demand_Typ;
12546: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
12547: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
12548: m NUMBER;
12549: k NUMBER;

Line 12546: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;

12542: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
12543: l_atp_period2 MRP_ATP_PUB.ATP_Period_Typ;
12544: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
12545: l_atp_supply_demand2 MRP_ATP_PUB.ATP_Supply_Demand_Typ;
12546: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
12547: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
12548: m NUMBER;
12549: k NUMBER;
12550: l_item_weight_qty NUMBER;

Line 12547: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

12543: l_atp_period2 MRP_ATP_PUB.ATP_Period_Typ;
12544: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
12545: l_atp_supply_demand2 MRP_ATP_PUB.ATP_Supply_Demand_Typ;
12546: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
12547: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
12548: m NUMBER;
12549: k NUMBER;
12550: l_item_weight_qty NUMBER;
12551: l_item_volume_qty NUMBER;