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_CONS_SEGMENT_MAP_PKG dependencies on GL_CONS_SEGMENT_MAP

Line 1: PACKAGE BODY GL_CONS_SEGMENT_MAP_PKG as

1: PACKAGE BODY GL_CONS_SEGMENT_MAP_PKG as
2: /* $Header: glicosrb.pls 120.7 2005/05/05 01:06:04 kvora ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Segment_Map_Id IN OUT NOCOPY NUMBER,

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: -- Issue check_duplicate_rules call from server instead of in client.
34:

Line 50: INSERT INTO gl_cons_segment_map(

46: OPEN C2;
47: FETCH C2 INTO X_Segment_Map_Id;
48: CLOSE C2;
49: end if;
50: INSERT INTO gl_cons_segment_map(
51: segment_map_id,
52: coa_mapping_id,
53: last_update_date,
54: last_updated_by,

Line 123: FROM gl_cons_segment_map

119: X_Parent_Rollup_Value VARCHAR2
120: ) IS
121: CURSOR C IS
122: SELECT *
123: FROM gl_cons_segment_map
124: WHERE rowid = X_Rowid
125: FOR UPDATE of Segment_Map_Id NOWAIT;
126: Recinfo C%ROWTYPE;
127: BEGIN

Line 236: UPDATE gl_cons_segment_map

232: -- DELETE FROM GL_CONS_FLEX_HIERARCHIES
233: -- WHERE segment_map_id = X_Segment_Map_Id;
234: -- END IF;
235:
236: UPDATE gl_cons_segment_map
237: SET
238:
239: segment_map_id = X_Segment_Map_Id,
240: coa_mapping_id = X_Coa_Mapping_Id,

Line 273: DELETE FROM gl_cons_segment_map

269: DELETE FROM GL_CONS_FLEX_HIERARCHIES
270: WHERE SEGMENT_MAP_ID = X_Segment_Map_Id;
271:
272:
273: DELETE FROM gl_cons_segment_map
274: WHERE rowid = X_Rowid;
275:
276: if (SQL%NOTFOUND) then
277: RAISE NO_DATA_FOUND;

Line 292: select 'x' from gl_cons_segment_map

288: X_From_Value_Set_Id NUMBER,
289: X_Segment_Map_Type VARCHAR2)
290: RETURN NUMBER IS
291: CURSOR DUPS1 IS
292: select 'x' from gl_cons_segment_map
293: where coa_mapping_id = X_Coa_Mapping_Id
294: and to_application_column_name = X_To_Application_Column_Name
295: and to_value_set_id = X_To_Value_Set_Id
296: and segment_map_type in ('S', 'C')

Line 300: select 'x' from gl_cons_segment_map

296: and segment_map_type in ('S', 'C')
297: and (rowid <> X_Rowid OR X_Rowid is NULL);
298:
299: CURSOR DUPS2 IS
300: select 'x' from gl_cons_segment_map
301: where coa_mapping_id = X_Coa_Mapping_id
302: and to_application_column_name = X_To_Application_Column_Name
303: and to_value_set_id = X_To_Value_Set_Id
304: and segment_map_type NOT IN ('S', 'C')

Line 313: from gl_cons_segment_map csm,

309: -- checked against detail ranges for overlaps in the second part of the union.
310: -- This only cathes overlaps with the same target specified.
311: CURSOR DUPS3 IS
312: select 'x'
313: from gl_cons_segment_map csm,
314: fnd_flex_value_hierarchies fvh_curr,
315: fnd_flex_value_hierarchies fvh_new
316: where coa_mapping_id = X_Coa_Mapping_id
317: and csm.to_application_column_name = X_To_Application_Column_Name

Line 342: gl_cons_segment_map csm,

338: and (csm.rowid <> X_Rowid OR X_Rowid is NULL)
339: UNION
340: select 'x'
341: from gl_cons_flex_hierarchies cfh,
342: gl_cons_segment_map csm,
343: fnd_flex_value_hierarchies fvh
344: where csm.segment_map_id = cfh.segment_map_id
345: and csm.coa_mapping_id = X_Coa_Mapping_id
346: and single_value = X_Single_Value

Line 373: from gl_cons_segment_map csm,

369: -- checked against detail ranges for overlaps in the second part of the union.
370: -- This will catch overlaps that go to separate targets.
371: CURSOR DUPS4 IS
372: select 'x'
373: from gl_cons_segment_map csm,
374: fnd_flex_value_hierarchies fvh_curr,
375: fnd_flex_value_hierarchies fvh_new
376: where coa_mapping_id = X_Coa_Mapping_id
377: and csm.to_application_column_name = X_To_Application_Column_Name

Line 401: gl_cons_segment_map csm,

397: and (csm.rowid <> X_Rowid OR X_Rowid is NULL)
398: UNION
399: select 'x'
400: from gl_cons_flex_hierarchies cfh,
401: gl_cons_segment_map csm,
402: fnd_flex_value_hierarchies fvh
403: where csm.segment_map_id = cfh.segment_map_id
404: and csm.coa_mapping_id = X_Coa_Mapping_id
405: and csm.to_application_column_name = X_To_Application_Column_Name

Line 499: FROM GL_CONS_SEGMENT_MAP

495: X_Parent_Rules_Present IN OUT NOCOPY VARCHAR2) IS
496:
497: CURSOR X_TYPE IS
498: SELECT 'Y'
499: FROM GL_CONS_SEGMENT_MAP
500: WHERE coa_mapping_id = X_Coa_Mapping_Id
501: AND segment_map_type IN ( 'U', 'V' );
502:
503: BEGIN

Line 516: END GL_CONS_SEGMENT_MAP_PKG;

512: CLOSE X_TYPE;
513: END IF;
514: END Check_Any_Parent_Rules;
515:
516: END GL_CONS_SEGMENT_MAP_PKG;