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_ACCESS_SETS dependencies on GL_ACCESS_SET_NORM_ASSIGN

Line 12: -- sets. All changes in GL_ACCESS_SET_NORM_ASSIGN are done

8: GLSTFL_fatal_err EXCEPTION;
9: BEGIN
10:
11: -- This is the routine that processes changes in explicit ledger
12: -- sets. All changes in GL_ACCESS_SET_NORM_ASSIGN are done
13: -- through the form, so this routine only needs to call
14: -- Fix_Flattened_Table to maintain GL_ACCESS_SET_ASSIGNMENTS.
15: -- There is no need to clean up data before processing since
16: -- changes to GL_ACCESS_SET_ASSIGNMENTS will not be committed

Line 78: -- 1) Clean up GL_ACCESS_SET_NORM_ASSIGN for all implicit acces sets

74: -- This is the routine that processes changes in the implicit
75: -- access sets due to modifications to the respective ledger
76: -- hierarchies.
77: -- The basic flow is as follows:
78: -- 1) Clean up GL_ACCESS_SET_NORM_ASSIGN for all implicit acces sets
79: -- within the chart of accounts. There is no need to clean
80: -- up GL_ACCESS_SET_ASSIGNMENTS since no changes should be
81: -- committed there unless everything has been completed.
82: -- 2) Call routine Fix_Norm_Table to maintain GL_ACCESS_SET_NORM_ASSIGN.

Line 82: -- 2) Call routine Fix_Norm_Table to maintain GL_ACCESS_SET_NORM_ASSIGN.

78: -- 1) Clean up GL_ACCESS_SET_NORM_ASSIGN for all implicit acces sets
79: -- within the chart of accounts. There is no need to clean
80: -- up GL_ACCESS_SET_ASSIGNMENTS since no changes should be
81: -- committed there unless everything has been completed.
82: -- 2) Call routine Fix_Norm_Table to maintain GL_ACCESS_SET_NORM_ASSIGN.
83: -- 3) Call routine Fix_Flattened_Table to maintain
84: -- GL_ACCESS_SET_ASSIGNMENTS.
85:
86: GL_MESSAGE.Func_Ent

Line 89: -- Clean up GL_ACCESS_SET_NORM_ASSIGN

85:
86: GL_MESSAGE.Func_Ent
87: (func_name => 'GL_FLATTEN_ACCESS_SETS.Fix_Implicit_Sets');
88:
89: -- Clean up GL_ACCESS_SET_NORM_ASSIGN
90: -- for any unprocessed data left over from previous failed run
91:
92: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
93: GL_MESSAGE.Write_Log

Line 100: 'GL_ACCESS_SET_NORM_ASSIGN...');

96: t1 => 'ROUTINE',
97: v1 => 'Fix_Implicit_Sets()',
98: t2 => 'ACTION',
99: v2 => 'Deleting records with status code I in ' ||
100: 'GL_ACCESS_SET_NORM_ASSIGN...');
101: END IF;
102:
103: DELETE from GL_ACCESS_SET_NORM_ASSIGN
104: WHERE status_code = 'I'

Line 103: DELETE from GL_ACCESS_SET_NORM_ASSIGN

99: v2 => 'Deleting records with status code I in ' ||
100: 'GL_ACCESS_SET_NORM_ASSIGN...');
101: END IF;
102:
103: DELETE from GL_ACCESS_SET_NORM_ASSIGN
104: WHERE status_code = 'I'
105: AND access_set_id IN
106: (SELECT access_set_id
107: FROM GL_ACCESS_SETS

Line 118: v2 => 'GL_ACCESS_SET_NORM_ASSIGN');

114: token_num => 2,
115: t1 => 'NUM',
116: v1 => TO_CHAR(row_count),
117: t2 => 'TABLE',
118: v2 => 'GL_ACCESS_SET_NORM_ASSIGN');
119: row_count := 0;
120:
121: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
122: GL_MESSAGE.Write_Log

Line 129: 'GL_ACCESS_SET_NORM_ASSIGN...');

125: t1 => 'ROUTINE',
126: v1 => 'Fix_Implicit_Sets()',
127: t2 => 'ACTION',
128: v2 => 'Updating records with status code D or U in ' ||
129: 'GL_ACCESS_SET_NORM_ASSIGN...');
130: END IF;
131:
132: UPDATE GL_ACCESS_SET_NORM_ASSIGN
133: SET status_code = NULL

Line 132: UPDATE GL_ACCESS_SET_NORM_ASSIGN

128: v2 => 'Updating records with status code D or U in ' ||
129: 'GL_ACCESS_SET_NORM_ASSIGN...');
130: END IF;
131:
132: UPDATE GL_ACCESS_SET_NORM_ASSIGN
133: SET status_code = NULL
134: WHERE status_code IN ('D', 'U')
135: AND access_set_id IN
136: (SELECT access_set_id

Line 148: v2 => 'GL_ACCESS_SET_NORM_ASSIGN');

144: token_num => 2,
145: t1 => 'NUM',
146: v1 => TO_CHAR(row_count),
147: t2 => 'TABLE',
148: v2 => 'GL_ACCESS_SET_NORM_ASSIGN');
149: row_count := 0;
150:
151: -- Commit all clean up work
152: FND_CONCURRENT.Af_Commit;

Line 217: -- This routine maintains GL_ACCESS_SET_NORM_ASSIGN.

213: RETURN BOOLEAN IS
214: row_count NUMBER := 0;
215: BEGIN
216:
217: -- This routine maintains GL_ACCESS_SET_NORM_ASSIGN.
218: -- Here is the sequence of events:
219: -- 1) For each new ledger, create a self mapping
220: -- access set assignment for the ledger
221: -- itself if it doesn't exist already.

Line 233: *** -- 2) Mark records in GL_ACCESS_SET_NORM_ASSIGN for delete

229: | hierarchy in Accounting Setup Flow.
230: +-------------------------------------------------------------------*/
231: /* *** -- If input parameter indicates there are changes in hierarchies:
232: *** --
233: *** -- 2) Mark records in GL_ACCESS_SET_NORM_ASSIGN for delete
234: *** -- based on marked records in GL_LEDGER_LEDGERS
235: *** -- Again, different statements will be used to process
236: *** -- legal and management hierarchies.
237: *** -- 3) Update records in GL_ACCESS_SET_NORM_ASSIGN based

Line 237: *** -- 3) Update records in GL_ACCESS_SET_NORM_ASSIGN based

233: *** -- 2) Mark records in GL_ACCESS_SET_NORM_ASSIGN for delete
234: *** -- based on marked records in GL_LEDGER_LEDGERS
235: *** -- Again, different statements will be used to process
236: *** -- legal and management hierarchies.
237: *** -- 3) Update records in GL_ACCESS_SET_NORM_ASSIGN based
238: *** -- on updated records in GL_LEDGER___HIERARCHIES.
239: *** -- 4) Insert new records into GL_ACCESS_SET_NORM_ASSIGN based
240: *** -- on new records in GL_LEDGER_HIERARCHIES. Several
241: *** -- statements will be run to process legal and management

Line 239: *** -- 4) Insert new records into GL_ACCESS_SET_NORM_ASSIGN based

235: *** -- Again, different statements will be used to process
236: *** -- legal and management hierarchies.
237: *** -- 3) Update records in GL_ACCESS_SET_NORM_ASSIGN based
238: *** -- on updated records in GL_LEDGER___HIERARCHIES.
239: *** -- 4) Insert new records into GL_ACCESS_SET_NORM_ASSIGN based
240: *** -- on new records in GL_LEDGER_HIERARCHIES. Several
241: *** -- statements will be run to process legal and management
242: *** -- hierarchies. */
243:

Line 256: 'GL_ACCESS_SET_NORM_ASSIGN ' ||

252: v1 => 'Fix_Norm_Table()',
253: t2 => 'ACTION',
254: v2 => 'Inserting self mapping records and ALCs ' ||
255: 'under its source ledger access set into ' ||
256: 'GL_ACCESS_SET_NORM_ASSIGN ' ||
257: 'for any new ledgers...');
258: END IF;
259:
260: INSERT into GL_ACCESS_SET_NORM_ASSIGN

Line 260: INSERT into GL_ACCESS_SET_NORM_ASSIGN

256: 'GL_ACCESS_SET_NORM_ASSIGN ' ||
257: 'for any new ledgers...');
258: END IF;
259:
260: INSERT into GL_ACCESS_SET_NORM_ASSIGN
261: (access_set_id, ledger_id, all_segment_value_flag,
262: segment_value_type_code, access_privilege_code, status_code,
263: record_id, last_update_date, last_updated_by, last_update_login,
264: creation_date, created_by, request_id, segment_value,

Line 267: 'S', 'B', 'I', GL_ACCESS_SET_NORM_ASSIGN_S.nextval,

263: record_id, last_update_date, last_updated_by, last_update_login,
264: creation_date, created_by, request_id, segment_value,
265: start_date, end_date, link_id)
266: (SELECT gll.implicit_access_set_id, glr.target_ledger_id, 'Y',
267: 'S', 'B', 'I', GL_ACCESS_SET_NORM_ASSIGN_S.nextval,
268: SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
269: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
270: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
271: GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID,

Line 287: FROM GL_ACCESS_SET_NORM_ASSIGN glasna

283: AND glr.relationship_type_code IN ('NONE','JOURNAL','SUBLEDGER')
284: AND glr.application_id = 101
285: AND NOT EXISTS
286: (SELECT 1
287: FROM GL_ACCESS_SET_NORM_ASSIGN glasna
288: WHERE glasna.access_set_id = gll.implicit_access_set_id
289: AND glasna.ledger_id = glr.target_ledger_id
290: AND glasna.all_segment_value_flag = 'Y'
291: AND glasna.segment_value_type_code = 'S'

Line 304: v2 => 'GL_ACCESS_SET_NORM_ASSIGN');

300: token_num => 2,
301: t1 => 'NUM',
302: v1 => TO_CHAR(row_count),
303: t2 => 'TABLE',
304: v2 => 'GL_ACCESS_SET_NORM_ASSIGN');
305: row_count := 0;
306:
307: -- Commit all work
308: FND_CONCURRENT.Af_Commit;

Line 790: GL_ACCESS_SET_NORM_ASSIGN glasna

786: FROM DUAL
787: WHERE EXISTS
788: (SELECT 1
789: FROM GL_ACCESS_SETS glas,
790: GL_ACCESS_SET_NORM_ASSIGN glasna
791: WHERE glas.secured_seg_value_set_id =
792: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
793: AND glas.security_segment_code <> 'F'
794: AND glasna.access_set_id = glas.access_set_id

Line 813: FROM GL_ACCESS_SET_NORM_ASSIGN glasna

809: INTO row_count
810: FROM DUAL
811: WHERE EXISTS
812: (SELECT 1
813: FROM GL_ACCESS_SET_NORM_ASSIGN glasna
814: WHERE glasna.ledger_id IN
815: (SELECT distinct gllsa.ledger_set_id
816: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,
817: GL_LEDGERS gll

Line 846: GL_ACCESS_SET_NORM_ASSIGN glasna

842: FROM DUAL
843: WHERE EXISTS
844: (SELECT 1
845: FROM GL_ACCESS_SETS glas,
846: GL_ACCESS_SET_NORM_ASSIGN glasna
847: WHERE glas.chart_of_accounts_id =
848: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
849: AND glas.automatically_created_flag = 'N'
850: AND glasna.access_set_id = glas.access_set_id

Line 869: GL_ACCESS_SET_NORM_ASSIGN glasna

865: FROM DUAL
866: WHERE EXISTS
867: (SELECT 1
868: FROM GL_ACCESS_SETS glas,
869: GL_ACCESS_SET_NORM_ASSIGN glasna
870: WHERE glas.chart_of_accounts_id =
871: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
872: AND glas.automatically_created_flag = 'N'
873: AND glasna.access_set_id = glas.access_set_id

Line 891: GL_ACCESS_SET_NORM_ASSIGN glasna

887: FROM DUAL
888: WHERE EXISTS
889: (SELECT 1
890: FROM GL_ACCESS_SETS glas,
891: GL_ACCESS_SET_NORM_ASSIGN glasna
892: WHERE glas.chart_of_accounts_id =
893: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
894: AND glas.automatically_created_flag = 'N'
895: AND glas.security_segment_code <> 'F'

Line 961: GL_ACCESS_SET_NORM_ASSIGN glasna,

957: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
958: glasna.start_date, glasna.end_date
959: FROM GL_SEG_VAL_HIERARCHIES glsvh,
960: GL_ACCESS_SETS glas,
961: GL_ACCESS_SET_NORM_ASSIGN glasna,
962: GL_LEDGER_SET_ASSIGNMENTS gllsa
963: WHERE glsvh.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
964: AND glsvh.status_code in ('I', 'D')
965: AND glas.security_segment_code <> 'F'

Line 1029: GL_ACCESS_SET_NORM_ASSIGN glasna,

1025: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1026: glasna.start_date, glasna.end_date
1027: FROM GL_SEG_VAL_HIERARCHIES glsvh,
1028: GL_ACCESS_SETS glas,
1029: GL_ACCESS_SET_NORM_ASSIGN glasna,
1030: GL_LEDGER_SET_ASSIGNMENTS gllsa
1031: WHERE glsvh.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
1032: AND glsvh.parent_flex_value = 'T'
1033: AND glsvh.status_code = 'I'

Line 1084: FROM GL_ACCESS_SET_NORM_ASSIGN glasna,

1080: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1081: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
1082: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1083: glasna.start_date, glasna.end_date
1084: FROM GL_ACCESS_SET_NORM_ASSIGN glasna,
1085: GL_LEDGERS gll
1086: WHERE glasna.status_code IN ('I')
1087: AND glasna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
1088: AND gll.implicit_access_set_id = glasna.access_set_id

Line 1144: GL_ACCESS_SET_NORM_ASSIGN glasna,

1140: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1141: glasna.start_date, glasna.end_date
1142: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,
1143: GL_LEDGERS gll,
1144: GL_ACCESS_SET_NORM_ASSIGN glasna,
1145: GL_ACCESS_SETS glas
1146: WHERE gllsa.status_code IN ('I', 'D')
1147: AND gll.ledger_id = gllsa.ledger_set_id
1148: AND gll.chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID

Line 1193: GL_ACCESS_SET_NORM_ASSIGN glasna,

1189: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1190: glasna.start_date, glasna.end_date
1191: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,
1192: GL_LEDGERS gll,
1193: GL_ACCESS_SET_NORM_ASSIGN glasna,
1194: GL_ACCESS_SETS glas,
1195: GL_SEG_VAL_HIERARCHIES glsvh
1196: WHERE gllsa.status_code IN ('I', 'D')
1197: AND gll.ledger_id = gllsa.ledger_set_id

Line 1245: GL_ACCESS_SET_NORM_ASSIGN glasna,

1241: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1242: glasna.start_date, glasna.end_date
1243: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,
1244: GL_LEDGERS gll,
1245: GL_ACCESS_SET_NORM_ASSIGN glasna,
1246: GL_ACCESS_SETS glas,
1247: GL_SEG_VAL_HIERARCHIES glsvh
1248: WHERE gllsa.status_code IN ('I', 'D')
1249: AND gll.ledger_id = gllsa.ledger_set_id

Line 1298: GL_ACCESS_SET_NORM_ASSIGN glasna

1294: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1295: glasna.start_date, glasna.end_date
1296: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,
1297: GL_LEDGERS gll,
1298: GL_ACCESS_SET_NORM_ASSIGN glasna
1299: WHERE gllsa.status_code IN ('I', 'D')
1300: AND gll.ledger_id = gllsa.ledger_set_id
1301: AND gll.chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
1302: AND gll.automatically_created_flag = 'N'

Line 1355: FROM GL_ACCESS_SET_NORM_ASSIGN glasna,

1351: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1352: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
1353: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1354: glasna.start_date, glasna.end_date
1355: FROM GL_ACCESS_SET_NORM_ASSIGN glasna,
1356: GL_ACCESS_SETS glas,
1357: GL_LEDGER_SET_ASSIGNMENTS gllsa
1358: WHERE glasna.status_code IN ('I', 'D')
1359: AND glasna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID

Line 1409: FROM GL_ACCESS_SET_NORM_ASSIGN glasna,

1405: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1406: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
1407: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1408: glasna.start_date, glasna.end_date
1409: FROM GL_ACCESS_SET_NORM_ASSIGN glasna,
1410: GL_ACCESS_SETS glas,
1411: GL_LEDGER_SET_ASSIGNMENTS gllsa,
1412: GL_SEG_VAL_HIERARCHIES glsvh
1413: WHERE glasna.status_code IN ('I', 'D', 'U')

Line 1465: FROM GL_ACCESS_SET_NORM_ASSIGN glasna,

1461: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1462: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
1463: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1464: glasna.start_date, glasna.end_date
1465: FROM GL_ACCESS_SET_NORM_ASSIGN glasna,
1466: GL_ACCESS_SETS glas,
1467: GL_LEDGER_SET_ASSIGNMENTS gllsa,
1468: GL_SEG_VAL_HIERARCHIES glsvh
1469: WHERE glasna.status_code IN ('I', 'D', 'U')

Line 1900: -- to clean up GL_ACCESS_SET_NORM_ASSIGN

1896: GL_MESSAGE.Func_Ent
1897: (func_name => 'GL_FLATTEN_ACCESS_SETS.Clean_Up_By_Coa');
1898:
1899: -- Run the following statements using the right parameters
1900: -- to clean up GL_ACCESS_SET_NORM_ASSIGN
1901:
1902: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
1903: GL_MESSAGE.Write_Log
1904: (msg_name => 'SHRD0180',

Line 1909: v2 => 'Deleting records from GL_ACCESS_SET_NORM_ASSIGN...');

1905: token_num => 2,
1906: t1 => 'ROUTINE',
1907: v1 => 'Clean_Up_By_Coa()',
1908: t2 => 'ACTION',
1909: v2 => 'Deleting records from GL_ACCESS_SET_NORM_ASSIGN...');
1910: END IF;
1911:
1912: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_OP_MODE = 'AS') THEN
1913:

Line 1914: DELETE from GL_ACCESS_SET_NORM_ASSIGN

1910: END IF;
1911:
1912: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_OP_MODE = 'AS') THEN
1913:
1914: DELETE from GL_ACCESS_SET_NORM_ASSIGN
1915: WHERE status_code = 'D'
1916: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
1917: AND access_set_id IN
1918: (SELECT access_set_id

Line 1926: DELETE from GL_ACCESS_SET_NORM_ASSIGN

1922: AND automatically_created_flag = 'N');
1923:
1924: ELSIF (GL_FLATTEN_SETUP_DATA.GLSTFL_OP_MODE IN ('LH', 'VH')) THEN
1925:
1926: DELETE from GL_ACCESS_SET_NORM_ASSIGN
1927: WHERE status_code = 'D'
1928: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
1929: AND access_set_id IN
1930: (SELECT implicit_access_set_id

Line 1944: v2 => 'GL_ACCESS_SET_NORM_ASSIGN');

1940: token_num => 2,
1941: t1 => 'NUM',
1942: v1 => TO_CHAR(row_count),
1943: t2 => 'TABLE',
1944: v2 => 'GL_ACCESS_SET_NORM_ASSIGN');
1945: row_count := 0;
1946:
1947: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
1948: GL_MESSAGE.Write_Log

Line 1954: v2 => 'Updating records in GL_ACCESS_SET_NORM_ASSIGN...');

1950: token_num => 2,
1951: t1 => 'ROUTINE',
1952: v1 => 'Clean_Up_By_Coa()',
1953: t2 => 'ACTION',
1954: v2 => 'Updating records in GL_ACCESS_SET_NORM_ASSIGN...');
1955: END IF;
1956:
1957: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_OP_MODE IN ('LS', 'VS')) THEN
1958:

Line 1959: UPDATE GL_ACCESS_SET_NORM_ASSIGN

1955: END IF;
1956:
1957: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_OP_MODE IN ('LS', 'VS')) THEN
1958:
1959: UPDATE GL_ACCESS_SET_NORM_ASSIGN
1960: SET status_code = NULL, request_id = NULL
1961: WHERE status_code IN ('I', 'U')
1962: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
1963: AND access_set_id IN

Line 1972: UPDATE GL_ACCESS_SET_NORM_ASSIGN

1968: AND object_type_code = 'S');
1969:
1970: ELSIF (GL_FLATTEN_SETUP_DATA.GLSTFL_OP_MODE = 'AS') THEN
1971:
1972: UPDATE GL_ACCESS_SET_NORM_ASSIGN
1973: SET status_code = NULL, request_id = NULL
1974: WHERE status_code IN ('I', 'U')
1975: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
1976: AND access_set_id IN

Line 1985: UPDATE GL_ACCESS_SET_NORM_ASSIGN

1981: AND automatically_created_flag = 'N');
1982:
1983: ELSIF (GL_FLATTEN_SETUP_DATA.GLSTFL_OP_MODE IN ('LH', 'VH')) THEN
1984:
1985: UPDATE GL_ACCESS_SET_NORM_ASSIGN
1986: SET status_code = NULL, request_id = NULL
1987: WHERE status_code IN ('I', 'U')
1988: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
1989: AND access_set_id IN

Line 2004: v2 => 'GL_ACCESS_SET_NORM_ASSIGN');

2000: token_num => 2,
2001: t1 => 'NUM',
2002: v1 => TO_CHAR(row_count),
2003: t2 => 'TABLE',
2004: v2 => 'GL_ACCESS_SET_NORM_ASSIGN');
2005: row_count := 0;
2006:
2007: GL_MESSAGE.Func_Succ
2008: (func_name => 'GL_FLATTEN_ACCESS_SETS.Clean_Up_By_Coa');