[Home] [Help]
424: ,p_party_id => p_party_id
425: ,p_vacancy_id => p_vacancy_id
426: );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'CREATE_APPLICANT'
431: ,p_hook_type => 'BP'
432: );
425: ,p_vacancy_id => p_vacancy_id
426: );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'CREATE_APPLICANT'
431: ,p_hook_type => 'BP'
432: );
433: --
764: ,p_name_combination_warning => l_name_combination_warning
765: ,p_orig_hire_warning => l_orig_hire_warning
766: );
767: exception
768: when hr_api.cannot_find_prog_unit then
769: hr_api.cannot_find_prog_unit_error
770: (p_module_name => 'CREATE_APPLICANT'
771: ,p_hook_type => 'AP'
772: );
765: ,p_orig_hire_warning => l_orig_hire_warning
766: );
767: exception
768: when hr_api.cannot_find_prog_unit then
769: hr_api.cannot_find_prog_unit_error
770: (p_module_name => 'CREATE_APPLICANT'
771: ,p_hook_type => 'AP'
772: );
773: --
777: --
778: -- When in validation only mode raise the Validate_Enabled exception
779: --
780: if p_validate then
781: raise hr_api.validate_enabled;
782: end if;
783: --
784: -- Set OUT parameters
785: --
811: p_applicant_number := l_applicant_number;
812:
813: hr_utility.set_location(' Leaving:'||l_proc, 50);
814: exception
815: when hr_api.validate_enabled then
816: --
817: -- As the Validate_Enabled exception has been raised
818: -- we must rollback to the savepoint
819: --
1752: p_hire_date in date,
1753: p_person_id in per_all_people_f.person_id%TYPE,
1754: p_assignment_id in number, --default null,
1755: p_person_type_id in number, --default null,
1756: p_national_identifier in per_all_people_f.national_identifier%type, --default hr_api.g_varchar2,
1757: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1758: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1759: p_per_effective_start_date out nocopy date,
1760: p_per_effective_end_date out nocopy date,
1804: p_hire_date in date,
1805: p_person_id in per_all_people_f.person_id%TYPE,
1806: p_assignment_id in number, --default null,
1807: p_person_type_id in number, --default null,
1808: p_national_identifier in per_all_people_f.national_identifier%type, --default hr_api.g_varchar2,
1809: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1810: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1811: p_per_effective_start_date out nocopy date,
1812: p_per_effective_end_date out nocopy date,
1905: l_apln_date_to date;
1906: l_yes_backtoback varchar2(1) :='N';
1907:
1908: cursor csr_get_apln_details is
1909: select date_received,nvl(date_end ,hr_api.g_eot)
1910: from per_applications
1911: where person_id = p_person_id and date_received > l_hire_date;
1912:
1913: cursor csr_back_toback_apln is
1926:
1927: cursor chk_apl_exists(p_asg_start_date date) is
1928: select application_id, date_end from per_applications
1929: where person_id = p_person_id
1930: and p_asg_start_date between date_received and nvl(date_end,hr_api.g_eot);
1931:
1932: cursor chk_future_changes(p_assignment_id number) is
1933: select 'Y' from per_all_assignments_f
1934: where person_id = p_person_id
2028: and per.person_id = p_person_id
2029: and l_hire_date between per.effective_start_date
2030: and per.effective_end_date
2031: and l_hire_date between pap.date_received
2032: and nvl(pap.date_end,hr_api.g_eot);
2033: --
2034: cursor csr_chk_asg_status is
2035: select count(asg.assignment_id)
2036: from per_assignments_f asg,
2415:
2416: end if;
2417: -- End chagnes for bug 9879782
2418: --
2419: hr_api.mandatory_arg_error
2420: (p_api_name => l_proc
2421: ,p_argument => 'person_id'
2422: ,p_argument_value => p_person_id
2423: );
2421: ,p_argument => 'person_id'
2422: ,p_argument_value => p_person_id
2423: );
2424: --
2425: hr_api.mandatory_arg_error
2426: (p_api_name => l_proc
2427: ,p_argument => 'hire_date'
2428: ,p_argument_value => p_hire_date
2429: );
2535: p_employee_number => p_employee_number,
2536: p_original_date_of_hire => l_original_date_of_hire
2537: );
2538: exception
2539: when hr_api.cannot_find_prog_unit then
2540: hr_api.cannot_find_prog_unit_error
2541: (p_module_name => 'HIRE_APPLICANT'
2542: ,p_hook_type => 'BP'
2543: );
2536: p_original_date_of_hire => l_original_date_of_hire
2537: );
2538: exception
2539: when hr_api.cannot_find_prog_unit then
2540: hr_api.cannot_find_prog_unit_error
2541: (p_module_name => 'HIRE_APPLICANT'
2542: ,p_hook_type => 'BP'
2543: );
2544: --
2655: hr_utility.set_location(l_proc,100);
2656: --
2657: --close csr_chk_asg_status;
2658: --
2659: hr_api.mandatory_arg_error
2660: (p_api_name => l_proc
2661: ,p_argument => 'assignment_id'
2662: ,p_argument_value => p_assignment_id
2663: );
2865: where person_id = p_person_id
2866: and assignment_id = apl.assignment_id
2867: and assignment_type = 'A';
2868:
2869: if l_apl_end_date = hr_api.g_eot then
2870: l_apl_end_date := null;
2871: end if;
2872:
2873: -- check whether an application exists on the start date of the ASG
2895:
2896: else
2897:
2898: -- if APLN end date < ASG end date, update the APLN
2899: if nvl(l_current_apl_end_date,hr_api.g_eot) < nvl(l_apl_end_date,hr_api.g_eot) then
2900: update per_applications
2901: set date_end = l_apl_end_date
2902: where person_id = p_person_id
2903: and application_id = l_cur_apl_id;
3250: ,p_original_date_of_hire => l_original_date_of_hire
3251: ,p_per_information7 => l_new_hire_code
3252: );
3253:
3254: if l_apln_date_to <> hr_api.g_eot then
3255:
3256: -- checking for back-to-back APLN
3257: open csr_back_toback_apln ;
3258: fetch csr_back_toback_apln into l_yes_backtoback;
3342: -- 3) When the accepted assignments are multiple, the primary flag of the
3343: -- record not specified by P_ASSIGNMENT_ID is set to 'N'.
3344: --
3345: -- reset l_assignment_status_type_id for updating the accepted assignments
3346: l_assignment_status_type_id := hr_api.g_number;
3347: --
3348: per_asg_bus1.chk_assignment_status_type
3349: (p_assignment_status_type_id => l_assignment_status_type_id
3350: ,p_business_group_id => l_business_group_id
3409:
3410: if l_soft_coding_keyflex_id is null and l_payroll_id is not null and p_source=true then
3411: l_soft_coding_keyflex_id := l_dummy_soft_coding_keyflex_id;
3412: else
3413: l_soft_coding_keyflex_id := hr_api.g_number;
3414: end if;
3415:
3416: --Fix For Bug 5749371 Ends
3417:
3635:
3636: if l_soft_coding_keyflex_id is null and l_payroll_id is not null and p_source=true then
3637: l_soft_coding_keyflex_id := l_dummy_soft_coding_keyflex_id;
3638: else
3639: l_soft_coding_keyflex_id := hr_api.g_number;
3640: end if;
3641:
3642: --Fix For Bug 5749371 Ends
3643:
4024: p_oversubscribed_vacancy_id => l_oversubscribed_vacancy_id,
4025: p_original_date_of_hire => l_original_date_of_hire
4026: );
4027: exception
4028: when hr_api.cannot_find_prog_unit then
4029: hr_api.cannot_find_prog_unit_error
4030: (p_module_name => 'HIRE_APPLICANT'
4031: ,p_hook_type => 'AP'
4032: );
4025: p_original_date_of_hire => l_original_date_of_hire
4026: );
4027: exception
4028: when hr_api.cannot_find_prog_unit then
4029: hr_api.cannot_find_prog_unit_error
4030: (p_module_name => 'HIRE_APPLICANT'
4031: ,p_hook_type => 'AP'
4032: );
4033: --
4037: --
4038: -- When in validation only mode raise the Validate_Enabled exception
4039: --
4040: if p_validate then
4041: raise hr_api.validate_enabled;
4042: end if;
4043: --
4044: --
4045: p_employee_number := l_employee_number;
4052: --
4053: hr_utility.set_location(' Leaving:'||l_proc, 250);
4054: --
4055: exception
4056: when hr_api.validate_enabled then
4057: --
4058: -- As the Validate_Enabled exception has been raised
4059: -- we must rollback to the savepoint
4060: --
4108: (p_validate IN BOOLEAN --DEFAULT FALSE
4109: ,p_effective_date IN DATE
4110: ,p_person_id IN per_all_people_f.person_id%TYPE
4111: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4112: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT hr_api.g_number
4113: ,p_termination_reason IN per_applications.termination_reason%TYPE --DEFAULT NULL
4114: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4115: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4116: )
4349: hr_utility.set_location('Entering:'||l_proc,10);
4350: --
4351: -- Ensure mandatory arguments have been passed
4352: --
4353: hr_api.mandatory_arg_error
4354: (p_api_name => l_proc
4355: ,p_argument => 'person_id'
4356: ,p_argument_value => p_person_id
4357: );
4355: ,p_argument => 'person_id'
4356: ,p_argument_value => p_person_id
4357: );
4358: --
4359: hr_api.mandatory_arg_error
4360: (p_api_name => l_proc
4361: ,p_argument => 'effective_date'
4362: ,p_argument_value => p_effective_date
4363: );
4382: ,p_person_type_id => p_person_type_id
4383: ,p_termination_reason => p_termination_reason
4384: );
4385: EXCEPTION
4386: WHEN hr_api.cannot_find_prog_unit
4387: THEN
4388: hr_api.cannot_find_prog_unit_error
4389: (p_module_name => 'TERMINATE_APPLICANT'
4390: ,p_hook_type => 'B'
4384: );
4385: EXCEPTION
4386: WHEN hr_api.cannot_find_prog_unit
4387: THEN
4388: hr_api.cannot_find_prog_unit_error
4389: (p_module_name => 'TERMINATE_APPLICANT'
4390: ,p_hook_type => 'B'
4391: );
4392: END;
4458: close csr_lock_ptu;
4459: /*
4460: per_per_shd.lck
4461: (p_effective_date => l_effective_date + 1
4462: ,p_datetrack_mode => hr_api.g_update
4463: ,p_person_id => p_person_id
4464: ,p_object_version_number => p_object_version_number
4465: ,p_validation_start_date => l_validation_start_date
4466: ,p_validation_end_date => l_validation_end_date
4490: per_asg_del.del
4491: (p_assignment_id => l_fut_asg.assignment_id
4492: ,p_object_version_number => l_fut_asg.object_version_number
4493: ,p_effective_date => l_fut_asg.effective_start_date
4494: ,p_datetrack_mode => hr_api.g_zap
4495: ,p_effective_start_date => l_effective_start_date
4496: ,p_effective_end_date => l_effective_end_date
4497: ,p_business_group_id => l_business_group_id
4498: ,p_validation_start_date => l_validation_start_date
4506: (p_effective_date => l_effective_date
4507: ,p_person_id => p_person_id
4508: )
4509: LOOP
4510: if l_assignment.effective_end_date <> hr_api.g_eot then
4511: -- delete future DT updates
4512: per_asg_del.del
4513: (p_assignment_id => l_assignment.assignment_id
4514: ,p_object_version_number => l_assignment.object_version_number
4512: per_asg_del.del
4513: (p_assignment_id => l_assignment.assignment_id
4514: ,p_object_version_number => l_assignment.object_version_number
4515: ,p_effective_date => l_effective_date
4516: ,p_datetrack_mode => hr_api.g_future_change
4517: ,p_effective_start_date => l_effective_start_date
4518: ,p_effective_end_date => l_effective_end_date
4519: ,p_business_group_id => l_business_group_id
4520: ,p_validation_start_date => l_validation_start_date
4525: per_asg_del.del
4526: (p_assignment_id => l_assignment.assignment_id
4527: ,p_object_version_number => l_assignment.object_version_number
4528: ,p_effective_date => l_effective_date
4529: ,p_datetrack_mode => hr_api.g_delete
4530: ,p_effective_start_date => l_effective_start_date
4531: ,p_effective_end_date => l_effective_end_date
4532: ,p_business_group_id => l_business_group_id
4533: ,p_validation_start_date => l_validation_start_date
4540: per_asg_del.del
4541: (p_assignment_id => l_assignment.assignment_id
4542: ,p_object_version_number => l_assignment.object_version_number
4543: ,p_effective_date => l_effective_date
4544: ,p_datetrack_mode => hr_api.g_delete
4545: ,p_effective_start_date => l_effective_start_date
4546: ,p_effective_end_date => l_effective_end_date
4547: ,p_business_group_id => l_business_group_id
4548: ,p_validation_start_date => l_validation_start_date
4690: -- ,p_object_version_number => p_object_version_number
4691: -- ,p_effective_date => l_effective_date + 1
4692: -- ,p_applicant_number => l_application.applicant_number
4693: -- ,p_employee_number => l_application.employee_number
4694: -- ,p_datetrack_mode => hr_api.g_update
4695: -- ,p_person_type_id => l_person_type_id1
4696: -- ,p_effective_start_date => l_effective_start_date
4697: -- ,p_effective_end_date => l_effective_end_date
4698: -- ,p_comment_id => l_comment_id
4745: ,p_effective_end_date => l_effective_end_date
4746: ,p_remove_fut_asg_warning => l_remove_future_asg_warning
4747: );
4748: EXCEPTION
4749: WHEN hr_api.cannot_find_prog_unit
4750: THEN
4751: hr_api.cannot_find_prog_unit_error
4752: (p_module_name => 'TERMINATE_APPLICANT'
4753: ,p_hook_type => 'A'
4747: );
4748: EXCEPTION
4749: WHEN hr_api.cannot_find_prog_unit
4750: THEN
4751: hr_api.cannot_find_prog_unit_error
4752: (p_module_name => 'TERMINATE_APPLICANT'
4753: ,p_hook_type => 'A'
4754: );
4755: END;
4759: -- When in validation only mode raise validate enabled exception
4760: --
4761: IF p_validate
4762: THEN
4763: RAISE hr_api.validate_enabled;
4764: END IF;
4765: --
4766: -- Set OUT parameters
4767: --
4771: --
4772: hr_utility.set_location(' Leaving:'||l_proc,1000);
4773: --
4774: EXCEPTION
4775: WHEN hr_api.validate_enabled
4776: THEN
4777: --
4778: -- In validation only mode
4779: -- Rollback to savepoint
4922: hr_utility.set_location('Entering:'||l_proc,10);
4923: --
4924: -- Ensure mandatory arguments have been passed
4925: --
4926: hr_api.mandatory_arg_error
4927: (p_api_name => l_proc
4928: ,p_argument => 'person_id'
4929: ,p_argument_value => p_person_id
4930: );
4928: ,p_argument => 'person_id'
4929: ,p_argument_value => p_person_id
4930: );
4931: --
4932: hr_api.mandatory_arg_error
4933: (p_api_name => l_proc
4934: ,p_argument => 'effective_date'
4935: ,p_argument_value => p_effective_date
4936: );
4973: ,p_applicant_number => p_applicant_number
4974: ,p_person_type_id => p_person_type_id
4975: );
4976: EXCEPTION
4977: WHEN hr_api.cannot_find_prog_unit
4978: THEN
4979: hr_api.cannot_find_prog_unit_error
4980: (p_module_name => 'APPLY_FOR_VACANCY'
4981: ,p_hook_type => 'BP'
4975: );
4976: EXCEPTION
4977: WHEN hr_api.cannot_find_prog_unit
4978: THEN
4979: hr_api.cannot_find_prog_unit_error
4980: (p_module_name => 'APPLY_FOR_VACANCY'
4981: ,p_hook_type => 'BP'
4982: );
4983: END;
4997: --
4998: -- Ensure the applicant number will not be changed if it exists
4999: --
5000: IF l_per_details_rec.applicant_number IS NOT NULL
5001: AND NVL(p_applicant_number,hr_api.g_number) <> l_per_details_rec.applicant_number
5002: THEN
5003: hr_utility.set_location(l_proc,70);
5004: p_applicant_number := l_per_details_rec.applicant_number;
5005: END IF;
5048: ,p_effective_end_date => l_effective_end_date
5049: ,p_appl_override_warning => l_appl_override_warning
5050: );
5051: EXCEPTION
5052: WHEN hr_api.cannot_find_prog_unit
5053: THEN
5054: hr_api.cannot_find_prog_unit_error
5055: (p_module_name => 'APPLY_FOR_VACANCY'
5056: ,p_hook_type => 'AP'
5050: );
5051: EXCEPTION
5052: WHEN hr_api.cannot_find_prog_unit
5053: THEN
5054: hr_api.cannot_find_prog_unit_error
5055: (p_module_name => 'APPLY_FOR_VACANCY'
5056: ,p_hook_type => 'AP'
5057: );
5058: END;
5062: -- When in validation only mode raise validate_enabled exception
5063: --
5064: IF p_validate
5065: THEN
5066: RAISE hr_api.validate_enabled;
5067: END IF;
5068: --
5069: -- Set OUT parameters
5070: --
5075: hr_utility.set_location(' Leaving:'||l_proc,1000);
5076: --
5077: EXCEPTION
5078: --
5079: WHEN hr_api.validate_enabled
5080: THEN
5081: --
5082: -- In validation only mode
5083: -- Rollback to savepoint
5132: select application_id
5133: from per_applications
5134: where person_id = p_person_id
5135: and date_received < p_effective_date
5136: and nvl(date_end,hr_api.g_eot) >= p_effective_date;
5137:
5138: cursor csr_apl_yesterday is
5139: select application_id
5140: from per_applications
5286: --
5287: -- Ensure that the mandatory parameter, p_person_id
5288: -- is not null
5289: --
5290: hr_api.mandatory_arg_error
5291: (p_api_name => l_proc
5292: ,p_argument => 'person id'
5293: ,p_argument_value => p_person_id);
5294: --
5338: ,p_person_type_id => p_person_type_id
5339: ,p_assignment_status_type_id => p_assignment_status_type_id
5340: );
5341: exception
5342: when hr_api.cannot_find_prog_unit then
5343: hr_api.cannot_find_prog_unit_error
5344: (p_module_name => 'apply_for_job_anytime'
5345: ,p_hook_type => 'BP'
5346: );
5339: ,p_assignment_status_type_id => p_assignment_status_type_id
5340: );
5341: exception
5342: when hr_api.cannot_find_prog_unit then
5343: hr_api.cannot_find_prog_unit_error
5344: (p_module_name => 'apply_for_job_anytime'
5345: ,p_hook_type => 'BP'
5346: );
5347: --
5414: ,p_appl_override_warning => l_appl_override_warning
5415: );
5416: --
5417: exception
5418: when hr_api.cannot_find_prog_unit then
5419: hr_api.cannot_find_prog_unit_error
5420: (p_module_name => 'apply_for_job_anytime'
5421: ,p_hook_type => 'AP'
5422: );
5415: );
5416: --
5417: exception
5418: when hr_api.cannot_find_prog_unit then
5419: hr_api.cannot_find_prog_unit_error
5420: (p_module_name => 'apply_for_job_anytime'
5421: ,p_hook_type => 'AP'
5422: );
5423: --
5443: -- when in validation only mode raise the Validate_Enabled exception
5444: --
5445:
5446: if p_validate then
5447: raise hr_api.validate_enabled;
5448: end if;
5449: --
5450: if g_debug then
5451: hr_utility.set_location(' Leaving:'||l_proc, 50);
5450: if g_debug then
5451: hr_utility.set_location(' Leaving:'||l_proc, 50);
5452: end if;
5453: exception
5454: when hr_api.validate_enabled then
5455: --
5456: -- As the Validate_Enabled exception has been raised
5457: -- we must rollback to the savepoint
5458: --