DBA Data[Home] [Help]

APPS.PER_POSITIONS_PKG dependencies on PER_POSITIONS_PKG

Line 1: PACKAGE BODY PER_POSITIONS_PKG as

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

Line 1092: hr_utility.set_location('per_positions_pkg.check_valid_grades', 1);

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;

Line 1099: hr_utility.set_location('per_positions_pkg.check_valid_grades', 2);

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;

Line 1106: hr_utility.set_location('per_positions_pkg.check_valid_grades', 3);

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;

Line 1113: hr_utility.set_location('per_positions_pkg.check_valid_grades', 4);

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,

Line 1294: END PER_POSITIONS_PKG;

1290: rollback;
1291: END;
1292: --
1293: --
1294: END PER_POSITIONS_PKG;