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_XRF_BUS dependencies on BEN_XRF_SHD

Line 155: l_api_updating := ben_xrf_shd.api_updating

151: Begin
152: --
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: --
155: l_api_updating := ben_xrf_shd.api_updating
156: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
157: p_object_version_number => p_object_version_number);
158: --
159: if (l_api_updating

Line 161: <> ben_xrf_shd.g_old_rec.ext_rcd_in_file_id) then

157: p_object_version_number => p_object_version_number);
158: --
159: if (l_api_updating
160: and nvl(p_ext_rcd_in_file_id,hr_api.g_number)
161: <> ben_xrf_shd.g_old_rec.ext_rcd_in_file_id) then
162: --
163: -- raise error as PK has changed
164: --
165: ben_xrf_shd.constraint_error('BEN_EXT_RCD_IN_FILE_PK');

Line 165: ben_xrf_shd.constraint_error('BEN_EXT_RCD_IN_FILE_PK');

161: <> ben_xrf_shd.g_old_rec.ext_rcd_in_file_id) then
162: --
163: -- raise error as PK has changed
164: --
165: ben_xrf_shd.constraint_error('BEN_EXT_RCD_IN_FILE_PK');
166: --
167: elsif not l_api_updating then
168: --
169: -- check if PK is null

Line 175: ben_xrf_shd.constraint_error('BEN_EXT_RCD_IN_FILE_PK');

171: if p_ext_rcd_in_file_id is not null then
172: --
173: -- raise error as PK is not null
174: --
175: ben_xrf_shd.constraint_error('BEN_EXT_RCD_IN_FILE_PK');
176: --
177: end if;
178: --
179: end if;

Line 227: l_api_updating := ben_xrf_shd.api_updating

223: Begin
224: --
225: hr_utility.set_location('Entering:'||l_proc,5);
226: --
227: l_api_updating := ben_xrf_shd.api_updating
228: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
229: p_object_version_number => p_object_version_number);
230: --
231: if (l_api_updating

Line 233: <> nvl(ben_xrf_shd.g_old_rec.ext_rcd_id,hr_api.g_number)

229: p_object_version_number => p_object_version_number);
230: --
231: if (l_api_updating
232: and nvl(p_ext_rcd_id,hr_api.g_number)
233: <> nvl(ben_xrf_shd.g_old_rec.ext_rcd_id,hr_api.g_number)
234: or not l_api_updating) then
235: --
236: -- check if ext_rcd_id value exists in ben_ext_rcd table
237: --

Line 248: ben_xrf_shd.constraint_error('BEN_EXT_RCD_IN_FILE_FK2');

244: --
245: -- raise error as FK does not relate to PK in ben_ext_rcd
246: -- table.
247: --
248: ben_xrf_shd.constraint_error('BEN_EXT_RCD_IN_FILE_FK2');
249: --
250: end if;
251: --
252: close c1;

Line 302: l_api_updating := ben_xrf_shd.api_updating

298: Begin
299: --
300: hr_utility.set_location('Entering:'||l_proc,5);
301: --
302: l_api_updating := ben_xrf_shd.api_updating
303: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
304: p_object_version_number => p_object_version_number);
305: --
306: if (l_api_updating

Line 308: <> nvl(ben_xrf_shd.g_old_rec.ext_file_id,hr_api.g_number)

304: p_object_version_number => p_object_version_number);
305: --
306: if (l_api_updating
307: and nvl(p_ext_file_id,hr_api.g_number)
308: <> nvl(ben_xrf_shd.g_old_rec.ext_file_id,hr_api.g_number)
309: or not l_api_updating) then
310: --
311: -- check if ext_file_id value exists in ben_ext_file table
312: --

Line 323: ben_xrf_shd.constraint_error('BEN_EXT_RCD_IN_FILE_FK1');

319: --
320: -- raise error as FK does not relate to PK in ben_ext_file
321: -- table.
322: --
323: ben_xrf_shd.constraint_error('BEN_EXT_RCD_IN_FILE_FK1');
324: --
325: end if;
326: --
327: close c1;

Line 375: l_api_updating := ben_xrf_shd.api_updating

371: Begin
372: --
373: hr_utility.set_location('Entering:'||l_proc, 5);
374: --
375: l_api_updating := ben_xrf_shd.api_updating
376: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
377: p_object_version_number => p_object_version_number);
378: --
379: if (l_api_updating

Line 381: <> nvl(ben_xrf_shd.g_old_rec.sprs_cd,hr_api.g_varchar2)

377: p_object_version_number => p_object_version_number);
378: --
379: if (l_api_updating
380: and p_sprs_cd
381: <> nvl(ben_xrf_shd.g_old_rec.sprs_cd,hr_api.g_varchar2)
382: or not l_api_updating)
383: and p_sprs_cd is not null then
384: --
385: -- check if value of lookup falls within lookup type.

Line 467: l_api_updating := ben_xrf_shd.api_updating

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

Line 473: <> nvl(ben_xrf_shd.g_old_rec.any_or_all_cd,hr_api.g_varchar2)

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

Line 556: l_api_updating := ben_xrf_shd.api_updating

552: Begin
553: --
554: hr_utility.set_location('Entering:'||l_proc, 5);
555: --
556: l_api_updating := ben_xrf_shd.api_updating
557: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
558: p_object_version_number => p_object_version_number);
559: --
560: if (l_api_updating

Line 562: <> nvl(ben_xrf_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

558: p_object_version_number => p_object_version_number);
559: --
560: if (l_api_updating
561: and p_rqd_flag
562: <> nvl(ben_xrf_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)
563: or not l_api_updating) then
564: --
565: -- check if value of lookup falls within lookup type.
566: --

Line 649: l_api_updating := ben_xrf_shd.api_updating

645: Begin
646: --
647: hr_utility.set_location('Entering:'||l_proc, 5);
648: --
649: l_api_updating := ben_xrf_shd.api_updating
650: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
651: p_object_version_number => p_object_version_number);
652: --
653: if (l_api_updating

Line 655: <> nvl(ben_xrf_shd.g_old_rec.chg_rcd_upd_flag,hr_api.g_varchar2)

651: p_object_version_number => p_object_version_number);
652: --
653: if (l_api_updating
654: and p_chg_rcd_upd_flag
655: <> nvl(ben_xrf_shd.g_old_rec.chg_rcd_upd_flag,hr_api.g_varchar2)
656: or not l_api_updating) then
657: --
658: -- check if value of lookup falls within lookup type.
659: --

Line 745: l_api_updating := ben_xrf_shd.api_updating

741: Begin
742: --
743: hr_utility.set_location('Entering:'||l_proc, 5);
744: --
745: l_api_updating := ben_xrf_shd.api_updating
746: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
747: p_object_version_number => p_object_version_number);
748: --
749: if (l_api_updating

Line 751: <> nvl(ben_xrf_shd.g_old_rec.hide_flag,hr_api.g_varchar2)

747: p_object_version_number => p_object_version_number);
748: --
749: if (l_api_updating
750: and p_hide_flag
751: <> nvl(ben_xrf_shd.g_old_rec.hide_flag,hr_api.g_varchar2)
752: or not l_api_updating) then
753: --
754: -- check if value of lookup falls within lookup type.
755: --

Line 930: l_api_updating := ben_xrf_shd.api_updating

926: --
927: hr_utility.set_location('Entering:'||l_proc, 5);
928: --
929: --
930: l_api_updating := ben_xrf_shd.api_updating
931: (p_ext_rcd_in_file_id => p_ext_rcd_in_file_id,
932: p_object_version_number => p_object_version_number);
933: --
934: if (l_api_updating and

Line 937: <> nvl(ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id ,hr_api.g_number) or

933: --
934: if (l_api_updating and
935: (
936: nvl(p_sort1_data_elmt_in_rcd_id,hr_api.g_number)
937: <> nvl(ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id ,hr_api.g_number) or
938: nvl(p_sort2_data_elmt_in_rcd_id,hr_api.g_number)
939: <> nvl(ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id ,hr_api.g_number) or
940: nvl(p_sort3_data_elmt_in_rcd_id,hr_api.g_number)
941: <> nvl(ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id ,hr_api.g_number) or

Line 939: <> nvl(ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id ,hr_api.g_number) or

935: (
936: nvl(p_sort1_data_elmt_in_rcd_id,hr_api.g_number)
937: <> nvl(ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id ,hr_api.g_number) or
938: nvl(p_sort2_data_elmt_in_rcd_id,hr_api.g_number)
939: <> nvl(ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id ,hr_api.g_number) or
940: nvl(p_sort3_data_elmt_in_rcd_id,hr_api.g_number)
941: <> nvl(ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id ,hr_api.g_number) or
942: nvl(p_sort4_data_elmt_in_rcd_id,hr_api.g_number)
943: <> nvl(ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id ,hr_api.g_number)

Line 941: <> nvl(ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id ,hr_api.g_number) or

937: <> nvl(ben_xrf_shd.g_old_rec.sort1_data_elmt_in_rcd_id ,hr_api.g_number) or
938: nvl(p_sort2_data_elmt_in_rcd_id,hr_api.g_number)
939: <> nvl(ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id ,hr_api.g_number) or
940: nvl(p_sort3_data_elmt_in_rcd_id,hr_api.g_number)
941: <> nvl(ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id ,hr_api.g_number) or
942: nvl(p_sort4_data_elmt_in_rcd_id,hr_api.g_number)
943: <> nvl(ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id ,hr_api.g_number)
944: )
945: )

Line 943: <> nvl(ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id ,hr_api.g_number)

939: <> nvl(ben_xrf_shd.g_old_rec.sort2_data_elmt_in_rcd_id ,hr_api.g_number) or
940: nvl(p_sort3_data_elmt_in_rcd_id,hr_api.g_number)
941: <> nvl(ben_xrf_shd.g_old_rec.sort3_data_elmt_in_rcd_id ,hr_api.g_number) or
942: nvl(p_sort4_data_elmt_in_rcd_id,hr_api.g_number)
943: <> nvl(ben_xrf_shd.g_old_rec.sort4_data_elmt_in_rcd_id ,hr_api.g_number)
944: )
945: )
946: or not l_api_updating then
947:

Line 1074: Procedure insert_validate(p_rec in ben_xrf_shd.g_rec_type

1070:
1071: -- ----------------------------------------------------------------------------
1072: -- |---------------------------< insert_validate >----------------------------|
1073: -- ----------------------------------------------------------------------------
1074: Procedure insert_validate(p_rec in ben_xrf_shd.g_rec_type
1075: ,p_effective_date in date) is
1076: --
1077: l_proc varchar2(72) := g_package||'insert_validate';
1078: --

Line 1171: Procedure update_validate(p_rec in ben_xrf_shd.g_rec_type

1167: --
1168: -- ----------------------------------------------------------------------------
1169: -- |---------------------------< update_validate >----------------------------|
1170: -- ----------------------------------------------------------------------------
1171: Procedure update_validate(p_rec in ben_xrf_shd.g_rec_type
1172: ,p_effective_date in date) is
1173: --
1174: l_proc varchar2(72) := g_package||'update_validate';
1175: --

Line 1267: Procedure delete_validate(p_rec in ben_xrf_shd.g_rec_type

1263: --
1264: -- ----------------------------------------------------------------------------
1265: -- |---------------------------< delete_validate >----------------------------|
1266: -- ----------------------------------------------------------------------------
1267: Procedure delete_validate(p_rec in ben_xrf_shd.g_rec_type
1268: ,p_effective_date in date) is
1269: --
1270: l_proc varchar2(72) := g_package||'delete_validate';
1271: --

Line 1281: ,ben_xrf_shd.g_old_rec.business_group_id

1277:
1278: -- Call all supporting business operations
1279: --
1280: chk_startup_action(False
1281: ,ben_xrf_shd.g_old_rec.business_group_id
1282: ,ben_xrf_shd.g_old_rec.legislation_code);
1283: --
1284: hr_utility.set_location(' Leaving:'||l_proc, 10);
1285: End delete_validate;

Line 1282: ,ben_xrf_shd.g_old_rec.legislation_code);

1278: -- Call all supporting business operations
1279: --
1280: chk_startup_action(False
1281: ,ben_xrf_shd.g_old_rec.business_group_id
1282: ,ben_xrf_shd.g_old_rec.legislation_code);
1283: --
1284: hr_utility.set_location(' Leaving:'||l_proc, 10);
1285: End delete_validate;
1286: --