APPS.BEN_PEO_BUS dependencies on DT_API

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

1577: p_argument_value => p_datetrack_mode);
1578: --
1579: -- Only perform the validation if the datetrack update mode is valid
1580: --
1581: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
1582: --
1583: --
1584: -- Ensure the arguments are not null
1585: --

Line 1597: NOT (dt_api.check_min_max_dates

1593: p_argument => 'validation_end_date',
1594: p_argument_value => p_validation_end_date);
1595: --
1596: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
1597: NOT (dt_api.check_min_max_dates
1598: (p_base_table_name => 'ben_oipl_f',
1599: p_base_key_column => 'oipl_id',
1600: p_base_key_value => p_oipl_id,
1601: p_from_date => p_validation_start_date,

Line 1607: NOT (dt_api.check_min_max_dates

1603: l_table_name := 'ben_oipl_f';
1604: Raise l_integrity_error;
1605: End If;
1606: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and
1607: NOT (dt_api.check_min_max_dates
1608: (p_base_table_name => 'ben_ler_f',
1609: p_base_key_column => 'ler_id',
1610: p_base_key_value => p_ler_id,
1611: p_from_date => p_validation_start_date,

Line 1617: NOT (dt_api.check_min_max_dates

1613: l_table_name := 'ben_ler_f';
1614: Raise l_integrity_error;
1615: End If;
1616: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
1617: NOT (dt_api.check_min_max_dates
1618: (p_base_table_name => 'ben_pl_f',
1619: p_base_key_column => 'pl_id',
1620: p_base_key_value => p_pl_id,
1621: p_from_date => p_validation_start_date,

Line 1627: NOT (dt_api.check_min_max_dates

1623: l_table_name := 'ben_pl_f';
1624: Raise l_integrity_error;
1625: End If;
1626: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
1627: NOT (dt_api.check_min_max_dates
1628: (p_base_table_name => 'ben_pgm_f',
1629: p_base_key_column => 'pgm_id',
1630: p_base_key_value => p_pgm_id,
1631: p_from_date => p_validation_start_date,

Line 1637: NOT (dt_api.check_min_max_dates

1633: l_table_name := 'ben_pgm_f';
1634: Raise l_integrity_error;
1635: End If;
1636: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
1637: NOT (dt_api.check_min_max_dates
1638: (p_base_table_name => 'ben_ptip_f',
1639: p_base_key_column => 'ptip_id',
1640: p_base_key_value => p_ptip_id,
1641: p_from_date => p_validation_start_date,

Line 1647: NOT (dt_api.check_min_max_dates

1643: l_table_name := 'ben_ptip_f';
1644: Raise l_integrity_error;
1645: End If;
1646: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
1647: NOT (dt_api.check_min_max_dates
1648: (p_base_table_name => 'ben_plip_f',
1649: p_base_key_column => 'plip_id',
1650: p_base_key_value => p_plip_id,
1651: p_from_date => p_validation_start_date,

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

1699: -- Processing continues.
1700: --
1701: -- Post Failure:
1702: -- If a row exists by determining the returning Boolean value from the
1703: -- generic dt_api.rows_exist function then we must supply an error via
1704: -- the use of the local exception handler l_rows_exist.
1705: --
1706: -- Developer Implementation Notes:
1707: -- This procedure should not need maintenance unless the HR Schema model