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

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

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

Line 129: and nvl(p_address_id,hr_api.g_number)

125: p_effective_date => p_effective_date,
126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_address_id,hr_api.g_number)
130: <> nvl(ben_pcd_shd.g_old_rec.address_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_address_id is not null then
133: --

Line 130: <> nvl(ben_pcd_shd.g_old_rec.address_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_address_id,hr_api.g_number)
130: <> nvl(ben_pcd_shd.g_old_rec.address_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_address_id is not null then
133: --
134: -- check if address_id value exists in per_addresses table

Line 205: <> nvl(ben_pcd_shd.g_old_rec.to_be_sent_dt,hr_api.g_varchar2)

201: p_object_version_number => p_object_version_number);
202: --
203: if (l_api_updating
204: and p_to_be_sent_dt
205: <> nvl(ben_pcd_shd.g_old_rec.to_be_sent_dt,hr_api.g_varchar2)
206: or not l_api_updating)
207: and p_to_be_sent_dt is not null then
208: --
209: if p_to_be_sent_dt < p_effective_date then

Line 267: <> nvl(ben_pcd_shd.g_old_rec.cm_dlvry_mthd_cd,hr_api.g_varchar2)

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

Line 273: if hr_api.not_exists_in_hr_lookups

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

Line 339: <> nvl(ben_pcd_shd.g_old_rec.cm_dlvry_med_cd,hr_api.g_varchar2)

335: p_object_version_number => p_object_version_number);
336: --
337: if (l_api_updating
338: and p_cm_dlvry_med_cd
339: <> nvl(ben_pcd_shd.g_old_rec.cm_dlvry_med_cd,hr_api.g_varchar2)
340: or not l_api_updating)
341: and p_cm_dlvry_med_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_cm_dlvry_med_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_DLVRY_MED',
347: p_lookup_code => p_cm_dlvry_med_cd,
348: p_effective_date => p_effective_date) then
349: --

Line 410: <> nvl(ben_pcd_shd.g_old_rec.per_cm_prvdd_stat_cd,hr_api.g_varchar2)

406: p_object_version_number => p_object_version_number);
407: --
408: if (l_api_updating
409: and p_per_cm_prvdd_stat_cd
410: <> nvl(ben_pcd_shd.g_old_rec.per_cm_prvdd_stat_cd,hr_api.g_varchar2)
411: or not l_api_updating)
412: and p_per_cm_prvdd_stat_cd is not null then
413: --
414: -- check if value of lookup falls within lookup type.

Line 416: if hr_api.not_exists_in_hr_lookups

412: and p_per_cm_prvdd_stat_cd is not null then
413: --
414: -- check if value of lookup falls within lookup type.
415: --
416: if hr_api.not_exists_in_hr_lookups
417: (p_lookup_type => 'BEN_PER_CM_PRVDD_STAT',
418: p_lookup_code => p_per_cm_prvdd_stat_cd,
419: p_effective_date => p_effective_date) then
420: --

Line 482: <> nvl(ben_pcd_shd.g_old_rec.resnd_rsn_cd,hr_api.g_varchar2)

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

Line 488: if hr_api.not_exists_in_hr_lookups

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

Line 552: <> nvl(ben_pcd_shd.g_old_rec.inspn_rqd_flag,hr_api.g_varchar2)

548: p_object_version_number => p_object_version_number);
549: --
550: if (l_api_updating
551: and p_inspn_rqd_flag
552: <> nvl(ben_pcd_shd.g_old_rec.inspn_rqd_flag,hr_api.g_varchar2)
553: or not l_api_updating) then
554: --
555: -- check if value of lookup falls within lookup type.
556: --

Line 558: if hr_api.not_exists_in_hr_lookups

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

Line 623: <> nvl(ben_pcd_shd.g_old_rec.rqstd_flag,hr_api.g_varchar2)

619: p_object_version_number => p_object_version_number);
620: --
621: if (l_api_updating
622: and p_rqstd_flag
623: <> nvl(ben_pcd_shd.g_old_rec.rqstd_flag,hr_api.g_varchar2)
624: or not l_api_updating) then
625: --
626: -- check if value of lookup falls within lookup type.
627: --

Line 629: if hr_api.not_exists_in_hr_lookups

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

Line 679: (p_per_cm_id in number default hr_api.g_number,

675: --
676: -- {End Of Comments}
677: -- ----------------------------------------------------------------------------
678: Procedure dt_update_validate
679: (p_per_cm_id in number default hr_api.g_number,
680: p_datetrack_mode in varchar2,
681: p_validation_start_date in date,
682: p_validation_end_date in date) Is
683: --

Line 693: hr_api.mandatory_arg_error

689: hr_utility.set_location('Entering:'||l_proc, 5);
690: --
691: -- Ensure that the p_datetrack_mode argument is not null
692: --
693: hr_api.mandatory_arg_error
694: (p_api_name => l_proc,
695: p_argument => 'datetrack_mode',
696: p_argument_value => p_datetrack_mode);
697: --

Line 705: hr_api.mandatory_arg_error

701: --
702: --
703: -- Ensure the arguments are not null
704: --
705: hr_api.mandatory_arg_error
706: (p_api_name => l_proc,
707: p_argument => 'validation_start_date',
708: p_argument_value => p_validation_start_date);
709: --

Line 710: hr_api.mandatory_arg_error

706: (p_api_name => l_proc,
707: p_argument => 'validation_start_date',
708: p_argument_value => p_validation_start_date);
709: --
710: hr_api.mandatory_arg_error
711: (p_api_name => l_proc,
712: p_argument => 'validation_end_date',
713: p_argument_value => p_validation_end_date);
714: --

Line 715: If ((nvl(p_per_cm_id, hr_api.g_number) <> hr_api.g_number) and

711: (p_api_name => l_proc,
712: p_argument => 'validation_end_date',
713: p_argument_value => p_validation_end_date);
714: --
715: If ((nvl(p_per_cm_id, hr_api.g_number) <> hr_api.g_number) and
716: NOT (dt_api.check_min_max_dates
717: (p_base_table_name => 'ben_per_cm_f',
718: p_base_key_column => 'per_cm_id',
719: p_base_key_value => p_per_cm_id,

Line 798: hr_api.mandatory_arg_error

794: hr_utility.set_location('Entering:'||l_proc, 5);
795: --
796: -- Ensure that the p_datetrack_mode argument is not null
797: --
798: hr_api.mandatory_arg_error
799: (p_api_name => l_proc,
800: p_argument => 'datetrack_mode',
801: p_argument_value => p_datetrack_mode);
802: --

Line 812: hr_api.mandatory_arg_error

808: --
809: --
810: -- Ensure the arguments are not null
811: --
812: hr_api.mandatory_arg_error
813: (p_api_name => l_proc,
814: p_argument => 'validation_start_date',
815: p_argument_value => p_validation_start_date);
816: --

Line 817: hr_api.mandatory_arg_error

813: (p_api_name => l_proc,
814: p_argument => 'validation_start_date',
815: p_argument_value => p_validation_start_date);
816: --
817: hr_api.mandatory_arg_error
818: (p_api_name => l_proc,
819: p_argument => 'validation_end_date',
820: p_argument_value => p_validation_end_date);
821: --

Line 822: hr_api.mandatory_arg_error

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

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

864: --
865: -- Call all supporting business operations
866: --
867: --
868: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
869: --
870: chk_per_cm_prvdd_id
871: (p_per_cm_prvdd_id => p_rec.per_cm_prvdd_id,
872: p_effective_date => p_effective_date,

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

946: --
947: -- Call all supporting business operations
948: --
949: --
950: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
951: --
952: chk_per_cm_prvdd_id
953: (p_per_cm_prvdd_id => p_rec.per_cm_prvdd_id,
954: p_effective_date => p_effective_date,

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

1061: hr_utility.set_location('Entering:'|| l_proc, 10);
1062: --
1063: -- Ensure that all the mandatory parameter are not null
1064: --
1065: hr_api.mandatory_arg_error(p_api_name => l_proc,
1066: p_argument => 'per_cm_prvdd_id',
1067: p_argument_value => p_per_cm_prvdd_id);
1068: --
1069: open csr_leg_code;