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.

[Home] [Help]

APPS.FND_FLEX_VAL_API dependencies on FND_COLUMNS

Line 213: FROM fnd_columns c, fnd_tables t

209:
210: BEGIN
211: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
212: column_name INTO hierarchy_level_column_name
213: FROM fnd_columns c, fnd_tables t
214: WHERE c.column_name = 'STRUCTURED_HIERARCHY_LEVEL'
215: AND t.table_name = application_table_name
216: AND t.application_id= table_application_id
217: AND t.table_id = c.table_id

Line 228: FROM fnd_columns c, fnd_tables t

224:
225: BEGIN
226: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
227: column_name INTO enabled_column_name
228: FROM fnd_columns c, fnd_tables t
229: WHERE c.column_name = 'ENABLED_FLAG'
230: AND c.column_type IN ('C', 'V')
231: AND t.table_name = application_table_name
232: AND t.application_id= table_application_id

Line 244: FROM fnd_columns c, fnd_tables t

240:
241: BEGIN
242: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
243: column_name INTO start_date_column_name
244: FROM fnd_columns c, fnd_tables t
245: WHERE c.column_name = 'START_DATE_ACTIVE'
246: AND t.table_name = application_table_name
247: AND t.application_id= table_application_id
248: AND t.table_id = c.table_id

Line 259: FROM fnd_columns c, fnd_tables t

255:
256: BEGIN
257: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
258: column_name INTO end_date_column_name
259: FROM fnd_columns c, fnd_tables t
260: WHERE c.column_name = 'END_DATE_ACTIVE'
261: AND t.table_name = application_table_name
262: AND t.application_id= table_application_id
263: AND t.table_id = c.table_id

Line 274: FROM fnd_columns c, fnd_tables t

270:
271: BEGIN
272: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
273: column_name INTO summary_column_name
274: FROM fnd_columns c, fnd_tables t
275: WHERE c.column_name = 'SUMMARY_FLAG'
276: AND t.table_name = application_table_name
277: AND t.application_id= table_application_id
278: AND t.table_id = c.table_id

Line 289: FROM fnd_columns c, fnd_tables t

285:
286: BEGIN
287: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
288: column_name INTO compiled_attribute_column_name
289: FROM fnd_columns c, fnd_tables t
290: WHERE c.column_name = 'COMPILED_VALUE_ATTRIBUTES'
291: AND t.table_name = application_table_name
292: AND t.application_id= table_application_id
293: AND t.table_id = c.table_id

Line 480: FROM fnd_tables t, fnd_lookup_values l, fnd_columns c

476: BEGIN
477: IF(column_name_in IS NOT NULL) THEN
478: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
479: NULL INTO dummy
480: FROM fnd_tables t, fnd_lookup_values l, fnd_columns c
481: WHERE t.application_id = table_application_id_in
482: AND t.table_name = application_table_name_in
483: AND c.application_id = t.application_id
484: AND c.column_name = column_name_in

Line 504: column_type_i fnd_columns.column_type%TYPE;

500: application_table_name_in IN VARCHAR2,
501: column_name_in IN VARCHAR2,
502: format_type_in IN VARCHAR2)
503: IS
504: column_type_i fnd_columns.column_type%TYPE;
505: dummy NUMBER;
506: BEGIN
507: BEGIN
508: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */

Line 511: FROM fnd_tables t, fnd_lookup_values l, fnd_columns c

507: BEGIN
508: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
509: column_type
510: INTO column_type_i
511: FROM fnd_tables t, fnd_lookup_values l, fnd_columns c
512: WHERE t.application_id = table_application_id_in
513: AND t.table_name = application_table_name_in
514: AND c.application_id = t.application_id
515: AND c.table_id = t.table_id

Line 1945: FROM fnd_columns c, fnd_tables t

1941: BEGIN
1942: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1943: width
1944: INTO width_i
1945: FROM fnd_columns c, fnd_tables t
1946: WHERE (t.application_id = table_r.table_application_id
1947: OR table_r.table_application_id IS NULL)
1948: AND t.table_id = c.table_id
1949: AND t.application_id = c.application_id

Line 1977: FROM fnd_columns c, fnd_tables t

1973: BEGIN
1974: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
1975: width
1976: INTO width_i
1977: FROM fnd_columns c, fnd_tables t
1978: WHERE (t.application_id = table_r.table_application_id
1979: OR table_r.table_application_id IS NULL)
1980: AND t.table_id = c.table_id
1981: AND t.application_id = c.application_id

Line 2578: p_column_name IN fnd_columns.column_name%TYPE,

2574:
2575:
2576: FUNCTION is_column_used(p_application_id IN fnd_tables.application_id%TYPE,
2577: p_table_name IN fnd_tables.table_name%TYPE,
2578: p_column_name IN fnd_columns.column_name%TYPE,
2579: x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2580: IS
2581: up_table_name fnd_tables.table_name%TYPE;
2582: up_column_name fnd_columns.column_name%TYPE;

Line 2582: up_column_name fnd_columns.column_name%TYPE;

2578: p_column_name IN fnd_columns.column_name%TYPE,
2579: x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2580: IS
2581: up_table_name fnd_tables.table_name%TYPE;
2582: up_column_name fnd_columns.column_name%TYPE;
2583: l_vset_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2584: BEGIN
2585: up_table_name := Upper(p_table_name);
2586: up_column_name := Upper(p_column_name);

Line 3727: fnd_columns c, fnd_tables tb

3723: l_column_type, l_appl_col_size
3724: FROM
3725: fnd_flex_value_sets v,
3726: fnd_flex_validation_tables t,
3727: fnd_columns c, fnd_tables tb
3728: WHERE
3729: v.flex_value_set_id = p_value_set_id and
3730: v.flex_value_set_id = t.flex_value_set_id(+) and
3731: tb.application_id = 0 and

Line 4066: p_application_column_type IN fnd_columns.column_type%TYPE,

4062:
4063: END is_valueset_allowed;
4064:
4065: PROCEDURE check_base_table_column(
4066: p_application_column_type IN fnd_columns.column_type%TYPE,
4067: p_application_column_size IN fnd_columns.width%TYPE,
4068: p_id_column_type IN fnd_flex_validation_tables.id_column_type%TYPE,
4069: p_id_column_size IN fnd_flex_validation_tables.id_column_size%TYPE,
4070: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE,

Line 4067: p_application_column_size IN fnd_columns.width%TYPE,

4063: END is_valueset_allowed;
4064:
4065: PROCEDURE check_base_table_column(
4066: p_application_column_type IN fnd_columns.column_type%TYPE,
4067: p_application_column_size IN fnd_columns.width%TYPE,
4068: p_id_column_type IN fnd_flex_validation_tables.id_column_type%TYPE,
4069: p_id_column_size IN fnd_flex_validation_tables.id_column_size%TYPE,
4070: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE,
4071: p_format_type IN fnd_flex_value_sets.format_type%TYPE,

Line 4253: fnd_columns c, fnd_tables tb

4249: c.column_type, c.width
4250: INTO
4251: l_application_column_type, l_application_column_size
4252: FROM
4253: fnd_columns c, fnd_tables tb
4254: WHERE
4255: tb.application_id = 0 and
4256: tb.table_name = 'FND_SRS_MASTER' and
4257: tb.application_id = c.application_id and

Line 4267: fnd_columns c

4263: l_application_column_type, l_application_column_size
4264: FROM
4265: fnd_descriptive_flexs dff,
4266: fnd_tables tb,
4267: fnd_columns c
4268: WHERE
4269: c.application_id = tb.application_id and
4270: c.table_id = tb.table_id and
4271: c.application_id = dff.table_application_id and

Line 4436: fnd_columns c

4432: l_application_column_type, l_application_column_size, l_allow_id_valuesets
4433: FROM
4434: fnd_id_flexs kff,
4435: fnd_tables tb,
4436: fnd_columns c
4437: WHERE
4438: c.application_id = tb.application_id and
4439: c.table_id = tb.table_id and
4440: c.application_id = kff.table_application_id and