eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_NOTIFICATION_PREFS_API dependencies on HR_API

Line 121: when hr_api.cannot_find_prog_unit then

117: ,p_agency_id => p_agency_id
118: ,p_attempt_id => p_attempt_id
119: );
120: exception
121: when hr_api.cannot_find_prog_unit then
122: hr_api.cannot_find_prog_unit_error
123: (p_module_name => 'CREATE_NOTIFICATION_PREFS'
124: ,p_hook_type => 'BP'
125: );

Line 122: hr_api.cannot_find_prog_unit_error

118: ,p_attempt_id => p_attempt_id
119: );
120: exception
121: when hr_api.cannot_find_prog_unit then
122: hr_api.cannot_find_prog_unit_error
123: (p_module_name => 'CREATE_NOTIFICATION_PREFS'
124: ,p_hook_type => 'BP'
125: );
126: end;

Line 226: when hr_api.cannot_find_prog_unit then

222: ,p_agency_id => p_agency_id
223: ,p_attempt_id => p_attempt_id
224: );
225: exception
226: when hr_api.cannot_find_prog_unit then
227: hr_api.cannot_find_prog_unit_error
228: (p_module_name => 'CREATE_NOTIFICATION_PREFS'
229: ,p_hook_type => 'AP'
230: );

Line 227: hr_api.cannot_find_prog_unit_error

223: ,p_attempt_id => p_attempt_id
224: );
225: exception
226: when hr_api.cannot_find_prog_unit then
227: hr_api.cannot_find_prog_unit_error
228: (p_module_name => 'CREATE_NOTIFICATION_PREFS'
229: ,p_hook_type => 'AP'
230: );
231: end;

Line 236: raise hr_api.validate_enabled;

232: --
233: -- When in validation only mode raise the Validate_Enabled exception
234: --
235: if p_validate then
236: raise hr_api.validate_enabled;
237: end if;
238: --
239: -- Set all output arguments
240: --

Line 246: when hr_api.validate_enabled then

242: p_notification_preference_id := l_notification_preference_id;
243: --
244: hr_utility.set_location(' Leaving:'||l_proc, 70);
245: exception
246: when hr_api.validate_enabled then
247: --
248: -- As the Validate_Enabled exception has been raised
249: -- we must rollback to the savepoint
250: --

Line 277: ,p_party_id in number default hr_api.g_number

273: -- ----------------------------------------------------------------------------
274: --
275: procedure UPDATE_NOTIFICATION_PREFS
276: (p_validate in boolean default false
277: ,p_party_id in number default hr_api.g_number
278: ,p_person_id in number default hr_api.g_number
279: ,p_effective_date in date
280: ,p_matching_jobs in varchar2 default hr_api.g_varchar2
281: ,p_matching_job_freq in varchar2 default hr_api.g_varchar2

Line 278: ,p_person_id in number default hr_api.g_number

274: --
275: procedure UPDATE_NOTIFICATION_PREFS
276: (p_validate in boolean default false
277: ,p_party_id in number default hr_api.g_number
278: ,p_person_id in number default hr_api.g_number
279: ,p_effective_date in date
280: ,p_matching_jobs in varchar2 default hr_api.g_varchar2
281: ,p_matching_job_freq in varchar2 default hr_api.g_varchar2
282: ,p_allow_access in varchar2 default hr_api.g_varchar2

Line 280: ,p_matching_jobs in varchar2 default hr_api.g_varchar2

276: (p_validate in boolean default false
277: ,p_party_id in number default hr_api.g_number
278: ,p_person_id in number default hr_api.g_number
279: ,p_effective_date in date
280: ,p_matching_jobs in varchar2 default hr_api.g_varchar2
281: ,p_matching_job_freq in varchar2 default hr_api.g_varchar2
282: ,p_allow_access in varchar2 default hr_api.g_varchar2
283: ,p_receive_info_mail in varchar2 default hr_api.g_varchar2
284: ,p_address_id in number default hr_api.g_number

Line 281: ,p_matching_job_freq in varchar2 default hr_api.g_varchar2

277: ,p_party_id in number default hr_api.g_number
278: ,p_person_id in number default hr_api.g_number
279: ,p_effective_date in date
280: ,p_matching_jobs in varchar2 default hr_api.g_varchar2
281: ,p_matching_job_freq in varchar2 default hr_api.g_varchar2
282: ,p_allow_access in varchar2 default hr_api.g_varchar2
283: ,p_receive_info_mail in varchar2 default hr_api.g_varchar2
284: ,p_address_id in number default hr_api.g_number
285: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 282: ,p_allow_access in varchar2 default hr_api.g_varchar2

278: ,p_person_id in number default hr_api.g_number
279: ,p_effective_date in date
280: ,p_matching_jobs in varchar2 default hr_api.g_varchar2
281: ,p_matching_job_freq in varchar2 default hr_api.g_varchar2
282: ,p_allow_access in varchar2 default hr_api.g_varchar2
283: ,p_receive_info_mail in varchar2 default hr_api.g_varchar2
284: ,p_address_id in number default hr_api.g_number
285: ,p_attribute_category in varchar2 default hr_api.g_varchar2
286: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 283: ,p_receive_info_mail in varchar2 default hr_api.g_varchar2

279: ,p_effective_date in date
280: ,p_matching_jobs in varchar2 default hr_api.g_varchar2
281: ,p_matching_job_freq in varchar2 default hr_api.g_varchar2
282: ,p_allow_access in varchar2 default hr_api.g_varchar2
283: ,p_receive_info_mail in varchar2 default hr_api.g_varchar2
284: ,p_address_id in number default hr_api.g_number
285: ,p_attribute_category in varchar2 default hr_api.g_varchar2
286: ,p_attribute1 in varchar2 default hr_api.g_varchar2
287: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 284: ,p_address_id in number default hr_api.g_number

280: ,p_matching_jobs in varchar2 default hr_api.g_varchar2
281: ,p_matching_job_freq in varchar2 default hr_api.g_varchar2
282: ,p_allow_access in varchar2 default hr_api.g_varchar2
283: ,p_receive_info_mail in varchar2 default hr_api.g_varchar2
284: ,p_address_id in number default hr_api.g_number
285: ,p_attribute_category in varchar2 default hr_api.g_varchar2
286: ,p_attribute1 in varchar2 default hr_api.g_varchar2
287: ,p_attribute2 in varchar2 default hr_api.g_varchar2
288: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 285: ,p_attribute_category in varchar2 default hr_api.g_varchar2

281: ,p_matching_job_freq in varchar2 default hr_api.g_varchar2
282: ,p_allow_access in varchar2 default hr_api.g_varchar2
283: ,p_receive_info_mail in varchar2 default hr_api.g_varchar2
284: ,p_address_id in number default hr_api.g_number
285: ,p_attribute_category in varchar2 default hr_api.g_varchar2
286: ,p_attribute1 in varchar2 default hr_api.g_varchar2
287: ,p_attribute2 in varchar2 default hr_api.g_varchar2
288: ,p_attribute3 in varchar2 default hr_api.g_varchar2
289: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 286: ,p_attribute1 in varchar2 default hr_api.g_varchar2

282: ,p_allow_access in varchar2 default hr_api.g_varchar2
283: ,p_receive_info_mail in varchar2 default hr_api.g_varchar2
284: ,p_address_id in number default hr_api.g_number
285: ,p_attribute_category in varchar2 default hr_api.g_varchar2
286: ,p_attribute1 in varchar2 default hr_api.g_varchar2
287: ,p_attribute2 in varchar2 default hr_api.g_varchar2
288: ,p_attribute3 in varchar2 default hr_api.g_varchar2
289: ,p_attribute4 in varchar2 default hr_api.g_varchar2
290: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 287: ,p_attribute2 in varchar2 default hr_api.g_varchar2

283: ,p_receive_info_mail in varchar2 default hr_api.g_varchar2
284: ,p_address_id in number default hr_api.g_number
285: ,p_attribute_category in varchar2 default hr_api.g_varchar2
286: ,p_attribute1 in varchar2 default hr_api.g_varchar2
287: ,p_attribute2 in varchar2 default hr_api.g_varchar2
288: ,p_attribute3 in varchar2 default hr_api.g_varchar2
289: ,p_attribute4 in varchar2 default hr_api.g_varchar2
290: ,p_attribute5 in varchar2 default hr_api.g_varchar2
291: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 288: ,p_attribute3 in varchar2 default hr_api.g_varchar2

284: ,p_address_id in number default hr_api.g_number
285: ,p_attribute_category in varchar2 default hr_api.g_varchar2
286: ,p_attribute1 in varchar2 default hr_api.g_varchar2
287: ,p_attribute2 in varchar2 default hr_api.g_varchar2
288: ,p_attribute3 in varchar2 default hr_api.g_varchar2
289: ,p_attribute4 in varchar2 default hr_api.g_varchar2
290: ,p_attribute5 in varchar2 default hr_api.g_varchar2
291: ,p_attribute6 in varchar2 default hr_api.g_varchar2
292: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 289: ,p_attribute4 in varchar2 default hr_api.g_varchar2

285: ,p_attribute_category in varchar2 default hr_api.g_varchar2
286: ,p_attribute1 in varchar2 default hr_api.g_varchar2
287: ,p_attribute2 in varchar2 default hr_api.g_varchar2
288: ,p_attribute3 in varchar2 default hr_api.g_varchar2
289: ,p_attribute4 in varchar2 default hr_api.g_varchar2
290: ,p_attribute5 in varchar2 default hr_api.g_varchar2
291: ,p_attribute6 in varchar2 default hr_api.g_varchar2
292: ,p_attribute7 in varchar2 default hr_api.g_varchar2
293: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 290: ,p_attribute5 in varchar2 default hr_api.g_varchar2

286: ,p_attribute1 in varchar2 default hr_api.g_varchar2
287: ,p_attribute2 in varchar2 default hr_api.g_varchar2
288: ,p_attribute3 in varchar2 default hr_api.g_varchar2
289: ,p_attribute4 in varchar2 default hr_api.g_varchar2
290: ,p_attribute5 in varchar2 default hr_api.g_varchar2
291: ,p_attribute6 in varchar2 default hr_api.g_varchar2
292: ,p_attribute7 in varchar2 default hr_api.g_varchar2
293: ,p_attribute8 in varchar2 default hr_api.g_varchar2
294: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 291: ,p_attribute6 in varchar2 default hr_api.g_varchar2

287: ,p_attribute2 in varchar2 default hr_api.g_varchar2
288: ,p_attribute3 in varchar2 default hr_api.g_varchar2
289: ,p_attribute4 in varchar2 default hr_api.g_varchar2
290: ,p_attribute5 in varchar2 default hr_api.g_varchar2
291: ,p_attribute6 in varchar2 default hr_api.g_varchar2
292: ,p_attribute7 in varchar2 default hr_api.g_varchar2
293: ,p_attribute8 in varchar2 default hr_api.g_varchar2
294: ,p_attribute9 in varchar2 default hr_api.g_varchar2
295: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 292: ,p_attribute7 in varchar2 default hr_api.g_varchar2

288: ,p_attribute3 in varchar2 default hr_api.g_varchar2
289: ,p_attribute4 in varchar2 default hr_api.g_varchar2
290: ,p_attribute5 in varchar2 default hr_api.g_varchar2
291: ,p_attribute6 in varchar2 default hr_api.g_varchar2
292: ,p_attribute7 in varchar2 default hr_api.g_varchar2
293: ,p_attribute8 in varchar2 default hr_api.g_varchar2
294: ,p_attribute9 in varchar2 default hr_api.g_varchar2
295: ,p_attribute10 in varchar2 default hr_api.g_varchar2
296: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 293: ,p_attribute8 in varchar2 default hr_api.g_varchar2

289: ,p_attribute4 in varchar2 default hr_api.g_varchar2
290: ,p_attribute5 in varchar2 default hr_api.g_varchar2
291: ,p_attribute6 in varchar2 default hr_api.g_varchar2
292: ,p_attribute7 in varchar2 default hr_api.g_varchar2
293: ,p_attribute8 in varchar2 default hr_api.g_varchar2
294: ,p_attribute9 in varchar2 default hr_api.g_varchar2
295: ,p_attribute10 in varchar2 default hr_api.g_varchar2
296: ,p_attribute11 in varchar2 default hr_api.g_varchar2
297: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 294: ,p_attribute9 in varchar2 default hr_api.g_varchar2

290: ,p_attribute5 in varchar2 default hr_api.g_varchar2
291: ,p_attribute6 in varchar2 default hr_api.g_varchar2
292: ,p_attribute7 in varchar2 default hr_api.g_varchar2
293: ,p_attribute8 in varchar2 default hr_api.g_varchar2
294: ,p_attribute9 in varchar2 default hr_api.g_varchar2
295: ,p_attribute10 in varchar2 default hr_api.g_varchar2
296: ,p_attribute11 in varchar2 default hr_api.g_varchar2
297: ,p_attribute12 in varchar2 default hr_api.g_varchar2
298: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 295: ,p_attribute10 in varchar2 default hr_api.g_varchar2

291: ,p_attribute6 in varchar2 default hr_api.g_varchar2
292: ,p_attribute7 in varchar2 default hr_api.g_varchar2
293: ,p_attribute8 in varchar2 default hr_api.g_varchar2
294: ,p_attribute9 in varchar2 default hr_api.g_varchar2
295: ,p_attribute10 in varchar2 default hr_api.g_varchar2
296: ,p_attribute11 in varchar2 default hr_api.g_varchar2
297: ,p_attribute12 in varchar2 default hr_api.g_varchar2
298: ,p_attribute13 in varchar2 default hr_api.g_varchar2
299: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 296: ,p_attribute11 in varchar2 default hr_api.g_varchar2

292: ,p_attribute7 in varchar2 default hr_api.g_varchar2
293: ,p_attribute8 in varchar2 default hr_api.g_varchar2
294: ,p_attribute9 in varchar2 default hr_api.g_varchar2
295: ,p_attribute10 in varchar2 default hr_api.g_varchar2
296: ,p_attribute11 in varchar2 default hr_api.g_varchar2
297: ,p_attribute12 in varchar2 default hr_api.g_varchar2
298: ,p_attribute13 in varchar2 default hr_api.g_varchar2
299: ,p_attribute14 in varchar2 default hr_api.g_varchar2
300: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 297: ,p_attribute12 in varchar2 default hr_api.g_varchar2

293: ,p_attribute8 in varchar2 default hr_api.g_varchar2
294: ,p_attribute9 in varchar2 default hr_api.g_varchar2
295: ,p_attribute10 in varchar2 default hr_api.g_varchar2
296: ,p_attribute11 in varchar2 default hr_api.g_varchar2
297: ,p_attribute12 in varchar2 default hr_api.g_varchar2
298: ,p_attribute13 in varchar2 default hr_api.g_varchar2
299: ,p_attribute14 in varchar2 default hr_api.g_varchar2
300: ,p_attribute15 in varchar2 default hr_api.g_varchar2
301: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 298: ,p_attribute13 in varchar2 default hr_api.g_varchar2

294: ,p_attribute9 in varchar2 default hr_api.g_varchar2
295: ,p_attribute10 in varchar2 default hr_api.g_varchar2
296: ,p_attribute11 in varchar2 default hr_api.g_varchar2
297: ,p_attribute12 in varchar2 default hr_api.g_varchar2
298: ,p_attribute13 in varchar2 default hr_api.g_varchar2
299: ,p_attribute14 in varchar2 default hr_api.g_varchar2
300: ,p_attribute15 in varchar2 default hr_api.g_varchar2
301: ,p_attribute16 in varchar2 default hr_api.g_varchar2
302: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 299: ,p_attribute14 in varchar2 default hr_api.g_varchar2

295: ,p_attribute10 in varchar2 default hr_api.g_varchar2
296: ,p_attribute11 in varchar2 default hr_api.g_varchar2
297: ,p_attribute12 in varchar2 default hr_api.g_varchar2
298: ,p_attribute13 in varchar2 default hr_api.g_varchar2
299: ,p_attribute14 in varchar2 default hr_api.g_varchar2
300: ,p_attribute15 in varchar2 default hr_api.g_varchar2
301: ,p_attribute16 in varchar2 default hr_api.g_varchar2
302: ,p_attribute17 in varchar2 default hr_api.g_varchar2
303: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 300: ,p_attribute15 in varchar2 default hr_api.g_varchar2

296: ,p_attribute11 in varchar2 default hr_api.g_varchar2
297: ,p_attribute12 in varchar2 default hr_api.g_varchar2
298: ,p_attribute13 in varchar2 default hr_api.g_varchar2
299: ,p_attribute14 in varchar2 default hr_api.g_varchar2
300: ,p_attribute15 in varchar2 default hr_api.g_varchar2
301: ,p_attribute16 in varchar2 default hr_api.g_varchar2
302: ,p_attribute17 in varchar2 default hr_api.g_varchar2
303: ,p_attribute18 in varchar2 default hr_api.g_varchar2
304: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 301: ,p_attribute16 in varchar2 default hr_api.g_varchar2

297: ,p_attribute12 in varchar2 default hr_api.g_varchar2
298: ,p_attribute13 in varchar2 default hr_api.g_varchar2
299: ,p_attribute14 in varchar2 default hr_api.g_varchar2
300: ,p_attribute15 in varchar2 default hr_api.g_varchar2
301: ,p_attribute16 in varchar2 default hr_api.g_varchar2
302: ,p_attribute17 in varchar2 default hr_api.g_varchar2
303: ,p_attribute18 in varchar2 default hr_api.g_varchar2
304: ,p_attribute19 in varchar2 default hr_api.g_varchar2
305: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 302: ,p_attribute17 in varchar2 default hr_api.g_varchar2

298: ,p_attribute13 in varchar2 default hr_api.g_varchar2
299: ,p_attribute14 in varchar2 default hr_api.g_varchar2
300: ,p_attribute15 in varchar2 default hr_api.g_varchar2
301: ,p_attribute16 in varchar2 default hr_api.g_varchar2
302: ,p_attribute17 in varchar2 default hr_api.g_varchar2
303: ,p_attribute18 in varchar2 default hr_api.g_varchar2
304: ,p_attribute19 in varchar2 default hr_api.g_varchar2
305: ,p_attribute20 in varchar2 default hr_api.g_varchar2
306: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 303: ,p_attribute18 in varchar2 default hr_api.g_varchar2

299: ,p_attribute14 in varchar2 default hr_api.g_varchar2
300: ,p_attribute15 in varchar2 default hr_api.g_varchar2
301: ,p_attribute16 in varchar2 default hr_api.g_varchar2
302: ,p_attribute17 in varchar2 default hr_api.g_varchar2
303: ,p_attribute18 in varchar2 default hr_api.g_varchar2
304: ,p_attribute19 in varchar2 default hr_api.g_varchar2
305: ,p_attribute20 in varchar2 default hr_api.g_varchar2
306: ,p_attribute21 in varchar2 default hr_api.g_varchar2
307: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 304: ,p_attribute19 in varchar2 default hr_api.g_varchar2

300: ,p_attribute15 in varchar2 default hr_api.g_varchar2
301: ,p_attribute16 in varchar2 default hr_api.g_varchar2
302: ,p_attribute17 in varchar2 default hr_api.g_varchar2
303: ,p_attribute18 in varchar2 default hr_api.g_varchar2
304: ,p_attribute19 in varchar2 default hr_api.g_varchar2
305: ,p_attribute20 in varchar2 default hr_api.g_varchar2
306: ,p_attribute21 in varchar2 default hr_api.g_varchar2
307: ,p_attribute22 in varchar2 default hr_api.g_varchar2
308: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 305: ,p_attribute20 in varchar2 default hr_api.g_varchar2

301: ,p_attribute16 in varchar2 default hr_api.g_varchar2
302: ,p_attribute17 in varchar2 default hr_api.g_varchar2
303: ,p_attribute18 in varchar2 default hr_api.g_varchar2
304: ,p_attribute19 in varchar2 default hr_api.g_varchar2
305: ,p_attribute20 in varchar2 default hr_api.g_varchar2
306: ,p_attribute21 in varchar2 default hr_api.g_varchar2
307: ,p_attribute22 in varchar2 default hr_api.g_varchar2
308: ,p_attribute23 in varchar2 default hr_api.g_varchar2
309: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 306: ,p_attribute21 in varchar2 default hr_api.g_varchar2

302: ,p_attribute17 in varchar2 default hr_api.g_varchar2
303: ,p_attribute18 in varchar2 default hr_api.g_varchar2
304: ,p_attribute19 in varchar2 default hr_api.g_varchar2
305: ,p_attribute20 in varchar2 default hr_api.g_varchar2
306: ,p_attribute21 in varchar2 default hr_api.g_varchar2
307: ,p_attribute22 in varchar2 default hr_api.g_varchar2
308: ,p_attribute23 in varchar2 default hr_api.g_varchar2
309: ,p_attribute24 in varchar2 default hr_api.g_varchar2
310: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 307: ,p_attribute22 in varchar2 default hr_api.g_varchar2

303: ,p_attribute18 in varchar2 default hr_api.g_varchar2
304: ,p_attribute19 in varchar2 default hr_api.g_varchar2
305: ,p_attribute20 in varchar2 default hr_api.g_varchar2
306: ,p_attribute21 in varchar2 default hr_api.g_varchar2
307: ,p_attribute22 in varchar2 default hr_api.g_varchar2
308: ,p_attribute23 in varchar2 default hr_api.g_varchar2
309: ,p_attribute24 in varchar2 default hr_api.g_varchar2
310: ,p_attribute25 in varchar2 default hr_api.g_varchar2
311: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 308: ,p_attribute23 in varchar2 default hr_api.g_varchar2

304: ,p_attribute19 in varchar2 default hr_api.g_varchar2
305: ,p_attribute20 in varchar2 default hr_api.g_varchar2
306: ,p_attribute21 in varchar2 default hr_api.g_varchar2
307: ,p_attribute22 in varchar2 default hr_api.g_varchar2
308: ,p_attribute23 in varchar2 default hr_api.g_varchar2
309: ,p_attribute24 in varchar2 default hr_api.g_varchar2
310: ,p_attribute25 in varchar2 default hr_api.g_varchar2
311: ,p_attribute26 in varchar2 default hr_api.g_varchar2
312: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 309: ,p_attribute24 in varchar2 default hr_api.g_varchar2

305: ,p_attribute20 in varchar2 default hr_api.g_varchar2
306: ,p_attribute21 in varchar2 default hr_api.g_varchar2
307: ,p_attribute22 in varchar2 default hr_api.g_varchar2
308: ,p_attribute23 in varchar2 default hr_api.g_varchar2
309: ,p_attribute24 in varchar2 default hr_api.g_varchar2
310: ,p_attribute25 in varchar2 default hr_api.g_varchar2
311: ,p_attribute26 in varchar2 default hr_api.g_varchar2
312: ,p_attribute27 in varchar2 default hr_api.g_varchar2
313: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 310: ,p_attribute25 in varchar2 default hr_api.g_varchar2

306: ,p_attribute21 in varchar2 default hr_api.g_varchar2
307: ,p_attribute22 in varchar2 default hr_api.g_varchar2
308: ,p_attribute23 in varchar2 default hr_api.g_varchar2
309: ,p_attribute24 in varchar2 default hr_api.g_varchar2
310: ,p_attribute25 in varchar2 default hr_api.g_varchar2
311: ,p_attribute26 in varchar2 default hr_api.g_varchar2
312: ,p_attribute27 in varchar2 default hr_api.g_varchar2
313: ,p_attribute28 in varchar2 default hr_api.g_varchar2
314: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 311: ,p_attribute26 in varchar2 default hr_api.g_varchar2

307: ,p_attribute22 in varchar2 default hr_api.g_varchar2
308: ,p_attribute23 in varchar2 default hr_api.g_varchar2
309: ,p_attribute24 in varchar2 default hr_api.g_varchar2
310: ,p_attribute25 in varchar2 default hr_api.g_varchar2
311: ,p_attribute26 in varchar2 default hr_api.g_varchar2
312: ,p_attribute27 in varchar2 default hr_api.g_varchar2
313: ,p_attribute28 in varchar2 default hr_api.g_varchar2
314: ,p_attribute29 in varchar2 default hr_api.g_varchar2
315: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 312: ,p_attribute27 in varchar2 default hr_api.g_varchar2

308: ,p_attribute23 in varchar2 default hr_api.g_varchar2
309: ,p_attribute24 in varchar2 default hr_api.g_varchar2
310: ,p_attribute25 in varchar2 default hr_api.g_varchar2
311: ,p_attribute26 in varchar2 default hr_api.g_varchar2
312: ,p_attribute27 in varchar2 default hr_api.g_varchar2
313: ,p_attribute28 in varchar2 default hr_api.g_varchar2
314: ,p_attribute29 in varchar2 default hr_api.g_varchar2
315: ,p_attribute30 in varchar2 default hr_api.g_varchar2
316: ,p_notification_preference_id in number

Line 313: ,p_attribute28 in varchar2 default hr_api.g_varchar2

309: ,p_attribute24 in varchar2 default hr_api.g_varchar2
310: ,p_attribute25 in varchar2 default hr_api.g_varchar2
311: ,p_attribute26 in varchar2 default hr_api.g_varchar2
312: ,p_attribute27 in varchar2 default hr_api.g_varchar2
313: ,p_attribute28 in varchar2 default hr_api.g_varchar2
314: ,p_attribute29 in varchar2 default hr_api.g_varchar2
315: ,p_attribute30 in varchar2 default hr_api.g_varchar2
316: ,p_notification_preference_id in number
317: ,p_agency_id in number default hr_api.g_number

Line 314: ,p_attribute29 in varchar2 default hr_api.g_varchar2

310: ,p_attribute25 in varchar2 default hr_api.g_varchar2
311: ,p_attribute26 in varchar2 default hr_api.g_varchar2
312: ,p_attribute27 in varchar2 default hr_api.g_varchar2
313: ,p_attribute28 in varchar2 default hr_api.g_varchar2
314: ,p_attribute29 in varchar2 default hr_api.g_varchar2
315: ,p_attribute30 in varchar2 default hr_api.g_varchar2
316: ,p_notification_preference_id in number
317: ,p_agency_id in number default hr_api.g_number
318: ,p_attempt_id in number default hr_api.g_number

Line 315: ,p_attribute30 in varchar2 default hr_api.g_varchar2

311: ,p_attribute26 in varchar2 default hr_api.g_varchar2
312: ,p_attribute27 in varchar2 default hr_api.g_varchar2
313: ,p_attribute28 in varchar2 default hr_api.g_varchar2
314: ,p_attribute29 in varchar2 default hr_api.g_varchar2
315: ,p_attribute30 in varchar2 default hr_api.g_varchar2
316: ,p_notification_preference_id in number
317: ,p_agency_id in number default hr_api.g_number
318: ,p_attempt_id in number default hr_api.g_number
319: ,p_object_version_number in out nocopy number

Line 317: ,p_agency_id in number default hr_api.g_number

313: ,p_attribute28 in varchar2 default hr_api.g_varchar2
314: ,p_attribute29 in varchar2 default hr_api.g_varchar2
315: ,p_attribute30 in varchar2 default hr_api.g_varchar2
316: ,p_notification_preference_id in number
317: ,p_agency_id in number default hr_api.g_number
318: ,p_attempt_id in number default hr_api.g_number
319: ,p_object_version_number in out nocopy number
320: ) is
321: --

Line 318: ,p_attempt_id in number default hr_api.g_number

314: ,p_attribute29 in varchar2 default hr_api.g_varchar2
315: ,p_attribute30 in varchar2 default hr_api.g_varchar2
316: ,p_notification_preference_id in number
317: ,p_agency_id in number default hr_api.g_number
318: ,p_attempt_id in number default hr_api.g_number
319: ,p_object_version_number in out nocopy number
320: ) is
321: --
322: -- Declare cursors and local variables

Line 388: when hr_api.cannot_find_prog_unit then

384: ,p_agency_id => p_agency_id
385: ,p_attempt_id => p_attempt_id
386: );
387: exception
388: when hr_api.cannot_find_prog_unit then
389: hr_api.cannot_find_prog_unit_error
390: (p_module_name => 'UPDATE_NOTIFICATION_PREFS'
391: ,p_hook_type => 'BP'
392: );

Line 389: hr_api.cannot_find_prog_unit_error

385: ,p_attempt_id => p_attempt_id
386: );
387: exception
388: when hr_api.cannot_find_prog_unit then
389: hr_api.cannot_find_prog_unit_error
390: (p_module_name => 'UPDATE_NOTIFICATION_PREFS'
391: ,p_hook_type => 'BP'
392: );
393: end;

Line 498: when hr_api.cannot_find_prog_unit then

494: ,p_agency_id => p_agency_id
495: ,p_attempt_id => p_attempt_id
496: );
497: exception
498: when hr_api.cannot_find_prog_unit then
499: hr_api.cannot_find_prog_unit_error
500: (p_module_name => 'UPDATE_NOTIFICATION_PREFS'
501: ,p_hook_type => 'AP'
502: );

Line 499: hr_api.cannot_find_prog_unit_error

495: ,p_attempt_id => p_attempt_id
496: );
497: exception
498: when hr_api.cannot_find_prog_unit then
499: hr_api.cannot_find_prog_unit_error
500: (p_module_name => 'UPDATE_NOTIFICATION_PREFS'
501: ,p_hook_type => 'AP'
502: );
503: end;

Line 508: raise hr_api.validate_enabled;

504: --
505: -- When in validation only mode raise the Validate_Enabled exception
506: --
507: if p_validate then
508: raise hr_api.validate_enabled;
509: end if;
510: --
511: -- Set all output arguments
512: --

Line 517: when hr_api.validate_enabled then

513: --
514: p_object_version_number := l_p_object_version_number;
515: hr_utility.set_location(' Leaving:'||l_proc, 70);
516: exception
517: when hr_api.validate_enabled then
518: --
519: -- As the Validate_Enabled exception has been raised
520: -- we must rollback to the savepoint
521: --

Line 577: when hr_api.cannot_find_prog_unit then

573: (p_notification_preference_id => p_notification_preference_id
574: ,p_object_version_number => p_object_version_number
575: );
576: exception
577: when hr_api.cannot_find_prog_unit then
578: hr_api.cannot_find_prog_unit_error
579: (p_module_name => 'DELETE_NOTIFICATION_PREFS'
580: ,p_hook_type => 'BP'
581: );

Line 578: hr_api.cannot_find_prog_unit_error

574: ,p_object_version_number => p_object_version_number
575: );
576: exception
577: when hr_api.cannot_find_prog_unit then
578: hr_api.cannot_find_prog_unit_error
579: (p_module_name => 'DELETE_NOTIFICATION_PREFS'
580: ,p_hook_type => 'BP'
581: );
582: end;

Line 602: when hr_api.cannot_find_prog_unit then

598: (p_notification_preference_id => p_notification_preference_id
599: ,p_object_version_number => p_object_version_number
600: );
601: exception
602: when hr_api.cannot_find_prog_unit then
603: hr_api.cannot_find_prog_unit_error
604: (p_module_name => 'DELETE_NOTIFICATION_PREFS'
605: ,p_hook_type => 'AP'
606: );

Line 603: hr_api.cannot_find_prog_unit_error

599: ,p_object_version_number => p_object_version_number
600: );
601: exception
602: when hr_api.cannot_find_prog_unit then
603: hr_api.cannot_find_prog_unit_error
604: (p_module_name => 'DELETE_NOTIFICATION_PREFS'
605: ,p_hook_type => 'AP'
606: );
607: end;

Line 612: raise hr_api.validate_enabled;

608: --
609: -- When in validation only mode raise the Validate_Enabled exception
610: --
611: if p_validate then
612: raise hr_api.validate_enabled;
613: end if;
614: --
615: -- Set all output arguments
616: --

Line 620: when hr_api.validate_enabled then

616: --
617: --
618: hr_utility.set_location(' Leaving:'||l_proc, 70);
619: exception
620: when hr_api.validate_enabled then
621: --
622: -- As the Validate_Enabled exception has been raised
623: -- we must rollback to the savepoint
624: --