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_XDF_BUS dependencies on BEN_XDF_SHD

Line 106: l_api_updating := ben_xdf_shd.api_updating

102: Begin
103: --
104: hr_utility.set_location('Entering:'||l_proc, 5);
105: --
106: l_api_updating := ben_xdf_shd.api_updating
107: (p_ext_dfn_id => p_ext_dfn_id,
108: p_object_version_number => p_object_version_number);
109: --
110: if (l_api_updating

Line 112: <> ben_xdf_shd.g_old_rec.ext_dfn_id) then

108: p_object_version_number => p_object_version_number);
109: --
110: if (l_api_updating
111: and nvl(p_ext_dfn_id,hr_api.g_number)
112: <> ben_xdf_shd.g_old_rec.ext_dfn_id) then
113: --
114: -- raise error as PK has changed
115: --
116: ben_xdf_shd.constraint_error('BEN_EXT_DFN_PK');

Line 116: ben_xdf_shd.constraint_error('BEN_EXT_DFN_PK');

112: <> ben_xdf_shd.g_old_rec.ext_dfn_id) then
113: --
114: -- raise error as PK has changed
115: --
116: ben_xdf_shd.constraint_error('BEN_EXT_DFN_PK');
117: --
118: elsif not l_api_updating then
119: --
120: -- check if PK is null

Line 126: ben_xdf_shd.constraint_error('BEN_EXT_DFN_PK');

122: if p_ext_dfn_id is not null then
123: --
124: -- raise error as PK is not null
125: --
126: ben_xdf_shd.constraint_error('BEN_EXT_DFN_PK');
127: --
128: end if;
129: --
130: end if;

Line 178: l_api_updating := ben_xdf_shd.api_updating

174: Begin
175: --
176: hr_utility.set_location('Entering:'||l_proc,5);
177: --
178: l_api_updating := ben_xdf_shd.api_updating
179: (p_ext_dfn_id => p_ext_dfn_id,
180: p_object_version_number => p_object_version_number);
181: --
182: if (l_api_updating

Line 184: <> nvl(ben_xdf_shd.g_old_rec.ext_file_id,hr_api.g_number)

180: p_object_version_number => p_object_version_number);
181: --
182: if (l_api_updating
183: and nvl(p_ext_file_id,hr_api.g_number)
184: <> nvl(ben_xdf_shd.g_old_rec.ext_file_id,hr_api.g_number)
185: or not l_api_updating) and
186: p_ext_file_id is not null then
187: --
188: -- check if ext_file_id value exists in ben_ext_file table

Line 200: ben_xdf_shd.constraint_error('BEN_EXT_DFN_FK2');

196: --
197: -- raise error as FK does not relate to PK in ben_ext_file
198: -- table.
199: --
200: ben_xdf_shd.constraint_error('BEN_EXT_DFN_FK2');
201: --
202: end if;
203: --
204: close c1;

Line 254: l_api_updating := ben_xdf_shd.api_updating

250: Begin
251: --
252: hr_utility.set_location('Entering:'||l_proc,5);
253: --
254: l_api_updating := ben_xdf_shd.api_updating
255: (p_ext_dfn_id => p_ext_dfn_id,
256: p_object_version_number => p_object_version_number);
257: --
258: if (l_api_updating

Line 260: <> nvl(ben_xdf_shd.g_old_rec.ext_crit_prfl_id,hr_api.g_number)

256: p_object_version_number => p_object_version_number);
257: --
258: if (l_api_updating
259: and nvl(p_ext_crit_prfl_id,hr_api.g_number)
260: <> nvl(ben_xdf_shd.g_old_rec.ext_crit_prfl_id,hr_api.g_number)
261: or not l_api_updating) and
262: p_ext_crit_prfl_id is not null then
263: --
264: -- check if ext_crit_prfl_id value exists in ben_ext_crit_prfl table

Line 276: ben_xdf_shd.constraint_error('BEN_EXT_DFN_FK1');

272: --
273: -- raise error as FK does not relate to PK in ben_ext_crit_prfl
274: -- table.
275: --
276: ben_xdf_shd.constraint_error('BEN_EXT_DFN_FK1');
277: --
278: end if;
279: --
280: close c1;

Line 328: l_api_updating := ben_xdf_shd.api_updating

324: Begin
325: --
326: hr_utility.set_location('Entering:'||l_proc, 5);
327: --
328: l_api_updating := ben_xdf_shd.api_updating
329: (p_ext_dfn_id => p_ext_dfn_id,
330: p_object_version_number => p_object_version_number);
331: --
332: if p_data_typ_cd is null then

Line 338: <> nvl(ben_xdf_shd.g_old_rec.data_typ_cd,hr_api.g_varchar2)

334: fnd_message.raise_error;
335: end if;
336: if (l_api_updating
337: and p_data_typ_cd
338: <> nvl(ben_xdf_shd.g_old_rec.data_typ_cd,hr_api.g_varchar2)
339: or not l_api_updating)
340: and p_data_typ_cd is not null then
341: --
342: -- check if value of lookup falls within lookup type.

Line 431: l_api_updating := ben_xdf_shd.api_updating

427: Begin
428: --
429: hr_utility.set_location('Entering:'||l_proc, 5);
430: --
431: l_api_updating := ben_xdf_shd.api_updating
432: (p_ext_dfn_id => p_ext_dfn_id,
433: p_object_version_number => p_object_version_number);
434: --
435: if (l_api_updating

Line 437: <> nvl(ben_xdf_shd.g_old_rec.apnd_rqst_id_flag,hr_api.g_varchar2)

433: p_object_version_number => p_object_version_number);
434: --
435: if (l_api_updating
436: and p_apnd_rqst_id_flag
437: <> nvl(ben_xdf_shd.g_old_rec.apnd_rqst_id_flag,hr_api.g_varchar2)
438: or not l_api_updating)
439: and p_apnd_rqst_id_flag is not null then
440: --
441: -- check if value of lookup falls within lookup type.

Line 531: l_api_updating := ben_xdf_shd.api_updating

527: Begin
528: --
529: hr_utility.set_location('Entering:'||l_proc, 5);
530: --
531: l_api_updating := ben_xdf_shd.api_updating
532: (p_ext_dfn_id => p_ext_dfn_id,
533: p_object_version_number => p_object_version_number);
534: --
535: if (l_api_updating

Line 537: <> nvl(ben_xdf_shd.g_old_rec.kickoff_wrt_prc_flag,hr_api.g_varchar2)

533: p_object_version_number => p_object_version_number);
534: --
535: if (l_api_updating
536: and p_kickoff_wrt_prc_flag
537: <> nvl(ben_xdf_shd.g_old_rec.kickoff_wrt_prc_flag,hr_api.g_varchar2)
538: or not l_api_updating)
539: and p_kickoff_wrt_prc_flag is not null then
540: --
541: -- check if value of lookup falls within lookup type.

Line 620: l_api_updating := ben_xdf_shd.api_updating

616: Begin
617: --
618: hr_utility.set_location('Entering:'||l_proc, 5);
619: --
620: l_api_updating := ben_xdf_shd.api_updating
621: (p_ext_dfn_id => p_ext_dfn_id,
622: p_object_version_number => p_object_version_number);
623: --
624: if (l_api_updating

Line 626: <> nvl(ben_xdf_shd.g_old_rec.spcl_hndl_flag,hr_api.g_varchar2)

622: p_object_version_number => p_object_version_number);
623: --
624: if (l_api_updating
625: and p_spcl_hndl_flag
626: <> nvl(ben_xdf_shd.g_old_rec.spcl_hndl_flag,hr_api.g_varchar2)
627: or not l_api_updating)
628: and p_spcl_hndl_flag is not null then
629: --
630: -- check if value of lookup falls within lookup type.

Line 687: l_api_updating := ben_xdf_shd.api_updating

683: Begin
684: --
685: hr_utility.set_location('Entering:'||l_proc, 5);
686: --
687: l_api_updating := ben_xdf_shd.api_updating
688: (p_ext_dfn_id => p_ext_dfn_id,
689: p_object_version_number => p_object_version_number);
690: --
691: if (l_api_updating

Line 693: <> nvl(ben_xdf_shd.g_old_rec.ext_global_flag,hr_api.g_varchar2)

689: p_object_version_number => p_object_version_number);
690: --
691: if (l_api_updating
692: and p_ext_global_flag
693: <> nvl(ben_xdf_shd.g_old_rec.ext_global_flag,hr_api.g_varchar2)
694: or not l_api_updating)
695: and p_ext_global_flag is not null then
696: --
697: -- check if value of lookup falls within lookup type.

Line 754: l_api_updating := ben_xdf_shd.api_updating

750: Begin
751: --
752: hr_utility.set_location('Entering:'||l_proc, 5);
753: --
754: l_api_updating := ben_xdf_shd.api_updating
755: (p_ext_dfn_id => p_ext_dfn_id,
756: p_object_version_number => p_object_version_number);
757: --
758: if (l_api_updating

Line 760: <> nvl(ben_xdf_shd.g_old_rec.cm_display_flag,hr_api.g_varchar2)

756: p_object_version_number => p_object_version_number);
757: --
758: if (l_api_updating
759: and p_cm_display_flag
760: <> nvl(ben_xdf_shd.g_old_rec.cm_display_flag,hr_api.g_varchar2)
761: or not l_api_updating)
762: and p_cm_display_flag is not null then
763: --
764: -- check if value of lookup falls within lookup type.

Line 844: l_api_updating := ben_xdf_shd.api_updating

840: Begin
841: --
842: hr_utility.set_location('Entering:'||l_proc, 5);
843: --
844: l_api_updating := ben_xdf_shd.api_updating
845: (p_ext_dfn_id => p_ext_dfn_id,
846: p_object_version_number => p_object_version_number);
847: --
848: if (l_api_updating

Line 850: <> nvl(ben_xdf_shd.g_old_rec.upd_cm_sent_dt_flag,hr_api.g_varchar2)

846: p_object_version_number => p_object_version_number);
847: --
848: if (l_api_updating
849: and p_upd_cm_sent_dt_flag
850: <> nvl(ben_xdf_shd.g_old_rec.upd_cm_sent_dt_flag,hr_api.g_varchar2)
851: or not l_api_updating)
852: and p_upd_cm_sent_dt_flag is not null then
853: --
854: -- check if value of lookup falls within lookup type.

Line 934: l_api_updating := ben_xdf_shd.api_updating

930: Begin
931: --
932: hr_utility.set_location('Entering:'||l_proc, 5);
933: --
934: l_api_updating := ben_xdf_shd.api_updating
935: (p_ext_dfn_id => p_ext_dfn_id,
936: p_object_version_number => p_object_version_number);
937: --
938: if (l_api_updating

Line 940: <> nvl(ben_xdf_shd.g_old_rec.use_eff_dt_for_chgs_flag,hr_api.g_varchar2)

936: p_object_version_number => p_object_version_number);
937: --
938: if (l_api_updating
939: and p_use_eff_dt_for_chgs_flag
940: <> nvl(ben_xdf_shd.g_old_rec.use_eff_dt_for_chgs_flag,hr_api.g_varchar2)
941: or not l_api_updating)
942: and p_use_eff_dt_for_chgs_flag is not null then
943: --
944: -- check if value of lookup falls within lookup type.

Line 1035: l_api_updating := ben_xdf_shd.api_updating

1031: Begin
1032: --
1033: hr_utility.set_location('Entering:'||l_proc, 5);
1034: --
1035: l_api_updating := ben_xdf_shd.api_updating
1036: (p_ext_dfn_id => p_ext_dfn_id,
1037: p_object_version_number => p_object_version_number);
1038: --
1039: if p_data_typ_cd = 'F' then

Line 1057: <> nvl(ben_xdf_shd.g_old_rec.strt_dt,hr_api.g_varchar2)

1053: end if;
1054: --
1055: if (l_api_updating
1056: and p_strt_dt
1057: <> nvl(ben_xdf_shd.g_old_rec.strt_dt,hr_api.g_varchar2)
1058: or not l_api_updating)
1059: and p_strt_dt is not null then
1060:
1061: if substr(p_strt_dt,1,1) in ('0','1','2','3','4','5','6','7','8','9') then

Line 1114: <> nvl(ben_xdf_shd.g_old_rec.end_dt,hr_api.g_varchar2)

1110: end if;
1111: --
1112: if (l_api_updating
1113: and p_end_dt
1114: <> nvl(ben_xdf_shd.g_old_rec.end_dt,hr_api.g_varchar2)
1115: or not l_api_updating)
1116: and p_end_dt is not null then
1117: if substr(p_end_dt,1,1) in ('0','1','2','3','4','5','6','7','8','9') then
1118: begin

Line 1428: Procedure insert_validate(p_rec in ben_xdf_shd.g_rec_type

1424:
1425: -- ----------------------------------------------------------------------------
1426: -- |---------------------------< insert_validate >----------------------------|
1427: -- ----------------------------------------------------------------------------
1428: Procedure insert_validate(p_rec in ben_xdf_shd.g_rec_type
1429: ,p_effective_date in date) is
1430: --
1431: l_proc varchar2(72) := g_package||'insert_validate';
1432: --

Line 1556: Procedure update_validate(p_rec in ben_xdf_shd.g_rec_type

1552: --
1553: -- ----------------------------------------------------------------------------
1554: -- |---------------------------< update_validate >----------------------------|
1555: -- ----------------------------------------------------------------------------
1556: Procedure update_validate(p_rec in ben_xdf_shd.g_rec_type
1557: ,p_effective_date in date) is
1558: --
1559: l_proc varchar2(72) := g_package||'update_validate';
1560: --

Line 1684: Procedure delete_validate(p_rec in ben_xdf_shd.g_rec_type

1680: --
1681: -- ----------------------------------------------------------------------------
1682: -- |---------------------------< delete_validate >----------------------------|
1683: -- ----------------------------------------------------------------------------
1684: Procedure delete_validate(p_rec in ben_xdf_shd.g_rec_type
1685: ,p_effective_date in date) is
1686: --
1687: l_proc varchar2(72) := g_package||'delete_validate';
1688: --

Line 1696: ,ben_xdf_shd.g_old_rec.business_group_id

1692: chk_child_recs ( p_rec.ext_dfn_id);
1693: -- Call all supporting business operations
1694: --
1695: chk_startup_action(False
1696: ,ben_xdf_shd.g_old_rec.business_group_id
1697: ,ben_xdf_shd.g_old_rec.legislation_code);
1698:
1699: hr_utility.set_location(' Leaving:'||l_proc, 10);
1700: End delete_validate;

Line 1697: ,ben_xdf_shd.g_old_rec.legislation_code);

1693: -- Call all supporting business operations
1694: --
1695: chk_startup_action(False
1696: ,ben_xdf_shd.g_old_rec.business_group_id
1697: ,ben_xdf_shd.g_old_rec.legislation_code);
1698:
1699: hr_utility.set_location(' Leaving:'||l_proc, 10);
1700: End delete_validate;
1701: --