APPS.GL_CONS_FLEX_HIER_PKG dependencies on GL_CONS_FLEX_HIERARCHIES

Line 23: FROM gl_cons_flex_hierarchies cfh, gl_cons_segment_map csm

19: ) RETURN NUMBER IS
20:
21: -- The first cursor catches overlaps to the same target
22: CURSOR C1 IS SELECT 'Overlaps'
23: FROM gl_cons_flex_hierarchies cfh, gl_cons_segment_map csm
24: WHERE csm.coa_mapping_id = X_Coa_Mapping_Id
25: AND csm.single_value = X_Parent_Flex_Value
26: AND csm.to_value_set_id = X_To_Value_Set_Id
27: AND csm.from_value_set_id = X_From_Value_Set_Id

Line 71: FROM gl_cons_flex_hierarchies cfh, gl_cons_segment_map csm

67: ;
68:
69: -- The second cursor catches overlaps to different targets
70: CURSOR C2 IS SELECT 'Overlaps'
71: FROM gl_cons_flex_hierarchies cfh, gl_cons_segment_map csm
72: WHERE csm.coa_mapping_id = X_Coa_Mapping_Id
73: AND csm.to_value_set_id = X_To_Value_Set_Id
74: AND csm.from_value_set_id = X_From_Value_Set_Id
75: AND csm.to_application_column_name = X_to_application_column_name

Line 141: CURSOR C2 IS SELECT '1' FROM gl_cons_flex_hierarchies

137: END Overlap;
138:
139: PROCEDURE Count_Ranges(X_Segment_Map_Id NUMBER) IS
140:
141: CURSOR C2 IS SELECT '1' FROM gl_cons_flex_hierarchies
142: WHERE segment_map_id = X_Segment_Map_Id;
143:
144: Range_Count VARCHAR2(2);
145:

Line 173: CURSOR C IS SELECT rowid FROM gl_cons_flex_hierarchies

169: X_Attribute4 VARCHAR2,
170: X_Attribute5 VARCHAR2,
171: X_Context VARCHAR2
172: ) IS
173: CURSOR C IS SELECT rowid FROM gl_cons_flex_hierarchies
174:
175: WHERE segment_map_id = X_Segment_Map_Id;
176: CURSOR C2 IS SELECT gl_cons_segment_map_s.nextval FROM dual;
177: BEGIN

Line 185: INSERT INTO gl_cons_flex_hierarchies(

181: FETCH C2 INTO X_Segment_Map_Id;
182: CLOSE C2;
183: end if;
184:
185: INSERT INTO gl_cons_flex_hierarchies(
186: segment_map_id,
187: parent_flex_value,
188: child_flex_value_low,
189: child_flex_value_high,

Line 247: FROM gl_cons_flex_hierarchies

243: X_Context VARCHAR2
244: ) IS
245: CURSOR C IS
246: SELECT *
247: FROM gl_cons_flex_hierarchies
248: WHERE rowid = X_Rowid
249: FOR UPDATE of Segment_Map_Id NOWAIT;
250: Recinfo C%ROWTYPE;
251: BEGIN

Line 343: UPDATE gl_cons_flex_hierarchies

339: -- X_To_Value_Set_Id,
340: -- X_Segment_Map_Type );
341: --
342:
343: UPDATE gl_cons_flex_hierarchies
344: SET
345:
346: segment_map_id = X_Segment_Map_Id,
347: parent_flex_value = X_Parent_Flex_Value,

Line 378: UPDATE gl_cons_flex_hierarchies

374: X_Last_Update_Login NUMBER
375: ) IS
376: BEGIN
377:
378: UPDATE gl_cons_flex_hierarchies
379: SET
380: parent_flex_value = X_Parent_Flex_Value,
381: last_update_date = X_Last_Update_Date,
382: last_updated_by = X_Last_Updated_By,

Line 396: --DELETE FROM GL_CONS_FLEX_HIERARCHIES

392: PROCEDURE Delete_Row(X_Rowid VARCHAR2, X_Segment_Map_Id NUMBER ) IS
393: BEGIN
394:
395: --Previously from Pre-Delete
396: --DELETE FROM GL_CONS_FLEX_HIERARCHIES
397: --WHERE SEGMENT_MAP_ID = X_Segment_Map_Id;
398:
399:
400: DELETE FROM gl_cons_flex_hierarchies

Line 400: DELETE FROM gl_cons_flex_hierarchies

396: --DELETE FROM GL_CONS_FLEX_HIERARCHIES
397: --WHERE SEGMENT_MAP_ID = X_Segment_Map_Id;
398:
399:
400: DELETE FROM gl_cons_flex_hierarchies
401: WHERE rowid = X_Rowid;
402:
403: if (SQL%NOTFOUND) then
404: RAISE NO_DATA_FOUND;