[Home] [Help]
136:
137: --
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;
623: --------------------------------------------------------------------------------
624: -- Returns Application details.
625: --------------------------------------------------------------------------------
626: PROCEDURE get_app
627: (p_application_short_name IN fnd_application.application_short_name%TYPE,
628: x_app OUT nocopy app_type)
629: IS
630: l_application app_type;
631: l_key VARCHAR2(2000);
658: --
659: BEGIN
660: SELECT fa.*
661: INTO l_application
662: FROM fnd_application fa
663: WHERE fa.application_short_name = p_application_short_name;
664: --
665: -- Create the cache value, and populate it with values came from DB.
666: --
697: --------------------------------------------------------------------------------
698: -- Returns Key Flexfield details.
699: --------------------------------------------------------------------------------
700: PROCEDURE get_kff_flx
701: (p_application_short_name IN fnd_application.application_short_name%TYPE,
702: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
703: x_kff_flx OUT nocopy kff_flx_type)
704: IS
705: l_application app_type;
1872:
1873: -- ======================================================================
1874: PROCEDURE kff_flexfield_metadata
1875: (p_lexical_name IN VARCHAR2,
1876: p_application_short_name IN fnd_application.application_short_name%TYPE,
1877: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
1878: p_metadata_type IN VARCHAR2,
1879: x_metadata OUT nocopy VARCHAR2)
1880: IS
1884:
1885: -- ======================================================================
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)
1897:
1898: -- ======================================================================
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,
1911:
1912: -- ======================================================================
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,
2018: -- KFF Combination Process API, version #1
2019: -- ======================================================================
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,
2277:
2278: -- ======================================================================
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,
2400:
2401: -- ======================================================================
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',
2637:
2638: -- ======================================================================
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,