eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_COA_SEG_VAL_IMP_PKG dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 199: cp_parent_flex_value fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE ) IS

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
203: AND parent_flex_value = cp_parent_flex_value;

Line 201: FROM fnd_flex_value_norm_hierarchy

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
203: AND parent_flex_value = cp_parent_flex_value;
204:
205: rec_fnd_flex_value_nh_exists c_fnd_flex_value_nh_exists%ROWTYPE;

Line 235: DELETE FROM FND_FLEX_VALUE_NORM_HIERARCHY WHERE FLEX_VALUE_SET_ID = l_cur_co.flex_value_set_id AND PARENT_FLEX_VALUE = gl_coa_flex_values_rec.flex_value;

231: IF c_fnd_flex_value_nh_exists%NOTFOUND THEN
232: CLOSE c_fnd_flex_value_nh_exists;
233: ELSE
234: CLOSE c_fnd_flex_value_nh_exists;
235: DELETE FROM FND_FLEX_VALUE_NORM_HIERARCHY WHERE FLEX_VALUE_SET_ID = l_cur_co.flex_value_set_id AND PARENT_FLEX_VALUE = gl_coa_flex_values_rec.flex_value;
236: END IF;
237: END IF;
238:
239: --Default enabled_flag to the db value

Line 711: /DRM Removed: ,cp_parent_flex_value fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE/

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
715: WHERE flex_value_set_id = cp_flex_value_set_id;

Line 714: FROM fnd_flex_value_norm_hierarchy

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
715: WHERE flex_value_set_id = cp_flex_value_set_id;
716: /*DRM Removed: AND parent_flex_value = cp_parent_flex_value;*/
717:
718: rec_fnd_flex_value_nh_exists c_fnd_flex_value_nh_exists%ROWTYPE;

Line 780: cp_parent_flex_value fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE ) IS

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
784: AND flex_value = cp_parent_flex_value;

Line 870: --Business Validations for the fnd_flex_value_norm_hierarchy entities

866: validate_db_cons (p_gl_flex_values_nh_tbl(I));
867: END IF;
868: END IF;
869:
870: --Business Validations for the fnd_flex_value_norm_hierarchy entities
871: IF p_gl_flex_values_nh_tbl(I).status = 'S' THEN
872: -- DRM Change: Conditional validation
873: IF p_validation_level = FND_API.g_valid_level_full THEN
874: validate_nh ( p_gl_flex_values_nh_tbl(I) );

Line 885: -- DELETE fnd_flex_value_norm_hierarchy

881: --THEN
882: -- IF l_nh_exists
883: -- THEN
884: -- flex_vl_set_id_del_tab(flex_vl_set_id_del_tab.count+1) := l_cur_co.flex_value_set_id;
885: -- DELETE fnd_flex_value_norm_hierarchy
886: -- WHERE flex_value_set_id = l_cur_co.flex_value_set_id
887: -- AND parent_flex_value = p_gl_flex_values_nh_tbl(I).parent_flex_value;
888: -- END IF;
889: --ELSE

Line 895: DELETE FROM fnd_flex_value_norm_hierarchy

891: THEN
892: -- IF l_nh_exists
893: -- THEN
894: flex_vl_set_id_del_tab(flex_vl_set_id_del_tab.count+1) := l_cur_co.flex_value_set_id;
895: DELETE FROM fnd_flex_value_norm_hierarchy
896: WHERE flex_value_set_id =l_cur_co.flex_value_set_id;
897: -- AND parent_flex_value =p_gl_flex_values_nh_tbl(I).parent_flex_value;
898: -- END IF;
899: END IF;

Line 918: UPDATE fnd_flex_value_norm_hierarchy

914: p_last_update_date => NULL,
915: p_start_date_active => NULL,
916: p_end_date_active => NULL);
917: ---As approved by Flex Dev team in the bug 13345598
918: UPDATE fnd_flex_value_norm_hierarchy
919: SET last_update_date = sysdate,
920: last_updated_by = g_n_user_id,
921: created_by = g_n_user_id,
922: creation_date = sysdate,