DBA Data[Home] [Help]

APPS.BEN_TCV_BUS dependencies on HR_API

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

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

Line 266: and nvl(p_cvg_vol_det_rl,hr_api.g_number)

262: p_effective_date => p_effective_date,
263: p_object_version_number => p_object_version_number);
264: --
265: if (l_api_updating
266: and nvl(p_cvg_vol_det_rl,hr_api.g_number)
267: <> ben_tcv_shd.g_old_rec.cvg_vol_det_rl
268: or not l_api_updating)
269: and p_cvg_vol_det_rl is not null then
270: --

Line 343: <> nvl(ben_tcv_shd.g_old_rec.cvg_vol_det_cd,hr_api.g_varchar2)

339: p_object_version_number => p_object_version_number);
340: --
341: if (l_api_updating
342: and p_cvg_vol_det_cd
343: <> nvl(ben_tcv_shd.g_old_rec.cvg_vol_det_cd,hr_api.g_varchar2)
344: or not l_api_updating)
345: and p_cvg_vol_det_cd is not null then
346: --
347: -- check if value of lookup falls within lookup type.

Line 349: if hr_api.not_exists_in_hr_lookups

345: and p_cvg_vol_det_cd is not null then
346: --
347: -- check if value of lookup falls within lookup type.
348: --
349: if hr_api.not_exists_in_hr_lookups
350: (p_lookup_type => 'BEN_CVG_DET_DT',
351: p_lookup_code => p_cvg_vol_det_cd,
352: p_effective_date => p_effective_date) then
353: --

Line 414: <> nvl(ben_tcv_shd.g_old_rec.no_mx_cvg_vol_amt_apls_flag,hr_api.g_varchar2)

410: p_object_version_number => p_object_version_number);
411: --
412: if (l_api_updating
413: and p_no_mx_cvg_vol_amt_apls_flag
414: <> nvl(ben_tcv_shd.g_old_rec.no_mx_cvg_vol_amt_apls_flag,hr_api.g_varchar2)
415: or not l_api_updating) then
416: --
417: -- check if value of lookup falls within lookup type.
418: --

Line 420: if hr_api.not_exists_in_hr_lookups

416: --
417: -- check if value of lookup falls within lookup type.
418: --
419: --
420: if hr_api.not_exists_in_hr_lookups
421: (p_lookup_type => 'YES_NO',
422: p_lookup_code => p_no_mx_cvg_vol_amt_apls_flag,
423: p_effective_date => p_effective_date) then
424: --

Line 485: <> nvl(ben_tcv_shd.g_old_rec.no_mn_cvg_vol_amt_apls_flag,hr_api.g_varchar2)

481: p_object_version_number => p_object_version_number);
482: --
483: if (l_api_updating
484: and p_no_mn_cvg_vol_amt_apls_flag
485: <> nvl(ben_tcv_shd.g_old_rec.no_mn_cvg_vol_amt_apls_flag,hr_api.g_varchar2)
486: or not l_api_updating) then
487: --
488: -- check if value of lookup falls within lookup type.
489: --

Line 491: if hr_api.not_exists_in_hr_lookups

487: --
488: -- check if value of lookup falls within lookup type.
489: --
490: --
491: if hr_api.not_exists_in_hr_lookups
492: (p_lookup_type => 'YES_NO',
493: p_lookup_code => p_no_mn_cvg_vol_amt_apls_flag,
494: p_effective_date => p_effective_date) then
495: --

Line 556: <> nvl(ben_tcv_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

552: p_object_version_number => p_object_version_number);
553: --
554: if (l_api_updating
555: and p_excld_flag
556: <> nvl(ben_tcv_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
557: or not l_api_updating) then
558: --
559: -- check if value of lookup falls within lookup type.
560: --

Line 562: if hr_api.not_exists_in_hr_lookups

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

Line 877: (p_vrbl_rt_prfl_id in number default hr_api.g_number,

873: --
874: -- {End Of Comments}
875: -- ----------------------------------------------------------------------------
876: Procedure dt_update_validate
877: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
878: p_datetrack_mode in varchar2,
879: p_validation_start_date in date,
880: p_validation_end_date in date) Is
881: --

Line 891: hr_api.mandatory_arg_error

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

Line 903: hr_api.mandatory_arg_error

899: --
900: --
901: -- Ensure the arguments are not null
902: --
903: hr_api.mandatory_arg_error
904: (p_api_name => l_proc,
905: p_argument => 'validation_start_date',
906: p_argument_value => p_validation_start_date);
907: --

Line 908: hr_api.mandatory_arg_error

904: (p_api_name => l_proc,
905: p_argument => 'validation_start_date',
906: p_argument_value => p_validation_start_date);
907: --
908: hr_api.mandatory_arg_error
909: (p_api_name => l_proc,
910: p_argument => 'validation_end_date',
911: p_argument_value => p_validation_end_date);
912: --

Line 913: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

909: (p_api_name => l_proc,
910: p_argument => 'validation_end_date',
911: p_argument_value => p_validation_end_date);
912: --
913: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
914: NOT (dt_api.check_min_max_dates
915: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
916: p_base_key_column => 'vrbl_rt_prfl_id',
917: p_base_key_value => p_vrbl_rt_prfl_id,

Line 995: hr_api.mandatory_arg_error

991: hr_utility.set_location('Entering:'||l_proc, 5);
992: --
993: -- Ensure that the p_datetrack_mode argument is not null
994: --
995: hr_api.mandatory_arg_error
996: (p_api_name => l_proc,
997: p_argument => 'datetrack_mode',
998: p_argument_value => p_datetrack_mode);
999: --

Line 1009: hr_api.mandatory_arg_error

1005: --
1006: --
1007: -- Ensure the arguments are not null
1008: --
1009: hr_api.mandatory_arg_error
1010: (p_api_name => l_proc,
1011: p_argument => 'validation_start_date',
1012: p_argument_value => p_validation_start_date);
1013: --

Line 1014: hr_api.mandatory_arg_error

1010: (p_api_name => l_proc,
1011: p_argument => 'validation_start_date',
1012: p_argument_value => p_validation_start_date);
1013: --
1014: hr_api.mandatory_arg_error
1015: (p_api_name => l_proc,
1016: p_argument => 'validation_end_date',
1017: p_argument_value => p_validation_end_date);
1018: --

Line 1019: hr_api.mandatory_arg_error

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

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

1063: --
1064: -- Call all supporting business operations
1065: --
1066: --
1067: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1068: --
1069: chk_ttl_cvg_vol_rt_id
1070: (p_ttl_cvg_vol_rt_id => p_rec.ttl_cvg_vol_rt_id,
1071: p_effective_date => p_effective_date,

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

1162: --
1163: -- Call all supporting business operations
1164: --
1165: --
1166: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1167: --
1168: chk_ttl_cvg_vol_rt_id
1169: (p_ttl_cvg_vol_rt_id => p_rec.ttl_cvg_vol_rt_id,
1170: p_effective_date => p_effective_date,

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

1305: hr_utility.set_location('Entering:'|| l_proc, 10);
1306: --
1307: -- Ensure that all the mandatory parameter are not null
1308: --
1309: hr_api.mandatory_arg_error(p_api_name => l_proc,
1310: p_argument => 'ttl_cvg_vol_rt_id',
1311: p_argument_value => p_ttl_cvg_vol_rt_id);
1312: --
1313: open csr_leg_code;