DBA Data[Home] [Help]

APPS.FND_FLEX_SERVER dependencies on FND_APPLICATION

Line 5207: l_application_short_name fnd_application.application_short_name%TYPE;

5203: p_descriptive_flexfield_name IN VARCHAR2)
5204: IS
5205: l_parameters wf_parameter_list_t := wf_parameter_list_t();
5206:
5207: l_application_short_name fnd_application.application_short_name%TYPE;
5208: BEGIN
5209: SELECT 'AFFFSSVB.pls : $Revision: 120.28.12020000.2 $ : raise_dff_compiled' arcs_revision,
5210: application_short_name
5211: INTO g_arcs_revision,

Line 5213: FROM fnd_application

5209: SELECT 'AFFFSSVB.pls : $Revision: 120.28.12020000.2 $ : raise_dff_compiled' arcs_revision,
5210: application_short_name
5211: INTO g_arcs_revision,
5212: l_application_short_name
5213: FROM fnd_application
5214: WHERE application_id = p_application_id;
5215:
5216: wf_event.addparametertolist(p_name => 'APPLICATION_SHORT_NAME',
5217: p_value => l_application_short_name,

Line 5287: l_application_short_name fnd_application.application_short_name%TYPE;

5283: p_id_flex_num IN NUMBER)
5284: IS
5285: l_parameters wf_parameter_list_t := wf_parameter_list_t();
5286:
5287: l_application_short_name fnd_application.application_short_name%TYPE;
5288: l_id_flex_structure_code fnd_id_flex_structures.id_flex_structure_code%TYPE;
5289: BEGIN
5290: SELECT 'AFFFSSVB.pls : $Revision: 120.28.12020000.2 $ : raise_kff_structure_compiled' arcs_revision,
5291: application_short_name

Line 5294: FROM fnd_application

5290: SELECT 'AFFFSSVB.pls : $Revision: 120.28.12020000.2 $ : raise_kff_structure_compiled' arcs_revision,
5291: application_short_name
5292: INTO g_arcs_revision,
5293: l_application_short_name
5294: FROM fnd_application
5295: WHERE application_id = p_application_id;
5296:
5297: SELECT 'AFFFSSVB.pls : $Revision: 120.28.12020000.2 $ : raise_kff_structure_compiled' arcs_revision,
5298: id_flex_structure_code

Line 6123: l_application_short_name fnd_application.application_short_name%TYPE;

6119: p_descriptive_flexfield_name IN VARCHAR2,
6120: x_warning_count OUT nocopy NUMBER)
6121: IS
6122: l_non_forms_warn_table_type table_of_varchar2_32000;
6123: l_application_short_name fnd_application.application_short_name%TYPE;
6124: l_application_name fnd_application_tl.application_name%TYPE;
6125: l_title fnd_descriptive_flexs_tl.title%TYPE;
6126: l_meaning fnd_lookup_values_vl.meaning%TYPE;
6127: l_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

Line 6124: l_application_name fnd_application_tl.application_name%TYPE;

6120: x_warning_count OUT nocopy NUMBER)
6121: IS
6122: l_non_forms_warn_table_type table_of_varchar2_32000;
6123: l_application_short_name fnd_application.application_short_name%TYPE;
6124: l_application_name fnd_application_tl.application_name%TYPE;
6125: l_title fnd_descriptive_flexs_tl.title%TYPE;
6126: l_meaning fnd_lookup_values_vl.meaning%TYPE;
6127: l_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
6128: l_srs_flag BOOLEAN;

Line 6382: FROM fnd_application_vl

6378: --
6379:
6380: SELECT application_short_name, application_name
6381: INTO l_application_short_name, l_application_name
6382: FROM fnd_application_vl
6383: WHERE application_id = p_application_id;
6384:
6385: SELECT title
6386: INTO l_title

Line 6441: l_application_short_name fnd_application.application_short_name%TYPE;

6437: --
6438: -- Compute non_forms warnings for KFF
6439: --
6440:
6441: l_application_short_name fnd_application.application_short_name%TYPE;
6442: l_application_name fnd_application_tl.application_name%TYPE;
6443: l_id_flex_structure_code fnd_id_flex_structures.id_flex_structure_code%TYPE;
6444: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
6445: l_nsegments NUMBER;

Line 6442: l_application_name fnd_application_tl.application_name%TYPE;

6438: -- Compute non_forms warnings for KFF
6439: --
6440:
6441: l_application_short_name fnd_application.application_short_name%TYPE;
6442: l_application_name fnd_application_tl.application_name%TYPE;
6443: l_id_flex_structure_code fnd_id_flex_structures.id_flex_structure_code%TYPE;
6444: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
6445: l_nsegments NUMBER;
6446: l_message VARCHAR2(1000);

Line 6568: from fnd_application_vl

6564: fnd_flex_key_api.set_session_mode(session_mode => 'customer_data');
6565:
6566: select application_short_name, application_name
6567: into l_application_short_name, l_application_name
6568: from fnd_application_vl
6569: where application_id=p_application_id;
6570:
6571: select id_flex_structure_code into l_id_flex_structure_code
6572: from fnd_id_flex_structures