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 335: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

331: BEGIN
332: PER_RIC_PKG.chk_integrity (
333: p_entity_name => 'HR_ITEM_PROPERTIES_B',
334: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
335: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
336: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL))),
337: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID1,NULL))),
339: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 337: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

333: p_entity_name => 'HR_ITEM_PROPERTIES_B',
334: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
335: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
336: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL))),
337: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID1,NULL))),
339: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID2,NULL))),
341: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 339: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

335: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
336: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL))),
337: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID1,NULL))),
339: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID2,NULL))),
341: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID3,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 341: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

337: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID1,NULL))),
339: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID2,NULL))),
341: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID3,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID4,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 343: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

339: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
340: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID2,NULL))),
341: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID3,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID4,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID5,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 345: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

341: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID3,NULL))),
343: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID4,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID5,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_NEXT_NAVIGATION_ITEM_ID,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 347: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

343: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
344: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID4,NULL))),
345: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID5,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_NEXT_NAVIGATION_ITEM_ID,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_PREVIOUS_NAVIGATION_ITEM_ID,NULL))),
351: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 349: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

345: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_VALIDATION_PARAM_ITEM_ID5,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_NEXT_NAVIGATION_ITEM_ID,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_PREVIOUS_NAVIGATION_ITEM_ID,NULL))),
351: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
352: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID1,NULL))),
353: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 351: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

347: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_NEXT_NAVIGATION_ITEM_ID,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_PREVIOUS_NAVIGATION_ITEM_ID,NULL))),
351: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
352: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID1,NULL))),
353: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
354: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID2,NULL))),
355: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 353: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

349: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_PREVIOUS_NAVIGATION_ITEM_ID,NULL))),
351: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
352: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID1,NULL))),
353: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
354: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID2,NULL))),
355: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
356: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID3,NULL))),
357: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 355: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

351: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
352: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID1,NULL))),
353: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
354: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID2,NULL))),
355: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
356: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID3,NULL))),
357: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
358: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID4,NULL))),
359: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 357: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

353: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
354: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID2,NULL))),
355: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
356: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID3,NULL))),
357: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
358: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID4,NULL))),
359: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
360: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID5,NULL))),
361: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(

Line 359: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(

355: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
356: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID3,NULL))),
357: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
358: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID4,NULL))),
359: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
360: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_INFORMATION_PARAM_ITEM_ID5,NULL))),
361: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
362: PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,X_TEMPLATE_ITEM_ID,NULL))),
363: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B', PER_RIC_PKG.column_info_tbl(

Line 1416: from hr_form_items_b

1412:
1413: BEGIN
1414: select form_item_id
1415: into x_previous_navigation_item_id
1416: from hr_form_items_b
1417: where full_item_name = x_prev_item_name
1418: and form_id = x_form_id
1419: and application_id = x_application_id;
1420: EXCEPTION --2608813 added exception so if item is radio button we do not error

Line 1424: from hr_form_items_b

1420: EXCEPTION --2608813 added exception so if item is radio button we do not error
1421: WHEN TOO_MANY_ROWS THEN
1422: select form_item_id
1423: into x_previous_navigation_item_id
1424: from hr_form_items_b
1425: where full_item_name = x_prev_item_name
1426: and form_id = x_form_id
1427: and application_id = x_application_id
1428: and radio_button_name is not null

Line 1439: from hr_form_items_b

1435:
1436: BEGIN
1437: select form_item_id
1438: into x_next_navigation_item_id
1439: from hr_form_items_b
1440: where full_item_name = x_next_item_name
1441: and form_id = x_form_id
1442: and application_id = x_application_id;
1443: EXCEPTION --2608813 added exception so if item is radio button we do not error

Line 1447: from hr_form_items_b

1443: EXCEPTION --2608813 added exception so if item is radio button we do not error
1444: WHEN TOO_MANY_ROWS THEN
1445: select form_item_id
1446: into x_next_navigation_item_id
1447: from hr_form_items_b
1448: where full_item_name = x_next_item_name
1449: and form_id = x_form_id
1450: and application_id = x_application_id
1451: and radio_button_name is not null

Line 1498: from hr_form_items_b

1494:
1495: BEGIN
1496: select form_item_id
1497: into x_information_param_item_id1
1498: from hr_form_items_b
1499: where full_item_name = x_full_item_name_ip1
1500: and form_id = x_form_id
1501: and application_id = x_application_id;
1502: EXCEPTION --2608813 added exception so if item is radio button we do not error

Line 1506: from hr_form_items_b

1502: EXCEPTION --2608813 added exception so if item is radio button we do not error
1503: WHEN TOO_MANY_ROWS THEN
1504: select form_item_id
1505: into x_information_param_item_id1
1506: from hr_form_items_b
1507: where full_item_name = x_full_item_name_ip1
1508: and form_id = x_form_id
1509: and application_id = x_application_id
1510: and radio_button_name is not null

Line 1521: from hr_form_items_b

1517:
1518: BEGIN
1519: select form_item_id
1520: into x_information_param_item_id2
1521: from hr_form_items_b
1522: where full_item_name = x_full_item_name_ip2
1523: and form_id = x_form_id
1524: and application_id = x_application_id;
1525: EXCEPTION --2608813 added exception so if item is radio button we do not error

Line 1529: from hr_form_items_b

1525: EXCEPTION --2608813 added exception so if item is radio button we do not error
1526: WHEN TOO_MANY_ROWS THEN
1527: select form_item_id
1528: into x_information_param_item_id2
1529: from hr_form_items_b
1530: where full_item_name = x_full_item_name_ip2
1531: and form_id = x_form_id
1532: and application_id = x_application_id
1533: and radio_button_name is not null

Line 1544: from hr_form_items_b

1540:
1541: BEGIN
1542: select form_item_id
1543: into x_information_param_item_id3
1544: from hr_form_items_b
1545: where full_item_name = x_full_item_name_ip3
1546: and form_id = x_form_id
1547: and application_id = x_application_id;
1548: EXCEPTION --2608813 added exception so if item is radio button we do not error

Line 1552: from hr_form_items_b

1548: EXCEPTION --2608813 added exception so if item is radio button we do not error
1549: WHEN TOO_MANY_ROWS THEN
1550: select form_item_id
1551: into x_information_param_item_id3
1552: from hr_form_items_b
1553: where full_item_name = x_full_item_name_ip3
1554: and form_id = x_form_id
1555: and application_id = x_application_id
1556: and radio_button_name is not null

Line 1567: from hr_form_items_b

1563:
1564: BEGIN
1565: select form_item_id
1566: into x_information_param_item_id4
1567: from hr_form_items_b
1568: where full_item_name = x_full_item_name_ip4
1569: and form_id = x_form_id
1570: and application_id = x_application_id;
1571: EXCEPTION --2608813 added exception so if item is radio button we do not error

Line 1575: from hr_form_items_b

1571: EXCEPTION --2608813 added exception so if item is radio button we do not error
1572: WHEN TOO_MANY_ROWS THEN
1573: select form_item_id
1574: into x_information_param_item_id4
1575: from hr_form_items_b
1576: where full_item_name = x_full_item_name_ip4
1577: and form_id = x_form_id
1578: and application_id = x_application_id
1579: and radio_button_name is not null

Line 1590: from hr_form_items_b

1586:
1587: BEGIN
1588: select form_item_id
1589: into x_information_param_item_id5
1590: from hr_form_items_b
1591: where full_item_name = x_full_item_name_ip5
1592: and form_id = x_form_id
1593: and application_id = x_application_id;
1594: EXCEPTION --2608813 added exception so if item is radio button we do not error

Line 1598: from hr_form_items_b

1594: EXCEPTION --2608813 added exception so if item is radio button we do not error
1595: WHEN TOO_MANY_ROWS THEN
1596: select form_item_id
1597: into x_information_param_item_id5
1598: from hr_form_items_b
1599: where full_item_name = x_full_item_name_ip5
1600: and form_id = x_form_id
1601: and application_id = x_application_id
1602: and radio_button_name is not null

Line 1664: from hr_form_items_b

1660:
1661: BEGIN
1662: select form_item_id
1663: into x_validation_param_item_id1
1664: from hr_form_items_b
1665: where full_item_name = x_full_item_name_vp1
1666: and form_id = x_form_id
1667: and application_id = x_application_id;
1668: EXCEPTION

Line 1672: from hr_form_items_b

1668: EXCEPTION
1669: WHEN TOO_MANY_ROWS THEN
1670: select form_item_id
1671: into x_validation_param_item_id1
1672: from hr_form_items_b
1673: where full_item_name = x_full_item_name_vp1
1674: and form_id = x_form_id
1675: and application_id = x_application_id
1676: and radio_button_name is not null

Line 1687: from hr_form_items_b

1683:
1684: BEGIN
1685: select form_item_id
1686: into x_validation_param_item_id2
1687: from hr_form_items_b
1688: where full_item_name = x_full_item_name_vp2
1689: and form_id = x_form_id
1690: and application_id = x_application_id;
1691: EXCEPTION

Line 1695: from hr_form_items_b

1691: EXCEPTION
1692: WHEN TOO_MANY_ROWS THEN
1693: select form_item_id
1694: into x_validation_param_item_id2
1695: from hr_form_items_b
1696: where full_item_name = x_full_item_name_vp2
1697: and form_id = x_form_id
1698: and application_id = x_application_id
1699: and radio_button_name is not null

Line 1710: from hr_form_items_b

1706:
1707: BEGIN
1708: select form_item_id
1709: into x_validation_param_item_id3
1710: from hr_form_items_b
1711: where full_item_name = x_full_item_name_vp3
1712: and form_id = x_form_id
1713: and application_id = x_application_id;
1714: EXCEPTION

Line 1718: from hr_form_items_b

1714: EXCEPTION
1715: WHEN TOO_MANY_ROWS THEN
1716: select form_item_id
1717: into x_validation_param_item_id3
1718: from hr_form_items_b
1719: where full_item_name = x_full_item_name_vp3
1720: and form_id = x_form_id
1721: and application_id = x_application_id
1722: and radio_button_name is not null

Line 1733: from hr_form_items_b

1729:
1730: BEGIN
1731: select form_item_id
1732: into x_validation_param_item_id4
1733: from hr_form_items_b
1734: where full_item_name = x_full_item_name_vp4
1735: and form_id = x_form_id
1736: and application_id = x_application_id;
1737: EXCEPTION

Line 1741: from hr_form_items_b

1737: EXCEPTION
1738: WHEN TOO_MANY_ROWS THEN
1739: select form_item_id
1740: into x_validation_param_item_id4
1741: from hr_form_items_b
1742: where full_item_name = x_full_item_name_vp4
1743: and form_id = x_form_id
1744: and application_id = x_application_id
1745: and radio_button_name is not null

Line 1756: from hr_form_items_b

1752:
1753: BEGIN
1754: select form_item_id
1755: into x_validation_param_item_id5
1756: from hr_form_items_b
1757: where full_item_name = x_full_item_name_vp5
1758: and form_id = x_form_id
1759: and application_id = x_application_id;
1760: EXCEPTION

Line 1764: from hr_form_items_b

1760: EXCEPTION
1761: WHEN TOO_MANY_ROWS THEN
1762: select form_item_id
1763: into x_validation_param_item_id5
1764: from hr_form_items_b
1765: where full_item_name = x_full_item_name_vp5
1766: and form_id = x_form_id
1767: and application_id = x_application_id
1768: and radio_button_name is not null

Line 1778: from hr_form_items_b

1774: end if;
1775:
1776: select form_item_id
1777: into x_form_item_id
1778: from hr_form_items_b
1779: where full_item_name = x_full_item_name
1780: and application_id = x_application_id
1781: and form_id = x_form_id
1782: and ( radio_button_name = x_radio_button_name

Line 2262: from hr_form_items_b

2258: END IF;
2259:
2260: select form_item_id
2261: into x_form_item_id
2262: from hr_form_items_b
2263: where full_item_name = x_full_item_name
2264: and application_id = g_application_id --x_application_id
2265: and form_id = g_form_id --x_form_id
2266: and ( radio_button_name = x_radio_button_name

Line 2550: from hr_form_items_b

2546: END IF;
2547:
2548: select form_item_id
2549: into x_form_item_id
2550: from hr_form_items_b
2551: where full_item_name = x_full_item_name
2552: and application_id = g_application_id --x_application_id
2553: and form_id = g_form_id --x_form_id
2554: and ( radio_button_name = x_radio_button_name