DBA Data[Home] [Help]

APPS.GL_MC_INFO dependencies on FND_FLEX_VALUE_SETS

Line 441: l_fv_type FND_FLEX_VALUE_SETS.validation_type%TYPE;

437: l_bsv_vset_id NUMBER;
438:
439: l_fv_table FND_FLEX_VALIDATION_TABLES.application_table_name%TYPE;
440: l_fv_col FND_FLEX_VALIDATION_TABLES.value_column_name%TYPE;
441: l_fv_type FND_FLEX_VALUE_SETS.validation_type%TYPE;
442:
443: l_insertSQL DBMS_SQL.VARCHAR2S;
444: l_line_no NUMBER := 0;
445: l_cursorID INTEGER;

Line 574: FROM fnd_flex_value_sets fvs

570: , fvs.validation_type
571: INTO l_fv_table
572: , l_fv_col
573: , l_fv_type
574: FROM fnd_flex_value_sets fvs
575: , fnd_flex_validation_tables fvt
576: WHERE fvs.flex_value_set_id = l_bsv_vset_id
577: AND fvt.flex_value_set_id(+) = fvs.flex_value_set_id;
578:

Line 2315: l_fv_type fnd_flex_value_sets.validation_type%TYPE;

2311: l_line_num NUMBER := 1;
2312: l_cursor integer;
2313: l_fv_table varchar2(30);
2314: l_fv_col varchar2(30);
2315: l_fv_type fnd_flex_value_sets.validation_type%TYPE;
2316: l_fv_description fnd_flex_validation_tables.meaning_column_name%TYPE;
2317: rows_processed number;
2318: l_status varchar2(30);
2319: BEGIN

Line 2354: FROM fnd_flex_value_sets fvs

2350: INTO l_fv_table
2351: , l_fv_col
2352: , l_fv_type
2353: , l_fv_description
2354: FROM fnd_flex_value_sets fvs
2355: , fnd_flex_validation_tables fvt
2356: , gl_ledgers gl
2357: WHERE fvs.flex_value_set_id = gl.bal_seg_value_set_id
2358: AND gl.ledger_id = n_ledger_id