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_FLATTEN_SEG_VAL_HIERARCHIES dependencies on GL_FLATTEN_SETUP_DATA

Line 59: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

55:
56:
57: -- Clean Norm Table before processing
58:
59: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
60: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
61: token_num => 2,
62: t1 =>'ROUTINE',
63: v1 =>

Line 78: AND flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;

74:
75: DELETE
76: FROM GL_SEG_VAL_NORM_HIERARCHY
77: WHERE status_code = l_status_flag
78: AND flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;
79:
80: l_no_rows := NVL(SQL%ROWCOUNT,0);
81: GL_MESSAGE.Write_Log(msg_name =>'SHRD0119',
82: token_num =>2,

Line 88: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

84: v1 => TO_CHAR(l_no_rows),
85: t2 =>'TABLE',
86: v2 =>'GL_SEG_VAL_NORM_HIERARCHY');
87:
88: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
89: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
90: token_num => 2,
91: t1 =>'ROUTINE',
92: v1 =>

Line 103: AND flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;

99:
100: UPDATE GL_SEG_VAL_NORM_HIERARCHY
101: SET status_code = NULL
102: WHERE status_code ='D'
103: AND flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;
104:
105: l_no_rows := NVL(SQL%ROWCOUNT,0);
106: GL_MESSAGE.Write_Log(msg_name =>'SHRD0118',
107: token_num =>2,

Line 116: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

112:
113:
114: -- Clean Flattened table before processing
115:
116: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
117: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
118: token_num => 2,
119: t1 =>'ROUTINE',
120: v1 =>

Line 134: AND flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;

130:
131: DELETE
132: FROM GL_SEG_VAL_HIERARCHIES
133: WHERE status_code = l_status_flag
134: AND flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;
135:
136: l_no_rows := NVL(SQL%ROWCOUNT,0);
137: GL_MESSAGE.Write_Log(msg_name =>'SHRD0119',
138: token_num =>2,

Line 144: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

140: v1 => TO_CHAR(l_no_rows),
141: t2 =>'TABLE',
142: v2 =>'GL_SEG_VAL_HIERARCHIES');
143:
144: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
145: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
146: token_num => 2,
147: t1 =>'ROUTINE',
148: v1 =>

Line 159: AND flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;

155:
156: UPDATE GL_SEG_VAL_HIERARCHIES
157: SET status_code = NULL
158: WHERE status_code ='D'
159: AND flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;
160:
161: l_no_rows := NVL(SQL%ROWCOUNT,0);
162: GL_MESSAGE.Write_Log(msg_name =>'SHRD0118',
163: token_num =>2,

Line 187: AND fifs.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID)

183: (SELECT 1
184: FROM FND_ID_FLEX_SEGMENTS fifs
185: WHERE fifs.application_id = 101
186: AND fifs.id_flex_code = 'GL#'
187: AND fifs.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID)
188: OR EXISTS
189: (SELECT 1
190: FROM FND_FLEX_VALUE_NORM_HIERARCHY ffvnh
191: WHERE ffvnh.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

Line 191: WHERE ffvnh.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

187: AND fifs.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID)
188: OR EXISTS
189: (SELECT 1
190: FROM FND_FLEX_VALUE_NORM_HIERARCHY ffvnh
191: WHERE ffvnh.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
192: AND ROWNUM = 1);
193:
194: EXCEPTION
195:

Line 212: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

208: glsvh.summary_flag =
209: (SELECT DISTINCT ffv.summary_flag
210: FROM FND_FLEX_VALUES ffv
211: WHERE ffv.flex_value_set_id =
212: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
213: AND ffv.flex_value = glsvh.child_flex_value)
214: WHERE glsvh.flex_value_set_id =
215: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
216: AND glsvh.parent_flex_value = 'T'

Line 215: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

211: WHERE ffv.flex_value_set_id =
212: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
213: AND ffv.flex_value = glsvh.child_flex_value)
214: WHERE glsvh.flex_value_set_id =
215: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
216: AND glsvh.parent_flex_value = 'T'
217: AND glsvh.child_flex_value IN
218: (SELECT ffv2.flex_value
219: FROM FND_FLEX_VALUES ffv2

Line 243: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,

239: summary_flag, status_code, created_by, creation_date,
240: last_updated_by, last_update_login, last_update_date)
241: (SELECT DISTINCT ffv.flex_value_set_id, 'T', ffv.flex_value,
242: ffv.summary_flag, 'I',
243: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
244: SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
245: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
246: SYSDATE
247: FROM FND_FLEX_VALUES ffv

Line 244: SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,

240: last_updated_by, last_update_login, last_update_date)
241: (SELECT DISTINCT ffv.flex_value_set_id, 'T', ffv.flex_value,
242: ffv.summary_flag, 'I',
243: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
244: SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
245: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
246: SYSDATE
247: FROM FND_FLEX_VALUES ffv
248: WHERE ffv.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

Line 245: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,

241: (SELECT DISTINCT ffv.flex_value_set_id, 'T', ffv.flex_value,
242: ffv.summary_flag, 'I',
243: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
244: SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
245: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
246: SYSDATE
247: FROM FND_FLEX_VALUES ffv
248: WHERE ffv.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
249: AND NOT EXISTS

Line 248: WHERE ffv.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

244: SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
245: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
246: SYSDATE
247: FROM FND_FLEX_VALUES ffv
248: WHERE ffv.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
249: AND NOT EXISTS
250: (SELECT 1
251: FROM GL_SEG_VAL_HIERARCHIES glsvh
252: WHERE glsvh.flex_value_set_id =

Line 277: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_VS_TAB_NAME IS NOT NULL) THEN

273: -- stored in the user defined table. So the above statement takes
274: -- care of all parent values and the following DYNAMIC SQL statement
275: -- inserts all detail records into GL_SEG_VAL_HIERARCHIES table.
276:
277: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_VS_TAB_NAME IS NOT NULL) THEN
278:
279: l_no_rows := 0;
280: add_table := GL_FLATTEN_SETUP_DATA.GLSTFL_VS_TAB_NAME;
281: column_name := GL_FLATTEN_SETUP_DATA.GLSTFL_VS_COL_NAME;

Line 280: add_table := GL_FLATTEN_SETUP_DATA.GLSTFL_VS_TAB_NAME;

276:
277: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_VS_TAB_NAME IS NOT NULL) THEN
278:
279: l_no_rows := 0;
280: add_table := GL_FLATTEN_SETUP_DATA.GLSTFL_VS_TAB_NAME;
281: column_name := GL_FLATTEN_SETUP_DATA.GLSTFL_VS_COL_NAME;
282:
283: sqlbuf := 'INSERT INTO GL_SEG_VAL_HIERARCHIES
284: (flex_value_set_id, parent_flex_value,

Line 281: column_name := GL_FLATTEN_SETUP_DATA.GLSTFL_VS_COL_NAME;

277: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_VS_TAB_NAME IS NOT NULL) THEN
278:
279: l_no_rows := 0;
280: add_table := GL_FLATTEN_SETUP_DATA.GLSTFL_VS_TAB_NAME;
281: column_name := GL_FLATTEN_SETUP_DATA.GLSTFL_VS_COL_NAME;
282:
283: sqlbuf := 'INSERT INTO GL_SEG_VAL_HIERARCHIES
284: (flex_value_set_id, parent_flex_value,
285: child_flex_value, summary_flag,

Line 307: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

303: = ''T''
304: AND glsvh.child_flex_value
305: = tv.'||column_name|| ' ))';
306:
307: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
308:
309: l_sql_stmt := LENGTH(sqlbuf);
310:
311:

Line 321: v3 => GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID);

317: 'GL_FLATTEN_SEG_VAL_HIERARCHIES.Flatten_Seg_Val_Hier()',
318: t2 =>'VARIABLE',
319: v2 =>'Value_Set_Id',
320: t3 =>'VALUE',
321: v3 => GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID);
322:
323: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
324: token_num => 3 ,
325: t1 =>'ROUTINE',

Line 341: v3 => GL_FLATTEN_SETUP_DATA.GLSTFL_VS_COL_NAME);

337: 'GL_FLATTEN_SEG_VAL_HIERARCHIES.Flatten_Seg_Val_Hier()',
338: t2 =>'VARIABLE',
339: v2 =>'Column Name',
340: t3 =>'VALUE',
341: v3 => GL_FLATTEN_SETUP_DATA.GLSTFL_VS_COL_NAME);
342:
343: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
344: token_num => 3 ,
345: t1 =>'ROUTINE',

Line 376: USING GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID,

372:
373: END IF;
374:
375: EXECUTE IMMEDIATE sqlbuf
376: USING GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID,
377: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
378: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
379: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
380: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;

Line 377: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,

373: END IF;
374:
375: EXECUTE IMMEDIATE sqlbuf
376: USING GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID,
377: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
378: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
379: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
380: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;
381:

Line 378: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,

374:
375: EXECUTE IMMEDIATE sqlbuf
376: USING GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID,
377: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
378: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
379: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
380: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;
381:
382: IF (SQL%FOUND) OR (Is_Seg_Hier_Changed) THEN

Line 379: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,

375: EXECUTE IMMEDIATE sqlbuf
376: USING GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID,
377: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
378: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
379: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
380: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;
381:
382: IF (SQL%FOUND) OR (Is_Seg_Hier_Changed) THEN
383: Is_Seg_Hier_Changed := TRUE;

Line 380: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;

376: USING GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID,
377: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
378: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
379: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
380: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;
381:
382: IF (SQL%FOUND) OR (Is_Seg_Hier_Changed) THEN
383: Is_Seg_Hier_Changed := TRUE;
384: END IF;

Line 525: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID);

521: (SELECT 1
522: FROM GL_SEG_VAL_HIERARCHIES
523: WHERE status_code = 'I'
524: AND flex_value_set_id =
525: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID);
526:
527: IF (l_no_rows = 1) THEN
528: Is_Norm_Table_Changed := TRUE;
529: ELSE

Line 536: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

532:
533: --Reset the number of rows variable.
534: l_no_rows := 0;
535:
536: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
537: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
538: token_num => 2,
539: t1 =>'ROUTINE',
540: v1 =>

Line 554: WHERE glsvnh.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

550: -- value mappings in the table GL_SEG_VAL_NORM_HIERARCHY
551:
552: UPDATE GL_SEG_VAL_NORM_HIERARCHY glsvnh
553: SET glsvnh.status_code = 'D'
554: WHERE glsvnh.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
555: AND
556: (NOT EXISTS
557: (SELECT 1
558: FROM FND_FLEX_VALUE_NORM_HIERARCHY ffvnh

Line 595: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

591: t2 =>'TABLE',
592: v2 =>'GL_SEG_VAL_NORM_HIERARCHY');
593:
594:
595: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
596:
597:
598: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
599: token_num => 3 ,

Line 606: v3 =>GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID);

602: 'GL_FLATTEN_SEG_VAL_HIERARCHIES.Fix_Norm_Table()',
603: t2 =>'VARIABLE',
604: v2 =>'Value_Set_Id',
605: t3 =>'VALUE',
606: v3 =>GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID);
607:
608: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
609: token_num => 2,
610: t1 =>'ROUTINE',

Line 632: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,

628: (SELECT DISTINCT ffvnh.flex_value_set_id,
629: ffvnh.parent_flex_value,
630: glsvh.child_flex_value,
631: glsvh.summary_flag, 'I',
632: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
633: SYSDATE,
634: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
635: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
636: SYSDATE

Line 634: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,

630: glsvh.child_flex_value,
631: glsvh.summary_flag, 'I',
632: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
633: SYSDATE,
634: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
635: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
636: SYSDATE
637: FROM FND_FLEX_VALUE_NORM_HIERARCHY ffvnh,
638: GL_SEG_VAL_HIERARCHIES glsvh

Line 635: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,

631: glsvh.summary_flag, 'I',
632: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
633: SYSDATE,
634: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
635: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
636: SYSDATE
637: FROM FND_FLEX_VALUE_NORM_HIERARCHY ffvnh,
638: GL_SEG_VAL_HIERARCHIES glsvh
639: WHERE ffvnh.flex_value_set_id =

Line 640: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

636: SYSDATE
637: FROM FND_FLEX_VALUE_NORM_HIERARCHY ffvnh,
638: GL_SEG_VAL_HIERARCHIES glsvh
639: WHERE ffvnh.flex_value_set_id =
640: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
641: AND glsvh.flex_value_set_id = ffvnh.flex_value_set_id
642: AND glsvh.parent_flex_value = 'T'
643: AND glsvh.summary_flag =
644: DECODE(ffvnh.range_attribute,

Line 748: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

744: glsvnh.summary_flag
745: FROM GL_SEG_VAL_NORM_HIERARCHY glsvnh,
746: GL_SEG_VAL_HIERARCHIES glsvh1
747: WHERE glsvnh.flex_value_set_id =
748: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
749: AND glsvnh.status_code ='D'
750: AND glsvh1.flex_value_set_id =
751: glsvnh.flex_value_set_id
752: AND glsvh1.child_flex_value =

Line 767: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

763: Is_Flattened_Tab_Changed := TRUE;
764:
765: END IF;
766:
767: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
768: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
769: token_num =>2,
770: t1 =>'ROUTINE',
771: v1 =>

Line 791: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

787: -- The following SQL statement mark all records for delete that
788: -- contain any deleted parent child and its descendants
789: -- in GL_SEG_VAL_HIERARCHIES
790:
791: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
792: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
793: token_num =>2,
794: t1 =>'ROUTINE',
795: v1 =>

Line 819: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

815: GL_SEG_VAL_HIERARCHIES glsvh2
816: WHERE glsvnh.status_code ='D'
817: AND glsvnh.summary_flag = 'Y'
818: AND glsvnh.flex_value_set_id =
819: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
820: AND glsvh1.flex_value_set_id =
821: glsvnh.flex_value_set_id
822: AND glsvh1.child_flex_value =
823: glsvnh.parent_flex_value

Line 851: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

847: -- The following SQL checks and reconnects if the deleted child is
848: -- mapped to the parent again through some other paths. It will run
849: -- in a loop until no more changes occur.
850:
851: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
852:
853: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
854: token_num =>2,
855: t1 =>'ROUTINE',

Line 877: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

873: UPDATE GL_SEG_VAL_HIERARCHIES glsvh1
874: SET glsvh1.status_code = NULL
875: WHERE glsvh1.status_code ='D'
876: AND glsvh1.flex_value_set_id =
877: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
878: AND (EXISTS
879: (SELECT 1
880: FROM GL_SEG_VAL_HIERARCHIES glsvh2,
881: GL_SEG_VAL_HIERARCHIES glsvh3

Line 926: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

922:
923: -- Insert new self reocrds into GL_SEG_VAL_HIERARCHIES for each
924: -- new parent / changing being a child value to a parent value
925:
926: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
927: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
928: token_num =>2,
929: t1 =>'ROUTINE',
930: v1 =>

Line 944: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,

940: summary_flag, status_code, created_by, creation_date,
941: last_updated_by, last_update_login, last_update_date)
942: (SELECT DISTINCT glsvh.flex_value_set_id, glsvh.child_flex_value,
943: glsvh.child_flex_value, 'Y', 'I',
944: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
945: SYSDATE,
946: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
947: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
948: SYSDATE

Line 946: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,

942: (SELECT DISTINCT glsvh.flex_value_set_id, glsvh.child_flex_value,
943: glsvh.child_flex_value, 'Y', 'I',
944: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
945: SYSDATE,
946: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
947: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
948: SYSDATE
949: FROM GL_SEG_VAL_HIERARCHIES glsvh
950: WHERE glsvh.flex_value_set_id =

Line 947: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,

943: glsvh.child_flex_value, 'Y', 'I',
944: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
945: SYSDATE,
946: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
947: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
948: SYSDATE
949: FROM GL_SEG_VAL_HIERARCHIES glsvh
950: WHERE glsvh.flex_value_set_id =
951: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

Line 951: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

947: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
948: SYSDATE
949: FROM GL_SEG_VAL_HIERARCHIES glsvh
950: WHERE glsvh.flex_value_set_id =
951: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
952: AND glsvh.parent_flex_value = 'T'
953: AND glsvh.status_code IN ('I','U')
954: AND glsvh.summary_flag = 'Y'
955: AND NOT EXISTS

Line 983: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

979:
980:
981: -- The following SQL statement Insert all new detail child mappings
982:
983: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
984: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
985: token_num =>2,
986: t1 =>'ROUTINE',
987: v1 =>

Line 1003: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,

999: (SELECT DISTINCT glsvnh.flex_value_set_id,
1000: glsvh.parent_flex_value,
1001: glsvnh.child_flex_value,
1002: glsvnh.summary_flag, 'I',
1003: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
1004: SYSDATE,
1005: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
1006: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
1007: SYSDATE

Line 1005: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,

1001: glsvnh.child_flex_value,
1002: glsvnh.summary_flag, 'I',
1003: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
1004: SYSDATE,
1005: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
1006: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
1007: SYSDATE
1008: FROM GL_SEG_VAL_NORM_HIERARCHY glsvnh,
1009: GL_SEG_VAL_HIERARCHIES glsvh

Line 1006: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,

1002: glsvnh.summary_flag, 'I',
1003: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
1004: SYSDATE,
1005: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
1006: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
1007: SYSDATE
1008: FROM GL_SEG_VAL_NORM_HIERARCHY glsvnh,
1009: GL_SEG_VAL_HIERARCHIES glsvh
1010: WHERE glsvnh.flex_value_set_id =

Line 1011: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

1007: SYSDATE
1008: FROM GL_SEG_VAL_NORM_HIERARCHY glsvnh,
1009: GL_SEG_VAL_HIERARCHIES glsvh
1010: WHERE glsvnh.flex_value_set_id =
1011: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
1012: AND glsvnh.status_code = 'I'
1013: AND glsvnh.summary_flag = 'N'
1014: AND glsvh.flex_value_set_id =
1015: glsvnh.flex_value_set_id

Line 1050: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

1046:
1047: -- The following SQL statement insert all new parent-child mappings
1048: -- for all levels in the hierarchy into the table GL_SEG_VAL_HIERARCHIES
1049:
1050: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
1051: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
1052: token_num =>2,
1053: t1 =>'ROUTINE',
1054: v1 =>

Line 1075: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,

1071: (SELECT DISTINCT glsvnh.flex_value_set_id,
1072: glsvh1.parent_flex_value,
1073: glsvh2.child_flex_value,
1074: glsvh2.summary_flag, 'I',
1075: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
1076: SYSDATE,
1077: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
1078: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
1079: SYSDATE

Line 1077: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,

1073: glsvh2.child_flex_value,
1074: glsvh2.summary_flag, 'I',
1075: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
1076: SYSDATE,
1077: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
1078: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
1079: SYSDATE
1080: FROM GL_SEG_VAL_NORM_HIERARCHY glsvnh,
1081: GL_SEG_VAL_HIERARCHIES glsvh1,

Line 1078: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,

1074: glsvh2.summary_flag, 'I',
1075: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
1076: SYSDATE,
1077: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
1078: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
1079: SYSDATE
1080: FROM GL_SEG_VAL_NORM_HIERARCHY glsvnh,
1081: GL_SEG_VAL_HIERARCHIES glsvh1,
1082: GL_SEG_VAL_HIERARCHIES glsvh2

Line 1084: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID

1080: FROM GL_SEG_VAL_NORM_HIERARCHY glsvnh,
1081: GL_SEG_VAL_HIERARCHIES glsvh1,
1082: GL_SEG_VAL_HIERARCHIES glsvh2
1083: WHERE glsvnh.flex_value_set_id =
1084: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
1085: AND glsvnh.status_code = 'I'
1086: AND glsvnh.summary_flag = 'Y'
1087: AND glsvh1.flex_value_set_id =
1088: glsvnh.flex_value_set_id

Line 1176: IF(GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

1172: BEGIN
1173: GL_MESSAGE.Func_Ent(func_name =>
1174: 'GL_FLATTEN_SEG_VAL_HIERARCHIES.Clean_Up');
1175:
1176: IF(GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
1177:
1178: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
1179: token_num => 3,
1180: t1 => 'ROUTINE',

Line 1187: TO_CHAR(GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID));

1183: t2 =>'VARIABLE',
1184: v2 => 'Value_Set_Id',
1185: t3 => 'VALUE',
1186: v3 =>
1187: TO_CHAR(GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID));
1188: END IF;
1189:
1190: UPDATE GL_SEG_VAL_NORM_HIERARCHY
1191: SET status_code = NULL

Line 1193: AND flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;

1189:
1190: UPDATE GL_SEG_VAL_NORM_HIERARCHY
1191: SET status_code = NULL
1192: WHERE status_code = 'I'
1193: AND flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;
1194:
1195: l_no_rows := NVL(SQL%ROWCOUNT,0);
1196:
1197: GL_MESSAGE.Write_Log(msg_name =>'SHRD0118',

Line 1207: AND flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;

1203:
1204: UPDATE GL_SEG_VAL_HIERARCHIES
1205: SET status_code = NULL
1206: WHERE status_code IN ('I','U')
1207: AND flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;
1208:
1209: l_no_rows := NVL(SQL%ROWCOUNT,0);
1210:
1211: GL_MESSAGE.Write_Log(msg_name =>'SHRD0118',

Line 1223: AND flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;

1219: l_status := 'D';
1220:
1221: DELETE FROM GL_SEG_VAL_NORM_HIERARCHY
1222: WHERE status_code = l_status
1223: AND flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;
1224:
1225: l_no_rows := NVL(SQL%ROWCOUNT,0);
1226:
1227: GL_MESSAGE.Write_Log(msg_name =>'SHRD0119',

Line 1236: AND flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;

1232: v2 =>'GL_SEG_VAL_NORM_HIERARCHY');
1233:
1234: DELETE FROM GL_SEG_VAL_HIERARCHIES
1235: WHERE status_code= l_status
1236: AND flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID;
1237: l_no_rows := NVL(SQL%ROWCOUNT,0);
1238:
1239: GL_MESSAGE.Write_Log(msg_name =>'SHRD0119',
1240: token_num => 2,