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_CC_MGR_SUP_C dependencies on FII_CC_MGR_HIER_GT

Line 114: -- Populate the TMP table: FII_CC_MGR_HIER_GT

110: raise;
111: END Init;
112:
113: --**********************************************************************
114: -- Populate the TMP table: FII_CC_MGR_HIER_GT
115:
116: PROCEDURE Populate_HIER_TMP IS
117:
118: l_status VARCHAR2(1);

Line 166: --Begin to populate the table FII_CC_MGR_HIER_GT

162: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_PERSON_ID_TMP');
163: end if;
164:
165: ----------------------------------------------------------
166: --Begin to populate the table FII_CC_MGR_HIER_GT
167: ----------------------------------------------------------
168: FII_UTIL.start_timer;
169: g_phase := 'Truncate table FII_CC_MGR_HIER_GT';
170:

Line 169: g_phase := 'Truncate table FII_CC_MGR_HIER_GT';

165: ----------------------------------------------------------
166: --Begin to populate the table FII_CC_MGR_HIER_GT
167: ----------------------------------------------------------
168: FII_UTIL.start_timer;
169: g_phase := 'Truncate table FII_CC_MGR_HIER_GT';
170:
171: TRUNCATE_TABLE ('FII_CC_MGR_HIER_GT');
172:
173: g_phase := 'Insert into table FII_CC_MGR_HIER_GT';

Line 171: TRUNCATE_TABLE ('FII_CC_MGR_HIER_GT');

167: ----------------------------------------------------------
168: FII_UTIL.start_timer;
169: g_phase := 'Truncate table FII_CC_MGR_HIER_GT';
170:
171: TRUNCATE_TABLE ('FII_CC_MGR_HIER_GT');
172:
173: g_phase := 'Insert into table FII_CC_MGR_HIER_GT';
174:
175: --We populate aggregation_flag to 'N' if child_level is greater

Line 173: g_phase := 'Insert into table FII_CC_MGR_HIER_GT';

169: g_phase := 'Truncate table FII_CC_MGR_HIER_GT';
170:
171: TRUNCATE_TABLE ('FII_CC_MGR_HIER_GT');
172:
173: g_phase := 'Insert into table FII_CC_MGR_HIER_GT';
174:
175: --We populate aggregation_flag to 'N' if child_level is greater
176: --than the profile option for aggregation level
177:

Line 178: INSERT INTO FII_CC_MGR_HIER_GT

174:
175: --We populate aggregation_flag to 'N' if child_level is greater
176: --than the profile option for aggregation level
177:
178: INSERT INTO FII_CC_MGR_HIER_GT
179: (MGR_ID,
180: MGR_LEVEL,
181: DIRECT_ID,
182: DIRECT_LEVEL,

Line 217: ' rows of data into FII_CC_MGR_HIER_GT table');

213: ---------------------------------------------------------------
214:
215: if g_debug_flag = 'Y' then
216: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT ||
217: ' rows of data into FII_CC_MGR_HIER_GT table');
218: end if;
219:
220: --Set mgr_id to -999 and mgr_level to 0 for records of
221: -- mgr_level = 1 and direct_level = 1

Line 224: Update FII_CC_MGR_HIER_GT

220: --Set mgr_id to -999 and mgr_level to 0 for records of
221: -- mgr_level = 1 and direct_level = 1
222: g_phase := 'Update MGR_ID and MGR_LEVEL for records of top person';
223:
224: Update FII_CC_MGR_HIER_GT
225: Set mgr_id = -999,
226: mgr_level = 0
227: Where mgr_level = 1
228: and direct_level = 1;

Line 231: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CC_MGR_HIER_GT');

227: Where mgr_level = 1
228: and direct_level = 1;
229:
230: if g_debug_flag = 'Y' then
231: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CC_MGR_HIER_GT');
232: end if;
233:
234: --Insert all self records (using mgr_id = -999)
235: g_phase := 'Insert all self records';

Line 237: Insert into FII_CC_MGR_HIER_GT

233:
234: --Insert all self records (using mgr_id = -999)
235: g_phase := 'Insert all self records';
236:
237: Insert into FII_CC_MGR_HIER_GT
238: (MGR_ID,
239: MGR_LEVEL,
240: DIRECT_ID,
241: DIRECT_LEVEL,

Line 257: from FII_CC_MGR_HIER_GT

253: EMP_LEVEL,
254: 'N',
255: 'N',
256: AGGREGATION_FLAG
257: from FII_CC_MGR_HIER_GT
258: where mgr_id = -999;
259:
260: if g_debug_flag = 'Y' then
261: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_CC_MGR_HIER_GT');

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

257: from FII_CC_MGR_HIER_GT
258: where mgr_id = -999;
259:
260: if g_debug_flag = 'Y' then
261: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_CC_MGR_HIER_GT');
262: end if;
263:
264: --Update the column next_level_is_leaf
265: g_phase := 'Update column next_level_is_leaf...';

Line 267: Update FII_CC_MGR_HIER_GT tab1

263:
264: --Update the column next_level_is_leaf
265: g_phase := 'Update column next_level_is_leaf...';
266:
267: Update FII_CC_MGR_HIER_GT tab1
268: Set tab1.next_level_is_leaf = 'Y'
269: Where tab1.direct_id = tab1.emp_id
270: AND tab1.aggregation_flag = 'Y'
271: AND 1 = (select count(*)

Line 272: from FII_CC_MGR_HIER_GT tab2

268: Set tab1.next_level_is_leaf = 'Y'
269: Where tab1.direct_id = tab1.emp_id
270: AND tab1.aggregation_flag = 'Y'
271: AND 1 = (select count(*)
272: from FII_CC_MGR_HIER_GT tab2
273: where tab2.mgr_id = tab1.direct_id
274: and tab2.aggregation_flag = 'Y');
275:
276: if g_debug_flag = 'Y' then

Line 277: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CC_MGR_HIER_GT');

273: where tab2.mgr_id = tab1.direct_id
274: and tab2.aggregation_flag = 'Y');
275:
276: if g_debug_flag = 'Y' then
277: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CC_MGR_HIER_GT');
278: end if;
279:
280: --Update the column is_leaf_flag
281: g_phase := 'Update column is_leaf_flag...';

Line 283: Update FII_CC_MGR_HIER_GT

279:
280: --Update the column is_leaf_flag
281: g_phase := 'Update column is_leaf_flag...';
282:
283: Update FII_CC_MGR_HIER_GT
284: Set is_leaf_flag = 'Y'
285: Where mgr_id = direct_id
286: and direct_id = emp_id
287: and next_level_is_leaf = 'Y';

Line 290: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CC_MGR_HIER_GT');

286: and direct_id = emp_id
287: and next_level_is_leaf = 'Y';
288:
289: if g_debug_flag = 'Y' then
290: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in FII_CC_MGR_HIER_GT');
291: end if;
292:
293: FII_UTIL.stop_timer;
294:

Line 328: --call to populate the table FII_CC_MGR_HIER_GT

324: FII_MESSAGE.Func_Ent('FII_CC_MGR_SUP_C.Incre_Update');
325: end if;
326:
327: ----------------------------------------------------------
328: --call to populate the table FII_CC_MGR_HIER_GT
329: ----------------------------------------------------------
330: g_phase := 'call to populate the table FII_CC_MGR_HIER_GT';
331:
332: Populate_HIER_TMP;

Line 330: g_phase := 'call to populate the table FII_CC_MGR_HIER_GT';

326:
327: ----------------------------------------------------------
328: --call to populate the table FII_CC_MGR_HIER_GT
329: ----------------------------------------------------------
330: g_phase := 'call to populate the table FII_CC_MGR_HIER_GT';
331:
332: Populate_HIER_TMP;
333:
334: ----------------------------------------------------------

Line 336: --by diff FII_CC_MGR_HIER_GT and FII_CC_MGR_HIERARCHIES

332: Populate_HIER_TMP;
333:
334: ----------------------------------------------------------
335: --Begin to update the table FII_CC_MGR_HIERARCHIES
336: --by diff FII_CC_MGR_HIER_GT and FII_CC_MGR_HIERARCHIES
337: --for incremental update
338: ----------------------------------------------------------
339:
340: FII_UTIL.start_timer;

Line 353: FROM FII_CC_MGR_HIER_GT

349: FROM FII_CC_MGR_HIERARCHIES
350: MINUS
351: SELECT mgr_id, mgr_level, direct_id, direct_level,
352: emp_id, emp_level, next_level_is_leaf, is_leaf_flag
353: FROM FII_CC_MGR_HIER_GT
354: WHERE aggregation_flag = 'Y');
355:
356: if g_debug_flag = 'Y' then
357: FII_UTIL.Write_Log('Deleted ' || SQL%ROWCOUNT || ' rows from FII_CC_MGR_HIERARCHIES');

Line 389: FROM FII_CC_MGR_HIER_GT

385: G_FII_USER_ID,
386: SYSDATE,
387: G_FII_USER_ID,
388: G_FII_LOGIN_ID
389: FROM FII_CC_MGR_HIER_GT
390: WHERE aggregation_flag = 'Y'
391: MINUS
392: SELECT mgr_id,
393: mgr_level,

Line 470: --call to populate the table FII_CC_MGR_HIER_GT

466: FII_MESSAGE.Func_Ent('FII_CC_MGR_SUP_C.Init_Load');
467: end if;
468:
469: ----------------------------------------------------------
470: --call to populate the table FII_CC_MGR_HIER_GT
471: ----------------------------------------------------------
472: g_phase := 'call to populate the table FII_CC_MGR_HIER_GT';
473:
474: Populate_HIER_TMP;

Line 472: g_phase := 'call to populate the table FII_CC_MGR_HIER_GT';

468:
469: ----------------------------------------------------------
470: --call to populate the table FII_CC_MGR_HIER_GT
471: ----------------------------------------------------------
472: g_phase := 'call to populate the table FII_CC_MGR_HIER_GT';
473:
474: Populate_HIER_TMP;
475:
476: g_phase := 'Truncate table FII_CC_MGR_HIERARCHIES';

Line 511: FII_CC_MGR_HIER_GT

507: SYSDATE,
508: G_FII_USER_ID,
509: G_FII_LOGIN_ID
510: from
511: FII_CC_MGR_HIER_GT
512: where AGGREGATION_FLAG = 'Y';
513:
514:
515: ---------------------------------------------------------------