26: ) AS
27: --
28: l_proc VARCHAR2(100);
29: l_location_id hr_locations.location_id%TYPE;
30: l_scl_gre hr_soft_coding_keyflex.segment1%TYPE;
31:
32: CURSOR csr_get_gre_location IS
33: SELECT paf.location_id,
34: hsck.segment1
32: CURSOR csr_get_gre_location IS
33: SELECT paf.location_id,
34: hsck.segment1
35: FROM per_assignments_f PAF,
36: hr_soft_coding_keyflex HSCK
37: WHERE paf.assignment_id = p_assignment_id
38: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
39: AND trunc(p_effective_date) BETWEEN paf.effective_start_date
40: AND paf.effective_end_date;
83: PROCEDURE chk_loc_gre_for_leav_reason(p_effective_date IN DATE,
84: p_datetrack_update_mode IN VARCHAR2,
85: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
86: p_location_id IN hr_locations.location_id%TYPE,
87: p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
88: ) AS
89: --
90: l_gre_old hr_soft_coding_keyflex.segment1%TYPE;
91: l_gre_new hr_soft_coding_keyflex.segment1%TYPE;
86: p_location_id IN hr_locations.location_id%TYPE,
87: p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
88: ) AS
89: --
90: l_gre_old hr_soft_coding_keyflex.segment1%TYPE;
91: l_gre_new hr_soft_coding_keyflex.segment1%TYPE;
92: l_location_old hr_locations.location_id%TYPE;
93: l_scl_gre hr_soft_coding_keyflex.segment1%TYPE;
94: l_dummy1 BOOLEAN;
87: p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
88: ) AS
89: --
90: l_gre_old hr_soft_coding_keyflex.segment1%TYPE;
91: l_gre_new hr_soft_coding_keyflex.segment1%TYPE;
92: l_location_old hr_locations.location_id%TYPE;
93: l_scl_gre hr_soft_coding_keyflex.segment1%TYPE;
94: l_dummy1 BOOLEAN;
95: l_dummy2 BOOLEAN;
89: --
90: l_gre_old hr_soft_coding_keyflex.segment1%TYPE;
91: l_gre_new hr_soft_coding_keyflex.segment1%TYPE;
92: l_location_old hr_locations.location_id%TYPE;
93: l_scl_gre hr_soft_coding_keyflex.segment1%TYPE;
94: l_dummy1 BOOLEAN;
95: l_dummy2 BOOLEAN;
96: l_dummy3 per_assignment_extra_info.assignment_extra_info_id%TYPE;
97: l_dummy4 NUMBER;
96: l_dummy3 per_assignment_extra_info.assignment_extra_info_id%TYPE;
97: l_dummy4 NUMBER;
98: l_bg_id per_assignments_f.business_group_id%TYPE;
99: l_proc VARCHAR2(100);
100: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;
101: l_location_id hr_locations.location_id%TYPE;
102:
103:
104: CURSOR csr_fetch_bg IS
270: --------------------------------------------------------------------------
271: PROCEDURE chk_gre_for_leav_reason(p_effective_date IN DATE,
272: p_datetrack_update_mode IN VARCHAR2,
273: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
274: p_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
275: ) AS
276: --
277: l_gre_old hr_soft_coding_keyflex.segment1%TYPE;
278: l_gre_new hr_soft_coding_keyflex.segment1%TYPE;
273: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
274: p_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
275: ) AS
276: --
277: l_gre_old hr_soft_coding_keyflex.segment1%TYPE;
278: l_gre_new hr_soft_coding_keyflex.segment1%TYPE;
279: l_location_old hr_locations.location_id%TYPE;
280: l_scl_gre hr_soft_coding_keyflex.segment1%TYPE;
281: l_dummy1 BOOLEAN;
274: p_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
275: ) AS
276: --
277: l_gre_old hr_soft_coding_keyflex.segment1%TYPE;
278: l_gre_new hr_soft_coding_keyflex.segment1%TYPE;
279: l_location_old hr_locations.location_id%TYPE;
280: l_scl_gre hr_soft_coding_keyflex.segment1%TYPE;
281: l_dummy1 BOOLEAN;
282: l_dummy2 BOOLEAN;
276: --
277: l_gre_old hr_soft_coding_keyflex.segment1%TYPE;
278: l_gre_new hr_soft_coding_keyflex.segment1%TYPE;
279: l_location_old hr_locations.location_id%TYPE;
280: l_scl_gre hr_soft_coding_keyflex.segment1%TYPE;
281: l_dummy1 BOOLEAN;
282: l_dummy2 BOOLEAN;
283: l_dummy3 per_assignment_extra_info.assignment_extra_info_id%TYPE;
284: l_dummy4 NUMBER;
283: l_dummy3 per_assignment_extra_info.assignment_extra_info_id%TYPE;
284: l_dummy4 NUMBER;
285: l_bg_id per_assignments_f.business_group_id%TYPE;
286: l_proc VARCHAR2(100);
287: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;
288:
289: CURSOR csr_fetch_bg IS
290: SELECT business_group_id
291: FROM per_assignments_f
451: p_assignment_id IN per_assignments_f.assignment_id%TYPE
452: )
453: AS
454: --
455: l_gre_old hr_soft_coding_keyflex.segment1%TYPE;
456: l_location_old hr_locations.location_id%TYPE;
457: l_scl_gre hr_soft_coding_keyflex.segment1%TYPE;
458: l_dummy1 BOOLEAN;
459: l_dummy2 BOOLEAN;
453: AS
454: --
455: l_gre_old hr_soft_coding_keyflex.segment1%TYPE;
456: l_location_old hr_locations.location_id%TYPE;
457: l_scl_gre hr_soft_coding_keyflex.segment1%TYPE;
458: l_dummy1 BOOLEAN;
459: l_dummy2 BOOLEAN;
460: l_dummy3 per_assignment_extra_info.assignment_extra_info_id%TYPE;
461: l_dummy4 NUMBER;