DBA Data[Home] [Help]

APPS.PQH_DE_VLDDEF_API dependencies on HR_API

Line 52: when hr_api.cannot_find_prog_unit then

48: ,p_EMPLOYMENT_TYPE => p_EMPLOYMENT_TYPE
49: ,p_REMUNERATION_REGULATION => p_REMUNERATION_REGULATION);
50:
51: exception
52: when hr_api.cannot_find_prog_unit then
53: hr_api.cannot_find_prog_unit_error
54: (p_module_name => 'Insert_Vldtn_Defn'
55: ,p_hook_type => 'BP'
56: );

Line 53: hr_api.cannot_find_prog_unit_error

49: ,p_REMUNERATION_REGULATION => p_REMUNERATION_REGULATION);
50:
51: exception
52: when hr_api.cannot_find_prog_unit then
53: hr_api.cannot_find_prog_unit_error
54: (p_module_name => 'Insert_Vldtn_Defn'
55: ,p_hook_type => 'BP'
56: );
57: end;

Line 85: when hr_api.cannot_find_prog_unit then

81: ,p_WRKPLC_VLDTN_ID => l_WRKPLC_VLDTN_ID
82: ,p_object_version_number => l_object_version_Number);
83:
84: exception
85: when hr_api.cannot_find_prog_unit then
86: hr_api.cannot_find_prog_unit_error
87: (p_module_name => 'Insert_Vldtn_Defn'
88: ,p_hook_type => 'AP'
89: );

Line 86: hr_api.cannot_find_prog_unit_error

82: ,p_object_version_number => l_object_version_Number);
83:
84: exception
85: when hr_api.cannot_find_prog_unit then
86: hr_api.cannot_find_prog_unit_error
87: (p_module_name => 'Insert_Vldtn_Defn'
88: ,p_hook_type => 'AP'
89: );
90: end;

Line 95: raise hr_api.validate_enabled;

91: --
92: -- When in validation only mode raise the Validate_Enabled exception
93: --
94: if p_validate then
95: raise hr_api.validate_enabled;
96: end if;
97: --
98: -- Set all output arguments
99: --

Line 106: when hr_api.validate_enabled then

102:
103: --
104: hr_utility.set_location(' Leaving:'||l_proc, 70);
105: exception
106: when hr_api.validate_enabled then
107: --
108: -- As the Validate_Enabled exception has been raised
109: -- we must rollback to the savepoint
110: --

Line 140: ,p_business_group_id in number Default hr_api.g_Number

136:
137: procedure Update_Vldtn_Defn
138: (p_validate in boolean default false
139: ,p_effective_date in date
140: ,p_business_group_id in number Default hr_api.g_Number
141: ,p_VALIDATION_NAME In Varchar2 Default hr_api.g_Varchar2
142: ,p_EMPLOYMENT_TYPE In Varchar2 Default hr_api.g_Varchar2
143: ,p_REMUNERATION_REGULATION In Varchar2 Default hr_api.g_Varchar2
144: ,p_WRKPLC_VLDTN_ID In number

Line 141: ,p_VALIDATION_NAME In Varchar2 Default hr_api.g_Varchar2

137: procedure Update_Vldtn_Defn
138: (p_validate in boolean default false
139: ,p_effective_date in date
140: ,p_business_group_id in number Default hr_api.g_Number
141: ,p_VALIDATION_NAME In Varchar2 Default hr_api.g_Varchar2
142: ,p_EMPLOYMENT_TYPE In Varchar2 Default hr_api.g_Varchar2
143: ,p_REMUNERATION_REGULATION In Varchar2 Default hr_api.g_Varchar2
144: ,p_WRKPLC_VLDTN_ID In number
145: ,p_object_version_number In out nocopy number) Is

Line 142: ,p_EMPLOYMENT_TYPE In Varchar2 Default hr_api.g_Varchar2

138: (p_validate in boolean default false
139: ,p_effective_date in date
140: ,p_business_group_id in number Default hr_api.g_Number
141: ,p_VALIDATION_NAME In Varchar2 Default hr_api.g_Varchar2
142: ,p_EMPLOYMENT_TYPE In Varchar2 Default hr_api.g_Varchar2
143: ,p_REMUNERATION_REGULATION In Varchar2 Default hr_api.g_Varchar2
144: ,p_WRKPLC_VLDTN_ID In number
145: ,p_object_version_number In out nocopy number) Is
146:

Line 143: ,p_REMUNERATION_REGULATION In Varchar2 Default hr_api.g_Varchar2

139: ,p_effective_date in date
140: ,p_business_group_id in number Default hr_api.g_Number
141: ,p_VALIDATION_NAME In Varchar2 Default hr_api.g_Varchar2
142: ,p_EMPLOYMENT_TYPE In Varchar2 Default hr_api.g_Varchar2
143: ,p_REMUNERATION_REGULATION In Varchar2 Default hr_api.g_Varchar2
144: ,p_WRKPLC_VLDTN_ID In number
145: ,p_object_version_number In out nocopy number) Is
146:
147: l_proc varchar2(72) := g_package||'Update_Vldtn_Defn';

Line 175: when hr_api.cannot_find_prog_unit then

171: ,p_REMUNERATION_REGULATION => p_remuneration_Regulation
172: ,p_WRKPLC_VLDTN_ID => p_Wrkplc_vldtn_id
173: ,p_object_version_number => l_Object_Version_number);
174: exception
175: when hr_api.cannot_find_prog_unit then
176: hr_api.cannot_find_prog_unit_error
177: (p_module_name => 'Update_Vldtn_Defn'
178: ,p_hook_type => 'BP'
179: );

Line 176: hr_api.cannot_find_prog_unit_error

172: ,p_WRKPLC_VLDTN_ID => p_Wrkplc_vldtn_id
173: ,p_object_version_number => l_Object_Version_number);
174: exception
175: when hr_api.cannot_find_prog_unit then
176: hr_api.cannot_find_prog_unit_error
177: (p_module_name => 'Update_Vldtn_Defn'
178: ,p_hook_type => 'BP'
179: );
180: end;

Line 207: when hr_api.cannot_find_prog_unit then

203: ,p_object_version_number => l_Object_Version_Number);
204:
205:
206: exception
207: when hr_api.cannot_find_prog_unit then
208: hr_api.cannot_find_prog_unit_error
209: (p_module_name => 'Update_Vldtn_Defn'
210: ,p_hook_type => 'AP'
211: );

Line 208: hr_api.cannot_find_prog_unit_error

204:
205:
206: exception
207: when hr_api.cannot_find_prog_unit then
208: hr_api.cannot_find_prog_unit_error
209: (p_module_name => 'Update_Vldtn_Defn'
210: ,p_hook_type => 'AP'
211: );
212: end;

Line 217: raise hr_api.validate_enabled;

213: --
214: -- When in validation only mode raise the Validate_Enabled exception
215: --
216: if p_validate then
217: raise hr_api.validate_enabled;
218: end if;
219: --
220: -- Set all output arguments
221: --

Line 228: when hr_api.validate_enabled then

224:
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 70);
227: exception
228: when hr_api.validate_enabled then
229: --
230: -- As the Validate_Enabled exception has been raised
231: -- we must rollback to the savepoint
232: --

Line 278: when hr_api.cannot_find_prog_unit then

274: PQH_DE_VLDDEF_BK3.Delete_Vldtn_Defn_b
275: (p_WRKPLC_VLDTN_ID => p_WRKPLC_VLDTN_ID
276: ,p_object_version_number => p_object_version_number);
277: exception
278: when hr_api.cannot_find_prog_unit then
279: hr_api.cannot_find_prog_unit_error
280: (p_module_name => 'delete_Vldtn_Defn'
281: ,p_hook_type => 'BP');
282: end;

Line 279: hr_api.cannot_find_prog_unit_error

275: (p_WRKPLC_VLDTN_ID => p_WRKPLC_VLDTN_ID
276: ,p_object_version_number => p_object_version_number);
277: exception
278: when hr_api.cannot_find_prog_unit then
279: hr_api.cannot_find_prog_unit_error
280: (p_module_name => 'delete_Vldtn_Defn'
281: ,p_hook_type => 'BP');
282: end;
283: --

Line 299: when hr_api.cannot_find_prog_unit then

295: (p_WRKPLC_VLDTN_ID => p_WRKPLC_VLDTN_ID
296: ,p_object_version_number => p_object_version_number);
297:
298: exception
299: when hr_api.cannot_find_prog_unit then
300: hr_api.cannot_find_prog_unit_error
301: (p_module_name => 'delete_Vldtn_Defn'
302: ,p_hook_type => 'AP');
303: end;

Line 300: hr_api.cannot_find_prog_unit_error

296: ,p_object_version_number => p_object_version_number);
297:
298: exception
299: when hr_api.cannot_find_prog_unit then
300: hr_api.cannot_find_prog_unit_error
301: (p_module_name => 'delete_Vldtn_Defn'
302: ,p_hook_type => 'AP');
303: end;
304: --

Line 308: raise hr_api.validate_enabled;

304: --
305: -- When in validation only mode raise the Validate_Enabled exception
306: --
307: if p_validate then
308: raise hr_api.validate_enabled;
309: end if;
310: --
311: -- Set all output arguments
312: --

Line 315: when hr_api.validate_enabled then

311: -- Set all output arguments
312: --
313: hr_utility.set_location(' Leaving:'||l_proc, 70);
314: exception
315: when hr_api.validate_enabled then
316: --
317: -- As the Validate_Enabled exception has been raised
318: -- we must rollback to the savepoint
319: --