APPS.GL_FLATTEN_SETUP_DATA dependencies on GL_LEDGER_NORM_SEG_VALS

Line 276: -- 1) GL_LEDGER_NORM_SEG_VALS: LV, VH, VS

272: END IF;
273:
274: -- Populate the REQUEST_ID column of the various norm tables based
275: -- on the operation mode.
276: -- 1) GL_LEDGER_NORM_SEG_VALS: LV, VH, VS
277: -- 2) GL_LEDGER___NORM___HIERARCHY: VH, LH
278: -- 3) GL_LEDGER_SET_NORM_ASSIGN: VS, LS
279: -- 4) GL_ACCESS_SET_NORM_ASSIGN: AS
280: IF (GLSTFL_OP_MODE IN ('LV', 'VH', 'VS')) THEN

Line 289: 'GL_LEDGER_NORM_SEG_VALS by populating ' ||

285: t1 => 'ROUTINE',
286: v1 => 'Main()',
287: t2 => 'ACTION',
288: v2 => 'Locking down changed records in ' ||
289: 'GL_LEDGER_NORM_SEG_VALS by populating ' ||
290: 'the REQUEST_ID column...');
291: END IF;
292:
293: UPDATE GL_LEDGER_NORM_SEG_VALS

Line 293: UPDATE GL_LEDGER_NORM_SEG_VALS

289: 'GL_LEDGER_NORM_SEG_VALS by populating ' ||
290: 'the REQUEST_ID column...');
291: END IF;
292:
293: UPDATE GL_LEDGER_NORM_SEG_VALS
294: SET request_id = GLSTFL_REQ_ID
295: WHERE status_code is NOT NULL
296: AND ledger_id IN ( SELECT LEDGER_ID FROM GL_LEDGERS
297: WHERE chart_of_accounts_id =

Line 307: v2 => 'GL_LEDGER_NORM_SEG_VALS');

303: token_num => 2,
304: t1 => 'NUM',
305: v1 => TO_CHAR(row_count),
306: t2 => 'TABLE',
307: v2 => 'GL_LEDGER_NORM_SEG_VALS');
308:
309: row_count := 0;
310: END IF;
311: END IF;