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 291: when hr_api.cannot_find_prog_unit then

287: --
288: begin
289: null;
290: exception
291: when hr_api.cannot_find_prog_unit then
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'CREATE_SECONDARY_EMP_ASG'
294: ,p_hook_type => 'BP'
295: );

Line 292: hr_api.cannot_find_prog_unit_error

288: begin
289: null;
290: exception
291: when hr_api.cannot_find_prog_unit then
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'CREATE_SECONDARY_EMP_ASG'
294: ,p_hook_type => 'BP'
295: );
296: --

Line 307: hr_api.mandatory_arg_error

303: -- Validation in addition to Table Handlers
304: --
305: -- Get person details.
306: --
307: hr_api.mandatory_arg_error
308: (p_api_name => l_proc
309: ,p_argument => 'person_id'
310: ,p_argument_value => p_person_id
311: );

Line 313: hr_api.mandatory_arg_error

309: ,p_argument => 'person_id'
310: ,p_argument_value => p_person_id
311: );
312: --
313: hr_api.mandatory_arg_error
314: (p_api_name => l_proc
315: ,p_argument => 'effective_date'
316: ,p_argument_value => l_effective_date
317: );

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

382: (c_bgp_id => l_business_group_id
383: );
384: --
385: fetch c_getdefmthpaydets into l_mthpayroll_id;
386: if hr_api.return_legislation_code(l_business_group_id) in ('US','CA') and
387: (c_getdefmthpaydets%notfound or l_mthpayroll_id is null) then --Bug 1539414
388: close c_getdefmthpaydets;
389: --
390: hr_utility.set_message(805,'BEN_92109_NODEFPAYEXISTS');

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

501: hr_utility.set_location(l_proc, 40);
502:
503: --
504: -- Call per_asg_ins.ins when p_called_from = 'FORM', (called from BENEBNAS.pld)
505: -- to create benefits assignment with HR api validations.
506: --
507: -- Call ben_asg_ins.ins when p_called_from is NULL, to create benefits assignment
508: -- without HR api validations
509: --

Line 508: -- without HR api validations

504: -- Call per_asg_ins.ins when p_called_from = 'FORM', (called from BENEBNAS.pld)
505: -- to create benefits assignment with HR api validations.
506: --
507: -- Call ben_asg_ins.ins when p_called_from is NULL, to create benefits assignment
508: -- without HR api validations
509: --
510:
511: if p_called_from = 'FORM' then
512: per_asg_ins.ins

Line 770: when hr_api.cannot_find_prog_unit then

766: hr_utility.set_location(l_proc, 60);
767: begin
768: null;
769: exception
770: when hr_api.cannot_find_prog_unit then
771: hr_api.cannot_find_prog_unit_error
772: (p_module_name => 'CREATE_SECONDARY_EMP_ASG'
773: ,p_hook_type => 'AP'
774: );

Line 771: hr_api.cannot_find_prog_unit_error

767: begin
768: null;
769: exception
770: when hr_api.cannot_find_prog_unit then
771: hr_api.cannot_find_prog_unit_error
772: (p_module_name => 'CREATE_SECONDARY_EMP_ASG'
773: ,p_hook_type => 'AP'
774: );
775: --

Line 783: raise hr_api.validate_enabled;

779: --
780: -- When in validation only mode raise the Validate_Enabled exception
781: --
782: if p_validate then
783: raise hr_api.validate_enabled;
784: end if;
785: --
786: -- Set remaining output arguments
787: --

Line 797: when hr_api.validate_enabled then

793: p_aei_object_version_number := l_aei_ovn;
794: --
795: hr_utility.set_location(' Leaving:'||l_proc, 50);
796: exception
797: when hr_api.validate_enabled then
798: --
799: -- As the Validate_Enabled exception has been raised
800: -- we must rollback to the savepoint
801: --

Line 837: ,p_grade_id in number default hr_api.g_number

833: ,p_datetrack_update_mode in varchar2
834: ,p_assignment_id in number
835: ,p_object_version_number in out nocopy number
836: --
837: ,p_grade_id in number default hr_api.g_number
838: ,p_position_id in number default hr_api.g_number
839: ,p_job_id in number default hr_api.g_number
840: ,p_payroll_id in number default hr_api.g_number
841: ,p_location_id in number default hr_api.g_number

Line 838: ,p_position_id in number default hr_api.g_number

834: ,p_assignment_id in number
835: ,p_object_version_number in out nocopy number
836: --
837: ,p_grade_id in number default hr_api.g_number
838: ,p_position_id in number default hr_api.g_number
839: ,p_job_id in number default hr_api.g_number
840: ,p_payroll_id in number default hr_api.g_number
841: ,p_location_id in number default hr_api.g_number
842: ,p_special_ceiling_step_id in out nocopy number

Line 839: ,p_job_id in number default hr_api.g_number

835: ,p_object_version_number in out nocopy number
836: --
837: ,p_grade_id in number default hr_api.g_number
838: ,p_position_id in number default hr_api.g_number
839: ,p_job_id in number default hr_api.g_number
840: ,p_payroll_id in number default hr_api.g_number
841: ,p_location_id in number default hr_api.g_number
842: ,p_special_ceiling_step_id in out nocopy number
843: ,p_organization_id in number default hr_api.g_number

Line 840: ,p_payroll_id in number default hr_api.g_number

836: --
837: ,p_grade_id in number default hr_api.g_number
838: ,p_position_id in number default hr_api.g_number
839: ,p_job_id in number default hr_api.g_number
840: ,p_payroll_id in number default hr_api.g_number
841: ,p_location_id in number default hr_api.g_number
842: ,p_special_ceiling_step_id in out nocopy number
843: ,p_organization_id in number default hr_api.g_number
844: ,p_people_group_id in number default hr_api.g_number

Line 841: ,p_location_id in number default hr_api.g_number

837: ,p_grade_id in number default hr_api.g_number
838: ,p_position_id in number default hr_api.g_number
839: ,p_job_id in number default hr_api.g_number
840: ,p_payroll_id in number default hr_api.g_number
841: ,p_location_id in number default hr_api.g_number
842: ,p_special_ceiling_step_id in out nocopy number
843: ,p_organization_id in number default hr_api.g_number
844: ,p_people_group_id in number default hr_api.g_number
845: ,p_pay_basis_id in number default hr_api.g_number

Line 843: ,p_organization_id in number default hr_api.g_number

839: ,p_job_id in number default hr_api.g_number
840: ,p_payroll_id in number default hr_api.g_number
841: ,p_location_id in number default hr_api.g_number
842: ,p_special_ceiling_step_id in out nocopy number
843: ,p_organization_id in number default hr_api.g_number
844: ,p_people_group_id in number default hr_api.g_number
845: ,p_pay_basis_id in number default hr_api.g_number
846: ,p_employment_category in varchar2 default hr_api.g_varchar2
847: --

Line 844: ,p_people_group_id in number default hr_api.g_number

840: ,p_payroll_id in number default hr_api.g_number
841: ,p_location_id in number default hr_api.g_number
842: ,p_special_ceiling_step_id in out nocopy number
843: ,p_organization_id in number default hr_api.g_number
844: ,p_people_group_id in number default hr_api.g_number
845: ,p_pay_basis_id in number default hr_api.g_number
846: ,p_employment_category in varchar2 default hr_api.g_varchar2
847: --
848: ,p_supervisor_id in number default hr_api.g_number

Line 845: ,p_pay_basis_id in number default hr_api.g_number

841: ,p_location_id in number default hr_api.g_number
842: ,p_special_ceiling_step_id in out nocopy number
843: ,p_organization_id in number default hr_api.g_number
844: ,p_people_group_id in number default hr_api.g_number
845: ,p_pay_basis_id in number default hr_api.g_number
846: ,p_employment_category in varchar2 default hr_api.g_varchar2
847: --
848: ,p_supervisor_id in number default hr_api.g_number
849: ,p_change_reason in varchar2 default hr_api.g_varchar2

Line 846: ,p_employment_category in varchar2 default hr_api.g_varchar2

842: ,p_special_ceiling_step_id in out nocopy number
843: ,p_organization_id in number default hr_api.g_number
844: ,p_people_group_id in number default hr_api.g_number
845: ,p_pay_basis_id in number default hr_api.g_number
846: ,p_employment_category in varchar2 default hr_api.g_varchar2
847: --
848: ,p_supervisor_id in number default hr_api.g_number
849: ,p_change_reason in varchar2 default hr_api.g_varchar2
850: ,p_comments in varchar2 default hr_api.g_varchar2

Line 848: ,p_supervisor_id in number default hr_api.g_number

844: ,p_people_group_id in number default hr_api.g_number
845: ,p_pay_basis_id in number default hr_api.g_number
846: ,p_employment_category in varchar2 default hr_api.g_varchar2
847: --
848: ,p_supervisor_id in number default hr_api.g_number
849: ,p_change_reason in varchar2 default hr_api.g_varchar2
850: ,p_comments in varchar2 default hr_api.g_varchar2
851: ,p_date_probation_end in date default hr_api.g_date
852: ,p_default_code_comb_id in number default hr_api.g_number

Line 849: ,p_change_reason in varchar2 default hr_api.g_varchar2

845: ,p_pay_basis_id in number default hr_api.g_number
846: ,p_employment_category in varchar2 default hr_api.g_varchar2
847: --
848: ,p_supervisor_id in number default hr_api.g_number
849: ,p_change_reason in varchar2 default hr_api.g_varchar2
850: ,p_comments in varchar2 default hr_api.g_varchar2
851: ,p_date_probation_end in date default hr_api.g_date
852: ,p_default_code_comb_id in number default hr_api.g_number
853: ,p_frequency in varchar2 default hr_api.g_varchar2

Line 850: ,p_comments in varchar2 default hr_api.g_varchar2

846: ,p_employment_category in varchar2 default hr_api.g_varchar2
847: --
848: ,p_supervisor_id in number default hr_api.g_number
849: ,p_change_reason in varchar2 default hr_api.g_varchar2
850: ,p_comments in varchar2 default hr_api.g_varchar2
851: ,p_date_probation_end in date default hr_api.g_date
852: ,p_default_code_comb_id in number default hr_api.g_number
853: ,p_frequency in varchar2 default hr_api.g_varchar2
854: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

Line 851: ,p_date_probation_end in date default hr_api.g_date

847: --
848: ,p_supervisor_id in number default hr_api.g_number
849: ,p_change_reason in varchar2 default hr_api.g_varchar2
850: ,p_comments in varchar2 default hr_api.g_varchar2
851: ,p_date_probation_end in date default hr_api.g_date
852: ,p_default_code_comb_id in number default hr_api.g_number
853: ,p_frequency in varchar2 default hr_api.g_varchar2
854: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
855: ,p_manager_flag in varchar2 default hr_api.g_varchar2

Line 852: ,p_default_code_comb_id in number default hr_api.g_number

848: ,p_supervisor_id in number default hr_api.g_number
849: ,p_change_reason in varchar2 default hr_api.g_varchar2
850: ,p_comments in varchar2 default hr_api.g_varchar2
851: ,p_date_probation_end in date default hr_api.g_date
852: ,p_default_code_comb_id in number default hr_api.g_number
853: ,p_frequency in varchar2 default hr_api.g_varchar2
854: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
855: ,p_manager_flag in varchar2 default hr_api.g_varchar2
856: ,p_normal_hours in number default hr_api.g_number

Line 853: ,p_frequency in varchar2 default hr_api.g_varchar2

849: ,p_change_reason in varchar2 default hr_api.g_varchar2
850: ,p_comments in varchar2 default hr_api.g_varchar2
851: ,p_date_probation_end in date default hr_api.g_date
852: ,p_default_code_comb_id in number default hr_api.g_number
853: ,p_frequency in varchar2 default hr_api.g_varchar2
854: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
855: ,p_manager_flag in varchar2 default hr_api.g_varchar2
856: ,p_normal_hours in number default hr_api.g_number
857: ,p_perf_review_period in number default hr_api.g_number

Line 854: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

850: ,p_comments in varchar2 default hr_api.g_varchar2
851: ,p_date_probation_end in date default hr_api.g_date
852: ,p_default_code_comb_id in number default hr_api.g_number
853: ,p_frequency in varchar2 default hr_api.g_varchar2
854: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
855: ,p_manager_flag in varchar2 default hr_api.g_varchar2
856: ,p_normal_hours in number default hr_api.g_number
857: ,p_perf_review_period in number default hr_api.g_number
858: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 855: ,p_manager_flag in varchar2 default hr_api.g_varchar2

851: ,p_date_probation_end in date default hr_api.g_date
852: ,p_default_code_comb_id in number default hr_api.g_number
853: ,p_frequency in varchar2 default hr_api.g_varchar2
854: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
855: ,p_manager_flag in varchar2 default hr_api.g_varchar2
856: ,p_normal_hours in number default hr_api.g_number
857: ,p_perf_review_period in number default hr_api.g_number
858: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
859: ,p_probation_period in number default hr_api.g_number

Line 856: ,p_normal_hours in number default hr_api.g_number

852: ,p_default_code_comb_id in number default hr_api.g_number
853: ,p_frequency in varchar2 default hr_api.g_varchar2
854: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
855: ,p_manager_flag in varchar2 default hr_api.g_varchar2
856: ,p_normal_hours in number default hr_api.g_number
857: ,p_perf_review_period in number default hr_api.g_number
858: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
859: ,p_probation_period in number default hr_api.g_number
860: ,p_probation_unit in varchar2 default hr_api.g_varchar2

Line 857: ,p_perf_review_period in number default hr_api.g_number

853: ,p_frequency in varchar2 default hr_api.g_varchar2
854: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
855: ,p_manager_flag in varchar2 default hr_api.g_varchar2
856: ,p_normal_hours in number default hr_api.g_number
857: ,p_perf_review_period in number default hr_api.g_number
858: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
859: ,p_probation_period in number default hr_api.g_number
860: ,p_probation_unit in varchar2 default hr_api.g_varchar2
861: ,p_sal_review_period in number default hr_api.g_number

Line 858: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

854: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
855: ,p_manager_flag in varchar2 default hr_api.g_varchar2
856: ,p_normal_hours in number default hr_api.g_number
857: ,p_perf_review_period in number default hr_api.g_number
858: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
859: ,p_probation_period in number default hr_api.g_number
860: ,p_probation_unit in varchar2 default hr_api.g_varchar2
861: ,p_sal_review_period in number default hr_api.g_number
862: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 859: ,p_probation_period in number default hr_api.g_number

855: ,p_manager_flag in varchar2 default hr_api.g_varchar2
856: ,p_normal_hours in number default hr_api.g_number
857: ,p_perf_review_period in number default hr_api.g_number
858: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
859: ,p_probation_period in number default hr_api.g_number
860: ,p_probation_unit in varchar2 default hr_api.g_varchar2
861: ,p_sal_review_period in number default hr_api.g_number
862: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
863: ,p_set_of_books_id in number default hr_api.g_number

Line 860: ,p_probation_unit in varchar2 default hr_api.g_varchar2

856: ,p_normal_hours in number default hr_api.g_number
857: ,p_perf_review_period in number default hr_api.g_number
858: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
859: ,p_probation_period in number default hr_api.g_number
860: ,p_probation_unit in varchar2 default hr_api.g_varchar2
861: ,p_sal_review_period in number default hr_api.g_number
862: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
863: ,p_set_of_books_id in number default hr_api.g_number
864: ,p_source_type in varchar2 default hr_api.g_varchar2

Line 861: ,p_sal_review_period in number default hr_api.g_number

857: ,p_perf_review_period in number default hr_api.g_number
858: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
859: ,p_probation_period in number default hr_api.g_number
860: ,p_probation_unit in varchar2 default hr_api.g_varchar2
861: ,p_sal_review_period in number default hr_api.g_number
862: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
863: ,p_set_of_books_id in number default hr_api.g_number
864: ,p_source_type in varchar2 default hr_api.g_varchar2
865: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

Line 862: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

858: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
859: ,p_probation_period in number default hr_api.g_number
860: ,p_probation_unit in varchar2 default hr_api.g_varchar2
861: ,p_sal_review_period in number default hr_api.g_number
862: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
863: ,p_set_of_books_id in number default hr_api.g_number
864: ,p_source_type in varchar2 default hr_api.g_varchar2
865: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
866: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

Line 863: ,p_set_of_books_id in number default hr_api.g_number

859: ,p_probation_period in number default hr_api.g_number
860: ,p_probation_unit in varchar2 default hr_api.g_varchar2
861: ,p_sal_review_period in number default hr_api.g_number
862: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
863: ,p_set_of_books_id in number default hr_api.g_number
864: ,p_source_type in varchar2 default hr_api.g_varchar2
865: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
866: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
867: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

Line 864: ,p_source_type in varchar2 default hr_api.g_varchar2

860: ,p_probation_unit in varchar2 default hr_api.g_varchar2
861: ,p_sal_review_period in number default hr_api.g_number
862: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
863: ,p_set_of_books_id in number default hr_api.g_number
864: ,p_source_type in varchar2 default hr_api.g_varchar2
865: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
866: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
867: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
868: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2

Line 865: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

861: ,p_sal_review_period in number default hr_api.g_number
862: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
863: ,p_set_of_books_id in number default hr_api.g_number
864: ,p_source_type in varchar2 default hr_api.g_varchar2
865: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
866: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
867: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
868: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
869: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2

Line 866: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

862: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
863: ,p_set_of_books_id in number default hr_api.g_number
864: ,p_source_type in varchar2 default hr_api.g_varchar2
865: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
866: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
867: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
868: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
869: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
870: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

Line 867: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

863: ,p_set_of_books_id in number default hr_api.g_number
864: ,p_source_type in varchar2 default hr_api.g_varchar2
865: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
866: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
867: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
868: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
869: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
870: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
871: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

Line 868: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2

864: ,p_source_type in varchar2 default hr_api.g_varchar2
865: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
866: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
867: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
868: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
869: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
870: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
871: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
872: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

Line 869: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2

865: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
866: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
867: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
868: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
869: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
870: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
871: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
872: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
873: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

Line 870: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

866: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
867: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
868: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
869: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
870: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
871: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
872: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
873: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
874: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

Line 871: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

867: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
868: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
869: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
870: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
871: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
872: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
873: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
874: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
875: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

Line 872: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

868: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
869: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
870: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
871: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
872: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
873: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
874: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
875: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
876: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

Line 873: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

869: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
870: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
871: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
872: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
873: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
874: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
875: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
876: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
877: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

Line 874: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

870: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
871: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
872: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
873: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
874: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
875: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
876: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
877: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
878: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

Line 875: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

871: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
872: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
873: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
874: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
875: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
876: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
877: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
878: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
879: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

Line 876: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

872: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
873: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
874: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
875: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
876: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
877: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
878: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
879: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
880: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

Line 877: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

873: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
874: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
875: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
876: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
877: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
878: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
879: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
880: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
881: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

Line 878: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

874: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
875: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
876: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
877: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
878: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
879: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
880: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
881: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
882: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

Line 879: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

875: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
876: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
877: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
878: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
879: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
880: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
881: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
882: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
883: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

Line 880: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

876: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
877: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
878: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
879: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
880: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
881: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
882: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
883: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
884: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

Line 881: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

877: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
878: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
879: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
880: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
881: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
882: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
883: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
884: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
885: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

Line 882: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

878: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
879: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
880: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
881: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
882: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
883: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
884: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
885: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
886: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

Line 883: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

879: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
880: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
881: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
882: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
883: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
884: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
885: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
886: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
887: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

Line 884: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

880: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
881: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
882: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
883: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
884: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
885: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
886: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
887: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
888: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

Line 885: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

881: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
882: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
883: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
884: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
885: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
886: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
887: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
888: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
889: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

Line 886: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

882: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
883: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
884: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
885: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
886: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
887: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
888: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
889: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
890: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

Line 887: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

883: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
884: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
885: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
886: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
887: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
888: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
889: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
890: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
891: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

Line 888: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

884: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
885: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
886: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
887: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
888: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
889: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
890: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
891: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
892: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

Line 889: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

885: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
886: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
887: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
888: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
889: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
890: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
891: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
892: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
893: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

Line 890: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

886: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
887: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
888: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
889: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
890: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
891: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
892: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
893: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
894: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

Line 891: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

887: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
888: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
889: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
890: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
891: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
892: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
893: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
894: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
895: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

Line 892: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

888: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
889: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
890: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
891: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
892: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
893: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
894: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
895: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
896: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

Line 893: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

889: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
890: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
891: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
892: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
893: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
894: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
895: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
896: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
897: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

Line 894: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

890: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
891: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
892: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
893: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
894: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
895: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
896: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
897: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
898: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

Line 895: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

891: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
892: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
893: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
894: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
895: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
896: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
897: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
898: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
899: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

Line 896: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

892: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
893: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
894: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
895: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
896: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
897: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
898: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
899: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
900: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

Line 897: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

893: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
894: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
895: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
896: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
897: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
898: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
899: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
900: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
901: ,p_title in varchar2 default hr_api.g_varchar2

Line 898: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

894: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
895: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
896: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
897: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
898: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
899: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
900: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
901: ,p_title in varchar2 default hr_api.g_varchar2
902: ,p_age in number default hr_api.g_number

Line 899: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

895: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
896: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
897: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
898: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
899: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
900: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
901: ,p_title in varchar2 default hr_api.g_varchar2
902: ,p_age in number default hr_api.g_number
903: ,p_adjusted_service_date in date default hr_api.g_date

Line 900: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

896: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
897: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
898: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
899: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
900: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
901: ,p_title in varchar2 default hr_api.g_varchar2
902: ,p_age in number default hr_api.g_number
903: ,p_adjusted_service_date in date default hr_api.g_date
904: ,p_original_hire_date in date default hr_api.g_date

Line 901: ,p_title in varchar2 default hr_api.g_varchar2

897: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
898: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
899: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
900: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
901: ,p_title in varchar2 default hr_api.g_varchar2
902: ,p_age in number default hr_api.g_number
903: ,p_adjusted_service_date in date default hr_api.g_date
904: ,p_original_hire_date in date default hr_api.g_date
905: ,p_salary in varchar2 default hr_api.g_varchar2

Line 902: ,p_age in number default hr_api.g_number

898: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
899: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
900: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
901: ,p_title in varchar2 default hr_api.g_varchar2
902: ,p_age in number default hr_api.g_number
903: ,p_adjusted_service_date in date default hr_api.g_date
904: ,p_original_hire_date in date default hr_api.g_date
905: ,p_salary in varchar2 default hr_api.g_varchar2
906: ,p_original_person_type in varchar2 default hr_api.g_varchar2

Line 903: ,p_adjusted_service_date in date default hr_api.g_date

899: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
900: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
901: ,p_title in varchar2 default hr_api.g_varchar2
902: ,p_age in number default hr_api.g_number
903: ,p_adjusted_service_date in date default hr_api.g_date
904: ,p_original_hire_date in date default hr_api.g_date
905: ,p_salary in varchar2 default hr_api.g_varchar2
906: ,p_original_person_type in varchar2 default hr_api.g_varchar2
907: ,p_original_person_type_id in varchar2 default hr_api.g_varchar2 -- Added parameter for Bug:7562768

Line 904: ,p_original_hire_date in date default hr_api.g_date

900: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
901: ,p_title in varchar2 default hr_api.g_varchar2
902: ,p_age in number default hr_api.g_number
903: ,p_adjusted_service_date in date default hr_api.g_date
904: ,p_original_hire_date in date default hr_api.g_date
905: ,p_salary in varchar2 default hr_api.g_varchar2
906: ,p_original_person_type in varchar2 default hr_api.g_varchar2
907: ,p_original_person_type_id in varchar2 default hr_api.g_varchar2 -- Added parameter for Bug:7562768
908: ,p_termination_date in date default hr_api.g_date

Line 905: ,p_salary in varchar2 default hr_api.g_varchar2

901: ,p_title in varchar2 default hr_api.g_varchar2
902: ,p_age in number default hr_api.g_number
903: ,p_adjusted_service_date in date default hr_api.g_date
904: ,p_original_hire_date in date default hr_api.g_date
905: ,p_salary in varchar2 default hr_api.g_varchar2
906: ,p_original_person_type in varchar2 default hr_api.g_varchar2
907: ,p_original_person_type_id in varchar2 default hr_api.g_varchar2 -- Added parameter for Bug:7562768
908: ,p_termination_date in date default hr_api.g_date
909: ,p_termination_reason in varchar2 default hr_api.g_varchar2

Line 906: ,p_original_person_type in varchar2 default hr_api.g_varchar2

902: ,p_age in number default hr_api.g_number
903: ,p_adjusted_service_date in date default hr_api.g_date
904: ,p_original_hire_date in date default hr_api.g_date
905: ,p_salary in varchar2 default hr_api.g_varchar2
906: ,p_original_person_type in varchar2 default hr_api.g_varchar2
907: ,p_original_person_type_id in varchar2 default hr_api.g_varchar2 -- Added parameter for Bug:7562768
908: ,p_termination_date in date default hr_api.g_date
909: ,p_termination_reason in varchar2 default hr_api.g_varchar2
910: ,p_leave_of_absence_date in date default hr_api.g_date

Line 907: ,p_original_person_type_id in varchar2 default hr_api.g_varchar2 -- Added parameter for Bug:7562768

903: ,p_adjusted_service_date in date default hr_api.g_date
904: ,p_original_hire_date in date default hr_api.g_date
905: ,p_salary in varchar2 default hr_api.g_varchar2
906: ,p_original_person_type in varchar2 default hr_api.g_varchar2
907: ,p_original_person_type_id in varchar2 default hr_api.g_varchar2 -- Added parameter for Bug:7562768
908: ,p_termination_date in date default hr_api.g_date
909: ,p_termination_reason in varchar2 default hr_api.g_varchar2
910: ,p_leave_of_absence_date in date default hr_api.g_date
911: ,p_absence_type in varchar2 default hr_api.g_varchar2

Line 908: ,p_termination_date in date default hr_api.g_date

904: ,p_original_hire_date in date default hr_api.g_date
905: ,p_salary in varchar2 default hr_api.g_varchar2
906: ,p_original_person_type in varchar2 default hr_api.g_varchar2
907: ,p_original_person_type_id in varchar2 default hr_api.g_varchar2 -- Added parameter for Bug:7562768
908: ,p_termination_date in date default hr_api.g_date
909: ,p_termination_reason in varchar2 default hr_api.g_varchar2
910: ,p_leave_of_absence_date in date default hr_api.g_date
911: ,p_absence_type in varchar2 default hr_api.g_varchar2
912: ,p_absence_reason in varchar2 default hr_api.g_varchar2

Line 909: ,p_termination_reason in varchar2 default hr_api.g_varchar2

905: ,p_salary in varchar2 default hr_api.g_varchar2
906: ,p_original_person_type in varchar2 default hr_api.g_varchar2
907: ,p_original_person_type_id in varchar2 default hr_api.g_varchar2 -- Added parameter for Bug:7562768
908: ,p_termination_date in date default hr_api.g_date
909: ,p_termination_reason in varchar2 default hr_api.g_varchar2
910: ,p_leave_of_absence_date in date default hr_api.g_date
911: ,p_absence_type in varchar2 default hr_api.g_varchar2
912: ,p_absence_reason in varchar2 default hr_api.g_varchar2
913: ,p_date_of_hire in date default hr_api.g_date

Line 910: ,p_leave_of_absence_date in date default hr_api.g_date

906: ,p_original_person_type in varchar2 default hr_api.g_varchar2
907: ,p_original_person_type_id in varchar2 default hr_api.g_varchar2 -- Added parameter for Bug:7562768
908: ,p_termination_date in date default hr_api.g_date
909: ,p_termination_reason in varchar2 default hr_api.g_varchar2
910: ,p_leave_of_absence_date in date default hr_api.g_date
911: ,p_absence_type in varchar2 default hr_api.g_varchar2
912: ,p_absence_reason in varchar2 default hr_api.g_varchar2
913: ,p_date_of_hire in date default hr_api.g_date
914: --

Line 911: ,p_absence_type in varchar2 default hr_api.g_varchar2

907: ,p_original_person_type_id in varchar2 default hr_api.g_varchar2 -- Added parameter for Bug:7562768
908: ,p_termination_date in date default hr_api.g_date
909: ,p_termination_reason in varchar2 default hr_api.g_varchar2
910: ,p_leave_of_absence_date in date default hr_api.g_date
911: ,p_absence_type in varchar2 default hr_api.g_varchar2
912: ,p_absence_reason in varchar2 default hr_api.g_varchar2
913: ,p_date_of_hire in date default hr_api.g_date
914: --
915: ,p_called_from in varchar2 default hr_api.g_varchar2

Line 912: ,p_absence_reason in varchar2 default hr_api.g_varchar2

908: ,p_termination_date in date default hr_api.g_date
909: ,p_termination_reason in varchar2 default hr_api.g_varchar2
910: ,p_leave_of_absence_date in date default hr_api.g_date
911: ,p_absence_type in varchar2 default hr_api.g_varchar2
912: ,p_absence_reason in varchar2 default hr_api.g_varchar2
913: ,p_date_of_hire in date default hr_api.g_date
914: --
915: ,p_called_from in varchar2 default hr_api.g_varchar2
916: --

Line 913: ,p_date_of_hire in date default hr_api.g_date

909: ,p_termination_reason in varchar2 default hr_api.g_varchar2
910: ,p_leave_of_absence_date in date default hr_api.g_date
911: ,p_absence_type in varchar2 default hr_api.g_varchar2
912: ,p_absence_reason in varchar2 default hr_api.g_varchar2
913: ,p_date_of_hire in date default hr_api.g_date
914: --
915: ,p_called_from in varchar2 default hr_api.g_varchar2
916: --
917: ,p_effective_start_date out nocopy date

Line 915: ,p_called_from in varchar2 default hr_api.g_varchar2

911: ,p_absence_type in varchar2 default hr_api.g_varchar2
912: ,p_absence_reason in varchar2 default hr_api.g_varchar2
913: ,p_date_of_hire in date default hr_api.g_date
914: --
915: ,p_called_from in varchar2 default hr_api.g_varchar2
916: --
917: ,p_effective_start_date out nocopy date
918: ,p_effective_end_date out nocopy date
919: )

Line 1025: hr_api.mandatory_arg_error

1021: -- Validation in addition to Table Handlers
1022: --
1023: -- Get assignment type.
1024: --
1025: hr_api.mandatory_arg_error
1026: (p_api_name => l_proc
1027: ,p_argument => 'assignment_id'
1028: ,p_argument_value => p_assignment_id);
1029: --

Line 1030: hr_api.mandatory_arg_error

1026: (p_api_name => l_proc
1027: ,p_argument => 'assignment_id'
1028: ,p_argument_value => p_assignment_id);
1029: --
1030: hr_api.mandatory_arg_error
1031: (p_api_name => l_proc
1032: ,p_argument => 'effective_date'
1033: ,p_argument_value => l_effective_date);
1034: hr_utility.set_location('ASG ID: '||p_assignment_id||' '||l_proc, 25);

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

1098: --
1099:
1100: --
1101: -- Call per_asg_upd.upd when p_called_from = 'FORM', (called from BENEBNAS.pld)
1102: -- to update benefits assignment with HR api validations.
1103: --
1104: -- Call ben_asg_upd.upd when p_called_from is NULL, to update benefits assignment
1105: -- without HR api validations
1106: --

Line 1105: -- without HR api validations

1101: -- Call per_asg_upd.upd when p_called_from = 'FORM', (called from BENEBNAS.pld)
1102: -- to update benefits assignment with HR api validations.
1103: --
1104: -- Call ben_asg_upd.upd when p_called_from is NULL, to update benefits assignment
1105: -- without HR api validations
1106: --
1107:
1108: if p_called_from = 'FORM' then
1109: per_asg_upd.upd

Line 1128: ,p_assignment_number => hr_api.g_varchar2

1124: ,p_employment_category => p_employment_category
1125: --
1126: ,p_supervisor_id => p_supervisor_id
1127: ,p_soft_coding_keyflex_id => l_soft_coding_keyflex_id
1128: ,p_assignment_number => hr_api.g_varchar2
1129: ,p_change_reason => p_change_reason
1130: ,p_comment_id => l_comment_id
1131: ,p_comments => p_comments
1132: ,p_date_probation_end => l_date_probation_end

Line 1198: l_orig_payroll_id := hr_api.g_varchar2;

1194: ,p_hourly_salaried_warning => l_boolean_dummy2
1195: );
1196: else
1197:
1198: l_orig_payroll_id := hr_api.g_varchar2;
1199: l_payroll_changed := hr_api.g_varchar2;
1200:
1201: --- Defaulrt Payroll id passed only for
1202: --- Backend process, if Ben_Assg form modifield

Line 1199: l_payroll_changed := hr_api.g_varchar2;

1195: );
1196: else
1197:
1198: l_orig_payroll_id := hr_api.g_varchar2;
1199: l_payroll_changed := hr_api.g_varchar2;
1200:
1201: --- Defaulrt Payroll id passed only for
1202: --- Backend process, if Ben_Assg form modifield
1203: ---- the payroll passed as it is

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

1205: (c_bgp_id => l_business_group_id
1206: );
1207: --
1208: fetch c_getdefmthpaydets into l_mthpayroll_id;
1209: if hr_api.return_legislation_code(l_business_group_id) in ('US','CA') and
1210: (c_getdefmthpaydets%notfound or l_mthpayroll_id is null) then -- Bug 1539414
1211: close c_getdefmthpaydets;
1212: --
1213: hr_utility.set_message(805,'BEN_92109_NODEFPAYEXISTS');

Line 1257: ,p_assignment_number => hr_api.g_varchar2

1253: ,p_employment_category => p_employment_category
1254: --
1255: ,p_supervisor_id => p_supervisor_id
1256: ,p_soft_coding_keyflex_id => l_soft_coding_keyflex_id
1257: ,p_assignment_number => hr_api.g_varchar2
1258: ,p_change_reason => p_change_reason
1259: ,p_comment_id => l_comment_id
1260: ,p_comments => p_comments
1261: ,p_date_probation_end => l_date_probation_end

Line 1390: l_orig_payroll_id := hr_api.g_varchar2;

1386: l_payroll_changed := 'Y';
1387: --
1388: else
1389: --
1390: l_orig_payroll_id := hr_api.g_varchar2;
1391: l_payroll_changed := hr_api.g_varchar2;
1392: --
1393: end if;
1394: --

Line 1391: l_payroll_changed := hr_api.g_varchar2;

1387: --
1388: else
1389: --
1390: l_orig_payroll_id := hr_api.g_varchar2;
1391: l_payroll_changed := hr_api.g_varchar2;
1392: --
1393: end if;
1394: --
1395: else

Line 1401: l_orig_payroll_id := hr_api.g_varchar2;

1397: hr_utility.set_location(l_proc, 60);
1398: --
1399: -- Unchanged
1400: --
1401: l_orig_payroll_id := hr_api.g_varchar2;
1402: l_payroll_changed := hr_api.g_varchar2;
1403: --
1404: end if;
1405: */

Line 1402: l_payroll_changed := hr_api.g_varchar2;

1398: --
1399: -- Unchanged
1400: --
1401: l_orig_payroll_id := hr_api.g_varchar2;
1402: l_payroll_changed := hr_api.g_varchar2;
1403: --
1404: end if;
1405: */
1406: --

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

1410: --
1411: -- Bug 1904347 : eventhough update_ben_asg defaults p_age to number and
1412: -- p_adjusted_service_date, p_original_hire_date, p_termination_date
1413: -- p_leave_of_absence_date are defaulted to dates, when they are defaulted
1414: -- they have to go as hr_api.g_varchar2.
1415: --
1416: hr_utility.set_location('ORIG PAY ID: '||l_orig_payroll_id||' '||l_proc, 50);
1417: if p_age = hr_api.g_number then
1418: --

Line 1417: if p_age = hr_api.g_number then

1413: -- p_leave_of_absence_date are defaulted to dates, when they are defaulted
1414: -- they have to go as hr_api.g_varchar2.
1415: --
1416: hr_utility.set_location('ORIG PAY ID: '||l_orig_payroll_id||' '||l_proc, 50);
1417: if p_age = hr_api.g_number then
1418: --
1419: l_char_age := hr_api.g_varchar2;
1420: --
1421: else

Line 1419: l_char_age := hr_api.g_varchar2;

1415: --
1416: hr_utility.set_location('ORIG PAY ID: '||l_orig_payroll_id||' '||l_proc, 50);
1417: if p_age = hr_api.g_number then
1418: --
1419: l_char_age := hr_api.g_varchar2;
1420: --
1421: else
1422: --
1423: l_char_age := to_char(p_age);

Line 1427: if p_adjusted_service_date = hr_api.g_date then

1423: l_char_age := to_char(p_age);
1424: --
1425: end if;
1426: --
1427: if p_adjusted_service_date = hr_api.g_date then
1428: --
1429: l_char_adjusted_service_date := hr_api.g_varchar2;
1430: --
1431: else

Line 1429: l_char_adjusted_service_date := hr_api.g_varchar2;

1425: end if;
1426: --
1427: if p_adjusted_service_date = hr_api.g_date then
1428: --
1429: l_char_adjusted_service_date := hr_api.g_varchar2;
1430: --
1431: else
1432: --
1433: l_char_adjusted_service_date := fnd_date.date_to_canonical(p_adjusted_service_date);

Line 1437: if p_original_hire_date = hr_api.g_date then

1433: l_char_adjusted_service_date := fnd_date.date_to_canonical(p_adjusted_service_date);
1434: --
1435: end if;
1436: --
1437: if p_original_hire_date = hr_api.g_date then
1438: --
1439: l_char_original_hire_date := hr_api.g_varchar2;
1440: --
1441: else

Line 1439: l_char_original_hire_date := hr_api.g_varchar2;

1435: end if;
1436: --
1437: if p_original_hire_date = hr_api.g_date then
1438: --
1439: l_char_original_hire_date := hr_api.g_varchar2;
1440: --
1441: else
1442: --
1443: l_char_original_hire_date := fnd_date.date_to_canonical(p_original_hire_date);

Line 1447: if p_termination_date = hr_api.g_date then

1443: l_char_original_hire_date := fnd_date.date_to_canonical(p_original_hire_date);
1444: --
1445: end if;
1446: --
1447: if p_termination_date = hr_api.g_date then
1448: --
1449: l_char_termination_date := hr_api.g_varchar2;
1450: --
1451: else

Line 1449: l_char_termination_date := hr_api.g_varchar2;

1445: end if;
1446: --
1447: if p_termination_date = hr_api.g_date then
1448: --
1449: l_char_termination_date := hr_api.g_varchar2;
1450: --
1451: else
1452: --
1453: l_char_termination_date := fnd_date.date_to_canonical(p_termination_date);

Line 1457: if p_leave_of_absence_date = hr_api.g_date then

1453: l_char_termination_date := fnd_date.date_to_canonical(p_termination_date);
1454: --
1455: end if;
1456: --
1457: if p_leave_of_absence_date = hr_api.g_date then
1458: --
1459: l_char_leave_of_absence_date := hr_api.g_varchar2;
1460: --
1461: else

Line 1459: l_char_leave_of_absence_date := hr_api.g_varchar2;

1455: end if;
1456: --
1457: if p_leave_of_absence_date = hr_api.g_date then
1458: --
1459: l_char_leave_of_absence_date := hr_api.g_varchar2;
1460: --
1461: else
1462: --
1463: l_char_leave_of_absence_date := fnd_date.date_to_canonical(p_leave_of_absence_date);

Line 1467: if p_date_of_hire = hr_api.g_date then

1463: l_char_leave_of_absence_date := fnd_date.date_to_canonical(p_leave_of_absence_date);
1464: --
1465: end if;
1466: --
1467: if p_date_of_hire = hr_api.g_date then
1468: --
1469: l_char_date_of_hire := hr_api.g_varchar2;
1470: --
1471: else

Line 1469: l_char_date_of_hire := hr_api.g_varchar2;

1465: end if;
1466: --
1467: if p_date_of_hire = hr_api.g_date then
1468: --
1469: l_char_date_of_hire := hr_api.g_varchar2;
1470: --
1471: else
1472: --
1473: l_char_date_of_hire := fnd_date.date_to_canonical(p_date_of_hire);

Line 1501: raise hr_api.validate_enabled;

1497: --
1498: -- When in validation only mode raise the Validate_Enabled exception
1499: --
1500: if p_validate then
1501: raise hr_api.validate_enabled;
1502: end if;
1503: --
1504: -- Set all output arguments
1505: --

Line 1512: when hr_api.validate_enabled then

1508: p_effective_end_date := l_effective_end_date;
1509: --
1510: hr_utility.set_location(' Leaving:'||l_proc, 30);
1511: exception
1512: when hr_api.validate_enabled then
1513: --
1514: -- As the Validate_Enabled exception has been raised
1515: -- we must rollback to the savepoint
1516: --

Line 1650: if p_datetrack_mode = hr_api.g_zap then

1646: hr_utility.set_location(l_proc, 20);
1647: --
1648: -- Check the datetrack mode
1649: --
1650: if p_datetrack_mode = hr_api.g_zap then
1651: --
1652: -- Remove related information
1653: --
1654: -- - Remove all benefits assignment related PTUs

Line 1764: elsif p_datetrack_mode = hr_api.g_delete then

1760: --
1761: delete from pay_assignment_link_usages_f
1762: where assignment_id = p_assignment_id;
1763: --
1764: elsif p_datetrack_mode = hr_api.g_delete then
1765: --
1766: -- End date related information
1767: --
1768: -- - PTUs

Line 1838: raise hr_api.validate_enabled;

1834: --
1835: -- When in validation only mode raise the Validate_Enabled exception
1836: --
1837: if p_validate then
1838: raise hr_api.validate_enabled;
1839: end if;
1840: --
1841: -- Set OUT parameters
1842: --

Line 1851: when hr_api.validate_enabled then

1847: hr_utility.set_location(' Leaving:'||l_proc, 70);
1848: --
1849: exception
1850: --
1851: when hr_api.validate_enabled then
1852: --
1853: -- As the Validate_Enabled exception has been raised
1854: -- we must rollback to the savepoint
1855: --