APPS.FND_FLEX_KEY_API dependencies on FND_APPLICATION

Line 76: SUBTYPE app_type IS fnd_application%ROWTYPE;

72:
73: --
74: -- TYPEs
75: --
76: SUBTYPE app_type IS fnd_application%ROWTYPE;
77:
78: --
79: -- Global Variables
80: --

Line 743: RETURN fnd_application.application_id%TYPE

739: /* ---------------------------------------------------------------------- */
740: /* Name to Id conversion functions */
741: /* ---------------------------------------------------------------------- */
742: FUNCTION application_id_f(application_short_name_in IN VARCHAR2)
743: RETURN fnd_application.application_id%TYPE
744: IS
745: application_id_ret fnd_application.application_id%TYPE;
746: BEGIN
747: SELECT application_id

Line 745: application_id_ret fnd_application.application_id%TYPE;

741: /* ---------------------------------------------------------------------- */
742: FUNCTION application_id_f(application_short_name_in IN VARCHAR2)
743: RETURN fnd_application.application_id%TYPE
744: IS
745: application_id_ret fnd_application.application_id%TYPE;
746: BEGIN
747: SELECT application_id
748: INTO application_id_ret
749: FROM fnd_application

Line 749: FROM fnd_application

745: application_id_ret fnd_application.application_id%TYPE;
746: BEGIN
747: SELECT application_id
748: INTO application_id_ret
749: FROM fnd_application
750: WHERE application_short_name = application_short_name_in
751: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
752:
753: RETURN application_id_ret;

Line 1296: FROM fnd_id_flexs idf, fnd_application tap, fnd_tables tab

1292: idf.application_id,
1293: tap.application_id,
1294: tab.table_id
1295: INTO flexfield
1296: FROM fnd_id_flexs idf, fnd_application tap, fnd_tables tab
1297: WHERE idf.application_id = flexfield.application_id
1298: AND id_flex_code = flexfield.flex_code
1299: AND idf.table_application_id = tap.application_id
1300: AND tab.application_id = table_application_id

Line 4045: (p_application_short_name IN fnd_application.application_short_name%TYPE,

4041: --------------------------------------------------------------------------------
4042: -- Returns Application details.
4043: --------------------------------------------------------------------------------
4044: PROCEDURE get_app
4045: (p_application_short_name IN fnd_application.application_short_name%TYPE,
4046: x_app OUT nocopy app_type)
4047: IS
4048: BEGIN
4049: BEGIN

Line 4052: FROM fnd_application fa

4048: BEGIN
4049: BEGIN
4050: SELECT fa.*
4051: INTO x_app
4052: FROM fnd_application fa
4053: WHERE fa.application_short_name = p_application_short_name;
4054: EXCEPTION
4055: WHEN no_data_found THEN
4056: raise_no_data_found

Line 4070: (p_application_id IN fnd_application.application_id%TYPE,

4066:
4067: -- Deletes compiled definition from fnd_compiled_id_flexs and fnd_compiled_id_flex_structs tables.
4068:
4069: PROCEDURE delete_compiled_definition
4070: (p_application_id IN fnd_application.application_id%TYPE,
4071: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
4072: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE)
4073: IS
4074: BEGIN