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

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

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

Line 124: <> nvl(ben_lct_shd.g_old_rec.tco_chg_enrt_cd,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_tco_chg_enrt_cd
124: <> nvl(ben_lct_shd.g_old_rec.tco_chg_enrt_cd,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_tco_chg_enrt_cd 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_tco_chg_enrt_cd 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 => 'BEN_TCO_CHG_ENRT',
132: p_lookup_code => p_tco_chg_enrt_cd,
133: p_effective_date => p_effective_date) then
134: --

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

191: p_effective_date => p_effective_date,
192: p_object_version_number => p_object_version_number);
193: --
194: if (l_api_updating
195: and nvl(p_enrt_rl,hr_api.g_number)
196: <> ben_lct_shd.g_old_rec.enrt_rl
197: or not l_api_updating)
198: and p_enrt_rl is not null then
199: --

Line 268: <> nvl(ben_lct_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)

264: p_object_version_number => p_object_version_number);
265: --
266: if (l_api_updating
267: and p_enrt_mthd_cd
268: <> nvl(ben_lct_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)
269: or not l_api_updating)
270: and p_enrt_mthd_cd is not null then
271: --
272: -- check if value of lookup falls within lookup type.

Line 274: if hr_api.not_exists_in_hr_lookups

270: and p_enrt_mthd_cd is not null then
271: --
272: -- check if value of lookup falls within lookup type.
273: --
274: if hr_api.not_exists_in_hr_lookups
275: (p_lookup_type => 'BEN_ENRT_MTHD',
276: p_lookup_code => p_enrt_mthd_cd,
277: p_effective_date => p_effective_date) then
278: --

Line 339: <> nvl(ben_lct_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)

335: p_object_version_number => p_object_version_number);
336: --
337: if (l_api_updating
338: and p_enrt_cd
339: <> nvl(ben_lct_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)
340: or not l_api_updating)
341: and p_enrt_cd is not null then
342: --
343: -- check if value of lookup falls within lookup type.

Line 345: if hr_api.not_exists_in_hr_lookups

341: and p_enrt_cd is not null then
342: --
343: -- check if value of lookup falls within lookup type.
344: --
345: if hr_api.not_exists_in_hr_lookups
346: (p_lookup_type => 'BEN_ENRT',
347: p_lookup_code => p_enrt_cd,
348: p_effective_date => p_effective_date) then
349: --

Line 410: and nvl(p_dflt_enrt_rl,hr_api.g_number)

406: p_effective_date => p_effective_date,
407: p_object_version_number => p_object_version_number);
408: --
409: if (l_api_updating
410: and nvl(p_dflt_enrt_rl,hr_api.g_number)
411: <> ben_lct_shd.g_old_rec.dflt_enrt_rl
412: or not l_api_updating)
413: and p_dflt_enrt_rl is not null then
414: --

Line 483: <> nvl(ben_lct_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)

479: p_object_version_number => p_object_version_number);
480: --
481: if (l_api_updating
482: and p_dflt_enrt_cd
483: <> nvl(ben_lct_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)
484: or not l_api_updating)
485: and p_dflt_enrt_cd is not null then
486: --
487: -- check if value of lookup falls within lookup type.

Line 489: if hr_api.not_exists_in_hr_lookups

485: and p_dflt_enrt_cd is not null then
486: --
487: -- check if value of lookup falls within lookup type.
488: --
489: if hr_api.not_exists_in_hr_lookups
490: (p_lookup_type => 'BEN_DFLT_ENRT',
491: p_lookup_code => p_dflt_enrt_cd,
492: p_effective_date => p_effective_date) then
493: --

Line 554: <> nvl(ben_lct_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

550: p_object_version_number => p_object_version_number);
551: --
552: if (l_api_updating
553: and p_dflt_flag
554: <> nvl(ben_lct_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
555: or not l_api_updating) then
556: --
557: -- check if value of lookup falls within lookup type.
558: --

Line 560: if hr_api.not_exists_in_hr_lookups

556: --
557: -- check if value of lookup falls within lookup type.
558: --
559: --
560: if hr_api.not_exists_in_hr_lookups
561: (p_lookup_type => 'YES_NO',
562: p_lookup_code => p_dflt_flag,
563: p_effective_date => p_effective_date) then
564: --

Line 625: <> nvl(ben_lct_shd.g_old_rec.stl_elig_cant_chg_flag,hr_api.g_varchar2)

621: p_object_version_number => p_object_version_number);
622: --
623: if (l_api_updating
624: and p_stl_elig_cant_chg_flag
625: <> nvl(ben_lct_shd.g_old_rec.stl_elig_cant_chg_flag,hr_api.g_varchar2)
626: or not l_api_updating) then
627: --
628: -- check if value of lookup falls within lookup type.
629: --

Line 631: if hr_api.not_exists_in_hr_lookups

627: --
628: -- check if value of lookup falls within lookup type.
629: --
630: --
631: if hr_api.not_exists_in_hr_lookups
632: (p_lookup_type => 'YES_NO',
633: p_lookup_code => p_stl_elig_cant_chg_flag,
634: p_effective_date => p_effective_date) then
635: --

Line 696: <> nvl(ben_lct_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)

692: p_object_version_number => p_object_version_number);
693: --
694: if (l_api_updating
695: and p_crnt_enrt_prclds_chg_flag
696: <> nvl(ben_lct_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)
697: or not l_api_updating) then
698: --
699: -- check if value of lookup falls within lookup type.
700: --

Line 702: if hr_api.not_exists_in_hr_lookups

698: --
699: -- check if value of lookup falls within lookup type.
700: --
701: --
702: if hr_api.not_exists_in_hr_lookups
703: (p_lookup_type => 'YES_NO',
704: p_lookup_code => p_crnt_enrt_prclds_chg_flag,
705: p_effective_date => p_effective_date) then
706: --

Line 752: (p_ptip_id in number default hr_api.g_number,

748: --
749: -- {End Of Comments}
750: -- ----------------------------------------------------------------------------
751: Procedure dt_update_validate
752: (p_ptip_id in number default hr_api.g_number,
753: p_ler_id in number default hr_api.g_number,
754: p_datetrack_mode in varchar2,
755: p_validation_start_date in date,
756: p_validation_end_date in date) Is

Line 753: p_ler_id in number default hr_api.g_number,

749: -- {End Of Comments}
750: -- ----------------------------------------------------------------------------
751: Procedure dt_update_validate
752: (p_ptip_id in number default hr_api.g_number,
753: p_ler_id in number default hr_api.g_number,
754: p_datetrack_mode in varchar2,
755: p_validation_start_date in date,
756: p_validation_end_date in date) Is
757: --

Line 767: hr_api.mandatory_arg_error

763: hr_utility.set_location('Entering:'||l_proc, 5);
764: --
765: -- Ensure that the p_datetrack_mode argument is not null
766: --
767: hr_api.mandatory_arg_error
768: (p_api_name => l_proc,
769: p_argument => 'datetrack_mode',
770: p_argument_value => p_datetrack_mode);
771: --

Line 779: hr_api.mandatory_arg_error

775: --
776: --
777: -- Ensure the arguments are not null
778: --
779: hr_api.mandatory_arg_error
780: (p_api_name => l_proc,
781: p_argument => 'validation_start_date',
782: p_argument_value => p_validation_start_date);
783: --

Line 784: hr_api.mandatory_arg_error

780: (p_api_name => l_proc,
781: p_argument => 'validation_start_date',
782: p_argument_value => p_validation_start_date);
783: --
784: hr_api.mandatory_arg_error
785: (p_api_name => l_proc,
786: p_argument => 'validation_end_date',
787: p_argument_value => p_validation_end_date);
788: --

Line 789: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and

785: (p_api_name => l_proc,
786: p_argument => 'validation_end_date',
787: p_argument_value => p_validation_end_date);
788: --
789: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
790: NOT (dt_api.check_min_max_dates
791: (p_base_table_name => 'ben_ptip_f',
792: p_base_key_column => 'ptip_id',
793: p_base_key_value => p_ptip_id,

Line 799: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and

795: p_to_date => p_validation_end_date))) Then
796: l_table_name := 'ben_ptip_f';
797: Raise l_integrity_error;
798: End If;
799: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and
800: NOT (dt_api.check_min_max_dates
801: (p_base_table_name => 'ben_ler_f',
802: p_base_key_column => 'ler_id',
803: p_base_key_value => p_ler_id,

Line 881: hr_api.mandatory_arg_error

877: hr_utility.set_location('Entering:'||l_proc, 5);
878: --
879: -- Ensure that the p_datetrack_mode argument is not null
880: --
881: hr_api.mandatory_arg_error
882: (p_api_name => l_proc,
883: p_argument => 'datetrack_mode',
884: p_argument_value => p_datetrack_mode);
885: --

Line 895: hr_api.mandatory_arg_error

891: --
892: --
893: -- Ensure the arguments are not null
894: --
895: hr_api.mandatory_arg_error
896: (p_api_name => l_proc,
897: p_argument => 'validation_start_date',
898: p_argument_value => p_validation_start_date);
899: --

Line 900: hr_api.mandatory_arg_error

896: (p_api_name => l_proc,
897: p_argument => 'validation_start_date',
898: p_argument_value => p_validation_start_date);
899: --
900: hr_api.mandatory_arg_error
901: (p_api_name => l_proc,
902: p_argument => 'validation_end_date',
903: p_argument_value => p_validation_end_date);
904: --

Line 905: hr_api.mandatory_arg_error

901: (p_api_name => l_proc,
902: p_argument => 'validation_end_date',
903: p_argument_value => p_validation_end_date);
904: --
905: hr_api.mandatory_arg_error
906: (p_api_name => l_proc,
907: p_argument => 'ler_chg_ptip_enrt_id',
908: p_argument_value => p_ler_chg_ptip_enrt_id);
909: --

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

949: --
950: -- Call all supporting business operations
951: --
952: --
953: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
954: --
955: chk_ler_chg_ptip_enrt_id
956: (p_ler_chg_ptip_enrt_id => p_rec.ler_chg_ptip_enrt_id,
957: p_effective_date => p_effective_date,

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

1033: --
1034: -- Call all supporting business operations
1035: --
1036: --
1037: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1038: --
1039: chk_ler_chg_ptip_enrt_id
1040: (p_ler_chg_ptip_enrt_id => p_rec.ler_chg_ptip_enrt_id,
1041: p_effective_date => p_effective_date,

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

1162: hr_utility.set_location('Entering:'|| l_proc, 10);
1163: --
1164: -- Ensure that all the mandatory parameter are not null
1165: --
1166: hr_api.mandatory_arg_error(p_api_name => l_proc,
1167: p_argument => 'ler_chg_ptip_enrt_id',
1168: p_argument_value => p_ler_chg_ptip_enrt_id);
1169: --
1170: open csr_leg_code;