DBA Data[Home] [Help]

APPS.FND_FLEX_VAL_API dependencies on FND_APPLICATION

Line 312: RETURN fnd_application.application_id%TYPE

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

Line 314: application_id_ret fnd_application.application_id%TYPE;

310: FUNCTION application_id_f(application_name_in IN VARCHAR2,
311: application_short_name_in IN VARCHAR2)
312: RETURN fnd_application.application_id%TYPE
313: IS
314: application_id_ret fnd_application.application_id%TYPE;
315: BEGIN
316: BEGIN
317: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
318: application_id

Line 320: FROM fnd_application

316: BEGIN
317: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
318: application_id
319: INTO application_id_ret
320: FROM fnd_application
321: WHERE application_short_name = application_short_name_in;
322: EXCEPTION
323: WHEN no_data_found THEN
324: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */

Line 327: FROM fnd_application_tl

323: WHEN no_data_found THEN
324: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
325: application_id
326: INTO application_id_ret
327: FROM fnd_application_tl
328: WHERE application_name = application_name_in
329: AND rownum =1;
330: END;
331: RETURN application_id_ret;

Line 1071: table_application_id_i fnd_application.application_id%TYPE;

1067: additional_columns IN VARCHAR2 DEFAULT NULL)
1068: IS
1069: validation_type fnd_flex_value_sets.validation_type%TYPE;
1070: value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
1071: table_application_id_i fnd_application.application_id%TYPE;
1072: format_code fnd_flex_value_sets.format_type%TYPE;
1073: value_column_type_code fnd_flex_value_sets.format_type%TYPE;
1074: meaning_column_type_code fnd_flex_value_sets.format_type%TYPE;
1075: id_column_type_code fnd_flex_value_sets.format_type%TYPE;

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

5082: END LOOP;
5083:
5084: /* Bug 4908763 problem 1. Remove all " into field " from
5085: Additional Columns.
5086: select application_id "ap_id' into ap_id from fnd_application;
5087: becomes
5088: select application_id "ap_id" from fnd_application; */
5089:
5090: l_tmpaddlclmn_no_into := l_tmpaddlclmn;

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

5084: /* Bug 4908763 problem 1. Remove all " into field " from
5085: Additional Columns.
5086: select application_id "ap_id' into ap_id from fnd_application;
5087: becomes
5088: select application_id "ap_id" from fnd_application; */
5089:
5090: l_tmpaddlclmn_no_into := l_tmpaddlclmn;
5091: for i in 0..3
5092: loop