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_LEDGER_SEG_VALS dependencies on GL_LEDGER_SEGMENT_VALUES

Line 32: -- status_code ='D' to NULL in the GL_LEDGER_SEGMENT_VALUES table

28:
29:
30: -- The flow of this routine is as follows
31: -- First clean records with status_code 'I' and update records with
32: -- status_code ='D' to NULL in the GL_LEDGER_SEGMENT_VALUES table
33: -- Detect any changes in GL_LEDGER_NORM_SEG_VALS table, then mainatain
34: -- GL_LEDGER_SEGMENT_VALUES based on these changes.
35: -- Calls routine Error_Check to makesure that the data is fine.
36:

Line 34: -- GL_LEDGER_SEGMENT_VALUES based on these changes.

30: -- The flow of this routine is as follows
31: -- First clean records with status_code 'I' and update records with
32: -- status_code ='D' to NULL in the GL_LEDGER_SEGMENT_VALUES table
33: -- Detect any changes in GL_LEDGER_NORM_SEG_VALS table, then mainatain
34: -- GL_LEDGER_SEGMENT_VALUES based on these changes.
35: -- Calls routine Error_Check to makesure that the data is fine.
36:
37:
38: -- Cleaning GL_LEDGER_SEGMENT_VALUES before processing

Line 38: -- Cleaning GL_LEDGER_SEGMENT_VALUES before processing

34: -- GL_LEDGER_SEGMENT_VALUES based on these changes.
35: -- Calls routine Error_Check to makesure that the data is fine.
36:
37:
38: -- Cleaning GL_LEDGER_SEGMENT_VALUES before processing
39:
40: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
41: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',
42: TOKEN_NUM => 2,

Line 49: ||' GL_LEDGER_SEGMENT_VALUES');

45: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',
46: T2 =>'ACTION',
47: V2 =>'DELETING RECORDS WITH STATUS CODE I '
48: ||' IN THE TABLE'
49: ||' GL_LEDGER_SEGMENT_VALUES');
50: END IF;
51:
52: -- To improve performance for bug fix # 5075776
53: l_status_flag := 'I';

Line 56: FROM GL_LEDGER_SEGMENT_VALUES

52: -- To improve performance for bug fix # 5075776
53: l_status_flag := 'I';
54:
55: DELETE
56: FROM GL_LEDGER_SEGMENT_VALUES
57: WHERE STATUS_CODE = l_status_flag
58: AND LEDGER_ID IN
59: (SELECT LEDGER_ID
60: FROM GL_LEDGERS

Line 69: V2 =>'GL_LEDGER_SEGMENT_VALUES');

65: TOKEN_NUM =>2,
66: T1 =>'NUM',
67: V1 => TO_CHAR(L_NUMBER_OF_ROWS),
68: T2 =>'TABLE',
69: V2 =>'GL_LEDGER_SEGMENT_VALUES');
70:
71:
72: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
73: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',

Line 81: ||' GL_LEDGER_SEGMENT_VALUES');

77: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',
78: T2 =>'ACTION',
79: V2 =>'Updating records with status code D'
80: ||' in the table'
81: ||' GL_LEDGER_SEGMENT_VALUES');
82: END IF;
83:
84: UPDATE GL_LEDGER_SEGMENT_VALUES
85: SET status_code = NULL

Line 84: UPDATE GL_LEDGER_SEGMENT_VALUES

80: ||' in the table'
81: ||' GL_LEDGER_SEGMENT_VALUES');
82: END IF;
83:
84: UPDATE GL_LEDGER_SEGMENT_VALUES
85: SET status_code = NULL
86: WHERE status_code = 'D'
87: AND ledger_id IN
88: (SELECT ledger_id

Line 98: V2 =>'GL_LEDGER_SEGMENT_VALUES');

94: TOKEN_NUM =>2,
95: T1 =>'NUM',
96: V1 => TO_CHAR(L_NUMBER_OF_ROWS),
97: T2 =>'TABLE',
98: V2 =>'GL_LEDGER_SEGMENT_VALUES');
99:
100: FND_CONCURRENT.AF_COMMIT; -- COMMIT Point
101:
102: -- Update Start_Date/End_Date In GL_LEDGER_SEGMENT_VALUES

Line 102: -- Update Start_Date/End_Date In GL_LEDGER_SEGMENT_VALUES

98: V2 =>'GL_LEDGER_SEGMENT_VALUES');
99:
100: FND_CONCURRENT.AF_COMMIT; -- COMMIT Point
101:
102: -- Update Start_Date/End_Date In GL_LEDGER_SEGMENT_VALUES
103:
104: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
105: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',
106: TOKEN_NUM => 2,

Line 113: ||' GL_LEDGER_SEGMENT_VALUES');

109: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',
110: T2 =>'ACTION',
111: V2 =>'UPDATING START_DATE/END_DATE'
112: ||' IN THE TABLE'
113: ||' GL_LEDGER_SEGMENT_VALUES');
114: END IF;
115:
116: UPDATE GL_LEDGER_SEGMENT_VALUES GLLSV
117: SET (GLLSV.START_DATE, GLLSV.END_DATE) =

Line 116: UPDATE GL_LEDGER_SEGMENT_VALUES GLLSV

112: ||' IN THE TABLE'
113: ||' GL_LEDGER_SEGMENT_VALUES');
114: END IF;
115:
116: UPDATE GL_LEDGER_SEGMENT_VALUES GLLSV
117: SET (GLLSV.START_DATE, GLLSV.END_DATE) =
118: (SELECT GLLNSV.START_DATE, GLLNSV.END_DATE
119: FROM GL_LEDGER_NORM_SEG_VALS GLLNSV
120: WHERE GLLNSV.RECORD_ID = GLLSV.PARENT_RECORD_ID)

Line 138: V2 =>'GL_LEDGER_SEGMENT_VALUES');

134: TOKEN_NUM =>2,
135: T1 =>'NUM',
136: V1 => TO_CHAR(L_NUMBER_OF_ROWS),
137: T2 =>'TABLE',
138: V2 =>'GL_LEDGER_SEGMENT_VALUES');
139:
140: -- Marking outdated records in GL_LEDGER_SEGMENT_VALUES for delete.
141:
142: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN

Line 140: -- Marking outdated records in GL_LEDGER_SEGMENT_VALUES for delete.

136: V1 => TO_CHAR(L_NUMBER_OF_ROWS),
137: T2 =>'TABLE',
138: V2 =>'GL_LEDGER_SEGMENT_VALUES');
139:
140: -- Marking outdated records in GL_LEDGER_SEGMENT_VALUES for delete.
141:
142: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
143: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',
144: TOKEN_NUM => 2,

Line 151: ||' GL_LEDGER_SEGMENT_VALUES for delete');

147: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',
148: T2 =>'ACTION',
149: V2 =>'Updating outdated records'
150: ||' in the table'
151: ||' GL_LEDGER_SEGMENT_VALUES for delete');
152: END IF;
153:
154: UPDATE GL_LEDGER_SEGMENT_VALUES
155: SET STATUS_CODE = 'D'

Line 154: UPDATE GL_LEDGER_SEGMENT_VALUES

150: ||' in the table'
151: ||' GL_LEDGER_SEGMENT_VALUES for delete');
152: END IF;
153:
154: UPDATE GL_LEDGER_SEGMENT_VALUES
155: SET STATUS_CODE = 'D'
156: WHERE PARENT_RECORD_ID IN
157: (SELECT RECORD_ID
158: FROM GL_LEDGERS GLL,

Line 171: V2 =>'GL_LEDGER_SEGMENT_VALUES');

167: TOKEN_NUM =>2,
168: T1 =>'NUM',
169: V1 => TO_CHAR(l_number_of_rows),
170: T2 =>'TABLE',
171: V2 =>'GL_LEDGER_SEGMENT_VALUES');
172:
173: -- Inserting new Ledger-Segment value assignments into the table
174: -- GL_LEDGER_SEGMENT_VALUES.
175:

Line 174: -- GL_LEDGER_SEGMENT_VALUES.

170: T2 =>'TABLE',
171: V2 =>'GL_LEDGER_SEGMENT_VALUES');
172:
173: -- Inserting new Ledger-Segment value assignments into the table
174: -- GL_LEDGER_SEGMENT_VALUES.
175:
176: -- The following statement inserts a record into GL_LEDGER_SEGMENT_VALUES
177: -- table for every new record in GL_LEDGER_NORM_SEG_VALS with
178: -- status_code 'I' and segment_value_type_code of 'S'.

Line 176: -- The following statement inserts a record into GL_LEDGER_SEGMENT_VALUES

172:
173: -- Inserting new Ledger-Segment value assignments into the table
174: -- GL_LEDGER_SEGMENT_VALUES.
175:
176: -- The following statement inserts a record into GL_LEDGER_SEGMENT_VALUES
177: -- table for every new record in GL_LEDGER_NORM_SEG_VALS with
178: -- status_code 'I' and segment_value_type_code of 'S'.
179:
180: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN

Line 188: ||' GL_LEDGER_SEGMENT_VALUES'

184: V1 =>
185: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',
186: T2 =>'ACTION',
187: V2 =>'Inserting new record(S) Into'
188: ||' GL_LEDGER_SEGMENT_VALUES'
189: ||' for every record with status code I '
190: ||' and segment_value_type_code of S'
191: ||' in the table'
192: ||' GL_LEDGER_NORM_SEG_VALS ');

Line 195: INSERT INTO GL_LEDGER_SEGMENT_VALUES

191: ||' in the table'
192: ||' GL_LEDGER_NORM_SEG_VALS ');
193: END IF;
194:
195: INSERT INTO GL_LEDGER_SEGMENT_VALUES
196: (LEDGER_ID, SEGMENT_TYPE_CODE, SEGMENT_VALUE, STATUS_CODE,
197: PARENT_RECORD_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
198: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, START_DATE,
199: END_DATE)

Line 224: V2 =>'GL_LEDGER_SEGMENT_VALUES');

220: TOKEN_NUM =>2,
221: T1 =>'NUM',
222: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
223: T2 =>'TABLE',
224: V2 =>'GL_LEDGER_SEGMENT_VALUES');
225: l_number_of_rows := 0;
226:
227: -- The following statement inserts a record into GL_LEDGER_SEGMENT_VALUES
228: -- table for every new record in GL_LEDGER_NORM_SEG_VALS with

Line 227: -- The following statement inserts a record into GL_LEDGER_SEGMENT_VALUES

223: T2 =>'TABLE',
224: V2 =>'GL_LEDGER_SEGMENT_VALUES');
225: l_number_of_rows := 0;
226:
227: -- The following statement inserts a record into GL_LEDGER_SEGMENT_VALUES
228: -- table for every new record in GL_LEDGER_NORM_SEG_VALS with
229: -- status_code 'I' and segment_value_type_code of 'C'.
230:
231: If (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN

Line 239: ||' GL_LEDGER_SEGMENT_VALUES'

235: V1 =>
236: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',
237: T2 =>'ACTION',
238: V2 =>'INSERT NEW RECORD(S) INTO'
239: ||' GL_LEDGER_SEGMENT_VALUES'
240: ||' FOR EVERY RECORD WITH STATUS CODE I '
241: ||' AND SEGMENT_VALUE_TYPE_CODE OF C'
242: ||' IN THE TABLE'
243: ||' GL_LEDGER_NORM_SEG_VALS ');

Line 332: INSERT INTO GL_LEDGER_SEGMENT_VALUES

328:
329: -- These locks will be released in GL_FLATTEN_SETUP_DATA.Main()package
330: -- after successfull completion of the clean up routines.
331:
332: INSERT INTO GL_LEDGER_SEGMENT_VALUES
333: (LEDGER_ID, SEGMENT_TYPE_CODE,SEGMENT_VALUE, STATUS_CODE,
334: PARENT_RECORD_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
335: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, START_DATE,
336: END_DATE)

Line 368: V2 =>'GL_LEDGER_SEGMENT_VALUES');

364: TOKEN_NUM =>2,
365: T1 =>'NUM',
366: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
367: T2 =>'TABLE',
368: V2 =>'GL_LEDGER_SEGMENT_VALUES');
369:
370: l_number_of_rows := 0;
371:
372: -- ALC changes.

Line 391: ||' GL_LEDGER_SEGMENT_VALUES'

387: V1 =>
388: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',
389: T2 =>'ACTION',
390: V2 =>'Inserting ALC ledger record(S) into'
391: ||' GL_LEDGER_SEGMENT_VALUES'
392: ||' for every source ledger '
393: ||' in the '
394: ||' GL_LEDGER_NORM_SEG_VALS table');
395: END IF;

Line 397: INSERT INTO GL_LEDGER_SEGMENT_VALUES

393: ||' in the '
394: ||' GL_LEDGER_NORM_SEG_VALS table');
395: END IF;
396:
397: INSERT INTO GL_LEDGER_SEGMENT_VALUES
398: (LEDGER_ID, SEGMENT_TYPE_CODE, SEGMENT_VALUE, STATUS_CODE,
399: PARENT_RECORD_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
400: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, START_DATE,
401: END_DATE)

Line 412: ,GL_LEDGER_SEGMENT_VALUES gllsv

408: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID,
409: gllsv.start_date, gllsv.end_date
410: FROM GL_LEDGERS gll
411: ,GL_LEDGER_RELATIONSHIPS glr
412: ,GL_LEDGER_SEGMENT_VALUES gllsv
413: WHERE gll.chart_of_accounts_id =
414: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
415: AND (gll.bal_seg_value_option_code = 'I' OR
416: gll.mgt_seg_value_option_code = 'I')

Line 429: FROM GL_LEDGER_SEGMENT_VALUES gllsv2

425: DECODE(gll.mgt_seg_value_option_code,'I','M',''))
426: AND NVL(GLLSV.STATUS_CODE,'X') <> 'D'
427: AND NOT EXISTS
428: (SELECT 1
429: FROM GL_LEDGER_SEGMENT_VALUES gllsv2
430: WHERE gllsv2.ledger_id = glr.target_ledger_id
431: AND gllsv2.segment_type_code = gllsv.SEGMENT_TYPE_CODE
432: AND gllsv2.segment_value = gllsv.segment_value
433: AND NVL(gllsv2.start_date,

Line 449: V2 =>'GL_LEDGER_SEGMENT_VALUES');

445: TOKEN_NUM =>2,
446: T1 =>'NUM',
447: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
448: T2 =>'TABLE',
449: V2 =>'GL_LEDGER_SEGMENT_VALUES');
450: l_number_of_rows := 0;
451:
452: -- Check for any date overlap
453:

Line 564: -- Cleaning GL_LEDGER_SEGMENT_VALUES before processing

560: RETURN TRUE;
561:
562: ELSE
563:
564: -- Cleaning GL_LEDGER_SEGMENT_VALUES before processing
565:
566: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
567: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',
568: TOKEN_NUM => 2,

Line 576: ||' GL_LEDGER_SEGMENT_VALUES');

572: T2 =>'ACTION',
573: V2 =>'DELETING RECORDS WITH'
574: ||' STATUS CODE I'
575: ||' IN THE TABLE'
576: ||' GL_LEDGER_SEGMENT_VALUES');
577: END IF;
578:
579: DELETE
580: FROM GL_LEDGER_SEGMENT_VALUES

Line 580: FROM GL_LEDGER_SEGMENT_VALUES

576: ||' GL_LEDGER_SEGMENT_VALUES');
577: END IF;
578:
579: DELETE
580: FROM GL_LEDGER_SEGMENT_VALUES
581: WHERE STATUS_CODE = 'I'
582: AND LEDGER_ID IN
583: (SELECT LEDGER_ID
584: FROM GL_LEDGERS

Line 596: V2 =>'GL_LEDGER_SEGMENT_VALUES');

592: TOKEN_NUM =>2,
593: T1 =>'NUM',
594: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
595: T2 =>'TABLE',
596: V2 =>'GL_LEDGER_SEGMENT_VALUES');
597:
598: -- Cleaning GL_LEDGER_SEGMENT_VALUES before processing
599:
600: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN

Line 598: -- Cleaning GL_LEDGER_SEGMENT_VALUES before processing

594: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
595: T2 =>'TABLE',
596: V2 =>'GL_LEDGER_SEGMENT_VALUES');
597:
598: -- Cleaning GL_LEDGER_SEGMENT_VALUES before processing
599:
600: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
601: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',
602: TOKEN_NUM => 2,

Line 609: ||' GL_LEDGER_SEGMENT_VALUES');

605: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Value_Set()',
606: T2 =>'ACTION',
607: V2 =>'UPDATING RECORDS WITH STATUS'
608: ||' CODE D TO NULL IN THE TABLE'
609: ||' GL_LEDGER_SEGMENT_VALUES');
610: END IF;
611:
612: UPDATE GL_LEDGER_SEGMENT_VALUES
613: SET STATUS_CODE = NULL

Line 612: UPDATE GL_LEDGER_SEGMENT_VALUES

608: ||' CODE D TO NULL IN THE TABLE'
609: ||' GL_LEDGER_SEGMENT_VALUES');
610: END IF;
611:
612: UPDATE GL_LEDGER_SEGMENT_VALUES
613: SET STATUS_CODE = NULL
614: WHERE STATUS_CODE = 'D'
615: AND LEDGER_ID IN
616: (SELECT LEDGER_ID

Line 630: V2 =>'GL_LEDGER_SEGMENT_VALUES');

626: TOKEN_NUM =>2,
627: T1 =>'NUM',
628: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
629: T2 =>'TABLE',
630: V2 =>'GL_LEDGER_SEGMENT_VALUES');
631:
632: FND_CONCURRENT.AF_COMMIT; -- COMMIT Point
633:
634: -- Marking Parent-Child segment value mappings in

Line 635: -- GL_LEDGER_SEGMENT_VALUES for delete

631:
632: FND_CONCURRENT.AF_COMMIT; -- COMMIT Point
633:
634: -- Marking Parent-Child segment value mappings in
635: -- GL_LEDGER_SEGMENT_VALUES for delete
636:
637: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
638: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',
639: TOKEN_NUM => 2,

Line 646: ||' GL_LEDGER_SEGMENT_VALUES'

642: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Value_Set()',
643: T2 =>'ACTION',
644: V2 =>'UPDATING PARENT-CHILD SEGMENT'
645: ||' VALUE MAPPINGS IN'
646: ||' GL_LEDGER_SEGMENT_VALUES'
647: ||' FOR DELETE');
648: END IF;
649:
650: UPDATE GL_LEDGER_SEGMENT_VALUES GLLSV

Line 650: UPDATE GL_LEDGER_SEGMENT_VALUES GLLSV

646: ||' GL_LEDGER_SEGMENT_VALUES'
647: ||' FOR DELETE');
648: END IF;
649:
650: UPDATE GL_LEDGER_SEGMENT_VALUES GLLSV
651: SET GLLSV.STATUS_CODE = 'D'
652: WHERE (GLLSV.LEDGER_ID, GLLSV.PARENT_RECORD_ID,
653: GLLSV.SEGMENT_VALUE) IN
654: (SELECT GLLNSV.LEDGER_ID, GLLNSV.RECORD_ID,

Line 682: V2 =>'GL_LEDGER_SEGMENT_VALUES');

678: TOKEN_NUM =>2,
679: T1 =>'NUM',
680: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
681: T2 =>'TABLE',
682: V2 =>'GL_LEDGER_SEGMENT_VALUES');
683:
684:
685:
686: -- Inserting New Parent-Child segment value mappings into

Line 687: -- GL_LEDGER_SEGMENT_VALUES.

683:
684:
685:
686: -- Inserting New Parent-Child segment value mappings into
687: -- GL_LEDGER_SEGMENT_VALUES.
688:
689: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
690:
691: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',

Line 699: ||' into GL_LEDGER_SEGMENT_VALUES');

695: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Value_Set()',
696: T2 =>'ACTION',
697: V2 =>'Insert new segment values'
698: ||' from segment value hierarchy'
699: ||' into GL_LEDGER_SEGMENT_VALUES');
700:
701:
702: END IF;
703:

Line 704: INSERT INTO GL_LEDGER_SEGMENT_VALUES

700:
701:
702: END IF;
703:
704: INSERT INTO GL_LEDGER_SEGMENT_VALUES
705: (LEDGER_ID, SEGMENT_TYPE_CODE, SEGMENT_VALUE, STATUS_CODE,
706: PARENT_RECORD_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
707: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, START_DATE,
708: END_DATE)

Line 743: V2 =>'GL_LEDGER_SEGMENT_VALUES');

739: TOKEN_NUM =>2,
740: T1 =>'NUM',
741: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
742: T2 =>'TABLE',
743: V2 =>'GL_LEDGER_SEGMENT_VALUES');
744:
745: END IF; -- Value set ID If - Else control ends here.
746:
747: IF (NOT ERROR_CHECK) THEN

Line 798: -- and GL_LEDGER_SEGMENT_VALUES for a particular Chart Of Accounts.

794: -- FUNCTION
795: -- Clean_Up_By_Coa
796: -- PURPOSE
797: -- This Function is to clean the tables GL_LEDGER_NORM_SEG_VALUES
798: -- and GL_LEDGER_SEGMENT_VALUES for a particular Chart Of Accounts.
799: -- HISTORY
800: -- 06-04-2001 SRINI PALA CREATED
801: -- ARGUMENTS
802:

Line 840: UPDATE GL_LEDGER_SEGMENT_VALUES

836: V2 => 'GL_LEDGER_NORM_SEG_VALS');
837:
838: l_number_of_rows := 0;
839:
840: UPDATE GL_LEDGER_SEGMENT_VALUES
841: SET STATUS_CODE = NULL
842: WHERE STATUS_CODE = 'I'
843: AND LEDGER_ID IN
844: (SELECT LEDGER_ID

Line 855: V2 => 'GL_LEDGER_SEGMENT_VALUES');

851: TOKEN_NUM =>2,
852: T1 =>'NUM',
853: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
854: T2 => 'TABLE',
855: V2 => 'GL_LEDGER_SEGMENT_VALUES');
856: l_number_of_rows := 0;
857:
858: -- To improve performance for bug fix # 5075776
859: l_status := 'D';

Line 880: FROM GL_LEDGER_SEGMENT_VALUES

876: V2 => 'GL_LEDGER_NORM_SEG_VALS');
877: l_number_of_rows := 0;
878:
879: DELETE
880: FROM GL_LEDGER_SEGMENT_VALUES
881: WHERE STATUS_CODE = l_status
882: AND LEDGER_ID IN
883: (SELECT LEDGER_ID
884: FROM GL_LEDGERS

Line 894: V2 => 'GL_LEDGER_SEGMENT_VALUES');

890: TOKEN_NUM => 2,
891: T1 => 'NUM',
892: V1 => TO_CHAR(L_NUMBER_OF_ROWS),
893: T2 =>'TABLE',
894: V2 => 'GL_LEDGER_SEGMENT_VALUES');
895: l_number_of_rows := 0;
896:
897: GL_MESSAGE.FUNC_SUCC(FUNC_NAME =>
898: 'GL_FLATTEN_LEDGER_SEG_VALS.Clean_Up_By_Coa');

Line 925: -- and GL_LEDGER_SEGMENT_VALUES for a particular value set.

921: -- FUNCTION
922: -- Clean_Up_By_Value_Set
923: -- PURPOSE
924: -- This Function is to clean the tables GL_LEDGER_NORM_SEG_VALUES
925: -- and GL_LEDGER_SEGMENT_VALUES for a particular value set.
926: -- HISTORY
927: -- 06-04-2001 Srini Pala Created
928: -- ARGUMENTS
929:

Line 943: UPDATE GL_LEDGER_SEGMENT_VALUES

939:
940: GL_MESSAGE.FUNC_ENT(FUNC_NAME =>
941: 'GL_FLATTEN_LEDGER_SEG_VALS.Clean_Up_By_Value_Set');
942:
943: UPDATE GL_LEDGER_SEGMENT_VALUES
944: SET STATUS_CODE = NULL
945: WHERE STATUS_CODE = 'I'
946: AND LEDGER_ID IN
947: (SELECT LEDGER_ID

Line 960: V2 => 'GL_LEDGER_SEGMENT_VALUES');

956: TOKEN_NUM =>2,
957: T1 =>'NUM',
958: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
959: T2 => 'TABLE',
960: V2 => 'GL_LEDGER_SEGMENT_VALUES');
961:
962: DELETE
963: FROM GL_LEDGER_SEGMENT_VALUES
964: WHERE STATUS_CODE = 'D'

Line 963: FROM GL_LEDGER_SEGMENT_VALUES

959: T2 => 'TABLE',
960: V2 => 'GL_LEDGER_SEGMENT_VALUES');
961:
962: DELETE
963: FROM GL_LEDGER_SEGMENT_VALUES
964: WHERE STATUS_CODE = 'D'
965: AND LEDGER_ID IN
966: (SELECT LEDGER_ID
967: FROM GL_LEDGERS

Line 979: V2 => 'GL_LEDGER_SEGMENT_VALUES');

975: TOKEN_NUM => 2,
976: T1 => 'NUM',
977: V1 => TO_CHAR(L_NUMBER_OF_ROWS),
978: T2 =>'TABLE',
979: V2 => 'GL_LEDGER_SEGMENT_VALUES');
980:
981:
982: GL_MESSAGE.FUNC_SUCC(FUNC_NAME =>
983: 'GL_FLATTEN_LEDGER_SEG_VALS.Clean_Up_By_Value_Set');

Line 1044: GL_LEDGER_SEGMENT_VALUES GLLSV1,

1040:
1041: CURSOR Cursor_LV_Ledger IS
1042: SELECT DISTINCT GLLSV1.LEDGER_ID, GLLSV2.SEGMENT_VALUE
1043: FROM GL_LEDGERS GLL,
1044: GL_LEDGER_SEGMENT_VALUES GLLSV1,
1045: GL_LEDGER_SEGMENT_VALUES GLLSV2
1046: WHERE GLL.CHART_OF_ACCOUNTS_ID =
1047: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
1048: AND GLLSV1.LEDGER_ID = GLL.LEDGER_ID

Line 1045: GL_LEDGER_SEGMENT_VALUES GLLSV2

1041: CURSOR Cursor_LV_Ledger IS
1042: SELECT DISTINCT GLLSV1.LEDGER_ID, GLLSV2.SEGMENT_VALUE
1043: FROM GL_LEDGERS GLL,
1044: GL_LEDGER_SEGMENT_VALUES GLLSV1,
1045: GL_LEDGER_SEGMENT_VALUES GLLSV2
1046: WHERE GLL.CHART_OF_ACCOUNTS_ID =
1047: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
1048: AND GLLSV1.LEDGER_ID = GLL.LEDGER_ID
1049: AND GLLSV1.LEDGER_ID = GLLSV2.LEDGER_ID

Line 1127: GL_LEDGER_SEGMENT_VALUES GLLSV1,

1123:
1124: CURSOR Cursor_SH_Ledger IS
1125: SELECT GLLSV1.LEDGER_ID, GLLSV2.SEGMENT_VALUE
1126: FROM GL_LEDGERS GLL,
1127: GL_LEDGER_SEGMENT_VALUES GLLSV1,
1128: GL_LEDGER_SEGMENT_VALUES GLLSV2
1129: WHERE ( GLL.BAL_SEG_VALUE_SET_ID =
1130: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
1131: OR GLL.MGT_SEG_VALUE_SET_ID =

Line 1128: GL_LEDGER_SEGMENT_VALUES GLLSV2

1124: CURSOR Cursor_SH_Ledger IS
1125: SELECT GLLSV1.LEDGER_ID, GLLSV2.SEGMENT_VALUE
1126: FROM GL_LEDGERS GLL,
1127: GL_LEDGER_SEGMENT_VALUES GLLSV1,
1128: GL_LEDGER_SEGMENT_VALUES GLLSV2
1129: WHERE ( GLL.BAL_SEG_VALUE_SET_ID =
1130: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
1131: OR GLL.MGT_SEG_VALUE_SET_ID =
1132: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID)