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.FII_GL_CCID_C dependencies on FII_CCID_SLG_GT

Line 259: -- This procedure populates the global temp table FII_CCID_SLG_GT

255: END GET_ACCT_SEGMENTS;
256:
257: -----------------------------------------------------------------------------
258: -- PROCEDURE POPULATE_SLG_TMP
259: -- This procedure populates the global temp table FII_CCID_SLG_GT
260: -----------------------------------------------------------------------------
261: Procedure POPULATE_SLG_TMP IS
262:
263: l_coa_id number(15);

Line 269: from FII_CCID_SLG_GT

265: l_stmt varchar2(1000);
266:
267: Cursor tmp_coa_list IS
268: select distinct COA_ID
269: from FII_CCID_SLG_GT
270: where BAL_SEG_VALUE_ID = -1;
271:
272: Begin
273:

Line 279: FII_UTIL.Write_Log('Insert to FII_CCID_SLG_GT by select DISTINCT ');

275: FII_MESSAGE.Func_Ent('FII_GL_CCID_C.POPULATE_SLG_TMP');
276: End if;
277:
278: IF g_debug_flag = 'Y' then
279: FII_UTIL.Write_Log('Insert to FII_CCID_SLG_GT by select DISTINCT ');
280: END IF;
281:
282: insert into FII_CCID_SLG_GT
283: (COA_ID,

Line 282: insert into FII_CCID_SLG_GT

278: IF g_debug_flag = 'Y' then
279: FII_UTIL.Write_Log('Insert to FII_CCID_SLG_GT by select DISTINCT ');
280: END IF;
281:
282: insert into FII_CCID_SLG_GT
283: (COA_ID,
284: BAL_SEG_VALUE,
285: BAL_SEG_VALUE_ID)
286: select DISTINCT

Line 296: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_CCID_SLG_GT');

292: where slg.usage_code = 'DBI'
293: and slg.source_ledger_group_id = sts.source_ledger_group_id;
294:
295: If g_debug_flag = 'Y' then
296: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_CCID_SLG_GT');
297: End if;
298:
299: IF g_debug_flag = 'Y' then
300: FII_UTIL.Write_Log('Update FII_CCID_SLG_GT for BAL_SEG_VALUE_ID = -1 (insert all company values)');

Line 300: FII_UTIL.Write_Log('Update FII_CCID_SLG_GT for BAL_SEG_VALUE_ID = -1 (insert all company values)');

296: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_CCID_SLG_GT');
297: End if;
298:
299: IF g_debug_flag = 'Y' then
300: FII_UTIL.Write_Log('Update FII_CCID_SLG_GT for BAL_SEG_VALUE_ID = -1 (insert all company values)');
301: END IF;
302:
303: For l_coa_rec IN tmp_coa_list LOOP
304: l_coa_id := l_coa_rec.COA_ID;

Line 306: delete from FII_CCID_SLG_GT where COA_ID = l_coa_id;

302:
303: For l_coa_rec IN tmp_coa_list LOOP
304: l_coa_id := l_coa_rec.COA_ID;
305:
306: delete from FII_CCID_SLG_GT where COA_ID = l_coa_id;
307:
308: SELECT application_column_name INTO l_company_seg
309: FROM FND_SEGMENT_ATTRIBUTE_VALUES
310: WHERE application_id = 101

Line 316: l_stmt := 'INSERT INTO FII_CCID_SLG_GT

312: AND id_flex_num = l_coa_id
313: AND segment_attribute_type = 'GL_BALANCING'
314: AND attribute_value = 'Y';
315:
316: l_stmt := 'INSERT INTO FII_CCID_SLG_GT
317: (COA_ID,
318: BAL_SEG_VALUE,
319: BAL_SEG_VALUE_ID)
320: SELECT DISTINCT

Line 337: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_CCID_SLG_GT');

333:
334: EXECUTE IMMEDIATE l_stmt;
335:
336: If g_debug_flag = 'Y' then
337: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_CCID_SLG_GT');
338: End if;
339:
340: END LOOP;
341:

Line 440: FII_CCID_SLG_GT csg,

436: and natural_seg_name = ''' || p_natural_seg || '''
437: and nvl(udd1_seg_name, 1) = nvl(''' || p_ud1_seg || ''',1)
438: and nvl(udd2_seg_name, 1) =nvl(''' || p_ud2_seg || ''',1)
439: ) accts,
440: FII_CCID_SLG_GT csg,
441: fnd_id_flex_segments seg1,
442: fnd_id_flex_segments seg2,
443: fnd_id_flex_segments seg3,
444: GL_CODE_COMBINATIONS glcc,

Line 618: FII_CCID_SLG_GT csg,

614: and natural_seg_name = ''' || p_natural_seg || '''
615: and nvl(udd1_seg_name, 1) = nvl('''|| p_ud1_seg ||''',1)
616: and nvl(udd2_seg_name, 1) =nvl('''|| p_ud2_seg ||''',1)
617: ) accts,
618: FII_CCID_SLG_GT csg,
619: fnd_id_flex_segments seg1,
620: fnd_id_flex_segments seg2,
621: fnd_id_flex_segments seg3,
622: GL_CODE_COMBINATIONS glcc,

Line 2301: -- Populate the global temp table FII_CCID_SLG_GT

2297:
2298: INIT_DBI_CHANGE_LOG;
2299:
2300: ---------------------------------------------------
2301: -- Populate the global temp table FII_CCID_SLG_GT
2302: ---------------------------------------------------
2303: g_phase := 'Call POPULATE_SLG_TMP';
2304:
2305: POPULATE_SLG_TMP;