eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ASSIGNMENT_API dependencies on HR_API

Line 277: when hr_api.cannot_find_prog_unit then

273: --
274: begin
275: null;
276: exception
277: when hr_api.cannot_find_prog_unit then
278: hr_api.cannot_find_prog_unit_error
279: (p_module_name => 'CREATE_SECONDARY_EMP_ASG'
280: ,p_hook_type => 'BP'
281: );

Line 278: hr_api.cannot_find_prog_unit_error

274: begin
275: null;
276: exception
277: when hr_api.cannot_find_prog_unit then
278: hr_api.cannot_find_prog_unit_error
279: (p_module_name => 'CREATE_SECONDARY_EMP_ASG'
280: ,p_hook_type => 'BP'
281: );
282: --

Line 293: hr_api.mandatory_arg_error

289: -- Validation in addition to Table Handlers
290: --
291: -- Get person details.
292: --
293: hr_api.mandatory_arg_error
294: (p_api_name => l_proc
295: ,p_argument => 'person_id'
296: ,p_argument_value => p_person_id
297: );

Line 299: hr_api.mandatory_arg_error

295: ,p_argument => 'person_id'
296: ,p_argument_value => p_person_id
297: );
298: --
299: hr_api.mandatory_arg_error
300: (p_api_name => l_proc
301: ,p_argument => 'effective_date'
302: ,p_argument_value => l_effective_date
303: );

Line 372: if hr_api.return_legislation_code(l_business_group_id) in ('US','CA') and

368: (c_bgp_id => l_business_group_id
369: );
370: --
371: fetch c_getdefmthpaydets into l_mthpayroll_id;
372: if hr_api.return_legislation_code(l_business_group_id) in ('US','CA') and
373: (c_getdefmthpaydets%notfound or l_mthpayroll_id is null) then --Bug 1539414
374: close c_getdefmthpaydets;
375: --
376: hr_utility.set_message(805,'BEN_92109_NODEFPAYEXISTS');

Line 491: -- to create benefits assignment with HR api validations.

487: hr_utility.set_location(l_proc, 40);
488:
489: --
490: -- Call per_asg_ins.ins when p_called_from = 'FORM', (called from BENEBNAS.pld)
491: -- to create benefits assignment with HR api validations.
492: --
493: -- Call ben_asg_ins.ins when p_called_from is NULL, to create benefits assignment
494: -- without HR api validations
495: --

Line 494: -- without HR api validations

490: -- Call per_asg_ins.ins when p_called_from = 'FORM', (called from BENEBNAS.pld)
491: -- to create benefits assignment with HR api validations.
492: --
493: -- Call ben_asg_ins.ins when p_called_from is NULL, to create benefits assignment
494: -- without HR api validations
495: --
496:
497: if p_called_from = 'FORM' then
498: per_asg_ins.ins

Line 744: when hr_api.cannot_find_prog_unit then

740: hr_utility.set_location(l_proc, 60);
741: begin
742: null;
743: exception
744: when hr_api.cannot_find_prog_unit then
745: hr_api.cannot_find_prog_unit_error
746: (p_module_name => 'CREATE_SECONDARY_EMP_ASG'
747: ,p_hook_type => 'AP'
748: );

Line 745: hr_api.cannot_find_prog_unit_error

741: begin
742: null;
743: exception
744: when hr_api.cannot_find_prog_unit then
745: hr_api.cannot_find_prog_unit_error
746: (p_module_name => 'CREATE_SECONDARY_EMP_ASG'
747: ,p_hook_type => 'AP'
748: );
749: --

Line 757: raise hr_api.validate_enabled;

753: --
754: -- When in validation only mode raise the Validate_Enabled exception
755: --
756: if p_validate then
757: raise hr_api.validate_enabled;
758: end if;
759: --
760: -- Set remaining output arguments
761: --

Line 771: when hr_api.validate_enabled then

767: p_aei_object_version_number := l_aei_ovn;
768: --
769: hr_utility.set_location(' Leaving:'||l_proc, 50);
770: exception
771: when hr_api.validate_enabled then
772: --
773: -- As the Validate_Enabled exception has been raised
774: -- we must rollback to the savepoint
775: --

Line 811: ,p_grade_id in number default hr_api.g_number

807: ,p_datetrack_update_mode in varchar2
808: ,p_assignment_id in number
809: ,p_object_version_number in out nocopy number
810: --
811: ,p_grade_id in number default hr_api.g_number
812: ,p_position_id in number default hr_api.g_number
813: ,p_job_id in number default hr_api.g_number
814: ,p_payroll_id in number default hr_api.g_number
815: ,p_location_id in number default hr_api.g_number

Line 812: ,p_position_id in number default hr_api.g_number

808: ,p_assignment_id in number
809: ,p_object_version_number in out nocopy number
810: --
811: ,p_grade_id in number default hr_api.g_number
812: ,p_position_id in number default hr_api.g_number
813: ,p_job_id in number default hr_api.g_number
814: ,p_payroll_id in number default hr_api.g_number
815: ,p_location_id in number default hr_api.g_number
816: ,p_special_ceiling_step_id in out nocopy number

Line 813: ,p_job_id in number default hr_api.g_number

809: ,p_object_version_number in out nocopy number
810: --
811: ,p_grade_id in number default hr_api.g_number
812: ,p_position_id in number default hr_api.g_number
813: ,p_job_id in number default hr_api.g_number
814: ,p_payroll_id in number default hr_api.g_number
815: ,p_location_id in number default hr_api.g_number
816: ,p_special_ceiling_step_id in out nocopy number
817: ,p_organization_id in number default hr_api.g_number

Line 814: ,p_payroll_id in number default hr_api.g_number

810: --
811: ,p_grade_id in number default hr_api.g_number
812: ,p_position_id in number default hr_api.g_number
813: ,p_job_id in number default hr_api.g_number
814: ,p_payroll_id in number default hr_api.g_number
815: ,p_location_id in number default hr_api.g_number
816: ,p_special_ceiling_step_id in out nocopy number
817: ,p_organization_id in number default hr_api.g_number
818: ,p_people_group_id in number default hr_api.g_number

Line 815: ,p_location_id in number default hr_api.g_number

811: ,p_grade_id in number default hr_api.g_number
812: ,p_position_id in number default hr_api.g_number
813: ,p_job_id in number default hr_api.g_number
814: ,p_payroll_id in number default hr_api.g_number
815: ,p_location_id in number default hr_api.g_number
816: ,p_special_ceiling_step_id in out nocopy number
817: ,p_organization_id in number default hr_api.g_number
818: ,p_people_group_id in number default hr_api.g_number
819: ,p_pay_basis_id in number default hr_api.g_number

Line 817: ,p_organization_id in number default hr_api.g_number

813: ,p_job_id in number default hr_api.g_number
814: ,p_payroll_id in number default hr_api.g_number
815: ,p_location_id in number default hr_api.g_number
816: ,p_special_ceiling_step_id in out nocopy number
817: ,p_organization_id in number default hr_api.g_number
818: ,p_people_group_id in number default hr_api.g_number
819: ,p_pay_basis_id in number default hr_api.g_number
820: ,p_employment_category in varchar2 default hr_api.g_varchar2
821: --

Line 818: ,p_people_group_id in number default hr_api.g_number

814: ,p_payroll_id in number default hr_api.g_number
815: ,p_location_id in number default hr_api.g_number
816: ,p_special_ceiling_step_id in out nocopy number
817: ,p_organization_id in number default hr_api.g_number
818: ,p_people_group_id in number default hr_api.g_number
819: ,p_pay_basis_id in number default hr_api.g_number
820: ,p_employment_category in varchar2 default hr_api.g_varchar2
821: --
822: ,p_supervisor_id in number default hr_api.g_number

Line 819: ,p_pay_basis_id in number default hr_api.g_number

815: ,p_location_id in number default hr_api.g_number
816: ,p_special_ceiling_step_id in out nocopy number
817: ,p_organization_id in number default hr_api.g_number
818: ,p_people_group_id in number default hr_api.g_number
819: ,p_pay_basis_id in number default hr_api.g_number
820: ,p_employment_category in varchar2 default hr_api.g_varchar2
821: --
822: ,p_supervisor_id in number default hr_api.g_number
823: ,p_change_reason in varchar2 default hr_api.g_varchar2

Line 820: ,p_employment_category in varchar2 default hr_api.g_varchar2

816: ,p_special_ceiling_step_id in out nocopy number
817: ,p_organization_id in number default hr_api.g_number
818: ,p_people_group_id in number default hr_api.g_number
819: ,p_pay_basis_id in number default hr_api.g_number
820: ,p_employment_category in varchar2 default hr_api.g_varchar2
821: --
822: ,p_supervisor_id in number default hr_api.g_number
823: ,p_change_reason in varchar2 default hr_api.g_varchar2
824: ,p_comments in varchar2 default hr_api.g_varchar2

Line 822: ,p_supervisor_id in number default hr_api.g_number

818: ,p_people_group_id in number default hr_api.g_number
819: ,p_pay_basis_id in number default hr_api.g_number
820: ,p_employment_category in varchar2 default hr_api.g_varchar2
821: --
822: ,p_supervisor_id in number default hr_api.g_number
823: ,p_change_reason in varchar2 default hr_api.g_varchar2
824: ,p_comments in varchar2 default hr_api.g_varchar2
825: ,p_date_probation_end in date default hr_api.g_date
826: ,p_default_code_comb_id in number default hr_api.g_number

Line 823: ,p_change_reason in varchar2 default hr_api.g_varchar2

819: ,p_pay_basis_id in number default hr_api.g_number
820: ,p_employment_category in varchar2 default hr_api.g_varchar2
821: --
822: ,p_supervisor_id in number default hr_api.g_number
823: ,p_change_reason in varchar2 default hr_api.g_varchar2
824: ,p_comments in varchar2 default hr_api.g_varchar2
825: ,p_date_probation_end in date default hr_api.g_date
826: ,p_default_code_comb_id in number default hr_api.g_number
827: ,p_frequency in varchar2 default hr_api.g_varchar2

Line 824: ,p_comments in varchar2 default hr_api.g_varchar2

820: ,p_employment_category in varchar2 default hr_api.g_varchar2
821: --
822: ,p_supervisor_id in number default hr_api.g_number
823: ,p_change_reason in varchar2 default hr_api.g_varchar2
824: ,p_comments in varchar2 default hr_api.g_varchar2
825: ,p_date_probation_end in date default hr_api.g_date
826: ,p_default_code_comb_id in number default hr_api.g_number
827: ,p_frequency in varchar2 default hr_api.g_varchar2
828: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

Line 825: ,p_date_probation_end in date default hr_api.g_date

821: --
822: ,p_supervisor_id in number default hr_api.g_number
823: ,p_change_reason in varchar2 default hr_api.g_varchar2
824: ,p_comments in varchar2 default hr_api.g_varchar2
825: ,p_date_probation_end in date default hr_api.g_date
826: ,p_default_code_comb_id in number default hr_api.g_number
827: ,p_frequency in varchar2 default hr_api.g_varchar2
828: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
829: ,p_manager_flag in varchar2 default hr_api.g_varchar2

Line 826: ,p_default_code_comb_id in number default hr_api.g_number

822: ,p_supervisor_id in number default hr_api.g_number
823: ,p_change_reason in varchar2 default hr_api.g_varchar2
824: ,p_comments in varchar2 default hr_api.g_varchar2
825: ,p_date_probation_end in date default hr_api.g_date
826: ,p_default_code_comb_id in number default hr_api.g_number
827: ,p_frequency in varchar2 default hr_api.g_varchar2
828: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
829: ,p_manager_flag in varchar2 default hr_api.g_varchar2
830: ,p_normal_hours in number default hr_api.g_number

Line 827: ,p_frequency in varchar2 default hr_api.g_varchar2

823: ,p_change_reason in varchar2 default hr_api.g_varchar2
824: ,p_comments in varchar2 default hr_api.g_varchar2
825: ,p_date_probation_end in date default hr_api.g_date
826: ,p_default_code_comb_id in number default hr_api.g_number
827: ,p_frequency in varchar2 default hr_api.g_varchar2
828: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
829: ,p_manager_flag in varchar2 default hr_api.g_varchar2
830: ,p_normal_hours in number default hr_api.g_number
831: ,p_perf_review_period in number default hr_api.g_number

Line 828: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

824: ,p_comments in varchar2 default hr_api.g_varchar2
825: ,p_date_probation_end in date default hr_api.g_date
826: ,p_default_code_comb_id in number default hr_api.g_number
827: ,p_frequency in varchar2 default hr_api.g_varchar2
828: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
829: ,p_manager_flag in varchar2 default hr_api.g_varchar2
830: ,p_normal_hours in number default hr_api.g_number
831: ,p_perf_review_period in number default hr_api.g_number
832: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 829: ,p_manager_flag in varchar2 default hr_api.g_varchar2

825: ,p_date_probation_end in date default hr_api.g_date
826: ,p_default_code_comb_id in number default hr_api.g_number
827: ,p_frequency in varchar2 default hr_api.g_varchar2
828: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
829: ,p_manager_flag in varchar2 default hr_api.g_varchar2
830: ,p_normal_hours in number default hr_api.g_number
831: ,p_perf_review_period in number default hr_api.g_number
832: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
833: ,p_probation_period in number default hr_api.g_number

Line 830: ,p_normal_hours in number default hr_api.g_number

826: ,p_default_code_comb_id in number default hr_api.g_number
827: ,p_frequency in varchar2 default hr_api.g_varchar2
828: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
829: ,p_manager_flag in varchar2 default hr_api.g_varchar2
830: ,p_normal_hours in number default hr_api.g_number
831: ,p_perf_review_period in number default hr_api.g_number
832: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
833: ,p_probation_period in number default hr_api.g_number
834: ,p_probation_unit in varchar2 default hr_api.g_varchar2

Line 831: ,p_perf_review_period in number default hr_api.g_number

827: ,p_frequency in varchar2 default hr_api.g_varchar2
828: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
829: ,p_manager_flag in varchar2 default hr_api.g_varchar2
830: ,p_normal_hours in number default hr_api.g_number
831: ,p_perf_review_period in number default hr_api.g_number
832: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
833: ,p_probation_period in number default hr_api.g_number
834: ,p_probation_unit in varchar2 default hr_api.g_varchar2
835: ,p_sal_review_period in number default hr_api.g_number

Line 832: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

828: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
829: ,p_manager_flag in varchar2 default hr_api.g_varchar2
830: ,p_normal_hours in number default hr_api.g_number
831: ,p_perf_review_period in number default hr_api.g_number
832: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
833: ,p_probation_period in number default hr_api.g_number
834: ,p_probation_unit in varchar2 default hr_api.g_varchar2
835: ,p_sal_review_period in number default hr_api.g_number
836: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 833: ,p_probation_period in number default hr_api.g_number

829: ,p_manager_flag in varchar2 default hr_api.g_varchar2
830: ,p_normal_hours in number default hr_api.g_number
831: ,p_perf_review_period in number default hr_api.g_number
832: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
833: ,p_probation_period in number default hr_api.g_number
834: ,p_probation_unit in varchar2 default hr_api.g_varchar2
835: ,p_sal_review_period in number default hr_api.g_number
836: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
837: ,p_set_of_books_id in number default hr_api.g_number

Line 834: ,p_probation_unit in varchar2 default hr_api.g_varchar2

830: ,p_normal_hours in number default hr_api.g_number
831: ,p_perf_review_period in number default hr_api.g_number
832: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
833: ,p_probation_period in number default hr_api.g_number
834: ,p_probation_unit in varchar2 default hr_api.g_varchar2
835: ,p_sal_review_period in number default hr_api.g_number
836: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
837: ,p_set_of_books_id in number default hr_api.g_number
838: ,p_source_type in varchar2 default hr_api.g_varchar2

Line 835: ,p_sal_review_period in number default hr_api.g_number

831: ,p_perf_review_period in number default hr_api.g_number
832: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
833: ,p_probation_period in number default hr_api.g_number
834: ,p_probation_unit in varchar2 default hr_api.g_varchar2
835: ,p_sal_review_period in number default hr_api.g_number
836: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
837: ,p_set_of_books_id in number default hr_api.g_number
838: ,p_source_type in varchar2 default hr_api.g_varchar2
839: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

Line 836: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

832: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
833: ,p_probation_period in number default hr_api.g_number
834: ,p_probation_unit in varchar2 default hr_api.g_varchar2
835: ,p_sal_review_period in number default hr_api.g_number
836: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
837: ,p_set_of_books_id in number default hr_api.g_number
838: ,p_source_type in varchar2 default hr_api.g_varchar2
839: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
840: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

Line 837: ,p_set_of_books_id in number default hr_api.g_number

833: ,p_probation_period in number default hr_api.g_number
834: ,p_probation_unit in varchar2 default hr_api.g_varchar2
835: ,p_sal_review_period in number default hr_api.g_number
836: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
837: ,p_set_of_books_id in number default hr_api.g_number
838: ,p_source_type in varchar2 default hr_api.g_varchar2
839: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
840: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
841: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

Line 838: ,p_source_type in varchar2 default hr_api.g_varchar2

834: ,p_probation_unit in varchar2 default hr_api.g_varchar2
835: ,p_sal_review_period in number default hr_api.g_number
836: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
837: ,p_set_of_books_id in number default hr_api.g_number
838: ,p_source_type in varchar2 default hr_api.g_varchar2
839: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
840: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
841: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
842: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2

Line 839: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

835: ,p_sal_review_period in number default hr_api.g_number
836: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
837: ,p_set_of_books_id in number default hr_api.g_number
838: ,p_source_type in varchar2 default hr_api.g_varchar2
839: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
840: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
841: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
842: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
843: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2

Line 840: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

836: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
837: ,p_set_of_books_id in number default hr_api.g_number
838: ,p_source_type in varchar2 default hr_api.g_varchar2
839: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
840: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
841: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
842: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
843: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
844: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

Line 841: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

837: ,p_set_of_books_id in number default hr_api.g_number
838: ,p_source_type in varchar2 default hr_api.g_varchar2
839: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
840: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
841: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
842: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
843: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
844: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
845: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

Line 842: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2

838: ,p_source_type in varchar2 default hr_api.g_varchar2
839: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
840: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
841: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
842: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
843: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
844: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
845: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
846: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

Line 843: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2

839: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
840: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
841: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
842: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
843: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
844: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
845: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
846: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
847: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

Line 844: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

840: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
841: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
842: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
843: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
844: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
845: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
846: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
847: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
848: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

Line 845: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

841: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
842: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
843: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
844: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
845: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
846: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
847: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
848: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
849: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

Line 846: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

842: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
843: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
844: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
845: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
846: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
847: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
848: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
849: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
850: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

Line 847: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

843: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
844: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
845: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
846: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
847: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
848: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
849: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
850: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
851: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

Line 848: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

844: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
845: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
846: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
847: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
848: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
849: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
850: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
851: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
852: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

Line 849: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

845: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
846: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
847: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
848: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
849: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
850: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
851: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
852: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
853: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

Line 850: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

846: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
847: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
848: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
849: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
850: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
851: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
852: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
853: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
854: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

Line 851: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

847: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
848: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
849: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
850: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
851: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
852: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
853: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
854: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
855: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

Line 852: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

848: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
849: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
850: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
851: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
852: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
853: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
854: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
855: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
856: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

Line 853: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

849: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
850: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
851: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
852: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
853: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
854: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
855: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
856: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
857: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

Line 854: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

850: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
851: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
852: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
853: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
854: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
855: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
856: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
857: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
858: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

Line 855: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

851: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
852: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
853: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
854: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
855: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
856: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
857: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
858: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
859: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

Line 856: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

852: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
853: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
854: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
855: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
856: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
857: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
858: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
859: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
860: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

Line 857: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

853: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
854: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
855: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
856: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
857: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
858: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
859: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
860: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
861: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

Line 858: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

854: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
855: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
856: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
857: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
858: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
859: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
860: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
861: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
862: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

Line 859: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

855: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
856: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
857: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
858: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
859: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
860: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
861: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
862: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
863: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

Line 860: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

856: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
857: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
858: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
859: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
860: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
861: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
862: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
863: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
864: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

Line 861: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

857: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
858: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
859: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
860: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
861: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
862: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
863: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
864: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
865: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

Line 862: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

858: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
859: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
860: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
861: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
862: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
863: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
864: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
865: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
866: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

Line 863: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

859: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
860: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
861: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
862: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
863: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
864: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
865: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
866: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
867: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

Line 864: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

860: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
861: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
862: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
863: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
864: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
865: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
866: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
867: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
868: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

Line 865: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

861: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
862: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
863: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
864: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
865: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
866: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
867: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
868: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
869: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

Line 866: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

862: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
863: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
864: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
865: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
866: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
867: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
868: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
869: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
870: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

Line 867: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

863: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
864: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
865: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
866: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
867: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
868: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
869: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
870: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
871: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

Line 868: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

864: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
865: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
866: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
867: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
868: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
869: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
870: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
871: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
872: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

Line 869: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

865: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
866: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
867: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
868: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
869: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
870: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
871: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
872: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
873: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

Line 870: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

866: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
867: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
868: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
869: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
870: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
871: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
872: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
873: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
874: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

Line 871: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

867: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
868: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
869: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
870: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
871: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
872: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
873: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
874: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
875: ,p_title in varchar2 default hr_api.g_varchar2

Line 872: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

868: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
869: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
870: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
871: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
872: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
873: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
874: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
875: ,p_title in varchar2 default hr_api.g_varchar2
876: ,p_age in number default hr_api.g_number

Line 873: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

869: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
870: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
871: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
872: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
873: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
874: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
875: ,p_title in varchar2 default hr_api.g_varchar2
876: ,p_age in number default hr_api.g_number
877: ,p_adjusted_service_date in date default hr_api.g_date

Line 874: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

870: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
871: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
872: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
873: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
874: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
875: ,p_title in varchar2 default hr_api.g_varchar2
876: ,p_age in number default hr_api.g_number
877: ,p_adjusted_service_date in date default hr_api.g_date
878: ,p_original_hire_date in date default hr_api.g_date

Line 875: ,p_title in varchar2 default hr_api.g_varchar2

871: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
872: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
873: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
874: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
875: ,p_title in varchar2 default hr_api.g_varchar2
876: ,p_age in number default hr_api.g_number
877: ,p_adjusted_service_date in date default hr_api.g_date
878: ,p_original_hire_date in date default hr_api.g_date
879: ,p_salary in varchar2 default hr_api.g_varchar2

Line 876: ,p_age in number default hr_api.g_number

872: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
873: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
874: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
875: ,p_title in varchar2 default hr_api.g_varchar2
876: ,p_age in number default hr_api.g_number
877: ,p_adjusted_service_date in date default hr_api.g_date
878: ,p_original_hire_date in date default hr_api.g_date
879: ,p_salary in varchar2 default hr_api.g_varchar2
880: ,p_original_person_type in varchar2 default hr_api.g_varchar2

Line 877: ,p_adjusted_service_date in date default hr_api.g_date

873: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
874: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
875: ,p_title in varchar2 default hr_api.g_varchar2
876: ,p_age in number default hr_api.g_number
877: ,p_adjusted_service_date in date default hr_api.g_date
878: ,p_original_hire_date in date default hr_api.g_date
879: ,p_salary in varchar2 default hr_api.g_varchar2
880: ,p_original_person_type in varchar2 default hr_api.g_varchar2
881: ,p_termination_date in date default hr_api.g_date

Line 878: ,p_original_hire_date in date default hr_api.g_date

874: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
875: ,p_title in varchar2 default hr_api.g_varchar2
876: ,p_age in number default hr_api.g_number
877: ,p_adjusted_service_date in date default hr_api.g_date
878: ,p_original_hire_date in date default hr_api.g_date
879: ,p_salary in varchar2 default hr_api.g_varchar2
880: ,p_original_person_type in varchar2 default hr_api.g_varchar2
881: ,p_termination_date in date default hr_api.g_date
882: ,p_termination_reason in varchar2 default hr_api.g_varchar2

Line 879: ,p_salary in varchar2 default hr_api.g_varchar2

875: ,p_title in varchar2 default hr_api.g_varchar2
876: ,p_age in number default hr_api.g_number
877: ,p_adjusted_service_date in date default hr_api.g_date
878: ,p_original_hire_date in date default hr_api.g_date
879: ,p_salary in varchar2 default hr_api.g_varchar2
880: ,p_original_person_type in varchar2 default hr_api.g_varchar2
881: ,p_termination_date in date default hr_api.g_date
882: ,p_termination_reason in varchar2 default hr_api.g_varchar2
883: ,p_leave_of_absence_date in date default hr_api.g_date

Line 880: ,p_original_person_type in varchar2 default hr_api.g_varchar2

876: ,p_age in number default hr_api.g_number
877: ,p_adjusted_service_date in date default hr_api.g_date
878: ,p_original_hire_date in date default hr_api.g_date
879: ,p_salary in varchar2 default hr_api.g_varchar2
880: ,p_original_person_type in varchar2 default hr_api.g_varchar2
881: ,p_termination_date in date default hr_api.g_date
882: ,p_termination_reason in varchar2 default hr_api.g_varchar2
883: ,p_leave_of_absence_date in date default hr_api.g_date
884: ,p_absence_type in varchar2 default hr_api.g_varchar2

Line 881: ,p_termination_date in date default hr_api.g_date

877: ,p_adjusted_service_date in date default hr_api.g_date
878: ,p_original_hire_date in date default hr_api.g_date
879: ,p_salary in varchar2 default hr_api.g_varchar2
880: ,p_original_person_type in varchar2 default hr_api.g_varchar2
881: ,p_termination_date in date default hr_api.g_date
882: ,p_termination_reason in varchar2 default hr_api.g_varchar2
883: ,p_leave_of_absence_date in date default hr_api.g_date
884: ,p_absence_type in varchar2 default hr_api.g_varchar2
885: ,p_absence_reason in varchar2 default hr_api.g_varchar2

Line 882: ,p_termination_reason in varchar2 default hr_api.g_varchar2

878: ,p_original_hire_date in date default hr_api.g_date
879: ,p_salary in varchar2 default hr_api.g_varchar2
880: ,p_original_person_type in varchar2 default hr_api.g_varchar2
881: ,p_termination_date in date default hr_api.g_date
882: ,p_termination_reason in varchar2 default hr_api.g_varchar2
883: ,p_leave_of_absence_date in date default hr_api.g_date
884: ,p_absence_type in varchar2 default hr_api.g_varchar2
885: ,p_absence_reason in varchar2 default hr_api.g_varchar2
886: ,p_date_of_hire in date default hr_api.g_date

Line 883: ,p_leave_of_absence_date in date default hr_api.g_date

879: ,p_salary in varchar2 default hr_api.g_varchar2
880: ,p_original_person_type in varchar2 default hr_api.g_varchar2
881: ,p_termination_date in date default hr_api.g_date
882: ,p_termination_reason in varchar2 default hr_api.g_varchar2
883: ,p_leave_of_absence_date in date default hr_api.g_date
884: ,p_absence_type in varchar2 default hr_api.g_varchar2
885: ,p_absence_reason in varchar2 default hr_api.g_varchar2
886: ,p_date_of_hire in date default hr_api.g_date
887: --

Line 884: ,p_absence_type in varchar2 default hr_api.g_varchar2

880: ,p_original_person_type in varchar2 default hr_api.g_varchar2
881: ,p_termination_date in date default hr_api.g_date
882: ,p_termination_reason in varchar2 default hr_api.g_varchar2
883: ,p_leave_of_absence_date in date default hr_api.g_date
884: ,p_absence_type in varchar2 default hr_api.g_varchar2
885: ,p_absence_reason in varchar2 default hr_api.g_varchar2
886: ,p_date_of_hire in date default hr_api.g_date
887: --
888: ,p_called_from in varchar2 default hr_api.g_varchar2

Line 885: ,p_absence_reason in varchar2 default hr_api.g_varchar2

881: ,p_termination_date in date default hr_api.g_date
882: ,p_termination_reason in varchar2 default hr_api.g_varchar2
883: ,p_leave_of_absence_date in date default hr_api.g_date
884: ,p_absence_type in varchar2 default hr_api.g_varchar2
885: ,p_absence_reason in varchar2 default hr_api.g_varchar2
886: ,p_date_of_hire in date default hr_api.g_date
887: --
888: ,p_called_from in varchar2 default hr_api.g_varchar2
889: --

Line 886: ,p_date_of_hire in date default hr_api.g_date

882: ,p_termination_reason in varchar2 default hr_api.g_varchar2
883: ,p_leave_of_absence_date in date default hr_api.g_date
884: ,p_absence_type in varchar2 default hr_api.g_varchar2
885: ,p_absence_reason in varchar2 default hr_api.g_varchar2
886: ,p_date_of_hire in date default hr_api.g_date
887: --
888: ,p_called_from in varchar2 default hr_api.g_varchar2
889: --
890: ,p_effective_start_date out nocopy date

Line 888: ,p_called_from in varchar2 default hr_api.g_varchar2

884: ,p_absence_type in varchar2 default hr_api.g_varchar2
885: ,p_absence_reason in varchar2 default hr_api.g_varchar2
886: ,p_date_of_hire in date default hr_api.g_date
887: --
888: ,p_called_from in varchar2 default hr_api.g_varchar2
889: --
890: ,p_effective_start_date out nocopy date
891: ,p_effective_end_date out nocopy date
892: )

Line 998: hr_api.mandatory_arg_error

994: -- Validation in addition to Table Handlers
995: --
996: -- Get assignment type.
997: --
998: hr_api.mandatory_arg_error
999: (p_api_name => l_proc
1000: ,p_argument => 'assignment_id'
1001: ,p_argument_value => p_assignment_id);
1002: --

Line 1003: hr_api.mandatory_arg_error

999: (p_api_name => l_proc
1000: ,p_argument => 'assignment_id'
1001: ,p_argument_value => p_assignment_id);
1002: --
1003: hr_api.mandatory_arg_error
1004: (p_api_name => l_proc
1005: ,p_argument => 'effective_date'
1006: ,p_argument_value => l_effective_date);
1007: hr_utility.set_location('ASG ID: '||p_assignment_id||' '||l_proc, 25);

Line 1075: -- to update benefits assignment with HR api validations.

1071: --
1072:
1073: --
1074: -- Call per_asg_upd.upd when p_called_from = 'FORM', (called from BENEBNAS.pld)
1075: -- to update benefits assignment with HR api validations.
1076: --
1077: -- Call ben_asg_upd.upd when p_called_from is NULL, to update benefits assignment
1078: -- without HR api validations
1079: --

Line 1078: -- without HR api validations

1074: -- Call per_asg_upd.upd when p_called_from = 'FORM', (called from BENEBNAS.pld)
1075: -- to update benefits assignment with HR api validations.
1076: --
1077: -- Call ben_asg_upd.upd when p_called_from is NULL, to update benefits assignment
1078: -- without HR api validations
1079: --
1080:
1081: if p_called_from = 'FORM' then
1082: per_asg_upd.upd

Line 1101: ,p_assignment_number => hr_api.g_varchar2

1097: ,p_employment_category => p_employment_category
1098: --
1099: ,p_supervisor_id => p_supervisor_id
1100: ,p_soft_coding_keyflex_id => l_soft_coding_keyflex_id
1101: ,p_assignment_number => hr_api.g_varchar2
1102: ,p_change_reason => p_change_reason
1103: ,p_comment_id => l_comment_id
1104: ,p_comments => p_comments
1105: ,p_date_probation_end => l_date_probation_end

Line 1171: l_orig_payroll_id := hr_api.g_varchar2;

1167: ,p_hourly_salaried_warning => l_boolean_dummy2
1168: );
1169: else
1170:
1171: l_orig_payroll_id := hr_api.g_varchar2;
1172: l_payroll_changed := hr_api.g_varchar2;
1173:
1174: --- Defaulrt Payroll id passed only for
1175: --- Backend process, if Ben_Assg form modifield

Line 1172: l_payroll_changed := hr_api.g_varchar2;

1168: );
1169: else
1170:
1171: l_orig_payroll_id := hr_api.g_varchar2;
1172: l_payroll_changed := hr_api.g_varchar2;
1173:
1174: --- Defaulrt Payroll id passed only for
1175: --- Backend process, if Ben_Assg form modifield
1176: ---- the payroll passed as it is

Line 1182: if hr_api.return_legislation_code(l_business_group_id) in ('US','CA') and

1178: (c_bgp_id => l_business_group_id
1179: );
1180: --
1181: fetch c_getdefmthpaydets into l_mthpayroll_id;
1182: if hr_api.return_legislation_code(l_business_group_id) in ('US','CA') and
1183: (c_getdefmthpaydets%notfound or l_mthpayroll_id is null) then -- Bug 1539414
1184: close c_getdefmthpaydets;
1185: --
1186: hr_utility.set_message(805,'BEN_92109_NODEFPAYEXISTS');

Line 1230: ,p_assignment_number => hr_api.g_varchar2

1226: ,p_employment_category => p_employment_category
1227: --
1228: ,p_supervisor_id => p_supervisor_id
1229: ,p_soft_coding_keyflex_id => l_soft_coding_keyflex_id
1230: ,p_assignment_number => hr_api.g_varchar2
1231: ,p_change_reason => p_change_reason
1232: ,p_comment_id => l_comment_id
1233: ,p_comments => p_comments
1234: ,p_date_probation_end => l_date_probation_end

Line 1363: l_orig_payroll_id := hr_api.g_varchar2;

1359: l_payroll_changed := 'Y';
1360: --
1361: else
1362: --
1363: l_orig_payroll_id := hr_api.g_varchar2;
1364: l_payroll_changed := hr_api.g_varchar2;
1365: --
1366: end if;
1367: --

Line 1364: l_payroll_changed := hr_api.g_varchar2;

1360: --
1361: else
1362: --
1363: l_orig_payroll_id := hr_api.g_varchar2;
1364: l_payroll_changed := hr_api.g_varchar2;
1365: --
1366: end if;
1367: --
1368: else

Line 1374: l_orig_payroll_id := hr_api.g_varchar2;

1370: hr_utility.set_location(l_proc, 60);
1371: --
1372: -- Unchanged
1373: --
1374: l_orig_payroll_id := hr_api.g_varchar2;
1375: l_payroll_changed := hr_api.g_varchar2;
1376: --
1377: end if;
1378: */

Line 1375: l_payroll_changed := hr_api.g_varchar2;

1371: --
1372: -- Unchanged
1373: --
1374: l_orig_payroll_id := hr_api.g_varchar2;
1375: l_payroll_changed := hr_api.g_varchar2;
1376: --
1377: end if;
1378: */
1379: --

Line 1387: -- they have to go as hr_api.g_varchar2.

1383: --
1384: -- Bug 1904347 : eventhough update_ben_asg defaults p_age to number and
1385: -- p_adjusted_service_date, p_original_hire_date, p_termination_date
1386: -- p_leave_of_absence_date are defaulted to dates, when they are defaulted
1387: -- they have to go as hr_api.g_varchar2.
1388: --
1389: hr_utility.set_location('ORIG PAY ID: '||l_orig_payroll_id||' '||l_proc, 50);
1390: if p_age = hr_api.g_number then
1391: --

Line 1390: if p_age = hr_api.g_number then

1386: -- p_leave_of_absence_date are defaulted to dates, when they are defaulted
1387: -- they have to go as hr_api.g_varchar2.
1388: --
1389: hr_utility.set_location('ORIG PAY ID: '||l_orig_payroll_id||' '||l_proc, 50);
1390: if p_age = hr_api.g_number then
1391: --
1392: l_char_age := hr_api.g_varchar2;
1393: --
1394: else

Line 1392: l_char_age := hr_api.g_varchar2;

1388: --
1389: hr_utility.set_location('ORIG PAY ID: '||l_orig_payroll_id||' '||l_proc, 50);
1390: if p_age = hr_api.g_number then
1391: --
1392: l_char_age := hr_api.g_varchar2;
1393: --
1394: else
1395: --
1396: l_char_age := to_char(p_age);

Line 1400: if p_adjusted_service_date = hr_api.g_date then

1396: l_char_age := to_char(p_age);
1397: --
1398: end if;
1399: --
1400: if p_adjusted_service_date = hr_api.g_date then
1401: --
1402: l_char_adjusted_service_date := hr_api.g_varchar2;
1403: --
1404: else

Line 1402: l_char_adjusted_service_date := hr_api.g_varchar2;

1398: end if;
1399: --
1400: if p_adjusted_service_date = hr_api.g_date then
1401: --
1402: l_char_adjusted_service_date := hr_api.g_varchar2;
1403: --
1404: else
1405: --
1406: l_char_adjusted_service_date := fnd_date.date_to_canonical(p_adjusted_service_date);

Line 1410: if p_original_hire_date = hr_api.g_date then

1406: l_char_adjusted_service_date := fnd_date.date_to_canonical(p_adjusted_service_date);
1407: --
1408: end if;
1409: --
1410: if p_original_hire_date = hr_api.g_date then
1411: --
1412: l_char_original_hire_date := hr_api.g_varchar2;
1413: --
1414: else

Line 1412: l_char_original_hire_date := hr_api.g_varchar2;

1408: end if;
1409: --
1410: if p_original_hire_date = hr_api.g_date then
1411: --
1412: l_char_original_hire_date := hr_api.g_varchar2;
1413: --
1414: else
1415: --
1416: l_char_original_hire_date := fnd_date.date_to_canonical(p_original_hire_date);

Line 1420: if p_termination_date = hr_api.g_date then

1416: l_char_original_hire_date := fnd_date.date_to_canonical(p_original_hire_date);
1417: --
1418: end if;
1419: --
1420: if p_termination_date = hr_api.g_date then
1421: --
1422: l_char_termination_date := hr_api.g_varchar2;
1423: --
1424: else

Line 1422: l_char_termination_date := hr_api.g_varchar2;

1418: end if;
1419: --
1420: if p_termination_date = hr_api.g_date then
1421: --
1422: l_char_termination_date := hr_api.g_varchar2;
1423: --
1424: else
1425: --
1426: l_char_termination_date := fnd_date.date_to_canonical(p_termination_date);

Line 1430: if p_leave_of_absence_date = hr_api.g_date then

1426: l_char_termination_date := fnd_date.date_to_canonical(p_termination_date);
1427: --
1428: end if;
1429: --
1430: if p_leave_of_absence_date = hr_api.g_date then
1431: --
1432: l_char_leave_of_absence_date := hr_api.g_varchar2;
1433: --
1434: else

Line 1432: l_char_leave_of_absence_date := hr_api.g_varchar2;

1428: end if;
1429: --
1430: if p_leave_of_absence_date = hr_api.g_date then
1431: --
1432: l_char_leave_of_absence_date := hr_api.g_varchar2;
1433: --
1434: else
1435: --
1436: l_char_leave_of_absence_date := fnd_date.date_to_canonical(p_leave_of_absence_date);

Line 1440: if p_date_of_hire = hr_api.g_date then

1436: l_char_leave_of_absence_date := fnd_date.date_to_canonical(p_leave_of_absence_date);
1437: --
1438: end if;
1439: --
1440: if p_date_of_hire = hr_api.g_date then
1441: --
1442: l_char_date_of_hire := hr_api.g_varchar2;
1443: --
1444: else

Line 1442: l_char_date_of_hire := hr_api.g_varchar2;

1438: end if;
1439: --
1440: if p_date_of_hire = hr_api.g_date then
1441: --
1442: l_char_date_of_hire := hr_api.g_varchar2;
1443: --
1444: else
1445: --
1446: l_char_date_of_hire := fnd_date.date_to_canonical(p_date_of_hire);

Line 1473: raise hr_api.validate_enabled;

1469: --
1470: -- When in validation only mode raise the Validate_Enabled exception
1471: --
1472: if p_validate then
1473: raise hr_api.validate_enabled;
1474: end if;
1475: --
1476: -- Set all output arguments
1477: --

Line 1484: when hr_api.validate_enabled then

1480: p_effective_end_date := l_effective_end_date;
1481: --
1482: hr_utility.set_location(' Leaving:'||l_proc, 30);
1483: exception
1484: when hr_api.validate_enabled then
1485: --
1486: -- As the Validate_Enabled exception has been raised
1487: -- we must rollback to the savepoint
1488: --

Line 1622: if p_datetrack_mode = hr_api.g_zap then

1618: hr_utility.set_location(l_proc, 20);
1619: --
1620: -- Check the datetrack mode
1621: --
1622: if p_datetrack_mode = hr_api.g_zap then
1623: --
1624: -- Remove related information
1625: --
1626: -- - Remove all benefits assignment related PTUs

Line 1736: elsif p_datetrack_mode = hr_api.g_delete then

1732: --
1733: delete from pay_assignment_link_usages_f
1734: where assignment_id = p_assignment_id;
1735: --
1736: elsif p_datetrack_mode = hr_api.g_delete then
1737: --
1738: -- End date related information
1739: --
1740: -- - PTUs

Line 1810: raise hr_api.validate_enabled;

1806: --
1807: -- When in validation only mode raise the Validate_Enabled exception
1808: --
1809: if p_validate then
1810: raise hr_api.validate_enabled;
1811: end if;
1812: --
1813: -- Set OUT parameters
1814: --

Line 1823: when hr_api.validate_enabled then

1819: hr_utility.set_location(' Leaving:'||l_proc, 70);
1820: --
1821: exception
1822: --
1823: when hr_api.validate_enabled then
1824: --
1825: -- As the Validate_Enabled exception has been raised
1826: -- we must rollback to the savepoint
1827: --