APPS.FND_FLEX_DIAGNOSE dependencies on FND_FLEX_VALIDATION_TABLES

Line 19: SUBTYPE vst_tbl_type IS fnd_flex_validation_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;
23: SUBTYPE vst_scu_type IS fnd_flex_value_rule_usages%ROWTYPE;

Line 245: FROM fnd_flex_validation_tables

241: IS
242: BEGIN
243: SELECT *
244: INTO x_vst_tbl
245: FROM fnd_flex_validation_tables
246: WHERE flex_value_set_id = p_vst_set.flex_value_set_id;
247: RETURN(TRUE);
248: EXCEPTION
249: WHEN OTHERS THEN

Line 250: x_message := msg_uts('FND_FLEX_VALIDATION_TABLES',

246: WHERE flex_value_set_id = p_vst_set.flex_value_set_id;
247: RETURN(TRUE);
248: EXCEPTION
249: WHEN OTHERS THEN
250: x_message := msg_uts('FND_FLEX_VALIDATION_TABLES',
251: 'flex_value_set_id', p_vst_set.flex_value_set_id);
252: RETURN(FALSE);
253: END fetch_vst_tbl;
254: -- ---------------------------------------------------------------------------

Line 1152: FROM fnd_flex_validation_tables

1148: Nvl(id_column_name,'') || '/' ||
1149: Nvl(id_column_type,'') || '/' ||
1150: Nvl(To_char(id_column_size),'')
1151: INTO l_return
1152: FROM fnd_flex_validation_tables
1153: WHERE flex_value_set_id = p_flex_value_set_id;
1154: RETURN(line_return(l_return));
1155: EXCEPTION
1156: WHEN no_data_found THEN

Line 1587: FROM fnd_flex_validation_tables fvt

1583: -- Table without set.
1584: --
1585: BEGIN
1586: DELETE
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

Line 1599: 'Unable to delete from FND_FLEX_VALIDATION_TABLES. ' || Sqlerrm;

1595: GOTO return_success;
1596: EXCEPTION
1597: WHEN OTHERS THEN
1598: x_message :=
1599: 'Unable to delete from FND_FLEX_VALIDATION_TABLES. ' || Sqlerrm;
1600: GOTO return_error;
1601: END;
1602: END IF;
1603:

Line 1855: UPDATE fnd_flex_validation_tables SET

1851: l_vst_tbl.summary_allowed_flag := 'N';
1852: END IF;
1853:
1854: BEGIN
1855: UPDATE fnd_flex_validation_tables SET
1856: id_column_type = l_vst_tbl.id_column_type,
1857: value_column_type = l_vst_tbl.value_column_type,
1858: meaning_column_type = l_vst_tbl.meaning_column_type,
1859: summary_allowed_flag = l_vst_tbl.summary_allowed_flag,

Line 1867: x_message := 'Unable to update FND_FLEX_VALIDATION_TABLES. ' ||

1863: x_message := SQL%rowcount || ' row(s) updated.';
1864: GOTO return_success;
1865: EXCEPTION
1866: WHEN OTHERS THEN
1867: x_message := 'Unable to update FND_FLEX_VALIDATION_TABLES. ' ||
1868: Sqlerrm;
1869: GOTO return_error;
1870: END;
1871: END IF;