[Home] [Help]
PACKAGE: APPS.OE_GLOBALS
Source
1 PACKAGE Oe_Globals AS
2 /* $Header: OEXSGLBS.pls 120.15.12010000.3 2008/11/19 10:28:44 vbkapoor ship $ */
3
4 G_LANG VARCHAR2(4) := USERENV('LANG');
5 G_LANGUAGE VARCHAR2(255) := USERENV('LANGUAGE');
6 G_SYSDATE DATE := SYSDATE;
7
8 -- Procedure Get_Entities_Tbl;
9 --
10 -- Used by generator to avoid overriding or duplicating existing
11 -- entity constants.
12 --
13 -- DO NOT MODIFY
14
15 PROCEDURE Get_Entities_Tbl;
16
17 -- Product entity constants.
18 -- Partial Validation Level. This might go away when moved to FND_API
19 G_VALID_LEVEL_PARTIAL CONSTANT NUMBER := 50;
20 -- Partial Validation Level with def.
21 G_VALID_PARTIAL_WITH_DEF CONSTANT NUMBER := 75;
22 -- Global Variable to hold ORG
23 G_ORG_ID NUMBER;
24
25 -- START GEN entities
26 -- bug 6817566
27 G_MANUAL_ADV_MODIFIER VARCHAR2(1) := NULL;
28
29
30 G_ENTITY_ALL CONSTANT VARCHAR2(30) := 'ALL';
31 G_ENTITY_COMMIT CONSTANT VARCHAR2(30) := 'COMMIT';
32
33 /* Order Object Entities: Begin */
34 G_ENTITY_HEADER CONSTANT VARCHAR2(30) := 'HEADER';
35 G_ENTITY_HEADER_ADJ CONSTANT VARCHAR2(30) := 'HEADER_ADJ';
36 G_ENTITY_HEADER_PRICE_ATT CONSTANT VARCHAR2(30) := 'HEADER_PATT';
37 G_ENTITY_HEADER_ADJ_ATT CONSTANT VARCHAR2(30) := 'HEADER_AATT';
38 G_ENTITY_HEADER_ADJ_ASSOC CONSTANT VARCHAR2(30) := 'HEADER_ASSOC';
39 G_ENTITY_HEADER_SCREDIT CONSTANT VARCHAR2(30) := 'HEADER_SCREDIT';
40 G_ENTITY_LINE CONSTANT VARCHAR2(30) := 'LINE';
41 G_ENTITY_LINE_ADJ CONSTANT VARCHAR2(30) := 'LINE_ADJ';
42 G_ENTITY_LINE_PRICE_ATT CONSTANT VARCHAR2(30) := 'LINE_PATT';
43 G_ENTITY_LINE_ADJ_ATT CONSTANT VARCHAR2(30) := 'LINE_AATT';
44 G_ENTITY_LINE_ADJ_ASSOC CONSTANT VARCHAR2(30) := 'LINE_ASSOC';
45 G_ENTITY_LINE_SCREDIT CONSTANT VARCHAR2(30) := 'LINE_SCREDIT';
46 G_ENTITY_LOT_SERIAL CONSTANT VARCHAR2(30) := 'LOT_SERIAL';
47 G_ENTITY_RESERVATION CONSTANT VARCHAR2(30) := 'RESERVATION';
48 G_ENTITY_HEADER_PAYMENT CONSTANT VARCHAR2(30) := 'HEADER_PAYMENT';
49 G_ENTITY_LINE_PAYMENT CONSTANT VARCHAR2(30) := 'LINE_PAYMENT';
50 /* Order Object Entities: End */
51
52 /* Pricing Contract Object Entities: Begin */
53 G_ENTITY_CONTRACT CONSTANT VARCHAR2(30) := 'CONTRACT';
54 G_ENTITY_AGREEMENT CONSTANT VARCHAR2(30) := 'AGREEMENT';
55 G_ENTITY_PRICE_LHEADER CONSTANT VARCHAR2(30) := 'PRICE_LHEADER';
56 G_ENTITY_DISCOUNT_HEADER CONSTANT VARCHAR2(30) := 'DISCOUNT_HEADER';
57 G_ENTITY_PRICE_LLINE CONSTANT VARCHAR2(30) := 'PRICE_LLINE';
58 G_ENTITY_DISCOUNT_CUST CONSTANT VARCHAR2(30) := 'DISCOUNT_CUST';
59 G_ENTITY_DISCOUNT_LINE CONSTANT VARCHAR2(30) := 'DISCOUNT_LINE';
60 G_ENTITY_PRICE_BREAK CONSTANT VARCHAR2(30) := 'PRICE_BREAK';
61 /* Pricing Contract Object Entities: End */
62
63 /* Charge Object Entities: Begin */
64 G_ENTITY_CHARGE_LINE CONSTANT VARCHAR2(30) := 'CHARGE_LINE';
65 /* Charge Object Entities: End */
66
67 /* Customer and Item Settings object: Begin */
68 G_ENTITY_CUST_ITEM_SET CONSTANT VARCHAR2(30) := 'CUST_ITEM_SET';
69 /* Customer and Item Settings object: End */
70 -- END GEN entities
71
72 -- following constants are used to debug lock_order,
73 -- please do not use them for any other purpose.
74
75 G_LOCK_TEST VARCHAR2(1):= 'N';
76 G_LOCK_CONST NUMBER := 0;
77
78 -- Operations.
79 G_OPR_INSERT CONSTANT VARCHAR2(30) := 'INSERT';
80 G_OPR_CREATE CONSTANT VARCHAR2(30) := 'CREATE';
81 G_OPR_UPDATE CONSTANT VARCHAR2(30) := 'UPDATE';
82 G_OPR_DELETE CONSTANT VARCHAR2(30) := 'DELETE';
83 G_OPR_LOCK CONSTANT VARCHAR2(30) := 'LOCK';
84 G_OPR_NONE CONSTANT VARCHAR2(30) := FND_API.G_MISS_CHAR;
85 G_OPR_DISCONTINUE CONSTANT VARCHAR2(30) := 'DISCONTINUE';
86
87 -- for 5331980 start
88 G_CALCULATE_LINE_TOTAL BOOLEAN := TRUE;
89 -- for 5331980 end
90
91 -- OE Item Types.
92 G_ITEM_MODEL CONSTANT VARCHAR2(30) := 'MODEL';
93 G_ITEM_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';
94 G_ITEM_INCLUDED CONSTANT VARCHAR2(30) := 'INCLUDED';
95 G_ITEM_CONFIG CONSTANT VARCHAR2(30) := 'CONFIG';
96 G_ITEM_CLASS CONSTANT VARCHAR2(30) := 'CLASS';
97 G_ITEM_OPTION CONSTANT VARCHAR2(30) := 'OPTION';
98 G_ITEM_KIT CONSTANT VARCHAR2(30) := 'KIT';
99 G_ITEM_SERVICE CONSTANT VARCHAR2(30) := 'SERVICE';
100
101 -- Included Item Freeze Methods
102 G_IIFM_ENTRY CONSTANT VARCHAR2(30) := 'ENTRY';
103 G_IIFM_BOOKING CONSTANT VARCHAR2(30) := 'BOOKING';
104 G_IIFM_PICK_RELEASE CONSTANT VARCHAR2(30) := 'PICK RELEASE';
105
106 -- OE Source Types
107 G_SOURCE_EXTERNAL CONSTANT VARCHAR2(30) := 'EXTERNAL';
108 G_SOURCE_INTERNAL CONSTANT VARCHAR2(30) := 'INTERNAL';
109
110 -- OE Order Sources
111 G_ORDER_SOURCE_COPY CONSTANT NUMBER := 2;
112 G_ORDER_SOURCE_EDI CONSTANT NUMBER := 6;
113 G_ORDER_SOURCE_INTERNAL CONSTANT NUMBER := 10;
114
115 -- OE Set Types.
116 G_SET_SHIP CONSTANT VARCHAR2(30) := 'SHIP';
117 G_SET_DELIVERY CONSTANT VARCHAR2(30) := 'DELIVERY';
118 G_SET_INVOICE CONSTANT VARCHAR2(30) := 'INVOICE';
119 G_SET_FULFILL CONSTANT VARCHAR2(30) := 'FULFILL';
120
121 -- Changes for Line Set Enhancements
122 G_ADD_FULFILLMENT_SET CONSTANT VARCHAR2(30) := 'ADD_FULFILLMENT_SET';
123 G_REMOVE_FULFILLMENT_SET CONSTANT VARCHAR2(30) := 'REMOVE_FULFILLMENT_SET';
124
125 -- Values for API Service Level argument in the group API (OEXGORDS/B.pls)
126 G_ALL_SERVICE CONSTANT VARCHAR2(30) := 'ALL';
127 G_CHECK_SECURITY_ONLY CONSTANT VARCHAR2(30) := 'CHECK_SECURITY_ONLY';
128 G_VALIDATION_ONLY CONSTANT VARCHAR2(30) := 'VALIDATION_ONLY';
129
130 -- Delayed Requests for Enhanced Drop Shipments
131 G_DROPSHIP_CMS CONSTANT Varchar2(30) := 'DROPSHIP_CMS';
132
133
134 -- added for bug 3636884, for group API calls, default the reason code,
135 -- unless called by order import (also added control_rec.require_reason)
136 G_DEFAULT_REASON BOOLEAN := FALSE;
137
138 -- added to determine when to use created_by context when retrieving profiles
139 G_FLOW_RESTARTED BOOLEAN := FALSE;
140 G_USE_CREATED_BY_CONTEXT BOOLEAN := FALSE;
141
142
143 /* Start Audit Trail */
144 -- Flag to determine if the change in the entity requires reason
145 -- for auditing purposes.
146 G_AUDIT_REASON_RQD_FLAG VARCHAR2(1) := 'N';
147 G_AUDIT_HISTORY_RQD_FLAG VARCHAR2(1) := 'N';
148 /* End Audit Trail */
149
150 /* Start Versioning */
151 G_ROLL_VERSION VARCHAR2(2) := 'N';
152 G_CAPTURED_REASON VARCHAR2(1) := 'N';
153 G_REASON_TYPE VARCHAR2(30) := NULL; --added for bug 3625599
154 G_REASON_CODE VARCHAR2(30) := NULL;
155 G_REASON_COMMENTS VARCHAR2(2000) := NULL;
156 G_VERSION_AUDIT VARCHAR2(30) := 'VERSION_AUDIT';
157 /* End Versioning */
158
159 -- Flag to de-activate recursion in process order: used by sets,
160 -- Configurations, Splits etc.
161 G_RECURSION_MODE VARCHAR2(1) := 'N';
162
163 -- Flag set by the sales order form to indicate to process order API that
164 -- the caller is UI
165 G_UI_FLAG BOOLEAN := FALSE;
166
167 -- This flag would be used by callers of the process order API to
168 -- find out whether the process order call resulted in cascading the
169 -- changes to other records/entities that were not directly operated on.
170 -- For e.g. cascading quantity changes on model lines to option classes
171 -- /option lines
172 -- This is set to TRUE when a cascading delayed request is LOGGED.
173 -- It is upto the caller to reset the flag back to FALSE after checking the
174 -- value. For e.g. the sales order form would check this value after
175 -- a call to process order and if TRUE,a message is displayed asking the user
176 -- if he/she wants to re-query so that changes to all the cascaded records are
177 -- displayed. If the changes are queried, the flag needs to be reset to FALSE
178 G_CASCADING_REQUEST_LOGGED BOOLEAN := FALSE;
179
180
181 -- this flag will be used to requery the lines/headers block
182 -- if any of lines/header change occurs through the call of process_objects
183 -- i.e. after validate and write. We need to refresh the block with
184 -- the changes happend in delayed req. execution.
185 -- is set to true in process_objects in oOEXFHDRB.pls and based
186 -- on it being true, we set the G_CASCADING_REQUEST_LOGGED to true
187 -- in OEXVREQB.pls in process_request_pvt.
188
189 G_PROCESS_OBJECTS_FLAG BOOLEAN := FALSE;
190
191 -- Delayed Request Entity Types
192 G_DREQ_HEADER CONSTANT Varchar2(30) := 'HEADER';
193 G_DREQ_LINE CONSTANT Varchar2(30) := 'LINE';
194
195 -- DELAYED REQUEST TYPES
196 G_FTE_REINVOKE VARCHAR2(1) := 'N';
197 G_DELETE_CHARGES CONSTANT VARCHAR2(30):= 'DELETE_CHARGES';
198 G_PRICE_LINE CONSTANT VARCHAR2(30) := 'PRICE_LINE';
199 G_PRICE_ORDER CONSTANT VARCHAR2(30) := 'PRICE_ORDER';
200 G_PRICE_ADJ CONSTANT VARCHAR2(30) := 'PRICE_ADJ';
201 G_COPY_ADJUSTMENTS CONSTANT VARCHAR2(30) := 'COPY_ADJUSTMENTS';
202 G_COPY_FREIGHT_CHARGES CONSTANT VARCHAR2(30) := 'COPY_FREIGHT_CHARGES';
203 /* Added the following line to fix the bug 2170086 */
204 G_COPY_HEADER_ADJUSTMENTS CONSTANT VARCHAR2(30) := 'COPY_HEADER_ADJUSTMENTS';
205 G_TAX_LINE CONSTANT VARCHAR2(30) := 'TAX_LINE';
206 G_PRICE_FLAG VARCHAR2(30);
207 G_PRICING_RECURSION VARCHAR2(1) := 'N';
208 G_TAX_FLAG VARCHAR2(30);
209 G_CHANGE_CFG_FLAG VARCHAR2(1) := 'Y';
210 G_COPY_PRICING_ATTRIBUTES CONSTANT VARCHAR2(30) := 'COPY_PRICING_ATTRIBUTES';
211 G_COPY_MODEL_PATTR CONSTANT VARCHAR2(30) := 'COPY_MODEL_PATTR';
212 G_DEL_CHG_LINES VARCHAR2(30) := 'DEL_CHG_LINES';
213 G_REVERSE_LIMITS CONSTANT VARCHAR2(30) := 'REVERSE_LIMITS'; -- BUG 2013611
214 G_FREIGHT_FOR_INCLUDED CONSTANT VARCHAR2(30) := 'FREIGHT_FOR_INCLUDED';
215 G_MARGIN_HOLD CONSTANT VARCHAR2(12):='MARGIN_HOLD';
216 G_GET_COST CONSTANT VARCHAR2(8) := 'GET_COST';
217 G_FREIGHT_RATING CONSTANT VARCHAR2(30) := 'FREIGHT_RATING';
218 G_GET_FREIGHT_RATES CONSTANT VARCHAR2(30) := 'GET_FREIGHT_RATES';
219 G_GET_SHIP_METHOD_AND_RATES CONSTANT VARCHAR2(30) := 'GET_SHIP_METHOD_AND_RATES';
220
221 -- Delayed requests for Payments
222 G_CALCULATE_COMMITMENT CONSTANT VARCHAR2(30) := 'CALCULATE_COMMITMENT';
223 G_UPDATE_COMMITMENT CONSTANT VARCHAR2(30) := 'UPDATE_COMMITMENT';
224 G_UPDATE_COMMITMENT_APPLIED CONSTANT VARCHAR2(30) := 'UPDATE_COMMITMENT_APPLIED';
225 G_COMMITMENT_BALANCE NUMBER;
226 G_ORIGINAL_COMMITMENT_APPLIED NUMBER;
227 G_SPLIT_PAYMENT CONSTANT VARCHAR2(30) := 'SPLIT_PAYMENT';
228 G_UPDATE_HDR_PAYMENT CONSTANT VARCHAR2(30) := 'UPD_HDR_PAYMENT';
229 G_APPLY_PPP_HOLD CONSTANT VARCHAR2(30) := 'APPLY_PPP_HOLD';
230 G_PROCESS_PAYMENT CONSTANT VARCHAR2(30) := 'PROCESS_PAYMENT';
231 G_DELETE_PAYMENT_HOLD CONSTANT VARCHAR2(30) := 'DELETE_PAYMENT_HOLD';
232 G_DELETE_PAYMENTS CONSTANT VARCHAR2(30) := 'DELETE_PAYMENTS'; --R12 CC Encryption
233
234 --RT{
235 G_COPY_RETROBILL_ADJ VARCHAR2(30):='COPY_RETROBILLING_ADJUSTMENTS';
236 --RT}
237
238 -- pricing header / line level adjustments
239 G_PROCESS_ADJUSTMENTS CONSTANT VARCHAR2(30) := 'PROCESS_ADJUSTMENTS';
240
241 -- check max percentage on price adjustments
242 G_CHECK_PERCENTAGE CONSTANT VARCHAR2(30) := 'CHECK_PERCENTAGE';
243
244 -- check the duplication of a discount
245 G_CHECK_DUPLICATE CONSTANT VARCHAR2(30) := 'CHECK_DUPLICATE';
246
247 -- check the application of a price discount
248 G_CHECK_FIXED_PRICE CONSTANT VARCHAR2(30) := 'CHECK_FIXED_PRICE';
249
250 -- Delayed Request for Holds
251 G_APPLY_HOLD CONSTANT VARCHAR2(30) := 'APPLY_HOLD';
252 G_RELEASE_HOLD CONSTANT VARCHAR2(30) := 'RELEASE_HOLD';
253
254 -- Delayed request for Holds when a line splits
255 G_SPLIT_HOLD CONSTANT VARCHAR2(30) := 'SPLIT_HOLD';
256
257 -- Delayed Request for Sales Credits
258 G_CHECK_HSC_QUOTA_TOTAL CONSTANT Varchar2(30) := 'CHECK_HSC_QUOTA_TOTAL';
259 G_CHECK_LSC_QUOTA_TOTAL CONSTANT Varchar2(30) := 'CHECK_LSC_QUOTA_TOTAL';
260 G_CASCADE_SERVICE_SCREDIT CONSTANT Varchar2(30) := 'CASCADE_SERVICE_SCREDIT';
261 G_DFLT_HSCREDIT_FOR_SREP CONSTANT Varchar2(30) := 'DFLT_HSCREDIT_FOR_SREP';
262
263 G_CREATE_SETS CONSTANT Varchar2(30) := 'CREATE_SETS';
264 G_VALIDATE_LINE_SET CONSTANT Varchar2(30) := 'VALIDATE_SET';
265 G_SPLIT_SET_CHK CONSTANT Varchar2(30) := 'SPLIT_SET';
266 G_CREATE_RESERVATIONS CONSTANT Varchar2(30) := 'CREATE_RESERVATIONS';
267 G_INSERT_INTO_SETS CONSTANT Varchar2(30) := 'INSERT_INTO_SETS';
268 G_SCHEDULE_LINE CONSTANT Varchar2(30) := 'SCHEDULE_LINE';
269 G_RESCHEDULE_LINE CONSTANT Varchar2(30) := 'RESCHEDULE_LINE';
270 G_SCHEDULE_SMC CONSTANT Varchar2(30) := 'SCHEDULE_SMC';
271 G_SCHEDULE_ATO CONSTANT Varchar2(30) := 'SCHEDULE_ATO';
272 /* Added the following line to fix the bug 6663462 */
273 G_DELAYED_SCHEDULE CONSTANT Varchar2(30) := 'DELAYED_SCHEDULE';
274
275
276 G_SCHEDULE_NONSMC CONSTANT Varchar2(30) := 'SCHEDULE_NONSMC';
277 G_CASCADE_SHIP_SET_ATTR CONSTANT Varchar2(30) := 'CASCADE_SHIP_SET_ATTR';
278
279 -- Delayed Request/ Actions for ATO/PTO Models
280 G_INS_INCLUDED_ITEMS CONSTANT Varchar2(30) := 'INS_INCLUDED_ITEMS';
281 G_CREATE_CONFIG_ITEM CONSTANT Varchar2(30) := 'CREATE_CONFIG_ITEM';
282 G_CASCADE_CHANGES CONSTANT Varchar2(30) := 'CASCADE_CHANGES ';
283 G_CHANGE_CONFIGURATION CONSTANT Varchar2(30) := 'CHG_CONFIGURATION ';
284 G_CASCADE_QUANTITY CONSTANT Varchar2(30) := 'CASCADE_QUANTITY';
285 G_CASCADE_PROJECT CONSTANT Varchar2(30) := 'G_CASCADE_PROJECT';
286 G_CASCADE_TASK CONSTANT Varchar2(30) := 'G_CASCADE_TASK';
287 G_COPY_CONFIGURATION CONSTANT Varchar2(30) := 'COPY_CONFIGURATION';
288 G_COMPLETE_CONFIGURATION CONSTANT Varchar2(30) := 'COMPLETE_CONFIGURATION';
289 G_VALIDATE_CONFIGURATION CONSTANT Varchar2(30) := 'VALIDATE_CONFIGURATION';
290 G_MATCH_AND_RESERVE CONSTANT Varchar2(30) := 'MATCH_AND_RESERVE';
291 G_DELINK_CONFIG CONSTANT Varchar2(30) := 'DELINK_CONFIG';
292 G_LINK_CONFIG CONSTANT Varchar2(30) := 'LINK_CONFIG';
293 G_DELETE_OPTION CONSTANT Varchar2(30) := 'DELETE_OPTION';
294 G_UPDATE_OPTION CONSTANT Varchar2(30) := 'UPDATE_OPTION';
295 G_CTO_NOTIFICATION CONSTANT Varchar2(30) := 'CTO_NOTIFICATION';
296 G_CTO_CHANGE CONSTANT Varchar2(30) := 'CTO_CHANGE';
297
298 -- delayed request for scheduleing
299 G_GROUP_SCHEDULE CONSTANT Varchar2(30) := 'GROUP_SCHEDULE';
300 G_GROUP_SET CONSTANT Varchar2(30) := 'GROUP_SET';
301 G_SPLIT_SCHEDULE CONSTANT Varchar2(30) := 'SPLIT_SCHEDULE';
302 -- 40256758 : delayed request to delete set
303 G_DELETE_SET CONSTANT Varchar2(30) := 'DELETE_SET';
304
305 G_FORCE_CLEAR_UI_BLOCK VARCHAR2(1) := 'N';
306
307 -- delayed request for Payment Verification
308 G_VERIFY_PAYMENT CONSTANT VARCHAR2(30) := 'VERIFY_PAYMENT';
309
310 -- delayed request for Updating Shipping from OE
311 G_UPDATE_SHIPPING CONSTANT VARCHAR2(30) := 'UPDATE_SHIPPING';
312
313 -- delayed request for Ship Confirmation
314 G_SHIP_CONFIRMATION CONSTANT VARCHAR2(30) := 'SHIP_CONFIRMATION';
315
316 -- delayed request for Work flow Activity completion
317 G_COMPLETE_ACTIVITY CONSTANT VARCHAR2(30) := 'COMPLETE_ACTIVITY';
318
319 --2391781
320 -- delayed request for scheduling attribute changes in sets
321 G_CASCADE_SCH_ATTRBS CONSTANT VARCHAR2(30) := 'CASCADE_SCH_ATTRIBUTES';
322
323 -- Shipment Statuses for a line
324 G_FULLY_SHIPPED CONSTANT VARCHAR2(30) := 'Fully Shipped';
325 G_SHIPPED_WITHIN_TOL_BELOW CONSTANT VARCHAR2(30) := 'Shipped within tolerance below';
326 G_SHIPPED_WITHIN_TOL_ABOVE CONSTANT VARCHAR2(30) := 'Shipped within tolerance above';
327 G_SHIPPED_BEYOND_TOLERANCE CONSTANT VARCHAR2(30) := 'Shipped beyond tolerance';
328 G_PARTIALLY_SHIPPED CONSTANT VARCHAR2(30) := 'Partially Shipped';
329
330 -- delayed request for RMA
334
331 G_INSERT_RMA CONSTANT VARCHAR2(30) := 'INSERT_RMA';
332 G_CHECK_OVER_RETURN CONSTANT VARCHAR2(30) := 'CHECK_OVER_RETURN';
333
335 -- Delayed request for Service
336 G_INSERT_SERVICE CONSTANT VARCHAR2(30) := 'INSERT_SERVICE';
337 /* added for bug #1533658 */
338 G_UPDATE_SERVICE CONSTANT VARCHAR2(30) := 'UPDATE_SERVICE';
339
340 /* lchen added for bug 1761154 */
341 G_CASCADE_OPTIONS_SERVICE CONSTANT VARCHAR2(30) := 'CASCADE_OPTIONS_SERVICE';
342
343
344 -- Delayed Request for Applying or Removing Holds when hold source entities
345 -- (customer/site/item) are entered or updated on the order or line.
346 G_EVAL_HOLD_SOURCE CONSTANT VARCHAR2(30) := 'EVAL_HOLD_SOURCE';
347
348 /* 7576948: IR ISO Change Management project Start */
349 -- delayed requet for updating Internal Requisition in Purchasing.
350 -- This is added for IR ISO Change Management project
351 G_UPDATE_REQUISITION CONSTANT VARCHAR2(30) := 'UPDATE_INTERNAL_REQ';
352 /* IR ISO Change Management project End */
353
354 -- Action Request to Book the Order
355 G_BOOK_ORDER CONSTANT VARCHAR2(30) := 'BOOK_ORDER';
356
357 -- Action Request to get the Ship Method for Order
358 G_GET_SHIP_METHOD CONSTANT VARCHAR2(30) := 'GET_SHIP_METHOD';
359 G_FTE_INSTALLED VARCHAR2(1) := NULL;
360
361 -- Delayed Request/Action Request for Applying Automatic Attachments
362 G_APPLY_AUTOMATIC_ATCHMT CONSTANT VARCHAR2(30) := 'AUTOMATIC_ATCHMT';
363 -- Delayed Request for Copying Attachments
364 G_COPY_ATCHMT CONSTANT VARCHAR2(30) := 'COPY_ATCHMT';
365
366 --Delayed Request for the automatic internal req creation (ikon) Mshenoy
367 G_CREATE_INTERNAL_REQ CONSTANT VARCHAR2(30) := 'CREATE_INTERNAL_REQ';
368
369 --Delayed Request for XML Generation
370 G_GENERATE_XML_REQ_HDR CONSTANT VARCHAR2(30) := 'GENERATE_XML_REQ_HDR';
371 G_GENERATE_XML_REQ_LN CONSTANT VARCHAR2(30) := 'GENERATE_XML_REQ_LN';
372
373 --Delayed Request for 3A7 Hold
374 G_XML_APPLY_3A7_HOLD_REQ CONSTANT VARCHAR2(30) := 'XML_APPLY_3A7_HOLD';
375
376 -- Added 09-DEC-2002
377 -- DELAYED REQUESTS FOR BLANKETS/RELEASES
378 G_PROCESS_RELEASE CONSTANT VARCHAR2(30) := 'PROCESS_RELEASE';
379 G_VALIDATE_RELEASE_SHIPMENTS CONSTANT VARCHAR2(30) := 'VALIDATE_RELEASE_SHIPMENTS';
380
381 --Delayed Request for Clearing a Blanket Pricelist Line.Bug 3309427
382 G_CLEAR_BLKT_PRICE_LIST_LINE CONSTANT VARCHAR2(30) := 'CLEAR_BLKT_PRICE_LIST_LINE';
383
384 -- delayed request for scheduleing
385 G_CANCEL_WF CONSTANT Varchar2(30) := 'CANCEL_WF';
386
387 -- Attribute groups for processing constraints
388 G_ATTR_GRP_HSCREDIT CONSTANT Varchar2(30) := 'HEADER_SCREDIT';
389 G_ATTR_GRP_LSCREDIT CONSTANT Varchar2(30) := 'LINE_SCREDIT';
390
391 -- Return Category Code
392 G_RETURN_CATEGORY_CODE CONSTANT Varchar2(30) := 'RETURN';
393
394 -- Used when processing children of a return line
395 -- This is for internal returns processing use only
396 G_RETURN_CHILDREN_MODE Varchar2(1) := 'N';
397
398 -- Max number of defaulting tterations.
399 G_MAX_DEF_ITERATIONS CONSTANT NUMBER:= 5;
400
401 -- Please follow the naming convention for prefixing any of the
402 -- following Workflow attributes
403 -- G_WFI -- item type
404 -- G_WFIA -- item attribute
405 -- G_WFA -- activity
406 -- G_WFR -- results
407 -----------------------------------------------------------------
408 -- Workflow Item Types
409
410 G_WFI_HDR CONSTANT VARCHAR2(8) := 'OEOH';
411 G_WFI_LIN CONSTANT VARCHAR2(8) := 'OEOL';
412
413 G_WFI_NGO CONSTANT VARCHAR2(8) := 'OENH';
414 G_WFI_BKT CONSTANT VARCHAR2(8) := 'OEBH';
415
416
417 -- Sales Document Type Code for Quote vs Blanket
418 G_SALES_DOCUMENT_TYPE_CODE VARCHAR2(1) := NULL;
419
420 -- Common Workflow Results
421 G_WFR_COMPLETE CONSTANT VARCHAR2(30) := 'COMPLETE';
422 G_WFR_INCOMPLETE CONSTANT VARCHAR2(30) := 'INCOMPLETE';
423 G_WFR_ON_HOLD CONSTANT VARCHAR2(30) := 'ON_HOLD';
424 G_WFR_NOT_ELIGIBLE CONSTANT VARCHAR2(30) := 'NOT_ELIGIBLE';
425 G_WFR_PRTL_COMPLETE CONSTANT VARCHAR2(30) := 'PRTL_COMPLETE';
426 G_WFR_PRTL_INCOMPLETE CONSTANT VARCHAR2(30) := 'PRTL_INCOMPLETE';
427 G_WFR_PENDING_ACCEPTANCE VARCHAR2(30) := 'PENDING_ACCEPTANCE';
428
429 -- Seeded Workflow Activities
430 G_WFA_PICK_ORDER CONSTANT VARCHAR2(30) := 'PICK_ORDER';
431 G_WFA_PICK_ORDER_LINE CONSTANT VARCHAR2(30) := 'PICK_ORDER_LINE';
432
433 -- Globals used for starting Order and Line flows
434
435 -- This indicates whether a Header flow needs to be started.
436 G_START_HEADER_FLOW NUMBER := NULL;
437
438 -- This indicates whether a Negotiation Header flow needs to be started.
439 G_START_NEGOTIATE_HEADER_FLOW NUMBER := NULL;
440
441 -- This indicates whether a Blanket Header (fulfillment) flow needs to be started.
442 G_START_BLANKET_HEADER_FLOW NUMBER := NULL;
443
444
445 -- This indicates whether we have started executing the code that starts on the pending
446 -- header and line flows.
447 G_FLOW_PROCESSING_STARTED BOOLEAN := FALSE;
448 --This flag indicates if the flex fields has to be validated .By default it is set to Y
449 --However Public API and Group API can set these values to Y/N based on parameter p_validate_desc_flex
450 --R12 CVV2
451 G_PAYMENT_PROCESSED VARCHAR2(1);
452 --R12 CVV2
453
457
454 --This flag indicates if the flex fields has to be validated .By default it is set to Y
455 --However Public API and Group API can set these values to Y/N based on parameter p_validate_desc_flex
456 g_validate_desc_flex varchar2(1) :='Y'; -- 4343612
458 -- For bug 3000619
459 TYPE Line_ID_List_Rec IS Record
460 ( line_id NUMBER
461 ,post_write_ato_line_id NUMBER);
462
463
464 -- Table type used for storing Line Ids that need their flows to be started
465 -- Bug 3000619, changed line_id_list to be a table of Line_ID_List_Rec
466 TYPE Line_ID_List IS TABLE OF Line_ID_List_Rec INDEX BY BINARY_INTEGER;
467
468 -- Global table used for storing Line Ids that need their flows to be started
469 G_START_LINE_FLOWS_TBL Line_ID_List;
470
471
472
473 -- Cancellation Specific declarations
474 -- Results of Cancelation Operation
475 G_CANCELED CONSTANT VARCHAR2(1) := 'Y';
476 G_CANNOT_CANCEL CONSTANT VARCHAR2(1) := 'N';
477 G_NOTIFIED CONSTANT VARCHAR2(1) := 'A';
478 G_FULL CONSTANT VARCHAR2(1) := 'F';
479 G_PARTIAL CONSTANT VARCHAR2(1) := 'P';
480 G_CANCELATION_HOLD_ID CONSTANT NUMBER := 4;
481 G_CAN_HIST_TYPE_CODE CONSTANT VARCHAR2(30) := 'CANCELLATION';
482
483 -- Commit specific requests that need to executed
484
485 G_GAPLESS_ORDER_NUMBER CONSTANT VARCHAR2(30) := 'GEN_GAPLESS_ORDNUM';
486
487 -- To check if a specific product is installed
488 G_FND_INSTALLED VARCHAR2(1) := NULL;
489 G_IPAYMENT_INSTALLED VARCHAR2(1) := NULL;
490 G_OTA_INSTALLED VARCHAR2(1) := NULL;
491 G_ASO_INSTALLED VARCHAR2(1) := NULL;
492 G_OKS_INSTALLED VARCHAR2(1) := NULL;
493 G_EC_INSTALLED VARCHAR2(1) := NULL;
494 G_CONFIGURATOR_INSTALLED VARCHAR2(1) := NULL;
495 G_RLM_INSTALLED VARCHAR2(1) := NULL;
496 G_GMI_INSTALLED VARCHAR2(1) := NULL; -- OPM 2547940
497
498 -- Global to check whether the header record is created in the same call.
499 G_HEADER_CREATED BOOLEAN := FALSE;
500
501 -- Global flag to determine if this is from html om ui session
502 G_HTML_FLAG BOOLEAN := FALSE;
503
504 -- global to indicate current XML transaction type
505 G_XML_TXN_CODE VARCHAR2(30) := NULL;
506
507 -- Global which would indicate whether defaulting updated any
508 -- attributes or not.
509 -- Callers that need to check this global value should always
510 -- initialize it to 'N' before making a call to any API (e.g. process
511 -- order, clear_dep_and_default) that could result in defaulting.
512 -- If it is set to 'Y'
513 -- after the call, it indicates that at least one attribute was
514 -- updated by defaulting.
515 G_ATTR_UPDATED_BY_DEF VARCHAR2(1) := 'N';
516 G_FREIGHT_RECURSION VARCHAR2(1) := 'N';
517 -- Global Indicates whether pricing is deferred at line level
518 G_DEFER_PRICING VARCHAR2(1) := 'N';
519
520 --Action Requests for Customer Acceptance
521 G_ACCEPT_FULFILLMENT CONSTANT VARCHAR2(30) := 'ACCEPT_FULFILLMENT';
522 G_REJECT_FULFILLMENT CONSTANT VARCHAR2(30) := 'REJECT_FULFILLMENT';
523 G_DFLT_CONTINGENCY_ATTRIBUTES CONSTANT VARCHAR2(30) := 'DEFAULT_CONTINGENCY_ATTRIBUTES';
524 G_UPDATE_GLOBAL_PICTURE VARCHAR2(30) := 'Y';
525
526 -- To allow order import to fail in cases where partial
527 -- processing should apply only to direct callers of process order
528 G_FAIL_ORDER_IMPORT BOOLEAN := FALSE; /* Bug # 4036765 */
529
530 -- Added for bug 7367433. This indicates if Process Order code is being executed as part of Order Import call or not.
531 G_ORDER_IMPORT_CALL BOOLEAN := FALSE;
532
533 -- Index table type used by JVC controllers.
534 TYPE Index_Tbl_Type IS TABLE OF BINARY_INTEGER
535 INDEX BY BINARY_INTEGER;
536
537 -- API Operation control flags.
538 TYPE Control_Rec_Type IS RECORD
539 ( controlled_operation BOOLEAN := FALSE
540 , Private_Call BOOLEAN := TRUE
541 , check_security BOOLEAN := TRUE
542 , clear_dependents BOOLEAN := TRUE
543 , default_attributes BOOLEAN := TRUE
544 , change_attributes BOOLEAN := TRUE
545 , validate_entity BOOLEAN := TRUE
546 , write_to_db BOOLEAN := TRUE
547 , Process_Partial BOOLEAN := FALSE
548 , process BOOLEAN := TRUE
549 , process_entity VARCHAR2(30) := G_ENTITY_ALL
550 , clear_api_cache BOOLEAN := TRUE
551 , clear_api_requests BOOLEAN := TRUE
552 , request_category VARCHAR2(30):= NULL
553 , request_name VARCHAR2(30):= NULL
554 , org_id NUMBER := FND_API.G_MISS_NUM
555 , require_reason BOOLEAN := NULL
556 );
557
558
559 -- Variable representing missing control record.
560
561 G_MISS_CONTROL_REC Control_Rec_Type;
562
563 /* Request rec and request table definition has been moved to OEXPORDS */
564 -- API request record type.
565 /*
566 TYPE Request_Rec_Type IS RECORD
567 (
568 -- entity VARCHAR2(30) := NULL
569 --, step VARCHAR2(30) := NULL
570 --, name VARCHAR2(30) := NULL
571 --, category VARCHAR2(30) := NULL
572 --, processed BOOLEAN := FALSE
573 --, attribute1 VARCHAR2(240) := NULL
574 --, attribute2 VARCHAR2(240) := NULL
575 --, attribute3 VARCHAR2(240) := NULL
576 --, attribute4 VARCHAR2(240) := NULL
577 --, attribute5 VARCHAR2(240) := NULL
578
579
580 -- merge from admin/sql
581 -- Object for which the delayed request has been logged
582 -- ie LINE, ORDER, PRICE_ADJUSTMENT
583 Entity_code Varchar2(30):= NULL,
584
585 -- Primary key for the object as in entity_code
586 Entity_id Number := NULL,
587
588 -- Function / Procedure indentifier ie 'PRICE_LINE'
589 -- 'RECORD_HISTORY'
590 request_type Varchar2(30) := NULL,
591
592 return_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
593
594 -- Parameters (param - param10) for the delayed request
595 param1 Varchar2(2000) := NULL,
596 param2 Varchar2(240) := NULL,
597 param3 Varchar2(240) := NULL,
598 param4 Varchar2(240) := NULL,
599 param5 Varchar2(240) := NULL,
600 param6 Varchar2(240) := NULL,
601 param7 Varchar2(240) := NULL,
602 param8 Varchar2(240) := NULL,
603 param9 Varchar2(240) := NULL,
604 param10 Varchar2(240) := NULL,
605 long_param1 Varchar2(2000) := NULL,
606 processed BOOLEAN := FALSE
607
608 );
609
610 -- API Request table type.
611
612 TYPE Request_Tbl_Type IS TABLE OF Request_Rec_Type
613 INDEX BY BINARY_INTEGER;
614
615 -- Missing request record type
616 G_MISS_REQUEST_REC Request_Rec_Type;
617 G_MISS_REQUEST_TBL Request_Tbl_Type;
618 */
619
620 /* History type 'R' -> requires reason and history
621 'H' -> requires only history */
622
623 TYPE OE_AUDIT_HISTORY_REC IS RECORD
624 (HEADER_ID NUMBER,
625 LINE_ID NUMBER,
626 HISTORY_TYPE VARCHAR2(1));
627
628 TYPE oe_audit_trail_history_tbl IS TABLE OF oe_audit_history_rec
629 INDEX BY BINARY_INTEGER;
630
631 OE_AUDIT_HISTORY_TBL oe_audit_trail_history_tbl;
632
633 -- Generic table types
634 TYPE Boolean_Tbl_Type IS TABLE OF BOOLEAN
635 INDEX BY BINARY_INTEGER;
636
637 TYPE Number_Tbl_Type IS TABLE OF NUMBER
638 INDEX BY BINARY_INTEGER;
639
640 -- Variable representing a missing table.
641 G_MISS_BOOLEAN_TBL Boolean_Tbl_Type;
642 G_MISS_NUMBER_TBL Number_Tbl_Type;
643
644 TYPE ACCESS_LIST IS TABLE OF VARCHAR2(100)
645 INDEX BY BINARY_INTEGER;
646 G_ACCESS_LIST ACCESS_LIST;
647 -- Get Application ID #1942082
648
649 -- added for Electronic Messaging Exc Mgmt
650 G_EM_ACCESS_LIST ACCESS_LIST;
651 -- end Electronic Messaging Exc Mgmt
652
653 FUNCTION GET_APPLICATION_ID
654 ( p_resp_id IN NUMBER
655 ) RETURN NUMBER;
656
657 -- Initialize control record.
658 FUNCTION Init_Control_Rec
659 ( p_operation IN VARCHAR2
660 , p_control_rec IN Control_Rec_Type
661 )RETURN Control_Rec_Type;
662
663 -- Function Equal
664 -- Number comparison.
665
666 FUNCTION Equal
667 ( p_attribute1 IN NUMBER
668 , p_attribute2 IN NUMBER
669 )RETURN BOOLEAN;
670
671 -- Varchar2 comparison.
672
673 FUNCTION Equal
674 ( p_attribute1 IN VARCHAR2
675 , p_attribute2 IN VARCHAR2
676 )RETURN BOOLEAN;
677
678 -- Date comparison.
679
680 FUNCTION Equal
681 ( p_attribute1 IN DATE
682 , p_attribute2 IN DATE
683 )RETURN BOOLEAN;
684
685
686 PROCEDURE Set_Context;
687
688 FUNCTION CHECK_PRODUCT_INSTALLED
689 ( p_application_id IN NUMBER
690 )RETURN VARCHAR2;
691
692 FUNCTION GET_FORCE_CLEAR_UI_BLOCK RETURN VARCHAR2;
693 PROCEDURE SET_FORCE_CLEAR_UI_BLOCK (ui_block IN VARCHAR2);
694
695 FUNCTION Is_Same_Credit_Card
696 ( p_cc_num_old IN VARCHAR2 DEFAULT NULL
697 , p_cc_num_new IN VARCHAR2 DEFAULT NULL
698 , p_instrument_id_old IN NUMBER DEFAULT NULL
699 , p_instrument_id_new IN NUMBER DEFAULT NULL
700 )RETURN BOOLEAN;
701
702 TYPE Selected_Record_Type IS RECORD
703 (
704 id1 NUMBER
705 ,id2 NUMBER
706 ,id3 NUMBER
707 ,id4 NUMBER
708 ,id5 NUMBER
709 ,org_id NUMBER
710 );
711
712 TYPE Selected_Record_Tbl IS TABLE OF Selected_Record_Type
713 INDEX BY BINARY_INTEGER;
714
715
716 END Oe_Globals;