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: APPS.MRP_ATP_PUB

Source


1 PACKAGE MRP_ATP_PUB AS
2 /* $Header: MRPEATPS.pls 120.4 2008/01/03 10:44:53 avjain ship $  */
3 
4 TYPE number_arr IS TABLE OF number;
5 TYPE char1_arr IS TABLE of varchar2(1);
6 TYPE char3_arr IS TABLE OF varchar2(3);
7 TYPE char7_arr IS TABLE OF varchar2(7);
8 TYPE char10_arr IS TABLE OF varchar2(10);
9 TYPE char14_arr IS TABLE of varchar2(14); -- For ship_rec_cal
10 TYPE char15_arr IS TABLE of varchar2(15);
11 TYPE char16_arr IS TABLE of varchar2(16); --4774169
12 TYPE char20_arr  IS TABLE of varchar2(20);
13 TYPE char30_arr IS TABLE OF varchar2(30);
14 TYPE char40_arr IS TABLE OF varchar2(40);
15 TYPE char60_arr IS TABLE OF varchar2(60);
16 TYPE char62_arr IS TABLE OF varchar2(62);
17 TYPE char80_arr IS TABLE of varchar2(80);
18 TYPE char255_arr IS TABLE of varchar2(255);
19 TYPE char2000_arr IS TABLE of varchar2(2000);
20 TYPE date_arr IS TABLE OF date;
21 
22 TYPE ATP_Supply_Demand_Typ is RECORD (
23 Level				number_arr := number_arr(),
24 Identifier                      number_arr := number_arr(),
25 Inventory_Item_Id               number_arr := number_arr(),
26 Request_Item_Id			number_arr := number_arr(),
27 Organization_Id                 number_arr := number_arr(),
28 Department_Id			number_arr := number_arr(),
29 Resource_Id			number_arr := number_arr(),
30 Supplier_Id			number_arr := number_arr(),
31 Supplier_Site_Id		number_arr := number_arr(),
32 From_Organization_Id		number_arr := number_arr(),
33 From_Location_Id		number_arr := number_arr(),
34 To_Organization_Id		number_arr := number_arr(),
35 To_Location_Id			number_arr := number_arr(),
36 Ship_Method			char30_arr := char30_arr(),
37 Uom				char3_arr := char3_arr(),
38 Disposition_Type                number_arr := number_arr(),
39 Disposition_Name		char80_arr := char80_arr(),
40 Identifier1                     number_arr := number_arr(),
41 Identifier2                     number_arr := number_arr(),
42 Identifier3                     number_arr := number_arr(),
43 Identifier4                     number_arr := number_arr(),
44 Supply_Demand_Type              number_arr := number_arr(),
45 Supply_Demand_Source_Type       number_arr := number_arr(),
46 Supply_Demand_Source_Type_Name  char80_arr := char80_arr(),
47 Supply_Demand_Date              date_arr := date_arr(),
48 Supply_Demand_Quantity          number_arr := number_arr(),
49 Scenario_Id                     number_arr := number_arr(),
50 Pegging_Id                      number_arr := number_arr(),
51 End_Pegging_Id                  number_arr := number_arr(),
52 -- time_phased_atp
53 Original_Item_Id                number_arr := number_arr(),
54 Original_Supply_Demand_Type     number_arr := number_arr(),
55 Original_Demand_Date            date_arr   := date_arr(),
56 Original_Demand_Quantity        number_arr := number_arr(),
57 Allocated_Quantity              number_arr := number_arr(),
58 Pf_Display_Flag                 number_arr := number_arr()
59 );
60 
61 TYPE ATP_Period_Typ is Record (
62 Level                           number_arr := number_arr(),
63 Identifier                      number_arr := number_arr(),
64 Inventory_Item_Id		number_arr := number_arr(),
65 Request_Item_Id                 number_arr := number_arr(),
66 Organization_Id			number_arr := number_arr(),
67 Department_Id                   number_arr := number_arr(),
68 Resource_Id                     number_arr := number_arr(),
69 Supplier_Id                     number_arr := number_arr(),
70 Supplier_Site_Id                number_arr := number_arr(),
71 From_Organization_Id            number_arr := number_arr(),
72 From_Location_Id                number_arr := number_arr(),
73 To_Organization_Id              number_arr := number_arr(),
74 To_Location_Id                  number_arr := number_arr(),
75 Ship_Method                     char30_arr := char30_arr(),
76 Uom                             char3_arr := char3_arr(),
77 Total_Supply_Quantity		number_arr := number_arr(),
78 Total_Demand_Quantity		number_arr := number_arr(),
79 Period_Start_Date               date_arr := date_arr(),
80 Period_End_Date                 date_arr := date_arr(),
81 Period_Quantity                 number_arr := number_arr(),
82 Cumulative_Quantity             number_arr := number_arr(),
83 Identifier1                     number_arr := number_arr(),
84 Identifier2                     number_arr := number_arr(),
85 Scenario_Id                     number_arr := number_arr(),
86 Pegging_Id                      number_arr := number_arr(),
87 End_Pegging_Id                  number_arr := number_arr(),
88 --ssurendr 25-NOV-2002: New fields added for alloc w/b
89 Identifier4			number_arr := number_arr(), -- Sysdate allocation percent. Used only in rule based case
90 Demand_Class			char80_arr := char80_arr(), -- Demand class in DC case; Level 3 Demand class in CC case
91 Class				char80_arr := char80_arr(), -- Customer class. Used only in customer class case
92 Customer_Id			number_arr := number_arr(), -- Customer Id. Used only in customer class case
93 Customer_Site_Id		number_arr := number_arr(), -- Customer site Id. Used only in customer class case
94 Allocated_Supply_Quantity	number_arr := number_arr(), -- Supply allocated to a demand class on a date
95 Supply_Adjustment_Quantity	number_arr := number_arr(), -- Supply adjusment. Used only in demand priority case
96 Backward_Forward_Quantity	number_arr := number_arr(), -- Figures after b/w:f/w consumption. Used only in demand priority case
97 Backward_Quantity		number_arr := number_arr(), -- Figures after b/w consumption. Used only in rule based case
98 Demand_Adjustment_Quantity	number_arr := number_arr(), -- Demand adjusment. Used only in rule based case
99 Adjusted_Availability_Quantity	number_arr := number_arr(), -- Figures after DC consumption (and f/w consumption in method 1)
100                                             -- Used only in rule based case
101 Adjusted_Cum_Quantity		number_arr := number_arr(), -- Adjusted Cum. Used only in rule based and method 2
102 Unallocated_Supply_Quantity	number_arr := number_arr(), -- Unallocated supply. Used only in rule based and method 2
103 Unallocated_Demand_Quantity	number_arr := number_arr(), -- Unallocated demand. Used only in rule based and method 2
104 Unallocated_Net_Quantity	number_arr := number_arr(), -- Unallocated net. Used only in rule based and method 2
105 -- time_phased_atp
106 Total_Bucketed_Demand_Quantity  number_arr := number_arr(), -- Bucketed Demand. Used only in PF time phased ATP
107 -- bug 3282426
108 Unalloc_Bucketed_Demand_Qty     number_arr := number_arr()  -- Unallocated bucketed demand. Used in rule based + time phased ATP
109 );
110 
111 TYPE ATP_Details_Typ is RECORD (
112 Level				number_arr := number_arr(),
113 Identifier                      number_arr := number_arr(),
114 Request_Item_Id			number_arr := number_arr(),
115 Request_Item_Name		char40_arr := char40_arr(),
116 Inventory_Item_Id               number_arr := number_arr(),
117 Inventory_Item_Name		char40_arr := char40_arr(),
118 Organization_Id                 number_arr := number_arr(),
119 Organization_Code               char3_arr := char3_arr(),
120 Department_Id                   number_arr := number_arr(),
121 Department_Code                 char10_arr := char10_arr(),
122 Resource_Id                     number_arr := number_arr(),
123 Resource_Code                   char10_arr := char10_arr(),
124 Supplier_Id                     number_arr := number_arr(),
125 Supplier_Name                   char80_arr := char80_arr(),
126 Supplier_Site_Id                number_arr := number_arr(),
127 From_Organization_Id            number_arr := number_arr(),
128 From_Organization_Code          char3_arr := char3_arr(),
129 From_Location_Id                number_arr := number_arr(),
130 From_Location_Code              char20_arr := char20_arr(),
131 To_Organization_Id              number_arr := number_arr(),
132 To_Organization_Code            char3_arr := char3_arr(),
133 To_Location_Id                  number_arr := number_arr(),
134 To_Location_Code                char20_arr := char20_arr(),
135 Ship_Method                     char30_arr := char30_arr(),
136 Uom                             char3_arr := char3_arr(),
137 Supply_Demand_Type		number_arr := number_arr(),
138 Supply_Demand_Quantity		number_arr := number_arr(),
139 Source_Type			number_arr := number_arr(),
140 Identifier1                     number_arr := number_arr(),
141 Identifier2			number_arr := number_arr(),
142 Identifier3                     number_arr := number_arr(),
143 Identifier4                     number_arr := number_arr(),
144 Scenario_Id                     number_arr := number_arr()
145 );
146 
147 
148 -- NGOEL 6/14, added ato_delete_flag and attribute_01 to attribute_10
149 -- for any future requirements.
150 
151 TYPE ATP_Rec_Typ is RECORD (
152 Row_Id				char30_arr := char30_arr(),
153 Instance_Id                     number_arr := number_arr(),
154 Inventory_Item_Id               number_arr := number_arr(),
155 Inventory_Item_Name		char40_arr := char40_arr(),
156 Source_Organization_Id          number_arr := number_arr(),
157 Source_Organization_Code	char7_arr := char7_arr(),
158 Organization_Id 		number_arr := number_arr(),
159 Identifier                      number_arr := number_arr(),
160 Demand_Source_Header_Id		number_arr := number_arr(),
161 Demand_Source_Delivery          char30_arr := char30_arr(),
162 Demand_Source_Type              number_arr := number_arr(),
163 Scenario_Id			number_arr := number_arr(),
164 Calling_Module                  number_arr := number_arr(),
165 Customer_Id                  	number_arr := number_arr(),
166 Customer_Site_Id                number_arr := number_arr(),
167 Destination_Time_Zone           char30_arr := char30_arr(),
168 Quantity_Ordered                number_arr := number_arr(),
169 Quantity_UOM                    char3_arr := char3_arr(),
170 Requested_Ship_Date             date_arr := date_arr(),
171 Requested_Arrival_Date          date_arr := date_arr(),
172 Earliest_Acceptable_Date        date_arr := date_arr(),
173 Latest_Acceptable_Date          date_arr := date_arr(),
174 Delivery_Lead_Time              number_arr := number_arr(),
175 Freight_Carrier                 char30_arr := char30_arr(),
176 Ship_Method                     char30_arr := char30_arr(),
177 Demand_Class                    char30_arr := char30_arr(),
178 Ship_Set_Name                   char30_arr := char30_arr(),
179 Arrival_Set_Name                char30_arr := char30_arr(),
180 Override_Flag                   char1_arr := char1_arr(),
181 Action                          number_arr := number_arr(),
182 Ship_Date                       date_arr := date_arr(),
183 Arrival_date 			date_arr := date_arr(),
184 Available_Quantity              number_arr := number_arr(),
185 Requested_Date_Quantity         number_arr := number_arr(),
186 Group_Ship_Date                 date_arr := date_arr(),
187 Group_Arrival_Date              date_arr := date_arr(),
188 Vendor_Id			number_arr := number_arr(),
189 Vendor_Name			char80_arr := char80_arr(),
190 Vendor_Site_Id			number_arr := number_arr(),
191 Vendor_Site_Name		char80_arr := char80_arr(),
192 Insert_Flag                     number_arr := number_arr(),
193 OE_Flag                         char1_arr := char1_arr(),
194 Atp_Lead_Time                   number_arr := number_arr(),
195 Error_Code			number_arr := number_arr(),
196 Message                         char2000_arr := char2000_arr(),
197 End_Pegging_Id			number_arr := number_arr(),
198 Order_Number                    number_arr := number_arr(),
199 Old_Source_Organization_Id      number_arr := number_arr(),
200 Old_Demand_Class                char30_arr := char30_arr(),
201 ato_delete_flag			char1_arr := char1_arr(),
202 attribute_01      		number_arr := number_arr(),	-- used for source_document_line_id for internal SO
203 attribute_02      		number_arr := number_arr(),
204 attribute_03      		number_arr := number_arr(),
205 attribute_04      		number_arr := number_arr(),     -- used for 24x7 ATP - stores refresh number
206 attribute_05                	char30_arr := char30_arr(),	-- used for procure CTO for setting visible demand flag
207 attribute_06                	char30_arr := char30_arr(),	-- used for sending ATP_Flag from source to destination
208 attribute_07                	char30_arr := char30_arr(),
209 attribute_08                	char30_arr := char30_arr(),
210 attribute_09			date_arr := date_arr(),
211 attribute_10			date_arr := date_arr(),
212 -- start of new attributes for region level sourcing
213 --customer_name			char80_arr := char80_arr(),
214 customer_name			char255_arr := char255_arr(),--3991728
215 customer_class			char30_arr := char30_arr(),
216 customer_location		char40_arr := char40_arr(),
217 customer_country		char60_arr := char60_arr(),
218 customer_state			char60_arr := char60_arr(),
219 customer_city			char60_arr := char60_arr(),
220 customer_postal_code		char60_arr := char60_arr(),
221 -- end of new attributes for region level sourcing
222 --- new columns for Product substitution
223 substitution_typ_code           number_arr := number_arr(),
224 req_item_detail_flag            number_arr := number_arr(),
225 request_item_id                 number_arr := number_arr(),
226 req_item_req_date_qty           number_arr := number_arr(),
227 req_item_available_date         date_arr := date_arr(),
228 req_item_available_date_qty     number_arr := number_arr(),
229 request_item_name               char40_arr := char40_arr(),
230 old_inventory_item_id           number_arr := number_arr(),
231 sales_rep                       char255_arr := char255_arr(),
232 customer_contact                char255_arr := char255_arr(),
233 subst_flag                      number_arr := number_arr(),
234 ---new column for CTO enhancement project
235 Top_Model_line_id               number_arr := number_arr(),
236 ATO_Parent_Model_Line_Id        number_arr := number_arr(),
237 ATO_Model_Line_Id               number_arr := number_arr(),
238 Parent_line_id                  number_arr := number_arr(),
239 match_item_id                   number_arr := number_arr(),
240 Config_item_line_id             number_arr := number_arr(),
241 Validation_Org                  number_arr := number_arr(),
242 Component_Sequence_ID           number_arr := number_arr(),
243 Component_Code                  char255_arr := char255_arr(),
244 line_number                     char80_arr := char80_arr(),
245 included_item_flag              number_arr := number_arr(),
246 atp_flag                        char1_arr  := char1_arr(),
247 atp_components_flag             char1_arr  := char1_arr(),
248 wip_supply_type                 number_arr := number_arr(),
249 bom_item_type                   number_arr := number_arr(),
250 mandatory_item_flag             number_arr := number_arr(),
251 pick_components_flag            char1_arr := char1_arr(),
252 base_model_id                   number_arr := number_arr(),
253 OSS_ERROR_CODE                  number_arr := number_arr(),
254 matched_item_name               char255_arr := char255_arr(),
255 cascade_model_info_to_comp      number_arr := number_arr(),
256 --columns for backlog workbench
257 sequence_number                 number_arr := number_arr(),
258 firm_flag                       number_arr := number_arr(),
259 order_line_number               number_arr := number_arr(),
260 option_number                   number_arr := number_arr(),
261 shipment_number                 number_arr := number_arr(),
262 item_desc                       char255_arr := char255_arr(),
263 old_line_schedule_date          date_arr := date_arr(),
264 old_source_organization_code    char7_arr := char7_arr(),
265 firm_source_org_id              number_arr := number_arr(),
266 firm_source_org_code            char7_arr := char7_arr(),
267 firm_ship_date                  date_arr := date_arr(),
268 firm_arrival_date               date_arr := date_arr(),
272 PROJECT_ID                      number_arr := number_arr(),
269 ship_method_text                char255_arr := char255_arr(),
270 ship_set_id                     number_arr := number_arr(),
271 arrival_set_id                  number_arr := number_arr(),
273 TASK_ID                         number_arr := number_arr(),
274 PROJECT_NUMBER                  char30_arr := char30_arr(),
275 TASK_NUMBER                     char30_arr := char30_arr(),
276 attribute_11                    number_arr := number_arr(),
277 attribute_12                    number_arr := number_arr(),
278 attribute_13                    number_arr := number_arr(),
279 attribute_14                    number_arr := number_arr(),
280 attribute_15                    char30_arr := char30_arr(),
281 attribute_16                    char30_arr := char30_arr(),
282 attribute_17                    char30_arr := char30_arr(),
283 attribute_18                    char30_arr := char30_arr(),
284 attribute_19                    date_arr := date_arr(),
285 attribute_20                    date_arr := date_arr(),
286 Attribute_21                    number_arr := number_arr(),
287 attribute_22                    number_arr := number_arr(),
288 attribute_23                    number_arr := number_arr(),
289 attribute_24                    number_arr := number_arr(),
290 attribute_25                    char30_arr := char30_arr(),
291 attribute_26                    char30_arr := char30_arr(),
292 attribute_27                    char30_arr := char30_arr(),
293 attribute_28                    char30_arr := char30_arr(),
294 attribute_29                    date_arr := date_arr(),
295 attribute_30                    date_arr := date_arr(),
296 -- time_phased_atp
297 atf_date                        date_arr := date_arr(),
298 plan_id                         number_arr := number_arr(),
299 --request by plan
300 original_request_date		date_arr := date_arr(),
301 -- ship_rec_cal
302 receiving_cal_code              char14_arr := char14_arr(),
303 intransit_cal_code              char14_arr := char14_arr(),
304 shipping_cal_code               char14_arr := char14_arr(),
305 manufacturing_cal_code          char14_arr := char14_arr(),
306 --3409286
307 internal_org_id                number_arr := number_arr(),
308 --bug 3328421
309 first_valid_ship_arrival_date  date_arr := date_arr(),
310 --2814895
311 party_site_id      		number_arr := number_arr(),
312 part_of_set                    char1_arr := char1_arr() --4500382
313 );
314 
315 
316 -- Added by ngoel 10/13/2000. This type is required for supporting
317 -- multi-level multi-org CTO models from OM and CZ modules.
318 
319 TYPE ATP_BOM_Rec_Typ is RECORD (
320 assembly_identifier     	number_arr := number_arr(),
321 assembly_item_id        	number_arr := number_arr(),
322 component_identifier 		number_arr := number_arr(),
323 component_item_id 		number_arr := number_arr(),
324 quantity                	number_arr := number_arr(),
325 fixed_lt                	number_arr := number_arr(),
326 variable_lt             	number_arr := number_arr(),
327 pre_process_lt			number_arr := number_arr(),
328 effective_date			date_arr := date_arr(),
329 disable_date			date_arr := date_arr(),
330 atp_check			number_arr := number_arr(),
331 wip_supply_type			number_arr := number_arr(),
332 smc_flag			char1_arr := char1_arr(),
333 source_organization_id          number_arr := number_arr(),     -- 2400614 : krajan
334 atp_flag                        char1_arr := char1_arr()       -- 2462661 : krajan
335 );
336 
337 
338 
339 -- Added by ngoel 10/26/2000. This type is required for supporting
340 -- multi-level multi-org CTO models from OM and CZ modules.
341 
342 TYPE shipset_status_rec_type is RECORD (
343 Ship_Set_Name                   char30_arr := char30_arr(),
344 Status                          char1_arr := char1_arr());
345 
346 
347 PROCEDURE Call_ATP (
348                p_session_id	    IN OUT NoCopy NUMBER,
349                p_atp_rec            IN    MRP_ATP_PUB.ATP_Rec_Typ,
350                x_atp_rec            OUT   NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
351 	       x_atp_supply_demand  OUT   NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
352                x_atp_period         OUT   NoCopy MRP_ATP_PUB.ATP_Period_Typ,
353 	       x_atp_details        OUT   NoCopy MRP_ATP_PUB.ATP_Details_Typ,
354                x_return_status      OUT   NoCopy VARCHAR2,
355                x_msg_data           OUT   NoCopy VARCHAR2,
356                x_msg_count          OUT   NoCopy NUMBER
357 );
358 
359 PROCEDURE Call_ATP_No_Commit (
360                p_session_id         IN OUT NoCopy NUMBER,
361                p_atp_rec            IN    MRP_ATP_PUB.ATP_Rec_Typ,
362                x_atp_rec            OUT   NoCopy MRP_ATP_PUB.ATP_Rec_Typ,
363                x_atp_supply_demand  OUT   NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
364                x_atp_period         OUT   NoCopy MRP_ATP_PUB.ATP_Period_Typ,
365                x_atp_details        OUT   NoCopy MRP_ATP_PUB.ATP_Details_Typ,
369 );
366                x_return_status      OUT   NoCopy VARCHAR2,
367                x_msg_data           OUT   NoCopy VARCHAR2,
368                x_msg_count          OUT   NoCopy NUMBER
370 
371 
372 END MRP_ATP_PUB;