DBA Data[Home] [Help]

APPS.FND_FLEX_XML_PUBLISHER_APIS dependencies on FND_ID_FLEX_STRUCTURES

Line 142: SUBTYPE kff_str_type IS fnd_id_flex_structures%ROWTYPE;

138: -- TYPEs
139: --
140: SUBTYPE app_type IS fnd_application%ROWTYPE;
141: SUBTYPE kff_flx_type IS fnd_id_flexs%ROWTYPE;
142: SUBTYPE kff_str_type IS fnd_id_flex_structures%ROWTYPE;
143: SUBTYPE kff_seg_type IS fnd_id_flex_segments%ROWTYPE;
144: SUBTYPE kff_seg_tl_type IS fnd_id_flex_segments_tl%ROWTYPE;
145:
146: TYPE varchar2_30_array_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line 822: FROM fnd_id_flex_structures fifst

818: l_numof_structures := l_numof_values;
819: ELSE
820: SELECT fifst.id_flex_num
821: BULK COLLECT INTO l_structure_numbers
822: FROM fnd_id_flex_structures fifst
823: WHERE fifst.application_id = p_kff_flx.application_id
824: AND fifst.id_flex_code = p_kff_flx.id_flex_code
825: AND fifst.enabled_flag = 'Y'
826: AND fifst.freeze_flex_definition_flag = 'Y'

Line 874: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,

870: -- Returns KFF Structure
871: --------------------------------------------------------------------------------
872: PROCEDURE get_kff_str
873: (p_kff_flx IN kff_flx_type,
874: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,
875: x_kff_str OUT nocopy kff_str_type)
876: IS
877: l_key VARCHAR2(2000);
878: l_return_code VARCHAR2(1);

Line 912: FROM fnd_id_flex_structures fifst

908: --
909: BEGIN
910: SELECT fifst.*
911: INTO l_kff_str
912: FROM fnd_id_flex_structures fifst
913: WHERE fifst.application_id = p_kff_flx.application_id
914: AND fifst.id_flex_code = p_kff_flx.id_flex_code
915: AND fifst.id_flex_num = p_id_flex_num;
916: --

Line 1890: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,

1886: PROCEDURE kff_structure_metadata
1887: (p_lexical_name IN VARCHAR2,
1888: p_application_short_name IN fnd_application.application_short_name%TYPE,
1889: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
1890: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,
1891: p_metadata_type IN VARCHAR2,
1892: x_metadata OUT nocopy VARCHAR2)
1893: IS
1894: BEGIN

Line 1903: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,

1899: PROCEDURE kff_segment_metadata
1900: (p_lexical_name IN VARCHAR2,
1901: p_application_short_name IN fnd_application.application_short_name%TYPE,
1902: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
1903: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,
1904: p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
1905: p_metadata_type IN VARCHAR2,
1906: x_metadata OUT nocopy VARCHAR2)
1907: IS

Line 1917: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,

1913: PROCEDURE kff_segments_metadata
1914: (p_lexical_name IN VARCHAR2,
1915: p_application_short_name IN fnd_application.application_short_name%TYPE,
1916: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
1917: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,
1918: p_segments IN VARCHAR2,
1919: p_show_parent_segments IN VARCHAR2,
1920: p_metadata_type IN VARCHAR2,
1921: x_metadata OUT nocopy VARCHAR2)

Line 2024: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,

2020: FUNCTION process_kff_combination_1
2021: (p_lexical_name IN VARCHAR2,
2022: p_application_short_name IN fnd_application.application_short_name%TYPE,
2023: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
2024: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,
2025: p_data_set IN fnd_id_flex_structures.id_flex_num%TYPE,
2026: p_ccid IN NUMBER,
2027: p_segments IN VARCHAR2,
2028: p_show_parent_segments IN VARCHAR2,

Line 2025: p_data_set IN fnd_id_flex_structures.id_flex_num%TYPE,

2021: (p_lexical_name IN VARCHAR2,
2022: p_application_short_name IN fnd_application.application_short_name%TYPE,
2023: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
2024: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,
2025: p_data_set IN fnd_id_flex_structures.id_flex_num%TYPE,
2026: p_ccid IN NUMBER,
2027: p_segments IN VARCHAR2,
2028: p_show_parent_segments IN VARCHAR2,
2029: p_output_type IN VARCHAR2)

Line 2283: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE DEFAULT 101,

2279: PROCEDURE kff_select
2280: (p_lexical_name IN VARCHAR2,
2281: p_application_short_name IN fnd_application.application_short_name%TYPE,
2282: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
2283: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE DEFAULT 101,
2284: p_multiple_id_flex_num IN VARCHAR2 DEFAULT 'N',
2285: p_code_combination_table_alias IN VARCHAR2 DEFAULT NULL,
2286: p_segments IN VARCHAR2 DEFAULT 'ALL',
2287: p_show_parent_segments IN VARCHAR2 DEFAULT 'Y',

Line 2406: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,

2402: PROCEDURE kff_where
2403: (p_lexical_name IN VARCHAR2,
2404: p_application_short_name IN fnd_application.application_short_name%TYPE,
2405: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
2406: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,
2407: p_code_combination_table_alias IN VARCHAR2 DEFAULT NULL,
2408: p_segments IN VARCHAR2 DEFAULT 'ALL',
2409: p_operator IN VARCHAR2,
2410: p_operand1 IN VARCHAR2,

Line 2643: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE DEFAULT 101,

2639: PROCEDURE kff_order_by
2640: (p_lexical_name IN VARCHAR2,
2641: p_application_short_name IN fnd_application.application_short_name%TYPE,
2642: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
2643: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE DEFAULT 101,
2644: p_multiple_id_flex_num IN VARCHAR2 DEFAULT 'N',
2645: p_code_combination_table_alias IN VARCHAR2 DEFAULT NULL,
2646: p_segments IN VARCHAR2 DEFAULT 'ALL',
2647: p_show_parent_segments IN VARCHAR2 DEFAULT 'Y',