1 PACKAGE GMO_VBATCH_GRP AS
2 /* $Header: GMOGVBTS.pls 120.2 2005/10/26 05:49 rahugupt noship $ */
3
4 --This procdeure would instantiate the process instructions for the batch.
5
6 -- Start of comments
7 -- API name : instantiate_advanced_pi
8 -- Type : Group Utility.
9 -- Function : Instantiates the process instructions
10 -- Pre-reqs : None.
11 -- Parameters :
12 -- IN : p_api_version in number,
13 -- p_init_msg_list in varchar2 default fnd_api.g_false,
14 -- p_commit in varchar2 default fnd_api.g_false,
15 -- p_validation_level in number default fnd_api.g_valid_level_full,
16 -- p_entity_name in varchar2
17 -- p_entity_key in varchar2
18 -- OUT : x_return_status out varchar2
19 -- x_msg_count out number
20 -- x_msg_data out varchar2
21 -- End of comments
22
23 procedure INSTANTIATE_ADVANCED_PI (P_API_VERSION IN NUMBER,
24 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
25 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26 P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
27 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
28 X_MSG_COUNT OUT NOCOPY NUMBER,
29 X_MSG_DATA OUT NOCOPY VARCHAR2,
30 P_ENTITY_NAME IN VARCHAR2,
31 P_ENTITY_KEY IN VARCHAR2
32 );
33
34
35 --This procdeure would get the context information for the task.
36
37 -- Start of comments
38 -- API name : on_task_load
39 -- Type : Group Utility.
40 -- Function : gets the context information for the task
41 -- Pre-reqs : None.
42 -- Parameters :
43 -- IN : p_api_version in number,
44 -- p_init_msg_list in varchar2 default fnd_api.g_false,
45 -- p_commit in varchar2 default fnd_api.g_false,
46 -- p_validation_level in number default fnd_api.g_valid_level_full,
47 -- p_from_module in varchar2
48 -- p_entity_name in varchar2
49 -- p_entity_key in varchar2
50 -- p_task in varchar2
51 -- p_task_attribute in varchar2
52 -- p_instruction_id in number
53 -- OUT : x_entity_name out varchar2
54 -- x_entity_key out varchar2
55 -- x_task out varchar2
56 -- x_task_key out varchar2
57 -- x_read_only out char
58 -- x_context_params_tbl out CONTEXT_PARAMS_TBL_TYPE
59 -- x_return_status out varchar2
60 -- x_msg_count out number
61 -- x_msg_data out varchar2
62 -- End of comments
63
64 procedure ON_TASK_LOAD (P_API_VERSION IN NUMBER,
65 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
66 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
67 P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
68 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
69 X_MSG_COUNT OUT NOCOPY NUMBER,
70 X_MSG_DATA OUT NOCOPY VARCHAR2,
71 P_FROM_MODULE IN VARCHAR2,
72 P_ENTITY_NAME IN VARCHAR2,
73 P_ENTITY_KEY IN VARCHAR2,
74 P_TASK IN VARCHAR2,
75 P_TASK_ATTRIBUTE IN VARCHAR2,
76 P_INSTRUCTION_ID IN NUMBER,
77 P_INSTRUCTION_PROCESS_ID IN NUMBER,
78 P_REQUESTER IN NUMBER,
79 P_VBATCH_MODE IN VARCHAR2,
80 X_TASK_ENTITY_NAME OUT NOCOPY VARCHAR2,
81 X_TASK_ENTITY_KEY OUT NOCOPY VARCHAR2,
82 X_TASK_NAME OUT NOCOPY VARCHAR2,
83 X_TASK_KEY OUT NOCOPY VARCHAR2,
84 X_READ_ONLY OUT NOCOPY VARCHAR2,
85 X_CONTEXT_PARAMS_TBL OUT NOCOPY GMO_DATATYPES_GRP.CONTEXT_PARAMS_TBL_TYPE
86 );
87
88
89 --This procdeure would process the action performed by the task.
90
91 -- Start of comments
92 -- API name : on_task_action
93 -- Type : Group Utility.
94 -- Function : process the action performed by the task
95 -- Pre-reqs : None.
96 -- Parameters :
97 -- IN : p_api_version in number,
98 -- p_init_msg_list in varchar2 default fnd_api.g_false,
99 -- p_commit in varchar2 default fnd_api.g_false,
100 -- p_validation_level in number default fnd_api.g_valid_level_full,
101 -- p_entity_name in varchar2
102 -- p_entity_key in varchar2
103 -- p_task in varchar2
104 -- p_task_attribute in varchar2
105 -- OUT : x_return_status out varchar2
106 -- x_msg_count out number
107 -- x_msg_data out varchar2
108 -- End of comments
109
110 procedure ON_TASK_ACTION (P_API_VERSION IN NUMBER,
111 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
112 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
113 P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
114 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
115 X_MSG_COUNT OUT NOCOPY NUMBER,
116 X_MSG_DATA OUT NOCOPY VARCHAR2,
117 P_ENTITY_NAME IN VARCHAR2,
118 P_ENTITY_KEY IN VARCHAR2,
119 P_TASK IN VARCHAR2,
120 P_TASK_ATTRIBUTE IN VARCHAR2,
121 P_REQUESTER IN NUMBER
122 );
123
124
125 --This procdeure would process the save event of the task.
126
127 -- Start of comments
128 -- API name : on_task_save
129 -- Type : Group Utility.
130 -- Function : process the save event of the task.
131 -- Pre-reqs : None.
132 -- Parameters :
133 -- IN : p_api_version in number,
134 -- p_init_msg_list in varchar2 default fnd_api.g_false,
135 -- p_commit in varchar2 default fnd_api.g_false,
136 -- p_validation_level in number default fnd_api.g_valid_level_full,
137 -- p_from_module in varchar2
138 -- p_entity_name in varchar2
139 -- p_entity_key in varchar2
140 -- p_task in varchar2
141 -- p_task_attribute in varchar2
142 -- p_instruction_id in number
143 -- p_task_identifier in gmo_table_of_varchar2_255
144 -- p_task_value in gmo_table_of_varchar2_255
145 -- p_task_erecord in gmo_table_of_varchar2_255
146 -- p_requester in number
147 -- OUT : x_return_status out varchar2
148 -- x_msg_count out number
149 -- x_msg_data out varchar2
150 -- End of comments
151
152
153 procedure ON_TASK_SAVE (P_API_VERSION IN NUMBER,
154 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
155 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
156 P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
157 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
158 X_MSG_COUNT OUT NOCOPY NUMBER,
159 X_MSG_DATA OUT NOCOPY VARCHAR2,
160 P_FROM_MODULE IN VARCHAR2,
161 P_ENTITY_NAME IN VARCHAR2,
162 P_ENTITY_KEY IN VARCHAR2,
163 P_TASK IN VARCHAR2,
164 P_TASK_ATTRIBUTE IN VARCHAR2 DEFAULT NULL,
165 P_INSTRUCTION_ID IN NUMBER DEFAULT NULL,
166 P_INSTRUCTION_PROCESS_ID IN NUMBER DEFAULT NULL,
167 P_TASK_IDENTIFIER IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
168 P_TASK_VALUE IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
169 P_TASK_ERECORD IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
170 P_REQUESTER IN NUMBER
171 );
172
173
174 --This procdeure would check if the entity is locked or not
175
176 -- Start of comments
177 -- API name : get_entity_lock_status
178 -- Type : Group Utility.
179 -- Function : checks if the entity is locked or not
180 -- Pre-reqs : None.
181 -- Parameters :
182 -- IN : p_api_version in number,
183 -- p_init_msg_list in varchar2 default fnd_api.g_false,
184 -- p_commit in varchar2 default fnd_api.g_false,
185 -- p_validation_level in number default fnd_api.g_valid_level_full,
186 -- p_entity_name in varchar2
187 -- p_entity_key in varchar2
188 -- p_requester in varchar2
189 -- OUT : x_lock_status out varchar2
190 -- x_locked_by_status out varchar2
191 -- x_lock_allowed out varchar2
192 -- x_return_status out varchar2
193 -- x_msg_count out number
194 -- x_msg_data out varchar2
195 -- End of comments
196
197 procedure GET_ENTITY_LOCK_STATUS (P_API_VERSION IN NUMBER,
198 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
199 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
200 P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
201 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
202 X_MSG_COUNT OUT NOCOPY NUMBER,
203 X_MSG_DATA OUT NOCOPY VARCHAR2,
204 P_ENTITY_NAME IN VARCHAR2,
205 P_ENTITY_KEY IN VARCHAR2,
206 P_REQUESTER IN NUMBER,
207 X_LOCK_STATUS OUT NOCOPY VARCHAR2,
208 X_LOCKED_BY_STATUS OUT NOCOPY VARCHAR2,
209 X_LOCK_ALLOWED OUT NOCOPY VARCHAR2
210 );
211
212
213
214
215 END GMO_VBATCH_GRP;