APPS.BIM_BUDGETS_DENORM_PKG dependencies on BIM_I_BUDGETS_DENORM

Line 163: Execute Immediate 'Truncate Table '||l_schema||'.bim_i_budgets_denorm';

159: bis_collection_utilities.log('Truncating the Budget Denorm Table ');
160:
161: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
162:
163: Execute Immediate 'Truncate Table '||l_schema||'.bim_i_budgets_denorm';
164:
165: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_BUDGET_DENORM');
166:
167: ELSE

Line 169: DELETE bim_i_budgets_denorm

165: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_BUDGET_DENORM');
166:
167: ELSE
168: /* This piece of code is for the budgets that have changed from one parent to another. */
169: DELETE bim_i_budgets_denorm
170: WHERE object_id IN
171: (SELECT fund_id
172: FROM ozf_funds_all_b a
173: WHERE last_update_date > l_temp_start_date

Line 176: FROM bim_i_budgets_denorm b

172: FROM ozf_funds_all_b a
173: WHERE last_update_date > l_temp_start_date
174: AND NOT EXISTS
175: (SELECT 1
176: FROM bim_i_budgets_denorm b
177: WHERE b.object_id = a.fund_id
178: AND b.object_type='BUDGET'
179: AND b.parent_object_id = a.parent_fund_id)
180: );

Line 182: DELETE bim_i_budgets_denorm

178: AND b.object_type='BUDGET'
179: AND b.parent_object_id = a.parent_fund_id)
180: );
181:
182: DELETE bim_i_budgets_denorm
183: WHERE object_id IN
184: (SELECT category_id
185: FROM ams_categories_b a
186: WHERE arc_category_created_for='FUND'

Line 190: FROM bim_i_budgets_denorm b

186: WHERE arc_category_created_for='FUND'
187: AND last_update_date > l_temp_start_date
188: AND NOT EXISTS
189: (SELECT 1
190: FROM bim_i_budgets_denorm b
191: WHERE b.object_id = a.category_id
192: AND b.object_type='CATEGORY'
193: AND b.parent_object_id = a.parent_category_id)
194: );

Line 207: INSERT INTO bim_i_budgets_denorm

203: ,l_start_date
204: ,l_end_date
205: );
206:
207: INSERT INTO bim_i_budgets_denorm
208: (object_id
209: ,child_denorm_id
210: ,object_type
211: ,child_denorm_type

Line 244: FROM bim_i_budgets_denorm b

240: FROM ozf_funds_all_b a
241: WHERE
242: NOT EXISTS
243: (SELECT 1
244: FROM bim_i_budgets_denorm b
245: WHERE b.object_id = a.fund_id
246: AND b.object_type ='BUDGET'
247: AND nvl(b.parent_object_id,1) = nvl(a.parent_fund_id,1))
248: CONNECT BY PRIOR parent_fund_id = fund_id

Line 270: FROM bim_i_budgets_denorm b

266: FROM ams_categories_b a
267: WHERE arc_category_created_for='FUND'
268: AND NOT EXISTS
269: (SELECT 1
270: FROM bim_i_budgets_denorm b
271: WHERE b.object_id = a.category_id
272: AND b.object_type ='CATEGORY'
273: AND nvl(b.parent_object_id,1) = nvl(a.parent_category_id,1))
274: connect by prior parent_category_id = category_id ;

Line 276: update bim_i_budgets_denorm bd

272: AND b.object_type ='CATEGORY'
273: AND nvl(b.parent_object_id,1) = nvl(a.parent_category_id,1))
274: connect by prior parent_category_id = category_id ;
275: commit;
276: update bim_i_budgets_denorm bd
277: set leaf_node_flag='Y'
278: where (object_id,object_type) in(
279: select object_id, object_type from bim_i_budgets_denorm a
280: where child_denorm_id =object_id

Line 279: select object_id, object_type from bim_i_budgets_denorm a

275: commit;
276: update bim_i_budgets_denorm bd
277: set leaf_node_flag='Y'
278: where (object_id,object_type) in(
279: select object_id, object_type from bim_i_budgets_denorm a
280: where child_denorm_id =object_id
281: and not exists (select 1
282: from bim_i_budgets_denorm b
283: where a.object_id = b.parent_object_id

Line 282: from bim_i_budgets_denorm b

278: where (object_id,object_type) in(
279: select object_id, object_type from bim_i_budgets_denorm a
280: where child_denorm_id =object_id
281: and not exists (select 1
282: from bim_i_budgets_denorm b
283: where a.object_id = b.parent_object_id
284: and a.object_type=b.object_type
285: ));
286: COMMIT;