50: ,P_grade_id => P_grade_id );
51:
52:
53: exception
54: when hr_api.cannot_find_prog_unit then
55: hr_api.cannot_find_prog_unit_error
56: (p_module_name => 'CREATE_RESULT_SETS'
57: ,p_hook_type => 'BP'
58: );
51:
52:
53: exception
54: when hr_api.cannot_find_prog_unit then
55: hr_api.cannot_find_prog_unit_error
56: (p_module_name => 'CREATE_RESULT_SETS'
57: ,p_hook_type => 'BP'
58: );
59: end;
86: ,p_result_set_id => p_result_set_id
87: ,p_object_version_number => l_OBJECT_VERSION_NUMBER );
88:
89: exception
90: when hr_api.cannot_find_prog_unit then
91: hr_api.cannot_find_prog_unit_error
92: (p_module_name => 'CREATE_RESULT_SETS'
93: ,p_hook_type => 'AP'
94: );
87: ,p_object_version_number => l_OBJECT_VERSION_NUMBER );
88:
89: exception
90: when hr_api.cannot_find_prog_unit then
91: hr_api.cannot_find_prog_unit_error
92: (p_module_name => 'CREATE_RESULT_SETS'
93: ,p_hook_type => 'AP'
94: );
95: end;
96: --
97: -- When in validation only mode raise the Validate_Enabled exception
98: --
99: if p_validate then
100: raise hr_api.validate_enabled;
101: end if;
102: --
103: -- Set all output arguments
104: --
107:
108: --
109: hr_utility.set_location(' Leaving:'||l_proc, 70);
110: exception
111: when hr_api.validate_enabled then
112: --
113: -- As the Validate_Enabled exception has been raised
114: -- we must rollback to the savepoint
115: --
143: (p_validate in boolean default false
144: ,p_effective_date in date
145: ,p_result_set_id in number
146: ,p_object_version_number in out nocopy number
147: ,p_gradual_value_number_from in number default hr_api.g_number
148: ,p_gradual_value_number_to in number default hr_api.g_number
149: ,p_grade_id in number default hr_api.g_number
150: ) is
151:
144: ,p_effective_date in date
145: ,p_result_set_id in number
146: ,p_object_version_number in out nocopy number
147: ,p_gradual_value_number_from in number default hr_api.g_number
148: ,p_gradual_value_number_to in number default hr_api.g_number
149: ,p_grade_id in number default hr_api.g_number
150: ) is
151:
152: l_proc varchar2(72) := g_package||'Update_RESULT_SETS';
145: ,p_result_set_id in number
146: ,p_object_version_number in out nocopy number
147: ,p_gradual_value_number_from in number default hr_api.g_number
148: ,p_gradual_value_number_to in number default hr_api.g_number
149: ,p_grade_id in number default hr_api.g_number
150: ) is
151:
152: l_proc varchar2(72) := g_package||'Update_RESULT_SETS';
153: l_object_Version_Number PQH_DE_RESULT_SETS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
177: ,p_object_version_number => p_object_version_number);
178:
179:
180: exception
181: when hr_api.cannot_find_prog_unit then
182: hr_api.cannot_find_prog_unit_error
183: (p_module_name => 'UPDATE_TATIGKEIT_DETAILS'
184: ,p_hook_type => 'BP'
185: );
178:
179:
180: exception
181: when hr_api.cannot_find_prog_unit then
182: hr_api.cannot_find_prog_unit_error
183: (p_module_name => 'UPDATE_TATIGKEIT_DETAILS'
184: ,p_hook_type => 'BP'
185: );
186: end;
208: ,P_RESULT_SET_ID => p_RESULT_SET_ID
209: ,p_object_version_number => p_object_version_number);
210:
211: exception
212: when hr_api.cannot_find_prog_unit then
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'UPDATE_RESULT_SETS'
215: ,p_hook_type => 'AP'
216: );
209: ,p_object_version_number => p_object_version_number);
210:
211: exception
212: when hr_api.cannot_find_prog_unit then
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'UPDATE_RESULT_SETS'
215: ,p_hook_type => 'AP'
216: );
217: end;
218: --
219: -- When in validation only mode raise the Validate_Enabled exception
220: --
221: if p_validate then
222: raise hr_api.validate_enabled;
223: end if;
224: --
225: -- Set all output arguments
226: --
229:
230: --
231: hr_utility.set_location(' Leaving:'||l_proc, 70);
232: exception
233: when hr_api.validate_enabled then
234: --
235: -- As the Validate_Enabled exception has been raised
236: -- we must rollback to the savepoint
237: --
281: PQH_DE_RESULT_SETS_BK3.Delete_RESULT_SETS_b
282: (p_RESULT_SET_Id => p_RESULT_SET_Id
283: ,p_object_version_number => p_object_version_number);
284: exception
285: when hr_api.cannot_find_prog_unit then
286: hr_api.cannot_find_prog_unit_error
287: (p_module_name => 'delete_RESULT_SETS'
288: ,p_hook_type => 'BP');
289: end;
282: (p_RESULT_SET_Id => p_RESULT_SET_Id
283: ,p_object_version_number => p_object_version_number);
284: exception
285: when hr_api.cannot_find_prog_unit then
286: hr_api.cannot_find_prog_unit_error
287: (p_module_name => 'delete_RESULT_SETS'
288: ,p_hook_type => 'BP');
289: end;
290: --
303: (p_RESULT_SET_Id => p_RESULT_SET_Id
304: ,p_object_version_number => p_object_version_number);
305:
306: exception
307: when hr_api.cannot_find_prog_unit then
308: hr_api.cannot_find_prog_unit_error
309: (p_module_name => 'DELETE_RESULT_SETS'
310: ,p_hook_type => 'AP');
311: end;
304: ,p_object_version_number => p_object_version_number);
305:
306: exception
307: when hr_api.cannot_find_prog_unit then
308: hr_api.cannot_find_prog_unit_error
309: (p_module_name => 'DELETE_RESULT_SETS'
310: ,p_hook_type => 'AP');
311: end;
312: --
312: --
313: -- When in validation only mode raise the Validate_Enabled exception
314: --
315: if p_validate then
316: raise hr_api.validate_enabled;
317: end if;
318: --
319: -- Set all output arguments
320: --
319: -- Set all output arguments
320: --
321: hr_utility.set_location(' Leaving:'||l_proc, 70);
322: exception
323: when hr_api.validate_enabled then
324: --
325: -- As the Validate_Enabled exception has been raised
326: -- we must rollback to the savepoint
327: --