DBA Data[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;