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 1854: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

1850: p_default_atp_rule_id IN NUMBER,
1851: p_default_dmd_class IN VARCHAR2,
1852: p_itf IN DATE,
1853: p_refresh_number IN NUMBER,
1854: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
1855: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
1856: x_return_status OUT NOCOPY VARCHAR2
1857: ) IS
1858: l_return_status VARCHAR2(1);

Line 1855: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

1851: p_default_dmd_class IN VARCHAR2,
1852: p_itf IN DATE,
1853: p_refresh_number IN NUMBER,
1854: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
1855: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
1856: x_return_status OUT NOCOPY VARCHAR2
1857: ) IS
1858: l_return_status VARCHAR2(1);
1859:

Line 2072: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

2068: p_demand_class IN VARCHAR2,
2069: p_default_atp_rule_id IN NUMBER,
2070: p_default_dmd_class IN VARCHAR2,
2071: p_itf IN DATE,
2072: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
2073: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
2074: x_return_status OUT NOCOPY VARCHAR2
2075: ) IS
2076:

Line 2073: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

2069: p_default_atp_rule_id IN NUMBER,
2070: p_default_dmd_class IN VARCHAR2,
2071: p_itf IN DATE,
2072: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
2073: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
2074: x_return_status OUT NOCOPY VARCHAR2
2075: ) IS
2076:
2077: BEGIN

Line 2169: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

2165: p_demand_class IN VARCHAR2,
2166: p_default_atp_rule_id IN NUMBER,
2167: p_default_dmd_class IN VARCHAR2,
2168: p_itf IN DATE,
2169: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
2170: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
2171: x_return_status OUT NOCOPY VARCHAR2
2172: ) IS
2173: -- local variables

Line 2170: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

2166: p_default_atp_rule_id IN NUMBER,
2167: p_default_dmd_class IN VARCHAR2,
2168: p_itf IN DATE,
2169: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
2170: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
2171: x_return_status OUT NOCOPY VARCHAR2
2172: ) IS
2173: -- local variables
2174: l_sysdate date := sysdate;

Line 2432: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

2428: p_instance_id IN NUMBER,
2429: p_plan_id IN NUMBER,
2430: p_itf IN DATE,
2431: p_refresh_number IN NUMBER, -- For summary enhancement
2432: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
2433: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
2434: x_return_status OUT NOCOPY VARCHAR2
2435: ) IS
2436:

Line 2433: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

2429: p_plan_id IN NUMBER,
2430: p_itf IN DATE,
2431: p_refresh_number IN NUMBER, -- For summary enhancement
2432: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
2433: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
2434: x_return_status OUT NOCOPY VARCHAR2
2435: ) IS
2436:
2437: BEGIN

Line 2536: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

2532: p_org_id IN NUMBER,
2533: p_instance_id IN NUMBER,
2534: p_plan_id IN NUMBER,
2535: p_itf IN DATE,
2536: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
2537: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
2538: x_return_status OUT NOCOPY VARCHAR2
2539: ) IS
2540:

Line 2537: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

2533: p_instance_id IN NUMBER,
2534: p_plan_id IN NUMBER,
2535: p_itf IN DATE,
2536: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
2537: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
2538: x_return_status OUT NOCOPY VARCHAR2
2539: ) IS
2540:
2541: BEGIN

Line 3435: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

3431: p_level_id IN NUMBER,
3432: p_itf IN DATE,
3433: p_sys_next_date IN DATE, --bug3099066
3434: p_atf_date IN DATE,
3435: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
3436: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
3437: x_return_status OUT NOCOPY VARCHAR2
3438: ) IS
3439:

Line 3436: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

3432: p_itf IN DATE,
3433: p_sys_next_date IN DATE, --bug3099066
3434: p_atf_date IN DATE,
3435: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
3436: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
3437: x_return_status OUT NOCOPY VARCHAR2
3438: ) IS
3439:
3440: BEGIN

Line 3898: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

3894: p_level_id IN NUMBER,
3895: p_itf IN DATE,
3896: p_sys_next_date IN DATE, --3099066
3897: p_atf_date IN DATE,
3898: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
3899: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
3900: x_atp_unalloc_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
3901: x_return_status OUT NOCOPY VARCHAR2
3902: ) IS

Line 3899: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

3895: p_itf IN DATE,
3896: p_sys_next_date IN DATE, --3099066
3897: p_atf_date IN DATE,
3898: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
3899: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
3900: x_atp_unalloc_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
3901: x_return_status OUT NOCOPY VARCHAR2
3902: ) IS
3903:

Line 3900: x_atp_unalloc_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

3896: p_sys_next_date IN DATE, --3099066
3897: p_atf_date IN DATE,
3898: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
3899: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
3900: x_atp_unalloc_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
3901: x_return_status OUT NOCOPY VARCHAR2
3902: ) IS
3903:
3904: BEGIN

Line 5332: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

5328: p_instance_id IN NUMBER,
5329: p_plan_id IN NUMBER,
5330: p_demand_class IN VARCHAR2,
5331: p_itf IN DATE,
5332: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5333: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5334: x_return_status OUT NOCOPY VARCHAR2
5335: ) IS
5336:

Line 5333: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

5329: p_plan_id IN NUMBER,
5330: p_demand_class IN VARCHAR2,
5331: p_itf IN DATE,
5332: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5333: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5334: x_return_status OUT NOCOPY VARCHAR2
5335: ) IS
5336:
5337: BEGIN

Line 5408: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

5404: p_plan_id IN NUMBER,
5405: p_demand_class IN VARCHAR2,
5406: p_itf IN DATE,
5407: p_refresh_number IN NUMBER,
5408: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5409: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5410: x_return_status OUT NOCOPY VARCHAR2
5411: ) IS
5412:

Line 5409: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

5405: p_demand_class IN VARCHAR2,
5406: p_itf IN DATE,
5407: p_refresh_number IN NUMBER,
5408: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5409: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5410: x_return_status OUT NOCOPY VARCHAR2
5411: ) IS
5412:
5413: BEGIN

Line 5769: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

5765: p_org_id IN NUMBER,
5766: p_instance_id IN NUMBER,
5767: p_plan_id IN NUMBER,
5768: p_itf IN DATE,
5769: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5770: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5771: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
5772: x_return_status OUT NOCOPY VARCHAR2
5773: ) IS

Line 5770: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

5766: p_instance_id IN NUMBER,
5767: p_plan_id IN NUMBER,
5768: p_itf IN DATE,
5769: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5770: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5771: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
5772: x_return_status OUT NOCOPY VARCHAR2
5773: ) IS
5774:

Line 5771: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,

5767: p_plan_id IN NUMBER,
5768: p_itf IN DATE,
5769: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5770: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5771: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
5772: x_return_status OUT NOCOPY VARCHAR2
5773: ) IS
5774:
5775: BEGIN

Line 5860: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,

5856: p_instance_id IN NUMBER,
5857: p_plan_id IN NUMBER,
5858: p_itf IN DATE,
5859: p_refresh_number IN NUMBER,
5860: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5861: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5862: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
5863: x_return_status OUT NOCOPY VARCHAR2
5864: ) IS

Line 5861: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,

5857: p_plan_id IN NUMBER,
5858: p_itf IN DATE,
5859: p_refresh_number IN NUMBER,
5860: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5861: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5862: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
5863: x_return_status OUT NOCOPY VARCHAR2
5864: ) IS
5865:

Line 5862: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,

5858: p_itf IN DATE,
5859: p_refresh_number IN NUMBER,
5860: x_atp_dates OUT NOCOPY MRP_ATP_PUB.date_arr,
5861: x_atp_qtys OUT NOCOPY MRP_ATP_PUB.number_arr,
5862: x_atp_dcs OUT NOCOPY MRP_ATP_PUB.char80_arr,
5863: x_return_status OUT NOCOPY VARCHAR2
5864: ) IS
5865:
5866: BEGIN

Line 7403: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,

7399: | - Bw_Fw_Cum(4) : Backward consumption, forward consumption and accumulation
7400: | - Bw_Fw(5) : Backward consumption and forward consumption
7401: +-------------------------------------------------------------------------*/
7402: PROCEDURE PF_Atp_Consume(
7403: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
7404: x_return_status OUT NOCOPY VARCHAR2,
7405: p_atp_period IN MRP_ATP_PUB.date_arr :=NULL,
7406: p_consumption_type IN NUMBER := Bw_Fw_Cum,
7407: p_atf_date IN DATE := NULL

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

7401: +-------------------------------------------------------------------------*/
7402: PROCEDURE PF_Atp_Consume(
7403: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
7404: x_return_status OUT NOCOPY VARCHAR2,
7405: p_atp_period IN MRP_ATP_PUB.date_arr :=NULL,
7406: p_consumption_type IN NUMBER := Bw_Fw_Cum,
7407: p_atf_date IN DATE := NULL
7408: )
7409: IS

Line 7591: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,

7587: | consumption when crossing aggregate time fence.
7588: | - Incorporates better algorithm for consumption.
7589: +----------------------------------------------------------------------------*/
7590: PROCEDURE PF_Atp_Alloc_Consume(
7591: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
7592: p_atp_period IN MRP_ATP_PUB.date_arr,
7593: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
7594: p_atf_date IN DATE,
7595: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,

Line 7592: p_atp_period IN MRP_ATP_PUB.date_arr,

7588: | - Incorporates better algorithm for consumption.
7589: +----------------------------------------------------------------------------*/
7590: PROCEDURE PF_Atp_Alloc_Consume(
7591: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
7592: p_atp_period IN MRP_ATP_PUB.date_arr,
7593: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
7594: p_atf_date IN DATE,
7595: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
7596: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,

Line 7593: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,

7589: +----------------------------------------------------------------------------*/
7590: PROCEDURE PF_Atp_Alloc_Consume(
7591: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
7592: p_atp_period IN MRP_ATP_PUB.date_arr,
7593: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
7594: p_atf_date IN DATE,
7595: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
7596: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
7597: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,

Line 7595: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,

7591: p_atp_qty IN OUT NOCOPY MRP_ATP_PUB.number_arr,
7592: p_atp_period IN MRP_ATP_PUB.date_arr,
7593: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
7594: p_atf_date IN DATE,
7595: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
7596: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
7597: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
7598: x_return_status OUT NOCOPY VARCHAR2
7599: )

Line 7596: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,

7592: p_atp_period IN MRP_ATP_PUB.date_arr,
7593: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
7594: p_atf_date IN DATE,
7595: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
7596: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
7597: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
7598: x_return_status OUT NOCOPY VARCHAR2
7599: )
7600: IS

Line 7597: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,

7593: p_atp_dc_tab IN MRP_ATP_PUB.char80_arr,
7594: p_atf_date IN DATE,
7595: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
7596: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
7597: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
7598: x_return_status OUT NOCOPY VARCHAR2
7599: )
7600: IS
7601: i NUMBER;

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

7610:
7611: -- Initializing API return code
7612: x_return_status := FND_API.G_RET_STS_SUCCESS;
7613:
7614: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();
7615: x_dc_start_index := MRP_ATP_PUB.Number_Arr();
7616: x_dc_end_index := MRP_ATP_PUB.Number_Arr();
7617:
7618: x_dc_list_tab.EXTEND;

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

7611: -- Initializing API return code
7612: x_return_status := FND_API.G_RET_STS_SUCCESS;
7613:
7614: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();
7615: x_dc_start_index := MRP_ATP_PUB.Number_Arr();
7616: x_dc_end_index := MRP_ATP_PUB.Number_Arr();
7617:
7618: x_dc_list_tab.EXTEND;
7619: x_dc_start_index.EXTEND;

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

7612: x_return_status := FND_API.G_RET_STS_SUCCESS;
7613:
7614: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();
7615: x_dc_start_index := MRP_ATP_PUB.Number_Arr();
7616: x_dc_end_index := MRP_ATP_PUB.Number_Arr();
7617:
7618: x_dc_list_tab.EXTEND;
7619: x_dc_start_index.EXTEND;
7620: x_dc_end_index.EXTEND;

Line 7784: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

7780: | Original_Demand_Quantity column.
7781: | o For Total_Bucketed_Demand_Quantity all demands are looked at.
7782: +-------------------------------------------------------------------------*/
7783: PROCEDURE Get_Period_Data_From_Sd_Temp(
7784: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
7785: x_return_status OUT NOCOPY VARCHAR2
7786: ) IS
7787: i NUMBER;
7788: j NUMBER;

Line 7937: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

7933: | o This is similar to previous procedure only difference being that we
7934: | also return unallocated quantities.
7935: +-------------------------------------------------------------------------*/
7936: PROCEDURE Get_Unalloc_Data_From_Sd_Temp(
7937: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
7938: p_unallocated_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info,
7939: x_return_status OUT NOCOPY VARCHAR2
7940: ) IS
7941: i NUMBER;

Line 8103: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

8099: p_scenario_id IN NUMBER,
8100: p_level_id IN NUMBER,
8101: p_record_type IN PLS_INTEGER,
8102: p_session_id IN NUMBER,
8103: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
8104: x_return_status OUT NOCOPY VARCHAR2
8105: ) IS
8106:
8107: BEGIN

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

8868: x_return_status OUT NOCOPY VARCHAR2
8869: ) IS
8870: -- local variables
8871: --bug3663487 start
8872: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8873: l_sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8874: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8875: l_atf_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();
8876: j NUMBER;

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

8869: ) IS
8870: -- local variables
8871: --bug3663487 start
8872: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8873: l_sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8874: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8875: l_atf_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();
8876: j NUMBER;
8877: k NUMBER;

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

8870: -- local variables
8871: --bug3663487 start
8872: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8873: l_sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8874: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8875: l_atf_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();
8876: j NUMBER;
8877: k NUMBER;
8878: --bug3663487 end

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

8871: --bug3663487 start
8872: l_organization_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8873: l_sr_instance_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8874: l_inventory_item_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8875: l_atf_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();
8876: j NUMBER;
8877: k NUMBER;
8878: --bug3663487 end
8879:

Line 9219: atp_summ_tab MRP_ATP_PUB.char30_arr :=

9215: l_sql_stmt_1 VARCHAR2(16000);
9216: l_table_name VARCHAR2(30);
9217: l_tbspace VARCHAR2(30);
9218: l_temp_table VARCHAR2(30);
9219: atp_summ_tab MRP_ATP_PUB.char30_arr :=
9220: MRP_ATP_PUB.char30_arr(
9221: 'ALLOC_DEMANDS',
9222: 'ALLOC_SUPPLIES'
9223: );

Line 9220: MRP_ATP_PUB.char30_arr(

9216: l_table_name VARCHAR2(30);
9217: l_tbspace VARCHAR2(30);
9218: l_temp_table VARCHAR2(30);
9219: atp_summ_tab MRP_ATP_PUB.char30_arr :=
9220: MRP_ATP_PUB.char30_arr(
9221: 'ALLOC_DEMANDS',
9222: 'ALLOC_SUPPLIES'
9223: );
9224: l_plan_name varchar2(10);