APPS.OTA_CERT_PRD_ENROLLMENT_SWI dependencies on HR_API

Line 13: ,p_validate in number default hr_api.g_false_num

9: -- |----------------------< create_cert_prd_enrollment >----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_cert_prd_enrollment
12: (p_effective_date in date
13: ,p_validate in number default hr_api.g_false_num
14: ,p_cert_enrollment_id in number
15: ,p_period_status_code in varchar2
16: ,p_completion_date in date default null
17: ,p_cert_period_start_date in date default null

Line 72: hr_api.constant_to_boolean

68: --
69: -- Convert constant values to their corresponding boolean value
70: --
71: l_validate :=
72: hr_api.constant_to_boolean
73: (p_constant_value => p_validate);
74: --
75: -- Register Surrogate ID or user key values
76: --

Line 175: ,p_completion_date in date default hr_api.g_date

171: ,p_cert_prd_enrollment_id in number
172: ,p_object_version_number in out nocopy number
173: ,p_cert_enrollment_id in number
174: ,p_period_status_code in varchar2
175: ,p_completion_date in date default hr_api.g_date
176: ,p_cert_period_start_date in date default hr_api.g_date
177: ,p_cert_period_end_date in date default hr_api.g_date
178: ,p_business_group_id in number default hr_api.g_number
179: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 176: ,p_cert_period_start_date in date default hr_api.g_date

172: ,p_object_version_number in out nocopy number
173: ,p_cert_enrollment_id in number
174: ,p_period_status_code in varchar2
175: ,p_completion_date in date default hr_api.g_date
176: ,p_cert_period_start_date in date default hr_api.g_date
177: ,p_cert_period_end_date in date default hr_api.g_date
178: ,p_business_group_id in number default hr_api.g_number
179: ,p_attribute_category in varchar2 default hr_api.g_varchar2
180: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 177: ,p_cert_period_end_date in date default hr_api.g_date

173: ,p_cert_enrollment_id in number
174: ,p_period_status_code in varchar2
175: ,p_completion_date in date default hr_api.g_date
176: ,p_cert_period_start_date in date default hr_api.g_date
177: ,p_cert_period_end_date in date default hr_api.g_date
178: ,p_business_group_id in number default hr_api.g_number
179: ,p_attribute_category in varchar2 default hr_api.g_varchar2
180: ,p_attribute1 in varchar2 default hr_api.g_varchar2
181: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 178: ,p_business_group_id in number default hr_api.g_number

174: ,p_period_status_code in varchar2
175: ,p_completion_date in date default hr_api.g_date
176: ,p_cert_period_start_date in date default hr_api.g_date
177: ,p_cert_period_end_date in date default hr_api.g_date
178: ,p_business_group_id in number default hr_api.g_number
179: ,p_attribute_category in varchar2 default hr_api.g_varchar2
180: ,p_attribute1 in varchar2 default hr_api.g_varchar2
181: ,p_attribute2 in varchar2 default hr_api.g_varchar2
182: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 179: ,p_attribute_category in varchar2 default hr_api.g_varchar2

175: ,p_completion_date in date default hr_api.g_date
176: ,p_cert_period_start_date in date default hr_api.g_date
177: ,p_cert_period_end_date in date default hr_api.g_date
178: ,p_business_group_id in number default hr_api.g_number
179: ,p_attribute_category in varchar2 default hr_api.g_varchar2
180: ,p_attribute1 in varchar2 default hr_api.g_varchar2
181: ,p_attribute2 in varchar2 default hr_api.g_varchar2
182: ,p_attribute3 in varchar2 default hr_api.g_varchar2
183: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 180: ,p_attribute1 in varchar2 default hr_api.g_varchar2

176: ,p_cert_period_start_date in date default hr_api.g_date
177: ,p_cert_period_end_date in date default hr_api.g_date
178: ,p_business_group_id in number default hr_api.g_number
179: ,p_attribute_category in varchar2 default hr_api.g_varchar2
180: ,p_attribute1 in varchar2 default hr_api.g_varchar2
181: ,p_attribute2 in varchar2 default hr_api.g_varchar2
182: ,p_attribute3 in varchar2 default hr_api.g_varchar2
183: ,p_attribute4 in varchar2 default hr_api.g_varchar2
184: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 181: ,p_attribute2 in varchar2 default hr_api.g_varchar2

177: ,p_cert_period_end_date in date default hr_api.g_date
178: ,p_business_group_id in number default hr_api.g_number
179: ,p_attribute_category in varchar2 default hr_api.g_varchar2
180: ,p_attribute1 in varchar2 default hr_api.g_varchar2
181: ,p_attribute2 in varchar2 default hr_api.g_varchar2
182: ,p_attribute3 in varchar2 default hr_api.g_varchar2
183: ,p_attribute4 in varchar2 default hr_api.g_varchar2
184: ,p_attribute5 in varchar2 default hr_api.g_varchar2
185: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 182: ,p_attribute3 in varchar2 default hr_api.g_varchar2

178: ,p_business_group_id in number default hr_api.g_number
179: ,p_attribute_category in varchar2 default hr_api.g_varchar2
180: ,p_attribute1 in varchar2 default hr_api.g_varchar2
181: ,p_attribute2 in varchar2 default hr_api.g_varchar2
182: ,p_attribute3 in varchar2 default hr_api.g_varchar2
183: ,p_attribute4 in varchar2 default hr_api.g_varchar2
184: ,p_attribute5 in varchar2 default hr_api.g_varchar2
185: ,p_attribute6 in varchar2 default hr_api.g_varchar2
186: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 183: ,p_attribute4 in varchar2 default hr_api.g_varchar2

179: ,p_attribute_category in varchar2 default hr_api.g_varchar2
180: ,p_attribute1 in varchar2 default hr_api.g_varchar2
181: ,p_attribute2 in varchar2 default hr_api.g_varchar2
182: ,p_attribute3 in varchar2 default hr_api.g_varchar2
183: ,p_attribute4 in varchar2 default hr_api.g_varchar2
184: ,p_attribute5 in varchar2 default hr_api.g_varchar2
185: ,p_attribute6 in varchar2 default hr_api.g_varchar2
186: ,p_attribute7 in varchar2 default hr_api.g_varchar2
187: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 184: ,p_attribute5 in varchar2 default hr_api.g_varchar2

180: ,p_attribute1 in varchar2 default hr_api.g_varchar2
181: ,p_attribute2 in varchar2 default hr_api.g_varchar2
182: ,p_attribute3 in varchar2 default hr_api.g_varchar2
183: ,p_attribute4 in varchar2 default hr_api.g_varchar2
184: ,p_attribute5 in varchar2 default hr_api.g_varchar2
185: ,p_attribute6 in varchar2 default hr_api.g_varchar2
186: ,p_attribute7 in varchar2 default hr_api.g_varchar2
187: ,p_attribute8 in varchar2 default hr_api.g_varchar2
188: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 185: ,p_attribute6 in varchar2 default hr_api.g_varchar2

181: ,p_attribute2 in varchar2 default hr_api.g_varchar2
182: ,p_attribute3 in varchar2 default hr_api.g_varchar2
183: ,p_attribute4 in varchar2 default hr_api.g_varchar2
184: ,p_attribute5 in varchar2 default hr_api.g_varchar2
185: ,p_attribute6 in varchar2 default hr_api.g_varchar2
186: ,p_attribute7 in varchar2 default hr_api.g_varchar2
187: ,p_attribute8 in varchar2 default hr_api.g_varchar2
188: ,p_attribute9 in varchar2 default hr_api.g_varchar2
189: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 186: ,p_attribute7 in varchar2 default hr_api.g_varchar2

182: ,p_attribute3 in varchar2 default hr_api.g_varchar2
183: ,p_attribute4 in varchar2 default hr_api.g_varchar2
184: ,p_attribute5 in varchar2 default hr_api.g_varchar2
185: ,p_attribute6 in varchar2 default hr_api.g_varchar2
186: ,p_attribute7 in varchar2 default hr_api.g_varchar2
187: ,p_attribute8 in varchar2 default hr_api.g_varchar2
188: ,p_attribute9 in varchar2 default hr_api.g_varchar2
189: ,p_attribute10 in varchar2 default hr_api.g_varchar2
190: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 187: ,p_attribute8 in varchar2 default hr_api.g_varchar2

183: ,p_attribute4 in varchar2 default hr_api.g_varchar2
184: ,p_attribute5 in varchar2 default hr_api.g_varchar2
185: ,p_attribute6 in varchar2 default hr_api.g_varchar2
186: ,p_attribute7 in varchar2 default hr_api.g_varchar2
187: ,p_attribute8 in varchar2 default hr_api.g_varchar2
188: ,p_attribute9 in varchar2 default hr_api.g_varchar2
189: ,p_attribute10 in varchar2 default hr_api.g_varchar2
190: ,p_attribute11 in varchar2 default hr_api.g_varchar2
191: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 188: ,p_attribute9 in varchar2 default hr_api.g_varchar2

184: ,p_attribute5 in varchar2 default hr_api.g_varchar2
185: ,p_attribute6 in varchar2 default hr_api.g_varchar2
186: ,p_attribute7 in varchar2 default hr_api.g_varchar2
187: ,p_attribute8 in varchar2 default hr_api.g_varchar2
188: ,p_attribute9 in varchar2 default hr_api.g_varchar2
189: ,p_attribute10 in varchar2 default hr_api.g_varchar2
190: ,p_attribute11 in varchar2 default hr_api.g_varchar2
191: ,p_attribute12 in varchar2 default hr_api.g_varchar2
192: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 189: ,p_attribute10 in varchar2 default hr_api.g_varchar2

185: ,p_attribute6 in varchar2 default hr_api.g_varchar2
186: ,p_attribute7 in varchar2 default hr_api.g_varchar2
187: ,p_attribute8 in varchar2 default hr_api.g_varchar2
188: ,p_attribute9 in varchar2 default hr_api.g_varchar2
189: ,p_attribute10 in varchar2 default hr_api.g_varchar2
190: ,p_attribute11 in varchar2 default hr_api.g_varchar2
191: ,p_attribute12 in varchar2 default hr_api.g_varchar2
192: ,p_attribute13 in varchar2 default hr_api.g_varchar2
193: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 190: ,p_attribute11 in varchar2 default hr_api.g_varchar2

186: ,p_attribute7 in varchar2 default hr_api.g_varchar2
187: ,p_attribute8 in varchar2 default hr_api.g_varchar2
188: ,p_attribute9 in varchar2 default hr_api.g_varchar2
189: ,p_attribute10 in varchar2 default hr_api.g_varchar2
190: ,p_attribute11 in varchar2 default hr_api.g_varchar2
191: ,p_attribute12 in varchar2 default hr_api.g_varchar2
192: ,p_attribute13 in varchar2 default hr_api.g_varchar2
193: ,p_attribute14 in varchar2 default hr_api.g_varchar2
194: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 191: ,p_attribute12 in varchar2 default hr_api.g_varchar2

187: ,p_attribute8 in varchar2 default hr_api.g_varchar2
188: ,p_attribute9 in varchar2 default hr_api.g_varchar2
189: ,p_attribute10 in varchar2 default hr_api.g_varchar2
190: ,p_attribute11 in varchar2 default hr_api.g_varchar2
191: ,p_attribute12 in varchar2 default hr_api.g_varchar2
192: ,p_attribute13 in varchar2 default hr_api.g_varchar2
193: ,p_attribute14 in varchar2 default hr_api.g_varchar2
194: ,p_attribute15 in varchar2 default hr_api.g_varchar2
195: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 192: ,p_attribute13 in varchar2 default hr_api.g_varchar2

188: ,p_attribute9 in varchar2 default hr_api.g_varchar2
189: ,p_attribute10 in varchar2 default hr_api.g_varchar2
190: ,p_attribute11 in varchar2 default hr_api.g_varchar2
191: ,p_attribute12 in varchar2 default hr_api.g_varchar2
192: ,p_attribute13 in varchar2 default hr_api.g_varchar2
193: ,p_attribute14 in varchar2 default hr_api.g_varchar2
194: ,p_attribute15 in varchar2 default hr_api.g_varchar2
195: ,p_attribute16 in varchar2 default hr_api.g_varchar2
196: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 193: ,p_attribute14 in varchar2 default hr_api.g_varchar2

189: ,p_attribute10 in varchar2 default hr_api.g_varchar2
190: ,p_attribute11 in varchar2 default hr_api.g_varchar2
191: ,p_attribute12 in varchar2 default hr_api.g_varchar2
192: ,p_attribute13 in varchar2 default hr_api.g_varchar2
193: ,p_attribute14 in varchar2 default hr_api.g_varchar2
194: ,p_attribute15 in varchar2 default hr_api.g_varchar2
195: ,p_attribute16 in varchar2 default hr_api.g_varchar2
196: ,p_attribute17 in varchar2 default hr_api.g_varchar2
197: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 194: ,p_attribute15 in varchar2 default hr_api.g_varchar2

190: ,p_attribute11 in varchar2 default hr_api.g_varchar2
191: ,p_attribute12 in varchar2 default hr_api.g_varchar2
192: ,p_attribute13 in varchar2 default hr_api.g_varchar2
193: ,p_attribute14 in varchar2 default hr_api.g_varchar2
194: ,p_attribute15 in varchar2 default hr_api.g_varchar2
195: ,p_attribute16 in varchar2 default hr_api.g_varchar2
196: ,p_attribute17 in varchar2 default hr_api.g_varchar2
197: ,p_attribute18 in varchar2 default hr_api.g_varchar2
198: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 195: ,p_attribute16 in varchar2 default hr_api.g_varchar2

191: ,p_attribute12 in varchar2 default hr_api.g_varchar2
192: ,p_attribute13 in varchar2 default hr_api.g_varchar2
193: ,p_attribute14 in varchar2 default hr_api.g_varchar2
194: ,p_attribute15 in varchar2 default hr_api.g_varchar2
195: ,p_attribute16 in varchar2 default hr_api.g_varchar2
196: ,p_attribute17 in varchar2 default hr_api.g_varchar2
197: ,p_attribute18 in varchar2 default hr_api.g_varchar2
198: ,p_attribute19 in varchar2 default hr_api.g_varchar2
199: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 196: ,p_attribute17 in varchar2 default hr_api.g_varchar2

192: ,p_attribute13 in varchar2 default hr_api.g_varchar2
193: ,p_attribute14 in varchar2 default hr_api.g_varchar2
194: ,p_attribute15 in varchar2 default hr_api.g_varchar2
195: ,p_attribute16 in varchar2 default hr_api.g_varchar2
196: ,p_attribute17 in varchar2 default hr_api.g_varchar2
197: ,p_attribute18 in varchar2 default hr_api.g_varchar2
198: ,p_attribute19 in varchar2 default hr_api.g_varchar2
199: ,p_attribute20 in varchar2 default hr_api.g_varchar2
200: ,p_expiration_date in date default hr_api.g_date

Line 197: ,p_attribute18 in varchar2 default hr_api.g_varchar2

193: ,p_attribute14 in varchar2 default hr_api.g_varchar2
194: ,p_attribute15 in varchar2 default hr_api.g_varchar2
195: ,p_attribute16 in varchar2 default hr_api.g_varchar2
196: ,p_attribute17 in varchar2 default hr_api.g_varchar2
197: ,p_attribute18 in varchar2 default hr_api.g_varchar2
198: ,p_attribute19 in varchar2 default hr_api.g_varchar2
199: ,p_attribute20 in varchar2 default hr_api.g_varchar2
200: ,p_expiration_date in date default hr_api.g_date
201: ,p_validate in number default hr_api.g_false_num

Line 198: ,p_attribute19 in varchar2 default hr_api.g_varchar2

194: ,p_attribute15 in varchar2 default hr_api.g_varchar2
195: ,p_attribute16 in varchar2 default hr_api.g_varchar2
196: ,p_attribute17 in varchar2 default hr_api.g_varchar2
197: ,p_attribute18 in varchar2 default hr_api.g_varchar2
198: ,p_attribute19 in varchar2 default hr_api.g_varchar2
199: ,p_attribute20 in varchar2 default hr_api.g_varchar2
200: ,p_expiration_date in date default hr_api.g_date
201: ,p_validate in number default hr_api.g_false_num
202: ,p_return_status out nocopy varchar2

Line 199: ,p_attribute20 in varchar2 default hr_api.g_varchar2

195: ,p_attribute16 in varchar2 default hr_api.g_varchar2
196: ,p_attribute17 in varchar2 default hr_api.g_varchar2
197: ,p_attribute18 in varchar2 default hr_api.g_varchar2
198: ,p_attribute19 in varchar2 default hr_api.g_varchar2
199: ,p_attribute20 in varchar2 default hr_api.g_varchar2
200: ,p_expiration_date in date default hr_api.g_date
201: ,p_validate in number default hr_api.g_false_num
202: ,p_return_status out nocopy varchar2
203: ) is

Line 200: ,p_expiration_date in date default hr_api.g_date

196: ,p_attribute17 in varchar2 default hr_api.g_varchar2
197: ,p_attribute18 in varchar2 default hr_api.g_varchar2
198: ,p_attribute19 in varchar2 default hr_api.g_varchar2
199: ,p_attribute20 in varchar2 default hr_api.g_varchar2
200: ,p_expiration_date in date default hr_api.g_date
201: ,p_validate in number default hr_api.g_false_num
202: ,p_return_status out nocopy varchar2
203: ) is
204: --

Line 201: ,p_validate in number default hr_api.g_false_num

197: ,p_attribute18 in varchar2 default hr_api.g_varchar2
198: ,p_attribute19 in varchar2 default hr_api.g_varchar2
199: ,p_attribute20 in varchar2 default hr_api.g_varchar2
200: ,p_expiration_date in date default hr_api.g_date
201: ,p_validate in number default hr_api.g_false_num
202: ,p_return_status out nocopy varchar2
203: ) is
204: --
205: -- Variables for API Boolean parameters

Line 231: hr_api.constant_to_boolean

227: --
228: -- Convert constant values to their corresponding boolean value
229: --
230: l_validate :=
231: hr_api.constant_to_boolean
232: (p_constant_value => p_validate);
233: --
234: -- Register Surrogate ID or user key values
235: --

Line 328: ,p_validate in number default hr_api.g_false_num

324: -- ----------------------------------------------------------------------------
325: PROCEDURE delete_cert_prd_enrollment
326: (p_cert_prd_enrollment_id in number
327: ,p_object_version_number in number
328: ,p_validate in number default hr_api.g_false_num
329: ,p_return_status out nocopy varchar2
330: ) is
331: --
332: -- Variables for API Boolean parameters

Line 356: hr_api.constant_to_boolean

352: --
353: -- Convert constant values to their corresponding boolean value
354: --
355: l_validate :=
356: hr_api.constant_to_boolean
357: (p_constant_value => p_validate);
358: --
359: -- Register Surrogate ID or user key values
360: --

Line 420: procedure renew_cert_prd_enrollment(p_validate in number default hr_api.g_false_num

416:
417: -- ----------------------------------------------------------------------------
418: -- |----------------------< renew_cert_prd_enrollment >----------------------|
419: -- ----------------------------------------------------------------------------
420: procedure renew_cert_prd_enrollment(p_validate in number default hr_api.g_false_num
421: ,p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type
422: ,p_cert_prd_enrollment_id OUT NOCOPY ota_cert_prd_enrollments.cert_prd_enrollment_id%type
423: ,p_certification_status_code OUT NOCOPY VARCHAR2
424: ,p_return_status OUT NOCOPY VARCHAR2)

Line 436: hr_api.constant_to_boolean

432: hr_multi_message.enable_message_list;
433: savepoint renew_cert_prd_enrollment_swi;
434:
435: l_validate :=
436: hr_api.constant_to_boolean
437: (p_constant_value => p_validate);
438:
439: ota_cert_prd_enrollment_api.renew_cert_prd_enrollment(p_validate => l_validate
440: ,p_cert_enrollment_id => p_cert_enrollment_id

Line 475: when hr_api.validate_enabled then

471: p_certification_status_code := null;
472: p_return_status := hr_multi_message.get_return_status_disable;
473: hr_utility.set_location(' Leaving:' || l_proc, 30);
474:
475: when hr_api.validate_enabled then
476: --
477: -- As the Validate_Enabled exception has been raised
478: -- we must rollback to the savepoint
479: --