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.FA_RX_SHARED_PKG dependencies on FND_VSET

Line 1254: PROCEDURE Initialize_Where(vset in out nocopy fnd_vset.valueset_r,v_flex_value in varchar2)

1250: /* -------------------------------------------------------------------------------------------*/
1251: /* StatReq - The following two functions have been added for statutory reporting requirements */
1252: /* -------------------------------------------------------------------------------------------*/
1253:
1254: PROCEDURE Initialize_Where(vset in out nocopy fnd_vset.valueset_r,v_flex_value in varchar2)
1255: is
1256:
1257: where_clause long;
1258:

Line 1368: vset fnd_vset.valueset_r;

1364: v_flex_value_set_name IN VARCHAR2,
1365: v_flex_value IN VARCHAR2)
1366: RETURN VARCHAR2 IS
1367: vsid number;
1368: vset fnd_vset.valueset_r;
1369: fmt fnd_vset.valueset_dr;
1370: found BOOLEAN;
1371: row NUMBER;
1372: value fnd_vset.value_dr;

Line 1369: fmt fnd_vset.valueset_dr;

1365: v_flex_value IN VARCHAR2)
1366: RETURN VARCHAR2 IS
1367: vsid number;
1368: vset fnd_vset.valueset_r;
1369: fmt fnd_vset.valueset_dr;
1370: found BOOLEAN;
1371: row NUMBER;
1372: value fnd_vset.value_dr;
1373: meaning varchar2(240) := '';

Line 1372: value fnd_vset.value_dr;

1368: vset fnd_vset.valueset_r;
1369: fmt fnd_vset.valueset_dr;
1370: found BOOLEAN;
1371: row NUMBER;
1372: value fnd_vset.value_dr;
1373: meaning varchar2(240) := '';
1374: vsname varchar2(150);
1375:
1376: i BINARY_INTEGER := 0;

Line 1457: fnd_vset.get_valueset(vsid, vset, fmt);

1453: g_value_set_tab(g_value_set_counter).from_counter := g_value_counter + 1;
1454: g_value_set_tab(g_value_set_counter).to_counter := g_value_counter + 1;
1455:
1456: /* Get valueset info */
1457: fnd_vset.get_valueset(vsid, vset, fmt);
1458:
1459: If nvl(vset.validation_type,'*') = 'F' and nvl(fmt.longlist_flag,'N') = 'Y' Then
1460: /* Initialize WHERE Clause for Table validated value sets */
1461: Initialize_Where(vset,v_flex_value);

Line 1467: fnd_vset.get_value_init(vset, TRUE);

1463: Initialize_Where(vset,null);
1464: End If;
1465:
1466: /* Initialize valueset variables */
1467: fnd_vset.get_value_init(vset, TRUE);
1468:
1469: /* Fetch first value of valueset */
1470: fnd_vset.get_value(vset, row, found, value);
1471:

Line 1470: fnd_vset.get_value(vset, row, found, value);

1466: /* Initialize valueset variables */
1467: fnd_vset.get_value_init(vset, TRUE);
1468:
1469: /* Fetch first value of valueset */
1470: fnd_vset.get_value(vset, row, found, value);
1471:
1472: WHILE(found) LOOP
1473: /* Increase session flex value counter by 1 */
1474:

Line 1493: fnd_vset.get_value(vset, row, found, value);

1489: end if;
1490:
1491: /* Get next flex value in set */
1492:
1493: fnd_vset.get_value(vset, row, found, value);
1494:
1495: END LOOP;
1496:
1497: fnd_vset.get_value_end(vset);

Line 1497: fnd_vset.get_value_end(vset);

1493: fnd_vset.get_value(vset, row, found, value);
1494:
1495: END LOOP;
1496:
1497: fnd_vset.get_value_end(vset);
1498:
1499: /* cache the value of this value set */
1500: flex_val_count := flex_val_count + 1;
1501: flex_val_cache(flex_val_count).flex_value_set_name := upper(vsname);

Line 1510: fnd_vset.get_value_end(vset);

1506: return(nvl(meaning, v_flex_value));
1507:
1508: EXCEPTION
1509: WHEN NO_DATA_FOUND THEN
1510: fnd_vset.get_value_end(vset);
1511: return(v_flex_value);
1512: WHEN OTHERS THEN
1513: IF (g_print_debug) THEN
1514: fa_rx_util_pkg.debug('EXCEPTION in get_flex_val_meaning');

Line 1532: vset fnd_vset.valueset_r;

1528: v_flex_value IN VARCHAR2,
1529: v_parent_flex_val IN VARCHAR2)
1530: RETURN VARCHAR2 IS
1531: vsid number;
1532: vset fnd_vset.valueset_r;
1533: fmt fnd_vset.valueset_dr;
1534: found BOOLEAN;
1535: row NUMBER;
1536: value fnd_vset.value_dr;

Line 1533: fmt fnd_vset.valueset_dr;

1529: v_parent_flex_val IN VARCHAR2)
1530: RETURN VARCHAR2 IS
1531: vsid number;
1532: vset fnd_vset.valueset_r;
1533: fmt fnd_vset.valueset_dr;
1534: found BOOLEAN;
1535: row NUMBER;
1536: value fnd_vset.value_dr;
1537: meaning varchar2(240) := '';

Line 1536: value fnd_vset.value_dr;

1532: vset fnd_vset.valueset_r;
1533: fmt fnd_vset.valueset_dr;
1534: found BOOLEAN;
1535: row NUMBER;
1536: value fnd_vset.value_dr;
1537: meaning varchar2(240) := '';
1538: vsname varchar2(150);
1539:
1540: i BINARY_INTEGER := 0;

Line 1626: fnd_vset.get_valueset(vsid, vset, fmt);

1622: g_value_set_tab(g_value_set_counter).from_counter := g_value_counter + 1;
1623: g_value_set_tab(g_value_set_counter).to_counter := g_value_counter + 1;
1624:
1625: /* Get valueset info */
1626: fnd_vset.get_valueset(vsid, vset, fmt);
1627:
1628: If nvl(vset.validation_type,'*') = 'F' and nvl(fmt.longlist_flag,'N') = 'Y' Then
1629: /* Initialize WHERE Clause for Table validated value sets */
1630: Initialize_Where(vset,v_flex_value);

Line 1636: fnd_vset.get_value_init(vset, TRUE);

1632: Initialize_Where(vset,null);
1633: End If;
1634:
1635: /* Initialize valueset variables */
1636: fnd_vset.get_value_init(vset, TRUE);
1637:
1638: /* Fetch first value of valueset */
1639: fnd_vset.get_value(vset, row, found, value);
1640:

Line 1639: fnd_vset.get_value(vset, row, found, value);

1635: /* Initialize valueset variables */
1636: fnd_vset.get_value_init(vset, TRUE);
1637:
1638: /* Fetch first value of valueset */
1639: fnd_vset.get_value(vset, row, found, value);
1640:
1641: WHILE(found) LOOP
1642: /* Increase session flex value counter by 1 */
1643:

Line 1666: fnd_vset.get_value(vset, row, found, value);

1662: then
1663: meaning := nvl(value.meaning, value.value);
1664: end if;
1665: /* Get next flex value in set */
1666: fnd_vset.get_value(vset, row, found, value);
1667:
1668: END LOOP;
1669:
1670: fnd_vset.get_value_end(vset);

Line 1670: fnd_vset.get_value_end(vset);

1666: fnd_vset.get_value(vset, row, found, value);
1667:
1668: END LOOP;
1669:
1670: fnd_vset.get_value_end(vset);
1671: /* cache the value of this value set */
1672: flex_val_count := flex_val_count + 1;
1673: flex_val_cache(flex_val_count).flex_value_set_name := upper(vsname);
1674: flex_val_cache(flex_val_count).flex_value_id := v_flex_value;

Line 1681: fnd_vset.get_value_end(vset);

1677: return(nvl(meaning, v_flex_value));
1678:
1679: EXCEPTION
1680: WHEN NO_DATA_FOUND THEN
1681: fnd_vset.get_value_end(vset);
1682: return(v_flex_value);
1683: WHEN OTHERS THEN
1684: fnd_vset.get_value_end(vset);
1685: return(v_flex_value);

Line 1684: fnd_vset.get_value_end(vset);

1680: WHEN NO_DATA_FOUND THEN
1681: fnd_vset.get_value_end(vset);
1682: return(v_flex_value);
1683: WHEN OTHERS THEN
1684: fnd_vset.get_value_end(vset);
1685: return(v_flex_value);
1686: END get_flex_val_meaning;
1687:
1688: FUNCTION get_asset_info (