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 1985: insert into ff_route_parameters

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

Line 1991: values (ff_route_parameters_s.nextval,

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

Line 2086: insert into ff_route_parameters

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

Line 2092: values (ff_route_parameters_s.nextval,

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

Line 2186: insert into ff_route_parameters

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

Line 2192: values (ff_route_parameters_s.nextval,

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

Line 2286: insert into ff_route_parameters

2282: 0,
2283: sysdate);
2284:
2285: -- define the route_parameter
2286: insert into ff_route_parameters
2287: (ROUTE_PARAMETER_ID,
2288: ROUTE_ID,
2289: DATA_TYPE,
2290: PARAMETER_NAME,

Line 2292: values (ff_route_parameters_s.nextval,

2288: ROUTE_ID,
2289: DATA_TYPE,
2290: PARAMETER_NAME,
2291: SEQUENCE_NO )
2292: values (ff_route_parameters_s.nextval,
2293: ff_routes_s.currval,
2294: 'N',
2295: 'User Entity ID',
2296: 1);

Line 2389: insert into ff_route_parameters

2385: 0,
2386: sysdate);
2387:
2388: -- define the route_parameter
2389: insert into ff_route_parameters
2390: (ROUTE_PARAMETER_ID,
2391: ROUTE_ID,
2392: DATA_TYPE,
2393: PARAMETER_NAME,

Line 2395: values (ff_route_parameters_s.nextval,

2391: ROUTE_ID,
2392: DATA_TYPE,
2393: PARAMETER_NAME,
2394: SEQUENCE_NO )
2395: values (ff_route_parameters_s.nextval,
2396: ff_routes_s.currval,
2397: 'N',
2398: 'User Entity ID',
2399: 1);

Line 2535: from ff_route_parameters

2531: end if;
2532: end if;
2533:
2534: select ROUTE_PARAMETER_ID into l_route_parameter_id
2535: from ff_route_parameters
2536: where parameter_name = 'User Entity ID'
2537: and route_id = l_route_id;
2538:
2539: insert into ff_user_entities

Line 2958: from ff_route_parameters

2954:
2955: hr_utility.trace('getting route parameter id for ' || to_char(l_route_id));
2956:
2957: select ROUTE_PARAMETER_ID into l_route_parameter_id
2958: from ff_route_parameters
2959: where parameter_name = 'User Entity ID'
2960: and route_id = l_route_id;
2961:
2962: hr_utility.trace('got route parameter id');