424: ,p_effective_date IN DATE
425: ,p_datetrack_update_mode IN VARCHAR2
426: ,p_assignment_id IN NUMBER
427: ,p_object_version_number IN OUT NOCOPY NUMBER
428: ,p_supervisor_id IN NUMBER DEFAULT hr_api.g_number
429: ,p_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
430: ,p_change_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
431: ,p_assignment_status_type_id IN NUMBER DEFAULT hr_api.g_number
432: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
425: ,p_datetrack_update_mode IN VARCHAR2
426: ,p_assignment_id IN NUMBER
427: ,p_object_version_number IN OUT NOCOPY NUMBER
428: ,p_supervisor_id IN NUMBER DEFAULT hr_api.g_number
429: ,p_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
430: ,p_change_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
431: ,p_assignment_status_type_id IN NUMBER DEFAULT hr_api.g_number
432: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
433: ,p_date_probation_end IN DATE DEFAULT hr_api.g_date
426: ,p_assignment_id IN NUMBER
427: ,p_object_version_number IN OUT NOCOPY NUMBER
428: ,p_supervisor_id IN NUMBER DEFAULT hr_api.g_number
429: ,p_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
430: ,p_change_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
431: ,p_assignment_status_type_id IN NUMBER DEFAULT hr_api.g_number
432: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
433: ,p_date_probation_end IN DATE DEFAULT hr_api.g_date
434: ,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
427: ,p_object_version_number IN OUT NOCOPY NUMBER
428: ,p_supervisor_id IN NUMBER DEFAULT hr_api.g_number
429: ,p_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
430: ,p_change_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
431: ,p_assignment_status_type_id IN NUMBER DEFAULT hr_api.g_number
432: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
433: ,p_date_probation_end IN DATE DEFAULT hr_api.g_date
434: ,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
435: ,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
428: ,p_supervisor_id IN NUMBER DEFAULT hr_api.g_number
429: ,p_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
430: ,p_change_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
431: ,p_assignment_status_type_id IN NUMBER DEFAULT hr_api.g_number
432: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
433: ,p_date_probation_end IN DATE DEFAULT hr_api.g_date
434: ,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
435: ,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
436: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
429: ,p_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
430: ,p_change_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
431: ,p_assignment_status_type_id IN NUMBER DEFAULT hr_api.g_number
432: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
433: ,p_date_probation_end IN DATE DEFAULT hr_api.g_date
434: ,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
435: ,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
436: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
437: ,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
430: ,p_change_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
431: ,p_assignment_status_type_id IN NUMBER DEFAULT hr_api.g_number
432: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
433: ,p_date_probation_end IN DATE DEFAULT hr_api.g_date
434: ,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
435: ,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
436: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
437: ,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
438: ,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
431: ,p_assignment_status_type_id IN NUMBER DEFAULT hr_api.g_number
432: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
433: ,p_date_probation_end IN DATE DEFAULT hr_api.g_date
434: ,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
435: ,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
436: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
437: ,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
438: ,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
439: ,p_perf_review_period IN NUMBER DEFAULT hr_api.g_number
432: ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
433: ,p_date_probation_end IN DATE DEFAULT hr_api.g_date
434: ,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
435: ,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
436: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
437: ,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
438: ,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
439: ,p_perf_review_period IN NUMBER DEFAULT hr_api.g_number
440: ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
433: ,p_date_probation_end IN DATE DEFAULT hr_api.g_date
434: ,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
435: ,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
436: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
437: ,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
438: ,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
439: ,p_perf_review_period IN NUMBER DEFAULT hr_api.g_number
440: ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
441: ,p_probation_period IN NUMBER DEFAULT hr_api.g_number
434: ,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
435: ,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
436: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
437: ,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
438: ,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
439: ,p_perf_review_period IN NUMBER DEFAULT hr_api.g_number
440: ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
441: ,p_probation_period IN NUMBER DEFAULT hr_api.g_number
442: ,p_probation_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
435: ,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
436: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
437: ,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
438: ,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
439: ,p_perf_review_period IN NUMBER DEFAULT hr_api.g_number
440: ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
441: ,p_probation_period IN NUMBER DEFAULT hr_api.g_number
442: ,p_probation_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
443: ,p_sal_review_period IN NUMBER DEFAULT hr_api.g_number
436: ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
437: ,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
438: ,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
439: ,p_perf_review_period IN NUMBER DEFAULT hr_api.g_number
440: ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
441: ,p_probation_period IN NUMBER DEFAULT hr_api.g_number
442: ,p_probation_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
443: ,p_sal_review_period IN NUMBER DEFAULT hr_api.g_number
444: ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
437: ,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
438: ,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
439: ,p_perf_review_period IN NUMBER DEFAULT hr_api.g_number
440: ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
441: ,p_probation_period IN NUMBER DEFAULT hr_api.g_number
442: ,p_probation_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
443: ,p_sal_review_period IN NUMBER DEFAULT hr_api.g_number
444: ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
445: ,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
438: ,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
439: ,p_perf_review_period IN NUMBER DEFAULT hr_api.g_number
440: ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
441: ,p_probation_period IN NUMBER DEFAULT hr_api.g_number
442: ,p_probation_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
443: ,p_sal_review_period IN NUMBER DEFAULT hr_api.g_number
444: ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
445: ,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
446: ,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
439: ,p_perf_review_period IN NUMBER DEFAULT hr_api.g_number
440: ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
441: ,p_probation_period IN NUMBER DEFAULT hr_api.g_number
442: ,p_probation_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
443: ,p_sal_review_period IN NUMBER DEFAULT hr_api.g_number
444: ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
445: ,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
446: ,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
447: ,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
440: ,p_perf_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
441: ,p_probation_period IN NUMBER DEFAULT hr_api.g_number
442: ,p_probation_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
443: ,p_sal_review_period IN NUMBER DEFAULT hr_api.g_number
444: ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
445: ,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
446: ,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
447: ,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
448: ,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
441: ,p_probation_period IN NUMBER DEFAULT hr_api.g_number
442: ,p_probation_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
443: ,p_sal_review_period IN NUMBER DEFAULT hr_api.g_number
444: ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
445: ,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
446: ,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
447: ,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
448: ,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
449: ,p_bargaining_unit_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
442: ,p_probation_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
443: ,p_sal_review_period IN NUMBER DEFAULT hr_api.g_number
444: ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
445: ,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
446: ,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
447: ,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
448: ,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
449: ,p_bargaining_unit_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
450: ,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
443: ,p_sal_review_period IN NUMBER DEFAULT hr_api.g_number
444: ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
445: ,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
446: ,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
447: ,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
448: ,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
449: ,p_bargaining_unit_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
450: ,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
451: ,p_hourly_salaried_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
444: ,p_sal_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
445: ,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
446: ,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
447: ,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
448: ,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
449: ,p_bargaining_unit_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
450: ,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
451: ,p_hourly_salaried_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
452: ,p_ass_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
445: ,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
446: ,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
447: ,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
448: ,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
449: ,p_bargaining_unit_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
450: ,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
451: ,p_hourly_salaried_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
452: ,p_ass_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
453: ,p_ass_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
446: ,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
447: ,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
448: ,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
449: ,p_bargaining_unit_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
450: ,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
451: ,p_hourly_salaried_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
452: ,p_ass_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
453: ,p_ass_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
454: ,p_ass_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
447: ,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
448: ,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
449: ,p_bargaining_unit_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
450: ,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
451: ,p_hourly_salaried_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
452: ,p_ass_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
453: ,p_ass_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
454: ,p_ass_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
455: ,p_ass_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
448: ,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
449: ,p_bargaining_unit_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
450: ,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
451: ,p_hourly_salaried_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
452: ,p_ass_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
453: ,p_ass_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
454: ,p_ass_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
455: ,p_ass_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
456: ,p_ass_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
449: ,p_bargaining_unit_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
450: ,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
451: ,p_hourly_salaried_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
452: ,p_ass_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
453: ,p_ass_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
454: ,p_ass_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
455: ,p_ass_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
456: ,p_ass_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_ass_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
450: ,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
451: ,p_hourly_salaried_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
452: ,p_ass_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
453: ,p_ass_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
454: ,p_ass_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
455: ,p_ass_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
456: ,p_ass_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_ass_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_ass_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
451: ,p_hourly_salaried_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
452: ,p_ass_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
453: ,p_ass_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
454: ,p_ass_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
455: ,p_ass_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
456: ,p_ass_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_ass_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_ass_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_ass_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
452: ,p_ass_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
453: ,p_ass_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
454: ,p_ass_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
455: ,p_ass_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
456: ,p_ass_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_ass_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_ass_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_ass_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
460: ,p_ass_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
453: ,p_ass_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
454: ,p_ass_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
455: ,p_ass_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
456: ,p_ass_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_ass_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_ass_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_ass_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
460: ,p_ass_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_ass_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
454: ,p_ass_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
455: ,p_ass_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
456: ,p_ass_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_ass_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_ass_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_ass_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
460: ,p_ass_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_ass_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_ass_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
455: ,p_ass_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
456: ,p_ass_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_ass_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_ass_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_ass_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
460: ,p_ass_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_ass_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_ass_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_ass_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
456: ,p_ass_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_ass_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_ass_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_ass_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
460: ,p_ass_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_ass_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_ass_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_ass_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_ass_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_ass_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_ass_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_ass_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
460: ,p_ass_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_ass_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_ass_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_ass_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_ass_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_ass_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_ass_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_ass_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
460: ,p_ass_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_ass_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_ass_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_ass_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_ass_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_ass_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_ass_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_ass_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
460: ,p_ass_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_ass_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_ass_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_ass_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_ass_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_ass_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_ass_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
467: ,p_ass_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
460: ,p_ass_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_ass_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_ass_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_ass_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_ass_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_ass_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_ass_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
467: ,p_ass_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_ass_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_ass_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_ass_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_ass_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_ass_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_ass_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_ass_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
467: ,p_ass_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_ass_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
469: ,p_ass_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_ass_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_ass_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_ass_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_ass_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_ass_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
467: ,p_ass_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_ass_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
469: ,p_ass_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
470: ,p_ass_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_ass_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_ass_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_ass_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_ass_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
467: ,p_ass_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_ass_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
469: ,p_ass_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
470: ,p_ass_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
471: ,p_ass_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_ass_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_ass_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_ass_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
467: ,p_ass_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_ass_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
469: ,p_ass_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
470: ,p_ass_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
471: ,p_ass_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_ass_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_ass_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_ass_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
467: ,p_ass_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_ass_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
469: ,p_ass_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
470: ,p_ass_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
471: ,p_ass_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_ass_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_ass_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_ass_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
467: ,p_ass_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_ass_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
469: ,p_ass_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
470: ,p_ass_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
471: ,p_ass_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_ass_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_ass_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_ass_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
467: ,p_ass_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_ass_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
469: ,p_ass_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
470: ,p_ass_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
471: ,p_ass_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_ass_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_ass_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_ass_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_ass_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_ass_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
469: ,p_ass_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
470: ,p_ass_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
471: ,p_ass_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_ass_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_ass_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_ass_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_ass_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_ass_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
469: ,p_ass_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
470: ,p_ass_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
471: ,p_ass_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_ass_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_ass_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_ass_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_ass_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_ass_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ass_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
470: ,p_ass_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
471: ,p_ass_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_ass_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_ass_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_ass_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_ass_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_ass_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ass_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
478: ,p_ass_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
471: ,p_ass_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_ass_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_ass_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_ass_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_ass_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_ass_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ass_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
478: ,p_ass_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_ass_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_ass_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_ass_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_ass_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_ass_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_ass_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ass_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
478: ,p_ass_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_ass_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_ass_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_ass_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_ass_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_ass_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_ass_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ass_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
478: ,p_ass_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_ass_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_ass_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_ass_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_ass_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_ass_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_ass_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ass_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
478: ,p_ass_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_ass_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_ass_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_ass_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_ass_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_ass_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_ass_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ass_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
478: ,p_ass_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_ass_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_ass_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_ass_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_ass_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_ass_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ass_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
478: ,p_ass_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_ass_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_ass_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_ass_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_ass_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_employer IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ass_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
478: ,p_ass_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_ass_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_ass_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_ass_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_ass_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_employer IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_sec_emp IN VARCHAR2 DEFAULT hr_api.g_varchar2
478: ,p_ass_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_ass_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_ass_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_ass_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_ass_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_employer IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_sec_emp IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_contract_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_ass_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_ass_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_ass_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_ass_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_employer IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_sec_emp IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_contract_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_issue_date IN DATE DEFAULT hr_api.g_date
480: ,p_ass_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_ass_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_ass_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_employer IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_sec_emp IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_contract_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_issue_date IN DATE DEFAULT hr_api.g_date
488: ,p_cont_end_date IN DATE DEFAULT hr_api.g_date
481: ,p_ass_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_ass_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_employer IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_sec_emp IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_contract_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_issue_date IN DATE DEFAULT hr_api.g_date
488: ,p_cont_end_date IN DATE DEFAULT hr_api.g_date
489: ,p_limit_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_ass_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_employer IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_sec_emp IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_contract_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_issue_date IN DATE DEFAULT hr_api.g_date
488: ,p_cont_end_date IN DATE DEFAULT hr_api.g_date
489: ,p_limit_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_end_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_employer IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_sec_emp IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_contract_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_issue_date IN DATE DEFAULT hr_api.g_date
488: ,p_cont_end_date IN DATE DEFAULT hr_api.g_date
489: ,p_limit_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_end_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_territory_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_employer IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_sec_emp IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_contract_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_issue_date IN DATE DEFAULT hr_api.g_date
488: ,p_cont_end_date IN DATE DEFAULT hr_api.g_date
489: ,p_limit_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_end_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_territory_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_spl_work_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_sec_emp IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_contract_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_issue_date IN DATE DEFAULT hr_api.g_date
488: ,p_cont_end_date IN DATE DEFAULT hr_api.g_date
489: ,p_limit_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_end_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_territory_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_spl_work_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_csr IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_contract_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_issue_date IN DATE DEFAULT hr_api.g_date
488: ,p_cont_end_date IN DATE DEFAULT hr_api.g_date
489: ,p_limit_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_end_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_territory_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_spl_work_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_csr IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_csr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_issue_date IN DATE DEFAULT hr_api.g_date
488: ,p_cont_end_date IN DATE DEFAULT hr_api.g_date
489: ,p_limit_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_end_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_territory_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_spl_work_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_csr IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_csr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_lsr IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_cont_end_date IN DATE DEFAULT hr_api.g_date
489: ,p_limit_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_end_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_territory_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_spl_work_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_csr IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_csr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_lsr IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_lsr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_limit_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_end_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_territory_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_spl_work_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_csr IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_csr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_lsr IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_lsr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_unint_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_end_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_territory_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_spl_work_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_csr IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_csr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_lsr IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_lsr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_unint_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_total_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_territory_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_spl_work_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_csr IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_csr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_lsr IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_lsr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_unint_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_total_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_pension_years IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_spl_work_cond IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_csr IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_csr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_lsr IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_lsr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_unint_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_total_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_pension_years IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_pension_months IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_csr IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_csr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_lsr IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_lsr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_unint_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_total_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_pension_years IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_pension_months IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_pension_days IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_csr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_lsr IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_lsr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_unint_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_total_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_pension_years IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_pension_months IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_pension_days IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_lsr IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_lsr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_unint_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_total_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_pension_years IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_pension_months IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_pension_days IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_contract_id IN NUMBER DEFAULT hr_api.g_number
496: ,p_lsr_add_info IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_unint_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_total_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_pension_years IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_pension_months IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_pension_days IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_contract_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_establishment_id IN NUMBER DEFAULT hr_api.g_number
497: ,p_unint_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_total_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_pension_years IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_pension_months IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_pension_days IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_contract_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_establishment_id IN NUMBER DEFAULT hr_api.g_number
505: ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
498: ,p_total_service_rec IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_pension_years IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_pension_months IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_pension_days IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_contract_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_establishment_id IN NUMBER DEFAULT hr_api.g_number
505: ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
506: ,p_cagr_id_flex_num IN NUMBER DEFAULT hr_api.g_number
499: ,p_pension_years IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_pension_months IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_pension_days IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_contract_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_establishment_id IN NUMBER DEFAULT hr_api.g_number
505: ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
506: ,p_cagr_id_flex_num IN NUMBER DEFAULT hr_api.g_number
507: ,p_cag_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_pension_months IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_pension_days IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_contract_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_establishment_id IN NUMBER DEFAULT hr_api.g_number
505: ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
506: ,p_cagr_id_flex_num IN NUMBER DEFAULT hr_api.g_number
507: ,p_cag_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_cag_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_pension_days IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_contract_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_establishment_id IN NUMBER DEFAULT hr_api.g_number
505: ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
506: ,p_cagr_id_flex_num IN NUMBER DEFAULT hr_api.g_number
507: ,p_cag_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_cag_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_cag_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_contract_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_establishment_id IN NUMBER DEFAULT hr_api.g_number
505: ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
506: ,p_cagr_id_flex_num IN NUMBER DEFAULT hr_api.g_number
507: ,p_cag_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_cag_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_cag_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_cag_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_contract_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_establishment_id IN NUMBER DEFAULT hr_api.g_number
505: ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
506: ,p_cagr_id_flex_num IN NUMBER DEFAULT hr_api.g_number
507: ,p_cag_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_cag_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_cag_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_cag_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_cag_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_establishment_id IN NUMBER DEFAULT hr_api.g_number
505: ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
506: ,p_cagr_id_flex_num IN NUMBER DEFAULT hr_api.g_number
507: ,p_cag_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_cag_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_cag_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_cag_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_cag_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_cag_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
506: ,p_cagr_id_flex_num IN NUMBER DEFAULT hr_api.g_number
507: ,p_cag_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_cag_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_cag_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_cag_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_cag_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_cag_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_cag_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_cagr_id_flex_num IN NUMBER DEFAULT hr_api.g_number
507: ,p_cag_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_cag_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_cag_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_cag_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_cag_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_cag_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_cag_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_cag_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_cag_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_cag_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_cag_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_cag_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_cag_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_cag_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_cag_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_cag_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_cag_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_cag_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_cag_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_cag_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_cag_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_cag_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_cag_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_cag_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_cag_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_cag_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_cag_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_cag_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_cag_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_cag_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_cag_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_cag_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_cag_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_cag_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_cag_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_cag_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_cag_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_cag_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_cag_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_cag_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_cag_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_cag_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_cag_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_cag_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_cag_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_cag_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_cag_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_cag_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_cag_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_cag_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_cag_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_cag_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_cag_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_cag_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_cag_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_cag_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_cag_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_cag_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_cag_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_cag_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_cag_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_cag_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_cag_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_cag_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_cag_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_cag_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_cag_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_cag_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_cag_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_cag_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_cag_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_cag_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_cag_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_cag_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_cag_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_cag_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_cag_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_cag_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_cag_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_cag_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_cag_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_cag_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_cag_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_cag_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_cag_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_cag_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_cag_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_cag_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_cag_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_cag_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_cag_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_cag_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_cag_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_cag_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_cag_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_cag_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_cag_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_cag_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_cag_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_cag_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_cag_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_cag_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_cag_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_cag_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_cag_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_cag_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_cag_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_cag_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_cag_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_cag_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_cag_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_cag_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_cag_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_cag_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_cag_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_cag_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_cag_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_cag_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_cag_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_cag_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_cag_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_cag_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_cag_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_cag_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_notice_period IN NUMBER DEFAULT hr_api.g_varchar2
520: ,p_cag_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_cag_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_cag_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_cag_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_cag_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_cag_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_cag_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_notice_period IN NUMBER DEFAULT hr_api.g_varchar2
528: ,p_notice_period_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_cag_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_cag_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_cag_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_cag_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_cag_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_cag_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_notice_period IN NUMBER DEFAULT hr_api.g_varchar2
528: ,p_notice_period_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_employee_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_cag_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_cag_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_cag_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_cag_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_cag_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_notice_period IN NUMBER DEFAULT hr_api.g_varchar2
528: ,p_notice_period_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_employee_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_work_at_home IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_cag_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_cag_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_cag_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_cag_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_notice_period IN NUMBER DEFAULT hr_api.g_varchar2
528: ,p_notice_period_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_employee_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_work_at_home IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_job_post_source_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_cag_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_cag_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_cag_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_notice_period IN NUMBER DEFAULT hr_api.g_varchar2
528: ,p_notice_period_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_employee_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_work_at_home IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_job_post_source_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_supervisor_assignment_id IN NUMBER DEFAULT hr_api.g_number
525: ,p_cag_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_cag_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_notice_period IN NUMBER DEFAULT hr_api.g_varchar2
528: ,p_notice_period_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_employee_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_work_at_home IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_job_post_source_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_supervisor_assignment_id IN NUMBER DEFAULT hr_api.g_number
533: ,p_cagr_grade_def_id IN OUT NOCOPY NUMBER
526: ,p_cag_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_notice_period IN NUMBER DEFAULT hr_api.g_varchar2
528: ,p_notice_period_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_employee_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_work_at_home IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_job_post_source_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_supervisor_assignment_id IN NUMBER DEFAULT hr_api.g_number
533: ,p_cagr_grade_def_id IN OUT NOCOPY NUMBER
534: ,p_cagr_concatenated_segments OUT NOCOPY VARCHAR2
527: ,p_notice_period IN NUMBER DEFAULT hr_api.g_varchar2
528: ,p_notice_period_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_employee_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_work_at_home IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_job_post_source_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_supervisor_assignment_id IN NUMBER DEFAULT hr_api.g_number
533: ,p_cagr_grade_def_id IN OUT NOCOPY NUMBER
534: ,p_cagr_concatenated_segments OUT NOCOPY VARCHAR2
535: ,p_soft_coding_keyflex_id IN OUT NOCOPY NUMBER
528: ,p_notice_period_uom IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_employee_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_work_at_home IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_job_post_source_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_supervisor_assignment_id IN NUMBER DEFAULT hr_api.g_number
533: ,p_cagr_grade_def_id IN OUT NOCOPY NUMBER
534: ,p_cagr_concatenated_segments OUT NOCOPY VARCHAR2
535: ,p_soft_coding_keyflex_id IN OUT NOCOPY NUMBER
536: ,p_effective_start_date OUT NOCOPY DATE
601: --
602: --
603: -- Call update_emp_asg business process
604: --
605: if p_issue_date = hr_api.g_date THEN
606: l_issue_date := hr_api.g_varchar2;
607: else
608: l_issue_date := fnd_date.date_to_canonical(p_issue_date);
609: end if;
602: --
603: -- Call update_emp_asg business process
604: --
605: if p_issue_date = hr_api.g_date THEN
606: l_issue_date := hr_api.g_varchar2;
607: else
608: l_issue_date := fnd_date.date_to_canonical(p_issue_date);
609: end if;
610:
607: else
608: l_issue_date := fnd_date.date_to_canonical(p_issue_date);
609: end if;
610:
611: if p_cont_end_date = hr_api.g_date THEN
612: l_cont_end_date := hr_api.g_varchar2;
613: else
614: l_cont_end_date := fnd_date.date_to_canonical(p_cont_end_date);
615: end if;
608: l_issue_date := fnd_date.date_to_canonical(p_issue_date);
609: end if;
610:
611: if p_cont_end_date = hr_api.g_date THEN
612: l_cont_end_date := hr_api.g_varchar2;
613: else
614: l_cont_end_date := fnd_date.date_to_canonical(p_cont_end_date);
615: end if;
616: