DBA Data[Home] [Help]

APPS.HR_CAGR_ENT_ITEM_API dependencies on HR_API

Line 15: ,p_language_code in varchar2 default hr_api.userenv_lang

11: --
12: procedure create_cagr_entitlement_item
13: (p_validate in boolean default false
14: ,p_effective_date in date
15: ,p_language_code in varchar2 default hr_api.userenv_lang
16: ,p_business_group_id in number default null
17: ,p_item_name in varchar2
18: ,p_element_type_id in number default null
19: ,p_input_value_id in varchar2 default null

Line 74: hr_api.validate_language_code(p_language_code => l_language_code);

70: -- instead of p_language_code from now on, to allow an IN OUT parameter to
71: -- be passed through.
72: --
73: l_language_code := p_language_code;
74: hr_api.validate_language_code(p_language_code => l_language_code);
75: --
76: -- Create the option that will be used for this item
77: --
78: BEGIN

Line 153: WHEN hr_api.cannot_find_prog_unit THEN

149: ,p_auto_create_entries_flag => p_auto_create_entries_flag -- CEI Enh
150:
151: );
152: EXCEPTION
153: WHEN hr_api.cannot_find_prog_unit THEN
154: hr_api.cannot_find_prog_unit_error
155: (
156: p_module_name => 'CREATE_CAGR_ENTITLEMENT_ITEM'
157: ,p_hook_type => 'BP'

Line 154: hr_api.cannot_find_prog_unit_error

150:
151: );
152: EXCEPTION
153: WHEN hr_api.cannot_find_prog_unit THEN
154: hr_api.cannot_find_prog_unit_error
155: (
156: p_module_name => 'CREATE_CAGR_ENTITLEMENT_ITEM'
157: ,p_hook_type => 'BP'
158: );

Line 225: when hr_api.cannot_find_prog_unit then

221: ,p_auto_create_entries_flag => p_auto_create_entries_flag -- CEI Enh
222: ,p_object_version_number => l_object_version_number
223: );
224: exception
225: when hr_api.cannot_find_prog_unit then
226: hr_api.cannot_find_prog_unit_error
227: (p_module_name => 'CREATE_cagr_entitlement_item'
228: ,p_hook_type => 'AP'
229: );

Line 226: hr_api.cannot_find_prog_unit_error

222: ,p_object_version_number => l_object_version_number
223: );
224: exception
225: when hr_api.cannot_find_prog_unit then
226: hr_api.cannot_find_prog_unit_error
227: (p_module_name => 'CREATE_cagr_entitlement_item'
228: ,p_hook_type => 'AP'
229: );
230: --

Line 240: raise hr_api.validate_enabled;

236: --
237: -- When in validation only mode raise the Validate_Enabled exception
238: --
239: if p_validate then
240: raise hr_api.validate_enabled;
241: end if;
242: --
243: -- Set all output arguments
244: --

Line 253: when hr_api.validate_enabled then

249: hr_utility.set_location(' Leaving:'||l_proc, 999);
250: --
251: exception
252: --
253: when hr_api.validate_enabled then
254: --
255: -- As the Validate_Enabled exception has been raised
256: -- we must rollback to the savepoint
257: --

Line 282: ,p_language_code in varchar2 DEFAULT hr_api.userenv_lang

278: --
279: procedure update_cagr_entitlement_item
280: (p_validate in boolean default false
281: ,p_effective_date in date
282: ,p_language_code in varchar2 DEFAULT hr_api.userenv_lang
283: ,p_cagr_entitlement_item_id in number default hr_api.g_number
284: ,p_business_group_id in number default hr_api.g_number
285: ,p_item_name in varchar2 default hr_api.g_varchar2
286: ,p_element_type_id in number default hr_api.g_number

Line 283: ,p_cagr_entitlement_item_id in number default hr_api.g_number

279: procedure update_cagr_entitlement_item
280: (p_validate in boolean default false
281: ,p_effective_date in date
282: ,p_language_code in varchar2 DEFAULT hr_api.userenv_lang
283: ,p_cagr_entitlement_item_id in number default hr_api.g_number
284: ,p_business_group_id in number default hr_api.g_number
285: ,p_item_name in varchar2 default hr_api.g_varchar2
286: ,p_element_type_id in number default hr_api.g_number
287: ,p_input_value_id in varchar2 default hr_api.g_varchar2

Line 284: ,p_business_group_id in number default hr_api.g_number

280: (p_validate in boolean default false
281: ,p_effective_date in date
282: ,p_language_code in varchar2 DEFAULT hr_api.userenv_lang
283: ,p_cagr_entitlement_item_id in number default hr_api.g_number
284: ,p_business_group_id in number default hr_api.g_number
285: ,p_item_name in varchar2 default hr_api.g_varchar2
286: ,p_element_type_id in number default hr_api.g_number
287: ,p_input_value_id in varchar2 default hr_api.g_varchar2
288: ,p_column_type in varchar2 default hr_api.g_varchar2

Line 285: ,p_item_name in varchar2 default hr_api.g_varchar2

281: ,p_effective_date in date
282: ,p_language_code in varchar2 DEFAULT hr_api.userenv_lang
283: ,p_cagr_entitlement_item_id in number default hr_api.g_number
284: ,p_business_group_id in number default hr_api.g_number
285: ,p_item_name in varchar2 default hr_api.g_varchar2
286: ,p_element_type_id in number default hr_api.g_number
287: ,p_input_value_id in varchar2 default hr_api.g_varchar2
288: ,p_column_type in varchar2 default hr_api.g_varchar2
289: ,p_column_size in number default hr_api.g_number

Line 286: ,p_element_type_id in number default hr_api.g_number

282: ,p_language_code in varchar2 DEFAULT hr_api.userenv_lang
283: ,p_cagr_entitlement_item_id in number default hr_api.g_number
284: ,p_business_group_id in number default hr_api.g_number
285: ,p_item_name in varchar2 default hr_api.g_varchar2
286: ,p_element_type_id in number default hr_api.g_number
287: ,p_input_value_id in varchar2 default hr_api.g_varchar2
288: ,p_column_type in varchar2 default hr_api.g_varchar2
289: ,p_column_size in number default hr_api.g_number
290: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 287: ,p_input_value_id in varchar2 default hr_api.g_varchar2

283: ,p_cagr_entitlement_item_id in number default hr_api.g_number
284: ,p_business_group_id in number default hr_api.g_number
285: ,p_item_name in varchar2 default hr_api.g_varchar2
286: ,p_element_type_id in number default hr_api.g_number
287: ,p_input_value_id in varchar2 default hr_api.g_varchar2
288: ,p_column_type in varchar2 default hr_api.g_varchar2
289: ,p_column_size in number default hr_api.g_number
290: ,p_legislation_code in varchar2 default hr_api.g_varchar2
291: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2

Line 288: ,p_column_type in varchar2 default hr_api.g_varchar2

284: ,p_business_group_id in number default hr_api.g_number
285: ,p_item_name in varchar2 default hr_api.g_varchar2
286: ,p_element_type_id in number default hr_api.g_number
287: ,p_input_value_id in varchar2 default hr_api.g_varchar2
288: ,p_column_type in varchar2 default hr_api.g_varchar2
289: ,p_column_size in number default hr_api.g_number
290: ,p_legislation_code in varchar2 default hr_api.g_varchar2
291: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2
292: ,p_cagr_api_param_id in number default hr_api.g_number

Line 289: ,p_column_size in number default hr_api.g_number

285: ,p_item_name in varchar2 default hr_api.g_varchar2
286: ,p_element_type_id in number default hr_api.g_number
287: ,p_input_value_id in varchar2 default hr_api.g_varchar2
288: ,p_column_type in varchar2 default hr_api.g_varchar2
289: ,p_column_size in number default hr_api.g_number
290: ,p_legislation_code in varchar2 default hr_api.g_varchar2
291: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2
292: ,p_cagr_api_param_id in number default hr_api.g_number
293: ,p_category_name in varchar2 default hr_api.g_varchar2

Line 290: ,p_legislation_code in varchar2 default hr_api.g_varchar2

286: ,p_element_type_id in number default hr_api.g_number
287: ,p_input_value_id in varchar2 default hr_api.g_varchar2
288: ,p_column_type in varchar2 default hr_api.g_varchar2
289: ,p_column_size in number default hr_api.g_number
290: ,p_legislation_code in varchar2 default hr_api.g_varchar2
291: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2
292: ,p_cagr_api_param_id in number default hr_api.g_number
293: ,p_category_name in varchar2 default hr_api.g_varchar2
294: ,p_beneficial_formula_id in number default hr_api.g_number

Line 291: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2

287: ,p_input_value_id in varchar2 default hr_api.g_varchar2
288: ,p_column_type in varchar2 default hr_api.g_varchar2
289: ,p_column_size in number default hr_api.g_number
290: ,p_legislation_code in varchar2 default hr_api.g_varchar2
291: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2
292: ,p_cagr_api_param_id in number default hr_api.g_number
293: ,p_category_name in varchar2 default hr_api.g_varchar2
294: ,p_beneficial_formula_id in number default hr_api.g_number
295: ,p_uom in varchar2 default hr_api.g_varchar2

Line 292: ,p_cagr_api_param_id in number default hr_api.g_number

288: ,p_column_type in varchar2 default hr_api.g_varchar2
289: ,p_column_size in number default hr_api.g_number
290: ,p_legislation_code in varchar2 default hr_api.g_varchar2
291: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2
292: ,p_cagr_api_param_id in number default hr_api.g_number
293: ,p_category_name in varchar2 default hr_api.g_varchar2
294: ,p_beneficial_formula_id in number default hr_api.g_number
295: ,p_uom in varchar2 default hr_api.g_varchar2
296: ,p_flex_value_set_id in number default hr_api.g_number

Line 293: ,p_category_name in varchar2 default hr_api.g_varchar2

289: ,p_column_size in number default hr_api.g_number
290: ,p_legislation_code in varchar2 default hr_api.g_varchar2
291: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2
292: ,p_cagr_api_param_id in number default hr_api.g_number
293: ,p_category_name in varchar2 default hr_api.g_varchar2
294: ,p_beneficial_formula_id in number default hr_api.g_number
295: ,p_uom in varchar2 default hr_api.g_varchar2
296: ,p_flex_value_set_id in number default hr_api.g_number
297: ,p_ben_rule_value_set_id in number default hr_api.g_number

Line 294: ,p_beneficial_formula_id in number default hr_api.g_number

290: ,p_legislation_code in varchar2 default hr_api.g_varchar2
291: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2
292: ,p_cagr_api_param_id in number default hr_api.g_number
293: ,p_category_name in varchar2 default hr_api.g_varchar2
294: ,p_beneficial_formula_id in number default hr_api.g_number
295: ,p_uom in varchar2 default hr_api.g_varchar2
296: ,p_flex_value_set_id in number default hr_api.g_number
297: ,p_ben_rule_value_set_id in number default hr_api.g_number
298: ,p_mult_entries_allowed_flag in varchar2 default hr_api.g_varchar2

Line 295: ,p_uom in varchar2 default hr_api.g_varchar2

291: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2
292: ,p_cagr_api_param_id in number default hr_api.g_number
293: ,p_category_name in varchar2 default hr_api.g_varchar2
294: ,p_beneficial_formula_id in number default hr_api.g_number
295: ,p_uom in varchar2 default hr_api.g_varchar2
296: ,p_flex_value_set_id in number default hr_api.g_number
297: ,p_ben_rule_value_set_id in number default hr_api.g_number
298: ,p_mult_entries_allowed_flag in varchar2 default hr_api.g_varchar2
299: ,p_object_version_number in out nocopy number

Line 296: ,p_flex_value_set_id in number default hr_api.g_number

292: ,p_cagr_api_param_id in number default hr_api.g_number
293: ,p_category_name in varchar2 default hr_api.g_varchar2
294: ,p_beneficial_formula_id in number default hr_api.g_number
295: ,p_uom in varchar2 default hr_api.g_varchar2
296: ,p_flex_value_set_id in number default hr_api.g_number
297: ,p_ben_rule_value_set_id in number default hr_api.g_number
298: ,p_mult_entries_allowed_flag in varchar2 default hr_api.g_varchar2
299: ,p_object_version_number in out nocopy number
300: ) is

Line 297: ,p_ben_rule_value_set_id in number default hr_api.g_number

293: ,p_category_name in varchar2 default hr_api.g_varchar2
294: ,p_beneficial_formula_id in number default hr_api.g_number
295: ,p_uom in varchar2 default hr_api.g_varchar2
296: ,p_flex_value_set_id in number default hr_api.g_number
297: ,p_ben_rule_value_set_id in number default hr_api.g_number
298: ,p_mult_entries_allowed_flag in varchar2 default hr_api.g_varchar2
299: ,p_object_version_number in out nocopy number
300: ) is
301: --

Line 298: ,p_mult_entries_allowed_flag in varchar2 default hr_api.g_varchar2

294: ,p_beneficial_formula_id in number default hr_api.g_number
295: ,p_uom in varchar2 default hr_api.g_varchar2
296: ,p_flex_value_set_id in number default hr_api.g_number
297: ,p_ben_rule_value_set_id in number default hr_api.g_number
298: ,p_mult_entries_allowed_flag in varchar2 default hr_api.g_varchar2
299: ,p_object_version_number in out nocopy number
300: ) is
301: --
302: -- Declare cursors and local variables

Line 332: hr_api.validate_language_code(p_language_code => l_language_code);

328: -- instead of p_language_code from now on, to allow an IN OUT parameter to be
329: -- passed through.
330: --
331: l_language_code := p_language_code;
332: hr_api.validate_language_code(p_language_code => l_language_code);
333: --
334: hr_utility.set_location(l_proc, 30);
335: --
336: -- Fetch the API ID for the CAGR Parameter

Line 391: when hr_api.cannot_find_prog_unit then

387: ,p_mult_entries_allowed_flag => p_mult_entries_allowed_flag
388: ,p_object_version_number => l_object_version_number
389: );
390: exception
391: when hr_api.cannot_find_prog_unit then
392: hr_api.cannot_find_prog_unit_error
393: (p_module_name => 'UPDATE_cagr_entitlement_item'
394: ,p_hook_type => 'BP'
395: );

Line 392: hr_api.cannot_find_prog_unit_error

388: ,p_object_version_number => l_object_version_number
389: );
390: exception
391: when hr_api.cannot_find_prog_unit then
392: hr_api.cannot_find_prog_unit_error
393: (p_module_name => 'UPDATE_cagr_entitlement_item'
394: ,p_hook_type => 'BP'
395: );
396: --

Line 454: when hr_api.cannot_find_prog_unit then

450: ,p_mult_entries_allowed_flag => p_mult_entries_allowed_flag
451: ,p_object_version_number => l_object_version_number
452: );
453: exception
454: when hr_api.cannot_find_prog_unit then
455: hr_api.cannot_find_prog_unit_error
456: (p_module_name => 'UPDATE_cagr_entitlement_item'
457: ,p_hook_type => 'AP'
458: );

Line 455: hr_api.cannot_find_prog_unit_error

451: ,p_object_version_number => l_object_version_number
452: );
453: exception
454: when hr_api.cannot_find_prog_unit then
455: hr_api.cannot_find_prog_unit_error
456: (p_module_name => 'UPDATE_cagr_entitlement_item'
457: ,p_hook_type => 'AP'
458: );
459: --

Line 469: raise hr_api.validate_enabled;

465: --
466: -- When in validation only mode raise the Validate_Enabled exception
467: --
468: if p_validate then
469: raise hr_api.validate_enabled;
470: end if;
471: --
472: -- Set all output arguments
473: --

Line 480: when hr_api.validate_enabled then

476: hr_utility.set_location(' Leaving:'||l_proc, 999);
477: --
478: exception
479: --
480: when hr_api.validate_enabled then
481: --
482: -- As the Validate_Enabled exception has been raised
483: -- we must rollback to the savepoint
484: --

Line 557: when hr_api.cannot_find_prog_unit then

553: ,p_effective_date => l_effective_date
554: ,p_object_version_number => l_object_version_number
555: );
556: exception
557: when hr_api.cannot_find_prog_unit then
558: hr_api.cannot_find_prog_unit_error
559: (p_module_name => 'DELETE_cagr_entitlement_item'
560: ,p_hook_type => 'BP'
561: );

Line 558: hr_api.cannot_find_prog_unit_error

554: ,p_object_version_number => l_object_version_number
555: );
556: exception
557: when hr_api.cannot_find_prog_unit then
558: hr_api.cannot_find_prog_unit_error
559: (p_module_name => 'DELETE_cagr_entitlement_item'
560: ,p_hook_type => 'BP'
561: );
562: --

Line 616: when hr_api.cannot_find_prog_unit then

612: ,p_effective_date => l_effective_date
613: ,p_object_version_number => l_object_version_number);
614:
615: exception
616: when hr_api.cannot_find_prog_unit then
617: hr_api.cannot_find_prog_unit_error
618: (p_module_name => 'DELETE_cagr_entitlement_item'
619: ,p_hook_type => 'AP'
620: );

Line 617: hr_api.cannot_find_prog_unit_error

613: ,p_object_version_number => l_object_version_number);
614:
615: exception
616: when hr_api.cannot_find_prog_unit then
617: hr_api.cannot_find_prog_unit_error
618: (p_module_name => 'DELETE_cagr_entitlement_item'
619: ,p_hook_type => 'AP'
620: );
621: --

Line 631: raise hr_api.validate_enabled;

627: --
628: -- When in validation only mode raise the Validate_Enabled exception
629: --
630: if p_validate then
631: raise hr_api.validate_enabled;
632: end if;
633: --
634: hr_utility.set_location(' Leaving:'||l_proc, 70);
635: --

Line 638: when hr_api.validate_enabled then

634: hr_utility.set_location(' Leaving:'||l_proc, 70);
635: --
636: exception
637: --
638: when hr_api.validate_enabled then
639: --
640: -- As the Validate_Enabled exception has been raised
641: -- we must rollback to the savepoint
642: --