APPS.BIM_PROGRAMS_DENORM_PKG dependencies on BIM_I_SOURCE_DENORM

Line 213: Execute Immediate 'Truncate Table '||l_schema||'.bim_i_source_denorm';

209: bis_collection_utilities.log('Truncating the Source Denorm Table ');
210:
211: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
212:
213: Execute Immediate 'Truncate Table '||l_schema||'.bim_i_source_denorm';
214:
215: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SOURCE_DENORM');
216:
217: ELSE

Line 220: DELETE bim_i_source_denorm

216:
217: ELSE
218: /* This piece of code is for the objects that had an update somewhere in their hierarachy chain. */
219:
220: DELETE bim_i_source_denorm
221: WHERE source_code_id IN
222: (SELECT source_code_id
223: FROM bim_i_source_codes a
224: WHERE obj_last_update_date > l_temp_start_date

Line 228: /*DELETE bim_i_source_denorm

224: WHERE obj_last_update_date > l_temp_start_date
225: );
226:
227: /* This piece of code is for the campaigns that have changed from one program to another. */
228: /*DELETE bim_i_source_denorm
229: WHERE source_code_id IN
230: (
231: SELECT source_code_id
232: FROM bim_i_source_denorm

Line 232: FROM bim_i_source_denorm

228: /*DELETE bim_i_source_denorm
229: WHERE source_code_id IN
230: (
231: SELECT source_code_id
232: FROM bim_i_source_denorm
233: WHERE parent_source_code_id IN
234: (
235: SELECT b.source_code_id
236: FROM ams_campaigns_all_b a,

Line 245: DELETE bim_i_source_denorm

241: )
242:
243: );*/
244: --Modified the query as per performance bug 4901135
245: DELETE bim_i_source_denorm
246: WHERE source_code_id IN
247: (
248: SELECT source_code_id
249: FROM bim_i_source_denorm

Line 249: FROM bim_i_source_denorm

245: DELETE bim_i_source_denorm
246: WHERE source_code_id IN
247: (
248: SELECT source_code_id
249: FROM bim_i_source_denorm
250: WHERE parent_source_code_id IN
251: (
252: SELECT b.source_code_id
253: FROM bim_i_source_codes b

Line 275: UPDATE bim_i_source_denorm SET leaf_node_flag = 'N'

271: IF l_period_to IS NOT NULL THEN
272:
273: BIS_COLLECTION_UTILITIES.log('Updating leaf node flags for incremental load ');
274: --add update logic here
275: UPDATE bim_i_source_denorm SET leaf_node_flag = 'N'
276: WHERE source_code_id
277: IN
278: (
279: SELECT parent_source_code_id

Line 284: FROM bim_i_source_denorm b

280: FROM bim_i_source_codes a
281: WHERE rollup_type in ('CSCH', 'EVE0')
282: AND NOT EXISTS (
283: SELECT 1
284: FROM bim_i_source_denorm b
285: WHERE b.source_code_id = a.source_code_id
286: )
287: AND object_level = 1
288: );

Line 293: INSERT INTO bim_i_source_denorm

289:
290:
291: /*************FOR CAMPAIGNS AND EVENTS OBJECTS ******************************/
292:
293: INSERT INTO bim_i_source_denorm
294: (source_code_id
295: ,parent_source_code_id
296: ,immediate_parent_flag
297: ,immediate_parent_id

Line 361: FROM BIM_I_SOURCE_DENORM b

357: FROM bim_i_source_codes a
358: WHERE
359: NOT EXISTS
360: (SELECT 1
361: FROM BIM_I_SOURCE_DENORM b
362: WHERE b.source_code_id = a.source_code_id
363: -- AND nvl(b.parent_object_id,1) = nvl(a.parent_campaign_id,1)
364: )
365: CONNECT BY PRIOR source_code_id = parent_source_code_id ) x,

Line 379: INSERT INTO bim_i_source_denorm

375: bis_collection_utilities.log('Initial Load of Source Denorm Concurrent Program');
376:
377: /*************FOR CAMPAIGNS AND EVENTS OBJECTS ******************************/
378:
379: INSERT INTO bim_i_source_denorm
380: (source_code_id
381: ,parent_source_code_id
382: ,immediate_parent_flag
383: ,immediate_parent_id

Line 632: FROM bim_i_source_denorm b,

628: sysdate,
629: -1,
630: -1,
631: -1
632: FROM bim_i_source_denorm b,
633: (
634: SELECT
635: a.resource_id,code1.source_code_id,
636: max(b.object_level) object_level ,

Line 639: bim_i_source_denorm b,

635: a.resource_id,code1.source_code_id,
636: max(b.object_level) object_level ,
637: a.object_type object_type
638: FROM ams_act_access_denorm a,
639: bim_i_source_denorm b,
640: bim_i_source_codes code1,
641: ams_act_access_denorm c,
642: bim_i_source_codes code2
643: WHERE a.object_id = code1.object_id