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.FND_FLEX_DIAGNOSE dependencies on FND_FLEX_VALUE_SETS

Line 18: SUBTYPE vst_set_type IS fnd_flex_value_sets%ROWTYPE;

14: SUBTYPE tbl_type IS fnd_tables%ROWTYPE;
15: SUBTYPE col_type IS fnd_columns%ROWTYPE;
16: SUBTYPE rsp_type IS fnd_responsibility%ROWTYPE;
17:
18: SUBTYPE vst_set_type IS fnd_flex_value_sets%ROWTYPE;
19: SUBTYPE vst_tbl_type IS fnd_flex_validation_tables%ROWTYPE;
20: SUBTYPE vst_evt_type IS fnd_flex_validation_events%ROWTYPE;
21: SUBTYPE vst_scr_type IS fnd_flex_value_rules%ROWTYPE;
22: SUBTYPE vst_scl_type IS fnd_flex_value_rule_lines%ROWTYPE;

Line 227: FROM fnd_flex_value_sets

223: IS
224: BEGIN
225: SELECT *
226: INTO x_vst_set
227: FROM fnd_flex_value_sets
228: WHERE flex_value_set_id = p_flex_value_set_id;
229: RETURN(TRUE);
230: EXCEPTION
231: WHEN OTHERS THEN

Line 232: x_message := msg_uts('FND_FLEX_VALUE_SETS',

228: WHERE flex_value_set_id = p_flex_value_set_id;
229: RETURN(TRUE);
230: EXCEPTION
231: WHEN OTHERS THEN
232: x_message := msg_uts('FND_FLEX_VALUE_SETS',
233: 'flex_value_set_id', p_flex_value_set_id);
234: RETURN(FALSE);
235: END fetch_vst_set;
236: -- ---------------------------------------------------------------------------

Line 1126: FROM fnd_flex_value_sets

1122: format_type || '/' ||
1123: To_char(maximum_size) || '/' ||
1124: Nvl(description, '')
1125: INTO l_return
1126: FROM fnd_flex_value_sets
1127: WHERE flex_value_set_id = p_flex_value_set_id;
1128: RETURN(line_return(l_return));
1129: EXCEPTION
1130: WHEN no_data_found THEN

Line 1591: FROM fnd_flex_value_sets fvs

1587: FROM fnd_flex_validation_tables fvt
1588: WHERE flex_value_set_id = p_flex_value_set_id
1589: AND NOT EXISTS
1590: (SELECT null
1591: FROM fnd_flex_value_sets fvs
1592: WHERE fvs.flex_value_set_id = fvt.flex_value_set_id
1593: AND fvs.validation_type = 'F');
1594: x_message := SQL%rowcount || ' row(s) deleted.';
1595: GOTO return_success;

Line 1625: UPDATE fnd_flex_value_sets SET

1621: GOTO return_error;
1622: END IF;
1623:
1624: BEGIN
1625: UPDATE fnd_flex_value_sets SET
1626: validation_type = 'N',
1627: last_update_date = Sysdate,
1628: last_updated_by = 1
1629: WHERE flex_value_set_id = l_vst_set.flex_value_set_id;

Line 1634: x_message := 'Unable to update FND_FLEX_VALUE_SETS. ' || Sqlerrm;

1630: x_message := SQL%rowcount || ' row(s) updated.';
1631: GOTO return_success;
1632: EXCEPTION
1633: WHEN OTHERS THEN
1634: x_message := 'Unable to update FND_FLEX_VALUE_SETS. ' || Sqlerrm;
1635: GOTO return_error;
1636: END;
1637: END IF;
1638:

Line 1656: UPDATE fnd_flex_value_sets SET

1652: GOTO return_error;
1653: END IF;
1654:
1655: BEGIN
1656: UPDATE fnd_flex_value_sets SET
1657: validation_type = 'N',
1658: parent_flex_value_set_id = NULL,
1659: dependant_default_value = NULL,
1660: dependant_default_meaning = NULL,

Line 1668: x_message := 'Unable to update FND_FLEX_VALUE_SETS. ' || Sqlerrm;

1664: x_message := SQL%rowcount || ' row(s) updated.';
1665: GOTO return_success;
1666: EXCEPTION
1667: WHEN OTHERS THEN
1668: x_message := 'Unable to update FND_FLEX_VALUE_SETS. ' || Sqlerrm;
1669: GOTO return_error;
1670: END;
1671: END IF;
1672:

Line 1690: UPDATE fnd_flex_value_sets SET

1686: GOTO return_error;
1687: END IF;
1688:
1689: BEGIN
1690: UPDATE fnd_flex_value_sets SET
1691: validation_type = 'N',
1692: last_update_date = Sysdate,
1693: last_updated_by = 1
1694: WHERE flex_value_set_id = l_vst_set.flex_value_set_id;

Line 1699: x_message := 'Unable to update FND_FLEX_VALUE_SETS. ' || Sqlerrm;

1695: x_message := SQL%rowcount || ' row(s) updated.';
1696: GOTO return_success;
1697: EXCEPTION
1698: WHEN OTHERS THEN
1699: x_message := 'Unable to update FND_FLEX_VALUE_SETS. ' || Sqlerrm;
1700: GOTO return_error;
1701: END;
1702: END IF;
1703:

Line 1731: UPDATE fnd_flex_value_sets SET

1727: GOTO return_error;
1728: END IF;
1729:
1730: BEGIN
1731: UPDATE fnd_flex_value_sets SET
1732: validation_type = 'N',
1733: last_update_date = Sysdate,
1734: last_updated_by = 1
1735: WHERE flex_value_set_id = l_vst_set.flex_value_set_id;

Line 1740: x_message := 'Unable to update FND_FLEX_VALUE_SETS. ' || Sqlerrm;

1736: x_message := SQL%rowcount || ' row(s) updated.';
1737: GOTO return_success;
1738: EXCEPTION
1739: WHEN OTHERS THEN
1740: x_message := 'Unable to update FND_FLEX_VALUE_SETS. ' || Sqlerrm;
1741: GOTO return_error;
1742: END;
1743: END IF;
1744:

Line 1799: UPDATE fnd_flex_value_sets SET

1795: END IF;
1796: END IF;
1797:
1798: BEGIN
1799: UPDATE fnd_flex_value_sets SET
1800: validation_type = l_vst_set.validation_type,
1801: format_type = l_vst_set.format_type,
1802: protected_flag = l_vst_set.protected_flag,
1803: longlist_flag = l_vst_set.longlist_flag,

Line 1817: x_message := 'Unable to update FND_FLEX_VALUE_SETS. ' || Sqlerrm;

1813: x_message := SQL%rowcount || ' row(s) updated.';
1814: GOTO return_success;
1815: EXCEPTION
1816: WHEN OTHERS THEN
1817: x_message := 'Unable to update FND_FLEX_VALUE_SETS. ' || Sqlerrm;
1818: GOTO return_error;
1819: END;
1820: END IF;
1821:

Line 1901: FROM fnd_flex_value_sets fvs

1897: WHERE flex_value_set_id = p_flex_value_set_id
1898: AND event_code = p_event_code
1899: AND NOT EXISTS
1900: (SELECT null
1901: FROM fnd_flex_value_sets fvs
1902: WHERE fvs.flex_value_set_id = fve.flex_value_set_id
1903: AND fvs.validation_type IN ('U', 'P'));
1904: x_message := SQL%rowcount || ' row(s) deleted.';
1905: GOTO return_success;

Line 1976: FROM fnd_flex_value_sets fvs

1972: WHERE flex_value_set_id = p_flex_value_set_id
1973: AND flex_value_rule_id = p_flex_value_rule_id
1974: AND NOT EXISTS
1975: (SELECT null
1976: FROM fnd_flex_value_sets fvs
1977: WHERE fvs.flex_value_set_id = fvr.flex_value_set_id);
1978: x_message := SQL%rowcount || ' row(s) deleted.';
1979: GOTO return_success;
1980: EXCEPTION

Line 2229: FROM fnd_flex_value_sets fvs

2225: WHERE flex_value_set_id = p_flex_value_set_id
2226: AND flex_value_id = p_flex_value_id
2227: AND NOT EXISTS
2228: (SELECT null
2229: FROM fnd_flex_value_sets fvs
2230: WHERE fvs.flex_value_set_id = fv.flex_value_set_id);
2231: x_message := SQL%rowcount || ' row(s) deleted.';
2232: GOTO return_success;
2233: EXCEPTION

Line 2319: FROM fnd_flex_value_sets fvs

2315: WHERE flex_value_set_id = p_flex_value_set_id
2316: AND hierarchy_id = p_hierarchy_id
2317: AND NOT EXISTS
2318: (SELECT null
2319: FROM fnd_flex_value_sets fvs
2320: WHERE fvs.flex_value_set_id = fh.flex_value_set_id);
2321: x_message := SQL%rowcount || ' row(s) deleted.';
2322: GOTO return_success;
2323: EXCEPTION

Line 5781: FROM fnd_flex_value_sets fvs

5777: AND value_attribute_type = p_value_attribute_type
5778: AND flex_value_set_id = p_flex_value_set_id
5779: AND NOT EXISTS
5780: (SELECT null
5781: FROM fnd_flex_value_sets fvs
5782: WHERE fvs.flex_value_set_id = fvq.flex_value_set_id);
5783: x_message := SQL%rowcount || ' row(s) deleted.';
5784: GOTO return_success;
5785: EXCEPTION