DBA Data[Home] [Help]

APPS.BEN_CCT_BUS dependencies on DT_API

Line 902: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then

898: p_argument_value => p_datetrack_mode);
899: --
900: -- Only perform the validation if the datetrack update mode is valid
901: --
902: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
903: --
904: --
905: -- Ensure the arguments are not null
906: --

Line 919: NOT (dt_api.check_min_max_dates

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,
923: p_from_date => p_validation_start_date,

Line 974: -- generic dt_api.rows_exist function then we must supply an error via

970: -- Processing continues.
971: --
972: -- Post Failure:
973: -- If a row exists by determining the returning Boolean value from the
974: -- generic dt_api.rows_exist function then we must supply an error via
975: -- the use of the local exception handler l_rows_exist.
976: --
977: -- Developer Implementation Notes:
978: -- This procedure should not need maintenance unless the HR Schema model

Line 1031: If (dt_api.rows_exist

1027: p_argument => 'cm_typ_id',
1028: p_argument_value => p_cm_typ_id);
1029: --
1030: hr_utility.set_location('*******b4 check rows exist', 5);
1031: If (dt_api.rows_exist
1032: (p_base_table_name => 'ben_cm_typ_f',
1033: p_base_key_column => 'parnt_cm_typ_id',
1034: p_base_key_value => p_cm_typ_id,
1035: p_from_date => p_validation_start_date,

Line 1041: If (dt_api.rows_exist

1037: l_table_name := 'ben_cm_typ_f';
1038: Raise l_rows_exist;
1039: End If;
1040: hr_utility.set_location('*******after check rows exist', 5);
1041: If (dt_api.rows_exist
1042: (p_base_table_name => 'ben_cm_typ_trgr_f',
1043: p_base_key_column => 'cm_typ_id',
1044: p_base_key_value => p_cm_typ_id,
1045: p_from_date => p_validation_start_date,

Line 1050: If (dt_api.rows_exist

1046: p_to_date => p_validation_end_date)) Then
1047: l_table_name := 'ben_cm_typ_trgr_f';
1048: Raise l_rows_exist;
1049: End If;
1050: If (dt_api.rows_exist
1051: (p_base_table_name => 'ben_cm_typ_usg_f',
1052: p_base_key_column => 'cm_typ_id',
1053: p_base_key_value => p_cm_typ_id,
1054: p_from_date => p_validation_start_date,

Line 1059: If (dt_api.rows_exist

1055: p_to_date => p_validation_end_date)) Then
1056: l_table_name := 'ben_cm_typ_usg_f';
1057: Raise l_rows_exist;
1058: End If;
1059: If (dt_api.rows_exist
1060: (p_base_table_name => 'ben_per_cm_f',
1061: p_base_key_column => 'cm_typ_id',
1062: p_base_key_value => p_cm_typ_id,
1063: p_from_date => p_validation_start_date,