APPS.HR_TRANSACTION_API dependencies on HR_API_TRANSACTION_VALUES

Line 956: from hr_api_transaction_values hatv

952: l_proc constant varchar2(100) := g_package || ' update_transaction_step';
953: --
954: cursor csr_hatv is
955: select hatv.transaction_value_id
956: from hr_api_transaction_values hatv
957: where hatv.transaction_step_id = p_transaction_step_id;
958: --
959: begin
960: g_debug := hr_utility.debug_enabled;

Line 1040: delete from hr_api_transaction_values

1036: -- delete each transaction value
1037: -- Do this using direct SQL rather than in a loop using the row handler
1038: -- to improve performance.
1039: --
1040: delete from hr_api_transaction_values
1041: where transaction_step_id = p_transaction_step_id;
1042: -- delete the transaction step
1043: hr_trs_del.del
1044: (p_transaction_step_id => p_transaction_step_id

Line 1080: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;

1076: -- declare local variables
1077: -- --------------------------------------------------------------------------
1078: l_proc constant varchar2(100) := g_package || ' set_value';
1079: l_insert boolean := false;
1080: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
1081: l_name hr_api_transaction_values.name%type;
1082: --
1083: l_current_value varchar2(2000); --ns
1084: l_original_value varchar2(2000);

Line 1081: l_name hr_api_transaction_values.name%type;

1077: -- --------------------------------------------------------------------------
1078: l_proc constant varchar2(100) := g_package || ' set_value';
1079: l_insert boolean := false;
1080: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
1081: l_name hr_api_transaction_values.name%type;
1082: --
1083: l_current_value varchar2(2000); --ns
1084: l_original_value varchar2(2000);
1085: --

Line 1090: from hr_api_transaction_values hatv

1086: cursor csr_hatv is
1087: select hatv.transaction_value_id,
1088: varchar2_value || fnd_date.date_to_canonical(date_value) || number_value current_value, --ns
1089: original_varchar2_value || fnd_date.date_to_canonical(original_date_value) || original_number_value original_value
1090: from hr_api_transaction_values hatv
1091: where hatv.transaction_step_id = p_transaction_step_id
1092: and hatv.name = l_name;
1093: --
1094: begin

Line 1196: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;

1192: -- --------------------------------------------------------------------------
1193: -- declare local variables
1194: -- --------------------------------------------------------------------------
1195: l_proc constant varchar2(100) := g_package || ' set_varchar2_value';
1196: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
1197: --
1198: begin
1199: g_debug := hr_utility.debug_enabled;
1200:

Line 1237: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;

1233: -- --------------------------------------------------------------------------
1234: -- declare local variables
1235: -- --------------------------------------------------------------------------
1236: l_proc constant varchar2(100) := g_package || ' set_number_value';
1237: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
1238: --
1239: begin
1240: g_debug := hr_utility.debug_enabled;
1241:

Line 1278: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;

1274: -- --------------------------------------------------------------------------
1275: -- declare local variables
1276: -- --------------------------------------------------------------------------
1277: l_proc constant varchar2(100) := g_package || ' set_date_value';
1278: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
1279: --
1280: begin
1281: g_debug := hr_utility.debug_enabled;
1282:

Line 1319: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;

1315: -- --------------------------------------------------------------------------
1316: -- declare local variables
1317: -- --------------------------------------------------------------------------
1318: l_proc constant varchar2(100) := g_package || ' set_boolean_value';
1319: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
1320: l_value varchar2(30);
1321: l_original_value varchar2(30); --ns
1322: --
1323: begin

Line 1381: l_name hr_api_transaction_values.name%type;

1377: -- declare local variables
1378: -- --------------------------------------------------------------------------
1379: l_proc constant varchar2(100) := g_package || ' get_value';
1380: l_insert boolean := false;
1381: l_name hr_api_transaction_values.name%type;
1382: --
1383: cursor csr_hatv is
1384: select hatv.datatype
1385: ,hatv.varchar2_value

Line 1388: from hr_api_transaction_values hatv

1384: select hatv.datatype
1385: ,hatv.varchar2_value
1386: ,hatv.number_value
1387: ,hatv.date_value
1388: from hr_api_transaction_values hatv
1389: where hatv.transaction_step_id = p_transaction_step_id
1390: and hatv.name = l_name;
1391: --
1392: begin

Line 1428: l_datatype hr_api_transaction_values.datatype%type;

1424: -- --------------------------------------------------------------------------
1425: -- declare local variables
1426: -- --------------------------------------------------------------------------
1427: l_proc constant varchar2(100) := g_package || ' get_varchar2_value';
1428: l_datatype hr_api_transaction_values.datatype%type;
1429: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1430: l_number hr_api_transaction_values.number_value%type;
1431: l_date hr_api_transaction_values.date_value%type;
1432: --

Line 1429: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1425: -- declare local variables
1426: -- --------------------------------------------------------------------------
1427: l_proc constant varchar2(100) := g_package || ' get_varchar2_value';
1428: l_datatype hr_api_transaction_values.datatype%type;
1429: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1430: l_number hr_api_transaction_values.number_value%type;
1431: l_date hr_api_transaction_values.date_value%type;
1432: --
1433: begin

Line 1430: l_number hr_api_transaction_values.number_value%type;

1426: -- --------------------------------------------------------------------------
1427: l_proc constant varchar2(100) := g_package || ' get_varchar2_value';
1428: l_datatype hr_api_transaction_values.datatype%type;
1429: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1430: l_number hr_api_transaction_values.number_value%type;
1431: l_date hr_api_transaction_values.date_value%type;
1432: --
1433: begin
1434: g_debug := hr_utility.debug_enabled;

Line 1431: l_date hr_api_transaction_values.date_value%type;

1427: l_proc constant varchar2(100) := g_package || ' get_varchar2_value';
1428: l_datatype hr_api_transaction_values.datatype%type;
1429: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1430: l_number hr_api_transaction_values.number_value%type;
1431: l_date hr_api_transaction_values.date_value%type;
1432: --
1433: begin
1434: g_debug := hr_utility.debug_enabled;
1435:

Line 1467: l_datatype hr_api_transaction_values.datatype%type;

1463: -- --------------------------------------------------------------------------
1464: -- declare local variables
1465: -- --------------------------------------------------------------------------
1466: l_proc constant varchar2(100) := g_package || ' get_number_value';
1467: l_datatype hr_api_transaction_values.datatype%type;
1468: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1469: l_number hr_api_transaction_values.number_value%type;
1470: l_date hr_api_transaction_values.date_value%type;
1471: --

Line 1468: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1464: -- declare local variables
1465: -- --------------------------------------------------------------------------
1466: l_proc constant varchar2(100) := g_package || ' get_number_value';
1467: l_datatype hr_api_transaction_values.datatype%type;
1468: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1469: l_number hr_api_transaction_values.number_value%type;
1470: l_date hr_api_transaction_values.date_value%type;
1471: --
1472: begin

Line 1469: l_number hr_api_transaction_values.number_value%type;

1465: -- --------------------------------------------------------------------------
1466: l_proc constant varchar2(100) := g_package || ' get_number_value';
1467: l_datatype hr_api_transaction_values.datatype%type;
1468: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1469: l_number hr_api_transaction_values.number_value%type;
1470: l_date hr_api_transaction_values.date_value%type;
1471: --
1472: begin
1473: g_debug := hr_utility.debug_enabled;

Line 1470: l_date hr_api_transaction_values.date_value%type;

1466: l_proc constant varchar2(100) := g_package || ' get_number_value';
1467: l_datatype hr_api_transaction_values.datatype%type;
1468: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1469: l_number hr_api_transaction_values.number_value%type;
1470: l_date hr_api_transaction_values.date_value%type;
1471: --
1472: begin
1473: g_debug := hr_utility.debug_enabled;
1474:

Line 1508: l_datatype hr_api_transaction_values.datatype%type;

1504: -- --------------------------------------------------------------------------
1505: -- declare local variables
1506: -- --------------------------------------------------------------------------
1507: l_proc constant varchar2(100) := g_package || ' get_date_value';
1508: l_datatype hr_api_transaction_values.datatype%type;
1509: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1510: l_number hr_api_transaction_values.number_value%type;
1511: l_date hr_api_transaction_values.date_value%type;
1512: --

Line 1509: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1505: -- declare local variables
1506: -- --------------------------------------------------------------------------
1507: l_proc constant varchar2(100) := g_package || ' get_date_value';
1508: l_datatype hr_api_transaction_values.datatype%type;
1509: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1510: l_number hr_api_transaction_values.number_value%type;
1511: l_date hr_api_transaction_values.date_value%type;
1512: --
1513: begin

Line 1510: l_number hr_api_transaction_values.number_value%type;

1506: -- --------------------------------------------------------------------------
1507: l_proc constant varchar2(100) := g_package || ' get_date_value';
1508: l_datatype hr_api_transaction_values.datatype%type;
1509: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1510: l_number hr_api_transaction_values.number_value%type;
1511: l_date hr_api_transaction_values.date_value%type;
1512: --
1513: begin
1514: g_debug := hr_utility.debug_enabled;

Line 1511: l_date hr_api_transaction_values.date_value%type;

1507: l_proc constant varchar2(100) := g_package || ' get_date_value';
1508: l_datatype hr_api_transaction_values.datatype%type;
1509: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1510: l_number hr_api_transaction_values.number_value%type;
1511: l_date hr_api_transaction_values.date_value%type;
1512: --
1513: begin
1514: g_debug := hr_utility.debug_enabled;
1515:

Line 1550: l_datatype hr_api_transaction_values.datatype%type;

1546: -- --------------------------------------------------------------------------
1547: -- declare local variables
1548: -- --------------------------------------------------------------------------
1549: l_proc constant varchar2(100) := g_package || ' get_date2char_value';
1550: l_datatype hr_api_transaction_values.datatype%type;
1551: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1552: l_number hr_api_transaction_values.number_value%type;
1553: l_date hr_api_transaction_values.date_value%type;
1554: l_char_date varchar2(200);

Line 1551: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1547: -- declare local variables
1548: -- --------------------------------------------------------------------------
1549: l_proc constant varchar2(100) := g_package || ' get_date2char_value';
1550: l_datatype hr_api_transaction_values.datatype%type;
1551: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1552: l_number hr_api_transaction_values.number_value%type;
1553: l_date hr_api_transaction_values.date_value%type;
1554: l_char_date varchar2(200);
1555: --

Line 1552: l_number hr_api_transaction_values.number_value%type;

1548: -- --------------------------------------------------------------------------
1549: l_proc constant varchar2(100) := g_package || ' get_date2char_value';
1550: l_datatype hr_api_transaction_values.datatype%type;
1551: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1552: l_number hr_api_transaction_values.number_value%type;
1553: l_date hr_api_transaction_values.date_value%type;
1554: l_char_date varchar2(200);
1555: --
1556: begin

Line 1553: l_date hr_api_transaction_values.date_value%type;

1549: l_proc constant varchar2(100) := g_package || ' get_date2char_value';
1550: l_datatype hr_api_transaction_values.datatype%type;
1551: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1552: l_number hr_api_transaction_values.number_value%type;
1553: l_date hr_api_transaction_values.date_value%type;
1554: l_char_date varchar2(200);
1555: --
1556: begin
1557: g_debug := hr_utility.debug_enabled;

Line 1596: l_datatype hr_api_transaction_values.datatype%type;

1592: -- --------------------------------------------------------------------------
1593: -- declare local variables
1594: -- --------------------------------------------------------------------------
1595: l_proc constant varchar2(100) := g_package || ' get_boolean_value';
1596: l_datatype hr_api_transaction_values.datatype%type;
1597: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1598: l_number hr_api_transaction_values.number_value%type;
1599: l_date hr_api_transaction_values.date_value%type;
1600: l_boolean boolean;

Line 1597: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1593: -- declare local variables
1594: -- --------------------------------------------------------------------------
1595: l_proc constant varchar2(100) := g_package || ' get_boolean_value';
1596: l_datatype hr_api_transaction_values.datatype%type;
1597: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1598: l_number hr_api_transaction_values.number_value%type;
1599: l_date hr_api_transaction_values.date_value%type;
1600: l_boolean boolean;
1601: --

Line 1598: l_number hr_api_transaction_values.number_value%type;

1594: -- --------------------------------------------------------------------------
1595: l_proc constant varchar2(100) := g_package || ' get_boolean_value';
1596: l_datatype hr_api_transaction_values.datatype%type;
1597: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1598: l_number hr_api_transaction_values.number_value%type;
1599: l_date hr_api_transaction_values.date_value%type;
1600: l_boolean boolean;
1601: --
1602: begin

Line 1599: l_date hr_api_transaction_values.date_value%type;

1595: l_proc constant varchar2(100) := g_package || ' get_boolean_value';
1596: l_datatype hr_api_transaction_values.datatype%type;
1597: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1598: l_number hr_api_transaction_values.number_value%type;
1599: l_date hr_api_transaction_values.date_value%type;
1600: l_boolean boolean;
1601: --
1602: begin
1603: g_debug := hr_utility.debug_enabled;

Line 1648: l_name hr_api_transaction_values.name%type;

1644: -- declare local variables
1645: -- --------------------------------------------------------------------------
1646: l_proc constant varchar2(100) := g_package || ' get_original_value';
1647: l_insert boolean := false;
1648: l_name hr_api_transaction_values.name%type;
1649: --
1650: cursor csr_hatv is
1651: select hatv.datatype
1652: ,hatv.original_varchar2_value

Line 1655: from hr_api_transaction_values hatv

1651: select hatv.datatype
1652: ,hatv.original_varchar2_value
1653: ,hatv.original_number_value
1654: ,hatv.original_date_value
1655: from hr_api_transaction_values hatv
1656: where hatv.transaction_step_id = p_transaction_step_id
1657: and hatv.name = l_name;
1658: --
1659: begin

Line 1701: l_datatype hr_api_transaction_values.datatype%type;

1697: -- --------------------------------------------------------------------------
1698: -- declare local variables
1699: -- --------------------------------------------------------------------------
1700: l_proc constant varchar2(100) := g_package || ' get_original_varchar2_value';
1701: l_datatype hr_api_transaction_values.datatype%type;
1702: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1703: l_number hr_api_transaction_values.number_value%type;
1704: l_date hr_api_transaction_values.date_value%type;
1705: --

Line 1702: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1698: -- declare local variables
1699: -- --------------------------------------------------------------------------
1700: l_proc constant varchar2(100) := g_package || ' get_original_varchar2_value';
1701: l_datatype hr_api_transaction_values.datatype%type;
1702: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1703: l_number hr_api_transaction_values.number_value%type;
1704: l_date hr_api_transaction_values.date_value%type;
1705: --
1706: begin

Line 1703: l_number hr_api_transaction_values.number_value%type;

1699: -- --------------------------------------------------------------------------
1700: l_proc constant varchar2(100) := g_package || ' get_original_varchar2_value';
1701: l_datatype hr_api_transaction_values.datatype%type;
1702: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1703: l_number hr_api_transaction_values.number_value%type;
1704: l_date hr_api_transaction_values.date_value%type;
1705: --
1706: begin
1707: g_debug := hr_utility.debug_enabled;

Line 1704: l_date hr_api_transaction_values.date_value%type;

1700: l_proc constant varchar2(100) := g_package || ' get_original_varchar2_value';
1701: l_datatype hr_api_transaction_values.datatype%type;
1702: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1703: l_number hr_api_transaction_values.number_value%type;
1704: l_date hr_api_transaction_values.date_value%type;
1705: --
1706: begin
1707: g_debug := hr_utility.debug_enabled;
1708:

Line 1740: l_datatype hr_api_transaction_values.datatype%type;

1736: -- --------------------------------------------------------------------------
1737: -- declare local variables
1738: -- --------------------------------------------------------------------------
1739: l_proc constant varchar2(100) := g_package || ' get_original_number_value';
1740: l_datatype hr_api_transaction_values.datatype%type;
1741: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1742: l_number hr_api_transaction_values.number_value%type;
1743: l_date hr_api_transaction_values.date_value%type;
1744: --

Line 1741: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1737: -- declare local variables
1738: -- --------------------------------------------------------------------------
1739: l_proc constant varchar2(100) := g_package || ' get_original_number_value';
1740: l_datatype hr_api_transaction_values.datatype%type;
1741: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1742: l_number hr_api_transaction_values.number_value%type;
1743: l_date hr_api_transaction_values.date_value%type;
1744: --
1745: begin

Line 1742: l_number hr_api_transaction_values.number_value%type;

1738: -- --------------------------------------------------------------------------
1739: l_proc constant varchar2(100) := g_package || ' get_original_number_value';
1740: l_datatype hr_api_transaction_values.datatype%type;
1741: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1742: l_number hr_api_transaction_values.number_value%type;
1743: l_date hr_api_transaction_values.date_value%type;
1744: --
1745: begin
1746: g_debug := hr_utility.debug_enabled;

Line 1743: l_date hr_api_transaction_values.date_value%type;

1739: l_proc constant varchar2(100) := g_package || ' get_original_number_value';
1740: l_datatype hr_api_transaction_values.datatype%type;
1741: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1742: l_number hr_api_transaction_values.number_value%type;
1743: l_date hr_api_transaction_values.date_value%type;
1744: --
1745: begin
1746: g_debug := hr_utility.debug_enabled;
1747:

Line 1779: l_datatype hr_api_transaction_values.datatype%type;

1775: -- --------------------------------------------------------------------------
1776: -- declare local variables
1777: -- --------------------------------------------------------------------------
1778: l_proc constant varchar2(100) := g_package || ' get_original_date_value';
1779: l_datatype hr_api_transaction_values.datatype%type;
1780: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1781: l_number hr_api_transaction_values.number_value%type;
1782: l_date hr_api_transaction_values.date_value%type;
1783: --

Line 1780: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1776: -- declare local variables
1777: -- --------------------------------------------------------------------------
1778: l_proc constant varchar2(100) := g_package || ' get_original_date_value';
1779: l_datatype hr_api_transaction_values.datatype%type;
1780: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1781: l_number hr_api_transaction_values.number_value%type;
1782: l_date hr_api_transaction_values.date_value%type;
1783: --
1784: begin

Line 1781: l_number hr_api_transaction_values.number_value%type;

1777: -- --------------------------------------------------------------------------
1778: l_proc constant varchar2(100) := g_package || ' get_original_date_value';
1779: l_datatype hr_api_transaction_values.datatype%type;
1780: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1781: l_number hr_api_transaction_values.number_value%type;
1782: l_date hr_api_transaction_values.date_value%type;
1783: --
1784: begin
1785: g_debug := hr_utility.debug_enabled;

Line 1782: l_date hr_api_transaction_values.date_value%type;

1778: l_proc constant varchar2(100) := g_package || ' get_original_date_value';
1779: l_datatype hr_api_transaction_values.datatype%type;
1780: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1781: l_number hr_api_transaction_values.number_value%type;
1782: l_date hr_api_transaction_values.date_value%type;
1783: --
1784: begin
1785: g_debug := hr_utility.debug_enabled;
1786:

Line 1818: l_datatype hr_api_transaction_values.datatype%type;

1814: -- --------------------------------------------------------------------------
1815: -- declare local variables
1816: -- --------------------------------------------------------------------------
1817: l_proc constant varchar2(100) := g_package || ' get_original_boolean_value';
1818: l_datatype hr_api_transaction_values.datatype%type;
1819: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1820: l_number hr_api_transaction_values.number_value%type;
1821: l_date hr_api_transaction_values.date_value%type;
1822: l_boolean boolean;

Line 1819: l_varchar2 hr_api_transaction_values.varchar2_value%type;

1815: -- declare local variables
1816: -- --------------------------------------------------------------------------
1817: l_proc constant varchar2(100) := g_package || ' get_original_boolean_value';
1818: l_datatype hr_api_transaction_values.datatype%type;
1819: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1820: l_number hr_api_transaction_values.number_value%type;
1821: l_date hr_api_transaction_values.date_value%type;
1822: l_boolean boolean;
1823: --

Line 1820: l_number hr_api_transaction_values.number_value%type;

1816: -- --------------------------------------------------------------------------
1817: l_proc constant varchar2(100) := g_package || ' get_original_boolean_value';
1818: l_datatype hr_api_transaction_values.datatype%type;
1819: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1820: l_number hr_api_transaction_values.number_value%type;
1821: l_date hr_api_transaction_values.date_value%type;
1822: l_boolean boolean;
1823: --
1824: begin

Line 1821: l_date hr_api_transaction_values.date_value%type;

1817: l_proc constant varchar2(100) := g_package || ' get_original_boolean_value';
1818: l_datatype hr_api_transaction_values.datatype%type;
1819: l_varchar2 hr_api_transaction_values.varchar2_value%type;
1820: l_number hr_api_transaction_values.number_value%type;
1821: l_date hr_api_transaction_values.date_value%type;
1822: l_boolean boolean;
1823: --
1824: begin
1825: g_debug := hr_utility.debug_enabled;

Line 1893: from hr_api_transaction_values trv

1889: ,p_validate in boolean default false) is
1890: -- cursor to select all transaction values for a transaction
1891: cursor csr_trv(c_transaction_step_id number) is
1892: select trv.transaction_value_id
1893: from hr_api_transaction_values trv
1894: where trv.transaction_step_id = c_transaction_step_id;
1895: -- cursor to select all transaction steps for a transaction
1896: cursor csr_trs is
1897: select trs.transaction_step_id