DBA Data[Home] [Help]

APPS.BEN_PFF_BUS dependencies on BEN_PFF_SHD

Line 46: l_api_updating := ben_pff_shd.api_updating

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

Line 52: <> ben_pff_shd.g_old_rec.pct_fl_tm_fctr_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_pct_fl_tm_fctr_id,hr_api.g_number)
52: <> ben_pff_shd.g_old_rec.pct_fl_tm_fctr_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_pff_shd.constraint_error('BEN_PCT_FL_TM_FCTR_PK');

Line 56: ben_pff_shd.constraint_error('BEN_PCT_FL_TM_FCTR_PK');

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

Line 66: ben_pff_shd.constraint_error('BEN_PCT_FL_TM_FCTR_PK');

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

Line 132: l_api_updating := ben_pff_shd.api_updating

128: Begin
129: --
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: --
132: l_api_updating := ben_pff_shd.api_updating
133: (p_pct_fl_tm_fctr_id => p_pct_fl_tm_fctr_id,
134: p_object_version_number => p_object_version_number);
135: --
136: if (l_api_updating

Line 138: <> ben_pff_shd.g_old_rec.rndg_rl

134: p_object_version_number => p_object_version_number);
135: --
136: if (l_api_updating
137: and nvl(p_rndg_rl,hr_api.g_number)
138: <> ben_pff_shd.g_old_rec.rndg_rl
139: or not l_api_updating)
140: and p_rndg_rl is not null then
141: --
142: -- check if value of formula rule is valid.

Line 220: l_api_updating := ben_pff_shd.api_updating

216: Begin
217: --
218: hr_utility.set_location('Entering:'||l_proc, 5);
219: --
220: l_api_updating := ben_pff_shd.api_updating
221: (p_pct_fl_tm_fctr_id => p_pct_fl_tm_fctr_id,
222: p_object_version_number => p_object_version_number);
223: --
224: if (l_api_updating

Line 226: <> nvl(ben_pff_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)

222: p_object_version_number => p_object_version_number);
223: --
224: if (l_api_updating
225: and p_rndg_cd
226: <> nvl(ben_pff_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)
227: or not l_api_updating)
228: and p_rndg_cd is not null then
229: --
230: -- check if value of lookup falls within lookup type.

Line 288: l_api_updating := ben_pff_shd.api_updating

284: Begin
285: --
286: hr_utility.set_location('Entering:'||l_proc, 5);
287: --
288: l_api_updating := ben_pff_shd.api_updating
289: (p_pct_fl_tm_fctr_id => p_pct_fl_tm_fctr_id,
290: p_object_version_number => p_object_version_number);
291: --
292: if (l_api_updating

Line 294: <> nvl(ben_pff_shd.g_old_rec.use_sum_of_all_asnts_flag,hr_api.g_varchar2)

290: p_object_version_number => p_object_version_number);
291: --
292: if (l_api_updating
293: and p_use_sum_of_all_asnts_flag
294: <> nvl(ben_pff_shd.g_old_rec.use_sum_of_all_asnts_flag,hr_api.g_varchar2)
295: or not l_api_updating)
296: and p_use_sum_of_all_asnts_flag is not null then
297: --
298: -- check if value of lookup falls within lookup type.

Line 356: l_api_updating := ben_pff_shd.api_updating

352: Begin
353: --
354: hr_utility.set_location('Entering:'||l_proc, 5);
355: --
356: l_api_updating := ben_pff_shd.api_updating
357: (p_pct_fl_tm_fctr_id => p_pct_fl_tm_fctr_id,
358: p_object_version_number => p_object_version_number);
359: --
360: if (l_api_updating

Line 362: <> nvl(ben_pff_shd.g_old_rec.use_prmry_asnt_only_flag,hr_api.g_varchar2)

358: p_object_version_number => p_object_version_number);
359: --
360: if (l_api_updating
361: and p_use_prmry_asnt_only_flag
362: <> nvl(ben_pff_shd.g_old_rec.use_prmry_asnt_only_flag,hr_api.g_varchar2)
363: or not l_api_updating)
364: and p_use_prmry_asnt_only_flag is not null then
365: --
366: -- check if value of lookup falls within lookup type.

Line 424: l_api_updating := ben_pff_shd.api_updating

420: Begin
421: --
422: hr_utility.set_location('Entering:'||l_proc, 5);
423: --
424: l_api_updating := ben_pff_shd.api_updating
425: (p_pct_fl_tm_fctr_id => p_pct_fl_tm_fctr_id,
426: p_object_version_number => p_object_version_number);
427: --
428: if (l_api_updating

Line 430: <> nvl(ben_pff_shd.g_old_rec.no_mx_pct_val_flag,hr_api.g_varchar2)

426: p_object_version_number => p_object_version_number);
427: --
428: if (l_api_updating
429: and p_no_mx_pct_val_flag
430: <> nvl(ben_pff_shd.g_old_rec.no_mx_pct_val_flag,hr_api.g_varchar2)
431: or not l_api_updating)
432: and p_no_mx_pct_val_flag is not null then
433: --
434: -- check if value of lookup falls within lookup type.

Line 492: l_api_updating := ben_pff_shd.api_updating

488: Begin
489: --
490: hr_utility.set_location('Entering:'||l_proc, 5);
491: --
492: l_api_updating := ben_pff_shd.api_updating
493: (p_pct_fl_tm_fctr_id => p_pct_fl_tm_fctr_id,
494: p_object_version_number => p_object_version_number);
495: --
496: if (l_api_updating

Line 498: <> nvl(ben_pff_shd.g_old_rec.no_mn_pct_val_flag,hr_api.g_varchar2)

494: p_object_version_number => p_object_version_number);
495: --
496: if (l_api_updating
497: and p_no_mn_pct_val_flag
498: <> nvl(ben_pff_shd.g_old_rec.no_mn_pct_val_flag,hr_api.g_varchar2)
499: or not l_api_updating)
500: and p_no_mn_pct_val_flag is not null then
501: --
502: -- check if value of lookup falls within lookup type.

Line 666: l_api_updating := ben_pff_shd.api_updating

662: Begin
663: --
664: hr_utility.set_location('Entering:'||l_proc, 5);
665: --
666: l_api_updating := ben_pff_shd.api_updating
667: (p_pct_fl_tm_fctr_id => p_pct_fl_tm_fctr_id,
668: -- p_effective_date => p_effective_date,
669: p_object_version_number => p_object_version_number);
670: --

Line 673: <> ben_pff_shd.g_old_rec.name

669: p_object_version_number => p_object_version_number);
670: --
671: if (l_api_updating
672: and nvl(p_name,hr_api.g_varchar2)
673: <> ben_pff_shd.g_old_rec.name
674: or not l_api_updating)
675: and p_name is not null then
676: --
677: -- check if name already used.

Line 767: Procedure insert_validate(p_rec in ben_pff_shd.g_rec_type

763: --
764: -- ----------------------------------------------------------------------------
765: -- |---------------------------< insert_validate >----------------------------|
766: -- ----------------------------------------------------------------------------
767: Procedure insert_validate(p_rec in ben_pff_shd.g_rec_type
768: ,p_effective_date in date) is
769: --
770: l_proc varchar2(72) := g_package||'insert_validate';
771: --

Line 844: Procedure update_validate(p_rec in ben_pff_shd.g_rec_type

840: --
841: -- ----------------------------------------------------------------------------
842: -- |---------------------------< update_validate >----------------------------|
843: -- ----------------------------------------------------------------------------
844: Procedure update_validate(p_rec in ben_pff_shd.g_rec_type
845: ,p_effective_date in date) is
846: --
847: l_proc varchar2(72) := g_package||'update_validate';
848: --

Line 922: Procedure delete_validate(p_rec in ben_pff_shd.g_rec_type

918: --
919: -- ----------------------------------------------------------------------------
920: -- |---------------------------< delete_validate >----------------------------|
921: -- ----------------------------------------------------------------------------
922: Procedure delete_validate(p_rec in ben_pff_shd.g_rec_type
923: ,p_effective_date in date) is
924: --
925: l_proc varchar2(72) := g_package||'delete_validate';
926: --