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.BEN_CBR_QUALD_BNF_API dependencies on HR_API

Line 128: when hr_api.cannot_find_prog_unit then

124: ,p_cqb_attribute30 => p_cqb_attribute30
125: ,p_effective_date => trunc(p_effective_date)
126: );
127: exception
128: when hr_api.cannot_find_prog_unit then
129: hr_api.cannot_find_prog_unit_error
130: (
131: p_module_name => 'CREATE_CBR_QUALD_BNF'
132: ,p_hook_type => 'BP'

Line 129: hr_api.cannot_find_prog_unit_error

125: ,p_effective_date => trunc(p_effective_date)
126: );
127: exception
128: when hr_api.cannot_find_prog_unit then
129: hr_api.cannot_find_prog_unit_error
130: (
131: p_module_name => 'CREATE_CBR_QUALD_BNF'
132: ,p_hook_type => 'BP'
133: );

Line 239: when hr_api.cannot_find_prog_unit then

235: ,p_object_version_number => l_object_version_number
236: ,p_effective_date => trunc(p_effective_date)
237: );
238: exception
239: when hr_api.cannot_find_prog_unit then
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'CREATE_CBR_QUALD_BNF'
242: ,p_hook_type => 'AP'
243: );

Line 240: hr_api.cannot_find_prog_unit_error

236: ,p_effective_date => trunc(p_effective_date)
237: );
238: exception
239: when hr_api.cannot_find_prog_unit then
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'CREATE_CBR_QUALD_BNF'
242: ,p_hook_type => 'AP'
243: );
244: --

Line 254: raise hr_api.validate_enabled;

250: --
251: -- When in validation only mode raise the Validate_Enabled exception
252: --
253: if p_validate then
254: raise hr_api.validate_enabled;
255: end if;
256: --
257: -- Set all output arguments
258: --

Line 266: when hr_api.validate_enabled then

262: hr_utility.set_location(' Leaving:'||l_proc, 70);
263: --
264: exception
265: --
266: when hr_api.validate_enabled then
267: --
268: -- As the Validate_Enabled exception has been raised
269: -- we must rollback to the savepoint
270: --

Line 296: ,p_quald_bnf_flag in varchar2 default hr_api.g_varchar2

292: --
293: procedure update_CBR_QUALD_BNF
294: (p_validate in boolean default false
295: ,p_cbr_quald_bnf_id in number
296: ,p_quald_bnf_flag in varchar2 default hr_api.g_varchar2
297: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
298: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
299: ,p_quald_bnf_person_id in number default hr_api.g_number
300: ,p_pgm_id in number default hr_api.g_number

Line 297: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date

293: procedure update_CBR_QUALD_BNF
294: (p_validate in boolean default false
295: ,p_cbr_quald_bnf_id in number
296: ,p_quald_bnf_flag in varchar2 default hr_api.g_varchar2
297: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
298: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
299: ,p_quald_bnf_person_id in number default hr_api.g_number
300: ,p_pgm_id in number default hr_api.g_number
301: ,p_ptip_id in number default hr_api.g_number

Line 298: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date

294: (p_validate in boolean default false
295: ,p_cbr_quald_bnf_id in number
296: ,p_quald_bnf_flag in varchar2 default hr_api.g_varchar2
297: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
298: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
299: ,p_quald_bnf_person_id in number default hr_api.g_number
300: ,p_pgm_id in number default hr_api.g_number
301: ,p_ptip_id in number default hr_api.g_number
302: ,p_pl_typ_id in number default hr_api.g_number

Line 299: ,p_quald_bnf_person_id in number default hr_api.g_number

295: ,p_cbr_quald_bnf_id in number
296: ,p_quald_bnf_flag in varchar2 default hr_api.g_varchar2
297: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
298: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
299: ,p_quald_bnf_person_id in number default hr_api.g_number
300: ,p_pgm_id in number default hr_api.g_number
301: ,p_ptip_id in number default hr_api.g_number
302: ,p_pl_typ_id in number default hr_api.g_number
303: ,p_cvrd_emp_person_id in number default hr_api.g_number

Line 300: ,p_pgm_id in number default hr_api.g_number

296: ,p_quald_bnf_flag in varchar2 default hr_api.g_varchar2
297: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
298: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
299: ,p_quald_bnf_person_id in number default hr_api.g_number
300: ,p_pgm_id in number default hr_api.g_number
301: ,p_ptip_id in number default hr_api.g_number
302: ,p_pl_typ_id in number default hr_api.g_number
303: ,p_cvrd_emp_person_id in number default hr_api.g_number
304: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2

Line 301: ,p_ptip_id in number default hr_api.g_number

297: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
298: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
299: ,p_quald_bnf_person_id in number default hr_api.g_number
300: ,p_pgm_id in number default hr_api.g_number
301: ,p_ptip_id in number default hr_api.g_number
302: ,p_pl_typ_id in number default hr_api.g_number
303: ,p_cvrd_emp_person_id in number default hr_api.g_number
304: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
305: ,p_business_group_id in number default hr_api.g_number

Line 302: ,p_pl_typ_id in number default hr_api.g_number

298: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
299: ,p_quald_bnf_person_id in number default hr_api.g_number
300: ,p_pgm_id in number default hr_api.g_number
301: ,p_ptip_id in number default hr_api.g_number
302: ,p_pl_typ_id in number default hr_api.g_number
303: ,p_cvrd_emp_person_id in number default hr_api.g_number
304: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
305: ,p_business_group_id in number default hr_api.g_number
306: ,p_cqb_attribute_category in varchar2 default hr_api.g_varchar2

Line 303: ,p_cvrd_emp_person_id in number default hr_api.g_number

299: ,p_quald_bnf_person_id in number default hr_api.g_number
300: ,p_pgm_id in number default hr_api.g_number
301: ,p_ptip_id in number default hr_api.g_number
302: ,p_pl_typ_id in number default hr_api.g_number
303: ,p_cvrd_emp_person_id in number default hr_api.g_number
304: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
305: ,p_business_group_id in number default hr_api.g_number
306: ,p_cqb_attribute_category in varchar2 default hr_api.g_varchar2
307: ,p_cqb_attribute1 in varchar2 default hr_api.g_varchar2

Line 304: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2

300: ,p_pgm_id in number default hr_api.g_number
301: ,p_ptip_id in number default hr_api.g_number
302: ,p_pl_typ_id in number default hr_api.g_number
303: ,p_cvrd_emp_person_id in number default hr_api.g_number
304: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
305: ,p_business_group_id in number default hr_api.g_number
306: ,p_cqb_attribute_category in varchar2 default hr_api.g_varchar2
307: ,p_cqb_attribute1 in varchar2 default hr_api.g_varchar2
308: ,p_cqb_attribute2 in varchar2 default hr_api.g_varchar2

Line 305: ,p_business_group_id in number default hr_api.g_number

301: ,p_ptip_id in number default hr_api.g_number
302: ,p_pl_typ_id in number default hr_api.g_number
303: ,p_cvrd_emp_person_id in number default hr_api.g_number
304: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
305: ,p_business_group_id in number default hr_api.g_number
306: ,p_cqb_attribute_category in varchar2 default hr_api.g_varchar2
307: ,p_cqb_attribute1 in varchar2 default hr_api.g_varchar2
308: ,p_cqb_attribute2 in varchar2 default hr_api.g_varchar2
309: ,p_cqb_attribute3 in varchar2 default hr_api.g_varchar2

Line 306: ,p_cqb_attribute_category in varchar2 default hr_api.g_varchar2

302: ,p_pl_typ_id in number default hr_api.g_number
303: ,p_cvrd_emp_person_id in number default hr_api.g_number
304: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
305: ,p_business_group_id in number default hr_api.g_number
306: ,p_cqb_attribute_category in varchar2 default hr_api.g_varchar2
307: ,p_cqb_attribute1 in varchar2 default hr_api.g_varchar2
308: ,p_cqb_attribute2 in varchar2 default hr_api.g_varchar2
309: ,p_cqb_attribute3 in varchar2 default hr_api.g_varchar2
310: ,p_cqb_attribute4 in varchar2 default hr_api.g_varchar2

Line 307: ,p_cqb_attribute1 in varchar2 default hr_api.g_varchar2

303: ,p_cvrd_emp_person_id in number default hr_api.g_number
304: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
305: ,p_business_group_id in number default hr_api.g_number
306: ,p_cqb_attribute_category in varchar2 default hr_api.g_varchar2
307: ,p_cqb_attribute1 in varchar2 default hr_api.g_varchar2
308: ,p_cqb_attribute2 in varchar2 default hr_api.g_varchar2
309: ,p_cqb_attribute3 in varchar2 default hr_api.g_varchar2
310: ,p_cqb_attribute4 in varchar2 default hr_api.g_varchar2
311: ,p_cqb_attribute5 in varchar2 default hr_api.g_varchar2

Line 308: ,p_cqb_attribute2 in varchar2 default hr_api.g_varchar2

304: ,p_cbr_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
305: ,p_business_group_id in number default hr_api.g_number
306: ,p_cqb_attribute_category in varchar2 default hr_api.g_varchar2
307: ,p_cqb_attribute1 in varchar2 default hr_api.g_varchar2
308: ,p_cqb_attribute2 in varchar2 default hr_api.g_varchar2
309: ,p_cqb_attribute3 in varchar2 default hr_api.g_varchar2
310: ,p_cqb_attribute4 in varchar2 default hr_api.g_varchar2
311: ,p_cqb_attribute5 in varchar2 default hr_api.g_varchar2
312: ,p_cqb_attribute6 in varchar2 default hr_api.g_varchar2

Line 309: ,p_cqb_attribute3 in varchar2 default hr_api.g_varchar2

305: ,p_business_group_id in number default hr_api.g_number
306: ,p_cqb_attribute_category in varchar2 default hr_api.g_varchar2
307: ,p_cqb_attribute1 in varchar2 default hr_api.g_varchar2
308: ,p_cqb_attribute2 in varchar2 default hr_api.g_varchar2
309: ,p_cqb_attribute3 in varchar2 default hr_api.g_varchar2
310: ,p_cqb_attribute4 in varchar2 default hr_api.g_varchar2
311: ,p_cqb_attribute5 in varchar2 default hr_api.g_varchar2
312: ,p_cqb_attribute6 in varchar2 default hr_api.g_varchar2
313: ,p_cqb_attribute7 in varchar2 default hr_api.g_varchar2

Line 310: ,p_cqb_attribute4 in varchar2 default hr_api.g_varchar2

306: ,p_cqb_attribute_category in varchar2 default hr_api.g_varchar2
307: ,p_cqb_attribute1 in varchar2 default hr_api.g_varchar2
308: ,p_cqb_attribute2 in varchar2 default hr_api.g_varchar2
309: ,p_cqb_attribute3 in varchar2 default hr_api.g_varchar2
310: ,p_cqb_attribute4 in varchar2 default hr_api.g_varchar2
311: ,p_cqb_attribute5 in varchar2 default hr_api.g_varchar2
312: ,p_cqb_attribute6 in varchar2 default hr_api.g_varchar2
313: ,p_cqb_attribute7 in varchar2 default hr_api.g_varchar2
314: ,p_cqb_attribute8 in varchar2 default hr_api.g_varchar2

Line 311: ,p_cqb_attribute5 in varchar2 default hr_api.g_varchar2

307: ,p_cqb_attribute1 in varchar2 default hr_api.g_varchar2
308: ,p_cqb_attribute2 in varchar2 default hr_api.g_varchar2
309: ,p_cqb_attribute3 in varchar2 default hr_api.g_varchar2
310: ,p_cqb_attribute4 in varchar2 default hr_api.g_varchar2
311: ,p_cqb_attribute5 in varchar2 default hr_api.g_varchar2
312: ,p_cqb_attribute6 in varchar2 default hr_api.g_varchar2
313: ,p_cqb_attribute7 in varchar2 default hr_api.g_varchar2
314: ,p_cqb_attribute8 in varchar2 default hr_api.g_varchar2
315: ,p_cqb_attribute9 in varchar2 default hr_api.g_varchar2

Line 312: ,p_cqb_attribute6 in varchar2 default hr_api.g_varchar2

308: ,p_cqb_attribute2 in varchar2 default hr_api.g_varchar2
309: ,p_cqb_attribute3 in varchar2 default hr_api.g_varchar2
310: ,p_cqb_attribute4 in varchar2 default hr_api.g_varchar2
311: ,p_cqb_attribute5 in varchar2 default hr_api.g_varchar2
312: ,p_cqb_attribute6 in varchar2 default hr_api.g_varchar2
313: ,p_cqb_attribute7 in varchar2 default hr_api.g_varchar2
314: ,p_cqb_attribute8 in varchar2 default hr_api.g_varchar2
315: ,p_cqb_attribute9 in varchar2 default hr_api.g_varchar2
316: ,p_cqb_attribute10 in varchar2 default hr_api.g_varchar2

Line 313: ,p_cqb_attribute7 in varchar2 default hr_api.g_varchar2

309: ,p_cqb_attribute3 in varchar2 default hr_api.g_varchar2
310: ,p_cqb_attribute4 in varchar2 default hr_api.g_varchar2
311: ,p_cqb_attribute5 in varchar2 default hr_api.g_varchar2
312: ,p_cqb_attribute6 in varchar2 default hr_api.g_varchar2
313: ,p_cqb_attribute7 in varchar2 default hr_api.g_varchar2
314: ,p_cqb_attribute8 in varchar2 default hr_api.g_varchar2
315: ,p_cqb_attribute9 in varchar2 default hr_api.g_varchar2
316: ,p_cqb_attribute10 in varchar2 default hr_api.g_varchar2
317: ,p_cqb_attribute11 in varchar2 default hr_api.g_varchar2

Line 314: ,p_cqb_attribute8 in varchar2 default hr_api.g_varchar2

310: ,p_cqb_attribute4 in varchar2 default hr_api.g_varchar2
311: ,p_cqb_attribute5 in varchar2 default hr_api.g_varchar2
312: ,p_cqb_attribute6 in varchar2 default hr_api.g_varchar2
313: ,p_cqb_attribute7 in varchar2 default hr_api.g_varchar2
314: ,p_cqb_attribute8 in varchar2 default hr_api.g_varchar2
315: ,p_cqb_attribute9 in varchar2 default hr_api.g_varchar2
316: ,p_cqb_attribute10 in varchar2 default hr_api.g_varchar2
317: ,p_cqb_attribute11 in varchar2 default hr_api.g_varchar2
318: ,p_cqb_attribute12 in varchar2 default hr_api.g_varchar2

Line 315: ,p_cqb_attribute9 in varchar2 default hr_api.g_varchar2

311: ,p_cqb_attribute5 in varchar2 default hr_api.g_varchar2
312: ,p_cqb_attribute6 in varchar2 default hr_api.g_varchar2
313: ,p_cqb_attribute7 in varchar2 default hr_api.g_varchar2
314: ,p_cqb_attribute8 in varchar2 default hr_api.g_varchar2
315: ,p_cqb_attribute9 in varchar2 default hr_api.g_varchar2
316: ,p_cqb_attribute10 in varchar2 default hr_api.g_varchar2
317: ,p_cqb_attribute11 in varchar2 default hr_api.g_varchar2
318: ,p_cqb_attribute12 in varchar2 default hr_api.g_varchar2
319: ,p_cqb_attribute13 in varchar2 default hr_api.g_varchar2

Line 316: ,p_cqb_attribute10 in varchar2 default hr_api.g_varchar2

312: ,p_cqb_attribute6 in varchar2 default hr_api.g_varchar2
313: ,p_cqb_attribute7 in varchar2 default hr_api.g_varchar2
314: ,p_cqb_attribute8 in varchar2 default hr_api.g_varchar2
315: ,p_cqb_attribute9 in varchar2 default hr_api.g_varchar2
316: ,p_cqb_attribute10 in varchar2 default hr_api.g_varchar2
317: ,p_cqb_attribute11 in varchar2 default hr_api.g_varchar2
318: ,p_cqb_attribute12 in varchar2 default hr_api.g_varchar2
319: ,p_cqb_attribute13 in varchar2 default hr_api.g_varchar2
320: ,p_cqb_attribute14 in varchar2 default hr_api.g_varchar2

Line 317: ,p_cqb_attribute11 in varchar2 default hr_api.g_varchar2

313: ,p_cqb_attribute7 in varchar2 default hr_api.g_varchar2
314: ,p_cqb_attribute8 in varchar2 default hr_api.g_varchar2
315: ,p_cqb_attribute9 in varchar2 default hr_api.g_varchar2
316: ,p_cqb_attribute10 in varchar2 default hr_api.g_varchar2
317: ,p_cqb_attribute11 in varchar2 default hr_api.g_varchar2
318: ,p_cqb_attribute12 in varchar2 default hr_api.g_varchar2
319: ,p_cqb_attribute13 in varchar2 default hr_api.g_varchar2
320: ,p_cqb_attribute14 in varchar2 default hr_api.g_varchar2
321: ,p_cqb_attribute15 in varchar2 default hr_api.g_varchar2

Line 318: ,p_cqb_attribute12 in varchar2 default hr_api.g_varchar2

314: ,p_cqb_attribute8 in varchar2 default hr_api.g_varchar2
315: ,p_cqb_attribute9 in varchar2 default hr_api.g_varchar2
316: ,p_cqb_attribute10 in varchar2 default hr_api.g_varchar2
317: ,p_cqb_attribute11 in varchar2 default hr_api.g_varchar2
318: ,p_cqb_attribute12 in varchar2 default hr_api.g_varchar2
319: ,p_cqb_attribute13 in varchar2 default hr_api.g_varchar2
320: ,p_cqb_attribute14 in varchar2 default hr_api.g_varchar2
321: ,p_cqb_attribute15 in varchar2 default hr_api.g_varchar2
322: ,p_cqb_attribute16 in varchar2 default hr_api.g_varchar2

Line 319: ,p_cqb_attribute13 in varchar2 default hr_api.g_varchar2

315: ,p_cqb_attribute9 in varchar2 default hr_api.g_varchar2
316: ,p_cqb_attribute10 in varchar2 default hr_api.g_varchar2
317: ,p_cqb_attribute11 in varchar2 default hr_api.g_varchar2
318: ,p_cqb_attribute12 in varchar2 default hr_api.g_varchar2
319: ,p_cqb_attribute13 in varchar2 default hr_api.g_varchar2
320: ,p_cqb_attribute14 in varchar2 default hr_api.g_varchar2
321: ,p_cqb_attribute15 in varchar2 default hr_api.g_varchar2
322: ,p_cqb_attribute16 in varchar2 default hr_api.g_varchar2
323: ,p_cqb_attribute17 in varchar2 default hr_api.g_varchar2

Line 320: ,p_cqb_attribute14 in varchar2 default hr_api.g_varchar2

316: ,p_cqb_attribute10 in varchar2 default hr_api.g_varchar2
317: ,p_cqb_attribute11 in varchar2 default hr_api.g_varchar2
318: ,p_cqb_attribute12 in varchar2 default hr_api.g_varchar2
319: ,p_cqb_attribute13 in varchar2 default hr_api.g_varchar2
320: ,p_cqb_attribute14 in varchar2 default hr_api.g_varchar2
321: ,p_cqb_attribute15 in varchar2 default hr_api.g_varchar2
322: ,p_cqb_attribute16 in varchar2 default hr_api.g_varchar2
323: ,p_cqb_attribute17 in varchar2 default hr_api.g_varchar2
324: ,p_cqb_attribute18 in varchar2 default hr_api.g_varchar2

Line 321: ,p_cqb_attribute15 in varchar2 default hr_api.g_varchar2

317: ,p_cqb_attribute11 in varchar2 default hr_api.g_varchar2
318: ,p_cqb_attribute12 in varchar2 default hr_api.g_varchar2
319: ,p_cqb_attribute13 in varchar2 default hr_api.g_varchar2
320: ,p_cqb_attribute14 in varchar2 default hr_api.g_varchar2
321: ,p_cqb_attribute15 in varchar2 default hr_api.g_varchar2
322: ,p_cqb_attribute16 in varchar2 default hr_api.g_varchar2
323: ,p_cqb_attribute17 in varchar2 default hr_api.g_varchar2
324: ,p_cqb_attribute18 in varchar2 default hr_api.g_varchar2
325: ,p_cqb_attribute19 in varchar2 default hr_api.g_varchar2

Line 322: ,p_cqb_attribute16 in varchar2 default hr_api.g_varchar2

318: ,p_cqb_attribute12 in varchar2 default hr_api.g_varchar2
319: ,p_cqb_attribute13 in varchar2 default hr_api.g_varchar2
320: ,p_cqb_attribute14 in varchar2 default hr_api.g_varchar2
321: ,p_cqb_attribute15 in varchar2 default hr_api.g_varchar2
322: ,p_cqb_attribute16 in varchar2 default hr_api.g_varchar2
323: ,p_cqb_attribute17 in varchar2 default hr_api.g_varchar2
324: ,p_cqb_attribute18 in varchar2 default hr_api.g_varchar2
325: ,p_cqb_attribute19 in varchar2 default hr_api.g_varchar2
326: ,p_cqb_attribute20 in varchar2 default hr_api.g_varchar2

Line 323: ,p_cqb_attribute17 in varchar2 default hr_api.g_varchar2

319: ,p_cqb_attribute13 in varchar2 default hr_api.g_varchar2
320: ,p_cqb_attribute14 in varchar2 default hr_api.g_varchar2
321: ,p_cqb_attribute15 in varchar2 default hr_api.g_varchar2
322: ,p_cqb_attribute16 in varchar2 default hr_api.g_varchar2
323: ,p_cqb_attribute17 in varchar2 default hr_api.g_varchar2
324: ,p_cqb_attribute18 in varchar2 default hr_api.g_varchar2
325: ,p_cqb_attribute19 in varchar2 default hr_api.g_varchar2
326: ,p_cqb_attribute20 in varchar2 default hr_api.g_varchar2
327: ,p_cqb_attribute21 in varchar2 default hr_api.g_varchar2

Line 324: ,p_cqb_attribute18 in varchar2 default hr_api.g_varchar2

320: ,p_cqb_attribute14 in varchar2 default hr_api.g_varchar2
321: ,p_cqb_attribute15 in varchar2 default hr_api.g_varchar2
322: ,p_cqb_attribute16 in varchar2 default hr_api.g_varchar2
323: ,p_cqb_attribute17 in varchar2 default hr_api.g_varchar2
324: ,p_cqb_attribute18 in varchar2 default hr_api.g_varchar2
325: ,p_cqb_attribute19 in varchar2 default hr_api.g_varchar2
326: ,p_cqb_attribute20 in varchar2 default hr_api.g_varchar2
327: ,p_cqb_attribute21 in varchar2 default hr_api.g_varchar2
328: ,p_cqb_attribute22 in varchar2 default hr_api.g_varchar2

Line 325: ,p_cqb_attribute19 in varchar2 default hr_api.g_varchar2

321: ,p_cqb_attribute15 in varchar2 default hr_api.g_varchar2
322: ,p_cqb_attribute16 in varchar2 default hr_api.g_varchar2
323: ,p_cqb_attribute17 in varchar2 default hr_api.g_varchar2
324: ,p_cqb_attribute18 in varchar2 default hr_api.g_varchar2
325: ,p_cqb_attribute19 in varchar2 default hr_api.g_varchar2
326: ,p_cqb_attribute20 in varchar2 default hr_api.g_varchar2
327: ,p_cqb_attribute21 in varchar2 default hr_api.g_varchar2
328: ,p_cqb_attribute22 in varchar2 default hr_api.g_varchar2
329: ,p_cqb_attribute23 in varchar2 default hr_api.g_varchar2

Line 326: ,p_cqb_attribute20 in varchar2 default hr_api.g_varchar2

322: ,p_cqb_attribute16 in varchar2 default hr_api.g_varchar2
323: ,p_cqb_attribute17 in varchar2 default hr_api.g_varchar2
324: ,p_cqb_attribute18 in varchar2 default hr_api.g_varchar2
325: ,p_cqb_attribute19 in varchar2 default hr_api.g_varchar2
326: ,p_cqb_attribute20 in varchar2 default hr_api.g_varchar2
327: ,p_cqb_attribute21 in varchar2 default hr_api.g_varchar2
328: ,p_cqb_attribute22 in varchar2 default hr_api.g_varchar2
329: ,p_cqb_attribute23 in varchar2 default hr_api.g_varchar2
330: ,p_cqb_attribute24 in varchar2 default hr_api.g_varchar2

Line 327: ,p_cqb_attribute21 in varchar2 default hr_api.g_varchar2

323: ,p_cqb_attribute17 in varchar2 default hr_api.g_varchar2
324: ,p_cqb_attribute18 in varchar2 default hr_api.g_varchar2
325: ,p_cqb_attribute19 in varchar2 default hr_api.g_varchar2
326: ,p_cqb_attribute20 in varchar2 default hr_api.g_varchar2
327: ,p_cqb_attribute21 in varchar2 default hr_api.g_varchar2
328: ,p_cqb_attribute22 in varchar2 default hr_api.g_varchar2
329: ,p_cqb_attribute23 in varchar2 default hr_api.g_varchar2
330: ,p_cqb_attribute24 in varchar2 default hr_api.g_varchar2
331: ,p_cqb_attribute25 in varchar2 default hr_api.g_varchar2

Line 328: ,p_cqb_attribute22 in varchar2 default hr_api.g_varchar2

324: ,p_cqb_attribute18 in varchar2 default hr_api.g_varchar2
325: ,p_cqb_attribute19 in varchar2 default hr_api.g_varchar2
326: ,p_cqb_attribute20 in varchar2 default hr_api.g_varchar2
327: ,p_cqb_attribute21 in varchar2 default hr_api.g_varchar2
328: ,p_cqb_attribute22 in varchar2 default hr_api.g_varchar2
329: ,p_cqb_attribute23 in varchar2 default hr_api.g_varchar2
330: ,p_cqb_attribute24 in varchar2 default hr_api.g_varchar2
331: ,p_cqb_attribute25 in varchar2 default hr_api.g_varchar2
332: ,p_cqb_attribute26 in varchar2 default hr_api.g_varchar2

Line 329: ,p_cqb_attribute23 in varchar2 default hr_api.g_varchar2

325: ,p_cqb_attribute19 in varchar2 default hr_api.g_varchar2
326: ,p_cqb_attribute20 in varchar2 default hr_api.g_varchar2
327: ,p_cqb_attribute21 in varchar2 default hr_api.g_varchar2
328: ,p_cqb_attribute22 in varchar2 default hr_api.g_varchar2
329: ,p_cqb_attribute23 in varchar2 default hr_api.g_varchar2
330: ,p_cqb_attribute24 in varchar2 default hr_api.g_varchar2
331: ,p_cqb_attribute25 in varchar2 default hr_api.g_varchar2
332: ,p_cqb_attribute26 in varchar2 default hr_api.g_varchar2
333: ,p_cqb_attribute27 in varchar2 default hr_api.g_varchar2

Line 330: ,p_cqb_attribute24 in varchar2 default hr_api.g_varchar2

326: ,p_cqb_attribute20 in varchar2 default hr_api.g_varchar2
327: ,p_cqb_attribute21 in varchar2 default hr_api.g_varchar2
328: ,p_cqb_attribute22 in varchar2 default hr_api.g_varchar2
329: ,p_cqb_attribute23 in varchar2 default hr_api.g_varchar2
330: ,p_cqb_attribute24 in varchar2 default hr_api.g_varchar2
331: ,p_cqb_attribute25 in varchar2 default hr_api.g_varchar2
332: ,p_cqb_attribute26 in varchar2 default hr_api.g_varchar2
333: ,p_cqb_attribute27 in varchar2 default hr_api.g_varchar2
334: ,p_cqb_attribute28 in varchar2 default hr_api.g_varchar2

Line 331: ,p_cqb_attribute25 in varchar2 default hr_api.g_varchar2

327: ,p_cqb_attribute21 in varchar2 default hr_api.g_varchar2
328: ,p_cqb_attribute22 in varchar2 default hr_api.g_varchar2
329: ,p_cqb_attribute23 in varchar2 default hr_api.g_varchar2
330: ,p_cqb_attribute24 in varchar2 default hr_api.g_varchar2
331: ,p_cqb_attribute25 in varchar2 default hr_api.g_varchar2
332: ,p_cqb_attribute26 in varchar2 default hr_api.g_varchar2
333: ,p_cqb_attribute27 in varchar2 default hr_api.g_varchar2
334: ,p_cqb_attribute28 in varchar2 default hr_api.g_varchar2
335: ,p_cqb_attribute29 in varchar2 default hr_api.g_varchar2

Line 332: ,p_cqb_attribute26 in varchar2 default hr_api.g_varchar2

328: ,p_cqb_attribute22 in varchar2 default hr_api.g_varchar2
329: ,p_cqb_attribute23 in varchar2 default hr_api.g_varchar2
330: ,p_cqb_attribute24 in varchar2 default hr_api.g_varchar2
331: ,p_cqb_attribute25 in varchar2 default hr_api.g_varchar2
332: ,p_cqb_attribute26 in varchar2 default hr_api.g_varchar2
333: ,p_cqb_attribute27 in varchar2 default hr_api.g_varchar2
334: ,p_cqb_attribute28 in varchar2 default hr_api.g_varchar2
335: ,p_cqb_attribute29 in varchar2 default hr_api.g_varchar2
336: ,p_cqb_attribute30 in varchar2 default hr_api.g_varchar2

Line 333: ,p_cqb_attribute27 in varchar2 default hr_api.g_varchar2

329: ,p_cqb_attribute23 in varchar2 default hr_api.g_varchar2
330: ,p_cqb_attribute24 in varchar2 default hr_api.g_varchar2
331: ,p_cqb_attribute25 in varchar2 default hr_api.g_varchar2
332: ,p_cqb_attribute26 in varchar2 default hr_api.g_varchar2
333: ,p_cqb_attribute27 in varchar2 default hr_api.g_varchar2
334: ,p_cqb_attribute28 in varchar2 default hr_api.g_varchar2
335: ,p_cqb_attribute29 in varchar2 default hr_api.g_varchar2
336: ,p_cqb_attribute30 in varchar2 default hr_api.g_varchar2
337: ,p_object_version_number in out nocopy number

Line 334: ,p_cqb_attribute28 in varchar2 default hr_api.g_varchar2

330: ,p_cqb_attribute24 in varchar2 default hr_api.g_varchar2
331: ,p_cqb_attribute25 in varchar2 default hr_api.g_varchar2
332: ,p_cqb_attribute26 in varchar2 default hr_api.g_varchar2
333: ,p_cqb_attribute27 in varchar2 default hr_api.g_varchar2
334: ,p_cqb_attribute28 in varchar2 default hr_api.g_varchar2
335: ,p_cqb_attribute29 in varchar2 default hr_api.g_varchar2
336: ,p_cqb_attribute30 in varchar2 default hr_api.g_varchar2
337: ,p_object_version_number in out nocopy number
338: ,p_effective_date in date

Line 335: ,p_cqb_attribute29 in varchar2 default hr_api.g_varchar2

331: ,p_cqb_attribute25 in varchar2 default hr_api.g_varchar2
332: ,p_cqb_attribute26 in varchar2 default hr_api.g_varchar2
333: ,p_cqb_attribute27 in varchar2 default hr_api.g_varchar2
334: ,p_cqb_attribute28 in varchar2 default hr_api.g_varchar2
335: ,p_cqb_attribute29 in varchar2 default hr_api.g_varchar2
336: ,p_cqb_attribute30 in varchar2 default hr_api.g_varchar2
337: ,p_object_version_number in out nocopy number
338: ,p_effective_date in date
339: ) is

Line 336: ,p_cqb_attribute30 in varchar2 default hr_api.g_varchar2

332: ,p_cqb_attribute26 in varchar2 default hr_api.g_varchar2
333: ,p_cqb_attribute27 in varchar2 default hr_api.g_varchar2
334: ,p_cqb_attribute28 in varchar2 default hr_api.g_varchar2
335: ,p_cqb_attribute29 in varchar2 default hr_api.g_varchar2
336: ,p_cqb_attribute30 in varchar2 default hr_api.g_varchar2
337: ,p_object_version_number in out nocopy number
338: ,p_effective_date in date
339: ) is
340: --

Line 412: when hr_api.cannot_find_prog_unit then

408: ,p_object_version_number => p_object_version_number
409: ,p_effective_date => trunc(p_effective_date)
410: );
411: exception
412: when hr_api.cannot_find_prog_unit then
413: hr_api.cannot_find_prog_unit_error
414: (p_module_name => 'UPDATE_CBR_QUALD_BNF'
415: ,p_hook_type => 'BP'
416: );

Line 413: hr_api.cannot_find_prog_unit_error

409: ,p_effective_date => trunc(p_effective_date)
410: );
411: exception
412: when hr_api.cannot_find_prog_unit then
413: hr_api.cannot_find_prog_unit_error
414: (p_module_name => 'UPDATE_CBR_QUALD_BNF'
415: ,p_hook_type => 'BP'
416: );
417: --

Line 522: when hr_api.cannot_find_prog_unit then

518: ,p_object_version_number => l_object_version_number
519: ,p_effective_date => trunc(p_effective_date)
520: );
521: exception
522: when hr_api.cannot_find_prog_unit then
523: hr_api.cannot_find_prog_unit_error
524: (p_module_name => 'UPDATE_CBR_QUALD_BNF'
525: ,p_hook_type => 'AP'
526: );

Line 523: hr_api.cannot_find_prog_unit_error

519: ,p_effective_date => trunc(p_effective_date)
520: );
521: exception
522: when hr_api.cannot_find_prog_unit then
523: hr_api.cannot_find_prog_unit_error
524: (p_module_name => 'UPDATE_CBR_QUALD_BNF'
525: ,p_hook_type => 'AP'
526: );
527: --

Line 537: raise hr_api.validate_enabled;

533: --
534: -- When in validation only mode raise the Validate_Enabled exception
535: --
536: if p_validate then
537: raise hr_api.validate_enabled;
538: end if;
539: --
540: -- Set all output arguments
541: --

Line 548: when hr_api.validate_enabled then

544: hr_utility.set_location(' Leaving:'||l_proc, 70);
545: --
546: exception
547: --
548: when hr_api.validate_enabled then
549: --
550: -- As the Validate_Enabled exception has been raised
551: -- we must rollback to the savepoint
552: --

Line 611: when hr_api.cannot_find_prog_unit then

607: ,p_object_version_number => p_object_version_number
608: ,p_effective_date => trunc(p_effective_date)
609: );
610: exception
611: when hr_api.cannot_find_prog_unit then
612: hr_api.cannot_find_prog_unit_error
613: (p_module_name => 'DELETE_CBR_QUALD_BNF'
614: ,p_hook_type => 'BP'
615: );

Line 612: hr_api.cannot_find_prog_unit_error

608: ,p_effective_date => trunc(p_effective_date)
609: );
610: exception
611: when hr_api.cannot_find_prog_unit then
612: hr_api.cannot_find_prog_unit_error
613: (p_module_name => 'DELETE_CBR_QUALD_BNF'
614: ,p_hook_type => 'BP'
615: );
616: --

Line 639: when hr_api.cannot_find_prog_unit then

635: ,p_object_version_number => l_object_version_number
636: ,p_effective_date => trunc(p_effective_date)
637: );
638: exception
639: when hr_api.cannot_find_prog_unit then
640: hr_api.cannot_find_prog_unit_error
641: (p_module_name => 'DELETE_CBR_QUALD_BNF'
642: ,p_hook_type => 'AP'
643: );

Line 640: hr_api.cannot_find_prog_unit_error

636: ,p_effective_date => trunc(p_effective_date)
637: );
638: exception
639: when hr_api.cannot_find_prog_unit then
640: hr_api.cannot_find_prog_unit_error
641: (p_module_name => 'DELETE_CBR_QUALD_BNF'
642: ,p_hook_type => 'AP'
643: );
644: --

Line 654: raise hr_api.validate_enabled;

650: --
651: -- When in validation only mode raise the Validate_Enabled exception
652: --
653: if p_validate then
654: raise hr_api.validate_enabled;
655: end if;
656: --
657: hr_utility.set_location(' Leaving:'||l_proc, 70);
658: --

Line 661: when hr_api.validate_enabled then

657: hr_utility.set_location(' Leaving:'||l_proc, 70);
658: --
659: exception
660: --
661: when hr_api.validate_enabled then
662: --
663: -- As the Validate_Enabled exception has been raised
664: -- we must rollback to the savepoint
665: --