DBA Data[Home] [Help]

APPS.PQH_DE_VLDVER_API dependencies on HR_API

Line 80: when hr_api.cannot_find_prog_unit then

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: );

Line 81: hr_api.cannot_find_prog_unit_error

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;

Line 139: when hr_api.cannot_find_prog_unit then

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: );

Line 140: hr_api.cannot_find_prog_unit_error

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;

Line 149: raise hr_api.validate_enabled;

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: --

Line 160: when hr_api.validate_enabled then

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: --

Line 195: ,p_WRKPLC_VLDTN_ID In Number Default hr_api.g_Number

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

Line 196: ,P_VERSION_NUMBER In Number Default hr_api.g_Number

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

Line 197: ,P_REMUNERATION_JOB_DESCRIPTION In VarChar2 Default hr_api.g_Varchar2

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

Line 198: ,P_TARIFF_CONTRACT_CODE In Varchar2 Default hr_api.g_VArchar2

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

Line 199: ,P_TARIFF_GROUP_CODE In Varchar2 Default hr_api.g_Varchar2

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

Line 200: ,P_JOB_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

Line 201: ,P_REMUNERATION_JOB_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

Line 202: ,P_DERIVED_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

Line 203: ,P_DERIVED_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

Line 204: ,P_DERIVED_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

Line 205: ,P_USER_ENTERABLE_GRADE_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
209: ,p_WRKPLC_VLDTN_VER_ID In Number

Line 206: ,P_USER_ENTERABLE_CASE_GROUP_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
210: ,p_object_version_number in out nocopy number) Is

Line 207: ,P_USER_ENTERABLE_SUBCASGRP_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
211:

Line 208: ,P_FREEZE In Varchar2 Default hr_api.g_Varchar2

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';

Line 252: when hr_api.cannot_find_prog_unit then

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: );

Line 253: hr_api.cannot_find_prog_unit_error

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;

Line 306: when hr_api.cannot_find_prog_unit then

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: );

Line 307: hr_api.cannot_find_prog_unit_error

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;

Line 316: raise hr_api.validate_enabled;

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: --

Line 327: when hr_api.validate_enabled then

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: --

Line 377: when hr_api.cannot_find_prog_unit then

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;

Line 378: hr_api.cannot_find_prog_unit_error

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: --

Line 398: when hr_api.cannot_find_prog_unit then

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;

Line 399: hr_api.cannot_find_prog_unit_error

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: --

Line 407: raise hr_api.validate_enabled;

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: --

Line 414: when hr_api.validate_enabled then

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: --