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

Line 58: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

54: p_demand_class IN VARCHAR2,
55: p_default_atp_rule_id IN NUMBER,
56: p_default_dmd_class IN VARCHAR2,
57: p_itf IN DATE,
58: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
59: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
60: x_return_status OUT NOCOPY VARCHAR2
61: );
62:

Line 59: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

55: p_default_atp_rule_id IN NUMBER,
56: p_default_dmd_class IN VARCHAR2,
57: p_itf IN DATE,
58: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
59: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
60: x_return_status OUT NOCOPY VARCHAR2
61: );
62:
63: PROCEDURE Get_Mat_Avail_Pf_Ods(

Line 75: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

71: p_demand_class IN VARCHAR2,
72: p_default_atp_rule_id IN NUMBER,
73: p_default_dmd_class IN VARCHAR2,
74: p_itf IN DATE,
75: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
76: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
77: x_return_status OUT NOCOPY VARCHAR2
78: );
79:

Line 76: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

72: p_default_atp_rule_id IN NUMBER,
73: p_default_dmd_class IN VARCHAR2,
74: p_itf IN DATE,
75: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
76: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
77: x_return_status OUT NOCOPY VARCHAR2
78: );
79:
80: PROCEDURE Get_Mat_Avail_Pf_Pds_Summ(

Line 88: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

84: p_instance_id IN NUMBER,
85: p_plan_id IN NUMBER,
86: p_itf IN DATE,
87: p_refresh_number IN NUMBER, -- For summary enhancement
88: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
89: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
90: x_return_status OUT NOCOPY VARCHAR2
91: );
92:

Line 89: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

85: p_plan_id IN NUMBER,
86: p_itf IN DATE,
87: p_refresh_number IN NUMBER, -- For summary enhancement
88: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
89: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
90: x_return_status OUT NOCOPY VARCHAR2
91: );
92:
93: PROCEDURE Get_Mat_Avail_Pf_Pds(

Line 100: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

96: p_org_id IN NUMBER,
97: p_instance_id IN NUMBER,
98: p_plan_id IN NUMBER,
99: p_itf IN DATE,
100: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
101: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
102: x_return_status OUT NOCOPY VARCHAR2
103: );
104:

Line 101: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

97: p_instance_id IN NUMBER,
98: p_plan_id IN NUMBER,
99: p_itf IN DATE,
100: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
101: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
102: x_return_status OUT NOCOPY VARCHAR2
103: );
104:
105: PROCEDURE Get_Mat_Avail_Pf_Ods_Dtls (

Line 1861: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

1857: p_default_atp_rule_id IN NUMBER,
1858: p_default_dmd_class IN VARCHAR2,
1859: p_itf IN DATE,
1860: p_refresh_number IN NUMBER,
1861: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
1862: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
1863: x_return_status OUT NOCOPY VARCHAR2
1864: ) IS
1865: l_return_status VARCHAR2(1);

Line 1862: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

1858: p_default_dmd_class IN VARCHAR2,
1859: p_itf IN DATE,
1860: p_refresh_number IN NUMBER,
1861: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
1862: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
1863: x_return_status OUT NOCOPY VARCHAR2
1864: ) IS
1865: l_return_status VARCHAR2(1);
1866:

Line 2079: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

2075: p_demand_class IN VARCHAR2,
2076: p_default_atp_rule_id IN NUMBER,
2077: p_default_dmd_class IN VARCHAR2,
2078: p_itf IN DATE,
2079: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
2080: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
2081: x_return_status OUT NOCOPY VARCHAR2
2082: ) IS
2083:

Line 2080: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

2076: p_default_atp_rule_id IN NUMBER,
2077: p_default_dmd_class IN VARCHAR2,
2078: p_itf IN DATE,
2079: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
2080: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
2081: x_return_status OUT NOCOPY VARCHAR2
2082: ) IS
2083:
2084: BEGIN

Line 2176: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

2172: p_demand_class IN VARCHAR2,
2173: p_default_atp_rule_id IN NUMBER,
2174: p_default_dmd_class IN VARCHAR2,
2175: p_itf IN DATE,
2176: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
2177: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
2178: x_return_status OUT NOCOPY VARCHAR2
2179: ) IS
2180: -- local variables

Line 2177: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

2173: p_default_atp_rule_id IN NUMBER,
2174: p_default_dmd_class IN VARCHAR2,
2175: p_itf IN DATE,
2176: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
2177: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
2178: x_return_status OUT NOCOPY VARCHAR2
2179: ) IS
2180: -- local variables
2181: l_sysdate date := sysdate;

Line 2444: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

2440: p_instance_id IN NUMBER,
2441: p_plan_id IN NUMBER,
2442: p_itf IN DATE,
2443: p_refresh_number IN NUMBER, -- For summary enhancement
2444: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
2445: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
2446: x_return_status OUT NOCOPY VARCHAR2
2447: ) IS
2448:

Line 2445: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

2441: p_plan_id IN NUMBER,
2442: p_itf IN DATE,
2443: p_refresh_number IN NUMBER, -- For summary enhancement
2444: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
2445: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
2446: x_return_status OUT NOCOPY VARCHAR2
2447: ) IS
2448:
2449: BEGIN

Line 2548: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

2544: p_org_id IN NUMBER,
2545: p_instance_id IN NUMBER,
2546: p_plan_id IN NUMBER,
2547: p_itf IN DATE,
2548: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
2549: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
2550: x_return_status OUT NOCOPY VARCHAR2
2551: ) IS
2552:

Line 2549: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

2545: p_instance_id IN NUMBER,
2546: p_plan_id IN NUMBER,
2547: p_itf IN DATE,
2548: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
2549: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
2550: x_return_status OUT NOCOPY VARCHAR2
2551: ) IS
2552:
2553: BEGIN

Line 3452: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

3448: p_level_id IN NUMBER,
3449: p_itf IN DATE,
3450: p_sys_next_date IN DATE, --bug3099066
3451: p_atf_date IN DATE,
3452: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
3453: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
3454: x_return_status OUT NOCOPY VARCHAR2
3455: ) IS
3456:

Line 3453: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

3449: p_itf IN DATE,
3450: p_sys_next_date IN DATE, --bug3099066
3451: p_atf_date IN DATE,
3452: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
3453: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
3454: x_return_status OUT NOCOPY VARCHAR2
3455: ) IS
3456:
3457: BEGIN

Line 3918: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

3914: p_level_id IN NUMBER,
3915: p_itf IN DATE,
3916: p_sys_next_date IN DATE, --3099066
3917: p_atf_date IN DATE,
3918: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
3919: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
3920: x_atp_unalloc_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
3921: x_return_status OUT NOCOPY VARCHAR2
3922: ) IS

Line 3919: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

3915: p_itf IN DATE,
3916: p_sys_next_date IN DATE, --3099066
3917: p_atf_date IN DATE,
3918: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
3919: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
3920: x_atp_unalloc_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
3921: x_return_status OUT NOCOPY VARCHAR2
3922: ) IS
3923:

Line 3920: x_atp_unalloc_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

3916: p_sys_next_date IN DATE, --3099066
3917: p_atf_date IN DATE,
3918: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
3919: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
3920: x_atp_unalloc_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
3921: x_return_status OUT NOCOPY VARCHAR2
3922: ) IS
3923:
3924: BEGIN

Line 5358: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

5354: p_instance_id IN NUMBER,
5355: p_plan_id IN NUMBER,
5356: p_demand_class IN VARCHAR2,
5357: p_itf IN DATE,
5358: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5359: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5360: x_return_status OUT NOCOPY VARCHAR2
5361: ) IS
5362:

Line 5359: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

5355: p_plan_id IN NUMBER,
5356: p_demand_class IN VARCHAR2,
5357: p_itf IN DATE,
5358: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5359: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5360: x_return_status OUT NOCOPY VARCHAR2
5361: ) IS
5362:
5363: BEGIN

Line 5434: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

5430: p_plan_id IN NUMBER,
5431: p_demand_class IN VARCHAR2,
5432: p_itf IN DATE,
5433: p_refresh_number IN NUMBER,
5434: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5435: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5436: x_return_status OUT NOCOPY VARCHAR2
5437: ) IS
5438:

Line 5435: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

5431: p_demand_class IN VARCHAR2,
5432: p_itf IN DATE,
5433: p_refresh_number IN NUMBER,
5434: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5435: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5436: x_return_status OUT NOCOPY VARCHAR2
5437: ) IS
5438:
5439: BEGIN

Line 5795: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

5791: p_org_id IN NUMBER,
5792: p_instance_id IN NUMBER,
5793: p_plan_id IN NUMBER,
5794: p_itf IN DATE,
5795: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5796: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5797: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
5798: x_return_status OUT NOCOPY VARCHAR2
5799: ) IS

Line 5796: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

5792: p_instance_id IN NUMBER,
5793: p_plan_id IN NUMBER,
5794: p_itf IN DATE,
5795: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5796: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5797: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
5798: x_return_status OUT NOCOPY VARCHAR2
5799: ) IS
5800:

Line 5797: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,

5793: p_plan_id IN NUMBER,
5794: p_itf IN DATE,
5795: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5796: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5797: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
5798: x_return_status OUT NOCOPY VARCHAR2
5799: ) IS
5800:
5801: BEGIN

Line 5886: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

5882: p_instance_id IN NUMBER,
5883: p_plan_id IN NUMBER,
5884: p_itf IN DATE,
5885: p_refresh_number IN NUMBER,
5886: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5887: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5888: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
5889: x_return_status OUT NOCOPY VARCHAR2
5890: ) IS

Line 5887: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

5883: p_plan_id IN NUMBER,
5884: p_itf IN DATE,
5885: p_refresh_number IN NUMBER,
5886: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5887: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5888: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
5889: x_return_status OUT NOCOPY VARCHAR2
5890: ) IS
5891:

Line 5888: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,

5884: p_itf IN DATE,
5885: p_refresh_number IN NUMBER,
5886: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5887: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5888: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
5889: x_return_status OUT NOCOPY VARCHAR2
5890: ) IS
5891:
5892: BEGIN

Line 7429: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,

7425: | - Bw_Fw_Cum(4) : Backward consumption, forward consumption and accumulation
7426: | - Bw_Fw(5) : Backward consumption and forward consumption
7427: +-------------------------------------------------------------------------*/
7428: PROCEDURE PF_Atp_Consume(
7429: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
7430: x_return_status OUT NOCOPY VARCHAR2,
7431: p_atp_period IN MRP_ATP_PUB.date_arr :=NULL,
7432: p_consumption_type IN NUMBER := Bw_Fw_Cum,
7433: p_atf_date IN DATE := NULL

Line 7431: p_atp_period IN MRP_ATP_PUB.date_arr :=NULL,

7427: +-------------------------------------------------------------------------*/
7428: PROCEDURE PF_Atp_Consume(
7429: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
7430: x_return_status OUT NOCOPY VARCHAR2,
7431: p_atp_period IN MRP_ATP_PUB.date_arr :=NULL,
7432: p_consumption_type IN NUMBER := Bw_Fw_Cum,
7433: p_atf_date IN DATE := NULL
7434: )
7435: IS

Line 7617: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,

7613: | consumption when crossing aggregate time fence.
7614: | - Incorporates better algorithm for consumption.
7615: +----------------------------------------------------------------------------*/
7616: PROCEDURE PF_Atp_Alloc_Consume(
7617: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
7618: p_atp_period IN MRP_ATP_PUB.date_arr,
7619: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
7620: p_atf_date IN DATE,
7621: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,

Line 7618: p_atp_period IN MRP_ATP_PUB.date_arr,

7614: | - Incorporates better algorithm for consumption.
7615: +----------------------------------------------------------------------------*/
7616: PROCEDURE PF_Atp_Alloc_Consume(
7617: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
7618: p_atp_period IN MRP_ATP_PUB.date_arr,
7619: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
7620: p_atf_date IN DATE,
7621: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
7622: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,

Line 7619: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,

7615: +----------------------------------------------------------------------------*/
7616: PROCEDURE PF_Atp_Alloc_Consume(
7617: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
7618: p_atp_period IN MRP_ATP_PUB.date_arr,
7619: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
7620: p_atf_date IN DATE,
7621: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
7622: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
7623: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,

Line 7621: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,

7617: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
7618: p_atp_period IN MRP_ATP_PUB.date_arr,
7619: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
7620: p_atf_date IN DATE,
7621: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
7622: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
7623: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
7624: x_return_status OUT NOCOPY VARCHAR2
7625: )

Line 7622: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,

7618: p_atp_period IN MRP_ATP_PUB.date_arr,
7619: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
7620: p_atf_date IN DATE,
7621: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
7622: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
7623: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
7624: x_return_status OUT NOCOPY VARCHAR2
7625: )
7626: IS

Line 7623: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,

7619: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
7620: p_atf_date IN DATE,
7621: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
7622: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
7623: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
7624: x_return_status OUT NOCOPY VARCHAR2
7625: )
7626: IS
7627: i NUMBER;

Line 7640: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();

7636:
7637: -- Initializing API return code
7638: x_return_status := FND_API.G_RET_STS_SUCCESS;
7639:
7640: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();
7641: x_dc_start_index := MRP_ATP_PUB.Number_Arr();
7642: x_dc_end_index := MRP_ATP_PUB.Number_Arr();
7643:
7644: x_dc_list_tab.EXTEND;

Line 7641: x_dc_start_index := MRP_ATP_PUB.Number_Arr();

7637: -- Initializing API return code
7638: x_return_status := FND_API.G_RET_STS_SUCCESS;
7639:
7640: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();
7641: x_dc_start_index := MRP_ATP_PUB.Number_Arr();
7642: x_dc_end_index := MRP_ATP_PUB.Number_Arr();
7643:
7644: x_dc_list_tab.EXTEND;
7645: x_dc_start_index.EXTEND;

Line 7642: x_dc_end_index := MRP_ATP_PUB.Number_Arr();

7638: x_return_status := FND_API.G_RET_STS_SUCCESS;
7639:
7640: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();
7641: x_dc_start_index := MRP_ATP_PUB.Number_Arr();
7642: x_dc_end_index := MRP_ATP_PUB.Number_Arr();
7643:
7644: x_dc_list_tab.EXTEND;
7645: x_dc_start_index.EXTEND;
7646: x_dc_end_index.EXTEND;

Line 7810: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

7806: | Original_Demand_Quantity column.
7807: | o For Total_Bucketed_Demand_Quantity all demands are looked at.
7808: +-------------------------------------------------------------------------*/
7809: PROCEDURE Get_Period_Data_From_Sd_Temp(
7810: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
7811: x_return_status OUT NOCOPY VARCHAR2
7812: ) IS
7813: i NUMBER;
7814: j NUMBER;

Line 7963: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

7959: | o This is similar to previous procedure only difference being that we
7960: | also return unallocated quantities.
7961: +-------------------------------------------------------------------------*/
7962: PROCEDURE Get_Unalloc_Data_From_Sd_Temp(
7963: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
7964: p_unallocated_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info,
7965: x_return_status OUT NOCOPY VARCHAR2
7966: ) IS
7967: i NUMBER;

Line 8129: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

8125: p_scenario_id IN NUMBER,
8126: p_level_id IN NUMBER,
8127: p_record_type IN PLS_INTEGER,
8128: p_session_id IN NUMBER,
8129: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
8130: x_return_status OUT NOCOPY VARCHAR2
8131: ) IS
8132:
8133: BEGIN

Line 8898: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

8894: x_return_status OUT NOCOPY VARCHAR2
8895: ) IS
8896: -- local variables
8897: --bug3663487 start
8898: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8899: l_sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8900: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8901: l_atf_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();
8902: j NUMBER;

Line 8899: l_sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

8895: ) IS
8896: -- local variables
8897: --bug3663487 start
8898: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8899: l_sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8900: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8901: l_atf_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();
8902: j NUMBER;
8903: k NUMBER;

Line 8900: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

8896: -- local variables
8897: --bug3663487 start
8898: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8899: l_sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8900: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8901: l_atf_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();
8902: j NUMBER;
8903: k NUMBER;
8904: --bug3663487 end

Line 8901: l_atf_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();

8897: --bug3663487 start
8898: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8899: l_sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8900: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8901: l_atf_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();
8902: j NUMBER;
8903: k NUMBER;
8904: --bug3663487 end
8905:

Line 9245: atp_summ_tab MRP_ATP_PUB.char30_arr :=

9241: l_sql_stmt_1 VARCHAR2(16000);
9242: l_table_name VARCHAR2(30);
9243: l_tbspace VARCHAR2(30);
9244: l_temp_table VARCHAR2(30);
9245: atp_summ_tab MRP_ATP_PUB.char30_arr :=
9246: MRP_ATP_PUB.char30_arr(
9247: 'ALLOC_DEMANDS',
9248: 'ALLOC_SUPPLIES'
9249: );

Line 9246: MRP_ATP_PUB.char30_arr(

9242: l_table_name VARCHAR2(30);
9243: l_tbspace VARCHAR2(30);
9244: l_temp_table VARCHAR2(30);
9245: atp_summ_tab MRP_ATP_PUB.char30_arr :=
9246: MRP_ATP_PUB.char30_arr(
9247: 'ALLOC_DEMANDS',
9248: 'ALLOC_SUPPLIES'
9249: );
9250: l_plan_name varchar2(10);