eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_CEI_UPD dependencies on HR_API

Line 108: When hr_api.check_integrity_violated Then

104: --
105: hr_utility.set_location(' Leaving:'||l_proc, 10);
106: --
107: Exception
108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: --
111: per_cei_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: --
111: per_cei_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: --
116: per_cei_shd.constraint_error

Line 113: When hr_api.parent_integrity_violated Then

109: -- A check constraint has been violated
110: --
111: per_cei_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: --
116: per_cei_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: --
116: per_cei_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: --
121: per_cei_shd.constraint_error

Line 118: When hr_api.unique_integrity_violated Then

114: -- Parent integrity has been violated
115: --
116: per_cei_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: --
121: per_cei_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: --
121: per_cei_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: --
125: Raise;
126: End update_dml;

Line 260: when hr_api.cannot_find_prog_unit then

256: );
257: --
258: exception
259: --
260: when hr_api.cannot_find_prog_unit then
261: --
262: hr_api.cannot_find_prog_unit_error
263: (p_module_name => 'PER_CAGR_ENTITLEMENT_ITEMS'
264: ,p_hook_type => 'AU');

Line 262: hr_api.cannot_find_prog_unit_error

258: exception
259: --
260: when hr_api.cannot_find_prog_unit then
261: --
262: hr_api.cannot_find_prog_unit_error
263: (p_module_name => 'PER_CAGR_ENTITLEMENT_ITEMS'
264: ,p_hook_type => 'AU');
265: --
266: end;

Line 325: If (p_rec.item_name = hr_api.g_varchar2) then

321: -- p_rec plsql record structure
322: -- to see if a system default is being used. If a system default
323: -- is being used then we must set to the 'current' argument value.
324: --
325: If (p_rec.item_name = hr_api.g_varchar2) then
326: p_rec.item_name :=
327: per_cei_shd.g_old_rec.item_name;
328: End If;
329: If (p_rec.element_type_id = hr_api.g_number) then

Line 329: If (p_rec.element_type_id = hr_api.g_number) then

325: If (p_rec.item_name = hr_api.g_varchar2) then
326: p_rec.item_name :=
327: per_cei_shd.g_old_rec.item_name;
328: End If;
329: If (p_rec.element_type_id = hr_api.g_number) then
330: p_rec.element_type_id :=
331: per_cei_shd.g_old_rec.element_type_id;
332: End If;
333: If (p_rec.input_value_id = hr_api.g_varchar2) then

Line 333: If (p_rec.input_value_id = hr_api.g_varchar2) then

329: If (p_rec.element_type_id = hr_api.g_number) then
330: p_rec.element_type_id :=
331: per_cei_shd.g_old_rec.element_type_id;
332: End If;
333: If (p_rec.input_value_id = hr_api.g_varchar2) then
334: p_rec.input_value_id :=
335: per_cei_shd.g_old_rec.input_value_id;
336: End If;
337: --

Line 338: If (p_rec.column_type = hr_api.g_varchar2) then

334: p_rec.input_value_id :=
335: per_cei_shd.g_old_rec.input_value_id;
336: End If;
337: --
338: If (p_rec.column_type = hr_api.g_varchar2) then
339: p_rec.column_type :=
340: per_cei_shd.g_old_rec.column_type;
341: End If;
342: --

Line 343: If (p_rec.column_size = hr_api.g_number) then

339: p_rec.column_type :=
340: per_cei_shd.g_old_rec.column_type;
341: End If;
342: --
343: If (p_rec.column_size = hr_api.g_number) then
344: p_rec.column_size :=
345: per_cei_shd.g_old_rec.column_size;
346: End If;
347: --

Line 348: If (p_rec.legislation_code = hr_api.g_varchar2) then

344: p_rec.column_size :=
345: per_cei_shd.g_old_rec.column_size;
346: End If;
347: --
348: If (p_rec.legislation_code = hr_api.g_varchar2) then
349: p_rec.legislation_code :=
350: per_cei_shd.g_old_rec.legislation_code;
351: End If;
352: If (p_rec.beneficial_rule = hr_api.g_varchar2) then

Line 352: If (p_rec.beneficial_rule = hr_api.g_varchar2) then

348: If (p_rec.legislation_code = hr_api.g_varchar2) then
349: p_rec.legislation_code :=
350: per_cei_shd.g_old_rec.legislation_code;
351: End If;
352: If (p_rec.beneficial_rule = hr_api.g_varchar2) then
353: p_rec.beneficial_rule :=
354: per_cei_shd.g_old_rec.beneficial_rule;
355: End If;
356: If (p_rec.cagr_api_id = hr_api.g_number) then

Line 356: If (p_rec.cagr_api_id = hr_api.g_number) then

352: If (p_rec.beneficial_rule = hr_api.g_varchar2) then
353: p_rec.beneficial_rule :=
354: per_cei_shd.g_old_rec.beneficial_rule;
355: End If;
356: If (p_rec.cagr_api_id = hr_api.g_number) then
357: p_rec.cagr_api_id :=
358: per_cei_shd.g_old_rec.cagr_api_id;
359: End If;
360: If (p_rec.cagr_api_param_id = hr_api.g_number) then

Line 360: If (p_rec.cagr_api_param_id = hr_api.g_number) then

356: If (p_rec.cagr_api_id = hr_api.g_number) then
357: p_rec.cagr_api_id :=
358: per_cei_shd.g_old_rec.cagr_api_id;
359: End If;
360: If (p_rec.cagr_api_param_id = hr_api.g_number) then
361: p_rec.cagr_api_param_id :=
362: per_cei_shd.g_old_rec.cagr_api_param_id;
363: End If;
364:

Line 365: If (p_rec.business_group_id = hr_api.g_number) then

361: p_rec.cagr_api_param_id :=
362: per_cei_shd.g_old_rec.cagr_api_param_id;
363: End If;
364:
365: If (p_rec.business_group_id = hr_api.g_number) then
366: p_rec.business_group_id :=
367: per_cei_shd.g_old_rec.business_group_id;
368: End If;
369: If (p_rec.beneficial_rule = hr_api.g_varchar2) then

Line 369: If (p_rec.beneficial_rule = hr_api.g_varchar2) then

365: If (p_rec.business_group_id = hr_api.g_number) then
366: p_rec.business_group_id :=
367: per_cei_shd.g_old_rec.business_group_id;
368: End If;
369: If (p_rec.beneficial_rule = hr_api.g_varchar2) then
370: p_rec.beneficial_rule :=
371: per_cei_shd.g_old_rec.beneficial_rule;
372: End If;
373: If (p_rec.category_name = hr_api.g_varchar2) then

Line 373: If (p_rec.category_name = hr_api.g_varchar2) then

369: If (p_rec.beneficial_rule = hr_api.g_varchar2) then
370: p_rec.beneficial_rule :=
371: per_cei_shd.g_old_rec.beneficial_rule;
372: End If;
373: If (p_rec.category_name = hr_api.g_varchar2) then
374: p_rec.category_name :=
375: per_cei_shd.g_old_rec.category_name;
376: End If;
377: If (p_rec.uom = hr_api.g_varchar2) then

Line 377: If (p_rec.uom = hr_api.g_varchar2) then

373: If (p_rec.category_name = hr_api.g_varchar2) then
374: p_rec.category_name :=
375: per_cei_shd.g_old_rec.category_name;
376: End If;
377: If (p_rec.uom = hr_api.g_varchar2) then
378: p_rec.uom :=
379: per_cei_shd.g_old_rec.uom;
380: End If;
381: If (p_rec.flex_value_set_id = hr_api.g_number) then

Line 381: If (p_rec.flex_value_set_id = hr_api.g_number) then

377: If (p_rec.uom = hr_api.g_varchar2) then
378: p_rec.uom :=
379: per_cei_shd.g_old_rec.uom;
380: End If;
381: If (p_rec.flex_value_set_id = hr_api.g_number) then
382: p_rec.flex_value_set_id :=
383: per_cei_shd.g_old_rec.flex_value_set_id;
384: End If;
385:

Line 386: If (p_rec.beneficial_formula_id = hr_api.g_number) then

382: p_rec.flex_value_set_id :=
383: per_cei_shd.g_old_rec.flex_value_set_id;
384: End If;
385:
386: If (p_rec.beneficial_formula_id = hr_api.g_number) then
387: p_rec.beneficial_formula_id :=
388: per_cei_shd.g_old_rec.beneficial_formula_id;
389: End If;
390: --

Line 392: If (p_rec.ben_rule_value_set_id = hr_api.g_number) then

388: per_cei_shd.g_old_rec.beneficial_formula_id;
389: End If;
390: --
391:
392: If (p_rec.ben_rule_value_set_id = hr_api.g_number) then
393: p_rec.ben_rule_value_set_id :=
394: per_cei_shd.g_old_rec.ben_rule_value_set_id;
395: End If;
396: --

Line 398: If (p_rec.mult_entries_allowed_flag = hr_api.g_varchar2) then

394: per_cei_shd.g_old_rec.ben_rule_value_set_id;
395: End If;
396: --
397:
398: If (p_rec.mult_entries_allowed_flag = hr_api.g_varchar2) then
399: p_rec.mult_entries_allowed_flag :=
400: per_cei_shd.g_old_rec.mult_entries_allowed_flag;
401: End If;
402: -- -- CEI Enh

Line 403: IF (p_rec.auto_create_entries_flag = hr_api.g_varchar2) THEN -- CEI Enh

399: p_rec.mult_entries_allowed_flag :=
400: per_cei_shd.g_old_rec.mult_entries_allowed_flag;
401: End If;
402: -- -- CEI Enh
403: IF (p_rec.auto_create_entries_flag = hr_api.g_varchar2) THEN -- CEI Enh
404: p_rec.auto_create_entries_flag := -- CEI Enh
405: per_cei_shd.g_old_rec.auto_create_entries_flag; -- CEI Enh
406: END IF; -- CEI Enh
407: --

Line 408: If (p_rec.opt_id = hr_api.g_number) then

404: p_rec.auto_create_entries_flag := -- CEI Enh
405: per_cei_shd.g_old_rec.auto_create_entries_flag; -- CEI Enh
406: END IF; -- CEI Enh
407: --
408: If (p_rec.opt_id = hr_api.g_number) then
409: p_rec.opt_id := per_cei_shd.g_old_rec.opt_id;
410: End If;
411: --
412: End convert_defs;

Line 470: ,p_item_name in varchar2 default hr_api.g_varchar2

466: Procedure upd
467: (p_effective_date in date
468: ,p_cagr_entitlement_item_id in number
469: ,p_object_Version_number in number
470: ,p_item_name in varchar2 default hr_api.g_varchar2
471: ,p_legislation_code in varchar2 default hr_api.g_varchar2
472: ,p_business_group_id in number default hr_api.g_number
473: ,p_category_name in varchar2 default hr_api.g_varchar2
474: ,p_uom in varchar2 default hr_api.g_varchar2

Line 471: ,p_legislation_code in varchar2 default hr_api.g_varchar2

467: (p_effective_date in date
468: ,p_cagr_entitlement_item_id in number
469: ,p_object_Version_number in number
470: ,p_item_name in varchar2 default hr_api.g_varchar2
471: ,p_legislation_code in varchar2 default hr_api.g_varchar2
472: ,p_business_group_id in number default hr_api.g_number
473: ,p_category_name in varchar2 default hr_api.g_varchar2
474: ,p_uom in varchar2 default hr_api.g_varchar2
475: ,p_flex_value_set_id in number default hr_api.g_number

Line 472: ,p_business_group_id in number default hr_api.g_number

468: ,p_cagr_entitlement_item_id in number
469: ,p_object_Version_number in number
470: ,p_item_name in varchar2 default hr_api.g_varchar2
471: ,p_legislation_code in varchar2 default hr_api.g_varchar2
472: ,p_business_group_id in number default hr_api.g_number
473: ,p_category_name in varchar2 default hr_api.g_varchar2
474: ,p_uom in varchar2 default hr_api.g_varchar2
475: ,p_flex_value_set_id in number default hr_api.g_number
476: ,p_element_type_id in number default hr_api.g_number

Line 473: ,p_category_name in varchar2 default hr_api.g_varchar2

469: ,p_object_Version_number in number
470: ,p_item_name in varchar2 default hr_api.g_varchar2
471: ,p_legislation_code in varchar2 default hr_api.g_varchar2
472: ,p_business_group_id in number default hr_api.g_number
473: ,p_category_name in varchar2 default hr_api.g_varchar2
474: ,p_uom in varchar2 default hr_api.g_varchar2
475: ,p_flex_value_set_id in number default hr_api.g_number
476: ,p_element_type_id in number default hr_api.g_number
477: ,p_input_value_id in varchar2 default hr_api.g_varchar2

Line 474: ,p_uom in varchar2 default hr_api.g_varchar2

470: ,p_item_name in varchar2 default hr_api.g_varchar2
471: ,p_legislation_code in varchar2 default hr_api.g_varchar2
472: ,p_business_group_id in number default hr_api.g_number
473: ,p_category_name in varchar2 default hr_api.g_varchar2
474: ,p_uom in varchar2 default hr_api.g_varchar2
475: ,p_flex_value_set_id in number default hr_api.g_number
476: ,p_element_type_id in number default hr_api.g_number
477: ,p_input_value_id in varchar2 default hr_api.g_varchar2
478: ,p_column_type in varchar2 default hr_api.g_varchar2

Line 475: ,p_flex_value_set_id in number default hr_api.g_number

471: ,p_legislation_code in varchar2 default hr_api.g_varchar2
472: ,p_business_group_id in number default hr_api.g_number
473: ,p_category_name in varchar2 default hr_api.g_varchar2
474: ,p_uom in varchar2 default hr_api.g_varchar2
475: ,p_flex_value_set_id in number default hr_api.g_number
476: ,p_element_type_id in number default hr_api.g_number
477: ,p_input_value_id in varchar2 default hr_api.g_varchar2
478: ,p_column_type in varchar2 default hr_api.g_varchar2
479: ,p_column_size in number default hr_api.g_number

Line 476: ,p_element_type_id in number default hr_api.g_number

472: ,p_business_group_id in number default hr_api.g_number
473: ,p_category_name in varchar2 default hr_api.g_varchar2
474: ,p_uom in varchar2 default hr_api.g_varchar2
475: ,p_flex_value_set_id in number default hr_api.g_number
476: ,p_element_type_id in number default hr_api.g_number
477: ,p_input_value_id in varchar2 default hr_api.g_varchar2
478: ,p_column_type in varchar2 default hr_api.g_varchar2
479: ,p_column_size in number default hr_api.g_number
480: ,p_cagr_api_id in number default hr_api.g_number

Line 477: ,p_input_value_id in varchar2 default hr_api.g_varchar2

473: ,p_category_name in varchar2 default hr_api.g_varchar2
474: ,p_uom in varchar2 default hr_api.g_varchar2
475: ,p_flex_value_set_id in number default hr_api.g_number
476: ,p_element_type_id in number default hr_api.g_number
477: ,p_input_value_id in varchar2 default hr_api.g_varchar2
478: ,p_column_type in varchar2 default hr_api.g_varchar2
479: ,p_column_size in number default hr_api.g_number
480: ,p_cagr_api_id in number default hr_api.g_number
481: ,p_cagr_api_param_id in number default hr_api.g_number

Line 478: ,p_column_type in varchar2 default hr_api.g_varchar2

474: ,p_uom in varchar2 default hr_api.g_varchar2
475: ,p_flex_value_set_id in number default hr_api.g_number
476: ,p_element_type_id in number default hr_api.g_number
477: ,p_input_value_id in varchar2 default hr_api.g_varchar2
478: ,p_column_type in varchar2 default hr_api.g_varchar2
479: ,p_column_size in number default hr_api.g_number
480: ,p_cagr_api_id in number default hr_api.g_number
481: ,p_cagr_api_param_id in number default hr_api.g_number
482: ,p_beneficial_formula_id in number default hr_api.g_number

Line 479: ,p_column_size in number default hr_api.g_number

475: ,p_flex_value_set_id in number default hr_api.g_number
476: ,p_element_type_id in number default hr_api.g_number
477: ,p_input_value_id in varchar2 default hr_api.g_varchar2
478: ,p_column_type in varchar2 default hr_api.g_varchar2
479: ,p_column_size in number default hr_api.g_number
480: ,p_cagr_api_id in number default hr_api.g_number
481: ,p_cagr_api_param_id in number default hr_api.g_number
482: ,p_beneficial_formula_id in number default hr_api.g_number
483: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2

Line 480: ,p_cagr_api_id in number default hr_api.g_number

476: ,p_element_type_id in number default hr_api.g_number
477: ,p_input_value_id in varchar2 default hr_api.g_varchar2
478: ,p_column_type in varchar2 default hr_api.g_varchar2
479: ,p_column_size in number default hr_api.g_number
480: ,p_cagr_api_id in number default hr_api.g_number
481: ,p_cagr_api_param_id in number default hr_api.g_number
482: ,p_beneficial_formula_id in number default hr_api.g_number
483: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2
484: ,p_ben_rule_value_set_id in number default hr_api.g_number

Line 481: ,p_cagr_api_param_id in number default hr_api.g_number

477: ,p_input_value_id in varchar2 default hr_api.g_varchar2
478: ,p_column_type in varchar2 default hr_api.g_varchar2
479: ,p_column_size in number default hr_api.g_number
480: ,p_cagr_api_id in number default hr_api.g_number
481: ,p_cagr_api_param_id in number default hr_api.g_number
482: ,p_beneficial_formula_id in number default hr_api.g_number
483: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2
484: ,p_ben_rule_value_set_id in number default hr_api.g_number
485: ,p_mult_entries_allowed_flag in varchar2 default hr_api.g_varchar2

Line 482: ,p_beneficial_formula_id in number default hr_api.g_number

478: ,p_column_type in varchar2 default hr_api.g_varchar2
479: ,p_column_size in number default hr_api.g_number
480: ,p_cagr_api_id in number default hr_api.g_number
481: ,p_cagr_api_param_id in number default hr_api.g_number
482: ,p_beneficial_formula_id in number default hr_api.g_number
483: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2
484: ,p_ben_rule_value_set_id in number default hr_api.g_number
485: ,p_mult_entries_allowed_flag in varchar2 default hr_api.g_varchar2
486: ,p_auto_create_entries_flag in varchar2 default hr_api.g_varchar2 -- CEI Enh

Line 483: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2

479: ,p_column_size in number default hr_api.g_number
480: ,p_cagr_api_id in number default hr_api.g_number
481: ,p_cagr_api_param_id in number default hr_api.g_number
482: ,p_beneficial_formula_id in number default hr_api.g_number
483: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2
484: ,p_ben_rule_value_set_id in number default hr_api.g_number
485: ,p_mult_entries_allowed_flag in varchar2 default hr_api.g_varchar2
486: ,p_auto_create_entries_flag in varchar2 default hr_api.g_varchar2 -- CEI Enh
487:

Line 484: ,p_ben_rule_value_set_id in number default hr_api.g_number

480: ,p_cagr_api_id in number default hr_api.g_number
481: ,p_cagr_api_param_id in number default hr_api.g_number
482: ,p_beneficial_formula_id in number default hr_api.g_number
483: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2
484: ,p_ben_rule_value_set_id in number default hr_api.g_number
485: ,p_mult_entries_allowed_flag in varchar2 default hr_api.g_varchar2
486: ,p_auto_create_entries_flag in varchar2 default hr_api.g_varchar2 -- CEI Enh
487:
488: ) is

Line 485: ,p_mult_entries_allowed_flag in varchar2 default hr_api.g_varchar2

481: ,p_cagr_api_param_id in number default hr_api.g_number
482: ,p_beneficial_formula_id in number default hr_api.g_number
483: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2
484: ,p_ben_rule_value_set_id in number default hr_api.g_number
485: ,p_mult_entries_allowed_flag in varchar2 default hr_api.g_varchar2
486: ,p_auto_create_entries_flag in varchar2 default hr_api.g_varchar2 -- CEI Enh
487:
488: ) is
489: --

Line 486: ,p_auto_create_entries_flag in varchar2 default hr_api.g_varchar2 -- CEI Enh

482: ,p_beneficial_formula_id in number default hr_api.g_number
483: ,p_beneficial_rule in varchar2 default hr_api.g_varchar2
484: ,p_ben_rule_value_set_id in number default hr_api.g_number
485: ,p_mult_entries_allowed_flag in varchar2 default hr_api.g_varchar2
486: ,p_auto_create_entries_flag in varchar2 default hr_api.g_varchar2 -- CEI Enh
487:
488: ) is
489: --
490: l_rec per_cei_shd.g_rec_type;

Line 519: ,hr_api.g_number -- opt_id

515: ,p_object_version_number
516: ,p_ben_rule_value_set_id
517: ,p_mult_entries_allowed_flag
518: ,p_auto_create_entries_flag -- CEI Enh
519: ,hr_api.g_number -- opt_id
520: ) ;
521: --
522: -- Having converted the arguments into the
523: -- plsql record structure we call the corresponding record