DBA Data[Home] [Help]

APPS.BEN_BFT_BUS dependencies on BEN_BFT_SHD

Line 46: l_api_updating := ben_bft_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_bft_shd.api_updating
47: (p_benefit_action_id => p_benefit_action_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> ben_bft_shd.g_old_rec.benefit_action_id) then

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: --
56: ben_bft_shd.constraint_error('BEN_BENEFIT_ACTIONS_PK');

Line 56: ben_bft_shd.constraint_error('BEN_BENEFIT_ACTIONS_PK');

52: <> ben_bft_shd.g_old_rec.benefit_action_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_bft_shd.constraint_error('BEN_BENEFIT_ACTIONS_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ben_bft_shd.constraint_error('BEN_BENEFIT_ACTIONS_PK');

62: if p_benefit_action_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_bft_shd.constraint_error('BEN_BENEFIT_ACTIONS_PK');
67: --
68: end if;
69: --
70: end if;

Line 114: l_api_updating := ben_bft_shd.api_updating

110: Begin
111: --
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: l_api_updating := ben_bft_shd.api_updating
115: (p_benefit_action_id => p_benefit_action_id,
116: p_object_version_number => p_object_version_number);
117: --
118: if (l_api_updating

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 184: l_api_updating := ben_bft_shd.api_updating

180: Begin
181: --
182: hr_utility.set_location('Entering:'||l_proc, 5);
183: --
184: l_api_updating := ben_bft_shd.api_updating
185: (p_benefit_action_id => p_benefit_action_id,
186: p_object_version_number => p_object_version_number);
187: --
188: if (l_api_updating

Line 190: <> ben_bft_shd.g_old_rec.person_selection_rl

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: --
194: -- check if value of formula rule is valid.

Line 256: l_api_updating := ben_bft_shd.api_updating

252: Begin
253: --
254: hr_utility.set_location('Entering:'||l_proc, 5);
255: --
256: l_api_updating := ben_bft_shd.api_updating
257: (p_benefit_action_id => p_benefit_action_id,
258: p_object_version_number => p_object_version_number);
259: --
260: if (l_api_updating

Line 262: <> ben_bft_shd.g_old_rec.comp_selection_rl

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: --
266: -- check if value of formula rule is valid.

Line 327: l_api_updating := ben_bft_shd.api_updating

323: Begin
324: --
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: l_api_updating := ben_bft_shd.api_updating
328: (p_benefit_action_id => p_benefit_action_id,
329: p_object_version_number => p_object_version_number);
330: --
331: if (l_api_updating

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 396: l_api_updating := ben_bft_shd.api_updating

392: Begin
393: --
394: hr_utility.set_location('Entering:'||l_proc, 5);
395: --
396: l_api_updating := ben_bft_shd.api_updating
397: (p_benefit_action_id => p_benefit_action_id,
398: p_object_version_number => p_object_version_number);
399: --
400: if (l_api_updating

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 465: l_api_updating := ben_bft_shd.api_updating

461: Begin
462: --
463: hr_utility.set_location('Entering:'||l_proc, 5);
464: --
465: l_api_updating := ben_bft_shd.api_updating
466: (p_benefit_action_id => p_benefit_action_id,
467: p_object_version_number => p_object_version_number);
468: --
469: if (l_api_updating

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 534: l_api_updating := ben_bft_shd.api_updating

530: Begin
531: --
532: hr_utility.set_location('Entering:'||l_proc, 5);
533: --
534: l_api_updating := ben_bft_shd.api_updating
535: (p_benefit_action_id => p_benefit_action_id,
536: p_object_version_number => p_object_version_number);
537: --
538: if (l_api_updating

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 603: l_api_updating := ben_bft_shd.api_updating

599: Begin
600: --
601: hr_utility.set_location('Entering:'||l_proc, 5);
602: --
603: l_api_updating := ben_bft_shd.api_updating
604: (p_benefit_action_id => p_benefit_action_id,
605: p_object_version_number => p_object_version_number);
606: --
607: if (l_api_updating

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 672: l_api_updating := ben_bft_shd.api_updating

668: Begin
669: --
670: hr_utility.set_location('Entering:'||l_proc, 5);
671: --
672: l_api_updating := ben_bft_shd.api_updating
673: (p_benefit_action_id => p_benefit_action_id,
674: p_object_version_number => p_object_version_number);
675: --
676: if (l_api_updating

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 716: Procedure insert_validate(p_rec in ben_bft_shd.g_rec_type

712: --
713: -- ----------------------------------------------------------------------------
714: -- |---------------------------< insert_validate >----------------------------|
715: -- ----------------------------------------------------------------------------
716: Procedure insert_validate(p_rec in ben_bft_shd.g_rec_type
717: ,p_effective_date in date) is
718: --
719: l_proc varchar2(72) := g_package||'insert_validate';
720: --

Line 800: Procedure update_validate(p_rec in ben_bft_shd.g_rec_type

796: --
797: -- ----------------------------------------------------------------------------
798: -- |---------------------------< update_validate >----------------------------|
799: -- ----------------------------------------------------------------------------
800: Procedure update_validate(p_rec in ben_bft_shd.g_rec_type
801: ,p_effective_date in date) is
802: --
803: l_proc varchar2(72) := g_package||'update_validate';
804: --

Line 884: Procedure delete_validate(p_rec in ben_bft_shd.g_rec_type

880: --
881: -- ----------------------------------------------------------------------------
882: -- |---------------------------< delete_validate >----------------------------|
883: -- ----------------------------------------------------------------------------
884: Procedure delete_validate(p_rec in ben_bft_shd.g_rec_type
885: ,p_effective_date in date) is
886: --
887: l_proc varchar2(72) := g_package||'delete_validate';
888: --