APPS.HR_QUA_AWARDS_UTIL_SS dependencies on HR_TRANSACTION_API

Line 141: hr_transaction_api.get_varchar2_value

137: ,p_qua_subjects => l_qua_subjects
138: ,p_qua_attendance => l_qua_attendance);
139:
140: l_selected_person_id := to_number(
141: hr_transaction_api.get_varchar2_value
142: (p_transaction_step_id => p_transaction_step_id
143: ,p_name => 'P_SELECTED_PERSON_ID'));
144:
145: IF l_qualifications(1).delete_flag = 'Y' THEN

Line 1356: hr_transaction_api.get_varchar2_value

1352:
1353: hr_utility.set_location('Entering For Loop:'||l_proc,10);
1354: FOR i IN 1..NVL(l_transaction_step_id.count,0) LOOP
1355: l_qualification_id :=
1356: hr_transaction_api.get_varchar2_value
1357: (p_transaction_step_id => l_transaction_step_id(i)
1358: ,p_name => 'P_QUALIFICATION_ID');
1359: IF l_qualification_id = p_qualification_id THEN
1360: l_pending_found := 'Y';

Line 1559: hr_transaction_api.create_transaction_step

1555: ,p_item_key => p_item_key);
1556:
1557: --create a transaction step for this transaction.
1558:
1559: hr_transaction_api.create_transaction_step
1560: (p_validate => FALSE
1561: ,p_creator_person_id => p_creator_person_id
1562: ,p_transaction_id => l_transaction_id
1563: ,p_api_name => HR_QUA_AWARDS_UTIL_SS.API_NAME

Line 1572: hr_transaction_api.set_varchar2_value

1568:
1569:
1570: --save to transaction table
1571:
1572: hr_transaction_api.set_varchar2_value
1573: (p_transaction_step_id => p_transaction_step_id
1574: ,p_person_id => p_creator_person_id
1575: ,p_name => 'p_mode'
1576: ,p_value => p_mode);

Line 1578: hr_transaction_api.set_varchar2_value

1574: ,p_person_id => p_creator_person_id
1575: ,p_name => 'p_mode'
1576: ,p_value => p_mode);
1577:
1578: hr_transaction_api.set_varchar2_value
1579: (p_transaction_step_id => p_transaction_step_id
1580: ,p_person_id => p_creator_person_id
1581: ,p_name => 'P_SELECTED_PERSON_ID'
1582: ,p_value => p_selected_person_id);

Line 1584: hr_transaction_api.set_varchar2_value

1580: ,p_person_id => p_creator_person_id
1581: ,p_name => 'P_SELECTED_PERSON_ID'
1582: ,p_value => p_selected_person_id);
1583:
1584: hr_transaction_api.set_varchar2_value
1585: (p_transaction_step_id => p_transaction_step_id
1586: ,p_person_id => p_creator_person_id
1587: ,p_name => 'P_PQ_PERSON_ID'
1588: ,p_value => p_qualifications(1).person_id);

Line 1590: hr_transaction_api.set_varchar2_value

1586: ,p_person_id => p_creator_person_id
1587: ,p_name => 'P_PQ_PERSON_ID'
1588: ,p_value => p_qualifications(1).person_id);
1589:
1590: hr_transaction_api.set_varchar2_value
1591: (p_transaction_step_id => p_transaction_step_id
1592: ,p_person_id => p_creator_person_id
1593: ,p_name => 'P_BUSINESS_GROUP_ID'
1594: ,p_value => p_qualifications(1).business_group_id);

Line 1597: hr_transaction_api.set_varchar2_value

1593: ,p_name => 'P_BUSINESS_GROUP_ID'
1594: ,p_value => p_qualifications(1).business_group_id);
1595:
1596:
1597: hr_transaction_api.set_varchar2_value
1598: (p_transaction_step_id => p_transaction_step_id
1599: ,p_person_id => p_creator_person_id
1600: ,p_name => 'P_DELETE_FLAG'
1601: ,p_value => p_qualifications(1).delete_flag);

Line 1603: hr_transaction_api.set_varchar2_value

1599: ,p_person_id => p_creator_person_id
1600: ,p_name => 'P_DELETE_FLAG'
1601: ,p_value => p_qualifications(1).delete_flag);
1602:
1603: hr_transaction_api.set_varchar2_value
1604: (p_transaction_step_id => p_transaction_step_id
1605: ,p_person_id => p_creator_person_id
1606: ,p_name => 'P_QUALIFICATION_ID'
1607: ,p_value => p_qualifications(1).qualification_id);

Line 1609: hr_transaction_api.set_varchar2_value

1605: ,p_person_id => p_creator_person_id
1606: ,p_name => 'P_QUALIFICATION_ID'
1607: ,p_value => p_qualifications(1).qualification_id);
1608:
1609: hr_transaction_api.set_varchar2_value
1610: (p_transaction_step_id => p_transaction_step_id
1611: ,p_person_id => p_creator_person_id
1612: ,p_name => 'P_QUALIFICATION_TYPE_ID'
1613: ,p_value => p_qualifications(1).qualification_type_id);

Line 1615: hr_transaction_api.set_varchar2_value

1611: ,p_person_id => p_creator_person_id
1612: ,p_name => 'P_QUALIFICATION_TYPE_ID'
1613: ,p_value => p_qualifications(1).qualification_type_id);
1614:
1615: hr_transaction_api.set_varchar2_value
1616: (p_transaction_step_id => p_transaction_step_id
1617: ,p_person_id => p_creator_person_id
1618: ,p_name => 'P_PQ_OBJECT_VERSION_NUMBER'
1619: ,p_value => p_qualifications(1).object_version_number);

Line 1621: hr_transaction_api.set_varchar2_value

1617: ,p_person_id => p_creator_person_id
1618: ,p_name => 'P_PQ_OBJECT_VERSION_NUMBER'
1619: ,p_value => p_qualifications(1).object_version_number);
1620:
1621: hr_transaction_api.set_varchar2_value
1622: (p_transaction_step_id => p_transaction_step_id
1623: ,p_person_id => p_creator_person_id
1624: ,p_name => 'P_PQ_TITLE'
1625: ,p_value => p_qualifications(1).title);

Line 1627: hr_transaction_api.set_date_value

1623: ,p_person_id => p_creator_person_id
1624: ,p_name => 'P_PQ_TITLE'
1625: ,p_value => p_qualifications(1).title);
1626:
1627: hr_transaction_api.set_date_value
1628: (p_transaction_step_id => p_transaction_step_id
1629: ,p_person_id => p_creator_person_id
1630: ,p_name => 'P_PQ_START_DATE'
1631: ,p_value => p_qualifications(1).start_date);

Line 1633: hr_transaction_api.set_date_value

1629: ,p_person_id => p_creator_person_id
1630: ,p_name => 'P_PQ_START_DATE'
1631: ,p_value => p_qualifications(1).start_date);
1632:
1633: hr_transaction_api.set_date_value
1634: (p_transaction_step_id => p_transaction_step_id
1635: ,p_person_id => p_creator_person_id
1636: ,p_name => 'P_PQ_END_DATE'
1637: ,p_value => p_qualifications(1).end_date);

Line 1639: hr_transaction_api.set_varchar2_value

1635: ,p_person_id => p_creator_person_id
1636: ,p_name => 'P_PQ_END_DATE'
1637: ,p_value => p_qualifications(1).end_date);
1638:
1639: hr_transaction_api.set_varchar2_value
1640: (p_transaction_step_id => p_transaction_step_id
1641: ,p_person_id => p_creator_person_id
1642: ,p_name => 'P_PQ_STATUS'
1643: ,p_value => p_qualifications(1).status);

Line 1645: hr_transaction_api.set_varchar2_value

1641: ,p_person_id => p_creator_person_id
1642: ,p_name => 'P_PQ_STATUS'
1643: ,p_value => p_qualifications(1).status);
1644:
1645: hr_transaction_api.set_varchar2_value
1646: (p_transaction_step_id => p_transaction_step_id
1647: ,p_person_id => p_creator_person_id
1648: ,p_name => 'P_PQ_GRADE_ATTAINED'
1649: ,p_value => p_qualifications(1).grade_attained);

Line 1651: hr_transaction_api.set_varchar2_value

1647: ,p_person_id => p_creator_person_id
1648: ,p_name => 'P_PQ_GRADE_ATTAINED'
1649: ,p_value => p_qualifications(1).grade_attained);
1650:
1651: hr_transaction_api.set_varchar2_value
1652: (p_transaction_step_id => p_transaction_step_id
1653: ,p_person_id => p_creator_person_id
1654: ,p_name => 'P_PQ_TUITION_METHOD'
1655: ,p_value => p_qualifications(1).tuition_method);

Line 1657: hr_transaction_api.set_varchar2_value

1653: ,p_person_id => p_creator_person_id
1654: ,p_name => 'P_PQ_TUITION_METHOD'
1655: ,p_value => p_qualifications(1).tuition_method);
1656:
1657: hr_transaction_api.set_varchar2_value
1658: (p_transaction_step_id => p_transaction_step_id
1659: ,p_person_id => p_creator_person_id
1660: ,p_name => 'P_PQ_FEE'
1661: ,p_value => p_qualifications(1).fee);

Line 1663: hr_transaction_api.set_varchar2_value

1659: ,p_person_id => p_creator_person_id
1660: ,p_name => 'P_PQ_FEE'
1661: ,p_value => p_qualifications(1).fee);
1662:
1663: hr_transaction_api.set_varchar2_value
1664: (p_transaction_step_id => p_transaction_step_id
1665: ,p_person_id => p_creator_person_id
1666: ,p_name => 'P_PQ_FEE_CURRENCY'
1667: ,p_value => p_qualifications(1).fee_currency);

Line 1669: hr_transaction_api.set_varchar2_value

1665: ,p_person_id => p_creator_person_id
1666: ,p_name => 'P_PQ_FEE_CURRENCY'
1667: ,p_value => p_qualifications(1).fee_currency);
1668:
1669: hr_transaction_api.set_varchar2_value
1670: (p_transaction_step_id => p_transaction_step_id
1671: ,p_person_id => p_creator_person_id
1672: ,p_name => 'P_PQ_REIMBURSEMENT'
1673: ,p_value => p_qualifications(1).reimbursement_arrangements);

Line 1675: hr_transaction_api.set_varchar2_value

1671: ,p_person_id => p_creator_person_id
1672: ,p_name => 'P_PQ_REIMBURSEMENT'
1673: ,p_value => p_qualifications(1).reimbursement_arrangements);
1674:
1675: hr_transaction_api.set_varchar2_value
1676: (p_transaction_step_id => p_transaction_step_id
1677: ,p_person_id => p_creator_person_id
1678: ,p_name => 'P_PQ_COMPLETED_AMOUNT'
1679: ,p_value => p_qualifications(1).training_completed_amount);

Line 1681: hr_transaction_api.set_varchar2_value

1677: ,p_person_id => p_creator_person_id
1678: ,p_name => 'P_PQ_COMPLETED_AMOUNT'
1679: ,p_value => p_qualifications(1).training_completed_amount);
1680:
1681: hr_transaction_api.set_varchar2_value
1682: (p_transaction_step_id => p_transaction_step_id
1683: ,p_person_id => p_creator_person_id
1684: ,p_name => 'P_PQ_COMPLETED_UNITS'
1685: ,p_value => p_qualifications(1).training_completed_units);

Line 1687: hr_transaction_api.set_varchar2_value

1683: ,p_person_id => p_creator_person_id
1684: ,p_name => 'P_PQ_COMPLETED_UNITS'
1685: ,p_value => p_qualifications(1).training_completed_units);
1686:
1687: hr_transaction_api.set_varchar2_value
1688: (p_transaction_step_id => p_transaction_step_id
1689: ,p_person_id => p_creator_person_id
1690: ,p_name => 'P_PQ_TOTAL_AMOUNT'
1691: ,p_value => p_qualifications(1).total_training_amount);

Line 1693: hr_transaction_api.set_varchar2_value

1689: ,p_person_id => p_creator_person_id
1690: ,p_name => 'P_PQ_TOTAL_AMOUNT'
1691: ,p_value => p_qualifications(1).total_training_amount);
1692:
1693: hr_transaction_api.set_varchar2_value
1694: (p_transaction_step_id => p_transaction_step_id
1695: ,p_person_id => p_creator_person_id
1696: ,p_name => 'P_PQ_COMMENTS'
1697: ,p_value => p_qualifications(1).comments);

Line 1699: hr_transaction_api.set_varchar2_value

1695: ,p_person_id => p_creator_person_id
1696: ,p_name => 'P_PQ_COMMENTS'
1697: ,p_value => p_qualifications(1).comments);
1698:
1699: hr_transaction_api.set_varchar2_value
1700: (p_transaction_step_id => p_transaction_step_id
1701: ,p_person_id => p_creator_person_id
1702: ,p_name => 'P_PQ_AWARDING_BODY'
1703: ,p_value => p_qualifications(1).awarding_body);

Line 1705: hr_transaction_api.set_varchar2_value

1701: ,p_person_id => p_creator_person_id
1702: ,p_name => 'P_PQ_AWARDING_BODY'
1703: ,p_value => p_qualifications(1).awarding_body);
1704:
1705: hr_transaction_api.set_varchar2_value
1706: (p_transaction_step_id => p_transaction_step_id
1707: ,p_person_id => p_creator_person_id
1708: ,p_name => 'P_PQ_GROUP_RANKING'
1709: ,p_value => p_qualifications(1).group_ranking);

Line 1711: hr_transaction_api.set_date_value

1707: ,p_person_id => p_creator_person_id
1708: ,p_name => 'P_PQ_GROUP_RANKING'
1709: ,p_value => p_qualifications(1).group_ranking);
1710:
1711: hr_transaction_api.set_date_value
1712: (p_transaction_step_id => p_transaction_step_id
1713: ,p_person_id => p_creator_person_id
1714: ,p_name => 'P_PQ_AWARDED_DATE'
1715: ,p_value => p_qualifications(1).awarded_date);

Line 1717: hr_transaction_api.set_varchar2_value

1713: ,p_person_id => p_creator_person_id
1714: ,p_name => 'P_PQ_AWARDED_DATE'
1715: ,p_value => p_qualifications(1).awarded_date);
1716:
1717: hr_transaction_api.set_varchar2_value
1718: (p_transaction_step_id => p_transaction_step_id
1719: ,p_person_id => p_creator_person_id
1720: ,p_name => 'P_PQ_LICENSE_NUMBER'
1721: ,p_value => p_qualifications(1).license_number);

Line 1723: hr_transaction_api.set_date_value

1719: ,p_person_id => p_creator_person_id
1720: ,p_name => 'P_PQ_LICENSE_NUMBER'
1721: ,p_value => p_qualifications(1).license_number);
1722:
1723: hr_transaction_api.set_date_value
1724: (p_transaction_step_id => p_transaction_step_id
1725: ,p_person_id => p_creator_person_id
1726: ,p_name => 'P_PQ_EXPIRY_DATE'
1727: ,p_value => p_qualifications(1).expiry_date);

Line 1729: hr_transaction_api.set_varchar2_value

1725: ,p_person_id => p_creator_person_id
1726: ,p_name => 'P_PQ_EXPIRY_DATE'
1727: ,p_value => p_qualifications(1).expiry_date);
1728:
1729: hr_transaction_api.set_varchar2_value
1730: (p_transaction_step_id => p_transaction_step_id
1731: ,p_person_id => p_creator_person_id
1732: ,p_name => 'P_PQ_LICENSE_RESTRICTIONS'
1733: ,p_value => p_qualifications(1).license_restrictions);

Line 1735: hr_transaction_api.set_varchar2_value

1731: ,p_person_id => p_creator_person_id
1732: ,p_name => 'P_PQ_LICENSE_RESTRICTIONS'
1733: ,p_value => p_qualifications(1).license_restrictions);
1734:
1735: hr_transaction_api.set_varchar2_value
1736: (p_transaction_step_id => p_transaction_step_id
1737: ,p_person_id => p_creator_person_id
1738: ,p_name => 'P_PEA_PERSON_ID'
1739: ,p_value => p_qua_attendance(1).person_id);

Line 1741: hr_transaction_api.set_varchar2_value

1737: ,p_person_id => p_creator_person_id
1738: ,p_name => 'P_PEA_PERSON_ID'
1739: ,p_value => p_qua_attendance(1).person_id);
1740:
1741: hr_transaction_api.set_varchar2_value
1742: (p_transaction_step_id => p_transaction_step_id
1743: ,p_person_id => p_creator_person_id
1744: ,p_name => 'P_ESTABLISHMENT_ID'
1745: ,p_value => p_qua_attendance(1).establishment_id);

Line 1747: hr_transaction_api.set_varchar2_value

1743: ,p_person_id => p_creator_person_id
1744: ,p_name => 'P_ESTABLISHMENT_ID'
1745: ,p_value => p_qua_attendance(1).establishment_id);
1746:
1747: hr_transaction_api.set_varchar2_value
1748: (p_transaction_step_id => p_transaction_step_id
1749: ,p_person_id => p_creator_person_id
1750: ,p_name => 'P_PE_NAME'
1751: ,p_value => p_qua_attendance(1).establishment);

Line 1753: hr_transaction_api.set_varchar2_value

1749: ,p_person_id => p_creator_person_id
1750: ,p_name => 'P_PE_NAME'
1751: ,p_value => p_qua_attendance(1).establishment);
1752:
1753: hr_transaction_api.set_varchar2_value
1754: (p_transaction_step_id => p_transaction_step_id
1755: ,p_person_id => p_creator_person_id
1756: ,p_name => 'P_ATTENDANCE_ID'
1757: ,p_value => p_qualifications(1).attendance_id);

Line 1759: hr_transaction_api.set_varchar2_value

1755: ,p_person_id => p_creator_person_id
1756: ,p_name => 'P_ATTENDANCE_ID'
1757: ,p_value => p_qualifications(1).attendance_id);
1758:
1759: hr_transaction_api.set_varchar2_value
1760: (p_transaction_step_id => p_transaction_step_id
1761: ,p_person_id => p_creator_person_id
1762: ,p_name => 'P_PEA_OBJECT_VERSION_NUMBER'
1763: ,p_value => p_qua_attendance(1).object_version_number);

Line 1765: hr_transaction_api.set_date_value

1761: ,p_person_id => p_creator_person_id
1762: ,p_name => 'P_PEA_OBJECT_VERSION_NUMBER'
1763: ,p_value => p_qua_attendance(1).object_version_number);
1764:
1765: hr_transaction_api.set_date_value
1766: (p_transaction_step_id => p_transaction_step_id
1767: ,p_person_id => p_creator_person_id
1768: ,p_name => 'P_PEA_START_DATE'
1769: ,p_value => p_qua_attendance(1).attended_start_date);

Line 1771: hr_transaction_api.set_date_value

1767: ,p_person_id => p_creator_person_id
1768: ,p_name => 'P_PEA_START_DATE'
1769: ,p_value => p_qua_attendance(1).attended_start_date);
1770:
1771: hr_transaction_api.set_date_value
1772: (p_transaction_step_id => p_transaction_step_id
1773: ,p_person_id => p_creator_person_id
1774: ,p_name => 'P_PEA_END_DATE'
1775: ,p_value => p_qua_attendance(1).attended_end_date);

Line 1777: hr_transaction_api.set_varchar2_value

1773: ,p_person_id => p_creator_person_id
1774: ,p_name => 'P_PEA_END_DATE'
1775: ,p_value => p_qua_attendance(1).attended_end_date);
1776:
1777: hr_transaction_api.set_varchar2_value
1778: (p_transaction_step_id => p_transaction_step_id
1779: ,p_person_id => p_creator_person_id
1780: ,p_name => 'P_PEA_FULL_TIME'
1781: ,p_value => p_qua_attendance(1).full_time);

Line 1783: hr_transaction_api.set_varchar2_value

1779: ,p_person_id => p_creator_person_id
1780: ,p_name => 'P_PEA_FULL_TIME'
1781: ,p_value => p_qua_attendance(1).full_time);
1782:
1783: hr_transaction_api.set_varchar2_value
1784: (p_transaction_step_id => p_transaction_step_id
1785: ,p_person_id => p_creator_person_id
1786: ,p_name => 'P_PQ_ATTRIBUTE_CATEGORY'
1787: ,p_value => p_qualifications(1).attribute_category);

Line 1789: hr_transaction_api.set_varchar2_value

1785: ,p_person_id => p_creator_person_id
1786: ,p_name => 'P_PQ_ATTRIBUTE_CATEGORY'
1787: ,p_value => p_qualifications(1).attribute_category);
1788:
1789: hr_transaction_api.set_varchar2_value
1790: (p_transaction_step_id => p_transaction_step_id
1791: ,p_person_id => p_creator_person_id
1792: ,p_name => 'P_PQ_ATTRIBUTE1'
1793: ,p_value => p_qualifications(1).attribute1);

Line 1795: hr_transaction_api.set_varchar2_value

1791: ,p_person_id => p_creator_person_id
1792: ,p_name => 'P_PQ_ATTRIBUTE1'
1793: ,p_value => p_qualifications(1).attribute1);
1794:
1795: hr_transaction_api.set_varchar2_value
1796: (p_transaction_step_id => p_transaction_step_id
1797: ,p_person_id => p_creator_person_id
1798: ,p_name => 'P_PQ_ATTRIBUTE2'
1799: ,p_value => p_qualifications(1).attribute2);

Line 1801: hr_transaction_api.set_varchar2_value

1797: ,p_person_id => p_creator_person_id
1798: ,p_name => 'P_PQ_ATTRIBUTE2'
1799: ,p_value => p_qualifications(1).attribute2);
1800:
1801: hr_transaction_api.set_varchar2_value
1802: (p_transaction_step_id => p_transaction_step_id
1803: ,p_person_id => p_creator_person_id
1804: ,p_name => 'P_PQ_ATTRIBUTE3'
1805: ,p_value => p_qualifications(1).attribute3);

Line 1807: hr_transaction_api.set_varchar2_value

1803: ,p_person_id => p_creator_person_id
1804: ,p_name => 'P_PQ_ATTRIBUTE3'
1805: ,p_value => p_qualifications(1).attribute3);
1806:
1807: hr_transaction_api.set_varchar2_value
1808: (p_transaction_step_id => p_transaction_step_id
1809: ,p_person_id => p_creator_person_id
1810: ,p_name => 'P_PQ_ATTRIBUTE4'
1811: ,p_value => p_qualifications(1).attribute4);

Line 1813: hr_transaction_api.set_varchar2_value

1809: ,p_person_id => p_creator_person_id
1810: ,p_name => 'P_PQ_ATTRIBUTE4'
1811: ,p_value => p_qualifications(1).attribute4);
1812:
1813: hr_transaction_api.set_varchar2_value
1814: (p_transaction_step_id => p_transaction_step_id
1815: ,p_person_id => p_creator_person_id
1816: ,p_name => 'P_PQ_ATTRIBUTE5'
1817: ,p_value => p_qualifications(1).attribute5);

Line 1819: hr_transaction_api.set_varchar2_value

1815: ,p_person_id => p_creator_person_id
1816: ,p_name => 'P_PQ_ATTRIBUTE5'
1817: ,p_value => p_qualifications(1).attribute5);
1818:
1819: hr_transaction_api.set_varchar2_value
1820: (p_transaction_step_id => p_transaction_step_id
1821: ,p_person_id => p_creator_person_id
1822: ,p_name => 'P_PQ_ATTRIBUTE6'
1823: ,p_value => p_qualifications(1).attribute6);

Line 1825: hr_transaction_api.set_varchar2_value

1821: ,p_person_id => p_creator_person_id
1822: ,p_name => 'P_PQ_ATTRIBUTE6'
1823: ,p_value => p_qualifications(1).attribute6);
1824:
1825: hr_transaction_api.set_varchar2_value
1826: (p_transaction_step_id => p_transaction_step_id
1827: ,p_person_id => p_creator_person_id
1828: ,p_name => 'P_PQ_ATTRIBUTE7'
1829: ,p_value => p_qualifications(1).attribute7);

Line 1831: hr_transaction_api.set_varchar2_value

1827: ,p_person_id => p_creator_person_id
1828: ,p_name => 'P_PQ_ATTRIBUTE7'
1829: ,p_value => p_qualifications(1).attribute7);
1830:
1831: hr_transaction_api.set_varchar2_value
1832: (p_transaction_step_id => p_transaction_step_id
1833: ,p_person_id => p_creator_person_id
1834: ,p_name => 'P_PQ_ATTRIBUTE8'
1835: ,p_value => p_qualifications(1).attribute8);

Line 1837: hr_transaction_api.set_varchar2_value

1833: ,p_person_id => p_creator_person_id
1834: ,p_name => 'P_PQ_ATTRIBUTE8'
1835: ,p_value => p_qualifications(1).attribute8);
1836:
1837: hr_transaction_api.set_varchar2_value
1838: (p_transaction_step_id => p_transaction_step_id
1839: ,p_person_id => p_creator_person_id
1840: ,p_name => 'P_PQ_ATTRIBUTE9'
1841: ,p_value => p_qualifications(1).attribute9);

Line 1843: hr_transaction_api.set_varchar2_value

1839: ,p_person_id => p_creator_person_id
1840: ,p_name => 'P_PQ_ATTRIBUTE9'
1841: ,p_value => p_qualifications(1).attribute9);
1842:
1843: hr_transaction_api.set_varchar2_value
1844: (p_transaction_step_id => p_transaction_step_id
1845: ,p_person_id => p_creator_person_id
1846: ,p_name => 'P_PQ_ATTRIBUTE10'
1847: ,p_value => p_qualifications(1).attribute10);

Line 1849: hr_transaction_api.set_varchar2_value

1845: ,p_person_id => p_creator_person_id
1846: ,p_name => 'P_PQ_ATTRIBUTE10'
1847: ,p_value => p_qualifications(1).attribute10);
1848:
1849: hr_transaction_api.set_varchar2_value
1850: (p_transaction_step_id => p_transaction_step_id
1851: ,p_person_id => p_creator_person_id
1852: ,p_name => 'P_PQ_ATTRIBUTE11'
1853: ,p_value => p_qualifications(1).attribute11);

Line 1855: hr_transaction_api.set_varchar2_value

1851: ,p_person_id => p_creator_person_id
1852: ,p_name => 'P_PQ_ATTRIBUTE11'
1853: ,p_value => p_qualifications(1).attribute11);
1854:
1855: hr_transaction_api.set_varchar2_value
1856: (p_transaction_step_id => p_transaction_step_id
1857: ,p_person_id => p_creator_person_id
1858: ,p_name => 'P_PQ_ATTRIBUTE12'
1859: ,p_value => p_qualifications(1).attribute12);

Line 1861: hr_transaction_api.set_varchar2_value

1857: ,p_person_id => p_creator_person_id
1858: ,p_name => 'P_PQ_ATTRIBUTE12'
1859: ,p_value => p_qualifications(1).attribute12);
1860:
1861: hr_transaction_api.set_varchar2_value
1862: (p_transaction_step_id => p_transaction_step_id
1863: ,p_person_id => p_creator_person_id
1864: ,p_name => 'P_PQ_ATTRIBUTE13'
1865: ,p_value => p_qualifications(1).attribute13);

Line 1867: hr_transaction_api.set_varchar2_value

1863: ,p_person_id => p_creator_person_id
1864: ,p_name => 'P_PQ_ATTRIBUTE13'
1865: ,p_value => p_qualifications(1).attribute13);
1866:
1867: hr_transaction_api.set_varchar2_value
1868: (p_transaction_step_id => p_transaction_step_id
1869: ,p_person_id => p_creator_person_id
1870: ,p_name => 'P_PQ_ATTRIBUTE14'
1871: ,p_value => p_qualifications(1).attribute14);

Line 1873: hr_transaction_api.set_varchar2_value

1869: ,p_person_id => p_creator_person_id
1870: ,p_name => 'P_PQ_ATTRIBUTE14'
1871: ,p_value => p_qualifications(1).attribute14);
1872:
1873: hr_transaction_api.set_varchar2_value
1874: (p_transaction_step_id => p_transaction_step_id
1875: ,p_person_id => p_creator_person_id
1876: ,p_name => 'P_PQ_ATTRIBUTE15'
1877: ,p_value => p_qualifications(1).attribute15);

Line 1879: hr_transaction_api.set_varchar2_value

1875: ,p_person_id => p_creator_person_id
1876: ,p_name => 'P_PQ_ATTRIBUTE15'
1877: ,p_value => p_qualifications(1).attribute15);
1878:
1879: hr_transaction_api.set_varchar2_value
1880: (p_transaction_step_id => p_transaction_step_id
1881: ,p_person_id => p_creator_person_id
1882: ,p_name => 'P_PQ_ATTRIBUTE16'
1883: ,p_value => p_qualifications(1).attribute16);

Line 1885: hr_transaction_api.set_varchar2_value

1881: ,p_person_id => p_creator_person_id
1882: ,p_name => 'P_PQ_ATTRIBUTE16'
1883: ,p_value => p_qualifications(1).attribute16);
1884:
1885: hr_transaction_api.set_varchar2_value
1886: (p_transaction_step_id => p_transaction_step_id
1887: ,p_person_id => p_creator_person_id
1888: ,p_name => 'P_PQ_ATTRIBUTE17'
1889: ,p_value => p_qualifications(1).attribute17);

Line 1891: hr_transaction_api.set_varchar2_value

1887: ,p_person_id => p_creator_person_id
1888: ,p_name => 'P_PQ_ATTRIBUTE17'
1889: ,p_value => p_qualifications(1).attribute17);
1890:
1891: hr_transaction_api.set_varchar2_value
1892: (p_transaction_step_id => p_transaction_step_id
1893: ,p_person_id => p_creator_person_id
1894: ,p_name => 'P_PQ_ATTRIBUTE18'
1895: ,p_value => p_qualifications(1).attribute18);

Line 1897: hr_transaction_api.set_varchar2_value

1893: ,p_person_id => p_creator_person_id
1894: ,p_name => 'P_PQ_ATTRIBUTE18'
1895: ,p_value => p_qualifications(1).attribute18);
1896:
1897: hr_transaction_api.set_varchar2_value
1898: (p_transaction_step_id => p_transaction_step_id
1899: ,p_person_id => p_creator_person_id
1900: ,p_name => 'P_PQ_ATTRIBUTE19'
1901: ,p_value => p_qualifications(1).attribute19);

Line 1903: hr_transaction_api.set_varchar2_value

1899: ,p_person_id => p_creator_person_id
1900: ,p_name => 'P_PQ_ATTRIBUTE19'
1901: ,p_value => p_qualifications(1).attribute19);
1902:
1903: hr_transaction_api.set_varchar2_value
1904: (p_transaction_step_id => p_transaction_step_id
1905: ,p_person_id => p_creator_person_id
1906: ,p_name => 'P_PQ_ATTRIBUTE20'
1907: ,p_value => p_qualifications(1).attribute20);

Line 1909: hr_transaction_api.set_varchar2_value

1905: ,p_person_id => p_creator_person_id
1906: ,p_name => 'P_PQ_ATTRIBUTE20'
1907: ,p_value => p_qualifications(1).attribute20);
1908:
1909: hr_transaction_api.set_varchar2_value
1910: (p_transaction_step_id => p_transaction_step_id
1911: ,p_person_id => p_creator_person_id
1912: ,p_name => 'P_PQ_QUA_INFORMATION_CATEGORY'
1913: ,p_value => p_qualifications(1).qua_information_category);

Line 1915: hr_transaction_api.set_varchar2_value

1911: ,p_person_id => p_creator_person_id
1912: ,p_name => 'P_PQ_QUA_INFORMATION_CATEGORY'
1913: ,p_value => p_qualifications(1).qua_information_category);
1914:
1915: hr_transaction_api.set_varchar2_value
1916: (p_transaction_step_id => p_transaction_step_id
1917: ,p_person_id => p_creator_person_id
1918: ,p_name => 'P_PQ_QUA_INFORMATION1'
1919: ,p_value => p_qualifications(1).qua_information1);

Line 1921: hr_transaction_api.set_varchar2_value

1917: ,p_person_id => p_creator_person_id
1918: ,p_name => 'P_PQ_QUA_INFORMATION1'
1919: ,p_value => p_qualifications(1).qua_information1);
1920:
1921: hr_transaction_api.set_varchar2_value
1922: (p_transaction_step_id => p_transaction_step_id
1923: ,p_person_id => p_creator_person_id
1924: ,p_name => 'P_PQ_QUA_INFORMATION2'
1925: ,p_value => p_qualifications(1).qua_information2);

Line 1926: hr_transaction_api.set_varchar2_value

1922: (p_transaction_step_id => p_transaction_step_id
1923: ,p_person_id => p_creator_person_id
1924: ,p_name => 'P_PQ_QUA_INFORMATION2'
1925: ,p_value => p_qualifications(1).qua_information2);
1926: hr_transaction_api.set_varchar2_value
1927: (p_transaction_step_id => p_transaction_step_id
1928: ,p_person_id => p_creator_person_id
1929: ,p_name => 'P_PQ_QUA_INFORMATION3'
1930: ,p_value => p_qualifications(1).qua_information3);

Line 1931: hr_transaction_api.set_varchar2_value

1927: (p_transaction_step_id => p_transaction_step_id
1928: ,p_person_id => p_creator_person_id
1929: ,p_name => 'P_PQ_QUA_INFORMATION3'
1930: ,p_value => p_qualifications(1).qua_information3);
1931: hr_transaction_api.set_varchar2_value
1932: (p_transaction_step_id => p_transaction_step_id
1933: ,p_person_id => p_creator_person_id
1934: ,p_name => 'P_PQ_QUA_INFORMATION4'
1935: ,p_value => p_qualifications(1).qua_information4);

Line 1936: hr_transaction_api.set_varchar2_value

1932: (p_transaction_step_id => p_transaction_step_id
1933: ,p_person_id => p_creator_person_id
1934: ,p_name => 'P_PQ_QUA_INFORMATION4'
1935: ,p_value => p_qualifications(1).qua_information4);
1936: hr_transaction_api.set_varchar2_value
1937: (p_transaction_step_id => p_transaction_step_id
1938: ,p_person_id => p_creator_person_id
1939: ,p_name => 'P_PQ_QUA_INFORMATION5'
1940: ,p_value => p_qualifications(1).qua_information5);

Line 1941: hr_transaction_api.set_varchar2_value

1937: (p_transaction_step_id => p_transaction_step_id
1938: ,p_person_id => p_creator_person_id
1939: ,p_name => 'P_PQ_QUA_INFORMATION5'
1940: ,p_value => p_qualifications(1).qua_information5);
1941: hr_transaction_api.set_varchar2_value
1942: (p_transaction_step_id => p_transaction_step_id
1943: ,p_person_id => p_creator_person_id
1944: ,p_name => 'P_PQ_QUA_INFORMATION6'
1945: ,p_value => p_qualifications(1).qua_information6);

Line 1946: hr_transaction_api.set_varchar2_value

1942: (p_transaction_step_id => p_transaction_step_id
1943: ,p_person_id => p_creator_person_id
1944: ,p_name => 'P_PQ_QUA_INFORMATION6'
1945: ,p_value => p_qualifications(1).qua_information6);
1946: hr_transaction_api.set_varchar2_value
1947: (p_transaction_step_id => p_transaction_step_id
1948: ,p_person_id => p_creator_person_id
1949: ,p_name => 'P_PQ_QUA_INFORMATION7'
1950: ,p_value => p_qualifications(1).qua_information7);

Line 1951: hr_transaction_api.set_varchar2_value

1947: (p_transaction_step_id => p_transaction_step_id
1948: ,p_person_id => p_creator_person_id
1949: ,p_name => 'P_PQ_QUA_INFORMATION7'
1950: ,p_value => p_qualifications(1).qua_information7);
1951: hr_transaction_api.set_varchar2_value
1952: (p_transaction_step_id => p_transaction_step_id
1953: ,p_person_id => p_creator_person_id
1954: ,p_name => 'P_PQ_QUA_INFORMATION8'
1955: ,p_value => p_qualifications(1).qua_information8);

Line 1956: hr_transaction_api.set_varchar2_value

1952: (p_transaction_step_id => p_transaction_step_id
1953: ,p_person_id => p_creator_person_id
1954: ,p_name => 'P_PQ_QUA_INFORMATION8'
1955: ,p_value => p_qualifications(1).qua_information8);
1956: hr_transaction_api.set_varchar2_value
1957: (p_transaction_step_id => p_transaction_step_id
1958: ,p_person_id => p_creator_person_id
1959: ,p_name => 'P_PQ_QUA_INFORMATION9'
1960: ,p_value => p_qualifications(1).qua_information9);

Line 1961: hr_transaction_api.set_varchar2_value

1957: (p_transaction_step_id => p_transaction_step_id
1958: ,p_person_id => p_creator_person_id
1959: ,p_name => 'P_PQ_QUA_INFORMATION9'
1960: ,p_value => p_qualifications(1).qua_information9);
1961: hr_transaction_api.set_varchar2_value
1962: (p_transaction_step_id => p_transaction_step_id
1963: ,p_person_id => p_creator_person_id
1964: ,p_name => 'P_PQ_QUA_INFORMATION10'
1965: ,p_value => p_qualifications(1).qua_information10);

Line 1967: hr_transaction_api.set_varchar2_value

1963: ,p_person_id => p_creator_person_id
1964: ,p_name => 'P_PQ_QUA_INFORMATION10'
1965: ,p_value => p_qualifications(1).qua_information10);
1966:
1967: hr_transaction_api.set_varchar2_value
1968: (p_transaction_step_id => p_transaction_step_id
1969: ,p_person_id => p_creator_person_id
1970: ,p_name => 'P_PQ_QUA_INFORMATION11'
1971: ,p_value => p_qualifications(1).qua_information11);

Line 1972: hr_transaction_api.set_varchar2_value

1968: (p_transaction_step_id => p_transaction_step_id
1969: ,p_person_id => p_creator_person_id
1970: ,p_name => 'P_PQ_QUA_INFORMATION11'
1971: ,p_value => p_qualifications(1).qua_information11);
1972: hr_transaction_api.set_varchar2_value
1973: (p_transaction_step_id => p_transaction_step_id
1974: ,p_person_id => p_creator_person_id
1975: ,p_name => 'P_PQ_QUA_INFORMATION12'
1976: ,p_value => p_qualifications(1).qua_information12);

Line 1977: hr_transaction_api.set_varchar2_value

1973: (p_transaction_step_id => p_transaction_step_id
1974: ,p_person_id => p_creator_person_id
1975: ,p_name => 'P_PQ_QUA_INFORMATION12'
1976: ,p_value => p_qualifications(1).qua_information12);
1977: hr_transaction_api.set_varchar2_value
1978: (p_transaction_step_id => p_transaction_step_id
1979: ,p_person_id => p_creator_person_id
1980: ,p_name => 'P_PQ_QUA_INFORMATION13'
1981: ,p_value => p_qualifications(1).qua_information13);

Line 1982: hr_transaction_api.set_varchar2_value

1978: (p_transaction_step_id => p_transaction_step_id
1979: ,p_person_id => p_creator_person_id
1980: ,p_name => 'P_PQ_QUA_INFORMATION13'
1981: ,p_value => p_qualifications(1).qua_information13);
1982: hr_transaction_api.set_varchar2_value
1983: (p_transaction_step_id => p_transaction_step_id
1984: ,p_person_id => p_creator_person_id
1985: ,p_name => 'P_PQ_QUA_INFORMATION14'
1986: ,p_value => p_qualifications(1).qua_information14);

Line 1987: hr_transaction_api.set_varchar2_value

1983: (p_transaction_step_id => p_transaction_step_id
1984: ,p_person_id => p_creator_person_id
1985: ,p_name => 'P_PQ_QUA_INFORMATION14'
1986: ,p_value => p_qualifications(1).qua_information14);
1987: hr_transaction_api.set_varchar2_value
1988: (p_transaction_step_id => p_transaction_step_id
1989: ,p_person_id => p_creator_person_id
1990: ,p_name => 'P_PQ_QUA_INFORMATION15'
1991: ,p_value => p_qualifications(1).qua_information15);

Line 1992: hr_transaction_api.set_varchar2_value

1988: (p_transaction_step_id => p_transaction_step_id
1989: ,p_person_id => p_creator_person_id
1990: ,p_name => 'P_PQ_QUA_INFORMATION15'
1991: ,p_value => p_qualifications(1).qua_information15);
1992: hr_transaction_api.set_varchar2_value
1993: (p_transaction_step_id => p_transaction_step_id
1994: ,p_person_id => p_creator_person_id
1995: ,p_name => 'P_PQ_QUA_INFORMATION16'
1996: ,p_value => p_qualifications(1).qua_information16);

Line 1997: hr_transaction_api.set_varchar2_value

1993: (p_transaction_step_id => p_transaction_step_id
1994: ,p_person_id => p_creator_person_id
1995: ,p_name => 'P_PQ_QUA_INFORMATION16'
1996: ,p_value => p_qualifications(1).qua_information16);
1997: hr_transaction_api.set_varchar2_value
1998: (p_transaction_step_id => p_transaction_step_id
1999: ,p_person_id => p_creator_person_id
2000: ,p_name => 'P_PQ_QUA_INFORMATION17'
2001: ,p_value => p_qualifications(1).qua_information17);

Line 2002: hr_transaction_api.set_varchar2_value

1998: (p_transaction_step_id => p_transaction_step_id
1999: ,p_person_id => p_creator_person_id
2000: ,p_name => 'P_PQ_QUA_INFORMATION17'
2001: ,p_value => p_qualifications(1).qua_information17);
2002: hr_transaction_api.set_varchar2_value
2003: (p_transaction_step_id => p_transaction_step_id
2004: ,p_person_id => p_creator_person_id
2005: ,p_name => 'P_PQ_QUA_INFORMATION18'
2006: ,p_value => p_qualifications(1).qua_information18);

Line 2007: hr_transaction_api.set_varchar2_value

2003: (p_transaction_step_id => p_transaction_step_id
2004: ,p_person_id => p_creator_person_id
2005: ,p_name => 'P_PQ_QUA_INFORMATION18'
2006: ,p_value => p_qualifications(1).qua_information18);
2007: hr_transaction_api.set_varchar2_value
2008: (p_transaction_step_id => p_transaction_step_id
2009: ,p_person_id => p_creator_person_id
2010: ,p_name => 'P_PQ_QUA_INFORMATION19'
2011: ,p_value => p_qualifications(1).qua_information19);

Line 2012: hr_transaction_api.set_varchar2_value

2008: (p_transaction_step_id => p_transaction_step_id
2009: ,p_person_id => p_creator_person_id
2010: ,p_name => 'P_PQ_QUA_INFORMATION19'
2011: ,p_value => p_qualifications(1).qua_information19);
2012: hr_transaction_api.set_varchar2_value
2013: (p_transaction_step_id => p_transaction_step_id
2014: ,p_person_id => p_creator_person_id
2015: ,p_name => 'P_PQ_QUA_INFORMATION20'
2016: ,p_value => p_qualifications(1).qua_information20);

Line 2018: hr_transaction_api.set_varchar2_value

2014: ,p_person_id => p_creator_person_id
2015: ,p_name => 'P_PQ_QUA_INFORMATION20'
2016: ,p_value => p_qualifications(1).qua_information20);
2017:
2018: hr_transaction_api.set_varchar2_value
2019: (p_transaction_step_id => p_transaction_step_id
2020: ,p_person_id => p_creator_person_id
2021: ,p_name => 'P_PARTY_ID'
2022: ,p_value => p_qualifications(1).party_id);

Line 2024: hr_transaction_api.set_varchar2_value

2020: ,p_person_id => p_creator_person_id
2021: ,p_name => 'P_PARTY_ID'
2022: ,p_value => p_qualifications(1).party_id);
2023:
2024: hr_transaction_api.set_varchar2_value
2025: (p_transaction_step_id => p_transaction_step_id
2026: ,p_person_id => p_creator_person_id
2027: ,p_name => 'P_PEA_ATTRIBUTE_CATEGORY'
2028: ,p_value => p_qua_attendance(1).attribute_category);

Line 2030: hr_transaction_api.set_varchar2_value

2026: ,p_person_id => p_creator_person_id
2027: ,p_name => 'P_PEA_ATTRIBUTE_CATEGORY'
2028: ,p_value => p_qua_attendance(1).attribute_category);
2029:
2030: hr_transaction_api.set_varchar2_value
2031: (p_transaction_step_id => p_transaction_step_id
2032: ,p_person_id => p_creator_person_id
2033: ,p_name => 'P_PEA_ATTRIBUTE1'
2034: ,p_value => p_qua_attendance(1).attribute1);

Line 2036: hr_transaction_api.set_varchar2_value

2032: ,p_person_id => p_creator_person_id
2033: ,p_name => 'P_PEA_ATTRIBUTE1'
2034: ,p_value => p_qua_attendance(1).attribute1);
2035:
2036: hr_transaction_api.set_varchar2_value
2037: (p_transaction_step_id => p_transaction_step_id
2038: ,p_person_id => p_creator_person_id
2039: ,p_name => 'P_PEA_ATTRIBUTE2'
2040: ,p_value => p_qua_attendance(1).attribute2);

Line 2042: hr_transaction_api.set_varchar2_value

2038: ,p_person_id => p_creator_person_id
2039: ,p_name => 'P_PEA_ATTRIBUTE2'
2040: ,p_value => p_qua_attendance(1).attribute2);
2041:
2042: hr_transaction_api.set_varchar2_value
2043: (p_transaction_step_id => p_transaction_step_id
2044: ,p_person_id => p_creator_person_id
2045: ,p_name => 'P_PEA_ATTRIBUTE3'
2046: ,p_value => p_qua_attendance(1).attribute3);

Line 2048: hr_transaction_api.set_varchar2_value

2044: ,p_person_id => p_creator_person_id
2045: ,p_name => 'P_PEA_ATTRIBUTE3'
2046: ,p_value => p_qua_attendance(1).attribute3);
2047:
2048: hr_transaction_api.set_varchar2_value
2049: (p_transaction_step_id => p_transaction_step_id
2050: ,p_person_id => p_creator_person_id
2051: ,p_name => 'P_PEA_ATTRIBUTE4'
2052: ,p_value => p_qua_attendance(1).attribute4);

Line 2054: hr_transaction_api.set_varchar2_value

2050: ,p_person_id => p_creator_person_id
2051: ,p_name => 'P_PEA_ATTRIBUTE4'
2052: ,p_value => p_qua_attendance(1).attribute4);
2053:
2054: hr_transaction_api.set_varchar2_value
2055: (p_transaction_step_id => p_transaction_step_id
2056: ,p_person_id => p_creator_person_id
2057: ,p_name => 'P_PEA_ATTRIBUTE5'
2058: ,p_value => p_qua_attendance(1).attribute5);

Line 2060: hr_transaction_api.set_varchar2_value

2056: ,p_person_id => p_creator_person_id
2057: ,p_name => 'P_PEA_ATTRIBUTE5'
2058: ,p_value => p_qua_attendance(1).attribute5);
2059:
2060: hr_transaction_api.set_varchar2_value
2061: (p_transaction_step_id => p_transaction_step_id
2062: ,p_person_id => p_creator_person_id
2063: ,p_name => 'P_PEA_ATTRIBUTE6'
2064: ,p_value => p_qua_attendance(1).attribute6);

Line 2066: hr_transaction_api.set_varchar2_value

2062: ,p_person_id => p_creator_person_id
2063: ,p_name => 'P_PEA_ATTRIBUTE6'
2064: ,p_value => p_qua_attendance(1).attribute6);
2065:
2066: hr_transaction_api.set_varchar2_value
2067: (p_transaction_step_id => p_transaction_step_id
2068: ,p_person_id => p_creator_person_id
2069: ,p_name => 'P_PEA_ATTRIBUTE7'
2070: ,p_value => p_qua_attendance(1).attribute7);

Line 2072: hr_transaction_api.set_varchar2_value

2068: ,p_person_id => p_creator_person_id
2069: ,p_name => 'P_PEA_ATTRIBUTE7'
2070: ,p_value => p_qua_attendance(1).attribute7);
2071:
2072: hr_transaction_api.set_varchar2_value
2073: (p_transaction_step_id => p_transaction_step_id
2074: ,p_person_id => p_creator_person_id
2075: ,p_name => 'P_PEA_ATTRIBUTE8'
2076: ,p_value => p_qua_attendance(1).attribute8);

Line 2078: hr_transaction_api.set_varchar2_value

2074: ,p_person_id => p_creator_person_id
2075: ,p_name => 'P_PEA_ATTRIBUTE8'
2076: ,p_value => p_qua_attendance(1).attribute8);
2077:
2078: hr_transaction_api.set_varchar2_value
2079: (p_transaction_step_id => p_transaction_step_id
2080: ,p_person_id => p_creator_person_id
2081: ,p_name => 'P_PEA_ATTRIBUTE9'
2082: ,p_value => p_qua_attendance(1).attribute9);

Line 2084: hr_transaction_api.set_varchar2_value

2080: ,p_person_id => p_creator_person_id
2081: ,p_name => 'P_PEA_ATTRIBUTE9'
2082: ,p_value => p_qua_attendance(1).attribute9);
2083:
2084: hr_transaction_api.set_varchar2_value
2085: (p_transaction_step_id => p_transaction_step_id
2086: ,p_person_id => p_creator_person_id
2087: ,p_name => 'P_PEA_ATTRIBUTE10'
2088: ,p_value => p_qua_attendance(1).attribute10);

Line 2090: hr_transaction_api.set_varchar2_value

2086: ,p_person_id => p_creator_person_id
2087: ,p_name => 'P_PEA_ATTRIBUTE10'
2088: ,p_value => p_qua_attendance(1).attribute10);
2089:
2090: hr_transaction_api.set_varchar2_value
2091: (p_transaction_step_id => p_transaction_step_id
2092: ,p_person_id => p_creator_person_id
2093: ,p_name => 'P_PEA_ATTRIBUTE11'
2094: ,p_value => p_qua_attendance(1).attribute11);

Line 2096: hr_transaction_api.set_varchar2_value

2092: ,p_person_id => p_creator_person_id
2093: ,p_name => 'P_PEA_ATTRIBUTE11'
2094: ,p_value => p_qua_attendance(1).attribute11);
2095:
2096: hr_transaction_api.set_varchar2_value
2097: (p_transaction_step_id => p_transaction_step_id
2098: ,p_person_id => p_creator_person_id
2099: ,p_name => 'P_PEA_ATTRIBUTE12'
2100: ,p_value => p_qua_attendance(1).attribute12);

Line 2102: hr_transaction_api.set_varchar2_value

2098: ,p_person_id => p_creator_person_id
2099: ,p_name => 'P_PEA_ATTRIBUTE12'
2100: ,p_value => p_qua_attendance(1).attribute12);
2101:
2102: hr_transaction_api.set_varchar2_value
2103: (p_transaction_step_id => p_transaction_step_id
2104: ,p_person_id => p_creator_person_id
2105: ,p_name => 'P_PEA_ATTRIBUTE13'
2106: ,p_value => p_qua_attendance(1).attribute13);

Line 2108: hr_transaction_api.set_varchar2_value

2104: ,p_person_id => p_creator_person_id
2105: ,p_name => 'P_PEA_ATTRIBUTE13'
2106: ,p_value => p_qua_attendance(1).attribute13);
2107:
2108: hr_transaction_api.set_varchar2_value
2109: (p_transaction_step_id => p_transaction_step_id
2110: ,p_person_id => p_creator_person_id
2111: ,p_name => 'P_PEA_ATTRIBUTE14'
2112: ,p_value => p_qua_attendance(1).attribute14);

Line 2114: hr_transaction_api.set_varchar2_value

2110: ,p_person_id => p_creator_person_id
2111: ,p_name => 'P_PEA_ATTRIBUTE14'
2112: ,p_value => p_qua_attendance(1).attribute14);
2113:
2114: hr_transaction_api.set_varchar2_value
2115: (p_transaction_step_id => p_transaction_step_id
2116: ,p_person_id => p_creator_person_id
2117: ,p_name => 'P_PEA_ATTRIBUTE15'
2118: ,p_value => p_qua_attendance(1).attribute15);

Line 2120: hr_transaction_api.set_varchar2_value

2116: ,p_person_id => p_creator_person_id
2117: ,p_name => 'P_PEA_ATTRIBUTE15'
2118: ,p_value => p_qua_attendance(1).attribute15);
2119:
2120: hr_transaction_api.set_varchar2_value
2121: (p_transaction_step_id => p_transaction_step_id
2122: ,p_person_id => p_creator_person_id
2123: ,p_name => 'P_PEA_ATTRIBUTE16'
2124: ,p_value => p_qua_attendance(1).attribute16);

Line 2126: hr_transaction_api.set_varchar2_value

2122: ,p_person_id => p_creator_person_id
2123: ,p_name => 'P_PEA_ATTRIBUTE16'
2124: ,p_value => p_qua_attendance(1).attribute16);
2125:
2126: hr_transaction_api.set_varchar2_value
2127: (p_transaction_step_id => p_transaction_step_id
2128: ,p_person_id => p_creator_person_id
2129: ,p_name => 'P_PEA_ATTRIBUTE17'
2130: ,p_value => p_qua_attendance(1).attribute17);

Line 2132: hr_transaction_api.set_varchar2_value

2128: ,p_person_id => p_creator_person_id
2129: ,p_name => 'P_PEA_ATTRIBUTE17'
2130: ,p_value => p_qua_attendance(1).attribute17);
2131:
2132: hr_transaction_api.set_varchar2_value
2133: (p_transaction_step_id => p_transaction_step_id
2134: ,p_person_id => p_creator_person_id
2135: ,p_name => 'P_PEA_ATTRIBUTE18'
2136: ,p_value => p_qua_attendance(1).attribute18);

Line 2138: hr_transaction_api.set_varchar2_value

2134: ,p_person_id => p_creator_person_id
2135: ,p_name => 'P_PEA_ATTRIBUTE18'
2136: ,p_value => p_qua_attendance(1).attribute18);
2137:
2138: hr_transaction_api.set_varchar2_value
2139: (p_transaction_step_id => p_transaction_step_id
2140: ,p_person_id => p_creator_person_id
2141: ,p_name => 'P_PEA_ATTRIBUTE19'
2142: ,p_value => p_qua_attendance(1).attribute19);

Line 2144: hr_transaction_api.set_varchar2_value

2140: ,p_person_id => p_creator_person_id
2141: ,p_name => 'P_PEA_ATTRIBUTE19'
2142: ,p_value => p_qua_attendance(1).attribute19);
2143:
2144: hr_transaction_api.set_varchar2_value
2145: (p_transaction_step_id => p_transaction_step_id
2146: ,p_person_id => p_creator_person_id
2147: ,p_name => 'P_PEA_ATTRIBUTE20'
2148: ,p_value => p_qua_attendance(1).attribute20);

Line 2152: hr_transaction_api.set_varchar2_value

2148: ,p_value => p_qua_attendance(1).attribute20);
2149:
2150: l_subject_count := NVL(p_qua_subjects.count,0);
2151:
2152: hr_transaction_api.set_varchar2_value
2153: (p_transaction_step_id => p_transaction_step_id
2154: ,p_person_id => p_creator_person_id
2155: ,p_name => 'P_SUBJECT_COUNT'
2156: ,p_value => l_subject_count);

Line 2161: hr_transaction_api.set_varchar2_value

2157:
2158: hr_utility.set_location('Entering For Loop:'||l_proc,10);
2159: FOR i IN 1..l_subject_count LOOP
2160:
2161: hr_transaction_api.set_varchar2_value
2162: (p_transaction_step_id => p_transaction_step_id
2163: ,p_person_id => p_creator_person_id
2164: ,p_name => 'P_SUBJECTS_TAKEN_ID'||i
2165: ,p_value => p_qua_subjects(i).subjects_taken_id);

Line 2167: hr_transaction_api.set_varchar2_value

2163: ,p_person_id => p_creator_person_id
2164: ,p_name => 'P_SUBJECTS_TAKEN_ID'||i
2165: ,p_value => p_qua_subjects(i).subjects_taken_id);
2166:
2167: hr_transaction_api.set_varchar2_value
2168: (p_transaction_step_id => p_transaction_step_id
2169: ,p_person_id => p_creator_person_id
2170: ,p_name => 'P_PST_OBJECT_VERSION_NUMBER'||i
2171: ,p_value => p_qua_subjects(i).object_version_number);

Line 2173: hr_transaction_api.set_varchar2_value

2169: ,p_person_id => p_creator_person_id
2170: ,p_name => 'P_PST_OBJECT_VERSION_NUMBER'||i
2171: ,p_value => p_qua_subjects(i).object_version_number);
2172:
2173: hr_transaction_api.set_varchar2_value
2174: (p_transaction_step_id => p_transaction_step_id
2175: ,p_person_id => p_creator_person_id
2176: ,p_name => 'P_PST_SUBJECT'||i
2177: ,p_value => p_qua_subjects(i).subject);

Line 2179: hr_transaction_api.set_varchar2_value

2175: ,p_person_id => p_creator_person_id
2176: ,p_name => 'P_PST_SUBJECT'||i
2177: ,p_value => p_qua_subjects(i).subject);
2178:
2179: hr_transaction_api.set_varchar2_value
2180: (p_transaction_step_id => p_transaction_step_id
2181: ,p_person_id => p_creator_person_id
2182: ,p_name => 'P_PST_MAJOR'||i
2183: ,p_value => p_qua_subjects(i).major);

Line 2185: hr_transaction_api.set_date_value

2181: ,p_person_id => p_creator_person_id
2182: ,p_name => 'P_PST_MAJOR'||i
2183: ,p_value => p_qua_subjects(i).major);
2184:
2185: hr_transaction_api.set_date_value
2186: (p_transaction_step_id => p_transaction_step_id
2187: ,p_person_id => p_creator_person_id
2188: ,p_name => 'P_PST_START_DATE'||i
2189: ,p_value => p_qua_subjects(i).start_date);

Line 2191: hr_transaction_api.set_date_value

2187: ,p_person_id => p_creator_person_id
2188: ,p_name => 'P_PST_START_DATE'||i
2189: ,p_value => p_qua_subjects(i).start_date);
2190:
2191: hr_transaction_api.set_date_value
2192: (p_transaction_step_id => p_transaction_step_id
2193: ,p_person_id => p_creator_person_id
2194: ,p_name => 'P_PST_END_DATE'||i
2195: ,p_value => p_qua_subjects(i).end_date);

Line 2197: hr_transaction_api.set_varchar2_value

2193: ,p_person_id => p_creator_person_id
2194: ,p_name => 'P_PST_END_DATE'||i
2195: ,p_value => p_qua_subjects(i).end_date);
2196:
2197: hr_transaction_api.set_varchar2_value
2198: (p_transaction_step_id => p_transaction_step_id
2199: ,p_person_id => p_creator_person_id
2200: ,p_name => 'P_PST_SUBJECT_STATUS'||i
2201: ,p_value => p_qua_subjects(i).subject_status);

Line 2203: hr_transaction_api.set_varchar2_value

2199: ,p_person_id => p_creator_person_id
2200: ,p_name => 'P_PST_SUBJECT_STATUS'||i
2201: ,p_value => p_qua_subjects(i).subject_status);
2202:
2203: hr_transaction_api.set_varchar2_value
2204: (p_transaction_step_id => p_transaction_step_id
2205: ,p_person_id => p_creator_person_id
2206: ,p_name => 'P_PST_GRADE_ATTAINED'||i
2207: ,p_value => p_qua_subjects(i).grade_attained);

Line 2209: hr_transaction_api.set_varchar2_value

2205: ,p_person_id => p_creator_person_id
2206: ,p_name => 'P_PST_GRADE_ATTAINED'||i
2207: ,p_value => p_qua_subjects(i).grade_attained);
2208:
2209: hr_transaction_api.set_varchar2_value
2210: (p_transaction_step_id => p_transaction_step_id
2211: ,p_person_id => p_creator_person_id
2212: ,p_name => 'P_PST_DELETE_FLAG'||i
2213: ,p_value => p_qua_subjects(i).delete_flag);

Line 2215: hr_transaction_api.set_varchar2_value

2211: ,p_person_id => p_creator_person_id
2212: ,p_name => 'P_PST_DELETE_FLAG'||i
2213: ,p_value => p_qua_subjects(i).delete_flag);
2214:
2215: hr_transaction_api.set_varchar2_value
2216: (p_transaction_step_id => p_transaction_step_id
2217: ,p_person_id => p_creator_person_id
2218: ,p_name => 'P_PST_ATTRIBUTE_CATEGORY'||i
2219: ,p_value => p_qua_subjects(i).attribute_category);

Line 2221: hr_transaction_api.set_varchar2_value

2217: ,p_person_id => p_creator_person_id
2218: ,p_name => 'P_PST_ATTRIBUTE_CATEGORY'||i
2219: ,p_value => p_qua_subjects(i).attribute_category);
2220:
2221: hr_transaction_api.set_varchar2_value
2222: (p_transaction_step_id => p_transaction_step_id
2223: ,p_person_id => p_creator_person_id
2224: ,p_name => 'P_ATTRIBUTE1_PST'||i
2225: ,p_value => p_qua_subjects(i).attribute1);

Line 2227: hr_transaction_api.set_varchar2_value

2223: ,p_person_id => p_creator_person_id
2224: ,p_name => 'P_ATTRIBUTE1_PST'||i
2225: ,p_value => p_qua_subjects(i).attribute1);
2226:
2227: hr_transaction_api.set_varchar2_value
2228: (p_transaction_step_id => p_transaction_step_id
2229: ,p_person_id => p_creator_person_id
2230: ,p_name => 'P_ATTRIBUTE2_PST'||i
2231: ,p_value => p_qua_subjects(i).attribute2);

Line 2232: hr_transaction_api.set_varchar2_value

2228: (p_transaction_step_id => p_transaction_step_id
2229: ,p_person_id => p_creator_person_id
2230: ,p_name => 'P_ATTRIBUTE2_PST'||i
2231: ,p_value => p_qua_subjects(i).attribute2);
2232: hr_transaction_api.set_varchar2_value
2233: (p_transaction_step_id => p_transaction_step_id
2234: ,p_person_id => p_creator_person_id
2235: ,p_name => 'P_ATTRIBUTE3_PST'||i
2236: ,p_value => p_qua_subjects(i).attribute3);

Line 2237: hr_transaction_api.set_varchar2_value

2233: (p_transaction_step_id => p_transaction_step_id
2234: ,p_person_id => p_creator_person_id
2235: ,p_name => 'P_ATTRIBUTE3_PST'||i
2236: ,p_value => p_qua_subjects(i).attribute3);
2237: hr_transaction_api.set_varchar2_value
2238: (p_transaction_step_id => p_transaction_step_id
2239: ,p_person_id => p_creator_person_id
2240: ,p_name => 'P_ATTRIBUTE4_PST'||i
2241: ,p_value => p_qua_subjects(i).attribute4);

Line 2242: hr_transaction_api.set_varchar2_value

2238: (p_transaction_step_id => p_transaction_step_id
2239: ,p_person_id => p_creator_person_id
2240: ,p_name => 'P_ATTRIBUTE4_PST'||i
2241: ,p_value => p_qua_subjects(i).attribute4);
2242: hr_transaction_api.set_varchar2_value
2243: (p_transaction_step_id => p_transaction_step_id
2244: ,p_person_id => p_creator_person_id
2245: ,p_name => 'P_ATTRIBUTE5_PST'||i
2246: ,p_value => p_qua_subjects(i).attribute5);

Line 2247: hr_transaction_api.set_varchar2_value

2243: (p_transaction_step_id => p_transaction_step_id
2244: ,p_person_id => p_creator_person_id
2245: ,p_name => 'P_ATTRIBUTE5_PST'||i
2246: ,p_value => p_qua_subjects(i).attribute5);
2247: hr_transaction_api.set_varchar2_value
2248: (p_transaction_step_id => p_transaction_step_id
2249: ,p_person_id => p_creator_person_id
2250: ,p_name => 'P_ATTRIBUTE6_PST'||i
2251: ,p_value => p_qua_subjects(i).attribute6);

Line 2252: hr_transaction_api.set_varchar2_value

2248: (p_transaction_step_id => p_transaction_step_id
2249: ,p_person_id => p_creator_person_id
2250: ,p_name => 'P_ATTRIBUTE6_PST'||i
2251: ,p_value => p_qua_subjects(i).attribute6);
2252: hr_transaction_api.set_varchar2_value
2253: (p_transaction_step_id => p_transaction_step_id
2254: ,p_person_id => p_creator_person_id
2255: ,p_name => 'P_ATTRIBUTE7_PST'||i
2256: ,p_value => p_qua_subjects(i).attribute7);

Line 2257: hr_transaction_api.set_varchar2_value

2253: (p_transaction_step_id => p_transaction_step_id
2254: ,p_person_id => p_creator_person_id
2255: ,p_name => 'P_ATTRIBUTE7_PST'||i
2256: ,p_value => p_qua_subjects(i).attribute7);
2257: hr_transaction_api.set_varchar2_value
2258: (p_transaction_step_id => p_transaction_step_id
2259: ,p_person_id => p_creator_person_id
2260: ,p_name => 'P_ATTRIBUTE8_PST'||i
2261: ,p_value => p_qua_subjects(i).attribute8);

Line 2262: hr_transaction_api.set_varchar2_value

2258: (p_transaction_step_id => p_transaction_step_id
2259: ,p_person_id => p_creator_person_id
2260: ,p_name => 'P_ATTRIBUTE8_PST'||i
2261: ,p_value => p_qua_subjects(i).attribute8);
2262: hr_transaction_api.set_varchar2_value
2263: (p_transaction_step_id => p_transaction_step_id
2264: ,p_person_id => p_creator_person_id
2265: ,p_name => 'P_ATTRIBUTE9_PST'||i
2266: ,p_value => p_qua_subjects(i).attribute9);

Line 2267: hr_transaction_api.set_varchar2_value

2263: (p_transaction_step_id => p_transaction_step_id
2264: ,p_person_id => p_creator_person_id
2265: ,p_name => 'P_ATTRIBUTE9_PST'||i
2266: ,p_value => p_qua_subjects(i).attribute9);
2267: hr_transaction_api.set_varchar2_value
2268: (p_transaction_step_id => p_transaction_step_id
2269: ,p_person_id => p_creator_person_id
2270: ,p_name => 'P_ATTRIBUTE10_PST'||i
2271: ,p_value => p_qua_subjects(i).attribute10);

Line 2272: hr_transaction_api.set_varchar2_value

2268: (p_transaction_step_id => p_transaction_step_id
2269: ,p_person_id => p_creator_person_id
2270: ,p_name => 'P_ATTRIBUTE10_PST'||i
2271: ,p_value => p_qua_subjects(i).attribute10);
2272: hr_transaction_api.set_varchar2_value
2273: (p_transaction_step_id => p_transaction_step_id
2274: ,p_person_id => p_creator_person_id
2275: ,p_name => 'P_ATTRIBUTE11_PST'||i
2276: ,p_value => p_qua_subjects(i).attribute11);

Line 2277: hr_transaction_api.set_varchar2_value

2273: (p_transaction_step_id => p_transaction_step_id
2274: ,p_person_id => p_creator_person_id
2275: ,p_name => 'P_ATTRIBUTE11_PST'||i
2276: ,p_value => p_qua_subjects(i).attribute11);
2277: hr_transaction_api.set_varchar2_value
2278: (p_transaction_step_id => p_transaction_step_id
2279: ,p_person_id => p_creator_person_id
2280: ,p_name => 'P_ATTRIBUTE12_PST'||i
2281: ,p_value => p_qua_subjects(i).attribute12);

Line 2282: hr_transaction_api.set_varchar2_value

2278: (p_transaction_step_id => p_transaction_step_id
2279: ,p_person_id => p_creator_person_id
2280: ,p_name => 'P_ATTRIBUTE12_PST'||i
2281: ,p_value => p_qua_subjects(i).attribute12);
2282: hr_transaction_api.set_varchar2_value
2283: (p_transaction_step_id => p_transaction_step_id
2284: ,p_person_id => p_creator_person_id
2285: ,p_name => 'P_ATTRIBUTE13_PST'||i
2286: ,p_value => p_qua_subjects(i).attribute13);

Line 2287: hr_transaction_api.set_varchar2_value

2283: (p_transaction_step_id => p_transaction_step_id
2284: ,p_person_id => p_creator_person_id
2285: ,p_name => 'P_ATTRIBUTE13_PST'||i
2286: ,p_value => p_qua_subjects(i).attribute13);
2287: hr_transaction_api.set_varchar2_value
2288: (p_transaction_step_id => p_transaction_step_id
2289: ,p_person_id => p_creator_person_id
2290: ,p_name => 'P_ATTRIBUTE14_PST'||i
2291: ,p_value => p_qua_subjects(i).attribute14);

Line 2292: hr_transaction_api.set_varchar2_value

2288: (p_transaction_step_id => p_transaction_step_id
2289: ,p_person_id => p_creator_person_id
2290: ,p_name => 'P_ATTRIBUTE14_PST'||i
2291: ,p_value => p_qua_subjects(i).attribute14);
2292: hr_transaction_api.set_varchar2_value
2293: (p_transaction_step_id => p_transaction_step_id
2294: ,p_person_id => p_creator_person_id
2295: ,p_name => 'P_ATTRIBUTE15_PST'||i
2296: ,p_value => p_qua_subjects(i).attribute15);

Line 2297: hr_transaction_api.set_varchar2_value

2293: (p_transaction_step_id => p_transaction_step_id
2294: ,p_person_id => p_creator_person_id
2295: ,p_name => 'P_ATTRIBUTE15_PST'||i
2296: ,p_value => p_qua_subjects(i).attribute15);
2297: hr_transaction_api.set_varchar2_value
2298: (p_transaction_step_id => p_transaction_step_id
2299: ,p_person_id => p_creator_person_id
2300: ,p_name => 'P_ATTRIBUTE16_PST'||i
2301: ,p_value => p_qua_subjects(i).attribute16);

Line 2302: hr_transaction_api.set_varchar2_value

2298: (p_transaction_step_id => p_transaction_step_id
2299: ,p_person_id => p_creator_person_id
2300: ,p_name => 'P_ATTRIBUTE16_PST'||i
2301: ,p_value => p_qua_subjects(i).attribute16);
2302: hr_transaction_api.set_varchar2_value
2303: (p_transaction_step_id => p_transaction_step_id
2304: ,p_person_id => p_creator_person_id
2305: ,p_name => 'P_ATTRIBUTE17_PST'||i
2306: ,p_value => p_qua_subjects(i).attribute17);

Line 2307: hr_transaction_api.set_varchar2_value

2303: (p_transaction_step_id => p_transaction_step_id
2304: ,p_person_id => p_creator_person_id
2305: ,p_name => 'P_ATTRIBUTE17_PST'||i
2306: ,p_value => p_qua_subjects(i).attribute17);
2307: hr_transaction_api.set_varchar2_value
2308: (p_transaction_step_id => p_transaction_step_id
2309: ,p_person_id => p_creator_person_id
2310: ,p_name => 'P_ATTRIBUTE18_PST'||i
2311: ,p_value => p_qua_subjects(i).attribute18);

Line 2312: hr_transaction_api.set_varchar2_value

2308: (p_transaction_step_id => p_transaction_step_id
2309: ,p_person_id => p_creator_person_id
2310: ,p_name => 'P_ATTRIBUTE18_PST'||i
2311: ,p_value => p_qua_subjects(i).attribute18);
2312: hr_transaction_api.set_varchar2_value
2313: (p_transaction_step_id => p_transaction_step_id
2314: ,p_person_id => p_creator_person_id
2315: ,p_name => 'P_ATTRIBUTE19_PST'||i
2316: ,p_value => p_qua_subjects(i).attribute19);

Line 2317: hr_transaction_api.set_varchar2_value

2313: (p_transaction_step_id => p_transaction_step_id
2314: ,p_person_id => p_creator_person_id
2315: ,p_name => 'P_ATTRIBUTE19_PST'||i
2316: ,p_value => p_qua_subjects(i).attribute19);
2317: hr_transaction_api.set_varchar2_value
2318: (p_transaction_step_id => p_transaction_step_id
2319: ,p_person_id => p_creator_person_id
2320: ,p_name => 'P_ATTRIBUTE20_PST'||i
2321: ,p_value => p_qua_subjects(i).attribute20);

Line 2322: hr_transaction_api.set_varchar2_value

2318: (p_transaction_step_id => p_transaction_step_id
2319: ,p_person_id => p_creator_person_id
2320: ,p_name => 'P_ATTRIBUTE20_PST'||i
2321: ,p_value => p_qua_subjects(i).attribute20);
2322: hr_transaction_api.set_varchar2_value
2323: (p_transaction_step_id => p_transaction_step_id
2324: ,p_person_id => p_creator_person_id
2325: ,p_name => 'P_SUB_INFORMATION_CATEGORY'||i
2326: ,p_value => p_qua_subjects(i).sub_information_category);

Line 2327: hr_transaction_api.set_varchar2_value

2323: (p_transaction_step_id => p_transaction_step_id
2324: ,p_person_id => p_creator_person_id
2325: ,p_name => 'P_SUB_INFORMATION_CATEGORY'||i
2326: ,p_value => p_qua_subjects(i).sub_information_category);
2327: hr_transaction_api.set_varchar2_value
2328: (p_transaction_step_id => p_transaction_step_id
2329: ,p_person_id => p_creator_person_id
2330: ,p_name => 'P_SUB_INFORMATION1_PST'||i
2331: ,p_value => p_qua_subjects(i).sub_information1);

Line 2332: hr_transaction_api.set_varchar2_value

2328: (p_transaction_step_id => p_transaction_step_id
2329: ,p_person_id => p_creator_person_id
2330: ,p_name => 'P_SUB_INFORMATION1_PST'||i
2331: ,p_value => p_qua_subjects(i).sub_information1);
2332: hr_transaction_api.set_varchar2_value
2333: (p_transaction_step_id => p_transaction_step_id
2334: ,p_person_id => p_creator_person_id
2335: ,p_name => 'P_SUB_INFORMATION2_PST'||i
2336: ,p_value => p_qua_subjects(i).sub_information2);

Line 2337: hr_transaction_api.set_varchar2_value

2333: (p_transaction_step_id => p_transaction_step_id
2334: ,p_person_id => p_creator_person_id
2335: ,p_name => 'P_SUB_INFORMATION2_PST'||i
2336: ,p_value => p_qua_subjects(i).sub_information2);
2337: hr_transaction_api.set_varchar2_value
2338: (p_transaction_step_id => p_transaction_step_id
2339: ,p_person_id => p_creator_person_id
2340: ,p_name => 'P_SUB_INFORMATION3_PST'||i
2341: ,p_value => p_qua_subjects(i).sub_information3);

Line 2342: hr_transaction_api.set_varchar2_value

2338: (p_transaction_step_id => p_transaction_step_id
2339: ,p_person_id => p_creator_person_id
2340: ,p_name => 'P_SUB_INFORMATION3_PST'||i
2341: ,p_value => p_qua_subjects(i).sub_information3);
2342: hr_transaction_api.set_varchar2_value
2343: (p_transaction_step_id => p_transaction_step_id
2344: ,p_person_id => p_creator_person_id
2345: ,p_name => 'P_SUB_INFORMATION4_PST'||i
2346: ,p_value => p_qua_subjects(i).sub_information4);

Line 2347: hr_transaction_api.set_varchar2_value

2343: (p_transaction_step_id => p_transaction_step_id
2344: ,p_person_id => p_creator_person_id
2345: ,p_name => 'P_SUB_INFORMATION4_PST'||i
2346: ,p_value => p_qua_subjects(i).sub_information4);
2347: hr_transaction_api.set_varchar2_value
2348: (p_transaction_step_id => p_transaction_step_id
2349: ,p_person_id => p_creator_person_id
2350: ,p_name => 'P_SUB_INFORMATION5_PST'||i
2351: ,p_value => p_qua_subjects(i).sub_information5);

Line 2352: hr_transaction_api.set_varchar2_value

2348: (p_transaction_step_id => p_transaction_step_id
2349: ,p_person_id => p_creator_person_id
2350: ,p_name => 'P_SUB_INFORMATION5_PST'||i
2351: ,p_value => p_qua_subjects(i).sub_information5);
2352: hr_transaction_api.set_varchar2_value
2353: (p_transaction_step_id => p_transaction_step_id
2354: ,p_person_id => p_creator_person_id
2355: ,p_name => 'P_SUB_INFORMATION6_PST'||i
2356: ,p_value => p_qua_subjects(i).sub_information6);

Line 2357: hr_transaction_api.set_varchar2_value

2353: (p_transaction_step_id => p_transaction_step_id
2354: ,p_person_id => p_creator_person_id
2355: ,p_name => 'P_SUB_INFORMATION6_PST'||i
2356: ,p_value => p_qua_subjects(i).sub_information6);
2357: hr_transaction_api.set_varchar2_value
2358: (p_transaction_step_id => p_transaction_step_id
2359: ,p_person_id => p_creator_person_id
2360: ,p_name => 'P_SUB_INFORMATION7_PST'||i
2361: ,p_value => p_qua_subjects(i).sub_information7);

Line 2362: hr_transaction_api.set_varchar2_value

2358: (p_transaction_step_id => p_transaction_step_id
2359: ,p_person_id => p_creator_person_id
2360: ,p_name => 'P_SUB_INFORMATION7_PST'||i
2361: ,p_value => p_qua_subjects(i).sub_information7);
2362: hr_transaction_api.set_varchar2_value
2363: (p_transaction_step_id => p_transaction_step_id
2364: ,p_person_id => p_creator_person_id
2365: ,p_name => 'P_SUB_INFORMATION8_PST'||i
2366: ,p_value => p_qua_subjects(i).sub_information8);

Line 2367: hr_transaction_api.set_varchar2_value

2363: (p_transaction_step_id => p_transaction_step_id
2364: ,p_person_id => p_creator_person_id
2365: ,p_name => 'P_SUB_INFORMATION8_PST'||i
2366: ,p_value => p_qua_subjects(i).sub_information8);
2367: hr_transaction_api.set_varchar2_value
2368: (p_transaction_step_id => p_transaction_step_id
2369: ,p_person_id => p_creator_person_id
2370: ,p_name => 'P_SUB_INFORMATION9_PST'||i
2371: ,p_value => p_qua_subjects(i).sub_information9);

Line 2372: hr_transaction_api.set_varchar2_value

2368: (p_transaction_step_id => p_transaction_step_id
2369: ,p_person_id => p_creator_person_id
2370: ,p_name => 'P_SUB_INFORMATION9_PST'||i
2371: ,p_value => p_qua_subjects(i).sub_information9);
2372: hr_transaction_api.set_varchar2_value
2373: (p_transaction_step_id => p_transaction_step_id
2374: ,p_person_id => p_creator_person_id
2375: ,p_name => 'P_SUB_INFORMATION10_PST'||i
2376: ,p_value => p_qua_subjects(i).sub_information10);

Line 2377: hr_transaction_api.set_varchar2_value

2373: (p_transaction_step_id => p_transaction_step_id
2374: ,p_person_id => p_creator_person_id
2375: ,p_name => 'P_SUB_INFORMATION10_PST'||i
2376: ,p_value => p_qua_subjects(i).sub_information10);
2377: hr_transaction_api.set_varchar2_value
2378: (p_transaction_step_id => p_transaction_step_id
2379: ,p_person_id => p_creator_person_id
2380: ,p_name => 'P_SUB_INFORMATION11_PST'||i
2381: ,p_value => p_qua_subjects(i).sub_information11);

Line 2382: hr_transaction_api.set_varchar2_value

2378: (p_transaction_step_id => p_transaction_step_id
2379: ,p_person_id => p_creator_person_id
2380: ,p_name => 'P_SUB_INFORMATION11_PST'||i
2381: ,p_value => p_qua_subjects(i).sub_information11);
2382: hr_transaction_api.set_varchar2_value
2383: (p_transaction_step_id => p_transaction_step_id
2384: ,p_person_id => p_creator_person_id
2385: ,p_name => 'P_SUB_INFORMATION12_PST'||i
2386: ,p_value => p_qua_subjects(i).sub_information12);

Line 2387: hr_transaction_api.set_varchar2_value

2383: (p_transaction_step_id => p_transaction_step_id
2384: ,p_person_id => p_creator_person_id
2385: ,p_name => 'P_SUB_INFORMATION12_PST'||i
2386: ,p_value => p_qua_subjects(i).sub_information12);
2387: hr_transaction_api.set_varchar2_value
2388: (p_transaction_step_id => p_transaction_step_id
2389: ,p_person_id => p_creator_person_id
2390: ,p_name => 'P_SUB_INFORMATION13_PST'||i
2391: ,p_value => p_qua_subjects(i).sub_information13);

Line 2392: hr_transaction_api.set_varchar2_value

2388: (p_transaction_step_id => p_transaction_step_id
2389: ,p_person_id => p_creator_person_id
2390: ,p_name => 'P_SUB_INFORMATION13_PST'||i
2391: ,p_value => p_qua_subjects(i).sub_information13);
2392: hr_transaction_api.set_varchar2_value
2393: (p_transaction_step_id => p_transaction_step_id
2394: ,p_person_id => p_creator_person_id
2395: ,p_name => 'P_SUB_INFORMATION14_PST'||i
2396: ,p_value => p_qua_subjects(i).sub_information14);

Line 2397: hr_transaction_api.set_varchar2_value

2393: (p_transaction_step_id => p_transaction_step_id
2394: ,p_person_id => p_creator_person_id
2395: ,p_name => 'P_SUB_INFORMATION14_PST'||i
2396: ,p_value => p_qua_subjects(i).sub_information14);
2397: hr_transaction_api.set_varchar2_value
2398: (p_transaction_step_id => p_transaction_step_id
2399: ,p_person_id => p_creator_person_id
2400: ,p_name => 'P_SUB_INFORMATION15_PST'||i
2401: ,p_value => p_qua_subjects(i).sub_information15);

Line 2402: hr_transaction_api.set_varchar2_value

2398: (p_transaction_step_id => p_transaction_step_id
2399: ,p_person_id => p_creator_person_id
2400: ,p_name => 'P_SUB_INFORMATION15_PST'||i
2401: ,p_value => p_qua_subjects(i).sub_information15);
2402: hr_transaction_api.set_varchar2_value
2403: (p_transaction_step_id => p_transaction_step_id
2404: ,p_person_id => p_creator_person_id
2405: ,p_name => 'P_SUB_INFORMATION16_PST'||i
2406: ,p_value => p_qua_subjects(i).sub_information16);

Line 2407: hr_transaction_api.set_varchar2_value

2403: (p_transaction_step_id => p_transaction_step_id
2404: ,p_person_id => p_creator_person_id
2405: ,p_name => 'P_SUB_INFORMATION16_PST'||i
2406: ,p_value => p_qua_subjects(i).sub_information16);
2407: hr_transaction_api.set_varchar2_value
2408: (p_transaction_step_id => p_transaction_step_id
2409: ,p_person_id => p_creator_person_id
2410: ,p_name => 'P_SUB_INFORMATION17_PST'||i
2411: ,p_value => p_qua_subjects(i).sub_information17);

Line 2412: hr_transaction_api.set_varchar2_value

2408: (p_transaction_step_id => p_transaction_step_id
2409: ,p_person_id => p_creator_person_id
2410: ,p_name => 'P_SUB_INFORMATION17_PST'||i
2411: ,p_value => p_qua_subjects(i).sub_information17);
2412: hr_transaction_api.set_varchar2_value
2413: (p_transaction_step_id => p_transaction_step_id
2414: ,p_person_id => p_creator_person_id
2415: ,p_name => 'P_SUB_INFORMATION18_PST'||i
2416: ,p_value => p_qua_subjects(i).sub_information18);

Line 2417: hr_transaction_api.set_varchar2_value

2413: (p_transaction_step_id => p_transaction_step_id
2414: ,p_person_id => p_creator_person_id
2415: ,p_name => 'P_SUB_INFORMATION18_PST'||i
2416: ,p_value => p_qua_subjects(i).sub_information18);
2417: hr_transaction_api.set_varchar2_value
2418: (p_transaction_step_id => p_transaction_step_id
2419: ,p_person_id => p_creator_person_id
2420: ,p_name => 'P_SUB_INFORMATION19_PST'||i
2421: ,p_value => p_qua_subjects(i).sub_information19);

Line 2422: hr_transaction_api.set_varchar2_value

2418: (p_transaction_step_id => p_transaction_step_id
2419: ,p_person_id => p_creator_person_id
2420: ,p_name => 'P_SUB_INFORMATION19_PST'||i
2421: ,p_value => p_qua_subjects(i).sub_information19);
2422: hr_transaction_api.set_varchar2_value
2423: (p_transaction_step_id => p_transaction_step_id
2424: ,p_person_id => p_creator_person_id
2425: ,p_name => 'P_SUB_INFORMATION20_PST'||i
2426: ,p_value => p_qua_subjects(i).sub_information20);

Line 2431: hr_transaction_api.set_varchar2_value

2427:
2428: END LOOP;
2429: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
2430:
2431: hr_transaction_api.set_varchar2_value
2432: (p_transaction_step_id => p_transaction_step_id
2433: ,p_person_id => p_creator_person_id
2434: ,p_name => 'P_REVIEW_PROC_CALL'
2435: ,p_value => p_proc_call);

Line 2437: hr_transaction_api.set_varchar2_value

2433: ,p_person_id => p_creator_person_id
2434: ,p_name => 'P_REVIEW_PROC_CALL'
2435: ,p_value => p_proc_call);
2436:
2437: hr_transaction_api.set_varchar2_value
2438: (p_transaction_step_id => p_transaction_step_id
2439: ,p_person_id => p_creator_person_id
2440: ,p_name => 'P_REVIEW_ACTID'
2441: ,p_value => p_actid);

Line 3649: hr_transaction_api.get_varchar2_value

3645: BEGIN
3646:
3647: hr_utility.set_location('Entering:'||l_proc, 5);
3648: p_mode :=
3649: hr_transaction_api.get_varchar2_value
3650: (p_transaction_step_id => p_transaction_step_id
3651: ,p_name => 'P_MODE');
3652:
3653: l_subject_count := to_number(

Line 3654: hr_transaction_api.get_varchar2_value

3650: (p_transaction_step_id => p_transaction_step_id
3651: ,p_name => 'P_MODE');
3652:
3653: l_subject_count := to_number(
3654: hr_transaction_api.get_varchar2_value
3655: (p_transaction_step_id => p_transaction_step_id
3656: ,p_name => 'P_SUBJECT_COUNT'));
3657:
3658: p_qua_attendance := SSHR_QUA_ATTENDANCE_TAB_TYP();

Line 3664: to_number(hr_transaction_api.get_varchar2_value

3660: hr_utility.set_location('Entering For Loop:'||l_proc,10);
3661: FOR i IN 1..NVL(l_attendance_count,0) LOOP
3662: p_qua_attendance.extend;
3663: p_qua_attendance(i) := SSHR_QUA_ATTENDANCE_OBJ_TYP(
3664: to_number(hr_transaction_api.get_varchar2_value
3665: (p_transaction_step_id => p_transaction_step_id
3666: ,p_name => 'P_ATTENDANCE_ID')),
3667: hr_transaction_api.get_date_value
3668: (p_transaction_step_id => p_transaction_step_id

Line 3667: hr_transaction_api.get_date_value

3663: p_qua_attendance(i) := SSHR_QUA_ATTENDANCE_OBJ_TYP(
3664: to_number(hr_transaction_api.get_varchar2_value
3665: (p_transaction_step_id => p_transaction_step_id
3666: ,p_name => 'P_ATTENDANCE_ID')),
3667: hr_transaction_api.get_date_value
3668: (p_transaction_step_id => p_transaction_step_id
3669: ,p_name => 'P_PEA_START_DATE'),
3670: to_number(hr_transaction_api.get_varchar2_value
3671: (p_transaction_step_id => p_transaction_step_id

Line 3670: to_number(hr_transaction_api.get_varchar2_value

3666: ,p_name => 'P_ATTENDANCE_ID')),
3667: hr_transaction_api.get_date_value
3668: (p_transaction_step_id => p_transaction_step_id
3669: ,p_name => 'P_PEA_START_DATE'),
3670: to_number(hr_transaction_api.get_varchar2_value
3671: (p_transaction_step_id => p_transaction_step_id
3672: ,p_name => 'P_PEA_PERSON_ID')),
3673: hr_transaction_api.get_varchar2_value
3674: (p_transaction_step_id => p_transaction_step_id

Line 3673: hr_transaction_api.get_varchar2_value

3669: ,p_name => 'P_PEA_START_DATE'),
3670: to_number(hr_transaction_api.get_varchar2_value
3671: (p_transaction_step_id => p_transaction_step_id
3672: ,p_name => 'P_PEA_PERSON_ID')),
3673: hr_transaction_api.get_varchar2_value
3674: (p_transaction_step_id => p_transaction_step_id
3675: ,p_name => 'P_PEA_FULL_TIME'),
3676: hr_transaction_api.get_date_value
3677: (p_transaction_step_id => p_transaction_step_id

Line 3676: hr_transaction_api.get_date_value

3672: ,p_name => 'P_PEA_PERSON_ID')),
3673: hr_transaction_api.get_varchar2_value
3674: (p_transaction_step_id => p_transaction_step_id
3675: ,p_name => 'P_PEA_FULL_TIME'),
3676: hr_transaction_api.get_date_value
3677: (p_transaction_step_id => p_transaction_step_id
3678: ,p_name => 'P_PEA_END_DATE'),
3679: to_number(hr_transaction_api.get_varchar2_value
3680: (p_transaction_step_id => p_transaction_step_id

Line 3679: to_number(hr_transaction_api.get_varchar2_value

3675: ,p_name => 'P_PEA_FULL_TIME'),
3676: hr_transaction_api.get_date_value
3677: (p_transaction_step_id => p_transaction_step_id
3678: ,p_name => 'P_PEA_END_DATE'),
3679: to_number(hr_transaction_api.get_varchar2_value
3680: (p_transaction_step_id => p_transaction_step_id
3681: ,p_name => 'P_ESTABLISHMENT_ID')),
3682: to_number(hr_transaction_api.get_varchar2_value
3683: (p_transaction_step_id => p_transaction_step_id

Line 3682: to_number(hr_transaction_api.get_varchar2_value

3678: ,p_name => 'P_PEA_END_DATE'),
3679: to_number(hr_transaction_api.get_varchar2_value
3680: (p_transaction_step_id => p_transaction_step_id
3681: ,p_name => 'P_ESTABLISHMENT_ID')),
3682: to_number(hr_transaction_api.get_varchar2_value
3683: (p_transaction_step_id => p_transaction_step_id
3684: ,p_name => 'P_PEA_OBJECT_VERSION_NUMBER')),
3685: hr_transaction_api.get_varchar2_value
3686: (p_transaction_step_id => p_transaction_step_id

Line 3685: hr_transaction_api.get_varchar2_value

3681: ,p_name => 'P_ESTABLISHMENT_ID')),
3682: to_number(hr_transaction_api.get_varchar2_value
3683: (p_transaction_step_id => p_transaction_step_id
3684: ,p_name => 'P_PEA_OBJECT_VERSION_NUMBER')),
3685: hr_transaction_api.get_varchar2_value
3686: (p_transaction_step_id => p_transaction_step_id
3687: ,p_name => 'P_BUSINESS_GROUP_ID'),
3688: hr_transaction_api.get_varchar2_value
3689: (p_transaction_step_id => p_transaction_step_id

Line 3688: hr_transaction_api.get_varchar2_value

3684: ,p_name => 'P_PEA_OBJECT_VERSION_NUMBER')),
3685: hr_transaction_api.get_varchar2_value
3686: (p_transaction_step_id => p_transaction_step_id
3687: ,p_name => 'P_BUSINESS_GROUP_ID'),
3688: hr_transaction_api.get_varchar2_value
3689: (p_transaction_step_id => p_transaction_step_id
3690: ,p_name => 'P_PEA_ATTRIBUTE_CATEGORY'),
3691: hr_transaction_api.get_varchar2_value
3692: (p_transaction_step_id => p_transaction_step_id

Line 3691: hr_transaction_api.get_varchar2_value

3687: ,p_name => 'P_BUSINESS_GROUP_ID'),
3688: hr_transaction_api.get_varchar2_value
3689: (p_transaction_step_id => p_transaction_step_id
3690: ,p_name => 'P_PEA_ATTRIBUTE_CATEGORY'),
3691: hr_transaction_api.get_varchar2_value
3692: (p_transaction_step_id => p_transaction_step_id
3693: ,p_name => 'P_PEA_ATTRIBUTE1'),
3694: hr_transaction_api.get_varchar2_value
3695: (p_transaction_step_id => p_transaction_step_id

Line 3694: hr_transaction_api.get_varchar2_value

3690: ,p_name => 'P_PEA_ATTRIBUTE_CATEGORY'),
3691: hr_transaction_api.get_varchar2_value
3692: (p_transaction_step_id => p_transaction_step_id
3693: ,p_name => 'P_PEA_ATTRIBUTE1'),
3694: hr_transaction_api.get_varchar2_value
3695: (p_transaction_step_id => p_transaction_step_id
3696: ,p_name => 'P_PEA_ATTRIBUTE2'),
3697: hr_transaction_api.get_varchar2_value
3698: (p_transaction_step_id => p_transaction_step_id

Line 3697: hr_transaction_api.get_varchar2_value

3693: ,p_name => 'P_PEA_ATTRIBUTE1'),
3694: hr_transaction_api.get_varchar2_value
3695: (p_transaction_step_id => p_transaction_step_id
3696: ,p_name => 'P_PEA_ATTRIBUTE2'),
3697: hr_transaction_api.get_varchar2_value
3698: (p_transaction_step_id => p_transaction_step_id
3699: ,p_name => 'P_PEA_ATTRIBUTE3'),
3700: hr_transaction_api.get_varchar2_value
3701: (p_transaction_step_id => p_transaction_step_id

Line 3700: hr_transaction_api.get_varchar2_value

3696: ,p_name => 'P_PEA_ATTRIBUTE2'),
3697: hr_transaction_api.get_varchar2_value
3698: (p_transaction_step_id => p_transaction_step_id
3699: ,p_name => 'P_PEA_ATTRIBUTE3'),
3700: hr_transaction_api.get_varchar2_value
3701: (p_transaction_step_id => p_transaction_step_id
3702: ,p_name => 'P_PEA_ATTRIBUTE4'),
3703: hr_transaction_api.get_varchar2_value
3704: (p_transaction_step_id => p_transaction_step_id

Line 3703: hr_transaction_api.get_varchar2_value

3699: ,p_name => 'P_PEA_ATTRIBUTE3'),
3700: hr_transaction_api.get_varchar2_value
3701: (p_transaction_step_id => p_transaction_step_id
3702: ,p_name => 'P_PEA_ATTRIBUTE4'),
3703: hr_transaction_api.get_varchar2_value
3704: (p_transaction_step_id => p_transaction_step_id
3705: ,p_name => 'P_PEA_ATTRIBUTE5'),
3706: hr_transaction_api.get_varchar2_value
3707: (p_transaction_step_id => p_transaction_step_id

Line 3706: hr_transaction_api.get_varchar2_value

3702: ,p_name => 'P_PEA_ATTRIBUTE4'),
3703: hr_transaction_api.get_varchar2_value
3704: (p_transaction_step_id => p_transaction_step_id
3705: ,p_name => 'P_PEA_ATTRIBUTE5'),
3706: hr_transaction_api.get_varchar2_value
3707: (p_transaction_step_id => p_transaction_step_id
3708: ,p_name => 'P_PEA_ATTRIBUTE6'),
3709: hr_transaction_api.get_varchar2_value
3710: (p_transaction_step_id => p_transaction_step_id

Line 3709: hr_transaction_api.get_varchar2_value

3705: ,p_name => 'P_PEA_ATTRIBUTE5'),
3706: hr_transaction_api.get_varchar2_value
3707: (p_transaction_step_id => p_transaction_step_id
3708: ,p_name => 'P_PEA_ATTRIBUTE6'),
3709: hr_transaction_api.get_varchar2_value
3710: (p_transaction_step_id => p_transaction_step_id
3711: ,p_name => 'P_PEA_ATTRIBUTE7'),
3712: hr_transaction_api.get_varchar2_value
3713: (p_transaction_step_id => p_transaction_step_id

Line 3712: hr_transaction_api.get_varchar2_value

3708: ,p_name => 'P_PEA_ATTRIBUTE6'),
3709: hr_transaction_api.get_varchar2_value
3710: (p_transaction_step_id => p_transaction_step_id
3711: ,p_name => 'P_PEA_ATTRIBUTE7'),
3712: hr_transaction_api.get_varchar2_value
3713: (p_transaction_step_id => p_transaction_step_id
3714: ,p_name => 'P_PEA_ATTRIBUTE8'),
3715: hr_transaction_api.get_varchar2_value
3716: (p_transaction_step_id => p_transaction_step_id

Line 3715: hr_transaction_api.get_varchar2_value

3711: ,p_name => 'P_PEA_ATTRIBUTE7'),
3712: hr_transaction_api.get_varchar2_value
3713: (p_transaction_step_id => p_transaction_step_id
3714: ,p_name => 'P_PEA_ATTRIBUTE8'),
3715: hr_transaction_api.get_varchar2_value
3716: (p_transaction_step_id => p_transaction_step_id
3717: ,p_name => 'P_PEA_ATTRIBUTE9'),
3718: hr_transaction_api.get_varchar2_value
3719: (p_transaction_step_id => p_transaction_step_id

Line 3718: hr_transaction_api.get_varchar2_value

3714: ,p_name => 'P_PEA_ATTRIBUTE8'),
3715: hr_transaction_api.get_varchar2_value
3716: (p_transaction_step_id => p_transaction_step_id
3717: ,p_name => 'P_PEA_ATTRIBUTE9'),
3718: hr_transaction_api.get_varchar2_value
3719: (p_transaction_step_id => p_transaction_step_id
3720: ,p_name => 'P_PEA_ATTRIBUTE10'),
3721: hr_transaction_api.get_varchar2_value
3722: (p_transaction_step_id => p_transaction_step_id

Line 3721: hr_transaction_api.get_varchar2_value

3717: ,p_name => 'P_PEA_ATTRIBUTE9'),
3718: hr_transaction_api.get_varchar2_value
3719: (p_transaction_step_id => p_transaction_step_id
3720: ,p_name => 'P_PEA_ATTRIBUTE10'),
3721: hr_transaction_api.get_varchar2_value
3722: (p_transaction_step_id => p_transaction_step_id
3723: ,p_name => 'P_PEA_ATTRIBUTE11'),
3724: hr_transaction_api.get_varchar2_value
3725: (p_transaction_step_id => p_transaction_step_id

Line 3724: hr_transaction_api.get_varchar2_value

3720: ,p_name => 'P_PEA_ATTRIBUTE10'),
3721: hr_transaction_api.get_varchar2_value
3722: (p_transaction_step_id => p_transaction_step_id
3723: ,p_name => 'P_PEA_ATTRIBUTE11'),
3724: hr_transaction_api.get_varchar2_value
3725: (p_transaction_step_id => p_transaction_step_id
3726: ,p_name => 'P_PEA_ATTRIBUTE12'),
3727: hr_transaction_api.get_varchar2_value
3728: (p_transaction_step_id => p_transaction_step_id

Line 3727: hr_transaction_api.get_varchar2_value

3723: ,p_name => 'P_PEA_ATTRIBUTE11'),
3724: hr_transaction_api.get_varchar2_value
3725: (p_transaction_step_id => p_transaction_step_id
3726: ,p_name => 'P_PEA_ATTRIBUTE12'),
3727: hr_transaction_api.get_varchar2_value
3728: (p_transaction_step_id => p_transaction_step_id
3729: ,p_name => 'P_PEA_ATTRIBUTE13'),
3730: hr_transaction_api.get_varchar2_value
3731: (p_transaction_step_id => p_transaction_step_id

Line 3730: hr_transaction_api.get_varchar2_value

3726: ,p_name => 'P_PEA_ATTRIBUTE12'),
3727: hr_transaction_api.get_varchar2_value
3728: (p_transaction_step_id => p_transaction_step_id
3729: ,p_name => 'P_PEA_ATTRIBUTE13'),
3730: hr_transaction_api.get_varchar2_value
3731: (p_transaction_step_id => p_transaction_step_id
3732: ,p_name => 'P_PEA_ATTRIBUTE14'),
3733: hr_transaction_api.get_varchar2_value
3734: (p_transaction_step_id => p_transaction_step_id

Line 3733: hr_transaction_api.get_varchar2_value

3729: ,p_name => 'P_PEA_ATTRIBUTE13'),
3730: hr_transaction_api.get_varchar2_value
3731: (p_transaction_step_id => p_transaction_step_id
3732: ,p_name => 'P_PEA_ATTRIBUTE14'),
3733: hr_transaction_api.get_varchar2_value
3734: (p_transaction_step_id => p_transaction_step_id
3735: ,p_name => 'P_PEA_ATTRIBUTE15'),
3736: hr_transaction_api.get_varchar2_value
3737: (p_transaction_step_id => p_transaction_step_id

Line 3736: hr_transaction_api.get_varchar2_value

3732: ,p_name => 'P_PEA_ATTRIBUTE14'),
3733: hr_transaction_api.get_varchar2_value
3734: (p_transaction_step_id => p_transaction_step_id
3735: ,p_name => 'P_PEA_ATTRIBUTE15'),
3736: hr_transaction_api.get_varchar2_value
3737: (p_transaction_step_id => p_transaction_step_id
3738: ,p_name => 'P_PEA_ATTRIBUTE16'),
3739: hr_transaction_api.get_varchar2_value
3740: (p_transaction_step_id => p_transaction_step_id

Line 3739: hr_transaction_api.get_varchar2_value

3735: ,p_name => 'P_PEA_ATTRIBUTE15'),
3736: hr_transaction_api.get_varchar2_value
3737: (p_transaction_step_id => p_transaction_step_id
3738: ,p_name => 'P_PEA_ATTRIBUTE16'),
3739: hr_transaction_api.get_varchar2_value
3740: (p_transaction_step_id => p_transaction_step_id
3741: ,p_name => 'P_PEA_ATTRIBUTE17'),
3742: hr_transaction_api.get_varchar2_value
3743: (p_transaction_step_id => p_transaction_step_id

Line 3742: hr_transaction_api.get_varchar2_value

3738: ,p_name => 'P_PEA_ATTRIBUTE16'),
3739: hr_transaction_api.get_varchar2_value
3740: (p_transaction_step_id => p_transaction_step_id
3741: ,p_name => 'P_PEA_ATTRIBUTE17'),
3742: hr_transaction_api.get_varchar2_value
3743: (p_transaction_step_id => p_transaction_step_id
3744: ,p_name => 'P_PEA_ATTRIBUTE18'),
3745: hr_transaction_api.get_varchar2_value
3746: (p_transaction_step_id => p_transaction_step_id

Line 3745: hr_transaction_api.get_varchar2_value

3741: ,p_name => 'P_PEA_ATTRIBUTE17'),
3742: hr_transaction_api.get_varchar2_value
3743: (p_transaction_step_id => p_transaction_step_id
3744: ,p_name => 'P_PEA_ATTRIBUTE18'),
3745: hr_transaction_api.get_varchar2_value
3746: (p_transaction_step_id => p_transaction_step_id
3747: ,p_name => 'P_PEA_ATTRIBUTE19'),
3748: hr_transaction_api.get_varchar2_value
3749: (p_transaction_step_id => p_transaction_step_id

Line 3748: hr_transaction_api.get_varchar2_value

3744: ,p_name => 'P_PEA_ATTRIBUTE18'),
3745: hr_transaction_api.get_varchar2_value
3746: (p_transaction_step_id => p_transaction_step_id
3747: ,p_name => 'P_PEA_ATTRIBUTE19'),
3748: hr_transaction_api.get_varchar2_value
3749: (p_transaction_step_id => p_transaction_step_id
3750: ,p_name => 'P_PEA_ATTRIBUTE20'),
3751: hr_transaction_api.get_varchar2_value
3752: (p_transaction_step_id => p_transaction_step_id

Line 3751: hr_transaction_api.get_varchar2_value

3747: ,p_name => 'P_PEA_ATTRIBUTE19'),
3748: hr_transaction_api.get_varchar2_value
3749: (p_transaction_step_id => p_transaction_step_id
3750: ,p_name => 'P_PEA_ATTRIBUTE20'),
3751: hr_transaction_api.get_varchar2_value
3752: (p_transaction_step_id => p_transaction_step_id
3753: ,p_name => 'P_PE_NAME'),
3754: to_number(hr_transaction_api.get_varchar2_value
3755: (p_transaction_step_id => p_transaction_step_id

Line 3754: to_number(hr_transaction_api.get_varchar2_value

3750: ,p_name => 'P_PEA_ATTRIBUTE20'),
3751: hr_transaction_api.get_varchar2_value
3752: (p_transaction_step_id => p_transaction_step_id
3753: ,p_name => 'P_PE_NAME'),
3754: to_number(hr_transaction_api.get_varchar2_value
3755: (p_transaction_step_id => p_transaction_step_id
3756: ,p_name => 'P_PARTY_ID'))
3757: );
3758: END LOOP;

Line 3767: to_number(hr_transaction_api.get_varchar2_value

3763: hr_utility.set_location('Entering For Loop:'||l_proc,20);
3764: FOR i IN 1..NVL(l_qua_count,0) LOOP
3765: p_qualifications.extend;
3766: p_qualifications(i) := SSHR_QUA_OBJ_TYP(
3767: to_number(hr_transaction_api.get_varchar2_value
3768: (p_transaction_step_id => p_transaction_step_id
3769: ,p_name => 'P_QUALIFICATION_ID')),
3770: hr_transaction_api.get_varchar2_value
3771: (p_transaction_step_id => p_transaction_step_id

Line 3770: hr_transaction_api.get_varchar2_value

3766: p_qualifications(i) := SSHR_QUA_OBJ_TYP(
3767: to_number(hr_transaction_api.get_varchar2_value
3768: (p_transaction_step_id => p_transaction_step_id
3769: ,p_name => 'P_QUALIFICATION_ID')),
3770: hr_transaction_api.get_varchar2_value
3771: (p_transaction_step_id => p_transaction_step_id
3772: ,p_name => 'P_DELETE_FLAG'),
3773: to_number(hr_transaction_api.get_varchar2_value
3774: (p_transaction_step_id => p_transaction_step_id

Line 3773: to_number(hr_transaction_api.get_varchar2_value

3769: ,p_name => 'P_QUALIFICATION_ID')),
3770: hr_transaction_api.get_varchar2_value
3771: (p_transaction_step_id => p_transaction_step_id
3772: ,p_name => 'P_DELETE_FLAG'),
3773: to_number(hr_transaction_api.get_varchar2_value
3774: (p_transaction_step_id => p_transaction_step_id
3775: ,p_name => 'P_BUSINESS_GROUP_ID')),
3776: to_number(hr_transaction_api.get_varchar2_value
3777: (p_transaction_step_id => p_transaction_step_id

Line 3776: to_number(hr_transaction_api.get_varchar2_value

3772: ,p_name => 'P_DELETE_FLAG'),
3773: to_number(hr_transaction_api.get_varchar2_value
3774: (p_transaction_step_id => p_transaction_step_id
3775: ,p_name => 'P_BUSINESS_GROUP_ID')),
3776: to_number(hr_transaction_api.get_varchar2_value
3777: (p_transaction_step_id => p_transaction_step_id
3778: ,p_name => 'P_PQ_OBJECT_VERSION_NUMBER')),
3779: to_number(hr_transaction_api.get_varchar2_value
3780: (p_transaction_step_id => p_transaction_step_id

Line 3779: to_number(hr_transaction_api.get_varchar2_value

3775: ,p_name => 'P_BUSINESS_GROUP_ID')),
3776: to_number(hr_transaction_api.get_varchar2_value
3777: (p_transaction_step_id => p_transaction_step_id
3778: ,p_name => 'P_PQ_OBJECT_VERSION_NUMBER')),
3779: to_number(hr_transaction_api.get_varchar2_value
3780: (p_transaction_step_id => p_transaction_step_id
3781: ,p_name => 'P_PQ_PERSON_ID')),
3782: hr_transaction_api.get_varchar2_value
3783: (p_transaction_step_id => p_transaction_step_id

Line 3782: hr_transaction_api.get_varchar2_value

3778: ,p_name => 'P_PQ_OBJECT_VERSION_NUMBER')),
3779: to_number(hr_transaction_api.get_varchar2_value
3780: (p_transaction_step_id => p_transaction_step_id
3781: ,p_name => 'P_PQ_PERSON_ID')),
3782: hr_transaction_api.get_varchar2_value
3783: (p_transaction_step_id => p_transaction_step_id
3784: ,p_name => 'P_PQ_TITLE'),
3785: hr_transaction_api.get_varchar2_value
3786: (p_transaction_step_id => p_transaction_step_id

Line 3785: hr_transaction_api.get_varchar2_value

3781: ,p_name => 'P_PQ_PERSON_ID')),
3782: hr_transaction_api.get_varchar2_value
3783: (p_transaction_step_id => p_transaction_step_id
3784: ,p_name => 'P_PQ_TITLE'),
3785: hr_transaction_api.get_varchar2_value
3786: (p_transaction_step_id => p_transaction_step_id
3787: ,p_name => 'P_PQ_GRADE_ATTAINED'),
3788: hr_transaction_api.get_varchar2_value
3789: (p_transaction_step_id => p_transaction_step_id

Line 3788: hr_transaction_api.get_varchar2_value

3784: ,p_name => 'P_PQ_TITLE'),
3785: hr_transaction_api.get_varchar2_value
3786: (p_transaction_step_id => p_transaction_step_id
3787: ,p_name => 'P_PQ_GRADE_ATTAINED'),
3788: hr_transaction_api.get_varchar2_value
3789: (p_transaction_step_id => p_transaction_step_id
3790: ,p_name => 'P_PQ_STATUS'),
3791: hr_transaction_api.get_date_value
3792: (p_transaction_step_id => p_transaction_step_id

Line 3791: hr_transaction_api.get_date_value

3787: ,p_name => 'P_PQ_GRADE_ATTAINED'),
3788: hr_transaction_api.get_varchar2_value
3789: (p_transaction_step_id => p_transaction_step_id
3790: ,p_name => 'P_PQ_STATUS'),
3791: hr_transaction_api.get_date_value
3792: (p_transaction_step_id => p_transaction_step_id
3793: ,p_name => 'P_PQ_AWARDED_DATE'),
3794: to_number(hr_transaction_api.get_varchar2_value
3795: (p_transaction_step_id => p_transaction_step_id

Line 3794: to_number(hr_transaction_api.get_varchar2_value

3790: ,p_name => 'P_PQ_STATUS'),
3791: hr_transaction_api.get_date_value
3792: (p_transaction_step_id => p_transaction_step_id
3793: ,p_name => 'P_PQ_AWARDED_DATE'),
3794: to_number(hr_transaction_api.get_varchar2_value
3795: (p_transaction_step_id => p_transaction_step_id
3796: ,p_name => 'P_PQ_FEE')),
3797: hr_transaction_api.get_varchar2_value
3798: (p_transaction_step_id => p_transaction_step_id

Line 3797: hr_transaction_api.get_varchar2_value

3793: ,p_name => 'P_PQ_AWARDED_DATE'),
3794: to_number(hr_transaction_api.get_varchar2_value
3795: (p_transaction_step_id => p_transaction_step_id
3796: ,p_name => 'P_PQ_FEE')),
3797: hr_transaction_api.get_varchar2_value
3798: (p_transaction_step_id => p_transaction_step_id
3799: ,p_name => 'P_PQ_FEE_CURRENCY'),
3800: to_number(hr_transaction_api.get_varchar2_value
3801: (p_transaction_step_id => p_transaction_step_id

Line 3800: to_number(hr_transaction_api.get_varchar2_value

3796: ,p_name => 'P_PQ_FEE')),
3797: hr_transaction_api.get_varchar2_value
3798: (p_transaction_step_id => p_transaction_step_id
3799: ,p_name => 'P_PQ_FEE_CURRENCY'),
3800: to_number(hr_transaction_api.get_varchar2_value
3801: (p_transaction_step_id => p_transaction_step_id
3802: ,p_name => 'P_PQ_COMPLETED_AMOUNT')),
3803: hr_transaction_api.get_varchar2_value
3804: (p_transaction_step_id => p_transaction_step_id

Line 3803: hr_transaction_api.get_varchar2_value

3799: ,p_name => 'P_PQ_FEE_CURRENCY'),
3800: to_number(hr_transaction_api.get_varchar2_value
3801: (p_transaction_step_id => p_transaction_step_id
3802: ,p_name => 'P_PQ_COMPLETED_AMOUNT')),
3803: hr_transaction_api.get_varchar2_value
3804: (p_transaction_step_id => p_transaction_step_id
3805: ,p_name => 'P_PQ_REIMBURSEMENT'),
3806: hr_transaction_api.get_varchar2_value
3807: (p_transaction_step_id => p_transaction_step_id

Line 3806: hr_transaction_api.get_varchar2_value

3802: ,p_name => 'P_PQ_COMPLETED_AMOUNT')),
3803: hr_transaction_api.get_varchar2_value
3804: (p_transaction_step_id => p_transaction_step_id
3805: ,p_name => 'P_PQ_REIMBURSEMENT'),
3806: hr_transaction_api.get_varchar2_value
3807: (p_transaction_step_id => p_transaction_step_id
3808: ,p_name => 'P_PQ_COMPLETED_UNITS'),
3809: to_number(hr_transaction_api.get_varchar2_value
3810: (p_transaction_step_id => p_transaction_step_id

Line 3809: to_number(hr_transaction_api.get_varchar2_value

3805: ,p_name => 'P_PQ_REIMBURSEMENT'),
3806: hr_transaction_api.get_varchar2_value
3807: (p_transaction_step_id => p_transaction_step_id
3808: ,p_name => 'P_PQ_COMPLETED_UNITS'),
3809: to_number(hr_transaction_api.get_varchar2_value
3810: (p_transaction_step_id => p_transaction_step_id
3811: ,p_name => 'P_PQ_TOTAL_AMOUNT')),
3812: hr_transaction_api.get_date_value
3813: (p_transaction_step_id => p_transaction_step_id

Line 3812: hr_transaction_api.get_date_value

3808: ,p_name => 'P_PQ_COMPLETED_UNITS'),
3809: to_number(hr_transaction_api.get_varchar2_value
3810: (p_transaction_step_id => p_transaction_step_id
3811: ,p_name => 'P_PQ_TOTAL_AMOUNT')),
3812: hr_transaction_api.get_date_value
3813: (p_transaction_step_id => p_transaction_step_id
3814: ,p_name => 'P_PQ_START_DATE'),
3815: hr_transaction_api.get_date_value
3816: (p_transaction_step_id => p_transaction_step_id

Line 3815: hr_transaction_api.get_date_value

3811: ,p_name => 'P_PQ_TOTAL_AMOUNT')),
3812: hr_transaction_api.get_date_value
3813: (p_transaction_step_id => p_transaction_step_id
3814: ,p_name => 'P_PQ_START_DATE'),
3815: hr_transaction_api.get_date_value
3816: (p_transaction_step_id => p_transaction_step_id
3817: ,p_name => 'P_PQ_END_DATE'),
3818: hr_transaction_api.get_varchar2_value
3819: (p_transaction_step_id => p_transaction_step_id

Line 3818: hr_transaction_api.get_varchar2_value

3814: ,p_name => 'P_PQ_START_DATE'),
3815: hr_transaction_api.get_date_value
3816: (p_transaction_step_id => p_transaction_step_id
3817: ,p_name => 'P_PQ_END_DATE'),
3818: hr_transaction_api.get_varchar2_value
3819: (p_transaction_step_id => p_transaction_step_id
3820: ,p_name => 'P_PQ_LICENSE_NUMBER'),
3821: hr_transaction_api.get_date_value
3822: (p_transaction_step_id => p_transaction_step_id

Line 3821: hr_transaction_api.get_date_value

3817: ,p_name => 'P_PQ_END_DATE'),
3818: hr_transaction_api.get_varchar2_value
3819: (p_transaction_step_id => p_transaction_step_id
3820: ,p_name => 'P_PQ_LICENSE_NUMBER'),
3821: hr_transaction_api.get_date_value
3822: (p_transaction_step_id => p_transaction_step_id
3823: ,p_name => 'P_PQ_EXPIRY_DATE'),
3824: hr_transaction_api.get_varchar2_value
3825: (p_transaction_step_id => p_transaction_step_id

Line 3824: hr_transaction_api.get_varchar2_value

3820: ,p_name => 'P_PQ_LICENSE_NUMBER'),
3821: hr_transaction_api.get_date_value
3822: (p_transaction_step_id => p_transaction_step_id
3823: ,p_name => 'P_PQ_EXPIRY_DATE'),
3824: hr_transaction_api.get_varchar2_value
3825: (p_transaction_step_id => p_transaction_step_id
3826: ,p_name => 'P_PQ_LICENSE_RESTRICTIONS'),
3827: null, --PROJECTED_COMPLETION_DATE
3828: hr_transaction_api.get_varchar2_value

Line 3828: hr_transaction_api.get_varchar2_value

3824: hr_transaction_api.get_varchar2_value
3825: (p_transaction_step_id => p_transaction_step_id
3826: ,p_name => 'P_PQ_LICENSE_RESTRICTIONS'),
3827: null, --PROJECTED_COMPLETION_DATE
3828: hr_transaction_api.get_varchar2_value
3829: (p_transaction_step_id => p_transaction_step_id
3830: ,p_name => 'P_PQ_AWARDING_BODY'),
3831: hr_transaction_api.get_varchar2_value
3832: (p_transaction_step_id => p_transaction_step_id

Line 3831: hr_transaction_api.get_varchar2_value

3827: null, --PROJECTED_COMPLETION_DATE
3828: hr_transaction_api.get_varchar2_value
3829: (p_transaction_step_id => p_transaction_step_id
3830: ,p_name => 'P_PQ_AWARDING_BODY'),
3831: hr_transaction_api.get_varchar2_value
3832: (p_transaction_step_id => p_transaction_step_id
3833: ,p_name => 'P_PQ_TUITION_METHOD'),
3834: hr_transaction_api.get_varchar2_value
3835: (p_transaction_step_id => p_transaction_step_id

Line 3834: hr_transaction_api.get_varchar2_value

3830: ,p_name => 'P_PQ_AWARDING_BODY'),
3831: hr_transaction_api.get_varchar2_value
3832: (p_transaction_step_id => p_transaction_step_id
3833: ,p_name => 'P_PQ_TUITION_METHOD'),
3834: hr_transaction_api.get_varchar2_value
3835: (p_transaction_step_id => p_transaction_step_id
3836: ,p_name => 'P_PQ_GROUP_RANKING'),
3837: hr_transaction_api.get_varchar2_value
3838: (p_transaction_step_id => p_transaction_step_id

Line 3837: hr_transaction_api.get_varchar2_value

3833: ,p_name => 'P_PQ_TUITION_METHOD'),
3834: hr_transaction_api.get_varchar2_value
3835: (p_transaction_step_id => p_transaction_step_id
3836: ,p_name => 'P_PQ_GROUP_RANKING'),
3837: hr_transaction_api.get_varchar2_value
3838: (p_transaction_step_id => p_transaction_step_id
3839: ,p_name => 'P_PQ_COMMENTS'),
3840: to_number(hr_transaction_api.get_varchar2_value
3841: (p_transaction_step_id => p_transaction_step_id

Line 3840: to_number(hr_transaction_api.get_varchar2_value

3836: ,p_name => 'P_PQ_GROUP_RANKING'),
3837: hr_transaction_api.get_varchar2_value
3838: (p_transaction_step_id => p_transaction_step_id
3839: ,p_name => 'P_PQ_COMMENTS'),
3840: to_number(hr_transaction_api.get_varchar2_value
3841: (p_transaction_step_id => p_transaction_step_id
3842: ,p_name => 'P_QUALIFICATION_TYPE_ID')),
3843: to_number(hr_transaction_api.get_varchar2_value
3844: (p_transaction_step_id => p_transaction_step_id

Line 3843: to_number(hr_transaction_api.get_varchar2_value

3839: ,p_name => 'P_PQ_COMMENTS'),
3840: to_number(hr_transaction_api.get_varchar2_value
3841: (p_transaction_step_id => p_transaction_step_id
3842: ,p_name => 'P_QUALIFICATION_TYPE_ID')),
3843: to_number(hr_transaction_api.get_varchar2_value
3844: (p_transaction_step_id => p_transaction_step_id
3845: ,p_name => 'P_ATTENDANCE_ID')),
3846: hr_transaction_api.get_varchar2_value
3847: (p_transaction_step_id => p_transaction_step_id

Line 3846: hr_transaction_api.get_varchar2_value

3842: ,p_name => 'P_QUALIFICATION_TYPE_ID')),
3843: to_number(hr_transaction_api.get_varchar2_value
3844: (p_transaction_step_id => p_transaction_step_id
3845: ,p_name => 'P_ATTENDANCE_ID')),
3846: hr_transaction_api.get_varchar2_value
3847: (p_transaction_step_id => p_transaction_step_id
3848: ,p_name => 'P_PQ_ATTRIBUTE_CATEGORY'),
3849: hr_transaction_api.get_varchar2_value
3850: (p_transaction_step_id => p_transaction_step_id

Line 3849: hr_transaction_api.get_varchar2_value

3845: ,p_name => 'P_ATTENDANCE_ID')),
3846: hr_transaction_api.get_varchar2_value
3847: (p_transaction_step_id => p_transaction_step_id
3848: ,p_name => 'P_PQ_ATTRIBUTE_CATEGORY'),
3849: hr_transaction_api.get_varchar2_value
3850: (p_transaction_step_id => p_transaction_step_id
3851: ,p_name => 'P_PQ_ATTRIBUTE1'),
3852: hr_transaction_api.get_varchar2_value
3853: (p_transaction_step_id => p_transaction_step_id

Line 3852: hr_transaction_api.get_varchar2_value

3848: ,p_name => 'P_PQ_ATTRIBUTE_CATEGORY'),
3849: hr_transaction_api.get_varchar2_value
3850: (p_transaction_step_id => p_transaction_step_id
3851: ,p_name => 'P_PQ_ATTRIBUTE1'),
3852: hr_transaction_api.get_varchar2_value
3853: (p_transaction_step_id => p_transaction_step_id
3854: ,p_name => 'P_PQ_ATTRIBUTE2'),
3855: hr_transaction_api.get_varchar2_value
3856: (p_transaction_step_id => p_transaction_step_id

Line 3855: hr_transaction_api.get_varchar2_value

3851: ,p_name => 'P_PQ_ATTRIBUTE1'),
3852: hr_transaction_api.get_varchar2_value
3853: (p_transaction_step_id => p_transaction_step_id
3854: ,p_name => 'P_PQ_ATTRIBUTE2'),
3855: hr_transaction_api.get_varchar2_value
3856: (p_transaction_step_id => p_transaction_step_id
3857: ,p_name => 'P_PQ_ATTRIBUTE3'),
3858: hr_transaction_api.get_varchar2_value
3859: (p_transaction_step_id => p_transaction_step_id

Line 3858: hr_transaction_api.get_varchar2_value

3854: ,p_name => 'P_PQ_ATTRIBUTE2'),
3855: hr_transaction_api.get_varchar2_value
3856: (p_transaction_step_id => p_transaction_step_id
3857: ,p_name => 'P_PQ_ATTRIBUTE3'),
3858: hr_transaction_api.get_varchar2_value
3859: (p_transaction_step_id => p_transaction_step_id
3860: ,p_name => 'P_PQ_ATTRIBUTE4'),
3861: hr_transaction_api.get_varchar2_value
3862: (p_transaction_step_id => p_transaction_step_id

Line 3861: hr_transaction_api.get_varchar2_value

3857: ,p_name => 'P_PQ_ATTRIBUTE3'),
3858: hr_transaction_api.get_varchar2_value
3859: (p_transaction_step_id => p_transaction_step_id
3860: ,p_name => 'P_PQ_ATTRIBUTE4'),
3861: hr_transaction_api.get_varchar2_value
3862: (p_transaction_step_id => p_transaction_step_id
3863: ,p_name => 'P_PQ_ATTRIBUTE5'),
3864: hr_transaction_api.get_varchar2_value
3865: (p_transaction_step_id => p_transaction_step_id

Line 3864: hr_transaction_api.get_varchar2_value

3860: ,p_name => 'P_PQ_ATTRIBUTE4'),
3861: hr_transaction_api.get_varchar2_value
3862: (p_transaction_step_id => p_transaction_step_id
3863: ,p_name => 'P_PQ_ATTRIBUTE5'),
3864: hr_transaction_api.get_varchar2_value
3865: (p_transaction_step_id => p_transaction_step_id
3866: ,p_name => 'P_PQ_ATTRIBUTE6'),
3867: hr_transaction_api.get_varchar2_value
3868: (p_transaction_step_id => p_transaction_step_id

Line 3867: hr_transaction_api.get_varchar2_value

3863: ,p_name => 'P_PQ_ATTRIBUTE5'),
3864: hr_transaction_api.get_varchar2_value
3865: (p_transaction_step_id => p_transaction_step_id
3866: ,p_name => 'P_PQ_ATTRIBUTE6'),
3867: hr_transaction_api.get_varchar2_value
3868: (p_transaction_step_id => p_transaction_step_id
3869: ,p_name => 'P_PQ_ATTRIBUTE7'),
3870: hr_transaction_api.get_varchar2_value
3871: (p_transaction_step_id => p_transaction_step_id

Line 3870: hr_transaction_api.get_varchar2_value

3866: ,p_name => 'P_PQ_ATTRIBUTE6'),
3867: hr_transaction_api.get_varchar2_value
3868: (p_transaction_step_id => p_transaction_step_id
3869: ,p_name => 'P_PQ_ATTRIBUTE7'),
3870: hr_transaction_api.get_varchar2_value
3871: (p_transaction_step_id => p_transaction_step_id
3872: ,p_name => 'P_PQ_ATTRIBUTE8'),
3873: hr_transaction_api.get_varchar2_value
3874: (p_transaction_step_id => p_transaction_step_id

Line 3873: hr_transaction_api.get_varchar2_value

3869: ,p_name => 'P_PQ_ATTRIBUTE7'),
3870: hr_transaction_api.get_varchar2_value
3871: (p_transaction_step_id => p_transaction_step_id
3872: ,p_name => 'P_PQ_ATTRIBUTE8'),
3873: hr_transaction_api.get_varchar2_value
3874: (p_transaction_step_id => p_transaction_step_id
3875: ,p_name => 'P_PQ_ATTRIBUTE9'),
3876: hr_transaction_api.get_varchar2_value
3877: (p_transaction_step_id => p_transaction_step_id

Line 3876: hr_transaction_api.get_varchar2_value

3872: ,p_name => 'P_PQ_ATTRIBUTE8'),
3873: hr_transaction_api.get_varchar2_value
3874: (p_transaction_step_id => p_transaction_step_id
3875: ,p_name => 'P_PQ_ATTRIBUTE9'),
3876: hr_transaction_api.get_varchar2_value
3877: (p_transaction_step_id => p_transaction_step_id
3878: ,p_name => 'P_PQ_ATTRIBUTE10'),
3879: hr_transaction_api.get_varchar2_value
3880: (p_transaction_step_id => p_transaction_step_id

Line 3879: hr_transaction_api.get_varchar2_value

3875: ,p_name => 'P_PQ_ATTRIBUTE9'),
3876: hr_transaction_api.get_varchar2_value
3877: (p_transaction_step_id => p_transaction_step_id
3878: ,p_name => 'P_PQ_ATTRIBUTE10'),
3879: hr_transaction_api.get_varchar2_value
3880: (p_transaction_step_id => p_transaction_step_id
3881: ,p_name => 'P_PQ_ATTRIBUTE11'),
3882: hr_transaction_api.get_varchar2_value
3883: (p_transaction_step_id => p_transaction_step_id

Line 3882: hr_transaction_api.get_varchar2_value

3878: ,p_name => 'P_PQ_ATTRIBUTE10'),
3879: hr_transaction_api.get_varchar2_value
3880: (p_transaction_step_id => p_transaction_step_id
3881: ,p_name => 'P_PQ_ATTRIBUTE11'),
3882: hr_transaction_api.get_varchar2_value
3883: (p_transaction_step_id => p_transaction_step_id
3884: ,p_name => 'P_PQ_ATTRIBUTE12'),
3885: hr_transaction_api.get_varchar2_value
3886: (p_transaction_step_id => p_transaction_step_id

Line 3885: hr_transaction_api.get_varchar2_value

3881: ,p_name => 'P_PQ_ATTRIBUTE11'),
3882: hr_transaction_api.get_varchar2_value
3883: (p_transaction_step_id => p_transaction_step_id
3884: ,p_name => 'P_PQ_ATTRIBUTE12'),
3885: hr_transaction_api.get_varchar2_value
3886: (p_transaction_step_id => p_transaction_step_id
3887: ,p_name => 'P_PQ_ATTRIBUTE13'),
3888: hr_transaction_api.get_varchar2_value
3889: (p_transaction_step_id => p_transaction_step_id

Line 3888: hr_transaction_api.get_varchar2_value

3884: ,p_name => 'P_PQ_ATTRIBUTE12'),
3885: hr_transaction_api.get_varchar2_value
3886: (p_transaction_step_id => p_transaction_step_id
3887: ,p_name => 'P_PQ_ATTRIBUTE13'),
3888: hr_transaction_api.get_varchar2_value
3889: (p_transaction_step_id => p_transaction_step_id
3890: ,p_name => 'P_PQ_ATTRIBUTE14'),
3891: hr_transaction_api.get_varchar2_value
3892: (p_transaction_step_id => p_transaction_step_id

Line 3891: hr_transaction_api.get_varchar2_value

3887: ,p_name => 'P_PQ_ATTRIBUTE13'),
3888: hr_transaction_api.get_varchar2_value
3889: (p_transaction_step_id => p_transaction_step_id
3890: ,p_name => 'P_PQ_ATTRIBUTE14'),
3891: hr_transaction_api.get_varchar2_value
3892: (p_transaction_step_id => p_transaction_step_id
3893: ,p_name => 'P_PQ_ATTRIBUTE15'),
3894: hr_transaction_api.get_varchar2_value
3895: (p_transaction_step_id => p_transaction_step_id

Line 3894: hr_transaction_api.get_varchar2_value

3890: ,p_name => 'P_PQ_ATTRIBUTE14'),
3891: hr_transaction_api.get_varchar2_value
3892: (p_transaction_step_id => p_transaction_step_id
3893: ,p_name => 'P_PQ_ATTRIBUTE15'),
3894: hr_transaction_api.get_varchar2_value
3895: (p_transaction_step_id => p_transaction_step_id
3896: ,p_name => 'P_PQ_ATTRIBUTE16'),
3897: hr_transaction_api.get_varchar2_value
3898: (p_transaction_step_id => p_transaction_step_id

Line 3897: hr_transaction_api.get_varchar2_value

3893: ,p_name => 'P_PQ_ATTRIBUTE15'),
3894: hr_transaction_api.get_varchar2_value
3895: (p_transaction_step_id => p_transaction_step_id
3896: ,p_name => 'P_PQ_ATTRIBUTE16'),
3897: hr_transaction_api.get_varchar2_value
3898: (p_transaction_step_id => p_transaction_step_id
3899: ,p_name => 'P_PQ_ATTRIBUTE17'),
3900: hr_transaction_api.get_varchar2_value
3901: (p_transaction_step_id => p_transaction_step_id

Line 3900: hr_transaction_api.get_varchar2_value

3896: ,p_name => 'P_PQ_ATTRIBUTE16'),
3897: hr_transaction_api.get_varchar2_value
3898: (p_transaction_step_id => p_transaction_step_id
3899: ,p_name => 'P_PQ_ATTRIBUTE17'),
3900: hr_transaction_api.get_varchar2_value
3901: (p_transaction_step_id => p_transaction_step_id
3902: ,p_name => 'P_PQ_ATTRIBUTE18'),
3903: hr_transaction_api.get_varchar2_value
3904: (p_transaction_step_id => p_transaction_step_id

Line 3903: hr_transaction_api.get_varchar2_value

3899: ,p_name => 'P_PQ_ATTRIBUTE17'),
3900: hr_transaction_api.get_varchar2_value
3901: (p_transaction_step_id => p_transaction_step_id
3902: ,p_name => 'P_PQ_ATTRIBUTE18'),
3903: hr_transaction_api.get_varchar2_value
3904: (p_transaction_step_id => p_transaction_step_id
3905: ,p_name => 'P_PQ_ATTRIBUTE19'),
3906: hr_transaction_api.get_varchar2_value
3907: (p_transaction_step_id => p_transaction_step_id

Line 3906: hr_transaction_api.get_varchar2_value

3902: ,p_name => 'P_PQ_ATTRIBUTE18'),
3903: hr_transaction_api.get_varchar2_value
3904: (p_transaction_step_id => p_transaction_step_id
3905: ,p_name => 'P_PQ_ATTRIBUTE19'),
3906: hr_transaction_api.get_varchar2_value
3907: (p_transaction_step_id => p_transaction_step_id
3908: ,p_name => 'P_PQ_ATTRIBUTE20'),
3909: hr_transaction_api.get_varchar2_value
3910: (p_transaction_step_id => p_transaction_step_id

Line 3909: hr_transaction_api.get_varchar2_value

3905: ,p_name => 'P_PQ_ATTRIBUTE19'),
3906: hr_transaction_api.get_varchar2_value
3907: (p_transaction_step_id => p_transaction_step_id
3908: ,p_name => 'P_PQ_ATTRIBUTE20'),
3909: hr_transaction_api.get_varchar2_value
3910: (p_transaction_step_id => p_transaction_step_id
3911: ,p_name => 'P_PQ_QUA_INFORMATION_CATEGORY'),
3912: hr_transaction_api.get_varchar2_value
3913: (p_transaction_step_id => p_transaction_step_id

Line 3912: hr_transaction_api.get_varchar2_value

3908: ,p_name => 'P_PQ_ATTRIBUTE20'),
3909: hr_transaction_api.get_varchar2_value
3910: (p_transaction_step_id => p_transaction_step_id
3911: ,p_name => 'P_PQ_QUA_INFORMATION_CATEGORY'),
3912: hr_transaction_api.get_varchar2_value
3913: (p_transaction_step_id => p_transaction_step_id
3914: ,p_name => 'P_PQ_QUA_INFORMATION1'),
3915: hr_transaction_api.get_varchar2_value
3916: (p_transaction_step_id => p_transaction_step_id

Line 3915: hr_transaction_api.get_varchar2_value

3911: ,p_name => 'P_PQ_QUA_INFORMATION_CATEGORY'),
3912: hr_transaction_api.get_varchar2_value
3913: (p_transaction_step_id => p_transaction_step_id
3914: ,p_name => 'P_PQ_QUA_INFORMATION1'),
3915: hr_transaction_api.get_varchar2_value
3916: (p_transaction_step_id => p_transaction_step_id
3917: ,p_name => 'P_PQ_QUA_INFORMATION2'),
3918: hr_transaction_api.get_varchar2_value
3919: (p_transaction_step_id => p_transaction_step_id

Line 3918: hr_transaction_api.get_varchar2_value

3914: ,p_name => 'P_PQ_QUA_INFORMATION1'),
3915: hr_transaction_api.get_varchar2_value
3916: (p_transaction_step_id => p_transaction_step_id
3917: ,p_name => 'P_PQ_QUA_INFORMATION2'),
3918: hr_transaction_api.get_varchar2_value
3919: (p_transaction_step_id => p_transaction_step_id
3920: ,p_name => 'P_PQ_QUA_INFORMATION3'),
3921: hr_transaction_api.get_varchar2_value
3922: (p_transaction_step_id => p_transaction_step_id

Line 3921: hr_transaction_api.get_varchar2_value

3917: ,p_name => 'P_PQ_QUA_INFORMATION2'),
3918: hr_transaction_api.get_varchar2_value
3919: (p_transaction_step_id => p_transaction_step_id
3920: ,p_name => 'P_PQ_QUA_INFORMATION3'),
3921: hr_transaction_api.get_varchar2_value
3922: (p_transaction_step_id => p_transaction_step_id
3923: ,p_name => 'P_PQ_QUA_INFORMATION4'),
3924: hr_transaction_api.get_varchar2_value
3925: (p_transaction_step_id => p_transaction_step_id

Line 3924: hr_transaction_api.get_varchar2_value

3920: ,p_name => 'P_PQ_QUA_INFORMATION3'),
3921: hr_transaction_api.get_varchar2_value
3922: (p_transaction_step_id => p_transaction_step_id
3923: ,p_name => 'P_PQ_QUA_INFORMATION4'),
3924: hr_transaction_api.get_varchar2_value
3925: (p_transaction_step_id => p_transaction_step_id
3926: ,p_name => 'P_PQ_QUA_INFORMATION5'),
3927: hr_transaction_api.get_varchar2_value
3928: (p_transaction_step_id => p_transaction_step_id

Line 3927: hr_transaction_api.get_varchar2_value

3923: ,p_name => 'P_PQ_QUA_INFORMATION4'),
3924: hr_transaction_api.get_varchar2_value
3925: (p_transaction_step_id => p_transaction_step_id
3926: ,p_name => 'P_PQ_QUA_INFORMATION5'),
3927: hr_transaction_api.get_varchar2_value
3928: (p_transaction_step_id => p_transaction_step_id
3929: ,p_name => 'P_PQ_QUA_INFORMATION6'),
3930: hr_transaction_api.get_varchar2_value
3931: (p_transaction_step_id => p_transaction_step_id

Line 3930: hr_transaction_api.get_varchar2_value

3926: ,p_name => 'P_PQ_QUA_INFORMATION5'),
3927: hr_transaction_api.get_varchar2_value
3928: (p_transaction_step_id => p_transaction_step_id
3929: ,p_name => 'P_PQ_QUA_INFORMATION6'),
3930: hr_transaction_api.get_varchar2_value
3931: (p_transaction_step_id => p_transaction_step_id
3932: ,p_name => 'P_PQ_QUA_INFORMATION7'),
3933: hr_transaction_api.get_varchar2_value
3934: (p_transaction_step_id => p_transaction_step_id

Line 3933: hr_transaction_api.get_varchar2_value

3929: ,p_name => 'P_PQ_QUA_INFORMATION6'),
3930: hr_transaction_api.get_varchar2_value
3931: (p_transaction_step_id => p_transaction_step_id
3932: ,p_name => 'P_PQ_QUA_INFORMATION7'),
3933: hr_transaction_api.get_varchar2_value
3934: (p_transaction_step_id => p_transaction_step_id
3935: ,p_name => 'P_PQ_QUA_INFORMATION8'),
3936: hr_transaction_api.get_varchar2_value
3937: (p_transaction_step_id => p_transaction_step_id

Line 3936: hr_transaction_api.get_varchar2_value

3932: ,p_name => 'P_PQ_QUA_INFORMATION7'),
3933: hr_transaction_api.get_varchar2_value
3934: (p_transaction_step_id => p_transaction_step_id
3935: ,p_name => 'P_PQ_QUA_INFORMATION8'),
3936: hr_transaction_api.get_varchar2_value
3937: (p_transaction_step_id => p_transaction_step_id
3938: ,p_name => 'P_PQ_QUA_INFORMATION9'),
3939: hr_transaction_api.get_varchar2_value
3940: (p_transaction_step_id => p_transaction_step_id

Line 3939: hr_transaction_api.get_varchar2_value

3935: ,p_name => 'P_PQ_QUA_INFORMATION8'),
3936: hr_transaction_api.get_varchar2_value
3937: (p_transaction_step_id => p_transaction_step_id
3938: ,p_name => 'P_PQ_QUA_INFORMATION9'),
3939: hr_transaction_api.get_varchar2_value
3940: (p_transaction_step_id => p_transaction_step_id
3941: ,p_name => 'P_PQ_QUA_INFORMATION10'),
3942: hr_transaction_api.get_varchar2_value
3943: (p_transaction_step_id => p_transaction_step_id

Line 3942: hr_transaction_api.get_varchar2_value

3938: ,p_name => 'P_PQ_QUA_INFORMATION9'),
3939: hr_transaction_api.get_varchar2_value
3940: (p_transaction_step_id => p_transaction_step_id
3941: ,p_name => 'P_PQ_QUA_INFORMATION10'),
3942: hr_transaction_api.get_varchar2_value
3943: (p_transaction_step_id => p_transaction_step_id
3944: ,p_name => 'P_PQ_QUA_INFORMATION11'),
3945: hr_transaction_api.get_varchar2_value
3946: (p_transaction_step_id => p_transaction_step_id

Line 3945: hr_transaction_api.get_varchar2_value

3941: ,p_name => 'P_PQ_QUA_INFORMATION10'),
3942: hr_transaction_api.get_varchar2_value
3943: (p_transaction_step_id => p_transaction_step_id
3944: ,p_name => 'P_PQ_QUA_INFORMATION11'),
3945: hr_transaction_api.get_varchar2_value
3946: (p_transaction_step_id => p_transaction_step_id
3947: ,p_name => 'P_PQ_QUA_INFORMATION12'),
3948: hr_transaction_api.get_varchar2_value
3949: (p_transaction_step_id => p_transaction_step_id

Line 3948: hr_transaction_api.get_varchar2_value

3944: ,p_name => 'P_PQ_QUA_INFORMATION11'),
3945: hr_transaction_api.get_varchar2_value
3946: (p_transaction_step_id => p_transaction_step_id
3947: ,p_name => 'P_PQ_QUA_INFORMATION12'),
3948: hr_transaction_api.get_varchar2_value
3949: (p_transaction_step_id => p_transaction_step_id
3950: ,p_name => 'P_PQ_QUA_INFORMATION13'),
3951: hr_transaction_api.get_varchar2_value
3952: (p_transaction_step_id => p_transaction_step_id

Line 3951: hr_transaction_api.get_varchar2_value

3947: ,p_name => 'P_PQ_QUA_INFORMATION12'),
3948: hr_transaction_api.get_varchar2_value
3949: (p_transaction_step_id => p_transaction_step_id
3950: ,p_name => 'P_PQ_QUA_INFORMATION13'),
3951: hr_transaction_api.get_varchar2_value
3952: (p_transaction_step_id => p_transaction_step_id
3953: ,p_name => 'P_PQ_QUA_INFORMATION14'),
3954: hr_transaction_api.get_varchar2_value
3955: (p_transaction_step_id => p_transaction_step_id

Line 3954: hr_transaction_api.get_varchar2_value

3950: ,p_name => 'P_PQ_QUA_INFORMATION13'),
3951: hr_transaction_api.get_varchar2_value
3952: (p_transaction_step_id => p_transaction_step_id
3953: ,p_name => 'P_PQ_QUA_INFORMATION14'),
3954: hr_transaction_api.get_varchar2_value
3955: (p_transaction_step_id => p_transaction_step_id
3956: ,p_name => 'P_PQ_QUA_INFORMATION15'),
3957: hr_transaction_api.get_varchar2_value
3958: (p_transaction_step_id => p_transaction_step_id

Line 3957: hr_transaction_api.get_varchar2_value

3953: ,p_name => 'P_PQ_QUA_INFORMATION14'),
3954: hr_transaction_api.get_varchar2_value
3955: (p_transaction_step_id => p_transaction_step_id
3956: ,p_name => 'P_PQ_QUA_INFORMATION15'),
3957: hr_transaction_api.get_varchar2_value
3958: (p_transaction_step_id => p_transaction_step_id
3959: ,p_name => 'P_PQ_QUA_INFORMATION16'),
3960: hr_transaction_api.get_varchar2_value
3961: (p_transaction_step_id => p_transaction_step_id

Line 3960: hr_transaction_api.get_varchar2_value

3956: ,p_name => 'P_PQ_QUA_INFORMATION15'),
3957: hr_transaction_api.get_varchar2_value
3958: (p_transaction_step_id => p_transaction_step_id
3959: ,p_name => 'P_PQ_QUA_INFORMATION16'),
3960: hr_transaction_api.get_varchar2_value
3961: (p_transaction_step_id => p_transaction_step_id
3962: ,p_name => 'P_PQ_QUA_INFORMATION17'),
3963: hr_transaction_api.get_varchar2_value
3964: (p_transaction_step_id => p_transaction_step_id

Line 3963: hr_transaction_api.get_varchar2_value

3959: ,p_name => 'P_PQ_QUA_INFORMATION16'),
3960: hr_transaction_api.get_varchar2_value
3961: (p_transaction_step_id => p_transaction_step_id
3962: ,p_name => 'P_PQ_QUA_INFORMATION17'),
3963: hr_transaction_api.get_varchar2_value
3964: (p_transaction_step_id => p_transaction_step_id
3965: ,p_name => 'P_PQ_QUA_INFORMATION18'),
3966: hr_transaction_api.get_varchar2_value
3967: (p_transaction_step_id => p_transaction_step_id

Line 3966: hr_transaction_api.get_varchar2_value

3962: ,p_name => 'P_PQ_QUA_INFORMATION17'),
3963: hr_transaction_api.get_varchar2_value
3964: (p_transaction_step_id => p_transaction_step_id
3965: ,p_name => 'P_PQ_QUA_INFORMATION18'),
3966: hr_transaction_api.get_varchar2_value
3967: (p_transaction_step_id => p_transaction_step_id
3968: ,p_name => 'P_PQ_QUA_INFORMATION19'),
3969: hr_transaction_api.get_varchar2_value
3970: (p_transaction_step_id => p_transaction_step_id

Line 3969: hr_transaction_api.get_varchar2_value

3965: ,p_name => 'P_PQ_QUA_INFORMATION18'),
3966: hr_transaction_api.get_varchar2_value
3967: (p_transaction_step_id => p_transaction_step_id
3968: ,p_name => 'P_PQ_QUA_INFORMATION19'),
3969: hr_transaction_api.get_varchar2_value
3970: (p_transaction_step_id => p_transaction_step_id
3971: ,p_name => 'P_PQ_QUA_INFORMATION20'),
3972: null,null,null,null,
3973: /*hr_transaction_api.get_varchar2_value

Line 3973: /*hr_transaction_api.get_varchar2_value

3969: hr_transaction_api.get_varchar2_value
3970: (p_transaction_step_id => p_transaction_step_id
3971: ,p_name => 'P_PQ_QUA_INFORMATION20'),
3972: null,null,null,null,
3973: /*hr_transaction_api.get_varchar2_value
3974: (p_transaction_step_id => p_transaction_step_id
3975: ,p_name => 'P_PQ_PROFESSIONAL_BODY_NAME'),
3976: hr_transaction_api.get_varchar2_value
3977: (p_transaction_step_id => p_transaction_step_id

Line 3976: hr_transaction_api.get_varchar2_value

3972: null,null,null,null,
3973: /*hr_transaction_api.get_varchar2_value
3974: (p_transaction_step_id => p_transaction_step_id
3975: ,p_name => 'P_PQ_PROFESSIONAL_BODY_NAME'),
3976: hr_transaction_api.get_varchar2_value
3977: (p_transaction_step_id => p_transaction_step_id
3978: ,p_name => 'P_PQ_MEMBERSHIP_NUMBER'),
3979: hr_transaction_api.get_varchar2_value
3980: (p_transaction_step_id => p_transaction_step_id

Line 3979: hr_transaction_api.get_varchar2_value

3975: ,p_name => 'P_PQ_PROFESSIONAL_BODY_NAME'),
3976: hr_transaction_api.get_varchar2_value
3977: (p_transaction_step_id => p_transaction_step_id
3978: ,p_name => 'P_PQ_MEMBERSHIP_NUMBER'),
3979: hr_transaction_api.get_varchar2_value
3980: (p_transaction_step_id => p_transaction_step_id
3981: ,p_name => 'P_PQ_MEMBERSHIP_CATEGORY'),
3982: hr_transaction_api.get_varchar2_value
3983: (p_transaction_step_id => p_transaction_step_id

Line 3982: hr_transaction_api.get_varchar2_value

3978: ,p_name => 'P_PQ_MEMBERSHIP_NUMBER'),
3979: hr_transaction_api.get_varchar2_value
3980: (p_transaction_step_id => p_transaction_step_id
3981: ,p_name => 'P_PQ_MEMBERSHIP_CATEGORY'),
3982: hr_transaction_api.get_varchar2_value
3983: (p_transaction_step_id => p_transaction_step_id
3984: ,p_name => 'P_PQ_SUBS_PAYMENT_METHOD'),*/
3985: hr_transaction_api.get_number_value
3986: (p_transaction_step_id => p_transaction_step_id

Line 3985: hr_transaction_api.get_number_value

3981: ,p_name => 'P_PQ_MEMBERSHIP_CATEGORY'),
3982: hr_transaction_api.get_varchar2_value
3983: (p_transaction_step_id => p_transaction_step_id
3984: ,p_name => 'P_PQ_SUBS_PAYMENT_METHOD'),*/
3985: hr_transaction_api.get_number_value
3986: (p_transaction_step_id => p_transaction_step_id
3987: ,p_name => 'P_PARTY_ID')
3988: );
3989: END LOOP;

Line 4001: to_number(hr_transaction_api.get_varchar2_value

3997: FOR i IN 1..NVL(l_subject_count,0) LOOP
3998: p_qua_subjects.extend;
3999: p_qua_subjects(i) := SSHR_QUA_SUBJECT_OBJ_TYP(
4000:
4001: to_number(hr_transaction_api.get_varchar2_value
4002: (p_transaction_step_id => p_transaction_step_id
4003: ,p_name => 'P_SUBJECTS_TAKEN_ID'||i)),
4004:
4005: hr_transaction_api.get_varchar2_value

Line 4005: hr_transaction_api.get_varchar2_value

4001: to_number(hr_transaction_api.get_varchar2_value
4002: (p_transaction_step_id => p_transaction_step_id
4003: ,p_name => 'P_SUBJECTS_TAKEN_ID'||i)),
4004:
4005: hr_transaction_api.get_varchar2_value
4006: (p_transaction_step_id => p_transaction_step_id
4007: ,p_name => 'P_PST_DELETE_FLAG'||i),
4008:
4009: hr_transaction_api.get_date_value

Line 4009: hr_transaction_api.get_date_value

4005: hr_transaction_api.get_varchar2_value
4006: (p_transaction_step_id => p_transaction_step_id
4007: ,p_name => 'P_PST_DELETE_FLAG'||i),
4008:
4009: hr_transaction_api.get_date_value
4010: (p_transaction_step_id => p_transaction_step_id
4011: ,p_name => 'P_PST_START_DATE'||i),
4012:
4013: hr_transaction_api.get_varchar2_value

Line 4013: hr_transaction_api.get_varchar2_value

4009: hr_transaction_api.get_date_value
4010: (p_transaction_step_id => p_transaction_step_id
4011: ,p_name => 'P_PST_START_DATE'||i),
4012:
4013: hr_transaction_api.get_varchar2_value
4014: (p_transaction_step_id => p_transaction_step_id
4015: ,p_name => 'P_PST_MAJOR'||i),
4016: hr_transaction_api.get_varchar2_value
4017: (p_transaction_step_id => p_transaction_step_id

Line 4016: hr_transaction_api.get_varchar2_value

4012:
4013: hr_transaction_api.get_varchar2_value
4014: (p_transaction_step_id => p_transaction_step_id
4015: ,p_name => 'P_PST_MAJOR'||i),
4016: hr_transaction_api.get_varchar2_value
4017: (p_transaction_step_id => p_transaction_step_id
4018: ,p_name => 'P_PST_SUBJECT_STATUS'||i),
4019:
4020: hr_transaction_api.get_varchar2_value

Line 4020: hr_transaction_api.get_varchar2_value

4016: hr_transaction_api.get_varchar2_value
4017: (p_transaction_step_id => p_transaction_step_id
4018: ,p_name => 'P_PST_SUBJECT_STATUS'||i),
4019:
4020: hr_transaction_api.get_varchar2_value
4021: (p_transaction_step_id => p_transaction_step_id
4022: ,p_name => 'P_PST_SUBJECT'||i),
4023:
4024: hr_transaction_api.get_varchar2_value

Line 4024: hr_transaction_api.get_varchar2_value

4020: hr_transaction_api.get_varchar2_value
4021: (p_transaction_step_id => p_transaction_step_id
4022: ,p_name => 'P_PST_SUBJECT'||i),
4023:
4024: hr_transaction_api.get_varchar2_value
4025: (p_transaction_step_id => p_transaction_step_id
4026: ,p_name => 'P_PST_GRADE_ATTAINED'||i),
4027:
4028: hr_transaction_api.get_date_value

Line 4028: hr_transaction_api.get_date_value

4024: hr_transaction_api.get_varchar2_value
4025: (p_transaction_step_id => p_transaction_step_id
4026: ,p_name => 'P_PST_GRADE_ATTAINED'||i),
4027:
4028: hr_transaction_api.get_date_value
4029: (p_transaction_step_id => p_transaction_step_id
4030: ,p_name => 'P_PST_END_DATE'||i),
4031:
4032: hr_transaction_api.get_number_value

Line 4032: hr_transaction_api.get_number_value

4028: hr_transaction_api.get_date_value
4029: (p_transaction_step_id => p_transaction_step_id
4030: ,p_name => 'P_PST_END_DATE'||i),
4031:
4032: hr_transaction_api.get_number_value
4033: (p_transaction_step_id => p_transaction_step_id
4034: ,p_name => 'P_QUALIFICATION_ID'),
4035:
4036: to_number(hr_transaction_api.get_varchar2_value

Line 4036: to_number(hr_transaction_api.get_varchar2_value

4032: hr_transaction_api.get_number_value
4033: (p_transaction_step_id => p_transaction_step_id
4034: ,p_name => 'P_QUALIFICATION_ID'),
4035:
4036: to_number(hr_transaction_api.get_varchar2_value
4037: (p_transaction_step_id => p_transaction_step_id
4038: ,p_name => 'P_PST_OBJECT_VERSION_NUMBER'||i)),
4039:
4040: hr_transaction_api.get_varchar2_value

Line 4040: hr_transaction_api.get_varchar2_value

4036: to_number(hr_transaction_api.get_varchar2_value
4037: (p_transaction_step_id => p_transaction_step_id
4038: ,p_name => 'P_PST_OBJECT_VERSION_NUMBER'||i)),
4039:
4040: hr_transaction_api.get_varchar2_value
4041: (p_transaction_step_id => p_transaction_step_id
4042: ,p_name => 'P_PST_ATTRIBUTE_CATEGORY'||i),
4043:
4044: hr_transaction_api.get_varchar2_value

Line 4044: hr_transaction_api.get_varchar2_value

4040: hr_transaction_api.get_varchar2_value
4041: (p_transaction_step_id => p_transaction_step_id
4042: ,p_name => 'P_PST_ATTRIBUTE_CATEGORY'||i),
4043:
4044: hr_transaction_api.get_varchar2_value
4045: (p_transaction_step_id => p_transaction_step_id
4046: ,p_name => 'P_ATTRIBUTE1_PST'||i),
4047:
4048: hr_transaction_api.get_varchar2_value

Line 4048: hr_transaction_api.get_varchar2_value

4044: hr_transaction_api.get_varchar2_value
4045: (p_transaction_step_id => p_transaction_step_id
4046: ,p_name => 'P_ATTRIBUTE1_PST'||i),
4047:
4048: hr_transaction_api.get_varchar2_value
4049: (p_transaction_step_id => p_transaction_step_id
4050: ,p_name => 'P_ATTRIBUTE2_PST'||i),
4051:
4052: hr_transaction_api.get_varchar2_value

Line 4052: hr_transaction_api.get_varchar2_value

4048: hr_transaction_api.get_varchar2_value
4049: (p_transaction_step_id => p_transaction_step_id
4050: ,p_name => 'P_ATTRIBUTE2_PST'||i),
4051:
4052: hr_transaction_api.get_varchar2_value
4053: (p_transaction_step_id => p_transaction_step_id
4054: ,p_name => 'P_ATTRIBUTE3_PST'||i),
4055:
4056: hr_transaction_api.get_varchar2_value

Line 4056: hr_transaction_api.get_varchar2_value

4052: hr_transaction_api.get_varchar2_value
4053: (p_transaction_step_id => p_transaction_step_id
4054: ,p_name => 'P_ATTRIBUTE3_PST'||i),
4055:
4056: hr_transaction_api.get_varchar2_value
4057: (p_transaction_step_id => p_transaction_step_id
4058: ,p_name => 'P_ATTRIBUTE4_PST'||i),
4059:
4060: hr_transaction_api.get_varchar2_value

Line 4060: hr_transaction_api.get_varchar2_value

4056: hr_transaction_api.get_varchar2_value
4057: (p_transaction_step_id => p_transaction_step_id
4058: ,p_name => 'P_ATTRIBUTE4_PST'||i),
4059:
4060: hr_transaction_api.get_varchar2_value
4061: (p_transaction_step_id => p_transaction_step_id
4062: ,p_name => 'P_ATTRIBUTE5_PST'||i),
4063:
4064: hr_transaction_api.get_varchar2_value

Line 4064: hr_transaction_api.get_varchar2_value

4060: hr_transaction_api.get_varchar2_value
4061: (p_transaction_step_id => p_transaction_step_id
4062: ,p_name => 'P_ATTRIBUTE5_PST'||i),
4063:
4064: hr_transaction_api.get_varchar2_value
4065: (p_transaction_step_id => p_transaction_step_id
4066: ,p_name => 'P_ATTRIBUTE6_PST'||i),
4067:
4068: hr_transaction_api.get_varchar2_value

Line 4068: hr_transaction_api.get_varchar2_value

4064: hr_transaction_api.get_varchar2_value
4065: (p_transaction_step_id => p_transaction_step_id
4066: ,p_name => 'P_ATTRIBUTE6_PST'||i),
4067:
4068: hr_transaction_api.get_varchar2_value
4069: (p_transaction_step_id => p_transaction_step_id
4070: ,p_name => 'P_ATTRIBUTE7_PST'||i),
4071:
4072: hr_transaction_api.get_varchar2_value

Line 4072: hr_transaction_api.get_varchar2_value

4068: hr_transaction_api.get_varchar2_value
4069: (p_transaction_step_id => p_transaction_step_id
4070: ,p_name => 'P_ATTRIBUTE7_PST'||i),
4071:
4072: hr_transaction_api.get_varchar2_value
4073: (p_transaction_step_id => p_transaction_step_id
4074: ,p_name => 'P_ATTRIBUTE8_PST'||i),
4075:
4076: hr_transaction_api.get_varchar2_value

Line 4076: hr_transaction_api.get_varchar2_value

4072: hr_transaction_api.get_varchar2_value
4073: (p_transaction_step_id => p_transaction_step_id
4074: ,p_name => 'P_ATTRIBUTE8_PST'||i),
4075:
4076: hr_transaction_api.get_varchar2_value
4077: (p_transaction_step_id => p_transaction_step_id
4078: ,p_name => 'P_ATTRIBUTE9_PST'||i),
4079:
4080: hr_transaction_api.get_varchar2_value

Line 4080: hr_transaction_api.get_varchar2_value

4076: hr_transaction_api.get_varchar2_value
4077: (p_transaction_step_id => p_transaction_step_id
4078: ,p_name => 'P_ATTRIBUTE9_PST'||i),
4079:
4080: hr_transaction_api.get_varchar2_value
4081: (p_transaction_step_id => p_transaction_step_id
4082: ,p_name => 'P_ATTRIBUTE10_PST'||i),
4083:
4084: hr_transaction_api.get_varchar2_value

Line 4084: hr_transaction_api.get_varchar2_value

4080: hr_transaction_api.get_varchar2_value
4081: (p_transaction_step_id => p_transaction_step_id
4082: ,p_name => 'P_ATTRIBUTE10_PST'||i),
4083:
4084: hr_transaction_api.get_varchar2_value
4085: (p_transaction_step_id => p_transaction_step_id
4086: ,p_name => 'P_ATTRIBUTE11_PST'||i),
4087:
4088: hr_transaction_api.get_varchar2_value

Line 4088: hr_transaction_api.get_varchar2_value

4084: hr_transaction_api.get_varchar2_value
4085: (p_transaction_step_id => p_transaction_step_id
4086: ,p_name => 'P_ATTRIBUTE11_PST'||i),
4087:
4088: hr_transaction_api.get_varchar2_value
4089: (p_transaction_step_id => p_transaction_step_id
4090: ,p_name => 'P_ATTRIBUTE12_PST'||i),
4091:
4092: hr_transaction_api.get_varchar2_value

Line 4092: hr_transaction_api.get_varchar2_value

4088: hr_transaction_api.get_varchar2_value
4089: (p_transaction_step_id => p_transaction_step_id
4090: ,p_name => 'P_ATTRIBUTE12_PST'||i),
4091:
4092: hr_transaction_api.get_varchar2_value
4093: (p_transaction_step_id => p_transaction_step_id
4094: ,p_name => 'P_ATTRIBUTE13_PST'||i),
4095:
4096: hr_transaction_api.get_varchar2_value

Line 4096: hr_transaction_api.get_varchar2_value

4092: hr_transaction_api.get_varchar2_value
4093: (p_transaction_step_id => p_transaction_step_id
4094: ,p_name => 'P_ATTRIBUTE13_PST'||i),
4095:
4096: hr_transaction_api.get_varchar2_value
4097: (p_transaction_step_id => p_transaction_step_id
4098: ,p_name => 'P_ATTRIBUTE14_PST'||i),
4099:
4100: hr_transaction_api.get_varchar2_value

Line 4100: hr_transaction_api.get_varchar2_value

4096: hr_transaction_api.get_varchar2_value
4097: (p_transaction_step_id => p_transaction_step_id
4098: ,p_name => 'P_ATTRIBUTE14_PST'||i),
4099:
4100: hr_transaction_api.get_varchar2_value
4101: (p_transaction_step_id => p_transaction_step_id
4102: ,p_name => 'P_ATTRIBUTE15_PST'||i),
4103:
4104: hr_transaction_api.get_varchar2_value

Line 4104: hr_transaction_api.get_varchar2_value

4100: hr_transaction_api.get_varchar2_value
4101: (p_transaction_step_id => p_transaction_step_id
4102: ,p_name => 'P_ATTRIBUTE15_PST'||i),
4103:
4104: hr_transaction_api.get_varchar2_value
4105: (p_transaction_step_id => p_transaction_step_id
4106: ,p_name => 'P_ATTRIBUTE16_PST'||i),
4107:
4108: hr_transaction_api.get_varchar2_value

Line 4108: hr_transaction_api.get_varchar2_value

4104: hr_transaction_api.get_varchar2_value
4105: (p_transaction_step_id => p_transaction_step_id
4106: ,p_name => 'P_ATTRIBUTE16_PST'||i),
4107:
4108: hr_transaction_api.get_varchar2_value
4109: (p_transaction_step_id => p_transaction_step_id
4110: ,p_name => 'P_ATTRIBUTE17_PST'||i),
4111:
4112: hr_transaction_api.get_varchar2_value

Line 4112: hr_transaction_api.get_varchar2_value

4108: hr_transaction_api.get_varchar2_value
4109: (p_transaction_step_id => p_transaction_step_id
4110: ,p_name => 'P_ATTRIBUTE17_PST'||i),
4111:
4112: hr_transaction_api.get_varchar2_value
4113: (p_transaction_step_id => p_transaction_step_id
4114: ,p_name => 'P_ATTRIBUTE18_PST'||i),
4115:
4116: hr_transaction_api.get_varchar2_value

Line 4116: hr_transaction_api.get_varchar2_value

4112: hr_transaction_api.get_varchar2_value
4113: (p_transaction_step_id => p_transaction_step_id
4114: ,p_name => 'P_ATTRIBUTE18_PST'||i),
4115:
4116: hr_transaction_api.get_varchar2_value
4117: (p_transaction_step_id => p_transaction_step_id
4118: ,p_name => 'P_ATTRIBUTE19_PST'||i),
4119:
4120: hr_transaction_api.get_varchar2_value

Line 4120: hr_transaction_api.get_varchar2_value

4116: hr_transaction_api.get_varchar2_value
4117: (p_transaction_step_id => p_transaction_step_id
4118: ,p_name => 'P_ATTRIBUTE19_PST'||i),
4119:
4120: hr_transaction_api.get_varchar2_value
4121: (p_transaction_step_id => p_transaction_step_id
4122: ,p_name => 'P_ATTRIBUTE20_PST'||i),
4123:
4124: hr_transaction_api.get_varchar2_value

Line 4124: hr_transaction_api.get_varchar2_value

4120: hr_transaction_api.get_varchar2_value
4121: (p_transaction_step_id => p_transaction_step_id
4122: ,p_name => 'P_ATTRIBUTE20_PST'||i),
4123:
4124: hr_transaction_api.get_varchar2_value
4125: (p_transaction_step_id => p_transaction_step_id
4126: ,p_name => 'P_SUB_INFORMATION_CATEGORY'||i),
4127:
4128: hr_transaction_api.get_varchar2_value

Line 4128: hr_transaction_api.get_varchar2_value

4124: hr_transaction_api.get_varchar2_value
4125: (p_transaction_step_id => p_transaction_step_id
4126: ,p_name => 'P_SUB_INFORMATION_CATEGORY'||i),
4127:
4128: hr_transaction_api.get_varchar2_value
4129: (p_transaction_step_id => p_transaction_step_id
4130: ,p_name => 'P_SUB_INFORMATION1_PST'||i),
4131:
4132: hr_transaction_api.get_varchar2_value

Line 4132: hr_transaction_api.get_varchar2_value

4128: hr_transaction_api.get_varchar2_value
4129: (p_transaction_step_id => p_transaction_step_id
4130: ,p_name => 'P_SUB_INFORMATION1_PST'||i),
4131:
4132: hr_transaction_api.get_varchar2_value
4133: (p_transaction_step_id => p_transaction_step_id
4134: ,p_name => 'P_SUB_INFORMATION2_PST'||i),
4135:
4136: hr_transaction_api.get_varchar2_value

Line 4136: hr_transaction_api.get_varchar2_value

4132: hr_transaction_api.get_varchar2_value
4133: (p_transaction_step_id => p_transaction_step_id
4134: ,p_name => 'P_SUB_INFORMATION2_PST'||i),
4135:
4136: hr_transaction_api.get_varchar2_value
4137: (p_transaction_step_id => p_transaction_step_id
4138: ,p_name => 'P_SUB_INFORMATION3_PST'||i),
4139:
4140: hr_transaction_api.get_varchar2_value

Line 4140: hr_transaction_api.get_varchar2_value

4136: hr_transaction_api.get_varchar2_value
4137: (p_transaction_step_id => p_transaction_step_id
4138: ,p_name => 'P_SUB_INFORMATION3_PST'||i),
4139:
4140: hr_transaction_api.get_varchar2_value
4141: (p_transaction_step_id => p_transaction_step_id
4142: ,p_name => 'P_SUB_INFORMATION4_PST'||i),
4143:
4144: hr_transaction_api.get_varchar2_value

Line 4144: hr_transaction_api.get_varchar2_value

4140: hr_transaction_api.get_varchar2_value
4141: (p_transaction_step_id => p_transaction_step_id
4142: ,p_name => 'P_SUB_INFORMATION4_PST'||i),
4143:
4144: hr_transaction_api.get_varchar2_value
4145: (p_transaction_step_id => p_transaction_step_id
4146: ,p_name => 'P_SUB_INFORMATION5_PST'||i),
4147:
4148: hr_transaction_api.get_varchar2_value

Line 4148: hr_transaction_api.get_varchar2_value

4144: hr_transaction_api.get_varchar2_value
4145: (p_transaction_step_id => p_transaction_step_id
4146: ,p_name => 'P_SUB_INFORMATION5_PST'||i),
4147:
4148: hr_transaction_api.get_varchar2_value
4149: (p_transaction_step_id => p_transaction_step_id
4150: ,p_name => 'P_SUB_INFORMATION6_PST'||i),
4151:
4152: hr_transaction_api.get_varchar2_value

Line 4152: hr_transaction_api.get_varchar2_value

4148: hr_transaction_api.get_varchar2_value
4149: (p_transaction_step_id => p_transaction_step_id
4150: ,p_name => 'P_SUB_INFORMATION6_PST'||i),
4151:
4152: hr_transaction_api.get_varchar2_value
4153: (p_transaction_step_id => p_transaction_step_id
4154: ,p_name => 'P_SUB_INFORMATION7_PST'||i),
4155:
4156: hr_transaction_api.get_varchar2_value

Line 4156: hr_transaction_api.get_varchar2_value

4152: hr_transaction_api.get_varchar2_value
4153: (p_transaction_step_id => p_transaction_step_id
4154: ,p_name => 'P_SUB_INFORMATION7_PST'||i),
4155:
4156: hr_transaction_api.get_varchar2_value
4157: (p_transaction_step_id => p_transaction_step_id
4158: ,p_name => 'P_SUB_INFORMATION8_PST'||i),
4159:
4160: hr_transaction_api.get_varchar2_value

Line 4160: hr_transaction_api.get_varchar2_value

4156: hr_transaction_api.get_varchar2_value
4157: (p_transaction_step_id => p_transaction_step_id
4158: ,p_name => 'P_SUB_INFORMATION8_PST'||i),
4159:
4160: hr_transaction_api.get_varchar2_value
4161: (p_transaction_step_id => p_transaction_step_id
4162: ,p_name => 'P_SUB_INFORMATION9_PST'||i),
4163:
4164: hr_transaction_api.get_varchar2_value

Line 4164: hr_transaction_api.get_varchar2_value

4160: hr_transaction_api.get_varchar2_value
4161: (p_transaction_step_id => p_transaction_step_id
4162: ,p_name => 'P_SUB_INFORMATION9_PST'||i),
4163:
4164: hr_transaction_api.get_varchar2_value
4165: (p_transaction_step_id => p_transaction_step_id
4166: ,p_name => 'P_SUB_INFORMATION10_PST'||i),
4167:
4168: hr_transaction_api.get_varchar2_value

Line 4168: hr_transaction_api.get_varchar2_value

4164: hr_transaction_api.get_varchar2_value
4165: (p_transaction_step_id => p_transaction_step_id
4166: ,p_name => 'P_SUB_INFORMATION10_PST'||i),
4167:
4168: hr_transaction_api.get_varchar2_value
4169: (p_transaction_step_id => p_transaction_step_id
4170: ,p_name => 'P_SUB_INFORMATION11_PST'||i),
4171:
4172: hr_transaction_api.get_varchar2_value

Line 4172: hr_transaction_api.get_varchar2_value

4168: hr_transaction_api.get_varchar2_value
4169: (p_transaction_step_id => p_transaction_step_id
4170: ,p_name => 'P_SUB_INFORMATION11_PST'||i),
4171:
4172: hr_transaction_api.get_varchar2_value
4173: (p_transaction_step_id => p_transaction_step_id
4174: ,p_name => 'P_SUB_INFORMATION12_PST'||i),
4175:
4176: hr_transaction_api.get_varchar2_value

Line 4176: hr_transaction_api.get_varchar2_value

4172: hr_transaction_api.get_varchar2_value
4173: (p_transaction_step_id => p_transaction_step_id
4174: ,p_name => 'P_SUB_INFORMATION12_PST'||i),
4175:
4176: hr_transaction_api.get_varchar2_value
4177: (p_transaction_step_id => p_transaction_step_id
4178: ,p_name => 'P_SUB_INFORMATION13_PST'||i),
4179:
4180: hr_transaction_api.get_varchar2_value

Line 4180: hr_transaction_api.get_varchar2_value

4176: hr_transaction_api.get_varchar2_value
4177: (p_transaction_step_id => p_transaction_step_id
4178: ,p_name => 'P_SUB_INFORMATION13_PST'||i),
4179:
4180: hr_transaction_api.get_varchar2_value
4181: (p_transaction_step_id => p_transaction_step_id
4182: ,p_name => 'P_SUB_INFORMATION14_PST'||i),
4183:
4184: hr_transaction_api.get_varchar2_value

Line 4184: hr_transaction_api.get_varchar2_value

4180: hr_transaction_api.get_varchar2_value
4181: (p_transaction_step_id => p_transaction_step_id
4182: ,p_name => 'P_SUB_INFORMATION14_PST'||i),
4183:
4184: hr_transaction_api.get_varchar2_value
4185: (p_transaction_step_id => p_transaction_step_id
4186: ,p_name => 'P_SUB_INFORMATION15_PST'||i),
4187:
4188: hr_transaction_api.get_varchar2_value

Line 4188: hr_transaction_api.get_varchar2_value

4184: hr_transaction_api.get_varchar2_value
4185: (p_transaction_step_id => p_transaction_step_id
4186: ,p_name => 'P_SUB_INFORMATION15_PST'||i),
4187:
4188: hr_transaction_api.get_varchar2_value
4189: (p_transaction_step_id => p_transaction_step_id
4190: ,p_name => 'P_SUB_INFORMATION16_PST'||i),
4191:
4192: hr_transaction_api.get_varchar2_value

Line 4192: hr_transaction_api.get_varchar2_value

4188: hr_transaction_api.get_varchar2_value
4189: (p_transaction_step_id => p_transaction_step_id
4190: ,p_name => 'P_SUB_INFORMATION16_PST'||i),
4191:
4192: hr_transaction_api.get_varchar2_value
4193: (p_transaction_step_id => p_transaction_step_id
4194: ,p_name => 'P_SUB_INFORMATION17_PST'||i),
4195:
4196: hr_transaction_api.get_varchar2_value

Line 4196: hr_transaction_api.get_varchar2_value

4192: hr_transaction_api.get_varchar2_value
4193: (p_transaction_step_id => p_transaction_step_id
4194: ,p_name => 'P_SUB_INFORMATION17_PST'||i),
4195:
4196: hr_transaction_api.get_varchar2_value
4197: (p_transaction_step_id => p_transaction_step_id
4198: ,p_name => 'P_SUB_INFORMATION18_PST'||i),
4199:
4200: hr_transaction_api.get_varchar2_value

Line 4200: hr_transaction_api.get_varchar2_value

4196: hr_transaction_api.get_varchar2_value
4197: (p_transaction_step_id => p_transaction_step_id
4198: ,p_name => 'P_SUB_INFORMATION18_PST'||i),
4199:
4200: hr_transaction_api.get_varchar2_value
4201: (p_transaction_step_id => p_transaction_step_id
4202: ,p_name => 'P_SUB_INFORMATION19_PST'||i),
4203:
4204: hr_transaction_api.get_varchar2_value

Line 4204: hr_transaction_api.get_varchar2_value

4200: hr_transaction_api.get_varchar2_value
4201: (p_transaction_step_id => p_transaction_step_id
4202: ,p_name => 'P_SUB_INFORMATION19_PST'||i),
4203:
4204: hr_transaction_api.get_varchar2_value
4205: (p_transaction_step_id => p_transaction_step_id
4206: ,p_name => 'P_SUB_INFORMATION20_PST'||i)
4207: );
4208:

Line 4252: hr_transaction_api.get_varchar2_value

4248: Begin
4249:
4250: hr_utility.set_location('Entering:'||l_proc, 5);
4251: l_qualification_id :=
4252: hr_transaction_api.get_varchar2_value
4253: (p_transaction_step_id => p_transaction_step_id
4254: ,p_name => 'p_qualification_id');
4255:
4256: hr_utility.set_location('Exiting:'||l_proc, 15);