DBA Data[Home] [Help]

APPS.PQH_DE_CASE_GROUPS_API dependencies on HR_API

Line 74: when hr_api.cannot_find_prog_unit then

70: ,p_sub_csgrp_description => p_sub_csgrp_description
71: );
72:
73: exception
74: when hr_api.cannot_find_prog_unit then
75: hr_api.cannot_find_prog_unit_error
76: (p_module_name => 'CREATE_CASE_GROUPS'
77: ,p_hook_type => 'BP'
78: );

Line 75: hr_api.cannot_find_prog_unit_error

71: );
72:
73: exception
74: when hr_api.cannot_find_prog_unit then
75: hr_api.cannot_find_prog_unit_error
76: (p_module_name => 'CREATE_CASE_GROUPS'
77: ,p_hook_type => 'BP'
78: );
79: end;

Line 134: when hr_api.cannot_find_prog_unit then

130: );
131:
132:
133: exception
134: when hr_api.cannot_find_prog_unit then
135: hr_api.cannot_find_prog_unit_error
136: (p_module_name => 'CREATE_CASE_GROUPS'
137: ,p_hook_type => 'AP'
138: );

Line 135: hr_api.cannot_find_prog_unit_error

131:
132:
133: exception
134: when hr_api.cannot_find_prog_unit then
135: hr_api.cannot_find_prog_unit_error
136: (p_module_name => 'CREATE_CASE_GROUPS'
137: ,p_hook_type => 'AP'
138: );
139: end;

Line 144: raise hr_api.validate_enabled;

140: --
141: -- When in validation only mode raise the Validate_Enabled exception
142: --
143: if p_validate then
144: raise hr_api.validate_enabled;
145: end if;
146: --
147: -- Set all output arguments
148: --

Line 155: when hr_api.validate_enabled then

151:
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 70);
154: exception
155: when hr_api.validate_enabled then
156: --
157: -- As the Validate_Enabled exception has been raised
158: -- we must rollback to the savepoint
159: --

Line 190: ,p_case_group_number in varchar2 default hr_api.g_varchar2

186: (p_validate in boolean default false
187: ,p_effective_date in date
188: ,p_case_group_id in number
189: ,p_object_version_number in out nocopy number
190: ,p_case_group_number in varchar2 default hr_api.g_varchar2
191: ,p_description in varchar2 default hr_api.g_varchar2
192: ,p_advanced_pay_grade in number default hr_api.g_number
193: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
194: ,p_period_of_prob_advmnt in number default hr_api.g_number

Line 191: ,p_description in varchar2 default hr_api.g_varchar2

187: ,p_effective_date in date
188: ,p_case_group_id in number
189: ,p_object_version_number in out nocopy number
190: ,p_case_group_number in varchar2 default hr_api.g_varchar2
191: ,p_description in varchar2 default hr_api.g_varchar2
192: ,p_advanced_pay_grade in number default hr_api.g_number
193: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
194: ,p_period_of_prob_advmnt in number default hr_api.g_number
195: ,p_period_of_time_advmnt in number default hr_api.g_number

Line 192: ,p_advanced_pay_grade in number default hr_api.g_number

188: ,p_case_group_id in number
189: ,p_object_version_number in out nocopy number
190: ,p_case_group_number in varchar2 default hr_api.g_varchar2
191: ,p_description in varchar2 default hr_api.g_varchar2
192: ,p_advanced_pay_grade in number default hr_api.g_number
193: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
194: ,p_period_of_prob_advmnt in number default hr_api.g_number
195: ,p_period_of_time_advmnt in number default hr_api.g_number
196: ,p_advancement_to in number default hr_api.g_number

Line 193: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2

189: ,p_object_version_number in out nocopy number
190: ,p_case_group_number in varchar2 default hr_api.g_varchar2
191: ,p_description in varchar2 default hr_api.g_varchar2
192: ,p_advanced_pay_grade in number default hr_api.g_number
193: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
194: ,p_period_of_prob_advmnt in number default hr_api.g_number
195: ,p_period_of_time_advmnt in number default hr_api.g_number
196: ,p_advancement_to in number default hr_api.g_number
197: ,p_advancement_additional_pyt in number default hr_api.g_number

Line 194: ,p_period_of_prob_advmnt in number default hr_api.g_number

190: ,p_case_group_number in varchar2 default hr_api.g_varchar2
191: ,p_description in varchar2 default hr_api.g_varchar2
192: ,p_advanced_pay_grade in number default hr_api.g_number
193: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
194: ,p_period_of_prob_advmnt in number default hr_api.g_number
195: ,p_period_of_time_advmnt in number default hr_api.g_number
196: ,p_advancement_to in number default hr_api.g_number
197: ,p_advancement_additional_pyt in number default hr_api.g_number
198: ,p_time_advanced_pay_grade in number default hr_api.g_number

Line 195: ,p_period_of_time_advmnt in number default hr_api.g_number

191: ,p_description in varchar2 default hr_api.g_varchar2
192: ,p_advanced_pay_grade in number default hr_api.g_number
193: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
194: ,p_period_of_prob_advmnt in number default hr_api.g_number
195: ,p_period_of_time_advmnt in number default hr_api.g_number
196: ,p_advancement_to in number default hr_api.g_number
197: ,p_advancement_additional_pyt in number default hr_api.g_number
198: ,p_time_advanced_pay_grade in number default hr_api.g_number
199: ,p_time_advancement_to in number default hr_api.g_number

Line 196: ,p_advancement_to in number default hr_api.g_number

192: ,p_advanced_pay_grade in number default hr_api.g_number
193: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
194: ,p_period_of_prob_advmnt in number default hr_api.g_number
195: ,p_period_of_time_advmnt in number default hr_api.g_number
196: ,p_advancement_to in number default hr_api.g_number
197: ,p_advancement_additional_pyt in number default hr_api.g_number
198: ,p_time_advanced_pay_grade in number default hr_api.g_number
199: ,p_time_advancement_to in number default hr_api.g_number
200: ,p_business_group_id in number default hr_api.g_number

Line 197: ,p_advancement_additional_pyt in number default hr_api.g_number

193: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
194: ,p_period_of_prob_advmnt in number default hr_api.g_number
195: ,p_period_of_time_advmnt in number default hr_api.g_number
196: ,p_advancement_to in number default hr_api.g_number
197: ,p_advancement_additional_pyt in number default hr_api.g_number
198: ,p_time_advanced_pay_grade in number default hr_api.g_number
199: ,p_time_advancement_to in number default hr_api.g_number
200: ,p_business_group_id in number default hr_api.g_number
201: ,p_time_advn_units in varchar2 default hr_api.g_varchar2

Line 198: ,p_time_advanced_pay_grade in number default hr_api.g_number

194: ,p_period_of_prob_advmnt in number default hr_api.g_number
195: ,p_period_of_time_advmnt in number default hr_api.g_number
196: ,p_advancement_to in number default hr_api.g_number
197: ,p_advancement_additional_pyt in number default hr_api.g_number
198: ,p_time_advanced_pay_grade in number default hr_api.g_number
199: ,p_time_advancement_to in number default hr_api.g_number
200: ,p_business_group_id in number default hr_api.g_number
201: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
202: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2

Line 199: ,p_time_advancement_to in number default hr_api.g_number

195: ,p_period_of_time_advmnt in number default hr_api.g_number
196: ,p_advancement_to in number default hr_api.g_number
197: ,p_advancement_additional_pyt in number default hr_api.g_number
198: ,p_time_advanced_pay_grade in number default hr_api.g_number
199: ,p_time_advancement_to in number default hr_api.g_number
200: ,p_business_group_id in number default hr_api.g_number
201: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
202: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
203: ,p_sub_csgrp_description In Varchar2 default hr_api.g_varchar2

Line 200: ,p_business_group_id in number default hr_api.g_number

196: ,p_advancement_to in number default hr_api.g_number
197: ,p_advancement_additional_pyt in number default hr_api.g_number
198: ,p_time_advanced_pay_grade in number default hr_api.g_number
199: ,p_time_advancement_to in number default hr_api.g_number
200: ,p_business_group_id in number default hr_api.g_number
201: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
202: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
203: ,p_sub_csgrp_description In Varchar2 default hr_api.g_varchar2
204: ) is

Line 201: ,p_time_advn_units in varchar2 default hr_api.g_varchar2

197: ,p_advancement_additional_pyt in number default hr_api.g_number
198: ,p_time_advanced_pay_grade in number default hr_api.g_number
199: ,p_time_advancement_to in number default hr_api.g_number
200: ,p_business_group_id in number default hr_api.g_number
201: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
202: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
203: ,p_sub_csgrp_description In Varchar2 default hr_api.g_varchar2
204: ) is
205:

Line 202: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2

198: ,p_time_advanced_pay_grade in number default hr_api.g_number
199: ,p_time_advancement_to in number default hr_api.g_number
200: ,p_business_group_id in number default hr_api.g_number
201: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
202: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
203: ,p_sub_csgrp_description In Varchar2 default hr_api.g_varchar2
204: ) is
205:
206: l_proc varchar2(72) := g_package||'Update_CASE_GROUPS';

Line 203: ,p_sub_csgrp_description In Varchar2 default hr_api.g_varchar2

199: ,p_time_advancement_to in number default hr_api.g_number
200: ,p_business_group_id in number default hr_api.g_number
201: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
202: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
203: ,p_sub_csgrp_description In Varchar2 default hr_api.g_varchar2
204: ) is
205:
206: l_proc varchar2(72) := g_package||'Update_CASE_GROUPS';
207: l_object_Version_Number PQH_DE_CASE_GROUPS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;

Line 247: when hr_api.cannot_find_prog_unit then

243: );
244:
245:
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'UPDATE_CASE_GROUPS'
250: ,p_hook_type => 'BP'
251: );

Line 248: hr_api.cannot_find_prog_unit_error

244:
245:
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'UPDATE_CASE_GROUPS'
250: ,p_hook_type => 'BP'
251: );
252: end;

Line 299: when hr_api.cannot_find_prog_unit then

295: ,p_prob_advn_units => p_prob_advn_units
296: ,p_sub_csgrp_description => p_sub_csgrp_description );
297:
298: exception
299: when hr_api.cannot_find_prog_unit then
300: hr_api.cannot_find_prog_unit_error
301: (p_module_name => 'UPDATE_CASE_GROUPS'
302: ,p_hook_type => 'AP'
303: );

Line 300: hr_api.cannot_find_prog_unit_error

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

Line 309: raise hr_api.validate_enabled;

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

Line 320: when hr_api.validate_enabled then

316:
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 70);
319: exception
320: when hr_api.validate_enabled then
321: --
322: -- As the Validate_Enabled exception has been raised
323: -- we must rollback to the savepoint
324: --

Line 373: when hr_api.cannot_find_prog_unit then

369: ,p_object_version_number => p_object_version_number);
370:
371:
372: exception
373: when hr_api.cannot_find_prog_unit then
374: hr_api.cannot_find_prog_unit_error
375: (p_module_name => 'delete_CASE_GROUPS'
376: ,p_hook_type => 'BP');
377: end;

Line 374: hr_api.cannot_find_prog_unit_error

370:
371:
372: exception
373: when hr_api.cannot_find_prog_unit then
374: hr_api.cannot_find_prog_unit_error
375: (p_module_name => 'delete_CASE_GROUPS'
376: ,p_hook_type => 'BP');
377: end;
378: --

Line 395: when hr_api.cannot_find_prog_unit then

391: (p_CASE_GROUP_Id => p_CASE_GROUP_Id
392: ,p_object_version_number => p_object_version_number);
393:
394: exception
395: when hr_api.cannot_find_prog_unit then
396: hr_api.cannot_find_prog_unit_error
397: (p_module_name => 'DELETE_CASE_GROUPS'
398: ,p_hook_type => 'AP');
399: end;

Line 396: hr_api.cannot_find_prog_unit_error

392: ,p_object_version_number => p_object_version_number);
393:
394: exception
395: when hr_api.cannot_find_prog_unit then
396: hr_api.cannot_find_prog_unit_error
397: (p_module_name => 'DELETE_CASE_GROUPS'
398: ,p_hook_type => 'AP');
399: end;
400: --

Line 404: raise hr_api.validate_enabled;

400: --
401: -- When in validation only mode raise the Validate_Enabled exception
402: --
403: if p_validate then
404: raise hr_api.validate_enabled;
405: end if;
406: --
407: -- Set all output arguments
408: --

Line 411: when hr_api.validate_enabled then

407: -- Set all output arguments
408: --
409: hr_utility.set_location(' Leaving:'||l_proc, 70);
410: exception
411: when hr_api.validate_enabled then
412: --
413: -- As the Validate_Enabled exception has been raised
414: -- we must rollback to the savepoint
415: --