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_TOP_SPENDERS_PKG dependencies on FII_TOP_SPENDERS_STG

Line 49: g_phase := 'Truncate table FII_TOP_SPENDERS_STG';

45:
46: ----------------------------------------------------------
47: -- Truncate staging and base tables
48: ----------------------------------------------------------
49: g_phase := 'Truncate table FII_TOP_SPENDERS_STG';
50: FII_UTIL.truncate_table ('FII_TOP_SPENDERS_STG', 'FII', g_retcode);
51:
52: g_phase := 'Truncate table FII_TOP_SPNDR_SUM_B';
53: FII_UTIL.truncate_table ('FII_TOP_SPNDR_SUM_B', 'FII', g_retcode);

Line 50: FII_UTIL.truncate_table ('FII_TOP_SPENDERS_STG', 'FII', g_retcode);

46: ----------------------------------------------------------
47: -- Truncate staging and base tables
48: ----------------------------------------------------------
49: g_phase := 'Truncate table FII_TOP_SPENDERS_STG';
50: FII_UTIL.truncate_table ('FII_TOP_SPENDERS_STG', 'FII', g_retcode);
51:
52: g_phase := 'Truncate table FII_TOP_SPNDR_SUM_B';
53: FII_UTIL.truncate_table ('FII_TOP_SPNDR_SUM_B', 'FII', g_retcode);
54:

Line 83: fii_util.write_log('Populating month slices in fii_top_spenders_stg table');

79:
80: BEGIN
81:
82: if g_debug_flag = 'Y' then
83: fii_util.write_log('Populating month slices in fii_top_spenders_stg table');
84: end if;
85:
86: g_phase := 'Insert month slices into fii_top_spenders_stg table';
87:

Line 86: g_phase := 'Insert month slices into fii_top_spenders_stg table';

82: if g_debug_flag = 'Y' then
83: fii_util.write_log('Populating month slices in fii_top_spenders_stg table');
84: end if;
85:
86: g_phase := 'Insert month slices into fii_top_spenders_stg table';
87:
88: INSERT /*+ append parallel(stg) */ INTO FII_TOP_SPENDERS_STG (
89: period_id,
90: slice_type_flag,

Line 88: INSERT /+ append parallel(stg) / INTO FII_TOP_SPENDERS_STG (

84: end if;
85:
86: g_phase := 'Insert month slices into fii_top_spenders_stg table';
87:
88: INSERT /*+ append parallel(stg) */ INTO FII_TOP_SPENDERS_STG (
89: period_id,
90: slice_type_flag,
91: qtr_id,
92: year_id,

Line 126: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPENDERS_STG');

122: and b.COST_CENTER_ID = m.COST_CENTER_ID
123: GROUP BY m.COMPANY_COST_CENTER_ORG_ID, b.employee_id, t.ENT_YEAR_ID, t.ENT_QTR_ID, t.ENT_PERIOD_ID;
124:
125: if g_debug_flag = 'Y' then
126: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPENDERS_STG');
127: end if;
128:
129: commit;
130:

Line 150: fii_util.write_log('Populating quarter slices in fii_top_spenders_stg table');

146:
147: BEGIN
148:
149: if g_debug_flag = 'Y' then
150: fii_util.write_log('Populating quarter slices in fii_top_spenders_stg table');
151: end if;
152:
153: g_phase := 'Insert quarter slices into fii_top_spenders_stg table';
154:

Line 153: g_phase := 'Insert quarter slices into fii_top_spenders_stg table';

149: if g_debug_flag = 'Y' then
150: fii_util.write_log('Populating quarter slices in fii_top_spenders_stg table');
151: end if;
152:
153: g_phase := 'Insert quarter slices into fii_top_spenders_stg table';
154:
155: INSERT /*+ append parallel(stg) */ INTO FII_TOP_SPENDERS_STG (
156: period_id,
157: slice_type_flag,

Line 155: INSERT /+ append parallel(stg) / INTO FII_TOP_SPENDERS_STG (

151: end if;
152:
153: g_phase := 'Insert quarter slices into fii_top_spenders_stg table';
154:
155: INSERT /*+ append parallel(stg) */ INTO FII_TOP_SPENDERS_STG (
156: period_id,
157: slice_type_flag,
158: qtr_id,
159: year_id,

Line 186: FROM fii_top_spenders_stg t;

182: g_fii_user_id,
183: sysdate,
184: g_fii_user_id,
185: g_fii_login_id
186: FROM fii_top_spenders_stg t;
187:
188: if g_debug_flag = 'Y' then
189: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPENDERS_STG');
190: end if;

Line 189: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPENDERS_STG');

185: g_fii_login_id
186: FROM fii_top_spenders_stg t;
187:
188: if g_debug_flag = 'Y' then
189: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPENDERS_STG');
190: end if;
191:
192: commit;
193:

Line 214: fii_util.write_log('Populating year slices in fii_top_spenders_stg table');

210:
211: BEGIN
212:
213: if g_debug_flag = 'Y' then
214: fii_util.write_log('Populating year slices in fii_top_spenders_stg table');
215: end if;
216:
217: g_phase := 'Insert year slices into fii_top_spenders_stg table';
218:

Line 217: g_phase := 'Insert year slices into fii_top_spenders_stg table';

213: if g_debug_flag = 'Y' then
214: fii_util.write_log('Populating year slices in fii_top_spenders_stg table');
215: end if;
216:
217: g_phase := 'Insert year slices into fii_top_spenders_stg table';
218:
219: INSERT /*+ append parallel(stg) */ INTO FII_TOP_SPENDERS_STG (
220: period_id,
221: slice_type_flag,

Line 219: INSERT /+ append parallel(stg) / INTO FII_TOP_SPENDERS_STG (

215: end if;
216:
217: g_phase := 'Insert year slices into fii_top_spenders_stg table';
218:
219: INSERT /*+ append parallel(stg) */ INTO FII_TOP_SPENDERS_STG (
220: period_id,
221: slice_type_flag,
222: qtr_id,
223: year_id,

Line 249: FROM fii_top_spenders_stg b

245: g_fii_user_id,
246: sysdate,
247: g_fii_user_id,
248: g_fii_login_id
249: FROM fii_top_spenders_stg b
250: WHERE b.slice_type_flag = 'M';
251:
252: if g_debug_flag = 'Y' then
253: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPENDERS_STG');

Line 253: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPENDERS_STG');

249: FROM fii_top_spenders_stg b
250: WHERE b.slice_type_flag = 'M';
251:
252: if g_debug_flag = 'Y' then
253: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPENDERS_STG');
254: end if;
255:
256: commit;
257:

Line 320: FROM fii_org_mgr_mappings help, fii_top_spenders_stg stg

316: ORDER BY sum(stg.prim_amount_g) DESC) AS RANK_WITHIN_MANAGER_ptd ,
317: sum(stg.prim_amount_g) prim_ptd_g,
318: sum(stg.sec_amount_g) sec_ptd_g,
319: sum(stg.no_of_exp_rpts) no_of_exp_rpts_ptd
320: FROM fii_org_mgr_mappings help, fii_top_spenders_stg stg
321: WHERE help.ccc_org_id = stg.ccc_org_id
322: GROUP BY stg.person_id ,
323: stg.period_id ,
324: stg.slice_type_flag,