[Home] [Help]
106: sequence_no,
107: parameter_name,
108: data_type,
109: route_parameter_id)
110: select ff_routes_s.currval,
111: p_sequence_no,
112: p_parameter_name,
113: p_data_type,
114: ff_route_parameters_s.nextval
127: insert into ff_route_context_usages
128: (route_id,
129: context_id,
130: sequence_no)
131: select ff_routes_s.currval,
132: p_context_id,
133: p_sequence_no
134: from dual;
135: end insert_route_context_usages;
216: last_updated_by,
217: last_update_login,
218: created_by,
219: creation_date)
220: select ff_routes_s.nextval,
221: 'ELEMENT_TYPE_AT_TYPE_LEVEL',
222: 'N',
223: 'simple element type route',
224: l_text,
265: last_updated_by,
266: last_update_login,
267: created_by,
268: creation_date)
269: select ff_routes_s.nextval,
270: 'ELEMENT_TYPE_AT_TYPE_LEVEL_DP',
271: 'N',
272: 'route for date paid element type at type level',
273: l_text,
346: -- inserting with a select when using a long data type. So select the next
347: -- value for the route_id separately, until this bug is fixed:
348: --
349: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 10);
350: select ff_routes_s.nextval
351: into l_temp
352: from dual;
353: --
354: -- now do the normal insert
364: last_updated_by,
365: last_update_login,
366: created_by,
367: creation_date)
368: values (ff_routes_s.currval,
369: 'ELEMENT_TYPE_AT_ASSIGNMENT_LEVEL',
370: 'N',
371: 'element type information with partial matching to the element link table',
372: l_text,
449: -- inserting with a select when using a long data type. So select the next
450: -- value for the route_id separately, until this bug is fixed:
451: --
452: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 12);
453: select ff_routes_s.nextval
454: into l_temp
455: from dual;
456: --
457: -- now do the normal insert
467: last_updated_by,
468: last_update_login,
469: created_by,
470: creation_date)
471: values (ff_routes_s.currval,
472: 'ELEMENT_TYPE_AT_ASSIGNMENT_LEVEL_DP',
473: 'N',
474: 'Date paid element type info with partial matching to the element link table',
475: l_text,
519: last_updated_by,
520: last_update_login,
521: created_by,
522: creation_date)
523: select ff_routes_s.nextval,
524: 'ELEMENT_TYPE_COUNT_OF_ELEMENT_ENTRIES',
525: 'N',
526: 'route to element entry table for given assignment and element type',
527: l_text,
571: last_updated_by,
572: last_update_login,
573: created_by,
574: creation_date)
575: select ff_routes_s.nextval,
576: 'ELEMENT_TYPE_COUNT_OF_ELEMENT_ENTRIES_DP',
577: 'N',
578: 'route for DP, element entry table for given assignment and element type',
579: l_text,
613: last_updated_by,
614: last_update_login,
615: created_by,
616: creation_date)
617: select ff_routes_s.nextval,
618: 'INPUT_VALUE_FROM_INPUT_VALUE_TABLE',
619: 'N',
620: 'route to input value table',
621: l_text,
658: last_updated_by,
659: last_update_login,
660: created_by,
661: creation_date)
662: select ff_routes_s.nextval,
663: 'INPUT_VALUE_FROM_INPUT_VALUE_TABLE_DP',
664: 'N',
665: 'Date paid route to input value table',
666: l_text,
728: -- inserting with a select when using a long data type. So select the next
729: -- value for the route_id separately, until this bug is fixed:
730: --
731: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 18);
732: select ff_routes_s.nextval
733: into l_temp
734: from dual;
735: --
736: -- now do the normal insert
746: last_updated_by,
747: last_update_login,
748: created_by,
749: creation_date)
750: values (ff_routes_s.currval,
751: 'INPUT_VALUE_USING_PARTIAL_MATCHING',
752: 'N',
753: 'route for input value for given assignment id',
754: l_text,
820: -- inserting with a select when using a long data type. So select the next
821: -- value for the route_id separately, until this bug is fixed:
822: --
823: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 20);
824: select ff_routes_s.nextval
825: into l_temp
826: from dual;
827: --
828: -- now do the normal insert
838: last_updated_by,
839: last_update_login,
840: created_by,
841: creation_date)
842: values (ff_routes_s.currval,
843: 'INPUT_VALUE_USING_PARTIAL_MATCHING_DP',
844: 'N',
845: 'route for input value for given assignment id',
846: l_text,
892: last_updated_by,
893: last_update_login,
894: created_by,
895: creation_date)
896: select ff_routes_s.nextval,
897: 'INPUT_VALUE_ENTRY_LEVEL',
898: 'N',
899: 'route for input value to element entry level',
900: l_text,
959: last_updated_by,
960: last_update_login,
961: created_by,
962: creation_date)
963: select ff_routes_s.nextval,
964: 'INPUT_VALUE_ENTRY_LEVEL_DP',
965: 'N',
966: 'route for input value to element entry level',
967: l_text,
1004: last_updated_by,
1005: last_update_login,
1006: created_by,
1007: creation_date)
1008: select ff_routes_s.nextval,
1009: 'GRADE_RATE_ROUTE',
1010: 'N',
1011: 'route for grade rates',
1012: l_text,
1048: last_updated_by,
1049: last_update_login,
1050: created_by,
1051: creation_date)
1052: select ff_routes_s.nextval,
1053: 'PEOPLE_FLEXFIELD_ROUTE',
1054: 'N',
1055: 'people group flexfield route',
1056: l_text,
1087: last_updated_by,
1088: last_update_login,
1089: created_by,
1090: creation_date)
1091: select ff_routes_s.nextval,
1092: 'PAYROLL_FLEXFIELD_ROUTE',
1093: 'N',
1094: 'payroll flexfield route',
1095: l_text,
1126: last_updated_by,
1127: last_update_login,
1128: created_by,
1129: creation_date)
1130: select ff_routes_s.nextval,
1131: 'ASSIGNMENT_FLEXFIELD_ROUTE',
1132: 'N',
1133: 'assignment flexfield route',
1134: l_text,
1167: last_updated_by,
1168: last_update_login,
1169: created_by,
1170: creation_date)
1171: select ff_routes_s.nextval,
1172: 'GRADE_FLEXFIELD_ROUTE',
1173: 'N',
1174: 'grade flexfield route',
1175: l_text,
1215: last_updated_by,
1216: last_update_login,
1217: created_by,
1218: creation_date)
1219: select ff_routes_s.nextval,
1220: 'ABSENCE_DESC_FLEX_ROUTE',
1221: 'N',
1222: 'Absence flexfield route',
1223: l_text,
1265: last_updated_by,
1266: last_update_login,
1267: created_by,
1268: creation_date)
1269: select ff_routes_s.nextval,
1270: 'ABSENCE_TYPE_DESC_FLEX_ROUTE',
1271: 'N',
1272: 'Absence type flexfield route',
1273: l_text,
1309: last_updated_by,
1310: last_update_login,
1311: created_by,
1312: creation_date)
1313: select ff_routes_s.nextval,
1314: 'EMPLOYEE_ADDRESSES_DESC_FLEX_ROUTE',
1315: 'N',
1316: 'Employee Addresses flexfield route',
1317: l_text,
1353: last_updated_by,
1354: last_update_login,
1355: created_by,
1356: creation_date)
1357: select ff_routes_s.nextval,
1358: 'EVENTS_DESC_FLEX_ROUTE',
1359: 'N',
1360: 'Events flexfield route',
1361: l_text,
1394: last_updated_by,
1395: last_update_login,
1396: created_by,
1397: creation_date)
1398: select ff_routes_s.nextval,
1399: 'JOBS_DESC_FLEX_ROUTE',
1400: 'N',
1401: 'Job flexfield route',
1402: l_text,
1437: last_updated_by,
1438: last_update_login,
1439: created_by,
1440: creation_date)
1441: select ff_routes_s.nextval,
1442: 'CONTACTS_DESC_FLEX_ROUTE',
1443: 'N',
1444: 'Contacts flexfield route',
1445: l_text,
1479: last_updated_by,
1480: last_update_login,
1481: created_by,
1482: creation_date)
1483: select ff_routes_s.nextval,
1484: 'PERIODS_OF_SERVICE_DESC_FLEX_ROUTE',
1485: 'N',
1486: 'periods of service flexfield route',
1487: l_text,
1521: last_updated_by,
1522: last_update_login,
1523: created_by,
1524: creation_date)
1525: select ff_routes_s.nextval,
1526: 'RECRUITMENT_ACTIVITIES_DESC_FLEX_ROUTE',
1527: 'N',
1528: 'recruitment activities flexfield route',
1529: l_text,
1562: last_updated_by,
1563: last_update_login,
1564: created_by,
1565: creation_date)
1566: select ff_routes_s.nextval,
1567: 'POSITION_DESC_FLEX_ROUTE',
1568: 'N',
1569: 'Positions flexfield route',
1570: l_text,
1604: last_updated_by,
1605: last_update_login,
1606: created_by,
1607: creation_date)
1608: select ff_routes_s.nextval,
1609: 'APPLICATIONS_DESC_FLEX_ROUTE',
1610: 'N',
1611: 'Applications flexfield route',
1612: l_text,
1645: last_updated_by,
1646: last_update_login,
1647: created_by,
1648: creation_date)
1649: select ff_routes_s.nextval,
1650: 'ORGANIZATION_DESC_FLEX_ROUTE',
1651: 'N',
1652: 'Organization flexfield route',
1653: l_text,
1688: last_updated_by,
1689: last_update_login,
1690: created_by,
1691: creation_date)
1692: select ff_routes_s.nextval,
1693: 'DEVELOPER_ORG_DESC_FLEX_ROUTE',
1694: 'N',
1695: 'route for Organization Developer Descriptive Flexfield',
1696: l_text,
1727: last_updated_by,
1728: last_update_login,
1729: created_by,
1730: creation_date)
1731: select ff_routes_s.nextval,
1732: 'DEVELOPER_ASS_DESC_FLEX_ROUTE',
1733: 'N',
1734: 'route for Assignment Developer Descriptive Flexfield',
1735: l_text,
1767: last_updated_by,
1768: last_update_login,
1769: created_by,
1770: creation_date)
1771: select ff_routes_s.nextval,
1772: 'ORG_PAY_METHOD_DESC_FLEX_ROUTE',
1773: 'N',
1774: 'route for Organization Payment Method Descriptive Flex',
1775: l_text,
1809: last_updated_by,
1810: last_update_login,
1811: created_by,
1812: creation_date)
1813: select ff_routes_s.nextval,
1814: 'EXT_ACCOUNT_PER_KEYFLEX_ROUTE',
1815: 'N',
1816: 'route for Personal External Account Keyflex',
1817: l_text,
1850: last_updated_by,
1851: last_update_login,
1852: created_by,
1853: creation_date)
1854: select ff_routes_s.nextval,
1855: 'EXT_ACCOUNT_ORG_KEYFLEX_ROUTE',
1856: 'N',
1857: 'route for Organization External Account Keyflex',
1858: l_text,
1889: last_updated_by,
1890: last_update_login,
1891: created_by,
1892: creation_date)
1893: select ff_routes_s.nextval,
1894: 'LEGAL_CO_DESC_FLEX_ROUTE',
1895: 'N',
1896: 'route for Legal Company Descriptive Flex',
1897: l_text,
1942: last_updated_by,
1943: last_update_login,
1944: created_by,
1945: creation_date)
1946: select ff_routes_s.nextval,
1947: 'ABSENCE_SUM_OF_ELEMENT_ENTRY_VALUES',
1948: 'N',
1949: 'absence route to element entry values',
1950: l_text,
1991: last_updated_by,
1992: last_update_login,
1993: created_by,
1994: creation_date)
1995: select ff_routes_s.nextval,
1996: 'SPINE_RATE_ROUTE',
1997: 'N',
1998: 'route for grade rates',
1999: l_text,
2045: last_updated_by,
2046: last_update_login,
2047: created_by,
2048: creation_date)
2049: select ff_routes_s.nextval,
2050: 'KEY_FLEXFIELD_ROUTE',
2051: 'N',
2052: 'key flexfield route',
2053: l_text,
2088: last_updated_by,
2089: last_update_login,
2090: created_by,
2091: creation_date)
2092: select ff_routes_s.nextval,
2093: 'SCL_ASS_FLEX_ROUTE',
2094: 'N',
2095: 'route for SCL assignment level Flexfield',
2096: l_text,
2136: last_updated_by,
2137: last_update_login,
2138: created_by,
2139: creation_date)
2140: select ff_routes_s.nextval,
2141: 'SCL_PAY_FLEX_ROUTE',
2142: 'N',
2143: 'route for SCL payroll level Flexfield',
2144: l_text,
2182: last_updated_by,
2183: last_update_login,
2184: created_by,
2185: creation_date)
2186: select ff_routes_s.nextval,
2187: 'SCL_ORG_FLEX_ROUTE',
2188: 'N',
2189: 'route for SCL organization level Flexfield',
2190: l_text,
2244: last_updated_by,
2245: last_update_login,
2246: created_by,
2247: creation_date)
2248: select ff_routes_s.nextval,
2249: 'RETROADJ_RUN_BAL_ROUTE',
2250: 'N',
2251: 'route for Retroadjusted Run To Date Balance',
2252: l_text,