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

Line 24: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

20: p_organization_id IN NUMBER,
21: p_plan_id IN NUMBER,
22: p_request_date IN DATE,
23: p_infinite_time_fence_date IN DATE,
24: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
25: p_dest_inv_item_id OUT NOCOPY NUMBER, -- For new allocation logic for time phased ATP
26: p_dest_family_item_id OUT NOCOPY NUMBER, -- For new allocation logic for time phased ATP
27: x_return_status OUT NOCOPY VARCHAR2);
28:

Line 35: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,

31: p_inventory_item_id IN NUMBER,
32: p_organization_id IN NUMBER,
33: p_instance_id IN NUMBER,
34: p_infinite_time_fence_date IN DATE,
35: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
36: p_plan_name IN VARCHAR2, -- bug 2771192
37: p_dest_inv_item_id IN NUMBER, -- For new allocation logic for time phased ATP
38: p_dest_family_item_id IN NUMBER, -- For new allocation logic for time phased ATP
39: x_return_status OUT NOCOPY VARCHAR2);

Line 42: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

38: p_dest_family_item_id IN NUMBER, -- For new allocation logic for time phased ATP
39: x_return_status OUT NOCOPY VARCHAR2);
40:
41: PROCEDURE Backward_Consume(
42: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
43: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
44: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
45: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
46: x_return_status OUT NOCOPY VARCHAR2);

Line 43: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,

39: x_return_status OUT NOCOPY VARCHAR2);
40:
41: PROCEDURE Backward_Consume(
42: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
43: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
44: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
45: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
46: x_return_status OUT NOCOPY VARCHAR2);
47:

Line 44: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,

40:
41: PROCEDURE Backward_Consume(
42: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
43: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
44: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
45: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
46: x_return_status OUT NOCOPY VARCHAR2);
47:
48: PROCEDURE Forward_Consume(

Line 45: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,

41: PROCEDURE Backward_Consume(
42: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
43: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
44: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
45: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
46: x_return_status OUT NOCOPY VARCHAR2);
47:
48: PROCEDURE Forward_Consume(
49: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

Line 49: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

45: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
46: x_return_status OUT NOCOPY VARCHAR2);
47:
48: PROCEDURE Forward_Consume(
49: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
50: p_start_index IN NUMBER,
51: p_end_index IN NUMBER,
52: x_return_status OUT NOCOPY VARCHAR2);
53:

Line 55: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

51: p_end_index IN NUMBER,
52: x_return_status OUT NOCOPY VARCHAR2);
53:
54: PROCEDURE Backward_Forward_Consume(
55: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
56: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
57: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
58: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
59: x_return_status OUT NOCOPY VARCHAR2);

Line 56: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,

52: x_return_status OUT NOCOPY VARCHAR2);
53:
54: PROCEDURE Backward_Forward_Consume(
55: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
56: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
57: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
58: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
59: x_return_status OUT NOCOPY VARCHAR2);
60:

Line 57: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,

53:
54: PROCEDURE Backward_Forward_Consume(
55: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
56: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
57: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
58: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
59: x_return_status OUT NOCOPY VARCHAR2);
60:
61: PROCEDURE Compute_Cum(

Line 58: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,

54: PROCEDURE Backward_Forward_Consume(
55: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
56: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
57: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
58: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
59: x_return_status OUT NOCOPY VARCHAR2);
60:
61: PROCEDURE Compute_Cum(
62: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

Line 62: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

58: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
59: x_return_status OUT NOCOPY VARCHAR2);
60:
61: PROCEDURE Compute_Cum(
62: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
63: p_dc_list_tab IN MRP_ATP_PUB.char80_arr,
64: p_dc_start_index IN MRP_ATP_PUB.number_arr,
65: p_dc_end_index IN MRP_ATP_PUB.number_arr,
66: x_return_status OUT NOCOPY VARCHAR2);

Line 63: p_dc_list_tab IN MRP_ATP_PUB.char80_arr,

59: x_return_status OUT NOCOPY VARCHAR2);
60:
61: PROCEDURE Compute_Cum(
62: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
63: p_dc_list_tab IN MRP_ATP_PUB.char80_arr,
64: p_dc_start_index IN MRP_ATP_PUB.number_arr,
65: p_dc_end_index IN MRP_ATP_PUB.number_arr,
66: x_return_status OUT NOCOPY VARCHAR2);
67:

Line 64: p_dc_start_index IN MRP_ATP_PUB.number_arr,

60:
61: PROCEDURE Compute_Cum(
62: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
63: p_dc_list_tab IN MRP_ATP_PUB.char80_arr,
64: p_dc_start_index IN MRP_ATP_PUB.number_arr,
65: p_dc_end_index IN MRP_ATP_PUB.number_arr,
66: x_return_status OUT NOCOPY VARCHAR2);
67:
68: PROCEDURE Adjust_Allocation_Details(

Line 65: p_dc_end_index IN MRP_ATP_PUB.number_arr,

61: PROCEDURE Compute_Cum(
62: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
63: p_dc_list_tab IN MRP_ATP_PUB.char80_arr,
64: p_dc_start_index IN MRP_ATP_PUB.number_arr,
65: p_dc_end_index IN MRP_ATP_PUB.number_arr,
66: x_return_status OUT NOCOPY VARCHAR2);
67:
68: PROCEDURE Adjust_Allocation_Details(
69: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

Line 69: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

65: p_dc_end_index IN MRP_ATP_PUB.number_arr,
66: x_return_status OUT NOCOPY VARCHAR2);
67:
68: PROCEDURE Adjust_Allocation_Details(
69: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
70: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
71: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
72: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
73: x_return_status OUT NOCOPY VARCHAR2);

Line 70: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,

66: x_return_status OUT NOCOPY VARCHAR2);
67:
68: PROCEDURE Adjust_Allocation_Details(
69: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
70: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
71: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
72: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
73: x_return_status OUT NOCOPY VARCHAR2);
74:

Line 71: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,

67:
68: PROCEDURE Adjust_Allocation_Details(
69: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
70: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
71: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
72: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
73: x_return_status OUT NOCOPY VARCHAR2);
74:
75: PROCEDURE Demand_Class_Consumption(

Line 72: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,

68: PROCEDURE Adjust_Allocation_Details(
69: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
70: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
71: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
72: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
73: x_return_status OUT NOCOPY VARCHAR2);
74:
75: PROCEDURE Demand_Class_Consumption(
76: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

Line 76: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

72: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
73: x_return_status OUT NOCOPY VARCHAR2);
74:
75: PROCEDURE Demand_Class_Consumption(
76: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
77: p_start_index IN number,
78: p_end_index IN number,
79: p_steal_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info,
80: x_return_status OUT NOCOPY VARCHAR2);

Line 83: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

79: p_steal_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info,
80: x_return_status OUT NOCOPY VARCHAR2);
81:
82: PROCEDURE Add_to_Next_Steal(
83: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
84: p_start_index IN number,
85: p_end_index IN number,
86: p_next_steal_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info,
87: x_return_status OUT NOCOPY VARCHAR2);

Line 90: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

86: p_next_steal_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info,
87: x_return_status OUT NOCOPY VARCHAR2);
88:
89: PROCEDURE Add_to_Current_Atp(
90: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
91: p_start_index IN number,
92: p_end_index IN number,
93: p_steal_atp IN MRP_ATP_PVT.ATP_Info,
94: x_return_status OUT NOCOPY VARCHAR2);

Line 97: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

93: p_steal_atp IN MRP_ATP_PVT.ATP_Info,
94: x_return_status OUT NOCOPY VARCHAR2);
95:
96: PROCEDURE Compute_Cum_Individual(
97: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
98: p_start_index IN NUMBER,
99: p_end_index IN NUMBER,
100: x_return_status OUT NOCOPY VARCHAR2);
101:

Line 103: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

99: p_end_index IN NUMBER,
100: x_return_status OUT NOCOPY VARCHAR2);
101:
102: PROCEDURE Remove_Negatives(
103: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
104: p_start_index IN NUMBER,
105: p_end_index IN NUMBER,
106: x_return_status OUT NOCOPY VARCHAR2);
107:

Line 109: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

105: p_end_index IN NUMBER,
106: x_return_status OUT NOCOPY VARCHAR2);
107:
108: PROCEDURE Adjust_Cum(
109: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
110: p_cur_start_index IN NUMBER,
111: p_cur_end_index IN NUMBER,
112: p_unalloc_start_index IN NUMBER,
113: p_unalloc_end_index IN NUMBER,

Line 139: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

135: -- local variables
136: l_request_date DATE;
137: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
138: l_infinite_time_fence_date DATE;
139: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
140: l_counter PLS_INTEGER;
141: l_return_status VARCHAR2(10) := FND_API.G_RET_STS_SUCCESS;
142:
143: -- For new allocation logic for time phased ATP

Line 350: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

346: p_organization_id IN NUMBER,
347: p_plan_id IN NUMBER,
348: p_request_date IN DATE,
349: p_infinite_time_fence_date IN DATE,
350: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
351: p_dest_inv_item_id OUT NOCOPY NUMBER, -- For new allocation logic for time phased ATP
352: p_dest_family_item_id OUT NOCOPY NUMBER, -- For new allocation logic for time phased ATP
353: x_return_status OUT NOCOPY VARCHAR2)
354: IS

Line 359: l_dc_list_tab MRP_ATP_PUB.char80_arr;

355: -- local variables
356: l_inv_item_id PLS_INTEGER;
357: l_inv_item_name MSC_SYSTEM_ITEMS.ITEM_NAME%TYPE;
358: l_uom_code VARCHAR2(3);
359: l_dc_list_tab MRP_ATP_PUB.char80_arr;
360: l_dc_start_index MRP_ATP_PUB.number_arr;
361: l_dc_end_index MRP_ATP_PUB.number_arr;
362: l_index_counter PLS_INTEGER;
363: l_start_index PLS_INTEGER;

Line 360: l_dc_start_index MRP_ATP_PUB.number_arr;

356: l_inv_item_id PLS_INTEGER;
357: l_inv_item_name MSC_SYSTEM_ITEMS.ITEM_NAME%TYPE;
358: l_uom_code VARCHAR2(3);
359: l_dc_list_tab MRP_ATP_PUB.char80_arr;
360: l_dc_start_index MRP_ATP_PUB.number_arr;
361: l_dc_end_index MRP_ATP_PUB.number_arr;
362: l_index_counter PLS_INTEGER;
363: l_start_index PLS_INTEGER;
364: l_end_index PLS_INTEGER;

Line 361: l_dc_end_index MRP_ATP_PUB.number_arr;

357: l_inv_item_name MSC_SYSTEM_ITEMS.ITEM_NAME%TYPE;
358: l_uom_code VARCHAR2(3);
359: l_dc_list_tab MRP_ATP_PUB.char80_arr;
360: l_dc_start_index MRP_ATP_PUB.number_arr;
361: l_dc_end_index MRP_ATP_PUB.number_arr;
362: l_index_counter PLS_INTEGER;
363: l_start_index PLS_INTEGER;
364: l_end_index PLS_INTEGER;
365: l_period_counter PLS_INTEGER;

Line 378: l_class_tab MRP_ATP_PUB.char80_arr;

374: l_level_id PLS_INTEGER;
375: l_return_status VARCHAR2(1);
376: -- bug 2763784 (ssurendr)
377: -- Should not error out if no s/d record found
378: l_class_tab MRP_ATP_PUB.char80_arr;
379: l_customer_id_tab MRP_ATP_PUB.number_arr;
380: l_customer_site_id_tab MRP_ATP_PUB.number_arr;
381: -- rajjain 02/19/2003 Bug 2806076
382: l_all_dc_list_tab MRP_ATP_PUB.char80_arr;

Line 379: l_customer_id_tab MRP_ATP_PUB.number_arr;

375: l_return_status VARCHAR2(1);
376: -- bug 2763784 (ssurendr)
377: -- Should not error out if no s/d record found
378: l_class_tab MRP_ATP_PUB.char80_arr;
379: l_customer_id_tab MRP_ATP_PUB.number_arr;
380: l_customer_site_id_tab MRP_ATP_PUB.number_arr;
381: -- rajjain 02/19/2003 Bug 2806076
382: l_all_dc_list_tab MRP_ATP_PUB.char80_arr;
383: -- bug 2813095 (ssurendr)

Line 380: l_customer_site_id_tab MRP_ATP_PUB.number_arr;

376: -- bug 2763784 (ssurendr)
377: -- Should not error out if no s/d record found
378: l_class_tab MRP_ATP_PUB.char80_arr;
379: l_customer_id_tab MRP_ATP_PUB.number_arr;
380: l_customer_site_id_tab MRP_ATP_PUB.number_arr;
381: -- rajjain 02/19/2003 Bug 2806076
382: l_all_dc_list_tab MRP_ATP_PUB.char80_arr;
383: -- bug 2813095 (ssurendr)
384: l_atp_flag VARCHAR2(1);

Line 382: l_all_dc_list_tab MRP_ATP_PUB.char80_arr;

378: l_class_tab MRP_ATP_PUB.char80_arr;
379: l_customer_id_tab MRP_ATP_PUB.number_arr;
380: l_customer_site_id_tab MRP_ATP_PUB.number_arr;
381: -- rajjain 02/19/2003 Bug 2806076
382: l_all_dc_list_tab MRP_ATP_PUB.char80_arr;
383: -- bug 2813095 (ssurendr)
384: l_atp_flag VARCHAR2(1);
385: -- time_phased_atp
386: l_time_phased_atp VARCHAR2(1) := 'N';

Line 3011: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,

3007: p_inventory_item_id IN NUMBER,
3008: p_organization_id IN NUMBER,
3009: p_instance_id IN NUMBER,
3010: p_infinite_time_fence_date IN DATE,
3011: p_atp_period IN MRP_ATP_PUB.ATP_Period_Typ,
3012: p_plan_name IN VARCHAR2, -- bug 2771192
3013: p_dest_inv_item_id IN NUMBER, -- For new allocation logic for time phased ATP
3014: p_dest_family_item_id IN NUMBER, -- For new allocation logic for time phased ATP
3015: x_return_status OUT NOCOPY VARCHAR2)

Line 4424: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

4420: /*--Backward_Consume-------------------------------------------------------
4421: | o Does backward consumption.
4422: +-------------------------------------------------------------------------*/
4423: PROCEDURE Backward_Consume(
4424: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4425: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
4426: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4427: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4428: x_return_status OUT NOCOPY VARCHAR2)

Line 4425: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,

4421: | o Does backward consumption.
4422: +-------------------------------------------------------------------------*/
4423: PROCEDURE Backward_Consume(
4424: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4425: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
4426: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4427: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4428: x_return_status OUT NOCOPY VARCHAR2)
4429: IS

Line 4426: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,

4422: +-------------------------------------------------------------------------*/
4423: PROCEDURE Backward_Consume(
4424: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4425: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
4426: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4427: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4428: x_return_status OUT NOCOPY VARCHAR2)
4429: IS
4430: i PLS_INTEGER;

Line 4427: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,

4423: PROCEDURE Backward_Consume(
4424: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4425: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
4426: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4427: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4428: x_return_status OUT NOCOPY VARCHAR2)
4429: IS
4430: i PLS_INTEGER;
4431: j PLS_INTEGER;

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

4439:
4440: -- Initializing API return code
4441: x_return_status := FND_API.G_RET_STS_SUCCESS;
4442:
4443: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();
4444: x_dc_start_index := MRP_ATP_PUB.Number_Arr();
4445: x_dc_end_index := MRP_ATP_PUB.Number_Arr();
4446:
4447: x_dc_list_tab.EXTEND;

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

4440: -- Initializing API return code
4441: x_return_status := FND_API.G_RET_STS_SUCCESS;
4442:
4443: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();
4444: x_dc_start_index := MRP_ATP_PUB.Number_Arr();
4445: x_dc_end_index := MRP_ATP_PUB.Number_Arr();
4446:
4447: x_dc_list_tab.EXTEND;
4448: x_dc_start_index.EXTEND;

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

4441: x_return_status := FND_API.G_RET_STS_SUCCESS;
4442:
4443: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();
4444: x_dc_start_index := MRP_ATP_PUB.Number_Arr();
4445: x_dc_end_index := MRP_ATP_PUB.Number_Arr();
4446:
4447: x_dc_list_tab.EXTEND;
4448: x_dc_start_index.EXTEND;
4449: x_dc_end_index.EXTEND;

Line 4534: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

4530: /*--Forward_Consume--------------------------------------------------------
4531: | o Does forward consumption.
4532: +-------------------------------------------------------------------------*/
4533: PROCEDURE Forward_Consume(
4534: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4535: p_start_index IN NUMBER,
4536: p_end_index IN NUMBER,
4537: x_return_status OUT NOCOPY VARCHAR2)
4538: IS

Line 4643: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

4639: | o Does backward/forward consumption.
4640: | o Used in demand priority case.
4641: +-------------------------------------------------------------------------*/
4642: PROCEDURE Backward_Forward_Consume(
4643: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4644: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
4645: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4646: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4647: x_return_status OUT NOCOPY VARCHAR2)

Line 4644: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,

4640: | o Used in demand priority case.
4641: +-------------------------------------------------------------------------*/
4642: PROCEDURE Backward_Forward_Consume(
4643: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4644: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
4645: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4646: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4647: x_return_status OUT NOCOPY VARCHAR2)
4648: IS

Line 4645: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,

4641: +-------------------------------------------------------------------------*/
4642: PROCEDURE Backward_Forward_Consume(
4643: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4644: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
4645: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4646: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4647: x_return_status OUT NOCOPY VARCHAR2)
4648: IS
4649: i PLS_INTEGER;

Line 4646: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,

4642: PROCEDURE Backward_Forward_Consume(
4643: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4644: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
4645: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4646: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4647: x_return_status OUT NOCOPY VARCHAR2)
4648: IS
4649: i PLS_INTEGER;
4650: j PLS_INTEGER;

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

4659:
4660: -- Initializing API return code
4661: x_return_status := FND_API.G_RET_STS_SUCCESS;
4662:
4663: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();
4664: x_dc_start_index := MRP_ATP_PUB.Number_Arr();
4665: x_dc_end_index := MRP_ATP_PUB.Number_Arr();
4666:
4667: x_dc_list_tab.EXTEND;

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

4660: -- Initializing API return code
4661: x_return_status := FND_API.G_RET_STS_SUCCESS;
4662:
4663: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();
4664: x_dc_start_index := MRP_ATP_PUB.Number_Arr();
4665: x_dc_end_index := MRP_ATP_PUB.Number_Arr();
4666:
4667: x_dc_list_tab.EXTEND;
4668: x_dc_start_index.EXTEND;

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

4661: x_return_status := FND_API.G_RET_STS_SUCCESS;
4662:
4663: x_dc_list_tab := MRP_ATP_PUB.Char80_Arr();
4664: x_dc_start_index := MRP_ATP_PUB.Number_Arr();
4665: x_dc_end_index := MRP_ATP_PUB.Number_Arr();
4666:
4667: x_dc_list_tab.EXTEND;
4668: x_dc_start_index.EXTEND;
4669: x_dc_end_index.EXTEND;

Line 4825: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

4821: /*--Compute_Cum------------------------------------------------------------
4822: | o Does accumulation for all demand classes.
4823: +-------------------------------------------------------------------------*/
4824: PROCEDURE Compute_Cum(
4825: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4826: p_dc_list_tab IN MRP_ATP_PUB.char80_arr,
4827: p_dc_start_index IN MRP_ATP_PUB.number_arr,
4828: p_dc_end_index IN MRP_ATP_PUB.number_arr,
4829: x_return_status OUT NOCOPY VARCHAR2)

Line 4826: p_dc_list_tab IN MRP_ATP_PUB.char80_arr,

4822: | o Does accumulation for all demand classes.
4823: +-------------------------------------------------------------------------*/
4824: PROCEDURE Compute_Cum(
4825: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4826: p_dc_list_tab IN MRP_ATP_PUB.char80_arr,
4827: p_dc_start_index IN MRP_ATP_PUB.number_arr,
4828: p_dc_end_index IN MRP_ATP_PUB.number_arr,
4829: x_return_status OUT NOCOPY VARCHAR2)
4830: IS

Line 4827: p_dc_start_index IN MRP_ATP_PUB.number_arr,

4823: +-------------------------------------------------------------------------*/
4824: PROCEDURE Compute_Cum(
4825: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4826: p_dc_list_tab IN MRP_ATP_PUB.char80_arr,
4827: p_dc_start_index IN MRP_ATP_PUB.number_arr,
4828: p_dc_end_index IN MRP_ATP_PUB.number_arr,
4829: x_return_status OUT NOCOPY VARCHAR2)
4830: IS
4831: i PLS_INTEGER;

Line 4828: p_dc_end_index IN MRP_ATP_PUB.number_arr,

4824: PROCEDURE Compute_Cum(
4825: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4826: p_dc_list_tab IN MRP_ATP_PUB.char80_arr,
4827: p_dc_start_index IN MRP_ATP_PUB.number_arr,
4828: p_dc_end_index IN MRP_ATP_PUB.number_arr,
4829: x_return_status OUT NOCOPY VARCHAR2)
4830: IS
4831: i PLS_INTEGER;
4832: j PLS_INTEGER;

Line 4869: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

4865: /*--Compute_Cum------------------------------------------------------------
4866: | o Does accumulation for a specific demand class.
4867: +-------------------------------------------------------------------------*/
4868: PROCEDURE Compute_Cum_Individual(
4869: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4870: p_start_index IN NUMBER,
4871: p_end_index IN NUMBER,
4872: x_return_status OUT NOCOPY VARCHAR2)
4873: IS

Line 4921: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

4917: | o Called by Compute_Allocation_Details only for rule based case.
4918: | o Performs demand class consumption and forward consumption.
4919: +-------------------------------------------------------------------------*/
4920: PROCEDURE Adjust_Allocation_Details(
4921: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4922: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
4923: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4924: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4925: x_return_status OUT NOCOPY VARCHAR2)

Line 4922: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,

4918: | o Performs demand class consumption and forward consumption.
4919: +-------------------------------------------------------------------------*/
4920: PROCEDURE Adjust_Allocation_Details(
4921: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4922: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
4923: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4924: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4925: x_return_status OUT NOCOPY VARCHAR2)
4926: IS

Line 4923: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,

4919: +-------------------------------------------------------------------------*/
4920: PROCEDURE Adjust_Allocation_Details(
4921: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4922: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
4923: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4924: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4925: x_return_status OUT NOCOPY VARCHAR2)
4926: IS
4927: l_return_status VARCHAR2(1);

Line 4924: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,

4920: PROCEDURE Adjust_Allocation_Details(
4921: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4922: x_dc_list_tab OUT NOCOPY MRP_ATP_PUB.char80_arr,
4923: x_dc_start_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4924: x_dc_end_index OUT NOCOPY MRP_ATP_PUB.number_arr,
4925: x_return_status OUT NOCOPY VARCHAR2)
4926: IS
4927: l_return_status VARCHAR2(1);
4928: l_lowest_priority_demand_class VARCHAR2(80);

Line 4937: l_fw_consume_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

4933: l_dc_count PLS_INTEGER;
4934: l_fw_consume_next PLS_INTEGER := 0;
4935: l_lowest_cust_priority PLS_INTEGER;
4936: l_lowest_site_priority PLS_INTEGER;
4937: l_fw_consume_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
4938: l_class_curr_steal_atp MRP_ATP_PVT.ATP_Info;
4939: l_class_next_steal_atp MRP_ATP_PVT.ATP_Info;
4940: l_partner_curr_steal_atp MRP_ATP_PVT.ATP_Info;
4941: l_partner_next_steal_atp MRP_ATP_PVT.ATP_Info;

Line 5666: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

5662: /*--Demand_Class_Consumption-----------------------------------------------
5663: | o Performs demand class consumption.
5664: +-------------------------------------------------------------------------*/
5665: PROCEDURE Demand_Class_Consumption(
5666: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
5667: p_start_index IN number,
5668: p_end_index IN number,
5669: p_steal_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info,
5670: x_return_status OUT NOCOPY VARCHAR2)

Line 5822: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

5818: | o Same as MSC_AATP_PVT.Add_to_Next_Steal_Atp except for the input
5819: | parameters.
5820: +-------------------------------------------------------------------------*/
5821: PROCEDURE Add_to_Next_Steal(
5822: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
5823: p_start_index IN number,
5824: p_end_index IN number,
5825: p_next_steal_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info,
5826: x_return_status OUT NOCOPY VARCHAR2)

Line 5980: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

5976: | o Same as MSC_AATP_PROC.Add_to_current_atp except for the input
5977: | parameters.
5978: +-------------------------------------------------------------------------*/
5979: PROCEDURE Add_to_Current_Atp(
5980: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
5981: p_start_index IN number,
5982: p_end_index IN number,
5983: p_steal_atp IN MRP_ATP_PVT.ATP_Info,
5984: x_return_status OUT NOCOPY VARCHAR2)

Line 6051: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

6047: | o Same as MSC_AATP_PROC.Atp_Remove_Negatives except for the input
6048: | parameters.
6049: +-------------------------------------------------------------------------*/
6050: PROCEDURE Remove_Negatives(
6051: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
6052: p_start_index IN NUMBER,
6053: p_end_index IN NUMBER,
6054: x_return_status OUT NOCOPY VARCHAR2)
6055: IS

Line 6092: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

6088: | o Same as MSC_AATP_PROC.Atp_Adjusted_Cum except for the input
6089: | parameters.
6090: +-------------------------------------------------------------------------*/
6091: PROCEDURE Adjust_Cum(
6092: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
6093: p_cur_start_index IN NUMBER,
6094: p_cur_end_index IN NUMBER,
6095: p_unalloc_start_index IN NUMBER,
6096: p_unalloc_end_index IN NUMBER,