APPS.FND_FLEX_SERVER dependencies on FND_ID_FLEX_STRUCTURES

Line 5288: l_id_flex_structure_code fnd_id_flex_structures.id_flex_structure_code%TYPE;

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

Line 5301: FROM fnd_id_flex_structures

5297: SELECT 'AFFFSSVB.pls : $Revision: 120.28.12020000.2 $ : raise_kff_structure_compiled' arcs_revision,
5298: id_flex_structure_code
5299: INTO g_arcs_revision,
5300: l_id_flex_structure_code
5301: FROM fnd_id_flex_structures
5302: WHERE application_id = p_application_id
5303: AND id_flex_code = p_id_flex_code
5304: AND id_flex_num = p_id_flex_num;
5305:

Line 5446: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;

5442: px_kfvssc_record IN OUT nocopy kfvssc_record_type)
5443: IS
5444: l_kfvcct_record kfvcct_record_type;
5445:
5446: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
5447:
5448: l_compact_concat VARCHAR2(32000);
5449: l_padded_concat VARCHAR2(32000);
5450: l_padding_type VARCHAR2(30);

Line 5489: FROM fnd_id_flex_structures fifst

5485: SELECT 'AFFFSSVB.pls : $Revision: 120.28.12020000.2 $ : get_kfv_sql' arcs_revision,
5486: fifst.concatenated_segment_delimiter
5487: INTO g_arcs_revision,
5488: l_delimiter
5489: FROM fnd_id_flex_structures fifst
5490: WHERE fifst.application_id = p_application_id
5491: AND fifst.id_flex_code = p_id_flex_code
5492: AND fifst.id_flex_num = p_id_flex_num;
5493:

Line 6443: l_id_flex_structure_code fnd_id_flex_structures.id_flex_structure_code%TYPE;

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

Line 6572: from fnd_id_flex_structures

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
6573: where application_id=p_application_id
6574: and id_flex_code=p_id_flex_code
6575: and id_flex_num=p_id_flex_num;
6576: