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 7056: FROM fnd_application

7052: last_update_date = l_file_who.last_update_date,
7053: last_update_login = l_file_who.last_update_login,
7054: description = Nvl(p_description, description)
7055: WHERE application_id = (SELECT application_id
7056: FROM fnd_application
7057: WHERE application_short_name = p_application_short_name)
7058: AND descriptive_flexfield_name = p_descriptive_flexfield_name
7059: AND default_context_field_name = p_default_context_field_name
7060: AND userenv('LANG') = (SELECT language_code

Line 7808: FROM fnd_application

7804: last_update_login = l_file_who.last_update_login,
7805: id_flex_name = Nvl(p_id_flex_name, id_flex_name),
7806: description = Nvl(p_description, description)
7807: WHERE application_id = (SELECT application_id
7808: FROM fnd_application
7809: WHERE application_short_name = p_application_short_name)
7810: AND id_flex_code = p_id_flex_code
7811: AND userenv('LANG') = (SELECT language_code
7812: FROM fnd_languages

Line 8301: FROM fnd_application

8297: last_update_login = l_file_who.last_update_login,
8298: segment_prompt = Nvl(p_segment_prompt, segment_prompt),
8299: description = Nvl(p_description, description)
8300: WHERE application_id = (SELECT application_id
8301: FROM fnd_application
8302: WHERE application_short_name = p_application_short_name)
8303: AND id_flex_code = p_id_flex_code
8304: AND segment_attribute_type = p_segment_attribute_type
8305: AND userenv('LANG') = (SELECT language_code

Line 9154: FROM fnd_application

9150: WHERE ((application_id, id_flex_code, id_flex_num) =
9151: (SELECT application_id, id_flex_code, id_flex_num
9152: FROM fnd_id_flex_structures
9153: WHERE application_id = (SELECT application_id
9154: FROM fnd_application
9155: WHERE application_short_name = p_application_short_name)
9156: AND id_flex_code = p_id_flex_code
9157: AND id_flex_structure_code = p_id_flex_structure_code))
9158: AND alias_name = p_alias_name

Line 9650: FROM fnd_application

9646: WHERE ((application_id, id_flex_code, id_flex_num) =
9647: (SELECT application_id, id_flex_code, id_flex_num
9648: FROM fnd_id_flex_structures
9649: WHERE application_id = (SELECT application_id
9650: FROM fnd_application
9651: WHERE application_short_name = p_application_short_name)
9652: AND id_flex_code = p_id_flex_code
9653: AND id_flex_structure_code = p_id_flex_structure_code))
9654: AND flex_validation_rule_name = p_flex_validation_rule_name