APPS.GL_CONS_SEGMENT_ACTIONS_PKG dependencies on GL_CONS_SEGMENT_MAP

Line 26: CURSOR C IS SELECT rowid FROM gl_cons_segment_map

22: X_Attribute5 VARCHAR2,
23: X_Context VARCHAR2,
24: X_Parent_Rollup_Value VARCHAR2
25: ) IS
26: CURSOR C IS SELECT rowid FROM gl_cons_segment_map
27:
28: WHERE segment_map_id = X_Segment_Map_Id;
29:
30: CURSOR C2 IS SELECT gl_cons_segment_map_s.nextval FROM dual;

Line 30: CURSOR C2 IS SELECT gl_cons_segment_map_s.nextval FROM dual;

26: CURSOR C IS SELECT rowid FROM gl_cons_segment_map
27:
28: WHERE segment_map_id = X_Segment_Map_Id;
29:
30: CURSOR C2 IS SELECT gl_cons_segment_map_s.nextval FROM dual;
31: BEGIN
32:
33: if (X_Segment_Map_Id is NULL) then
34: OPEN C2;

Line 38: INSERT INTO gl_cons_segment_map(

34: OPEN C2;
35: FETCH C2 INTO X_Segment_Map_Id;
36: CLOSE C2;
37: end if;
38: INSERT INTO gl_cons_segment_map(
39: segment_map_id,
40: coa_mapping_id,
41: last_update_date,
42: last_updated_by,

Line 96: FROM gl_cons_segment_map

92: X_Segment_Map_Id NUMBER
93: ) IS
94: CURSOR C IS
95: SELECT *
96: FROM gl_cons_segment_map
97: WHERE rowid = X_Rowid
98: FOR UPDATE of Segment_Map_Id NOWAIT;
99: Recinfo C%ROWTYPE;
100: BEGIN

Line 142: UPDATE gl_cons_segment_map

138: X_parent_rollup_value VARCHAR2
139: ) IS
140: BEGIN
141:
142: UPDATE gl_cons_segment_map
143: SET
144: segment_map_id = X_Segment_Map_Id,
145: coa_mapping_id = X_Coa_Mapping_Id,
146: last_update_date = X_Last_Update_Date,

Line 175: FROM GL_CONS_SEGMENT_MAP

171: BEGIN
172:
173: DELETE FROM GL_CONS_FLEX_HIERARCHIES
174: WHERE SEGMENT_MAP_ID IN ( SELECT segment_map_id
175: FROM GL_CONS_SEGMENT_MAP
176: WHERE coa_mapping_id = X_Coa_Mapping_id
177: AND to_application_column_name = X_to_application_column_name
178: );
179:

Line 180: DELETE FROM gl_cons_segment_map

176: WHERE coa_mapping_id = X_Coa_Mapping_id
177: AND to_application_column_name = X_to_application_column_name
178: );
179:
180: DELETE FROM gl_cons_segment_map
181: WHERE coa_mapping_id = X_Coa_Mapping_Id
182: AND to_application_column_name = X_to_application_column_name;
183:
184: --if (SQL%NOTFOUND) then

Line 199: select 'x' from gl_cons_segment_map

195: X_To_Value_Set_Id NUMBER,
196: X_From_Value_Set_Id NUMBER,
197: X_Segment_Map_Type VARCHAR2) IS
198: CURSOR DUPS1 IS
199: select 'x' from gl_cons_segment_map
200: where coa_mapping_id = X_Coa_Mapping_id
201: and to_application_column_name = X_To_Application_Column_Name
202: and to_value_set_id = X_To_Value_Set_Id
203: and segment_map_type in ('S', 'C')

Line 207: select 'x' from gl_cons_segment_map

203: and segment_map_type in ('S', 'C')
204: and (rowid <> X_Rowid OR X_Rowid is NULL);
205:
206: CURSOR DUPS2 IS
207: select 'x' from gl_cons_segment_map
208: where coa_mapping_id = X_Coa_Mapping_id
209: and to_application_column_name = X_To_Application_Column_Name
210: and to_value_set_id = X_To_Value_Set_Id
211: and segment_map_type NOT IN ('S', 'C')

Line 215: select 'x' from gl_cons_segment_map

211: and segment_map_type NOT IN ('S', 'C')
212: and (rowid <> X_Rowid OR X_Rowid is NULL);
213:
214: CURSOR DUPS3 IS
215: select 'x' from gl_cons_segment_map
216: where coa_mapping_id = X_Coa_Mapping_id
217: and to_application_column_name = X_To_Application_Column_Name
218: and to_value_set_id = X_To_Value_Set_Id
219: and single_value = X_Single_Value