[Home] [Help]
210:
211: BEGIN
212: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
213: column_name INTO hierarchy_level_column_name
214: FROM fnd_columns c, fnd_tables t
215: WHERE c.column_name = 'STRUCTURED_HIERARCHY_LEVEL'
216: AND t.table_name = application_table_name
217: AND t.application_id= table_application_id
218: AND t.table_id = c.table_id
225:
226: BEGIN
227: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
228: column_name INTO enabled_column_name
229: FROM fnd_columns c, fnd_tables t
230: WHERE c.column_name = 'ENABLED_FLAG'
231: AND c.column_type IN ('C', 'V')
232: AND t.table_name = application_table_name
233: AND t.application_id= table_application_id
241:
242: BEGIN
243: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
244: column_name INTO start_date_column_name
245: FROM fnd_columns c, fnd_tables t
246: WHERE c.column_name = 'START_DATE_ACTIVE'
247: AND t.table_name = application_table_name
248: AND t.application_id= table_application_id
249: AND t.table_id = c.table_id
256:
257: BEGIN
258: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
259: column_name INTO end_date_column_name
260: FROM fnd_columns c, fnd_tables t
261: WHERE c.column_name = 'END_DATE_ACTIVE'
262: AND t.table_name = application_table_name
263: AND t.application_id= table_application_id
264: AND t.table_id = c.table_id
271:
272: BEGIN
273: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
274: column_name INTO summary_column_name
275: FROM fnd_columns c, fnd_tables t
276: WHERE c.column_name = 'SUMMARY_FLAG'
277: AND t.table_name = application_table_name
278: AND t.application_id= table_application_id
279: AND t.table_id = c.table_id
286:
287: BEGIN
288: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
289: column_name INTO compiled_attribute_column_name
290: FROM fnd_columns c, fnd_tables t
291: WHERE c.column_name = 'COMPILED_VALUE_ATTRIBUTES'
292: AND t.table_name = application_table_name
293: AND t.application_id= table_application_id
294: AND t.table_id = c.table_id
477: BEGIN
478: IF(column_name_in IS NOT NULL) THEN
479: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
480: NULL INTO dummy
481: FROM fnd_tables t, fnd_lookup_values l, fnd_columns c
482: WHERE t.application_id = table_application_id_in
483: AND t.table_name = application_table_name_in
484: AND c.application_id = t.application_id
485: AND c.column_name = column_name_in
508: BEGIN
509: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
510: column_type
511: INTO column_type_i
512: FROM fnd_tables t, fnd_lookup_values l, fnd_columns c
513: WHERE t.application_id = table_application_id_in
514: AND t.table_name = application_table_name_in
515: AND c.application_id = t.application_id
516: AND c.table_id = t.table_id
1952: BEGIN
1953: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1954: width
1955: INTO width_i
1956: FROM fnd_columns c, fnd_tables t
1957: WHERE (t.application_id = table_r.table_application_id
1958: OR table_r.table_application_id IS NULL)
1959: AND t.table_id = c.table_id
1960: AND t.application_id = c.application_id
1984: BEGIN
1985: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1986: width
1987: INTO width_i
1988: FROM fnd_columns c, fnd_tables t
1989: WHERE (t.application_id = table_r.table_application_id
1990: OR table_r.table_application_id IS NULL)
1991: AND t.table_id = c.table_id
1992: AND t.application_id = c.application_id
2538: 'Error : ' || Sqlerrm);
2539: x_success := g_ret_others;
2540: END get_dependent_vset_select;
2541:
2542: FUNCTION is_table_used(p_application_id IN fnd_tables.application_id%TYPE,
2543: p_table_name IN fnd_tables.table_name%TYPE,
2544: x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2545: IS
2546: up_table_name fnd_tables.table_name%TYPE;
2539: x_success := g_ret_others;
2540: END get_dependent_vset_select;
2541:
2542: FUNCTION is_table_used(p_application_id IN fnd_tables.application_id%TYPE,
2543: p_table_name IN fnd_tables.table_name%TYPE,
2544: x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2545: IS
2546: up_table_name fnd_tables.table_name%TYPE;
2547: l_vset_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2542: FUNCTION is_table_used(p_application_id IN fnd_tables.application_id%TYPE,
2543: p_table_name IN fnd_tables.table_name%TYPE,
2544: x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2545: IS
2546: up_table_name fnd_tables.table_name%TYPE;
2547: l_vset_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2548: BEGIN
2549: up_table_name := Upper(p_table_name);
2550:
2583: RETURN(TRUE);
2584: END is_table_used;
2585:
2586:
2587: FUNCTION is_column_used(p_application_id IN fnd_tables.application_id%TYPE,
2588: p_table_name IN fnd_tables.table_name%TYPE,
2589: p_column_name IN fnd_columns.column_name%TYPE,
2590: x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2591: IS
2584: END is_table_used;
2585:
2586:
2587: FUNCTION is_column_used(p_application_id IN fnd_tables.application_id%TYPE,
2588: p_table_name IN fnd_tables.table_name%TYPE,
2589: p_column_name IN fnd_columns.column_name%TYPE,
2590: x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2591: IS
2592: up_table_name fnd_tables.table_name%TYPE;
2588: p_table_name IN fnd_tables.table_name%TYPE,
2589: p_column_name IN fnd_columns.column_name%TYPE,
2590: x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2591: IS
2592: up_table_name fnd_tables.table_name%TYPE;
2593: up_column_name fnd_columns.column_name%TYPE;
2594: l_vset_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2595: BEGIN
2596: up_table_name := Upper(p_table_name);
3851: l_column_type, l_appl_col_size
3852: FROM
3853: fnd_flex_value_sets v,
3854: fnd_flex_validation_tables t,
3855: fnd_columns c, fnd_tables tb
3856: WHERE
3857: v.flex_value_set_id = p_value_set_id and
3858: v.flex_value_set_id = t.flex_value_set_id(+) and
3859: tb.application_id = 0 and
3863:
3864: -- The SRS form does not need to save the Parameter values entered
3865: -- in the FF. Because of this, there is no base table to validate
3866: -- against. Instead of validating against a base table we use
3867: -- column attributes from fnd_column and fnd_tables.
3868: -- We assign the values returned to what normally we would
3869: -- get from the base table. Now normal validation can continue
3870: -- since we have values for p_application_column_type and
3871: -- p_application_column_size. They are passed in as null from
4365: IF (instr(p_descriptive_flexfield_name,'$SRS$') > 0) THEN
4366: -- The SRS form does not need to save the Parameter values entered
4367: -- in the FF. Because of this, there is no base table to validate
4368: -- against. Instead of validating against a base table we use
4369: -- column attributes from fnd_column and fnd_tables.
4370: -- We assign the values returned to what normally we would
4371: -- get from the base table. Now normal validation can continue
4372: -- since we have values for p_application_column_type and
4373: -- p_application_column_size. They are passed in as null from
4377: c.column_type, c.width
4378: INTO
4379: l_application_column_type, l_application_column_size
4380: FROM
4381: fnd_columns c, fnd_tables tb
4382: WHERE
4383: tb.application_id = 0 and
4384: tb.table_name = 'FND_SRS_MASTER' and
4385: tb.application_id = c.application_id and
4390: INTO
4391: l_application_column_type, l_application_column_size
4392: FROM
4393: fnd_descriptive_flexs dff,
4394: fnd_tables tb,
4395: fnd_columns c
4396: WHERE
4397: c.application_id = tb.application_id and
4398: c.table_id = tb.table_id and
4559: INTO
4560: l_application_column_type, l_application_column_size, l_allow_id_valuesets
4561: FROM
4562: fnd_id_flexs kff,
4563: fnd_tables tb,
4564: fnd_columns c
4565: WHERE
4566: c.application_id = tb.application_id and
4567: c.table_id = tb.table_id and