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 1102: PROCEDURE Initialize_Where(vset in out nocopy fnd_vset.valueset_r,v_flex_value in varchar2)

1098: /* -------------------------------------------------------------------------------------------*/
1099: /* StatReq - The following two functions have been added for statutory reporting requirements */
1100: /* -------------------------------------------------------------------------------------------*/
1101:
1102: PROCEDURE Initialize_Where(vset in out nocopy fnd_vset.valueset_r,v_flex_value in varchar2)
1103: is
1104:
1105: where_clause long;
1106:

Line 1216: vset fnd_vset.valueset_r;

1212: v_flex_value_set_name IN VARCHAR2,
1213: v_flex_value IN VARCHAR2)
1214: RETURN VARCHAR2 IS
1215: vsid number;
1216: vset fnd_vset.valueset_r;
1217: fmt fnd_vset.valueset_dr;
1218: found BOOLEAN;
1219: row NUMBER;
1220: value fnd_vset.value_dr;

Line 1217: fmt fnd_vset.valueset_dr;

1213: v_flex_value IN VARCHAR2)
1214: RETURN VARCHAR2 IS
1215: vsid number;
1216: vset fnd_vset.valueset_r;
1217: fmt fnd_vset.valueset_dr;
1218: found BOOLEAN;
1219: row NUMBER;
1220: value fnd_vset.value_dr;
1221: meaning varchar2(240) := '';

Line 1220: value fnd_vset.value_dr;

1216: vset fnd_vset.valueset_r;
1217: fmt fnd_vset.valueset_dr;
1218: found BOOLEAN;
1219: row NUMBER;
1220: value fnd_vset.value_dr;
1221: meaning varchar2(240) := '';
1222: vsname varchar2(150);
1223:
1224: i BINARY_INTEGER := 0;

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

1301: g_value_set_tab(g_value_set_counter).from_counter := g_value_counter + 1;
1302: g_value_set_tab(g_value_set_counter).to_counter := g_value_counter + 1;
1303:
1304: /* Get valueset info */
1305: fnd_vset.get_valueset(vsid, vset, fmt);
1306:
1307: If nvl(vset.validation_type,'*') = 'F' and nvl(fmt.longlist_flag,'N') = 'Y' Then
1308: /* Initialize WHERE Clause for Table validated value sets */
1309: Initialize_Where(vset,v_flex_value);

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

1311: Initialize_Where(vset,null);
1312: End If;
1313:
1314: /* Initialize valueset variables */
1315: fnd_vset.get_value_init(vset, TRUE);
1316:
1317: /* Fetch first value of valueset */
1318: fnd_vset.get_value(vset, row, found, value);
1319:

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

1314: /* Initialize valueset variables */
1315: fnd_vset.get_value_init(vset, TRUE);
1316:
1317: /* Fetch first value of valueset */
1318: fnd_vset.get_value(vset, row, found, value);
1319:
1320: WHILE(found) LOOP
1321: /* Increase session flex value counter by 1 */
1322:

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

1337: end if;
1338:
1339: /* Get next flex value in set */
1340:
1341: fnd_vset.get_value(vset, row, found, value);
1342:
1343: END LOOP;
1344:
1345: fnd_vset.get_value_end(vset);

Line 1345: fnd_vset.get_value_end(vset);

1341: fnd_vset.get_value(vset, row, found, value);
1342:
1343: END LOOP;
1344:
1345: fnd_vset.get_value_end(vset);
1346:
1347: /* cache the value of this value set */
1348: flex_val_count := flex_val_count + 1;
1349: flex_val_cache(flex_val_count).flex_value_set_name := upper(vsname);

Line 1358: fnd_vset.get_value_end(vset);

1354: return(nvl(meaning, v_flex_value));
1355:
1356: EXCEPTION
1357: WHEN NO_DATA_FOUND THEN
1358: fnd_vset.get_value_end(vset);
1359: return(v_flex_value);
1360: WHEN OTHERS THEN
1361: IF (g_print_debug) THEN
1362: fa_rx_util_pkg.debug('EXCEPTION in get_flex_val_meaning');

Line 1380: vset fnd_vset.valueset_r;

1376: v_flex_value IN VARCHAR2,
1377: v_parent_flex_val IN VARCHAR2)
1378: RETURN VARCHAR2 IS
1379: vsid number;
1380: vset fnd_vset.valueset_r;
1381: fmt fnd_vset.valueset_dr;
1382: found BOOLEAN;
1383: row NUMBER;
1384: value fnd_vset.value_dr;

Line 1381: fmt fnd_vset.valueset_dr;

1377: v_parent_flex_val IN VARCHAR2)
1378: RETURN VARCHAR2 IS
1379: vsid number;
1380: vset fnd_vset.valueset_r;
1381: fmt fnd_vset.valueset_dr;
1382: found BOOLEAN;
1383: row NUMBER;
1384: value fnd_vset.value_dr;
1385: meaning varchar2(240) := '';

Line 1384: value fnd_vset.value_dr;

1380: vset fnd_vset.valueset_r;
1381: fmt fnd_vset.valueset_dr;
1382: found BOOLEAN;
1383: row NUMBER;
1384: value fnd_vset.value_dr;
1385: meaning varchar2(240) := '';
1386: vsname varchar2(150);
1387:
1388: i BINARY_INTEGER := 0;

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

1470: g_value_set_tab(g_value_set_counter).from_counter := g_value_counter + 1;
1471: g_value_set_tab(g_value_set_counter).to_counter := g_value_counter + 1;
1472:
1473: /* Get valueset info */
1474: fnd_vset.get_valueset(vsid, vset, fmt);
1475:
1476: If nvl(vset.validation_type,'*') = 'F' and nvl(fmt.longlist_flag,'N') = 'Y' Then
1477: /* Initialize WHERE Clause for Table validated value sets */
1478: Initialize_Where(vset,v_flex_value);

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

1480: Initialize_Where(vset,null);
1481: End If;
1482:
1483: /* Initialize valueset variables */
1484: fnd_vset.get_value_init(vset, TRUE);
1485:
1486: /* Fetch first value of valueset */
1487: fnd_vset.get_value(vset, row, found, value);
1488:

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

1483: /* Initialize valueset variables */
1484: fnd_vset.get_value_init(vset, TRUE);
1485:
1486: /* Fetch first value of valueset */
1487: fnd_vset.get_value(vset, row, found, value);
1488:
1489: WHILE(found) LOOP
1490: /* Increase session flex value counter by 1 */
1491:

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

1510: then
1511: meaning := nvl(value.meaning, value.value);
1512: end if;
1513: /* Get next flex value in set */
1514: fnd_vset.get_value(vset, row, found, value);
1515:
1516: END LOOP;
1517:
1518: fnd_vset.get_value_end(vset);

Line 1518: fnd_vset.get_value_end(vset);

1514: fnd_vset.get_value(vset, row, found, value);
1515:
1516: END LOOP;
1517:
1518: fnd_vset.get_value_end(vset);
1519: /* cache the value of this value set */
1520: flex_val_count := flex_val_count + 1;
1521: flex_val_cache(flex_val_count).flex_value_set_name := upper(vsname);
1522: flex_val_cache(flex_val_count).flex_value_id := v_flex_value;

Line 1529: fnd_vset.get_value_end(vset);

1525: return(nvl(meaning, v_flex_value));
1526:
1527: EXCEPTION
1528: WHEN NO_DATA_FOUND THEN
1529: fnd_vset.get_value_end(vset);
1530: return(v_flex_value);
1531: WHEN OTHERS THEN
1532: fnd_vset.get_value_end(vset);
1533: return(v_flex_value);

Line 1532: fnd_vset.get_value_end(vset);

1528: WHEN NO_DATA_FOUND THEN
1529: fnd_vset.get_value_end(vset);
1530: return(v_flex_value);
1531: WHEN OTHERS THEN
1532: fnd_vset.get_value_end(vset);
1533: return(v_flex_value);
1534: END get_flex_val_meaning;
1535:
1536: FUNCTION get_asset_info (