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_DESIGN_RQMT_API dependencies on HR_API

Line 134: when hr_api.cannot_find_prog_unit then

130: ,p_ddr_attribute30 => p_ddr_attribute30
131: ,p_effective_date => trunc(p_effective_date)
132: );
133: exception
134: when hr_api.cannot_find_prog_unit then
135: hr_api.cannot_find_prog_unit_error
136: (
137: p_module_name => 'CREATE_design_rqmt'
138: ,p_hook_type => 'BP'

Line 135: hr_api.cannot_find_prog_unit_error

131: ,p_effective_date => trunc(p_effective_date)
132: );
133: exception
134: when hr_api.cannot_find_prog_unit then
135: hr_api.cannot_find_prog_unit_error
136: (
137: p_module_name => 'CREATE_design_rqmt'
138: ,p_hook_type => 'BP'
139: );

Line 251: when hr_api.cannot_find_prog_unit then

247: ,p_object_version_number => l_object_version_number
248: ,p_effective_date => trunc(p_effective_date)
249: );
250: exception
251: when hr_api.cannot_find_prog_unit then
252: hr_api.cannot_find_prog_unit_error
253: (p_module_name => 'CREATE_design_rqmt'
254: ,p_hook_type => 'AP'
255: );

Line 252: hr_api.cannot_find_prog_unit_error

248: ,p_effective_date => trunc(p_effective_date)
249: );
250: exception
251: when hr_api.cannot_find_prog_unit then
252: hr_api.cannot_find_prog_unit_error
253: (p_module_name => 'CREATE_design_rqmt'
254: ,p_hook_type => 'AP'
255: );
256: --

Line 266: raise hr_api.validate_enabled;

262: --
263: -- When in validation only mode raise the Validate_Enabled exception
264: --
265: if p_validate then
266: raise hr_api.validate_enabled;
267: end if;
268: --
269: -- Set all output arguments
270: --

Line 280: when hr_api.validate_enabled then

276: hr_utility.set_location(' Leaving:'||l_proc, 70);
277: --
278: exception
279: --
280: when hr_api.validate_enabled then
281: --
282: -- As the Validate_Enabled exception has been raised
283: -- we must rollback to the savepoint
284: --

Line 320: ,p_mn_dpnts_rqd_num in number default hr_api.g_number

316: (p_validate in boolean default false
317: ,p_dsgn_rqmt_id in number
318: ,p_effective_start_date out nocopy date
319: ,p_effective_end_date out nocopy date
320: ,p_mn_dpnts_rqd_num in number default hr_api.g_number
321: ,p_mx_dpnts_alwd_num in number default hr_api.g_number
322: ,p_no_mn_num_dfnd_flag in varchar2 default hr_api.g_varchar2
323: ,p_no_mx_num_dfnd_flag in varchar2 default hr_api.g_varchar2
324: ,p_cvr_all_elig_flag in varchar2 default hr_api.g_varchar2

Line 321: ,p_mx_dpnts_alwd_num in number default hr_api.g_number

317: ,p_dsgn_rqmt_id in number
318: ,p_effective_start_date out nocopy date
319: ,p_effective_end_date out nocopy date
320: ,p_mn_dpnts_rqd_num in number default hr_api.g_number
321: ,p_mx_dpnts_alwd_num in number default hr_api.g_number
322: ,p_no_mn_num_dfnd_flag in varchar2 default hr_api.g_varchar2
323: ,p_no_mx_num_dfnd_flag in varchar2 default hr_api.g_varchar2
324: ,p_cvr_all_elig_flag in varchar2 default hr_api.g_varchar2
325: ,p_oipl_id in number default hr_api.g_number

Line 322: ,p_no_mn_num_dfnd_flag in varchar2 default hr_api.g_varchar2

318: ,p_effective_start_date out nocopy date
319: ,p_effective_end_date out nocopy date
320: ,p_mn_dpnts_rqd_num in number default hr_api.g_number
321: ,p_mx_dpnts_alwd_num in number default hr_api.g_number
322: ,p_no_mn_num_dfnd_flag in varchar2 default hr_api.g_varchar2
323: ,p_no_mx_num_dfnd_flag in varchar2 default hr_api.g_varchar2
324: ,p_cvr_all_elig_flag in varchar2 default hr_api.g_varchar2
325: ,p_oipl_id in number default hr_api.g_number
326: ,p_pl_id in number default hr_api.g_number

Line 323: ,p_no_mx_num_dfnd_flag in varchar2 default hr_api.g_varchar2

319: ,p_effective_end_date out nocopy date
320: ,p_mn_dpnts_rqd_num in number default hr_api.g_number
321: ,p_mx_dpnts_alwd_num in number default hr_api.g_number
322: ,p_no_mn_num_dfnd_flag in varchar2 default hr_api.g_varchar2
323: ,p_no_mx_num_dfnd_flag in varchar2 default hr_api.g_varchar2
324: ,p_cvr_all_elig_flag in varchar2 default hr_api.g_varchar2
325: ,p_oipl_id in number default hr_api.g_number
326: ,p_pl_id in number default hr_api.g_number
327: ,p_opt_id in number default hr_api.g_number

Line 324: ,p_cvr_all_elig_flag in varchar2 default hr_api.g_varchar2

320: ,p_mn_dpnts_rqd_num in number default hr_api.g_number
321: ,p_mx_dpnts_alwd_num in number default hr_api.g_number
322: ,p_no_mn_num_dfnd_flag in varchar2 default hr_api.g_varchar2
323: ,p_no_mx_num_dfnd_flag in varchar2 default hr_api.g_varchar2
324: ,p_cvr_all_elig_flag in varchar2 default hr_api.g_varchar2
325: ,p_oipl_id in number default hr_api.g_number
326: ,p_pl_id in number default hr_api.g_number
327: ,p_opt_id in number default hr_api.g_number
328: ,p_grp_rlshp_cd in varchar2 default hr_api.g_varchar2

Line 325: ,p_oipl_id in number default hr_api.g_number

321: ,p_mx_dpnts_alwd_num in number default hr_api.g_number
322: ,p_no_mn_num_dfnd_flag in varchar2 default hr_api.g_varchar2
323: ,p_no_mx_num_dfnd_flag in varchar2 default hr_api.g_varchar2
324: ,p_cvr_all_elig_flag in varchar2 default hr_api.g_varchar2
325: ,p_oipl_id in number default hr_api.g_number
326: ,p_pl_id in number default hr_api.g_number
327: ,p_opt_id in number default hr_api.g_number
328: ,p_grp_rlshp_cd in varchar2 default hr_api.g_varchar2
329: ,p_dsgn_typ_cd in varchar2 default hr_api.g_varchar2

Line 326: ,p_pl_id in number default hr_api.g_number

322: ,p_no_mn_num_dfnd_flag in varchar2 default hr_api.g_varchar2
323: ,p_no_mx_num_dfnd_flag in varchar2 default hr_api.g_varchar2
324: ,p_cvr_all_elig_flag in varchar2 default hr_api.g_varchar2
325: ,p_oipl_id in number default hr_api.g_number
326: ,p_pl_id in number default hr_api.g_number
327: ,p_opt_id in number default hr_api.g_number
328: ,p_grp_rlshp_cd in varchar2 default hr_api.g_varchar2
329: ,p_dsgn_typ_cd in varchar2 default hr_api.g_varchar2
330: ,p_business_group_id in number default hr_api.g_number

Line 327: ,p_opt_id in number default hr_api.g_number

323: ,p_no_mx_num_dfnd_flag in varchar2 default hr_api.g_varchar2
324: ,p_cvr_all_elig_flag in varchar2 default hr_api.g_varchar2
325: ,p_oipl_id in number default hr_api.g_number
326: ,p_pl_id in number default hr_api.g_number
327: ,p_opt_id in number default hr_api.g_number
328: ,p_grp_rlshp_cd in varchar2 default hr_api.g_varchar2
329: ,p_dsgn_typ_cd in varchar2 default hr_api.g_varchar2
330: ,p_business_group_id in number default hr_api.g_number
331: ,p_ddr_attribute_category in varchar2 default hr_api.g_varchar2

Line 328: ,p_grp_rlshp_cd in varchar2 default hr_api.g_varchar2

324: ,p_cvr_all_elig_flag in varchar2 default hr_api.g_varchar2
325: ,p_oipl_id in number default hr_api.g_number
326: ,p_pl_id in number default hr_api.g_number
327: ,p_opt_id in number default hr_api.g_number
328: ,p_grp_rlshp_cd in varchar2 default hr_api.g_varchar2
329: ,p_dsgn_typ_cd in varchar2 default hr_api.g_varchar2
330: ,p_business_group_id in number default hr_api.g_number
331: ,p_ddr_attribute_category in varchar2 default hr_api.g_varchar2
332: ,p_ddr_attribute1 in varchar2 default hr_api.g_varchar2

Line 329: ,p_dsgn_typ_cd in varchar2 default hr_api.g_varchar2

325: ,p_oipl_id in number default hr_api.g_number
326: ,p_pl_id in number default hr_api.g_number
327: ,p_opt_id in number default hr_api.g_number
328: ,p_grp_rlshp_cd in varchar2 default hr_api.g_varchar2
329: ,p_dsgn_typ_cd in varchar2 default hr_api.g_varchar2
330: ,p_business_group_id in number default hr_api.g_number
331: ,p_ddr_attribute_category in varchar2 default hr_api.g_varchar2
332: ,p_ddr_attribute1 in varchar2 default hr_api.g_varchar2
333: ,p_ddr_attribute2 in varchar2 default hr_api.g_varchar2

Line 330: ,p_business_group_id in number default hr_api.g_number

326: ,p_pl_id in number default hr_api.g_number
327: ,p_opt_id in number default hr_api.g_number
328: ,p_grp_rlshp_cd in varchar2 default hr_api.g_varchar2
329: ,p_dsgn_typ_cd in varchar2 default hr_api.g_varchar2
330: ,p_business_group_id in number default hr_api.g_number
331: ,p_ddr_attribute_category in varchar2 default hr_api.g_varchar2
332: ,p_ddr_attribute1 in varchar2 default hr_api.g_varchar2
333: ,p_ddr_attribute2 in varchar2 default hr_api.g_varchar2
334: ,p_ddr_attribute3 in varchar2 default hr_api.g_varchar2

Line 331: ,p_ddr_attribute_category in varchar2 default hr_api.g_varchar2

327: ,p_opt_id in number default hr_api.g_number
328: ,p_grp_rlshp_cd in varchar2 default hr_api.g_varchar2
329: ,p_dsgn_typ_cd in varchar2 default hr_api.g_varchar2
330: ,p_business_group_id in number default hr_api.g_number
331: ,p_ddr_attribute_category in varchar2 default hr_api.g_varchar2
332: ,p_ddr_attribute1 in varchar2 default hr_api.g_varchar2
333: ,p_ddr_attribute2 in varchar2 default hr_api.g_varchar2
334: ,p_ddr_attribute3 in varchar2 default hr_api.g_varchar2
335: ,p_ddr_attribute4 in varchar2 default hr_api.g_varchar2

Line 332: ,p_ddr_attribute1 in varchar2 default hr_api.g_varchar2

328: ,p_grp_rlshp_cd in varchar2 default hr_api.g_varchar2
329: ,p_dsgn_typ_cd in varchar2 default hr_api.g_varchar2
330: ,p_business_group_id in number default hr_api.g_number
331: ,p_ddr_attribute_category in varchar2 default hr_api.g_varchar2
332: ,p_ddr_attribute1 in varchar2 default hr_api.g_varchar2
333: ,p_ddr_attribute2 in varchar2 default hr_api.g_varchar2
334: ,p_ddr_attribute3 in varchar2 default hr_api.g_varchar2
335: ,p_ddr_attribute4 in varchar2 default hr_api.g_varchar2
336: ,p_ddr_attribute5 in varchar2 default hr_api.g_varchar2

Line 333: ,p_ddr_attribute2 in varchar2 default hr_api.g_varchar2

329: ,p_dsgn_typ_cd in varchar2 default hr_api.g_varchar2
330: ,p_business_group_id in number default hr_api.g_number
331: ,p_ddr_attribute_category in varchar2 default hr_api.g_varchar2
332: ,p_ddr_attribute1 in varchar2 default hr_api.g_varchar2
333: ,p_ddr_attribute2 in varchar2 default hr_api.g_varchar2
334: ,p_ddr_attribute3 in varchar2 default hr_api.g_varchar2
335: ,p_ddr_attribute4 in varchar2 default hr_api.g_varchar2
336: ,p_ddr_attribute5 in varchar2 default hr_api.g_varchar2
337: ,p_ddr_attribute6 in varchar2 default hr_api.g_varchar2

Line 334: ,p_ddr_attribute3 in varchar2 default hr_api.g_varchar2

330: ,p_business_group_id in number default hr_api.g_number
331: ,p_ddr_attribute_category in varchar2 default hr_api.g_varchar2
332: ,p_ddr_attribute1 in varchar2 default hr_api.g_varchar2
333: ,p_ddr_attribute2 in varchar2 default hr_api.g_varchar2
334: ,p_ddr_attribute3 in varchar2 default hr_api.g_varchar2
335: ,p_ddr_attribute4 in varchar2 default hr_api.g_varchar2
336: ,p_ddr_attribute5 in varchar2 default hr_api.g_varchar2
337: ,p_ddr_attribute6 in varchar2 default hr_api.g_varchar2
338: ,p_ddr_attribute7 in varchar2 default hr_api.g_varchar2

Line 335: ,p_ddr_attribute4 in varchar2 default hr_api.g_varchar2

331: ,p_ddr_attribute_category in varchar2 default hr_api.g_varchar2
332: ,p_ddr_attribute1 in varchar2 default hr_api.g_varchar2
333: ,p_ddr_attribute2 in varchar2 default hr_api.g_varchar2
334: ,p_ddr_attribute3 in varchar2 default hr_api.g_varchar2
335: ,p_ddr_attribute4 in varchar2 default hr_api.g_varchar2
336: ,p_ddr_attribute5 in varchar2 default hr_api.g_varchar2
337: ,p_ddr_attribute6 in varchar2 default hr_api.g_varchar2
338: ,p_ddr_attribute7 in varchar2 default hr_api.g_varchar2
339: ,p_ddr_attribute8 in varchar2 default hr_api.g_varchar2

Line 336: ,p_ddr_attribute5 in varchar2 default hr_api.g_varchar2

332: ,p_ddr_attribute1 in varchar2 default hr_api.g_varchar2
333: ,p_ddr_attribute2 in varchar2 default hr_api.g_varchar2
334: ,p_ddr_attribute3 in varchar2 default hr_api.g_varchar2
335: ,p_ddr_attribute4 in varchar2 default hr_api.g_varchar2
336: ,p_ddr_attribute5 in varchar2 default hr_api.g_varchar2
337: ,p_ddr_attribute6 in varchar2 default hr_api.g_varchar2
338: ,p_ddr_attribute7 in varchar2 default hr_api.g_varchar2
339: ,p_ddr_attribute8 in varchar2 default hr_api.g_varchar2
340: ,p_ddr_attribute9 in varchar2 default hr_api.g_varchar2

Line 337: ,p_ddr_attribute6 in varchar2 default hr_api.g_varchar2

333: ,p_ddr_attribute2 in varchar2 default hr_api.g_varchar2
334: ,p_ddr_attribute3 in varchar2 default hr_api.g_varchar2
335: ,p_ddr_attribute4 in varchar2 default hr_api.g_varchar2
336: ,p_ddr_attribute5 in varchar2 default hr_api.g_varchar2
337: ,p_ddr_attribute6 in varchar2 default hr_api.g_varchar2
338: ,p_ddr_attribute7 in varchar2 default hr_api.g_varchar2
339: ,p_ddr_attribute8 in varchar2 default hr_api.g_varchar2
340: ,p_ddr_attribute9 in varchar2 default hr_api.g_varchar2
341: ,p_ddr_attribute10 in varchar2 default hr_api.g_varchar2

Line 338: ,p_ddr_attribute7 in varchar2 default hr_api.g_varchar2

334: ,p_ddr_attribute3 in varchar2 default hr_api.g_varchar2
335: ,p_ddr_attribute4 in varchar2 default hr_api.g_varchar2
336: ,p_ddr_attribute5 in varchar2 default hr_api.g_varchar2
337: ,p_ddr_attribute6 in varchar2 default hr_api.g_varchar2
338: ,p_ddr_attribute7 in varchar2 default hr_api.g_varchar2
339: ,p_ddr_attribute8 in varchar2 default hr_api.g_varchar2
340: ,p_ddr_attribute9 in varchar2 default hr_api.g_varchar2
341: ,p_ddr_attribute10 in varchar2 default hr_api.g_varchar2
342: ,p_ddr_attribute11 in varchar2 default hr_api.g_varchar2

Line 339: ,p_ddr_attribute8 in varchar2 default hr_api.g_varchar2

335: ,p_ddr_attribute4 in varchar2 default hr_api.g_varchar2
336: ,p_ddr_attribute5 in varchar2 default hr_api.g_varchar2
337: ,p_ddr_attribute6 in varchar2 default hr_api.g_varchar2
338: ,p_ddr_attribute7 in varchar2 default hr_api.g_varchar2
339: ,p_ddr_attribute8 in varchar2 default hr_api.g_varchar2
340: ,p_ddr_attribute9 in varchar2 default hr_api.g_varchar2
341: ,p_ddr_attribute10 in varchar2 default hr_api.g_varchar2
342: ,p_ddr_attribute11 in varchar2 default hr_api.g_varchar2
343: ,p_ddr_attribute12 in varchar2 default hr_api.g_varchar2

Line 340: ,p_ddr_attribute9 in varchar2 default hr_api.g_varchar2

336: ,p_ddr_attribute5 in varchar2 default hr_api.g_varchar2
337: ,p_ddr_attribute6 in varchar2 default hr_api.g_varchar2
338: ,p_ddr_attribute7 in varchar2 default hr_api.g_varchar2
339: ,p_ddr_attribute8 in varchar2 default hr_api.g_varchar2
340: ,p_ddr_attribute9 in varchar2 default hr_api.g_varchar2
341: ,p_ddr_attribute10 in varchar2 default hr_api.g_varchar2
342: ,p_ddr_attribute11 in varchar2 default hr_api.g_varchar2
343: ,p_ddr_attribute12 in varchar2 default hr_api.g_varchar2
344: ,p_ddr_attribute13 in varchar2 default hr_api.g_varchar2

Line 341: ,p_ddr_attribute10 in varchar2 default hr_api.g_varchar2

337: ,p_ddr_attribute6 in varchar2 default hr_api.g_varchar2
338: ,p_ddr_attribute7 in varchar2 default hr_api.g_varchar2
339: ,p_ddr_attribute8 in varchar2 default hr_api.g_varchar2
340: ,p_ddr_attribute9 in varchar2 default hr_api.g_varchar2
341: ,p_ddr_attribute10 in varchar2 default hr_api.g_varchar2
342: ,p_ddr_attribute11 in varchar2 default hr_api.g_varchar2
343: ,p_ddr_attribute12 in varchar2 default hr_api.g_varchar2
344: ,p_ddr_attribute13 in varchar2 default hr_api.g_varchar2
345: ,p_ddr_attribute14 in varchar2 default hr_api.g_varchar2

Line 342: ,p_ddr_attribute11 in varchar2 default hr_api.g_varchar2

338: ,p_ddr_attribute7 in varchar2 default hr_api.g_varchar2
339: ,p_ddr_attribute8 in varchar2 default hr_api.g_varchar2
340: ,p_ddr_attribute9 in varchar2 default hr_api.g_varchar2
341: ,p_ddr_attribute10 in varchar2 default hr_api.g_varchar2
342: ,p_ddr_attribute11 in varchar2 default hr_api.g_varchar2
343: ,p_ddr_attribute12 in varchar2 default hr_api.g_varchar2
344: ,p_ddr_attribute13 in varchar2 default hr_api.g_varchar2
345: ,p_ddr_attribute14 in varchar2 default hr_api.g_varchar2
346: ,p_ddr_attribute15 in varchar2 default hr_api.g_varchar2

Line 343: ,p_ddr_attribute12 in varchar2 default hr_api.g_varchar2

339: ,p_ddr_attribute8 in varchar2 default hr_api.g_varchar2
340: ,p_ddr_attribute9 in varchar2 default hr_api.g_varchar2
341: ,p_ddr_attribute10 in varchar2 default hr_api.g_varchar2
342: ,p_ddr_attribute11 in varchar2 default hr_api.g_varchar2
343: ,p_ddr_attribute12 in varchar2 default hr_api.g_varchar2
344: ,p_ddr_attribute13 in varchar2 default hr_api.g_varchar2
345: ,p_ddr_attribute14 in varchar2 default hr_api.g_varchar2
346: ,p_ddr_attribute15 in varchar2 default hr_api.g_varchar2
347: ,p_ddr_attribute16 in varchar2 default hr_api.g_varchar2

Line 344: ,p_ddr_attribute13 in varchar2 default hr_api.g_varchar2

340: ,p_ddr_attribute9 in varchar2 default hr_api.g_varchar2
341: ,p_ddr_attribute10 in varchar2 default hr_api.g_varchar2
342: ,p_ddr_attribute11 in varchar2 default hr_api.g_varchar2
343: ,p_ddr_attribute12 in varchar2 default hr_api.g_varchar2
344: ,p_ddr_attribute13 in varchar2 default hr_api.g_varchar2
345: ,p_ddr_attribute14 in varchar2 default hr_api.g_varchar2
346: ,p_ddr_attribute15 in varchar2 default hr_api.g_varchar2
347: ,p_ddr_attribute16 in varchar2 default hr_api.g_varchar2
348: ,p_ddr_attribute17 in varchar2 default hr_api.g_varchar2

Line 345: ,p_ddr_attribute14 in varchar2 default hr_api.g_varchar2

341: ,p_ddr_attribute10 in varchar2 default hr_api.g_varchar2
342: ,p_ddr_attribute11 in varchar2 default hr_api.g_varchar2
343: ,p_ddr_attribute12 in varchar2 default hr_api.g_varchar2
344: ,p_ddr_attribute13 in varchar2 default hr_api.g_varchar2
345: ,p_ddr_attribute14 in varchar2 default hr_api.g_varchar2
346: ,p_ddr_attribute15 in varchar2 default hr_api.g_varchar2
347: ,p_ddr_attribute16 in varchar2 default hr_api.g_varchar2
348: ,p_ddr_attribute17 in varchar2 default hr_api.g_varchar2
349: ,p_ddr_attribute18 in varchar2 default hr_api.g_varchar2

Line 346: ,p_ddr_attribute15 in varchar2 default hr_api.g_varchar2

342: ,p_ddr_attribute11 in varchar2 default hr_api.g_varchar2
343: ,p_ddr_attribute12 in varchar2 default hr_api.g_varchar2
344: ,p_ddr_attribute13 in varchar2 default hr_api.g_varchar2
345: ,p_ddr_attribute14 in varchar2 default hr_api.g_varchar2
346: ,p_ddr_attribute15 in varchar2 default hr_api.g_varchar2
347: ,p_ddr_attribute16 in varchar2 default hr_api.g_varchar2
348: ,p_ddr_attribute17 in varchar2 default hr_api.g_varchar2
349: ,p_ddr_attribute18 in varchar2 default hr_api.g_varchar2
350: ,p_ddr_attribute19 in varchar2 default hr_api.g_varchar2

Line 347: ,p_ddr_attribute16 in varchar2 default hr_api.g_varchar2

343: ,p_ddr_attribute12 in varchar2 default hr_api.g_varchar2
344: ,p_ddr_attribute13 in varchar2 default hr_api.g_varchar2
345: ,p_ddr_attribute14 in varchar2 default hr_api.g_varchar2
346: ,p_ddr_attribute15 in varchar2 default hr_api.g_varchar2
347: ,p_ddr_attribute16 in varchar2 default hr_api.g_varchar2
348: ,p_ddr_attribute17 in varchar2 default hr_api.g_varchar2
349: ,p_ddr_attribute18 in varchar2 default hr_api.g_varchar2
350: ,p_ddr_attribute19 in varchar2 default hr_api.g_varchar2
351: ,p_ddr_attribute20 in varchar2 default hr_api.g_varchar2

Line 348: ,p_ddr_attribute17 in varchar2 default hr_api.g_varchar2

344: ,p_ddr_attribute13 in varchar2 default hr_api.g_varchar2
345: ,p_ddr_attribute14 in varchar2 default hr_api.g_varchar2
346: ,p_ddr_attribute15 in varchar2 default hr_api.g_varchar2
347: ,p_ddr_attribute16 in varchar2 default hr_api.g_varchar2
348: ,p_ddr_attribute17 in varchar2 default hr_api.g_varchar2
349: ,p_ddr_attribute18 in varchar2 default hr_api.g_varchar2
350: ,p_ddr_attribute19 in varchar2 default hr_api.g_varchar2
351: ,p_ddr_attribute20 in varchar2 default hr_api.g_varchar2
352: ,p_ddr_attribute21 in varchar2 default hr_api.g_varchar2

Line 349: ,p_ddr_attribute18 in varchar2 default hr_api.g_varchar2

345: ,p_ddr_attribute14 in varchar2 default hr_api.g_varchar2
346: ,p_ddr_attribute15 in varchar2 default hr_api.g_varchar2
347: ,p_ddr_attribute16 in varchar2 default hr_api.g_varchar2
348: ,p_ddr_attribute17 in varchar2 default hr_api.g_varchar2
349: ,p_ddr_attribute18 in varchar2 default hr_api.g_varchar2
350: ,p_ddr_attribute19 in varchar2 default hr_api.g_varchar2
351: ,p_ddr_attribute20 in varchar2 default hr_api.g_varchar2
352: ,p_ddr_attribute21 in varchar2 default hr_api.g_varchar2
353: ,p_ddr_attribute22 in varchar2 default hr_api.g_varchar2

Line 350: ,p_ddr_attribute19 in varchar2 default hr_api.g_varchar2

346: ,p_ddr_attribute15 in varchar2 default hr_api.g_varchar2
347: ,p_ddr_attribute16 in varchar2 default hr_api.g_varchar2
348: ,p_ddr_attribute17 in varchar2 default hr_api.g_varchar2
349: ,p_ddr_attribute18 in varchar2 default hr_api.g_varchar2
350: ,p_ddr_attribute19 in varchar2 default hr_api.g_varchar2
351: ,p_ddr_attribute20 in varchar2 default hr_api.g_varchar2
352: ,p_ddr_attribute21 in varchar2 default hr_api.g_varchar2
353: ,p_ddr_attribute22 in varchar2 default hr_api.g_varchar2
354: ,p_ddr_attribute23 in varchar2 default hr_api.g_varchar2

Line 351: ,p_ddr_attribute20 in varchar2 default hr_api.g_varchar2

347: ,p_ddr_attribute16 in varchar2 default hr_api.g_varchar2
348: ,p_ddr_attribute17 in varchar2 default hr_api.g_varchar2
349: ,p_ddr_attribute18 in varchar2 default hr_api.g_varchar2
350: ,p_ddr_attribute19 in varchar2 default hr_api.g_varchar2
351: ,p_ddr_attribute20 in varchar2 default hr_api.g_varchar2
352: ,p_ddr_attribute21 in varchar2 default hr_api.g_varchar2
353: ,p_ddr_attribute22 in varchar2 default hr_api.g_varchar2
354: ,p_ddr_attribute23 in varchar2 default hr_api.g_varchar2
355: ,p_ddr_attribute24 in varchar2 default hr_api.g_varchar2

Line 352: ,p_ddr_attribute21 in varchar2 default hr_api.g_varchar2

348: ,p_ddr_attribute17 in varchar2 default hr_api.g_varchar2
349: ,p_ddr_attribute18 in varchar2 default hr_api.g_varchar2
350: ,p_ddr_attribute19 in varchar2 default hr_api.g_varchar2
351: ,p_ddr_attribute20 in varchar2 default hr_api.g_varchar2
352: ,p_ddr_attribute21 in varchar2 default hr_api.g_varchar2
353: ,p_ddr_attribute22 in varchar2 default hr_api.g_varchar2
354: ,p_ddr_attribute23 in varchar2 default hr_api.g_varchar2
355: ,p_ddr_attribute24 in varchar2 default hr_api.g_varchar2
356: ,p_ddr_attribute25 in varchar2 default hr_api.g_varchar2

Line 353: ,p_ddr_attribute22 in varchar2 default hr_api.g_varchar2

349: ,p_ddr_attribute18 in varchar2 default hr_api.g_varchar2
350: ,p_ddr_attribute19 in varchar2 default hr_api.g_varchar2
351: ,p_ddr_attribute20 in varchar2 default hr_api.g_varchar2
352: ,p_ddr_attribute21 in varchar2 default hr_api.g_varchar2
353: ,p_ddr_attribute22 in varchar2 default hr_api.g_varchar2
354: ,p_ddr_attribute23 in varchar2 default hr_api.g_varchar2
355: ,p_ddr_attribute24 in varchar2 default hr_api.g_varchar2
356: ,p_ddr_attribute25 in varchar2 default hr_api.g_varchar2
357: ,p_ddr_attribute26 in varchar2 default hr_api.g_varchar2

Line 354: ,p_ddr_attribute23 in varchar2 default hr_api.g_varchar2

350: ,p_ddr_attribute19 in varchar2 default hr_api.g_varchar2
351: ,p_ddr_attribute20 in varchar2 default hr_api.g_varchar2
352: ,p_ddr_attribute21 in varchar2 default hr_api.g_varchar2
353: ,p_ddr_attribute22 in varchar2 default hr_api.g_varchar2
354: ,p_ddr_attribute23 in varchar2 default hr_api.g_varchar2
355: ,p_ddr_attribute24 in varchar2 default hr_api.g_varchar2
356: ,p_ddr_attribute25 in varchar2 default hr_api.g_varchar2
357: ,p_ddr_attribute26 in varchar2 default hr_api.g_varchar2
358: ,p_ddr_attribute27 in varchar2 default hr_api.g_varchar2

Line 355: ,p_ddr_attribute24 in varchar2 default hr_api.g_varchar2

351: ,p_ddr_attribute20 in varchar2 default hr_api.g_varchar2
352: ,p_ddr_attribute21 in varchar2 default hr_api.g_varchar2
353: ,p_ddr_attribute22 in varchar2 default hr_api.g_varchar2
354: ,p_ddr_attribute23 in varchar2 default hr_api.g_varchar2
355: ,p_ddr_attribute24 in varchar2 default hr_api.g_varchar2
356: ,p_ddr_attribute25 in varchar2 default hr_api.g_varchar2
357: ,p_ddr_attribute26 in varchar2 default hr_api.g_varchar2
358: ,p_ddr_attribute27 in varchar2 default hr_api.g_varchar2
359: ,p_ddr_attribute28 in varchar2 default hr_api.g_varchar2

Line 356: ,p_ddr_attribute25 in varchar2 default hr_api.g_varchar2

352: ,p_ddr_attribute21 in varchar2 default hr_api.g_varchar2
353: ,p_ddr_attribute22 in varchar2 default hr_api.g_varchar2
354: ,p_ddr_attribute23 in varchar2 default hr_api.g_varchar2
355: ,p_ddr_attribute24 in varchar2 default hr_api.g_varchar2
356: ,p_ddr_attribute25 in varchar2 default hr_api.g_varchar2
357: ,p_ddr_attribute26 in varchar2 default hr_api.g_varchar2
358: ,p_ddr_attribute27 in varchar2 default hr_api.g_varchar2
359: ,p_ddr_attribute28 in varchar2 default hr_api.g_varchar2
360: ,p_ddr_attribute29 in varchar2 default hr_api.g_varchar2

Line 357: ,p_ddr_attribute26 in varchar2 default hr_api.g_varchar2

353: ,p_ddr_attribute22 in varchar2 default hr_api.g_varchar2
354: ,p_ddr_attribute23 in varchar2 default hr_api.g_varchar2
355: ,p_ddr_attribute24 in varchar2 default hr_api.g_varchar2
356: ,p_ddr_attribute25 in varchar2 default hr_api.g_varchar2
357: ,p_ddr_attribute26 in varchar2 default hr_api.g_varchar2
358: ,p_ddr_attribute27 in varchar2 default hr_api.g_varchar2
359: ,p_ddr_attribute28 in varchar2 default hr_api.g_varchar2
360: ,p_ddr_attribute29 in varchar2 default hr_api.g_varchar2
361: ,p_ddr_attribute30 in varchar2 default hr_api.g_varchar2

Line 358: ,p_ddr_attribute27 in varchar2 default hr_api.g_varchar2

354: ,p_ddr_attribute23 in varchar2 default hr_api.g_varchar2
355: ,p_ddr_attribute24 in varchar2 default hr_api.g_varchar2
356: ,p_ddr_attribute25 in varchar2 default hr_api.g_varchar2
357: ,p_ddr_attribute26 in varchar2 default hr_api.g_varchar2
358: ,p_ddr_attribute27 in varchar2 default hr_api.g_varchar2
359: ,p_ddr_attribute28 in varchar2 default hr_api.g_varchar2
360: ,p_ddr_attribute29 in varchar2 default hr_api.g_varchar2
361: ,p_ddr_attribute30 in varchar2 default hr_api.g_varchar2
362: ,p_object_version_number in out nocopy number

Line 359: ,p_ddr_attribute28 in varchar2 default hr_api.g_varchar2

355: ,p_ddr_attribute24 in varchar2 default hr_api.g_varchar2
356: ,p_ddr_attribute25 in varchar2 default hr_api.g_varchar2
357: ,p_ddr_attribute26 in varchar2 default hr_api.g_varchar2
358: ,p_ddr_attribute27 in varchar2 default hr_api.g_varchar2
359: ,p_ddr_attribute28 in varchar2 default hr_api.g_varchar2
360: ,p_ddr_attribute29 in varchar2 default hr_api.g_varchar2
361: ,p_ddr_attribute30 in varchar2 default hr_api.g_varchar2
362: ,p_object_version_number in out nocopy number
363: ,p_effective_date in date

Line 360: ,p_ddr_attribute29 in varchar2 default hr_api.g_varchar2

356: ,p_ddr_attribute25 in varchar2 default hr_api.g_varchar2
357: ,p_ddr_attribute26 in varchar2 default hr_api.g_varchar2
358: ,p_ddr_attribute27 in varchar2 default hr_api.g_varchar2
359: ,p_ddr_attribute28 in varchar2 default hr_api.g_varchar2
360: ,p_ddr_attribute29 in varchar2 default hr_api.g_varchar2
361: ,p_ddr_attribute30 in varchar2 default hr_api.g_varchar2
362: ,p_object_version_number in out nocopy number
363: ,p_effective_date in date
364: ,p_datetrack_mode in varchar2

Line 361: ,p_ddr_attribute30 in varchar2 default hr_api.g_varchar2

357: ,p_ddr_attribute26 in varchar2 default hr_api.g_varchar2
358: ,p_ddr_attribute27 in varchar2 default hr_api.g_varchar2
359: ,p_ddr_attribute28 in varchar2 default hr_api.g_varchar2
360: ,p_ddr_attribute29 in varchar2 default hr_api.g_varchar2
361: ,p_ddr_attribute30 in varchar2 default hr_api.g_varchar2
362: ,p_object_version_number in out nocopy number
363: ,p_effective_date in date
364: ,p_datetrack_mode in varchar2
365: ) is

Line 442: when hr_api.cannot_find_prog_unit then

438: ,p_effective_date => trunc(p_effective_date)
439: ,p_datetrack_mode => p_datetrack_mode
440: );
441: exception
442: when hr_api.cannot_find_prog_unit then
443: hr_api.cannot_find_prog_unit_error
444: (p_module_name => 'UPDATE_design_rqmt'
445: ,p_hook_type => 'BP'
446: );

Line 443: hr_api.cannot_find_prog_unit_error

439: ,p_datetrack_mode => p_datetrack_mode
440: );
441: exception
442: when hr_api.cannot_find_prog_unit then
443: hr_api.cannot_find_prog_unit_error
444: (p_module_name => 'UPDATE_design_rqmt'
445: ,p_hook_type => 'BP'
446: );
447: --

Line 560: when hr_api.cannot_find_prog_unit then

556: ,p_effective_date => trunc(p_effective_date)
557: ,p_datetrack_mode => p_datetrack_mode
558: );
559: exception
560: when hr_api.cannot_find_prog_unit then
561: hr_api.cannot_find_prog_unit_error
562: (p_module_name => 'UPDATE_design_rqmt'
563: ,p_hook_type => 'AP'
564: );

Line 561: hr_api.cannot_find_prog_unit_error

557: ,p_datetrack_mode => p_datetrack_mode
558: );
559: exception
560: when hr_api.cannot_find_prog_unit then
561: hr_api.cannot_find_prog_unit_error
562: (p_module_name => 'UPDATE_design_rqmt'
563: ,p_hook_type => 'AP'
564: );
565: --

Line 575: raise hr_api.validate_enabled;

571: --
572: -- When in validation only mode raise the Validate_Enabled exception
573: --
574: if p_validate then
575: raise hr_api.validate_enabled;
576: end if;
577: --
578: -- Set all output arguments
579: --

Line 588: when hr_api.validate_enabled then

584: hr_utility.set_location(' Leaving:'||l_proc, 70);
585: --
586: exception
587: --
588: when hr_api.validate_enabled then
589: --
590: -- As the Validate_Enabled exception has been raised
591: -- we must rollback to the savepoint
592: --

Line 667: when hr_api.cannot_find_prog_unit then

663: ,p_effective_date => trunc(p_effective_date)
664: ,p_datetrack_mode => p_datetrack_mode
665: );
666: exception
667: when hr_api.cannot_find_prog_unit then
668: hr_api.cannot_find_prog_unit_error
669: (p_module_name => 'DELETE_design_rqmt'
670: ,p_hook_type => 'BP'
671: );

Line 668: hr_api.cannot_find_prog_unit_error

664: ,p_datetrack_mode => p_datetrack_mode
665: );
666: exception
667: when hr_api.cannot_find_prog_unit then
668: hr_api.cannot_find_prog_unit_error
669: (p_module_name => 'DELETE_design_rqmt'
670: ,p_hook_type => 'BP'
671: );
672: --

Line 701: when hr_api.cannot_find_prog_unit then

697: ,p_effective_date => trunc(p_effective_date)
698: ,p_datetrack_mode => p_datetrack_mode
699: );
700: exception
701: when hr_api.cannot_find_prog_unit then
702: hr_api.cannot_find_prog_unit_error
703: (p_module_name => 'DELETE_design_rqmt'
704: ,p_hook_type => 'AP'
705: );

Line 702: hr_api.cannot_find_prog_unit_error

698: ,p_datetrack_mode => p_datetrack_mode
699: );
700: exception
701: when hr_api.cannot_find_prog_unit then
702: hr_api.cannot_find_prog_unit_error
703: (p_module_name => 'DELETE_design_rqmt'
704: ,p_hook_type => 'AP'
705: );
706: --

Line 716: raise hr_api.validate_enabled;

712: --
713: -- When in validation only mode raise the Validate_Enabled exception
714: --
715: if p_validate then
716: raise hr_api.validate_enabled;
717: end if;
718: --
719: hr_utility.set_location(' Leaving:'||l_proc, 70);
720: --

Line 723: when hr_api.validate_enabled then

719: hr_utility.set_location(' Leaving:'||l_proc, 70);
720: --
721: exception
722: --
723: when hr_api.validate_enabled then
724: --
725: -- As the Validate_Enabled exception has been raised
726: -- we must rollback to the savepoint
727: --