APPS.FND_FLEX_LOADER_APIS dependencies on FND_APPLICATION

Line 63: SUBTYPE app_type IS fnd_application%ROWTYPE;

59: ERROR_KFF_COL_USED CONSTANT NUMBER := -20303;
60: ERROR_KFF_COL_NOT_REG CONSTANT NUMBER := -20304;
61:
62:
63: SUBTYPE app_type IS fnd_application%ROWTYPE;
64: SUBTYPE tbl_type IS fnd_tables%ROWTYPE;
65: SUBTYPE col_type IS fnd_columns%ROWTYPE;
66: SUBTYPE resp_type IS fnd_responsibility%ROWTYPE;
67:

Line 1012: FROM fnd_application

1008: BEGIN
1009: l_func_name := g_api_name || 'get_app(short_name, F)';
1010: SELECT *
1011: INTO x_app
1012: FROM fnd_application
1013: WHERE application_short_name = p_application_short_name;
1014: RETURN TRUE;
1015: EXCEPTION
1016: WHEN no_data_found THEN

Line 1051: FROM fnd_application

1047: BEGIN
1048: l_func_name := g_api_name || 'get_app(id, F)';
1049: SELECT *
1050: INTO x_app
1051: FROM fnd_application
1052: WHERE application_id = p_application_id;
1053: RETURN TRUE;
1054: EXCEPTION
1055: WHEN no_data_found THEN

Line 3249: FROM fnd_application a, fnd_responsibility r

3245: WHERE u.user_name = 'SYSADMIN';
3246:
3247: SELECT r.application_id, r.responsibility_id
3248: INTO l_resp_appl_id, l_resp_id
3249: FROM fnd_application a, fnd_responsibility r
3250: WHERE r.application_id = a.application_id
3251: AND a.application_short_name = 'SYSADMIN'
3252: AND r.responsibility_key = 'SYSTEM_ADMINISTRATOR';
3253:

Line 3341: fnd_application fa

3337: SELECT request_id
3338: INTO l_request_id
3339: FROM fnd_concurrent_requests fcr,
3340: fnd_concurrent_programs fcp,
3341: fnd_application fa
3342: WHERE fa.application_short_name = p_application_short_name
3343: AND fcp.application_id = fa.application_id
3344: AND fcp.concurrent_program_name = p_concurrent_program_name
3345: AND fcr.program_application_id = fcp.application_id

Line 7062: FROM fnd_application

7058: last_update_date = l_file_who.last_update_date,
7059: last_update_login = l_file_who.last_update_login,
7060: description = Nvl(p_description, description)
7061: WHERE application_id = (SELECT application_id
7062: FROM fnd_application
7063: WHERE application_short_name = p_application_short_name)
7064: AND descriptive_flexfield_name = p_descriptive_flexfield_name
7065: AND default_context_field_name = p_default_context_field_name
7066: AND userenv('LANG') = (SELECT language_code

Line 7814: FROM fnd_application

7810: last_update_login = l_file_who.last_update_login,
7811: id_flex_name = Nvl(p_id_flex_name, id_flex_name),
7812: description = Nvl(p_description, description)
7813: WHERE application_id = (SELECT application_id
7814: FROM fnd_application
7815: WHERE application_short_name = p_application_short_name)
7816: AND id_flex_code = p_id_flex_code
7817: AND userenv('LANG') = (SELECT language_code
7818: FROM fnd_languages

Line 8307: FROM fnd_application

8303: last_update_login = l_file_who.last_update_login,
8304: segment_prompt = Nvl(p_segment_prompt, segment_prompt),
8305: description = Nvl(p_description, description)
8306: WHERE application_id = (SELECT application_id
8307: FROM fnd_application
8308: WHERE application_short_name = p_application_short_name)
8309: AND id_flex_code = p_id_flex_code
8310: AND segment_attribute_type = p_segment_attribute_type
8311: AND userenv('LANG') = (SELECT language_code

Line 9160: FROM fnd_application

9156: WHERE ((application_id, id_flex_code, id_flex_num) =
9157: (SELECT application_id, id_flex_code, id_flex_num
9158: FROM fnd_id_flex_structures
9159: WHERE application_id = (SELECT application_id
9160: FROM fnd_application
9161: WHERE application_short_name = p_application_short_name)
9162: AND id_flex_code = p_id_flex_code
9163: AND id_flex_structure_code = p_id_flex_structure_code))
9164: AND alias_name = p_alias_name

Line 9656: FROM fnd_application

9652: WHERE ((application_id, id_flex_code, id_flex_num) =
9653: (SELECT application_id, id_flex_code, id_flex_num
9654: FROM fnd_id_flex_structures
9655: WHERE application_id = (SELECT application_id
9656: FROM fnd_application
9657: WHERE application_short_name = p_application_short_name)
9658: AND id_flex_code = p_id_flex_code
9659: AND id_flex_structure_code = p_id_flex_structure_code))
9660: AND flex_validation_rule_name = p_flex_validation_rule_name