[Home] [Help]
PACKAGE: APPS.OE_HEADER_UTIL
Source
1 PACKAGE OE_Header_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXUHDRS.pls 120.7 2011/08/05 07:04:41 jrparuch ship $ */
3
4 -- Attributes global constants
5 G_ACCOUNTING_RULE CONSTANT NUMBER := 1;
6 G_AGREEMENT CONSTANT NUMBER := 2;
7 G_ATTRIBUTE1 CONSTANT NUMBER := 3;
8 G_ATTRIBUTE10 CONSTANT NUMBER := 4;
9 G_ATTRIBUTE11 CONSTANT NUMBER := 5;
10 G_ATTRIBUTE12 CONSTANT NUMBER := 6;
11 G_ATTRIBUTE13 CONSTANT NUMBER := 7;
12 G_ATTRIBUTE14 CONSTANT NUMBER := 8;
13 G_ATTRIBUTE15 CONSTANT NUMBER := 9;
14 G_ATTRIBUTE2 CONSTANT NUMBER := 10;
15 G_ATTRIBUTE3 CONSTANT NUMBER := 11;
16 G_ATTRIBUTE4 CONSTANT NUMBER := 12;
17 G_ATTRIBUTE5 CONSTANT NUMBER := 13;
18 G_ATTRIBUTE6 CONSTANT NUMBER := 14;
19 G_ATTRIBUTE7 CONSTANT NUMBER := 15;
20 G_ATTRIBUTE8 CONSTANT NUMBER := 16;
21 G_ATTRIBUTE9 CONSTANT NUMBER := 17;
22 G_BOOKED CONSTANT NUMBER := 18;
23 G_CANCELLED CONSTANT NUMBER := 19;
24 G_CHANGE_SEQUENCE_ID CONSTANT NUMBER := 20;
25 G_CONTEXT CONSTANT NUMBER := 21;
26 G_CONVERSION_RATE CONSTANT NUMBER := 22;
27 G_CONVERSION_RATE_DATE CONSTANT NUMBER := 23;
28 G_CONVERSION_TYPE CONSTANT NUMBER := 24;
29 G_CREATED_BY CONSTANT NUMBER := 25;
30 G_CREATION_DATE CONSTANT NUMBER := 26;
31 G_CUSTOMER_PAYMENT_TERM_ID CONSTANT NUMBER := 27;
32 G_CUST_PO_NUMBER CONSTANT NUMBER := 28;
33 G_DELIVER_TO_CONTACT CONSTANT NUMBER := 29;
34 G_DELIVER_TO_ORG CONSTANT NUMBER := 30;
38 G_EXPIRATION_DATE CONSTANT NUMBER := 34;
35 G_DEMAND_CLASS CONSTANT NUMBER := 31;
36 G_DROP_SHIP_FLAG CONSTANT NUMBER := 32;
37 G_EARLIEST_SCHEDULE_LIMIT CONSTANT NUMBER := 33;
39 G_FOB_POINT CONSTANT NUMBER := 35;
40 G_FREIGHT_CARRIER CONSTANT NUMBER := 36;
41 G_FREIGHT_TERMS CONSTANT NUMBER := 37;
42 G_GLOBAL_ATTRIBUTE1 CONSTANT NUMBER := 38;
43 G_GLOBAL_ATTRIBUTE10 CONSTANT NUMBER := 39;
44 G_GLOBAL_ATTRIBUTE11 CONSTANT NUMBER := 40;
45 G_GLOBAL_ATTRIBUTE12 CONSTANT NUMBER := 41;
46 G_GLOBAL_ATTRIBUTE13 CONSTANT NUMBER := 42;
47 G_GLOBAL_ATTRIBUTE14 CONSTANT NUMBER := 43;
48 G_GLOBAL_ATTRIBUTE15 CONSTANT NUMBER := 44;
49 G_GLOBAL_ATTRIBUTE16 CONSTANT NUMBER := 45;
50 G_GLOBAL_ATTRIBUTE17 CONSTANT NUMBER := 46;
51 G_GLOBAL_ATTRIBUTE18 CONSTANT NUMBER := 47;
52 G_GLOBAL_ATTRIBUTE19 CONSTANT NUMBER := 48;
53 G_GLOBAL_ATTRIBUTE2 CONSTANT NUMBER := 49;
54 G_GLOBAL_ATTRIBUTE20 CONSTANT NUMBER := 50;
55 G_GLOBAL_ATTRIBUTE3 CONSTANT NUMBER := 51;
56 G_GLOBAL_ATTRIBUTE4 CONSTANT NUMBER := 52;
57 G_GLOBAL_ATTRIBUTE5 CONSTANT NUMBER := 53;
58 G_GLOBAL_ATTRIBUTE6 CONSTANT NUMBER := 54;
59 G_GLOBAL_ATTRIBUTE7 CONSTANT NUMBER := 55;
60 G_GLOBAL_ATTRIBUTE8 CONSTANT NUMBER := 56;
61 G_GLOBAL_ATTRIBUTE9 CONSTANT NUMBER := 57;
62 G_GLOBAL_ATTRIBUTE_CATEGORY CONSTANT NUMBER := 58;
63 G_HEADER CONSTANT NUMBER := 59;
64 G_INVOICE_TO_CONTACT CONSTANT NUMBER := 60;
65 G_INVOICE_TO_ORG CONSTANT NUMBER := 61;
66 G_INVOICING_RULE CONSTANT NUMBER := 62;
67 G_LAST_UPDATED_BY CONSTANT NUMBER := 63;
68 G_LAST_UPDATE_DATE CONSTANT NUMBER := 64;
69 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 65;
70 G_LATEST_SCHEDULE_LIMIT CONSTANT NUMBER := 66;
71 G_OPEN CONSTANT NUMBER := 67;
72 G_ORDERED_DATE CONSTANT NUMBER := 68;
73 G_ORDER_DATE_TYPE_CODE CONSTANT NUMBER := 69;
74 G_ORDER_NUMBER CONSTANT NUMBER := 70;
75 G_ORDER_SOURCE CONSTANT NUMBER := 71;
76 G_ORDER_TYPE CONSTANT NUMBER := 72;
77 G_ORG CONSTANT NUMBER := 73;
78 G_ORIG_SYS_DOCUMENT_REF CONSTANT NUMBER := 74;
79 G_PARTIAL_SHIPMENTS_ALLOWED CONSTANT NUMBER := 75;
80 G_PAYMENT_TERM CONSTANT NUMBER := 76;
81 G_PRICE_LIST CONSTANT NUMBER := 77;
82 G_PRICING_DATE CONSTANT NUMBER := 78;
83 G_PROGRAM CONSTANT NUMBER := 79;
84 G_PROGRAM_APPLICATION CONSTANT NUMBER := 80;
85 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 81;
86 G_REQUEST CONSTANT NUMBER := 82;
87 G_REQUEST_DATE CONSTANT NUMBER := 83;
88 G_RETURN_REASON CONSTANT NUMBER := 84;
89 G_SALESREP CONSTANT NUMBER := 85;
90 G_SHIPMENT_PRIORITY CONSTANT NUMBER := 86;
91 G_SHIPPING_METHOD CONSTANT NUMBER := 87;
92 G_SHIP_FROM_ORG CONSTANT NUMBER := 88;
93 G_SHIP_TOLERANCE_ABOVE CONSTANT NUMBER := 89;
94 G_SHIP_TOLERANCE_BELOW CONSTANT NUMBER := 90;
95 G_SHIP_TO_CONTACT CONSTANT NUMBER := 91;
96 G_SHIP_TO_ORG CONSTANT NUMBER := 92;
97 G_SOLD_TO_CONTACT CONSTANT NUMBER := 93;
98 G_SOLD_TO_ORG CONSTANT NUMBER := 94;
99 G_SOURCE_DOCUMENT CONSTANT NUMBER := 95;
100 G_SOURCE_DOCUMENT_TYPE CONSTANT NUMBER := 96;
101 G_TAX_EXEMPT CONSTANT NUMBER := 97;
102 G_TAX_EXEMPT_NUMBER CONSTANT NUMBER := 98;
103 G_TAX_EXEMPT_REASON CONSTANT NUMBER := 99;
104 G_TAX_POINT CONSTANT NUMBER := 100;
105 G_TRANSACTIONAL_CURR CONSTANT NUMBER := 101;
106 G_VERSION_NUMBER CONSTANT NUMBER := 102;
107 G_PAYMENT_TYPE CONSTANT NUMBER := 103;
108 G_PAYMENT_AMOUNT CONSTANT NUMBER := 104;
109 G_CHECK_NUMBER CONSTANT NUMBER := 105;
110 G_CREDIT_CARD CONSTANT NUMBER := 106;
111 G_CREDIT_CARD_HOLDER_NAME CONSTANT NUMBER := 107;
112 G_CREDIT_CARD_NUMBER CONSTANT NUMBER := 108;
113 G_CREDIT_CARD_EXPIRATION_DATE CONSTANT NUMBER := 109;
114 G_CREDIT_CARD_APPROVAL CONSTANT NUMBER := 110;
115 G_FIRST_ACK CONSTANT NUMBER := 111;
116 G_FIRST_ACK_DATE CONSTANT NUMBER := 112;
117 G_LAST_ACK CONSTANT NUMBER := 113;
118 G_LAST_ACK_DATE CONSTANT NUMBER := 115;
119 G_SHIPPING_INSTRUCTIONS CONSTANT NUMBER := 116;
120 G_PACKING_INSTRUCTIONS CONSTANT NUMBER := 117;
121 G_ORDER_CATEGORY CONSTANT NUMBER := 118;
122 G_FLOW_STATUS CONSTANT NUMBER := 119;
123 G_CREDIT_CARD_APPROVAL_DATE CONSTANT NUMBER := 120;
124 G_CUSTOMER_PREFERENCE_SET CONSTANT NUMBER := 121;
125 G_BOOKED_DATE CONSTANT NUMBER := 122;
126 /*Synched up the TP constants with the client constant */
127
128 G_TP_CONTEXT CONSTANT NUMBER := 124;
129 G_TP_ATTRIBUTE1 CONSTANT NUMBER := 125;
130 G_TP_ATTRIBUTE2 CONSTANT NUMBER := 126;
131 G_TP_ATTRIBUTE3 CONSTANT NUMBER := 127;
132 G_TP_ATTRIBUTE4 CONSTANT NUMBER := 128;
133 G_TP_ATTRIBUTE5 CONSTANT NUMBER := 129;
134 G_TP_ATTRIBUTE6 CONSTANT NUMBER := 130;
135 G_TP_ATTRIBUTE7 CONSTANT NUMBER := 131;
136 G_TP_ATTRIBUTE8 CONSTANT NUMBER := 132;
137 G_TP_ATTRIBUTE9 CONSTANT NUMBER := 133;
138 G_TP_ATTRIBUTE10 CONSTANT NUMBER := 134;
139 G_TP_ATTRIBUTE11 CONSTANT NUMBER := 135;
140 G_TP_ATTRIBUTE12 CONSTANT NUMBER := 136;
141 G_TP_ATTRIBUTE13 CONSTANT NUMBER := 137;
142 G_TP_ATTRIBUTE14 CONSTANT NUMBER := 138;
143 G_TP_ATTRIBUTE15 CONSTANT NUMBER := 139;
144 G_MARKETING_SOURCE_CODE_ID CONSTANT NUMBER := 140;
148 G_PRICE_REQUEST_CODE CONSTANT NUMBER := 144; -- PROMOTIONS SEP/01
145 G_SALES_CHANNEL CONSTANT NUMBER := 141;
146 G_UPGRADED CONSTANT NUMBER := 142;
147 G_LOCK_CONTROL CONSTANT NUMBER := 143;
149 G_ACCOUNTING_RULE_DURATION CONSTANT NUMBER := 145;
150 -- ER 2184255 additional DFF segments
151 G_ATTRIBUTE16 CONSTANT NUMBER := 146;
152 G_ATTRIBUTE17 CONSTANT NUMBER := 147;
153 G_ATTRIBUTE18 CONSTANT NUMBER := 148;
154 G_ATTRIBUTE19 CONSTANT NUMBER := 149;
155 G_ATTRIBUTE20 CONSTANT NUMBER := 150;
156
157 G_BLANKET_NUMBER CONSTANT NUMBER := 151;
158 G_SOLD_TO_PHONE CONSTANT NUMBER := 152;
159 G_DEFAULT_FULFILLMENT_SET CONSTANT NUMBER := 153;
160 G_LINE_SET_NAME CONSTANT NUMBER := 154;
161 G_FULFILLMENT_SET_NAME CONSTANT NUMBER := 155;
162 -- QUOTING changes
163 g_quote_date CONSTANT NUMBER := 156;
164 g_quote_number CONSTANT NUMBER := 157;
165 g_sales_document_name CONSTANT NUMBER := 158;
166 g_transaction_phase CONSTANT NUMBER := 159;
167 g_user_status CONSTANT NUMBER := 160;
168 g_draft_submitted CONSTANT NUMBER := 161;
169 g_source_document_version CONSTANT NUMBER := 162;
170 g_sold_to_site_use CONSTANT NUMBER := 163;
171 -- QUOTING changes END
172 G_MINISITE_ID CONSTANT NUMBER := 164;
173 G_IB_OWNER CONSTANT NUMBER := 165;
174 G_IB_INSTALLED_AT_LOCATION CONSTANT NUMBER := 166;
175 G_IB_CURRENT_LOCATION CONSTANT NUMBER := 167;
176 G_END_CUSTOMER CONSTANT NUMBER := 168;
177 G_END_CUSTOMER_CONTACT CONSTANT NUMBER := 169;
178 G_END_CUSTOMER_SITE_USE CONSTANT NUMBER := 170;
179 G_SUPPLIER_SIGNATURE CONSTANT NUMBER := 171;
180 G_SUPPLIER_SIGNATURE_DATE CONSTANT NUMBER := 172;
181 G_CUSTOMER_SIGNATURE CONSTANT NUMBER := 173;
182 G_CUSTOMER_SIGNATURE_DATE CONSTANT NUMBER := 174;
183 G_CONTRACT_TEMPLATE CONSTANT NUMBER := 175;
184 g_contract_source_doc_type CONSTANT NUMBER := 176;
185 g_contract_source_document CONSTANT NUMBER := 177;
186 --key Transaction Dates
187 G_ORDER_FIRMED_DATE CONSTANT NUMBER := 178;
188 --R12 CC Encryption
189 G_INSTRUMENT_SECURITY CONSTANT NUMBER := 178;
190 G_CC_INSTRUMENT CONSTANT NUMBER := 179;
191 G_CC_INSTRUMENT_ASSIGNMENT CONSTANT NUMBER := 180;
192 --R12 CC Encryption
193 G_MAX_ATTR_ID CONSTANT NUMBER := 181;
194
195 g_rollback_done VARCHAR2(1); -- bug 12759791
196 -- Function to initialize view%rowtype record
197
198 FUNCTION G_MISS_OE_AK_HEADER_REC
199 RETURN OE_AK_ORDER_HEADERS_V%ROWTYPE;
200
201 -- Procedure API_Rec_To_Rowtype_Rec
202
203 PROCEDURE API_Rec_To_Rowtype_Rec
204 ( p_HEADER_rec IN OE_Order_PUB.HEADER_Rec_Type
205 , x_rowtype_rec IN OUT NOCOPY OE_AK_ORDER_HEADERS_V%ROWTYPE
206 );
207
208 -- Procedure Rowtype_Rec_To_API_Rec
209
210 PROCEDURE Rowtype_Rec_To_API_Rec
211 ( p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
212 , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_Rec_Type
213 );
214
215 -- Procedure Clear_Dependent_Attr: Overloaded for view%rowtype PARAMETERS
216
217 PROCEDURE Clear_Dependent_Attr
218 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
219 , p_initial_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
220 , p_old_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
221 , p_x_header_rec IN OUT NOCOPY OE_AK_ORDER_HEADERS_V%ROWTYPE
222 , p_x_instrument_id IN NUMBER DEFAULT NULL -- R12 CC Encryption
223 , p_old_instrument_id IN NUMBER DEFAULT NULL
224 );
225
226 -- Procedure Clear_Dependent_Attr
227
228 PROCEDURE Clear_Dependent_Attr
229 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
230 , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
231 , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
232 OE_Order_PUB.G_MISS_HEADER_REC
233 );
234
235 -- Procedure Apply_Attribute_Changes
236
237 PROCEDURE Apply_Attribute_Changes
238 ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
239 , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
240 OE_Order_PUB.G_MISS_HEADER_REC
241 );
242
243 -- Function Complete_Record
244
245 PROCEDURE Complete_Record
246 ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
247 , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
248 ) ;
249
250 -- Function Convert_Miss_To_Null
251
252 PROCEDURE Convert_Miss_To_Null
253 ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
254 ) ;
255
256 -- Procedure Update_Row
257
258 PROCEDURE Update_Row
259 ( p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
260 );
261
262 -- Procedure Insert_Row
263
264 PROCEDURE Insert_Row
265 ( p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
266 );
267
268 -- Procedure Delete_Row
269
270 PROCEDURE Delete_Row
271 ( p_header_id IN NUMBER
272 );
273
274 -- FUNCTION Query_Row
275 -- IMPORTANT: DO NOT CHANGE THE SPEC OF THIS FUNCTION
276 -- IT IS PUBLIC AND BEING CALLED BY OTHER PRODUCTS
277 -- Private OM callers should call the procedure query_row instead
278 -- as it has the nocopy option which would improve the performance
279
280 FUNCTION Query_Row
281 ( p_header_id IN NUMBER
285
282 ) RETURN OE_Order_PUB.Header_Rec_Type;
283
284 -- Function Query_Row
286 PROCEDURE Query_Row
287 ( p_header_id IN NUMBER,
288 x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
289 ) ;
290 --R12 CC Encryption
291 PROCEDURE Query_card_Details
292 ( p_header_id IN NUMBER,
293 p_credit_card_code OUT NOCOPY VARCHAR2,
294 p_credit_card_holder_name OUT NOCOPY VARCHAR2,
295 p_credit_card_number OUT NOCOPY VARCHAR2,
296 p_credit_Card_expiration_date OUT NOCOPY VARCHAR2,
297 p_credit_card_approval_code OUT NOCOPY VARCHAR2,
298 p_credit_card_approval_Date OUT NOCOPY VARCHAR2,
299 p_instrument_security_code OUT NOCOPY VARCHAR2,
300 p_instrument_id OUT NOCOPY NUMBER,
301 p_instrument_assignment_id OUT NOCOPY NUMBER
302 );
303 --R12 CC Encryption
304
305 -- Procedure lock_Row
306 --
307
308 PROCEDURE Lock_Row
309 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
310 , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
311 , p_header_id IN NUMBER
312 := FND_API.G_MISS_NUM
313 );
314
315
316 PROCEDURE cancel_header_charges
317 ( p_header_id IN number ,
318 x_return_status OUT NOCOPY varchar2
319 );
320
321 -- Function Get_Values
322
323 FUNCTION Get_Values
324 ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
325 , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
326 OE_Order_PUB.G_MISS_HEADER_REC
327 ) RETURN OE_Order_PUB.Header_Val_Rec_Type;
328
329 -- Function Get_Ids
330
331 PROCEDURE Get_Ids
332 ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
333 , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type
334 ) ;
335
336 FUNCTION Get_ord_seq_type
337 ( p_order_type_id IN NUMBER
338 , p_transaction_phase_code IN VARCHAR2 DEFAULT 'F'
339 ) RETURN VARCHAR2;
340
341
342 FUNCTION Get_Mtl_Sales_Order_Id
343 (p_header_id IN NUMBER,
344 p_order_number IN NUMBER := FND_API.G_MISS_NUM)
345 RETURN NUMBER;
346
347 PROCEDURE Get_Order_Info(p_header_id IN NUMBER,
348 x_order_number OUT NOCOPY /* file.sql.39 change */ NUMBER,
349 x_order_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
350 x_order_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
351
352 FUNCTION Get_Header_Id(p_order_number IN NUMBER,
353 p_order_type IN VARCHAR2,
354 p_order_source IN VARCHAR2)
355 RETURN NUMBER;
356
357 FUNCTION Get_Order_Type
358 ( p_order_type_id IN NUMBER)
359 RETURN VARCHAR2 ;
360
361 PROCEDURE Get_Order_Number
362 ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
363 p_old_header_rec IN oe_order_pub.header_rec_type );
364
365 PROCEDURE Pre_Write_Process(
366 p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
367 p_old_header_rec IN oe_order_pub.header_rec_type );
368
369 PROCEDURE Post_Write_Process(
370 p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
371 p_old_header_rec IN oe_order_pub.header_rec_type );
372
373 Procedure Validate_Gapless_Seq( p_application_id IN NUMBER,
374 p_entity_short_name in VARCHAR2,
375 p_validation_entity_short_name in VARCHAR2,
376 p_validation_tmplt_short_name in VARCHAR2,
377 p_record_set_tmplt_short_name in VARCHAR2,
378 p_scope in VARCHAR2,
379 p_result OUT NOCOPY /* file.sql.39 change */ NUMBER );
380
381
382 --bug 5083663
383 g_is_cc_selected_from_LOV VARCHAR2(1) := 'N';
384 Procedure Set_CC_Selected_From_Lov (p_CC_selected_from_LOV IN VARCHAR2);
385
386
387 PROCEDURE get_customer_details
388 ( p_org_id IN NUMBER
389 , p_site_use_code IN VARCHAR2
390 , x_customer_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
391 , x_customer_number OUT NOCOPY /* file.sql.39 change */ VARCHAR2
392 , x_customer_id OUT NOCOPY /* file.sql.39 change */ NUMBER
393 , x_location OUT NOCOPY /* file.sql.39 change */ VARCHAR2
394 , x_address1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
395 , x_address2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
396 , x_address3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
397 , x_address4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
398 , x_city OUT NOCOPY /* file.sql.39 change */ VARCHAR2
399 , x_state OUT NOCOPY /* file.sql.39 change */ VARCHAR2
400 , x_zip OUT NOCOPY /* file.sql.39 change */ VARCHAR2
401 , x_country OUT NOCOPY /* file.sql.39 change */ VARCHAR2
402 );
403
404 --ER7675548
405 Procedure Get_customer_info_ids
406 ( p_header_customer_info_tbl IN OUT NOCOPY OE_Order_Pub.CUSTOMER_INFO_TABLE_TYPE,
407 p_x_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type,
408 x_return_status OUT NOCOPY VARCHAR2,
409 x_msg_count OUT NOCOPY NUMBER,
410 x_msg_data OUT NOCOPY VARCHAR2
411 );
412
413 --7688372 start
414 TYPE attachment_rule_count_tab IS TABLE OF NUMBER INDEX by oe_attachment_rule_elements.ATTRIBUTE_CODE%TYPE;
415 g_attachment_rule_count_tab attachment_rule_count_tab;
416 --7688372 end
417 --Added for bug 8489881
418 FUNCTION Get_Primary_Site_Use_Id
419 ( p_site_use IN VARCHAR2,
420 p_cust_acct_id IN NUMBER,
421 p_org_id IN NUMBER)
422 RETURN NUMBER;
423
424 END OE_Header_Util;