DBA Data[Home] [Help]

APPS.PER_RAA_BUS dependencies on PER_RAA_BUS

Line 1: Package Body per_raa_bus as

1: Package Body per_raa_bus as
2: /* $Header: peraarhi.pkb 115.20 2003/11/21 02:05:11 vvayanip ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_raa_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 115: if ( nvl(per_raa_bus.g_recruitment_activity_id, hr_api.g_number)

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

Line 122: l_legislation_code := per_raa_bus.g_legislation_code;

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

Line 146: per_raa_bus.g_recruitment_activity_id := p_recruitment_activity_id;

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

Line 147: per_raa_bus.g_legislation_code := l_legislation_code;

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

Line 1643: per_raa_bus.CHK_NAME(p_name => p_rec.name

1639: --
1640: -- Validate Dependent Attributes
1641: --
1642: hr_utility.set_location(l_proc,10);
1643: per_raa_bus.CHK_NAME(p_name => p_rec.name
1644: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1645: ,p_object_version_number => p_rec.object_version_number);
1646: --
1647: hr_utility.set_location(l_proc,12);

Line 1649: per_raa_bus.CHK_POSTING_CONTENT_ID(

1645: ,p_object_version_number => p_rec.object_version_number);
1646: --
1647: hr_utility.set_location(l_proc,12);
1648: hr_utility.set_location(l_proc,15);
1649: per_raa_bus.CHK_POSTING_CONTENT_ID(
1650: p_posting_content_id => p_rec.posting_content_id
1651: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1652: ,p_object_version_number => p_rec.object_version_number);
1653: --

Line 1655: per_raa_bus.CHK_recruiting_site_id(

1651: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1652: ,p_object_version_number => p_rec.object_version_number);
1653: --
1654: hr_utility.set_location(l_proc,16);
1655: per_raa_bus.CHK_recruiting_site_id(
1656: p_recruiting_site_id => p_rec.recruiting_site_id
1657: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1658: ,p_object_version_number => p_rec.object_version_number);
1659: --

Line 1661: per_raa_bus.CHK_DATES(

1657: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1658: ,p_object_version_number => p_rec.object_version_number);
1659: --
1660: hr_utility.set_location(l_proc,20);
1661: per_raa_bus.CHK_DATES(
1662: p_date_start => p_rec.date_start
1663: ,p_date_end => p_rec.date_end
1664: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1665: ,p_object_version_number => p_rec.object_version_number);

Line 1668: per_raa_bus.CHK_TYPE(

1664: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1665: ,p_object_version_number => p_rec.object_version_number);
1666: --
1667: hr_utility.set_location(l_proc,25);
1668: per_raa_bus.CHK_TYPE(
1669: p_type => p_rec.type
1670: ,p_effective_date => p_rec.date_start
1671: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1672: ,p_object_version_number => p_rec.object_version_number);

Line 1675: per_raa_bus.CHK_DATE_CLOSING(

1671: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1672: ,p_object_version_number => p_rec.object_version_number);
1673: --
1674: hr_utility.set_location(l_proc,40);
1675: per_raa_bus.CHK_DATE_CLOSING(
1676: p_date_closing => p_rec.date_closing
1677: ,p_date_start => p_rec.date_start
1678: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1679: ,p_object_version_number => p_rec.object_version_number);

Line 1682: per_raa_bus.CHK_STATUS(

1678: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1679: ,p_object_version_number => p_rec.object_version_number);
1680: --
1681: hr_utility.set_location(l_proc,45);
1682: per_raa_bus.CHK_STATUS(
1683: p_status => p_rec.status
1684: ,p_effective_date => p_rec.date_start
1685: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1686: ,p_object_version_number => p_rec.object_version_number);

Line 1689: per_raa_bus.CHK_AUTHORISING_PERSON_ID(

1685: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1686: ,p_object_version_number => p_rec.object_version_number);
1687: --
1688: hr_utility.set_location(l_proc,50);
1689: per_raa_bus.CHK_AUTHORISING_PERSON_ID(
1690: p_authorising_person_id => p_rec.authorising_person_id
1691: ,p_date_start => p_rec.date_start
1692: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1693: ,p_object_version_number => p_rec.object_version_number);

Line 1696: per_raa_bus.CHK_RUN_BY_ORGANIZATION_ID(

1692: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1693: ,p_object_version_number => p_rec.object_version_number);
1694: --
1695: hr_utility.set_location(l_proc,55);
1696: per_raa_bus.CHK_RUN_BY_ORGANIZATION_ID(
1697: p_run_by_organization_id => p_rec.run_by_organization_id
1698: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1699: ,p_object_version_number => p_rec.object_version_number);
1700: --

Line 1702: per_raa_bus.CHK_INTERNAL_CONTACT_PERSON_ID(

1698: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1699: ,p_object_version_number => p_rec.object_version_number);
1700: --
1701: hr_utility.set_location(l_proc,60);
1702: per_raa_bus.CHK_INTERNAL_CONTACT_PERSON_ID(
1703: p_internal_contact_person_id =>
1704: p_rec.internal_contact_person_id
1705: ,p_date_start => p_rec.date_start
1706: ,p_recruitment_activity_id => p_rec.recruitment_activity_id

Line 1710: per_raa_bus.CHK_PARENT_RECRUITMENT_ACTIVIT(

1706: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1707: ,p_object_version_number => p_rec.object_version_number);
1708: --
1709: hr_utility.set_location(l_proc,65);
1710: per_raa_bus.CHK_PARENT_RECRUITMENT_ACTIVIT(
1711: p_parent_recruitment_activity
1712: => p_rec.parent_recruitment_activity_id
1713: ,p_date_start => p_rec.date_start
1714: ,p_business_group_id => p_rec.business_group_id

Line 1719: per_raa_bus.CHK_CURRENCY_CODE(

1715: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1716: ,p_object_version_number => p_rec.object_version_number);
1717: --
1718: hr_utility.set_location(l_proc,70);
1719: per_raa_bus.CHK_CURRENCY_CODE(
1720: p_currency_code => p_rec.currency_code
1721: ,p_date_start => p_rec.date_start
1722: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1723: ,p_object_version_number => p_rec.object_version_number);

Line 1726: per_raa_bus.CHK_ACTUAL_COST(

1722: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1723: ,p_object_version_number => p_rec.object_version_number);
1724: --
1725: hr_utility.set_location(l_proc,75);
1726: per_raa_bus.CHK_ACTUAL_COST(
1727: p_actual_cost => p_rec.actual_cost
1728: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1729: ,p_object_version_number => p_rec.object_version_number);
1730: --

Line 1732: per_raa_bus.CHK_PLANNED_COST(

1728: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1729: ,p_object_version_number => p_rec.object_version_number);
1730: --
1731: hr_utility.set_location(l_proc,80);
1732: per_raa_bus.CHK_PLANNED_COST(
1733: p_planned_cost => p_rec.planned_cost
1734: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1735: ,p_object_version_number => p_rec.object_version_number);
1736: --

Line 1738: per_raa_bus.chk_df(p_rec => p_rec);

1734: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1735: ,p_object_version_number => p_rec.object_version_number);
1736: --
1737: hr_utility.set_location(l_proc,85);
1738: per_raa_bus.chk_df(p_rec => p_rec);
1739: --
1740: hr_utility.set_location(' Leaving:'||l_proc, 90);
1741: End insert_validate;
1742: --

Line 1780: per_raa_bus.CHK_NAME(p_name => p_rec.name

1776: (p_rec => p_rec
1777: );
1778: --
1779: hr_utility.set_location(l_proc,10);
1780: per_raa_bus.CHK_NAME(p_name => p_rec.name
1781: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1782: ,p_object_version_number => p_rec.object_version_number);
1783: --
1784: hr_utility.set_location(l_proc,12);

Line 1787: per_raa_bus.CHK_POSTING_CONTENT_ID(

1783: --
1784: hr_utility.set_location(l_proc,12);
1785: --
1786: hr_utility.set_location(l_proc,15);
1787: per_raa_bus.CHK_POSTING_CONTENT_ID(
1788: p_posting_content_id => p_rec.posting_content_id
1789: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1790: ,p_object_version_number => p_rec.object_version_number);
1791: --

Line 1793: per_raa_bus.CHK_recruiting_site_id(

1789: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1790: ,p_object_version_number => p_rec.object_version_number);
1791: --
1792: hr_utility.set_location(l_proc,16);
1793: per_raa_bus.CHK_recruiting_site_id(
1794: p_recruiting_site_id => p_rec.recruiting_site_id
1795: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1796: ,p_object_version_number => p_rec.object_version_number);
1797: hr_utility.set_location(l_proc,20);

Line 1798: per_raa_bus.CHK_DATES(

1794: p_recruiting_site_id => p_rec.recruiting_site_id
1795: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1796: ,p_object_version_number => p_rec.object_version_number);
1797: hr_utility.set_location(l_proc,20);
1798: per_raa_bus.CHK_DATES(
1799: p_date_start => p_rec.date_start
1800: ,p_date_end => p_rec.date_end
1801: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1802: ,p_object_version_number => p_rec.object_version_number);

Line 1805: per_raa_bus.CHK_TYPE(

1801: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1802: ,p_object_version_number => p_rec.object_version_number);
1803: --
1804: hr_utility.set_location(l_proc,25);
1805: per_raa_bus.CHK_TYPE(
1806: p_type => p_rec.type
1807: ,p_effective_date => p_rec.date_start
1808: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1809: ,p_object_version_number => p_rec.object_version_number);

Line 1812: per_raa_bus.CHK_DATE_CLOSING(

1808: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1809: ,p_object_version_number => p_rec.object_version_number);
1810: --
1811: hr_utility.set_location(l_proc,40);
1812: per_raa_bus.CHK_DATE_CLOSING(
1813: p_date_closing => p_rec.date_closing
1814: ,p_date_start => p_rec.date_start
1815: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1816: ,p_object_version_number => p_rec.object_version_number);

Line 1819: per_raa_bus.CHK_STATUS(

1815: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1816: ,p_object_version_number => p_rec.object_version_number);
1817: --
1818: hr_utility.set_location(l_proc,45);
1819: per_raa_bus.CHK_STATUS(
1820: p_status => p_rec.status
1821: ,p_effective_date => p_rec.date_start
1822: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1823: ,p_object_version_number => p_rec.object_version_number);

Line 1826: per_raa_bus.CHK_AUTHORISING_PERSON_ID(

1822: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1823: ,p_object_version_number => p_rec.object_version_number);
1824: --
1825: hr_utility.set_location(l_proc,50);
1826: per_raa_bus.CHK_AUTHORISING_PERSON_ID(
1827: p_authorising_person_id => p_rec.authorising_person_id
1828: ,p_date_start => p_rec.date_start
1829: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1830: ,p_object_version_number => p_rec.object_version_number);

Line 1833: per_raa_bus.CHK_RUN_BY_ORGANIZATION_ID(

1829: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1830: ,p_object_version_number => p_rec.object_version_number);
1831: --
1832: hr_utility.set_location(l_proc,55);
1833: per_raa_bus.CHK_RUN_BY_ORGANIZATION_ID(
1834: p_run_by_organization_id => p_rec.run_by_organization_id
1835: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1836: ,p_object_version_number => p_rec.object_version_number);
1837: --

Line 1839: per_raa_bus.CHK_INTERNAL_CONTACT_PERSON_ID(

1835: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1836: ,p_object_version_number => p_rec.object_version_number);
1837: --
1838: hr_utility.set_location(l_proc,60);
1839: per_raa_bus.CHK_INTERNAL_CONTACT_PERSON_ID(
1840: p_internal_contact_person_id =>
1841: p_rec.internal_contact_person_id
1842: ,p_date_start => p_rec.date_start
1843: ,p_recruitment_activity_id => p_rec.recruitment_activity_id

Line 1847: per_raa_bus.CHK_PARENT_RECRUITMENT_ACTIVIT(

1843: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1844: ,p_object_version_number => p_rec.object_version_number);
1845: --
1846: hr_utility.set_location(l_proc,65);
1847: per_raa_bus.CHK_PARENT_RECRUITMENT_ACTIVIT(
1848: p_parent_recruitment_activity
1849: =>
1850: p_rec.parent_recruitment_activity_id
1851: ,p_date_start => p_rec.date_start

Line 1858: per_raa_bus.CHK_CURRENCY_CODE(

1854: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1855: ,p_object_version_number => p_rec.object_version_number);
1856: --
1857: hr_utility.set_location(l_proc,70);
1858: per_raa_bus.CHK_CURRENCY_CODE(
1859: p_currency_code => p_rec.currency_code
1860: ,p_date_start => p_rec.date_start
1861: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1862: ,p_object_version_number => p_rec.object_version_number);

Line 1865: per_raa_bus.CHK_ACTUAL_COST(

1861: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1862: ,p_object_version_number => p_rec.object_version_number);
1863: --
1864: hr_utility.set_location(l_proc,75);
1865: per_raa_bus.CHK_ACTUAL_COST(
1866: p_actual_cost => p_rec.actual_cost
1867: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1868: ,p_object_version_number => p_rec.object_version_number);
1869: --

Line 1871: per_raa_bus.CHK_PLANNED_COST(

1867: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1868: ,p_object_version_number => p_rec.object_version_number);
1869: --
1870: hr_utility.set_location(l_proc,80);
1871: per_raa_bus.CHK_PLANNED_COST(
1872: p_planned_cost => p_rec.planned_cost
1873: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1874: ,p_object_version_number => p_rec.object_version_number);
1875: --

Line 1877: per_raa_bus.chk_df(p_rec => p_rec);

1873: ,p_recruitment_activity_id => p_rec.recruitment_activity_id
1874: ,p_object_version_number => p_rec.object_version_number);
1875: --
1876: hr_utility.set_location(l_proc,85);
1877: per_raa_bus.chk_df(p_rec => p_rec);
1878: --
1879: hr_utility.set_location(' Leaving:'||l_proc, 90);
1880: End update_validate;
1881: --

Line 1899: end per_raa_bus;

1895: --
1896: hr_utility.set_location(' Leaving:'||l_proc, 10);
1897: End delete_validate;
1898: --
1899: end per_raa_bus;