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_OE_FORM_HEADER

Source


1 PACKAGE Oe_Oe_Form_Header AUTHID CURRENT_USER AS
2 /* $Header: OEXFHDRS.pls 120.6.12010000.2 2010/01/29 12:37:27 vmachett ship $ */
3 
4 --  Procedure : Default_Attributes
5 --
6 
7 G_ENABLE_VISIBILITY_MSG   VARCHAR2(1)  := NVL(FND_PROFILE.Value('ONT_ENABLE_MSG'),'N');
8 
9 G_HZ_H_Installed Varchar2(1);
10 
11 TYPE Number_Tbl_Type IS TABLE OF NUMBER
12     INDEX BY BINARY_INTEGER;
13 
14 TYPE Varchar2_Tbl_Type IS TABLE OF Varchar2(2000)
15     INDEX BY BINARY_INTEGER;
16 
17 G_NULL_NUMBER_TBL        Number_Tbl_Type;
18 G_NULL_VARCHAR2_TBL      Varchar2_Tbl_Type;
19 
20 PROCEDURE Default_Attributes
21 ( x_return_status OUT NOCOPY VARCHAR2
22 , x_msg_count OUT NOCOPY NUMBER
23 , x_msg_data OUT NOCOPY VARCHAR2
24 ,   x_header_rec                    IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
25 ,   x_header_val_rec                IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
26 ,   x_old_header_rec                IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
27 ,   p_transaction_phase_code        IN VARCHAR2
28 );
29 
30 --  Procedure   :   Change_Attribute
31 --
32 
33 PROCEDURE Change_Attribute
34 ( x_return_status OUT NOCOPY VARCHAR2
35 , x_msg_count OUT NOCOPY NUMBER
36 , x_msg_data OUT NOCOPY VARCHAR2
37 ,   p_header_id                     IN  NUMBER
38 ,   p_attr_id                       IN  NUMBER
39 ,   p_attr_value                    IN  VARCHAR2
40 ,   p_attr_id_tbl                   IN  Number_Tbl_Type
41 ,   p_attr_value_tbl                IN  Varchar2_Tbl_Type
42 ,   p_header_dff_rec                IN  Oe_Oe_Form_Header.Header_Dff_Rec_Type
43 ,   p_date_format_mask            IN  VARCHAR2 DEFAULT 'DD-MON-RRRR HH24:MI:SS'
44 ,   x_header_rec                 IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
45 ,   x_header_val_rec             IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
46 ,   x_old_header_rec             IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
47 );
48 
49 --  Procedure       Validate_And_Write
50 --
51 
52 PROCEDURE Validate_And_Write
53 ( x_return_status OUT NOCOPY VARCHAR2
54 , x_msg_count OUT NOCOPY NUMBER
55 , x_msg_data OUT NOCOPY VARCHAR2
56 , x_cascade_flag OUT NOCOPY BOOLEAN
57 ,   p_header_id                     IN  NUMBER
58 ,   p_change_reason_code            IN  VARCHAR2
59 ,   p_change_comments               IN  VARCHAR2
60 , x_creation_date OUT NOCOPY DATE
61 , x_created_by OUT NOCOPY NUMBER
62 , x_last_update_date OUT NOCOPY DATE
63 , x_last_updated_by OUT NOCOPY NUMBER
64 , x_last_update_login OUT NOCOPY NUMBER
65 , x_order_number OUT NOCOPY NUMBER
66 , x_lock_control OUT NOCOPY NUMBER
67 , x_quote_number OUT NOCOPY NUMBER
68 , x_shipping_method_code OUT NOCOPY VARCHAR2 --4159701
69 , x_freight_carrier_code OUT NOCOPY VARCHAR2 --4159701
70 , x_shipping_method  OUT NOCOPY VARCHAR2--4159701
71 , x_freight_carrier OUT NOCOPY VARCHAR2 --4159701
72 , x_freight_terms_code OUT NOCOPY VARCHAR2 --4348011
73 , x_freight_terms OUT NOCOPY VARCHAR2
74 , x_payment_term_id OUT NOCOPY NUMBER
75 , x_payment_term OUT NOCOPY VARCHAR2
76 );
77 
78 --  Procedure       Delete_Row
79 --
80 
81 PROCEDURE Delete_Row
82 ( x_return_status OUT NOCOPY VARCHAR2
83 , x_msg_count OUT NOCOPY NUMBER
84 , x_msg_data OUT NOCOPY VARCHAR2
85 ,   p_header_id                     IN  NUMBER
86 );
87 
88 --  Procedure       Process_Entity
89 --
90 
91 PROCEDURE Process_Entity
92 ( x_return_status OUT NOCOPY VARCHAR2
93 , x_msg_count OUT NOCOPY NUMBER
94 , x_msg_data OUT NOCOPY VARCHAR2
95 );
96 
97 --  Procedure       Process_Object
98 --
99 
100 PROCEDURE Process_Object
101 ( x_return_status OUT NOCOPY VARCHAR2
102 , x_msg_count OUT NOCOPY NUMBER
103 , x_msg_data OUT NOCOPY VARCHAR2
104 , x_cascade_flag OUT NOCOPY BOOLEAN
105 );
106 
107 --  Procedure       lock_Row
108 --
109 
110 PROCEDURE Lock_Row
111 ( x_return_status OUT NOCOPY VARCHAR2
112 , x_msg_count OUT NOCOPY NUMBER
113 , x_msg_data OUT NOCOPY VARCHAR2
114 ,   p_header_id                     IN  NUMBER
115 ,   p_lock_control                  IN  NUMBER
116 );
117 
118 
119 
120 Procedure Clear_Record
121 ( x_return_status OUT NOCOPY VARCHAR2
122 , x_msg_count OUT NOCOPY NUMBER
123 , x_msg_data OUT NOCOPY VARCHAR2
124 ,   p_header_id                     IN  NUMBER
125 );
126 
127 
128 Procedure Delete_All_Requests
129 ( x_return_status OUT NOCOPY VARCHAR2
130 , x_msg_count OUT NOCOPY NUMBER
131 , x_msg_data OUT NOCOPY VARCHAR2
132 );
133 
134 
135 Procedure Sales_Person
136 ( x_return_status OUT NOCOPY VARCHAR2
137 , x_msg_count OUT NOCOPY NUMBER
138 , x_msg_data OUT NOCOPY VARCHAR2
139 , p_multiple_sales_credits OUT NOCOPY Varchar2
140 ,   p_header_id                     IN  NUMBER
141 ,   p_salesrep_id                   IN  NUMBER
142 );
143 
144 PROCEDURE Get_Form_Startup_Values
145 (   Item_Id_Flex_Code         IN VARCHAR2,
146 Item_Id_Flex_Num OUT NOCOPY NUMBER
147 );
148 
149 TYPE Header_Rec_Type IS RECORD
150 (
151 salesrep_id            NUMBER,
152 fob_point_code         VARCHAR2(30),
153 tax_exempt_flag        VARCHAR2(30),
154 tax_exempt_reason_code VARCHAR2(30),
155 return_reason_code     VARCHAR2(30),
156 tax_point_code         VARCHAR2(30),
157 freight_terms_code     VARCHAR2(30),
158 shipment_priority_code VARCHAR2(30),
159 payment_type_code      VARCHAR2(30),
160 credit_card_code       VARCHAR2(30),
161 flow_status_code	VARCHAR2(30),
162 freight_carrier_code	VARCHAR2(30),
163 shipping_method_code	VARCHAR2(30),
164 order_date_type_code	VARCHAR2(30),
165 ship_from_org_id        NUMBER,
166 demand_class_code       VARCHAR2(30),
167 sales_channel_code      VARCHAR2(30),
168 ship_to_org_id          NUMBER,
169 invoice_to_org_id       NUMBER,
170 deliver_to_org_id       NUMBER,
171 deliver_to_contact_id   NUMBER,
172 order_source_id         NUMBER,
173 source_document_type_id NUMBER,
174 agreement_id            NUMBER,
175 conversion_type_code    VARCHAR2(30),
176 header_id               NUMBER,
177 sold_to_org_id          NUMBER,
178 sold_to_phone_id          NUMBER,
179 --kmuruges
180 transaction_phase_code VARCHAR2(30),
181 user_status_code       VARCHAR2(30),
182 sold_to_site_use_id    NUMBER,
183 --kmuruges end
184 blanket_number         NUMBER,
185 contract_template_id   NUMBER,
186 contract_source_doc_type_code VARCHAR2(30),
187 contract_source_document_id NUMBER,
188 SUPPLIER_SIGNATURE           VARCHAR2(240),
189 SUPPLIER_SIGNATURE_DATE      DATE,
190 CUSTOMER_SIGNATURE           VARCHAR2(240),
191 CUSTOMER_SIGNATURE_DATE      DATE,
192  end_customer_site_use_id  NUMBER,
193  end_customer_contact_id  NUMBER,
194  end_customer_id  NUMBER,
195 ib_owner                      VARCHAR2(60),
196 ib_installed_at_location      VARCHAR2(60),
197 ib_current_location           VARCHAR2(60),
198 contract_template                 VARCHAR2(60),
199 contract_source                 VARCHAR2(60),
200 authoring_party                 VARCHAR2(60),
201 org_id                    NUMBER
202 );
203 
204 TYPE Header_Val_Rec_Type IS RECORD
205 (
206 salesrep              VARCHAR2(240),
207 fob             VARCHAR2(240),
208 tax_exempt            VARCHAR2(240),
209 tax_exempt_reason     VARCHAR2(240),
210 return_reason         VARCHAR2(240),
211 tax_point             VARCHAR2(240),
212 freight_terms    VARCHAR2(240),
213 shipment_priority  VARCHAR2(240),
214 payment_type         VARCHAR2(240),
215 credit_card         VARCHAR2(240),
216 status		VARCHAR2(240),
217 freight_carrier     VARCHAR2(80),
218 shipping_method     VARCHAR2(80),
219 order_date_type     VARCHAR2(80),
220 demand_class        VARCHAR2(80),
221 sales_channel       VARCHAR2(80),
222 ship_to_customer_name  VARCHAR2(360),
223 ship_to_customer_number  VARCHAR2(50),
224 invoice_to_customer_name  VARCHAR2(360),
225 invoice_to_customer_number  VARCHAR2(50),
226 deliver_to                      VARCHAR2(40),
227 deliver_to_location             VARCHAR2(40),
228 deliver_to_address1             VARCHAR2(240),
229 deliver_to_address2             VARCHAR2(240),
230 deliver_to_address3             VARCHAR2(240),
231 deliver_to_address4             VARCHAR2(246),
232 /*1621182*/
233 deliver_to_address5             VARCHAR2(246),
234 /*1621182*/
235 deliver_to_contact              oe_contacts_v.name%type,   --Bug#9241636
236 agreement                       VARCHAR2(240),
237 order_source                    VARCHAR2(240),
238 source_document_type            VARCHAR2(240),
239 conversion_type                 VARCHAR2(30),
240 ship_to_customer_id     NUMBER,
241 hold_exists_flag                VARCHAR2(1),
242 Messages_exists_Flag            VARCHAR2(1),
243 invoice_to_customer_id  NUMBER,
244 subtotal                      NUMBER,
245 charges                       NUMBER,
246 header_charges                NUMBER,
247 discount                      NUMBER,
248 tax                           NUMBER,
249 gsa_indicator                 VARCHAR2(2),
250 deliver_to_customer_id  NUMBER,
251 deliver_to_customer_name  VARCHAR2(360),
252 deliver_to_customer_number  VARCHAR2(50),
253 /* START PREPAYMENT */
254 payment_set_id NUMBER,
255 prepaid_amount NUMBER,
256 pending_amount NUMBER,
257  --pnpl
258 pay_now_total NUMBER,
259 /* END PREPAYMENT */
260 PHONE_NUMBER VARCHAR2(40),
261 PHONE_AREA_CODE VARCHAR2(10),
262 PHONE_COUNTRY_CODE VARCHAR2(10),
263 PHONE_EXTENSION VARCHAR2(20),
264 --kmuruges
265 user_status  VARCHAR2(240),
266 transaction_phase VARCHAR2(240),
267 sold_to_location             VARCHAR2(240),
268 sold_to_location_address1    VARCHAR2(240),
269 sold_to_location_address2          VARCHAR2(240),
270 sold_to_location_address3             VARCHAR2(240),
271 sold_to_location_address4             VARCHAR2(240),
272 sold_to_location_name             VARCHAR2(240),
273 sold_to_location_city               varchar2(240),
274 sold_to_location_state               varchar2(240),
275 sold_to_location_postal               varchar2(240),
276 sold_to_location_country               varchar2(240),
277 end_customer_contact VARCHAR(240),
278 end_customer_name         VARCHAR(240),
279 end_customer_number VARCHAR(240),
280 end_customer_site_location             VARCHAR2(240),
281 end_customer_site_address1    VARCHAR2(240),
282 end_customer_site_address2          VARCHAR2(240),
283 end_customer_site_address3             VARCHAR2(240),
284 end_customer_site_address4             VARCHAR2(240),
285 end_customer_site_city               varchar2(240),
286 end_customer_site_state               varchar2(240),
287 end_customer_site_postal_code               varchar2(240),
288 end_customer_site_country               varchar2(240),
289 --kmuruges end
290 blanket_agreement_name              varchar2(240),
291 ib_owner_dsp                        VARCHAR2(60),
292 ib_installed_at_location_dsp        VARCHAR2(60),
293 ib_current_location_dsp             VARCHAR2(60),
294 -- fp word integration
295 contract_template                 VARCHAR2(60),
296 contract_source                 VARCHAR2(60),
297 authoring_party                 VARCHAR2(60),
298 --R12 CC Encryption
299 credit_card_code              	VARCHAR2(80),
300 credit_card_holder_name       	VARCHAR2(80),
301 credit_card_number            	VARCHAR2(80),
302 credit_card_expiration_date   	DATE,
303 credit_card_approval_code     	VARCHAR2(80),
304 credit_card_approval_date     	DATE,
305 instrument_security_code	VARCHAR2(20),
306 cc_instrument_id		NUMBER,
307 cc_instrument_assignment_id	NUMBER
308 --R12 CC Encryption
309 );
310 
311 
312 PROCEDURE POPULATE_CONTROL_FIELDS
313 (
314 p_header_rec_type             IN  Header_Rec_Type,
315 x_header_val_rec OUT NOCOPY Header_Val_Rec_Type
316 );
317 
318 FUNCTION Get_Cascade_Flag return Boolean;
319 
320 PROCEDURE Set_Cascade_Flag_False;
321 
322 TYPE Set_Of_Books_Rec_Type IS RECORD
323 (   set_of_books_id     NUMBER
324 ,   currency_code       VARCHAR2(15)
325 );
326 
327 FUNCTION Load_Set_Of_Books
328 RETURN Set_Of_Books_Rec_Type;
329 
330 
331 PROCEDURE get_invoice_to_customer_id ( p_site_use_id IN NUMBER,
332 x_invoice_to_customer_id OUT NOCOPY NUMBER
333                                       );
334 
335 PROCEDURE get_ship_to_customer_id ( p_site_use_id IN NUMBER,
336 x_ship_to_customer_id OUT NOCOPY NUMBER
337                                    );
338 
339 
340 PROCEDURE Reset_Debug_Level;
341 
342 PROCEDURE Set_Debug_Level
343                       (
344                        p_debug_level IN NUMBER
345                        );
346 
347 PROCEDURE Get_GSA_Indicator( p_sold_to_org_id IN NUMBER,
348 x_gsa_indicator OUT NOCOPY VARCHAR2
349                             );
350 
351 PROCEDURE CASCADE_HEADER_ATTRIBUTES
352                             (
353                               p_old_db_header_rec  IN OE_ORDER_PUB.Header_Rec_Type
354                          ,    p_header_rec         IN OE_ORDER_PUB.Header_Rec_Type
355 , x_return_status OUT NOCOPY VARCHAR2
356 , x_msg_count OUT NOCOPY NUMBER
357 , x_msg_data OUT NOCOPY VARCHAR2
358                               );
359 
360 TYPE Header_Dff_Rec_Type IS RECORD
361 (
362    attribute1                    VARCHAR2(240)
363 ,   attribute10                   VARCHAR2(240)
364 ,   attribute11                   VARCHAR2(240)
365 ,   attribute12                   VARCHAR2(240)
366 ,   attribute13                   VARCHAR2(240)
367 ,   attribute14                   VARCHAR2(240)
368 ,   attribute15                   VARCHAR2(240)
369 ,   attribute16                   VARCHAR2(240)     --For bug 2184255
370 ,   attribute17                   VARCHAR2(240)
371 ,   attribute18                   VARCHAR2(240)
372 ,   attribute19                   VARCHAR2(240)
373 ,   attribute2                    VARCHAR2(240)
374 ,   attribute20                   VARCHAR2(240)
375 ,   attribute3                    VARCHAR2(240)
376 ,   attribute4                    VARCHAR2(240)
377 ,   attribute5                    VARCHAR2(240)
381 ,   attribute9                    VARCHAR2(240)
378 ,   attribute6                    VARCHAR2(240)
379 ,   attribute7                    VARCHAR2(240)
380 ,   attribute8                    VARCHAR2(240)
382 ,   Context                       VARCHAR2(30)
383 ,   global_attribute1             VARCHAR2(240)
384 ,   global_attribute10            VARCHAR2(240)
385 ,   global_attribute11            VARCHAR2(240)
386 ,   global_attribute12            VARCHAR2(240)
387 ,   global_attribute13            VARCHAR2(240)
388 ,   global_attribute14            VARCHAR2(240)
389 ,   global_attribute15            VARCHAR2(240)
390 ,   global_attribute16            VARCHAR2(240)
391 ,   global_attribute17            VARCHAR2(240)
392 ,   global_attribute18            VARCHAR2(240)
393 ,   global_attribute19            VARCHAR2(240)
394 ,   global_attribute2             VARCHAR2(240)
395 ,   global_attribute20            VARCHAR2(240)
396 ,   global_attribute3             VARCHAR2(240)
397 ,   global_attribute4             VARCHAR2(240)
398 ,   global_attribute5             VARCHAR2(240)
399 ,   global_attribute6             VARCHAR2(240)
400 ,   global_attribute7             VARCHAR2(240)
401 ,   global_attribute8             VARCHAR2(240)
402 ,   global_attribute9             VARCHAR2(240)
403 ,   global_attribute_category     VARCHAR2(30)
404 ,   TP_CONTEXT                    VARCHAR2(30)
405 ,   TP_ATTRIBUTE1                 VARCHAR2(240)
406 ,   TP_ATTRIBUTE2                 VARCHAR2(240)
407 ,   TP_ATTRIBUTE3                 VARCHAR2(240)
408 ,   TP_ATTRIBUTE4                 VARCHAR2(240)
409 ,   TP_ATTRIBUTE5                 VARCHAR2(240)
410 ,   TP_ATTRIBUTE6                 VARCHAR2(240)
411 ,   TP_ATTRIBUTE7                 VARCHAR2(240)
412 ,   TP_ATTRIBUTE8                 VARCHAR2(240)
413 ,   TP_ATTRIBUTE9                 VARCHAR2(240)
414 ,   TP_ATTRIBUTE10                VARCHAR2(240)
415 ,   TP_ATTRIBUTE11                VARCHAR2(240)
416 ,   TP_ATTRIBUTE12                VARCHAR2(240)
417 ,   TP_ATTRIBUTE13                VARCHAR2(240)
418 ,   TP_ATTRIBUTE14                VARCHAR2(240)
419 ,   TP_ATTRIBUTE15                VARCHAR2(240)
420 );
421 
422 PROCEDURE CREATE_AGREEMENT(
423 x_return_status OUT NOCOPY VARCHAR2
424 , x_msg_count OUT NOCOPY NUMBER
425 , x_msg_data OUT NOCOPY VARCHAR2
426 ,   p_price_list_id                 IN  NUMBER
427 ,   p_agreement_name                IN  VARCHAR2
428 ,   p_term_id                       IN  NUMBER
429 ,   p_sold_to_org_id                IN  NUMBER
430 
431 );
432 
433 PROCEDURE Clear_Global_PO_Cache;
434 
435 PROCEDURE Copy_Attribute_To_Rec
436 (   p_attr_id                       IN  NUMBER
437 ,   p_attr_value                    IN  VARCHAR2
438 ,   p_header_dff_rec                IN  OE_OE_FORM_HEADER.header_dff_rec_type
439 ,   p_date_format_mask              IN  VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
440 ,   x_header_rec                    IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
441 ,   x_old_header_rec                IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
442 );
443 
444 PROCEDURE Validate_Phone_Number(
445                              p_area_code IN VARCHAR2 default null,
446                              p_phone_number     IN VARCHAR2 default null,
447                              p_country_code     IN VARCHAR2 default null,
448                              x_valid OUT NOCOPY /* file.sql.39 change */ BOOLEAN,
449                              x_area_codes OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
450                              x_phone_number_format OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
451                              x_phone_number_length OUT NOCOPY /* file.sql.39 change */ VARCHAR2
452                              );
453 
454 PROCEDURE Check_Sec_Header_Attr
455      (x_return_status         IN OUT NOCOPY varchar2,
456       p_header_id              IN OUT NOCOPY NUMBER,
457       p_operation               IN OUT NOCOPY VARCHAR2,
458       p_column_name           IN VARCHAR2 DEFAULT NULL,
459       x_msg_count             IN OUT NOCOPY NUMBER,
460       x_msg_data              IN OUT NOCOPY VARCHAR2,
461       x_constrained           IN OUT NOCOPY BOOLEAN
462 );
463 
464 
465 --ABH
466 FUNCTION Get_Opr_Update
467 RETURN varchar2;
468 
469 -- Start Of Enhanced Cascading
470 
471   TYPE Cascade_record IS RECORD
472    (
473       p_cached                           Varchar2(1) :='N'
474      ,p_accounting_rule                  Varchar2(1) :='N'
475      ,p_agreement                        Varchar2(1) :='N'
476      ,p_customer_po                      Varchar2(1) :='N'
477      ,p_blanket_number                   Varchar2(1) :='N'
478      ,p_deliver_to_contact               Varchar2(1) :='N'
479      ,p_deliver_to                       Varchar2(1) :='N'
480      ,p_demand_class                     Varchar2(1) :='N'
481      ,p_fob_point                        Varchar2(1) :='N'
482      ,p_freight_terms                    Varchar2(1) :='N'
483      ,p_bill_to_contact                  Varchar2(1) :='N'
484      ,p_bill_to                          Varchar2(1) :='N'
485      ,p_invoicing_rule                   Varchar2(1) :='N'
486      ,p_order_firmed_date                Varchar2(1) :='N'
487      ,p_payment_term                     Varchar2(1) :='N'
488      ,p_price_list                       Varchar2(1) :='N'
489      ,p_request_date                     Varchar2(1) :='N'
490      ,p_return_reason                    Varchar2(1) :='N'
491      ,p_salesperson                      Varchar2(1) :='N'
492      ,p_shipment_priority                Varchar2(1) :='N'
493      ,p_shipping_method                  Varchar2(1) :='N'
494      ,p_warehouse                        Varchar2(1) :='N'
495      ,p_ship_to_contact                  Varchar2(1) :='N'
496      ,p_ship_to                          Varchar2(1) :='N'
497      ,p_customer                         Varchar2(1) :='N'
498      ,p_tax_exempt                       Varchar2(1) :='N'
499 
500   );
501 
502 
503 
504 
505   PROCEDURE Read_Cascadable_Fields
506    (
507       x_cascade_record  OUT NOCOPY OE_OE_FORM_HEADER.cascade_record
508    );
509 
510 -- End Of Enhanced Cascading
511 
512 END Oe_Oe_Form_Header;