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

Line 9: dlt_lookup MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();

5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
6:
7: -- dlt dsting. replaced hash with nested table since 8i doesn't support it
8: MAX_DLT_CACHE_SZ NUMBER := 10;
9: dlt_lookup MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
10: dlt_cache MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
11: ship_method_cache MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
12: dlt_idx NUMBER := 0;
13:

Line 10: dlt_cache MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

6:
7: -- dlt dsting. replaced hash with nested table since 8i doesn't support it
8: MAX_DLT_CACHE_SZ NUMBER := 10;
9: dlt_lookup MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
10: dlt_cache MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
11: ship_method_cache MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
12: dlt_idx NUMBER := 0;
13:
14: -- 2834932

Line 11: ship_method_cache MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();

7: -- dlt dsting. replaced hash with nested table since 8i doesn't support it
8: MAX_DLT_CACHE_SZ NUMBER := 10;
9: dlt_lookup MRP_ATP_PUB.char80_arr := MRP_ATP_PUB.char80_arr();
10: dlt_cache MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
11: ship_method_cache MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
12: dlt_idx NUMBER := 0;
13:
14: -- 2834932
15: G_NONWORKING_DAY CONSTANT NUMBER := 1;

Line 52: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ

48: p_organization_id IN NUMBER,
49: p_supplier_id IN NUMBER,
50: p_supplier_site_id IN NUMBER,
51: p_infinite_time_fence_date IN DATE,
52: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ
53:
54: ) IS
55: j NUMBER;
56: l_return_status VARCHAR2(1);

Line 108: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ

104: -- NOTE: as part of the pegging enhancement this procedure assumes that
105: -- only 1 item's data is in the session specific temp table
106: --
107: PROCEDURE get_period_data_from_SD_temp(
108: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ
109: ) IS
110: i NUMBER;
111: j NUMBER;
112: x_return_status NUMBER;

Line 201: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

197: -- New procedure added as part of time_phased_atp to fix the
198: -- issue of not displaying correct quantities in ATP SD Window when
199: -- user opens ATP SD window from ATP pegging in allocated scenarios
200: PROCEDURE Get_Alloc_Data_From_Sd_Temp(
201: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
202: x_return_status OUT NOCOPY VARCHAR2
203: ) IS
204: i NUMBER;
205: j NUMBER;

Line 302: ---p_ship_set_item IN MRP_ATP_PUB.number_arr,

298: p_organization_id IN NUMBER,
299: p_customer_id IN NUMBER,
300: p_customer_site_id IN NUMBER,
301: p_assign_set_id IN NUMBER,
302: ---p_ship_set_item IN MRP_ATP_PUB.number_arr,
303: p_item_sourcing_info_rec IN MSC_ATP_CTO.Item_Sourcing_Info_Rec,
304: p_session_id IN NUMBER,
305: x_atp_sources OUT NoCopy MRP_ATP_PVT.Atp_Source_Typ,
306: x_return_status OUT NoCopy VARCHAR2,

Line 322: l_dist_sr_ship_set_item_list MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

318: l_distinct_item PLS_INTEGER;
319: l_organization_id NUMBER;
320:
321: /* Variables added for Bug 2585710 start */
322: l_dist_sr_ship_set_item_list MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
323: l_dest_ship_set_item_list MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
324: l_sysdate DATE;
325: l_return_status VARCHAR2(100);
326: /* Variables added for Bug 2585710 end */

Line 323: l_dest_ship_set_item_list MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

319: l_organization_id NUMBER;
320:
321: /* Variables added for Bug 2585710 start */
322: l_dist_sr_ship_set_item_list MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
323: l_dest_ship_set_item_list MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
324: l_sysdate DATE;
325: l_return_status VARCHAR2(100);
326: /* Variables added for Bug 2585710 end */
327: --s_cto_rearch

Line 329: l_line_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

325: l_return_status VARCHAR2(100);
326: /* Variables added for Bug 2585710 end */
327: --s_cto_rearch
328: l_model_flag number := 2;
329: l_line_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
330: l_source_list MRP_ATP_PVT.Atp_Source_Typ;
331: --e_cto_rearch
332:
333: BEGIN

Line 1625: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr,

1621: --
1622: --
1623:
1624: PROCEDURE atp_consume_range (
1625: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr,
1626: p_start_idx IN NUMBER,
1627: p_end_idx IN NUMBER)
1628: IS
1629: j NUMBER;

Line 1716: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr,

1712:
1713: END atp_consume_range;
1714:
1715: PROCEDURE atp_consume (
1716: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr,
1717: p_counter IN NUMBER)
1718: IS
1719: BEGIN
1720: atp_consume_range(p_atp_qty, 1, p_counter);

Line 1724: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,

1720: atp_consume_range(p_atp_qty, 1, p_counter);
1721: END atp_consume;
1722:
1723: PROCEDURE Details_Output (
1724: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
1725: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
1726: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
1727: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
1728: x_return_status OUT NoCopy VARCHAR2

Line 1725: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,

1721: END atp_consume;
1722:
1723: PROCEDURE Details_Output (
1724: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
1725: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
1726: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
1727: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
1728: x_return_status OUT NoCopy VARCHAR2
1729: ) IS

Line 1726: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

1722:
1723: PROCEDURE Details_Output (
1724: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
1725: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
1726: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
1727: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
1728: x_return_status OUT NoCopy VARCHAR2
1729: ) IS
1730:

Line 1727: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

1723: PROCEDURE Details_Output (
1724: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
1725: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
1726: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
1727: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
1728: x_return_status OUT NoCopy VARCHAR2
1729: ) IS
1730:
1731: l_period_count PLS_INTEGER;

Line 1930: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,

1926: END get_dept_res_code;
1927:
1928:
1929: PROCEDURE Get_SD_Period_Rec(
1930: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
1931: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
1932: p_identifier IN NUMBER,
1933: p_scenario_id IN NUMBER,
1934: p_new_scenario_id IN NUMBER,

Line 1931: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,

1927:
1928:
1929: PROCEDURE Get_SD_Period_Rec(
1930: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
1931: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
1932: p_identifier IN NUMBER,
1933: p_scenario_id IN NUMBER,
1934: p_new_scenario_id IN NUMBER,
1935: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

Line 1935: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

1931: p_atp_supply_demand IN MRP_ATP_PUB.ATP_Supply_Demand_Typ,
1932: p_identifier IN NUMBER,
1933: p_scenario_id IN NUMBER,
1934: p_new_scenario_id IN NUMBER,
1935: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
1936: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
1937: x_return_status OUT NoCopy VARCHAR2
1938: ) IS
1939:

Line 1936: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

1932: p_identifier IN NUMBER,
1933: p_scenario_id IN NUMBER,
1934: p_new_scenario_id IN NUMBER,
1935: x_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
1936: x_atp_supply_demand IN OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
1937: x_return_status OUT NoCopy VARCHAR2
1938: ) IS
1939:
1940: l_period_count PLS_INTEGER;

Line 2242: l_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

2238: l_using_new_plan number;
2239: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
2240:
2241: --bug 2854351
2242: l_plan_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
2243: i number;
2244: l_generic_plan number;
2245:
2246: --ATP4drp local variable for time phased ATP.

Line 2843: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr

2839:
2840: END Get_Plan_Info;
2841:
2842: PROCEDURE Atp_Backward_Consume(
2843: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr
2844: )
2845: IS
2846: i NUMBER;
2847: j NUMBER;

Line 2890: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr

2886: END Atp_Backward_Consume;
2887:
2888:
2889: PROCEDURE Atp_Accumulate(
2890: p_atp_qty IN OUT NoCopy MRP_ATP_PUB.number_arr
2891: )
2892: IS
2893: i NUMBER;
2894:

Line 2932: Inventory_item_id MRP_ATP_PUB.number_Arr,

2928: )
2929: IS
2930:
2931: TYPE ITEM_COPRODUCTS is RECORD (
2932: Inventory_item_id MRP_ATP_PUB.number_Arr,
2933: Quantity MRP_ATP_PUB.number_arr);
2934: l_coproducts_rec ITEM_COPRODUCTS;
2935: --l_supply_usage number;
2936: --l_coproducts_flag varchar(4);

Line 2933: Quantity MRP_ATP_PUB.number_arr);

2929: IS
2930:
2931: TYPE ITEM_COPRODUCTS is RECORD (
2932: Inventory_item_id MRP_ATP_PUB.number_Arr,
2933: Quantity MRP_ATP_PUB.number_arr);
2934: l_coproducts_rec ITEM_COPRODUCTS;
2935: --l_supply_usage number;
2936: --l_coproducts_flag varchar(4);
2937: l_transaction_id NUMBER;

Line 3230: l_item_arr mrp_atp_pub.number_arr := mrp_atp_pub.number_arr(1);

3226: IS
3227: l_return_status VARCHAR2(100);
3228: l_request_item_id NUMBER := NULL;
3229: l_sources mrp_atp_pvt.atp_source_typ;
3230: l_item_arr mrp_atp_pub.number_arr := mrp_atp_pub.number_arr(1);
3231: l_item_sourcing_rec MSC_ATP_CTO.Item_Sourcing_Info_Rec;
3232: l_other_cols order_sch_wb.other_cols_typ;
3233: l_item_id NUMBER;
3234: l_sr_instance_id NUMBER;

Line 4969: l_ship_method_arr MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();

4965:
4966:
4967: ---------------- Local Variables
4968:
4969: l_ship_method_arr MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4970: l_lead_time_arr MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4971:
4972: l_ship_method_arr_null MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4973: l_lead_time_arr_null MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 4970: l_lead_time_arr MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

4966:
4967: ---------------- Local Variables
4968:
4969: l_ship_method_arr MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4970: l_lead_time_arr MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4971:
4972: l_ship_method_arr_null MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4973: l_lead_time_arr_null MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4974:

Line 4972: l_ship_method_arr_null MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();

4968:
4969: l_ship_method_arr MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4970: l_lead_time_arr MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4971:
4972: l_ship_method_arr_null MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4973: l_lead_time_arr_null MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4974:
4975: l_counter number;
4976: l_counter2 number;

Line 4973: l_lead_time_arr_null MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

4969: l_ship_method_arr MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4970: l_lead_time_arr MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4971:
4972: l_ship_method_arr_null MRP_ATP_PUB.char30_arr := MRP_ATP_PUB.char30_arr();
4973: l_lead_time_arr_null MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4974:
4975: l_counter number;
4976: l_counter2 number;
4977: l_level_tmp number;

Line 5447: l_dist_level_type MRP_ATP_PUB.number_arr;

5443: p_order_line_id IN NUMBER, --2814895
5444: p_requested_date IN DATE DEFAULT NULL --8524794
5445: )
5446: IS
5447: l_dist_level_type MRP_ATP_PUB.number_arr;
5448: l_counter PLS_INTEGER := 0;
5449: l_sysdate DATE;
5450: l_inserted_rows PLS_INTEGER := 0;
5451: l_updated_rows PLS_INTEGER := 0;

Line 5453: l_inventory_item_id_arr MRP_ATP_PUB.number_arr;

5449: l_sysdate DATE;
5450: l_inserted_rows PLS_INTEGER := 0;
5451: l_updated_rows PLS_INTEGER := 0;
5452: l_min_region_value PLS_INTEGER := 0;
5453: l_inventory_item_id_arr MRP_ATP_PUB.number_arr;
5454: l_min_region_value_arr MRP_ATP_PUB.number_arr;
5455: l_items_visited PLS_INTEGER := 0;
5456: i PLS_INTEGER := 0;
5457:

Line 5454: l_min_region_value_arr MRP_ATP_PUB.number_arr;

5450: l_inserted_rows PLS_INTEGER := 0;
5451: l_updated_rows PLS_INTEGER := 0;
5452: l_min_region_value PLS_INTEGER := 0;
5453: l_inventory_item_id_arr MRP_ATP_PUB.number_arr;
5454: l_min_region_value_arr MRP_ATP_PUB.number_arr;
5455: l_items_visited PLS_INTEGER := 0;
5456: i PLS_INTEGER := 0;
5457:
5458: BEGIN

Line 7883: p_set IN MRP_ATP_PUB.ATP_Rec_Typ,

7879: -- Set processing procedures --
7880: --------------------------------------------------
7881:
7882: PROCEDURE Initialize_Set_Processing (
7883: p_set IN MRP_ATP_PUB.ATP_Rec_Typ,
7884: p_start IN NUMBER
7885: ) IS
7886: BEGIN
7887: IF PG_DEBUG in ('Y', 'C') THEN

Line 7904: p_set IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

7900: G_latest_arr_date_set := null;
7901: END Initialize_Set_Processing;
7902:
7903: PROCEDURE Process_Set_Line(
7904: p_set IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
7905: i IN NUMBER,
7906: x_line_status OUT NOCOPY NUMBER
7907: ) IS
7908: l_request_date_ln DATE;

Line 8057: p_set IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

8053:
8054: END Process_Set_Line;
8055:
8056: PROCEDURE Process_Set_Dates_Errors(
8057: p_set IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
8058: p_src_dest IN VARCHAR2,
8059: x_set_status OUT NOCOPY NUMBER,
8060: p_start IN NUMBER DEFAULT NULL,
8061: p_end IN NUMBER DEFAULT NULL

Line 8303: p_set IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

8299: END Process_Set_Dates_Errors;
8300:
8301: -- dsting copied and pasted from schedule
8302: PROCEDURE Update_Set_SD_Dates(
8303: p_set IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
8304: p_arrival_set IN mrp_atp_pub.date_arr
8305: ) IS
8306: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
8307: l_plan_id NUMBER;

Line 8304: p_arrival_set IN mrp_atp_pub.date_arr

8300:
8301: -- dsting copied and pasted from schedule
8302: PROCEDURE Update_Set_SD_Dates(
8303: p_set IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
8304: p_arrival_set IN mrp_atp_pub.date_arr
8305: ) IS
8306: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
8307: l_plan_id NUMBER;
8308: l_demand_pegging_id NUMBER;

Line 8886: p1 IN OUT NOCOPY mrp_atp_pub.number_arr,

8882:
8883: END get_delivery_lead_time;
8884:
8885: PROCEDURE number_arr_cat (
8886: p1 IN OUT NOCOPY mrp_atp_pub.number_arr,
8887: p2 IN mrp_atp_pub.number_arr
8888: ) IS
8889: len number;
8890: BEGIN

Line 8887: p2 IN mrp_atp_pub.number_arr

8883: END get_delivery_lead_time;
8884:
8885: PROCEDURE number_arr_cat (
8886: p1 IN OUT NOCOPY mrp_atp_pub.number_arr,
8887: p2 IN mrp_atp_pub.number_arr
8888: ) IS
8889: len number;
8890: BEGIN
8891: len := p1.count();

Line 8899: p1 IN OUT NOCOPY mrp_atp_pub.date_arr,

8895: end loop;
8896: END number_arr_cat;
8897:
8898: PROCEDURE date_arr_cat (
8899: p1 IN OUT NOCOPY mrp_atp_pub.date_arr,
8900: p2 IN mrp_atp_pub.date_arr
8901: ) IS
8902: len number;
8903: BEGIN

Line 8900: p2 IN mrp_atp_pub.date_arr

8896: END number_arr_cat;
8897:
8898: PROCEDURE date_arr_cat (
8899: p1 IN OUT NOCOPY mrp_atp_pub.date_arr,
8900: p2 IN mrp_atp_pub.date_arr
8901: ) IS
8902: len number;
8903: BEGIN
8904: len := p1.count();

Line 8914: peg_ids IN mrp_atp_pub.number_arr,

8910:
8911: PROCEDURE cleanup_set(
8912: p_instance_id IN number,
8913: p_plan_id IN number,
8914: peg_ids IN mrp_atp_pub.number_arr,
8915: dmd_class_flag IN mrp_atp_pub.number_arr
8916: ) IS
8917: l_return_sts varchar2(1);
8918: BEGIN

Line 8915: dmd_class_flag IN mrp_atp_pub.number_arr

8911: PROCEDURE cleanup_set(
8912: p_instance_id IN number,
8913: p_plan_id IN number,
8914: peg_ids IN mrp_atp_pub.number_arr,
8915: dmd_class_flag IN mrp_atp_pub.number_arr
8916: ) IS
8917: l_return_sts varchar2(1);
8918: BEGIN
8919: FOR i in 1..peg_ids.count LOOP