[Home] [Help]
241: and a.assignment_status_type_id = b.assignment_status_type_id) ;
242:
243: cursor c3(p_date_end date) is
244: SELECT 1
245: FROM PER_ALL_PEOPLE_F PAPF
246: WHERE PAPF.PERSON_ID = P_PERSON_ID
247: AND PAPF.EFFECTIVE_START_DATE > p_DATE_END + 1 ;
248:
249:
400: hr_utility.set_location('Entering:'|| l_proc, 110);
401:
402: -- Maintain the Person data by deleting the Ex-Appl Record and the same with PTU Data.
403:
404: DELETE FROM per_all_people_f papf
405: WHERE papf.person_id = p_person_id
406: AND papf.business_group_id + 0 = p_Business_group_id
407: AND papf.effective_start_date = l_date_end + 1;
408: --
408: --
409:
410: hr_utility.set_location('REVERSE_TERM_APLN - l_date_end:'|| l_date_end, 120);
411:
412: UPDATE per_all_people_f papf
413: SET papf.effective_end_date = l_eot
414: WHERE papf.person_id = p_person_id
415: AND papf.BUSINESS_GROUP_ID + 0 = p_Business_group_id
416: AND papf.effective_end_date = l_date_end;
4505: --
4506: cursor csr_get_derived_details is
4507: select bus.business_group_id
4508: , bus.legislation_code
4509: from per_all_people_f per
4510: , per_business_groups_perf bus
4511: where per.person_id = p_person_id
4512: and l_effective_date between per.effective_start_date
4513: and per.effective_end_date
5932: --
5933: cursor csr_get_derived_details is
5934: select bus.business_group_id
5935: , bus.legislation_code
5936: from per_all_people_f per
5937: , per_business_groups_perf bus
5938: where per.person_id = p_person_id
5939: and l_effective_date between per.effective_start_date
5940: and per.effective_end_date
19206: lv_cagr_grade_def_id number := p_cagr_grade_def_id ;
19207: lv_people_group_id number := p_people_group_id ;
19208: lv_soft_coding_keyflex_id number := p_people_group_id ;
19209: --
19210: l_applicant_number per_all_people_f.applicant_number%TYPE;
19211: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
19212: l_appl_override_warning boolean;
19213: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
19214: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
19207: lv_people_group_id number := p_people_group_id ;
19208: lv_soft_coding_keyflex_id number := p_people_group_id ;
19209: --
19210: l_applicant_number per_all_people_f.applicant_number%TYPE;
19211: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
19212: l_appl_override_warning boolean;
19213: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
19214: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
19215: l_apl_object_version_number per_applications.object_version_number%TYPE;
19209: --
19210: l_applicant_number per_all_people_f.applicant_number%TYPE;
19211: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
19212: l_appl_override_warning boolean;
19213: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
19214: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
19215: l_apl_object_version_number per_applications.object_version_number%TYPE;
19216: --
19217:
19210: l_applicant_number per_all_people_f.applicant_number%TYPE;
19211: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
19212: l_appl_override_warning boolean;
19213: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
19214: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
19215: l_apl_object_version_number per_applications.object_version_number%TYPE;
19216: --
19217:
19218: cursor csr_get_derived_details is
19218: cursor csr_get_derived_details is
19219: select bus.business_group_id
19220: , bus.legislation_code
19221: , per.applicant_number, per.object_version_number --3652025
19222: from per_all_people_f per
19223: , per_business_groups_perf bus
19224: where per.person_id = p_person_id
19225: and l_effective_date between per.effective_start_date
19226: and per.effective_end_date
22198: --
22199: PROCEDURE set_new_primary_asg
22200: (p_validate IN BOOLEAN
22201: ,p_effective_date IN DATE
22202: ,p_person_id IN per_all_people_f.person_id%TYPE
22203: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22204: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22205: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22206: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22252: ,pds.actual_termination_date;
22253: l_new_assignment csr_new_assignment%ROWTYPE;
22254: --
22255: CURSOR csr_old_assignment
22256: (p_person_id IN per_all_people_f.person_id%TYPE
22257: ,p_effective_date IN DATE
22258: )
22259: IS
22260: SELECT asg.assignment_id
22541: --
22542: PROCEDURE set_new_primary_cwk_asg
22543: (p_validate IN BOOLEAN
22544: ,p_effective_date IN DATE
22545: ,p_person_id IN per_all_people_f.person_id%TYPE
22546: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
22547: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
22548: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
22549: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
22593: ,asg.effective_end_date
22594: ,pop.actual_termination_date;
22595: --
22596: CURSOR csr_old_assignment
22597: (p_person_id IN per_all_people_f.person_id%TYPE
22598: ,p_effective_date IN DATE) IS
22599: SELECT asg.assignment_id
22600: ,asg.assignment_type
22601: ,asg.period_of_placement_date_start