APPS.FND_FLEX_VAL_API dependencies on FND_APPLICATION

Line 311: RETURN fnd_application.application_id%TYPE

307: /* ------------------------------------------------------------ */
308:
309: FUNCTION application_id_f(application_name_in IN VARCHAR2,
310: application_short_name_in IN VARCHAR2)
311: RETURN fnd_application.application_id%TYPE
312: IS
313: application_id_ret fnd_application.application_id%TYPE;
314: BEGIN
315: BEGIN

Line 313: application_id_ret fnd_application.application_id%TYPE;

309: FUNCTION application_id_f(application_name_in IN VARCHAR2,
310: application_short_name_in IN VARCHAR2)
311: RETURN fnd_application.application_id%TYPE
312: IS
313: application_id_ret fnd_application.application_id%TYPE;
314: BEGIN
315: BEGIN
316: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
317: application_id

Line 319: FROM fnd_application

315: BEGIN
316: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
317: application_id
318: INTO application_id_ret
319: FROM fnd_application
320: WHERE application_short_name = application_short_name_in;
321: EXCEPTION
322: WHEN no_data_found THEN
323: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */

Line 326: FROM fnd_application_tl

322: WHEN no_data_found THEN
323: SELECT /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
324: application_id
325: INTO application_id_ret
326: FROM fnd_application_tl
327: WHERE application_name = application_name_in
328: AND rownum =1;
329: END;
330: RETURN application_id_ret;

Line 1060: table_application_id_i fnd_application.application_id%TYPE;

1056: additional_columns IN VARCHAR2 DEFAULT NULL)
1057: IS
1058: validation_type fnd_flex_value_sets.validation_type%TYPE;
1059: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1060: table_application_id_i fnd_application.application_id%TYPE;
1061: format_code fnd_flex_value_sets.format_type%TYPE;
1062: value_column_type_code fnd_flex_value_sets.format_type%TYPE;
1063: meaning_column_type_code fnd_flex_value_sets.format_type%TYPE;
1064: id_column_type_code fnd_flex_value_sets.format_type%TYPE;

Line 4958: select application_id "ap_id' into ap_id from fnd_application;

4954: END LOOP;
4955:
4956: /* Bug 4908763 problem 1. Remove all " into field " from
4957: Additional Columns.
4958: select application_id "ap_id' into ap_id from fnd_application;
4959: becomes
4960: select application_id "ap_id" from fnd_application; */
4961:
4962: l_tmpaddlclmn_no_into := l_tmpaddlclmn;

Line 4960: select application_id "ap_id" from fnd_application; */

4956: /* Bug 4908763 problem 1. Remove all " into field " from
4957: Additional Columns.
4958: select application_id "ap_id' into ap_id from fnd_application;
4959: becomes
4960: select application_id "ap_id" from fnd_application; */
4961:
4962: l_tmpaddlclmn_no_into := l_tmpaddlclmn;
4963: for i in 0..3
4964: loop