DBA Data[Home] [Help]

APPS.HXT_INTERFACE_UTILITIES dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 1852: RETURN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE

1848:
1849: FUNCTION element_flex_context_code (
1850: p_element_type_id IN pay_element_types_f.element_type_id%TYPE
1851: )
1852: RETURN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE
1853: IS
1854: l_proc proc_name;
1855:
1856: l_element_flex_context_code fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;

Line 1856: l_element_flex_context_code fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;

1852: RETURN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE
1853: IS
1854: l_proc proc_name;
1855:
1856: l_element_flex_context_code fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;
1857: BEGIN
1858: g_debug :=hr_utility.debug_enabled;
1859: if g_debug then
1860: l_proc := g_package

Line 2028: RETURN fnd_descr_flex_column_usages.end_user_column_name%TYPE

2024: FUNCTION ddf_input_value_name (
2025: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
2026: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
2027: )
2028: RETURN fnd_descr_flex_column_usages.end_user_column_name%TYPE
2029: AS
2030: l_proc proc_name;
2031:
2032:

Line 2034: p_context fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,

2030: l_proc proc_name;
2031:
2032:
2033: CURSOR csr_ddf_input_value_name (
2034: p_context fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE,
2035: p_field_name hxc_mapping_components.field_name%TYPE
2036: )
2037: IS
2038: SELECT fdfcu.end_user_column_name

Line 2039: FROM fnd_descr_flex_column_usages fdfcu,

2035: p_field_name hxc_mapping_components.field_name%TYPE
2036: )
2037: IS
2038: SELECT fdfcu.end_user_column_name
2039: FROM fnd_descr_flex_column_usages fdfcu,
2040: hxc_mapping_components mpc
2041: WHERE fdfcu.application_id = g_hxc_app_id
2042: AND fdfcu.descriptive_flexfield_name = g_otl_info_types_ddf
2043: AND fdfcu.descriptive_flex_context_code = p_context

Line 2047: l_ddf_input_value_name fnd_descr_flex_column_usages.end_user_column_name%TYPE;

2043: AND fdfcu.descriptive_flex_context_code = p_context
2044: AND fdfcu.application_column_name = mpc.SEGMENT
2045: AND UPPER (mpc.field_name) = UPPER (p_field_name);
2046:
2047: l_ddf_input_value_name fnd_descr_flex_column_usages.end_user_column_name%TYPE;
2048: BEGIN
2049: g_debug :=hr_utility.debug_enabled;
2050: if g_debug then
2051: l_proc := g_package

Line 2314: l_ddf_iv_name fnd_descr_flex_column_usages.end_user_column_name%TYPE;

2310: AS
2311: l_proc proc_name ;
2312: l_iv_table input_value_name_table;
2313: l_iv_tbl_idx PLS_INTEGER;
2314: l_ddf_iv_name fnd_descr_flex_column_usages.end_user_column_name%TYPE;
2315: l_iv_found BOOLEAN := FALSE;
2316: l_iv_seq PLS_INTEGER;
2317: BEGIN
2318: g_debug :=hr_utility.debug_enabled;