APPS.BEN_CLP_BUS dependencies on DT_API

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

1509: p_argument_value => p_datetrack_mode);
1510: --
1511: -- Only perform the validation if the datetrack update mode is valid
1512: --
1513: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
1514: --
1515: --
1516: -- Ensure the arguments are not null
1517: --

Line 1529: NOT (dt_api.check_min_max_dates

1525: p_argument => 'validation_end_date',
1526: p_argument_value => p_validation_end_date);
1527: --
1528: If ((nvl(p_ler1_id, hr_api.g_number) <> hr_api.g_number) and
1529: NOT (dt_api.check_min_max_dates
1530: (p_base_table_name => 'ben_ler_f',
1531: p_base_key_column => 'ler_id',
1532: p_base_key_value => p_ler1_id,
1533: p_from_date => p_validation_start_date,

Line 1539: NOT (dt_api.check_min_max_dates

1535: l_table_name := 'ben_ler_f';
1536: Raise l_integrity_error;
1537: End If;
1538: If ((nvl(p_ler2_id, hr_api.g_number) <> hr_api.g_number) and
1539: NOT (dt_api.check_min_max_dates
1540: (p_base_table_name => 'ben_ler_f',
1541: p_base_key_column => 'ler_id',
1542: p_base_key_value => p_ler2_id,
1543: p_from_date => p_validation_start_date,

Line 1549: NOT (dt_api.check_min_max_dates

1545: l_table_name := 'ben_ler_f';
1546: Raise l_integrity_error;
1547: End If;
1548: If ((nvl(p_ler3_id, hr_api.g_number) <> hr_api.g_number) and
1549: NOT (dt_api.check_min_max_dates
1550: (p_base_table_name => 'ben_ler_f',
1551: p_base_key_column => 'ler_id',
1552: p_base_key_value => p_ler3_id,
1553: p_from_date => p_validation_start_date,

Line 1559: NOT (dt_api.check_min_max_dates

1555: l_table_name := 'ben_ler_f';
1556: Raise l_integrity_error;
1557: End If;
1558: If ((nvl(p_ler4_id, hr_api.g_number) <> hr_api.g_number) and
1559: NOT (dt_api.check_min_max_dates
1560: (p_base_table_name => 'ben_ler_f',
1561: p_base_key_column => 'ler_id',
1562: p_base_key_value => p_ler4_id,
1563: p_from_date => p_validation_start_date,

Line 1569: NOT (dt_api.check_min_max_dates

1565: l_table_name := 'ben_ler_f';
1566: Raise l_integrity_error;
1567: End If;
1568: If ((nvl(p_ler5_id, hr_api.g_number) <> hr_api.g_number) and
1569: NOT (dt_api.check_min_max_dates
1570: (p_base_table_name => 'ben_ler_f',
1571: p_base_key_column => 'ler_id',
1572: p_base_key_value => p_ler5_id,
1573: p_from_date => p_validation_start_date,

Line 1579: NOT (dt_api.check_min_max_dates

1575: l_table_name := 'ben_ler_f';
1576: Raise l_integrity_error;
1577: End If;
1578: If ((nvl(p_ler6_id, hr_api.g_number) <> hr_api.g_number) and
1579: NOT (dt_api.check_min_max_dates
1580: (p_base_table_name => 'ben_ler_f',
1581: p_base_key_column => 'ler_id',
1582: p_base_key_value => p_ler6_id,
1583: p_from_date => p_validation_start_date,

Line 1589: NOT (dt_api.check_min_max_dates

1585: l_table_name := 'ben_ler_f';
1586: Raise l_integrity_error;
1587: End If;
1588: If ((nvl(p_ler7_id, hr_api.g_number) <> hr_api.g_number) and
1589: NOT (dt_api.check_min_max_dates
1590: (p_base_table_name => 'ben_ler_f',
1591: p_base_key_column => 'ler_id',
1592: p_base_key_value => p_ler7_id,
1593: p_from_date => p_validation_start_date,

Line 1599: NOT (dt_api.check_min_max_dates

1595: l_table_name := 'ben_ler_f';
1596: Raise l_integrity_error;
1597: End If;
1598: If ((nvl(p_ler8_id, hr_api.g_number) <> hr_api.g_number) and
1599: NOT (dt_api.check_min_max_dates
1600: (p_base_table_name => 'ben_ler_f',
1601: p_base_key_column => 'ler_id',
1602: p_base_key_value => p_ler8_id,
1603: p_from_date => p_validation_start_date,

Line 1609: NOT (dt_api.check_min_max_dates

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

Line 1619: NOT (dt_api.check_min_max_dates

1615: l_table_name := 'ben_ler_f';
1616: Raise l_integrity_error;
1617: End If;
1618: If ((nvl(p_ler10_id, hr_api.g_number) <> hr_api.g_number) and
1619: NOT (dt_api.check_min_max_dates
1620: (p_base_table_name => 'ben_ler_f',
1621: p_base_key_column => 'ler_id',
1622: p_base_key_value => p_ler10_id,
1623: p_from_date => p_validation_start_date,

Line 1629: NOT (dt_api.check_min_max_dates

1625: l_table_name := 'ben_ler_f';
1626: Raise l_integrity_error;
1627: End If;
1628: If ((nvl(p_eval_ler_id, hr_api.g_number) <> hr_api.g_number) and
1629: NOT (dt_api.check_min_max_dates
1630: (p_base_table_name => 'ben_ler_f',
1631: p_base_key_column => 'ler_id',
1632: p_base_key_value => p_eval_ler_id,
1633: p_from_date => p_validation_start_date,

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

1681: -- Processing continues.
1682: --
1683: -- Post Failure:
1684: -- If a row exists by determining the returning Boolean value from the
1685: -- generic dt_api.rows_exist function then we must supply an error via
1686: -- the use of the local exception handler l_rows_exist.
1687: --
1688: -- Developer Implementation Notes:
1689: -- This procedure should not need maintenance unless the HR Schema model