[Home] [Help]
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
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
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
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
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
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
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
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
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
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
2527: 'Error : ' || Sqlerrm);
2528: x_success := g_ret_others;
2529: END get_dependent_vset_select;
2530:
2531: FUNCTION is_table_used(p_application_id IN fnd_tables.application_id%TYPE,
2532: p_table_name IN fnd_tables.table_name%TYPE,
2533: x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2534: IS
2535: up_table_name fnd_tables.table_name%TYPE;
2528: x_success := g_ret_others;
2529: END get_dependent_vset_select;
2530:
2531: FUNCTION is_table_used(p_application_id IN fnd_tables.application_id%TYPE,
2532: p_table_name IN fnd_tables.table_name%TYPE,
2533: x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2534: IS
2535: up_table_name fnd_tables.table_name%TYPE;
2536: l_vset_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2531: FUNCTION is_table_used(p_application_id IN fnd_tables.application_id%TYPE,
2532: p_table_name IN fnd_tables.table_name%TYPE,
2533: x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2534: IS
2535: up_table_name fnd_tables.table_name%TYPE;
2536: l_vset_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2537: BEGIN
2538: up_table_name := Upper(p_table_name);
2539:
2572: RETURN(TRUE);
2573: END is_table_used;
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
2573: END is_table_used;
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;
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;
2583: l_vset_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2584: BEGIN
2585: up_table_name := Upper(p_table_name);
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
3735:
3736: -- The SRS form does not need to save the Parameter values entered
3737: -- in the FF. Because of this, there is no base table to validate
3738: -- against. Instead of validating against a base table we use
3739: -- column attributes from fnd_column and fnd_tables.
3740: -- We assign the values returned to what normally we would
3741: -- get from the base table. Now normal validation can continue
3742: -- since we have values for p_application_column_type and
3743: -- p_application_column_size. They are passed in as null from
4237: IF (instr(p_descriptive_flexfield_name,'$SRS$') > 0) THEN
4238: -- The SRS form does not need to save the Parameter values entered
4239: -- in the FF. Because of this, there is no base table to validate
4240: -- against. Instead of validating against a base table we use
4241: -- column attributes from fnd_column and fnd_tables.
4242: -- We assign the values returned to what normally we would
4243: -- get from the base table. Now normal validation can continue
4244: -- since we have values for p_application_column_type and
4245: -- p_application_column_size. They are passed in as null from
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
4262: INTO
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
4431: INTO
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