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