DBA Data[Home] [Help]

APPS.GLXRVSUB_PKG dependencies on FND_FLEX_VALUES

Line 100: SELECT NVL(fvt.application_table_name, 'FND_FLEX_VALUES'),

96: RETURN FALSE;
97: END;
98:
99: BEGIN
100: SELECT NVL(fvt.application_table_name, 'FND_FLEX_VALUES'),
101: NVL(fvt.summary_column_name, 'SUMMARY_FLAG')
102: INTO p_table,
103: p_col
104: FROM fnd_flex_validation_tables fvt, fnd_flex_value_sets fvs

Line 109: p_table := 'FND_FLEX_VALUES';

105: WHERE fvs.flex_value_set_id = l_flex_value_set_id
106: AND fvt.flex_value_set_id(+) = fvs.flex_value_set_id;
107: EXCEPTION
108: WHEN OTHERS THEN
109: p_table := 'FND_FLEX_VALUES';
110: p_col := 'SUMMARY_FLAG';
111: END;
112:
113: IF ((p_table = 'FND_FLEX_VALUES') AND (p_col = 'SUMMARY_FLAG')) THEN

Line 113: IF ((p_table = 'FND_FLEX_VALUES') AND (p_col = 'SUMMARY_FLAG')) THEN

109: p_table := 'FND_FLEX_VALUES';
110: p_col := 'SUMMARY_FLAG';
111: END;
112:
113: IF ((p_table = 'FND_FLEX_VALUES') AND (p_col = 'SUMMARY_FLAG')) THEN
114: BEGIN
115: SELECT summary_flag
116: INTO l_summary_flag
117: FROM fnd_flex_values

Line 117: FROM fnd_flex_values

113: IF ((p_table = 'FND_FLEX_VALUES') AND (p_col = 'SUMMARY_FLAG')) THEN
114: BEGIN
115: SELECT summary_flag
116: INTO l_summary_flag
117: FROM fnd_flex_values
118: WHERE flex_value_set_id = l_flex_value_set_id
119: AND flex_value = account_num;
120: EXCEPTION
121: WHEN OTHERS THEN