1: PACKAGE BODY PER_POSITIONS_PKG as
2: /* $Header: pepos01t.pkb 120.0 2005/05/31 14:51:24 appldev noship $ */
3:
4: function exists_in_hierarchy(X_Pos_Structure_Version_Id NUMBER,
5: X_Position_Id NUMBER) return VARCHAR2 IS
1088: fetch csr_date_to into g_dummy_number;
1089: p_before_date_to := csr_date_to%FOUND;
1090: close csr_date_to;
1091: --
1092: hr_utility.set_location('per_positions_pkg.check_valid_grades', 1);
1093: --
1094: open csr_date_from;
1095: fetch csr_date_from into g_dummy_number;
1096: p_before_date_from := csr_date_from%FOUND;
1095: fetch csr_date_from into g_dummy_number;
1096: p_before_date_from := csr_date_from%FOUND;
1097: close csr_date_from;
1098: --
1099: hr_utility.set_location('per_positions_pkg.check_valid_grades', 2);
1100: --
1101: open csr_end_date_blank;
1102: fetch csr_end_date_blank into g_dummy_number;
1103: p_end_date_blank := csr_end_date_blank%FOUND;
1102: fetch csr_end_date_blank into g_dummy_number;
1103: p_end_date_blank := csr_end_date_blank%FOUND;
1104: close csr_end_date_blank;
1105: --
1106: hr_utility.set_location('per_positions_pkg.check_valid_grades', 3);
1107: --
1108: open csr_after_date_to;
1109: fetch csr_after_date_to into g_dummy_number;
1110: p_after_date_to := csr_after_date_to%FOUND;
1109: fetch csr_after_date_to into g_dummy_number;
1110: p_after_date_to := csr_after_date_to%FOUND;
1111: close csr_after_date_to;
1112: --
1113: hr_utility.set_location('per_positions_pkg.check_valid_grades', 4);
1114: --
1115: end check_valid_grades;
1116: --
1117: PROCEDURE maintain_valid_grades(p_position_id NUMBER,
1290: rollback;
1291: END;
1292: --
1293: --
1294: END PER_POSITIONS_PKG;