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.OE_ATP

Source


1 PACKAGE OE_ATP AS
2 /* $Header: OEXVATPS.pls 120.2 2005/12/02 06:41:42 rmoharan ship $ */
3 
4 --  Global constant holding the package name
5 
6 TYPE Atp_Rec_Type IS RECORD
7 ( org_id                        NUMBER  --4772886
8 , line_id                       NUMBER
9 , header_id                     NUMBER
10 , line_number                   NUMBER
11 , shipment_number               NUMBER
12 , option_number                 NUMBER
13 , component_Number              NUMBER
14 , item_input                    VARCHAR2(2000)
15 , inventory_item_id             NUMBER
16 , ordered_quantity              NUMBER
17 , order_quantity_uom            VARCHAR2(3)
18 , request_date                  DATE
19 , ship_from_org_id              NUMBER
20 , qty_on_request_date           NUMBER
21 , ordered_qty_Available_Date    DATE
22 , qty_on_available_date         NUMBER
23 , schedule_ship_date            DATE
24 , freight_carrier_code          NUMBER
25 , shipping_method_code          VARCHAR2(30)
26 , on_hand_qty                   NUMBER
27 , available_to_reserve          NUMBER
28 , error_message                 VARCHAR2(80)
29 -- Group Attributes
30 , ship_set                      VARCHAR2(30)
31 , arrival_set                   VARCHAR2(30)
32 , ship_model_complete_flag      VARCHAR2(30)
33 , ato_set                       VARCHAR2(30)
34 , group_available_date          DATE
35 -- Item Substitution
36 , request_item_id               NUMBER
37 , request_item_name             VARCHAR2(2000)
38 , req_item_req_date_qty         NUMBER
39 , req_item_available_date       DATE
40 , req_item_available_date_qty   NUMBER
41 , sub_on_hand_qty               NUMBER
42 , sub_available_to_reserve      NUMBER
43 , substitute_flag               VARCHAR2(1)
44 , Substitute_item_name          VARCHAR2(2000)
45 , Ordered_item_name             VARCHAR2(2000)
46 );
47 
48 TYPE Atp_Tbl_Type IS table of Atp_Rec_Type
49      INDEX BY BINARY_INTEGER;
50 
51 /*
52 TYPE Sch_Line_Rec_Type IS RECORD
53 ( line_id                       NUMBER
54 , inventory_item_id             NUMBER
55 , item_type_code                VARCHAR2(30)
56 , ordered_quantiTY              NUMBER
57 , order_quantity_uom            VARCHAR2(3)
58 , request_date                  DATE
59 , ship_from_org_id              NUMBER
60 , qty_on_request_date           NUMBER
61 , ordered_qty_Available_Date    DATE
62 , schedule_ship_date            DATE
63 , freight_carrier_code          NUMBER
64 , shipping_method_code          VARCHAR2(30)
65 );
66 */
67 
68 TYPE Sch_Tbl_Type IS table of Atp_Rec_Type
69  INDEX BY BINARY_INTEGER;
70 
71 
72 TYPE Line_Atp_Rec_Type IS RECORD
73 (   accounting_rule_id            NUMBER
74 ,   actual_arrival_date           DATE
75 ,   actual_shipment_date          DATE
76 ,   agreement_id                  NUMBER
77 ,   arrival_set_id                NUMBER
78 ,   ato_line_id                   NUMBER
79 ,   attribute1                    VARCHAR2(240)
80 ,   attribute10                   VARCHAR2(240)
81 ,   attribute11                   VARCHAR2(240)
82 ,   attribute12                   VARCHAR2(240)
83 ,   attribute13                   VARCHAR2(240)
84 ,   attribute14                   VARCHAR2(240)
85 ,   attribute15                   VARCHAR2(240)
86 ,   attribute2                    VARCHAR2(240)
87 ,   attribute3                    VARCHAR2(240)
88 ,   attribute4                    VARCHAR2(240)
89 ,   attribute5                    VARCHAR2(240)
90 ,   attribute6                    VARCHAR2(240)
91 ,   attribute7                    VARCHAR2(240)
92 ,   attribute8                    VARCHAR2(240)
93 ,   attribute9                    VARCHAR2(240)
94 ,   authorized_to_ship_flag	    VARCHAR2(1)
95 ,   auto_selected_quantity        NUMBER
96 ,   Booked_flag                   VARCHAR2(1)
97 ,   cancelled_flag		         VARCHAR2(1)
98 ,   cancelled_quantity            NUMBER
99 ,   component_code                VARCHAR2(1000)
100 ,   component_number              NUMBER
101 ,   component_sequence_id         NUMBER
102 ,   config_display_sequence       NUMBER
103 ,   top_model_line_id             NUMBER
104 ,   top_model_line_index          NUMBER
105 ,   context                       VARCHAR2(30)
106 ,   created_by                    NUMBER
107 ,   creation_date                 DATE
108 ,   customer_dock_code            VARCHAR2(50)
109 ,   customer_item_id              NUMBER
110 ,   customer_item_revision        VARCHAR2(50)
111 ,   customer_job                  VARCHAR2(50)
112 ,   customer_production_line      VARCHAR2(50)
113 ,   customer_trx_line_id          NUMBER
114 ,   cust_model_serial_number      VARCHAR2(50)
115 ,   cust_po_number                VARCHAR2(50)
116 ,   cust_production_seq_num	    VARCHAR2(50)
117 ,   delivery_lead_time            NUMBER
118 ,   deliver_to_contact_id         NUMBER
119 ,   deliver_to_org_id             NUMBER
120 ,   demand_bucket_type_code       VARCHAR2(30)
121 ,   demand_class_code             VARCHAR2(30)
122 ,   dep_plan_required_flag        VARCHAR2(1)
123 ,   earliest_acceptable_date      DATE
124 ,   explosion_date                DATE
125 ,   fob_point_code                VARCHAR2(30)
126 ,   freight_carrier_code          VARCHAR2(30)
127 ,   freight_terms_code            VARCHAR2(30)
128 ,   fulfilled_quantity            NUMBER
129 ,   global_attribute1             VARCHAR2(240)
130 ,   global_attribute10            VARCHAR2(240)
131 ,   global_attribute11            VARCHAR2(240)
132 ,   global_attribute12            VARCHAR2(240)
133 ,   global_attribute13            VARCHAR2(240)
134 ,   global_attribute14            VARCHAR2(240)
135 ,   global_attribute15            VARCHAR2(240)
136 ,   global_attribute16            VARCHAR2(240)
137 ,   global_attribute17            VARCHAR2(240)
138 ,   global_attribute18            VARCHAR2(240)
139 ,   global_attribute19            VARCHAR2(240)
140 ,   global_attribute2             VARCHAR2(240)
141 ,   global_attribute20            VARCHAR2(240)
142 ,   global_attribute3             VARCHAR2(240)
143 ,   global_attribute4             VARCHAR2(240)
144 ,   global_attribute5             VARCHAR2(240)
145 ,   global_attribute6             VARCHAR2(240)
146 ,   global_attribute7             VARCHAR2(240)
147 ,   global_attribute8             VARCHAR2(240)
148 ,   global_attribute9             VARCHAR2(240)
149 ,   global_attribute_category     VARCHAR2(30)
150 ,   header_id                     NUMBER
151 ,   industry_attribute1           VARCHAR2(240)
152 ,   industry_attribute10          VARCHAR2(240)
153 ,   industry_attribute11          VARCHAR2(240)
154 ,   industry_attribute12          VARCHAR2(240)
155 ,   industry_attribute13          VARCHAR2(240)
156 ,   industry_attribute14          VARCHAR2(240)
157 ,   industry_attribute15          VARCHAR2(240)
158 ,   industry_attribute16          VARCHAR2(240)
159 ,   industry_attribute17          VARCHAR2(240)
160 ,   industry_attribute18          VARCHAR2(240)
161 ,   industry_attribute19          VARCHAR2(240)
162 ,   industry_attribute20          VARCHAR2(240)
163 ,   industry_attribute21          VARCHAR2(240)
164 ,   industry_attribute22          VARCHAR2(240)
165 ,   industry_attribute23          VARCHAR2(240)
166 ,   industry_attribute24          VARCHAR2(240)
167 ,   industry_attribute25          VARCHAR2(240)
168 ,   industry_attribute26          VARCHAR2(240)
169 ,   industry_attribute27          VARCHAR2(240)
170 ,   industry_attribute28          VARCHAR2(240)
171 ,   industry_attribute29          VARCHAR2(240)
172 ,   industry_attribute30          VARCHAR2(240)
173 ,   industry_attribute2           VARCHAR2(240)
174 ,   industry_attribute3           VARCHAR2(240)
175 ,   industry_attribute4           VARCHAR2(240)
176 ,   industry_attribute5           VARCHAR2(240)
177 ,   industry_attribute6           VARCHAR2(240)
178 ,   industry_attribute7           VARCHAR2(240)
179 ,   industry_attribute8           VARCHAR2(240)
180 ,   industry_attribute9           VARCHAR2(240)
181 ,   industry_context              VARCHAR2(30)
182 ,   intermed_ship_to_org_id       NUMBER
183 ,   intermed_ship_to_contact_id   NUMBER
184 ,   inventory_item_id             NUMBER
185 ,   invoice_complete_flag         VARCHAR2(1)
186 ,   invoice_to_contact_id         NUMBER
187 ,   invoice_to_org_id             NUMBER
188 ,   invoicing_rule_id             NUMBER
189 ,   item_input                    VARCHAR2(2000)
190 ,   item_revision                 VARCHAR2(3)
191 ,   item_type_code                VARCHAR2(30)
192 ,   last_updated_by               NUMBER
193 ,   last_update_date              DATE
194 ,   last_update_login             NUMBER
195 ,   latest_acceptable_date        DATE
196 ,   line_category_code            VARCHAR2(30)
197 ,   line_id                       NUMBER
198 ,   line_number                   NUMBER
199 ,   line_type_id                  NUMBER
200 ,   link_to_line_id               NUMBER
201 ,   link_to_line_index            NUMBER
202 ,   model_group_number            NUMBER
203 ,   open_flag                     VARCHAR2(1)
204 ,   option_flag                   VARCHAR2(1)
205 ,   option_number                 NUMBER
206 ,   ordered_quantity              NUMBER
207 ,   order_quantity_uom            VARCHAR2(3)
208 ,   org_id                        NUMBER
209 ,   orig_sys_document_ref         VARCHAR2(50)
210 ,   orig_sys_line_ref             VARCHAR2(50)
211 ,   over_ship_reason_code	  VARCHAR2(30)
212 ,   over_ship_resolved_flag	  VARCHAR2(1)
213 ,   payment_term_id               NUMBER
214 ,   price_list_id                 NUMBER
215 ,   pricing_attribute1            VARCHAR2(240)
216 ,   pricing_attribute10           VARCHAR2(240)
217 ,   pricing_attribute2            VARCHAR2(240)
218 ,   pricing_attribute3            VARCHAR2(240)
219 ,   pricing_attribute4            VARCHAR2(240)
220 ,   pricing_attribute5            VARCHAR2(240)
221 ,   pricing_attribute6            VARCHAR2(240)
222 ,   pricing_attribute7            VARCHAR2(240)
223 ,   pricing_attribute8            VARCHAR2(240)
224 ,   pricing_attribute9            VARCHAR2(240)
225 ,   pricing_context               VARCHAR2(240)
226 ,   pricing_date                  DATE
227 ,   pricing_quantity              NUMBER
228 ,   pricing_quantity_uom          VARCHAR2(3)
229 ,   program_application_id        NUMBER
230 ,   program_id                    NUMBER
231 ,   program_update_date           DATE
232 ,   project_id                    NUMBER
233 ,   promise_date                  DATE
234 ,   reference_header_id           NUMBER
235 ,   reference_line_id             NUMBER
236 ,   reference_type                VARCHAR2(30)
237 ,   request_date                  DATE
238 ,   request_id                    NUMBER
239 ,   reserved_quantity             NUMBER
240 ,   return_attribute1             VARCHAR2(240)
241 ,   return_attribute10            VARCHAR2(240)
242 ,   return_attribute11            VARCHAR2(240)
243 ,   return_attribute12            VARCHAR2(240)
244 ,   return_attribute13            VARCHAR2(240)
245 ,   return_attribute14            VARCHAR2(240)
246 ,   return_attribute15            VARCHAR2(240)
247 ,   return_attribute2             VARCHAR2(240)
248 ,   return_attribute3             VARCHAR2(240)
249 ,   return_attribute4             VARCHAR2(240)
250 ,   return_attribute5             VARCHAR2(240)
251 ,   return_attribute6             VARCHAR2(240)
252 ,   return_attribute7             VARCHAR2(240)
253 ,   return_attribute8             VARCHAR2(240)
254 ,   return_attribute9             VARCHAR2(240)
255 ,   return_context                VARCHAR2(30)
256 ,   return_reason_code		    VARCHAR2(30)
257 ,   rla_schedule_type_code        VARCHAR2(30)
258 ,   salesrep_id			    NUMBER
259 ,   schedule_arrival_date         DATE
260 ,   schedule_ship_date            DATE
261 ,   schedule_action_code          VARCHAR2(30)
262 ,   schedule_status_code          VARCHAR2(30)
263 ,   shipment_number               NUMBER
264 ,   shipment_priority_code        VARCHAR2(30)
265 ,   shipped_quantity              NUMBER
266 ,   shipping_method_code          VARCHAR2(30)
267 ,   shipping_quantity             NUMBER
268 ,   shipping_quantity_uom         VARCHAR2(3)
269 ,   ship_from_org_id              NUMBER
270 ,   ship_model_complete_flag      VARCHAR2(30)
271 ,   ship_set_id                   NUMBER
272 ,   ship_tolerance_above          NUMBER
273 ,   ship_tolerance_below          NUMBER
274 ,   ship_to_contact_id            NUMBER
275 ,   ship_to_org_id                NUMBER
276 ,   sold_to_org_id                NUMBER
277 ,   sort_order                    VARCHAR2(2000)  -- 4336446
278 ,   source_document_id            NUMBER
279 ,   source_document_line_id       NUMBER
280 ,   source_document_type_id       NUMBER
281 ,   source_type_code              VARCHAR2(30)
282 ,   split_from_line_id		  NUMBER
283 ,   task_id                       NUMBER
284 ,   tax_code                      VARCHAR2(50)
285 ,   tax_date                      DATE
286 ,   tax_exempt_flag               VARCHAR2(30)
287 ,   tax_exempt_number             VARCHAR2(80)
288 ,   tax_exempt_reason_code        VARCHAR2(30)
289 ,   tax_point_code                VARCHAR2(30)
290 ,   tax_rate                      NUMBER
291 ,   tax_value                     NUMBER
292 ,   unit_list_price               NUMBER
293 ,   unit_selling_price            NUMBER
294 ,   veh_cus_item_cum_key_id       NUMBER
295 ,   visible_demand_flag           VARCHAR2(1)
296 ,   return_status                 VARCHAR2(1)
297 ,   db_flag                       VARCHAR2(1)
298 ,   operation                     VARCHAR2(30)
299 ,   change_reason                 VARCHAR2(30)
300 ,   change_comments               VARCHAR2(32000)
301 ,   arrival_set	           	  VARCHAR2(30)
302 ,   ship_set			  VARCHAR2(30)
303 --added for bug 3431595 to indicate that OE_Atp.Atp_check procedure has been called from Pricing And Availability Section of Quick Sales Order form
304 , p_pa_call			  BOOLEAN :=FALSE
305 
306 );
307 
308 
309 Procedure ATP_Check(p_line_atp_rec      IN line_atp_rec_type
310                     ,p_old_line_atp_rec IN line_atp_rec_type
311 ,x_atp_rec OUT NOCOPY atp_rec_type
312 
313 ,x_return_status OUT NOCOPY VARCHAR2
314 
315                     );
316 
317 Procedure ATP_Inquiry(p_entity_type     IN  VARCHAR2,
318                       p_entity_id       IN  NUMBER,
319 x_return_status OUT NOCOPY VARCHAR2,
320 
321 x_atp_tbl OUT NOCOPY atp_tbl_type
322 
323                       );
324 
325 Procedure Assign_Atprec(p_line_atp_rec      IN Line_Atp_Rec_Type
326                         ,x_line_rec       IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
327                        );
328 END OE_ATP;