DBA Data[Home] [Help]

APPS.FND_FLEX_XML_PUBLISHER_APIS dependencies on FND_ID_FLEXS

Line 141: SUBTYPE kff_flx_type IS fnd_id_flexs%ROWTYPE;

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;
145:

Line 702: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,

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;
706: l_kff_flx kff_flx_type;

Line 741: FROM fnd_id_flexs fif

737: --
738: BEGIN
739: SELECT fif.*
740: INTO l_kff_flx
741: FROM fnd_id_flexs fif
742: WHERE fif.application_id = l_application.application_id
743: AND fif.id_flex_code = p_id_flex_code;
744: --
745: -- Create the cache value, and populate it with values came from DB.

Line 1877: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,

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
1881: BEGIN

Line 1889: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,

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)
1893: IS

Line 1902: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,

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,
1906: x_metadata OUT nocopy VARCHAR2)

Line 1916: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,

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,
1920: p_metadata_type IN VARCHAR2,

Line 2023: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,

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,
2027: p_segments IN VARCHAR2,

Line 2282: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,

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,
2286: p_segments IN VARCHAR2 DEFAULT 'ALL',

Line 2405: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,

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',
2409: p_operator IN VARCHAR2,

Line 2447: FROM fnd_columns,fnd_tables,fnd_id_flexs

2443: l_format_mask VARCHAR2(30);
2444: BEGIN
2445: SELECT fnd_columns.column_type
2446: INTO l_datatype
2447: FROM fnd_columns,fnd_tables,fnd_id_flexs
2448: WHERE fnd_columns.column_name = p_column_name
2449: AND fnd_columns.table_id = fnd_tables.table_id
2450: AND fnd_columns.application_id = fnd_tables.application_id
2451: AND fnd_tables.table_name = fnd_id_flexs.application_table_name

Line 2451: AND fnd_tables.table_name = fnd_id_flexs.application_table_name

2447: FROM fnd_columns,fnd_tables,fnd_id_flexs
2448: WHERE fnd_columns.column_name = p_column_name
2449: AND fnd_columns.table_id = fnd_tables.table_id
2450: AND fnd_columns.application_id = fnd_tables.application_id
2451: AND fnd_tables.table_name = fnd_id_flexs.application_table_name
2452: AND fnd_tables.application_id = fnd_id_flexs.table_application_id
2453: AND fnd_id_flexs.id_flex_code = l_kff_flx.id_flex_code
2454: AND fnd_id_flexs.application_id = l_kff_flx.application_id;
2455:

Line 2452: AND fnd_tables.application_id = fnd_id_flexs.table_application_id

2448: WHERE fnd_columns.column_name = p_column_name
2449: AND fnd_columns.table_id = fnd_tables.table_id
2450: AND fnd_columns.application_id = fnd_tables.application_id
2451: AND fnd_tables.table_name = fnd_id_flexs.application_table_name
2452: AND fnd_tables.application_id = fnd_id_flexs.table_application_id
2453: AND fnd_id_flexs.id_flex_code = l_kff_flx.id_flex_code
2454: AND fnd_id_flexs.application_id = l_kff_flx.application_id;
2455:
2456: p_bind_variable.name := p_lexical_name || p_bind_variable_num;

Line 2453: AND fnd_id_flexs.id_flex_code = l_kff_flx.id_flex_code

2449: AND fnd_columns.table_id = fnd_tables.table_id
2450: AND fnd_columns.application_id = fnd_tables.application_id
2451: AND fnd_tables.table_name = fnd_id_flexs.application_table_name
2452: AND fnd_tables.application_id = fnd_id_flexs.table_application_id
2453: AND fnd_id_flexs.id_flex_code = l_kff_flx.id_flex_code
2454: AND fnd_id_flexs.application_id = l_kff_flx.application_id;
2455:
2456: p_bind_variable.name := p_lexical_name || p_bind_variable_num;
2457:

Line 2454: AND fnd_id_flexs.application_id = l_kff_flx.application_id;

2450: AND fnd_columns.application_id = fnd_tables.application_id
2451: AND fnd_tables.table_name = fnd_id_flexs.application_table_name
2452: AND fnd_tables.application_id = fnd_id_flexs.table_application_id
2453: AND fnd_id_flexs.id_flex_code = l_kff_flx.id_flex_code
2454: AND fnd_id_flexs.application_id = l_kff_flx.application_id;
2455:
2456: p_bind_variable.name := p_lexical_name || p_bind_variable_num;
2457:
2458: SELECT flex_value_set_id

Line 2642: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,

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,
2646: p_segments IN VARCHAR2 DEFAULT 'ALL',