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_PRG_BUS dependencies on HR_API

Line 54: and nvl(p_pl_regn_id,hr_api.g_number)

50: p_pl_regn_id => p_pl_regn_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_pl_regn_id,hr_api.g_number)
55: <> ben_prg_shd.g_old_rec.pl_regn_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 199: and nvl(p_rptg_grp_id,hr_api.g_number)

195: p_effective_date => p_effective_date,
196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_rptg_grp_id,hr_api.g_number)
200: <> nvl(ben_prg_shd.g_old_rec.rptg_grp_id,hr_api.g_number)
201: or not l_api_updating) then
202: --
203: -- check if pl_id value exists in ben_rept_grp table

Line 200: <> nvl(ben_prg_shd.g_old_rec.rptg_grp_id,hr_api.g_number)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_rptg_grp_id,hr_api.g_number)
200: <> nvl(ben_prg_shd.g_old_rec.rptg_grp_id,hr_api.g_number)
201: or not l_api_updating) then
202: --
203: -- check if pl_id value exists in ben_rept_grp table
204: --

Line 287: and nvl(p_hghly_compd_det_rl ,hr_api.g_number)

283: p_effective_date => p_effective_date,
284: p_object_version_number => p_object_version_number);
285: --
286: if (l_api_updating
287: and nvl(p_hghly_compd_det_rl ,hr_api.g_number)
288: <> ben_prg_shd.g_old_rec.hghly_compd_det_rl
289: or not l_api_updating)
290: and p_hghly_compd_det_rl is not null then
291: --

Line 379: and nvl(p_key_ee_det_rl ,hr_api.g_number)

375: p_effective_date => p_effective_date,
376: p_object_version_number => p_object_version_number);
377: --
378: if (l_api_updating
379: and nvl(p_key_ee_det_rl ,hr_api.g_number)
380: <> ben_prg_shd.g_old_rec.key_ee_det_rl
381: or not l_api_updating)
382: and p_key_ee_det_rl is not null then
383: --

Line 471: and nvl(p_cntr_nndscrn_rl ,hr_api.g_number)

467: p_effective_date => p_effective_date,
468: p_object_version_number => p_object_version_number);
469: --
470: if (l_api_updating
471: and nvl(p_cntr_nndscrn_rl ,hr_api.g_number)
472: <> ben_prg_shd.g_old_rec.cntr_nndscrn_rl
473: or not l_api_updating)
474: and p_cntr_nndscrn_rl is not null then
475: --

Line 563: and nvl(p_cvg_nndscrn_rl ,hr_api.g_number)

559: p_effective_date => p_effective_date,
560: p_object_version_number => p_object_version_number);
561: --
562: if (l_api_updating
563: and nvl(p_cvg_nndscrn_rl ,hr_api.g_number)
564: <> ben_prg_shd.g_old_rec.cvg_nndscrn_rl
565: or not l_api_updating)
566: and p_cvg_nndscrn_rl is not null then
567: --

Line 655: and nvl(p_five_pct_ownr_rl ,hr_api.g_number)

651: p_effective_date => p_effective_date,
652: p_object_version_number => p_object_version_number);
653: --
654: if (l_api_updating
655: and nvl(p_five_pct_ownr_rl ,hr_api.g_number)
656: <> ben_prg_shd.g_old_rec.five_pct_ownr_rl
657: or not l_api_updating)
658: and p_five_pct_ownr_rl is not null then
659: --

Line 732: <> nvl(ben_prg_shd.g_old_rec.regy_pl_typ_cd,hr_api.g_varchar2)

728: p_object_version_number => p_object_version_number);
729: --
730: if (l_api_updating
731: and p_regy_pl_typ_cd
732: <> nvl(ben_prg_shd.g_old_rec.regy_pl_typ_cd,hr_api.g_varchar2)
733: or not l_api_updating) and p_regy_pl_typ_cd is not null then
734: --
735: -- check if value of lookup falls within lookup type.
736: --

Line 737: if hr_api.not_exists_in_hr_lookups

733: or not l_api_updating) and p_regy_pl_typ_cd is not null then
734: --
735: -- check if value of lookup falls within lookup type.
736: --
737: if hr_api.not_exists_in_hr_lookups
738: (p_lookup_type => 'BEN_REGY_PL_TYP',
739: p_lookup_code => p_regy_pl_typ_cd,
740: p_effective_date => p_effective_date) then
741: --

Line 785: (p_hghly_compd_det_rl in number default hr_api.g_number,

781: --
782: -- {End Of Comments}
783: -- ----------------------------------------------------------------------------
784: Procedure dt_update_validate
785: (p_hghly_compd_det_rl in number default hr_api.g_number,
786: p_key_ee_det_rl in number default hr_api.g_number,
787: p_cntr_nndscrn_rl in number default hr_api.g_number,
788: p_cvg_nndscrn_rl in number default hr_api.g_number,
789: p_five_pct_ownr_rl in number default hr_api.g_number,

Line 786: p_key_ee_det_rl in number default hr_api.g_number,

782: -- {End Of Comments}
783: -- ----------------------------------------------------------------------------
784: Procedure dt_update_validate
785: (p_hghly_compd_det_rl in number default hr_api.g_number,
786: p_key_ee_det_rl in number default hr_api.g_number,
787: p_cntr_nndscrn_rl in number default hr_api.g_number,
788: p_cvg_nndscrn_rl in number default hr_api.g_number,
789: p_five_pct_ownr_rl in number default hr_api.g_number,
790: p_regn_id in number default hr_api.g_number,

Line 787: p_cntr_nndscrn_rl in number default hr_api.g_number,

783: -- ----------------------------------------------------------------------------
784: Procedure dt_update_validate
785: (p_hghly_compd_det_rl in number default hr_api.g_number,
786: p_key_ee_det_rl in number default hr_api.g_number,
787: p_cntr_nndscrn_rl in number default hr_api.g_number,
788: p_cvg_nndscrn_rl in number default hr_api.g_number,
789: p_five_pct_ownr_rl in number default hr_api.g_number,
790: p_regn_id in number default hr_api.g_number,
791: p_pl_id in number default hr_api.g_number,

Line 788: p_cvg_nndscrn_rl in number default hr_api.g_number,

784: Procedure dt_update_validate
785: (p_hghly_compd_det_rl in number default hr_api.g_number,
786: p_key_ee_det_rl in number default hr_api.g_number,
787: p_cntr_nndscrn_rl in number default hr_api.g_number,
788: p_cvg_nndscrn_rl in number default hr_api.g_number,
789: p_five_pct_ownr_rl in number default hr_api.g_number,
790: p_regn_id in number default hr_api.g_number,
791: p_pl_id in number default hr_api.g_number,
792: p_datetrack_mode in varchar2,

Line 789: p_five_pct_ownr_rl in number default hr_api.g_number,

785: (p_hghly_compd_det_rl in number default hr_api.g_number,
786: p_key_ee_det_rl in number default hr_api.g_number,
787: p_cntr_nndscrn_rl in number default hr_api.g_number,
788: p_cvg_nndscrn_rl in number default hr_api.g_number,
789: p_five_pct_ownr_rl in number default hr_api.g_number,
790: p_regn_id in number default hr_api.g_number,
791: p_pl_id in number default hr_api.g_number,
792: p_datetrack_mode in varchar2,
793: p_validation_start_date in date,

Line 790: p_regn_id in number default hr_api.g_number,

786: p_key_ee_det_rl in number default hr_api.g_number,
787: p_cntr_nndscrn_rl in number default hr_api.g_number,
788: p_cvg_nndscrn_rl in number default hr_api.g_number,
789: p_five_pct_ownr_rl in number default hr_api.g_number,
790: p_regn_id in number default hr_api.g_number,
791: p_pl_id in number default hr_api.g_number,
792: p_datetrack_mode in varchar2,
793: p_validation_start_date in date,
794: p_validation_end_date in date) Is

Line 791: p_pl_id in number default hr_api.g_number,

787: p_cntr_nndscrn_rl in number default hr_api.g_number,
788: p_cvg_nndscrn_rl in number default hr_api.g_number,
789: p_five_pct_ownr_rl in number default hr_api.g_number,
790: p_regn_id in number default hr_api.g_number,
791: p_pl_id in number default hr_api.g_number,
792: p_datetrack_mode in varchar2,
793: p_validation_start_date in date,
794: p_validation_end_date in date) Is
795: --

Line 805: hr_api.mandatory_arg_error

801: hr_utility.set_location('Entering:'||l_proc, 5);
802: --
803: -- Ensure that the p_datetrack_mode argument is not null
804: --
805: hr_api.mandatory_arg_error
806: (p_api_name => l_proc,
807: p_argument => 'datetrack_mode',
808: p_argument_value => p_datetrack_mode);
809: --

Line 817: hr_api.mandatory_arg_error

813: --
814: --
815: -- Ensure the arguments are not null
816: --
817: hr_api.mandatory_arg_error
818: (p_api_name => l_proc,
819: p_argument => 'validation_start_date',
820: p_argument_value => p_validation_start_date);
821: --

Line 822: hr_api.mandatory_arg_error

818: (p_api_name => l_proc,
819: p_argument => 'validation_start_date',
820: p_argument_value => p_validation_start_date);
821: --
822: hr_api.mandatory_arg_error
823: (p_api_name => l_proc,
824: p_argument => 'validation_end_date',
825: p_argument_value => p_validation_end_date);
826: --

Line 827: If ((nvl(p_hghly_compd_det_rl, hr_api.g_number) <> hr_api.g_number) and

823: (p_api_name => l_proc,
824: p_argument => 'validation_end_date',
825: p_argument_value => p_validation_end_date);
826: --
827: If ((nvl(p_hghly_compd_det_rl, hr_api.g_number) <> hr_api.g_number) and
828: NOT (dt_api.check_min_max_dates
829: (p_base_table_name => 'ff_formulas_f',
830: p_base_key_column => 'formula_id',
831: p_base_key_value => p_hghly_compd_det_rl,

Line 837: If ((nvl(p_key_ee_det_rl, hr_api.g_number) <> hr_api.g_number) and

833: p_to_date => p_validation_end_date))) Then
834: l_table_name := 'ff_formulas_f';
835: Raise l_integrity_error;
836: End If;
837: If ((nvl(p_key_ee_det_rl, hr_api.g_number) <> hr_api.g_number) and
838: NOT (dt_api.check_min_max_dates
839: (p_base_table_name => 'ff_formulas_f',
840: p_base_key_column => 'formula_id',
841: p_base_key_value => p_key_ee_det_rl,

Line 847: If ((nvl(p_cntr_nndscrn_rl, hr_api.g_number) <> hr_api.g_number) and

843: p_to_date => p_validation_end_date))) Then
844: l_table_name := 'ff_formulas_f';
845: Raise l_integrity_error;
846: End If;
847: If ((nvl(p_cntr_nndscrn_rl, hr_api.g_number) <> hr_api.g_number) and
848: NOT (dt_api.check_min_max_dates
849: (p_base_table_name => 'ff_formulas_f',
850: p_base_key_column => 'formula_id',
851: p_base_key_value => p_cntr_nndscrn_rl,

Line 857: If ((nvl(p_cvg_nndscrn_rl, hr_api.g_number) <> hr_api.g_number) and

853: p_to_date => p_validation_end_date))) Then
854: l_table_name := 'ff_formulas_f';
855: Raise l_integrity_error;
856: End If;
857: If ((nvl(p_cvg_nndscrn_rl, hr_api.g_number) <> hr_api.g_number) and
858: NOT (dt_api.check_min_max_dates
859: (p_base_table_name => 'ff_formulas_f',
860: p_base_key_column => 'formula_id',
861: p_base_key_value => p_cvg_nndscrn_rl,

Line 867: If ((nvl(p_five_pct_ownr_rl, hr_api.g_number) <> hr_api.g_number) and

863: p_to_date => p_validation_end_date))) Then
864: l_table_name := 'ff_formulas_f';
865: Raise l_integrity_error;
866: End If;
867: If ((nvl(p_five_pct_ownr_rl, hr_api.g_number) <> hr_api.g_number) and
868: NOT (dt_api.check_min_max_dates
869: (p_base_table_name => 'ff_formulas_f',
870: p_base_key_column => 'formula_id',
871: p_base_key_value => p_five_pct_ownr_rl,

Line 877: If ((nvl(p_regn_id, hr_api.g_number) <> hr_api.g_number) and

873: p_to_date => p_validation_end_date))) Then
874: l_table_name := 'ff_formulas_f';
875: Raise l_integrity_error;
876: End If;
877: If ((nvl(p_regn_id, hr_api.g_number) <> hr_api.g_number) and
878: NOT (dt_api.check_min_max_dates
879: (p_base_table_name => 'ben_regn_f',
880: p_base_key_column => 'regn_id',
881: p_base_key_value => p_regn_id,

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

883: p_to_date => p_validation_end_date))) Then
884: l_table_name := 'ben_regn_f';
885: Raise l_integrity_error;
886: End If;
887: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
888: NOT (dt_api.check_min_max_dates
889: (p_base_table_name => 'ben_pl_f',
890: p_base_key_column => 'pl_id',
891: p_base_key_value => p_pl_id,

Line 971: hr_api.mandatory_arg_error

967: hr_utility.set_location('Entering:'||l_proc, 5);
968: --
969: -- Ensure that the p_datetrack_mode argument is not null
970: --
971: hr_api.mandatory_arg_error
972: (p_api_name => l_proc,
973: p_argument => 'datetrack_mode',
974: p_argument_value => p_datetrack_mode);
975: --

Line 985: hr_api.mandatory_arg_error

981: --
982: --
983: -- Ensure the arguments are not null
984: --
985: hr_api.mandatory_arg_error
986: (p_api_name => l_proc,
987: p_argument => 'validation_start_date',
988: p_argument_value => p_validation_start_date);
989: --

Line 990: hr_api.mandatory_arg_error

986: (p_api_name => l_proc,
987: p_argument => 'validation_start_date',
988: p_argument_value => p_validation_start_date);
989: --
990: hr_api.mandatory_arg_error
991: (p_api_name => l_proc,
992: p_argument => 'validation_end_date',
993: p_argument_value => p_validation_end_date);
994: --

Line 995: hr_api.mandatory_arg_error

991: (p_api_name => l_proc,
992: p_argument => 'validation_end_date',
993: p_argument_value => p_validation_end_date);
994: --
995: hr_api.mandatory_arg_error
996: (p_api_name => l_proc,
997: p_argument => 'pl_regn_id',
998: p_argument_value => p_pl_regn_id);
999: --

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

1041: --
1042: --CWB Changes
1043: if p_rec.business_group_id is not null then
1044: --
1045: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1046: --
1047: end if;
1048: --
1049: chk_pl_regn_id

Line 1061: hr_api.mandatory_arg_error

1057: p_effective_date => p_effective_date,
1058: p_object_version_number => p_rec.object_version_number);
1059: --
1060: --
1061: hr_api.mandatory_arg_error
1062: (p_api_name => l_proc,
1063: p_argument => 'Regulation',
1064: p_argument_value => p_rec.regn_id);
1065: --

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

1133: --
1134: -- CWB Changes
1135: if p_rec.business_group_id is not null then
1136: --
1137: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1138: --
1139: end if;
1140: --
1141: chk_pl_regn_id

Line 1153: hr_api.mandatory_arg_error

1149: p_effective_date => p_effective_date,
1150: p_object_version_number => p_rec.object_version_number);
1151: --
1152: --
1153: hr_api.mandatory_arg_error
1154: (p_api_name => l_proc,
1155: p_argument => 'Regulation',
1156: p_argument_value => p_rec.regn_id);
1157: --

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

1270: hr_utility.set_location('Entering:'|| l_proc, 10);
1271: --
1272: -- Ensure that all the mandatory parameter are not null
1273: --
1274: hr_api.mandatory_arg_error(p_api_name => l_proc,
1275: p_argument => 'pl_regn_id',
1276: p_argument_value => p_pl_regn_id);
1277: --
1278: open csr_leg_code;