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

Line 118: when hr_api.cannot_find_prog_unit then

114: ,p_cmd_attribute30 => p_cmd_attribute30
115: ,p_effective_date => trunc(p_effective_date)
116: );
117: exception
118: when hr_api.cannot_find_prog_unit then
119: hr_api.cannot_find_prog_unit_error
120: (
121: p_module_name => 'CREATE_Comm_Dlvry_Media'
122: ,p_hook_type => 'BP'

Line 119: hr_api.cannot_find_prog_unit_error

115: ,p_effective_date => trunc(p_effective_date)
116: );
117: exception
118: when hr_api.cannot_find_prog_unit then
119: hr_api.cannot_find_prog_unit_error
120: (
121: p_module_name => 'CREATE_Comm_Dlvry_Media'
122: ,p_hook_type => 'BP'
123: );

Line 219: when hr_api.cannot_find_prog_unit then

215: ,p_object_version_number => l_object_version_number
216: ,p_effective_date => trunc(p_effective_date)
217: );
218: exception
219: when hr_api.cannot_find_prog_unit then
220: hr_api.cannot_find_prog_unit_error
221: (p_module_name => 'CREATE_Comm_Dlvry_Media'
222: ,p_hook_type => 'AP'
223: );

Line 220: hr_api.cannot_find_prog_unit_error

216: ,p_effective_date => trunc(p_effective_date)
217: );
218: exception
219: when hr_api.cannot_find_prog_unit then
220: hr_api.cannot_find_prog_unit_error
221: (p_module_name => 'CREATE_Comm_Dlvry_Media'
222: ,p_hook_type => 'AP'
223: );
224: --

Line 234: raise hr_api.validate_enabled;

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

Line 246: when hr_api.validate_enabled then

242: hr_utility.set_location(' Leaving:'||l_proc, 70);
243: --
244: exception
245: --
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 276: ,p_cm_dlvry_med_typ_cd in varchar2 default hr_api.g_varchar2

272: --
273: procedure update_Comm_Dlvry_Media
274: (p_validate in boolean default false
275: ,p_cm_dlvry_med_typ_id in number
276: ,p_cm_dlvry_med_typ_cd in varchar2 default hr_api.g_varchar2
277: ,p_cm_dlvry_mthd_typ_id in number default hr_api.g_number
278: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
279: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
280: ,p_business_group_id in number default hr_api.g_number

Line 277: ,p_cm_dlvry_mthd_typ_id in number default hr_api.g_number

273: procedure update_Comm_Dlvry_Media
274: (p_validate in boolean default false
275: ,p_cm_dlvry_med_typ_id in number
276: ,p_cm_dlvry_med_typ_cd in varchar2 default hr_api.g_varchar2
277: ,p_cm_dlvry_mthd_typ_id in number default hr_api.g_number
278: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
279: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
280: ,p_business_group_id in number default hr_api.g_number
281: ,p_cmd_attribute_category in varchar2 default hr_api.g_varchar2

Line 278: ,p_rqd_flag in varchar2 default hr_api.g_varchar2

274: (p_validate in boolean default false
275: ,p_cm_dlvry_med_typ_id in number
276: ,p_cm_dlvry_med_typ_cd in varchar2 default hr_api.g_varchar2
277: ,p_cm_dlvry_mthd_typ_id in number default hr_api.g_number
278: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
279: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
280: ,p_business_group_id in number default hr_api.g_number
281: ,p_cmd_attribute_category in varchar2 default hr_api.g_varchar2
282: ,p_cmd_attribute1 in varchar2 default hr_api.g_varchar2

Line 279: ,p_dflt_flag in varchar2 default hr_api.g_varchar2

275: ,p_cm_dlvry_med_typ_id in number
276: ,p_cm_dlvry_med_typ_cd in varchar2 default hr_api.g_varchar2
277: ,p_cm_dlvry_mthd_typ_id in number default hr_api.g_number
278: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
279: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
280: ,p_business_group_id in number default hr_api.g_number
281: ,p_cmd_attribute_category in varchar2 default hr_api.g_varchar2
282: ,p_cmd_attribute1 in varchar2 default hr_api.g_varchar2
283: ,p_cmd_attribute2 in varchar2 default hr_api.g_varchar2

Line 280: ,p_business_group_id in number default hr_api.g_number

276: ,p_cm_dlvry_med_typ_cd in varchar2 default hr_api.g_varchar2
277: ,p_cm_dlvry_mthd_typ_id in number default hr_api.g_number
278: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
279: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
280: ,p_business_group_id in number default hr_api.g_number
281: ,p_cmd_attribute_category in varchar2 default hr_api.g_varchar2
282: ,p_cmd_attribute1 in varchar2 default hr_api.g_varchar2
283: ,p_cmd_attribute2 in varchar2 default hr_api.g_varchar2
284: ,p_cmd_attribute3 in varchar2 default hr_api.g_varchar2

Line 281: ,p_cmd_attribute_category in varchar2 default hr_api.g_varchar2

277: ,p_cm_dlvry_mthd_typ_id in number default hr_api.g_number
278: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
279: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
280: ,p_business_group_id in number default hr_api.g_number
281: ,p_cmd_attribute_category in varchar2 default hr_api.g_varchar2
282: ,p_cmd_attribute1 in varchar2 default hr_api.g_varchar2
283: ,p_cmd_attribute2 in varchar2 default hr_api.g_varchar2
284: ,p_cmd_attribute3 in varchar2 default hr_api.g_varchar2
285: ,p_cmd_attribute4 in varchar2 default hr_api.g_varchar2

Line 282: ,p_cmd_attribute1 in varchar2 default hr_api.g_varchar2

278: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
279: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
280: ,p_business_group_id in number default hr_api.g_number
281: ,p_cmd_attribute_category in varchar2 default hr_api.g_varchar2
282: ,p_cmd_attribute1 in varchar2 default hr_api.g_varchar2
283: ,p_cmd_attribute2 in varchar2 default hr_api.g_varchar2
284: ,p_cmd_attribute3 in varchar2 default hr_api.g_varchar2
285: ,p_cmd_attribute4 in varchar2 default hr_api.g_varchar2
286: ,p_cmd_attribute5 in varchar2 default hr_api.g_varchar2

Line 283: ,p_cmd_attribute2 in varchar2 default hr_api.g_varchar2

279: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
280: ,p_business_group_id in number default hr_api.g_number
281: ,p_cmd_attribute_category in varchar2 default hr_api.g_varchar2
282: ,p_cmd_attribute1 in varchar2 default hr_api.g_varchar2
283: ,p_cmd_attribute2 in varchar2 default hr_api.g_varchar2
284: ,p_cmd_attribute3 in varchar2 default hr_api.g_varchar2
285: ,p_cmd_attribute4 in varchar2 default hr_api.g_varchar2
286: ,p_cmd_attribute5 in varchar2 default hr_api.g_varchar2
287: ,p_cmd_attribute6 in varchar2 default hr_api.g_varchar2

Line 284: ,p_cmd_attribute3 in varchar2 default hr_api.g_varchar2

280: ,p_business_group_id in number default hr_api.g_number
281: ,p_cmd_attribute_category in varchar2 default hr_api.g_varchar2
282: ,p_cmd_attribute1 in varchar2 default hr_api.g_varchar2
283: ,p_cmd_attribute2 in varchar2 default hr_api.g_varchar2
284: ,p_cmd_attribute3 in varchar2 default hr_api.g_varchar2
285: ,p_cmd_attribute4 in varchar2 default hr_api.g_varchar2
286: ,p_cmd_attribute5 in varchar2 default hr_api.g_varchar2
287: ,p_cmd_attribute6 in varchar2 default hr_api.g_varchar2
288: ,p_cmd_attribute7 in varchar2 default hr_api.g_varchar2

Line 285: ,p_cmd_attribute4 in varchar2 default hr_api.g_varchar2

281: ,p_cmd_attribute_category in varchar2 default hr_api.g_varchar2
282: ,p_cmd_attribute1 in varchar2 default hr_api.g_varchar2
283: ,p_cmd_attribute2 in varchar2 default hr_api.g_varchar2
284: ,p_cmd_attribute3 in varchar2 default hr_api.g_varchar2
285: ,p_cmd_attribute4 in varchar2 default hr_api.g_varchar2
286: ,p_cmd_attribute5 in varchar2 default hr_api.g_varchar2
287: ,p_cmd_attribute6 in varchar2 default hr_api.g_varchar2
288: ,p_cmd_attribute7 in varchar2 default hr_api.g_varchar2
289: ,p_cmd_attribute8 in varchar2 default hr_api.g_varchar2

Line 286: ,p_cmd_attribute5 in varchar2 default hr_api.g_varchar2

282: ,p_cmd_attribute1 in varchar2 default hr_api.g_varchar2
283: ,p_cmd_attribute2 in varchar2 default hr_api.g_varchar2
284: ,p_cmd_attribute3 in varchar2 default hr_api.g_varchar2
285: ,p_cmd_attribute4 in varchar2 default hr_api.g_varchar2
286: ,p_cmd_attribute5 in varchar2 default hr_api.g_varchar2
287: ,p_cmd_attribute6 in varchar2 default hr_api.g_varchar2
288: ,p_cmd_attribute7 in varchar2 default hr_api.g_varchar2
289: ,p_cmd_attribute8 in varchar2 default hr_api.g_varchar2
290: ,p_cmd_attribute9 in varchar2 default hr_api.g_varchar2

Line 287: ,p_cmd_attribute6 in varchar2 default hr_api.g_varchar2

283: ,p_cmd_attribute2 in varchar2 default hr_api.g_varchar2
284: ,p_cmd_attribute3 in varchar2 default hr_api.g_varchar2
285: ,p_cmd_attribute4 in varchar2 default hr_api.g_varchar2
286: ,p_cmd_attribute5 in varchar2 default hr_api.g_varchar2
287: ,p_cmd_attribute6 in varchar2 default hr_api.g_varchar2
288: ,p_cmd_attribute7 in varchar2 default hr_api.g_varchar2
289: ,p_cmd_attribute8 in varchar2 default hr_api.g_varchar2
290: ,p_cmd_attribute9 in varchar2 default hr_api.g_varchar2
291: ,p_cmd_attribute10 in varchar2 default hr_api.g_varchar2

Line 288: ,p_cmd_attribute7 in varchar2 default hr_api.g_varchar2

284: ,p_cmd_attribute3 in varchar2 default hr_api.g_varchar2
285: ,p_cmd_attribute4 in varchar2 default hr_api.g_varchar2
286: ,p_cmd_attribute5 in varchar2 default hr_api.g_varchar2
287: ,p_cmd_attribute6 in varchar2 default hr_api.g_varchar2
288: ,p_cmd_attribute7 in varchar2 default hr_api.g_varchar2
289: ,p_cmd_attribute8 in varchar2 default hr_api.g_varchar2
290: ,p_cmd_attribute9 in varchar2 default hr_api.g_varchar2
291: ,p_cmd_attribute10 in varchar2 default hr_api.g_varchar2
292: ,p_cmd_attribute11 in varchar2 default hr_api.g_varchar2

Line 289: ,p_cmd_attribute8 in varchar2 default hr_api.g_varchar2

285: ,p_cmd_attribute4 in varchar2 default hr_api.g_varchar2
286: ,p_cmd_attribute5 in varchar2 default hr_api.g_varchar2
287: ,p_cmd_attribute6 in varchar2 default hr_api.g_varchar2
288: ,p_cmd_attribute7 in varchar2 default hr_api.g_varchar2
289: ,p_cmd_attribute8 in varchar2 default hr_api.g_varchar2
290: ,p_cmd_attribute9 in varchar2 default hr_api.g_varchar2
291: ,p_cmd_attribute10 in varchar2 default hr_api.g_varchar2
292: ,p_cmd_attribute11 in varchar2 default hr_api.g_varchar2
293: ,p_cmd_attribute12 in varchar2 default hr_api.g_varchar2

Line 290: ,p_cmd_attribute9 in varchar2 default hr_api.g_varchar2

286: ,p_cmd_attribute5 in varchar2 default hr_api.g_varchar2
287: ,p_cmd_attribute6 in varchar2 default hr_api.g_varchar2
288: ,p_cmd_attribute7 in varchar2 default hr_api.g_varchar2
289: ,p_cmd_attribute8 in varchar2 default hr_api.g_varchar2
290: ,p_cmd_attribute9 in varchar2 default hr_api.g_varchar2
291: ,p_cmd_attribute10 in varchar2 default hr_api.g_varchar2
292: ,p_cmd_attribute11 in varchar2 default hr_api.g_varchar2
293: ,p_cmd_attribute12 in varchar2 default hr_api.g_varchar2
294: ,p_cmd_attribute13 in varchar2 default hr_api.g_varchar2

Line 291: ,p_cmd_attribute10 in varchar2 default hr_api.g_varchar2

287: ,p_cmd_attribute6 in varchar2 default hr_api.g_varchar2
288: ,p_cmd_attribute7 in varchar2 default hr_api.g_varchar2
289: ,p_cmd_attribute8 in varchar2 default hr_api.g_varchar2
290: ,p_cmd_attribute9 in varchar2 default hr_api.g_varchar2
291: ,p_cmd_attribute10 in varchar2 default hr_api.g_varchar2
292: ,p_cmd_attribute11 in varchar2 default hr_api.g_varchar2
293: ,p_cmd_attribute12 in varchar2 default hr_api.g_varchar2
294: ,p_cmd_attribute13 in varchar2 default hr_api.g_varchar2
295: ,p_cmd_attribute14 in varchar2 default hr_api.g_varchar2

Line 292: ,p_cmd_attribute11 in varchar2 default hr_api.g_varchar2

288: ,p_cmd_attribute7 in varchar2 default hr_api.g_varchar2
289: ,p_cmd_attribute8 in varchar2 default hr_api.g_varchar2
290: ,p_cmd_attribute9 in varchar2 default hr_api.g_varchar2
291: ,p_cmd_attribute10 in varchar2 default hr_api.g_varchar2
292: ,p_cmd_attribute11 in varchar2 default hr_api.g_varchar2
293: ,p_cmd_attribute12 in varchar2 default hr_api.g_varchar2
294: ,p_cmd_attribute13 in varchar2 default hr_api.g_varchar2
295: ,p_cmd_attribute14 in varchar2 default hr_api.g_varchar2
296: ,p_cmd_attribute15 in varchar2 default hr_api.g_varchar2

Line 293: ,p_cmd_attribute12 in varchar2 default hr_api.g_varchar2

289: ,p_cmd_attribute8 in varchar2 default hr_api.g_varchar2
290: ,p_cmd_attribute9 in varchar2 default hr_api.g_varchar2
291: ,p_cmd_attribute10 in varchar2 default hr_api.g_varchar2
292: ,p_cmd_attribute11 in varchar2 default hr_api.g_varchar2
293: ,p_cmd_attribute12 in varchar2 default hr_api.g_varchar2
294: ,p_cmd_attribute13 in varchar2 default hr_api.g_varchar2
295: ,p_cmd_attribute14 in varchar2 default hr_api.g_varchar2
296: ,p_cmd_attribute15 in varchar2 default hr_api.g_varchar2
297: ,p_cmd_attribute16 in varchar2 default hr_api.g_varchar2

Line 294: ,p_cmd_attribute13 in varchar2 default hr_api.g_varchar2

290: ,p_cmd_attribute9 in varchar2 default hr_api.g_varchar2
291: ,p_cmd_attribute10 in varchar2 default hr_api.g_varchar2
292: ,p_cmd_attribute11 in varchar2 default hr_api.g_varchar2
293: ,p_cmd_attribute12 in varchar2 default hr_api.g_varchar2
294: ,p_cmd_attribute13 in varchar2 default hr_api.g_varchar2
295: ,p_cmd_attribute14 in varchar2 default hr_api.g_varchar2
296: ,p_cmd_attribute15 in varchar2 default hr_api.g_varchar2
297: ,p_cmd_attribute16 in varchar2 default hr_api.g_varchar2
298: ,p_cmd_attribute17 in varchar2 default hr_api.g_varchar2

Line 295: ,p_cmd_attribute14 in varchar2 default hr_api.g_varchar2

291: ,p_cmd_attribute10 in varchar2 default hr_api.g_varchar2
292: ,p_cmd_attribute11 in varchar2 default hr_api.g_varchar2
293: ,p_cmd_attribute12 in varchar2 default hr_api.g_varchar2
294: ,p_cmd_attribute13 in varchar2 default hr_api.g_varchar2
295: ,p_cmd_attribute14 in varchar2 default hr_api.g_varchar2
296: ,p_cmd_attribute15 in varchar2 default hr_api.g_varchar2
297: ,p_cmd_attribute16 in varchar2 default hr_api.g_varchar2
298: ,p_cmd_attribute17 in varchar2 default hr_api.g_varchar2
299: ,p_cmd_attribute18 in varchar2 default hr_api.g_varchar2

Line 296: ,p_cmd_attribute15 in varchar2 default hr_api.g_varchar2

292: ,p_cmd_attribute11 in varchar2 default hr_api.g_varchar2
293: ,p_cmd_attribute12 in varchar2 default hr_api.g_varchar2
294: ,p_cmd_attribute13 in varchar2 default hr_api.g_varchar2
295: ,p_cmd_attribute14 in varchar2 default hr_api.g_varchar2
296: ,p_cmd_attribute15 in varchar2 default hr_api.g_varchar2
297: ,p_cmd_attribute16 in varchar2 default hr_api.g_varchar2
298: ,p_cmd_attribute17 in varchar2 default hr_api.g_varchar2
299: ,p_cmd_attribute18 in varchar2 default hr_api.g_varchar2
300: ,p_cmd_attribute19 in varchar2 default hr_api.g_varchar2

Line 297: ,p_cmd_attribute16 in varchar2 default hr_api.g_varchar2

293: ,p_cmd_attribute12 in varchar2 default hr_api.g_varchar2
294: ,p_cmd_attribute13 in varchar2 default hr_api.g_varchar2
295: ,p_cmd_attribute14 in varchar2 default hr_api.g_varchar2
296: ,p_cmd_attribute15 in varchar2 default hr_api.g_varchar2
297: ,p_cmd_attribute16 in varchar2 default hr_api.g_varchar2
298: ,p_cmd_attribute17 in varchar2 default hr_api.g_varchar2
299: ,p_cmd_attribute18 in varchar2 default hr_api.g_varchar2
300: ,p_cmd_attribute19 in varchar2 default hr_api.g_varchar2
301: ,p_cmd_attribute20 in varchar2 default hr_api.g_varchar2

Line 298: ,p_cmd_attribute17 in varchar2 default hr_api.g_varchar2

294: ,p_cmd_attribute13 in varchar2 default hr_api.g_varchar2
295: ,p_cmd_attribute14 in varchar2 default hr_api.g_varchar2
296: ,p_cmd_attribute15 in varchar2 default hr_api.g_varchar2
297: ,p_cmd_attribute16 in varchar2 default hr_api.g_varchar2
298: ,p_cmd_attribute17 in varchar2 default hr_api.g_varchar2
299: ,p_cmd_attribute18 in varchar2 default hr_api.g_varchar2
300: ,p_cmd_attribute19 in varchar2 default hr_api.g_varchar2
301: ,p_cmd_attribute20 in varchar2 default hr_api.g_varchar2
302: ,p_cmd_attribute21 in varchar2 default hr_api.g_varchar2

Line 299: ,p_cmd_attribute18 in varchar2 default hr_api.g_varchar2

295: ,p_cmd_attribute14 in varchar2 default hr_api.g_varchar2
296: ,p_cmd_attribute15 in varchar2 default hr_api.g_varchar2
297: ,p_cmd_attribute16 in varchar2 default hr_api.g_varchar2
298: ,p_cmd_attribute17 in varchar2 default hr_api.g_varchar2
299: ,p_cmd_attribute18 in varchar2 default hr_api.g_varchar2
300: ,p_cmd_attribute19 in varchar2 default hr_api.g_varchar2
301: ,p_cmd_attribute20 in varchar2 default hr_api.g_varchar2
302: ,p_cmd_attribute21 in varchar2 default hr_api.g_varchar2
303: ,p_cmd_attribute22 in varchar2 default hr_api.g_varchar2

Line 300: ,p_cmd_attribute19 in varchar2 default hr_api.g_varchar2

296: ,p_cmd_attribute15 in varchar2 default hr_api.g_varchar2
297: ,p_cmd_attribute16 in varchar2 default hr_api.g_varchar2
298: ,p_cmd_attribute17 in varchar2 default hr_api.g_varchar2
299: ,p_cmd_attribute18 in varchar2 default hr_api.g_varchar2
300: ,p_cmd_attribute19 in varchar2 default hr_api.g_varchar2
301: ,p_cmd_attribute20 in varchar2 default hr_api.g_varchar2
302: ,p_cmd_attribute21 in varchar2 default hr_api.g_varchar2
303: ,p_cmd_attribute22 in varchar2 default hr_api.g_varchar2
304: ,p_cmd_attribute23 in varchar2 default hr_api.g_varchar2

Line 301: ,p_cmd_attribute20 in varchar2 default hr_api.g_varchar2

297: ,p_cmd_attribute16 in varchar2 default hr_api.g_varchar2
298: ,p_cmd_attribute17 in varchar2 default hr_api.g_varchar2
299: ,p_cmd_attribute18 in varchar2 default hr_api.g_varchar2
300: ,p_cmd_attribute19 in varchar2 default hr_api.g_varchar2
301: ,p_cmd_attribute20 in varchar2 default hr_api.g_varchar2
302: ,p_cmd_attribute21 in varchar2 default hr_api.g_varchar2
303: ,p_cmd_attribute22 in varchar2 default hr_api.g_varchar2
304: ,p_cmd_attribute23 in varchar2 default hr_api.g_varchar2
305: ,p_cmd_attribute24 in varchar2 default hr_api.g_varchar2

Line 302: ,p_cmd_attribute21 in varchar2 default hr_api.g_varchar2

298: ,p_cmd_attribute17 in varchar2 default hr_api.g_varchar2
299: ,p_cmd_attribute18 in varchar2 default hr_api.g_varchar2
300: ,p_cmd_attribute19 in varchar2 default hr_api.g_varchar2
301: ,p_cmd_attribute20 in varchar2 default hr_api.g_varchar2
302: ,p_cmd_attribute21 in varchar2 default hr_api.g_varchar2
303: ,p_cmd_attribute22 in varchar2 default hr_api.g_varchar2
304: ,p_cmd_attribute23 in varchar2 default hr_api.g_varchar2
305: ,p_cmd_attribute24 in varchar2 default hr_api.g_varchar2
306: ,p_cmd_attribute25 in varchar2 default hr_api.g_varchar2

Line 303: ,p_cmd_attribute22 in varchar2 default hr_api.g_varchar2

299: ,p_cmd_attribute18 in varchar2 default hr_api.g_varchar2
300: ,p_cmd_attribute19 in varchar2 default hr_api.g_varchar2
301: ,p_cmd_attribute20 in varchar2 default hr_api.g_varchar2
302: ,p_cmd_attribute21 in varchar2 default hr_api.g_varchar2
303: ,p_cmd_attribute22 in varchar2 default hr_api.g_varchar2
304: ,p_cmd_attribute23 in varchar2 default hr_api.g_varchar2
305: ,p_cmd_attribute24 in varchar2 default hr_api.g_varchar2
306: ,p_cmd_attribute25 in varchar2 default hr_api.g_varchar2
307: ,p_cmd_attribute26 in varchar2 default hr_api.g_varchar2

Line 304: ,p_cmd_attribute23 in varchar2 default hr_api.g_varchar2

300: ,p_cmd_attribute19 in varchar2 default hr_api.g_varchar2
301: ,p_cmd_attribute20 in varchar2 default hr_api.g_varchar2
302: ,p_cmd_attribute21 in varchar2 default hr_api.g_varchar2
303: ,p_cmd_attribute22 in varchar2 default hr_api.g_varchar2
304: ,p_cmd_attribute23 in varchar2 default hr_api.g_varchar2
305: ,p_cmd_attribute24 in varchar2 default hr_api.g_varchar2
306: ,p_cmd_attribute25 in varchar2 default hr_api.g_varchar2
307: ,p_cmd_attribute26 in varchar2 default hr_api.g_varchar2
308: ,p_cmd_attribute27 in varchar2 default hr_api.g_varchar2

Line 305: ,p_cmd_attribute24 in varchar2 default hr_api.g_varchar2

301: ,p_cmd_attribute20 in varchar2 default hr_api.g_varchar2
302: ,p_cmd_attribute21 in varchar2 default hr_api.g_varchar2
303: ,p_cmd_attribute22 in varchar2 default hr_api.g_varchar2
304: ,p_cmd_attribute23 in varchar2 default hr_api.g_varchar2
305: ,p_cmd_attribute24 in varchar2 default hr_api.g_varchar2
306: ,p_cmd_attribute25 in varchar2 default hr_api.g_varchar2
307: ,p_cmd_attribute26 in varchar2 default hr_api.g_varchar2
308: ,p_cmd_attribute27 in varchar2 default hr_api.g_varchar2
309: ,p_cmd_attribute28 in varchar2 default hr_api.g_varchar2

Line 306: ,p_cmd_attribute25 in varchar2 default hr_api.g_varchar2

302: ,p_cmd_attribute21 in varchar2 default hr_api.g_varchar2
303: ,p_cmd_attribute22 in varchar2 default hr_api.g_varchar2
304: ,p_cmd_attribute23 in varchar2 default hr_api.g_varchar2
305: ,p_cmd_attribute24 in varchar2 default hr_api.g_varchar2
306: ,p_cmd_attribute25 in varchar2 default hr_api.g_varchar2
307: ,p_cmd_attribute26 in varchar2 default hr_api.g_varchar2
308: ,p_cmd_attribute27 in varchar2 default hr_api.g_varchar2
309: ,p_cmd_attribute28 in varchar2 default hr_api.g_varchar2
310: ,p_cmd_attribute29 in varchar2 default hr_api.g_varchar2

Line 307: ,p_cmd_attribute26 in varchar2 default hr_api.g_varchar2

303: ,p_cmd_attribute22 in varchar2 default hr_api.g_varchar2
304: ,p_cmd_attribute23 in varchar2 default hr_api.g_varchar2
305: ,p_cmd_attribute24 in varchar2 default hr_api.g_varchar2
306: ,p_cmd_attribute25 in varchar2 default hr_api.g_varchar2
307: ,p_cmd_attribute26 in varchar2 default hr_api.g_varchar2
308: ,p_cmd_attribute27 in varchar2 default hr_api.g_varchar2
309: ,p_cmd_attribute28 in varchar2 default hr_api.g_varchar2
310: ,p_cmd_attribute29 in varchar2 default hr_api.g_varchar2
311: ,p_cmd_attribute30 in varchar2 default hr_api.g_varchar2

Line 308: ,p_cmd_attribute27 in varchar2 default hr_api.g_varchar2

304: ,p_cmd_attribute23 in varchar2 default hr_api.g_varchar2
305: ,p_cmd_attribute24 in varchar2 default hr_api.g_varchar2
306: ,p_cmd_attribute25 in varchar2 default hr_api.g_varchar2
307: ,p_cmd_attribute26 in varchar2 default hr_api.g_varchar2
308: ,p_cmd_attribute27 in varchar2 default hr_api.g_varchar2
309: ,p_cmd_attribute28 in varchar2 default hr_api.g_varchar2
310: ,p_cmd_attribute29 in varchar2 default hr_api.g_varchar2
311: ,p_cmd_attribute30 in varchar2 default hr_api.g_varchar2
312: ,p_object_version_number in out nocopy number

Line 309: ,p_cmd_attribute28 in varchar2 default hr_api.g_varchar2

305: ,p_cmd_attribute24 in varchar2 default hr_api.g_varchar2
306: ,p_cmd_attribute25 in varchar2 default hr_api.g_varchar2
307: ,p_cmd_attribute26 in varchar2 default hr_api.g_varchar2
308: ,p_cmd_attribute27 in varchar2 default hr_api.g_varchar2
309: ,p_cmd_attribute28 in varchar2 default hr_api.g_varchar2
310: ,p_cmd_attribute29 in varchar2 default hr_api.g_varchar2
311: ,p_cmd_attribute30 in varchar2 default hr_api.g_varchar2
312: ,p_object_version_number in out nocopy number
313: ,p_effective_date in date

Line 310: ,p_cmd_attribute29 in varchar2 default hr_api.g_varchar2

306: ,p_cmd_attribute25 in varchar2 default hr_api.g_varchar2
307: ,p_cmd_attribute26 in varchar2 default hr_api.g_varchar2
308: ,p_cmd_attribute27 in varchar2 default hr_api.g_varchar2
309: ,p_cmd_attribute28 in varchar2 default hr_api.g_varchar2
310: ,p_cmd_attribute29 in varchar2 default hr_api.g_varchar2
311: ,p_cmd_attribute30 in varchar2 default hr_api.g_varchar2
312: ,p_object_version_number in out nocopy number
313: ,p_effective_date in date
314: ) is

Line 311: ,p_cmd_attribute30 in varchar2 default hr_api.g_varchar2

307: ,p_cmd_attribute26 in varchar2 default hr_api.g_varchar2
308: ,p_cmd_attribute27 in varchar2 default hr_api.g_varchar2
309: ,p_cmd_attribute28 in varchar2 default hr_api.g_varchar2
310: ,p_cmd_attribute29 in varchar2 default hr_api.g_varchar2
311: ,p_cmd_attribute30 in varchar2 default hr_api.g_varchar2
312: ,p_object_version_number in out nocopy number
313: ,p_effective_date in date
314: ) is
315: --

Line 382: when hr_api.cannot_find_prog_unit then

378: ,p_object_version_number => p_object_version_number
379: ,p_effective_date => trunc(p_effective_date)
380: );
381: exception
382: when hr_api.cannot_find_prog_unit then
383: hr_api.cannot_find_prog_unit_error
384: (p_module_name => 'UPDATE_Comm_Dlvry_Media'
385: ,p_hook_type => 'BP'
386: );

Line 383: hr_api.cannot_find_prog_unit_error

379: ,p_effective_date => trunc(p_effective_date)
380: );
381: exception
382: when hr_api.cannot_find_prog_unit then
383: hr_api.cannot_find_prog_unit_error
384: (p_module_name => 'UPDATE_Comm_Dlvry_Media'
385: ,p_hook_type => 'BP'
386: );
387: --

Line 482: when hr_api.cannot_find_prog_unit then

478: ,p_object_version_number => l_object_version_number
479: ,p_effective_date => trunc(p_effective_date)
480: );
481: exception
482: when hr_api.cannot_find_prog_unit then
483: hr_api.cannot_find_prog_unit_error
484: (p_module_name => 'UPDATE_Comm_Dlvry_Media'
485: ,p_hook_type => 'AP'
486: );

Line 483: hr_api.cannot_find_prog_unit_error

479: ,p_effective_date => trunc(p_effective_date)
480: );
481: exception
482: when hr_api.cannot_find_prog_unit then
483: hr_api.cannot_find_prog_unit_error
484: (p_module_name => 'UPDATE_Comm_Dlvry_Media'
485: ,p_hook_type => 'AP'
486: );
487: --

Line 497: raise hr_api.validate_enabled;

493: --
494: -- When in validation only mode raise the Validate_Enabled exception
495: --
496: if p_validate then
497: raise hr_api.validate_enabled;
498: end if;
499: --
500: -- Set all output arguments
501: --

Line 508: when hr_api.validate_enabled then

504: hr_utility.set_location(' Leaving:'||l_proc, 70);
505: --
506: exception
507: --
508: when hr_api.validate_enabled then
509: --
510: -- As the Validate_Enabled exception has been raised
511: -- we must rollback to the savepoint
512: --

Line 573: when hr_api.cannot_find_prog_unit then

569: ,p_object_version_number => p_object_version_number
570: ,p_effective_date => trunc(p_effective_date)
571: );
572: exception
573: when hr_api.cannot_find_prog_unit then
574: hr_api.cannot_find_prog_unit_error
575: (p_module_name => 'DELETE_Comm_Dlvry_Media'
576: ,p_hook_type => 'BP'
577: );

Line 574: hr_api.cannot_find_prog_unit_error

570: ,p_effective_date => trunc(p_effective_date)
571: );
572: exception
573: when hr_api.cannot_find_prog_unit then
574: hr_api.cannot_find_prog_unit_error
575: (p_module_name => 'DELETE_Comm_Dlvry_Media'
576: ,p_hook_type => 'BP'
577: );
578: --

Line 601: when hr_api.cannot_find_prog_unit then

597: ,p_object_version_number => l_object_version_number
598: ,p_effective_date => trunc(p_effective_date)
599: );
600: exception
601: when hr_api.cannot_find_prog_unit then
602: hr_api.cannot_find_prog_unit_error
603: (p_module_name => 'DELETE_Comm_Dlvry_Media'
604: ,p_hook_type => 'AP'
605: );

Line 602: hr_api.cannot_find_prog_unit_error

598: ,p_effective_date => trunc(p_effective_date)
599: );
600: exception
601: when hr_api.cannot_find_prog_unit then
602: hr_api.cannot_find_prog_unit_error
603: (p_module_name => 'DELETE_Comm_Dlvry_Media'
604: ,p_hook_type => 'AP'
605: );
606: --

Line 616: raise hr_api.validate_enabled;

612: --
613: -- When in validation only mode raise the Validate_Enabled exception
614: --
615: if p_validate then
616: raise hr_api.validate_enabled;
617: end if;
618: --
619: hr_utility.set_location(' Leaving:'||l_proc, 70);
620: --

Line 623: when hr_api.validate_enabled then

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