[Home] [Help]
PACKAGE: APPS.WIP_CONSTANTS
Source
1 PACKAGE WIP_CONSTANTS AS
2 /* $Header: wipconss.pls 120.3.12000000.4 2007/10/17 06:53:46 mraman ship $ */
3
4 ----------------------
5 -- Global Variables --
6 ----------------------
7 WIP_MOVE_WORKER VARCHAR2(1) := 'N';
8
9 MAX_NUMBER_PRECISION CONSTANT NUMBER := 38;
10 MAX_DISPLAYED_PRECISION CONSTANT NUMBER := 6;
11 INV_MAX_PRECISION CONSTANT NUMBER := 6;
12 ------------------
13 -- Lookup Codes --
14 ------------------
15
16 -- BASIS_TYPE -- component requirement basis type lookup code /* LBM Project */
17 ITEM_BASED_MTL CONSTANT NUMBER := 1;
18 LOT_BASED_MTL CONSTANT NUMBER := 2;
19
20
21 -- PREFER INHERITANCE
22 PREF_INHERITED CONSTANT NUMBER := 1;
23 PREF_NOT_INHERITED CONSTANT NUMBER := 2;
24
25
26 -- BOM_ACTION
27 DELETE_WKDY CONSTANT NUMBER := 1;
28 MODIFY_WKDY CONSTANT NUMBER := 2;
29 ADD_WKDY CONSTANT NUMBER := 3;
30
31 -- BOM_AUTOCHARGE_TYPE
32 WIP_MOVE CONSTANT NUMBER := 1;
33 MANUAL CONSTANT NUMBER := 2;
34 PO_RECEIPT CONSTANT NUMBER := 3;
35 PO_MOVE CONSTANT NUMBER := 4;
36
37 -- BOM_RESOURCE_SCHEDULE_TYPE
38 SCHED_YES CONSTANT NUMBER := 1;
39 SCHED_NO CONSTANT NUMBER := 2;
40 SCHED_PRIOR CONSTANT NUMBER := 3;
41 SCHED_NEXT CONSTANT NUMBER := 4;
42
43 -- BOM_COUNT_POINT_TYPE
44 YES_AUTO CONSTANT NUMBER := 1;
45 NO_AUTO CONSTANT NUMBER := 2;
46 NO_DIRECT CONSTANT NUMBER := 3;
47
48 -- MCG_COUNT_POINT
49 -- YES_AUTO CONSTANT NUMBER := 1; duplicate constant definition
50 -- NO_AUTO CONSTANT NUMBER := 2; duplicate constant definition
51 NO_MANUAL CONSTANT NUMBER := 3;
52
53 -- BOM RESOURCE TYPE
54 RES_MACHINE CONSTANT NUMBER := 1;
55 RES_PERSON CONSTANT NUMBER := 2;
56 RES_SPACE CONSTANT NUMBER := 3;
57 RES_MISC CONSTANT NUMBER := 4;
58 RES_AMOUNT CONSTANT NUMBER := 5;
59
60 -- BOM ASSEMBLY TYPE
61 MANUFACTURING_BILL CONSTANT NUMBER := 1;
62 ENGINEERING_BILL CONSTANT NUMBER := 2 ;
63
64 -- CST_BASIS
65 PER_ITEM CONSTANT NUMBER := 1;
66 PER_LOT CONSTANT NUMBER := 2;
67 PER_RESUNITS CONSTANT NUMBER := 3;
68 PER_RESVALUE CONSTANT NUMBER := 4;
69 PER_TOTVALUE CONSTANT NUMBER := 5;
70 PER_ACTUNITS CONSTANT NUMBER := 6;
71
72 -- CST_WIP_TRANSACTION_TYPE
73 RES_TXN CONSTANT NUMBER := 1;
74 OVHD_TXN CONSTANT NUMBER := 2;
75 OSP_TXN CONSTANT NUMBER := 3;
76 COST_UPD_TXN CONSTANT NUMBER := 4;
77 PER_CLOSE_TXN CONSTANT NUMBER := 5;
78 JOB_CLOSE_TXN CONSTANT NUMBER := 6;
79
80 -- WIP_MOVE_TRANSACTION_TYPE
81 MOVE_TXN CONSTANT NUMBER := 1; -- Normal move transaction
82 COMP_TXN CONSTANT NUMBER := 2; -- Easy completion transaction
83 RET_TXN CONSTANT NUMBER := 3; -- Easy return transaction
84
85
86 -- MTL_ENG_QUANTITY
87 NO_REV CONSTANT NUMBER := 1;
88 REV CONSTANT NUMBER := 2;
89
90 -- MTL_ITEM_LOCATOR_CONTROL
91 NO_CONTROL CONSTANT NUMBER := 1;
92 PRESPECIFIED CONSTANT NUMBER := 2;
93 DYNAMIC CONSTANT NUMBER := 3;
94
95 -- MTL_LOT_CONTROL
96 NO_LOT CONSTANT NUMBER := 1;
97 LOT CONSTANT NUMBER := 2;
98
99 -- MTL_LOT_GENERATION
100 ORG_LEVEL CONSTANT NUMBER := 1;
101 ITEM_LEVEL CONSTANT NUMBER := 2;
102 USER_DEFINED CONSTANT NUMBER := 3;
103
104 -- MTL_SERIAL_NUMBER
105 NO_SN CONSTANT NUMBER := 1;
106 FULL_SN CONSTANT NUMBER := 2;
107 DYN_RCV_SN CONSTANT NUMBER := 5;
108 DYN_SO_SN CONSTANT NUMBER := 6;
109
110 -- MTL_SERIAL_NUMBER.CURRENT_STATUS
111 DEF_NOT_USED CONSTANT NUMBER := 1;
112 IN_STORES CONSTANT NUMBER := 3;
113 OUT_OF_STORES CONSTANT NUMBER := 4;
114 IN_TRANSIT CONSTANT NUMBER := 5;
115
116 -- SHELF_LIFE_CODE
117 SHELF_LIFE CONSTANT NUMBER := 2;
118 USER_DEFINED_EXP CONSTANT NUMBER := 4;
119
120 -- SYS_YES_NO
121 YES CONSTANT NUMBER := 1;
122 NO CONSTANT NUMBER := 2;
123
124 -- TRANSACTION PROCESS MODES
125 NO_PROCESSING CONSTANT NUMBER := -1;
126 ONLINE CONSTANT NUMBER := 1;
127 IMMED_CONC CONSTANT NUMBER := 2;
128 BACKGROUND CONSTANT NUMBER := 3;
129 FORM_LEVEL CONSTANT NUMBER := 4;
130
131 -- SOURCE CODE
132 SOURCE_CODE CONSTANT VARCHAR2(14) := 'OA Transaction';
133
134 --MTL_TRANSACTIONS_INTERFACE PROCESS FLAG VALUES
135 MTI_INVENTORY CONSTANT NUMBER := 1;
136 MTI_NO CONSTANT NUMBER := 2;
137 MTI_ERROR CONSTANT NUMBER := 3;
138 MTI_WIP CONSTANT NUMBER := 4;
139
140 --MTL_MATERIAL_TRANSACTIONS_TEMP PROCESS FLAG VALUES
141 MMTT_INVENTORY CONSTANT VARCHAR2(1) := 'Y';
142 MMTT_NO CONSTANT VARCHAR2(1) := 'N';
143 MMTT_ERROR CONSTANT VARCHAR2(1) := 'E';
144 MMTT_WIP CONSTANT VARCHAR2(1) := 'W';
145
146 -- WIP_BACKFLUSH_LOT_ENTRY
147 MAN_ENTRY CONSTANT NUMBER := 1; -- Manual selection, verify all
148 RECDATE_FULL CONSTANT NUMBER := 2; -- Receipt date fifo, verify all
149 RECDATE_EXC CONSTANT NUMBER := 3; -- Receipt date fifo, verify exceptions
150 EXPDATE_FULL CONSTANT NUMBER := 4; -- Expiration date fifo, verify all
151 EXPDATE_EXC CONSTANT NUMBER := 5; -- Expiration date fifo, verify exceptions
152 /* Added for Wilson Greatbatch Enhancement */
153 TXNHISTORY_FULL CONSTANT NUMBER := 6 ; --Transaction History lifo , verify all
154 TXNHISTORY_EXC CONSTANT NUMBER := 7 ;-- Transaction History lifo, verify exceptions
155
156 -- WIP_CLASS_TYPE
157 DISC_CLASS CONSTANT NUMBER := 1;
158 REP_CLASS CONSTANT NUMBER := 2;
159 NS_ASSET_CLASS CONSTANT NUMBER := 3;
160 NS_EXPENSE_CLASS CONSTANT NUMBER := 4;
161 LOT_CLASS CONSTANT NUMBER := 5;
162 EAM_CLASS CONSTANT NUMBER := 6;
163 NS_LOT_EXPENSE_CLASS CONSTANT NUMBER := 7;
164
165 -- WIP_CHARGE
166 DISC_CHARGING CONSTANT NUMBER := 1; -- discrete charging only
167 FLOW_CHARGING CONSTANT NUMBER := 3; -- assembly flow charging
168
169 -- WIP_COST_DISTRIBUTION
170 ELEM_COST CONSTANT NUMBER := 3; -- Elemental value
171
172 -- WIP_DISCRETE_JOB
173 STANDARD CONSTANT NUMBER := 1;
174 NONSTANDARD CONSTANT NUMBER := 3;
175
176 -- WIP_ENTITY_TYPE
177 DISCRETE CONSTANT NUMBER := 1;
178 REPETITIVE CONSTANT NUMBER := 2;
179 CLOSED_DISC CONSTANT NUMBER := 3;
180 FLOW CONSTANT NUMBER := 4;
181 LOTBASED CONSTANT NUMBER := 5;
182 EAM CONSTANT NUMBER := 6;
183 CLOSED_EAM CONSTANT NUMBER := 7;
184 CLOSED_OSFM CONSTANT NUMBER := 8;
185
186 -- WIP_INTRAOPERATION_STEP
187 QUEUE CONSTANT NUMBER := 1;
188 RUN CONSTANT NUMBER := 2;
189 TOMOVE CONSTANT NUMBER := 3;
190 REJECT CONSTANT NUMBER := 4;
191 SCRAP CONSTANT NUMBER := 5;
192
193 -- WIP_JOB_STATUS
194 UNRELEASED CONSTANT NUMBER := 1; -- Unreleased - no charges allowed
195 SIMULATED CONSTANT NUMBER := 2; -- Simulated
196 RELEASED CONSTANT NUMBER := 3; -- Released - charges allowed
197 COMP_CHRG CONSTANT NUMBER := 4; -- Complete - charges allowed
198 COMP_NOCHRG CONSTANT NUMBER := 5; -- Complete - no charges allowed
199 HOLD CONSTANT NUMBER := 6; -- Hold - no charges allowed
200 CANCELLED CONSTANT NUMBER := 7; -- Cancelled - no charges allowed
201 PEND_BOM CONSTANT NUMBER := 8; -- Pending bill of material load
202 FAIL_BOM CONSTANT NUMBER := 9; -- Failed bill of material load
203 PEND_ROUT CONSTANT NUMBER := 10; -- Pending routing load
204 FAIL_ROUT CONSTANT NUMBER := 11; -- Failed routing load
205 CLOSED CONSTANT NUMBER := 12; -- Closed - no charges allowed
206 PEND_REPML CONSTANT NUMBER := 13; -- Pending - repetitively mass loaded
207 PEND_CLOSE CONSTANT NUMBER := 14; -- Pending Close
208 FAIL_CLOSE CONSTANT NUMBER := 15; -- Failed Close
209 PEND_SCHED CONSTANT NUMBER := 16; -- Pending Scheduling /* FS */
210 DRAFT CONSTANT NUMBER := 17; -- Draft
211
212 -- WIP_LIE_SCHED_TYPE
213 RATEBASE CONSTANT NUMBER := 1; -- Rate-based scheduling
214 ROUTBASE CONSTANT NUMBER := 2; -- Routing-based scheduling
215
216 -- WIP_LOAD_TYPE
217 CREATE_JOB CONSTANT NUMBER := 1; -- Create a standard discrete job
218 CREATE_SCHED CONSTANT NUMBER := 2; -- Create a repetitive schedule
219 RESCHED_JOB CONSTANT NUMBER := 3; -- Reschedule a discrete job
220 CREATE_NS_JOB CONSTANT NUMBER := 4; -- Create a non-standard discrete job
221 CREATE_LOT_JOB CONSTANT NUMBER := 5; -- Create Lot based job
222 RESCHED_LOT_JOB CONSTANT NUMBER := 6; -- Reschedule a lot based job
223 CREATE_EAM_JOB CONSTANT NUMBER := 7; -- Create an EAM job
224 RESCHED_EAM_JOB CONSTANT NUMBER := 8; -- Reschedule an EAM job
225
226 MI_NUM_LOAD_TYPES CONSTANT NUMBER := 8; -- The number of load types
227
228 -- WIP_LOT_DEFAULT
229 DEFAULT_JOB CONSTANT NUMBER := 1;
230 DEFAULT_INV CONSTANT NUMBER := 2;
231 NO_DEFAULT CONSTANT NUMBER := 3;
232
233 -- WIP_ML_PROCESS_PHASE
234 ML_VALIDATION CONSTANT NUMBER := 2;
235 ML_EXPLOSION CONSTANT NUMBER := 3;
236 ML_INSERTION CONSTANT NUMBER := 5;
237 ML_COMPLETE CONSTANT NUMBER := 4;
238
239 -- WIP_ML_VALIDATION_LEVEL
240 FULL CONSTANT NUMBER := 0;
241 MRP CONSTANT NUMBER := 1;
242 ATO CONSTANT NUMBER := 2;
243 INV CONSTANT NUMBER := 3;
244 SERVICE CONSTANT NUMBER := 4;
245
246 -- WIP_MOVE_PROCESS_PHASE
247 MOVE_VAL CONSTANT NUMBER := 1;
248 MOVE_PROC CONSTANT NUMBER := 2;
249 BF_SETUP CONSTANT NUMBER := 3;
250
251 -- WIP_MRP_CONTROL
252 SUPPLY_NET CONSTANT NUMBER := 1;
253 DEMAND_NET CONSTANT NUMBER := 2;
254 NO_NET CONSTANT NUMBER := 3;
255
256 -- WIP_PO_CREATION_TIME
257 AT_JOB_SCHEDULE_RELEASE CONSTANT NUMBER := 1;
258 AT_OPERATION CONSTANT NUMBER := 2;
259 MANUAL_CREATION CONSTANT NUMBER := 3;
260
261 -- WIP_PROCESS_STATUS
262 PENDING CONSTANT NUMBER := 1;
263 RUNNING CONSTANT NUMBER := 2;
264 ERROR CONSTANT NUMBER := 3;
265 COMPLETED CONSTANT NUMBER := 4;
266 WARNING CONSTANT NUMBER := 5;
267
268 -- WIP_RESCHEDULE
269 ENDPOINT CONSTANT NUMBER := 1; -- Endpoint rescheduling
270 MIDPOINT CONSTANT NUMBER := 2; -- Midpoint rescheduling
271
272 -- WIP_RESOURCE_PROCESS_PHASE
273 RES_VAL CONSTANT NUMBER := 1;
274 RES_PROC CONSTANT NUMBER := 2;
275
276 -- WIP_SCHED_DIRECTION
277 FORWARDS CONSTANT NUMBER := 1;
278 BACKWARDS CONSTANT NUMBER := 4;
279 NONE CONSTANT NUMBER := 5;
280 -- MIDPOINT CONSTANT NUMBER := 2; --this is defined above
281 MIDPOINT_FORWARDS CONSTANT NUMBER := 7;
282 MIDPOINT_BACKWARDS CONSTANT NUMBER := 8;
283 CURRENT_OP CONSTANT NUMBER := 9;
284 CURRENT_OP_RES CONSTANT NUMBER := 10;
285 CURRENT_SUB_GRP CONSTANT NUMBER := 11;
286 -- WIP_SCHEDULE_DIRECTION
287 FUSD CONSTANT NUMBER := 1;
288 FUCD CONSTANT NUMBER := 2;
289 LUSD CONSTANT NUMBER := 3;
290 LUCD CONSTANT NUMBER := 4;
291
292 -- WIP_SCHEDULING_LEVEL
293 OPLEVEL CONSTANT NUMBER := 1;
294 RESLEVEL CONSTANT NUMBER := 2;
295
296 -- WIP_SCHEDULE_METHOD
297 ROUTING CONSTANT NUMBER := 1;
298 LEADTIME CONSTANT NUMBER := 2;
299 ML_MANUAL CONSTANT NUMBER := 3;
300
301 -- WIP_SO_CHANGE_TYPE
302 NEVER CONSTANT NUMBER := 1;
303 ALWAYS CONSTANT NUMBER := 2;
304 ONETOONE CONSTANT NUMBER := 3;
305
306 -- WIP_SUPPLY
307 PUSH CONSTANT NUMBER := 1; -- Material pushed
308 ASSY_PULL CONSTANT NUMBER := 2; -- Assembly completion pull
309 OP_PULL CONSTANT NUMBER := 3; -- Operation pull
310 BULK CONSTANT NUMBER := 4;
311 VENDOR CONSTANT NUMBER := 5;
312 PHANTOM CONSTANT NUMBER := 6; -- Component is a phantom bill
313 BASED_ON_BOM CONSTANT NUMBER := 7; -- Supply based on bill of material
314
315 -- REPETITIVE ROLL FORWARD TYPES
316 ROLL_EC_IMP CONSTANT NUMBER := 1;
317 ROLL_COMPLETE CONSTANT NUMBER := 2;
318 ROLL_CANCEL CONSTANT NUMBER := 3;
319
320 -- COST METHODS
321 COST_STD CONSTANT NUMBER := 1;
322 COST_AVG CONSTANT NUMBER := 2;
323 COST_FIFO CONSTANT NUMBER := 5;
324 COST_LIFO CONSTANT NUMBER := 6;
325
326 -- COST SOURCES
327 COST_SRC_SYS CONSTANT NUMBER := 1; -- System Calculated
328 COST_SRC_USR CONSTANT NUMBER := 2; -- User Defined
329
330 -- Backflush constants
331 WBF_NOBF CONSTANT NUMBER := 0; -- No components to backflush
332 WBF_BF_NOPAGE CONSTANT NUMBER := 1; -- Some backflush components; no BF page
333 WBF_BF_PAGE CONSTANT NUMBER := 2; -- Some backflush components; BF page
334
335 -- Completion constants
336 WASSY_COMPLETION CONSTANT NUMBER := 1;
337 WASSY_RETURN CONSTANT NUMBER := 2;
338
339 -----------------------
340 -- Constants
341 -----------------------
342
343 EXPLODED_PHANT CONSTANT NUMBER := -99; -- As an op_seq indicates that
344 -- the phantom is exploded
345 -- use only with phantoms
346 UNKNOWN_USER CONSTANT NUMBER := -1; -- value for WHO column if user
347 -- is not known
348
349 -- Constant for Warning Status
353 --Constants for Relationship Type
350 WARN CONSTANT VARCHAR2(1) := 'W';/* For Bug 5860709 : Constant for Warning Status*/
351
352 --Constants for WIP WO Scheduling Relationships
354 G_REL_TYPE_CONSTRAINED CONSTANT NUMBER := 1;
355 G_REL_TYPE_DEPENDENT CONSTANT NUMBER := 2;
356
357 --Constants for Object Type
358 G_Obj_TYPE_WO CONSTANT NUMBER := 1;
359
360 --Constants for Relationship Status
361 G_REL_Status_Pending CONSTANT NUMBER := 0;
362 G_REL_Status_Processing CONSTANT NUMBER := 1;
363 G_REL_Status_Valid CONSTANT NUMBER := 2;
364 G_REL_Status_Invalid CONSTANT NUMBER := 3;
365
366
367 -- Material Transaction Actions
368 ISSCOMP_ACTION CONSTANT NUMBER := 1; -- Components taken out of INV
369 SUBTRFR_ACTION CONSTANT NUMBER := 2; -- Subinventory Transfer
370 COSTUPD_ACTION CONSTANT NUMBER := 24; -- Cost update
371 RETCOMP_ACTION CONSTANT NUMBER := 27; -- Components put into INV
372 SCRASSY_ACTION CONSTANT NUMBER := 30; -- Assembly scrap
373 CPLASSY_ACTION CONSTANT NUMBER := 31; -- Assemblies put into INV
374 RETASSY_ACTION CONSTANT NUMBER := 32; -- Assemblies taken out of INV
375 ISSNEGC_ACTION CONSTANT NUMBER := 33; -- Negative component issue
376 RETNEGC_ACTION CONSTANT NUMBER := 34; -- Negative component return
377
378 -- Material Transaction Types
379 ISSCOMP_TYPE CONSTANT NUMBER := 35; -- Components taken out of INV
380 BFLREPL_TYPE CONSTANT NUMBER := 51; -- Backflush replenishment
381 COSTUPD_TYPE CONSTANT NUMBER := 25; -- Cost update
382 RETCOMP_TYPE CONSTANT NUMBER := 43; -- Components put into INV
383 SCRASSY_TYPE CONSTANT NUMBER := 90; -- Assembly scrap
384 RETSCRA_TYPE CONSTANT NUMBER := 91; -- Return from scrap
385 CPLASSY_TYPE CONSTANT NUMBER := 44; -- Assemblies put into INV
386 RETASSY_TYPE CONSTANT NUMBER := 17; -- Assemblies taken out of INV
387 ISSNEGC_TYPE CONSTANT NUMBER := 38; -- Negative component issue
388 RETNEGC_TYPE CONSTANT NUMBER := 48; -- Negative component return
389
390 -- Overcompletion Tolerance Types
391 PERCENT CONSTANT NUMBER := 1; -- Tolerance expressed as a percent
392 AMOUNT CONSTANT NUMBER := 2; -- Tolerance expressed as a number
393 INFINITY CONSTANT NUMBER := -1; -- Tolerance value = -1
394
395 -- Overcompletion Transaction Types
396 normal_txn CONSTANT NUMBER := 1;
397 child_txn CONSTANT NUMBER := 2;
398 parent_txn CONSTANT NUMBER := 3;
399
400
401 -- Finite Scheduling
402 USE_FINITE_SCHEDULER CONSTANT NUMBER := 1;
403 USE_MATERIAL_CONSTRAINTS CONSTANT NUMBER := 1;
404 WPS_BACKWARD_SCHEDULE CONSTANT NUMBER := 1;
405 WPS_FORWARD_SCHEDULE CONSTANT NUMBER := 2;
406 WPS_MIDPOINT_SCHEDULE CONSTANT NUMBER := 3;
407
408 -- Eam Item Types
409 ASSET_GROUP_TYPE CONSTANT NUMBER := 1;
410 ASSET_ACTIVITY_TYPE CONSTANT NUMBER := 2;
411 REBUILD_ITEM_TYPE CONSTANT NUMBER := 3;
412
413 -- Bom Item Types
414 MODEL_TYPE CONSTANT NUMBER := 1;
415 OPTION_CLASS_TYPE CONSTANT NUMBER := 2;
416 PLANNING_TYPE CONSTANT NUMBER := 3;
417 STANDARD_TYPE CONSTANT NUMBER := 4;
418 PLANNING_FAMILY_TYPE CONSTANT NUMBER := 5;
419
420 -- Priority
421 DEFAULT_PRIORITY CONSTANT NUMBER := 10;
422
423 --MSI Revision Control Code
424 REVISION_CONTROLLED CONSTANT NUMBER := 2;
425
426 --MSI Pegging Constants
427 PEG_SOFT CONSTANT VARCHAR2(1) := 'A';
428 PEG_END_ASSM_SOFT CONSTANT VARCHAR2(1) := 'B';
429 PEG_HARD CONSTANT VARCHAR2(1) := 'I';
430 PEG_END_ASSM_HARD CONSTANT VARCHAR2(1) := 'X';
431 PEG_END_ASSM CONSTANT VARCHAR2(1) := 'Y';
432 PEG_NONE CONSTANT VARCHAR2(1) := 'N';
433
434 --Loggging constants. They are associated with the
435 --'FND: Debug Log Level' profile
436 NO_LOGGING CONSTANT NUMBER := fnd_log.level_unexpected + 1;
437 TRACE_LOGGING CONSTANT NUMBER := fnd_log.level_procedure;
438 FULL_LOGGING CONSTANT NUMBER := fnd_log.level_statement;
439
440 --transaction_batch_seq values
441 ASSY_BATCH_SEQ CONSTANT NUMBER := 1;
442 COMPONENT_BATCH_SEQ CONSTANT NUMBER := 2;
443
444 --table names
445 MTI_TBL CONSTANT VARCHAR2(3) := 'MTI';
446 MMTT_TBL CONSTANT VARCHAR2(4) := 'MMTT';
447
448 --patchset level
449 DMF_PATCHSET_LEVEL CONSTANT NUMBER := 115.10;
450 DMF_PATCHSET_I_VALUE CONSTANT NUMBER := 115.09;
451 DMF_PATCHSET_J_VALUE CONSTANT NUMBER := 115.10;
452
453 -- Date Formats
454 -- Note: We need these hard-coded. They are not to be used to support
455 -- flexible
456 -- date formats. They are needed to support the fact that Forms 4.5
457 -- automatically uses DD-MON-YYYY when doing name_in and copy.
458 -- Use routines in the WIP_DATETIMES package for flexible date formats
459 -- DATETIME_FMT CONSTANT VARCHAR2(22) := 'DD-MON-YYYY HH24:MI:SS';
460 -- DATE_FMT CONSTANT VARCHAR2(11) := 'DD-MON-YYYY';
461 -- DATETRUNC_FMT CONSTANT VARCHAR2(9) := 'DD-MON-YY';
462 -- TIME_FMT CONSTANT VARCHAR2(7) := 'HH24:MI';
463 -- TIMESEC_FMT CONSTANT VARCHAR2(10) := 'HH24:MI:SS';
464 -- C_DATETIME_FMT CONSTANT VARCHAR2(17) := 'DD-MON-RR HH24:MI';
465 -- C_DATE_FMT CONSTANT VARCHAR2(9) := 'DD-MON-RR';
466 DATETIME_FMT CONSTANT VARCHAR2(22) := 'YYYY/MM/DD HH24:MI:SS';
467 DATE_FMT CONSTANT VARCHAR2(11) := 'YYYY/MM/DD';
471
468 TIME_FMT CONSTANT VARCHAR2(7) := 'HH24:MI';
469 TIMESEC_FMT CONSTANT VARCHAR2(10) := 'HH24:MI:SS';
470 DT_NOSEC_FMT CONSTANT VARCHAR2(22) := 'YYYY/MM/DD HH24:MI';
472 -----------------------
473 -- Column Lengths
474 -----------------------
475 TABLE_NAME_LEN CONSTANT NUMBER := 31; -- Table name
476 COLUMN_NAME_LEN CONSTANT NUMBER := 31; -- Column name
477 DATE_LEN CONSTANT NUMBER := 10; -- Date
478 DATETIME_LEN CONSTANT NUMBER := 19; -- Date and time
479 TIME_LEN CONSTANT NUMBER := 8; -- Time (24-hour clock)
480 DEPT_LEN CONSTANT NUMBER := 11; -- Department
481 REV_LEN CONSTANT NUMBER := 4; -- Revision
482 LOT_LEN CONSTANT NUMBER := 31; -- Lot number
483 SN_LEN CONSTANT NUMBER := 31; -- Serial number
484 PREFIX_LEN CONSTANT NUMBER := 31; -- Lot/SN alpha prefix
485 DESC_LEN CONSTANT NUMBER := 241; -- Descriptive Text
486 SDESC_LEN CONSTANT NUMBER := 51; -- Shorter Description
487 CLASS_LEN CONSTANT NUMBER := 11; -- Class Code
488 DESIG_LEN CONSTANT NUMBER := 11; -- Bom or Routing Designator
489 SUBINV_LEN CONSTANT NUMBER := 11; -- Subinventory
490 ATT_CAT_LEN CONSTANT NUMBER := 31; -- Attribute Category
491 ATT_LEN CONSTANT NUMBER := 151; -- Attribute
492 FLAG_LEN CONSTANT NUMBER := 2; -- Flag
493 SEGMENT_LEN CONSTANT NUMBER := 16; -- Segment
494 COMMENT_LEN CONSTANT NUMBER := 11; -- Job Comment Code
495 OP_LEN CONSTANT NUMBER := 5; -- Operation Code
496 RES_LEN CONSTANT NUMBER := 11; -- Resource Code
497 LINE_LEN CONSTANT NUMBER := 11; -- Line Code
498 UOM_LEN CONSTANT NUMBER := 4; -- Unit Of Measure Code
499 UOMCLASS_LEN CONSTANT NUMBER := 11; -- Unit Of Measure Class
500 OVH_LEN CONSTANT NUMBER := 11; -- Overhead Code
501 SF_STATUS_LEN CONSTANT NUMBER := 11; -- Shop Floor Status Code
502 ACT_LEN CONSTANT NUMBER := 11; -- Activity name
503 REASON_LEN CONSTANT NUMBER := 31; -- Reason name
504 SRC_LEN CONSTANT NUMBER := 31; -- Source code
505 ORG_LEN CONSTANT NUMBER := 4; -- Organization code
506 CAL_LEN CONSTANT NUMBER := 11; -- Calendar codes
507 CONCSEG_LEN CONSTANT NUMBER := 241; -- Concatenated segments
508 JOB_LEN CONSTANT NUMBER := 241; -- Job name length
509 FLAG_LEN CONSTANT NUMBER := 2; -- Flags
510 PROFILE_LEN CONSTANT NUMBER := 241; -- Profile
511 ROWID_LEN CONSTANT NUMBER := 31; -- Rowid
512 SOURCE_CODE_LEN CONSTANT NUMBER := 31; -- Source code
513 ALT_LEN CONSTANT NUMBER := 11; -- Alternate designator
514 ERR_CODE_LEN CONSTANT NUMBER := 241; -- Error code length
515 ERR_LEN CONSTANT NUMBER := 241; -- Error length
516 ORDLINE_LEN CONSTANT NUMBER := 31; -- Sales Order Line
517 ORDDEL_LEN CONSTANT NUMBER := 31; -- Sales Order Delivery
518
519 /*=====================================================================+
520 | PROCEDURE
521 | GET_ORA_ERROR
522 |
523 | PURPOSE
524 | Get the values of SQLCODE and SQLERRM and places a message on the
525 | message stack upon error
526 |
527 | ARGUMENTS
528 | IN
529 | application Name of application; e.g. WIP, INV
530 | proc_name Name of procedure or function where error occurred
531 |
532 | EXCEPTIONS
533 | Sets generic SQL error message and then calls FND_MESSAGE.ERROR to raise
534 | an exception.
535 |
536 | NOTES
537 |
538 +=====================================================================*/
539 procedure get_ora_error (application VARCHAR2, proc_name VARCHAR2);
540
541 /*=====================================================================+
542 | PROCEDURE
543 | INITIALIZE
544 |
545 | PURPOSE
546 | To instantiate the WIP_CONSTANTS package.
547 |
548 | ARGUMENTS
549 |
550 | EXCEPTIONS
551 |
552 | NOTES
553 | This procedure simply returns upon being called. This is to initialize
554 | all the constants in this package.
555 |
556 +=====================================================================*/
557 procedure initialize;
558
559 --define the records locked exception
560 RECORDS_LOCKED EXCEPTION;
561 PRAGMA EXCEPTION_INIT (RECORDS_LOCKED, -0054);
562
563 END WIP_CONSTANTS;