[Home] [Help]
PACKAGE: APPS.OE_GLOBALS
Source
1 PACKAGE Oe_Globals AUTHID CURRENT_USER AS
2 /* $Header: OEXSGLBS.pls 120.25.12020000.3 2013/02/12 16:01:31 nilegupt 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_ASSOCIATION CONSTANT VARCHAR2(30) := 'COPY_ASSOCIATION'; --bug 16317238
203 G_COPY_FREIGHT_CHARGES CONSTANT VARCHAR2(30) := 'COPY_FREIGHT_CHARGES';
204 /* Added the following line to fix the bug 2170086 */
205 G_COPY_HEADER_ADJUSTMENTS CONSTANT VARCHAR2(30) := 'COPY_HEADER_ADJUSTMENTS';
206 G_TAX_LINE CONSTANT VARCHAR2(30) := 'TAX_LINE';
207 G_PRICE_FLAG VARCHAR2(30);
208 G_PRICING_RECURSION VARCHAR2(1) := 'N';
209 G_TAX_FLAG VARCHAR2(30);
210 G_CHANGE_CFG_FLAG VARCHAR2(1) := 'Y';
211 G_COPY_PRICING_ATTRIBUTES CONSTANT VARCHAR2(30) := 'COPY_PRICING_ATTRIBUTES';
212 G_COPY_MODEL_PATTR CONSTANT VARCHAR2(30) := 'COPY_MODEL_PATTR';
213 G_DEL_CHG_LINES VARCHAR2(30) := 'DEL_CHG_LINES';
214 G_REVERSE_LIMITS CONSTANT VARCHAR2(30) := 'REVERSE_LIMITS'; -- BUG 2013611
215 G_FREIGHT_FOR_INCLUDED CONSTANT VARCHAR2(30) := 'FREIGHT_FOR_INCLUDED';
216 G_MARGIN_HOLD CONSTANT VARCHAR2(12):='MARGIN_HOLD';
217 G_GET_COST CONSTANT VARCHAR2(8) := 'GET_COST';
218 G_FREIGHT_RATING CONSTANT VARCHAR2(30) := 'FREIGHT_RATING';
219 G_GET_FREIGHT_RATES CONSTANT VARCHAR2(30) := 'GET_FREIGHT_RATES';
220 G_GET_SHIP_METHOD_AND_RATES CONSTANT VARCHAR2(30) := 'GET_SHIP_METHOD_AND_RATES';
221
222 G_DR_COPY_OTM_RECORDS CONSTANT VARCHAR2(30) := 'DR_COPY_OTM_RECORDS'; --BUG#10052614
223
224 -- Delayed requests for Payments
225 G_CALCULATE_COMMITMENT CONSTANT VARCHAR2(30) := 'CALCULATE_COMMITMENT';
226 G_UPDATE_COMMITMENT CONSTANT VARCHAR2(30) := 'UPDATE_COMMITMENT';
227 G_UPDATE_COMMITMENT_APPLIED CONSTANT VARCHAR2(30) := 'UPDATE_COMMITMENT_APPLIED';
228 G_COMMITMENT_BALANCE NUMBER;
229 G_ORIGINAL_COMMITMENT_APPLIED NUMBER;
230 G_SPLIT_PAYMENT CONSTANT VARCHAR2(30) := 'SPLIT_PAYMENT';
231 G_UPDATE_HDR_PAYMENT CONSTANT VARCHAR2(30) := 'UPD_HDR_PAYMENT';
232 G_APPLY_PPP_HOLD CONSTANT VARCHAR2(30) := 'APPLY_PPP_HOLD';
233 G_PROCESS_PAYMENT CONSTANT VARCHAR2(30) := 'PROCESS_PAYMENT';
234 G_DELETE_PAYMENT_HOLD CONSTANT VARCHAR2(30) := 'DELETE_PAYMENT_HOLD';
235 G_DELETE_PAYMENTS CONSTANT VARCHAR2(30) := 'DELETE_PAYMENTS'; --R12 CC Encryption
236 G_CALLING_SOURCE VARCHAR2(5) := 'WSH'; --8478151
237
238 --RT{
239 G_COPY_RETROBILL_ADJ VARCHAR2(30):='COPY_RETROBILLING_ADJUSTMENTS';
240 --RT}
241
242 -- pricing header / line level adjustments
243 G_PROCESS_ADJUSTMENTS CONSTANT VARCHAR2(30) := 'PROCESS_ADJUSTMENTS';
244
245 -- check max percentage on price adjustments
246 G_CHECK_PERCENTAGE CONSTANT VARCHAR2(30) := 'CHECK_PERCENTAGE';
247
248 -- check the duplication of a discount
249 G_CHECK_DUPLICATE CONSTANT VARCHAR2(30) := 'CHECK_DUPLICATE';
250
251 -- check the application of a price discount
252 G_CHECK_FIXED_PRICE CONSTANT VARCHAR2(30) := 'CHECK_FIXED_PRICE';
253
254 -- Delayed Request for Holds
255 G_APPLY_HOLD CONSTANT VARCHAR2(30) := 'APPLY_HOLD';
256 G_RELEASE_HOLD CONSTANT VARCHAR2(30) := 'RELEASE_HOLD';
257
258 -- Delayed request for Holds when a line splits
259 G_SPLIT_HOLD CONSTANT VARCHAR2(30) := 'SPLIT_HOLD';
260
261 -- Delayed Request for Sales Credits
262 G_CHECK_HSC_QUOTA_TOTAL CONSTANT Varchar2(30) := 'CHECK_HSC_QUOTA_TOTAL';
263 G_CHECK_LSC_QUOTA_TOTAL CONSTANT Varchar2(30) := 'CHECK_LSC_QUOTA_TOTAL';
264 G_CASCADE_SERVICE_SCREDIT CONSTANT Varchar2(30) := 'CASCADE_SERVICE_SCREDIT';
265 G_DFLT_HSCREDIT_FOR_SREP CONSTANT Varchar2(30) := 'DFLT_HSCREDIT_FOR_SREP';
266
267 G_CREATE_SETS CONSTANT Varchar2(30) := 'CREATE_SETS';
268 G_VALIDATE_LINE_SET CONSTANT Varchar2(30) := 'VALIDATE_SET';
269 G_SPLIT_SET_CHK CONSTANT Varchar2(30) := 'SPLIT_SET';
270 G_CREATE_RESERVATIONS CONSTANT Varchar2(30) := 'CREATE_RESERVATIONS';
271 G_INSERT_INTO_SETS CONSTANT Varchar2(30) := 'INSERT_INTO_SETS';
272 G_SCHEDULE_LINE CONSTANT Varchar2(30) := 'SCHEDULE_LINE';
273 G_RESCHEDULE_LINE CONSTANT Varchar2(30) := 'RESCHEDULE_LINE';
274 G_SCHEDULE_SMC CONSTANT Varchar2(30) := 'SCHEDULE_SMC';
275 G_SCHEDULE_ATO CONSTANT Varchar2(30) := 'SCHEDULE_ATO';
276 /* Added the following line to fix the bug 6663462 */
277 G_DELAYED_SCHEDULE CONSTANT Varchar2(30) := 'DELAYED_SCHEDULE';
278
279
280 G_SCHEDULE_NONSMC CONSTANT Varchar2(30) := 'SCHEDULE_NONSMC';
281 G_CASCADE_SHIP_SET_ATTR CONSTANT Varchar2(30) := 'CASCADE_SHIP_SET_ATTR';
282
283 -- Delayed Request/ Actions for ATO/PTO Models
284 G_INS_INCLUDED_ITEMS CONSTANT Varchar2(30) := 'INS_INCLUDED_ITEMS';
285 G_CREATE_CONFIG_ITEM CONSTANT Varchar2(30) := 'CREATE_CONFIG_ITEM';
286 G_CASCADE_CHANGES CONSTANT Varchar2(30) := 'CASCADE_CHANGES ';
287 G_CHANGE_CONFIGURATION CONSTANT Varchar2(30) := 'CHG_CONFIGURATION ';
288 G_CASCADE_QUANTITY CONSTANT Varchar2(30) := 'CASCADE_QUANTITY';
289 G_CASCADE_PROJECT CONSTANT Varchar2(30) := 'G_CASCADE_PROJECT';
290 G_CASCADE_TASK CONSTANT Varchar2(30) := 'G_CASCADE_TASK';
294 G_MATCH_AND_RESERVE CONSTANT Varchar2(30) := 'MATCH_AND_RESERVE';
291 G_COPY_CONFIGURATION CONSTANT Varchar2(30) := 'COPY_CONFIGURATION';
292 G_COMPLETE_CONFIGURATION CONSTANT Varchar2(30) := 'COMPLETE_CONFIGURATION';
293 G_VALIDATE_CONFIGURATION CONSTANT Varchar2(30) := 'VALIDATE_CONFIGURATION';
295 G_DELINK_CONFIG CONSTANT Varchar2(30) := 'DELINK_CONFIG';
296 G_LINK_CONFIG CONSTANT Varchar2(30) := 'LINK_CONFIG';
297 G_DELETE_OPTION CONSTANT Varchar2(30) := 'DELETE_OPTION';
298 G_UPDATE_OPTION CONSTANT Varchar2(30) := 'UPDATE_OPTION';
299 G_CTO_NOTIFICATION CONSTANT Varchar2(30) := 'CTO_NOTIFICATION';
300 G_CTO_CHANGE CONSTANT Varchar2(30) := 'CTO_CHANGE';
301 -- G_SYS_HOLD is used to distinguish if system hold is applied by USER or SYSTEM(TRUE) --8477694
302 G_SYS_HOLD BOOLEAN := FALSE; --8477694
303
304 -- delayed request for scheduleing
305 G_GROUP_SCHEDULE CONSTANT Varchar2(30) := 'GROUP_SCHEDULE';
306 G_GROUP_SET CONSTANT Varchar2(30) := 'GROUP_SET';
307 G_SPLIT_SCHEDULE CONSTANT Varchar2(30) := 'SPLIT_SCHEDULE';
308 -- 40256758 : delayed request to delete set
309 G_DELETE_SET CONSTANT Varchar2(30) := 'DELETE_SET';
310
311 G_FORCE_CLEAR_UI_BLOCK VARCHAR2(1) := 'N';
312
313 -- delayed request for Payment Verification
314 G_VERIFY_PAYMENT CONSTANT VARCHAR2(30) := 'VERIFY_PAYMENT';
315
316 -- delayed request for Updating Shipping from OE
317 G_UPDATE_SHIPPING CONSTANT VARCHAR2(30) := 'UPDATE_SHIPPING';
318
319 -- delayed request for Ship Confirmation
320 G_SHIP_CONFIRMATION CONSTANT VARCHAR2(30) := 'SHIP_CONFIRMATION';
321
322 -- delayed request for Work flow Activity completion
323 G_COMPLETE_ACTIVITY CONSTANT VARCHAR2(30) := 'COMPLETE_ACTIVITY';
324
325 --Bug 10032407
326 G_SKIP_ACTIVITY CONSTANT VARCHAR2(30) := 'SKIP_ACTIVITY';
327
328 --2391781
329 -- delayed request for scheduling attribute changes in sets
330 G_CASCADE_SCH_ATTRBS CONSTANT VARCHAR2(30) := 'CASCADE_SCH_ATTRIBUTES';
331
332 -- Shipment Statuses for a line
333 G_FULLY_SHIPPED CONSTANT VARCHAR2(30) := 'Fully Shipped';
334 G_SHIPPED_WITHIN_TOL_BELOW CONSTANT VARCHAR2(30) := 'Shipped within tolerance below';
335 G_SHIPPED_WITHIN_TOL_ABOVE CONSTANT VARCHAR2(30) := 'Shipped within tolerance above';
336 G_SHIPPED_BEYOND_TOLERANCE CONSTANT VARCHAR2(30) := 'Shipped beyond tolerance';
337 G_PARTIALLY_SHIPPED CONSTANT VARCHAR2(30) := 'Partially Shipped';
338
339 -- delayed request for RMA
340 G_INSERT_RMA CONSTANT VARCHAR2(30) := 'INSERT_RMA';
341 G_CHECK_OVER_RETURN CONSTANT VARCHAR2(30) := 'CHECK_OVER_RETURN';
342
343
344 -- Delayed request for Service
345 G_INSERT_SERVICE CONSTANT VARCHAR2(30) := 'INSERT_SERVICE';
346 /* added for bug #1533658 */
347 G_UPDATE_SERVICE CONSTANT VARCHAR2(30) := 'UPDATE_SERVICE';
348
349 /* lchen added for bug 1761154 */
350 G_CASCADE_OPTIONS_SERVICE CONSTANT VARCHAR2(30) := 'CASCADE_OPTIONS_SERVICE';
351
352
353 -- Delayed Request for Applying or Removing Holds when hold source entities
354 -- (customer/site/item) are entered or updated on the order or line.
355 G_EVAL_HOLD_SOURCE CONSTANT VARCHAR2(30) := 'EVAL_HOLD_SOURCE';
356
357 /* 7576948: IR ISO Change Management project Start */
358 -- delayed requet for updating Internal Requisition in Purchasing.
359 -- This is added for IR ISO Change Management project
360 G_UPDATE_REQUISITION CONSTANT VARCHAR2(30) := 'UPDATE_INTERNAL_REQ';
361 /* IR ISO Change Management project End */
362
363 -- DOO Pre Exploded Kit
364 G_PRE_EXPLODED_KIT CONSTANT VARCHAR2(20) := 'PRE_EXPLODED_KIT';
365
366 -- Action Request to Book the Order
367 G_BOOK_ORDER CONSTANT VARCHAR2(30) := 'BOOK_ORDER';
368
369 -- Action Request to get the Ship Method for Order
370 G_GET_SHIP_METHOD CONSTANT VARCHAR2(30) := 'GET_SHIP_METHOD';
371 G_FTE_INSTALLED VARCHAR2(1) := NULL;
372
373 -- Delayed Request/Action Request for Applying Automatic Attachments
374 G_APPLY_AUTOMATIC_ATCHMT CONSTANT VARCHAR2(30) := 'AUTOMATIC_ATCHMT';
375 -- Delayed Request for Copying Attachments
376 G_COPY_ATCHMT CONSTANT VARCHAR2(30) := 'COPY_ATCHMT';
377
378 --Delayed Request for the automatic internal req creation (ikon) Mshenoy
379 G_CREATE_INTERNAL_REQ CONSTANT VARCHAR2(30) := 'CREATE_INTERNAL_REQ';
380
381 --Delayed Request for XML Generation
382 G_GENERATE_XML_REQ_HDR CONSTANT VARCHAR2(30) := 'GENERATE_XML_REQ_HDR';
383 G_GENERATE_XML_REQ_LN CONSTANT VARCHAR2(30) := 'GENERATE_XML_REQ_LN';
384
385 --Delayed Request for 3A7 Hold
386 G_XML_APPLY_3A7_HOLD_REQ CONSTANT VARCHAR2(30) := 'XML_APPLY_3A7_HOLD';
387
388 -- Added 09-DEC-2002
389 -- DELAYED REQUESTS FOR BLANKETS/RELEASES
390 G_PROCESS_RELEASE CONSTANT VARCHAR2(30) := 'PROCESS_RELEASE';
391 G_VALIDATE_RELEASE_SHIPMENTS CONSTANT VARCHAR2(30) := 'VALIDATE_RELEASE_SHIPMENTS';
392
393 --Delayed Request for Clearing a Blanket Pricelist Line.Bug 3309427
394 G_CLEAR_BLKT_PRICE_LIST_LINE CONSTANT VARCHAR2(30) := 'CLEAR_BLKT_PRICE_LIST_LINE';
395
396 -- delayed request for scheduleing
397 G_CANCEL_WF CONSTANT Varchar2(30) := 'CANCEL_WF';
398
399 -- Attribute groups for processing constraints
400 G_ATTR_GRP_HSCREDIT CONSTANT Varchar2(30) := 'HEADER_SCREDIT';
401 G_ATTR_GRP_LSCREDIT CONSTANT Varchar2(30) := 'LINE_SCREDIT';
402
403 -- Return Category Code
404 G_RETURN_CATEGORY_CODE CONSTANT Varchar2(30) := 'RETURN';
405
406 -- Used when processing children of a return line
407 -- This is for internal returns processing use only
408 G_RETURN_CHILDREN_MODE Varchar2(1) := 'N';
409
410 -- Max number of defaulting tterations.
411 G_MAX_DEF_ITERATIONS CONSTANT NUMBER:= 5;
415 -- G_WFI -- item type
412
413 -- Please follow the naming convention for prefixing any of the
414 -- following Workflow attributes
416 -- G_WFIA -- item attribute
417 -- G_WFA -- activity
418 -- G_WFR -- results
419 -----------------------------------------------------------------
420 -- Workflow Item Types
421
422 G_WFI_HDR CONSTANT VARCHAR2(8) := 'OEOH';
423 G_WFI_LIN CONSTANT VARCHAR2(8) := 'OEOL';
424
425 G_WFI_NGO CONSTANT VARCHAR2(8) := 'OENH';
426 G_WFI_BKT CONSTANT VARCHAR2(8) := 'OEBH';
427
428
429 -- Sales Document Type Code for Quote vs Blanket
430 G_SALES_DOCUMENT_TYPE_CODE VARCHAR2(1) := NULL;
431
432 -- Common Workflow Results
433 G_WFR_COMPLETE CONSTANT VARCHAR2(30) := 'COMPLETE';
434 G_WFR_INCOMPLETE CONSTANT VARCHAR2(30) := 'INCOMPLETE';
435 G_WFR_ON_HOLD CONSTANT VARCHAR2(30) := 'ON_HOLD';
436 G_WFR_NOT_ELIGIBLE CONSTANT VARCHAR2(30) := 'NOT_ELIGIBLE';
437 G_WFR_PRTL_COMPLETE CONSTANT VARCHAR2(30) := 'PRTL_COMPLETE';
438 G_WFR_PRTL_INCOMPLETE CONSTANT VARCHAR2(30) := 'PRTL_INCOMPLETE';
439 G_WFR_PENDING_ACCEPTANCE VARCHAR2(30) := 'PENDING_ACCEPTANCE';
440
441 -- Seeded Workflow Activities
442 G_WFA_PICK_ORDER CONSTANT VARCHAR2(30) := 'PICK_ORDER';
443 G_WFA_PICK_ORDER_LINE CONSTANT VARCHAR2(30) := 'PICK_ORDER_LINE';
444
445 -- Globals used for starting Order and Line flows
446
447 -- This indicates whether a Header flow needs to be started.
448 G_START_HEADER_FLOW NUMBER := NULL;
449
450 -- This indicates whether a Negotiation Header flow needs to be started.
451 G_START_NEGOTIATE_HEADER_FLOW NUMBER := NULL;
452
453 -- This indicates whether a Blanket Header (fulfillment) flow needs to be started.
454 G_START_BLANKET_HEADER_FLOW NUMBER := NULL;
455
456 -- This indicates whether we have started executing the code that starts on the pending
457 -- header and line flows.
458 G_FLOW_PROCESSING_STARTED BOOLEAN := FALSE;
459 --This flag indicates if the flex fields has to be validated .By default it is set to Y
460 --However Public API and Group API can set these values to Y/N based on parameter p_validate_desc_flex
461 --R12 CVV2
462 G_PAYMENT_PROCESSED VARCHAR2(1);
463 --R12 CVV2
464
465 --This flag indicates if the flex fields has to be validated .By default it is set to Y
466 --However Public API and Group API can set these values to Y/N based on parameter p_validate_desc_flex
467 g_validate_desc_flex varchar2(1) :='Y'; -- 4343612
468
469 -- For bug 3000619
470 TYPE Line_ID_List_Rec IS Record
471 ( line_id NUMBER
472 ,post_write_ato_line_id NUMBER);
473
474
475 -- Table type used for storing Line Ids that need their flows to be started
476 -- Bug 3000619, changed line_id_list to be a table of Line_ID_List_Rec
477 TYPE Line_ID_List IS TABLE OF Line_ID_List_Rec INDEX BY BINARY_INTEGER;
478
479 -- Global table used for storing Line Ids that need their flows to be started
480 G_START_LINE_FLOWS_TBL Line_ID_List;
481
482
483
484 -- Cancellation Specific declarations
485 -- Results of Cancelation Operation
486 G_CANCELED CONSTANT VARCHAR2(1) := 'Y';
487 G_CANNOT_CANCEL CONSTANT VARCHAR2(1) := 'N';
488 G_NOTIFIED CONSTANT VARCHAR2(1) := 'A';
489 G_FULL CONSTANT VARCHAR2(1) := 'F';
490 G_PARTIAL CONSTANT VARCHAR2(1) := 'P';
491 G_CANCELATION_HOLD_ID CONSTANT NUMBER := 4;
492 G_CAN_HIST_TYPE_CODE CONSTANT VARCHAR2(30) := 'CANCELLATION';
493
494 -- Commit specific requests that need to executed
495
496 G_GAPLESS_ORDER_NUMBER CONSTANT VARCHAR2(30) := 'GEN_GAPLESS_ORDNUM';
497
498 -- To check if a specific product is installed
499 G_FND_INSTALLED VARCHAR2(1) := NULL;
500 G_IPAYMENT_INSTALLED VARCHAR2(1) := NULL;
501 G_OTA_INSTALLED VARCHAR2(1) := NULL;
502 G_ASO_INSTALLED VARCHAR2(1) := NULL;
503 G_OKS_INSTALLED VARCHAR2(1) := NULL;
504 G_EC_INSTALLED VARCHAR2(1) := NULL;
505 G_CONFIGURATOR_INSTALLED VARCHAR2(1) := NULL;
506 G_RLM_INSTALLED VARCHAR2(1) := NULL;
507 G_GMI_INSTALLED VARCHAR2(1) := NULL; -- OPM 2547940
508
509 -- Global to check whether the header record is created in the same call.
510 G_HEADER_CREATED BOOLEAN := FALSE;
511
512 -- Global flag to determine if this is from html om ui session
513 G_HTML_FLAG BOOLEAN := FALSE;
514
515 -- global to indicate current XML transaction type
516 G_XML_TXN_CODE VARCHAR2(30) := NULL;
517
518 -- Global which would indicate whether defaulting updated any
519 -- attributes or not.
520 -- Callers that need to check this global value should always
521 -- initialize it to 'N' before making a call to any API (e.g. process
522 -- order, clear_dep_and_default) that could result in defaulting.
523 -- If it is set to 'Y'
524 -- after the call, it indicates that at least one attribute was
525 -- updated by defaulting.
526 G_ATTR_UPDATED_BY_DEF VARCHAR2(1) := 'N';
527 G_FREIGHT_RECURSION VARCHAR2(1) := 'N';
528 -- Global Indicates whether pricing is deferred at line level
529 G_DEFER_PRICING VARCHAR2(1) := 'N';
530
531 --Action Requests for Customer Acceptance
532 G_ACCEPT_FULFILLMENT CONSTANT VARCHAR2(30) := 'ACCEPT_FULFILLMENT';
533 G_REJECT_FULFILLMENT CONSTANT VARCHAR2(30) := 'REJECT_FULFILLMENT';
534 G_DFLT_CONTINGENCY_ATTRIBUTES CONSTANT VARCHAR2(30) := 'DEFAULT_CONTINGENCY_ATTRIBUTES';
535 G_UPDATE_GLOBAL_PICTURE VARCHAR2(30) := 'Y';
536 -- sol_ord_er #16014165
537 G_SERVICE_FIRST_PERIOD_BILL CONSTANT VARCHAR2(30) := 'SERVICE_FIRST_PERIOD_BILL';
538 G_ITEM_SUBSCRIPTION CONSTANT VARCHAR2(30) := 'SUBSCRIPTION';
539 G_CONTRACTS_BILLED VARCHAR2(30) := 'BILLED_FROM_CONTRACTS';
543 G_FAIL_ORDER_IMPORT BOOLEAN := FALSE; /* Bug # 4036765 */
540
541 -- To allow order import to fail in cases where partial
542 -- processing should apply only to direct callers of process order
544
545 -- Added for bug 7367433. This indicates if Process Order code is being executed as part of Order Import call or not.
546 G_ORDER_IMPORT_CALL BOOLEAN := FALSE;
547
548 -- Added global for bug 9354229
549 G_CALL_PROCESS_REQ BOOLEAN := TRUE;
550
551 --Added for ER7675548
552 -- Flag to determine what should happen if both ID and Value are sent for inline customer creation
553 G_UPDATE_ON_ID BOOLEAN := FALSE;
554
555 -- Index table type used by JVC controllers.
556 TYPE Index_Tbl_Type IS TABLE OF BINARY_INTEGER
557 INDEX BY BINARY_INTEGER;
558
559 -- API Operation control flags.
560 TYPE Control_Rec_Type IS RECORD
561 ( controlled_operation BOOLEAN := FALSE
562 , Private_Call BOOLEAN := TRUE
563 , check_security BOOLEAN := TRUE
564 , clear_dependents BOOLEAN := TRUE
565 , default_attributes BOOLEAN := TRUE
566 , change_attributes BOOLEAN := TRUE
567 , validate_entity BOOLEAN := TRUE
568 , write_to_db BOOLEAN := TRUE
569 , Process_Partial BOOLEAN := FALSE
570 , process BOOLEAN := TRUE
571 , process_entity VARCHAR2(30) := G_ENTITY_ALL
572 , clear_api_cache BOOLEAN := TRUE
573 , clear_api_requests BOOLEAN := TRUE
574 , request_category VARCHAR2(30):= NULL
575 , request_name VARCHAR2(30):= NULL
576 , org_id NUMBER := FND_API.G_MISS_NUM
577 , require_reason BOOLEAN := NULL
578 );
579
580
581 -- Variable representing missing control record.
582
583 G_MISS_CONTROL_REC Control_Rec_Type;
584
585 /* Request rec and request table definition has been moved to OEXPORDS */
586 -- API request record type.
587 /*
588 TYPE Request_Rec_Type IS RECORD
589 (
590 -- entity VARCHAR2(30) := NULL
591 --, step VARCHAR2(30) := NULL
592 --, name VARCHAR2(30) := NULL
593 --, category VARCHAR2(30) := NULL
594 --, processed BOOLEAN := FALSE
595 --, attribute1 VARCHAR2(240) := NULL
596 --, attribute2 VARCHAR2(240) := NULL
597 --, attribute3 VARCHAR2(240) := NULL
598 --, attribute4 VARCHAR2(240) := NULL
599 --, attribute5 VARCHAR2(240) := NULL
600
601
602 -- merge from admin/sql
603 -- Object for which the delayed request has been logged
604 -- ie LINE, ORDER, PRICE_ADJUSTMENT
605 Entity_code Varchar2(30):= NULL,
606
607 -- Primary key for the object as in entity_code
608 Entity_id Number := NULL,
609
610 -- Function / Procedure indentifier ie 'PRICE_LINE'
611 -- 'RECORD_HISTORY'
612 request_type Varchar2(30) := NULL,
613
614 return_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
615
616 -- Parameters (param - param10) for the delayed request
617 param1 Varchar2(2000) := NULL,
618 param2 Varchar2(240) := NULL,
619 param3 Varchar2(240) := NULL,
620 param4 Varchar2(240) := NULL,
621 param5 Varchar2(240) := NULL,
622 param6 Varchar2(240) := NULL,
623 param7 Varchar2(240) := NULL,
624 param8 Varchar2(240) := NULL,
625 param9 Varchar2(240) := NULL,
626 param10 Varchar2(240) := NULL,
627 long_param1 Varchar2(2000) := NULL,
628 processed BOOLEAN := FALSE
629
630 );
631
632 -- API Request table type.
633
634 TYPE Request_Tbl_Type IS TABLE OF Request_Rec_Type
635 INDEX BY BINARY_INTEGER;
636
637 -- Missing request record type
638 G_MISS_REQUEST_REC Request_Rec_Type;
639 G_MISS_REQUEST_TBL Request_Tbl_Type;
640 */
641
642 /* History type 'R' -> requires reason and history
643 'H' -> requires only history */
644
645 TYPE OE_AUDIT_HISTORY_REC IS RECORD
646 (HEADER_ID NUMBER,
647 LINE_ID NUMBER,
648 HISTORY_TYPE VARCHAR2(1));
649
650 TYPE oe_audit_trail_history_tbl IS TABLE OF oe_audit_history_rec
651 INDEX BY BINARY_INTEGER;
652
653 OE_AUDIT_HISTORY_TBL oe_audit_trail_history_tbl;
654
655 -- Generic table types
656 TYPE Boolean_Tbl_Type IS TABLE OF BOOLEAN
657 INDEX BY BINARY_INTEGER;
658
659 TYPE Number_Tbl_Type IS TABLE OF NUMBER
660 INDEX BY BINARY_INTEGER;
661
662 -- Variable representing a missing table.
663 G_MISS_BOOLEAN_TBL Boolean_Tbl_Type;
664 G_MISS_NUMBER_TBL Number_Tbl_Type;
665
666 TYPE ACCESS_LIST IS TABLE OF VARCHAR2(100)
667 INDEX BY BINARY_INTEGER;
668 G_ACCESS_LIST ACCESS_LIST;
669 -- Get Application ID #1942082
670
671 -- added for Electronic Messaging Exc Mgmt
672 G_EM_ACCESS_LIST ACCESS_LIST;
673 -- end Electronic Messaging Exc Mgmt
674
675 FUNCTION GET_APPLICATION_ID
676 ( p_resp_id IN NUMBER
677 ) RETURN NUMBER;
678
679 -- Initialize control record.
680 FUNCTION Init_Control_Rec
681 ( p_operation IN VARCHAR2
682 , p_control_rec IN Control_Rec_Type
683 )RETURN Control_Rec_Type;
684
685 -- Function Equal
686 -- Number comparison.
687
688 FUNCTION Equal
689 ( p_attribute1 IN NUMBER
690 , p_attribute2 IN NUMBER
691 )RETURN BOOLEAN;
692
693 -- Varchar2 comparison.
694
695 FUNCTION Equal
696 ( p_attribute1 IN VARCHAR2
697 , p_attribute2 IN VARCHAR2
698 )RETURN BOOLEAN;
699
700 -- Date comparison.
701
702 FUNCTION Equal
703 ( p_attribute1 IN DATE
704 , p_attribute2 IN DATE
705 )RETURN BOOLEAN;
706
707
708 PROCEDURE Set_Context;
709
710 FUNCTION CHECK_PRODUCT_INSTALLED
711 ( p_application_id IN NUMBER
712 )RETURN VARCHAR2;
713
714 FUNCTION GET_FORCE_CLEAR_UI_BLOCK RETURN VARCHAR2;
715 PROCEDURE SET_FORCE_CLEAR_UI_BLOCK (ui_block IN VARCHAR2);
716
717 FUNCTION Is_Same_Credit_Card
718 ( p_cc_num_old IN VARCHAR2 DEFAULT NULL
719 , p_cc_num_new IN VARCHAR2 DEFAULT NULL
720 , p_instrument_id_old IN NUMBER DEFAULT NULL
721 , p_instrument_id_new IN NUMBER DEFAULT NULL
722 )RETURN BOOLEAN;
723
724 TYPE Selected_Record_Type IS RECORD
725 (
726 id1 NUMBER
727 ,id2 NUMBER
728 ,id3 NUMBER
729 ,id4 NUMBER
730 ,id5 NUMBER
731 ,org_id NUMBER
732 );
733
734 TYPE Selected_Record_Tbl IS TABLE OF Selected_Record_Type
735 INDEX BY BINARY_INTEGER;
736
737 G_BINARY_LIMIT CONSTANT NUMBER:=2147483648; -- 8617475
738
739 END Oe_Globals;