APPS.HXT_INTERFACE_UTILITIES dependencies on FND_ID_FLEX_SEGMENTS

Line 3063: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,

3059: RETURN l_cost_allocation_structure_id;
3060: END cost_flex_structure_id;
3061:
3062: FUNCTION costflex_value (
3063: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
3064: p_segment_name IN fnd_id_flex_segments.application_column_name%TYPE,
3065: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE
3066: DEFAULT g_independant,
3067: p_flex_value_id IN hxc_time_attributes.attribute1%TYPE

Line 3064: p_segment_name IN fnd_id_flex_segments.application_column_name%TYPE,

3060: END cost_flex_structure_id;
3061:
3062: FUNCTION costflex_value (
3063: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
3064: p_segment_name IN fnd_id_flex_segments.application_column_name%TYPE,
3065: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE
3066: DEFAULT g_independant,
3067: p_flex_value_id IN hxc_time_attributes.attribute1%TYPE
3068: )

Line 3074: p_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE,

3070: IS
3071: l_proc proc_name ;
3072:
3073: CURSOR csr_flex_value (
3074: p_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE,
3075: p_segment_name fnd_id_flex_segments.application_column_name%TYPE,
3076: p_validation_type fnd_flex_value_sets.validation_type%TYPE,
3077: p_flex_value_id fnd_flex_values.flex_value_id%TYPE
3078: )

Line 3075: p_segment_name fnd_id_flex_segments.application_column_name%TYPE,

3071: l_proc proc_name ;
3072:
3073: CURSOR csr_flex_value (
3074: p_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE,
3075: p_segment_name fnd_id_flex_segments.application_column_name%TYPE,
3076: p_validation_type fnd_flex_value_sets.validation_type%TYPE,
3077: p_flex_value_id fnd_flex_values.flex_value_id%TYPE
3078: )
3079: IS

Line 3081: FROM fnd_id_flex_segments fifs,

3077: p_flex_value_id fnd_flex_values.flex_value_id%TYPE
3078: )
3079: IS
3080: SELECT ffv.flex_value
3081: FROM fnd_id_flex_segments fifs,
3082: fnd_flex_value_sets ffvs,
3083: fnd_flex_values ffv
3084: WHERE fifs.application_id = g_pay_app_id
3085: AND fifs.id_flex_code = g_cost_flex_code