[Home] [Help]
PACKAGE: APPS.GMO_CONSTANTS_GRP
Source
1 PACKAGE GMO_CONSTANTS_GRP AS
2 /* $Header: GMOGCONS.pls 120.6 2006/03/09 22:21 rahugupt noship $ */
3
4 -- Global Constants
5 ENTITY_BATCH CONSTANT VARCHAR2(20) := 'BATCH';
6 ENTITY_OPERATION CONSTANT VARCHAR2(20) := 'OPERATION';
7 ENTITY_ACTIVITY CONSTANT VARCHAR2(20) := 'ACTIVITY';
8 ENTITY_RESOURCE CONSTANT VARCHAR2(20) := 'RESOURCE';
9 ENTITY_MATERIAL CONSTANT VARCHAR2(20) := 'MATERIAL';
10
11 READ_ONLY_YES CONSTANT VARCHAR2(3) := 'YES';
12 READ_ONLY_NO CONSTANT VARCHAR2(2) := 'NO';
13
14 YES CONSTANT VARCHAR2(1) := 'Y';
15 NO CONSTANT VARCHAR2(1) := 'N';
16
17 DISABLE_TASK_YES CONSTANT VARCHAR2(1) := 'Y';
18 DISABLE_TASK_NO CONSTANT VARCHAR2(1) := 'N';
19
20 RETURN_STATUS_SUCCESS CONSTANT VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
21 RETURN_STATUS_ERROR CONSTANT VARCHAR2(20) := FND_API.G_RET_STS_ERROR;
22 RETURN_STATUS_UNEXP_ERROR CONSTANT VARCHAR2(20) := FND_API.G_RET_STS_UNEXP_ERROR;
23
24
25 PARAMETER_FROM_MODULE CONSTANT VARCHAR2(20) := 'FROM_MODULE';
26 PARAMETER_ENTITY_NAME CONSTANT VARCHAR2(20) := 'ENTITY_NAME';
27 PARAMETER_ENTITY_KEY CONSTANT VARCHAR2(20) := 'ENTITY_KEY';
28 PARAMETER_TASK CONSTANT VARCHAR2(20) := 'TASK';
29 PARAMETER_TASK_ATTRIBUTE CONSTANT VARCHAR2(20) := 'TASK_ATTRIBUTE';
30 PARAMETER_INSTRUCTION_ID CONSTANT VARCHAR2(20) := 'INSTRUCTION_ID';
31
32 TASK_RELEASE_STEP CONSTANT VARCHAR2(20) := 'RELEASE_STEP';
33 TASK_CLOSE_STEP CONSTANT VARCHAR2(20) := 'CLOSE_STEP';
34 TASK_ACTIVITY CONSTANT VARCHAR2(20) := 'ACTIVITY';
35 TASK_RESOURCE CONSTANT VARCHAR2(20) := 'RESOURCE';
36 TASK_PROCESS_PARAMETER CONSTANT VARCHAR2(20) := 'PROCESS_PARAMETER';
37 TASK_RESOURCE_TRANSACTION CONSTANT VARCHAR2(20) := 'RESOURCE_TRANSACTION';
38 TASK_MATERIAL CONSTANT VARCHAR2(20) := 'MATERIAL';
39 TASK_QUALITY CONSTANT VARCHAR2(20) := 'QUALITY';
40 TASK_MATERIAL_TRANSACTIONS CONSTANT VARCHAR2(50) := 'MATERIAL_TRANSACTIONS';
41
42 ACTION_UNRELEASE CONSTANT VARCHAR2(20) := 'UNRELEASE';
43 ACTION_TERMINATE CONSTANT VARCHAR2(20) := 'TERMINATE';
44 ACTION_DELETE_OPERATION CONSTANT VARCHAR2(20) := 'DELETE_OPERATION';
45 ACTION_DELETE_ACTIVITY CONSTANT VARCHAR2(20) := 'DELETE_ACTIVITY';
46 ACTION_DELETE_RESOURCE CONSTANT VARCHAR2(20) := 'DELETE_RESOURCE';
47 ACTION_DELETE_MATERIAL CONSTANT VARCHAR2(20) := 'DELETE_MATERIAL';
48
49 FROM_MODULE_PI CONSTANT VARCHAR2(20) := 'PI';
50 FROM_MODULE_VBATCH CONSTANT VARCHAR2(20) := 'VBATCH';
51
52 ENTITY_KEY_SEPARATOR CONSTANT VARCHAR2(1) := '$';
53
54 VBATCH_INSTRUCTION_TYPE CONSTANT VARCHAR2(20) := 'PROCESS';
55
56 STEP_WIP_STATUS CONSTANT NUMBER := 2;
57
58 VBATCH_ADMIN_MODE CONSTANT VARCHAR2(1) := 'A';
59 VBATCH_NORMAL_MODE CONSTANT VARCHAR2(1) := 'N';
60
61 VBATCH_MODE_PARAMETER CONSTANT VARCHAR2(20) := 'VBATCH_MODE';
62
63 -- Process Instruction Framework related constants
64
65 G_ENTITY_SEND CONSTANT VARCHAR2(40) := 'ENTITY_SENT';
66 G_ENTITY_SENT_SINGLE CONSTANT VARCHAR2(40) := 'SINGLE';
67 G_ENTITY_SENT_MULTIPLE CONSTANT VARCHAR2(40) := 'MULTIPLE';
68
69 G_DEFINITION_STATUS CONSTANT VARCHAR2(40) := 'DEFINITION_STATUS';
70 G_INSTANCE_STATUS CONSTANT VARCHAR2(40) := 'INSTANCE_STATUS';
71 G_STATUS_NO_CHANGE CONSTANT VARCHAR2(40) := 'NO_CHANGE';
72 G_STATUS_MODIFIED CONSTANT VARCHAR2(40) := 'MODIFIED';
73
74 G_INSTR_DEFN_MODE CONSTANT VARCHAR2(40) := 'MODE';
75 G_INSTR_DEFN_MODE_READ CONSTANT VARCHAR2(40) := 'READ';
76 G_INSTR_DEFN_MODE_UPDATE CONSTANT VARCHAR2(40) := 'UPDATE';
77
78 G_INSTR_SET_ACKN_STATUS CONSTANT VARCHAR2(40) := 'ACKNOWLEDGED';
79 G_INSTR_SET_UNACKN_STATUS CONSTANT VARCHAR2(40) := 'UNACKNOWLEDGED';
80
81 G_INSTR_TASK_UNACKN_STATUS CONSTANT VARCHAR2(40) := 'UNACKNOWLEDGED';
82 G_INSTR_TASK_ACKN_STATUS CONSTANT VARCHAR2(40) := 'ACKNOWLEDGED';
83
84 G_ORIG_SOURCE_DEFN CONSTANT VARCHAR2(40) := 'DEFINITION';
85 G_ORIG_SOURCE_INSTANCE CONSTANT VARCHAR2(40) := 'INSTANCE';
86
87 G_INSTR_STATUS_PENDING CONSTANT VARCHAR2(40) := 'PENDING';
88 G_INSTR_STATUS_DONE CONSTANT VARCHAR2(40) := 'DONE';
89 G_INSTR_STATUS_COMPLETE CONSTANT VARCHAR2(40) := 'COMPLETE';
90 G_INSTR_STATUS_CANCEL CONSTANT VARCHAR2(40) := 'CANCEL';
91 G_INSTR_OPERATOR_ACKN_YES CONSTANT VARCHAR2(1) := 'Y';
92 G_INSTR_OPERATOR_ACKN_NO CONSTANT VARCHAR2(1) := 'N';
93
94 G_PARAM_INTERNAL CONSTANT VARCHAR2(40) := 'INTERNAL';
95 G_PARAM_ACONTEXT CONSTANT VARCHAR2(40) := 'ACONTEXT';
96 G_PARAM_CONTEXT CONSTANT VARCHAR2(40) := 'CONTEXT';
97 G_PARAM_CONTEXT_NAME CONSTANT VARCHAR2(40) := 'CONTEXT_PARAMETER';
98 G_PARAM_PAGE CONSTANT VARCHAR2(40) := 'PAGE';
99 G_PARAM_TASK CONSTANT VARCHAR2(40) := 'TASK';
100 G_PARAM_ENTITY CONSTANT VARCHAR2(40) := 'ENTITY';
101
102 G_RENDER_TRUE CONSTANT VARCHAR2(40) := 'RENDER_TRUE';
103 G_RENDER_FALSE CONSTANT VARCHAR2(40) := 'RENDER_FALSE';
104
105 G_INSTR_INSTANCE_MODE CONSTANT VARCHAR2(40) := 'MODE';
106 G_INSTR_INSTANCE_MODE_READ CONSTANT VARCHAR2(40) := 'READ';
107 G_INSTR_INSTANCE_MODE_UPDATE CONSTANT VARCHAR2(40) := 'UPDATE';
108 G_INSTR_INSTANCE_MODE_INSERT CONSTANT VARCHAR2(40) := 'INSERT';
109
110 G_INSTR_MANDATORY CONSTANT VARCHAR2(40) := 'MANDATORY';
111 G_INSTR_PROCEED_ALLOWED CONSTANT VARCHAR2(40) := 'PROCEED_ALLOWED';
112 G_INSTR_OPTIONAL CONSTANT VARCHAR2(40) := 'OPTIONAL';
113
114 G_INSTR_DEFN_B_ENTITY CONSTANT VARCHAR2(40) := 'GMO_INSTR_DEFN_B';
115 G_INSTR_DEFN_T_ENTITY CONSTANT VARCHAR2(40) := 'GMO_INSTR_DEFN_T';
116
117 G_INSTR_SET_DEFN_B_ENTITY CONSTANT VARCHAR2(40) := 'GMO_INSTR_SET_DEFN_B';
118 G_INSTR_SET_DEFN_T_ENTITY CONSTANT VARCHAR2(40) := 'GMO_INSTR_SET_DEFN_T';
119
120 G_INSTR_SET_INSTANCE_B_ENTITY CONSTANT VARCHAR2(40) := 'GMO_INSTR_SET_INSTANCE_B';
121 G_INSTR_INSTANCE_B_ENTITY CONSTANT VARCHAR2(40) := 'GMO_INSTR_INSTANCE_B';
122
123 G_PROCESS_STATUS CONSTANT VARCHAR2(40) := 'PROCESS_STATUS';
124 G_PROCESS_ERROR CONSTANT VARCHAR2(40) := 'ERROR';
125 G_PROCESS_CANCEL CONSTANT VARCHAR2(40) := 'CANCEL';
126 G_PROCESS_SUCCESS CONSTANT VARCHAR2(40) := 'SUCCESS';
127 G_PROCESS_TERMINATE CONSTANT VARCHAR2(40) := 'TERMINATE';
128 G_PROCESS_COMPLETE CONSTANT VARCHAR2(40) := 'COMPLETE';
129 G_PROCESS_ACTIVE CONSTANT VARCHAR2(40) := 'ACTIVE';
130
131 G_INSTR_PREFIX CONSTANT VARCHAR2(40) := 'INSTR$';
132 G_INSTR_RETURN_URL CONSTANT VARCHAR2(40) := 'PI_RETURN_URL';
133 G_INSTR_SOURCE_APPL_TYPE CONSTANT VARCHAR2(40) := 'INSTR_SOURCE_TYPE';
134 -- Process Instruction related constants
135
136 --Bug 5059386: start
137 G_ALL_ATTRIBUTE CONSTANT VARCHAR2(40) := '-000-';
138
139 --This function will return the constant G_ALL_ATTRIBUTE
140 --so that it can be used in queries.
141
142 -- Start of comments
143 -- API name : all_attribute
144 -- Type : Private Utility.
145 -- Function : returns constant G_ALL_ATTRIBUTE
146 -- Pre-reqs : None.
147 -- Parameters :
148 -- IN :
149 -- OUT : constant G_ALL_ATTRIBUTE
150 -- End of comments
151 function ALL_ATTRIBUTE RETURN VARCHAR2;
152 --Bug 5059386: end
153
154 END GMO_CONSTANTS_GRP;