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

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

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

Line 176: <> nvl(ben_cct_shd.g_old_rec.rcpent_cd,hr_api.g_varchar2)

172: p_object_version_number => p_object_version_number);
173: --
174: if (l_api_updating
175: and p_rcpent_cd
176: <> nvl(ben_cct_shd.g_old_rec.rcpent_cd,hr_api.g_varchar2)
177: or not l_api_updating) then
178: --
179: -- check if value of lookup falls within lookup type.
180: --

Line 182: if p_rcpent_cd is not null and hr_api.not_exists_in_hr_lookups

178: --
179: -- check if value of lookup falls within lookup type.
180: --
181: --
182: if p_rcpent_cd is not null and hr_api.not_exists_in_hr_lookups
183: (p_lookup_type => 'BEN_RCPENT',
184: p_lookup_code => p_rcpent_cd,
185: p_effective_date => p_effective_date) then
186: --

Line 247: and nvl(p_inspn_rqd_rl,hr_api.g_number)

243: p_effective_date => p_effective_date,
244: p_object_version_number => p_object_version_number);
245: --
246: if (l_api_updating
247: and nvl(p_inspn_rqd_rl,hr_api.g_number)
248: <> ben_cct_shd.g_old_rec.inspn_rqd_rl
249: or not l_api_updating)
250: and p_inspn_rqd_rl is not null then
251: --

Line 318: <> nvl(ben_cct_shd.g_old_rec.inspn_rqd_flag,hr_api.g_varchar2)

314: p_object_version_number => p_object_version_number);
315: --
316: if (l_api_updating
317: and p_inspn_rqd_flag
318: <> nvl(ben_cct_shd.g_old_rec.inspn_rqd_flag,hr_api.g_varchar2)
319: or not l_api_updating) then
320: --
321: -- check if value of lookup falls within lookup type.
322: --

Line 323: if hr_api.not_exists_in_hr_lookups

319: or not l_api_updating) then
320: --
321: -- check if value of lookup falls within lookup type.
322: --
323: if hr_api.not_exists_in_hr_lookups
324: (p_lookup_type => 'YES_NO',
325: p_lookup_code => p_inspn_rqd_flag,
326: p_effective_date => p_effective_date) then
327: --

Line 388: and nvl(p_to_be_sent_dt_rl,hr_api.g_number)

384: p_effective_date => p_effective_date,
385: p_object_version_number => p_object_version_number);
386: --
387: if (l_api_updating
388: and nvl(p_to_be_sent_dt_rl,hr_api.g_number)
389: <> ben_cct_shd.g_old_rec.to_be_sent_dt_rl
390: or not l_api_updating)
391: and p_to_be_sent_dt_rl is not null then
392: --

Line 459: <> nvl(ben_cct_shd.g_old_rec.to_be_sent_dt_cd,hr_api.g_varchar2)

455: p_object_version_number => p_object_version_number);
456: --
457: if (l_api_updating
458: and p_to_be_sent_dt_cd
459: <> nvl(ben_cct_shd.g_old_rec.to_be_sent_dt_cd,hr_api.g_varchar2)
460: or not l_api_updating) then
461: --
462: -- check if value of lookup falls within lookup type.
463: --

Line 465: if hr_api.not_exists_in_hr_lookups

461: --
462: -- check if value of lookup falls within lookup type.
463: --
464: --
465: if hr_api.not_exists_in_hr_lookups
466: (p_lookup_type => 'BEN_TO_BE_SENT_DT',
467: p_lookup_code => p_to_be_sent_dt_cd,
468: p_effective_date => p_effective_date) or p_to_be_sent_dt_cd is null
469: then

Line 531: <> nvl(ben_cct_shd.g_old_rec.trk_mlg_flag,hr_api.g_varchar2)

527: p_object_version_number => p_object_version_number);
528: --
529: if (l_api_updating
530: and p_trk_mlg_flag
531: <> nvl(ben_cct_shd.g_old_rec.trk_mlg_flag,hr_api.g_varchar2)
532: or not l_api_updating) then
533: --
534: -- check if value of lookup falls within lookup type.
535: --

Line 537: if hr_api.not_exists_in_hr_lookups

533: --
534: -- check if value of lookup falls within lookup type.
535: --
536: --
537: if hr_api.not_exists_in_hr_lookups
538: (p_lookup_type => 'YES_NO',
539: p_lookup_code => p_trk_mlg_flag,
540: p_effective_date => p_effective_date) then
541: --

Line 602: <> nvl(ben_cct_shd.g_old_rec.pc_kit_cd,hr_api.g_varchar2)

598: p_object_version_number => p_object_version_number);
599: --
600: if (l_api_updating
601: and p_pc_kit_cd
602: <> nvl(ben_cct_shd.g_old_rec.pc_kit_cd,hr_api.g_varchar2)
603: or not l_api_updating)
604: and p_pc_kit_cd is not null then
605: --
606: -- check if value of lookup falls within lookup type.

Line 608: if hr_api.not_exists_in_hr_lookups

604: and p_pc_kit_cd is not null then
605: --
606: -- check if value of lookup falls within lookup type.
607: --
608: if hr_api.not_exists_in_hr_lookups
609: (p_lookup_type => 'BEN_PC_KIT',
610: p_lookup_code => p_pc_kit_cd,
611: p_effective_date => p_effective_date) then
612: --

Line 673: <> nvl(ben_cct_shd.g_old_rec.whnvr_trgrd_flag,hr_api.g_varchar2)

669: p_object_version_number => p_object_version_number);
670: --
671: if (l_api_updating
672: and p_whnvr_trgrd_flag
673: <> nvl(ben_cct_shd.g_old_rec.whnvr_trgrd_flag,hr_api.g_varchar2)
674: or not l_api_updating) then
675: --
676: -- check if value of lookup falls within lookup type.
677: --

Line 679: if hr_api.not_exists_in_hr_lookups

675: --
676: -- check if value of lookup falls within lookup type.
677: --
678: --
679: if hr_api.not_exists_in_hr_lookups
680: (p_lookup_type => 'YES_NO',
681: p_lookup_code => p_whnvr_trgrd_flag,
682: p_effective_date => p_effective_date) then
683: --

Line 745: <> nvl(ben_cct_shd.g_old_rec.cm_usg_cd,hr_api.g_varchar2)

741: p_object_version_number => p_object_version_number);
742: --
743: if (l_api_updating
744: and p_cm_usg_cd
745: <> nvl(ben_cct_shd.g_old_rec.cm_usg_cd,hr_api.g_varchar2)
746: or not l_api_updating)
747: and p_cm_usg_cd is not null then
748: --
749: -- check if value of lookup falls within lookup type.

Line 751: if hr_api.not_exists_in_hr_lookups

747: and p_cm_usg_cd is not null then
748: --
749: -- check if value of lookup falls within lookup type.
750: --
751: if hr_api.not_exists_in_hr_lookups
752: (p_lookup_type => 'BEN_CM_USG',
753: p_lookup_code => p_cm_usg_cd,
754: p_effective_date => p_effective_date) then
755: --

Line 825: and nvl(p_cm_typ_rl,hr_api.g_number)

821: p_effective_date => p_effective_date,
822: p_object_version_number => p_object_version_number);
823: --
824: if (l_api_updating
825: and nvl(p_cm_typ_rl,hr_api.g_number)
826: <> ben_cct_shd.g_old_rec.cm_typ_rl
827: or not l_api_updating)
828: and p_cm_typ_rl is not null then
829: --

Line 881: (p_cm_typ_id in number default hr_api.g_number,

877: --
878: -- {End Of Comments}
879: -- ----------------------------------------------------------------------------
880: Procedure dt_update_validate
881: (p_cm_typ_id in number default hr_api.g_number,
882: p_datetrack_mode in varchar2,
883: p_validation_start_date in date,
884: p_validation_end_date in date) Is
885: --

Line 895: hr_api.mandatory_arg_error

891: hr_utility.set_location('Entering:'||l_proc, 5);
892: --
893: -- Ensure that the p_datetrack_mode argument is not null
894: --
895: hr_api.mandatory_arg_error
896: (p_api_name => l_proc,
897: p_argument => 'datetrack_mode',
898: p_argument_value => p_datetrack_mode);
899: --

Line 907: hr_api.mandatory_arg_error

903: --
904: --
905: -- Ensure the arguments are not null
906: --
907: hr_api.mandatory_arg_error
908: (p_api_name => l_proc,
909: p_argument => 'validation_start_date',
910: p_argument_value => p_validation_start_date);
911: --

Line 912: hr_api.mandatory_arg_error

908: (p_api_name => l_proc,
909: p_argument => 'validation_start_date',
910: p_argument_value => p_validation_start_date);
911: --
912: hr_api.mandatory_arg_error
913: (p_api_name => l_proc,
914: p_argument => 'validation_end_date',
915: p_argument_value => p_validation_end_date);
916: --

Line 918: If ((nvl(p_cm_typ_id, hr_api.g_number) <> hr_api.g_number) and

914: p_argument => 'validation_end_date',
915: p_argument_value => p_validation_end_date);
916: --
917: hr_utility.set_location('*******b4 check min/max dates', 5);
918: If ((nvl(p_cm_typ_id, hr_api.g_number) <> hr_api.g_number) and
919: NOT (dt_api.check_min_max_dates
920: (p_base_table_name => 'ben_cm_typ_f',
921: p_base_key_column => 'cm_typ_id',
922: p_base_key_value => p_cm_typ_id,

Line 1001: hr_api.mandatory_arg_error

997: hr_utility.set_location('Entering:'||l_proc, 5);
998: --
999: -- Ensure that the p_datetrack_mode argument is not null
1000: --
1001: hr_api.mandatory_arg_error
1002: (p_api_name => l_proc,
1003: p_argument => 'datetrack_mode',
1004: p_argument_value => p_datetrack_mode);
1005: --

Line 1015: hr_api.mandatory_arg_error

1011: --
1012: --
1013: -- Ensure the arguments are not null
1014: --
1015: hr_api.mandatory_arg_error
1016: (p_api_name => l_proc,
1017: p_argument => 'validation_start_date',
1018: p_argument_value => p_validation_start_date);
1019: --

Line 1020: hr_api.mandatory_arg_error

1016: (p_api_name => l_proc,
1017: p_argument => 'validation_start_date',
1018: p_argument_value => p_validation_start_date);
1019: --
1020: hr_api.mandatory_arg_error
1021: (p_api_name => l_proc,
1022: p_argument => 'validation_end_date',
1023: p_argument_value => p_validation_end_date);
1024: --

Line 1025: hr_api.mandatory_arg_error

1021: (p_api_name => l_proc,
1022: p_argument => 'validation_end_date',
1023: p_argument_value => p_validation_end_date);
1024: --
1025: hr_api.mandatory_arg_error
1026: (p_api_name => l_proc,
1027: p_argument => 'cm_typ_id',
1028: p_argument_value => p_cm_typ_id);
1029: --

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

1104: --
1105: -- Call all supporting business operations
1106: --
1107: --
1108: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1109: --
1110: chk_cm_typ_id
1111: (p_cm_typ_id => p_rec.cm_typ_id,
1112: p_effective_date => p_effective_date,

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

1201: --
1202: -- Call all supporting business operations
1203: --
1204: --
1205: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1206: --
1207: chk_cm_typ_id
1208: (p_cm_typ_id => p_rec.cm_typ_id,
1209: p_effective_date => p_effective_date,

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

1343: hr_utility.set_location('Entering:'|| l_proc, 10);
1344: --
1345: -- Ensure that all the mandatory parameter are not null
1346: --
1347: hr_api.mandatory_arg_error(p_api_name => l_proc,
1348: p_argument => 'cm_typ_id',
1349: p_argument_value => p_cm_typ_id);
1350: --
1351: open csr_leg_code;