76: ,p_FREEZE => p_FREEZE);
77:
78:
79: exception
80: when hr_api.cannot_find_prog_unit then
81: hr_api.cannot_find_prog_unit_error
82: (p_module_name => 'Insert_Vldtn_Vern'
83: ,p_hook_type => 'BP'
84: );
77:
78:
79: exception
80: when hr_api.cannot_find_prog_unit then
81: hr_api.cannot_find_prog_unit_error
82: (p_module_name => 'Insert_Vldtn_Vern'
83: ,p_hook_type => 'BP'
84: );
85: end;
135: ,p_Wrkplc_Vldtn_Ver_Id => l_Wrkplc_Vldtn_Ver_Id
136: ,p_object_version_number => l_object_version_Number);
137:
138: exception
139: when hr_api.cannot_find_prog_unit then
140: hr_api.cannot_find_prog_unit_error
141: (p_module_name => 'Insert_Vldtn_Vern'
142: ,p_hook_type => 'AP'
143: );
136: ,p_object_version_number => l_object_version_Number);
137:
138: exception
139: when hr_api.cannot_find_prog_unit then
140: hr_api.cannot_find_prog_unit_error
141: (p_module_name => 'Insert_Vldtn_Vern'
142: ,p_hook_type => 'AP'
143: );
144: end;
145: --
146: -- When in validation only mode raise the Validate_Enabled exception
147: --
148: if p_validate then
149: raise hr_api.validate_enabled;
150: end if;
151: --
152: -- Set all output arguments
153: --
156:
157: --
158: hr_utility.set_location(' Leaving:'||l_proc, 70);
159: exception
160: when hr_api.validate_enabled then
161: --
162: -- As the Validate_Enabled exception has been raised
163: -- we must rollback to the savepoint
164: --
191: procedure Update_Vldtn_Vern
192: (p_validate in boolean default false
193: ,p_effective_date in date
194: ,p_business_group_id in number
195: ,p_WRKPLC_VLDTN_ID In Number Default hr_api.g_Number
196: ,P_VERSION_NUMBER In Number Default hr_api.g_Number
197: ,P_REMUNERATION_JOB_DESCRIPTION In VarChar2 Default hr_api.g_Varchar2
198: ,P_TARIFF_CONTRACT_CODE In Varchar2 Default hr_api.g_VArchar2
199: ,P_TARIFF_GROUP_CODE In Varchar2 Default hr_api.g_Varchar2
192: (p_validate in boolean default false
193: ,p_effective_date in date
194: ,p_business_group_id in number
195: ,p_WRKPLC_VLDTN_ID In Number Default hr_api.g_Number
196: ,P_VERSION_NUMBER In Number Default hr_api.g_Number
197: ,P_REMUNERATION_JOB_DESCRIPTION In VarChar2 Default hr_api.g_Varchar2
198: ,P_TARIFF_CONTRACT_CODE In Varchar2 Default hr_api.g_VArchar2
199: ,P_TARIFF_GROUP_CODE In Varchar2 Default hr_api.g_Varchar2
200: ,P_JOB_GROUP_ID In Number Default hr_api.g_Number
193: ,p_effective_date in date
194: ,p_business_group_id in number
195: ,p_WRKPLC_VLDTN_ID In Number Default hr_api.g_Number
196: ,P_VERSION_NUMBER In Number Default hr_api.g_Number
197: ,P_REMUNERATION_JOB_DESCRIPTION In VarChar2 Default hr_api.g_Varchar2
198: ,P_TARIFF_CONTRACT_CODE In Varchar2 Default hr_api.g_VArchar2
199: ,P_TARIFF_GROUP_CODE In Varchar2 Default hr_api.g_Varchar2
200: ,P_JOB_GROUP_ID In Number Default hr_api.g_Number
201: ,P_REMUNERATION_JOB_ID In Number Default hr_api.g_Number
194: ,p_business_group_id in number
195: ,p_WRKPLC_VLDTN_ID In Number Default hr_api.g_Number
196: ,P_VERSION_NUMBER In Number Default hr_api.g_Number
197: ,P_REMUNERATION_JOB_DESCRIPTION In VarChar2 Default hr_api.g_Varchar2
198: ,P_TARIFF_CONTRACT_CODE In Varchar2 Default hr_api.g_VArchar2
199: ,P_TARIFF_GROUP_CODE In Varchar2 Default hr_api.g_Varchar2
200: ,P_JOB_GROUP_ID In Number Default hr_api.g_Number
201: ,P_REMUNERATION_JOB_ID In Number Default hr_api.g_Number
202: ,P_DERIVED_GRADE_ID In Number Default hr_api.g_Number
195: ,p_WRKPLC_VLDTN_ID In Number Default hr_api.g_Number
196: ,P_VERSION_NUMBER In Number Default hr_api.g_Number
197: ,P_REMUNERATION_JOB_DESCRIPTION In VarChar2 Default hr_api.g_Varchar2
198: ,P_TARIFF_CONTRACT_CODE In Varchar2 Default hr_api.g_VArchar2
199: ,P_TARIFF_GROUP_CODE In Varchar2 Default hr_api.g_Varchar2
200: ,P_JOB_GROUP_ID In Number Default hr_api.g_Number
201: ,P_REMUNERATION_JOB_ID In Number Default hr_api.g_Number
202: ,P_DERIVED_GRADE_ID In Number Default hr_api.g_Number
203: ,P_DERIVED_CASE_GROUP_ID In Number Default hr_api.g_Number
196: ,P_VERSION_NUMBER In Number Default hr_api.g_Number
197: ,P_REMUNERATION_JOB_DESCRIPTION In VarChar2 Default hr_api.g_Varchar2
198: ,P_TARIFF_CONTRACT_CODE In Varchar2 Default hr_api.g_VArchar2
199: ,P_TARIFF_GROUP_CODE In Varchar2 Default hr_api.g_Varchar2
200: ,P_JOB_GROUP_ID In Number Default hr_api.g_Number
201: ,P_REMUNERATION_JOB_ID In Number Default hr_api.g_Number
202: ,P_DERIVED_GRADE_ID In Number Default hr_api.g_Number
203: ,P_DERIVED_CASE_GROUP_ID In Number Default hr_api.g_Number
204: ,P_DERIVED_SUBCASGRP_ID In Number Default hr_api.g_Number
197: ,P_REMUNERATION_JOB_DESCRIPTION In VarChar2 Default hr_api.g_Varchar2
198: ,P_TARIFF_CONTRACT_CODE In Varchar2 Default hr_api.g_VArchar2
199: ,P_TARIFF_GROUP_CODE In Varchar2 Default hr_api.g_Varchar2
200: ,P_JOB_GROUP_ID In Number Default hr_api.g_Number
201: ,P_REMUNERATION_JOB_ID In Number Default hr_api.g_Number
202: ,P_DERIVED_GRADE_ID In Number Default hr_api.g_Number
203: ,P_DERIVED_CASE_GROUP_ID In Number Default hr_api.g_Number
204: ,P_DERIVED_SUBCASGRP_ID In Number Default hr_api.g_Number
205: ,P_USER_ENTERABLE_GRADE_ID In Number Default hr_api.g_Number
198: ,P_TARIFF_CONTRACT_CODE In Varchar2 Default hr_api.g_VArchar2
199: ,P_TARIFF_GROUP_CODE In Varchar2 Default hr_api.g_Varchar2
200: ,P_JOB_GROUP_ID In Number Default hr_api.g_Number
201: ,P_REMUNERATION_JOB_ID In Number Default hr_api.g_Number
202: ,P_DERIVED_GRADE_ID In Number Default hr_api.g_Number
203: ,P_DERIVED_CASE_GROUP_ID In Number Default hr_api.g_Number
204: ,P_DERIVED_SUBCASGRP_ID In Number Default hr_api.g_Number
205: ,P_USER_ENTERABLE_GRADE_ID In Number Default hr_api.g_Number
206: ,P_USER_ENTERABLE_CASE_GROUP_ID In Number Default hr_api.g_Number
199: ,P_TARIFF_GROUP_CODE In Varchar2 Default hr_api.g_Varchar2
200: ,P_JOB_GROUP_ID In Number Default hr_api.g_Number
201: ,P_REMUNERATION_JOB_ID In Number Default hr_api.g_Number
202: ,P_DERIVED_GRADE_ID In Number Default hr_api.g_Number
203: ,P_DERIVED_CASE_GROUP_ID In Number Default hr_api.g_Number
204: ,P_DERIVED_SUBCASGRP_ID In Number Default hr_api.g_Number
205: ,P_USER_ENTERABLE_GRADE_ID In Number Default hr_api.g_Number
206: ,P_USER_ENTERABLE_CASE_GROUP_ID In Number Default hr_api.g_Number
207: ,P_USER_ENTERABLE_SUBCASGRP_ID In Number Default hr_api.g_Number
200: ,P_JOB_GROUP_ID In Number Default hr_api.g_Number
201: ,P_REMUNERATION_JOB_ID In Number Default hr_api.g_Number
202: ,P_DERIVED_GRADE_ID In Number Default hr_api.g_Number
203: ,P_DERIVED_CASE_GROUP_ID In Number Default hr_api.g_Number
204: ,P_DERIVED_SUBCASGRP_ID In Number Default hr_api.g_Number
205: ,P_USER_ENTERABLE_GRADE_ID In Number Default hr_api.g_Number
206: ,P_USER_ENTERABLE_CASE_GROUP_ID In Number Default hr_api.g_Number
207: ,P_USER_ENTERABLE_SUBCASGRP_ID In Number Default hr_api.g_Number
208: ,P_FREEZE In Varchar2 Default hr_api.g_Varchar2
201: ,P_REMUNERATION_JOB_ID In Number Default hr_api.g_Number
202: ,P_DERIVED_GRADE_ID In Number Default hr_api.g_Number
203: ,P_DERIVED_CASE_GROUP_ID In Number Default hr_api.g_Number
204: ,P_DERIVED_SUBCASGRP_ID In Number Default hr_api.g_Number
205: ,P_USER_ENTERABLE_GRADE_ID In Number Default hr_api.g_Number
206: ,P_USER_ENTERABLE_CASE_GROUP_ID In Number Default hr_api.g_Number
207: ,P_USER_ENTERABLE_SUBCASGRP_ID In Number Default hr_api.g_Number
208: ,P_FREEZE In Varchar2 Default hr_api.g_Varchar2
209: ,p_WRKPLC_VLDTN_VER_ID In Number
202: ,P_DERIVED_GRADE_ID In Number Default hr_api.g_Number
203: ,P_DERIVED_CASE_GROUP_ID In Number Default hr_api.g_Number
204: ,P_DERIVED_SUBCASGRP_ID In Number Default hr_api.g_Number
205: ,P_USER_ENTERABLE_GRADE_ID In Number Default hr_api.g_Number
206: ,P_USER_ENTERABLE_CASE_GROUP_ID In Number Default hr_api.g_Number
207: ,P_USER_ENTERABLE_SUBCASGRP_ID In Number Default hr_api.g_Number
208: ,P_FREEZE In Varchar2 Default hr_api.g_Varchar2
209: ,p_WRKPLC_VLDTN_VER_ID In Number
210: ,p_object_version_number in out nocopy number) Is
203: ,P_DERIVED_CASE_GROUP_ID In Number Default hr_api.g_Number
204: ,P_DERIVED_SUBCASGRP_ID In Number Default hr_api.g_Number
205: ,P_USER_ENTERABLE_GRADE_ID In Number Default hr_api.g_Number
206: ,P_USER_ENTERABLE_CASE_GROUP_ID In Number Default hr_api.g_Number
207: ,P_USER_ENTERABLE_SUBCASGRP_ID In Number Default hr_api.g_Number
208: ,P_FREEZE In Varchar2 Default hr_api.g_Varchar2
209: ,p_WRKPLC_VLDTN_VER_ID In Number
210: ,p_object_version_number in out nocopy number) Is
211:
204: ,P_DERIVED_SUBCASGRP_ID In Number Default hr_api.g_Number
205: ,P_USER_ENTERABLE_GRADE_ID In Number Default hr_api.g_Number
206: ,P_USER_ENTERABLE_CASE_GROUP_ID In Number Default hr_api.g_Number
207: ,P_USER_ENTERABLE_SUBCASGRP_ID In Number Default hr_api.g_Number
208: ,P_FREEZE In Varchar2 Default hr_api.g_Varchar2
209: ,p_WRKPLC_VLDTN_VER_ID In Number
210: ,p_object_version_number in out nocopy number) Is
211:
212: l_proc varchar2(72) := g_package||'Update_Vldtn_Vern';
248: ,p_WRKPLC_VLDTN_VER_ID => p_Wrkplc_Vldtn_ver_Id
249: ,p_object_version_number => l_Object_Version_Number);
250:
251: exception
252: when hr_api.cannot_find_prog_unit then
253: hr_api.cannot_find_prog_unit_error
254: (p_module_name => 'Update_Vldtn_Vern'
255: ,p_hook_type => 'BP'
256: );
249: ,p_object_version_number => l_Object_Version_Number);
250:
251: exception
252: when hr_api.cannot_find_prog_unit then
253: hr_api.cannot_find_prog_unit_error
254: (p_module_name => 'Update_Vldtn_Vern'
255: ,p_hook_type => 'BP'
256: );
257: end;
302: ,p_object_version_number => l_Object_Version_Number);
303:
304:
305: exception
306: when hr_api.cannot_find_prog_unit then
307: hr_api.cannot_find_prog_unit_error
308: (p_module_name => 'Update_Vldtn_Vern'
309: ,p_hook_type => 'AP'
310: );
303:
304:
305: exception
306: when hr_api.cannot_find_prog_unit then
307: hr_api.cannot_find_prog_unit_error
308: (p_module_name => 'Update_Vldtn_Vern'
309: ,p_hook_type => 'AP'
310: );
311: end;
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: --
323:
324: --
325: hr_utility.set_location(' Leaving:'||l_proc, 70);
326: exception
327: when hr_api.validate_enabled then
328: --
329: -- As the Validate_Enabled exception has been raised
330: -- we must rollback to the savepoint
331: --
373: PQH_DE_VLDVER_BK3.Delete_Vldtn_Vern_b
374: (p_WRKPLC_VLDTN_VERID => p_WRKPLC_VLDTN_VER_ID
375: ,p_object_version_number => p_object_version_number);
376: exception
377: when hr_api.cannot_find_prog_unit then
378: hr_api.cannot_find_prog_unit_error
379: (p_module_name => 'delete_Vldtn_Vern'
380: ,p_hook_type => 'BP');
381: end;
374: (p_WRKPLC_VLDTN_VERID => p_WRKPLC_VLDTN_VER_ID
375: ,p_object_version_number => p_object_version_number);
376: exception
377: when hr_api.cannot_find_prog_unit then
378: hr_api.cannot_find_prog_unit_error
379: (p_module_name => 'delete_Vldtn_Vern'
380: ,p_hook_type => 'BP');
381: end;
382: --
394: (p_WRKPLC_VLDTN_VER_ID => p_WRKPLC_VLDTN_VER_ID
395: ,p_object_version_number => p_object_version_number);
396:
397: exception
398: when hr_api.cannot_find_prog_unit then
399: hr_api.cannot_find_prog_unit_error
400: (p_module_name => 'delete_Vldtn_Vern'
401: ,p_hook_type => 'AP');
402: end;
395: ,p_object_version_number => p_object_version_number);
396:
397: exception
398: when hr_api.cannot_find_prog_unit then
399: hr_api.cannot_find_prog_unit_error
400: (p_module_name => 'delete_Vldtn_Vern'
401: ,p_hook_type => 'AP');
402: end;
403: --
403: --
404: -- When in validation only mode raise the Validate_Enabled exception
405: --
406: if p_validate then
407: raise hr_api.validate_enabled;
408: end if;
409: --
410: -- Set all output arguments
411: --
410: -- Set all output arguments
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 70);
413: exception
414: when hr_api.validate_enabled then
415: --
416: -- As the Validate_Enabled exception has been raised
417: -- we must rollback to the savepoint
418: --