DBA Data[Home] [Help]

APPS.BIM_RESPONSE_FACTS_PKG dependencies on BIM_UTL_PKG

Line 421: BIM_UTL_PKG.DROP_INDEX('BIM_R_RGRD_DAILY_FACTS');

417: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rrsn_weekly_facts_s CACHE 1000 ';
418:
419:
420: /* Dropping INdexes */
421: BIM_UTL_PKG.DROP_INDEX('BIM_R_RGRD_DAILY_FACTS');
422: BIM_UTL_PKG.DROP_INDEX('BIM_R_RRSN_DAILY_FACTS');
423: BIM_UTL_PKG.DROP_INDEX('BIM_R_RGRD_WEEKLY_FACTS');
424: BIM_UTL_PKG.DROP_INDEX('BIM_R_RRSN_WEEKLY_FACTS');
425:

Line 422: BIM_UTL_PKG.DROP_INDEX('BIM_R_RRSN_DAILY_FACTS');

418:
419:
420: /* Dropping INdexes */
421: BIM_UTL_PKG.DROP_INDEX('BIM_R_RGRD_DAILY_FACTS');
422: BIM_UTL_PKG.DROP_INDEX('BIM_R_RRSN_DAILY_FACTS');
423: BIM_UTL_PKG.DROP_INDEX('BIM_R_RGRD_WEEKLY_FACTS');
424: BIM_UTL_PKG.DROP_INDEX('BIM_R_RRSN_WEEKLY_FACTS');
425:
426:

Line 423: BIM_UTL_PKG.DROP_INDEX('BIM_R_RGRD_WEEKLY_FACTS');

419:
420: /* Dropping INdexes */
421: BIM_UTL_PKG.DROP_INDEX('BIM_R_RGRD_DAILY_FACTS');
422: BIM_UTL_PKG.DROP_INDEX('BIM_R_RRSN_DAILY_FACTS');
423: BIM_UTL_PKG.DROP_INDEX('BIM_R_RGRD_WEEKLY_FACTS');
424: BIM_UTL_PKG.DROP_INDEX('BIM_R_RRSN_WEEKLY_FACTS');
425:
426:
427: l_org_id := 204;

Line 424: BIM_UTL_PKG.DROP_INDEX('BIM_R_RRSN_WEEKLY_FACTS');

420: /* Dropping INdexes */
421: BIM_UTL_PKG.DROP_INDEX('BIM_R_RGRD_DAILY_FACTS');
422: BIM_UTL_PKG.DROP_INDEX('BIM_R_RRSN_DAILY_FACTS');
423: BIM_UTL_PKG.DROP_INDEX('BIM_R_RGRD_WEEKLY_FACTS');
424: BIM_UTL_PKG.DROP_INDEX('BIM_R_RRSN_WEEKLY_FACTS');
425:
426:
427: l_org_id := 204;
428:

Line 812: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_DAILY_FACTS');

808: fnd_message.set_name('BIM','BIM_R_RECREATE_INDEXES');
809: fnd_file.put_line(fnd_file.log,fnd_message.get);
810:
811: /* Recreating Indexes */
812: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_DAILY_FACTS');
813: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_DAILY_FACTS');
814: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_WEEKLY_FACTS');
815: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_WEEKLY_FACTS');
816:

Line 813: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_DAILY_FACTS');

809: fnd_file.put_line(fnd_file.log,fnd_message.get);
810:
811: /* Recreating Indexes */
812: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_DAILY_FACTS');
813: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_DAILY_FACTS');
814: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_WEEKLY_FACTS');
815: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_WEEKLY_FACTS');
816:
817: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rgrd_weekly_facts_s CACHE 20';

Line 814: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_WEEKLY_FACTS');

810:
811: /* Recreating Indexes */
812: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_DAILY_FACTS');
813: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_DAILY_FACTS');
814: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_WEEKLY_FACTS');
815: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_WEEKLY_FACTS');
816:
817: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rgrd_weekly_facts_s CACHE 20';
818: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rrsn_weekly_facts_s CACHE 20';

Line 815: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_WEEKLY_FACTS');

811: /* Recreating Indexes */
812: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_DAILY_FACTS');
813: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_DAILY_FACTS');
814: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_WEEKLY_FACTS');
815: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_WEEKLY_FACTS');
816:
817: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rgrd_weekly_facts_s CACHE 20';
818: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rrsn_weekly_facts_s CACHE 20';
819: