APPS.PER_PDM_UPD dependencies on HR_API

Line 99: When hr_api.check_integrity_violated Then

95: --
96: hr_utility.set_location(' Leaving:'||l_proc, 10);
97: --
98: Exception
99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: per_pdm_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then

Line 102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

98: Exception
99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: per_pdm_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_pdm_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 103: When hr_api.parent_integrity_violated Then

99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: per_pdm_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_pdm_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then

Line 106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_pdm_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: per_pdm_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 107: When hr_api.unique_integrity_violated Then

103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_pdm_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: per_pdm_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then

Line 110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: per_pdm_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: Raise;
113: End update_dml;
114: --

Line 271: when hr_api.cannot_find_prog_unit then

267: );
268: --
269: exception
270: --
271: when hr_api.cannot_find_prog_unit then
272: --
273: hr_api.cannot_find_prog_unit_error
274: (p_module_name => 'PER_PERSON_DLVRY_METHODS'
275: ,p_hook_type => 'AU');

Line 273: hr_api.cannot_find_prog_unit_error

269: exception
270: --
271: when hr_api.cannot_find_prog_unit then
272: --
273: hr_api.cannot_find_prog_unit_error
274: (p_module_name => 'PER_PERSON_DLVRY_METHODS'
275: ,p_hook_type => 'AU');
276: --
277: end;

Line 341: If (p_rec.person_id = hr_api.g_number) then

337: -- p_rec plsql record structure
338: -- to see if a system default is being used. If a system default
339: -- is being used then we must set to the 'current' argument value.
340: --
341: If (p_rec.person_id = hr_api.g_number) then
342: p_rec.person_id :=
343: per_pdm_shd.g_old_rec.person_id;
344: End If;
345: If (p_rec.date_start = hr_api.g_date) then

Line 345: If (p_rec.date_start = hr_api.g_date) then

341: If (p_rec.person_id = hr_api.g_number) then
342: p_rec.person_id :=
343: per_pdm_shd.g_old_rec.person_id;
344: End If;
345: If (p_rec.date_start = hr_api.g_date) then
346: p_rec.date_start :=
347: per_pdm_shd.g_old_rec.date_start;
348: End If;
349: If (p_rec.date_end = hr_api.g_date) then

Line 349: If (p_rec.date_end = hr_api.g_date) then

345: If (p_rec.date_start = hr_api.g_date) then
346: p_rec.date_start :=
347: per_pdm_shd.g_old_rec.date_start;
348: End If;
349: If (p_rec.date_end = hr_api.g_date) then
350: p_rec.date_end :=
351: per_pdm_shd.g_old_rec.date_end;
352: End If;
353: If (p_rec.comm_dlvry_method = hr_api.g_varchar2) then

Line 353: If (p_rec.comm_dlvry_method = hr_api.g_varchar2) then

349: If (p_rec.date_end = hr_api.g_date) then
350: p_rec.date_end :=
351: per_pdm_shd.g_old_rec.date_end;
352: End If;
353: If (p_rec.comm_dlvry_method = hr_api.g_varchar2) then
354: p_rec.comm_dlvry_method :=
355: per_pdm_shd.g_old_rec.comm_dlvry_method;
356: End If;
357: If (p_rec.preferred_flag = hr_api.g_varchar2) then

Line 357: If (p_rec.preferred_flag = hr_api.g_varchar2) then

353: If (p_rec.comm_dlvry_method = hr_api.g_varchar2) then
354: p_rec.comm_dlvry_method :=
355: per_pdm_shd.g_old_rec.comm_dlvry_method;
356: End If;
357: If (p_rec.preferred_flag = hr_api.g_varchar2) then
358: p_rec.preferred_flag :=
359: per_pdm_shd.g_old_rec.preferred_flag;
360: End If;
361: If (p_rec.request_id = hr_api.g_number) then

Line 361: If (p_rec.request_id = hr_api.g_number) then

357: If (p_rec.preferred_flag = hr_api.g_varchar2) then
358: p_rec.preferred_flag :=
359: per_pdm_shd.g_old_rec.preferred_flag;
360: End If;
361: If (p_rec.request_id = hr_api.g_number) then
362: p_rec.request_id :=
363: per_pdm_shd.g_old_rec.request_id;
364: End If;
365: If (p_rec.program_update_date = hr_api.g_date) then

Line 365: If (p_rec.program_update_date = hr_api.g_date) then

361: If (p_rec.request_id = hr_api.g_number) then
362: p_rec.request_id :=
363: per_pdm_shd.g_old_rec.request_id;
364: End If;
365: If (p_rec.program_update_date = hr_api.g_date) then
366: p_rec.program_update_date :=
367: per_pdm_shd.g_old_rec.program_update_date;
368: End If;
369: If (p_rec.program_application_id = hr_api.g_number) then

Line 369: If (p_rec.program_application_id = hr_api.g_number) then

365: If (p_rec.program_update_date = hr_api.g_date) then
366: p_rec.program_update_date :=
367: per_pdm_shd.g_old_rec.program_update_date;
368: End If;
369: If (p_rec.program_application_id = hr_api.g_number) then
370: p_rec.program_application_id :=
371: per_pdm_shd.g_old_rec.program_application_id;
372: End If;
373: If (p_rec.program_id = hr_api.g_number) then

Line 373: If (p_rec.program_id = hr_api.g_number) then

369: If (p_rec.program_application_id = hr_api.g_number) then
370: p_rec.program_application_id :=
371: per_pdm_shd.g_old_rec.program_application_id;
372: End If;
373: If (p_rec.program_id = hr_api.g_number) then
374: p_rec.program_id :=
375: per_pdm_shd.g_old_rec.program_id;
376: End If;
377: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 377: If (p_rec.attribute_category = hr_api.g_varchar2) then

373: If (p_rec.program_id = hr_api.g_number) then
374: p_rec.program_id :=
375: per_pdm_shd.g_old_rec.program_id;
376: End If;
377: If (p_rec.attribute_category = hr_api.g_varchar2) then
378: p_rec.attribute_category :=
379: per_pdm_shd.g_old_rec.attribute_category;
380: End If;
381: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 381: If (p_rec.attribute1 = hr_api.g_varchar2) then

377: If (p_rec.attribute_category = hr_api.g_varchar2) then
378: p_rec.attribute_category :=
379: per_pdm_shd.g_old_rec.attribute_category;
380: End If;
381: If (p_rec.attribute1 = hr_api.g_varchar2) then
382: p_rec.attribute1 :=
383: per_pdm_shd.g_old_rec.attribute1;
384: End If;
385: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 385: If (p_rec.attribute2 = hr_api.g_varchar2) then

381: If (p_rec.attribute1 = hr_api.g_varchar2) then
382: p_rec.attribute1 :=
383: per_pdm_shd.g_old_rec.attribute1;
384: End If;
385: If (p_rec.attribute2 = hr_api.g_varchar2) then
386: p_rec.attribute2 :=
387: per_pdm_shd.g_old_rec.attribute2;
388: End If;
389: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 389: If (p_rec.attribute3 = hr_api.g_varchar2) then

385: If (p_rec.attribute2 = hr_api.g_varchar2) then
386: p_rec.attribute2 :=
387: per_pdm_shd.g_old_rec.attribute2;
388: End If;
389: If (p_rec.attribute3 = hr_api.g_varchar2) then
390: p_rec.attribute3 :=
391: per_pdm_shd.g_old_rec.attribute3;
392: End If;
393: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 393: If (p_rec.attribute4 = hr_api.g_varchar2) then

389: If (p_rec.attribute3 = hr_api.g_varchar2) then
390: p_rec.attribute3 :=
391: per_pdm_shd.g_old_rec.attribute3;
392: End If;
393: If (p_rec.attribute4 = hr_api.g_varchar2) then
394: p_rec.attribute4 :=
395: per_pdm_shd.g_old_rec.attribute4;
396: End If;
397: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 397: If (p_rec.attribute5 = hr_api.g_varchar2) then

393: If (p_rec.attribute4 = hr_api.g_varchar2) then
394: p_rec.attribute4 :=
395: per_pdm_shd.g_old_rec.attribute4;
396: End If;
397: If (p_rec.attribute5 = hr_api.g_varchar2) then
398: p_rec.attribute5 :=
399: per_pdm_shd.g_old_rec.attribute5;
400: End If;
401: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 401: If (p_rec.attribute6 = hr_api.g_varchar2) then

397: If (p_rec.attribute5 = hr_api.g_varchar2) then
398: p_rec.attribute5 :=
399: per_pdm_shd.g_old_rec.attribute5;
400: End If;
401: If (p_rec.attribute6 = hr_api.g_varchar2) then
402: p_rec.attribute6 :=
403: per_pdm_shd.g_old_rec.attribute6;
404: End If;
405: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 405: If (p_rec.attribute7 = hr_api.g_varchar2) then

401: If (p_rec.attribute6 = hr_api.g_varchar2) then
402: p_rec.attribute6 :=
403: per_pdm_shd.g_old_rec.attribute6;
404: End If;
405: If (p_rec.attribute7 = hr_api.g_varchar2) then
406: p_rec.attribute7 :=
407: per_pdm_shd.g_old_rec.attribute7;
408: End If;
409: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 409: If (p_rec.attribute8 = hr_api.g_varchar2) then

405: If (p_rec.attribute7 = hr_api.g_varchar2) then
406: p_rec.attribute7 :=
407: per_pdm_shd.g_old_rec.attribute7;
408: End If;
409: If (p_rec.attribute8 = hr_api.g_varchar2) then
410: p_rec.attribute8 :=
411: per_pdm_shd.g_old_rec.attribute8;
412: End If;
413: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 413: If (p_rec.attribute9 = hr_api.g_varchar2) then

409: If (p_rec.attribute8 = hr_api.g_varchar2) then
410: p_rec.attribute8 :=
411: per_pdm_shd.g_old_rec.attribute8;
412: End If;
413: If (p_rec.attribute9 = hr_api.g_varchar2) then
414: p_rec.attribute9 :=
415: per_pdm_shd.g_old_rec.attribute9;
416: End If;
417: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 417: If (p_rec.attribute10 = hr_api.g_varchar2) then

413: If (p_rec.attribute9 = hr_api.g_varchar2) then
414: p_rec.attribute9 :=
415: per_pdm_shd.g_old_rec.attribute9;
416: End If;
417: If (p_rec.attribute10 = hr_api.g_varchar2) then
418: p_rec.attribute10 :=
419: per_pdm_shd.g_old_rec.attribute10;
420: End If;
421: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 421: If (p_rec.attribute11 = hr_api.g_varchar2) then

417: If (p_rec.attribute10 = hr_api.g_varchar2) then
418: p_rec.attribute10 :=
419: per_pdm_shd.g_old_rec.attribute10;
420: End If;
421: If (p_rec.attribute11 = hr_api.g_varchar2) then
422: p_rec.attribute11 :=
423: per_pdm_shd.g_old_rec.attribute11;
424: End If;
425: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 425: If (p_rec.attribute12 = hr_api.g_varchar2) then

421: If (p_rec.attribute11 = hr_api.g_varchar2) then
422: p_rec.attribute11 :=
423: per_pdm_shd.g_old_rec.attribute11;
424: End If;
425: If (p_rec.attribute12 = hr_api.g_varchar2) then
426: p_rec.attribute12 :=
427: per_pdm_shd.g_old_rec.attribute12;
428: End If;
429: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 429: If (p_rec.attribute13 = hr_api.g_varchar2) then

425: If (p_rec.attribute12 = hr_api.g_varchar2) then
426: p_rec.attribute12 :=
427: per_pdm_shd.g_old_rec.attribute12;
428: End If;
429: If (p_rec.attribute13 = hr_api.g_varchar2) then
430: p_rec.attribute13 :=
431: per_pdm_shd.g_old_rec.attribute13;
432: End If;
433: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 433: If (p_rec.attribute14 = hr_api.g_varchar2) then

429: If (p_rec.attribute13 = hr_api.g_varchar2) then
430: p_rec.attribute13 :=
431: per_pdm_shd.g_old_rec.attribute13;
432: End If;
433: If (p_rec.attribute14 = hr_api.g_varchar2) then
434: p_rec.attribute14 :=
435: per_pdm_shd.g_old_rec.attribute14;
436: End If;
437: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 437: If (p_rec.attribute15 = hr_api.g_varchar2) then

433: If (p_rec.attribute14 = hr_api.g_varchar2) then
434: p_rec.attribute14 :=
435: per_pdm_shd.g_old_rec.attribute14;
436: End If;
437: If (p_rec.attribute15 = hr_api.g_varchar2) then
438: p_rec.attribute15 :=
439: per_pdm_shd.g_old_rec.attribute15;
440: End If;
441: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 441: If (p_rec.attribute16 = hr_api.g_varchar2) then

437: If (p_rec.attribute15 = hr_api.g_varchar2) then
438: p_rec.attribute15 :=
439: per_pdm_shd.g_old_rec.attribute15;
440: End If;
441: If (p_rec.attribute16 = hr_api.g_varchar2) then
442: p_rec.attribute16 :=
443: per_pdm_shd.g_old_rec.attribute16;
444: End If;
445: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 445: If (p_rec.attribute17 = hr_api.g_varchar2) then

441: If (p_rec.attribute16 = hr_api.g_varchar2) then
442: p_rec.attribute16 :=
443: per_pdm_shd.g_old_rec.attribute16;
444: End If;
445: If (p_rec.attribute17 = hr_api.g_varchar2) then
446: p_rec.attribute17 :=
447: per_pdm_shd.g_old_rec.attribute17;
448: End If;
449: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 449: If (p_rec.attribute18 = hr_api.g_varchar2) then

445: If (p_rec.attribute17 = hr_api.g_varchar2) then
446: p_rec.attribute17 :=
447: per_pdm_shd.g_old_rec.attribute17;
448: End If;
449: If (p_rec.attribute18 = hr_api.g_varchar2) then
450: p_rec.attribute18 :=
451: per_pdm_shd.g_old_rec.attribute18;
452: End If;
453: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 453: If (p_rec.attribute19 = hr_api.g_varchar2) then

449: If (p_rec.attribute18 = hr_api.g_varchar2) then
450: p_rec.attribute18 :=
451: per_pdm_shd.g_old_rec.attribute18;
452: End If;
453: If (p_rec.attribute19 = hr_api.g_varchar2) then
454: p_rec.attribute19 :=
455: per_pdm_shd.g_old_rec.attribute19;
456: End If;
457: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 457: If (p_rec.attribute20 = hr_api.g_varchar2) then

453: If (p_rec.attribute19 = hr_api.g_varchar2) then
454: p_rec.attribute19 :=
455: per_pdm_shd.g_old_rec.attribute19;
456: End If;
457: If (p_rec.attribute20 = hr_api.g_varchar2) then
458: p_rec.attribute20 :=
459: per_pdm_shd.g_old_rec.attribute20;
460: End If;
461: --

Line 518: p_date_start in date default hr_api.g_date,

514: Procedure upd
515: (
516: p_effective_date in date,
517: p_delivery_method_id in number,
518: p_date_start in date default hr_api.g_date,
519: p_date_end in date default hr_api.g_date,
520: p_comm_dlvry_method in varchar2 default hr_api.g_varchar2,
521: p_preferred_flag in varchar2 default hr_api.g_varchar2,
522: p_object_version_number in out nocopy number,

Line 519: p_date_end in date default hr_api.g_date,

515: (
516: p_effective_date in date,
517: p_delivery_method_id in number,
518: p_date_start in date default hr_api.g_date,
519: p_date_end in date default hr_api.g_date,
520: p_comm_dlvry_method in varchar2 default hr_api.g_varchar2,
521: p_preferred_flag in varchar2 default hr_api.g_varchar2,
522: p_object_version_number in out nocopy number,
523: p_request_id in number default hr_api.g_number,

Line 520: p_comm_dlvry_method in varchar2 default hr_api.g_varchar2,

516: p_effective_date in date,
517: p_delivery_method_id in number,
518: p_date_start in date default hr_api.g_date,
519: p_date_end in date default hr_api.g_date,
520: p_comm_dlvry_method in varchar2 default hr_api.g_varchar2,
521: p_preferred_flag in varchar2 default hr_api.g_varchar2,
522: p_object_version_number in out nocopy number,
523: p_request_id in number default hr_api.g_number,
524: p_program_update_date in date default hr_api.g_date,

Line 521: p_preferred_flag in varchar2 default hr_api.g_varchar2,

517: p_delivery_method_id in number,
518: p_date_start in date default hr_api.g_date,
519: p_date_end in date default hr_api.g_date,
520: p_comm_dlvry_method in varchar2 default hr_api.g_varchar2,
521: p_preferred_flag in varchar2 default hr_api.g_varchar2,
522: p_object_version_number in out nocopy number,
523: p_request_id in number default hr_api.g_number,
524: p_program_update_date in date default hr_api.g_date,
525: p_program_application_id in number default hr_api.g_number,

Line 523: p_request_id in number default hr_api.g_number,

519: p_date_end in date default hr_api.g_date,
520: p_comm_dlvry_method in varchar2 default hr_api.g_varchar2,
521: p_preferred_flag in varchar2 default hr_api.g_varchar2,
522: p_object_version_number in out nocopy number,
523: p_request_id in number default hr_api.g_number,
524: p_program_update_date in date default hr_api.g_date,
525: p_program_application_id in number default hr_api.g_number,
526: p_program_id in number default hr_api.g_number,
527: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 524: p_program_update_date in date default hr_api.g_date,

520: p_comm_dlvry_method in varchar2 default hr_api.g_varchar2,
521: p_preferred_flag in varchar2 default hr_api.g_varchar2,
522: p_object_version_number in out nocopy number,
523: p_request_id in number default hr_api.g_number,
524: p_program_update_date in date default hr_api.g_date,
525: p_program_application_id in number default hr_api.g_number,
526: p_program_id in number default hr_api.g_number,
527: p_attribute_category in varchar2 default hr_api.g_varchar2,
528: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 525: p_program_application_id in number default hr_api.g_number,

521: p_preferred_flag in varchar2 default hr_api.g_varchar2,
522: p_object_version_number in out nocopy number,
523: p_request_id in number default hr_api.g_number,
524: p_program_update_date in date default hr_api.g_date,
525: p_program_application_id in number default hr_api.g_number,
526: p_program_id in number default hr_api.g_number,
527: p_attribute_category in varchar2 default hr_api.g_varchar2,
528: p_attribute1 in varchar2 default hr_api.g_varchar2,
529: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 526: p_program_id in number default hr_api.g_number,

522: p_object_version_number in out nocopy number,
523: p_request_id in number default hr_api.g_number,
524: p_program_update_date in date default hr_api.g_date,
525: p_program_application_id in number default hr_api.g_number,
526: p_program_id in number default hr_api.g_number,
527: p_attribute_category in varchar2 default hr_api.g_varchar2,
528: p_attribute1 in varchar2 default hr_api.g_varchar2,
529: p_attribute2 in varchar2 default hr_api.g_varchar2,
530: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 527: p_attribute_category in varchar2 default hr_api.g_varchar2,

523: p_request_id in number default hr_api.g_number,
524: p_program_update_date in date default hr_api.g_date,
525: p_program_application_id in number default hr_api.g_number,
526: p_program_id in number default hr_api.g_number,
527: p_attribute_category in varchar2 default hr_api.g_varchar2,
528: p_attribute1 in varchar2 default hr_api.g_varchar2,
529: p_attribute2 in varchar2 default hr_api.g_varchar2,
530: p_attribute3 in varchar2 default hr_api.g_varchar2,
531: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 528: p_attribute1 in varchar2 default hr_api.g_varchar2,

524: p_program_update_date in date default hr_api.g_date,
525: p_program_application_id in number default hr_api.g_number,
526: p_program_id in number default hr_api.g_number,
527: p_attribute_category in varchar2 default hr_api.g_varchar2,
528: p_attribute1 in varchar2 default hr_api.g_varchar2,
529: p_attribute2 in varchar2 default hr_api.g_varchar2,
530: p_attribute3 in varchar2 default hr_api.g_varchar2,
531: p_attribute4 in varchar2 default hr_api.g_varchar2,
532: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 529: p_attribute2 in varchar2 default hr_api.g_varchar2,

525: p_program_application_id in number default hr_api.g_number,
526: p_program_id in number default hr_api.g_number,
527: p_attribute_category in varchar2 default hr_api.g_varchar2,
528: p_attribute1 in varchar2 default hr_api.g_varchar2,
529: p_attribute2 in varchar2 default hr_api.g_varchar2,
530: p_attribute3 in varchar2 default hr_api.g_varchar2,
531: p_attribute4 in varchar2 default hr_api.g_varchar2,
532: p_attribute5 in varchar2 default hr_api.g_varchar2,
533: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 530: p_attribute3 in varchar2 default hr_api.g_varchar2,

526: p_program_id in number default hr_api.g_number,
527: p_attribute_category in varchar2 default hr_api.g_varchar2,
528: p_attribute1 in varchar2 default hr_api.g_varchar2,
529: p_attribute2 in varchar2 default hr_api.g_varchar2,
530: p_attribute3 in varchar2 default hr_api.g_varchar2,
531: p_attribute4 in varchar2 default hr_api.g_varchar2,
532: p_attribute5 in varchar2 default hr_api.g_varchar2,
533: p_attribute6 in varchar2 default hr_api.g_varchar2,
534: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 531: p_attribute4 in varchar2 default hr_api.g_varchar2,

527: p_attribute_category in varchar2 default hr_api.g_varchar2,
528: p_attribute1 in varchar2 default hr_api.g_varchar2,
529: p_attribute2 in varchar2 default hr_api.g_varchar2,
530: p_attribute3 in varchar2 default hr_api.g_varchar2,
531: p_attribute4 in varchar2 default hr_api.g_varchar2,
532: p_attribute5 in varchar2 default hr_api.g_varchar2,
533: p_attribute6 in varchar2 default hr_api.g_varchar2,
534: p_attribute7 in varchar2 default hr_api.g_varchar2,
535: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 532: p_attribute5 in varchar2 default hr_api.g_varchar2,

528: p_attribute1 in varchar2 default hr_api.g_varchar2,
529: p_attribute2 in varchar2 default hr_api.g_varchar2,
530: p_attribute3 in varchar2 default hr_api.g_varchar2,
531: p_attribute4 in varchar2 default hr_api.g_varchar2,
532: p_attribute5 in varchar2 default hr_api.g_varchar2,
533: p_attribute6 in varchar2 default hr_api.g_varchar2,
534: p_attribute7 in varchar2 default hr_api.g_varchar2,
535: p_attribute8 in varchar2 default hr_api.g_varchar2,
536: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 533: p_attribute6 in varchar2 default hr_api.g_varchar2,

529: p_attribute2 in varchar2 default hr_api.g_varchar2,
530: p_attribute3 in varchar2 default hr_api.g_varchar2,
531: p_attribute4 in varchar2 default hr_api.g_varchar2,
532: p_attribute5 in varchar2 default hr_api.g_varchar2,
533: p_attribute6 in varchar2 default hr_api.g_varchar2,
534: p_attribute7 in varchar2 default hr_api.g_varchar2,
535: p_attribute8 in varchar2 default hr_api.g_varchar2,
536: p_attribute9 in varchar2 default hr_api.g_varchar2,
537: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 534: p_attribute7 in varchar2 default hr_api.g_varchar2,

530: p_attribute3 in varchar2 default hr_api.g_varchar2,
531: p_attribute4 in varchar2 default hr_api.g_varchar2,
532: p_attribute5 in varchar2 default hr_api.g_varchar2,
533: p_attribute6 in varchar2 default hr_api.g_varchar2,
534: p_attribute7 in varchar2 default hr_api.g_varchar2,
535: p_attribute8 in varchar2 default hr_api.g_varchar2,
536: p_attribute9 in varchar2 default hr_api.g_varchar2,
537: p_attribute10 in varchar2 default hr_api.g_varchar2,
538: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 535: p_attribute8 in varchar2 default hr_api.g_varchar2,

531: p_attribute4 in varchar2 default hr_api.g_varchar2,
532: p_attribute5 in varchar2 default hr_api.g_varchar2,
533: p_attribute6 in varchar2 default hr_api.g_varchar2,
534: p_attribute7 in varchar2 default hr_api.g_varchar2,
535: p_attribute8 in varchar2 default hr_api.g_varchar2,
536: p_attribute9 in varchar2 default hr_api.g_varchar2,
537: p_attribute10 in varchar2 default hr_api.g_varchar2,
538: p_attribute11 in varchar2 default hr_api.g_varchar2,
539: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 536: p_attribute9 in varchar2 default hr_api.g_varchar2,

532: p_attribute5 in varchar2 default hr_api.g_varchar2,
533: p_attribute6 in varchar2 default hr_api.g_varchar2,
534: p_attribute7 in varchar2 default hr_api.g_varchar2,
535: p_attribute8 in varchar2 default hr_api.g_varchar2,
536: p_attribute9 in varchar2 default hr_api.g_varchar2,
537: p_attribute10 in varchar2 default hr_api.g_varchar2,
538: p_attribute11 in varchar2 default hr_api.g_varchar2,
539: p_attribute12 in varchar2 default hr_api.g_varchar2,
540: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 537: p_attribute10 in varchar2 default hr_api.g_varchar2,

533: p_attribute6 in varchar2 default hr_api.g_varchar2,
534: p_attribute7 in varchar2 default hr_api.g_varchar2,
535: p_attribute8 in varchar2 default hr_api.g_varchar2,
536: p_attribute9 in varchar2 default hr_api.g_varchar2,
537: p_attribute10 in varchar2 default hr_api.g_varchar2,
538: p_attribute11 in varchar2 default hr_api.g_varchar2,
539: p_attribute12 in varchar2 default hr_api.g_varchar2,
540: p_attribute13 in varchar2 default hr_api.g_varchar2,
541: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 538: p_attribute11 in varchar2 default hr_api.g_varchar2,

534: p_attribute7 in varchar2 default hr_api.g_varchar2,
535: p_attribute8 in varchar2 default hr_api.g_varchar2,
536: p_attribute9 in varchar2 default hr_api.g_varchar2,
537: p_attribute10 in varchar2 default hr_api.g_varchar2,
538: p_attribute11 in varchar2 default hr_api.g_varchar2,
539: p_attribute12 in varchar2 default hr_api.g_varchar2,
540: p_attribute13 in varchar2 default hr_api.g_varchar2,
541: p_attribute14 in varchar2 default hr_api.g_varchar2,
542: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 539: p_attribute12 in varchar2 default hr_api.g_varchar2,

535: p_attribute8 in varchar2 default hr_api.g_varchar2,
536: p_attribute9 in varchar2 default hr_api.g_varchar2,
537: p_attribute10 in varchar2 default hr_api.g_varchar2,
538: p_attribute11 in varchar2 default hr_api.g_varchar2,
539: p_attribute12 in varchar2 default hr_api.g_varchar2,
540: p_attribute13 in varchar2 default hr_api.g_varchar2,
541: p_attribute14 in varchar2 default hr_api.g_varchar2,
542: p_attribute15 in varchar2 default hr_api.g_varchar2,
543: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 540: p_attribute13 in varchar2 default hr_api.g_varchar2,

536: p_attribute9 in varchar2 default hr_api.g_varchar2,
537: p_attribute10 in varchar2 default hr_api.g_varchar2,
538: p_attribute11 in varchar2 default hr_api.g_varchar2,
539: p_attribute12 in varchar2 default hr_api.g_varchar2,
540: p_attribute13 in varchar2 default hr_api.g_varchar2,
541: p_attribute14 in varchar2 default hr_api.g_varchar2,
542: p_attribute15 in varchar2 default hr_api.g_varchar2,
543: p_attribute16 in varchar2 default hr_api.g_varchar2,
544: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 541: p_attribute14 in varchar2 default hr_api.g_varchar2,

537: p_attribute10 in varchar2 default hr_api.g_varchar2,
538: p_attribute11 in varchar2 default hr_api.g_varchar2,
539: p_attribute12 in varchar2 default hr_api.g_varchar2,
540: p_attribute13 in varchar2 default hr_api.g_varchar2,
541: p_attribute14 in varchar2 default hr_api.g_varchar2,
542: p_attribute15 in varchar2 default hr_api.g_varchar2,
543: p_attribute16 in varchar2 default hr_api.g_varchar2,
544: p_attribute17 in varchar2 default hr_api.g_varchar2,
545: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 542: p_attribute15 in varchar2 default hr_api.g_varchar2,

538: p_attribute11 in varchar2 default hr_api.g_varchar2,
539: p_attribute12 in varchar2 default hr_api.g_varchar2,
540: p_attribute13 in varchar2 default hr_api.g_varchar2,
541: p_attribute14 in varchar2 default hr_api.g_varchar2,
542: p_attribute15 in varchar2 default hr_api.g_varchar2,
543: p_attribute16 in varchar2 default hr_api.g_varchar2,
544: p_attribute17 in varchar2 default hr_api.g_varchar2,
545: p_attribute18 in varchar2 default hr_api.g_varchar2,
546: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 543: p_attribute16 in varchar2 default hr_api.g_varchar2,

539: p_attribute12 in varchar2 default hr_api.g_varchar2,
540: p_attribute13 in varchar2 default hr_api.g_varchar2,
541: p_attribute14 in varchar2 default hr_api.g_varchar2,
542: p_attribute15 in varchar2 default hr_api.g_varchar2,
543: p_attribute16 in varchar2 default hr_api.g_varchar2,
544: p_attribute17 in varchar2 default hr_api.g_varchar2,
545: p_attribute18 in varchar2 default hr_api.g_varchar2,
546: p_attribute19 in varchar2 default hr_api.g_varchar2,
547: p_attribute20 in varchar2 default hr_api.g_varchar2

Line 544: p_attribute17 in varchar2 default hr_api.g_varchar2,

540: p_attribute13 in varchar2 default hr_api.g_varchar2,
541: p_attribute14 in varchar2 default hr_api.g_varchar2,
542: p_attribute15 in varchar2 default hr_api.g_varchar2,
543: p_attribute16 in varchar2 default hr_api.g_varchar2,
544: p_attribute17 in varchar2 default hr_api.g_varchar2,
545: p_attribute18 in varchar2 default hr_api.g_varchar2,
546: p_attribute19 in varchar2 default hr_api.g_varchar2,
547: p_attribute20 in varchar2 default hr_api.g_varchar2
548: ) is

Line 545: p_attribute18 in varchar2 default hr_api.g_varchar2,

541: p_attribute14 in varchar2 default hr_api.g_varchar2,
542: p_attribute15 in varchar2 default hr_api.g_varchar2,
543: p_attribute16 in varchar2 default hr_api.g_varchar2,
544: p_attribute17 in varchar2 default hr_api.g_varchar2,
545: p_attribute18 in varchar2 default hr_api.g_varchar2,
546: p_attribute19 in varchar2 default hr_api.g_varchar2,
547: p_attribute20 in varchar2 default hr_api.g_varchar2
548: ) is
549: --

Line 546: p_attribute19 in varchar2 default hr_api.g_varchar2,

542: p_attribute15 in varchar2 default hr_api.g_varchar2,
543: p_attribute16 in varchar2 default hr_api.g_varchar2,
544: p_attribute17 in varchar2 default hr_api.g_varchar2,
545: p_attribute18 in varchar2 default hr_api.g_varchar2,
546: p_attribute19 in varchar2 default hr_api.g_varchar2,
547: p_attribute20 in varchar2 default hr_api.g_varchar2
548: ) is
549: --
550: l_rec per_pdm_shd.g_rec_type;

Line 547: p_attribute20 in varchar2 default hr_api.g_varchar2

543: p_attribute16 in varchar2 default hr_api.g_varchar2,
544: p_attribute17 in varchar2 default hr_api.g_varchar2,
545: p_attribute18 in varchar2 default hr_api.g_varchar2,
546: p_attribute19 in varchar2 default hr_api.g_varchar2,
547: p_attribute20 in varchar2 default hr_api.g_varchar2
548: ) is
549: --
550: l_rec per_pdm_shd.g_rec_type;
551: l_proc varchar2(72) := g_package||'upd';

Line 565: hr_api.g_number,

561: (
562: p_delivery_method_id,
563: p_date_start,
564: p_date_end,
565: hr_api.g_number,
566: p_comm_dlvry_method,
567: p_preferred_flag,
568: p_object_version_number,
569: p_request_id,