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.
PACKAGE BODY: APPS.MSC_ATPUI_UTIL

Source


1 PACKAGE BODY MSC_ATPUI_UTIL AS
2 /*  $Header: MSCATPUB.pls 120.1 2005/06/17 13:27:49 appldev  $ */
3 
4 PROCEDURE populate_schedule_temp_table(
5 		p_atp_schedule_temp IN MSC_ATPUI_UTIL.ATP_SCHEDULE_TEMP_TYP,
6 		p_return_status out nocopy VARCHAR2,
7 		p_error_message out nocopy VARCHAR2) IS
8 BEGIN
9  FORALL lCounter IN 1 .. p_atp_schedule_temp.ACTION.COUNT
10  INSERT INTO MRP_ATP_SCHEDULE_TEMP
11  ( ACTION, CALLING_MODULE, SESSION_ID, ORDER_HEADER_ID, ORDER_LINE_ID,
12  INVENTORY_ITEM_ID, ORGANIZATION_ID, SR_INSTANCE_ID, ORGANIZATION_CODE, ORDER_NUMBER,
13  SOURCE_ORGANIZATION_ID, CUSTOMER_ID, CUSTOMER_SITE_ID, DESTINATION_TIME_ZONE, QUANTITY_ORDERED,                         UOM_CODE, REQUESTED_SHIP_DATE, REQUESTED_ARRIVAL_DATE, LATEST_ACCEPTABLE_DATE, DELIVERY_LEAD_TIME,
14  FREIGHT_CARRIER, SHIP_METHOD, DEMAND_CLASS, SHIP_SET_NAME, ARRIVAL_SET_NAME,
15  OVERRIDE_FLAG, SCHEDULED_SHIP_DATE, SCHEDULED_ARRIVAL_DATE, AVAILABLE_QUANTITY, REQUESTED_DATE_QUANTITY,                  GROUP_SHIP_DATE, GROUP_ARRIVAL_DATE, VENDOR_ID, VENDOR_SITE_ID, INSERT_FLAG,
16  ERROR_CODE, ERROR_MESSAGE, SEQUENCE_NUMBER, FIRM_FLAG, INVENTORY_ITEM_NAME,
17  SOURCE_ORGANIZATION_CODE, INSTANCE_ID1, ORDER_LINE_NUMBER, PROMISE_DATE, CUSTOMER_NAME,
18  CUSTOMER_LOCATION, OLD_LINE_SCHEDULE_DATE, OLD_SOURCE_ORGANIZATION_CODE, SCENARIO_ID, VENDOR_NAME,
19  VENDOR_SITE_NAME, STATUS_FLAG, MDI_ROWID, DEMAND_SOURCE_TYPE, DEMAND_SOURCE_DELIVERY,
20  ATP_LEAD_TIME, OE_FLAG, ITEM_DESC, INTRANSIT_LEAD_TIME, SHIP_METHOD_TEXT,
21  END_PEGGING_ID, SHIP_SET_ID, ARRIVAL_SET_ID, SHIPMENT_NUMBER, OPTION_NUMBER,
22  PROJECT_ID, TASK_ID, PROJECT_NUMBER, TASK_NUMBER, EXCEPTION1,
23  EXCEPTION2, EXCEPTION3, EXCEPTION4, EXCEPTION5, EXCEPTION6,
24  EXCEPTION7, EXCEPTION8, EXCEPTION9, EXCEPTION10, EXCEPTION11,
25  EXCEPTION12, EXCEPTION13, EXCEPTION14, EXCEPTION15, FIRM_SOURCE_ORG_ID,
26  FIRM_SOURCE_ORG_CODE, FIRM_SHIP_DATE, FIRM_ARRIVAL_DATE, OLD_SOURCE_ORGANIZATION_ID, OLD_DEMAND_CLASS,
27  ATTRIBUTE_06, REQUEST_ITEM_ID, REQUEST_ITEM_NAME, REQ_ITEM_AVAILABLE_DATE, REQ_ITEM_AVAILABLE_DATE_QTY,
28  REQ_ITEM_REQ_DATE_QTY, SALES_REP, CUSTOMER_CONTACT, SUBST_FLAG, SUBSTITUTION_TYP_CODE,
29  REQ_ITEM_DETAIL_FLAG, OLD_INVENTORY_ITEM_ID, COMPILE_DESIGNATOR, CREATION_DATE, CREATED_BY,
30  LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, FLOW_STATUS_CODE, ASSIGNMENT_SET_ID,
31  DIAGNOSTIC_ATP_FLAG)
32  VALUES
33  ( p_atp_schedule_temp.ACTION(lCounter) ,p_atp_schedule_temp.CALLING_MODULE(lCounter) ,
34  p_atp_schedule_temp.SESSION_ID(lCounter), p_atp_schedule_temp.ORDER_HEADER_ID(lCounter) ,
35  p_atp_schedule_temp.ORDER_LINE_ID (lCounter), p_atp_schedule_temp.INVENTORY_ITEM_ID(lCounter) ,
36  p_atp_schedule_temp.ORGANIZATION_ID(lCounter), p_atp_schedule_temp.SR_INSTANCE_ID(lCounter),
37  p_atp_schedule_temp.ORGANIZATION_CODE(lCounter), p_atp_schedule_temp.ORDER_NUMBER(lCounter) ,
38  p_atp_schedule_temp.SOURCE_ORGANIZATION_ID(lCounter), p_atp_schedule_temp.CUSTOMER_ID(lCounter) ,
39  p_atp_schedule_temp.CUSTOMER_SITE_ID(lCounter), p_atp_schedule_temp.DESTINATION_TIME_ZONE(lCounter) ,
40  p_atp_schedule_temp.QUANTITY_ORDERED(lCounter), p_atp_schedule_temp.UOM_CODE(lCounter),
41  p_atp_schedule_temp.REQUESTED_SHIP_DATE(lCounter), p_atp_schedule_temp.REQUESTED_ARRIVAL_DATE(lCounter),
42  p_atp_schedule_temp.LATEST_ACCEPTABLE_DATE(lCounter), p_atp_schedule_temp.DELIVERY_LEAD_TIME(lCounter),
43  p_atp_schedule_temp.FREIGHT_CARRIER(lCounter), p_atp_schedule_temp.SHIP_METHOD(lCounter),
44  p_atp_schedule_temp.DEMAND_CLASS(lCounter), p_atp_schedule_temp.SHIP_SET_NAME(lCounter),
45  p_atp_schedule_temp.ARRIVAL_SET_NAME(lCounter), p_atp_schedule_temp.OVERRIDE_FLAG(lCounter),
46  p_atp_schedule_temp.SCHEDULED_SHIP_DATE(lCounter), p_atp_schedule_temp.SCHEDULED_ARRIVAL_DATE(lCounter),
47  p_atp_schedule_temp.AVAILABLE_QUANTITY(lCounter), p_atp_schedule_temp.REQUESTED_DATE_QUANTITY(lCounter),
48  p_atp_schedule_temp.GROUP_SHIP_DATE(lCounter), p_atp_schedule_temp.GROUP_ARRIVAL_DATE(lCounter),
49  p_atp_schedule_temp.VENDOR_ID(lCounter),
50  p_atp_schedule_temp.VENDOR_SITE_ID(lCounter), p_atp_schedule_temp.INSERT_FLAG(lCounter),
51  p_atp_schedule_temp.ERROR_CODE(lCounter), p_atp_schedule_temp.ERROR_MESSAGE(lCounter),
52  p_atp_schedule_temp.SEQUENCE_NUMBER(lCounter), p_atp_schedule_temp.FIRM_FLAG(lCounter),
53  p_atp_schedule_temp.INVENTORY_ITEM_NAME(lCounter), p_atp_schedule_temp.SOURCE_ORGANIZATION_CODE(lCounter),
54  p_atp_schedule_temp.INSTANCE_ID1(lCounter),
55  p_atp_schedule_temp.ORDER_LINE_NUMBER(lCounter), p_atp_schedule_temp.PROMISE_DATE(lCounter),
56  p_atp_schedule_temp.CUSTOMER_NAME(lCounter), p_atp_schedule_temp.CUSTOMER_LOCATION(lCounter),
57  p_atp_schedule_temp.OLD_LINE_SCHEDULE_DATE(lCounter),
58  p_atp_schedule_temp.OLD_SOURCE_ORGANIZATION_CODE(lCounter),
59  p_atp_schedule_temp.SCENARIO_ID(lCounter), p_atp_schedule_temp.VENDOR_NAME(lCounter),
60  p_atp_schedule_temp.VENDOR_SITE_NAME(lCounter), p_atp_schedule_temp.STATUS_FLAG(lCounter),
61  p_atp_schedule_temp.MDI_ROWID(lCounter), p_atp_schedule_temp.DEMAND_SOURCE_TYPE(lCounter),
62  p_atp_schedule_temp.DEMAND_SOURCE_DELIVERY(lCounter), p_atp_schedule_temp.ATP_LEAD_TIME(lCounter),
63  p_atp_schedule_temp.OE_FLAG(lCounter),
64  p_atp_schedule_temp.ITEM_DESC(lCounter), p_atp_schedule_temp.INTRANSIT_LEAD_TIME(lCounter),
65  p_atp_schedule_temp.SHIP_METHOD_TEXT(lCounter), p_atp_schedule_temp.END_PEGGING_ID(lCounter),
66  p_atp_schedule_temp.SHIP_SET_ID(lCounter),  p_atp_schedule_temp.ARRIVAL_SET_ID(lCounter),
67  p_atp_schedule_temp.SHIPMENT_NUMBER(lCounter),
68  p_atp_schedule_temp.OPTION_NUMBER(lCounter), p_atp_schedule_temp.PROJECT_ID(lCounter),
69  p_atp_schedule_temp.TASK_ID(lCounter), p_atp_schedule_temp.PROJECT_NUMBER(lCounter),
70  p_atp_schedule_temp.TASK_NUMBER(lCounter), p_atp_schedule_temp.EXCEPTION1(lCounter),
71  p_atp_schedule_temp.EXCEPTION2(lCounter), p_atp_schedule_temp.EXCEPTION3(lCounter),
72  p_atp_schedule_temp.EXCEPTION4(lCounter), p_atp_schedule_temp.EXCEPTION5(lCounter),
73  p_atp_schedule_temp.EXCEPTION6(lCounter), p_atp_schedule_temp.EXCEPTION7(lCounter),
74  p_atp_schedule_temp.EXCEPTION8(lCounter), p_atp_schedule_temp.EXCEPTION9(lCounter),
75  p_atp_schedule_temp.EXCEPTION10(lCounter), p_atp_schedule_temp.EXCEPTION11(lCounter),
76  p_atp_schedule_temp.EXCEPTION12(lCounter), p_atp_schedule_temp.EXCEPTION13(lCounter),
77  p_atp_schedule_temp.EXCEPTION14(lCounter), p_atp_schedule_temp.EXCEPTION15(lCounter),
78  p_atp_schedule_temp.FIRM_SOURCE_ORG_ID(lCounter), p_atp_schedule_temp.FIRM_SOURCE_ORG_CODE(lCounter),
79  p_atp_schedule_temp.FIRM_SHIP_DATE(lCounter) ,p_atp_schedule_temp.FIRM_ARRIVAL_DATE(lCounter),
80  p_atp_schedule_temp.OLD_SOURCE_ORGANIZATION_ID(lCounter),  p_atp_schedule_temp.OLD_DEMAND_CLASS(lCounter),
81  p_atp_schedule_temp.ATTRIBUTE_06(lCounter) ,p_atp_schedule_temp.REQUEST_ITEM_ID(lCounter),
82  p_atp_schedule_temp.REQUEST_ITEM_NAME(lCounter) ,p_atp_schedule_temp.REQ_ITEM_AVAILABLE_DATE(lCounter),
83  p_atp_schedule_temp.REQ_ITEM_AVAILABLE_DATE_QTY(lCounter), p_atp_schedule_temp.REQ_ITEM_REQ_DATE_QTY(lCounter),
84  p_atp_schedule_temp.SALES_REP(lCounter),
85  p_atp_schedule_temp.CUSTOMER_CONTACT(lCounter) ,p_atp_schedule_temp.SUBST_FLAG(lCounter),
86  p_atp_schedule_temp.SUBSTITUTION_TYP_CODE(lCounter) ,p_atp_schedule_temp.REQ_ITEM_DETAIL_FLAG(lCounter),
87  p_atp_schedule_temp.OLD_INVENTORY_ITEM_ID(lCounter),
88  p_atp_schedule_temp.COMPILE_DESIGNATOR(lCounter) ,p_atp_schedule_temp.CREATION_DATE(lCounter),
89  p_atp_schedule_temp.CREATED_BY(lCounter) ,p_atp_schedule_temp.LAST_UPDATE_DATE(lCounter),
90  p_atp_schedule_temp.LAST_UPDATED_BY(lCounter)  ,p_atp_schedule_temp.LAST_UPDATE_LOGIN(lCounter) ,
91  p_atp_schedule_temp.FLOW_STATUS_CODE(lCounter)  ,p_atp_schedule_temp.ASSIGNMENT_SET_ID(lCounter),
92  p_atp_schedule_temp.DIAGNOSTIC_ATP_FLAG(lCounter));
93 commit;
94 EXCEPTION
95   WHEN OTHERS THEN
96      p_return_status :='E';
97      p_error_message := substr(sqlerrm,1,100);
98 END populate_schedule_temp_table;
99 
100 PROCEDURE get_schedule_temp_rows(p_session_id in NUMBER,
101 				p_return_status out nocopy VARCHAR2,
102 				p_error_message out nocopy VARCHAR2) IS
103 p_atp_schedule_temp MSC_ATPUI_UTIL.ATP_SCHEDULE_TEMP_TYP;
104 p_atp_details_temp  MSC_ATPUI_UTIL.ATP_details_rec_type;
105 
106 BEGIN
107  p_return_status :='S';
108 
109  SELECT
110  ACTION, CALLING_MODULE, SESSION_ID, ORDER_HEADER_ID, ORDER_LINE_ID,
111  INVENTORY_ITEM_ID, ORGANIZATION_ID, SR_INSTANCE_ID, ORGANIZATION_CODE, ORDER_NUMBER,
112  SOURCE_ORGANIZATION_ID, CUSTOMER_ID, CUSTOMER_SITE_ID, DESTINATION_TIME_ZONE, QUANTITY_ORDERED,                         UOM_CODE, REQUESTED_SHIP_DATE, REQUESTED_ARRIVAL_DATE, LATEST_ACCEPTABLE_DATE, DELIVERY_LEAD_TIME,
113  FREIGHT_CARRIER, SHIP_METHOD, DEMAND_CLASS, SHIP_SET_NAME, ARRIVAL_SET_NAME,
114  OVERRIDE_FLAG, SCHEDULED_SHIP_DATE, SCHEDULED_ARRIVAL_DATE, AVAILABLE_QUANTITY, REQUESTED_DATE_QUANTITY,                  GROUP_SHIP_DATE, GROUP_ARRIVAL_DATE, VENDOR_ID, VENDOR_SITE_ID, INSERT_FLAG,
115  ERROR_CODE, ERROR_MESSAGE, SEQUENCE_NUMBER, FIRM_FLAG, INVENTORY_ITEM_NAME,
116  SOURCE_ORGANIZATION_CODE, INSTANCE_ID1, ORDER_LINE_NUMBER, PROMISE_DATE, CUSTOMER_NAME,
117  CUSTOMER_LOCATION, OLD_LINE_SCHEDULE_DATE, OLD_SOURCE_ORGANIZATION_CODE, SCENARIO_ID, VENDOR_NAME,
118  VENDOR_SITE_NAME, STATUS_FLAG, MDI_ROWID, DEMAND_SOURCE_TYPE, DEMAND_SOURCE_DELIVERY,
119  ATP_LEAD_TIME, OE_FLAG, ITEM_DESC, INTRANSIT_LEAD_TIME, SHIP_METHOD_TEXT,
120  END_PEGGING_ID, SHIP_SET_ID, ARRIVAL_SET_ID, SHIPMENT_NUMBER, OPTION_NUMBER,
121  PROJECT_ID, TASK_ID, PROJECT_NUMBER, TASK_NUMBER, EXCEPTION1,
122  EXCEPTION2, EXCEPTION3, EXCEPTION4, EXCEPTION5, EXCEPTION6,
123  EXCEPTION7, EXCEPTION8, EXCEPTION9, EXCEPTION10, EXCEPTION11,
124  EXCEPTION12, EXCEPTION13, EXCEPTION14, EXCEPTION15, FIRM_SOURCE_ORG_ID,
125  FIRM_SOURCE_ORG_CODE, FIRM_SHIP_DATE, FIRM_ARRIVAL_DATE, OLD_SOURCE_ORGANIZATION_ID, OLD_DEMAND_CLASS,
126  ATTRIBUTE_06, REQUEST_ITEM_ID, REQUEST_ITEM_NAME, REQ_ITEM_AVAILABLE_DATE, REQ_ITEM_AVAILABLE_DATE_QTY,
127  REQ_ITEM_REQ_DATE_QTY, SALES_REP, CUSTOMER_CONTACT, SUBST_FLAG, SUBSTITUTION_TYP_CODE,
128  REQ_ITEM_DETAIL_FLAG, OLD_INVENTORY_ITEM_ID, COMPILE_DESIGNATOR, CREATION_DATE, CREATED_BY,
129  LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, FLOW_STATUS_CODE, ASSIGNMENT_SET_ID,
130  DIAGNOSTIC_ATP_FLAG
131  BULK COLLECT INTO
132   p_atp_schedule_temp.ACTION ,p_atp_schedule_temp.CALLING_MODULE ,
133  p_atp_schedule_temp.SESSION_ID, p_atp_schedule_temp.ORDER_HEADER_ID ,
134  p_atp_schedule_temp.ORDER_LINE_ID , p_atp_schedule_temp.INVENTORY_ITEM_ID ,
135  p_atp_schedule_temp.ORGANIZATION_ID, p_atp_schedule_temp.SR_INSTANCE_ID,
136  p_atp_schedule_temp.ORGANIZATION_CODE, p_atp_schedule_temp.ORDER_NUMBER ,
137  p_atp_schedule_temp.SOURCE_ORGANIZATION_ID, p_atp_schedule_temp.CUSTOMER_ID ,
138  p_atp_schedule_temp.CUSTOMER_SITE_ID, p_atp_schedule_temp.DESTINATION_TIME_ZONE ,
139  p_atp_schedule_temp.QUANTITY_ORDERED, p_atp_schedule_temp.UOM_CODE,
140  p_atp_schedule_temp.REQUESTED_SHIP_DATE, p_atp_schedule_temp.REQUESTED_ARRIVAL_DATE,
141  p_atp_schedule_temp.LATEST_ACCEPTABLE_DATE, p_atp_schedule_temp.DELIVERY_LEAD_TIME,
142  p_atp_schedule_temp.FREIGHT_CARRIER, p_atp_schedule_temp.SHIP_METHOD,
143  p_atp_schedule_temp.DEMAND_CLASS, p_atp_schedule_temp.SHIP_SET_NAME,
144  p_atp_schedule_temp.ARRIVAL_SET_NAME, p_atp_schedule_temp.OVERRIDE_FLAG,
145  p_atp_schedule_temp.SCHEDULED_SHIP_DATE, p_atp_schedule_temp.SCHEDULED_ARRIVAL_DATE,
146  p_atp_schedule_temp.AVAILABLE_QUANTITY, p_atp_schedule_temp.REQUESTED_DATE_QUANTITY,
147  p_atp_schedule_temp.GROUP_SHIP_DATE, p_atp_schedule_temp.GROUP_ARRIVAL_DATE,
148  p_atp_schedule_temp.VENDOR_ID,
149  p_atp_schedule_temp.VENDOR_SITE_ID, p_atp_schedule_temp.INSERT_FLAG,
150  p_atp_schedule_temp.ERROR_CODE, p_atp_schedule_temp.ERROR_MESSAGE,
151  p_atp_schedule_temp.SEQUENCE_NUMBER, p_atp_schedule_temp.FIRM_FLAG,
152  p_atp_schedule_temp.INVENTORY_ITEM_NAME, p_atp_schedule_temp.SOURCE_ORGANIZATION_CODE,
153  p_atp_schedule_temp.INSTANCE_ID1,
154  p_atp_schedule_temp.ORDER_LINE_NUMBER, p_atp_schedule_temp.PROMISE_DATE,
155  p_atp_schedule_temp.CUSTOMER_NAME, p_atp_schedule_temp.CUSTOMER_LOCATION,
156  p_atp_schedule_temp.OLD_LINE_SCHEDULE_DATE, p_atp_schedule_temp.OLD_SOURCE_ORGANIZATION_CODE,
157  p_atp_schedule_temp.SCENARIO_ID, p_atp_schedule_temp.VENDOR_NAME,
158  p_atp_schedule_temp.VENDOR_SITE_NAME, p_atp_schedule_temp.STATUS_FLAG,
159  p_atp_schedule_temp.MDI_ROWID, p_atp_schedule_temp.DEMAND_SOURCE_TYPE,
160  p_atp_schedule_temp.DEMAND_SOURCE_DELIVERY, p_atp_schedule_temp.ATP_LEAD_TIME,
161  p_atp_schedule_temp.OE_FLAG,
162  p_atp_schedule_temp.ITEM_DESC, p_atp_schedule_temp.INTRANSIT_LEAD_TIME,
163  p_atp_schedule_temp.SHIP_METHOD_TEXT, p_atp_schedule_temp.END_PEGGING_ID,
164  p_atp_schedule_temp.SHIP_SET_ID,  p_atp_schedule_temp.ARRIVAL_SET_ID,
165  p_atp_schedule_temp.SHIPMENT_NUMBER,
166  p_atp_schedule_temp.OPTION_NUMBER, p_atp_schedule_temp.PROJECT_ID,
167  p_atp_schedule_temp.TASK_ID, p_atp_schedule_temp.PROJECT_NUMBER,
168  p_atp_schedule_temp.TASK_NUMBER, p_atp_schedule_temp.EXCEPTION1,
169  p_atp_schedule_temp.EXCEPTION2, p_atp_schedule_temp.EXCEPTION3,
170  p_atp_schedule_temp.EXCEPTION4, p_atp_schedule_temp.EXCEPTION5,
171  p_atp_schedule_temp.EXCEPTION6, p_atp_schedule_temp.EXCEPTION7,
172  p_atp_schedule_temp.EXCEPTION8, p_atp_schedule_temp.EXCEPTION9,
173  p_atp_schedule_temp.EXCEPTION10, p_atp_schedule_temp.EXCEPTION11,
174  p_atp_schedule_temp.EXCEPTION12, p_atp_schedule_temp.EXCEPTION13,
175  p_atp_schedule_temp.EXCEPTION14, p_atp_schedule_temp.EXCEPTION15,
176  p_atp_schedule_temp.FIRM_SOURCE_ORG_ID, p_atp_schedule_temp.FIRM_SOURCE_ORG_CODE,
177  p_atp_schedule_temp.FIRM_SHIP_DATE ,p_atp_schedule_temp.FIRM_ARRIVAL_DATE,
178  p_atp_schedule_temp.OLD_SOURCE_ORGANIZATION_ID,  p_atp_schedule_temp.OLD_DEMAND_CLASS,
179  p_atp_schedule_temp.ATTRIBUTE_06 ,p_atp_schedule_temp.REQUEST_ITEM_ID,
180  p_atp_schedule_temp.REQUEST_ITEM_NAME ,p_atp_schedule_temp.REQ_ITEM_AVAILABLE_DATE,
181  p_atp_schedule_temp.REQ_ITEM_AVAILABLE_DATE_QTY, p_atp_schedule_temp.REQ_ITEM_REQ_DATE_QTY,
182  p_atp_schedule_temp.SALES_REP,
183  p_atp_schedule_temp.CUSTOMER_CONTACT ,p_atp_schedule_temp.SUBST_FLAG,
184  p_atp_schedule_temp.SUBSTITUTION_TYP_CODE ,p_atp_schedule_temp.REQ_ITEM_DETAIL_FLAG,
185  p_atp_schedule_temp.OLD_INVENTORY_ITEM_ID,
186  p_atp_schedule_temp.COMPILE_DESIGNATOR ,p_atp_schedule_temp.CREATION_DATE,
187  p_atp_schedule_temp.CREATED_BY ,p_atp_schedule_temp.LAST_UPDATE_DATE,
188  p_atp_schedule_temp.LAST_UPDATED_BY  ,p_atp_schedule_temp.LAST_UPDATE_LOGIN ,
192  WHERE session_id = p_session_id and status_flag=2;
189  p_atp_schedule_temp.FLOW_STATUS_CODE  ,p_atp_schedule_temp.ASSIGNMENT_SET_ID,
190  p_atp_schedule_temp.DIAGNOSTIC_ATP_FLAG
191  FROM MRP_ATP_SCHEDULE_TEMP
193 
194  get_details_temp_rows( p_atp_details_temp,
195                         p_session_id ,
196                         p_return_status ,
197                         p_error_message );
198  ROLLBACK;
199 
200  populate_schedule_temp_table(p_atp_schedule_temp, p_return_status, p_error_message);
201  populate_details_temp_table(p_atp_details_temp, p_return_status, p_error_message);
202 
203 EXCEPTION
204   WHEN OTHERS THEN
205      p_return_status :='E';
206      p_error_message := substr(sqlerrm,1,100);
207 END get_schedule_temp_rows;
208 
209 PROCEDURE populate_details_temp_table(p_atp_details_temp IN MSC_ATPUI_UTIL.ATP_details_rec_type,
210 				p_return_status out nocopy VARCHAR2,
211 				p_error_message out nocopy VARCHAR2) IS
212 BEGIN
213  FORALL lCounter IN 1 .. p_atp_details_temp.inventory_item_id.COUNT
214  INSERT INTO  mrp_atp_details_temp
215  (SESSION_ID,
216 ORDER_LINE_ID,
217 PEGGING_ID,
218 PARENT_PEGGING_ID,
219 ATP_LEVEL,
220 REQUEST_ITEM_ID,
221 INVENTORY_ITEM_ID,
222 INVENTORY_ITEM_NAME,
223 ORGANIZATION_ID,
224 ORGANIZATION_CODE,
225 DEPARTMENT_ID,
226 DEPARTMENT_CODE,
227 RESOURCE_ID,
228 RESOURCE_CODE,
229 SUPPLIER_ID,
230 SUPPLIER_NAME,
231 SUPPLIER_SITE_ID,
232 SUPPLIER_SITE_NAME,
233 FROM_ORGANIZATION_ID,
234 FROM_ORGANIZATION_CODE,
235 FROM_LOCATION_ID,
236 FROM_LOCATION_CODE,
237 TO_ORGANIZATION_ID,
238 TO_ORGANIZATION_CODE,
239 TO_LOCATION_ID,
240 TO_LOCATION_CODE,
241 SHIP_METHOD,
242 UOM_CODE,
243 IDENTIFIER1,
244 IDENTIFIER2,
245 IDENTIFIER3,
246 IDENTIFIER4,
247 SUPPLY_DEMAND_TYPE,
248 SUPPLY_DEMAND_DATE,
249 SUPPLY_DEMAND_QUANTITY,
250 SUPPLY_DEMAND_SOURCE_TYPE,
251 ALLOCATED_QUANTITY,
252 SOURCE_TYPE,
253 RECORD_TYPE,
254 TOTAL_SUPPLY_QUANTITY,
255 TOTAL_DEMAND_QUANTITY,
256 PERIOD_START_DATE,
257 PERIOD_QUANTITY,
258 CUMULATIVE_QUANTITY,
259 WEIGHT_CAPACITY,
260 VOLUME_CAPACITY,
261 WEIGHT_UOM,
262 VOLUME_UOM,
263 PERIOD_END_DATE,
264 SCENARIO_ID,
265 DISPOSITION_TYPE,
266 DISPOSITION_NAME,
267 REQUEST_ITEM_NAME,
268 SUPPLY_DEMAND_SOURCE_TYPE_NAME,
269 END_PEGGING_ID,
270 CONSTRAINT_FLAG,
271 NUMBER1,
272 CHAR1,
273 COMPONENT_IDENTIFIER,
274 BATCHABLE_FLAG,
275 DEST_INV_ITEM_ID,
276 SUPPLIER_ATP_DATE,
277 SUMMARY_FLAG,
278 PTF_DATE,
279 CREATION_DATE,
280 CREATED_BY,
281 LAST_UPDATE_DATE,
282 LAST_UPDATED_BY,
283 LAST_UPDATE_LOGIN,
284 FIXED_LEAD_TIME,
285 VARIABLE_LEAD_TIME,
286 PREPROCESSING_LEAD_TIME,
287 PROCESSING_LEAD_TIME,
288 POSTPROCESSING_LEAD_TIME,
289 INTRANSIT_LEAD_TIME,
290 ALLOCATION_RULE,
291 INFINITE_TIME_FENCE,
292 SUBSTITUTION_WINDOW,
293 REQUIRED_QUANTITY,
294 ROUNDING_CONTROL,
295 ATP_FLAG,
296 ATP_COMPONENT_FLAG,
297 REQUIRED_DATE,
298 OPERATION_SEQUENCE_ID,
299 SOURCING_RULE_NAME,
300 OFFSET,
301 EFFICIENCY,
302 REVERSE_CUM_YIELD,
303 BASIS_TYPE,
304 USAGE,
305 CONSTRAINT_TYPE,
306 CONSTRAINT_DATE,
307 CRITICAL_PATH,
308 PEGGING_TYPE,
309 UTILIZATION,
310 ATP_RULE_ID,
311 OWNING_DEPARTMENT,
312 ATP_RULE_NAME,
313 PLAN_NAME,
314 CONSTRAINED_PATH,
315 PLAN_ID,
316 DEMAND_CLASS,
317 CLASS,
318 CUSTOMER_NAME,
319 CUSTOMER_SITE_NAME,
320 ALLOCATED_SUPPLY_QUANTITY,
321 SUPPLY_ADJUSTMENT_QUANTITY,
322 BACKWARD_FORWARD_QUANTITY,
323 BACKWARD_QUANTITY,
324 DEMAND_ADJUSTMENT_QUANTITY,
325 ADJUSTED_AVAILABILITY_QUANTITY,
326 ALLOCATION_PERCENT,
327 ACTUAL_ALLOCATION_PERCENT,
328 ADJUSTED_CUM_QUANTITY,
329 CUSTOMER_ID,
330 CUSTOMER_SITE_ID)
331 values
332 (p_atp_details_temp.SESSION_ID(lCounter),
333 p_atp_details_temp.ORDER_LINE_ID(lCounter),
334 p_atp_details_temp.PEGGING_ID(lCounter),
335 p_atp_details_temp.PARENT_PEGGING_ID(lCounter),
336 p_atp_details_temp.ATP_LEVEL(lCounter) ,
337 p_atp_details_temp.REQUEST_ITEM_ID(lCounter),
338 p_atp_details_temp.INVENTORY_ITEM_ID(lCounter),
339 p_atp_details_temp.INVENTORY_ITEM_NAME(lCounter),
340 p_atp_details_temp.ORGANIZATION_ID(lCounter),
341 p_atp_details_temp.ORGANIZATION_CODE(lCounter),
342 p_atp_details_temp.DEPARTMENT_ID(lCounter),
343 p_atp_details_temp.DEPARTMENT_CODE(lCounter),
344 p_atp_details_temp.RESOURCE_ID(lCounter),
345 p_atp_details_temp.RESOURCE_CODE(lCounter),
346 p_atp_details_temp.SUPPLIER_ID(lCounter),
347 p_atp_details_temp.SUPPLIER_NAME(lCounter),
348 p_atp_details_temp.SUPPLIER_SITE_ID(lCounter),
349 p_atp_details_temp.SUPPLIER_SITE_NAME(lCounter),
350 p_atp_details_temp.FROM_ORGANIZATION_ID(lCounter),
351 p_atp_details_temp.FROM_ORGANIZATION_CODE(lCounter),
352 p_atp_details_temp.FROM_LOCATION_ID(lCounter),
353 p_atp_details_temp.FROM_LOCATION_CODE(lCounter),
354 p_atp_details_temp.TO_ORGANIZATION_ID(lCounter),
355 p_atp_details_temp.TO_ORGANIZATION_CODE(lCounter),
356 p_atp_details_temp.TO_LOCATION_ID(lCounter),
357 p_atp_details_temp.TO_LOCATION_CODE(lCounter),
358 p_atp_details_temp.SHIP_METHOD(lCounter),
362 p_atp_details_temp.IDENTIFIER3(lCounter),
359 p_atp_details_temp.UOM_CODE(lCounter),
360 p_atp_details_temp.IDENTIFIER1(lCounter),
361 p_atp_details_temp.IDENTIFIER2(lCounter),
363 p_atp_details_temp.IDENTIFIER4(lCounter),
364 p_atp_details_temp.SUPPLY_DEMAND_TYPE(lCounter),
365 p_atp_details_temp.SUPPLY_DEMAND_DATE(lCounter),
366 p_atp_details_temp.SUPPLY_DEMAND_QUANTITY(lCounter),
367 p_atp_details_temp.SUPPLY_DEMAND_SOURCE_TYPE(lCounter),
368 p_atp_details_temp.ALLOCATED_QUANTITY(lCounter),
369 p_atp_details_temp.SOURCE_TYPE(lCounter),
370 p_atp_details_temp.RECORD_TYPE(lCounter),
371 p_atp_details_temp.TOTAL_SUPPLY_QUANTITY(lCounter),
372 p_atp_details_temp.TOTAL_DEMAND_QUANTITY(lCounter),
373 p_atp_details_temp.PERIOD_START_DATE(lCounter),
374 p_atp_details_temp.PERIOD_QUANTITY(lCounter),
375 p_atp_details_temp.CUMULATIVE_QUANTITY(lCounter),
376 p_atp_details_temp.WEIGHT_CAPACITY(lCounter),
377 p_atp_details_temp.VOLUME_CAPACITY(lCounter),
378 p_atp_details_temp.WEIGHT_UOM(lCounter),
379 p_atp_details_temp.VOLUME_UOM(lCounter),
380 p_atp_details_temp.PERIOD_END_DATE(lCounter),
381 p_atp_details_temp.SCENARIO_ID(lCounter),
382 p_atp_details_temp.DISPOSITION_TYPE(lCounter),
383 p_atp_details_temp.DISPOSITION_NAME(lCounter),
384 p_atp_details_temp.REQUEST_ITEM_NAME(lCounter),
385 p_atp_details_temp.SUPPLY_DEMAND_SOURCE_TYPE_NAME(lCounter),
386 p_atp_details_temp.END_PEGGING_ID(lCounter),
387 p_atp_details_temp.CONSTRAINT_FLAG(lCounter),
388 p_atp_details_temp.NUMBER1(lCounter),
389 p_atp_details_temp.CHAR1(lCounter),
390 p_atp_details_temp.COMPONENT_IDENTIFIER(lCounter),
391 p_atp_details_temp.BATCHABLE_FLAG(lCounter),
392 p_atp_details_temp.DEST_INV_ITEM_ID(lCounter),
393 p_atp_details_temp.SUPPLIER_ATP_DATE(lCounter),
394 p_atp_details_temp.SUMMARY_FLAG(lCounter),
395 p_atp_details_temp.PTF_DATE(lCounter),
396 p_atp_details_temp.CREATION_DATE(lCounter),
397 p_atp_details_temp.CREATED_BY(lCounter),
398 p_atp_details_temp.LAST_UPDATE_DATE(lCounter),
399 p_atp_details_temp.LAST_UPDATED_BY(lCounter),
400 p_atp_details_temp.LAST_UPDATE_LOGIN(lCounter),
401 p_atp_details_temp.FIXED_LEAD_TIME(lCounter),
402 p_atp_details_temp.VARIABLE_LEAD_TIME(lCounter),
403 p_atp_details_temp.PREPROCESSING_LEAD_TIME(lCounter),
404 p_atp_details_temp.PROCESSING_LEAD_TIME(lCounter),
405 p_atp_details_temp.POSTPROCESSING_LEAD_TIME(lCounter),
406 p_atp_details_temp.INTRANSIT_LEAD_TIME(lCounter),
407 p_atp_details_temp.ALLOCATION_RULE(lCounter),
408 p_atp_details_temp.INFINITE_TIME_FENCE(lCounter),
409 p_atp_details_temp.SUBSTITUTION_WINDOW(lCounter),
410 p_atp_details_temp.REQUIRED_QUANTITY(lCounter),
411 p_atp_details_temp.ROUNDING_CONTROL(lCounter),
412 p_atp_details_temp.ATP_FLAG(lCounter),
413 p_atp_details_temp.ATP_COMPONENT_FLAG(lCounter),
414 p_atp_details_temp.REQUIRED_DATE(lCounter),
415 p_atp_details_temp.OPERATION_SEQUENCE_ID(lCounter),
416 p_atp_details_temp.SOURCING_RULE_NAME(lCounter),
417 p_atp_details_temp.OFFSET(lCounter),
418 p_atp_details_temp.EFFICIENCY(lCounter),
419 p_atp_details_temp.REVERSE_CUM_YIELD(lCounter),
420 p_atp_details_temp.BASIS_TYPE(lCounter),
421 p_atp_details_temp.USAGE(lCounter),
422 p_atp_details_temp.CONSTRAINT_TYPE(lCounter),
423 p_atp_details_temp.CONSTRAINT_DATE(lCounter),
424 p_atp_details_temp.CRITICAL_PATH(lCounter),
425 p_atp_details_temp.PEGGING_TYPE(lCounter),
426 p_atp_details_temp.UTILIZATION(lCounter),
427 p_atp_details_temp.ATP_RULE_ID(lCounter),
428 p_atp_details_temp.OWNING_DEPARTMENT(lCounter),
429 p_atp_details_temp.ATP_RULE_NAME(lCounter),
430 p_atp_details_temp.PLAN_NAME(lCounter),
431 p_atp_details_temp.CONSTRAINED_PATH(lCounter),
432 p_atp_details_temp.PLAN_ID(lCounter),
433 p_atp_details_temp.DEMAND_CLASS(lCounter),
434 p_atp_details_temp.CLASS(lCounter),
435 p_atp_details_temp.CUSTOMER_NAME(lCounter),
436 p_atp_details_temp.CUSTOMER_SITE_NAME(lCounter),
437 p_atp_details_temp.ALLOCATED_SUPPLY_QUANTITY(lCounter),
438 p_atp_details_temp.SUPPLY_ADJUSTMENT_QUANTITY(lCounter),
439 p_atp_details_temp.BACKWARD_FORWARD_QUANTITY(lCounter),
440 p_atp_details_temp.BACKWARD_QUANTITY(lCounter),
441 p_atp_details_temp.DEMAND_ADJUSTMENT_QUANTITY(lCounter),
442 p_atp_details_temp.ADJUSTED_AVAILABILITY_QUANTITY(lCounter),
443 p_atp_details_temp.ALLOCATION_PERCENT(lCounter),
444 p_atp_details_temp.ACTUAL_ALLOCATION_PERCENT(lCounter),
445 p_atp_details_temp.ADJUSTED_CUM_QUANTITY(lCounter),
446 p_atp_details_temp.CUSTOMER_ID(lCounter),
447 p_atp_details_temp.CUSTOMER_SITE_ID(lCounter));
448 
449 commit;
450 
451 EXCEPTION
452   WHEN OTHERS THEN
453      p_return_status :='E';
454      p_error_message := substr(sqlerrm,1,100);
455 END populate_details_temp_table;
456 
457 PROCEDURE get_details_temp_rows(p_atp_details_temp  IN OUT NoCopy MSC_ATPUI_UTIL.ATP_details_rec_type,
458                                 p_session_id in NUMBER,
459 				p_return_status out nocopy VARCHAR2,
460 				p_error_message out nocopy VARCHAR2) IS
461 BEGIN
462  p_return_status :='S';
463 SELECT
464 SESSION_ID,
465 ORDER_LINE_ID,
466 PEGGING_ID,
467 PARENT_PEGGING_ID,
468 ATP_LEVEL,
469 REQUEST_ITEM_ID,
470 INVENTORY_ITEM_ID,
471 INVENTORY_ITEM_NAME,
472 ORGANIZATION_ID,
473 ORGANIZATION_CODE,
474 DEPARTMENT_ID,
475 DEPARTMENT_CODE,
476 RESOURCE_ID,
477 RESOURCE_CODE,
478 SUPPLIER_ID,
479 SUPPLIER_NAME,
480 SUPPLIER_SITE_ID,
481 SUPPLIER_SITE_NAME,
482 FROM_ORGANIZATION_ID,
483 FROM_ORGANIZATION_CODE,
484 FROM_LOCATION_ID,
485 FROM_LOCATION_CODE,
486 TO_ORGANIZATION_ID,
487 TO_ORGANIZATION_CODE,
488 TO_LOCATION_ID,
492 IDENTIFIER1,
489 TO_LOCATION_CODE,
490 SHIP_METHOD,
491 UOM_CODE,
493 IDENTIFIER2,
494 IDENTIFIER3,
495 IDENTIFIER4,
496 SUPPLY_DEMAND_TYPE,
497 SUPPLY_DEMAND_DATE,
498 SUPPLY_DEMAND_QUANTITY,
499 SUPPLY_DEMAND_SOURCE_TYPE,
500 ALLOCATED_QUANTITY,
501 SOURCE_TYPE,
502 RECORD_TYPE,
503 TOTAL_SUPPLY_QUANTITY,
504 TOTAL_DEMAND_QUANTITY,
505 PERIOD_START_DATE,
506 PERIOD_QUANTITY,
507 CUMULATIVE_QUANTITY,
508 WEIGHT_CAPACITY,
509 VOLUME_CAPACITY,
510 WEIGHT_UOM,
511 VOLUME_UOM,
512 PERIOD_END_DATE,
513 SCENARIO_ID,
514 DISPOSITION_TYPE,
515 DISPOSITION_NAME,
516 REQUEST_ITEM_NAME,
517 SUPPLY_DEMAND_SOURCE_TYPE_NAME,
518 END_PEGGING_ID,
519 CONSTRAINT_FLAG,
520 NUMBER1,
521 CHAR1,
522 COMPONENT_IDENTIFIER,
523 BATCHABLE_FLAG,
524 DEST_INV_ITEM_ID,
525 SUPPLIER_ATP_DATE,
526 SUMMARY_FLAG,
527 PTF_DATE,
528 CREATION_DATE,
529 CREATED_BY,
530 LAST_UPDATE_DATE,
531 LAST_UPDATED_BY,
532 LAST_UPDATE_LOGIN,
533 FIXED_LEAD_TIME,
534 VARIABLE_LEAD_TIME,
535 PREPROCESSING_LEAD_TIME,
536 PROCESSING_LEAD_TIME,
537 POSTPROCESSING_LEAD_TIME,
538 INTRANSIT_LEAD_TIME,
539 ALLOCATION_RULE,
540 INFINITE_TIME_FENCE,
541 SUBSTITUTION_WINDOW,
542 REQUIRED_QUANTITY,
543 ROUNDING_CONTROL,
544 ATP_FLAG,
545 ATP_COMPONENT_FLAG,
546 REQUIRED_DATE,
547 OPERATION_SEQUENCE_ID,
548 SOURCING_RULE_NAME,
549 OFFSET,
550 EFFICIENCY,
551 REVERSE_CUM_YIELD,
552 BASIS_TYPE,
553 USAGE,
554 CONSTRAINT_TYPE,
555 CONSTRAINT_DATE,
556 CRITICAL_PATH,
557 PEGGING_TYPE,
558 UTILIZATION,
559 ATP_RULE_ID,
560 OWNING_DEPARTMENT,
561 ATP_RULE_NAME,
562 PLAN_NAME,
563 CONSTRAINED_PATH,
564 PLAN_ID,
565 DEMAND_CLASS,
566 CLASS,
567 CUSTOMER_NAME,
568 CUSTOMER_SITE_NAME,
569 ALLOCATED_SUPPLY_QUANTITY,
570 SUPPLY_ADJUSTMENT_QUANTITY,
571 BACKWARD_FORWARD_QUANTITY,
572 BACKWARD_QUANTITY,
573 DEMAND_ADJUSTMENT_QUANTITY,
574 ADJUSTED_AVAILABILITY_QUANTITY,
575 ALLOCATION_PERCENT,
576 ACTUAL_ALLOCATION_PERCENT,
577 ADJUSTED_CUM_QUANTITY,
578 CUSTOMER_ID,
579 CUSTOMER_SITE_ID
580 BULK COLLECT INTO
581 p_atp_details_temp.SESSION_ID,
582 p_atp_details_temp.ORDER_LINE_ID,
583 p_atp_details_temp.PEGGING_ID,
584 p_atp_details_temp.PARENT_PEGGING_ID,
585 p_atp_details_temp.ATP_LEVEL,
586 p_atp_details_temp.REQUEST_ITEM_ID,
587 p_atp_details_temp.INVENTORY_ITEM_ID,
588 p_atp_details_temp.INVENTORY_ITEM_NAME,
589 p_atp_details_temp.ORGANIZATION_ID,
590 p_atp_details_temp.ORGANIZATION_CODE,
591 p_atp_details_temp.DEPARTMENT_ID,
592 p_atp_details_temp.DEPARTMENT_CODE,
593 p_atp_details_temp.RESOURCE_ID,
594 p_atp_details_temp.RESOURCE_CODE,
595 p_atp_details_temp.SUPPLIER_ID,
596 p_atp_details_temp.SUPPLIER_NAME,
597 p_atp_details_temp.SUPPLIER_SITE_ID,
598 p_atp_details_temp.SUPPLIER_SITE_NAME,
599 p_atp_details_temp.FROM_ORGANIZATION_ID,
600 p_atp_details_temp.FROM_ORGANIZATION_CODE,
601 p_atp_details_temp.FROM_LOCATION_ID,
602 p_atp_details_temp.FROM_LOCATION_CODE,
603 p_atp_details_temp.TO_ORGANIZATION_ID,
604 p_atp_details_temp.TO_ORGANIZATION_CODE,
605 p_atp_details_temp.TO_LOCATION_ID,
606 p_atp_details_temp.TO_LOCATION_CODE,
607 p_atp_details_temp.SHIP_METHOD,
608 p_atp_details_temp.UOM_CODE,
609 p_atp_details_temp.IDENTIFIER1,
610 p_atp_details_temp.IDENTIFIER2,
611 p_atp_details_temp.IDENTIFIER3,
612 p_atp_details_temp.IDENTIFIER4,
613 p_atp_details_temp.SUPPLY_DEMAND_TYPE,
614 p_atp_details_temp.SUPPLY_DEMAND_DATE,
615 p_atp_details_temp.SUPPLY_DEMAND_QUANTITY,
616 p_atp_details_temp.SUPPLY_DEMAND_SOURCE_TYPE,
617 p_atp_details_temp.ALLOCATED_QUANTITY,
618 p_atp_details_temp.SOURCE_TYPE,
619 p_atp_details_temp.RECORD_TYPE,
620 p_atp_details_temp.TOTAL_SUPPLY_QUANTITY,
621 p_atp_details_temp.TOTAL_DEMAND_QUANTITY,
622 p_atp_details_temp.PERIOD_START_DATE,
623 p_atp_details_temp.PERIOD_QUANTITY,
624 p_atp_details_temp.CUMULATIVE_QUANTITY,
625 p_atp_details_temp.WEIGHT_CAPACITY,
626 p_atp_details_temp.VOLUME_CAPACITY,
627 p_atp_details_temp.WEIGHT_UOM,
628 p_atp_details_temp.VOLUME_UOM,
629 p_atp_details_temp.PERIOD_END_DATE,
630 p_atp_details_temp.SCENARIO_ID,
631 p_atp_details_temp.DISPOSITION_TYPE,
632 p_atp_details_temp.DISPOSITION_NAME,
633 p_atp_details_temp.REQUEST_ITEM_NAME,
634 p_atp_details_temp.SUPPLY_DEMAND_SOURCE_TYPE_NAME,
635 p_atp_details_temp.END_PEGGING_ID,
636 p_atp_details_temp.CONSTRAINT_FLAG,
637 p_atp_details_temp.NUMBER1,
638 p_atp_details_temp.CHAR1,
639 p_atp_details_temp.COMPONENT_IDENTIFIER,
640 p_atp_details_temp.BATCHABLE_FLAG,
641 p_atp_details_temp.DEST_INV_ITEM_ID,
642 p_atp_details_temp.SUPPLIER_ATP_DATE,
643 p_atp_details_temp.SUMMARY_FLAG,
644 p_atp_details_temp.PTF_DATE,
645 p_atp_details_temp.CREATION_DATE,
646 p_atp_details_temp.CREATED_BY,
647 p_atp_details_temp.LAST_UPDATE_DATE,
648 p_atp_details_temp.LAST_UPDATED_BY,
649 p_atp_details_temp.LAST_UPDATE_LOGIN,
650 p_atp_details_temp.FIXED_LEAD_TIME,
651 p_atp_details_temp.VARIABLE_LEAD_TIME,
652 p_atp_details_temp.PREPROCESSING_LEAD_TIME,
653 p_atp_details_temp.PROCESSING_LEAD_TIME,
654 p_atp_details_temp.POSTPROCESSING_LEAD_TIME,
655 p_atp_details_temp.INTRANSIT_LEAD_TIME,
656 p_atp_details_temp.ALLOCATION_RULE,
657 p_atp_details_temp.INFINITE_TIME_FENCE,
658 p_atp_details_temp.SUBSTITUTION_WINDOW,
659 p_atp_details_temp.REQUIRED_QUANTITY,
663 p_atp_details_temp.REQUIRED_DATE,
660 p_atp_details_temp.ROUNDING_CONTROL,
661 p_atp_details_temp.ATP_FLAG,
662 p_atp_details_temp.ATP_COMPONENT_FLAG,
664 p_atp_details_temp.OPERATION_SEQUENCE_ID,
665 p_atp_details_temp.SOURCING_RULE_NAME,
666 p_atp_details_temp.OFFSET,
667 p_atp_details_temp.EFFICIENCY,
668 p_atp_details_temp.REVERSE_CUM_YIELD,
669 p_atp_details_temp.BASIS_TYPE,
670 p_atp_details_temp.USAGE,
671 p_atp_details_temp.CONSTRAINT_TYPE,
672 p_atp_details_temp.CONSTRAINT_DATE,
673 p_atp_details_temp.CRITICAL_PATH,
674 p_atp_details_temp.PEGGING_TYPE,
675 p_atp_details_temp.UTILIZATION,
676 p_atp_details_temp.ATP_RULE_ID,
677 p_atp_details_temp.OWNING_DEPARTMENT,
678 p_atp_details_temp.ATP_RULE_NAME,
679 p_atp_details_temp.PLAN_NAME,
680 p_atp_details_temp.CONSTRAINED_PATH,
681 p_atp_details_temp.PLAN_ID,
682 p_atp_details_temp.DEMAND_CLASS,
683 p_atp_details_temp.CLASS,
684 p_atp_details_temp.CUSTOMER_NAME,
685 p_atp_details_temp.CUSTOMER_SITE_NAME,
686 p_atp_details_temp.ALLOCATED_SUPPLY_QUANTITY,
687 p_atp_details_temp.SUPPLY_ADJUSTMENT_QUANTITY,
688 p_atp_details_temp.BACKWARD_FORWARD_QUANTITY,
689 p_atp_details_temp.BACKWARD_QUANTITY,
690 p_atp_details_temp.DEMAND_ADJUSTMENT_QUANTITY,
691 p_atp_details_temp.ADJUSTED_AVAILABILITY_QUANTITY,
692 p_atp_details_temp.ALLOCATION_PERCENT,
693 p_atp_details_temp.ACTUAL_ALLOCATION_PERCENT,
694 p_atp_details_temp.ADJUSTED_CUM_QUANTITY,
695 p_atp_details_temp.CUSTOMER_ID,
696 p_atp_details_temp.CUSTOMER_SITE_ID
697 FROM  mrp_atp_details_temp
698 WHERE session_id = p_session_id;
699 
700 
701 EXCEPTION
702   WHEN OTHERS THEN
703      p_return_status :='E';
704      p_error_message := substr(sqlerrm,1,100);
705 END get_details_temp_rows;
706 
707 PROCEDURE populate_mrp_atp_temp_tables(p_session_id in NUMBER,
708 				p_return_status out nocopy VARCHAR2,
709 				p_error_message out nocopy VARCHAR2) IS
710 BEGIN
711      p_return_status :='S';
712      get_schedule_temp_rows(p_session_id,p_return_status, p_error_message);
713 EXCEPTION
714   WHEN OTHERS THEN
715      p_return_status :='E';
716      p_error_message := substr(sqlerrm,1,100);
717 
718 END populate_mrp_atp_temp_tables;
719 
720 END MSC_ATPUI_UTIL ;