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 HR_API

Line 55: and nvl(p_oipl_id,hr_api.g_number)

51: p_oipl_id => p_oipl_id,
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: --

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 130: if hr_api.not_exists_in_hr_lookups

126: and p_dflt_flag is not null then
127: --
128: -- check if value of lookup falls within lookup type.
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'YES_NO',
132: p_lookup_code => p_dflt_flag,
133: p_effective_date => p_effective_date) then
134: --

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 200: if hr_api.not_exists_in_hr_lookups

196: and p_mndtry_flag is not null then
197: --
198: -- check if value of lookup falls within lookup type.
199: --
200: if hr_api.not_exists_in_hr_lookups
201: (p_lookup_type => 'YES_NO',
202: p_lookup_code => p_mndtry_flag,
203: p_effective_date => p_effective_date) then
204: --

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 270: if hr_api.not_exists_in_hr_lookups

266: and p_elig_apls_flag is not null then
267: --
268: -- check if value of lookup falls within lookup type.
269: --
270: if hr_api.not_exists_in_hr_lookups
271: (p_lookup_type => 'YES_NO',
272: p_lookup_code => p_elig_apls_flag,
273: p_effective_date => p_effective_date) then
274: --

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 340: if hr_api.not_exists_in_hr_lookups

336: and p_trk_inelig_per_flag is not null then
337: --
338: -- check if value of lookup falls within lookup type.
339: --
340: if hr_api.not_exists_in_hr_lookups
341: (p_lookup_type => 'YES_NO',
342: p_lookup_code => p_trk_inelig_per_flag,
343: p_effective_date => p_effective_date) then
344: --

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 411: if hr_api.not_exists_in_hr_lookups

407: and p_drvbl_fctr_prtn_elig_flag is not null then
408: --
409: -- check if value of lookup falls within lookup type.
410: --
411: if hr_api.not_exists_in_hr_lookups
412: (p_lookup_type => 'YES_NO',
413: p_lookup_code => p_drvbl_fctr_prtn_elig_flag,
414: p_effective_date => p_effective_date) then
415: --

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 482: if hr_api.not_exists_in_hr_lookups

478: and p_prtn_elig_ovrid_alwd_flag is not null then
479: --
480: -- check if value of lookup falls within lookup type.
481: --
482: if hr_api.not_exists_in_hr_lookups
483: (p_lookup_type => 'YES_NO',
484: p_lookup_code => p_prtn_elig_ovrid_alwd_flag,
485: p_effective_date => p_effective_date) then
486: --

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 553: if hr_api.not_exists_in_hr_lookups

549: and p_drvbl_fctr_apls_rts_flag is not null then
550: --
551: -- check if value of lookup falls within lookup type.
552: --
553: if hr_api.not_exists_in_hr_lookups
554: (p_lookup_type => 'YES_NO',
555: p_lookup_code => p_drvbl_fctr_apls_rts_flag,
556: p_effective_date => p_effective_date) then
557: --

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 623: if hr_api.not_exists_in_hr_lookups

619: and p_oipl_stat_cd is not null then
620: --
621: -- check if value of lookup falls within lookup type.
622: --
623: if hr_api.not_exists_in_hr_lookups
624: (p_lookup_type => 'BEN_STAT',
625: p_lookup_code => p_oipl_stat_cd,
626: p_effective_date => p_effective_date) then
627: --

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 693: if hr_api.not_exists_in_hr_lookups

689: and p_pcp_dsgn_cd is not null then
690: --
691: -- check if value of lookup falls within lookup type.
692: --
693: if hr_api.not_exists_in_hr_lookups
694: (p_lookup_type => 'BEN_PCP_DSGN',
695: p_lookup_code => p_pcp_dsgn_cd,
696: p_effective_date => p_effective_date) then
697: --

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 764: if hr_api.not_exists_in_hr_lookups

760: and p_pcp_dpnt_dsgn_cd is not null then
761: --
762: -- check if value of lookup falls within lookup type.
763: --
764: if hr_api.not_exists_in_hr_lookups
765: (p_lookup_type => 'BEN_PCP_DSGN',
766: p_lookup_code => p_pcp_dpnt_dsgn_cd,
767: p_effective_date => p_effective_date) then
768: --

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 834: if hr_api.not_exists_in_hr_lookups

830: and p_auto_enrt_flag is not null then
831: --
832: -- check if value of lookup falls within lookup type.
833: --
834: if hr_api.not_exists_in_hr_lookups
835: (p_lookup_type => 'YES_NO',
836: p_lookup_code => p_auto_enrt_flag,
837: p_effective_date => p_effective_date) then
838: --

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 905: if hr_api.not_exists_in_hr_lookups

901: and p_vrfy_fmly_mmbr_cd is not null then
902: --
903: -- check if value of lookup falls within lookup type.
904: --
905: if hr_api.not_exists_in_hr_lookups
906: (p_lookup_type => 'BEN_FMLY_MMBR',
907: p_lookup_code => p_vrfy_fmly_mmbr_cd,
908: p_effective_date => p_effective_date) then
909: --

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 975: if hr_api.not_exists_in_hr_lookups

971: and p_enrt_cd is not null then
972: --
973: -- check if value of lookup falls within lookup type.
974: --
975: if hr_api.not_exists_in_hr_lookups
976: (p_lookup_type => 'BEN_ENRT',
977: p_lookup_code => p_enrt_cd,
978: p_effective_date => p_effective_date) then
979: --

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 1045: if hr_api.not_exists_in_hr_lookups

1041: and p_dflt_enrt_cd is not null then
1042: --
1043: -- check if value of lookup falls within lookup type.
1044: --
1045: if hr_api.not_exists_in_hr_lookups
1046: (p_lookup_type => 'BEN_DFLT_ENRT',
1047: p_lookup_code => p_dflt_enrt_cd,
1048: p_effective_date => p_effective_date) then
1049: --

Line 1109: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)

1105: p_effective_date => p_effective_date,
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: --

Line 1183: and nvl(p_dflt_enrt_det_rl,hr_api.g_number)

1179: p_effective_date => p_effective_date,
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: --

Line 1255: and nvl(p_mndtry_rl,hr_api.g_number)

1251: p_effective_date => p_effective_date,
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: --

Line 1327: and nvl(p_rqd_perd_enrt_nenrt_rl,hr_api.g_number)

1323: p_effective_date => p_effective_date,
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: --

Line 1399: and nvl(p_postelcn_edit_rl,hr_api.g_number)

1395: p_effective_date => p_effective_date,
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: --

Line 1471: and nvl(p_vrfy_fmly_mmbr_rl,hr_api.g_number)

1467: p_effective_date => p_effective_date,
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: --

Line 1544: and nvl(p_enrt_rl,hr_api.g_number)

1540: p_effective_date => p_effective_date,
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: --

Line 1958: AND cop.oipl_id <> nvl(p_oipl_id, hr_api.g_number)

1954: SELECT NULL
1955: FROM ben_oipl_f cop
1956: WHERE cop.opt_id = p_opt_id
1957: AND cop.pl_id = p_pl_id
1958: AND cop.oipl_id <> nvl(p_oipl_id, hr_api.g_number)
1959: AND cop.business_group_id = p_business_group_id
1960: AND p_validation_start_date <= cop.effective_end_date
1961: AND p_validation_end_date >= cop.effective_start_date
1962: --

Line 1990: and nvl(p_opt_id,hr_api.g_number)

1986: p_effective_date => p_effective_date,
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: --

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 2062: and oipl_id <> nvl(p_oipl_id, hr_api.g_number)

2058: select null
2059: from ben_oipl_f
2060: where ordr_num = p_ordr_num
2061: and pl_id = p_pl_id
2062: and oipl_id <> nvl(p_oipl_id, hr_api.g_number)
2063: and business_group_id + 0 = p_business_group_id
2064: and p_validation_start_date <= effective_end_date
2065: and p_validation_end_date >= effective_start_date;
2066: --

Line 2077: and nvl(p_ordr_num,hr_api.g_number)

2073: p_effective_date => p_effective_date,
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: --

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 2133: (p_dflt_enrt_det_rl in number default hr_api.g_number,

2129: --
2130: -- {End Of Comments}
2131: -- ----------------------------------------------------------------------------
2132: Procedure dt_update_validate
2133: (p_dflt_enrt_det_rl in number default hr_api.g_number,
2134: p_mndtry_rl in number default hr_api.g_number,
2135: p_rqd_perd_enrt_nenrt_rl in number default hr_api.g_number,
2136: p_actl_prem_id in number default hr_api.g_number,
2137: p_pl_id in number default hr_api.g_number,

Line 2134: p_mndtry_rl in number default hr_api.g_number,

2130: -- {End Of Comments}
2131: -- ----------------------------------------------------------------------------
2132: Procedure dt_update_validate
2133: (p_dflt_enrt_det_rl in number default hr_api.g_number,
2134: p_mndtry_rl in number default hr_api.g_number,
2135: p_rqd_perd_enrt_nenrt_rl in number default hr_api.g_number,
2136: p_actl_prem_id in number default hr_api.g_number,
2137: p_pl_id in number default hr_api.g_number,
2138: p_opt_id in number default hr_api.g_number,

Line 2135: p_rqd_perd_enrt_nenrt_rl in number default hr_api.g_number,

2131: -- ----------------------------------------------------------------------------
2132: Procedure dt_update_validate
2133: (p_dflt_enrt_det_rl in number default hr_api.g_number,
2134: p_mndtry_rl in number default hr_api.g_number,
2135: p_rqd_perd_enrt_nenrt_rl in number default hr_api.g_number,
2136: p_actl_prem_id in number default hr_api.g_number,
2137: p_pl_id in number default hr_api.g_number,
2138: p_opt_id in number default hr_api.g_number,
2139: p_datetrack_mode in varchar2,

Line 2136: p_actl_prem_id in number default hr_api.g_number,

2132: Procedure dt_update_validate
2133: (p_dflt_enrt_det_rl in number default hr_api.g_number,
2134: p_mndtry_rl in number default hr_api.g_number,
2135: p_rqd_perd_enrt_nenrt_rl in number default hr_api.g_number,
2136: p_actl_prem_id in number default hr_api.g_number,
2137: p_pl_id in number default hr_api.g_number,
2138: p_opt_id in number default hr_api.g_number,
2139: p_datetrack_mode in varchar2,
2140: p_validation_start_date in date,

Line 2137: p_pl_id in number default hr_api.g_number,

2133: (p_dflt_enrt_det_rl in number default hr_api.g_number,
2134: p_mndtry_rl in number default hr_api.g_number,
2135: p_rqd_perd_enrt_nenrt_rl in number default hr_api.g_number,
2136: p_actl_prem_id in number default hr_api.g_number,
2137: p_pl_id in number default hr_api.g_number,
2138: p_opt_id in number default hr_api.g_number,
2139: p_datetrack_mode in varchar2,
2140: p_validation_start_date in date,
2141: p_validation_end_date in date) Is

Line 2138: p_opt_id in number default hr_api.g_number,

2134: p_mndtry_rl in number default hr_api.g_number,
2135: p_rqd_perd_enrt_nenrt_rl in number default hr_api.g_number,
2136: p_actl_prem_id in number default hr_api.g_number,
2137: p_pl_id in number default hr_api.g_number,
2138: p_opt_id in number default hr_api.g_number,
2139: p_datetrack_mode in varchar2,
2140: p_validation_start_date in date,
2141: p_validation_end_date in date) Is
2142: --

Line 2152: hr_api.mandatory_arg_error

2148: hr_utility.set_location('Entering:'||l_proc, 5);
2149: --
2150: -- Ensure that the p_datetrack_mode argument is not null
2151: --
2152: hr_api.mandatory_arg_error
2153: (p_api_name => l_proc,
2154: p_argument => 'datetrack_mode',
2155: p_argument_value => p_datetrack_mode);
2156: --

Line 2164: hr_api.mandatory_arg_error

2160: --
2161: --
2162: -- Ensure the arguments are not null
2163: --
2164: hr_api.mandatory_arg_error
2165: (p_api_name => l_proc,
2166: p_argument => 'validation_start_date',
2167: p_argument_value => p_validation_start_date);
2168: --

Line 2169: hr_api.mandatory_arg_error

2165: (p_api_name => l_proc,
2166: p_argument => 'validation_start_date',
2167: p_argument_value => p_validation_start_date);
2168: --
2169: hr_api.mandatory_arg_error
2170: (p_api_name => l_proc,
2171: p_argument => 'validation_end_date',
2172: p_argument_value => p_validation_end_date);
2173: --

Line 2174: If ((nvl(p_dflt_enrt_det_rl, hr_api.g_number) <> hr_api.g_number) and

2170: (p_api_name => l_proc,
2171: p_argument => 'validation_end_date',
2172: p_argument_value => p_validation_end_date);
2173: --
2174: If ((nvl(p_dflt_enrt_det_rl, hr_api.g_number) <> hr_api.g_number) and
2175: NOT (dt_api.check_min_max_dates
2176: (p_base_table_name => 'ff_formulas_f',
2177: p_base_key_column => 'formula_id',
2178: p_base_key_value => p_dflt_enrt_det_rl,

Line 2184: If ((nvl(p_mndtry_rl, hr_api.g_number) <> hr_api.g_number) and

2180: p_to_date => p_validation_end_date))) Then
2181: l_table_name := 'ff_formulas_f';
2182: Raise l_integrity_error;
2183: End If;
2184: If ((nvl(p_mndtry_rl, hr_api.g_number) <> hr_api.g_number) and
2185: NOT (dt_api.check_min_max_dates
2186: (p_base_table_name => 'ff_formulas_f',
2187: p_base_key_column => 'formula_id',
2188: p_base_key_value => p_mndtry_rl,

Line 2194: If ((nvl(p_rqd_perd_enrt_nenrt_rl, hr_api.g_number) <> hr_api.g_number) and

2190: p_to_date => p_validation_end_date))) Then
2191: l_table_name := 'ff_formulas_f';
2192: Raise l_integrity_error;
2193: End If;
2194: If ((nvl(p_rqd_perd_enrt_nenrt_rl, hr_api.g_number) <> hr_api.g_number) and
2195: NOT (dt_api.check_min_max_dates
2196: (p_base_table_name => 'ff_formulas_f',
2197: p_base_key_column => 'formula_id',
2198: p_base_key_value => p_rqd_perd_enrt_nenrt_rl,

Line 2204: If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and

2200: p_to_date => p_validation_end_date))) Then
2201: l_table_name := 'ff_formulas_f';
2202: Raise l_integrity_error;
2203: End If;
2204: If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and
2205: NOT (dt_api.check_min_max_dates
2206: (p_base_table_name => 'ben_actl_prem_f',
2207: p_base_key_column => 'actl_prem_id',
2208: p_base_key_value => p_actl_prem_id,

Line 2214: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and

2210: p_to_date => p_validation_end_date))) Then
2211: l_table_name := 'ben_actl_prem_f';
2212: Raise l_integrity_error;
2213: End If;
2214: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
2215: NOT (dt_api.check_min_max_dates
2216: (p_base_table_name => 'ben_pl_f',
2217: p_base_key_column => 'pl_id',
2218: p_base_key_value => p_pl_id,

Line 2224: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and

2220: p_to_date => p_validation_end_date))) Then
2221: l_table_name := 'ben_pl_f';
2222: Raise l_integrity_error;
2223: End If;
2224: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and
2225: NOT (dt_api.check_min_max_dates
2226: (p_base_table_name => 'ben_opt_f',
2227: p_base_key_column => 'opt_id',
2228: p_base_key_value => p_opt_id,

Line 2320: hr_api.mandatory_arg_error

2316: hr_utility.set_location('Entering:'||l_proc, 5);
2317: --
2318: -- Ensure that the p_datetrack_mode argument is not null
2319: --
2320: hr_api.mandatory_arg_error
2321: (p_api_name => l_proc,
2322: p_argument => 'datetrack_mode',
2323: p_argument_value => p_datetrack_mode);
2324: --

Line 2334: hr_api.mandatory_arg_error

2330: --
2331: --
2332: -- Ensure the arguments are not null
2333: --
2334: hr_api.mandatory_arg_error
2335: (p_api_name => l_proc,
2336: p_argument => 'validation_start_date',
2337: p_argument_value => p_validation_start_date);
2338: --

Line 2339: hr_api.mandatory_arg_error

2335: (p_api_name => l_proc,
2336: p_argument => 'validation_start_date',
2337: p_argument_value => p_validation_start_date);
2338: --
2339: hr_api.mandatory_arg_error
2340: (p_api_name => l_proc,
2341: p_argument => 'validation_end_date',
2342: p_argument_value => p_validation_end_date);
2343: --

Line 2344: hr_api.mandatory_arg_error

2340: (p_api_name => l_proc,
2341: p_argument => 'validation_end_date',
2342: p_argument_value => p_validation_end_date);
2343: --
2344: hr_api.mandatory_arg_error
2345: (p_api_name => l_proc,
2346: p_argument => 'oipl_id',
2347: p_argument_value => p_oipl_id);
2348: --

Line 2481: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

2477: -- Call all supporting business operations
2478: --
2479: --
2480: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
2481: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2482: end if;
2483: --
2484: chk_oipl_id
2485: (p_oipl_id => p_rec.oipl_id,

Line 2672: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

2668: -- Call all supporting business operations
2669: --
2670: --
2671: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
2672: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2673: end if;
2674: --
2675: chk_oipl_id
2676: (p_oipl_id => p_rec.oipl_id,

Line 2944: hr_api.mandatory_arg_error(p_api_name => l_proc,

2940: hr_utility.set_location('Entering:'|| l_proc, 10);
2941: --
2942: -- Ensure that all the mandatory parameter are not null
2943: --
2944: hr_api.mandatory_arg_error(p_api_name => l_proc,
2945: p_argument => 'oipl_id',
2946: p_argument_value => p_oipl_id);
2947: --
2948: open csr_leg_code;