PACKAGE: APPS.EAM_CONSTANTS

Source

1 PACKAGE EAM_CONSTANTS AUTHID CURRENT_USER AS
2  /* $Header: EAMCONSS.pls 120.0 2005/05/25 15:57:23 appldev noship $ */
3 
4   MAX_NUMBER_PRECISION    CONSTANT NUMBER := 38;
5   MAX_DISPLAYED_PRECISION CONSTANT NUMBER := 6;
6 
7   ------------------
8   -- Lookup Codes --
9   G_SHUTDOWN_TYPE CONSTANT VARCHAR2(30) := 'BOM_EAM_SHUTDOWN_TYPE';
10   G_SUPPLY_TYPE CONSTANT VARCHAR2(30) := 'WIP_SUPPLY';
11   G_OBJ_SOURCE CONSTANT VARCHAR2(30) := 'WIP_MAINTENANCE_OBJECT_SOURCE';
12   G_OBJ_TYPE CONSTANT VARCHAR2(30) := 'WIP_MAINTENANCE_OBJECT_TYPE';
13   G_ACT_SOURCE CONSTANT VARCHAR2(30) := 'MTL_EAM_ACTIVITY_SOURCE';
14   G_ACT_CAUSE CONSTANT VARCHAR2(30) := 'MTL_EAM_ACTIVITY_CAUSE';
15   G_ACT_TYPE CONSTANT VARCHAR2(30) := 'MTL_EAM_ACTIVITY_TYPE';
16   G_WO_TYPE CONSTANT VARCHAR2(30) := 'WIP_EAM_WORK_ORDER_TYPE';
17   G_AUTOCHARGE_TYPE CONSTANT VARCHAR2(30) := 'BOM_AUTOCHARGE_TYPE';
18   G_ACT_PRIORITY CONSTANT VARCHAR2(30) := 'WIP_EAM_ACTIVITY_PRIORITY';
19   G_OBJECT_TYPE CONSTANT VARCHAR2(30) := 'WIP_MAINTENANCE_OBJECT_TYPE';
20 
21   ------------------
22 
23  --EAM_ESTIMATION_STATUS
24   PENDING    CONSTANT NUMBER := 1;
25   RUNNING    CONSTANT NUMBER := 2;
26   ERROR      CONSTANT NUMBER := 3;
27   COMPLETE   CONSTANT NUMBER := 7;
28   REESTIMATE CONSTANT NUMBER := 8;
29   RUNREEST   CONSTANT NUMBER := 9;
30 
31 /*=====================================================================+
32  | PROCEDURE
33  |   GET_ORA_ERROR
34  |
35  | PURPOSE
36  |   Get the values of SQLCODE and SQLERRM and places a message on the
37  |   message stack upon error
38  |
39  | ARGUMENTS
40  |   IN
41  |     application          Name of application; e.g. EAM, INV
42  |     proc_name            Name of procedure or function where error occurred
43  |
44  | EXCEPTIONS
45  |   Sets generic SQL error message and then calls FND_MESSAGE.ERROR to raise
46  |   an exception.
47  |
48  | NOTES
49  |
50  +=====================================================================*/
51   procedure get_ora_error (application VARCHAR2, proc_name VARCHAR2);
52 
53 /*=====================================================================+
54  | PROCEDURE
55  |   INITIALIZE
56  |
57  | PURPOSE
58  |   To instantiate the EAM_CONSTANTS package.
59  |
60  | ARGUMENTS
61  |
62  | EXCEPTIONS
63  |
64  | NOTES
65  |   This procedure simply returns upon being called.  This is to initialize
66  |   all the constants in this package.
67  |
68  +=====================================================================*/
69   procedure initialize;
70 
71   --define the records locked exception
72   RECORDS_LOCKED  EXCEPTION;
73   PRAGMA EXCEPTION_INIT (RECORDS_LOCKED, -0054);
74 
75 END EAM_CONSTANTS;