APPS.BEN_PRG_BUS dependencies on DT_API

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

808: p_argument_value => p_datetrack_mode);
809: --
810: -- Only perform the validation if the datetrack update mode is valid
811: --
812: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
813: --
814: --
815: -- Ensure the arguments are not null
816: --

Line 828: NOT (dt_api.check_min_max_dates

824: p_argument => 'validation_end_date',
825: p_argument_value => p_validation_end_date);
826: --
827: If ((nvl(p_hghly_compd_det_rl, hr_api.g_number) <> hr_api.g_number) and
828: NOT (dt_api.check_min_max_dates
829: (p_base_table_name => 'ff_formulas_f',
830: p_base_key_column => 'formula_id',
831: p_base_key_value => p_hghly_compd_det_rl,
832: p_from_date => p_validation_start_date,

Line 838: NOT (dt_api.check_min_max_dates

834: l_table_name := 'ff_formulas_f';
835: Raise l_integrity_error;
836: End If;
837: If ((nvl(p_key_ee_det_rl, hr_api.g_number) <> hr_api.g_number) and
838: NOT (dt_api.check_min_max_dates
839: (p_base_table_name => 'ff_formulas_f',
840: p_base_key_column => 'formula_id',
841: p_base_key_value => p_key_ee_det_rl,
842: p_from_date => p_validation_start_date,

Line 848: NOT (dt_api.check_min_max_dates

844: l_table_name := 'ff_formulas_f';
845: Raise l_integrity_error;
846: End If;
847: If ((nvl(p_cntr_nndscrn_rl, hr_api.g_number) <> hr_api.g_number) and
848: NOT (dt_api.check_min_max_dates
849: (p_base_table_name => 'ff_formulas_f',
850: p_base_key_column => 'formula_id',
851: p_base_key_value => p_cntr_nndscrn_rl,
852: p_from_date => p_validation_start_date,

Line 858: NOT (dt_api.check_min_max_dates

854: l_table_name := 'ff_formulas_f';
855: Raise l_integrity_error;
856: End If;
857: If ((nvl(p_cvg_nndscrn_rl, hr_api.g_number) <> hr_api.g_number) and
858: NOT (dt_api.check_min_max_dates
859: (p_base_table_name => 'ff_formulas_f',
860: p_base_key_column => 'formula_id',
861: p_base_key_value => p_cvg_nndscrn_rl,
862: p_from_date => p_validation_start_date,

Line 868: NOT (dt_api.check_min_max_dates

864: l_table_name := 'ff_formulas_f';
865: Raise l_integrity_error;
866: End If;
867: If ((nvl(p_five_pct_ownr_rl, hr_api.g_number) <> hr_api.g_number) and
868: NOT (dt_api.check_min_max_dates
869: (p_base_table_name => 'ff_formulas_f',
870: p_base_key_column => 'formula_id',
871: p_base_key_value => p_five_pct_ownr_rl,
872: p_from_date => p_validation_start_date,

Line 878: NOT (dt_api.check_min_max_dates

874: l_table_name := 'ff_formulas_f';
875: Raise l_integrity_error;
876: End If;
877: If ((nvl(p_regn_id, hr_api.g_number) <> hr_api.g_number) and
878: NOT (dt_api.check_min_max_dates
879: (p_base_table_name => 'ben_regn_f',
880: p_base_key_column => 'regn_id',
881: p_base_key_value => p_regn_id,
882: p_from_date => p_validation_start_date,

Line 888: NOT (dt_api.check_min_max_dates

884: l_table_name := 'ben_regn_f';
885: Raise l_integrity_error;
886: End If;
887: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
888: NOT (dt_api.check_min_max_dates
889: (p_base_table_name => 'ben_pl_f',
890: p_base_key_column => 'pl_id',
891: p_base_key_value => p_pl_id,
892: p_from_date => p_validation_start_date,

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

940: -- Processing continues.
941: --
942: -- Post Failure:
943: -- If a row exists by determining the returning Boolean value from the
944: -- generic dt_api.rows_exist function then we must supply an error via
945: -- the use of the local exception handler l_rows_exist.
946: --
947: -- Developer Implementation Notes:
948: -- This procedure should not need maintenance unless the HR Schema model