eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DBI_STARTUP_PKG dependencies on DUAL

Line 115: from dual;

111: p_sequence_no,
112: p_parameter_name,
113: p_data_type,
114: ff_route_parameters_s.nextval
115: from dual;
116: end insert_route_parameters;
117: --
118: -- ******** local procedure : insert_route_context_usages ********
119: --

Line 134: from dual;

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;
136: --
137: BEGIN
138: --

Line 230: from dual;

226: 0,
227: 0,
228: 0,
229: sysdate
230: from dual;
231: --
232: insert_route_parameters ('Element Type ID', 'N', 1);
233: insert_route_context_usages (l_date_earned_context_id, 1);
234: --

Line 279: from dual;

275: 0,
276: 0,
277: 0,
278: sysdate
279: from dual;
280: --
281: insert_route_parameters ('Element Type ID', 'N', 1);
282: --
283: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Line 352: from dual;

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
355: --
356: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 11);

Line 455: from dual;

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
458: --
459: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 13);

Line 533: from dual;

529: 0,
530: 0,
531: 0,
532: sysdate
533: from dual;
534: --
535: insert_route_parameters ('Element Type ID', 'N', 1);
536: insert_route_context_usages (l_date_earned_context_id, 1);
537: insert_route_context_usages (l_assign_id_context_id, 2);

Line 585: from dual;

581: 0,
582: 0,
583: 0,
584: sysdate
585: from dual;
586: --
587: insert_route_parameters ('Element Type ID', 'N', 1);
588: insert_route_context_usages (l_assign_id_context_id, 1);
589: --

Line 627: from dual;

623: 0,
624: 0,
625: 0,
626: sysdate
627: from dual;
628: --
629: insert_route_parameters ('Input value ID', 'N', 1);
630: insert_route_context_usages (l_date_earned_context_id, 1);
631: --

Line 672: from dual;

668: 0,
669: 0,
670: 0,
671: sysdate
672: from dual;
673: --
674: insert_route_parameters ('Input value ID', 'N', 1);
675: --
676: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Line 734: from dual;

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
737: --
738: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 19);

Line 826: from dual;

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
829: --
830: hr_utility.set_location('pay_dbi_startup_pkg.create_dbi_startup', 21);

Line 906: from dual;

902: 0,
903: 0,
904: 0,
905: sysdate
906: from dual;
907: --
908: insert_route_parameters ('Input value ID', 'N', 1);
909: insert_route_parameters ('Element Type ID', 'N', 2);
910: insert_route_context_usages (l_date_earned_context_id, 1);

Line 973: from dual;

969: 0,
970: 0,
971: 0,
972: sysdate
973: from dual;
974: --
975: insert_route_parameters ('Input value ID', 'N', 1);
976: insert_route_context_usages (l_assign_id_context_id, 1);
977: --

Line 1018: from dual;

1014: 0,
1015: 0,
1016: 0,
1017: sysdate
1018: from dual;
1019: --
1020: insert_route_parameters ('Grade Rate ID', 'N', 1);
1021: insert_route_context_usages (l_date_earned_context_id, 1);
1022: insert_route_context_usages (l_assign_id_context_id, 2);

Line 1062: from dual;

1058: 0,
1059: 0,
1060: 0,
1061: sysdate
1062: from dual;
1063: --
1064: insert_route_context_usages (l_date_earned_context_id, 1);
1065: insert_route_context_usages (l_assign_id_context_id, 2);
1066: --

Line 1101: from dual;

1097: 0,
1098: 0,
1099: 0,
1100: sysdate
1101: from dual;
1102: --
1103: insert_route_context_usages (l_payroll_context_id, 1);
1104: insert_route_context_usages (l_date_earned_context_id, 2);
1105: --

Line 1140: from dual;

1136: 0,
1137: 0,
1138: 0,
1139: sysdate
1140: from dual;
1141: --
1142: insert_route_context_usages (l_date_earned_context_id, 1);
1143: insert_route_context_usages (l_assign_id_context_id, 2);
1144: --

Line 1181: from dual;

1177: 0,
1178: 0,
1179: 0,
1180: sysdate
1181: from dual;
1182: --
1183: insert_route_context_usages (l_date_earned_context_id, 1);
1184: insert_route_context_usages (l_assign_id_context_id, 2);
1185: --

Line 1229: from dual;

1225: 0,
1226: 0,
1227: 0,
1228: sysdate
1229: from dual;
1230: --
1231: insert_route_context_usages (l_date_earned_context_id, 1);
1232: insert_route_context_usages (l_assign_id_context_id, 2);
1233: --

Line 1279: from dual;

1275: 0,
1276: 0,
1277: 0,
1278: sysdate
1279: from dual;
1280: --
1281: insert_route_context_usages (l_date_earned_context_id, 1);
1282: insert_route_context_usages (l_assign_id_context_id, 2);
1283: --

Line 1323: from dual;

1319: 0,
1320: 0,
1321: 0,
1322: sysdate
1323: from dual;
1324: --
1325: insert_route_context_usages (l_date_earned_context_id, 1);
1326: insert_route_context_usages (l_assign_id_context_id, 2);
1327: --

Line 1367: from dual;

1363: 0,
1364: 0,
1365: 0,
1366: sysdate
1367: from dual;
1368: --
1369: insert_route_context_usages (l_date_earned_context_id, 1);
1370: insert_route_context_usages (l_assign_id_context_id, 2);
1371: --

Line 1408: from dual;

1404: 0,
1405: 0,
1406: 0,
1407: sysdate
1408: from dual;
1409: --
1410: insert_route_context_usages (l_date_earned_context_id, 1);
1411: insert_route_context_usages (l_assign_id_context_id, 2);
1412: --

Line 1451: from dual;

1447: 0,
1448: 0,
1449: 0,
1450: sysdate
1451: from dual;
1452: --
1453: insert_route_context_usages (l_date_earned_context_id, 1);
1454: insert_route_context_usages (l_assign_id_context_id, 2);
1455: --

Line 1493: from dual;

1489: 0,
1490: 0,
1491: 0,
1492: sysdate
1493: from dual;
1494: --
1495: insert_route_context_usages (l_date_earned_context_id, 1);
1496: insert_route_context_usages (l_assign_id_context_id, 2);
1497: --

Line 1535: from dual;

1531: 0,
1532: 0,
1533: 0,
1534: sysdate
1535: from dual;
1536: --
1537: insert_route_context_usages (l_date_earned_context_id, 1);
1538: insert_route_context_usages (l_assign_id_context_id, 2);
1539: --

Line 1576: from dual;

1572: 0,
1573: 0,
1574: 0,
1575: sysdate
1576: from dual;
1577: --
1578: insert_route_context_usages (l_date_earned_context_id, 1);
1579: insert_route_context_usages (l_assign_id_context_id, 2);
1580: --

Line 1618: from dual;

1614: 0,
1615: 0,
1616: 0,
1617: sysdate
1618: from dual;
1619: --
1620: insert_route_context_usages (l_date_earned_context_id, 1);
1621: insert_route_context_usages (l_assign_id_context_id, 2);
1622: --

Line 1659: from dual;

1655: 0,
1656: 0,
1657: 0,
1658: sysdate
1659: from dual;
1660: --
1661: insert_route_context_usages (l_date_earned_context_id, 1);
1662: insert_route_context_usages (l_assign_id_context_id, 2);
1663: --

Line 1702: from dual;

1698: 0,
1699: 0,
1700: 0,
1701: sysdate
1702: from dual;
1703: --
1704: insert_route_parameters ('Organization Information Context', 'T', 1);
1705: insert_route_context_usages (l_date_earned_context_id, 1);
1706: insert_route_context_usages (l_assign_id_context_id, 2);

Line 1741: from dual;

1737: 0,
1738: 0,
1739: 0,
1740: sysdate
1741: from dual;
1742: --
1743: insert_route_parameters ('Assignment Information Context', 'T', 1);
1744: insert_route_context_usages (l_assign_id_context_id, 1);
1745: --

Line 1781: from dual;

1777: 0,
1778: 0,
1779: 0,
1780: sysdate
1781: from dual;
1782: --
1783: insert_route_parameters ('Payment Type id', 'N', 1);
1784: insert_route_context_usages (l_date_earned_context_id, 1);
1785: insert_route_context_usages (l_org_pay_method_id, 2);

Line 1823: from dual;

1819: 0,
1820: 0,
1821: 0,
1822: sysdate
1823: from dual;
1824: --
1825: insert_route_context_usages (l_date_earned_context_id, 1);
1826: insert_route_context_usages (l_per_pay_method_id, 2);
1827: --

Line 1864: from dual;

1860: 0,
1861: 0,
1862: 0,
1863: sysdate
1864: from dual;
1865: --
1866: insert_route_context_usages (l_date_earned_context_id, 1);
1867: insert_route_context_usages (l_org_pay_method_id, 2);
1868: --

Line 1903: from dual;

1899: 0,
1900: 0,
1901: 0,
1902: sysdate
1903: from dual;
1904: --
1905: insert_route_parameters ('Organization Information Context', 'T', 1);
1906: insert_route_context_usages (l_tax_unit_id, 1);
1907: --

Line 1956: from dual;

1952: 0,
1953: 0,
1954: 0,
1955: sysdate
1956: from dual;
1957: --
1958: insert_route_parameters ('Absence Type ID', 'N', 1);
1959: insert_route_context_usages (l_assign_id_context_id, 1);
1960: --

Line 2005: from dual;

2001: 0,
2002: 0,
2003: 0,
2004: sysdate
2005: from dual;
2006: --
2007: insert_route_parameters ('Spine Rate ID', 'N', 1);
2008: insert_route_context_usages (l_date_earned_context_id, 1);
2009: insert_route_context_usages (l_assign_id_context_id, 2);

Line 2059: from dual;

2055: 0,
2056: 0,
2057: 0,
2058: sysdate
2059: from dual;
2060: --
2061: insert_route_context_usages (l_date_earned_context_id, 1);
2062: insert_route_context_usages (l_assign_id_context_id, 2);
2063: --

Line 2102: from dual;

2098: 0,
2099: 0,
2100: 0,
2101: sysdate
2102: from dual;
2103: --
2104: insert_route_parameters ('ID flex number', 'N', 1);
2105: insert_route_context_usages (l_date_earned_context_id, 1);
2106: insert_route_context_usages (l_assign_id_context_id, 2);

Line 2150: from dual;

2146: 0,
2147: 0,
2148: 0,
2149: sysdate
2150: from dual;
2151: --
2152: insert_route_parameters ('ID flex number', 'N', 1);
2153: insert_route_context_usages (l_date_earned_context_id, 1);
2154: insert_route_context_usages (l_assign_id_context_id, 2);

Line 2196: from dual;

2192: 0,
2193: 0,
2194: 0,
2195: sysdate
2196: from dual;
2197: --
2198: insert_route_parameters ('ID flex number', 'N', 1);
2199: insert_route_context_usages (l_date_earned_context_id, 1);
2200: insert_route_context_usages (l_assign_id_context_id, 2);

Line 2258: from dual;

2254: 0,
2255: 0,
2256: 0,
2257: sysdate
2258: from dual;
2259: --
2260: insert_route_parameters ('ID balance type', 'N', 1);
2261: insert_route_context_usages (l_assignment_action_id, 1);
2262: --

Line 2276: from dual;

2272: --
2273: hr_utility.set_location ('pay_dbi_startup_pkg.create_dbi_startup', 100);
2274: select ff_functions_s.nextval
2275: into l_function_id
2276: from dual;
2277: --
2278: hr_utility.set_location ('pay_dbi_startup_pkg.create_dbi_startup', 101);
2279: --
2280: -- insert the main formula: