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_BUDGET_BASE_UPG_C dependencies on FII_BUDGET_BASE

Line 1: PACKAGE BODY FII_BUDGET_BASE_UPG_C AS

1: PACKAGE BODY FII_BUDGET_BASE_UPG_C AS
2: /*$Header: FIIBUDUPB.pls 120.1 2006/01/18 20:44:33 lpoon noship $*/
3:
4: PROCEDURE UPDATE_TABLE(errbuf IN OUT NOCOPY VARCHAR2,
5: retcode IN OUT NOCOPY VARCHAR2) IS

Line 35: -- 2. Truncate FII_BUDGET_BASE_UPG_T

31: WHERE flex_value_set_name
32: = 'Financials Intelligence Internal Value Set')
33: AND flex_value = 'UNASSIGNED';
34:
35: -- 2. Truncate FII_BUDGET_BASE_UPG_T
36: l_phase := 'Find FII schema name';
37: IF l_debug_flag = 'Y' THEN
38: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
39: || l_phase);

Line 44: l_phase := 'Truncate FII_BUDGET_BASE_UPG_T before inserting';

40: END IF;
41:
42: l_fii_schema := FII_UTIL.get_schema_name('FII');
43:
44: l_phase := 'Truncate FII_BUDGET_BASE_UPG_T before inserting';
45: IF l_debug_flag = 'Y' THEN
46: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
47: || l_phase);
48: END IF;

Line 50: l_stmt := 'truncate table '||l_fii_schema||'.FII_BUDGET_BASE_UPG_T';

46: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
47: || l_phase);
48: END IF;
49:
50: l_stmt := 'truncate table '||l_fii_schema||'.FII_BUDGET_BASE_UPG_T';
51: EXECUTE IMMEDIATE l_stmt;
52:
53: -- 3. Insert data into FII_BUDGET_BASE_UPG_T from FII_BUDGET_BASE
54: l_phase := 'Insert into FII_BUDGET_BASE_UPG_T';

Line 53: -- 3. Insert data into FII_BUDGET_BASE_UPG_T from FII_BUDGET_BASE

49:
50: l_stmt := 'truncate table '||l_fii_schema||'.FII_BUDGET_BASE_UPG_T';
51: EXECUTE IMMEDIATE l_stmt;
52:
53: -- 3. Insert data into FII_BUDGET_BASE_UPG_T from FII_BUDGET_BASE
54: l_phase := 'Insert into FII_BUDGET_BASE_UPG_T';
55: IF l_debug_flag = 'Y' THEN
56: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
57: || l_phase);

Line 54: l_phase := 'Insert into FII_BUDGET_BASE_UPG_T';

50: l_stmt := 'truncate table '||l_fii_schema||'.FII_BUDGET_BASE_UPG_T';
51: EXECUTE IMMEDIATE l_stmt;
52:
53: -- 3. Insert data into FII_BUDGET_BASE_UPG_T from FII_BUDGET_BASE
54: l_phase := 'Insert into FII_BUDGET_BASE_UPG_T';
55: IF l_debug_flag = 'Y' THEN
56: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
57: || l_phase);
58: END IF;

Line 61: INTO FII_BUDGET_BASE_UPG_T t

57: || l_phase);
58: END IF;
59:
60: INSERT /*+ append parallel(t) */
61: INTO FII_BUDGET_BASE_UPG_T t
62: ( plan_type_code, time_id, period_type_id, prim_amount_g, sec_amount_g
63: , creation_date, created_by, last_update_date, last_updated_by
64: , last_update_login, company_cost_center_org_id, line_of_business
65: , natural_account, fin_item, product_code, category_id, fin_category_id

Line 99: FROM FII_BUDGET_BASE b

95: , b.upload_date
96: , b.no_version_flag
97: , b.posted_date
98: , b.baseline_amount_prim
99: FROM FII_BUDGET_BASE b
100: , (SELECT /*+ no_merge */
101: ccc_tbl.organization_id
102: , fv1.flex_value_id company_id
103: , fv2.flex_value_id cost_center_id

Line 119: -- 4. Truncate FII_BUDGET_BASE

115: AND fv2.flex_value_set_id = org.org_information4
116: AND fv2.flex_value = org.org_information5) v
117: WHERE b.company_cost_center_org_id = v.organization_id (+);
118:
119: -- 4. Truncate FII_BUDGET_BASE
120: l_phase := 'Truncate FII_BUDGET_BASE';
121: IF l_debug_flag = 'Y' THEN
122: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
123: || 'Inserted ' || SQL%ROWCOUNT

Line 120: l_phase := 'Truncate FII_BUDGET_BASE';

116: AND fv2.flex_value = org.org_information5) v
117: WHERE b.company_cost_center_org_id = v.organization_id (+);
118:
119: -- 4. Truncate FII_BUDGET_BASE
120: l_phase := 'Truncate FII_BUDGET_BASE';
121: IF l_debug_flag = 'Y' THEN
122: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
123: || 'Inserted ' || SQL%ROWCOUNT
124: || ' rows into FII_BUDGET_BASE_UPG_T');

Line 124: || ' rows into FII_BUDGET_BASE_UPG_T');

120: l_phase := 'Truncate FII_BUDGET_BASE';
121: IF l_debug_flag = 'Y' THEN
122: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
123: || 'Inserted ' || SQL%ROWCOUNT
124: || ' rows into FII_BUDGET_BASE_UPG_T');
125: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
126: || l_phase);
127: END IF;
128:

Line 129: l_stmt := 'truncate table '||l_fii_schema||'.FII_BUDGET_BASE';

125: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
126: || l_phase);
127: END IF;
128:
129: l_stmt := 'truncate table '||l_fii_schema||'.FII_BUDGET_BASE';
130: EXECUTE IMMEDIATE l_stmt;
131:
132: -- 5. Re-insert data into FII_BUDGET_BASE from FII_BUDGET_BASE_UPG_T
133: l_phase := 'Insert into FII_BUDGET_BASE';

Line 132: -- 5. Re-insert data into FII_BUDGET_BASE from FII_BUDGET_BASE_UPG_T

128:
129: l_stmt := 'truncate table '||l_fii_schema||'.FII_BUDGET_BASE';
130: EXECUTE IMMEDIATE l_stmt;
131:
132: -- 5. Re-insert data into FII_BUDGET_BASE from FII_BUDGET_BASE_UPG_T
133: l_phase := 'Insert into FII_BUDGET_BASE';
134: IF l_debug_flag = 'Y' THEN
135: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
136: || l_phase);

Line 133: l_phase := 'Insert into FII_BUDGET_BASE';

129: l_stmt := 'truncate table '||l_fii_schema||'.FII_BUDGET_BASE';
130: EXECUTE IMMEDIATE l_stmt;
131:
132: -- 5. Re-insert data into FII_BUDGET_BASE from FII_BUDGET_BASE_UPG_T
133: l_phase := 'Insert into FII_BUDGET_BASE';
134: IF l_debug_flag = 'Y' THEN
135: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
136: || l_phase);
137: END IF;

Line 140: INTO FII_BUDGET_BASE b

136: || l_phase);
137: END IF;
138:
139: INSERT /*+ append parallel(b) */
140: INTO FII_BUDGET_BASE b
141: ( plan_type_code, time_id, period_type_id, prim_amount_g, sec_amount_g
142: , creation_date, created_by, last_update_date, last_updated_by
143: , last_update_login, company_cost_center_org_id, line_of_business
144: , natural_account, fin_item, product_code, category_id, fin_category_id

Line 178: FROM FII_BUDGET_BASE_UPG_T t;

174: , t.upload_date
175: , t.no_version_flag
176: , t.posted_date
177: , t.baseline_amount_prim
178: FROM FII_BUDGET_BASE_UPG_T t;
179:
180: -- 6. Truncate MLOG$_FII_BUDGET_BASE
181: l_phase := 'Truncate MLOG$_FII_BUDGET_BASE';
182: IF l_debug_flag = 'Y' THEN

Line 180: -- 6. Truncate MLOG$_FII_BUDGET_BASE

176: , t.posted_date
177: , t.baseline_amount_prim
178: FROM FII_BUDGET_BASE_UPG_T t;
179:
180: -- 6. Truncate MLOG$_FII_BUDGET_BASE
181: l_phase := 'Truncate MLOG$_FII_BUDGET_BASE';
182: IF l_debug_flag = 'Y' THEN
183: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
184: || 'Inserted ' || SQL%ROWCOUNT

Line 181: l_phase := 'Truncate MLOG$_FII_BUDGET_BASE';

177: , t.baseline_amount_prim
178: FROM FII_BUDGET_BASE_UPG_T t;
179:
180: -- 6. Truncate MLOG$_FII_BUDGET_BASE
181: l_phase := 'Truncate MLOG$_FII_BUDGET_BASE';
182: IF l_debug_flag = 'Y' THEN
183: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
184: || 'Inserted ' || SQL%ROWCOUNT
185: || ' rows into FII_BUDGET_BASE');

Line 185: || ' rows into FII_BUDGET_BASE');

181: l_phase := 'Truncate MLOG$_FII_BUDGET_BASE';
182: IF l_debug_flag = 'Y' THEN
183: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
184: || 'Inserted ' || SQL%ROWCOUNT
185: || ' rows into FII_BUDGET_BASE');
186: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
187: || l_phase);
188: END IF;
189:

Line 190: l_stmt:='truncate table '||l_fii_schema||'.'|| 'MLOG$_FII_BUDGET_BASE';

186: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
187: || l_phase);
188: END IF;
189:
190: l_stmt:='truncate table '||l_fii_schema||'.'|| 'MLOG$_FII_BUDGET_BASE';
191: EXECUTE IMMEDIATE l_stmt;
192:
193: -- 7. Truncate FII_BUDGET_BASE_UPG_T
194: l_phase := 'Truncate FII_BUDGET_BASE_UPG_T before exit';

Line 193: -- 7. Truncate FII_BUDGET_BASE_UPG_T

189:
190: l_stmt:='truncate table '||l_fii_schema||'.'|| 'MLOG$_FII_BUDGET_BASE';
191: EXECUTE IMMEDIATE l_stmt;
192:
193: -- 7. Truncate FII_BUDGET_BASE_UPG_T
194: l_phase := 'Truncate FII_BUDGET_BASE_UPG_T before exit';
195: IF l_debug_flag = 'Y' THEN
196: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
197: || l_phase);

Line 194: l_phase := 'Truncate FII_BUDGET_BASE_UPG_T before exit';

190: l_stmt:='truncate table '||l_fii_schema||'.'|| 'MLOG$_FII_BUDGET_BASE';
191: EXECUTE IMMEDIATE l_stmt;
192:
193: -- 7. Truncate FII_BUDGET_BASE_UPG_T
194: l_phase := 'Truncate FII_BUDGET_BASE_UPG_T before exit';
195: IF l_debug_flag = 'Y' THEN
196: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
197: || l_phase);
198: END IF;

Line 200: l_stmt := 'truncate table '||l_fii_schema||'.FII_BUDGET_BASE_UPG_T';

196: FII_UTIL.put_line(TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') || ' - '
197: || l_phase);
198: END IF;
199:
200: l_stmt := 'truncate table '||l_fii_schema||'.FII_BUDGET_BASE_UPG_T';
201: EXECUTE IMMEDIATE l_stmt;
202:
203: EXCEPTION
204: WHEN OTHERS THEN

Line 216: END FII_BUDGET_BASE_UPG_C;

212: raise;
213:
214: END UPDATE_TABLE;
215:
216: END FII_BUDGET_BASE_UPG_C;