APPS.FND_FLEX_SERVER dependencies on FND_ID_FLEX_STRUCTURES

Line 5095: l_id_flex_structure_code fnd_id_flex_structures.id_flex_structure_code%TYPE;

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
5099: INTO g_arcs_revision,

Line 5108: FROM fnd_id_flex_structures

5104: SELECT 'AFFFSSVB.pls : $Revision: 120.13.12010000.3 $ : raise_kff_structure_compiled' arcs_revision,
5105: id_flex_structure_code
5106: INTO g_arcs_revision,
5107: l_id_flex_structure_code
5108: FROM fnd_id_flex_structures
5109: WHERE application_id = p_application_id
5110: AND id_flex_code = p_id_flex_code
5111: AND id_flex_num = p_id_flex_num;
5112:

Line 5253: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;

5249: px_kfvssc_record IN OUT nocopy kfvssc_record_type)
5250: IS
5251: l_kfvcct_record kfvcct_record_type;
5252:
5253: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
5254:
5255: l_compact_concat VARCHAR2(32000);
5256: l_padded_concat VARCHAR2(32000);
5257: l_padding_type VARCHAR2(30);

Line 5296: FROM fnd_id_flex_structures fifst

5292: SELECT 'AFFFSSVB.pls : $Revision: 120.13.12010000.3 $ : get_kfv_sql' arcs_revision,
5293: fifst.concatenated_segment_delimiter
5294: INTO g_arcs_revision,
5295: l_delimiter
5296: FROM fnd_id_flex_structures fifst
5297: WHERE fifst.application_id = p_application_id
5298: AND fifst.id_flex_code = p_id_flex_code
5299: AND fifst.id_flex_num = p_id_flex_num;
5300:

Line 6250: l_id_flex_structure_code fnd_id_flex_structures.id_flex_structure_code%TYPE;

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);
6254: l_validation_type VARCHAR2(1000);

Line 6379: from fnd_id_flex_structures

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
6380: where application_id=p_application_id
6381: and id_flex_code=p_id_flex_code
6382: and id_flex_num=p_id_flex_num;
6383: