APPS.BEN_OPT_BUS dependencies on DT_API

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

903: p_argument_value => p_datetrack_mode);
904: --
905: -- Only perform the validation if the datetrack update mode is valid
906: --
907: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
908: --
909: --
910: -- Ensure the arguments are not null
911: --

Line 923: NOT (dt_api.check_min_max_dates

919: p_argument => 'validation_end_date',
920: p_argument_value => p_validation_end_date);
921: --
922: /* If ((nvl(p_cmbn_ptip_opt_id, hr_api.g_number) <> hr_api.g_number) and
923: NOT (dt_api.check_min_max_dates
924: (p_base_table_name => 'ben_cmbn_ptip_opt_f',
925: p_base_key_column => 'cmbn_ptip_opt_id',
926: p_base_key_value => p_cmbn_ptip_opt_id,
927: p_from_date => p_validation_start_date,

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

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

Line 1034: If (dt_api.rows_exist

1030: (p_api_name => l_proc,
1031: p_argument => 'opt_id',
1032: p_argument_value => p_opt_id);
1033: --
1034: If (dt_api.rows_exist
1035: (p_base_table_name => 'ben_elig_per_opt_f',
1036: p_base_key_column => 'opt_id',
1037: p_base_key_value => p_opt_id,
1038: p_from_date => p_validation_start_date,

Line 1043: If (dt_api.rows_exist

1039: p_to_date => p_validation_end_date)) Then
1040: l_table_name := 'ben_elig_per_opt_f';
1041: Raise l_rows_exist;
1042: End If;
1043: If (dt_api.rows_exist
1044: (p_base_table_name => 'ben_oipl_f',
1045: p_base_key_column => 'opt_id',
1046: p_base_key_value => p_opt_id,
1047: p_from_date => p_validation_start_date,

Line 1052: If (dt_api.rows_exist

1048: p_to_date => p_validation_end_date)) Then
1049: l_table_name := 'ben_oipl_f';
1050: Raise l_rows_exist;
1051: End If;
1052: If (dt_api.rows_exist
1053: (p_base_table_name => 'ben_dsgn_rqmt_f',
1054: p_base_key_column => 'opt_id',
1055: p_base_key_value => p_opt_id,
1056: p_from_date => p_validation_start_date,

Line 1061: If (dt_api.rows_exist

1057: p_to_date => p_validation_end_date)) Then
1058: l_table_name := 'ben_dsgn_rqmt_f';
1059: Raise l_rows_exist;
1060: End If;
1061: If (dt_api.rows_exist
1062: (p_base_table_name => 'ben_pl_typ_opt_typ_f',
1063: p_base_key_column => 'opt_id',
1064: p_base_key_value => p_opt_id,
1065: p_from_date => p_validation_start_date,