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.PY_W2_DBITEMS dependencies on FF_ROUTE_PARAMETERS

Line 493: hr_utility.trace('inserting ff_route_parameters for EMPLOYER_ARCHIVE');

489: 0,
490: sysdate);
491:
492: -- define the route_parameter
493: hr_utility.trace('inserting ff_route_parameters for EMPLOYER_ARCHIVE');
494:
495: insert into ff_route_parameters
496: (ROUTE_PARAMETER_ID,
497: ROUTE_ID,

Line 495: insert into ff_route_parameters

491:
492: -- define the route_parameter
493: hr_utility.trace('inserting ff_route_parameters for EMPLOYER_ARCHIVE');
494:
495: insert into ff_route_parameters
496: (ROUTE_PARAMETER_ID,
497: ROUTE_ID,
498: DATA_TYPE,
499: PARAMETER_NAME,

Line 501: select ff_route_parameters_s.nextval,

497: ROUTE_ID,
498: DATA_TYPE,
499: PARAMETER_NAME,
500: SEQUENCE_NO )
501: select ff_route_parameters_s.nextval,
502: ff_routes_s.currval,
503: 'N',
504: 'User Entity ID',
505: 1 from dual;

Line 608: insert into ff_route_parameters

604: sysdate);
605:
606:
607: -- define the route_parameter
608: insert into ff_route_parameters
609: (ROUTE_PARAMETER_ID,
610: ROUTE_ID,
611: DATA_TYPE,
612: PARAMETER_NAME,

Line 614: select ff_route_parameters_s.nextval,

610: ROUTE_ID,
611: DATA_TYPE,
612: PARAMETER_NAME,
613: SEQUENCE_NO )
614: select ff_route_parameters_s.nextval,
615: ff_routes_s.currval,
616: 'N',
617: 'User Entity ID',
618: 1 from dual;

Line 719: insert into ff_route_parameters

715: sysdate);
716:
717:
718: -- define the route_parameter
719: insert into ff_route_parameters
720: (ROUTE_PARAMETER_ID,
721: ROUTE_ID,
722: DATA_TYPE,
723: PARAMETER_NAME,

Line 725: select ff_route_parameters_s.nextval,

721: ROUTE_ID,
722: DATA_TYPE,
723: PARAMETER_NAME,
724: SEQUENCE_NO )
725: select ff_route_parameters_s.nextval,
726: ff_routes_s.currval,
727: 'N',
728: 'User Entity ID',
729: 1 from dual;

Line 841: insert into ff_route_parameters

837: 0,
838: sysdate);
839:
840: -- define the route_parameter
841: insert into ff_route_parameters
842: (ROUTE_PARAMETER_ID,
843: ROUTE_ID,
844: DATA_TYPE,
845: PARAMETER_NAME,

Line 847: select ff_route_parameters_s.nextval,

843: ROUTE_ID,
844: DATA_TYPE,
845: PARAMETER_NAME,
846: SEQUENCE_NO )
847: select ff_route_parameters_s.nextval,
848: ff_routes_s.currval,
849: 'N',
850: 'User Entity ID',
851: 1 from dual;

Line 973: insert into ff_route_parameters

969: 0,
970: sysdate);
971:
972: -- define the route_parameter
973: insert into ff_route_parameters
974: (ROUTE_PARAMETER_ID,
975: ROUTE_ID,
976: DATA_TYPE,
977: PARAMETER_NAME,

Line 979: select ff_route_parameters_s.nextval,

975: ROUTE_ID,
976: DATA_TYPE,
977: PARAMETER_NAME,
978: SEQUENCE_NO )
979: select ff_route_parameters_s.nextval,
980: ff_routes_s.currval,
981: 'N',
982: 'User Entity ID',
983: 1 from dual;

Line 1100: insert into ff_route_parameters

1096: 0,
1097: sysdate);
1098:
1099: -- define the route_parameter
1100: insert into ff_route_parameters
1101: (ROUTE_PARAMETER_ID,
1102: ROUTE_ID,
1103: DATA_TYPE,
1104: PARAMETER_NAME,

Line 1106: select ff_route_parameters_s.nextval,

1102: ROUTE_ID,
1103: DATA_TYPE,
1104: PARAMETER_NAME,
1105: SEQUENCE_NO )
1106: select ff_route_parameters_s.nextval,
1107: ff_routes_s.currval,
1108: 'N',
1109: 'User Entity ID',
1110: 1 from dual;

Line 1232: insert into ff_route_parameters

1228: 0,
1229: sysdate);
1230:
1231: -- define the route_parameter
1232: insert into ff_route_parameters
1233: (ROUTE_PARAMETER_ID,
1234: ROUTE_ID,
1235: DATA_TYPE,
1236: PARAMETER_NAME,

Line 1238: select ff_route_parameters_s.nextval,

1234: ROUTE_ID,
1235: DATA_TYPE,
1236: PARAMETER_NAME,
1237: SEQUENCE_NO )
1238: select ff_route_parameters_s.nextval,
1239: ff_routes_s.currval,
1240: 'N',
1241: 'User Entity ID',
1242: 1 from dual;

Line 1372: insert into ff_route_parameters

1368: 0,
1369: sysdate);
1370:
1371: -- define the route_parameter
1372: insert into ff_route_parameters
1373: (ROUTE_PARAMETER_ID,
1374: ROUTE_ID,
1375: DATA_TYPE,
1376: PARAMETER_NAME,

Line 1378: select ff_route_parameters_s.nextval,

1374: ROUTE_ID,
1375: DATA_TYPE,
1376: PARAMETER_NAME,
1377: SEQUENCE_NO )
1378: select ff_route_parameters_s.nextval,
1379: ff_routes_s.currval,
1380: 'N',
1381: 'User Entity ID',
1382: 1 from dual;

Line 1512: insert into ff_route_parameters

1508: 0,
1509: sysdate);
1510:
1511: -- define the route_parameter
1512: insert into ff_route_parameters
1513: (ROUTE_PARAMETER_ID,
1514: ROUTE_ID,
1515: DATA_TYPE,
1516: PARAMETER_NAME,

Line 1518: select ff_route_parameters_s.nextval,

1514: ROUTE_ID,
1515: DATA_TYPE,
1516: PARAMETER_NAME,
1517: SEQUENCE_NO )
1518: select ff_route_parameters_s.nextval,
1519: ff_routes_s.currval,
1520: 'N',
1521: 'User Entity ID',
1522: 1 from dual;

Line 1596: insert into ff_route_parameters

1592: 0,
1593: sysdate);
1594:
1595: -- define the route_parameter
1596: insert into ff_route_parameters
1597: (ROUTE_PARAMETER_ID,
1598: ROUTE_ID,
1599: DATA_TYPE,
1600: PARAMETER_NAME,

Line 1602: select ff_route_parameters_s.nextval,

1598: ROUTE_ID,
1599: DATA_TYPE,
1600: PARAMETER_NAME,
1601: SEQUENCE_NO )
1602: select ff_route_parameters_s.nextval,
1603: ff_routes_s.currval,
1604: 'N',
1605: 'User Entity ID',
1606: 1 from dual;

Line 1663: insert into ff_route_parameters

1659: 0,
1660: sysdate);
1661:
1662: -- define the route_parameter
1663: insert into ff_route_parameters
1664: (ROUTE_PARAMETER_ID,
1665: ROUTE_ID,
1666: DATA_TYPE,
1667: PARAMETER_NAME,

Line 1669: select ff_route_parameters_s.nextval,

1665: ROUTE_ID,
1666: DATA_TYPE,
1667: PARAMETER_NAME,
1668: SEQUENCE_NO )
1669: select ff_route_parameters_s.nextval,
1670: ff_routes_s.currval,
1671: 'N',
1672: 'User Entity ID',
1673: 1 from dual;

Line 1729: insert into ff_route_parameters

1725: 0,
1726: sysdate);
1727:
1728: -- define the route_parameter
1729: insert into ff_route_parameters
1730: (ROUTE_PARAMETER_ID,
1731: ROUTE_ID,
1732: DATA_TYPE,
1733: PARAMETER_NAME,

Line 1735: select ff_route_parameters_s.nextval,

1731: ROUTE_ID,
1732: DATA_TYPE,
1733: PARAMETER_NAME,
1734: SEQUENCE_NO )
1735: select ff_route_parameters_s.nextval,
1736: ff_routes_s.currval,
1737: 'N',
1738: 'User Entity ID',
1739: 1 from dual;

Line 1806: insert into ff_route_parameters

1802: 0,
1803: sysdate);
1804:
1805: -- define the route_parameter
1806: insert into ff_route_parameters
1807: (ROUTE_PARAMETER_ID,
1808: ROUTE_ID,
1809: DATA_TYPE,
1810: PARAMETER_NAME,

Line 1812: values (ff_route_parameters_s.nextval,

1808: ROUTE_ID,
1809: DATA_TYPE,
1810: PARAMETER_NAME,
1811: SEQUENCE_NO )
1812: values (ff_route_parameters_s.nextval,
1813: ff_routes_s.currval,
1814: 'N',
1815: 'User Entity ID',
1816: 1);

Line 1892: insert into ff_route_parameters

1888: 0,
1889: sysdate);
1890:
1891: -- define the route_parameter
1892: insert into ff_route_parameters
1893: (ROUTE_PARAMETER_ID,
1894: ROUTE_ID,
1895: DATA_TYPE,
1896: PARAMETER_NAME,

Line 1898: values (ff_route_parameters_s.nextval,

1894: ROUTE_ID,
1895: DATA_TYPE,
1896: PARAMETER_NAME,
1897: SEQUENCE_NO )
1898: values (ff_route_parameters_s.nextval,
1899: ff_routes_s.currval,
1900: 'N',
1901: 'User Entity ID',
1902: 1);

Line 1984: insert into ff_route_parameters

1980: 0,
1981: sysdate);
1982:
1983: -- define the route_parameter
1984: insert into ff_route_parameters
1985: (ROUTE_PARAMETER_ID,
1986: ROUTE_ID,
1987: DATA_TYPE,
1988: PARAMETER_NAME,

Line 1990: values (ff_route_parameters_s.nextval,

1986: ROUTE_ID,
1987: DATA_TYPE,
1988: PARAMETER_NAME,
1989: SEQUENCE_NO )
1990: values (ff_route_parameters_s.nextval,
1991: ff_routes_s.currval,
1992: 'N',
1993: 'User Entity ID',
1994: 1);

Line 2084: insert into ff_route_parameters

2080: 0,
2081: sysdate);
2082:
2083: -- define the route_parameter
2084: insert into ff_route_parameters
2085: (ROUTE_PARAMETER_ID,
2086: ROUTE_ID,
2087: DATA_TYPE,
2088: PARAMETER_NAME,

Line 2090: values (ff_route_parameters_s.nextval,

2086: ROUTE_ID,
2087: DATA_TYPE,
2088: PARAMETER_NAME,
2089: SEQUENCE_NO )
2090: values (ff_route_parameters_s.nextval,
2091: ff_routes_s.currval,
2092: 'N',
2093: 'User Entity ID',
2094: 1);

Line 2183: insert into ff_route_parameters

2179: 0,
2180: sysdate);
2181:
2182: -- define the route_parameter
2183: insert into ff_route_parameters
2184: (ROUTE_PARAMETER_ID,
2185: ROUTE_ID,
2186: DATA_TYPE,
2187: PARAMETER_NAME,

Line 2189: values (ff_route_parameters_s.nextval,

2185: ROUTE_ID,
2186: DATA_TYPE,
2187: PARAMETER_NAME,
2188: SEQUENCE_NO )
2189: values (ff_route_parameters_s.nextval,
2190: ff_routes_s.currval,
2191: 'N',
2192: 'User Entity ID',
2193: 1);

Line 2282: insert into ff_route_parameters

2278: 0,
2279: sysdate);
2280:
2281: -- define the route_parameter
2282: insert into ff_route_parameters
2283: (ROUTE_PARAMETER_ID,
2284: ROUTE_ID,
2285: DATA_TYPE,
2286: PARAMETER_NAME,

Line 2288: values (ff_route_parameters_s.nextval,

2284: ROUTE_ID,
2285: DATA_TYPE,
2286: PARAMETER_NAME,
2287: SEQUENCE_NO )
2288: values (ff_route_parameters_s.nextval,
2289: ff_routes_s.currval,
2290: 'N',
2291: 'User Entity ID',
2292: 1);

Line 2426: from ff_route_parameters

2422: end if;
2423: end if;
2424:
2425: select ROUTE_PARAMETER_ID into l_route_parameter_id
2426: from ff_route_parameters
2427: where parameter_name = 'User Entity ID'
2428: and route_id = l_route_id;
2429:
2430: insert into ff_user_entities

Line 2839: from ff_route_parameters

2835:
2836: hr_utility.trace('getting route parameter id for ' || to_char(l_route_id));
2837:
2838: select ROUTE_PARAMETER_ID into l_route_parameter_id
2839: from ff_route_parameters
2840: where parameter_name = 'User Entity ID'
2841: and route_id = l_route_id;
2842:
2843: hr_utility.trace('got route parameter id');