DBA Data[Home] [Help]

APPS.PAY_RCU_UPD dependencies on HR_API

Line 88: When hr_api.check_integrity_violated Then

84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: --
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: --
91: pay_rcu_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: --
91: pay_rcu_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: --
96: pay_rcu_shd.constraint_error

Line 93: When hr_api.parent_integrity_violated Then

89: -- A check constraint has been violated
90: --
91: pay_rcu_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: --
96: pay_rcu_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: --
96: pay_rcu_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --
101: pay_rcu_shd.constraint_error

Line 98: When hr_api.unique_integrity_violated Then

94: -- Parent integrity has been violated
95: --
96: pay_rcu_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --
101: pay_rcu_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --
101: pay_rcu_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: --
105: Raise;
106: End update_dml;

Line 245: when hr_api.cannot_find_prog_unit then

241: );
242: --
243: exception
244: --
245: when hr_api.cannot_find_prog_unit then
246: --
247: hr_api.cannot_find_prog_unit_error
248: (p_module_name => 'PAY_RETRO_COMPONENT_USAGES'
249: ,p_hook_type => 'AU');

Line 247: hr_api.cannot_find_prog_unit_error

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

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

344: -- p_rec plsql record structure
345: -- to see if a system default is being used. If a system default
346: -- is being used then we must set to the 'current' argument value.
347: --
348: If (p_rec.business_group_id = hr_api.g_number) then
349: p_rec.business_group_id :=
350: pay_rcu_shd.g_old_rec.business_group_id;
351: End If;
352: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

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

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

352: If (p_rec.legislation_code = hr_api.g_varchar2) then
353: p_rec.legislation_code :=
354: pay_rcu_shd.g_old_rec.legislation_code;
355: End If;
356: If (p_rec.retro_component_id = hr_api.g_number) then
357: p_rec.retro_component_id :=
358: pay_rcu_shd.g_old_rec.retro_component_id;
359: End If;
360: If (p_rec.creator_id = hr_api.g_number) then

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

356: If (p_rec.retro_component_id = hr_api.g_number) then
357: p_rec.retro_component_id :=
358: pay_rcu_shd.g_old_rec.retro_component_id;
359: End If;
360: If (p_rec.creator_id = hr_api.g_number) then
361: p_rec.creator_id :=
362: pay_rcu_shd.g_old_rec.creator_id;
363: End If;
364: If (p_rec.creator_type = hr_api.g_varchar2) then

Line 364: If (p_rec.creator_type = hr_api.g_varchar2) then

360: If (p_rec.creator_id = hr_api.g_number) then
361: p_rec.creator_id :=
362: pay_rcu_shd.g_old_rec.creator_id;
363: End If;
364: If (p_rec.creator_type = hr_api.g_varchar2) then
365: p_rec.creator_type :=
366: pay_rcu_shd.g_old_rec.creator_type;
367: End If;
368: If (p_rec.default_component = hr_api.g_varchar2) then

Line 368: If (p_rec.default_component = hr_api.g_varchar2) then

364: If (p_rec.creator_type = hr_api.g_varchar2) then
365: p_rec.creator_type :=
366: pay_rcu_shd.g_old_rec.creator_type;
367: End If;
368: If (p_rec.default_component = hr_api.g_varchar2) then
369: p_rec.default_component :=
370: pay_rcu_shd.g_old_rec.default_component;
371: End If;
372: If (p_rec.reprocess_type = hr_api.g_varchar2) then

Line 372: If (p_rec.reprocess_type = hr_api.g_varchar2) then

368: If (p_rec.default_component = hr_api.g_varchar2) then
369: p_rec.default_component :=
370: pay_rcu_shd.g_old_rec.default_component;
371: End If;
372: If (p_rec.reprocess_type = hr_api.g_varchar2) then
373: p_rec.reprocess_type :=
374: pay_rcu_shd.g_old_rec.reprocess_type;
375: End If;
376: If (p_rec.replace_run_flag = hr_api.g_varchar2) then

Line 376: If (p_rec.replace_run_flag = hr_api.g_varchar2) then

372: If (p_rec.reprocess_type = hr_api.g_varchar2) then
373: p_rec.reprocess_type :=
374: pay_rcu_shd.g_old_rec.reprocess_type;
375: End If;
376: If (p_rec.replace_run_flag = hr_api.g_varchar2) then
377: p_rec.replace_run_flag :=
378: pay_rcu_shd.g_old_rec.replace_run_flag;
379: End If;
380: If (p_rec.use_override_dates = hr_api.g_varchar2) then

Line 380: If (p_rec.use_override_dates = hr_api.g_varchar2) then

376: If (p_rec.replace_run_flag = hr_api.g_varchar2) then
377: p_rec.replace_run_flag :=
378: pay_rcu_shd.g_old_rec.replace_run_flag;
379: End If;
380: If (p_rec.use_override_dates = hr_api.g_varchar2) then
381: p_rec.use_override_dates :=
382: pay_rcu_shd.g_old_rec.use_override_dates;
383: End If;
384: --

Line 448: ,p_retro_component_id in number default hr_api.g_number

444: Procedure upd
445: (p_effective_date in date
446: ,p_retro_component_usage_id in number
447: ,p_object_version_number in out nocopy number
448: ,p_retro_component_id in number default hr_api.g_number
449: ,p_creator_id in number default hr_api.g_number
450: ,p_creator_type in varchar2 default hr_api.g_varchar2
451: ,p_default_component in varchar2 default hr_api.g_varchar2
452: ,p_reprocess_type in varchar2 default hr_api.g_varchar2

Line 449: ,p_creator_id in number default hr_api.g_number

445: (p_effective_date in date
446: ,p_retro_component_usage_id in number
447: ,p_object_version_number in out nocopy number
448: ,p_retro_component_id in number default hr_api.g_number
449: ,p_creator_id in number default hr_api.g_number
450: ,p_creator_type in varchar2 default hr_api.g_varchar2
451: ,p_default_component in varchar2 default hr_api.g_varchar2
452: ,p_reprocess_type in varchar2 default hr_api.g_varchar2
453: ,p_replace_run_flag in varchar2 default hr_api.g_varchar2

Line 450: ,p_creator_type in varchar2 default hr_api.g_varchar2

446: ,p_retro_component_usage_id in number
447: ,p_object_version_number in out nocopy number
448: ,p_retro_component_id in number default hr_api.g_number
449: ,p_creator_id in number default hr_api.g_number
450: ,p_creator_type in varchar2 default hr_api.g_varchar2
451: ,p_default_component in varchar2 default hr_api.g_varchar2
452: ,p_reprocess_type in varchar2 default hr_api.g_varchar2
453: ,p_replace_run_flag in varchar2 default hr_api.g_varchar2
454: ,p_use_override_dates in varchar2 default hr_api.g_varchar2

Line 451: ,p_default_component in varchar2 default hr_api.g_varchar2

447: ,p_object_version_number in out nocopy number
448: ,p_retro_component_id in number default hr_api.g_number
449: ,p_creator_id in number default hr_api.g_number
450: ,p_creator_type in varchar2 default hr_api.g_varchar2
451: ,p_default_component in varchar2 default hr_api.g_varchar2
452: ,p_reprocess_type in varchar2 default hr_api.g_varchar2
453: ,p_replace_run_flag in varchar2 default hr_api.g_varchar2
454: ,p_use_override_dates in varchar2 default hr_api.g_varchar2
455: ) is

Line 452: ,p_reprocess_type in varchar2 default hr_api.g_varchar2

448: ,p_retro_component_id in number default hr_api.g_number
449: ,p_creator_id in number default hr_api.g_number
450: ,p_creator_type in varchar2 default hr_api.g_varchar2
451: ,p_default_component in varchar2 default hr_api.g_varchar2
452: ,p_reprocess_type in varchar2 default hr_api.g_varchar2
453: ,p_replace_run_flag in varchar2 default hr_api.g_varchar2
454: ,p_use_override_dates in varchar2 default hr_api.g_varchar2
455: ) is
456: --

Line 453: ,p_replace_run_flag in varchar2 default hr_api.g_varchar2

449: ,p_creator_id in number default hr_api.g_number
450: ,p_creator_type in varchar2 default hr_api.g_varchar2
451: ,p_default_component in varchar2 default hr_api.g_varchar2
452: ,p_reprocess_type in varchar2 default hr_api.g_varchar2
453: ,p_replace_run_flag in varchar2 default hr_api.g_varchar2
454: ,p_use_override_dates in varchar2 default hr_api.g_varchar2
455: ) is
456: --
457: l_rec pay_rcu_shd.g_rec_type;

Line 454: ,p_use_override_dates in varchar2 default hr_api.g_varchar2

450: ,p_creator_type in varchar2 default hr_api.g_varchar2
451: ,p_default_component in varchar2 default hr_api.g_varchar2
452: ,p_reprocess_type in varchar2 default hr_api.g_varchar2
453: ,p_replace_run_flag in varchar2 default hr_api.g_varchar2
454: ,p_use_override_dates in varchar2 default hr_api.g_varchar2
455: ) is
456: --
457: l_rec pay_rcu_shd.g_rec_type;
458: l_proc varchar2(72) := g_package||'upd';

Line 469: ,hr_api.g_number

465: --
466: l_rec :=
467: pay_rcu_shd.convert_args
468: (p_retro_component_usage_id
469: ,hr_api.g_number
470: ,hr_api.g_varchar2
471: ,p_retro_component_id
472: ,p_creator_id
473: ,p_creator_type

Line 470: ,hr_api.g_varchar2

466: l_rec :=
467: pay_rcu_shd.convert_args
468: (p_retro_component_usage_id
469: ,hr_api.g_number
470: ,hr_api.g_varchar2
471: ,p_retro_component_id
472: ,p_creator_id
473: ,p_creator_type
474: ,p_default_component