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