DBA Data[Home] [Help]

APPS.PER_DIS_BUS dependencies on PER_DIS_BUS

Line 1: Package Body per_dis_bus as

1: Package Body per_dis_bus as
2: /* $Header: pedisrhi.pkb 115.8 2002/12/04 18:57:24 pkakar noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' per_dis_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_dis_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --

Line 114: if ( nvl(per_dis_bus.g_disability_id, hr_api.g_number)

110: ,p_argument => 'disability_id'
111: ,p_argument_value => p_disability_id
112: );
113: --
114: if ( nvl(per_dis_bus.g_disability_id, hr_api.g_number)
115: = p_disability_id) then
116: --
117: -- The legislation code has already been found with a previous
118: -- call to this function. Just return the value in the global

Line 121: l_legislation_code := per_dis_bus.g_legislation_code;

117: -- The legislation code has already been found with a previous
118: -- call to this function. Just return the value in the global
119: -- variable.
120: --
121: l_legislation_code := per_dis_bus.g_legislation_code;
122: hr_utility.set_location(l_proc, 20);
123: else
124: --
125: -- The ID is different to the last call to this function

Line 145: per_dis_bus.g_disability_id := p_disability_id;

141: -- Set the global variables so the values are
142: -- available for the next call to this function.
143: --
144: close csr_leg_code;
145: per_dis_bus.g_disability_id := p_disability_id;
146: per_dis_bus.g_legislation_code := l_legislation_code;
147: end if;
148: hr_utility.set_location(' Leaving:'|| l_proc, 40);
149: return l_legislation_code;

Line 146: per_dis_bus.g_legislation_code := l_legislation_code;

142: -- available for the next call to this function.
143: --
144: close csr_leg_code;
145: per_dis_bus.g_disability_id := p_disability_id;
146: per_dis_bus.g_legislation_code := l_legislation_code;
147: end if;
148: hr_utility.set_location(' Leaving:'|| l_proc, 40);
149: return l_legislation_code;
150: end return_legislation_code;

Line 1613: per_dis_bus.chk_person_id

1609: per_per_bus.set_security_group_id(p_person_id => p_rec.person_id);
1610: --
1611: -- Validate PERSON_ID
1612: --
1613: per_dis_bus.chk_person_id
1614: (p_person_id => p_rec.person_id
1615: ,p_effective_date => p_effective_date
1616: );
1617:

Line 1621: per_dis_bus.chk_category

1617:
1618: --
1619: -- Validate CATEGORY
1620: --
1621: per_dis_bus.chk_category
1622: (p_disability_id => p_rec.disability_id
1623: ,p_category => p_rec.category
1624: ,p_effective_date => p_effective_date
1625: ,p_validation_start_date => p_validation_start_date

Line 1632: per_dis_bus.chk_status

1628:
1629: --
1630: -- Validate STATUS
1631: --
1632: per_dis_bus.chk_status
1633: (p_disability_id => p_rec.disability_id
1634: ,p_status => p_rec.status
1635: ,p_effective_date => p_effective_date
1636: ,p_validation_start_date => p_validation_start_date

Line 1642: per_dis_bus.chk_quota_fte

1638: );
1639: --
1640: -- Validate QUOTA_FTE
1641: --
1642: per_dis_bus.chk_quota_fte
1643: (p_quota_fte => p_rec.quota_fte);
1644: --
1645: -- Validate REASON
1646: --

Line 1647: per_dis_bus.chk_reason

1643: (p_quota_fte => p_rec.quota_fte);
1644: --
1645: -- Validate REASON
1646: --
1647: per_dis_bus.chk_reason
1648: (p_disability_id => p_rec.disability_id
1649: ,p_reason => p_rec.reason
1650: ,p_effective_date => p_effective_date
1651: ,p_validation_start_date => p_validation_start_date

Line 1657: per_dis_bus.chk_degree

1653: );
1654: --
1655: -- Validate DEGREE
1656: --
1657: per_dis_bus.chk_degree
1658: (p_degree => p_rec.degree);
1659: --
1660: --
1661: -- Validate INCIDENT_ID

Line 1663: per_dis_bus.chk_incident_id

1659: --
1660: --
1661: -- Validate INCIDENT_ID
1662: --
1663: per_dis_bus.chk_incident_id
1664: (p_disability_id => p_rec.disability_id
1665: ,p_person_id => p_rec.person_id
1666: ,p_effective_date => p_effective_date
1667: ,p_incident_id => p_rec.incident_id

Line 1675: per_dis_bus.chk_organization_id

1671: --
1672: open csr_person;
1673: fetch csr_person into l_business_group_id;
1674: close csr_person;
1675: per_dis_bus.chk_organization_id
1676: (p_disability_id => p_rec.disability_id
1677: ,p_organization_id => p_rec.organization_id
1678: ,p_business_group_id => l_business_group_id
1679: ,p_validation_start_date => p_validation_start_date

Line 1684: per_dis_bus.chk_registration_details

1680: );
1681: --
1682: -- Validate REGISTRATION details
1683: --
1684: per_dis_bus.chk_registration_details
1685: (p_organization_id => p_rec.organization_id
1686: ,p_registration_id => p_rec.registration_id
1687: ,p_registration_date => p_rec.registration_date
1688: ,p_registration_exp_date => p_rec.registration_exp_date

Line 1691: per_dis_bus.chk_ddf(p_rec);

1687: ,p_registration_date => p_rec.registration_date
1688: ,p_registration_exp_date => p_rec.registration_exp_date
1689: );
1690: --
1691: per_dis_bus.chk_ddf(p_rec);
1692: --
1693: per_dis_bus.chk_df(p_rec);
1694: --
1695: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1693: per_dis_bus.chk_df(p_rec);

1689: );
1690: --
1691: per_dis_bus.chk_ddf(p_rec);
1692: --
1693: per_dis_bus.chk_df(p_rec);
1694: --
1695: hr_utility.set_location(' Leaving:'||l_proc, 10);
1696: End insert_validate;
1697: --

Line 1732: per_dis_bus.chk_person_id

1728: );
1729: --
1730: -- Validate PERSON ID
1731: --
1732: per_dis_bus.chk_person_id
1733: (p_person_id => p_rec.person_id
1734: ,p_effective_date => p_effective_date
1735: );
1736: --

Line 1739: per_dis_bus.chk_category

1735: );
1736: --
1737: -- Validate CATEGORY
1738: --
1739: per_dis_bus.chk_category
1740: (p_disability_id => p_rec.disability_id
1741: ,p_category => p_rec.category
1742: ,p_effective_date => p_effective_date
1743: ,p_validation_start_date => p_validation_start_date

Line 1749: per_dis_bus.chk_status

1745: );
1746: --
1747: -- Validate STATUS
1748: --
1749: per_dis_bus.chk_status
1750: (p_disability_id => p_rec.disability_id
1751: ,p_status => p_rec.status
1752: ,p_effective_date => p_effective_date
1753: ,p_validation_start_date => p_validation_start_date

Line 1759: per_dis_bus.chk_quota_fte

1755: );
1756: --
1757: -- Validate QUOTA_FTE
1758: --
1759: per_dis_bus.chk_quota_fte
1760: (p_quota_fte => p_rec.quota_fte);
1761: --
1762: -- Validate REASON
1763: --

Line 1764: per_dis_bus.chk_reason

1760: (p_quota_fte => p_rec.quota_fte);
1761: --
1762: -- Validate REASON
1763: --
1764: per_dis_bus.chk_reason
1765: (p_disability_id => p_rec.disability_id
1766: ,p_reason => p_rec.reason
1767: ,p_effective_date => p_effective_date
1768: ,p_validation_start_date => p_validation_start_date

Line 1774: per_dis_bus.chk_degree

1770: );
1771: --
1772: -- Validate DEGREE
1773: --
1774: per_dis_bus.chk_degree
1775: (p_degree => p_rec.degree);
1776: --
1777: -- Validate INCIDENT_ID
1778: --

Line 1779: per_dis_bus.chk_incident_id

1775: (p_degree => p_rec.degree);
1776: --
1777: -- Validate INCIDENT_ID
1778: --
1779: per_dis_bus.chk_incident_id
1780: (p_disability_id => p_rec.disability_id
1781: ,p_person_id => p_rec.person_id
1782: ,p_effective_date => p_effective_date
1783: ,p_incident_id => p_rec.incident_id

Line 1791: per_dis_bus.chk_organization_id

1787: --
1788: open csr_person;
1789: fetch csr_person into l_business_group_id;
1790: close csr_person;
1791: per_dis_bus.chk_organization_id
1792: (p_disability_id => p_rec.disability_id
1793: ,p_organization_id => p_rec.organization_id
1794: ,p_business_group_id => l_business_group_id
1795: ,p_validation_start_date => p_validation_start_date

Line 1800: per_dis_bus.chk_registration_details

1796: );
1797: --
1798: -- Validate REGISTRATION details
1799: --
1800: per_dis_bus.chk_registration_details
1801: (p_organization_id => p_rec.organization_id
1802: ,p_registration_id => p_rec.registration_id
1803: ,p_registration_date => p_rec.registration_date
1804: ,p_registration_exp_date => p_rec.registration_exp_date

Line 1816: per_dis_bus.chk_ddf(p_rec);

1812: ,p_validation_start_date => p_validation_start_date
1813: ,p_validation_end_date => p_validation_end_date
1814: );
1815: --
1816: per_dis_bus.chk_ddf(p_rec);
1817: --
1818: per_dis_bus.chk_df(p_rec);
1819: --
1820: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1818: per_dis_bus.chk_df(p_rec);

1814: );
1815: --
1816: per_dis_bus.chk_ddf(p_rec);
1817: --
1818: per_dis_bus.chk_df(p_rec);
1819: --
1820: hr_utility.set_location(' Leaving:'||l_proc, 10);
1821: End update_validate;
1822: --

Line 1851: end per_dis_bus;

1847: --
1848: hr_utility.set_location(' Leaving:'||l_proc, 10);
1849: End delete_validate;
1850: --
1851: end per_dis_bus;