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.HR_MX_EXTRA_ASG_RULES dependencies on HR_SOFT_CODING_KEYFLEX

Line 30: l_scl_gre hr_soft_coding_keyflex.segment1%TYPE;

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

Line 36: hr_soft_coding_keyflex HSCK

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;

Line 87: p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE

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;

Line 90: l_gre_old 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;

Line 91: l_gre_new hr_soft_coding_keyflex.segment1%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;
95: l_dummy2 BOOLEAN;

Line 93: l_scl_gre hr_soft_coding_keyflex.segment1%TYPE;

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;

Line 100: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;

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

Line 274: p_segment1 IN hr_soft_coding_keyflex.segment1%TYPE

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;

Line 277: l_gre_old 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;

Line 278: l_gre_new hr_soft_coding_keyflex.segment1%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;
282: l_dummy2 BOOLEAN;

Line 280: l_scl_gre hr_soft_coding_keyflex.segment1%TYPE;

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;

Line 287: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;

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

Line 455: l_gre_old hr_soft_coding_keyflex.segment1%TYPE;

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;

Line 457: l_scl_gre hr_soft_coding_keyflex.segment1%TYPE;

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;