[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;
205: AND CELOOK.application_id = 800
206: AND CELOOK.lookup_type = ''YES_NO''';
207: --
208: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 8);
209: insert into ff_routes
210: (route_id,
211: route_name,
212: user_defined_flag,
213: description,
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,
254: AND CELOOK.application_id = 800
255: AND CELOOK.lookup_type = ''YES_NO''';
256: --
257: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 9);
258: insert into ff_routes
259: (route_id,
260: route_name,
261: user_defined_flag,
262: description,
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
353: --
354: -- now do the normal insert
355: --
356: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 11);
357: insert into ff_routes
358: (route_id,
359: route_name,
360: user_defined_flag,
361: description,
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
456: --
457: -- now do the normal insert
458: --
459: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 13);
460: insert into ff_routes
461: (route_id,
462: route_name,
463: user_defined_flag,
464: description,
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,
508: AND ETYPE.element_type_id = &U1
509: AND EE.assignment_id = &B2';
510: --
511: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 14);
512: insert into ff_routes
513: (route_id,
514: route_name,
515: user_defined_flag,
516: description,
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,
560: AND ETYPE.effective_end_date
561: AND ETYPE.element_type_id = &U1';
562: --
563: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 15);
564: insert into ff_routes
565: (route_id,
566: route_name,
567: user_defined_flag,
568: description,
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,
602: AND UMLOOK.application_id = 800
603: AND UMLOOK.lookup_type = ''UNITS''';
604: --
605: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 16);
606: insert into ff_routes
607: (route_id,
608: route_name,
609: user_defined_flag,
610: description,
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,
647: AND UMLOOK.application_id = 800
648: AND UMLOOK.lookup_type = ''UNITS''';
649: --
650: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 17);
651: insert into ff_routes
652: (route_id,
653: route_name,
654: user_defined_flag,
655: description,
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
735: --
736: -- now do the normal insert
737: --
738: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 19);
739: insert into ff_routes
740: (route_id,
741: route_name,
742: user_defined_flag,
743: description,
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
827: --
828: -- now do the normal insert
829: --
830: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 21);
831: insert into ff_routes
832: (route_id,
833: route_name,
834: user_defined_flag,
835: description,
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,
881: AND EE.effective_end_date
882: AND nvl(EE.ENTRY_TYPE, ''E'') = ''E''';
883: --
884: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 22);
885: insert into ff_routes
886: (route_id,
887: route_name,
888: user_defined_flag,
889: description,
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,
948: AND SES.effective_date BETWEEN EEV.effective_start_date
949: AND EEV.effective_end_date';
950: --
951: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 23);
952: insert into ff_routes
953: (route_id,
954: route_name,
955: user_defined_flag,
956: description,
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,
993: AND ASSIGN.effective_end_date
994: AND GRULE.rate_id = &U1';
995: --
996: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 24);
997: insert into ff_routes
998: (route_id,
999: route_name,
1000: user_defined_flag,
1001: description,
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,
1037: AND &B1 BETWEEN target.effective_start_date
1038: AND target.effective_end_date';
1039: --
1040: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 25);
1041: insert into ff_routes
1042: (route_id,
1043: route_name,
1044: user_defined_flag,
1045: description,
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,
1076: AND &B2 BETWEEN target.effective_start_date
1077: AND target.effective_end_date';
1078: --
1079: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 26);
1080: insert into ff_routes
1081: (route_id,
1082: route_name,
1083: user_defined_flag,
1084: description,
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,
1115: AND target.effective_end_date
1116: AND target.assignment_id = &B2';
1117: --
1118: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 28);
1119: insert into ff_routes
1120: (route_id,
1121: route_name,
1122: user_defined_flag,
1123: description,
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,
1156: AND ASSIGN.assignment_id = &B2
1157: AND ASSIGN.grade_id = target.grade_id';
1158: --
1159: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 29);
1160: insert into ff_routes
1161: (route_id,
1162: route_name,
1163: user_defined_flag,
1164: description,
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,
1204: and date_start <= &B1
1205: )';
1206: --
1207: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 30);
1208: insert into ff_routes
1209: (route_id,
1210: route_name,
1211: user_defined_flag,
1212: description,
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,
1254: and date_start <= &B1
1255: )';
1256: --
1257: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 31);
1258: insert into ff_routes
1259: (route_id,
1260: route_name,
1261: user_defined_flag,
1262: description,
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,
1298: AND &B1 BETWEEN target.date_from
1299: AND nvl (target.date_to, to_date (''4712/12/31'',''YYYY/MM/DD''))';
1300: --
1301: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 32);
1302: insert into ff_routes
1303: (route_id,
1304: route_name,
1305: user_defined_flag,
1306: description,
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,
1342: and nvl (date_end, to_date (''4712/12/31'',''YYYY/MM/DD''))
1343: )';
1344: --
1345: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 33);
1346: insert into ff_routes
1347: (route_id,
1348: route_name,
1349: user_defined_flag,
1350: description,
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,
1383: AND ASSIGN.assignment_id = &B2
1384: AND ASSIGN.job_id = target.job_id';
1385: --
1386: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 34);
1387: insert into ff_routes
1388: (route_id,
1389: route_name,
1390: user_defined_flag,
1391: description,
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,
1426: AND ASSIGN.person_id = target.contact_person_id
1427: AND target.primary_contact_flag = ''Y''';
1428: --
1429: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 35);
1430: insert into ff_routes
1431: (route_id,
1432: route_name,
1433: user_defined_flag,
1434: description,
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,
1468: AND ASSIGN.assignment_type = ''E''
1469: AND target.period_of_service_id = ASSIGN.period_of_service_id';
1470: --
1471: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 36);
1472: insert into ff_routes
1473: (route_id,
1474: route_name,
1475: user_defined_flag,
1476: description,
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,
1510: AND ASSIGN.assignment_type = ''A''
1511: AND target.recruitment_activity_id = ASSIGN.recruitment_activity_id';
1512: --
1513: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 37);
1514: insert into ff_routes
1515: (route_id,
1516: route_name,
1517: user_defined_flag,
1518: description,
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,
1551: AND ASSIGN.assignment_id = &B2
1552: AND target.position_id = ASSIGN.position_id';
1553: --
1554: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 38);
1555: insert into ff_routes
1556: (route_id,
1557: route_name,
1558: user_defined_flag,
1559: description,
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,
1593: AND ASSIGN.assignment_type = ''A''
1594: AND target.application_id = ASSIGN.application_id';
1595: --
1596: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 39);
1597: insert into ff_routes
1598: (route_id,
1599: route_name,
1600: user_defined_flag,
1601: description,
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,
1634: AND ASSIGN.assignment_id = &B2
1635: AND target.organization_id = ASSIGN.organization_id';
1636: --
1637: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 40);
1638: insert into ff_routes
1639: (route_id,
1640: route_name,
1641: user_defined_flag,
1642: description,
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,
1677: AND replace (ltrim(rtrim(target.org_information_context)),'' '',''_'')
1678: = &U1';
1679: --
1680: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 41);
1681: insert into ff_routes
1682: (route_id,
1683: route_name,
1684: user_defined_flag,
1685: description,
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,
1716: where target.assignment_id = &B1
1717: and replace (ltrim(rtrim(target.information_type)),'' '',''_'') = &U1';
1718: --
1719: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 42);
1720: insert into ff_routes
1721: (route_id,
1722: route_name,
1723: user_defined_flag,
1724: description,
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,
1756: and target.org_payment_method_id = &B2
1757: and target.payment_type_id = &U1';
1758: --
1759: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 43);
1760: insert into ff_routes
1761: (route_id,
1762: route_name,
1763: user_defined_flag,
1764: description,
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,
1798: and PERPAY.personal_payment_method_id = &B2
1799: and target.external_account_id (+)= PERPAY.external_account_id';
1800: --
1801: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 44);
1802: insert into ff_routes
1803: (route_id,
1804: route_name,
1805: user_defined_flag,
1806: description,
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,
1839: AND ORGPAY.effective_end_date
1840: and target.external_account_id = ORGPAY.external_account_id';
1841: --
1842: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 45);
1843: insert into ff_routes
1844: (route_id,
1845: route_name,
1846: user_defined_flag,
1847: description,
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,
1878: AND replace(ltrim(rtrim(target.org_information_context)),'' '',''_'')
1879: = &U1';
1880: --
1881: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 46);
1882: insert into ff_routes
1883: (route_id,
1884: route_name,
1885: user_defined_flag,
1886: description,
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,
1931: LNKV.effective_start_date and LNKV.effective_end_date
1932: AND EE.assignment_id = &B1';
1933: --
1934: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 47);
1935: insert into ff_routes
1936: (route_id,
1937: route_name,
1938: user_defined_flag,
1939: description,
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,
1980: AND &B1 BETWEEN spp.effective_start_date
1981: AND spp.effective_end_date';
1982: --
1983: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 48);
1984: insert into ff_routes
1985: (route_id,
1986: route_name,
1987: user_defined_flag,
1988: description,
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,
2034: AND JOBDEF.job_definition_id (+)= JOB.job_definition_id
2035: AND PGROUP.people_group_id (+)= ASSIGN.people_group_id';
2036: --
2037: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 49);
2038: insert into ff_routes
2039: (route_id,
2040: route_name,
2041: user_defined_flag,
2042: description,
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,
2077: AND target.enabled_flag = ''Y''
2078: AND target.id_flex_num = &U1';
2079: --
2080: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 50);
2081: insert into ff_routes
2082: (route_id,
2083: route_name,
2084: user_defined_flag,
2085: description,
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,
2125: AND PAYROLL.effective_end_date
2126: AND target.soft_coding_keyflex_id = PAYROLL.soft_coding_keyflex_id';
2127: --
2128: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 51);
2129: insert into ff_routes
2130: (route_id,
2131: route_name,
2132: user_defined_flag,
2133: description,
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,
2171: AND ORG.organization_id = ASSIGN.organization_id
2172: AND target.soft_coding_keyflex_id = ORG.soft_coding_keyflex_id';
2173: --
2174: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 52);
2175: insert into ff_routes
2176: (route_id,
2177: route_name,
2178: user_defined_flag,
2179: description,
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,
2233: or (PEE.creator_type = ''R'' and PEE.source_id = &B1
2234: and PEE.entry_type = ''E''))';
2235: --
2236: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 53);
2237: insert into ff_routes
2238: (route_id,
2239: route_name,
2240: user_defined_flag,
2241: description,
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,