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_USER_SEC_OPTIMIZER dependencies on FII_COST_CENTER_GRANTS

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

45: g_fii_user_id := FND_GLOBAL.User_Id;
46: g_fii_login_id := FND_GLOBAL.Login_Id;
47:
48: IF g_debug_flag = 'Y' THEN
49: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows into fii_cost_center_grants.');
50: END IF;
51:
52:
53: -------------------------------------------------------------

Line 56: g_phase := 'Truncating grants tables FII_COMPANY_GRANTS and FII_COST_CENTER_GRANTS...';

52:
53: -------------------------------------------------------------
54: --- Truncate grants tables ---------------------------------
55: ------------------------------------------------------------
56: g_phase := 'Truncating grants tables FII_COMPANY_GRANTS and FII_COST_CENTER_GRANTS...';
57: if g_debug_flag = 'Y' then
58: FII_UTIL.write_log(g_phase);
59: end if;
60:

Line 66: fii_util.truncate_table('FII_COST_CENTER_GRANTS', 'FII', l_retcode);

62: IF l_retcode = -1 then
63: fii_util.write_log('Error in fii_util.truncate_table(''FII_COMPANY_GRANTS'', ''FII'', l_retcode)');
64: raise FIIUSECB_fatal_err;
65: END IF;
66: fii_util.truncate_table('FII_COST_CENTER_GRANTS', 'FII', l_retcode);
67: IF l_retcode = -1 then
68: fii_util.write_log('Error in fii_util.truncate_table(''FII_COST_CENTER_GRANTS'', ''FII'', l_retcode)');
69: raise FIIUSECB_fatal_err;
70: END IF;

Line 68: fii_util.write_log('Error in fii_util.truncate_table(''FII_COST_CENTER_GRANTS'', ''FII'', l_retcode)');

64: raise FIIUSECB_fatal_err;
65: END IF;
66: fii_util.truncate_table('FII_COST_CENTER_GRANTS', 'FII', l_retcode);
67: IF l_retcode = -1 then
68: fii_util.write_log('Error in fii_util.truncate_table(''FII_COST_CENTER_GRANTS'', ''FII'', l_retcode)');
69: raise FIIUSECB_fatal_err;
70: END IF;
71:
72: g_phase := 'Selecting top nodes for company and cost center dimensions from fii_financial_dimensions.';

Line 115: g_phase := 'Inserting into fii_cost_center_grants from bis_grants_v.';

111: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows into fii_company_grants.');
112: END IF;
113: --DBMS_OUTPUT.PUT_LINE('Inserted ' || SQL%ROWCOUNT || ' rows into fii_company_grants.');
114:
115: g_phase := 'Inserting into fii_cost_center_grants from bis_grants_v.';
116:
117: INSERT INTO fii_cost_center_grants
118: (user_id,
119: report_region_code,

Line 117: INSERT INTO fii_cost_center_grants

113: --DBMS_OUTPUT.PUT_LINE('Inserted ' || SQL%ROWCOUNT || ' rows into fii_company_grants.');
114:
115: g_phase := 'Inserting into fii_cost_center_grants from bis_grants_v.';
116:
117: INSERT INTO fii_cost_center_grants
118: (user_id,
119: report_region_code,
120: cost_center_id,
121: aggregated_flag,

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

139: AND (sysdate BETWEEN TRUNC(s.start_date) AND nvl(TRUNC(s.end_date),to_date('12-31-9999','MM-DD-YYYY')))
140: AND s.granted_to = u.employee_id);
141:
142: IF g_debug_flag = 'Y' THEN
143: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows into fii_cost_center_grants.');
144: END IF;
145: --DBMS_OUTPUT.PUT_LINE('Inserted ' || SQL%ROWCOUNT || ' rows into fii_cost_center_grants.');
146:
147: g_phase := 'Filtering out child company assignments from fii_company_grants.';

Line 145: --DBMS_OUTPUT.PUT_LINE('Inserted ' || SQL%ROWCOUNT || ' rows into fii_cost_center_grants.');

141:
142: IF g_debug_flag = 'Y' THEN
143: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows into fii_cost_center_grants.');
144: END IF;
145: --DBMS_OUTPUT.PUT_LINE('Inserted ' || SQL%ROWCOUNT || ' rows into fii_cost_center_grants.');
146:
147: g_phase := 'Filtering out child company assignments from fii_company_grants.';
148:
149: DELETE FROM fii_company_grants

Line 161: g_phase := 'Filtering out child cost center assignments from fii_cost_center_grants.';

157: FII_UTIL.Write_Log ('Deleted ' || SQL%ROWCOUNT || ' rows from fii_company_grants.');
158: END IF;
159: --DBMS_OUTPUT.PUT_LINE('Deleted ' || SQL%ROWCOUNT || ' rows from fii_company_grants.');
160:
161: g_phase := 'Filtering out child cost center assignments from fii_cost_center_grants.';
162:
163: DELETE FROM fii_cost_center_grants
164: WHERE (user_id, report_region_code, cost_center_id) IN
165: (SELECT s.user_id, s.report_region_code, s.cost_center_id FROM fii_cost_center_grants s, fii_cost_ctr_hierarchies h

Line 163: DELETE FROM fii_cost_center_grants

159: --DBMS_OUTPUT.PUT_LINE('Deleted ' || SQL%ROWCOUNT || ' rows from fii_company_grants.');
160:
161: g_phase := 'Filtering out child cost center assignments from fii_cost_center_grants.';
162:
163: DELETE FROM fii_cost_center_grants
164: WHERE (user_id, report_region_code, cost_center_id) IN
165: (SELECT s.user_id, s.report_region_code, s.cost_center_id FROM fii_cost_center_grants s, fii_cost_ctr_hierarchies h
166: WHERE s.cost_center_id = h.child_cc_id
167: AND h.parent_cc_id IN (SELECT cost_center_id from fii_cost_center_grants where user_id=s.user_id and report_region_code=s.report_region_code)

Line 165: (SELECT s.user_id, s.report_region_code, s.cost_center_id FROM fii_cost_center_grants s, fii_cost_ctr_hierarchies h

161: g_phase := 'Filtering out child cost center assignments from fii_cost_center_grants.';
162:
163: DELETE FROM fii_cost_center_grants
164: WHERE (user_id, report_region_code, cost_center_id) IN
165: (SELECT s.user_id, s.report_region_code, s.cost_center_id FROM fii_cost_center_grants s, fii_cost_ctr_hierarchies h
166: WHERE s.cost_center_id = h.child_cc_id
167: AND h.parent_cc_id IN (SELECT cost_center_id from fii_cost_center_grants where user_id=s.user_id and report_region_code=s.report_region_code)
168: AND h.parent_cc_id <> h.child_cc_id);
169:

Line 167: AND h.parent_cc_id IN (SELECT cost_center_id from fii_cost_center_grants where user_id=s.user_id and report_region_code=s.report_region_code)

163: DELETE FROM fii_cost_center_grants
164: WHERE (user_id, report_region_code, cost_center_id) IN
165: (SELECT s.user_id, s.report_region_code, s.cost_center_id FROM fii_cost_center_grants s, fii_cost_ctr_hierarchies h
166: WHERE s.cost_center_id = h.child_cc_id
167: AND h.parent_cc_id IN (SELECT cost_center_id from fii_cost_center_grants where user_id=s.user_id and report_region_code=s.report_region_code)
168: AND h.parent_cc_id <> h.child_cc_id);
169:
170: IF g_debug_flag = 'Y' THEN
171: FII_UTIL.Write_Log ('Deleted ' || SQL%ROWCOUNT || ' rows from fii_cost_center_grants.');

Line 171: FII_UTIL.Write_Log ('Deleted ' || SQL%ROWCOUNT || ' rows from fii_cost_center_grants.');

167: AND h.parent_cc_id IN (SELECT cost_center_id from fii_cost_center_grants where user_id=s.user_id and report_region_code=s.report_region_code)
168: AND h.parent_cc_id <> h.child_cc_id);
169:
170: IF g_debug_flag = 'Y' THEN
171: FII_UTIL.Write_Log ('Deleted ' || SQL%ROWCOUNT || ' rows from fii_cost_center_grants.');
172: END IF;
173: --DBMS_OUTPUT.PUT_LINE('Deleted ' || SQL%ROWCOUNT || ' rows from fii_cost_center_grants.');
174:
175: --Call FND_STATS to collect statistics after populating the table

Line 173: --DBMS_OUTPUT.PUT_LINE('Deleted ' || SQL%ROWCOUNT || ' rows from fii_cost_center_grants.');

169:
170: IF g_debug_flag = 'Y' THEN
171: FII_UTIL.Write_Log ('Deleted ' || SQL%ROWCOUNT || ' rows from fii_cost_center_grants.');
172: END IF;
173: --DBMS_OUTPUT.PUT_LINE('Deleted ' || SQL%ROWCOUNT || ' rows from fii_cost_center_grants.');
174:
175: --Call FND_STATS to collect statistics after populating the table
176: g_phase := 'gather_table_stats for fii_cost_center_grants';
177: FND_STATS.gather_table_stats

Line 176: g_phase := 'gather_table_stats for fii_cost_center_grants';

172: END IF;
173: --DBMS_OUTPUT.PUT_LINE('Deleted ' || SQL%ROWCOUNT || ' rows from fii_cost_center_grants.');
174:
175: --Call FND_STATS to collect statistics after populating the table
176: g_phase := 'gather_table_stats for fii_cost_center_grants';
177: FND_STATS.gather_table_stats
178: (ownname => g_schema_name,
179: tabname => 'fii_cost_center_grants');
180:

Line 179: tabname => 'fii_cost_center_grants');

175: --Call FND_STATS to collect statistics after populating the table
176: g_phase := 'gather_table_stats for fii_cost_center_grants';
177: FND_STATS.gather_table_stats
178: (ownname => g_schema_name,
179: tabname => 'fii_cost_center_grants');
180:
181: EXCEPTION
182: WHEN FIIUSECB_fatal_err THEN
183: FII_UTIL.write_log('Fatal errors occured:');