62: (
63: P_VALIDATE in boolean default false
64: ,P_DISPLAY_MANAGER_INFO in varchar2
65: ,P_DISPLAY_RECRUITER_INFO in varchar2
66: ,P_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang
67: ,P_NAME in varchar2
68: ,P_ORG_NAME in varchar2 default null
69: ,P_ORG_DESCRIPTION in varchar2 default null
70: ,P_JOB_TITLE in varchar2 default null
157: --
158: savepoint create_posting_content;
159: --
160: l_language_code:=p_language_code;
161: hr_api.validate_language_code(p_language_code => l_language_code);
162: --
163: -- Call Before Process User Hook
164: --
165: begin
244: ,P_IPC_INFORMATION30 => P_IPC_INFORMATION30
245: ,P_DATE_APPROVED => l_date_approved
246: );
247: exception
248: when hr_api.cannot_find_prog_unit then
249: hr_api.cannot_find_prog_unit_error
250: (p_module_name => 'create_posting_content'
251: ,p_hook_type => 'BP'
252: );
245: ,P_DATE_APPROVED => l_date_approved
246: );
247: exception
248: when hr_api.cannot_find_prog_unit then
249: hr_api.cannot_find_prog_unit_error
250: (p_module_name => 'create_posting_content'
251: ,p_hook_type => 'BP'
252: );
253: end;
430: ,P_POSTING_CONTENT_ID => l_posting_content_id
431: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
432: );
433: exception
434: when hr_api.cannot_find_prog_unit then
435: hr_api.cannot_find_prog_unit_error
436: (p_module_name => 'create_posting_content'
437: ,p_hook_type => 'AP'
438: );
431: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
432: );
433: exception
434: when hr_api.cannot_find_prog_unit then
435: hr_api.cannot_find_prog_unit_error
436: (p_module_name => 'create_posting_content'
437: ,p_hook_type => 'AP'
438: );
439: end;
440: --
441: -- When in validation only mode raise the Validate_Enabled exception
442: --
443: if p_validate then
444: raise hr_api.validate_enabled;
445: end if;
446: --
447: -- Set all output arguments
448: --
450: P_OBJECT_VERSION_NUMBER := l_object_version_number;
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 70);
453: exception
454: when hr_api.validate_enabled then
455: --
456: -- As the Validate_Enabled exception has been raised
457: -- we must rollback to the savepoint
458: --
485: procedure update_posting_content
486: (
487: P_VALIDATE in boolean default false
488: ,P_POSTING_CONTENT_ID in number
489: ,P_DISPLAY_MANAGER_INFO in varchar2 default hr_api.g_varchar2
490: ,P_DISPLAY_RECRUITER_INFO in varchar2 default hr_api.g_varchar2
491: ,P_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang
492: ,P_NAME in varchar2 default hr_api.g_varchar2
493: ,P_ORG_NAME in varchar2 default hr_api.g_varchar2
486: (
487: P_VALIDATE in boolean default false
488: ,P_POSTING_CONTENT_ID in number
489: ,P_DISPLAY_MANAGER_INFO in varchar2 default hr_api.g_varchar2
490: ,P_DISPLAY_RECRUITER_INFO in varchar2 default hr_api.g_varchar2
491: ,P_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang
492: ,P_NAME in varchar2 default hr_api.g_varchar2
493: ,P_ORG_NAME in varchar2 default hr_api.g_varchar2
494: ,P_ORG_DESCRIPTION in varchar2 default hr_api.g_varchar2
487: P_VALIDATE in boolean default false
488: ,P_POSTING_CONTENT_ID in number
489: ,P_DISPLAY_MANAGER_INFO in varchar2 default hr_api.g_varchar2
490: ,P_DISPLAY_RECRUITER_INFO in varchar2 default hr_api.g_varchar2
491: ,P_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang
492: ,P_NAME in varchar2 default hr_api.g_varchar2
493: ,P_ORG_NAME in varchar2 default hr_api.g_varchar2
494: ,P_ORG_DESCRIPTION in varchar2 default hr_api.g_varchar2
495: ,P_JOB_TITLE in varchar2 default hr_api.g_varchar2
488: ,P_POSTING_CONTENT_ID in number
489: ,P_DISPLAY_MANAGER_INFO in varchar2 default hr_api.g_varchar2
490: ,P_DISPLAY_RECRUITER_INFO in varchar2 default hr_api.g_varchar2
491: ,P_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang
492: ,P_NAME in varchar2 default hr_api.g_varchar2
493: ,P_ORG_NAME in varchar2 default hr_api.g_varchar2
494: ,P_ORG_DESCRIPTION in varchar2 default hr_api.g_varchar2
495: ,P_JOB_TITLE in varchar2 default hr_api.g_varchar2
496: ,P_BRIEF_DESCRIPTION in varchar2 default hr_api.g_varchar2
489: ,P_DISPLAY_MANAGER_INFO in varchar2 default hr_api.g_varchar2
490: ,P_DISPLAY_RECRUITER_INFO in varchar2 default hr_api.g_varchar2
491: ,P_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang
492: ,P_NAME in varchar2 default hr_api.g_varchar2
493: ,P_ORG_NAME in varchar2 default hr_api.g_varchar2
494: ,P_ORG_DESCRIPTION in varchar2 default hr_api.g_varchar2
495: ,P_JOB_TITLE in varchar2 default hr_api.g_varchar2
496: ,P_BRIEF_DESCRIPTION in varchar2 default hr_api.g_varchar2
497: ,P_DETAILED_DESCRIPTION in varchar2 default hr_api.g_varchar2
490: ,P_DISPLAY_RECRUITER_INFO in varchar2 default hr_api.g_varchar2
491: ,P_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang
492: ,P_NAME in varchar2 default hr_api.g_varchar2
493: ,P_ORG_NAME in varchar2 default hr_api.g_varchar2
494: ,P_ORG_DESCRIPTION in varchar2 default hr_api.g_varchar2
495: ,P_JOB_TITLE in varchar2 default hr_api.g_varchar2
496: ,P_BRIEF_DESCRIPTION in varchar2 default hr_api.g_varchar2
497: ,P_DETAILED_DESCRIPTION in varchar2 default hr_api.g_varchar2
498: ,P_JOB_REQUIREMENTS in varchar2 default hr_api.g_varchar2
491: ,P_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang
492: ,P_NAME in varchar2 default hr_api.g_varchar2
493: ,P_ORG_NAME in varchar2 default hr_api.g_varchar2
494: ,P_ORG_DESCRIPTION in varchar2 default hr_api.g_varchar2
495: ,P_JOB_TITLE in varchar2 default hr_api.g_varchar2
496: ,P_BRIEF_DESCRIPTION in varchar2 default hr_api.g_varchar2
497: ,P_DETAILED_DESCRIPTION in varchar2 default hr_api.g_varchar2
498: ,P_JOB_REQUIREMENTS in varchar2 default hr_api.g_varchar2
499: ,P_ADDITIONAL_DETAILS in varchar2 default hr_api.g_varchar2
492: ,P_NAME in varchar2 default hr_api.g_varchar2
493: ,P_ORG_NAME in varchar2 default hr_api.g_varchar2
494: ,P_ORG_DESCRIPTION in varchar2 default hr_api.g_varchar2
495: ,P_JOB_TITLE in varchar2 default hr_api.g_varchar2
496: ,P_BRIEF_DESCRIPTION in varchar2 default hr_api.g_varchar2
497: ,P_DETAILED_DESCRIPTION in varchar2 default hr_api.g_varchar2
498: ,P_JOB_REQUIREMENTS in varchar2 default hr_api.g_varchar2
499: ,P_ADDITIONAL_DETAILS in varchar2 default hr_api.g_varchar2
500: ,P_HOW_TO_APPLY in varchar2 default hr_api.g_varchar2
493: ,P_ORG_NAME in varchar2 default hr_api.g_varchar2
494: ,P_ORG_DESCRIPTION in varchar2 default hr_api.g_varchar2
495: ,P_JOB_TITLE in varchar2 default hr_api.g_varchar2
496: ,P_BRIEF_DESCRIPTION in varchar2 default hr_api.g_varchar2
497: ,P_DETAILED_DESCRIPTION in varchar2 default hr_api.g_varchar2
498: ,P_JOB_REQUIREMENTS in varchar2 default hr_api.g_varchar2
499: ,P_ADDITIONAL_DETAILS in varchar2 default hr_api.g_varchar2
500: ,P_HOW_TO_APPLY in varchar2 default hr_api.g_varchar2
501: ,P_BENEFIT_INFO in varchar2 default hr_api.g_varchar2
494: ,P_ORG_DESCRIPTION in varchar2 default hr_api.g_varchar2
495: ,P_JOB_TITLE in varchar2 default hr_api.g_varchar2
496: ,P_BRIEF_DESCRIPTION in varchar2 default hr_api.g_varchar2
497: ,P_DETAILED_DESCRIPTION in varchar2 default hr_api.g_varchar2
498: ,P_JOB_REQUIREMENTS in varchar2 default hr_api.g_varchar2
499: ,P_ADDITIONAL_DETAILS in varchar2 default hr_api.g_varchar2
500: ,P_HOW_TO_APPLY in varchar2 default hr_api.g_varchar2
501: ,P_BENEFIT_INFO in varchar2 default hr_api.g_varchar2
502: ,P_IMAGE_URL in varchar2 default hr_api.g_varchar2
495: ,P_JOB_TITLE in varchar2 default hr_api.g_varchar2
496: ,P_BRIEF_DESCRIPTION in varchar2 default hr_api.g_varchar2
497: ,P_DETAILED_DESCRIPTION in varchar2 default hr_api.g_varchar2
498: ,P_JOB_REQUIREMENTS in varchar2 default hr_api.g_varchar2
499: ,P_ADDITIONAL_DETAILS in varchar2 default hr_api.g_varchar2
500: ,P_HOW_TO_APPLY in varchar2 default hr_api.g_varchar2
501: ,P_BENEFIT_INFO in varchar2 default hr_api.g_varchar2
502: ,P_IMAGE_URL in varchar2 default hr_api.g_varchar2
503: ,P_ALT_IMAGE_URL in varchar2 default hr_api.g_varchar2
496: ,P_BRIEF_DESCRIPTION in varchar2 default hr_api.g_varchar2
497: ,P_DETAILED_DESCRIPTION in varchar2 default hr_api.g_varchar2
498: ,P_JOB_REQUIREMENTS in varchar2 default hr_api.g_varchar2
499: ,P_ADDITIONAL_DETAILS in varchar2 default hr_api.g_varchar2
500: ,P_HOW_TO_APPLY in varchar2 default hr_api.g_varchar2
501: ,P_BENEFIT_INFO in varchar2 default hr_api.g_varchar2
502: ,P_IMAGE_URL in varchar2 default hr_api.g_varchar2
503: ,P_ALT_IMAGE_URL in varchar2 default hr_api.g_varchar2
504: ,P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
497: ,P_DETAILED_DESCRIPTION in varchar2 default hr_api.g_varchar2
498: ,P_JOB_REQUIREMENTS in varchar2 default hr_api.g_varchar2
499: ,P_ADDITIONAL_DETAILS in varchar2 default hr_api.g_varchar2
500: ,P_HOW_TO_APPLY in varchar2 default hr_api.g_varchar2
501: ,P_BENEFIT_INFO in varchar2 default hr_api.g_varchar2
502: ,P_IMAGE_URL in varchar2 default hr_api.g_varchar2
503: ,P_ALT_IMAGE_URL in varchar2 default hr_api.g_varchar2
504: ,P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
505: ,P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
498: ,P_JOB_REQUIREMENTS in varchar2 default hr_api.g_varchar2
499: ,P_ADDITIONAL_DETAILS in varchar2 default hr_api.g_varchar2
500: ,P_HOW_TO_APPLY in varchar2 default hr_api.g_varchar2
501: ,P_BENEFIT_INFO in varchar2 default hr_api.g_varchar2
502: ,P_IMAGE_URL in varchar2 default hr_api.g_varchar2
503: ,P_ALT_IMAGE_URL in varchar2 default hr_api.g_varchar2
504: ,P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
505: ,P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
506: ,P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
499: ,P_ADDITIONAL_DETAILS in varchar2 default hr_api.g_varchar2
500: ,P_HOW_TO_APPLY in varchar2 default hr_api.g_varchar2
501: ,P_BENEFIT_INFO in varchar2 default hr_api.g_varchar2
502: ,P_IMAGE_URL in varchar2 default hr_api.g_varchar2
503: ,P_ALT_IMAGE_URL in varchar2 default hr_api.g_varchar2
504: ,P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
505: ,P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
506: ,P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
507: ,P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
500: ,P_HOW_TO_APPLY in varchar2 default hr_api.g_varchar2
501: ,P_BENEFIT_INFO in varchar2 default hr_api.g_varchar2
502: ,P_IMAGE_URL in varchar2 default hr_api.g_varchar2
503: ,P_ALT_IMAGE_URL in varchar2 default hr_api.g_varchar2
504: ,P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
505: ,P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
506: ,P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
507: ,P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
508: ,P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
501: ,P_BENEFIT_INFO in varchar2 default hr_api.g_varchar2
502: ,P_IMAGE_URL in varchar2 default hr_api.g_varchar2
503: ,P_ALT_IMAGE_URL in varchar2 default hr_api.g_varchar2
504: ,P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
505: ,P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
506: ,P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
507: ,P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
508: ,P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
509: ,P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
502: ,P_IMAGE_URL in varchar2 default hr_api.g_varchar2
503: ,P_ALT_IMAGE_URL in varchar2 default hr_api.g_varchar2
504: ,P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
505: ,P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
506: ,P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
507: ,P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
508: ,P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
509: ,P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
510: ,P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
503: ,P_ALT_IMAGE_URL in varchar2 default hr_api.g_varchar2
504: ,P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
505: ,P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
506: ,P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
507: ,P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
508: ,P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
509: ,P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
510: ,P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
511: ,P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
504: ,P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
505: ,P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
506: ,P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
507: ,P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
508: ,P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
509: ,P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
510: ,P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
511: ,P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
512: ,P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
505: ,P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
506: ,P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
507: ,P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
508: ,P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
509: ,P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
510: ,P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
511: ,P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
512: ,P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
513: ,P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
506: ,P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
507: ,P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
508: ,P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
509: ,P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
510: ,P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
511: ,P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
512: ,P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
513: ,P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
514: ,P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
507: ,P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
508: ,P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
509: ,P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
510: ,P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
511: ,P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
512: ,P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
513: ,P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
514: ,P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
515: ,P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
508: ,P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
509: ,P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
510: ,P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
511: ,P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
512: ,P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
513: ,P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
514: ,P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
515: ,P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
516: ,P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
509: ,P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
510: ,P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
511: ,P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
512: ,P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
513: ,P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
514: ,P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
515: ,P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
516: ,P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
517: ,P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
510: ,P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
511: ,P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
512: ,P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
513: ,P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
514: ,P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
515: ,P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
516: ,P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
517: ,P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
518: ,P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
511: ,P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
512: ,P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
513: ,P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
514: ,P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
515: ,P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
516: ,P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
517: ,P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
518: ,P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
519: ,P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
512: ,P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
513: ,P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
514: ,P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
515: ,P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
516: ,P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
517: ,P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
518: ,P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
519: ,P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
520: ,P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
513: ,P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
514: ,P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
515: ,P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
516: ,P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
517: ,P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
518: ,P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
519: ,P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
520: ,P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
521: ,P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
514: ,P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
515: ,P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
516: ,P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
517: ,P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
518: ,P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
519: ,P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
520: ,P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
521: ,P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
522: ,P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
515: ,P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
516: ,P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
517: ,P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
518: ,P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
519: ,P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
520: ,P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
521: ,P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
522: ,P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
523: ,P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
516: ,P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
517: ,P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
518: ,P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
519: ,P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
520: ,P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
521: ,P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
522: ,P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
523: ,P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
524: ,P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
517: ,P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
518: ,P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
519: ,P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
520: ,P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
521: ,P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
522: ,P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
523: ,P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
524: ,P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
525: ,P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
518: ,P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
519: ,P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
520: ,P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
521: ,P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
522: ,P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
523: ,P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
524: ,P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
525: ,P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
526: ,P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
519: ,P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
520: ,P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
521: ,P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
522: ,P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
523: ,P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
524: ,P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
525: ,P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
526: ,P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
527: ,P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
520: ,P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
521: ,P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
522: ,P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
523: ,P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
524: ,P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
525: ,P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
526: ,P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
527: ,P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
528: ,P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
521: ,P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
522: ,P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
523: ,P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
524: ,P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
525: ,P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
526: ,P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
527: ,P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
528: ,P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
529: ,P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
522: ,P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
523: ,P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
524: ,P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
525: ,P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
526: ,P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
527: ,P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
528: ,P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
529: ,P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
530: ,P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
523: ,P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
524: ,P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
525: ,P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
526: ,P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
527: ,P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
528: ,P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
529: ,P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
530: ,P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
531: ,P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
524: ,P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
525: ,P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
526: ,P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
527: ,P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
528: ,P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
529: ,P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
530: ,P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
531: ,P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
532: ,P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
525: ,P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
526: ,P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
527: ,P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
528: ,P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
529: ,P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
530: ,P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
531: ,P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
532: ,P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
533: ,P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
526: ,P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
527: ,P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
528: ,P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
529: ,P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
530: ,P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
531: ,P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
532: ,P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
533: ,P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
534: ,P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
527: ,P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
528: ,P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
529: ,P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
530: ,P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
531: ,P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
532: ,P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
533: ,P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
534: ,P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
535: ,P_IPC_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
528: ,P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
529: ,P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
530: ,P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
531: ,P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
532: ,P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
533: ,P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
534: ,P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
535: ,P_IPC_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
536: ,P_IPC_INFORMATION1 in varchar2 default hr_api.g_varchar2
529: ,P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
530: ,P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
531: ,P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
532: ,P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
533: ,P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
534: ,P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
535: ,P_IPC_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
536: ,P_IPC_INFORMATION1 in varchar2 default hr_api.g_varchar2
537: ,P_IPC_INFORMATION2 in varchar2 default hr_api.g_varchar2
530: ,P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
531: ,P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
532: ,P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
533: ,P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
534: ,P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
535: ,P_IPC_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
536: ,P_IPC_INFORMATION1 in varchar2 default hr_api.g_varchar2
537: ,P_IPC_INFORMATION2 in varchar2 default hr_api.g_varchar2
538: ,P_IPC_INFORMATION3 in varchar2 default hr_api.g_varchar2
531: ,P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
532: ,P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
533: ,P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
534: ,P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
535: ,P_IPC_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
536: ,P_IPC_INFORMATION1 in varchar2 default hr_api.g_varchar2
537: ,P_IPC_INFORMATION2 in varchar2 default hr_api.g_varchar2
538: ,P_IPC_INFORMATION3 in varchar2 default hr_api.g_varchar2
539: ,P_IPC_INFORMATION4 in varchar2 default hr_api.g_varchar2
532: ,P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
533: ,P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
534: ,P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
535: ,P_IPC_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
536: ,P_IPC_INFORMATION1 in varchar2 default hr_api.g_varchar2
537: ,P_IPC_INFORMATION2 in varchar2 default hr_api.g_varchar2
538: ,P_IPC_INFORMATION3 in varchar2 default hr_api.g_varchar2
539: ,P_IPC_INFORMATION4 in varchar2 default hr_api.g_varchar2
540: ,P_IPC_INFORMATION5 in varchar2 default hr_api.g_varchar2
533: ,P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
534: ,P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
535: ,P_IPC_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
536: ,P_IPC_INFORMATION1 in varchar2 default hr_api.g_varchar2
537: ,P_IPC_INFORMATION2 in varchar2 default hr_api.g_varchar2
538: ,P_IPC_INFORMATION3 in varchar2 default hr_api.g_varchar2
539: ,P_IPC_INFORMATION4 in varchar2 default hr_api.g_varchar2
540: ,P_IPC_INFORMATION5 in varchar2 default hr_api.g_varchar2
541: ,P_IPC_INFORMATION6 in varchar2 default hr_api.g_varchar2
534: ,P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
535: ,P_IPC_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
536: ,P_IPC_INFORMATION1 in varchar2 default hr_api.g_varchar2
537: ,P_IPC_INFORMATION2 in varchar2 default hr_api.g_varchar2
538: ,P_IPC_INFORMATION3 in varchar2 default hr_api.g_varchar2
539: ,P_IPC_INFORMATION4 in varchar2 default hr_api.g_varchar2
540: ,P_IPC_INFORMATION5 in varchar2 default hr_api.g_varchar2
541: ,P_IPC_INFORMATION6 in varchar2 default hr_api.g_varchar2
542: ,P_IPC_INFORMATION7 in varchar2 default hr_api.g_varchar2
535: ,P_IPC_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
536: ,P_IPC_INFORMATION1 in varchar2 default hr_api.g_varchar2
537: ,P_IPC_INFORMATION2 in varchar2 default hr_api.g_varchar2
538: ,P_IPC_INFORMATION3 in varchar2 default hr_api.g_varchar2
539: ,P_IPC_INFORMATION4 in varchar2 default hr_api.g_varchar2
540: ,P_IPC_INFORMATION5 in varchar2 default hr_api.g_varchar2
541: ,P_IPC_INFORMATION6 in varchar2 default hr_api.g_varchar2
542: ,P_IPC_INFORMATION7 in varchar2 default hr_api.g_varchar2
543: ,P_IPC_INFORMATION8 in varchar2 default hr_api.g_varchar2
536: ,P_IPC_INFORMATION1 in varchar2 default hr_api.g_varchar2
537: ,P_IPC_INFORMATION2 in varchar2 default hr_api.g_varchar2
538: ,P_IPC_INFORMATION3 in varchar2 default hr_api.g_varchar2
539: ,P_IPC_INFORMATION4 in varchar2 default hr_api.g_varchar2
540: ,P_IPC_INFORMATION5 in varchar2 default hr_api.g_varchar2
541: ,P_IPC_INFORMATION6 in varchar2 default hr_api.g_varchar2
542: ,P_IPC_INFORMATION7 in varchar2 default hr_api.g_varchar2
543: ,P_IPC_INFORMATION8 in varchar2 default hr_api.g_varchar2
544: ,P_IPC_INFORMATION9 in varchar2 default hr_api.g_varchar2
537: ,P_IPC_INFORMATION2 in varchar2 default hr_api.g_varchar2
538: ,P_IPC_INFORMATION3 in varchar2 default hr_api.g_varchar2
539: ,P_IPC_INFORMATION4 in varchar2 default hr_api.g_varchar2
540: ,P_IPC_INFORMATION5 in varchar2 default hr_api.g_varchar2
541: ,P_IPC_INFORMATION6 in varchar2 default hr_api.g_varchar2
542: ,P_IPC_INFORMATION7 in varchar2 default hr_api.g_varchar2
543: ,P_IPC_INFORMATION8 in varchar2 default hr_api.g_varchar2
544: ,P_IPC_INFORMATION9 in varchar2 default hr_api.g_varchar2
545: ,P_IPC_INFORMATION10 in varchar2 default hr_api.g_varchar2
538: ,P_IPC_INFORMATION3 in varchar2 default hr_api.g_varchar2
539: ,P_IPC_INFORMATION4 in varchar2 default hr_api.g_varchar2
540: ,P_IPC_INFORMATION5 in varchar2 default hr_api.g_varchar2
541: ,P_IPC_INFORMATION6 in varchar2 default hr_api.g_varchar2
542: ,P_IPC_INFORMATION7 in varchar2 default hr_api.g_varchar2
543: ,P_IPC_INFORMATION8 in varchar2 default hr_api.g_varchar2
544: ,P_IPC_INFORMATION9 in varchar2 default hr_api.g_varchar2
545: ,P_IPC_INFORMATION10 in varchar2 default hr_api.g_varchar2
546: ,P_IPC_INFORMATION11 in varchar2 default hr_api.g_varchar2
539: ,P_IPC_INFORMATION4 in varchar2 default hr_api.g_varchar2
540: ,P_IPC_INFORMATION5 in varchar2 default hr_api.g_varchar2
541: ,P_IPC_INFORMATION6 in varchar2 default hr_api.g_varchar2
542: ,P_IPC_INFORMATION7 in varchar2 default hr_api.g_varchar2
543: ,P_IPC_INFORMATION8 in varchar2 default hr_api.g_varchar2
544: ,P_IPC_INFORMATION9 in varchar2 default hr_api.g_varchar2
545: ,P_IPC_INFORMATION10 in varchar2 default hr_api.g_varchar2
546: ,P_IPC_INFORMATION11 in varchar2 default hr_api.g_varchar2
547: ,P_IPC_INFORMATION12 in varchar2 default hr_api.g_varchar2
540: ,P_IPC_INFORMATION5 in varchar2 default hr_api.g_varchar2
541: ,P_IPC_INFORMATION6 in varchar2 default hr_api.g_varchar2
542: ,P_IPC_INFORMATION7 in varchar2 default hr_api.g_varchar2
543: ,P_IPC_INFORMATION8 in varchar2 default hr_api.g_varchar2
544: ,P_IPC_INFORMATION9 in varchar2 default hr_api.g_varchar2
545: ,P_IPC_INFORMATION10 in varchar2 default hr_api.g_varchar2
546: ,P_IPC_INFORMATION11 in varchar2 default hr_api.g_varchar2
547: ,P_IPC_INFORMATION12 in varchar2 default hr_api.g_varchar2
548: ,P_IPC_INFORMATION13 in varchar2 default hr_api.g_varchar2
541: ,P_IPC_INFORMATION6 in varchar2 default hr_api.g_varchar2
542: ,P_IPC_INFORMATION7 in varchar2 default hr_api.g_varchar2
543: ,P_IPC_INFORMATION8 in varchar2 default hr_api.g_varchar2
544: ,P_IPC_INFORMATION9 in varchar2 default hr_api.g_varchar2
545: ,P_IPC_INFORMATION10 in varchar2 default hr_api.g_varchar2
546: ,P_IPC_INFORMATION11 in varchar2 default hr_api.g_varchar2
547: ,P_IPC_INFORMATION12 in varchar2 default hr_api.g_varchar2
548: ,P_IPC_INFORMATION13 in varchar2 default hr_api.g_varchar2
549: ,P_IPC_INFORMATION14 in varchar2 default hr_api.g_varchar2
542: ,P_IPC_INFORMATION7 in varchar2 default hr_api.g_varchar2
543: ,P_IPC_INFORMATION8 in varchar2 default hr_api.g_varchar2
544: ,P_IPC_INFORMATION9 in varchar2 default hr_api.g_varchar2
545: ,P_IPC_INFORMATION10 in varchar2 default hr_api.g_varchar2
546: ,P_IPC_INFORMATION11 in varchar2 default hr_api.g_varchar2
547: ,P_IPC_INFORMATION12 in varchar2 default hr_api.g_varchar2
548: ,P_IPC_INFORMATION13 in varchar2 default hr_api.g_varchar2
549: ,P_IPC_INFORMATION14 in varchar2 default hr_api.g_varchar2
550: ,P_IPC_INFORMATION15 in varchar2 default hr_api.g_varchar2
543: ,P_IPC_INFORMATION8 in varchar2 default hr_api.g_varchar2
544: ,P_IPC_INFORMATION9 in varchar2 default hr_api.g_varchar2
545: ,P_IPC_INFORMATION10 in varchar2 default hr_api.g_varchar2
546: ,P_IPC_INFORMATION11 in varchar2 default hr_api.g_varchar2
547: ,P_IPC_INFORMATION12 in varchar2 default hr_api.g_varchar2
548: ,P_IPC_INFORMATION13 in varchar2 default hr_api.g_varchar2
549: ,P_IPC_INFORMATION14 in varchar2 default hr_api.g_varchar2
550: ,P_IPC_INFORMATION15 in varchar2 default hr_api.g_varchar2
551: ,P_IPC_INFORMATION16 in varchar2 default hr_api.g_varchar2
544: ,P_IPC_INFORMATION9 in varchar2 default hr_api.g_varchar2
545: ,P_IPC_INFORMATION10 in varchar2 default hr_api.g_varchar2
546: ,P_IPC_INFORMATION11 in varchar2 default hr_api.g_varchar2
547: ,P_IPC_INFORMATION12 in varchar2 default hr_api.g_varchar2
548: ,P_IPC_INFORMATION13 in varchar2 default hr_api.g_varchar2
549: ,P_IPC_INFORMATION14 in varchar2 default hr_api.g_varchar2
550: ,P_IPC_INFORMATION15 in varchar2 default hr_api.g_varchar2
551: ,P_IPC_INFORMATION16 in varchar2 default hr_api.g_varchar2
552: ,P_IPC_INFORMATION17 in varchar2 default hr_api.g_varchar2
545: ,P_IPC_INFORMATION10 in varchar2 default hr_api.g_varchar2
546: ,P_IPC_INFORMATION11 in varchar2 default hr_api.g_varchar2
547: ,P_IPC_INFORMATION12 in varchar2 default hr_api.g_varchar2
548: ,P_IPC_INFORMATION13 in varchar2 default hr_api.g_varchar2
549: ,P_IPC_INFORMATION14 in varchar2 default hr_api.g_varchar2
550: ,P_IPC_INFORMATION15 in varchar2 default hr_api.g_varchar2
551: ,P_IPC_INFORMATION16 in varchar2 default hr_api.g_varchar2
552: ,P_IPC_INFORMATION17 in varchar2 default hr_api.g_varchar2
553: ,P_IPC_INFORMATION18 in varchar2 default hr_api.g_varchar2
546: ,P_IPC_INFORMATION11 in varchar2 default hr_api.g_varchar2
547: ,P_IPC_INFORMATION12 in varchar2 default hr_api.g_varchar2
548: ,P_IPC_INFORMATION13 in varchar2 default hr_api.g_varchar2
549: ,P_IPC_INFORMATION14 in varchar2 default hr_api.g_varchar2
550: ,P_IPC_INFORMATION15 in varchar2 default hr_api.g_varchar2
551: ,P_IPC_INFORMATION16 in varchar2 default hr_api.g_varchar2
552: ,P_IPC_INFORMATION17 in varchar2 default hr_api.g_varchar2
553: ,P_IPC_INFORMATION18 in varchar2 default hr_api.g_varchar2
554: ,P_IPC_INFORMATION19 in varchar2 default hr_api.g_varchar2
547: ,P_IPC_INFORMATION12 in varchar2 default hr_api.g_varchar2
548: ,P_IPC_INFORMATION13 in varchar2 default hr_api.g_varchar2
549: ,P_IPC_INFORMATION14 in varchar2 default hr_api.g_varchar2
550: ,P_IPC_INFORMATION15 in varchar2 default hr_api.g_varchar2
551: ,P_IPC_INFORMATION16 in varchar2 default hr_api.g_varchar2
552: ,P_IPC_INFORMATION17 in varchar2 default hr_api.g_varchar2
553: ,P_IPC_INFORMATION18 in varchar2 default hr_api.g_varchar2
554: ,P_IPC_INFORMATION19 in varchar2 default hr_api.g_varchar2
555: ,P_IPC_INFORMATION20 in varchar2 default hr_api.g_varchar2
548: ,P_IPC_INFORMATION13 in varchar2 default hr_api.g_varchar2
549: ,P_IPC_INFORMATION14 in varchar2 default hr_api.g_varchar2
550: ,P_IPC_INFORMATION15 in varchar2 default hr_api.g_varchar2
551: ,P_IPC_INFORMATION16 in varchar2 default hr_api.g_varchar2
552: ,P_IPC_INFORMATION17 in varchar2 default hr_api.g_varchar2
553: ,P_IPC_INFORMATION18 in varchar2 default hr_api.g_varchar2
554: ,P_IPC_INFORMATION19 in varchar2 default hr_api.g_varchar2
555: ,P_IPC_INFORMATION20 in varchar2 default hr_api.g_varchar2
556: ,P_IPC_INFORMATION21 in varchar2 default hr_api.g_varchar2
549: ,P_IPC_INFORMATION14 in varchar2 default hr_api.g_varchar2
550: ,P_IPC_INFORMATION15 in varchar2 default hr_api.g_varchar2
551: ,P_IPC_INFORMATION16 in varchar2 default hr_api.g_varchar2
552: ,P_IPC_INFORMATION17 in varchar2 default hr_api.g_varchar2
553: ,P_IPC_INFORMATION18 in varchar2 default hr_api.g_varchar2
554: ,P_IPC_INFORMATION19 in varchar2 default hr_api.g_varchar2
555: ,P_IPC_INFORMATION20 in varchar2 default hr_api.g_varchar2
556: ,P_IPC_INFORMATION21 in varchar2 default hr_api.g_varchar2
557: ,P_IPC_INFORMATION22 in varchar2 default hr_api.g_varchar2
550: ,P_IPC_INFORMATION15 in varchar2 default hr_api.g_varchar2
551: ,P_IPC_INFORMATION16 in varchar2 default hr_api.g_varchar2
552: ,P_IPC_INFORMATION17 in varchar2 default hr_api.g_varchar2
553: ,P_IPC_INFORMATION18 in varchar2 default hr_api.g_varchar2
554: ,P_IPC_INFORMATION19 in varchar2 default hr_api.g_varchar2
555: ,P_IPC_INFORMATION20 in varchar2 default hr_api.g_varchar2
556: ,P_IPC_INFORMATION21 in varchar2 default hr_api.g_varchar2
557: ,P_IPC_INFORMATION22 in varchar2 default hr_api.g_varchar2
558: ,P_IPC_INFORMATION23 in varchar2 default hr_api.g_varchar2
551: ,P_IPC_INFORMATION16 in varchar2 default hr_api.g_varchar2
552: ,P_IPC_INFORMATION17 in varchar2 default hr_api.g_varchar2
553: ,P_IPC_INFORMATION18 in varchar2 default hr_api.g_varchar2
554: ,P_IPC_INFORMATION19 in varchar2 default hr_api.g_varchar2
555: ,P_IPC_INFORMATION20 in varchar2 default hr_api.g_varchar2
556: ,P_IPC_INFORMATION21 in varchar2 default hr_api.g_varchar2
557: ,P_IPC_INFORMATION22 in varchar2 default hr_api.g_varchar2
558: ,P_IPC_INFORMATION23 in varchar2 default hr_api.g_varchar2
559: ,P_IPC_INFORMATION24 in varchar2 default hr_api.g_varchar2
552: ,P_IPC_INFORMATION17 in varchar2 default hr_api.g_varchar2
553: ,P_IPC_INFORMATION18 in varchar2 default hr_api.g_varchar2
554: ,P_IPC_INFORMATION19 in varchar2 default hr_api.g_varchar2
555: ,P_IPC_INFORMATION20 in varchar2 default hr_api.g_varchar2
556: ,P_IPC_INFORMATION21 in varchar2 default hr_api.g_varchar2
557: ,P_IPC_INFORMATION22 in varchar2 default hr_api.g_varchar2
558: ,P_IPC_INFORMATION23 in varchar2 default hr_api.g_varchar2
559: ,P_IPC_INFORMATION24 in varchar2 default hr_api.g_varchar2
560: ,P_IPC_INFORMATION25 in varchar2 default hr_api.g_varchar2
553: ,P_IPC_INFORMATION18 in varchar2 default hr_api.g_varchar2
554: ,P_IPC_INFORMATION19 in varchar2 default hr_api.g_varchar2
555: ,P_IPC_INFORMATION20 in varchar2 default hr_api.g_varchar2
556: ,P_IPC_INFORMATION21 in varchar2 default hr_api.g_varchar2
557: ,P_IPC_INFORMATION22 in varchar2 default hr_api.g_varchar2
558: ,P_IPC_INFORMATION23 in varchar2 default hr_api.g_varchar2
559: ,P_IPC_INFORMATION24 in varchar2 default hr_api.g_varchar2
560: ,P_IPC_INFORMATION25 in varchar2 default hr_api.g_varchar2
561: ,P_IPC_INFORMATION26 in varchar2 default hr_api.g_varchar2
554: ,P_IPC_INFORMATION19 in varchar2 default hr_api.g_varchar2
555: ,P_IPC_INFORMATION20 in varchar2 default hr_api.g_varchar2
556: ,P_IPC_INFORMATION21 in varchar2 default hr_api.g_varchar2
557: ,P_IPC_INFORMATION22 in varchar2 default hr_api.g_varchar2
558: ,P_IPC_INFORMATION23 in varchar2 default hr_api.g_varchar2
559: ,P_IPC_INFORMATION24 in varchar2 default hr_api.g_varchar2
560: ,P_IPC_INFORMATION25 in varchar2 default hr_api.g_varchar2
561: ,P_IPC_INFORMATION26 in varchar2 default hr_api.g_varchar2
562: ,P_IPC_INFORMATION27 in varchar2 default hr_api.g_varchar2
555: ,P_IPC_INFORMATION20 in varchar2 default hr_api.g_varchar2
556: ,P_IPC_INFORMATION21 in varchar2 default hr_api.g_varchar2
557: ,P_IPC_INFORMATION22 in varchar2 default hr_api.g_varchar2
558: ,P_IPC_INFORMATION23 in varchar2 default hr_api.g_varchar2
559: ,P_IPC_INFORMATION24 in varchar2 default hr_api.g_varchar2
560: ,P_IPC_INFORMATION25 in varchar2 default hr_api.g_varchar2
561: ,P_IPC_INFORMATION26 in varchar2 default hr_api.g_varchar2
562: ,P_IPC_INFORMATION27 in varchar2 default hr_api.g_varchar2
563: ,P_IPC_INFORMATION28 in varchar2 default hr_api.g_varchar2
556: ,P_IPC_INFORMATION21 in varchar2 default hr_api.g_varchar2
557: ,P_IPC_INFORMATION22 in varchar2 default hr_api.g_varchar2
558: ,P_IPC_INFORMATION23 in varchar2 default hr_api.g_varchar2
559: ,P_IPC_INFORMATION24 in varchar2 default hr_api.g_varchar2
560: ,P_IPC_INFORMATION25 in varchar2 default hr_api.g_varchar2
561: ,P_IPC_INFORMATION26 in varchar2 default hr_api.g_varchar2
562: ,P_IPC_INFORMATION27 in varchar2 default hr_api.g_varchar2
563: ,P_IPC_INFORMATION28 in varchar2 default hr_api.g_varchar2
564: ,P_IPC_INFORMATION29 in varchar2 default hr_api.g_varchar2
557: ,P_IPC_INFORMATION22 in varchar2 default hr_api.g_varchar2
558: ,P_IPC_INFORMATION23 in varchar2 default hr_api.g_varchar2
559: ,P_IPC_INFORMATION24 in varchar2 default hr_api.g_varchar2
560: ,P_IPC_INFORMATION25 in varchar2 default hr_api.g_varchar2
561: ,P_IPC_INFORMATION26 in varchar2 default hr_api.g_varchar2
562: ,P_IPC_INFORMATION27 in varchar2 default hr_api.g_varchar2
563: ,P_IPC_INFORMATION28 in varchar2 default hr_api.g_varchar2
564: ,P_IPC_INFORMATION29 in varchar2 default hr_api.g_varchar2
565: ,P_IPC_INFORMATION30 in varchar2 default hr_api.g_varchar2
558: ,P_IPC_INFORMATION23 in varchar2 default hr_api.g_varchar2
559: ,P_IPC_INFORMATION24 in varchar2 default hr_api.g_varchar2
560: ,P_IPC_INFORMATION25 in varchar2 default hr_api.g_varchar2
561: ,P_IPC_INFORMATION26 in varchar2 default hr_api.g_varchar2
562: ,P_IPC_INFORMATION27 in varchar2 default hr_api.g_varchar2
563: ,P_IPC_INFORMATION28 in varchar2 default hr_api.g_varchar2
564: ,P_IPC_INFORMATION29 in varchar2 default hr_api.g_varchar2
565: ,P_IPC_INFORMATION30 in varchar2 default hr_api.g_varchar2
566: ,P_DATE_APPROVED in date default hr_api.g_date
559: ,P_IPC_INFORMATION24 in varchar2 default hr_api.g_varchar2
560: ,P_IPC_INFORMATION25 in varchar2 default hr_api.g_varchar2
561: ,P_IPC_INFORMATION26 in varchar2 default hr_api.g_varchar2
562: ,P_IPC_INFORMATION27 in varchar2 default hr_api.g_varchar2
563: ,P_IPC_INFORMATION28 in varchar2 default hr_api.g_varchar2
564: ,P_IPC_INFORMATION29 in varchar2 default hr_api.g_varchar2
565: ,P_IPC_INFORMATION30 in varchar2 default hr_api.g_varchar2
566: ,P_DATE_APPROVED in date default hr_api.g_date
567: ,P_OBJECT_VERSION_NUMBER in out nocopy number
560: ,P_IPC_INFORMATION25 in varchar2 default hr_api.g_varchar2
561: ,P_IPC_INFORMATION26 in varchar2 default hr_api.g_varchar2
562: ,P_IPC_INFORMATION27 in varchar2 default hr_api.g_varchar2
563: ,P_IPC_INFORMATION28 in varchar2 default hr_api.g_varchar2
564: ,P_IPC_INFORMATION29 in varchar2 default hr_api.g_varchar2
565: ,P_IPC_INFORMATION30 in varchar2 default hr_api.g_varchar2
566: ,P_DATE_APPROVED in date default hr_api.g_date
567: ,P_OBJECT_VERSION_NUMBER in out nocopy number
568: )
561: ,P_IPC_INFORMATION26 in varchar2 default hr_api.g_varchar2
562: ,P_IPC_INFORMATION27 in varchar2 default hr_api.g_varchar2
563: ,P_IPC_INFORMATION28 in varchar2 default hr_api.g_varchar2
564: ,P_IPC_INFORMATION29 in varchar2 default hr_api.g_varchar2
565: ,P_IPC_INFORMATION30 in varchar2 default hr_api.g_varchar2
566: ,P_DATE_APPROVED in date default hr_api.g_date
567: ,P_OBJECT_VERSION_NUMBER in out nocopy number
568: )
569: is
562: ,P_IPC_INFORMATION27 in varchar2 default hr_api.g_varchar2
563: ,P_IPC_INFORMATION28 in varchar2 default hr_api.g_varchar2
564: ,P_IPC_INFORMATION29 in varchar2 default hr_api.g_varchar2
565: ,P_IPC_INFORMATION30 in varchar2 default hr_api.g_varchar2
566: ,P_DATE_APPROVED in date default hr_api.g_date
567: ,P_OBJECT_VERSION_NUMBER in out nocopy number
568: )
569: is
570: --
581: --
582: savepoint update_posting_content;
583: --
584: l_language_code:=p_language_code;
585: hr_api.validate_language_code(p_language_code => l_language_code);
586: --
587: --
588: -- Call Before Process User Hook
589: --
671: ,P_DATE_APPROVED => l_date_approved
672: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
673: );
674: exception
675: when hr_api.cannot_find_prog_unit then
676: hr_api.cannot_find_prog_unit_error
677: (p_module_name => 'update_posting_content'
678: ,p_hook_type => 'BP'
679: );
672: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
673: );
674: exception
675: when hr_api.cannot_find_prog_unit then
676: hr_api.cannot_find_prog_unit_error
677: (p_module_name => 'update_posting_content'
678: ,p_hook_type => 'BP'
679: );
680: end;
856: ,P_DATE_APPROVED => l_date_approved
857: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
858: );
859: exception
860: when hr_api.cannot_find_prog_unit then
861: hr_api.cannot_find_prog_unit_error
862: (p_module_name => 'update_posting_content'
863: ,p_hook_type => 'AP'
864: );
857: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
858: );
859: exception
860: when hr_api.cannot_find_prog_unit then
861: hr_api.cannot_find_prog_unit_error
862: (p_module_name => 'update_posting_content'
863: ,p_hook_type => 'AP'
864: );
865: end;
866: --
867: -- When in validation only mode raise the Validate_Enabled exception
868: --
869: if p_validate then
870: raise hr_api.validate_enabled;
871: end if;
872: --
873: -- Set all output arguments
874: --
875: P_OBJECT_VERSION_NUMBER := l_object_version_number;
876: --
877: hr_utility.set_location(' Leaving:'||l_proc, 70);
878: exception
879: when hr_api.validate_enabled then
880: --
881: -- As the Validate_Enabled exception has been raised
882: -- we must rollback to the savepoint
883: --
932: P_POSTING_CONTENT_ID => P_POSTING_CONTENT_ID
933: ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
934: );
935: exception
936: when hr_api.cannot_find_prog_unit then
937: hr_api.cannot_find_prog_unit_error
938: (p_module_name => 'delete_posting_content'
939: ,p_hook_type => 'BP'
940: );
933: ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
934: );
935: exception
936: when hr_api.cannot_find_prog_unit then
937: hr_api.cannot_find_prog_unit_error
938: (p_module_name => 'delete_posting_content'
939: ,p_hook_type => 'BP'
940: );
941: end;
964: P_POSTING_CONTENT_ID => P_POSTING_CONTENT_ID
965: ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
966: );
967: exception
968: when hr_api.cannot_find_prog_unit then
969: hr_api.cannot_find_prog_unit_error
970: (p_module_name => 'delete_posting_content'
971: ,p_hook_type => 'AP'
972: );
965: ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
966: );
967: exception
968: when hr_api.cannot_find_prog_unit then
969: hr_api.cannot_find_prog_unit_error
970: (p_module_name => 'delete_posting_content'
971: ,p_hook_type => 'AP'
972: );
973: end;
974: --
975: -- When in validation only mode raise the Validate_Enabled exception
976: --
977: if p_validate then
978: raise hr_api.validate_enabled;
979: end if;
980: --
981: -- Set all output arguments
982: --
982: --
983: --
984: hr_utility.set_location(' Leaving:'||l_proc, 70);
985: exception
986: when hr_api.validate_enabled then
987: --
988: -- As the Validate_Enabled exception has been raised
989: -- we must rollback to the savepoint
990: --