eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_CWK_TERMINATION_SWI dependencies on HR_TRANSACTION_API

Line 1560: hr_transaction_api.get_transaction_step_info(

1556: -- activity. We will update this transaction step with
1557: -- the new information.
1558: ---------------------------------------------------------------------
1559:
1560: hr_transaction_api.get_transaction_step_info(
1561: p_item_type => p_item_type
1562: ,p_item_key => p_item_key
1563: ,p_activity_id => to_number(p_actid)
1564: ,p_transaction_step_id => ltt_trans_step_ids

Line 1575: hr_transaction_api.create_transaction_step (

1571: --------------------------------------------------------------------
1572: -- There is no transaction step for this transaction.
1573: -- Create a step within this new transaction
1574: --------------------------------------------------------------------
1575: hr_transaction_api.create_transaction_step (
1576: p_validate => false,
1577: p_creator_person_id => p_login_person_id,
1578: p_transaction_id => ln_transaction_id,
1579: p_api_name => g_package || 'PROCESS_API',

Line 1626: l_term_date := hr_transaction_api.get_date_value(ln_transaction_step_id, 'P_ACTUAL_TERMINATION_DATE');

1622: end if;
1623:
1624: if (isQKFn = 'Y' and isSupAsgPGExists = 'Y' ) then
1625:
1626: l_term_date := hr_transaction_api.get_date_value(ln_transaction_step_id, 'P_ACTUAL_TERMINATION_DATE');
1627:
1628: l_old_sup_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_PER_ID', true);
1629: l_old_sup_asg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_ASG_ID', true);
1630: l_old_sup_bg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_BG_ID', true);

Line 1758: hr_transaction_api.get_number_value

1754:
1755: hr_utility.set_location(' Entering:' || l_proc, 5);
1756: --
1757: p_person_id :=
1758: hr_transaction_api.get_number_value
1759: (p_transaction_step_id => p_transaction_step_id
1760: ,p_name => 'P_PERSON_ID');
1761: --
1762: p_date_start :=

Line 1763: hr_transaction_api.get_date_value

1759: (p_transaction_step_id => p_transaction_step_id
1760: ,p_name => 'P_PERSON_ID');
1761: --
1762: p_date_start :=
1763: hr_transaction_api.get_date_value
1764: (p_transaction_step_id => p_transaction_step_id
1765: ,p_name => 'P_DATE_START');
1766: --
1767: p_object_version_number :=

Line 1768: hr_transaction_api.get_number_value

1764: (p_transaction_step_id => p_transaction_step_id
1765: ,p_name => 'P_DATE_START');
1766: --
1767: p_object_version_number :=
1768: hr_transaction_api.get_number_value
1769: (p_transaction_step_id => p_transaction_step_id
1770: ,p_name => 'P_OBJECT_VERSION_NUMBER');
1771: --
1772: p_person_type_id :=

Line 1773: hr_transaction_api.get_number_value

1769: (p_transaction_step_id => p_transaction_step_id
1770: ,p_name => 'P_OBJECT_VERSION_NUMBER');
1771: --
1772: p_person_type_id :=
1773: hr_transaction_api.get_number_value
1774: (p_transaction_step_id => p_transaction_step_id
1775: ,p_name => 'P_PERSON_TYPE_ID');
1776: --
1777: -- p_assignment_status_type_id :=

Line 1778: -- hr_transaction_api.get_number_value

1774: (p_transaction_step_id => p_transaction_step_id
1775: ,p_name => 'P_PERSON_TYPE_ID');
1776: --
1777: -- p_assignment_status_type_id :=
1778: -- hr_transaction_api.get_number_value
1779: -- (p_transaction_step_id => p_transaction_step_id
1780: -- ,p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID');
1781: --
1782: p_actual_termination_date :=

Line 1783: hr_transaction_api.get_date_value

1779: -- (p_transaction_step_id => p_transaction_step_id
1780: -- ,p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID');
1781: --
1782: p_actual_termination_date :=
1783: hr_transaction_api.get_date_value
1784: (p_transaction_step_id => p_transaction_step_id
1785: ,p_name => 'P_ACTUAL_TERMINATION_DATE');
1786: --
1787: p_final_process_date :=

Line 1788: hr_transaction_api.get_date_value

1784: (p_transaction_step_id => p_transaction_step_id
1785: ,p_name => 'P_ACTUAL_TERMINATION_DATE');
1786: --
1787: p_final_process_date :=
1788: hr_transaction_api.get_date_value
1789: (p_transaction_step_id => p_transaction_step_id
1790: ,p_name => 'P_FINAL_PROCESS_DATE');
1791: --
1792: p_last_standard_process_date :=

Line 1793: hr_transaction_api.get_date_value

1789: (p_transaction_step_id => p_transaction_step_id
1790: ,p_name => 'P_FINAL_PROCESS_DATE');
1791: --
1792: p_last_standard_process_date :=
1793: hr_transaction_api.get_date_value
1794: (p_transaction_step_id => p_transaction_step_id
1795: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');
1796: --
1797: p_termination_reason :=

Line 1798: hr_transaction_api.get_varchar2_value

1794: (p_transaction_step_id => p_transaction_step_id
1795: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');
1796: --
1797: p_termination_reason :=
1798: hr_transaction_api.get_varchar2_value
1799: (p_transaction_step_id => p_transaction_step_id
1800: ,p_name => 'P_TERMINATION_REASON');
1801: --
1802: p_rehire_recommendation :=

Line 1803: hr_transaction_api.get_varchar2_value

1799: (p_transaction_step_id => p_transaction_step_id
1800: ,p_name => 'P_TERMINATION_REASON');
1801: --
1802: p_rehire_recommendation :=
1803: hr_transaction_api.get_varchar2_value
1804: (p_transaction_step_id => p_transaction_step_id
1805: ,p_name => 'P_REHIRE_RECOMMENDATION');
1806: --
1807: p_rehire_reason :=

Line 1808: hr_transaction_api.get_varchar2_value

1804: (p_transaction_step_id => p_transaction_step_id
1805: ,p_name => 'P_REHIRE_RECOMMENDATION');
1806: --
1807: p_rehire_reason :=
1808: hr_transaction_api.get_varchar2_value
1809: (p_transaction_step_id => p_transaction_step_id
1810: ,p_name => 'P_REHIRE_REASON');
1811: --
1812: p_projected_termination_date :=

Line 1813: hr_transaction_api.get_date_value

1809: (p_transaction_step_id => p_transaction_step_id
1810: ,p_name => 'P_REHIRE_REASON');
1811: --
1812: p_projected_termination_date :=
1813: hr_transaction_api.get_date_value
1814: (p_transaction_step_id => p_transaction_step_id
1815: ,p_name => 'P_PROJECTED_TERMINATION_DATE');
1816: --
1817: p_attribute_category :=

Line 1818: hr_transaction_api.get_varchar2_value

1814: (p_transaction_step_id => p_transaction_step_id
1815: ,p_name => 'P_PROJECTED_TERMINATION_DATE');
1816: --
1817: p_attribute_category :=
1818: hr_transaction_api.get_varchar2_value
1819: (p_transaction_step_id => p_transaction_step_id
1820: ,p_name => 'P_ATTRIBUTE_CATEGORY');
1821: --
1822: p_attribute1 :=

Line 1823: hr_transaction_api.get_varchar2_value

1819: (p_transaction_step_id => p_transaction_step_id
1820: ,p_name => 'P_ATTRIBUTE_CATEGORY');
1821: --
1822: p_attribute1 :=
1823: hr_transaction_api.get_varchar2_value
1824: (p_transaction_step_id => p_transaction_step_id
1825: ,p_name => 'P_ATTRIBUTE1');
1826: --
1827: p_attribute2 :=

Line 1828: hr_transaction_api.get_varchar2_value

1824: (p_transaction_step_id => p_transaction_step_id
1825: ,p_name => 'P_ATTRIBUTE1');
1826: --
1827: p_attribute2 :=
1828: hr_transaction_api.get_varchar2_value
1829: (p_transaction_step_id => p_transaction_step_id
1830: ,p_name => 'P_ATTRIBUTE2');
1831: --
1832: p_attribute3 :=

Line 1833: hr_transaction_api.get_varchar2_value

1829: (p_transaction_step_id => p_transaction_step_id
1830: ,p_name => 'P_ATTRIBUTE2');
1831: --
1832: p_attribute3 :=
1833: hr_transaction_api.get_varchar2_value
1834: (p_transaction_step_id => p_transaction_step_id
1835: ,p_name => 'P_ATTRIBUTE3');
1836: --
1837: p_attribute4 :=

Line 1838: hr_transaction_api.get_varchar2_value

1834: (p_transaction_step_id => p_transaction_step_id
1835: ,p_name => 'P_ATTRIBUTE3');
1836: --
1837: p_attribute4 :=
1838: hr_transaction_api.get_varchar2_value
1839: (p_transaction_step_id => p_transaction_step_id
1840: ,p_name => 'P_ATTRIBUTE4');
1841: --
1842: p_attribute5 :=

Line 1843: hr_transaction_api.get_varchar2_value

1839: (p_transaction_step_id => p_transaction_step_id
1840: ,p_name => 'P_ATTRIBUTE4');
1841: --
1842: p_attribute5 :=
1843: hr_transaction_api.get_varchar2_value
1844: (p_transaction_step_id => p_transaction_step_id
1845: ,p_name => 'P_ATTRIBUTE5');
1846: --
1847: p_attribute6 :=

Line 1848: hr_transaction_api.get_varchar2_value

1844: (p_transaction_step_id => p_transaction_step_id
1845: ,p_name => 'P_ATTRIBUTE5');
1846: --
1847: p_attribute6 :=
1848: hr_transaction_api.get_varchar2_value
1849: (p_transaction_step_id => p_transaction_step_id
1850: ,p_name => 'P_ATTRIBUTE6');
1851: --
1852: p_attribute7 :=

Line 1853: hr_transaction_api.get_varchar2_value

1849: (p_transaction_step_id => p_transaction_step_id
1850: ,p_name => 'P_ATTRIBUTE6');
1851: --
1852: p_attribute7 :=
1853: hr_transaction_api.get_varchar2_value
1854: (p_transaction_step_id => p_transaction_step_id
1855: ,p_name => 'P_ATTRIBUTE7');
1856: --
1857: p_attribute8 :=

Line 1858: hr_transaction_api.get_varchar2_value

1854: (p_transaction_step_id => p_transaction_step_id
1855: ,p_name => 'P_ATTRIBUTE7');
1856: --
1857: p_attribute8 :=
1858: hr_transaction_api.get_varchar2_value
1859: (p_transaction_step_id => p_transaction_step_id
1860: ,p_name => 'P_ATTRIBUTE8');
1861: --
1862: p_attribute9 :=

Line 1863: hr_transaction_api.get_varchar2_value

1859: (p_transaction_step_id => p_transaction_step_id
1860: ,p_name => 'P_ATTRIBUTE8');
1861: --
1862: p_attribute9 :=
1863: hr_transaction_api.get_varchar2_value
1864: (p_transaction_step_id => p_transaction_step_id
1865: ,p_name => 'P_ATTRIBUTE9');
1866: --
1867: p_attribute10 :=

Line 1868: hr_transaction_api.get_varchar2_value

1864: (p_transaction_step_id => p_transaction_step_id
1865: ,p_name => 'P_ATTRIBUTE9');
1866: --
1867: p_attribute10 :=
1868: hr_transaction_api.get_varchar2_value
1869: (p_transaction_step_id => p_transaction_step_id
1870: ,p_name => 'P_ATTRIBUTE10');
1871: --
1872: p_attribute11 :=

Line 1873: hr_transaction_api.get_varchar2_value

1869: (p_transaction_step_id => p_transaction_step_id
1870: ,p_name => 'P_ATTRIBUTE10');
1871: --
1872: p_attribute11 :=
1873: hr_transaction_api.get_varchar2_value
1874: (p_transaction_step_id => p_transaction_step_id
1875: ,p_name => 'P_ATTRIBUTE11');
1876: --
1877: p_attribute12 :=

Line 1878: hr_transaction_api.get_varchar2_value

1874: (p_transaction_step_id => p_transaction_step_id
1875: ,p_name => 'P_ATTRIBUTE11');
1876: --
1877: p_attribute12 :=
1878: hr_transaction_api.get_varchar2_value
1879: (p_transaction_step_id => p_transaction_step_id
1880: ,p_name => 'P_ATTRIBUTE12');
1881: --
1882: p_attribute13 :=

Line 1883: hr_transaction_api.get_varchar2_value

1879: (p_transaction_step_id => p_transaction_step_id
1880: ,p_name => 'P_ATTRIBUTE12');
1881: --
1882: p_attribute13 :=
1883: hr_transaction_api.get_varchar2_value
1884: (p_transaction_step_id => p_transaction_step_id
1885: ,p_name => 'P_ATTRIBUTE13');
1886: --
1887: p_attribute14 :=

Line 1888: hr_transaction_api.get_varchar2_value

1884: (p_transaction_step_id => p_transaction_step_id
1885: ,p_name => 'P_ATTRIBUTE13');
1886: --
1887: p_attribute14 :=
1888: hr_transaction_api.get_varchar2_value
1889: (p_transaction_step_id => p_transaction_step_id
1890: ,p_name => 'P_ATTRIBUTE14');
1891: --
1892: p_attribute15 :=

Line 1893: hr_transaction_api.get_varchar2_value

1889: (p_transaction_step_id => p_transaction_step_id
1890: ,p_name => 'P_ATTRIBUTE14');
1891: --
1892: p_attribute15 :=
1893: hr_transaction_api.get_varchar2_value
1894: (p_transaction_step_id => p_transaction_step_id
1895: ,p_name => 'P_ATTRIBUTE15');
1896: --
1897: p_attribute16 :=

Line 1898: hr_transaction_api.get_varchar2_value

1894: (p_transaction_step_id => p_transaction_step_id
1895: ,p_name => 'P_ATTRIBUTE15');
1896: --
1897: p_attribute16 :=
1898: hr_transaction_api.get_varchar2_value
1899: (p_transaction_step_id => p_transaction_step_id
1900: ,p_name => 'P_ATTRIBUTE16');
1901: --
1902: p_attribute17 :=

Line 1903: hr_transaction_api.get_varchar2_value

1899: (p_transaction_step_id => p_transaction_step_id
1900: ,p_name => 'P_ATTRIBUTE16');
1901: --
1902: p_attribute17 :=
1903: hr_transaction_api.get_varchar2_value
1904: (p_transaction_step_id => p_transaction_step_id
1905: ,p_name => 'P_ATTRIBUTE17');
1906: --
1907: p_attribute18 :=

Line 1908: hr_transaction_api.get_varchar2_value

1904: (p_transaction_step_id => p_transaction_step_id
1905: ,p_name => 'P_ATTRIBUTE17');
1906: --
1907: p_attribute18 :=
1908: hr_transaction_api.get_varchar2_value
1909: (p_transaction_step_id => p_transaction_step_id
1910: ,p_name => 'P_ATTRIBUTE18');
1911: --
1912: p_attribute19 :=

Line 1913: hr_transaction_api.get_varchar2_value

1909: (p_transaction_step_id => p_transaction_step_id
1910: ,p_name => 'P_ATTRIBUTE18');
1911: --
1912: p_attribute19 :=
1913: hr_transaction_api.get_varchar2_value
1914: (p_transaction_step_id => p_transaction_step_id
1915: ,p_name => 'P_ATTRIBUTE19');
1916: --
1917: p_attribute20 :=

Line 1918: hr_transaction_api.get_varchar2_value

1914: (p_transaction_step_id => p_transaction_step_id
1915: ,p_name => 'P_ATTRIBUTE19');
1916: --
1917: p_attribute20 :=
1918: hr_transaction_api.get_varchar2_value
1919: (p_transaction_step_id => p_transaction_step_id
1920: ,p_name => 'P_ATTRIBUTE20');
1921: --
1922: p_attribute21 :=

Line 1923: hr_transaction_api.get_varchar2_value

1919: (p_transaction_step_id => p_transaction_step_id
1920: ,p_name => 'P_ATTRIBUTE20');
1921: --
1922: p_attribute21 :=
1923: hr_transaction_api.get_varchar2_value
1924: (p_transaction_step_id => p_transaction_step_id
1925: ,p_name => 'P_ATTRIBUTE21');
1926: --
1927: p_attribute22 :=

Line 1928: hr_transaction_api.get_varchar2_value

1924: (p_transaction_step_id => p_transaction_step_id
1925: ,p_name => 'P_ATTRIBUTE21');
1926: --
1927: p_attribute22 :=
1928: hr_transaction_api.get_varchar2_value
1929: (p_transaction_step_id => p_transaction_step_id
1930: ,p_name => 'P_ATTRIBUTE22');
1931: --
1932: p_attribute23 :=

Line 1933: hr_transaction_api.get_varchar2_value

1929: (p_transaction_step_id => p_transaction_step_id
1930: ,p_name => 'P_ATTRIBUTE22');
1931: --
1932: p_attribute23 :=
1933: hr_transaction_api.get_varchar2_value
1934: (p_transaction_step_id => p_transaction_step_id
1935: ,p_name => 'P_ATTRIBUTE23');
1936: --
1937: p_attribute24 :=

Line 1938: hr_transaction_api.get_varchar2_value

1934: (p_transaction_step_id => p_transaction_step_id
1935: ,p_name => 'P_ATTRIBUTE23');
1936: --
1937: p_attribute24 :=
1938: hr_transaction_api.get_varchar2_value
1939: (p_transaction_step_id => p_transaction_step_id
1940: ,p_name => 'P_ATTRIBUTE24');
1941: --
1942: p_attribute25 :=

Line 1943: hr_transaction_api.get_varchar2_value

1939: (p_transaction_step_id => p_transaction_step_id
1940: ,p_name => 'P_ATTRIBUTE24');
1941: --
1942: p_attribute25 :=
1943: hr_transaction_api.get_varchar2_value
1944: (p_transaction_step_id => p_transaction_step_id
1945: ,p_name => 'P_ATTRIBUTE25');
1946: --
1947: p_attribute26 :=

Line 1948: hr_transaction_api.get_varchar2_value

1944: (p_transaction_step_id => p_transaction_step_id
1945: ,p_name => 'P_ATTRIBUTE25');
1946: --
1947: p_attribute26 :=
1948: hr_transaction_api.get_varchar2_value
1949: (p_transaction_step_id => p_transaction_step_id
1950: ,p_name => 'P_ATTRIBUTE26');
1951: --
1952: p_attribute27 :=

Line 1953: hr_transaction_api.get_varchar2_value

1949: (p_transaction_step_id => p_transaction_step_id
1950: ,p_name => 'P_ATTRIBUTE26');
1951: --
1952: p_attribute27 :=
1953: hr_transaction_api.get_varchar2_value
1954: (p_transaction_step_id => p_transaction_step_id
1955: ,p_name => 'P_ATTRIBUTE27');
1956: --
1957: p_attribute28 :=

Line 1958: hr_transaction_api.get_varchar2_value

1954: (p_transaction_step_id => p_transaction_step_id
1955: ,p_name => 'P_ATTRIBUTE27');
1956: --
1957: p_attribute28 :=
1958: hr_transaction_api.get_varchar2_value
1959: (p_transaction_step_id => p_transaction_step_id
1960: ,p_name => 'P_ATTRIBUTE28');
1961: --
1962: p_attribute29 :=

Line 1963: hr_transaction_api.get_varchar2_value

1959: (p_transaction_step_id => p_transaction_step_id
1960: ,p_name => 'P_ATTRIBUTE28');
1961: --
1962: p_attribute29 :=
1963: hr_transaction_api.get_varchar2_value
1964: (p_transaction_step_id => p_transaction_step_id
1965: ,p_name => 'P_ATTRIBUTE29');
1966: --
1967: p_attribute30 :=

Line 1968: hr_transaction_api.get_varchar2_value

1964: (p_transaction_step_id => p_transaction_step_id
1965: ,p_name => 'P_ATTRIBUTE29');
1966: --
1967: p_attribute30 :=
1968: hr_transaction_api.get_varchar2_value
1969: (p_transaction_step_id => p_transaction_step_id
1970: ,p_name => 'P_ATTRIBUTE30');
1971: --
1972: p_information_category :=

Line 1973: hr_transaction_api.get_varchar2_value

1969: (p_transaction_step_id => p_transaction_step_id
1970: ,p_name => 'P_ATTRIBUTE30');
1971: --
1972: p_information_category :=
1973: hr_transaction_api.get_varchar2_value
1974: (p_transaction_step_id => p_transaction_step_id
1975: ,p_name => 'P_INFORMATION_CATEGORY');
1976: --
1977: p_information1 :=

Line 1978: hr_transaction_api.get_varchar2_value

1974: (p_transaction_step_id => p_transaction_step_id
1975: ,p_name => 'P_INFORMATION_CATEGORY');
1976: --
1977: p_information1 :=
1978: hr_transaction_api.get_varchar2_value
1979: (p_transaction_step_id => p_transaction_step_id
1980: ,p_name => 'P_INFORMATION1');
1981: --
1982: p_information2 :=

Line 1983: hr_transaction_api.get_varchar2_value

1979: (p_transaction_step_id => p_transaction_step_id
1980: ,p_name => 'P_INFORMATION1');
1981: --
1982: p_information2 :=
1983: hr_transaction_api.get_varchar2_value
1984: (p_transaction_step_id => p_transaction_step_id
1985: ,p_name => 'P_INFORMATION2');
1986: --
1987: p_information3 :=

Line 1988: hr_transaction_api.get_varchar2_value

1984: (p_transaction_step_id => p_transaction_step_id
1985: ,p_name => 'P_INFORMATION2');
1986: --
1987: p_information3 :=
1988: hr_transaction_api.get_varchar2_value
1989: (p_transaction_step_id => p_transaction_step_id
1990: ,p_name => 'P_INFORMATION3');
1991: --
1992: p_information4 :=

Line 1993: hr_transaction_api.get_varchar2_value

1989: (p_transaction_step_id => p_transaction_step_id
1990: ,p_name => 'P_INFORMATION3');
1991: --
1992: p_information4 :=
1993: hr_transaction_api.get_varchar2_value
1994: (p_transaction_step_id => p_transaction_step_id
1995: ,p_name => 'P_INFORMATION4');
1996: --
1997: p_information5 :=

Line 1998: hr_transaction_api.get_varchar2_value

1994: (p_transaction_step_id => p_transaction_step_id
1995: ,p_name => 'P_INFORMATION4');
1996: --
1997: p_information5 :=
1998: hr_transaction_api.get_varchar2_value
1999: (p_transaction_step_id => p_transaction_step_id
2000: ,p_name => 'P_INFORMATION5');
2001: --
2002: p_information6 :=

Line 2003: hr_transaction_api.get_varchar2_value

1999: (p_transaction_step_id => p_transaction_step_id
2000: ,p_name => 'P_INFORMATION5');
2001: --
2002: p_information6 :=
2003: hr_transaction_api.get_varchar2_value
2004: (p_transaction_step_id => p_transaction_step_id
2005: ,p_name => 'P_INFORMATION6');
2006: --
2007: p_information7 :=

Line 2008: hr_transaction_api.get_varchar2_value

2004: (p_transaction_step_id => p_transaction_step_id
2005: ,p_name => 'P_INFORMATION6');
2006: --
2007: p_information7 :=
2008: hr_transaction_api.get_varchar2_value
2009: (p_transaction_step_id => p_transaction_step_id
2010: ,p_name => 'P_INFORMATION7');
2011: --
2012: p_information8 :=

Line 2013: hr_transaction_api.get_varchar2_value

2009: (p_transaction_step_id => p_transaction_step_id
2010: ,p_name => 'P_INFORMATION7');
2011: --
2012: p_information8 :=
2013: hr_transaction_api.get_varchar2_value
2014: (p_transaction_step_id => p_transaction_step_id
2015: ,p_name => 'P_INFORMATION8');
2016: --
2017: p_information9 :=

Line 2018: hr_transaction_api.get_varchar2_value

2014: (p_transaction_step_id => p_transaction_step_id
2015: ,p_name => 'P_INFORMATION8');
2016: --
2017: p_information9 :=
2018: hr_transaction_api.get_varchar2_value
2019: (p_transaction_step_id => p_transaction_step_id
2020: ,p_name => 'P_INFORMATION9');
2021: --
2022: p_information10 :=

Line 2023: hr_transaction_api.get_varchar2_value

2019: (p_transaction_step_id => p_transaction_step_id
2020: ,p_name => 'P_INFORMATION9');
2021: --
2022: p_information10 :=
2023: hr_transaction_api.get_varchar2_value
2024: (p_transaction_step_id => p_transaction_step_id
2025: ,p_name => 'P_INFORMATION10');
2026: --
2027: p_information11 :=

Line 2028: hr_transaction_api.get_varchar2_value

2024: (p_transaction_step_id => p_transaction_step_id
2025: ,p_name => 'P_INFORMATION10');
2026: --
2027: p_information11 :=
2028: hr_transaction_api.get_varchar2_value
2029: (p_transaction_step_id => p_transaction_step_id
2030: ,p_name => 'P_INFORMATION11');
2031: --
2032: p_information12 :=

Line 2033: hr_transaction_api.get_varchar2_value

2029: (p_transaction_step_id => p_transaction_step_id
2030: ,p_name => 'P_INFORMATION11');
2031: --
2032: p_information12 :=
2033: hr_transaction_api.get_varchar2_value
2034: (p_transaction_step_id => p_transaction_step_id
2035: ,p_name => 'P_INFORMATION12');
2036: --
2037: p_information13 :=

Line 2038: hr_transaction_api.get_varchar2_value

2034: (p_transaction_step_id => p_transaction_step_id
2035: ,p_name => 'P_INFORMATION12');
2036: --
2037: p_information13 :=
2038: hr_transaction_api.get_varchar2_value
2039: (p_transaction_step_id => p_transaction_step_id
2040: ,p_name => 'P_INFORMATION13');
2041: --
2042: p_information14 :=

Line 2043: hr_transaction_api.get_varchar2_value

2039: (p_transaction_step_id => p_transaction_step_id
2040: ,p_name => 'P_INFORMATION13');
2041: --
2042: p_information14 :=
2043: hr_transaction_api.get_varchar2_value
2044: (p_transaction_step_id => p_transaction_step_id
2045: ,p_name => 'P_INFORMATION14');
2046: --
2047: p_information15 :=

Line 2048: hr_transaction_api.get_varchar2_value

2044: (p_transaction_step_id => p_transaction_step_id
2045: ,p_name => 'P_INFORMATION14');
2046: --
2047: p_information15 :=
2048: hr_transaction_api.get_varchar2_value
2049: (p_transaction_step_id => p_transaction_step_id
2050: ,p_name => 'P_INFORMATION15');
2051: --
2052: p_information16 :=

Line 2053: hr_transaction_api.get_varchar2_value

2049: (p_transaction_step_id => p_transaction_step_id
2050: ,p_name => 'P_INFORMATION15');
2051: --
2052: p_information16 :=
2053: hr_transaction_api.get_varchar2_value
2054: (p_transaction_step_id => p_transaction_step_id
2055: ,p_name => 'P_INFORMATION16');
2056: --
2057: p_information17 :=

Line 2058: hr_transaction_api.get_varchar2_value

2054: (p_transaction_step_id => p_transaction_step_id
2055: ,p_name => 'P_INFORMATION16');
2056: --
2057: p_information17 :=
2058: hr_transaction_api.get_varchar2_value
2059: (p_transaction_step_id => p_transaction_step_id
2060: ,p_name => 'P_INFORMATION17');
2061: --
2062: p_information18 :=

Line 2063: hr_transaction_api.get_varchar2_value

2059: (p_transaction_step_id => p_transaction_step_id
2060: ,p_name => 'P_INFORMATION17');
2061: --
2062: p_information18 :=
2063: hr_transaction_api.get_varchar2_value
2064: (p_transaction_step_id => p_transaction_step_id
2065: ,p_name => 'P_INFORMATION18');
2066: --
2067: p_information19 :=

Line 2068: hr_transaction_api.get_varchar2_value

2064: (p_transaction_step_id => p_transaction_step_id
2065: ,p_name => 'P_INFORMATION18');
2066: --
2067: p_information19 :=
2068: hr_transaction_api.get_varchar2_value
2069: (p_transaction_step_id => p_transaction_step_id
2070: ,p_name => 'P_INFORMATION19');
2071: --
2072: p_information20 :=

Line 2073: hr_transaction_api.get_varchar2_value

2069: (p_transaction_step_id => p_transaction_step_id
2070: ,p_name => 'P_INFORMATION19');
2071: --
2072: p_information20 :=
2073: hr_transaction_api.get_varchar2_value
2074: (p_transaction_step_id => p_transaction_step_id
2075: ,p_name => 'P_INFORMATION20');
2076:
2077: --

Line 2079: hr_transaction_api.get_varchar2_value

2075: ,p_name => 'P_INFORMATION20');
2076:
2077: --
2078: p_information21 :=
2079: hr_transaction_api.get_varchar2_value
2080: (p_transaction_step_id => p_transaction_step_id
2081: ,p_name => 'P_INFORMATION21');
2082: --
2083: p_information22 :=

Line 2084: hr_transaction_api.get_varchar2_value

2080: (p_transaction_step_id => p_transaction_step_id
2081: ,p_name => 'P_INFORMATION21');
2082: --
2083: p_information22 :=
2084: hr_transaction_api.get_varchar2_value
2085: (p_transaction_step_id => p_transaction_step_id
2086: ,p_name => 'P_INFORMATION22');
2087: --
2088: p_information23 :=

Line 2089: hr_transaction_api.get_varchar2_value

2085: (p_transaction_step_id => p_transaction_step_id
2086: ,p_name => 'P_INFORMATION22');
2087: --
2088: p_information23 :=
2089: hr_transaction_api.get_varchar2_value
2090: (p_transaction_step_id => p_transaction_step_id
2091: ,p_name => 'P_INFORMATION23');
2092: --
2093: p_information24 :=

Line 2094: hr_transaction_api.get_varchar2_value

2090: (p_transaction_step_id => p_transaction_step_id
2091: ,p_name => 'P_INFORMATION23');
2092: --
2093: p_information24 :=
2094: hr_transaction_api.get_varchar2_value
2095: (p_transaction_step_id => p_transaction_step_id
2096: ,p_name => 'P_INFORMATION24');
2097: --
2098: p_information25 :=

Line 2099: hr_transaction_api.get_varchar2_value

2095: (p_transaction_step_id => p_transaction_step_id
2096: ,p_name => 'P_INFORMATION24');
2097: --
2098: p_information25 :=
2099: hr_transaction_api.get_varchar2_value
2100: (p_transaction_step_id => p_transaction_step_id
2101: ,p_name => 'P_INFORMATION25');
2102: --
2103: p_information26 :=

Line 2104: hr_transaction_api.get_varchar2_value

2100: (p_transaction_step_id => p_transaction_step_id
2101: ,p_name => 'P_INFORMATION25');
2102: --
2103: p_information26 :=
2104: hr_transaction_api.get_varchar2_value
2105: (p_transaction_step_id => p_transaction_step_id
2106: ,p_name => 'P_INFORMATION26');
2107: --
2108: p_information27 :=

Line 2109: hr_transaction_api.get_varchar2_value

2105: (p_transaction_step_id => p_transaction_step_id
2106: ,p_name => 'P_INFORMATION26');
2107: --
2108: p_information27 :=
2109: hr_transaction_api.get_varchar2_value
2110: (p_transaction_step_id => p_transaction_step_id
2111: ,p_name => 'P_INFORMATION27');
2112: --
2113: p_information28 :=

Line 2114: hr_transaction_api.get_varchar2_value

2110: (p_transaction_step_id => p_transaction_step_id
2111: ,p_name => 'P_INFORMATION27');
2112: --
2113: p_information28 :=
2114: hr_transaction_api.get_varchar2_value
2115: (p_transaction_step_id => p_transaction_step_id
2116: ,p_name => 'P_INFORMATION28');
2117: --
2118: p_information29 :=

Line 2119: hr_transaction_api.get_varchar2_value

2115: (p_transaction_step_id => p_transaction_step_id
2116: ,p_name => 'P_INFORMATION28');
2117: --
2118: p_information29 :=
2119: hr_transaction_api.get_varchar2_value
2120: (p_transaction_step_id => p_transaction_step_id
2121: ,p_name => 'P_INFORMATION29');
2122: --
2123: p_information30 :=

Line 2124: hr_transaction_api.get_varchar2_value

2120: (p_transaction_step_id => p_transaction_step_id
2121: ,p_name => 'P_INFORMATION29');
2122: --
2123: p_information30 :=
2124: hr_transaction_api.get_varchar2_value
2125: (p_transaction_step_id => p_transaction_step_id
2126: ,p_name => 'P_INFORMATION30');
2127:
2128: hr_utility.set_location(' Leaving:' || l_proc, 10);

Line 2328: hr_transaction_api.get_date_value

2324: /*person_id := to_number(l_person_id);
2325: object_version_number := to_number(l_object_version_number);
2326: person_type_id := to_number(l_person_type_id);
2327: date_start :=
2328: hr_transaction_api.get_date_value
2329: (p_transaction_step_id => p_transaction_step_id
2330: ,p_name => 'P_DATE_START');
2331: actual_termination_date :=
2332: hr_transaction_api.get_date_value

Line 2332: hr_transaction_api.get_date_value

2328: hr_transaction_api.get_date_value
2329: (p_transaction_step_id => p_transaction_step_id
2330: ,p_name => 'P_DATE_START');
2331: actual_termination_date :=
2332: hr_transaction_api.get_date_value
2333: (p_transaction_step_id => p_transaction_step_id
2334: ,p_name => 'P_ACTUAL_TERMINATION_DATE');
2335: final_process_date :=
2336: hr_transaction_api.get_date_value

Line 2336: hr_transaction_api.get_date_value

2332: hr_transaction_api.get_date_value
2333: (p_transaction_step_id => p_transaction_step_id
2334: ,p_name => 'P_ACTUAL_TERMINATION_DATE');
2335: final_process_date :=
2336: hr_transaction_api.get_date_value
2337: (p_transaction_step_id => p_transaction_step_id
2338: ,p_name => 'P_FINAL_PROCESS_DATE');
2339: last_standard_process_date :=
2340: hr_transaction_api.get_date_value

Line 2340: hr_transaction_api.get_date_value

2336: hr_transaction_api.get_date_value
2337: (p_transaction_step_id => p_transaction_step_id
2338: ,p_name => 'P_FINAL_PROCESS_DATE');
2339: last_standard_process_date :=
2340: hr_transaction_api.get_date_value
2341: (p_transaction_step_id => p_transaction_step_id
2342: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');
2343: projected_termination_date :=
2344: hr_transaction_api.get_date_value

Line 2344: hr_transaction_api.get_date_value

2340: hr_transaction_api.get_date_value
2341: (p_transaction_step_id => p_transaction_step_id
2342: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');
2343: projected_termination_date :=
2344: hr_transaction_api.get_date_value
2345: (p_transaction_step_id => p_transaction_step_id
2346: ,p_name => 'P_PROJECTED_TERMINATION_DATE');
2347: */
2348: l_effective_date :=

Line 2349: hr_transaction_api.get_date_value

2345: (p_transaction_step_id => p_transaction_step_id
2346: ,p_name => 'P_PROJECTED_TERMINATION_DATE');
2347: */
2348: l_effective_date :=
2349: hr_transaction_api.get_date_value
2350: (p_transaction_step_id => p_transaction_step_id
2351: ,p_name => 'P_EFFECTIVE_DATE');
2352:
2353:

Line 2406: hr_transaction_api.get_transaction_step_info(

2402:
2403: -- Quick Termination changes start from here
2404:
2405: BEGIN
2406: hr_transaction_api.get_transaction_step_info(
2407: p_transaction_step_id
2408: ,ItemType
2409: ,ItemKey
2410: ,ActivityId);

Line 2424: l_term_date := hr_transaction_api.get_date_value(p_transaction_step_id, 'P_ACTUAL_TERMINATION_DATE');

2420: end if;
2421:
2422: if (isQKFn = 'Y' and isSupAsgPGExists = 'Y' ) then
2423:
2424: l_term_date := hr_transaction_api.get_date_value(p_transaction_step_id, 'P_ACTUAL_TERMINATION_DATE');
2425:
2426: l_old_sup_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_PER_ID', true);
2427: l_old_sup_asg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_ASG_ID', true);
2428: l_old_sup_bg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_BG_ID', true);