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.HR_ITEM_PROPERTIES_PKG dependencies on HR_FORM_ITEMS_B

Line 1330: from hr_form_items_b

1326:
1327: BEGIN
1328: select form_item_id
1329: into x_previous_navigation_item_id
1330: from hr_form_items_b
1331: where full_item_name = x_prev_item_name
1332: and form_id = x_form_id
1333: and application_id = x_application_id;
1334: EXCEPTION --2608813 added exception so if item is radio button we do not error

Line 1338: from hr_form_items_b

1334: EXCEPTION --2608813 added exception so if item is radio button we do not error
1335: WHEN TOO_MANY_ROWS THEN
1336: select form_item_id
1337: into x_previous_navigation_item_id
1338: from hr_form_items_b
1339: where full_item_name = x_prev_item_name
1340: and form_id = x_form_id
1341: and application_id = x_application_id
1342: and radio_button_name is not null

Line 1353: from hr_form_items_b

1349:
1350: BEGIN
1351: select form_item_id
1352: into x_next_navigation_item_id
1353: from hr_form_items_b
1354: where full_item_name = x_next_item_name
1355: and form_id = x_form_id
1356: and application_id = x_application_id;
1357: EXCEPTION --2608813 added exception so if item is radio button we do not error

Line 1361: from hr_form_items_b

1357: EXCEPTION --2608813 added exception so if item is radio button we do not error
1358: WHEN TOO_MANY_ROWS THEN
1359: select form_item_id
1360: into x_next_navigation_item_id
1361: from hr_form_items_b
1362: where full_item_name = x_next_item_name
1363: and form_id = x_form_id
1364: and application_id = x_application_id
1365: and radio_button_name is not null

Line 1412: from hr_form_items_b

1408:
1409: BEGIN
1410: select form_item_id
1411: into x_information_param_item_id1
1412: from hr_form_items_b
1413: where full_item_name = x_full_item_name_ip1
1414: and form_id = x_form_id
1415: and application_id = x_application_id;
1416: EXCEPTION --2608813 added exception so if item is radio button we do not error

Line 1420: from hr_form_items_b

1416: EXCEPTION --2608813 added exception so if item is radio button we do not error
1417: WHEN TOO_MANY_ROWS THEN
1418: select form_item_id
1419: into x_information_param_item_id1
1420: from hr_form_items_b
1421: where full_item_name = x_full_item_name_ip1
1422: and form_id = x_form_id
1423: and application_id = x_application_id
1424: and radio_button_name is not null

Line 1435: from hr_form_items_b

1431:
1432: BEGIN
1433: select form_item_id
1434: into x_information_param_item_id2
1435: from hr_form_items_b
1436: where full_item_name = x_full_item_name_ip2
1437: and form_id = x_form_id
1438: and application_id = x_application_id;
1439: EXCEPTION --2608813 added exception so if item is radio button we do not error

Line 1443: from hr_form_items_b

1439: EXCEPTION --2608813 added exception so if item is radio button we do not error
1440: WHEN TOO_MANY_ROWS THEN
1441: select form_item_id
1442: into x_information_param_item_id2
1443: from hr_form_items_b
1444: where full_item_name = x_full_item_name_ip2
1445: and form_id = x_form_id
1446: and application_id = x_application_id
1447: and radio_button_name is not null

Line 1458: from hr_form_items_b

1454:
1455: BEGIN
1456: select form_item_id
1457: into x_information_param_item_id3
1458: from hr_form_items_b
1459: where full_item_name = x_full_item_name_ip3
1460: and form_id = x_form_id
1461: and application_id = x_application_id;
1462: EXCEPTION --2608813 added exception so if item is radio button we do not error

Line 1466: from hr_form_items_b

1462: EXCEPTION --2608813 added exception so if item is radio button we do not error
1463: WHEN TOO_MANY_ROWS THEN
1464: select form_item_id
1465: into x_information_param_item_id3
1466: from hr_form_items_b
1467: where full_item_name = x_full_item_name_ip3
1468: and form_id = x_form_id
1469: and application_id = x_application_id
1470: and radio_button_name is not null

Line 1481: from hr_form_items_b

1477:
1478: BEGIN
1479: select form_item_id
1480: into x_information_param_item_id4
1481: from hr_form_items_b
1482: where full_item_name = x_full_item_name_ip4
1483: and form_id = x_form_id
1484: and application_id = x_application_id;
1485: EXCEPTION --2608813 added exception so if item is radio button we do not error

Line 1489: from hr_form_items_b

1485: EXCEPTION --2608813 added exception so if item is radio button we do not error
1486: WHEN TOO_MANY_ROWS THEN
1487: select form_item_id
1488: into x_information_param_item_id4
1489: from hr_form_items_b
1490: where full_item_name = x_full_item_name_ip4
1491: and form_id = x_form_id
1492: and application_id = x_application_id
1493: and radio_button_name is not null

Line 1504: from hr_form_items_b

1500:
1501: BEGIN
1502: select form_item_id
1503: into x_information_param_item_id5
1504: from hr_form_items_b
1505: where full_item_name = x_full_item_name_ip5
1506: and form_id = x_form_id
1507: and application_id = x_application_id;
1508: EXCEPTION --2608813 added exception so if item is radio button we do not error

Line 1512: from hr_form_items_b

1508: EXCEPTION --2608813 added exception so if item is radio button we do not error
1509: WHEN TOO_MANY_ROWS THEN
1510: select form_item_id
1511: into x_information_param_item_id5
1512: from hr_form_items_b
1513: where full_item_name = x_full_item_name_ip5
1514: and form_id = x_form_id
1515: and application_id = x_application_id
1516: and radio_button_name is not null

Line 1578: from hr_form_items_b

1574:
1575: BEGIN
1576: select form_item_id
1577: into x_validation_param_item_id1
1578: from hr_form_items_b
1579: where full_item_name = x_full_item_name_vp1
1580: and form_id = x_form_id
1581: and application_id = x_application_id;
1582: EXCEPTION

Line 1586: from hr_form_items_b

1582: EXCEPTION
1583: WHEN TOO_MANY_ROWS THEN
1584: select form_item_id
1585: into x_validation_param_item_id1
1586: from hr_form_items_b
1587: where full_item_name = x_full_item_name_vp1
1588: and form_id = x_form_id
1589: and application_id = x_application_id
1590: and radio_button_name is not null

Line 1601: from hr_form_items_b

1597:
1598: BEGIN
1599: select form_item_id
1600: into x_validation_param_item_id2
1601: from hr_form_items_b
1602: where full_item_name = x_full_item_name_vp2
1603: and form_id = x_form_id
1604: and application_id = x_application_id;
1605: EXCEPTION

Line 1609: from hr_form_items_b

1605: EXCEPTION
1606: WHEN TOO_MANY_ROWS THEN
1607: select form_item_id
1608: into x_validation_param_item_id2
1609: from hr_form_items_b
1610: where full_item_name = x_full_item_name_vp2
1611: and form_id = x_form_id
1612: and application_id = x_application_id
1613: and radio_button_name is not null

Line 1624: from hr_form_items_b

1620:
1621: BEGIN
1622: select form_item_id
1623: into x_validation_param_item_id3
1624: from hr_form_items_b
1625: where full_item_name = x_full_item_name_vp3
1626: and form_id = x_form_id
1627: and application_id = x_application_id;
1628: EXCEPTION

Line 1632: from hr_form_items_b

1628: EXCEPTION
1629: WHEN TOO_MANY_ROWS THEN
1630: select form_item_id
1631: into x_validation_param_item_id3
1632: from hr_form_items_b
1633: where full_item_name = x_full_item_name_vp3
1634: and form_id = x_form_id
1635: and application_id = x_application_id
1636: and radio_button_name is not null

Line 1647: from hr_form_items_b

1643:
1644: BEGIN
1645: select form_item_id
1646: into x_validation_param_item_id4
1647: from hr_form_items_b
1648: where full_item_name = x_full_item_name_vp4
1649: and form_id = x_form_id
1650: and application_id = x_application_id;
1651: EXCEPTION

Line 1655: from hr_form_items_b

1651: EXCEPTION
1652: WHEN TOO_MANY_ROWS THEN
1653: select form_item_id
1654: into x_validation_param_item_id4
1655: from hr_form_items_b
1656: where full_item_name = x_full_item_name_vp4
1657: and form_id = x_form_id
1658: and application_id = x_application_id
1659: and radio_button_name is not null

Line 1670: from hr_form_items_b

1666:
1667: BEGIN
1668: select form_item_id
1669: into x_validation_param_item_id5
1670: from hr_form_items_b
1671: where full_item_name = x_full_item_name_vp5
1672: and form_id = x_form_id
1673: and application_id = x_application_id;
1674: EXCEPTION

Line 1678: from hr_form_items_b

1674: EXCEPTION
1675: WHEN TOO_MANY_ROWS THEN
1676: select form_item_id
1677: into x_validation_param_item_id5
1678: from hr_form_items_b
1679: where full_item_name = x_full_item_name_vp5
1680: and form_id = x_form_id
1681: and application_id = x_application_id
1682: and radio_button_name is not null

Line 1692: from hr_form_items_b

1688: end if;
1689:
1690: select form_item_id
1691: into x_form_item_id
1692: from hr_form_items_b
1693: where full_item_name = x_full_item_name
1694: and application_id = x_application_id
1695: and form_id = x_form_id
1696: and ( radio_button_name = x_radio_button_name

Line 2176: from hr_form_items_b

2172: END IF;
2173:
2174: select form_item_id
2175: into x_form_item_id
2176: from hr_form_items_b
2177: where full_item_name = x_full_item_name
2178: and application_id = g_application_id --x_application_id
2179: and form_id = g_form_id --x_form_id
2180: and ( radio_button_name = x_radio_button_name

Line 2464: from hr_form_items_b

2460: END IF;
2461:
2462: select form_item_id
2463: into x_form_item_id
2464: from hr_form_items_b
2465: where full_item_name = x_full_item_name
2466: and application_id = g_application_id --x_application_id
2467: and form_id = g_form_id --x_form_id
2468: and ( radio_button_name = x_radio_button_name