APPS.GL_COA_SEG_VAL_IMP_PKG dependencies on FND_FLEX_VALUE_SETS

Line 27: CURSOR c_fnd_flex_values ( cp_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE) IS

23: TYPE flex_vl_set_id_tbl_type IS TABLE OF fnd_flex_values.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER;
24: flex_vl_set_id_tab flex_vl_set_id_tbl_type;
25:
26: --Cursor to verify that the Value set name passed is valid.
27: CURSOR c_fnd_flex_values ( cp_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE) IS
28: SELECT ffvs.rowid,ffvs.*
29: FROM FND_FLEX_VALUE_SETS ffvs
30: WHERE FLEX_VALUE_SET_NAME = cp_flex_value_set_name;
31:

Line 29: FROM FND_FLEX_VALUE_SETS ffvs

25:
26: --Cursor to verify that the Value set name passed is valid.
27: CURSOR c_fnd_flex_values ( cp_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE) IS
28: SELECT ffvs.rowid,ffvs.*
29: FROM FND_FLEX_VALUE_SETS ffvs
30: WHERE FLEX_VALUE_SET_NAME = cp_flex_value_set_name;
31:
32: l_cur_co c_fnd_flex_values%ROWTYPE;
33:

Line 198: CURSOR c_fnd_flex_value_nh_exists(cp_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE,

194:
195: -- Assign default values to the parameters passed.
196: PROCEDURE assign_defaults ( gl_coa_flex_values_rec IN OUT NOCOPY gl_coa_seg_val_imp_pub.gl_flex_values_rec_type, p_insert IN VARCHAR2) IS
197: -- Cursor to check if child ranges exist for the flex value passed
198: CURSOR c_fnd_flex_value_nh_exists(cp_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE,
199: cp_parent_flex_value fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE ) IS
200: SELECT 'X'
201: FROM fnd_flex_value_norm_hierarchy
202: WHERE flex_value_set_id = cp_flex_value_set_id

Line 710: CURSOR c_fnd_flex_value_nh_exists(cp_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE

706: END trim_values;
707:
708: PROCEDURE validate_derivations ( gl_coa_flex_values_nh_rec IN OUT NOCOPY gl_coa_seg_val_imp_pub.gl_flex_values_nh_rec_type, p_nh_exists OUT BOOLEAN ) AS
709: --Cursor to check if child ranges already exist
710: CURSOR c_fnd_flex_value_nh_exists(cp_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE
711: /*DRM Removed: ,cp_parent_flex_value fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE*/
712: ) IS
713: SELECT 'X'
714: FROM fnd_flex_value_norm_hierarchy

Line 779: CURSOR c_fnd_flex_value_exists(cp_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE,

775:
776: -- Validate Database Constraints
777: PROCEDURE validate_db_cons (gl_coa_flex_values_nh_rec IN OUT NOCOPY gl_coa_seg_val_imp_pub.gl_flex_values_nh_rec_type ) AS
778: --Cursor to validate the parent flex value
779: CURSOR c_fnd_flex_value_exists(cp_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE,
780: cp_parent_flex_value fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE ) IS
781: SELECT summary_flag
782: FROM fnd_flex_values
783: WHERE flex_value_set_id = cp_flex_value_set_id