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_COMPANY_GRANTS

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 61: fii_util.truncate_table('FII_COMPANY_GRANTS', 'FII', l_retcode);

57: if g_debug_flag = 'Y' then
58: FII_UTIL.write_log(g_phase);
59: end if;
60:
61: fii_util.truncate_table('FII_COMPANY_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;

Line 63: fii_util.write_log('Error in fii_util.truncate_table(''FII_COMPANY_GRANTS'', ''FII'', l_retcode)');

59: end if;
60:
61: fii_util.truncate_table('FII_COMPANY_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

Line 82: g_phase := 'Inserting into fii_company_grants from bis_grants_v.';

78: fii_util.write_log('Error: Top node for the company or cost center dimension is not assigned.');
79: raise FIIUSECB_fatal_err;
80: END IF;
81:
82: g_phase := 'Inserting into fii_company_grants from bis_grants_v.';
83:
84:
85: INSERT INTO fii_company_grants
86: (user_id,

Line 85: INSERT INTO fii_company_grants

81:
82: g_phase := 'Inserting into fii_company_grants from bis_grants_v.';
83:
84:
85: INSERT INTO fii_company_grants
86: (user_id,
87: report_region_code,
88: company_id,
89: aggregated_flag,

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

107: AND (sysdate BETWEEN TRUNC(s.start_date) AND nvl(TRUNC(s.end_date),to_date('12-31-9999','MM-DD-YYYY')))
108: AND s.granted_to = u.employee_id);
109:
110: IF g_debug_flag = 'Y' THEN
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.';

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

109:
110: IF g_debug_flag = 'Y' THEN
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

Line 147: g_phase := 'Filtering out child company assignments from fii_company_grants.';

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
150: WHERE (user_id, report_region_code, company_id) IN
151: (SELECT s.user_id, s.report_region_code, s.company_id FROM fii_company_grants s, fii_company_hierarchies h

Line 149: DELETE FROM fii_company_grants

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
150: WHERE (user_id, report_region_code, company_id) IN
151: (SELECT s.user_id, s.report_region_code, s.company_id FROM fii_company_grants s, fii_company_hierarchies h
152: WHERE s.company_id = h.child_company_id
153: AND h.parent_company_id IN (SELECT company_id from fii_company_grants where user_id=s.user_id and report_region_code=s.report_region_code)

Line 151: (SELECT s.user_id, s.report_region_code, s.company_id FROM fii_company_grants s, fii_company_hierarchies h

147: g_phase := 'Filtering out child company assignments from fii_company_grants.';
148:
149: DELETE FROM fii_company_grants
150: WHERE (user_id, report_region_code, company_id) IN
151: (SELECT s.user_id, s.report_region_code, s.company_id FROM fii_company_grants s, fii_company_hierarchies h
152: WHERE s.company_id = h.child_company_id
153: AND h.parent_company_id IN (SELECT company_id from fii_company_grants where user_id=s.user_id and report_region_code=s.report_region_code)
154: AND h.parent_company_id <> h.child_company_id);
155:

Line 153: AND h.parent_company_id IN (SELECT company_id from fii_company_grants where user_id=s.user_id and report_region_code=s.report_region_code)

149: DELETE FROM fii_company_grants
150: WHERE (user_id, report_region_code, company_id) IN
151: (SELECT s.user_id, s.report_region_code, s.company_id FROM fii_company_grants s, fii_company_hierarchies h
152: WHERE s.company_id = h.child_company_id
153: AND h.parent_company_id IN (SELECT company_id from fii_company_grants where user_id=s.user_id and report_region_code=s.report_region_code)
154: AND h.parent_company_id <> h.child_company_id);
155:
156: IF g_debug_flag = 'Y' THEN
157: FII_UTIL.Write_Log ('Deleted ' || SQL%ROWCOUNT || ' rows from fii_company_grants.');

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

153: AND h.parent_company_id IN (SELECT company_id from fii_company_grants where user_id=s.user_id and report_region_code=s.report_region_code)
154: AND h.parent_company_id <> h.child_company_id);
155:
156: IF g_debug_flag = 'Y' THEN
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.';

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

155:
156: IF g_debug_flag = 'Y' THEN
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