APPS.BEN_OTP_BUS dependencies on DT_API

Line 609: NOT (dt_api.check_min_max_dates

605: ,p_argument_value => p_validation_end_date
606: );
607: --
608: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
609: NOT (dt_api.check_min_max_dates
610: (p_base_table_name => 'ben_pgm_f'
611: ,p_base_key_column => 'PGM_ID'
612: ,p_base_key_value => p_pgm_id
613: ,p_from_date => p_validation_start_date

Line 619: NOT (dt_api.check_min_max_dates

615: l_table_name := 'pgm';
616: raise l_integrity_error;
617: End If;
618: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
619: NOT (dt_api.check_min_max_dates
620: (p_base_table_name => 'ben_ptip_f'
621: ,p_base_key_column => 'PTIP_ID'
622: ,p_base_key_value => p_ptip_id
623: ,p_from_date => p_validation_start_date

Line 629: NOT (dt_api.check_min_max_dates

625: l_table_name := 'ptip';
626: raise l_integrity_error;
627: End If;
628: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and
629: NOT (dt_api.check_min_max_dates
630: (p_base_table_name => 'ben_opt_f'
631: ,p_base_key_column => 'OPT_ID'
632: ,p_base_key_value => p_opt_id
633: ,p_from_date => p_validation_start_date

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

678: -- Processing continues.
679: --
680: -- Post Failure:
681: -- If a row exists by determining the returning Boolean value from the
682: -- generic dt_api.rows_exist function then we must supply an error via
683: -- the use of the local exception handler l_rows_exist.
684: --
685: -- Developer Implementation Notes:
686: -- This procedure should not need maintenance unless the HR Schema model