1 package FND_CONCURRENT_PROGRAMS_PKG as
2 /* $Header: AFCPMCPS.pls 120.2.12000000.1 2007/01/18 13:15:13 appldev ship $ */
3
4
5 procedure INSERT_ROW (
6 X_ROWID in out nocopy VARCHAR2,
7 X_APPLICATION_ID in NUMBER,
8 X_CONCURRENT_PROGRAM_ID in NUMBER,
9 X_CONCURRENT_PROGRAM_NAME in VARCHAR2,
10 X_EXECUTABLE_APPLICATION_ID in NUMBER,
11 X_EXECUTABLE_ID in NUMBER,
12 X_EXECUTION_METHOD_CODE in VARCHAR2,
13 X_ARGUMENT_METHOD_CODE in VARCHAR2,
14 X_QUEUE_CONTROL_FLAG in VARCHAR2,
15 X_QUEUE_METHOD_CODE in VARCHAR2,
16 X_REQUEST_SET_FLAG in VARCHAR2,
17 X_ENABLED_FLAG in VARCHAR2,
18 X_PRINT_FLAG in VARCHAR2,
19 X_RUN_ALONE_FLAG in VARCHAR2,
20 X_SRS_FLAG in VARCHAR2,
21 X_CLASS_APPLICATION_ID in NUMBER,
22 X_CONCURRENT_CLASS_ID in NUMBER,
23 X_EXECUTION_OPTIONS in VARCHAR2,
24 X_SAVE_OUTPUT_FLAG in VARCHAR2,
25 X_REQUIRED_STYLE in VARCHAR2,
26 X_OUTPUT_PRINT_STYLE in VARCHAR2,
27 X_PRINTER_NAME in VARCHAR2,
28 X_MINIMUM_WIDTH in NUMBER,
29 X_MINIMUM_LENGTH in NUMBER,
30 X_REQUEST_PRIORITY in NUMBER,
31 X_OUTPUT_FILE_TYPE in VARCHAR2,
32 X_RESTART in VARCHAR2,
33 X_NLS_COMPLIANT in VARCHAR2,
34 X_ENABLE_TRACE in VARCHAR2,
35 X_ICON_NAME in VARCHAR2,
36 X_CD_PARAMETER in VARCHAR2,
37 X_SECURITY_GROUP_ID in NUMBER,
38 X_INCREMENT_PROC in VARCHAR2,
39 X_MLS_EXECUTABLE_APP_ID in NUMBER,
40 X_MLS_EXECUTABLE_ID in NUMBER,
41 X_RESOURCE_CONSUMER_GROUP in VARCHAR2,
42 X_ROLLBACK_SEGMENT in VARCHAR2,
43 X_OPTIMIZER_MODE in VARCHAR2,
44 X_USER_CONCURRENT_PROGRAM_NAME in VARCHAR2,
45 X_DESCRIPTION in VARCHAR2,
46 X_CREATION_DATE in DATE,
47 X_CREATED_BY in NUMBER,
48 X_LAST_UPDATE_DATE in DATE,
49 X_LAST_UPDATED_BY in NUMBER,
50 X_LAST_UPDATE_LOGIN in NUMBER,
51 X_ENABLE_TIME_STATISTICS in VARCHAR2,
52 X_REFRESH_PORTLET in VARCHAR2,
53 X_PROGRAM_TYPE in VARCHAR2,
54 X_ACTIVITY_SUMMARIZER in VARCHAR2,
55 X_ALLOW_MULTIPLE_PENDING_REQUE VARCHAR2,
56 X_DELETE_LOG_FILE VARCHAR2,
57 X_TEMPLATE_APPL_SHORT_NAME in VARCHAR2,
58 X_TEMPLATE_CODE in VARCHAR2,
59 X_MULTI_ORG_CATEGORY in VARCHAR2
60 );
61 procedure LOCK_ROW (
62 X_APPLICATION_ID in NUMBER,
63 X_CONCURRENT_PROGRAM_ID in NUMBER,
64 X_CONCURRENT_PROGRAM_NAME in VARCHAR2,
65 X_EXECUTABLE_APPLICATION_ID in NUMBER,
66 X_EXECUTABLE_ID in NUMBER,
67 X_EXECUTION_METHOD_CODE in VARCHAR2,
68 X_ARGUMENT_METHOD_CODE in VARCHAR2,
69 X_QUEUE_CONTROL_FLAG in VARCHAR2,
70 X_QUEUE_METHOD_CODE in VARCHAR2,
71 X_REQUEST_SET_FLAG in VARCHAR2,
72 X_ENABLED_FLAG in VARCHAR2,
73 X_PRINT_FLAG in VARCHAR2,
74 X_RUN_ALONE_FLAG in VARCHAR2,
75 X_SRS_FLAG in VARCHAR2,
76 X_CLASS_APPLICATION_ID in NUMBER,
77 X_CONCURRENT_CLASS_ID in NUMBER,
78 X_EXECUTION_OPTIONS in VARCHAR2,
79 X_SAVE_OUTPUT_FLAG in VARCHAR2,
80 X_REQUIRED_STYLE in VARCHAR2,
81 X_OUTPUT_PRINT_STYLE in VARCHAR2,
82 X_PRINTER_NAME in VARCHAR2,
83 X_MINIMUM_WIDTH in NUMBER,
84 X_MINIMUM_LENGTH in NUMBER,
85 X_REQUEST_PRIORITY in NUMBER,
86 X_OUTPUT_FILE_TYPE in VARCHAR2,
87 X_RESTART in VARCHAR2,
88 X_NLS_COMPLIANT in VARCHAR2,
89 X_ENABLE_TRACE in VARCHAR2,
90 X_ICON_NAME in VARCHAR2,
91 X_CD_PARAMETER in VARCHAR2,
92 X_SECURITY_GROUP_ID in NUMBER,
93 X_INCREMENT_PROC in VARCHAR2,
94 X_MLS_EXECUTABLE_APP_ID in NUMBER,
95 X_MLS_EXECUTABLE_ID in NUMBER,
96 X_RESOURCE_CONSUMER_GROUP in VARCHAR2,
97 X_ROLLBACK_SEGMENT in VARCHAR2,
98 X_OPTIMIZER_MODE in VARCHAR2,
99 X_USER_CONCURRENT_PROGRAM_NAME in VARCHAR2,
100 X_DESCRIPTION in VARCHAR2,
101 X_ENABLE_TIME_STATISTICS in VARCHAR2,
102 X_REFRESH_PORTLET in VARCHAR2,
103 X_PROGRAM_TYPE in VARCHAR2,
104 X_ACTIVITY_SUMMARIZER in VARCHAR2,
105 X_ALLOW_MULTIPLE_PENDING_REQUE VARCHAR2,
106 X_DELETE_LOG_FILE VARCHAR2,
107 X_TEMPLATE_APPL_SHORT_NAME in VARCHAR2,
108 X_TEMPLATE_CODE in VARCHAR2,
109 X_MULTI_ORG_CATEGORY in VARCHAR2
110 );
111 procedure UPDATE_ROW (
112 X_APPLICATION_ID in NUMBER,
113 X_CONCURRENT_PROGRAM_ID in NUMBER,
114 X_CONCURRENT_PROGRAM_NAME in VARCHAR2,
115 X_EXECUTABLE_APPLICATION_ID in NUMBER,
116 X_EXECUTABLE_ID in NUMBER,
117 X_EXECUTION_METHOD_CODE in VARCHAR2,
118 X_ARGUMENT_METHOD_CODE in VARCHAR2,
119 X_QUEUE_CONTROL_FLAG in VARCHAR2,
120 X_QUEUE_METHOD_CODE in VARCHAR2,
121 X_REQUEST_SET_FLAG in VARCHAR2,
122 X_ENABLED_FLAG in VARCHAR2,
123 X_PRINT_FLAG in VARCHAR2,
124 X_RUN_ALONE_FLAG in VARCHAR2,
125 X_SRS_FLAG in VARCHAR2,
126 X_CLASS_APPLICATION_ID in NUMBER,
127 X_CONCURRENT_CLASS_ID in NUMBER,
128 X_EXECUTION_OPTIONS in VARCHAR2,
129 X_SAVE_OUTPUT_FLAG in VARCHAR2,
130 X_REQUIRED_STYLE in VARCHAR2,
131 X_OUTPUT_PRINT_STYLE in VARCHAR2,
132 X_PRINTER_NAME in VARCHAR2,
133 X_MINIMUM_WIDTH in NUMBER,
134 X_MINIMUM_LENGTH in NUMBER,
135 X_REQUEST_PRIORITY in NUMBER,
136 X_OUTPUT_FILE_TYPE in VARCHAR2,
137 X_RESTART in VARCHAR2,
138 X_NLS_COMPLIANT in VARCHAR2,
139 X_ENABLE_TRACE in VARCHAR2,
140 X_ICON_NAME in VARCHAR2,
141 X_CD_PARAMETER in VARCHAR2,
142 X_SECURITY_GROUP_ID in NUMBER,
143 X_INCREMENT_PROC in VARCHAR2,
144 X_MLS_EXECUTABLE_APP_ID in NUMBER,
145 X_MLS_EXECUTABLE_ID in NUMBER,
146 X_RESOURCE_CONSUMER_GROUP in VARCHAR2,
147 X_ROLLBACK_SEGMENT in VARCHAR2,
148 X_OPTIMIZER_MODE in VARCHAR2,
149 X_USER_CONCURRENT_PROGRAM_NAME in VARCHAR2,
150 X_DESCRIPTION in VARCHAR2,
151 X_LAST_UPDATE_DATE in DATE,
152 X_LAST_UPDATED_BY in NUMBER,
153 X_LAST_UPDATE_LOGIN in NUMBER,
154 X_ENABLE_TIME_STATISTICS in VARCHAR2,
155 X_REFRESH_PORTLET in VARCHAR2,
156 X_PROGRAM_TYPE in VARCHAR2,
157 X_ACTIVITY_SUMMARIZER in VARCHAR2,
158 X_ALLOW_MULTIPLE_PENDING_REQUE VARCHAR2,
159 X_DELETE_LOG_FILE VARCHAR2,
160 X_TEMPLATE_APPL_SHORT_NAME in VARCHAR2,
161 X_TEMPLATE_CODE in VARCHAR2,
162 X_MULTI_ORG_CATEGORY in VARCHAR2
163 );
164 -- Overloaded in case custom_mode and last_upate_date are not used
165 procedure TRANSLATE_ROW (
166 x_concurrent_program_name in varchar2,
167 x_application_short_name in varchar2,
168 x_owner in varchar2,
169 x_user_concurrent_program_name in varchar2,
170 x_description in varchar2
171 );
172 -- Overloaded
173 procedure TRANSLATE_ROW (
174 x_concurrent_program_name in varchar2,
175 x_application_short_name in varchar2,
176 x_owner in varchar2,
177 x_user_concurrent_program_name in varchar2,
178 x_description in varchar2,
179 x_custom_mode in varchar2,
180 x_last_update_date in varchar2
181 );
182 -- Overloaded in case custom_mode and last_upate_date are not used
183 procedure LOAD_ROW (
184 x_concurrent_program_name in varchar2,
185 x_application_short_name in varchar2,
186 x_owner in varchar2,
187 x_user_concurrent_program_name in varchar2,
188 x_exec_executable_name in varchar2,
189 x_exec_application_short_name in varchar2,
190 x_execution_method_code in varchar2,
191 x_argument_method_code in varchar2,
192 x_queue_control_flag in varchar2,
193 x_queue_method_code in varchar2,
194 x_request_set_flag in varchar2,
195 x_enabled_flag in varchar2,
196 x_print_flag in varchar2,
197 x_run_alone_flag in varchar2,
198 x_srs_flag in varchar2,
199 x_description in varchar2,
200 x_class_application in varchar2,
201 x_concurrent_class_name in varchar2,
202 x_execution_options in varchar2,
203 x_save_output_flag in varchar2,
204 x_required_style in varchar2,
205 x_output_print_style in varchar2,
206 x_printer_name in varchar2,
207 x_minimum_width in varchar2,
208 x_minimum_length in varchar2,
209 x_request_priority in varchar2,
210 x_attribute_category in varchar2,
211 x_attribute1 in varchar2,
212 x_attribute2 in varchar2,
213 x_attribute3 in varchar2,
214 x_attribute4 in varchar2,
215 x_attribute5 in varchar2,
216 x_attribute6 in varchar2,
217 x_attribute7 in varchar2,
218 x_attribute8 in varchar2,
219 x_attribute9 in varchar2,
220 x_attribute10 in varchar2,
221 x_attribute11 in varchar2,
222 x_attribute12 in varchar2,
223 x_attribute13 in varchar2,
224 x_attribute14 in varchar2,
225 x_attribute15 in varchar2,
226 x_output_file_type in varchar2,
227 x_restart in varchar2,
228 x_nls_compliant in varchar2,
229 x_cd_parameter in varchar2,
230 x_increment_proc in varchar2,
231 x_me_ex_id in varchar2,
232 x_me_ap_id in varchar2,
233 x_enable_time_statistics in varchar2,
234 x_security_group_name in varchar2,
235 x_resource_consumer_group in varchar2,
236 x_rollback_segment in varchar2,
237 x_optimizer_mode in varchar2,
238 x_srs_flex in varchar2
239 );
240 procedure LOAD_ROW (
241 x_concurrent_program_name in varchar2,
242 x_application_short_name in varchar2,
243 x_owner in varchar2,
244 x_user_concurrent_program_name in varchar2,
245 x_exec_executable_name in varchar2,
246 x_exec_application_short_name in varchar2,
247 x_execution_method_code in varchar2,
248 x_argument_method_code in varchar2,
249 x_queue_control_flag in varchar2,
250 x_queue_method_code in varchar2,
251 x_request_set_flag in varchar2,
252 x_enabled_flag in varchar2,
253 x_print_flag in varchar2,
254 x_run_alone_flag in varchar2,
255 x_srs_flag in varchar2,
256 x_description in varchar2,
257 x_class_application in varchar2,
258 x_concurrent_class_name in varchar2,
259 x_execution_options in varchar2,
260 x_save_output_flag in varchar2,
261 x_required_style in varchar2,
262 x_output_print_style in varchar2,
263 x_printer_name in varchar2,
264 x_minimum_width in varchar2,
265 x_minimum_length in varchar2,
266 x_request_priority in varchar2,
267 x_attribute_category in varchar2,
268 x_attribute1 in varchar2,
269 x_attribute2 in varchar2,
270 x_attribute3 in varchar2,
271 x_attribute4 in varchar2,
272 x_attribute5 in varchar2,
273 x_attribute6 in varchar2,
274 x_attribute7 in varchar2,
275 x_attribute8 in varchar2,
276 x_attribute9 in varchar2,
277 x_attribute10 in varchar2,
278 x_attribute11 in varchar2,
279 x_attribute12 in varchar2,
280 x_attribute13 in varchar2,
281 x_attribute14 in varchar2,
282 x_attribute15 in varchar2,
283 x_output_file_type in varchar2,
284 x_restart in varchar2,
285 x_nls_compliant in varchar2,
286 x_cd_parameter in varchar2,
287 x_increment_proc in varchar2,
288 x_me_ex_id in varchar2,
289 x_me_ap_id in varchar2,
290 x_enable_time_statistics in varchar2,
291 x_security_group_name in varchar2,
292 x_resource_consumer_group in varchar2,
293 x_rollback_segment in varchar2,
294 x_optimizer_mode in varchar2,
295 x_srs_flex in varchar2,
296 x_custom_mode in varchar2,
297 x_last_update_date in varchar2,
298 x_refresh_portlet in varchar2,
299 x_activity_summarizer in varchar2,
300 x_program_type in varchar2,
301 x_allow_multiple_pending_reque in varchar2,
302 x_template_appl_short_name in varchar2,
303 x_template_code in varchar2,
304 x_multi_org_category in varchar2
305 );
306 procedure ADD_LANGUAGE;
307 end FND_CONCURRENT_PROGRAMS_PKG;