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

Line 51: G_OFF_INSTANCE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191

47:
48: -- For summary enhancement
49: G_TIME_PHASED_SET VARCHAR2(1);
50:
51: G_OFF_INSTANCE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
52: G_OFF_DEM_TRANS_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
53: G_OFF_PLAN_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
54:
55: Procedure Schedule (p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

Line 52: G_OFF_DEM_TRANS_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191

48: -- For summary enhancement
49: G_TIME_PHASED_SET VARCHAR2(1);
50:
51: G_OFF_INSTANCE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
52: G_OFF_DEM_TRANS_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
53: G_OFF_PLAN_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
54:
55: Procedure Schedule (p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
56: p_instance_id IN NUMBER,

Line 53: G_OFF_PLAN_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191

49: G_TIME_PHASED_SET VARCHAR2(1);
50:
51: G_OFF_INSTANCE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
52: G_OFF_DEM_TRANS_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
53: G_OFF_PLAN_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
54:
55: Procedure Schedule (p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
56: p_instance_id IN NUMBER,
57: p_assign_set_id IN NUMBER,

Line 55: Procedure Schedule (p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

51: G_OFF_INSTANCE_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
52: G_OFF_DEM_TRANS_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
53: G_OFF_PLAN_ID MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); --Bug 3629191
54:
55: Procedure Schedule (p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
56: p_instance_id IN NUMBER,
57: p_assign_set_id IN NUMBER,
58: p_refresh_number IN NUMBER,
59: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

Line 59: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

55: Procedure Schedule (p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
56: p_instance_id IN NUMBER,
57: p_assign_set_id IN NUMBER,
58: p_refresh_number IN NUMBER,
59: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
60: x_return_status OUT NoCopy VARCHAR2,
61: x_msg_data OUT NoCopy VARCHAR2,
62: x_msg_count OUT NoCopy NUMBER,
63: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

Line 63: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

59: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
60: x_return_status OUT NoCopy VARCHAR2,
61: x_msg_data OUT NoCopy VARCHAR2,
62: x_msg_count OUT NoCopy NUMBER,
63: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
64: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
65: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
66: ) IS
67:

Line 64: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

60: x_return_status OUT NoCopy VARCHAR2,
61: x_msg_data OUT NoCopy VARCHAR2,
62: x_msg_count OUT NoCopy NUMBER,
63: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
64: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
65: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
66: ) IS
67:
68: i PLS_INTEGER := 1;

Line 65: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ

61: x_msg_data OUT NoCopy VARCHAR2,
62: x_msg_count OUT NoCopy NUMBER,
63: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
64: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
65: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
66: ) IS
67:
68: i PLS_INTEGER := 1;
69: j PLS_INTEGER := 1;

Line 78: l_old_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); -- this is for ship set items

74: l_temp NUMBER;
75: l_plan_id NUMBER;
76: l_temp_plan_id NUMBER; -- this is for ship set items
77: --Bug 1661545, array to store old plan id for undoing unscheduling in case of failure.
78: l_old_plan_id MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr(); -- this is for ship set items
79: l_process_item_id NUMBER;
80: l_process_org_id NUMBER;
81: l_ship_count NUMBER;
82: l_arrival_count NUMBER;

Line 100: l_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

96: l_process_arrival_set VARCHAR2(30) := '@@@';
97: l_sources MRP_ATP_PVT.Atp_Source_Typ;
98: l_atp_rec MRP_ATP_PVT.AtpRec;
99: l_future_atp_rec MRP_ATP_PVT.AtpRec;
100: l_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
101: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
102: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
103: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
104: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 101: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

97: l_sources MRP_ATP_PVT.Atp_Source_Typ;
98: l_atp_rec MRP_ATP_PVT.AtpRec;
99: l_future_atp_rec MRP_ATP_PVT.AtpRec;
100: l_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
101: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
102: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
103: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
104: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
105: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 102: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

98: l_atp_rec MRP_ATP_PVT.AtpRec;
99: l_future_atp_rec MRP_ATP_PVT.AtpRec;
100: l_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
101: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
102: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
103: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
104: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
105: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
106: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

Line 103: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;

99: l_future_atp_rec MRP_ATP_PVT.AtpRec;
100: l_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
101: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
102: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
103: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
104: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
105: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
106: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
107: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 104: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

100: l_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
101: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
102: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
103: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
104: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
105: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
106: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
107: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
108: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 105: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

101: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
102: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
103: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
104: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
105: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
106: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
107: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
108: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
109: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 106: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

102: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
103: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
104: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
105: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
106: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
107: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
108: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
109: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;
110: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

Line 107: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;

103: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
104: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
105: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
106: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
107: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
108: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
109: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;
110: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
111: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 108: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

104: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
105: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
106: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
107: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
108: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
109: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;
110: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
111: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
112: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 109: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;

105: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
106: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
107: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
108: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
109: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;
110: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
111: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
112: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
113: l_temp_arr_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 110: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

106: l_temp_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
107: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
108: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
109: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;
110: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
111: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
112: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
113: l_temp_arr_atp_details MRP_ATP_PUB.ATP_Details_Typ;
114: l_curr_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 111: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;

107: l_temp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
108: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
109: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;
110: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
111: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
112: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
113: l_temp_arr_atp_details MRP_ATP_PUB.ATP_Details_Typ;
114: l_curr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
115: l_curr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 112: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

108: l_temp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
109: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;
110: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
111: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
112: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
113: l_temp_arr_atp_details MRP_ATP_PUB.ATP_Details_Typ;
114: l_curr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
115: l_curr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
116: l_complete_scatp VARCHAR2(1) := 'N';

Line 113: l_temp_arr_atp_details MRP_ATP_PUB.ATP_Details_Typ;

109: l_temp_atp_details MRP_ATP_PUB.ATP_Details_Typ;
110: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
111: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
112: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
113: l_temp_arr_atp_details MRP_ATP_PUB.ATP_Details_Typ;
114: l_curr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
115: l_curr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
116: l_complete_scatp VARCHAR2(1) := 'N';
117: l_multi_scenario NUMBER;

Line 114: l_curr_atp_period MRP_ATP_PUB.ATP_Period_Typ;

110: l_temp_arr_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
111: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
112: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
113: l_temp_arr_atp_details MRP_ATP_PUB.ATP_Details_Typ;
114: l_curr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
115: l_curr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
116: l_complete_scatp VARCHAR2(1) := 'N';
117: l_multi_scenario NUMBER;
118: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 115: l_curr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

111: l_temp_arr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
112: l_temp_arr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
113: l_temp_arr_atp_details MRP_ATP_PUB.ATP_Details_Typ;
114: l_curr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
115: l_curr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
116: l_complete_scatp VARCHAR2(1) := 'N';
117: l_multi_scenario NUMBER;
118: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
119: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 118: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;

114: l_curr_atp_period MRP_ATP_PUB.ATP_Period_Typ;
115: l_curr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
116: l_complete_scatp VARCHAR2(1) := 'N';
117: l_multi_scenario NUMBER;
118: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
119: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
120: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;
121: l_set_element_success PLS_INTEGER;
122: l_oe_demand_flag VARCHAR2(1) := 'N';

Line 119: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

115: l_curr_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
116: l_complete_scatp VARCHAR2(1) := 'N';
117: l_multi_scenario NUMBER;
118: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
119: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
120: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;
121: l_set_element_success PLS_INTEGER;
122: l_oe_demand_flag VARCHAR2(1) := 'N';
123: my_sqlcode NUMBER;

Line 120: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;

116: l_complete_scatp VARCHAR2(1) := 'N';
117: l_multi_scenario NUMBER;
118: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
119: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
120: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;
121: l_set_element_success PLS_INTEGER;
122: l_oe_demand_flag VARCHAR2(1) := 'N';
123: my_sqlcode NUMBER;
124: temp NUMBER;

Line 140: l_fst_src_pegging_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

136: l_default_demand_class VARCHAR2(34);
137: l_sd_qty NUMBER;
138: l_inv_item_id NUMBER;
139: --l_ship_date DATE; -- ship_rec_cal changes
140: l_fst_src_pegging_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
141: l_date_higher_src varchar2(1) := 'Y';
142: l_peg_count NUMBER;
143: l_dblink VARCHAR2(128);
144: l_sys_next_date DATE;

Line 161: l_pf_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

157: l_summary_flag number;
158: -- Bug 2085071: Assignment Set
159: lv_assign_set_id NUMBER;
160: --2152184
161: l_pf_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
162: --l_old_org_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
163:
164: ---subst
165: l_item_substitute_rec MSC_ATP_SUBST.Item_Info_Rec_Typ;

Line 162: --l_old_org_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

158: -- Bug 2085071: Assignment Set
159: lv_assign_set_id NUMBER;
160: --2152184
161: l_pf_item_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
162: --l_old_org_id MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
163:
164: ---subst
165: l_item_substitute_rec MSC_ATP_SUBST.Item_Info_Rec_Typ;
166: l_null_item_sub_rec MSC_ATP_SUBST.Item_Info_Rec_Typ;

Line 180: l_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

176: L_DELIVERY_LEAD_TIME number;
177: L_REQUESTED_SHIP_DATE date;
178: L_FROM_LOCATION_ID number;
179: L_SHIP_METHOD varchar2(50);
180: l_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
181: l_old_pf_item_id number;
182: l_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
183:
184: l_org_code VARCHAR2(7);

Line 182: l_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

178: L_FROM_LOCATION_ID number;
179: L_SHIP_METHOD varchar2(50);
180: l_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
181: l_old_pf_item_id number;
182: l_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
183:
184: l_org_code VARCHAR2(7);
185: l_counter NUMBER; -- defined for Bug 2368426
186:

Line 197: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

193: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
194: l_bkwd_pass_atf_date_qty NUMBER; --bug3397904
195:
196: --bug 2384224
197: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
198: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
199: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
200: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
201: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro

Line 198: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

194: l_bkwd_pass_atf_date_qty NUMBER; --bug3397904
195:
196: --bug 2384224
197: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
198: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
199: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
200: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
201: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
202: l_delete_demand_flag PLS_INTEGER;

Line 199: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

195:
196: --bug 2384224
197: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
198: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
199: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
200: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
201: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
202: l_delete_demand_flag PLS_INTEGER;
203:

Line 200: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

196: --bug 2384224
197: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
198: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
199: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
200: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
201: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
202: l_delete_demand_flag PLS_INTEGER;
203:
204: --diag_atp

Line 201: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro

197: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
198: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
199: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
200: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
201: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
202: l_delete_demand_flag PLS_INTEGER;
203:
204: --diag_atp
205: l_pegging_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

Line 205: l_pegging_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();

201: l_del_demand_source_type MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();--cmro
202: l_delete_demand_flag PLS_INTEGER;
203:
204: --diag_atp
205: l_pegging_ids MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
206: l_highest_rev NUMBER;
207:
208: -- ATP Override rajjain begin
209: l_latest_acceptable_date DATE;

Line 229: l_req_atp_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();

225: -- bug 2795053-reopen (ssurendr)
226: l_dmd_satisfied_date DATE;
227:
228: -- 2902265
229: l_req_atp_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();
230: l_req_date_qty mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
231: l_demand_class_atp_flag mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
232:
233: --s_cto_rearch

Line 230: l_req_date_qty mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();

226: l_dmd_satisfied_date DATE;
227:
228: -- 2902265
229: l_req_atp_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();
230: l_req_date_qty mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
231: l_demand_class_atp_flag mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
232:
233: --s_cto_rearch
234: l_item_sourcing_info_rec MSC_ATP_CTO.item_sourcing_info_rec;

Line 231: l_demand_class_atp_flag mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();

227:
228: -- 2902265
229: l_req_atp_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();
230: l_req_date_qty mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
231: l_demand_class_atp_flag mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
232:
233: --s_cto_rearch
234: l_item_sourcing_info_rec MSC_ATP_CTO.item_sourcing_info_rec;
235:

Line 245: l_atf_dates MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();

241: l_pf_atp VARCHAR2(1) := 'N';
242: l_time_phased_atp VARCHAR2(1) := 'N';
243: l_atf_date DATE;
244: l_time_phased_set VARCHAR2(1) := 'N';
245: l_atf_dates MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
246: l_match_item_family_id NUMBER;
247:
248: -- For summary enhancement
249: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();

Line 249: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();

245: l_atf_dates MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
246: l_match_item_family_id NUMBER;
247:
248: -- For summary enhancement
249: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
250: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
251: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
252:
253:

Line 250: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();

246: l_match_item_family_id NUMBER;
247:
248: -- For summary enhancement
249: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
250: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
251: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
252:
253:
254: -- CTO ODR and Simplified Pegging

Line 251: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();

247:
248: -- For summary enhancement
249: l_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
250: l_del_copy_demand_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
251: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
252:
253:
254: -- CTO ODR and Simplified Pegging
255: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;

Line 255: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;

251: l_del_copy_demand_plan_ids mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
252:
253:
254: -- CTO ODR and Simplified Pegging
255: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
256: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
257: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
258: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
259: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191

Line 256: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;

252:
253:
254: -- CTO ODR and Simplified Pegging
255: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
256: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
257: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
258: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
259: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
260: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191

Line 257: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;

253:
254: -- CTO ODR and Simplified Pegging
255: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
256: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
257: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
258: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
259: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
260: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
261: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191

Line 258: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;

254: -- CTO ODR and Simplified Pegging
255: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
256: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
257: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
258: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
259: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
260: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
261: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
262: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 259: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191

255: l_atp_peg_items MRP_ATP_PUB.Number_Arr ;
256: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
257: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
258: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
259: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
260: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
261: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
262: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
263: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 260: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191

256: l_atp_peg_demands MRP_ATP_PUB.Number_Arr ;
257: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
258: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
259: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
260: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
261: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
262: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
263: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
264: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 261: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191

257: l_atp_peg_supplies MRP_ATP_PUB.Number_Arr ;
258: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
259: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
260: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
261: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
262: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
263: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
264: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
265: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

Line 262: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

258: l_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr ;
259: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
260: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
261: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
262: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
263: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
264: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
265: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
266: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

Line 263: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

259: l_demand_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
260: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
261: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
262: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
263: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
264: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
265: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
266: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
267: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

Line 264: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

260: l_supply_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
261: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
262: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
263: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
264: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
265: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
266: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
267: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
268: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

Line 265: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

261: l_res_instance_id MRP_ATP_PUB.Number_Arr ; --Bug 3629191
262: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
263: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
264: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
265: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
266: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
267: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
268: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
269: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

Line 266: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

262: l_del_atp_peg_items MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
263: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
264: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
265: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
266: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
267: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
268: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
269: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
270: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

Line 267: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

263: l_del_atp_peg_demands MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
264: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
265: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
266: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
267: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
268: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
269: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
270: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
271: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

Line 268: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

264: l_del_atp_peg_supplies MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
265: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
266: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
267: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
268: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
269: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
270: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
271: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
272: -- END CTO ODR and Simplified Pegging

Line 269: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

265: l_del_atp_peg_res_reqs MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
266: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
267: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
268: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
269: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
270: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
271: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
272: -- END CTO ODR and Simplified Pegging
273: --plan by request date enhancment

Line 270: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

266: l_atp_peg_demands_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
267: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
268: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
269: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
270: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
271: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
272: -- END CTO ODR and Simplified Pegging
273: --plan by request date enhancment
274: l_original_req_arrival_date DATE;

Line 271: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191

267: l_atp_peg_supplies_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
268: l_atp_peg_res_reqs_plan_ids MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
269: l_off_demand_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
270: l_off_supply_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
271: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
272: -- END CTO ODR and Simplified Pegging
273: --plan by request date enhancment
274: l_original_req_arrival_date DATE;
275: l_req_arr_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();

Line 275: l_req_arr_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();

271: l_off_res_instance_id MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr(); --Bug 3629191
272: -- END CTO ODR and Simplified Pegging
273: --plan by request date enhancment
274: l_original_req_arrival_date DATE;
275: l_req_arr_date mrp_atp_pub.date_arr := mrp_atp_pub.date_arr();
276: -- ship_rec_cal changes
277: l_shipping_cal_code VARCHAR2(14);
278: l_receiving_cal_code VARCHAR2(14);
279: l_manufacturing_cal_code VARCHAR2(14);

Line 1054: --MRP_ATP_PUB.number_arr(NULL),

1050: p_atp_table.Customer_Site_Id(k),
1051: l_assign_set_id,
1052: --s_cto_rearch
1053: l_item_sourcing_info_rec,
1054: --MRP_ATP_PUB.number_arr(NULL),
1055: MSC_ATP_PVT.G_SESSION_ID,
1056: l_sources,
1057: l_return_status,
1058: l_partner_type, --2814895

Line 1154: l_sources.Organization_Id:= MRP_ATP_PUB.number_arr(l_process_org_id);

1150: RAISE NO_DATA_FOUND;
1151: END IF;
1152:
1153: ELSE
1154: l_sources.Organization_Id:= MRP_ATP_PUB.number_arr(l_process_org_id);
1155: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
1156: l_sources.Source_Type := MRP_ATP_PUB.number_arr(1);
1157: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(-1);
1158: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(-1);

Line 1155: l_sources.Rank := MRP_ATP_PUB.number_arr(1);

1151: END IF;
1152:
1153: ELSE
1154: l_sources.Organization_Id:= MRP_ATP_PUB.number_arr(l_process_org_id);
1155: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
1156: l_sources.Source_Type := MRP_ATP_PUB.number_arr(1);
1157: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(-1);
1158: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(-1);
1159: l_sources.Preferred := MRP_ATP_PUB.number_arr(1);

Line 1156: l_sources.Source_Type := MRP_ATP_PUB.number_arr(1);

1152:
1153: ELSE
1154: l_sources.Organization_Id:= MRP_ATP_PUB.number_arr(l_process_org_id);
1155: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
1156: l_sources.Source_Type := MRP_ATP_PUB.number_arr(1);
1157: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(-1);
1158: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(-1);
1159: l_sources.Preferred := MRP_ATP_PUB.number_arr(1);
1160: END IF;

Line 1157: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(-1);

1153: ELSE
1154: l_sources.Organization_Id:= MRP_ATP_PUB.number_arr(l_process_org_id);
1155: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
1156: l_sources.Source_Type := MRP_ATP_PUB.number_arr(1);
1157: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(-1);
1158: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(-1);
1159: l_sources.Preferred := MRP_ATP_PUB.number_arr(1);
1160: END IF;
1161: --e_cto_rearch

Line 1158: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(-1);

1154: l_sources.Organization_Id:= MRP_ATP_PUB.number_arr(l_process_org_id);
1155: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
1156: l_sources.Source_Type := MRP_ATP_PUB.number_arr(1);
1157: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(-1);
1158: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(-1);
1159: l_sources.Preferred := MRP_ATP_PUB.number_arr(1);
1160: END IF;
1161: --e_cto_rearch
1162: END IF;

Line 1159: l_sources.Preferred := MRP_ATP_PUB.number_arr(1);

1155: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
1156: l_sources.Source_Type := MRP_ATP_PUB.number_arr(1);
1157: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(-1);
1158: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(-1);
1159: l_sources.Preferred := MRP_ATP_PUB.number_arr(1);
1160: END IF;
1161: --e_cto_rearch
1162: END IF;
1163:

Line 6037: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

6033: p_search IN NUMBER,
6034: p_refresh_number IN NUMBER,
6035: p_parent_pegging_id IN NUMBER,
6036: p_assign_set_id IN NUMBER,
6037: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
6038: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
6039: x_return_status OUT NoCopy VARCHAR2,
6040: p_pre_processing_lead_time IN NUMBER :=0
6041: )

Line 6038: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

6034: p_refresh_number IN NUMBER,
6035: p_parent_pegging_id IN NUMBER,
6036: p_assign_set_id IN NUMBER,
6037: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
6038: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
6039: x_return_status OUT NoCopy VARCHAR2,
6040: p_pre_processing_lead_time IN NUMBER :=0
6041: )
6042: IS

Line 6068: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

6064: l_atp_rec MRP_ATP_PVT.AtpRec;
6065: l_net_demand NUMBER := 0; --5478124
6066: l_sched_status BOOLEAN;
6067: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
6068: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6069: l_atp_period_first MRP_ATP_PUB.ATP_Period_Typ;
6070: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6071: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6072: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 6069: l_atp_period_first MRP_ATP_PUB.ATP_Period_Typ;

6065: l_net_demand NUMBER := 0; --5478124
6066: l_sched_status BOOLEAN;
6067: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
6068: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6069: l_atp_period_first MRP_ATP_PUB.ATP_Period_Typ;
6070: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6071: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6072: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6073: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 6070: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

6066: l_sched_status BOOLEAN;
6067: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
6068: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6069: l_atp_period_first MRP_ATP_PUB.ATP_Period_Typ;
6070: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6071: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6072: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6073: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6074: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 6071: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;

6067: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
6068: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6069: l_atp_period_first MRP_ATP_PUB.ATP_Period_Typ;
6070: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6071: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6072: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6073: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6074: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6075: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 6072: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

6068: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6069: l_atp_period_first MRP_ATP_PUB.ATP_Period_Typ;
6070: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6071: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6072: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6073: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6074: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6075: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6076: l_tb_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 6073: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;

6069: l_atp_period_first MRP_ATP_PUB.ATP_Period_Typ;
6070: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6071: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6072: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6073: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6074: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6075: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6076: l_tb_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6077: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 6074: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

6070: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6071: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6072: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6073: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6074: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6075: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6076: l_tb_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6077: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6078: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 6075: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;

6071: l_res_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6072: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6073: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6074: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6075: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6076: l_tb_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6077: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6078: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6079:

Line 6076: l_tb_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

6072: l_res_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6073: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6074: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6075: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6076: l_tb_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6077: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6078: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6079:
6080: l_inv_item_id NUMBER;

Line 6077: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;

6073: l_comp_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6074: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6075: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6076: l_tb_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6077: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6078: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6079:
6080: l_inv_item_id NUMBER;
6081:

Line 6078: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

6074: l_comp_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6075: l_tb_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6076: l_tb_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6077: l_future_atp_period MRP_ATP_PUB.ATP_Period_Typ;
6078: l_future_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
6079:
6080: l_inv_item_id NUMBER;
6081:
6082: temp NUMBER;

Line 6141: l_atp_pegging_tab MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();

6137: l_ptf_date_for_child DATE; -- Bug 3782472
6138: l_req_date_qty NUMBER;
6139: l_item_attribute_rec MSC_ATP_PVT.item_attribute_rec; -- Obsoleted
6140: l_substitution_window NUMBER;
6141: l_atp_pegging_tab MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
6142: -- Only specific to this procedure
6143: PF_ITEM_INFO_REC MSC_ATP_PVT.item_attribute_rec; -- Only for PF info
6144: C_ITEM_INFO_REC MSC_ATP_PVT.item_attribute_rec; -- Copy of the global.
6145: -- Added for bug 2392456

Line 10063: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make

10059: msc_sch_wb.atp_debug('ATP_Check: ' || 'ods atp, we always make');
10060: END IF;
10061:
10062: --we should come here only for ATO models or ATO items
10063: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make
10064: l_sources.Organization_Id:=
10065: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10066: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10067: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);

Line 10065: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);

10061:
10062: --we should come here only for ATO models or ATO items
10063: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make
10064: l_sources.Organization_Id:=
10065: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10066: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10067: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10068: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10069: l_sources.instance_id :=

Line 10066: l_sources.Rank := MRP_ATP_PUB.number_arr(1);

10062: --we should come here only for ATO models or ATO items
10063: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make
10064: l_sources.Organization_Id:=
10065: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10066: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10067: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10068: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10069: l_sources.instance_id :=
10070: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);

Line 10067: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);

10063: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make
10064: l_sources.Organization_Id:=
10065: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10066: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10067: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10068: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10069: l_sources.instance_id :=
10070: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10071: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal

Line 10068: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);

10064: l_sources.Organization_Id:=
10065: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10066: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10067: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10068: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10069: l_sources.instance_id :=
10070: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10071: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10072: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal

Line 10070: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);

10066: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10067: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10068: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10069: l_sources.instance_id :=
10070: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10071: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10072: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10073: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10074: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal

Line 10071: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal

10067: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10068: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10069: l_sources.instance_id :=
10070: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10071: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10072: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10073: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10074: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10075: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal

Line 10072: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal

10068: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10069: l_sources.instance_id :=
10070: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10071: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10072: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10073: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10074: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10075: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10076:

Line 10073: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal

10069: l_sources.instance_id :=
10070: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10071: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10072: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10073: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10074: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10075: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10076:
10077: --do not get sources for phantom model

Line 10074: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal

10070: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10071: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10072: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10073: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10074: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10075: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10076:
10077: --do not get sources for phantom model
10078: ELSIF NOT (C_ITEM_INFO_REC.bom_item_type = 1 and NVL(p_atp_record.wip_supply_type,2) = 6 and

Line 10075: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal

10071: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10072: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10073: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10074: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10075: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10076:
10077: --do not get sources for phantom model
10078: ELSIF NOT (C_ITEM_INFO_REC.bom_item_type = 1 and NVL(p_atp_record.wip_supply_type,2) = 6 and
10079: C_ITEM_INFO_REC.replenish_to_ord_flag = 'Y') THEN

Line 10090: --MRP_ATP_PUB.number_arr(NULL),

10086: NULL,
10087: NULL,
10088: p_assign_set_id,
10089: l_item_sourcing_info_rec,
10090: --MRP_ATP_PUB.number_arr(NULL),
10091: MSC_ATP_PVT.G_SESSION_ID,
10092: l_sources,
10093: l_return_status);
10094:

Line 10138: l_sources.Source_Type := MRP_ATP_PUB.number_arr(3); --- BUY

10134: WHEN OTHERS THEN
10135: l_make_buy_cd := 1; --- make 'make' default
10136: END;
10137: IF (l_make_buy_cd = 2) THEN --- buy
10138: l_sources.Source_Type := MRP_ATP_PUB.number_arr(3); --- BUY
10139: l_sources.Organization_Id:=
10140: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10141: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10142: ----- Since supplier id and supplier site id is no known

Line 10140: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);

10136: END;
10137: IF (l_make_buy_cd = 2) THEN --- buy
10138: l_sources.Source_Type := MRP_ATP_PUB.number_arr(3); --- BUY
10139: l_sources.Organization_Id:=
10140: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10141: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10142: ----- Since supplier id and supplier site id is no known
10143: ---- we set it to -99. We cant set it to null because
10144: ---- when atp_check procedure is called from buy logic below

Line 10141: l_sources.Rank := MRP_ATP_PUB.number_arr(1);

10137: IF (l_make_buy_cd = 2) THEN --- buy
10138: l_sources.Source_Type := MRP_ATP_PUB.number_arr(3); --- BUY
10139: l_sources.Organization_Id:=
10140: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10141: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10142: ----- Since supplier id and supplier site id is no known
10143: ---- we set it to -99. We cant set it to null because
10144: ---- when atp_check procedure is called from buy logic below
10145: ---- then it will go into inventory org to do atp check rather

Line 10147: l_sources.Supplier_Id :=MRP_ATP_PUB.number_arr(-99);

10143: ---- we set it to -99. We cant set it to null because
10144: ---- when atp_check procedure is called from buy logic below
10145: ---- then it will go into inventory org to do atp check rather
10146: ----- then calling get_supplier_atp_info
10147: l_sources.Supplier_Id :=MRP_ATP_PUB.number_arr(-99);
10148: l_sources.Supplier_Site_Id :=MRP_ATP_PUB.number_arr(-99);
10149: l_sources.instance_id :=
10150: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10151: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal

Line 10148: l_sources.Supplier_Site_Id :=MRP_ATP_PUB.number_arr(-99);

10144: ---- when atp_check procedure is called from buy logic below
10145: ---- then it will go into inventory org to do atp check rather
10146: ----- then calling get_supplier_atp_info
10147: l_sources.Supplier_Id :=MRP_ATP_PUB.number_arr(-99);
10148: l_sources.Supplier_Site_Id :=MRP_ATP_PUB.number_arr(-99);
10149: l_sources.instance_id :=
10150: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10151: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10152: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal

Line 10150: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);

10146: ----- then calling get_supplier_atp_info
10147: l_sources.Supplier_Id :=MRP_ATP_PUB.number_arr(-99);
10148: l_sources.Supplier_Site_Id :=MRP_ATP_PUB.number_arr(-99);
10149: l_sources.instance_id :=
10150: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10151: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10152: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10153: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10154: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal

Line 10151: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal

10147: l_sources.Supplier_Id :=MRP_ATP_PUB.number_arr(-99);
10148: l_sources.Supplier_Site_Id :=MRP_ATP_PUB.number_arr(-99);
10149: l_sources.instance_id :=
10150: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10151: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10152: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10153: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10154: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10155: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal

Line 10152: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal

10148: l_sources.Supplier_Site_Id :=MRP_ATP_PUB.number_arr(-99);
10149: l_sources.instance_id :=
10150: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10151: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10152: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10153: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10154: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10155: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10156:

Line 10153: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal

10149: l_sources.instance_id :=
10150: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10151: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10152: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10153: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10154: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10155: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10156:
10157: -- dsting

Line 10154: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal

10150: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10151: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10152: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10153: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10154: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10155: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10156:
10157: -- dsting
10158: IF PG_DEBUG in ('Y', 'C') THEN

Line 10155: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal

10151: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10152: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10153: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10154: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10155: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10156:
10157: -- dsting
10158: IF PG_DEBUG in ('Y', 'C') THEN
10159: msc_sch_wb.atp_debug('ATP_Check: ' || 'MAKE_BUY_CHILDREN: have buy source');

Line 10163: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make

10159: msc_sch_wb.atp_debug('ATP_Check: ' || 'MAKE_BUY_CHILDREN: have buy source');
10160: END IF;
10161: p_atp_record.children_type := MAKE_BUY_CHILDREN;
10162: ELSE
10163: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make
10164: l_sources.Organization_Id:=
10165: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10166: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10167: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);

Line 10165: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);

10161: p_atp_record.children_type := MAKE_BUY_CHILDREN;
10162: ELSE
10163: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make
10164: l_sources.Organization_Id:=
10165: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10166: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10167: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10168: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10169: l_sources.instance_id :=

Line 10166: l_sources.Rank := MRP_ATP_PUB.number_arr(1);

10162: ELSE
10163: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make
10164: l_sources.Organization_Id:=
10165: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10166: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10167: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10168: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10169: l_sources.instance_id :=
10170: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);

Line 10167: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);

10163: l_sources.Source_Type := MRP_ATP_PUB.number_arr(2); -- make
10164: l_sources.Organization_Id:=
10165: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10166: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10167: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10168: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10169: l_sources.instance_id :=
10170: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10171: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal

Line 10168: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);

10164: l_sources.Organization_Id:=
10165: MRP_ATP_PUB.number_arr(p_atp_record.organization_id);
10166: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10167: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10168: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10169: l_sources.instance_id :=
10170: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10171: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10172: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal

Line 10170: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);

10166: l_sources.Rank := MRP_ATP_PUB.number_arr(1);
10167: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10168: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10169: l_sources.instance_id :=
10170: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10171: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10172: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10173: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10174: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal

Line 10171: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal

10167: l_sources.Supplier_Id := MRP_ATP_PUB.number_arr(NULL);
10168: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10169: l_sources.instance_id :=
10170: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10171: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10172: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10173: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10174: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10175: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal

Line 10172: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal

10168: l_sources.Supplier_Site_Id := MRP_ATP_PUB.number_arr(NULL);
10169: l_sources.instance_id :=
10170: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10171: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10172: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10173: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10174: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10175: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10176:

Line 10173: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal

10169: l_sources.instance_id :=
10170: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10171: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10172: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10173: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10174: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10175: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10176:
10177: -- dsting

Line 10174: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal

10170: MRP_ATP_PUB.number_arr(p_atp_record.instance_id);
10171: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10172: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10173: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10174: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10175: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10176:
10177: -- dsting
10178: IF PG_DEBUG in ('Y', 'C') THEN

Line 10175: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal

10171: l_sources.Lead_Time := MRP_ATP_PUB.number_arr(0); -- ship_rec_cal
10172: l_sources.Ship_Method := MRP_ATP_PUB.char30_arr('@@@'); -- ship_rec_cal
10173: l_sources.Preferred := MRP_ATP_PUB.number_arr(NULL); -- ship_rec_cal
10174: l_sources.make_flag := MRP_ATP_PUB.char1_arr(NULL); -- ship_rec_cal
10175: l_sources.Sup_Cap_Type := MRP_ATP_PUB.number_arr(2); -- ship_rec_cal
10176:
10177: -- dsting
10178: IF PG_DEBUG in ('Y', 'C') THEN
10179: msc_sch_wb.atp_debug('ATP_Check: ' || 'MAKE_BUY_CHILDREN: have make source');

Line 12617: l_atp_pegging_tab := MRP_ATP_PUB.Number_Arr(); --bug3581151

12613: -- Planned Pegging based AATP, l_atp_pegging_tab populated in
12614: -- MSC_AATP_REQ.Get_Forward_Material_Atp
12615:
12616: MSC_ATP_DB_UTILS.Remove_Invalid_Future_SD(l_atp_pegging_tab);
12617: l_atp_pegging_tab := MRP_ATP_PUB.Number_Arr(); --bug3581151
12618:
12619: ELSE -- IF l_atp_pegging_tab.COUNT > 0 THEN
12620: MSC_ATP_DB_UTILS.Update_Planned_Order(l_future_pegging_id,
12621: p_plan_id,

Line 14512: l_atp_pegging_tab := MRP_ATP_PUB.Number_Arr(); --bug3581151

14508: -- Planned Pegging based AATP, l_atp_pegging_tab populated in
14509: -- MSC_AATP_REQ.Get_Forward_Material_Atp
14510:
14511: MSC_ATP_DB_UTILS.Remove_Invalid_Future_SD(l_atp_pegging_tab);
14512: l_atp_pegging_tab := MRP_ATP_PUB.Number_Arr(); --bug3581151
14513:
14514: ELSE -- IF l_atp_pegging_tab.COUNT > 0 THEN
14515:
14516: MSC_ATP_DB_UTILS.Update_Planned_Order(l_future_pegging_id,

Line 16225: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,

16221:
16222:
16223: PROCEDURE Call_Schedule (
16224: p_session_id IN NUMBER,
16225: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
16226: p_instance_id IN NUMBER,
16227: p_assign_set_id IN NUMBER,
16228: p_refresh_number IN NUMBER,
16229: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

Line 16229: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,

16225: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
16226: p_instance_id IN NUMBER,
16227: p_assign_set_id IN NUMBER,
16228: p_refresh_number IN NUMBER,
16229: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
16230: x_return_status OUT NoCopy VARCHAR2,
16231: x_msg_data OUT NoCopy VARCHAR2,
16232: x_msg_count OUT NoCopy NUMBER,
16233: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

Line 16233: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,

16229: x_atp_table OUT NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
16230: x_return_status OUT NoCopy VARCHAR2,
16231: x_msg_data OUT NoCopy VARCHAR2,
16232: x_msg_count OUT NoCopy NUMBER,
16233: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
16234: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
16235: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
16236: ) IS
16237:

Line 16234: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,

16230: x_return_status OUT NoCopy VARCHAR2,
16231: x_msg_data OUT NoCopy VARCHAR2,
16232: x_msg_count OUT NoCopy NUMBER,
16233: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
16234: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
16235: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
16236: ) IS
16237:
16238: i PLS_INTEGER;

Line 16235: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ

16231: x_msg_data OUT NoCopy VARCHAR2,
16232: x_msg_count OUT NoCopy NUMBER,
16233: x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
16234: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
16235: x_atp_details OUT NOCOPY MRP_ATP_PUB.ATP_Details_Typ
16236: ) IS
16237:
16238: i PLS_INTEGER;
16239: j PLS_INTEGER;

Line 16243: l_atp_input_table MRP_ATP_PUB.ATP_Rec_Typ;

16239: j PLS_INTEGER;
16240: k PLS_INTEGER;
16241: m PLS_INTEGER;
16242: l_return_status VARCHAR2(1);
16243: l_atp_input_table MRP_ATP_PUB.ATP_Rec_Typ;
16244: l_atp_output_table MRP_ATP_PUB.ATP_Rec_Typ;
16245: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
16246: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
16247: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 16244: l_atp_output_table MRP_ATP_PUB.ATP_Rec_Typ;

16240: k PLS_INTEGER;
16241: m PLS_INTEGER;
16242: l_return_status VARCHAR2(1);
16243: l_atp_input_table MRP_ATP_PUB.ATP_Rec_Typ;
16244: l_atp_output_table MRP_ATP_PUB.ATP_Rec_Typ;
16245: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
16246: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
16247: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
16248: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

Line 16245: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

16241: m PLS_INTEGER;
16242: l_return_status VARCHAR2(1);
16243: l_atp_input_table MRP_ATP_PUB.ATP_Rec_Typ;
16244: l_atp_output_table MRP_ATP_PUB.ATP_Rec_Typ;
16245: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
16246: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
16247: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
16248: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
16249: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;

Line 16246: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

16242: l_return_status VARCHAR2(1);
16243: l_atp_input_table MRP_ATP_PUB.ATP_Rec_Typ;
16244: l_atp_output_table MRP_ATP_PUB.ATP_Rec_Typ;
16245: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
16246: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
16247: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
16248: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
16249: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
16250: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 16247: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

16243: l_atp_input_table MRP_ATP_PUB.ATP_Rec_Typ;
16244: l_atp_output_table MRP_ATP_PUB.ATP_Rec_Typ;
16245: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
16246: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
16247: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
16248: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
16249: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
16250: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
16251: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 16248: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

16244: l_atp_output_table MRP_ATP_PUB.ATP_Rec_Typ;
16245: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
16246: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
16247: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
16248: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
16249: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
16250: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
16251: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;
16252: l_msg_data VARCHAR2(2000);

Line 16249: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;

16245: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
16246: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
16247: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
16248: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
16249: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
16250: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
16251: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;
16252: l_msg_data VARCHAR2(2000);
16253: l_msg_text VARCHAR2(2000);

Line 16250: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

16246: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
16247: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
16248: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
16249: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
16250: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
16251: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;
16252: l_msg_data VARCHAR2(2000);
16253: l_msg_text VARCHAR2(2000);
16254: l_msg_count NUMBER;

Line 16251: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;

16247: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
16248: l_null_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
16249: l_null_atp_period MRP_ATP_PUB.ATP_Period_Typ;
16250: l_null_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
16251: l_null_atp_details MRP_ATP_PUB.ATP_Details_Typ;
16252: l_msg_data VARCHAR2(2000);
16253: l_msg_text VARCHAR2(2000);
16254: l_msg_count NUMBER;
16255: l_msg_number NUMBER;

Line 16296: l_included_item_table MRP_ATP_PUB.ATP_Rec_Typ;

16292: -- rajjain 02/03/2003 Bug 2766713
16293: l_set_fail_flag VARCHAR2(1) := 'N';
16294:
16295: --s_cto_rearch
16296: l_included_item_table MRP_ATP_PUB.ATP_Rec_Typ;
16297: l_included_item_cntr number;
16298: l_mand_comp_info_rec MSC_ATP_CTO.mand_comp_info_rec;
16299: l_null_mand_comp_info_rec MSC_ATP_CTO.mand_comp_info_rec;
16300: l_pto_cntr number;

Line 17691: MSC_ATP_PVT.G_COPY_DEMAND_ID := MRP_ATP_PUB.number_arr();

17687: MSC_ATP_PVT.G_COPY_DEMAND_PLAN_ID,
17688: G_TIME_PHASED_SET,
17689: l_return_status);
17690: END IF;
17691: MSC_ATP_PVT.G_COPY_DEMAND_ID := MRP_ATP_PUB.number_arr();
17692: MSC_ATP_PVT.G_COPY_DEMAND_PLAN_ID := MRP_ATP_PUB.number_arr();
17693:
17694: --Bug 3629191: Insert Offset Record to MRP_ATP_DETAILS_TEMP with record_type = 3
17695: -- and these will be inserted with NULL in all the three pegging_id columns

Line 17692: MSC_ATP_PVT.G_COPY_DEMAND_PLAN_ID := MRP_ATP_PUB.number_arr();

17688: G_TIME_PHASED_SET,
17689: l_return_status);
17690: END IF;
17691: MSC_ATP_PVT.G_COPY_DEMAND_ID := MRP_ATP_PUB.number_arr();
17692: MSC_ATP_PVT.G_COPY_DEMAND_PLAN_ID := MRP_ATP_PUB.number_arr();
17693:
17694: --Bug 3629191: Insert Offset Record to MRP_ATP_DETAILS_TEMP with record_type = 3
17695: -- and these will be inserted with NULL in all the three pegging_id columns
17696:

Line 18077: p_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

18073: ) IS
18074:
18075: i PLS_INTEGER;
18076: l_dblink VARCHAR2(128);
18077: p_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
18078: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
18079: x_return_status VARCHAR2(128);
18080: x_msg_data VARCHAR2(2000);
18081: x_msg_count NUMBER;

Line 18078: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;

18074:
18075: i PLS_INTEGER;
18076: l_dblink VARCHAR2(128);
18077: p_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
18078: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
18079: x_return_status VARCHAR2(128);
18080: x_msg_data VARCHAR2(2000);
18081: x_msg_count NUMBER;
18082: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 18082: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

18078: x_atp_table MRP_ATP_PUB.ATP_Rec_Typ;
18079: x_return_status VARCHAR2(128);
18080: x_msg_data VARCHAR2(2000);
18081: x_msg_count NUMBER;
18082: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18083: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18084: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18085: l_atp_bom_rec MRP_ATP_PUB.ATP_BOM_Rec_Typ;
18086:

Line 18083: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;

18079: x_return_status VARCHAR2(128);
18080: x_msg_data VARCHAR2(2000);
18081: x_msg_count NUMBER;
18082: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18083: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18084: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18085: l_atp_bom_rec MRP_ATP_PUB.ATP_BOM_Rec_Typ;
18086:
18087: -- Bug 2387242 : krajan

Line 18084: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;

18080: x_msg_data VARCHAR2(2000);
18081: x_msg_count NUMBER;
18082: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18083: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18084: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18085: l_atp_bom_rec MRP_ATP_PUB.ATP_BOM_Rec_Typ;
18086:
18087: -- Bug 2387242 : krajan
18088: -- Variables for SQL trace setup

Line 18085: l_atp_bom_rec MRP_ATP_PUB.ATP_BOM_Rec_Typ;

18081: x_msg_count NUMBER;
18082: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
18083: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
18084: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
18085: l_atp_bom_rec MRP_ATP_PUB.ATP_BOM_Rec_Typ;
18086:
18087: -- Bug 2387242 : krajan
18088: -- Variables for SQL trace setup
18089: C INTEGER;

Line 18097: l_profile_value MRP_ATP_PUB.char255_arr := MRP_ATP_PUB.char255_arr(); --bug3940999

18093: -- rajjain 12/20/2002
18094: l_spid VARCHAR2(12);
18095:
18096: --bug3940999
18097: l_profile_value MRP_ATP_PUB.char255_arr := MRP_ATP_PUB.char255_arr(); --bug3940999
18098: l_profile_name MRP_ATP_PUB.char255_arr := MRP_ATP_PUB.char255_arr(); --bug3940999
18099: l_use_ship_rec VARCHAR2(2); --bug3940999
18100: j NUMBER ; --bug3940999
18101:

Line 18098: l_profile_name MRP_ATP_PUB.char255_arr := MRP_ATP_PUB.char255_arr(); --bug3940999

18094: l_spid VARCHAR2(12);
18095:
18096: --bug3940999
18097: l_profile_value MRP_ATP_PUB.char255_arr := MRP_ATP_PUB.char255_arr(); --bug3940999
18098: l_profile_name MRP_ATP_PUB.char255_arr := MRP_ATP_PUB.char255_arr(); --bug3940999
18099: l_use_ship_rec VARCHAR2(2); --bug3940999
18100: j NUMBER ; --bug3940999
18101:
18102: BEGIN

Line 18510: PROCEDURE Process_Time_Stamp_Errors (l_atp_table IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,

18506: msc_sch_wb.atp_debug('***** End Call_Schedule_Remote Procedure *****');
18507: END IF;
18508:
18509: END Call_Schedule_Remote;
18510: PROCEDURE Process_Time_Stamp_Errors (l_atp_table IN OUT NOCOPY MRP_ATP_PUB.ATP_Rec_Typ,
18511: i NUMBER)
18512: IS
18513: BEGIN
18514: