DBA Data[Home] [Help]

APPS.BEN_BFT_BUS dependencies on HR_API

Line 51: and nvl(p_benefit_action_id,hr_api.g_number)

47: (p_benefit_action_id => p_benefit_action_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_benefit_action_id,hr_api.g_number)
52: <> ben_bft_shd.g_old_rec.benefit_action_id) then
53: --
54: -- raise error as PK has changed
55: --

Line 120: <> nvl(ben_bft_shd.g_old_rec.debug_messages_flag,hr_api.g_varchar2)

116: p_object_version_number => p_object_version_number);
117: --
118: if (l_api_updating
119: and p_debug_messages_flag
120: <> nvl(ben_bft_shd.g_old_rec.debug_messages_flag,hr_api.g_varchar2)
121: or not l_api_updating) then
122: --
123: -- check if value of lookup falls within lookup type.
124: --

Line 189: and nvl(p_person_selection_rl,hr_api.g_number)

185: (p_benefit_action_id => p_benefit_action_id,
186: p_object_version_number => p_object_version_number);
187: --
188: if (l_api_updating
189: and nvl(p_person_selection_rl,hr_api.g_number)
190: <> ben_bft_shd.g_old_rec.person_selection_rl
191: or not l_api_updating)
192: and p_person_selection_rl is not null then
193: --

Line 261: and nvl(p_comp_selection_rl,hr_api.g_number)

257: (p_benefit_action_id => p_benefit_action_id,
258: p_object_version_number => p_object_version_number);
259: --
260: if (l_api_updating
261: and nvl(p_comp_selection_rl,hr_api.g_number)
262: <> ben_bft_shd.g_old_rec.comp_selection_rl
263: or not l_api_updating)
264: and p_comp_selection_rl is not null then
265: --

Line 333: <> nvl(ben_bft_shd.g_old_rec.no_plans_flag,hr_api.g_varchar2)

329: p_object_version_number => p_object_version_number);
330: --
331: if (l_api_updating
332: and p_no_plans_flag
333: <> nvl(ben_bft_shd.g_old_rec.no_plans_flag,hr_api.g_varchar2)
334: or not l_api_updating) then
335: --
336: -- check if value of lookup falls within lookup type.
337: --

Line 402: <> nvl(ben_bft_shd.g_old_rec.no_programs_flag,hr_api.g_varchar2)

398: p_object_version_number => p_object_version_number);
399: --
400: if (l_api_updating
401: and p_no_programs_flag
402: <> nvl(ben_bft_shd.g_old_rec.no_programs_flag,hr_api.g_varchar2)
403: or not l_api_updating) then
404: --
405: -- check if value of lookup falls within lookup type.
406: --

Line 471: <> nvl(ben_bft_shd.g_old_rec.validate_flag,hr_api.g_varchar2)

467: p_object_version_number => p_object_version_number);
468: --
469: if (l_api_updating
470: and p_validate_flag
471: <> nvl(ben_bft_shd.g_old_rec.validate_flag,hr_api.g_varchar2)
472: or not l_api_updating) then
473: --
474: -- check if value of lookup falls within lookup type.
475: --

Line 540: <> nvl(ben_bft_shd.g_old_rec.derivable_factors_flag,hr_api.g_varchar2)

536: p_object_version_number => p_object_version_number);
537: --
538: if (l_api_updating
539: and p_derivable_factors_flag
540: <> nvl(ben_bft_shd.g_old_rec.derivable_factors_flag,hr_api.g_varchar2)
541: or not l_api_updating) then
542: --
543: -- check if value of lookup falls within lookup type.
544: --

Line 609: <> nvl(ben_bft_shd.g_old_rec.close_uneai_flag,hr_api.g_varchar2)

605: p_object_version_number => p_object_version_number);
606: --
607: if (l_api_updating
608: and p_close_uneai_flag
609: <> nvl(ben_bft_shd.g_old_rec.close_uneai_flag,hr_api.g_varchar2)
610: or not l_api_updating) then
611: --
612: -- check if value of lookup falls within lookup type.
613: --

Line 678: <> nvl(ben_bft_shd.g_old_rec.mode_cd,hr_api.g_varchar2)

674: p_object_version_number => p_object_version_number);
675: --
676: if (l_api_updating
677: and p_mode_cd
678: <> nvl(ben_bft_shd.g_old_rec.mode_cd,hr_api.g_varchar2)
679: or not l_api_updating) then
680: --
681: -- check if value of lookup falls within lookup type.
682: --

Line 686: if hr_api.not_exists_in_hr_lookups

682: --
683: -- The mode_cd is used by both BENMNGLE and BENTMPCM and each has
684: -- it's own domain.
685: --
686: if hr_api.not_exists_in_hr_lookups
687: (p_lookup_type => 'BEN_BENMNGLE_MD',
688: p_lookup_code => p_mode_cd,
689: p_effective_date => p_effective_date) and
690: hr_api.not_exists_in_hr_lookups

Line 690: hr_api.not_exists_in_hr_lookups

686: if hr_api.not_exists_in_hr_lookups
687: (p_lookup_type => 'BEN_BENMNGLE_MD',
688: p_lookup_code => p_mode_cd,
689: p_effective_date => p_effective_date) and
690: hr_api.not_exists_in_hr_lookups
691: (p_lookup_type => 'BEN_BENTMPCM_MD',
692: p_lookup_code => p_mode_cd,
693: p_effective_date => p_effective_date) and
694: hr_api.not_exists_in_hr_lookups

Line 694: hr_api.not_exists_in_hr_lookups

690: hr_api.not_exists_in_hr_lookups
691: (p_lookup_type => 'BEN_BENTMPCM_MD',
692: p_lookup_code => p_mode_cd,
693: p_effective_date => p_effective_date) and
694: hr_api.not_exists_in_hr_lookups
695: (p_lookup_type => 'BEN_BENCLENR_MD',
696: p_lookup_code => p_mode_cd,
697: p_effective_date => p_effective_date) -- 1674123
698: then

Line 732: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

728: --
729: -- Call all supporting business operations
730: --
731: --
732: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
733: --
734: chk_benefit_action_id
735: (p_benefit_action_id => p_rec.benefit_action_id,
736: p_object_version_number => p_rec.object_version_number);

Line 816: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

812: --
813: -- Call all supporting business operations
814: --
815: --
816: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
817: --
818: chk_benefit_action_id
819: (p_benefit_action_id => p_rec.benefit_action_id,
820: p_object_version_number => p_rec.object_version_number);

Line 925: hr_api.mandatory_arg_error(p_api_name => l_proc,

921: hr_utility.set_location('Entering:'|| l_proc, 10);
922: --
923: -- Ensure that all the mandatory parameter are not null
924: --
925: hr_api.mandatory_arg_error(p_api_name => l_proc,
926: p_argument => 'benefit_action_id',
927: p_argument_value => p_benefit_action_id);
928: --
929: open csr_leg_code;