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

Line 128: when hr_api.cannot_find_prog_unit then

124: ,p_ctfn_rqd_when_rl => p_ctfn_rqd_when_rl
125: ,p_rqd_flag => p_rqd_flag
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_plan_goods_serv_cert'
132: ,p_hook_type => 'BP'

Line 129: hr_api.cannot_find_prog_unit_error

125: ,p_rqd_flag => p_rqd_flag
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_plan_goods_serv_cert'
132: ,p_hook_type => 'BP'
133: );

Line 239: when hr_api.cannot_find_prog_unit then

235: ,p_ctfn_rqd_when_rl => p_ctfn_rqd_when_rl
236: ,p_rqd_flag => p_rqd_flag
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_plan_goods_serv_cert'
242: ,p_hook_type => 'AP'
243: );

Line 240: hr_api.cannot_find_prog_unit_error

236: ,p_rqd_flag => p_rqd_flag
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_plan_goods_serv_cert'
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 268: when hr_api.validate_enabled then

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

Line 309: ,p_business_group_id in number default hr_api.g_number

305: (p_validate in boolean default false
306: ,p_pl_gd_r_svc_ctfn_id in number
307: ,p_effective_start_date out nocopy date
308: ,p_effective_end_date out nocopy date
309: ,p_business_group_id in number default hr_api.g_number
310: ,p_pl_gd_or_svc_id in number default hr_api.g_number
311: ,p_pfd_flag in varchar2 default hr_api.g_varchar2
312: ,p_lack_ctfn_deny_rmbmt_flag in varchar2 default hr_api.g_varchar2
313: ,p_rmbmt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2

Line 310: ,p_pl_gd_or_svc_id in number default hr_api.g_number

306: ,p_pl_gd_r_svc_ctfn_id in number
307: ,p_effective_start_date out nocopy date
308: ,p_effective_end_date out nocopy date
309: ,p_business_group_id in number default hr_api.g_number
310: ,p_pl_gd_or_svc_id in number default hr_api.g_number
311: ,p_pfd_flag in varchar2 default hr_api.g_varchar2
312: ,p_lack_ctfn_deny_rmbmt_flag in varchar2 default hr_api.g_varchar2
313: ,p_rmbmt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
314: ,p_lack_ctfn_deny_rmbmt_rl in number default hr_api.g_number

Line 311: ,p_pfd_flag in varchar2 default hr_api.g_varchar2

307: ,p_effective_start_date out nocopy date
308: ,p_effective_end_date out nocopy date
309: ,p_business_group_id in number default hr_api.g_number
310: ,p_pl_gd_or_svc_id in number default hr_api.g_number
311: ,p_pfd_flag in varchar2 default hr_api.g_varchar2
312: ,p_lack_ctfn_deny_rmbmt_flag in varchar2 default hr_api.g_varchar2
313: ,p_rmbmt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
314: ,p_lack_ctfn_deny_rmbmt_rl in number default hr_api.g_number
315: ,p_pct_attribute_category in varchar2 default hr_api.g_varchar2

Line 312: ,p_lack_ctfn_deny_rmbmt_flag in varchar2 default hr_api.g_varchar2

308: ,p_effective_end_date out nocopy date
309: ,p_business_group_id in number default hr_api.g_number
310: ,p_pl_gd_or_svc_id in number default hr_api.g_number
311: ,p_pfd_flag in varchar2 default hr_api.g_varchar2
312: ,p_lack_ctfn_deny_rmbmt_flag in varchar2 default hr_api.g_varchar2
313: ,p_rmbmt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
314: ,p_lack_ctfn_deny_rmbmt_rl in number default hr_api.g_number
315: ,p_pct_attribute_category in varchar2 default hr_api.g_varchar2
316: ,p_pct_attribute1 in varchar2 default hr_api.g_varchar2

Line 313: ,p_rmbmt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2

309: ,p_business_group_id in number default hr_api.g_number
310: ,p_pl_gd_or_svc_id in number default hr_api.g_number
311: ,p_pfd_flag in varchar2 default hr_api.g_varchar2
312: ,p_lack_ctfn_deny_rmbmt_flag in varchar2 default hr_api.g_varchar2
313: ,p_rmbmt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
314: ,p_lack_ctfn_deny_rmbmt_rl in number default hr_api.g_number
315: ,p_pct_attribute_category in varchar2 default hr_api.g_varchar2
316: ,p_pct_attribute1 in varchar2 default hr_api.g_varchar2
317: ,p_pct_attribute2 in varchar2 default hr_api.g_varchar2

Line 314: ,p_lack_ctfn_deny_rmbmt_rl in number default hr_api.g_number

310: ,p_pl_gd_or_svc_id in number default hr_api.g_number
311: ,p_pfd_flag in varchar2 default hr_api.g_varchar2
312: ,p_lack_ctfn_deny_rmbmt_flag in varchar2 default hr_api.g_varchar2
313: ,p_rmbmt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
314: ,p_lack_ctfn_deny_rmbmt_rl in number default hr_api.g_number
315: ,p_pct_attribute_category in varchar2 default hr_api.g_varchar2
316: ,p_pct_attribute1 in varchar2 default hr_api.g_varchar2
317: ,p_pct_attribute2 in varchar2 default hr_api.g_varchar2
318: ,p_pct_attribute3 in varchar2 default hr_api.g_varchar2

Line 315: ,p_pct_attribute_category in varchar2 default hr_api.g_varchar2

311: ,p_pfd_flag in varchar2 default hr_api.g_varchar2
312: ,p_lack_ctfn_deny_rmbmt_flag in varchar2 default hr_api.g_varchar2
313: ,p_rmbmt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
314: ,p_lack_ctfn_deny_rmbmt_rl in number default hr_api.g_number
315: ,p_pct_attribute_category in varchar2 default hr_api.g_varchar2
316: ,p_pct_attribute1 in varchar2 default hr_api.g_varchar2
317: ,p_pct_attribute2 in varchar2 default hr_api.g_varchar2
318: ,p_pct_attribute3 in varchar2 default hr_api.g_varchar2
319: ,p_pct_attribute4 in varchar2 default hr_api.g_varchar2

Line 316: ,p_pct_attribute1 in varchar2 default hr_api.g_varchar2

312: ,p_lack_ctfn_deny_rmbmt_flag in varchar2 default hr_api.g_varchar2
313: ,p_rmbmt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
314: ,p_lack_ctfn_deny_rmbmt_rl in number default hr_api.g_number
315: ,p_pct_attribute_category in varchar2 default hr_api.g_varchar2
316: ,p_pct_attribute1 in varchar2 default hr_api.g_varchar2
317: ,p_pct_attribute2 in varchar2 default hr_api.g_varchar2
318: ,p_pct_attribute3 in varchar2 default hr_api.g_varchar2
319: ,p_pct_attribute4 in varchar2 default hr_api.g_varchar2
320: ,p_pct_attribute5 in varchar2 default hr_api.g_varchar2

Line 317: ,p_pct_attribute2 in varchar2 default hr_api.g_varchar2

313: ,p_rmbmt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
314: ,p_lack_ctfn_deny_rmbmt_rl in number default hr_api.g_number
315: ,p_pct_attribute_category in varchar2 default hr_api.g_varchar2
316: ,p_pct_attribute1 in varchar2 default hr_api.g_varchar2
317: ,p_pct_attribute2 in varchar2 default hr_api.g_varchar2
318: ,p_pct_attribute3 in varchar2 default hr_api.g_varchar2
319: ,p_pct_attribute4 in varchar2 default hr_api.g_varchar2
320: ,p_pct_attribute5 in varchar2 default hr_api.g_varchar2
321: ,p_pct_attribute6 in varchar2 default hr_api.g_varchar2

Line 318: ,p_pct_attribute3 in varchar2 default hr_api.g_varchar2

314: ,p_lack_ctfn_deny_rmbmt_rl in number default hr_api.g_number
315: ,p_pct_attribute_category in varchar2 default hr_api.g_varchar2
316: ,p_pct_attribute1 in varchar2 default hr_api.g_varchar2
317: ,p_pct_attribute2 in varchar2 default hr_api.g_varchar2
318: ,p_pct_attribute3 in varchar2 default hr_api.g_varchar2
319: ,p_pct_attribute4 in varchar2 default hr_api.g_varchar2
320: ,p_pct_attribute5 in varchar2 default hr_api.g_varchar2
321: ,p_pct_attribute6 in varchar2 default hr_api.g_varchar2
322: ,p_pct_attribute7 in varchar2 default hr_api.g_varchar2

Line 319: ,p_pct_attribute4 in varchar2 default hr_api.g_varchar2

315: ,p_pct_attribute_category in varchar2 default hr_api.g_varchar2
316: ,p_pct_attribute1 in varchar2 default hr_api.g_varchar2
317: ,p_pct_attribute2 in varchar2 default hr_api.g_varchar2
318: ,p_pct_attribute3 in varchar2 default hr_api.g_varchar2
319: ,p_pct_attribute4 in varchar2 default hr_api.g_varchar2
320: ,p_pct_attribute5 in varchar2 default hr_api.g_varchar2
321: ,p_pct_attribute6 in varchar2 default hr_api.g_varchar2
322: ,p_pct_attribute7 in varchar2 default hr_api.g_varchar2
323: ,p_pct_attribute8 in varchar2 default hr_api.g_varchar2

Line 320: ,p_pct_attribute5 in varchar2 default hr_api.g_varchar2

316: ,p_pct_attribute1 in varchar2 default hr_api.g_varchar2
317: ,p_pct_attribute2 in varchar2 default hr_api.g_varchar2
318: ,p_pct_attribute3 in varchar2 default hr_api.g_varchar2
319: ,p_pct_attribute4 in varchar2 default hr_api.g_varchar2
320: ,p_pct_attribute5 in varchar2 default hr_api.g_varchar2
321: ,p_pct_attribute6 in varchar2 default hr_api.g_varchar2
322: ,p_pct_attribute7 in varchar2 default hr_api.g_varchar2
323: ,p_pct_attribute8 in varchar2 default hr_api.g_varchar2
324: ,p_pct_attribute9 in varchar2 default hr_api.g_varchar2

Line 321: ,p_pct_attribute6 in varchar2 default hr_api.g_varchar2

317: ,p_pct_attribute2 in varchar2 default hr_api.g_varchar2
318: ,p_pct_attribute3 in varchar2 default hr_api.g_varchar2
319: ,p_pct_attribute4 in varchar2 default hr_api.g_varchar2
320: ,p_pct_attribute5 in varchar2 default hr_api.g_varchar2
321: ,p_pct_attribute6 in varchar2 default hr_api.g_varchar2
322: ,p_pct_attribute7 in varchar2 default hr_api.g_varchar2
323: ,p_pct_attribute8 in varchar2 default hr_api.g_varchar2
324: ,p_pct_attribute9 in varchar2 default hr_api.g_varchar2
325: ,p_pct_attribute10 in varchar2 default hr_api.g_varchar2

Line 322: ,p_pct_attribute7 in varchar2 default hr_api.g_varchar2

318: ,p_pct_attribute3 in varchar2 default hr_api.g_varchar2
319: ,p_pct_attribute4 in varchar2 default hr_api.g_varchar2
320: ,p_pct_attribute5 in varchar2 default hr_api.g_varchar2
321: ,p_pct_attribute6 in varchar2 default hr_api.g_varchar2
322: ,p_pct_attribute7 in varchar2 default hr_api.g_varchar2
323: ,p_pct_attribute8 in varchar2 default hr_api.g_varchar2
324: ,p_pct_attribute9 in varchar2 default hr_api.g_varchar2
325: ,p_pct_attribute10 in varchar2 default hr_api.g_varchar2
326: ,p_pct_attribute11 in varchar2 default hr_api.g_varchar2

Line 323: ,p_pct_attribute8 in varchar2 default hr_api.g_varchar2

319: ,p_pct_attribute4 in varchar2 default hr_api.g_varchar2
320: ,p_pct_attribute5 in varchar2 default hr_api.g_varchar2
321: ,p_pct_attribute6 in varchar2 default hr_api.g_varchar2
322: ,p_pct_attribute7 in varchar2 default hr_api.g_varchar2
323: ,p_pct_attribute8 in varchar2 default hr_api.g_varchar2
324: ,p_pct_attribute9 in varchar2 default hr_api.g_varchar2
325: ,p_pct_attribute10 in varchar2 default hr_api.g_varchar2
326: ,p_pct_attribute11 in varchar2 default hr_api.g_varchar2
327: ,p_pct_attribute12 in varchar2 default hr_api.g_varchar2

Line 324: ,p_pct_attribute9 in varchar2 default hr_api.g_varchar2

320: ,p_pct_attribute5 in varchar2 default hr_api.g_varchar2
321: ,p_pct_attribute6 in varchar2 default hr_api.g_varchar2
322: ,p_pct_attribute7 in varchar2 default hr_api.g_varchar2
323: ,p_pct_attribute8 in varchar2 default hr_api.g_varchar2
324: ,p_pct_attribute9 in varchar2 default hr_api.g_varchar2
325: ,p_pct_attribute10 in varchar2 default hr_api.g_varchar2
326: ,p_pct_attribute11 in varchar2 default hr_api.g_varchar2
327: ,p_pct_attribute12 in varchar2 default hr_api.g_varchar2
328: ,p_pct_attribute13 in varchar2 default hr_api.g_varchar2

Line 325: ,p_pct_attribute10 in varchar2 default hr_api.g_varchar2

321: ,p_pct_attribute6 in varchar2 default hr_api.g_varchar2
322: ,p_pct_attribute7 in varchar2 default hr_api.g_varchar2
323: ,p_pct_attribute8 in varchar2 default hr_api.g_varchar2
324: ,p_pct_attribute9 in varchar2 default hr_api.g_varchar2
325: ,p_pct_attribute10 in varchar2 default hr_api.g_varchar2
326: ,p_pct_attribute11 in varchar2 default hr_api.g_varchar2
327: ,p_pct_attribute12 in varchar2 default hr_api.g_varchar2
328: ,p_pct_attribute13 in varchar2 default hr_api.g_varchar2
329: ,p_pct_attribute14 in varchar2 default hr_api.g_varchar2

Line 326: ,p_pct_attribute11 in varchar2 default hr_api.g_varchar2

322: ,p_pct_attribute7 in varchar2 default hr_api.g_varchar2
323: ,p_pct_attribute8 in varchar2 default hr_api.g_varchar2
324: ,p_pct_attribute9 in varchar2 default hr_api.g_varchar2
325: ,p_pct_attribute10 in varchar2 default hr_api.g_varchar2
326: ,p_pct_attribute11 in varchar2 default hr_api.g_varchar2
327: ,p_pct_attribute12 in varchar2 default hr_api.g_varchar2
328: ,p_pct_attribute13 in varchar2 default hr_api.g_varchar2
329: ,p_pct_attribute14 in varchar2 default hr_api.g_varchar2
330: ,p_pct_attribute15 in varchar2 default hr_api.g_varchar2

Line 327: ,p_pct_attribute12 in varchar2 default hr_api.g_varchar2

323: ,p_pct_attribute8 in varchar2 default hr_api.g_varchar2
324: ,p_pct_attribute9 in varchar2 default hr_api.g_varchar2
325: ,p_pct_attribute10 in varchar2 default hr_api.g_varchar2
326: ,p_pct_attribute11 in varchar2 default hr_api.g_varchar2
327: ,p_pct_attribute12 in varchar2 default hr_api.g_varchar2
328: ,p_pct_attribute13 in varchar2 default hr_api.g_varchar2
329: ,p_pct_attribute14 in varchar2 default hr_api.g_varchar2
330: ,p_pct_attribute15 in varchar2 default hr_api.g_varchar2
331: ,p_pct_attribute16 in varchar2 default hr_api.g_varchar2

Line 328: ,p_pct_attribute13 in varchar2 default hr_api.g_varchar2

324: ,p_pct_attribute9 in varchar2 default hr_api.g_varchar2
325: ,p_pct_attribute10 in varchar2 default hr_api.g_varchar2
326: ,p_pct_attribute11 in varchar2 default hr_api.g_varchar2
327: ,p_pct_attribute12 in varchar2 default hr_api.g_varchar2
328: ,p_pct_attribute13 in varchar2 default hr_api.g_varchar2
329: ,p_pct_attribute14 in varchar2 default hr_api.g_varchar2
330: ,p_pct_attribute15 in varchar2 default hr_api.g_varchar2
331: ,p_pct_attribute16 in varchar2 default hr_api.g_varchar2
332: ,p_pct_attribute17 in varchar2 default hr_api.g_varchar2

Line 329: ,p_pct_attribute14 in varchar2 default hr_api.g_varchar2

325: ,p_pct_attribute10 in varchar2 default hr_api.g_varchar2
326: ,p_pct_attribute11 in varchar2 default hr_api.g_varchar2
327: ,p_pct_attribute12 in varchar2 default hr_api.g_varchar2
328: ,p_pct_attribute13 in varchar2 default hr_api.g_varchar2
329: ,p_pct_attribute14 in varchar2 default hr_api.g_varchar2
330: ,p_pct_attribute15 in varchar2 default hr_api.g_varchar2
331: ,p_pct_attribute16 in varchar2 default hr_api.g_varchar2
332: ,p_pct_attribute17 in varchar2 default hr_api.g_varchar2
333: ,p_pct_attribute18 in varchar2 default hr_api.g_varchar2

Line 330: ,p_pct_attribute15 in varchar2 default hr_api.g_varchar2

326: ,p_pct_attribute11 in varchar2 default hr_api.g_varchar2
327: ,p_pct_attribute12 in varchar2 default hr_api.g_varchar2
328: ,p_pct_attribute13 in varchar2 default hr_api.g_varchar2
329: ,p_pct_attribute14 in varchar2 default hr_api.g_varchar2
330: ,p_pct_attribute15 in varchar2 default hr_api.g_varchar2
331: ,p_pct_attribute16 in varchar2 default hr_api.g_varchar2
332: ,p_pct_attribute17 in varchar2 default hr_api.g_varchar2
333: ,p_pct_attribute18 in varchar2 default hr_api.g_varchar2
334: ,p_pct_attribute19 in varchar2 default hr_api.g_varchar2

Line 331: ,p_pct_attribute16 in varchar2 default hr_api.g_varchar2

327: ,p_pct_attribute12 in varchar2 default hr_api.g_varchar2
328: ,p_pct_attribute13 in varchar2 default hr_api.g_varchar2
329: ,p_pct_attribute14 in varchar2 default hr_api.g_varchar2
330: ,p_pct_attribute15 in varchar2 default hr_api.g_varchar2
331: ,p_pct_attribute16 in varchar2 default hr_api.g_varchar2
332: ,p_pct_attribute17 in varchar2 default hr_api.g_varchar2
333: ,p_pct_attribute18 in varchar2 default hr_api.g_varchar2
334: ,p_pct_attribute19 in varchar2 default hr_api.g_varchar2
335: ,p_pct_attribute20 in varchar2 default hr_api.g_varchar2

Line 332: ,p_pct_attribute17 in varchar2 default hr_api.g_varchar2

328: ,p_pct_attribute13 in varchar2 default hr_api.g_varchar2
329: ,p_pct_attribute14 in varchar2 default hr_api.g_varchar2
330: ,p_pct_attribute15 in varchar2 default hr_api.g_varchar2
331: ,p_pct_attribute16 in varchar2 default hr_api.g_varchar2
332: ,p_pct_attribute17 in varchar2 default hr_api.g_varchar2
333: ,p_pct_attribute18 in varchar2 default hr_api.g_varchar2
334: ,p_pct_attribute19 in varchar2 default hr_api.g_varchar2
335: ,p_pct_attribute20 in varchar2 default hr_api.g_varchar2
336: ,p_pct_attribute21 in varchar2 default hr_api.g_varchar2

Line 333: ,p_pct_attribute18 in varchar2 default hr_api.g_varchar2

329: ,p_pct_attribute14 in varchar2 default hr_api.g_varchar2
330: ,p_pct_attribute15 in varchar2 default hr_api.g_varchar2
331: ,p_pct_attribute16 in varchar2 default hr_api.g_varchar2
332: ,p_pct_attribute17 in varchar2 default hr_api.g_varchar2
333: ,p_pct_attribute18 in varchar2 default hr_api.g_varchar2
334: ,p_pct_attribute19 in varchar2 default hr_api.g_varchar2
335: ,p_pct_attribute20 in varchar2 default hr_api.g_varchar2
336: ,p_pct_attribute21 in varchar2 default hr_api.g_varchar2
337: ,p_pct_attribute22 in varchar2 default hr_api.g_varchar2

Line 334: ,p_pct_attribute19 in varchar2 default hr_api.g_varchar2

330: ,p_pct_attribute15 in varchar2 default hr_api.g_varchar2
331: ,p_pct_attribute16 in varchar2 default hr_api.g_varchar2
332: ,p_pct_attribute17 in varchar2 default hr_api.g_varchar2
333: ,p_pct_attribute18 in varchar2 default hr_api.g_varchar2
334: ,p_pct_attribute19 in varchar2 default hr_api.g_varchar2
335: ,p_pct_attribute20 in varchar2 default hr_api.g_varchar2
336: ,p_pct_attribute21 in varchar2 default hr_api.g_varchar2
337: ,p_pct_attribute22 in varchar2 default hr_api.g_varchar2
338: ,p_pct_attribute23 in varchar2 default hr_api.g_varchar2

Line 335: ,p_pct_attribute20 in varchar2 default hr_api.g_varchar2

331: ,p_pct_attribute16 in varchar2 default hr_api.g_varchar2
332: ,p_pct_attribute17 in varchar2 default hr_api.g_varchar2
333: ,p_pct_attribute18 in varchar2 default hr_api.g_varchar2
334: ,p_pct_attribute19 in varchar2 default hr_api.g_varchar2
335: ,p_pct_attribute20 in varchar2 default hr_api.g_varchar2
336: ,p_pct_attribute21 in varchar2 default hr_api.g_varchar2
337: ,p_pct_attribute22 in varchar2 default hr_api.g_varchar2
338: ,p_pct_attribute23 in varchar2 default hr_api.g_varchar2
339: ,p_pct_attribute24 in varchar2 default hr_api.g_varchar2

Line 336: ,p_pct_attribute21 in varchar2 default hr_api.g_varchar2

332: ,p_pct_attribute17 in varchar2 default hr_api.g_varchar2
333: ,p_pct_attribute18 in varchar2 default hr_api.g_varchar2
334: ,p_pct_attribute19 in varchar2 default hr_api.g_varchar2
335: ,p_pct_attribute20 in varchar2 default hr_api.g_varchar2
336: ,p_pct_attribute21 in varchar2 default hr_api.g_varchar2
337: ,p_pct_attribute22 in varchar2 default hr_api.g_varchar2
338: ,p_pct_attribute23 in varchar2 default hr_api.g_varchar2
339: ,p_pct_attribute24 in varchar2 default hr_api.g_varchar2
340: ,p_pct_attribute25 in varchar2 default hr_api.g_varchar2

Line 337: ,p_pct_attribute22 in varchar2 default hr_api.g_varchar2

333: ,p_pct_attribute18 in varchar2 default hr_api.g_varchar2
334: ,p_pct_attribute19 in varchar2 default hr_api.g_varchar2
335: ,p_pct_attribute20 in varchar2 default hr_api.g_varchar2
336: ,p_pct_attribute21 in varchar2 default hr_api.g_varchar2
337: ,p_pct_attribute22 in varchar2 default hr_api.g_varchar2
338: ,p_pct_attribute23 in varchar2 default hr_api.g_varchar2
339: ,p_pct_attribute24 in varchar2 default hr_api.g_varchar2
340: ,p_pct_attribute25 in varchar2 default hr_api.g_varchar2
341: ,p_pct_attribute26 in varchar2 default hr_api.g_varchar2

Line 338: ,p_pct_attribute23 in varchar2 default hr_api.g_varchar2

334: ,p_pct_attribute19 in varchar2 default hr_api.g_varchar2
335: ,p_pct_attribute20 in varchar2 default hr_api.g_varchar2
336: ,p_pct_attribute21 in varchar2 default hr_api.g_varchar2
337: ,p_pct_attribute22 in varchar2 default hr_api.g_varchar2
338: ,p_pct_attribute23 in varchar2 default hr_api.g_varchar2
339: ,p_pct_attribute24 in varchar2 default hr_api.g_varchar2
340: ,p_pct_attribute25 in varchar2 default hr_api.g_varchar2
341: ,p_pct_attribute26 in varchar2 default hr_api.g_varchar2
342: ,p_pct_attribute27 in varchar2 default hr_api.g_varchar2

Line 339: ,p_pct_attribute24 in varchar2 default hr_api.g_varchar2

335: ,p_pct_attribute20 in varchar2 default hr_api.g_varchar2
336: ,p_pct_attribute21 in varchar2 default hr_api.g_varchar2
337: ,p_pct_attribute22 in varchar2 default hr_api.g_varchar2
338: ,p_pct_attribute23 in varchar2 default hr_api.g_varchar2
339: ,p_pct_attribute24 in varchar2 default hr_api.g_varchar2
340: ,p_pct_attribute25 in varchar2 default hr_api.g_varchar2
341: ,p_pct_attribute26 in varchar2 default hr_api.g_varchar2
342: ,p_pct_attribute27 in varchar2 default hr_api.g_varchar2
343: ,p_pct_attribute28 in varchar2 default hr_api.g_varchar2

Line 340: ,p_pct_attribute25 in varchar2 default hr_api.g_varchar2

336: ,p_pct_attribute21 in varchar2 default hr_api.g_varchar2
337: ,p_pct_attribute22 in varchar2 default hr_api.g_varchar2
338: ,p_pct_attribute23 in varchar2 default hr_api.g_varchar2
339: ,p_pct_attribute24 in varchar2 default hr_api.g_varchar2
340: ,p_pct_attribute25 in varchar2 default hr_api.g_varchar2
341: ,p_pct_attribute26 in varchar2 default hr_api.g_varchar2
342: ,p_pct_attribute27 in varchar2 default hr_api.g_varchar2
343: ,p_pct_attribute28 in varchar2 default hr_api.g_varchar2
344: ,p_pct_attribute29 in varchar2 default hr_api.g_varchar2

Line 341: ,p_pct_attribute26 in varchar2 default hr_api.g_varchar2

337: ,p_pct_attribute22 in varchar2 default hr_api.g_varchar2
338: ,p_pct_attribute23 in varchar2 default hr_api.g_varchar2
339: ,p_pct_attribute24 in varchar2 default hr_api.g_varchar2
340: ,p_pct_attribute25 in varchar2 default hr_api.g_varchar2
341: ,p_pct_attribute26 in varchar2 default hr_api.g_varchar2
342: ,p_pct_attribute27 in varchar2 default hr_api.g_varchar2
343: ,p_pct_attribute28 in varchar2 default hr_api.g_varchar2
344: ,p_pct_attribute29 in varchar2 default hr_api.g_varchar2
345: ,p_pct_attribute30 in varchar2 default hr_api.g_varchar2

Line 342: ,p_pct_attribute27 in varchar2 default hr_api.g_varchar2

338: ,p_pct_attribute23 in varchar2 default hr_api.g_varchar2
339: ,p_pct_attribute24 in varchar2 default hr_api.g_varchar2
340: ,p_pct_attribute25 in varchar2 default hr_api.g_varchar2
341: ,p_pct_attribute26 in varchar2 default hr_api.g_varchar2
342: ,p_pct_attribute27 in varchar2 default hr_api.g_varchar2
343: ,p_pct_attribute28 in varchar2 default hr_api.g_varchar2
344: ,p_pct_attribute29 in varchar2 default hr_api.g_varchar2
345: ,p_pct_attribute30 in varchar2 default hr_api.g_varchar2
346: ,p_object_version_number in out nocopy number

Line 343: ,p_pct_attribute28 in varchar2 default hr_api.g_varchar2

339: ,p_pct_attribute24 in varchar2 default hr_api.g_varchar2
340: ,p_pct_attribute25 in varchar2 default hr_api.g_varchar2
341: ,p_pct_attribute26 in varchar2 default hr_api.g_varchar2
342: ,p_pct_attribute27 in varchar2 default hr_api.g_varchar2
343: ,p_pct_attribute28 in varchar2 default hr_api.g_varchar2
344: ,p_pct_attribute29 in varchar2 default hr_api.g_varchar2
345: ,p_pct_attribute30 in varchar2 default hr_api.g_varchar2
346: ,p_object_version_number in out nocopy number
347: ,p_effective_date in date

Line 344: ,p_pct_attribute29 in varchar2 default hr_api.g_varchar2

340: ,p_pct_attribute25 in varchar2 default hr_api.g_varchar2
341: ,p_pct_attribute26 in varchar2 default hr_api.g_varchar2
342: ,p_pct_attribute27 in varchar2 default hr_api.g_varchar2
343: ,p_pct_attribute28 in varchar2 default hr_api.g_varchar2
344: ,p_pct_attribute29 in varchar2 default hr_api.g_varchar2
345: ,p_pct_attribute30 in varchar2 default hr_api.g_varchar2
346: ,p_object_version_number in out nocopy number
347: ,p_effective_date in date
348: ,p_datetrack_mode in varchar2

Line 345: ,p_pct_attribute30 in varchar2 default hr_api.g_varchar2

341: ,p_pct_attribute26 in varchar2 default hr_api.g_varchar2
342: ,p_pct_attribute27 in varchar2 default hr_api.g_varchar2
343: ,p_pct_attribute28 in varchar2 default hr_api.g_varchar2
344: ,p_pct_attribute29 in varchar2 default hr_api.g_varchar2
345: ,p_pct_attribute30 in varchar2 default hr_api.g_varchar2
346: ,p_object_version_number in out nocopy number
347: ,p_effective_date in date
348: ,p_datetrack_mode in varchar2
349: ,p_ctfn_rqd_when_rl in number default hr_api.g_number

Line 349: ,p_ctfn_rqd_when_rl in number default hr_api.g_number

345: ,p_pct_attribute30 in varchar2 default hr_api.g_varchar2
346: ,p_object_version_number in out nocopy number
347: ,p_effective_date in date
348: ,p_datetrack_mode in varchar2
349: ,p_ctfn_rqd_when_rl in number default hr_api.g_number
350: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
351: ) is
352: --
353: -- Declare cursors and local variables

Line 350: ,p_rqd_flag in varchar2 default hr_api.g_varchar2

346: ,p_object_version_number in out nocopy number
347: ,p_effective_date in date
348: ,p_datetrack_mode in varchar2
349: ,p_ctfn_rqd_when_rl in number default hr_api.g_number
350: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
351: ) is
352: --
353: -- Declare cursors and local variables
354: --

Line 425: when hr_api.cannot_find_prog_unit then

421: ,p_ctfn_rqd_when_rl => p_ctfn_rqd_when_rl
422: ,p_rqd_flag => p_rqd_flag
423: );
424: exception
425: when hr_api.cannot_find_prog_unit then
426: hr_api.cannot_find_prog_unit_error
427: (p_module_name => 'UPDATE_plan_goods_serv_cert'
428: ,p_hook_type => 'BP'
429: );

Line 426: hr_api.cannot_find_prog_unit_error

422: ,p_rqd_flag => p_rqd_flag
423: );
424: exception
425: when hr_api.cannot_find_prog_unit then
426: hr_api.cannot_find_prog_unit_error
427: (p_module_name => 'UPDATE_plan_goods_serv_cert'
428: ,p_hook_type => 'BP'
429: );
430: --

Line 537: when hr_api.cannot_find_prog_unit then

533: ,p_ctfn_rqd_when_rl => p_ctfn_rqd_when_rl
534: ,p_rqd_flag => p_rqd_flag
535: );
536: exception
537: when hr_api.cannot_find_prog_unit then
538: hr_api.cannot_find_prog_unit_error
539: (p_module_name => 'UPDATE_plan_goods_serv_cert'
540: ,p_hook_type => 'AP'
541: );

Line 538: hr_api.cannot_find_prog_unit_error

534: ,p_rqd_flag => p_rqd_flag
535: );
536: exception
537: when hr_api.cannot_find_prog_unit then
538: hr_api.cannot_find_prog_unit_error
539: (p_module_name => 'UPDATE_plan_goods_serv_cert'
540: ,p_hook_type => 'AP'
541: );
542: --

Line 552: raise hr_api.validate_enabled;

548: --
549: -- When in validation only mode raise the Validate_Enabled exception
550: --
551: if p_validate then
552: raise hr_api.validate_enabled;
553: end if;
554: --
555: -- Set all output arguments
556: --

Line 565: when hr_api.validate_enabled then

561: hr_utility.set_location(' Leaving:'||l_proc, 70);
562: --
563: exception
564: --
565: when hr_api.validate_enabled then
566: --
567: -- As the Validate_Enabled exception has been raised
568: -- we must rollback to the savepoint
569: --

Line 640: when hr_api.cannot_find_prog_unit then

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

Line 641: hr_api.cannot_find_prog_unit_error

637: ,p_datetrack_mode => p_datetrack_mode
638: );
639: exception
640: when hr_api.cannot_find_prog_unit then
641: hr_api.cannot_find_prog_unit_error
642: (p_module_name => 'DELETE_plan_goods_serv_cert'
643: ,p_hook_type => 'BP'
644: );
645: --

Line 674: when hr_api.cannot_find_prog_unit then

670: ,p_effective_date => trunc(p_effective_date)
671: ,p_datetrack_mode => p_datetrack_mode
672: );
673: exception
674: when hr_api.cannot_find_prog_unit then
675: hr_api.cannot_find_prog_unit_error
676: (p_module_name => 'DELETE_plan_goods_serv_cert'
677: ,p_hook_type => 'AP'
678: );

Line 675: hr_api.cannot_find_prog_unit_error

671: ,p_datetrack_mode => p_datetrack_mode
672: );
673: exception
674: when hr_api.cannot_find_prog_unit then
675: hr_api.cannot_find_prog_unit_error
676: (p_module_name => 'DELETE_plan_goods_serv_cert'
677: ,p_hook_type => 'AP'
678: );
679: --

Line 689: raise hr_api.validate_enabled;

685: --
686: -- When in validation only mode raise the Validate_Enabled exception
687: --
688: if p_validate then
689: raise hr_api.validate_enabled;
690: end if;
691: --
692: hr_utility.set_location(' Leaving:'||l_proc, 70);
693: --

Line 696: when hr_api.validate_enabled then

692: hr_utility.set_location(' Leaving:'||l_proc, 70);
693: --
694: exception
695: --
696: when hr_api.validate_enabled then
697: --
698: -- As the Validate_Enabled exception has been raised
699: -- we must rollback to the savepoint
700: --