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.BEN_AGF_BUS dependencies on BEN_AGF_SHD

Line 46: l_api_updating := ben_agf_shd.api_updating

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

Line 52: <> ben_agf_shd.g_old_rec.age_fctr_id) then

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

Line 56: ben_agf_shd.constraint_error('BEN_AGE_FCTR_PK');

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

Line 66: ben_agf_shd.constraint_error('BEN_AGE_FCTR_PK');

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

Line 119: l_api_updating := ben_agf_shd.api_updating

115: Begin
116: --
117: hr_utility.set_location('Entering:'||l_proc,5);
118: --
119: l_api_updating := ben_agf_shd.api_updating
120: (p_age_fctr_id => p_age_fctr_id,
121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating

Line 125: <> nvl(ben_agf_shd.g_old_rec.organization_id,hr_api.g_number)

121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and nvl(p_organization_id,hr_api.g_number)
125: <> nvl(ben_agf_shd.g_old_rec.organization_id,hr_api.g_number)
126: or not l_api_updating) then
127: --
128: -- check if organization_id value exists in hr_all_organization_units table
129: --

Line 140: ben_agf_shd.constraint_error('BEN_AGE_FCTR_FK1');

136: --
137: -- raise error as FK does not relate to PK in hr_all_organization_units
138: -- table.
139: --
140: ben_agf_shd.constraint_error('BEN_AGE_FCTR_FK1');
141: --
142: end if;
143: --
144: close c1;

Line 191: l_api_updating := ben_agf_shd.api_updating

187: Begin
188: --
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: l_api_updating := ben_agf_shd.api_updating
192: (p_age_fctr_id => p_age_fctr_id,
193: p_object_version_number => p_object_version_number);
194: --
195: if (l_api_updating

Line 197: <> nvl(ben_agf_shd.g_old_rec.age_to_use_cd,hr_api.g_varchar2)

193: p_object_version_number => p_object_version_number);
194: --
195: if (l_api_updating
196: and p_age_to_use_cd
197: <> nvl(ben_agf_shd.g_old_rec.age_to_use_cd,hr_api.g_varchar2)
198: or not l_api_updating) and p_age_to_use_cd is not null then
199: --
200: -- check if value of lookup falls within lookup type.
201: --

Line 263: l_api_updating := ben_agf_shd.api_updating

259: Begin
260: --
261: hr_utility.set_location('Entering:'||l_proc, 5);
262: --
263: l_api_updating := ben_agf_shd.api_updating
264: (p_age_fctr_id => p_age_fctr_id,
265: p_object_version_number => p_object_version_number);
266: --
267: if (l_api_updating

Line 269: <> ben_agf_shd.g_old_rec.rndg_rl

265: p_object_version_number => p_object_version_number);
266: --
267: if (l_api_updating
268: and nvl(p_rndg_rl,hr_api.g_number)
269: <> ben_agf_shd.g_old_rec.rndg_rl
270: or not l_api_updating)
271: and p_rndg_rl is not null then
272: --
273: -- check if value of formula rule is valid.

Line 349: l_api_updating := ben_agf_shd.api_updating

345: Begin
346: --
347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: l_api_updating := ben_agf_shd.api_updating
350: (p_age_fctr_id => p_age_fctr_id,
351: p_object_version_number => p_object_version_number);
352: --
353: if (l_api_updating

Line 355: <> ben_agf_shd.g_old_rec.age_calc_rl

351: p_object_version_number => p_object_version_number);
352: --
353: if (l_api_updating
354: and nvl(p_age_calc_rl,hr_api.g_number)
355: <> ben_agf_shd.g_old_rec.age_calc_rl
356: or not l_api_updating)
357: and p_age_calc_rl is not null then
358: --
359: -- check if value of formula rule is valid.

Line 467: l_api_updating := ben_agf_shd.api_updating

463: Begin
464: --
465: hr_utility.set_location('Entering:'||l_proc, 5);
466: --
467: l_api_updating := ben_agf_shd.api_updating
468: (p_age_fctr_id => p_age_fctr_id,
469: p_object_version_number => p_object_version_number);
470: --
471: if (l_api_updating

Line 473: <> nvl(ben_agf_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)

469: p_object_version_number => p_object_version_number);
470: --
471: if (l_api_updating
472: and p_rndg_cd
473: <> nvl(ben_agf_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)
474: or not l_api_updating)
475: and p_rndg_cd is not null then
476: --
477: -- check if value of lookup falls within lookup type.

Line 540: l_api_updating := ben_agf_shd.api_updating

536: Begin
537: --
538: hr_utility.set_location('Entering:'||l_proc, 5);
539: --
540: l_api_updating := ben_agf_shd.api_updating
541: (p_age_fctr_id => p_age_fctr_id,
542: p_object_version_number => p_object_version_number);
543: --
544: if (l_api_updating

Line 546: <> ben_agf_shd.g_old_rec.age_det_rl

542: p_object_version_number => p_object_version_number);
543: --
544: if (l_api_updating
545: and nvl(p_age_det_rl,hr_api.g_number)
546: <> ben_agf_shd.g_old_rec.age_det_rl
547: or not l_api_updating)
548: and p_age_det_rl is not null then
549: --
550: -- check if value of formula rule is valid.

Line 627: l_api_updating := ben_agf_shd.api_updating

623: Begin
624: --
625: hr_utility.set_location('Entering:'||l_proc, 5);
626: --
627: l_api_updating := ben_agf_shd.api_updating
628: (p_age_fctr_id => p_age_fctr_id,
629: p_object_version_number => p_object_version_number);
630: --
631: if (l_api_updating

Line 633: <> nvl(ben_agf_shd.g_old_rec.age_det_cd,hr_api.g_varchar2)

629: p_object_version_number => p_object_version_number);
630: --
631: if (l_api_updating
632: and p_age_det_cd
633: <> nvl(ben_agf_shd.g_old_rec.age_det_cd,hr_api.g_varchar2)
634: or not l_api_updating)
635: and p_age_det_cd is not null then
636: --
637: -- check if value of lookup falls within lookup type.

Line 697: l_api_updating := ben_agf_shd.api_updating

693: Begin
694: --
695: hr_utility.set_location('Entering:'||l_proc, 5);
696: --
697: l_api_updating := ben_agf_shd.api_updating
698: (p_age_fctr_id => p_age_fctr_id,
699: p_object_version_number => p_object_version_number);
700: --
701: if (l_api_updating

Line 703: <> nvl(ben_agf_shd.g_old_rec.no_mx_age_flag,hr_api.g_varchar2)

699: p_object_version_number => p_object_version_number);
700: --
701: if (l_api_updating
702: and p_no_mx_age_flag
703: <> nvl(ben_agf_shd.g_old_rec.no_mx_age_flag,hr_api.g_varchar2)
704: or not l_api_updating) then
705: --
706: -- check if value of lookup falls within lookup type.
707: --

Line 767: l_api_updating := ben_agf_shd.api_updating

763: Begin
764: --
765: hr_utility.set_location('Entering:'||l_proc, 5);
766: --
767: l_api_updating := ben_agf_shd.api_updating
768: (p_age_fctr_id => p_age_fctr_id,
769: p_object_version_number => p_object_version_number);
770: --
771: if (l_api_updating

Line 773: <> nvl(ben_agf_shd.g_old_rec.no_mn_age_flag,hr_api.g_varchar2)

769: p_object_version_number => p_object_version_number);
770: --
771: if (l_api_updating
772: and p_no_mn_age_flag
773: <> nvl(ben_agf_shd.g_old_rec.no_mn_age_flag,hr_api.g_varchar2)
774: or not l_api_updating) then
775: --
776: -- check if value of lookup falls within lookup type.
777: --

Line 837: l_api_updating := ben_agf_shd.api_updating

833: Begin
834: --
835: hr_utility.set_location('Entering:'||l_proc, 5);
836: --
837: l_api_updating := ben_agf_shd.api_updating
838: (p_age_fctr_id => p_age_fctr_id,
839: p_object_version_number => p_object_version_number);
840: --
841: if (l_api_updating

Line 843: <> nvl(ben_agf_shd.g_old_rec.age_uom,hr_api.g_varchar2)

839: p_object_version_number => p_object_version_number);
840: --
841: if (l_api_updating
842: and p_age_uom
843: <> nvl(ben_agf_shd.g_old_rec.age_uom,hr_api.g_varchar2)
844: or not l_api_updating)
845: and p_age_uom is not null then
846: --
847: -- check if value of lookup falls within lookup type.

Line 1015: l_api_updating := ben_agf_shd.api_updating

1011: Begin
1012: --
1013: hr_utility.set_location('Entering:'||l_proc, 5);
1014: --
1015: l_api_updating := ben_agf_shd.api_updating
1016: (p_age_fctr_id => p_age_fctr_id,
1017: -- p_effective_date => p_effective_date,
1018: p_object_version_number => p_object_version_number);
1019: --

Line 1022: <> ben_agf_shd.g_old_rec.name

1018: p_object_version_number => p_object_version_number);
1019: --
1020: if (l_api_updating
1021: and nvl(p_name,hr_api.g_varchar2)
1022: <> ben_agf_shd.g_old_rec.name
1023: or not l_api_updating)
1024: and p_name is not null then
1025: --
1026: -- check if name already used.

Line 1165: Procedure insert_validate(p_rec in ben_agf_shd.g_rec_type

1161: --
1162: -- ----------------------------------------------------------------------------
1163: -- |---------------------------< insert_validate >----------------------------|
1164: -- ----------------------------------------------------------------------------
1165: Procedure insert_validate(p_rec in ben_agf_shd.g_rec_type
1166: ,p_effective_date in date) is
1167: --
1168: l_proc varchar2(72) := g_package||'insert_validate';
1169: --

Line 1273: Procedure update_validate(p_rec in ben_agf_shd.g_rec_type

1269: --
1270: -- ----------------------------------------------------------------------------
1271: -- |---------------------------< update_validate >----------------------------|
1272: -- ----------------------------------------------------------------------------
1273: Procedure update_validate(p_rec in ben_agf_shd.g_rec_type
1274: ,p_effective_date in date) is
1275: --
1276: l_proc varchar2(72) := g_package||'update_validate';
1277: --

Line 1381: Procedure delete_validate(p_rec in ben_agf_shd.g_rec_type

1377: --
1378: -- ----------------------------------------------------------------------------
1379: -- |---------------------------< delete_validate >----------------------------|
1380: -- ----------------------------------------------------------------------------
1381: Procedure delete_validate(p_rec in ben_agf_shd.g_rec_type
1382: ,p_effective_date in date) is
1383: --
1384: l_proc varchar2(72) := g_package||'delete_validate';
1385: --