DBA Data[Home] [Help]

APPS.FND_FLEX_SERVER dependencies on FND_APPLICATION

Line 5014: l_application_short_name fnd_application.application_short_name%TYPE;

5010: p_descriptive_flexfield_name IN VARCHAR2)
5011: IS
5012: l_parameters wf_parameter_list_t := wf_parameter_list_t();
5013:
5014: l_application_short_name fnd_application.application_short_name%TYPE;
5015: BEGIN
5016: SELECT 'AFFFSSVB.pls : $Revision: 120.13.12010000.3 $ : raise_dff_compiled' arcs_revision,
5017: application_short_name
5018: INTO g_arcs_revision,

Line 5020: FROM fnd_application

5016: SELECT 'AFFFSSVB.pls : $Revision: 120.13.12010000.3 $ : raise_dff_compiled' arcs_revision,
5017: application_short_name
5018: INTO g_arcs_revision,
5019: l_application_short_name
5020: FROM fnd_application
5021: WHERE application_id = p_application_id;
5022:
5023: wf_event.addparametertolist(p_name => 'APPLICATION_SHORT_NAME',
5024: p_value => l_application_short_name,

Line 5094: l_application_short_name fnd_application.application_short_name%TYPE;

5090: p_id_flex_num IN NUMBER)
5091: IS
5092: l_parameters wf_parameter_list_t := wf_parameter_list_t();
5093:
5094: l_application_short_name fnd_application.application_short_name%TYPE;
5095: l_id_flex_structure_code fnd_id_flex_structures.id_flex_structure_code%TYPE;
5096: BEGIN
5097: SELECT 'AFFFSSVB.pls : $Revision: 120.13.12010000.3 $ : raise_kff_structure_compiled' arcs_revision,
5098: application_short_name

Line 5101: FROM fnd_application

5097: SELECT 'AFFFSSVB.pls : $Revision: 120.13.12010000.3 $ : raise_kff_structure_compiled' arcs_revision,
5098: application_short_name
5099: INTO g_arcs_revision,
5100: l_application_short_name
5101: FROM fnd_application
5102: WHERE application_id = p_application_id;
5103:
5104: SELECT 'AFFFSSVB.pls : $Revision: 120.13.12010000.3 $ : raise_kff_structure_compiled' arcs_revision,
5105: id_flex_structure_code

Line 5930: l_application_short_name fnd_application.application_short_name%TYPE;

5926: p_descriptive_flexfield_name IN VARCHAR2,
5927: x_warning_count OUT nocopy NUMBER)
5928: IS
5929: l_non_forms_warn_table_type table_of_varchar2_32000;
5930: l_application_short_name fnd_application.application_short_name%TYPE;
5931: l_application_name fnd_application_tl.application_name%TYPE;
5932: l_title fnd_descriptive_flexs_tl.title%TYPE;
5933: l_meaning fnd_lookup_values_vl.meaning%TYPE;
5934: l_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

Line 5931: l_application_name fnd_application_tl.application_name%TYPE;

5927: x_warning_count OUT nocopy NUMBER)
5928: IS
5929: l_non_forms_warn_table_type table_of_varchar2_32000;
5930: l_application_short_name fnd_application.application_short_name%TYPE;
5931: l_application_name fnd_application_tl.application_name%TYPE;
5932: l_title fnd_descriptive_flexs_tl.title%TYPE;
5933: l_meaning fnd_lookup_values_vl.meaning%TYPE;
5934: l_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
5935: l_srs_flag BOOLEAN;

Line 6189: FROM fnd_application_vl

6185: --
6186:
6187: SELECT application_short_name, application_name
6188: INTO l_application_short_name, l_application_name
6189: FROM fnd_application_vl
6190: WHERE application_id = p_application_id;
6191:
6192: SELECT title
6193: INTO l_title

Line 6248: l_application_short_name fnd_application.application_short_name%TYPE;

6244: --
6245: -- Compute non_forms warnings for KFF
6246: --
6247:
6248: l_application_short_name fnd_application.application_short_name%TYPE;
6249: l_application_name fnd_application_tl.application_name%TYPE;
6250: l_id_flex_structure_code fnd_id_flex_structures.id_flex_structure_code%TYPE;
6251: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
6252: l_nsegments NUMBER;

Line 6249: l_application_name fnd_application_tl.application_name%TYPE;

6245: -- Compute non_forms warnings for KFF
6246: --
6247:
6248: l_application_short_name fnd_application.application_short_name%TYPE;
6249: l_application_name fnd_application_tl.application_name%TYPE;
6250: l_id_flex_structure_code fnd_id_flex_structures.id_flex_structure_code%TYPE;
6251: l_additional_quickpick_columns fnd_flex_validation_tables.additional_quickpick_columns%TYPE;
6252: l_nsegments NUMBER;
6253: l_message VARCHAR2(1000);

Line 6375: from fnd_application_vl

6371: fnd_flex_key_api.set_session_mode(session_mode => 'customer_data');
6372:
6373: select application_short_name, application_name
6374: into l_application_short_name, l_application_name
6375: from fnd_application_vl
6376: where application_id=p_application_id;
6377:
6378: select id_flex_structure_code into l_id_flex_structure_code
6379: from fnd_id_flex_structures