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_COP_BUS dependencies on BEN_COP_SHD

Line 49: l_api_updating := ben_cop_shd.api_updating

45: Begin
46: --
47: hr_utility.set_location('Entering:'||l_proc, 5);
48: --
49: l_api_updating := ben_cop_shd.api_updating
50: (p_effective_date => p_effective_date,
51: p_oipl_id => p_oipl_id,
52: p_object_version_number => p_object_version_number);
53: --

Line 56: <> ben_cop_shd.g_old_rec.oipl_id) then

52: p_object_version_number => p_object_version_number);
53: --
54: if (l_api_updating
55: and nvl(p_oipl_id,hr_api.g_number)
56: <> ben_cop_shd.g_old_rec.oipl_id) then
57: --
58: -- raise error as PK has changed
59: --
60: ben_cpo_shd.constraint_error('BEN_OIPL_PK');

Line 70: ben_cop_shd.constraint_error('BEN_OIPL_PK');

66: if p_oipl_id is not null then
67: --
68: -- raise error as PK is not null
69: --
70: ben_cop_shd.constraint_error('BEN_OIPL_PK');
71: --
72: end if;
73: --
74: end if;

Line 117: l_api_updating := ben_cop_shd.api_updating

113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_cop_shd.api_updating
118: (p_oipl_id => p_oipl_id,
119: p_effective_date => p_effective_date,
120: p_object_version_number => p_object_version_number);
121: --

Line 124: <> nvl(ben_cop_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_dflt_flag
124: <> nvl(ben_cop_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_dflt_flag is not null then
127: --
128: -- check if value of lookup falls within lookup type.

Line 187: l_api_updating := ben_cop_shd.api_updating

183: Begin
184: --
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: l_api_updating := ben_cop_shd.api_updating
188: (p_oipl_id => p_oipl_id,
189: p_effective_date => p_effective_date,
190: p_object_version_number => p_object_version_number);
191: --

Line 194: <> nvl(ben_cop_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)

190: p_object_version_number => p_object_version_number);
191: --
192: if (l_api_updating
193: and p_mndtry_flag
194: <> nvl(ben_cop_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)
195: or not l_api_updating)
196: and p_mndtry_flag is not null then
197: --
198: -- check if value of lookup falls within lookup type.

Line 257: l_api_updating := ben_cop_shd.api_updating

253: Begin
254: --
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: l_api_updating := ben_cop_shd.api_updating
258: (p_oipl_id => p_oipl_id,
259: p_effective_date => p_effective_date,
260: p_object_version_number => p_object_version_number);
261: --

Line 264: <> nvl(ben_cop_shd.g_old_rec.elig_apls_flag,hr_api.g_varchar2)

260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating
263: and p_elig_apls_flag
264: <> nvl(ben_cop_shd.g_old_rec.elig_apls_flag,hr_api.g_varchar2)
265: or not l_api_updating)
266: and p_elig_apls_flag is not null then
267: --
268: -- check if value of lookup falls within lookup type.

Line 327: l_api_updating := ben_cop_shd.api_updating

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

Line 334: <> nvl(ben_cop_shd.g_old_rec.trk_inelig_per_flag,hr_api.g_varchar2)

330: p_object_version_number => p_object_version_number);
331: --
332: if (l_api_updating
333: and p_trk_inelig_per_flag
334: <> nvl(ben_cop_shd.g_old_rec.trk_inelig_per_flag,hr_api.g_varchar2)
335: or not l_api_updating)
336: and p_trk_inelig_per_flag is not null then
337: --
338: -- check if value of lookup falls within lookup type.

Line 398: l_api_updating := ben_cop_shd.api_updating

394: Begin
395: --
396: hr_utility.set_location('Entering:'||l_proc, 5);
397: --
398: l_api_updating := ben_cop_shd.api_updating
399: (p_oipl_id => p_oipl_id,
400: p_effective_date => p_effective_date,
401: p_object_version_number => p_object_version_number);
402: --

Line 405: <> nvl(ben_cop_shd.g_old_rec.drvbl_fctr_prtn_elig_flag,hr_api.g_varchar2)

401: p_object_version_number => p_object_version_number);
402: --
403: if (l_api_updating
404: and p_drvbl_fctr_prtn_elig_flag
405: <> nvl(ben_cop_shd.g_old_rec.drvbl_fctr_prtn_elig_flag,hr_api.g_varchar2)
406: or not l_api_updating)
407: and p_drvbl_fctr_prtn_elig_flag is not null then
408: --
409: -- check if value of lookup falls within lookup type.

Line 469: l_api_updating := ben_cop_shd.api_updating

465: Begin
466: --
467: hr_utility.set_location('Entering:'||l_proc, 5);
468: --
469: l_api_updating := ben_cop_shd.api_updating
470: (p_oipl_id => p_oipl_id,
471: p_effective_date => p_effective_date,
472: p_object_version_number => p_object_version_number);
473: --

Line 476: <> nvl(ben_cop_shd.g_old_rec.prtn_elig_ovrid_alwd_flag,hr_api.g_varchar2)

472: p_object_version_number => p_object_version_number);
473: --
474: if (l_api_updating
475: and p_prtn_elig_ovrid_alwd_flag
476: <> nvl(ben_cop_shd.g_old_rec.prtn_elig_ovrid_alwd_flag,hr_api.g_varchar2)
477: or not l_api_updating)
478: and p_prtn_elig_ovrid_alwd_flag is not null then
479: --
480: -- check if value of lookup falls within lookup type.

Line 540: l_api_updating := ben_cop_shd.api_updating

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

Line 547: <> nvl(ben_cop_shd.g_old_rec.drvbl_fctr_apls_rts_flag,hr_api.g_varchar2)

543: p_object_version_number => p_object_version_number);
544: --
545: if (l_api_updating
546: and p_drvbl_fctr_apls_rts_flag
547: <> nvl(ben_cop_shd.g_old_rec.drvbl_fctr_apls_rts_flag,hr_api.g_varchar2)
548: or not l_api_updating)
549: and p_drvbl_fctr_apls_rts_flag is not null then
550: --
551: -- check if value of lookup falls within lookup type.

Line 610: l_api_updating := ben_cop_shd.api_updating

606: Begin
607: --
608: hr_utility.set_location('Entering:'||l_proc, 5);
609: --
610: l_api_updating := ben_cop_shd.api_updating
611: (p_oipl_id => p_oipl_id,
612: p_effective_date => p_effective_date,
613: p_object_version_number => p_object_version_number);
614: --

Line 617: <> nvl(ben_cop_shd.g_old_rec.oipl_stat_cd,hr_api.g_varchar2)

613: p_object_version_number => p_object_version_number);
614: --
615: if (l_api_updating
616: and p_oipl_stat_cd
617: <> nvl(ben_cop_shd.g_old_rec.oipl_stat_cd,hr_api.g_varchar2)
618: or not l_api_updating)
619: and p_oipl_stat_cd is not null then
620: --
621: -- check if value of lookup falls within lookup type.

Line 680: l_api_updating := ben_cop_shd.api_updating

676: Begin
677: --
678: hr_utility.set_location('Entering:'||l_proc, 5);
679: --
680: l_api_updating := ben_cop_shd.api_updating
681: (p_oipl_id => p_oipl_id,
682: p_effective_date => p_effective_date,
683: p_object_version_number => p_object_version_number);
684: --

Line 687: <> nvl(ben_cop_shd.g_old_rec.pcp_dsgn_cd,hr_api.g_varchar2)

683: p_object_version_number => p_object_version_number);
684: --
685: if (l_api_updating
686: and p_pcp_dsgn_cd
687: <> nvl(ben_cop_shd.g_old_rec.pcp_dsgn_cd,hr_api.g_varchar2)
688: or not l_api_updating)
689: and p_pcp_dsgn_cd is not null then
690: --
691: -- check if value of lookup falls within lookup type.

Line 751: l_api_updating := ben_cop_shd.api_updating

747: Begin
748: --
749: hr_utility.set_location('Entering:'||l_proc, 5);
750: --
751: l_api_updating := ben_cop_shd.api_updating
752: (p_oipl_id => p_oipl_id,
753: p_effective_date => p_effective_date,
754: p_object_version_number => p_object_version_number);
755: --

Line 758: <> nvl(ben_cop_shd.g_old_rec.pcp_dpnt_dsgn_cd,hr_api.g_varchar2)

754: p_object_version_number => p_object_version_number);
755: --
756: if (l_api_updating
757: and p_pcp_dpnt_dsgn_cd
758: <> nvl(ben_cop_shd.g_old_rec.pcp_dpnt_dsgn_cd,hr_api.g_varchar2)
759: or not l_api_updating)
760: and p_pcp_dpnt_dsgn_cd is not null then
761: --
762: -- check if value of lookup falls within lookup type.

Line 821: l_api_updating := ben_cop_shd.api_updating

817: Begin
818: --
819: hr_utility.set_location('Entering:'||l_proc, 5);
820: --
821: l_api_updating := ben_cop_shd.api_updating
822: (p_oipl_id => p_oipl_id,
823: p_effective_date => p_effective_date,
824: p_object_version_number => p_object_version_number);
825: --

Line 828: <> nvl(ben_cop_shd.g_old_rec.auto_enrt_flag,hr_api.g_varchar2)

824: p_object_version_number => p_object_version_number);
825: --
826: if (l_api_updating
827: and p_auto_enrt_flag
828: <> nvl(ben_cop_shd.g_old_rec.auto_enrt_flag,hr_api.g_varchar2)
829: or not l_api_updating)
830: and p_auto_enrt_flag is not null then
831: --
832: -- check if value of lookup falls within lookup type.

Line 892: l_api_updating := ben_cop_shd.api_updating

888: Begin
889: --
890: hr_utility.set_location('Entering:'||l_proc, 5);
891: --
892: l_api_updating := ben_cop_shd.api_updating
893: (p_oipl_id => p_oipl_id,
894: p_effective_date => p_effective_date,
895: p_object_version_number => p_object_version_number);
896: --

Line 899: <> nvl(ben_cop_shd.g_old_rec.vrfy_fmly_mmbr_cd,hr_api.g_varchar2)

895: p_object_version_number => p_object_version_number);
896: --
897: if (l_api_updating
898: and p_vrfy_fmly_mmbr_cd
899: <> nvl(ben_cop_shd.g_old_rec.vrfy_fmly_mmbr_cd,hr_api.g_varchar2)
900: or not l_api_updating)
901: and p_vrfy_fmly_mmbr_cd is not null then
902: --
903: -- check if value of lookup falls within lookup type.

Line 962: l_api_updating := ben_cop_shd.api_updating

958: Begin
959: --
960: hr_utility.set_location('Entering:'||l_proc, 5);
961: --
962: l_api_updating := ben_cop_shd.api_updating
963: (p_oipl_id => p_oipl_id,
964: p_effective_date => p_effective_date,
965: p_object_version_number => p_object_version_number);
966: --

Line 969: <> nvl(ben_cop_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)

965: p_object_version_number => p_object_version_number);
966: --
967: if (l_api_updating
968: and p_enrt_cd
969: <> nvl(ben_cop_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)
970: or not l_api_updating)
971: and p_enrt_cd is not null then
972: --
973: -- check if value of lookup falls within lookup type.

Line 1032: l_api_updating := ben_cop_shd.api_updating

1028: Begin
1029: --
1030: hr_utility.set_location('Entering:'||l_proc, 5);
1031: --
1032: l_api_updating := ben_cop_shd.api_updating
1033: (p_oipl_id => p_oipl_id,
1034: p_effective_date => p_effective_date,
1035: p_object_version_number => p_object_version_number);
1036: --

Line 1039: <> nvl(ben_cop_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)

1035: p_object_version_number => p_object_version_number);
1036: --
1037: if (l_api_updating
1038: and p_dflt_enrt_cd
1039: <> nvl(ben_cop_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)
1040: or not l_api_updating)
1041: and p_dflt_enrt_cd is not null then
1042: --
1043: -- check if value of lookup falls within lookup type.

Line 1103: l_api_updating := ben_cop_shd.api_updating

1099: Begin
1100: --
1101: hr_utility.set_location('Entering:'||l_proc, 5);
1102: --
1103: l_api_updating := ben_cop_shd.api_updating
1104: (p_oipl_id => p_oipl_id,
1105: p_effective_date => p_effective_date,
1106: p_object_version_number => p_object_version_number);
1107: --

Line 1110: <> ben_cop_shd.g_old_rec.auto_enrt_mthd_rl

1106: p_object_version_number => p_object_version_number);
1107: --
1108: if (l_api_updating
1109: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)
1110: <> ben_cop_shd.g_old_rec.auto_enrt_mthd_rl
1111: or not l_api_updating)
1112: and p_auto_enrt_mthd_rl is not null then
1113: --
1114: -- check if value of formula rule is valid.

Line 1177: l_api_updating := ben_cop_shd.api_updating

1173: Begin
1174: --
1175: hr_utility.set_location('Entering:'||l_proc, 5);
1176: --
1177: l_api_updating := ben_cop_shd.api_updating
1178: (p_oipl_id => p_oipl_id,
1179: p_effective_date => p_effective_date,
1180: p_object_version_number => p_object_version_number);
1181: --

Line 1184: <> ben_cop_shd.g_old_rec.dflt_enrt_det_rl

1180: p_object_version_number => p_object_version_number);
1181: --
1182: if (l_api_updating
1183: and nvl(p_dflt_enrt_det_rl,hr_api.g_number)
1184: <> ben_cop_shd.g_old_rec.dflt_enrt_det_rl
1185: or not l_api_updating)
1186: and p_dflt_enrt_det_rl is not null then
1187: --
1188: -- check if value of formula rule is valid.

Line 1249: l_api_updating := ben_cop_shd.api_updating

1245: Begin
1246: --
1247: hr_utility.set_location('Entering:'||l_proc, 5);
1248: --
1249: l_api_updating := ben_cop_shd.api_updating
1250: (p_oipl_id => p_oipl_id,
1251: p_effective_date => p_effective_date,
1252: p_object_version_number => p_object_version_number);
1253: --

Line 1256: <> ben_cop_shd.g_old_rec.mndtry_rl

1252: p_object_version_number => p_object_version_number);
1253: --
1254: if (l_api_updating
1255: and nvl(p_mndtry_rl,hr_api.g_number)
1256: <> ben_cop_shd.g_old_rec.mndtry_rl
1257: or not l_api_updating)
1258: and p_mndtry_rl is not null then
1259: --
1260: -- check if value of formula rule is valid.

Line 1321: l_api_updating := ben_cop_shd.api_updating

1317: Begin
1318: --
1319: hr_utility.set_location('Entering:'||l_proc, 5);
1320: --
1321: l_api_updating := ben_cop_shd.api_updating
1322: (p_oipl_id => p_oipl_id,
1323: p_effective_date => p_effective_date,
1324: p_object_version_number => p_object_version_number);
1325: --

Line 1328: <> ben_cop_shd.g_old_rec.rqd_perd_enrt_nenrt_rl

1324: p_object_version_number => p_object_version_number);
1325: --
1326: if (l_api_updating
1327: and nvl(p_rqd_perd_enrt_nenrt_rl,hr_api.g_number)
1328: <> ben_cop_shd.g_old_rec.rqd_perd_enrt_nenrt_rl
1329: or not l_api_updating)
1330: and p_rqd_perd_enrt_nenrt_rl is not null then
1331: --
1332: -- check if value of formula rule is valid.

Line 1393: l_api_updating := ben_cop_shd.api_updating

1389: Begin
1390: --
1391: hr_utility.set_location('Entering:'||l_proc, 5);
1392: --
1393: l_api_updating := ben_cop_shd.api_updating
1394: (p_oipl_id => p_oipl_id,
1395: p_effective_date => p_effective_date,
1396: p_object_version_number => p_object_version_number);
1397: --

Line 1400: <> ben_cop_shd.g_old_rec.postelcn_edit_rl

1396: p_object_version_number => p_object_version_number);
1397: --
1398: if (l_api_updating
1399: and nvl(p_postelcn_edit_rl,hr_api.g_number)
1400: <> ben_cop_shd.g_old_rec.postelcn_edit_rl
1401: or not l_api_updating)
1402: and p_postelcn_edit_rl is not null then
1403: --
1404: -- check if value of formula rule is valid.

Line 1465: l_api_updating := ben_cop_shd.api_updating

1461: Begin
1462: --
1463: hr_utility.set_location('Entering:'||l_proc, 5);
1464: --
1465: l_api_updating := ben_cop_shd.api_updating
1466: (p_oipl_id => p_oipl_id,
1467: p_effective_date => p_effective_date,
1468: p_object_version_number => p_object_version_number);
1469: --

Line 1472: <> ben_cop_shd.g_old_rec.vrfy_fmly_mmbr_rl

1468: p_object_version_number => p_object_version_number);
1469: --
1470: if (l_api_updating
1471: and nvl(p_vrfy_fmly_mmbr_rl,hr_api.g_number)
1472: <> ben_cop_shd.g_old_rec.vrfy_fmly_mmbr_rl
1473: or not l_api_updating)
1474: and p_vrfy_fmly_mmbr_rl is not null then
1475: --
1476: -- check if value of formula rule is valid.

Line 1538: l_api_updating := ben_cop_shd.api_updating

1534: Begin
1535: --
1536: hr_utility.set_location('Entering:'||l_proc, 5);
1537: --
1538: l_api_updating := ben_cop_shd.api_updating
1539: (p_oipl_id => p_oipl_id,
1540: p_effective_date => p_effective_date,
1541: p_object_version_number => p_object_version_number);
1542: --

Line 1545: <> ben_cop_shd.g_old_rec.enrt_rl

1541: p_object_version_number => p_object_version_number);
1542: --
1543: if (l_api_updating
1544: and nvl(p_enrt_rl,hr_api.g_number)
1545: <> ben_cop_shd.g_old_rec.enrt_rl
1546: or not l_api_updating)
1547: and p_enrt_rl is not null then
1548: --
1549: -- check if value of formula rule is valid.

Line 1800: l_api_updating := ben_cop_shd.api_updating

1796: Begin
1797: --
1798: hr_utility.set_location('Entering:'||l_proc, 5);
1799: --
1800: l_api_updating := ben_cop_shd.api_updating
1801: (p_effective_date => p_effective_date,
1802: p_oipl_id => p_oipl_id,
1803: p_object_version_number => p_object_version_number);
1804: --

Line 1882: l_api_updating := ben_cop_shd.api_updating

1878: Begin
1879: --
1880: hr_utility.set_location('Entering:'||l_proc, 5);
1881: --
1882: l_api_updating := ben_cop_shd.api_updating
1883: (p_effective_date => p_effective_date,
1884: p_oipl_id => p_oipl_id,
1885: p_object_version_number => p_object_version_number);
1886: --

Line 1984: l_api_updating := ben_cop_shd.api_updating

1980: Begin
1981: --
1982: hr_utility.set_location('Entering:'||l_proc,5);
1983: --
1984: l_api_updating := ben_cop_shd.api_updating
1985: (p_oipl_id => p_oipl_id,
1986: p_effective_date => p_effective_date,
1987: p_object_version_number => p_object_version_number);
1988: --

Line 1991: <> nvl(ben_cop_shd.g_old_rec.opt_id, hr_api.g_number)

1987: p_object_version_number => p_object_version_number);
1988: --
1989: if (l_api_updating
1990: and nvl(p_opt_id,hr_api.g_number)
1991: <> nvl(ben_cop_shd.g_old_rec.opt_id, hr_api.g_number)
1992: or not l_api_updating) then
1993: --
1994: --
1995: open c1;

Line 2071: l_api_updating := ben_cop_shd.api_updating

2067: Begin
2068: --
2069: hr_utility.set_location('Entering:'||l_proc,5);
2070: --
2071: l_api_updating := ben_cop_shd.api_updating
2072: (p_oipl_id => p_oipl_id,
2073: p_effective_date => p_effective_date,
2074: p_object_version_number => p_object_version_number);
2075: --

Line 2078: <> nvl(ben_cop_shd.g_old_rec.ordr_num, hr_api.g_number)

2074: p_object_version_number => p_object_version_number);
2075: --
2076: if (l_api_updating
2077: and nvl(p_ordr_num,hr_api.g_number)
2078: <> nvl(ben_cop_shd.g_old_rec.ordr_num, hr_api.g_number)
2079: or not l_api_updating) then
2080: --
2081: --
2082: open c1;

Line 2466: (p_rec in ben_cop_shd.g_rec_type,

2462: -- ----------------------------------------------------------------------------
2463: -- |---------------------------< insert_validate >----------------------------|
2464: -- ----------------------------------------------------------------------------
2465: Procedure insert_validate
2466: (p_rec in ben_cop_shd.g_rec_type,
2467: p_effective_date in date,
2468: p_datetrack_mode in varchar2,
2469: p_validation_start_date in date,
2470: p_validation_end_date in date) is

Line 2657: (p_rec in ben_cop_shd.g_rec_type,

2653: -- ----------------------------------------------------------------------------
2654: -- |---------------------------< update_validate >----------------------------|
2655: -- ----------------------------------------------------------------------------
2656: Procedure update_validate
2657: (p_rec in ben_cop_shd.g_rec_type,
2658: p_effective_date in date,
2659: p_datetrack_mode in varchar2,
2660: p_validation_start_date in date,
2661: p_validation_end_date in date) is

Line 2891: (p_rec in ben_cop_shd.g_rec_type,

2887: -- ----------------------------------------------------------------------------
2888: -- |---------------------------< delete_validate >----------------------------|
2889: -- ----------------------------------------------------------------------------
2890: Procedure delete_validate
2891: (p_rec in ben_cop_shd.g_rec_type,
2892: p_effective_date in date,
2893: p_datetrack_mode in varchar2,
2894: p_validation_start_date in date,
2895: p_validation_end_date in date) is