DBA Data[Home] [Help]

APPS.GL_COA_SEG_VAL_IMP_PKG dependencies on FND_FLEX_HIERARCHIES

Line 252: CURSOR c_roll_up_group ( cp_flex_value_set_id IN fnd_flex_hierarchies.flex_value_set_id%TYPE,

248:
249: -- Carry out business validations
250: PROCEDURE validate_flex_values ( gl_coa_flex_values_rec IN OUT NOCOPY gl_coa_seg_val_imp_pub.gl_flex_values_rec_type ) AS
251: -- Cursor to validate the Roll up group information
252: CURSOR c_roll_up_group ( cp_flex_value_set_id IN fnd_flex_hierarchies.flex_value_set_id%TYPE,
253: cp_hierarchy_code IN fnd_flex_hierarchies.hierarchy_code%TYPE) IS
254: SELECT'X'
255: FROM fnd_flex_hierarchies
256: WHERE FLEX_VALUE_SET_ID =cp_flex_value_set_id

Line 253: cp_hierarchy_code IN fnd_flex_hierarchies.hierarchy_code%TYPE) IS

249: -- Carry out business validations
250: PROCEDURE validate_flex_values ( gl_coa_flex_values_rec IN OUT NOCOPY gl_coa_seg_val_imp_pub.gl_flex_values_rec_type ) AS
251: -- Cursor to validate the Roll up group information
252: CURSOR c_roll_up_group ( cp_flex_value_set_id IN fnd_flex_hierarchies.flex_value_set_id%TYPE,
253: cp_hierarchy_code IN fnd_flex_hierarchies.hierarchy_code%TYPE) IS
254: SELECT'X'
255: FROM fnd_flex_hierarchies
256: WHERE FLEX_VALUE_SET_ID =cp_flex_value_set_id
257: AND HIERARCHY_CODE =cp_hierarchy_code;

Line 255: FROM fnd_flex_hierarchies

251: -- Cursor to validate the Roll up group information
252: CURSOR c_roll_up_group ( cp_flex_value_set_id IN fnd_flex_hierarchies.flex_value_set_id%TYPE,
253: cp_hierarchy_code IN fnd_flex_hierarchies.hierarchy_code%TYPE) IS
254: SELECT'X'
255: FROM fnd_flex_hierarchies
256: WHERE FLEX_VALUE_SET_ID =cp_flex_value_set_id
257: AND HIERARCHY_CODE =cp_hierarchy_code;
258: rec_roll_up_group c_roll_up_group%ROWTYPE;
259:

Line 261: CURSOR c_flex_val_qual ( cp_flex_value_set_id IN fnd_flex_hierarchies.flex_value_set_id%TYPE,

257: AND HIERARCHY_CODE =cp_hierarchy_code;
258: rec_roll_up_group c_roll_up_group%ROWTYPE;
259:
260: -- Cursor to validate the flex qualifiers and to form appropriate compiled_value_attribute
261: CURSOR c_flex_val_qual ( cp_flex_value_set_id IN fnd_flex_hierarchies.flex_value_set_id%TYPE,
262: cp_id_flex_code IN fnd_flex_validation_qualifiers.id_flex_code%TYPE,
263: cp_id_flex_application_id IN fnd_flex_validation_qualifiers.id_flex_application_id%TYPE) IS
264: SELECT segment_attribute_type,value_attribute_type
265: FROM fnd_flex_validation_qualifiers