1777:
1778: begin
1779: --
1780: l_assignment_id:=
1781: hr_transaction_api.get_number_value
1782: (p_transaction_step_id => p_transaction_step_id
1783: ,p_name => 'P_ASSIGNMENT_ID');
1784: --
1785: l_effective_date:=
1782: (p_transaction_step_id => p_transaction_step_id
1783: ,p_name => 'P_ASSIGNMENT_ID');
1784: --
1785: l_effective_date:=
1786: hr_transaction_api.get_date_value
1787: (p_transaction_step_id => p_transaction_step_id
1788: ,p_name => 'P_EFFECTIVE_DATE');
1789: --
1790: -- first of all get all of the old values
1795: --
1796: -- then replace the new values that were written to the transaction table
1797: --
1798: p_assignment_rec.object_version_number:=
1799: hr_transaction_api.get_number_value
1800: (p_transaction_step_id => p_transaction_step_id
1801: ,p_name => 'P_OBJECT_VERSION_NUMBER');
1802: --
1803: p_assignment_rec.organization_id:=
1800: (p_transaction_step_id => p_transaction_step_id
1801: ,p_name => 'P_OBJECT_VERSION_NUMBER');
1802: --
1803: p_assignment_rec.organization_id:=
1804: hr_transaction_api.get_number_value
1805: (p_transaction_step_id => p_transaction_step_id
1806: ,p_name => 'P_ORGANIZATION_ID');
1807: --
1808: p_assignment_rec.position_id:=
1805: (p_transaction_step_id => p_transaction_step_id
1806: ,p_name => 'P_ORGANIZATION_ID');
1807: --
1808: p_assignment_rec.position_id:=
1809: hr_transaction_api.get_number_value
1810: (p_transaction_step_id => p_transaction_step_id
1811: ,p_name => 'P_POSITION_ID');
1812: --
1813: p_assignment_rec.job_id:=
1810: (p_transaction_step_id => p_transaction_step_id
1811: ,p_name => 'P_POSITION_ID');
1812: --
1813: p_assignment_rec.job_id:=
1814: hr_transaction_api.get_number_value
1815: (p_transaction_step_id => p_transaction_step_id
1816: ,p_name => 'P_JOB_ID');
1817: --
1818: p_assignment_rec.grade_id:=
1815: (p_transaction_step_id => p_transaction_step_id
1816: ,p_name => 'P_JOB_ID');
1817: --
1818: p_assignment_rec.grade_id:=
1819: hr_transaction_api.get_number_value
1820: (p_transaction_step_id => p_transaction_step_id
1821: ,p_name => 'P_GRADE_ID');
1822: --
1823: p_assignment_rec.location_id:=
1820: (p_transaction_step_id => p_transaction_step_id
1821: ,p_name => 'P_GRADE_ID');
1822: --
1823: p_assignment_rec.location_id:=
1824: hr_transaction_api.get_number_value
1825: (p_transaction_step_id => p_transaction_step_id
1826: ,p_name => 'P_LOCATION_ID');
1827: --
1828: p_assignment_rec.employment_category:=
1825: (p_transaction_step_id => p_transaction_step_id
1826: ,p_name => 'P_LOCATION_ID');
1827: --
1828: p_assignment_rec.employment_category:=
1829: hr_transaction_api.get_varchar2_value
1830: (p_transaction_step_id => p_transaction_step_id
1831: ,p_name => 'P_EMPLOYMENT_CATEGORY');
1832: --
1833: p_assignment_rec.supervisor_id:=
1830: (p_transaction_step_id => p_transaction_step_id
1831: ,p_name => 'P_EMPLOYMENT_CATEGORY');
1832: --
1833: p_assignment_rec.supervisor_id:=
1834: hr_transaction_api.get_number_value
1835: (p_transaction_step_id => p_transaction_step_id
1836: ,p_name => 'P_SUPERVISOR_ID');
1837: --
1838: p_assignment_rec.manager_flag:=
1835: (p_transaction_step_id => p_transaction_step_id
1836: ,p_name => 'P_SUPERVISOR_ID');
1837: --
1838: p_assignment_rec.manager_flag:=
1839: hr_transaction_api.get_varchar2_value
1840: (p_transaction_step_id => p_transaction_step_id
1841: ,p_name => 'P_MANAGER_FLAG');
1842: --
1843: p_assignment_rec.normal_hours:=
1840: (p_transaction_step_id => p_transaction_step_id
1841: ,p_name => 'P_MANAGER_FLAG');
1842: --
1843: p_assignment_rec.normal_hours:=
1844: hr_transaction_api.get_number_value
1845: (p_transaction_step_id => p_transaction_step_id
1846: ,p_name => 'P_NORMAL_HOURS');
1847: --
1848: p_assignment_rec.frequency:=
1845: (p_transaction_step_id => p_transaction_step_id
1846: ,p_name => 'P_NORMAL_HOURS');
1847: --
1848: p_assignment_rec.frequency:=
1849: hr_transaction_api.get_varchar2_value
1850: (p_transaction_step_id => p_transaction_step_id
1851: ,p_name => 'P_FREQUENCY');
1852: --
1853: p_assignment_rec.time_normal_finish:=
1850: (p_transaction_step_id => p_transaction_step_id
1851: ,p_name => 'P_FREQUENCY');
1852: --
1853: p_assignment_rec.time_normal_finish:=
1854: substr(hr_transaction_api.get_varchar2_value
1855: (p_transaction_step_id => p_transaction_step_id
1856: ,p_name => 'P_TIME_NORMAL_FINISH'),0,5);
1857: --
1858: p_assignment_rec.time_normal_start:=
1855: (p_transaction_step_id => p_transaction_step_id
1856: ,p_name => 'P_TIME_NORMAL_FINISH'),0,5);
1857: --
1858: p_assignment_rec.time_normal_start:=
1859: substr(hr_transaction_api.get_varchar2_value
1860: (p_transaction_step_id => p_transaction_step_id
1861: ,p_name => 'P_TIME_NORMAL_START'),0,5);
1862: --
1863: p_assignment_rec.special_ceiling_step_id:=
1860: (p_transaction_step_id => p_transaction_step_id
1861: ,p_name => 'P_TIME_NORMAL_START'),0,5);
1862: --
1863: p_assignment_rec.special_ceiling_step_id:=
1864: hr_transaction_api.get_number_value
1865: (p_transaction_step_id => p_transaction_step_id
1866: ,p_name => 'P_SPECIAL_CEILING_STEP_ID');
1867: --
1868: p_assignment_rec.assignment_status_type_id:=
1865: (p_transaction_step_id => p_transaction_step_id
1866: ,p_name => 'P_SPECIAL_CEILING_STEP_ID');
1867: --
1868: p_assignment_rec.assignment_status_type_id:=
1869: hr_transaction_api.get_number_value
1870: (p_transaction_step_id => p_transaction_step_id
1871: ,p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID');
1872: --
1873: p_assignment_rec.ass_attribute_category:=
1870: (p_transaction_step_id => p_transaction_step_id
1871: ,p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID');
1872: --
1873: p_assignment_rec.ass_attribute_category:=
1874: hr_transaction_api.get_varchar2_value
1875: (p_transaction_step_id => p_transaction_step_id
1876: ,p_name => 'P_ASS_ATTRIBUTE_CATEGORY');
1877: --
1878: p_assignment_rec.change_reason:=
1875: (p_transaction_step_id => p_transaction_step_id
1876: ,p_name => 'P_ASS_ATTRIBUTE_CATEGORY');
1877: --
1878: p_assignment_rec.change_reason:=
1879: hr_transaction_api.get_varchar2_value
1880: (p_transaction_step_id => p_transaction_step_id
1881: ,p_name => 'P_CHANGE_REASON');
1882: --
1883: p_assignment_rec.ass_attribute1:=
1880: (p_transaction_step_id => p_transaction_step_id
1881: ,p_name => 'P_CHANGE_REASON');
1882: --
1883: p_assignment_rec.ass_attribute1:=
1884: hr_transaction_api.get_varchar2_value
1885: (p_transaction_step_id => p_transaction_step_id
1886: ,p_name => 'P_ASS_ATTRIBUTE1');
1887: --
1888: p_assignment_rec.ass_attribute2:=
1885: (p_transaction_step_id => p_transaction_step_id
1886: ,p_name => 'P_ASS_ATTRIBUTE1');
1887: --
1888: p_assignment_rec.ass_attribute2:=
1889: hr_transaction_api.get_varchar2_value
1890: (p_transaction_step_id => p_transaction_step_id
1891: ,p_name => 'P_ASS_ATTRIBUTE2');
1892: --
1893: p_assignment_rec.ass_attribute3:=
1890: (p_transaction_step_id => p_transaction_step_id
1891: ,p_name => 'P_ASS_ATTRIBUTE2');
1892: --
1893: p_assignment_rec.ass_attribute3:=
1894: hr_transaction_api.get_varchar2_value
1895: (p_transaction_step_id => p_transaction_step_id
1896: ,p_name => 'P_ASS_ATTRIBUTE3');
1897: --
1898: p_assignment_rec.ass_attribute4:=
1895: (p_transaction_step_id => p_transaction_step_id
1896: ,p_name => 'P_ASS_ATTRIBUTE3');
1897: --
1898: p_assignment_rec.ass_attribute4:=
1899: hr_transaction_api.get_varchar2_value
1900: (p_transaction_step_id => p_transaction_step_id
1901: ,p_name => 'P_ASS_ATTRIBUTE4');
1902: --
1903: p_assignment_rec.ass_attribute5:=
1900: (p_transaction_step_id => p_transaction_step_id
1901: ,p_name => 'P_ASS_ATTRIBUTE4');
1902: --
1903: p_assignment_rec.ass_attribute5:=
1904: hr_transaction_api.get_varchar2_value
1905: (p_transaction_step_id => p_transaction_step_id
1906: ,p_name => 'P_ASS_ATTRIBUTE5');
1907: --
1908: p_assignment_rec.ass_attribute6:=
1905: (p_transaction_step_id => p_transaction_step_id
1906: ,p_name => 'P_ASS_ATTRIBUTE5');
1907: --
1908: p_assignment_rec.ass_attribute6:=
1909: hr_transaction_api.get_varchar2_value
1910: (p_transaction_step_id => p_transaction_step_id
1911: ,p_name => 'P_ASS_ATTRIBUTE6');
1912: --
1913: p_assignment_rec.ass_attribute7:=
1910: (p_transaction_step_id => p_transaction_step_id
1911: ,p_name => 'P_ASS_ATTRIBUTE6');
1912: --
1913: p_assignment_rec.ass_attribute7:=
1914: hr_transaction_api.get_varchar2_value
1915: (p_transaction_step_id => p_transaction_step_id
1916: ,p_name => 'P_ASS_ATTRIBUTE7');
1917: --
1918: p_assignment_rec.ass_attribute8:=
1915: (p_transaction_step_id => p_transaction_step_id
1916: ,p_name => 'P_ASS_ATTRIBUTE7');
1917: --
1918: p_assignment_rec.ass_attribute8:=
1919: hr_transaction_api.get_varchar2_value
1920: (p_transaction_step_id => p_transaction_step_id
1921: ,p_name => 'P_ASS_ATTRIBUTE8');
1922: --
1923: p_assignment_rec.ass_attribute9:=
1920: (p_transaction_step_id => p_transaction_step_id
1921: ,p_name => 'P_ASS_ATTRIBUTE8');
1922: --
1923: p_assignment_rec.ass_attribute9:=
1924: hr_transaction_api.get_varchar2_value
1925: (p_transaction_step_id => p_transaction_step_id
1926: ,p_name => 'P_ASS_ATTRIBUTE9');
1927: --
1928: p_assignment_rec.ass_attribute10:=
1925: (p_transaction_step_id => p_transaction_step_id
1926: ,p_name => 'P_ASS_ATTRIBUTE9');
1927: --
1928: p_assignment_rec.ass_attribute10:=
1929: hr_transaction_api.get_varchar2_value
1930: (p_transaction_step_id => p_transaction_step_id
1931: ,p_name => 'P_ASS_ATTRIBUTE10');
1932: --
1933: p_assignment_rec.ass_attribute11:=
1930: (p_transaction_step_id => p_transaction_step_id
1931: ,p_name => 'P_ASS_ATTRIBUTE10');
1932: --
1933: p_assignment_rec.ass_attribute11:=
1934: hr_transaction_api.get_varchar2_value
1935: (p_transaction_step_id => p_transaction_step_id
1936: ,p_name => 'P_ASS_ATTRIBUTE11');
1937: --
1938: p_assignment_rec.ass_attribute12:=
1935: (p_transaction_step_id => p_transaction_step_id
1936: ,p_name => 'P_ASS_ATTRIBUTE11');
1937: --
1938: p_assignment_rec.ass_attribute12:=
1939: hr_transaction_api.get_varchar2_value
1940: (p_transaction_step_id => p_transaction_step_id
1941: ,p_name => 'P_ASS_ATTRIBUTE12');
1942: --
1943: p_assignment_rec.ass_attribute13:=
1940: (p_transaction_step_id => p_transaction_step_id
1941: ,p_name => 'P_ASS_ATTRIBUTE12');
1942: --
1943: p_assignment_rec.ass_attribute13:=
1944: hr_transaction_api.get_varchar2_value
1945: (p_transaction_step_id => p_transaction_step_id
1946: ,p_name => 'P_ASS_ATTRIBUTE13');
1947: --
1948: p_assignment_rec.ass_attribute14:=
1945: (p_transaction_step_id => p_transaction_step_id
1946: ,p_name => 'P_ASS_ATTRIBUTE13');
1947: --
1948: p_assignment_rec.ass_attribute14:=
1949: hr_transaction_api.get_varchar2_value
1950: (p_transaction_step_id => p_transaction_step_id
1951: ,p_name => 'P_ASS_ATTRIBUTE14');
1952: --
1953: p_assignment_rec.ass_attribute15:=
1950: (p_transaction_step_id => p_transaction_step_id
1951: ,p_name => 'P_ASS_ATTRIBUTE14');
1952: --
1953: p_assignment_rec.ass_attribute15:=
1954: hr_transaction_api.get_varchar2_value
1955: (p_transaction_step_id => p_transaction_step_id
1956: ,p_name => 'P_ASS_ATTRIBUTE15');
1957: --
1958: p_assignment_rec.ass_attribute16:=
1955: (p_transaction_step_id => p_transaction_step_id
1956: ,p_name => 'P_ASS_ATTRIBUTE15');
1957: --
1958: p_assignment_rec.ass_attribute16:=
1959: hr_transaction_api.get_varchar2_value
1960: (p_transaction_step_id => p_transaction_step_id
1961: ,p_name => 'P_ASS_ATTRIBUTE16');
1962: --
1963: p_assignment_rec.ass_attribute17:=
1960: (p_transaction_step_id => p_transaction_step_id
1961: ,p_name => 'P_ASS_ATTRIBUTE16');
1962: --
1963: p_assignment_rec.ass_attribute17:=
1964: hr_transaction_api.get_varchar2_value
1965: (p_transaction_step_id => p_transaction_step_id
1966: ,p_name => 'P_ASS_ATTRIBUTE17');
1967: --
1968: p_assignment_rec.ass_attribute18:=
1965: (p_transaction_step_id => p_transaction_step_id
1966: ,p_name => 'P_ASS_ATTRIBUTE17');
1967: --
1968: p_assignment_rec.ass_attribute18:=
1969: hr_transaction_api.get_varchar2_value
1970: (p_transaction_step_id => p_transaction_step_id
1971: ,p_name => 'P_ASS_ATTRIBUTE18');
1972: --
1973: p_assignment_rec.ass_attribute19:=
1970: (p_transaction_step_id => p_transaction_step_id
1971: ,p_name => 'P_ASS_ATTRIBUTE18');
1972: --
1973: p_assignment_rec.ass_attribute19:=
1974: hr_transaction_api.get_varchar2_value
1975: (p_transaction_step_id => p_transaction_step_id
1976: ,p_name => 'P_ASS_ATTRIBUTE19');
1977: --
1978: p_assignment_rec.ass_attribute20:=
1975: (p_transaction_step_id => p_transaction_step_id
1976: ,p_name => 'P_ASS_ATTRIBUTE19');
1977: --
1978: p_assignment_rec.ass_attribute20:=
1979: hr_transaction_api.get_varchar2_value
1980: (p_transaction_step_id => p_transaction_step_id
1981: ,p_name => 'P_ASS_ATTRIBUTE20');
1982: --
1983: p_assignment_rec.ass_attribute21:=
1980: (p_transaction_step_id => p_transaction_step_id
1981: ,p_name => 'P_ASS_ATTRIBUTE20');
1982: --
1983: p_assignment_rec.ass_attribute21:=
1984: hr_transaction_api.get_varchar2_value
1985: (p_transaction_step_id => p_transaction_step_id
1986: ,p_name => 'P_ASS_ATTRIBUTE21');
1987: --
1988: p_assignment_rec.ass_attribute22:=
1985: (p_transaction_step_id => p_transaction_step_id
1986: ,p_name => 'P_ASS_ATTRIBUTE21');
1987: --
1988: p_assignment_rec.ass_attribute22:=
1989: hr_transaction_api.get_varchar2_value
1990: (p_transaction_step_id => p_transaction_step_id
1991: ,p_name => 'P_ASS_ATTRIBUTE22');
1992: --
1993: p_assignment_rec.ass_attribute23:=
1990: (p_transaction_step_id => p_transaction_step_id
1991: ,p_name => 'P_ASS_ATTRIBUTE22');
1992: --
1993: p_assignment_rec.ass_attribute23:=
1994: hr_transaction_api.get_varchar2_value
1995: (p_transaction_step_id => p_transaction_step_id
1996: ,p_name => 'P_ASS_ATTRIBUTE23');
1997: --
1998: p_assignment_rec.ass_attribute24:=
1995: (p_transaction_step_id => p_transaction_step_id
1996: ,p_name => 'P_ASS_ATTRIBUTE23');
1997: --
1998: p_assignment_rec.ass_attribute24:=
1999: hr_transaction_api.get_varchar2_value
2000: (p_transaction_step_id => p_transaction_step_id
2001: ,p_name => 'P_ASS_ATTRIBUTE24');
2002: --
2003: p_assignment_rec.ass_attribute25:=
2000: (p_transaction_step_id => p_transaction_step_id
2001: ,p_name => 'P_ASS_ATTRIBUTE24');
2002: --
2003: p_assignment_rec.ass_attribute25:=
2004: hr_transaction_api.get_varchar2_value
2005: (p_transaction_step_id => p_transaction_step_id
2006: ,p_name => 'P_ASS_ATTRIBUTE25');
2007: --
2008: p_assignment_rec.ass_attribute26:=
2005: (p_transaction_step_id => p_transaction_step_id
2006: ,p_name => 'P_ASS_ATTRIBUTE25');
2007: --
2008: p_assignment_rec.ass_attribute26:=
2009: hr_transaction_api.get_varchar2_value
2010: (p_transaction_step_id => p_transaction_step_id
2011: ,p_name => 'P_ASS_ATTRIBUTE26');
2012: --
2013: p_assignment_rec.ass_attribute27:=
2010: (p_transaction_step_id => p_transaction_step_id
2011: ,p_name => 'P_ASS_ATTRIBUTE26');
2012: --
2013: p_assignment_rec.ass_attribute27:=
2014: hr_transaction_api.get_varchar2_value
2015: (p_transaction_step_id => p_transaction_step_id
2016: ,p_name => 'P_ASS_ATTRIBUTE27');
2017: --
2018: p_assignment_rec.ass_attribute28:=
2015: (p_transaction_step_id => p_transaction_step_id
2016: ,p_name => 'P_ASS_ATTRIBUTE27');
2017: --
2018: p_assignment_rec.ass_attribute28:=
2019: hr_transaction_api.get_varchar2_value
2020: (p_transaction_step_id => p_transaction_step_id
2021: ,p_name => 'P_ASS_ATTRIBUTE28');
2022: --
2023: p_assignment_rec.ass_attribute29:=
2020: (p_transaction_step_id => p_transaction_step_id
2021: ,p_name => 'P_ASS_ATTRIBUTE28');
2022: --
2023: p_assignment_rec.ass_attribute29:=
2024: hr_transaction_api.get_varchar2_value
2025: (p_transaction_step_id => p_transaction_step_id
2026: ,p_name => 'P_ASS_ATTRIBUTE29');
2027: --
2028: p_assignment_rec.ass_attribute30:=
2025: (p_transaction_step_id => p_transaction_step_id
2026: ,p_name => 'P_ASS_ATTRIBUTE29');
2027: --
2028: p_assignment_rec.ass_attribute30:=
2029: hr_transaction_api.get_varchar2_value
2030: (p_transaction_step_id => p_transaction_step_id
2031: ,p_name => 'P_ASS_ATTRIBUTE30');
2032: --
2033: end get_asg_from_tt;
2040: */
2041: begin
2042: --
2043: p_pgp_rec.segment1:=
2044: hr_transaction_api.get_varchar2_value
2045: (p_transaction_step_id => p_transaction_step_id
2046: ,p_name => 'P_PGP_SEGMENT1');
2047: --
2048: p_pgp_rec.segment2:=
2045: (p_transaction_step_id => p_transaction_step_id
2046: ,p_name => 'P_PGP_SEGMENT1');
2047: --
2048: p_pgp_rec.segment2:=
2049: hr_transaction_api.get_varchar2_value
2050: (p_transaction_step_id => p_transaction_step_id
2051: ,p_name => 'P_PGP_SEGMENT2');
2052: --
2053: p_pgp_rec.segment3:=
2050: (p_transaction_step_id => p_transaction_step_id
2051: ,p_name => 'P_PGP_SEGMENT2');
2052: --
2053: p_pgp_rec.segment3:=
2054: hr_transaction_api.get_varchar2_value
2055: (p_transaction_step_id => p_transaction_step_id
2056: ,p_name => 'P_PGP_SEGMENT3');
2057: --
2058: p_pgp_rec.segment4:=
2055: (p_transaction_step_id => p_transaction_step_id
2056: ,p_name => 'P_PGP_SEGMENT3');
2057: --
2058: p_pgp_rec.segment4:=
2059: hr_transaction_api.get_varchar2_value
2060: (p_transaction_step_id => p_transaction_step_id
2061: ,p_name => 'P_PGP_SEGMENT4');
2062: --
2063: p_pgp_rec.segment5:=
2060: (p_transaction_step_id => p_transaction_step_id
2061: ,p_name => 'P_PGP_SEGMENT4');
2062: --
2063: p_pgp_rec.segment5:=
2064: hr_transaction_api.get_varchar2_value
2065: (p_transaction_step_id => p_transaction_step_id
2066: ,p_name => 'P_PGP_SEGMENT5');
2067: --
2068: p_pgp_rec.segment6:=
2065: (p_transaction_step_id => p_transaction_step_id
2066: ,p_name => 'P_PGP_SEGMENT5');
2067: --
2068: p_pgp_rec.segment6:=
2069: hr_transaction_api.get_varchar2_value
2070: (p_transaction_step_id => p_transaction_step_id
2071: ,p_name => 'P_PGP_SEGMENT6');
2072: --
2073: p_pgp_rec.segment7:=
2070: (p_transaction_step_id => p_transaction_step_id
2071: ,p_name => 'P_PGP_SEGMENT6');
2072: --
2073: p_pgp_rec.segment7:=
2074: hr_transaction_api.get_varchar2_value
2075: (p_transaction_step_id => p_transaction_step_id
2076: ,p_name => 'P_PGP_SEGMENT7');
2077: --
2078: p_pgp_rec.segment8:=
2075: (p_transaction_step_id => p_transaction_step_id
2076: ,p_name => 'P_PGP_SEGMENT7');
2077: --
2078: p_pgp_rec.segment8:=
2079: hr_transaction_api.get_varchar2_value
2080: (p_transaction_step_id => p_transaction_step_id
2081: ,p_name => 'P_PGP_SEGMENT8');
2082: --
2083: p_pgp_rec.segment9:=
2080: (p_transaction_step_id => p_transaction_step_id
2081: ,p_name => 'P_PGP_SEGMENT8');
2082: --
2083: p_pgp_rec.segment9:=
2084: hr_transaction_api.get_varchar2_value
2085: (p_transaction_step_id => p_transaction_step_id
2086: ,p_name => 'P_PGP_SEGMENT9');
2087: --
2088: p_pgp_rec.segment10:=
2085: (p_transaction_step_id => p_transaction_step_id
2086: ,p_name => 'P_PGP_SEGMENT9');
2087: --
2088: p_pgp_rec.segment10:=
2089: hr_transaction_api.get_varchar2_value
2090: (p_transaction_step_id => p_transaction_step_id
2091: ,p_name => 'P_PGP_SEGMENT10');
2092: --
2093: p_pgp_rec.segment11:=
2090: (p_transaction_step_id => p_transaction_step_id
2091: ,p_name => 'P_PGP_SEGMENT10');
2092: --
2093: p_pgp_rec.segment11:=
2094: hr_transaction_api.get_varchar2_value
2095: (p_transaction_step_id => p_transaction_step_id
2096: ,p_name => 'P_PGP_SEGMENT11');
2097: --
2098: p_pgp_rec.segment12:=
2095: (p_transaction_step_id => p_transaction_step_id
2096: ,p_name => 'P_PGP_SEGMENT11');
2097: --
2098: p_pgp_rec.segment12:=
2099: hr_transaction_api.get_varchar2_value
2100: (p_transaction_step_id => p_transaction_step_id
2101: ,p_name => 'P_PGP_SEGMENT12');
2102: --
2103: p_pgp_rec.segment13:=
2100: (p_transaction_step_id => p_transaction_step_id
2101: ,p_name => 'P_PGP_SEGMENT12');
2102: --
2103: p_pgp_rec.segment13:=
2104: hr_transaction_api.get_varchar2_value
2105: (p_transaction_step_id => p_transaction_step_id
2106: ,p_name => 'P_PGP_SEGMENT13');
2107: --
2108: p_pgp_rec.segment14:=
2105: (p_transaction_step_id => p_transaction_step_id
2106: ,p_name => 'P_PGP_SEGMENT13');
2107: --
2108: p_pgp_rec.segment14:=
2109: hr_transaction_api.get_varchar2_value
2110: (p_transaction_step_id => p_transaction_step_id
2111: ,p_name => 'P_PGP_SEGMENT14');
2112: --
2113: p_pgp_rec.segment15:=
2110: (p_transaction_step_id => p_transaction_step_id
2111: ,p_name => 'P_PGP_SEGMENT14');
2112: --
2113: p_pgp_rec.segment15:=
2114: hr_transaction_api.get_varchar2_value
2115: (p_transaction_step_id => p_transaction_step_id
2116: ,p_name => 'P_PGP_SEGMENT15');
2117: --
2118: p_pgp_rec.segment16:=
2115: (p_transaction_step_id => p_transaction_step_id
2116: ,p_name => 'P_PGP_SEGMENT15');
2117: --
2118: p_pgp_rec.segment16:=
2119: hr_transaction_api.get_varchar2_value
2120: (p_transaction_step_id => p_transaction_step_id
2121: ,p_name => 'P_PGP_SEGMENT16');
2122: --
2123: p_pgp_rec.segment17:=
2120: (p_transaction_step_id => p_transaction_step_id
2121: ,p_name => 'P_PGP_SEGMENT16');
2122: --
2123: p_pgp_rec.segment17:=
2124: hr_transaction_api.get_varchar2_value
2125: (p_transaction_step_id => p_transaction_step_id
2126: ,p_name => 'P_PGP_SEGMENT17');
2127: --
2128: p_pgp_rec.segment18:=
2125: (p_transaction_step_id => p_transaction_step_id
2126: ,p_name => 'P_PGP_SEGMENT17');
2127: --
2128: p_pgp_rec.segment18:=
2129: hr_transaction_api.get_varchar2_value
2130: (p_transaction_step_id => p_transaction_step_id
2131: ,p_name => 'P_PGP_SEGMENT18');
2132: --
2133: p_pgp_rec.segment19:=
2130: (p_transaction_step_id => p_transaction_step_id
2131: ,p_name => 'P_PGP_SEGMENT18');
2132: --
2133: p_pgp_rec.segment19:=
2134: hr_transaction_api.get_varchar2_value
2135: (p_transaction_step_id => p_transaction_step_id
2136: ,p_name => 'P_PGP_SEGMENT19');
2137: --
2138: p_pgp_rec.segment20:=
2135: (p_transaction_step_id => p_transaction_step_id
2136: ,p_name => 'P_PGP_SEGMENT19');
2137: --
2138: p_pgp_rec.segment20:=
2139: hr_transaction_api.get_varchar2_value
2140: (p_transaction_step_id => p_transaction_step_id
2141: ,p_name => 'P_PGP_SEGMENT20');
2142: --
2143: p_pgp_rec.segment21:=
2140: (p_transaction_step_id => p_transaction_step_id
2141: ,p_name => 'P_PGP_SEGMENT20');
2142: --
2143: p_pgp_rec.segment21:=
2144: hr_transaction_api.get_varchar2_value
2145: (p_transaction_step_id => p_transaction_step_id
2146: ,p_name => 'P_PGP_SEGMENT21');
2147: --
2148: p_pgp_rec.segment22:=
2145: (p_transaction_step_id => p_transaction_step_id
2146: ,p_name => 'P_PGP_SEGMENT21');
2147: --
2148: p_pgp_rec.segment22:=
2149: hr_transaction_api.get_varchar2_value
2150: (p_transaction_step_id => p_transaction_step_id
2151: ,p_name => 'P_PGP_SEGMENT22');
2152: --
2153: p_pgp_rec.segment23:=
2150: (p_transaction_step_id => p_transaction_step_id
2151: ,p_name => 'P_PGP_SEGMENT22');
2152: --
2153: p_pgp_rec.segment23:=
2154: hr_transaction_api.get_varchar2_value
2155: (p_transaction_step_id => p_transaction_step_id
2156: ,p_name => 'P_PGP_SEGMENT23');
2157: --
2158: p_pgp_rec.segment24:=
2155: (p_transaction_step_id => p_transaction_step_id
2156: ,p_name => 'P_PGP_SEGMENT23');
2157: --
2158: p_pgp_rec.segment24:=
2159: hr_transaction_api.get_varchar2_value
2160: (p_transaction_step_id => p_transaction_step_id
2161: ,p_name => 'P_PGP_SEGMENT24');
2162: --
2163: p_pgp_rec.segment25:=
2160: (p_transaction_step_id => p_transaction_step_id
2161: ,p_name => 'P_PGP_SEGMENT24');
2162: --
2163: p_pgp_rec.segment25:=
2164: hr_transaction_api.get_varchar2_value
2165: (p_transaction_step_id => p_transaction_step_id
2166: ,p_name => 'P_PGP_SEGMENT25');
2167: --
2168: p_pgp_rec.segment26:=
2165: (p_transaction_step_id => p_transaction_step_id
2166: ,p_name => 'P_PGP_SEGMENT25');
2167: --
2168: p_pgp_rec.segment26:=
2169: hr_transaction_api.get_varchar2_value
2170: (p_transaction_step_id => p_transaction_step_id
2171: ,p_name => 'P_PGP_SEGMENT26');
2172: --
2173: p_pgp_rec.segment27:=
2170: (p_transaction_step_id => p_transaction_step_id
2171: ,p_name => 'P_PGP_SEGMENT26');
2172: --
2173: p_pgp_rec.segment27:=
2174: hr_transaction_api.get_varchar2_value
2175: (p_transaction_step_id => p_transaction_step_id
2176: ,p_name => 'P_PGP_SEGMENT27');
2177: --
2178: p_pgp_rec.segment28:=
2175: (p_transaction_step_id => p_transaction_step_id
2176: ,p_name => 'P_PGP_SEGMENT27');
2177: --
2178: p_pgp_rec.segment28:=
2179: hr_transaction_api.get_varchar2_value
2180: (p_transaction_step_id => p_transaction_step_id
2181: ,p_name => 'P_PGP_SEGMENT28');
2182: --
2183: p_pgp_rec.segment29:=
2180: (p_transaction_step_id => p_transaction_step_id
2181: ,p_name => 'P_PGP_SEGMENT28');
2182: --
2183: p_pgp_rec.segment29:=
2184: hr_transaction_api.get_varchar2_value
2185: (p_transaction_step_id => p_transaction_step_id
2186: ,p_name => 'P_PGP_SEGMENT29');
2187: --
2188: p_pgp_rec.segment30:=
2185: (p_transaction_step_id => p_transaction_step_id
2186: ,p_name => 'P_PGP_SEGMENT29');
2187: --
2188: p_pgp_rec.segment30:=
2189: hr_transaction_api.get_varchar2_value
2190: (p_transaction_step_id => p_transaction_step_id
2191: ,p_name => 'P_PGP_SEGMENT30');
2192: --
2193: end get_pgp_from_tt;
2201: */
2202: begin
2203: --
2204: p_scl_rec.segment1:=
2205: hr_transaction_api.get_varchar2_value
2206: (p_transaction_step_id => p_transaction_step_id
2207: ,p_name => 'P_SCL_SEGMENT1');
2208: --
2209: p_scl_rec.segment2:=
2206: (p_transaction_step_id => p_transaction_step_id
2207: ,p_name => 'P_SCL_SEGMENT1');
2208: --
2209: p_scl_rec.segment2:=
2210: hr_transaction_api.get_varchar2_value
2211: (p_transaction_step_id => p_transaction_step_id
2212: ,p_name => 'P_SCL_SEGMENT2');
2213: --
2214: p_scl_rec.segment3:=
2211: (p_transaction_step_id => p_transaction_step_id
2212: ,p_name => 'P_SCL_SEGMENT2');
2213: --
2214: p_scl_rec.segment3:=
2215: hr_transaction_api.get_varchar2_value
2216: (p_transaction_step_id => p_transaction_step_id
2217: ,p_name => 'P_SCL_SEGMENT3');
2218: --
2219: p_scl_rec.segment4:=
2216: (p_transaction_step_id => p_transaction_step_id
2217: ,p_name => 'P_SCL_SEGMENT3');
2218: --
2219: p_scl_rec.segment4:=
2220: hr_transaction_api.get_varchar2_value
2221: (p_transaction_step_id => p_transaction_step_id
2222: ,p_name => 'P_SCL_SEGMENT4');
2223: --
2224: p_scl_rec.segment5:=
2221: (p_transaction_step_id => p_transaction_step_id
2222: ,p_name => 'P_SCL_SEGMENT4');
2223: --
2224: p_scl_rec.segment5:=
2225: hr_transaction_api.get_varchar2_value
2226: (p_transaction_step_id => p_transaction_step_id
2227: ,p_name => 'P_SCL_SEGMENT5');
2228: --
2229: p_scl_rec.segment6:=
2226: (p_transaction_step_id => p_transaction_step_id
2227: ,p_name => 'P_SCL_SEGMENT5');
2228: --
2229: p_scl_rec.segment6:=
2230: hr_transaction_api.get_varchar2_value
2231: (p_transaction_step_id => p_transaction_step_id
2232: ,p_name => 'P_SCL_SEGMENT6');
2233: --
2234: p_scl_rec.segment7:=
2231: (p_transaction_step_id => p_transaction_step_id
2232: ,p_name => 'P_SCL_SEGMENT6');
2233: --
2234: p_scl_rec.segment7:=
2235: hr_transaction_api.get_varchar2_value
2236: (p_transaction_step_id => p_transaction_step_id
2237: ,p_name => 'P_SCL_SEGMENT7');
2238: --
2239: p_scl_rec.segment8:=
2236: (p_transaction_step_id => p_transaction_step_id
2237: ,p_name => 'P_SCL_SEGMENT7');
2238: --
2239: p_scl_rec.segment8:=
2240: hr_transaction_api.get_varchar2_value
2241: (p_transaction_step_id => p_transaction_step_id
2242: ,p_name => 'P_SCL_SEGMENT8');
2243: --
2244: p_scl_rec.segment9:=
2241: (p_transaction_step_id => p_transaction_step_id
2242: ,p_name => 'P_SCL_SEGMENT8');
2243: --
2244: p_scl_rec.segment9:=
2245: hr_transaction_api.get_varchar2_value
2246: (p_transaction_step_id => p_transaction_step_id
2247: ,p_name => 'P_SCL_SEGMENT9');
2248: --
2249: p_scl_rec.segment10:=
2246: (p_transaction_step_id => p_transaction_step_id
2247: ,p_name => 'P_SCL_SEGMENT9');
2248: --
2249: p_scl_rec.segment10:=
2250: hr_transaction_api.get_varchar2_value
2251: (p_transaction_step_id => p_transaction_step_id
2252: ,p_name => 'P_SCL_SEGMENT10');
2253: --
2254: p_scl_rec.segment11:=
2251: (p_transaction_step_id => p_transaction_step_id
2252: ,p_name => 'P_SCL_SEGMENT10');
2253: --
2254: p_scl_rec.segment11:=
2255: hr_transaction_api.get_varchar2_value
2256: (p_transaction_step_id => p_transaction_step_id
2257: ,p_name => 'P_SCL_SEGMENT11');
2258: --
2259: p_scl_rec.segment12:=
2256: (p_transaction_step_id => p_transaction_step_id
2257: ,p_name => 'P_SCL_SEGMENT11');
2258: --
2259: p_scl_rec.segment12:=
2260: hr_transaction_api.get_varchar2_value
2261: (p_transaction_step_id => p_transaction_step_id
2262: ,p_name => 'P_SCL_SEGMENT12');
2263: --
2264: p_scl_rec.segment13:=
2261: (p_transaction_step_id => p_transaction_step_id
2262: ,p_name => 'P_SCL_SEGMENT12');
2263: --
2264: p_scl_rec.segment13:=
2265: hr_transaction_api.get_varchar2_value
2266: (p_transaction_step_id => p_transaction_step_id
2267: ,p_name => 'P_SCL_SEGMENT13');
2268: --
2269: p_scl_rec.segment14:=
2266: (p_transaction_step_id => p_transaction_step_id
2267: ,p_name => 'P_SCL_SEGMENT13');
2268: --
2269: p_scl_rec.segment14:=
2270: hr_transaction_api.get_varchar2_value
2271: (p_transaction_step_id => p_transaction_step_id
2272: ,p_name => 'P_SCL_SEGMENT14');
2273: --
2274: p_scl_rec.segment15:=
2271: (p_transaction_step_id => p_transaction_step_id
2272: ,p_name => 'P_SCL_SEGMENT14');
2273: --
2274: p_scl_rec.segment15:=
2275: hr_transaction_api.get_varchar2_value
2276: (p_transaction_step_id => p_transaction_step_id
2277: ,p_name => 'P_SCL_SEGMENT15');
2278: --
2279: p_scl_rec.segment16:=
2276: (p_transaction_step_id => p_transaction_step_id
2277: ,p_name => 'P_SCL_SEGMENT15');
2278: --
2279: p_scl_rec.segment16:=
2280: hr_transaction_api.get_varchar2_value
2281: (p_transaction_step_id => p_transaction_step_id
2282: ,p_name => 'P_SCL_SEGMENT16');
2283: --
2284: p_scl_rec.segment17:=
2281: (p_transaction_step_id => p_transaction_step_id
2282: ,p_name => 'P_SCL_SEGMENT16');
2283: --
2284: p_scl_rec.segment17:=
2285: hr_transaction_api.get_varchar2_value
2286: (p_transaction_step_id => p_transaction_step_id
2287: ,p_name => 'P_SCL_SEGMENT17');
2288: --
2289: p_scl_rec.segment18:=
2286: (p_transaction_step_id => p_transaction_step_id
2287: ,p_name => 'P_SCL_SEGMENT17');
2288: --
2289: p_scl_rec.segment18:=
2290: hr_transaction_api.get_varchar2_value
2291: (p_transaction_step_id => p_transaction_step_id
2292: ,p_name => 'P_SCL_SEGMENT18');
2293: --
2294: p_scl_rec.segment19:=
2291: (p_transaction_step_id => p_transaction_step_id
2292: ,p_name => 'P_SCL_SEGMENT18');
2293: --
2294: p_scl_rec.segment19:=
2295: hr_transaction_api.get_varchar2_value
2296: (p_transaction_step_id => p_transaction_step_id
2297: ,p_name => 'P_SCL_SEGMENT19');
2298: --
2299: p_scl_rec.segment20:=
2296: (p_transaction_step_id => p_transaction_step_id
2297: ,p_name => 'P_SCL_SEGMENT19');
2298: --
2299: p_scl_rec.segment20:=
2300: hr_transaction_api.get_varchar2_value
2301: (p_transaction_step_id => p_transaction_step_id
2302: ,p_name => 'P_SCL_SEGMENT20');
2303: --
2304: p_scl_rec.segment21:=
2301: (p_transaction_step_id => p_transaction_step_id
2302: ,p_name => 'P_SCL_SEGMENT20');
2303: --
2304: p_scl_rec.segment21:=
2305: hr_transaction_api.get_varchar2_value
2306: (p_transaction_step_id => p_transaction_step_id
2307: ,p_name => 'P_SCL_SEGMENT21');
2308: --
2309: p_scl_rec.segment22:=
2306: (p_transaction_step_id => p_transaction_step_id
2307: ,p_name => 'P_SCL_SEGMENT21');
2308: --
2309: p_scl_rec.segment22:=
2310: hr_transaction_api.get_varchar2_value
2311: (p_transaction_step_id => p_transaction_step_id
2312: ,p_name => 'P_SCL_SEGMENT22');
2313: --
2314: p_scl_rec.segment23:=
2311: (p_transaction_step_id => p_transaction_step_id
2312: ,p_name => 'P_SCL_SEGMENT22');
2313: --
2314: p_scl_rec.segment23:=
2315: hr_transaction_api.get_varchar2_value
2316: (p_transaction_step_id => p_transaction_step_id
2317: ,p_name => 'P_SCL_SEGMENT23');
2318: --
2319: p_scl_rec.segment24:=
2316: (p_transaction_step_id => p_transaction_step_id
2317: ,p_name => 'P_SCL_SEGMENT23');
2318: --
2319: p_scl_rec.segment24:=
2320: hr_transaction_api.get_varchar2_value
2321: (p_transaction_step_id => p_transaction_step_id
2322: ,p_name => 'P_SCL_SEGMENT24');
2323: --
2324: p_scl_rec.segment25:=
2321: (p_transaction_step_id => p_transaction_step_id
2322: ,p_name => 'P_SCL_SEGMENT24');
2323: --
2324: p_scl_rec.segment25:=
2325: hr_transaction_api.get_varchar2_value
2326: (p_transaction_step_id => p_transaction_step_id
2327: ,p_name => 'P_SCL_SEGMENT25');
2328: --
2329: p_scl_rec.segment26:=
2326: (p_transaction_step_id => p_transaction_step_id
2327: ,p_name => 'P_SCL_SEGMENT25');
2328: --
2329: p_scl_rec.segment26:=
2330: hr_transaction_api.get_varchar2_value
2331: (p_transaction_step_id => p_transaction_step_id
2332: ,p_name => 'P_SCL_SEGMENT26');
2333: --
2334: p_scl_rec.segment27:=
2331: (p_transaction_step_id => p_transaction_step_id
2332: ,p_name => 'P_SCL_SEGMENT26');
2333: --
2334: p_scl_rec.segment27:=
2335: hr_transaction_api.get_varchar2_value
2336: (p_transaction_step_id => p_transaction_step_id
2337: ,p_name => 'P_SCL_SEGMENT27');
2338: --
2339: p_scl_rec.segment28:=
2336: (p_transaction_step_id => p_transaction_step_id
2337: ,p_name => 'P_SCL_SEGMENT27');
2338: --
2339: p_scl_rec.segment28:=
2340: hr_transaction_api.get_varchar2_value
2341: (p_transaction_step_id => p_transaction_step_id
2342: ,p_name => 'P_SCL_SEGMENT28');
2343: --
2344: p_scl_rec.segment29:=
2341: (p_transaction_step_id => p_transaction_step_id
2342: ,p_name => 'P_SCL_SEGMENT28');
2343: --
2344: p_scl_rec.segment29:=
2345: hr_transaction_api.get_varchar2_value
2346: (p_transaction_step_id => p_transaction_step_id
2347: ,p_name => 'P_SCL_SEGMENT29');
2348: --
2349: p_scl_rec.segment30:=
2346: (p_transaction_step_id => p_transaction_step_id
2347: ,p_name => 'P_SCL_SEGMENT29');
2348: --
2349: p_scl_rec.segment30:=
2350: hr_transaction_api.get_varchar2_value
2351: (p_transaction_step_id => p_transaction_step_id
2352: ,p_name => 'P_SCL_SEGMENT30');
2353: --
2354: end get_scl_from_tt;