DBA Data[Home] [Help]

APPS.HXT_INTERFACE_UTILITIES dependencies on FND_ID_FLEX_SEGMENTS

Line 3134: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,

3130: RETURN l_cost_allocation_structure_id;
3131: END cost_flex_structure_id;
3132:
3133: FUNCTION costflex_value (
3134: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
3135: p_segment_name IN fnd_id_flex_segments.application_column_name%TYPE,
3136: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE
3137: DEFAULT g_independant,
3138: p_flex_value_id IN hxc_time_attributes.attribute1%TYPE

Line 3135: p_segment_name IN fnd_id_flex_segments.application_column_name%TYPE,

3131: END cost_flex_structure_id;
3132:
3133: FUNCTION costflex_value (
3134: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
3135: p_segment_name IN fnd_id_flex_segments.application_column_name%TYPE,
3136: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE
3137: DEFAULT g_independant,
3138: p_flex_value_id IN hxc_time_attributes.attribute1%TYPE
3139: )

Line 3152: p_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE,

3148: -- to pass thru, because the calling code never passes any type parameter.
3149:
3150:
3151: CURSOR csr_flex_value (
3152: p_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE,
3153: p_segment_name fnd_id_flex_segments.application_column_name%TYPE,
3154: p_validation_type fnd_flex_value_sets.validation_type%TYPE,
3155: p_flex_value_id fnd_flex_values.flex_value_id%TYPE
3156: )

Line 3153: p_segment_name fnd_id_flex_segments.application_column_name%TYPE,

3149:
3150:
3151: CURSOR csr_flex_value (
3152: p_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE,
3153: p_segment_name fnd_id_flex_segments.application_column_name%TYPE,
3154: p_validation_type fnd_flex_value_sets.validation_type%TYPE,
3155: p_flex_value_id fnd_flex_values.flex_value_id%TYPE
3156: )
3157: IS

Line 3159: FROM fnd_id_flex_segments fifs,

3155: p_flex_value_id fnd_flex_values.flex_value_id%TYPE
3156: )
3157: IS
3158: SELECT ffv.flex_value
3159: FROM fnd_id_flex_segments fifs,
3160: fnd_flex_value_sets ffvs,
3161: fnd_flex_values ffv
3162: WHERE fifs.application_id = g_pay_app_id
3163: AND fifs.id_flex_code = g_cost_flex_code