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.BIM_I_SRC_CODE_PKG dependencies on BIM_I_SOURCE_CODES

Line 249: -- BIM_UTL_PKG.DROP_INDEX('BIM_I_SOURCE_CODES');

245:
246:
247:
248: /* Dropping INdexes */
249: -- BIM_UTL_PKG.DROP_INDEX('BIM_I_SOURCE_CODES');
250:
251: --EXECUTE IMMEDIATE 'TRUNCATE TABLE bim.bim_i_source_codes ';
252:
253:

Line 251: --EXECUTE IMMEDIATE 'TRUNCATE TABLE bim.bim_i_source_codes ';

247:
248: /* Dropping INdexes */
249: -- BIM_UTL_PKG.DROP_INDEX('BIM_I_SOURCE_CODES');
250:
251: --EXECUTE IMMEDIATE 'TRUNCATE TABLE bim.bim_i_source_codes ';
252:
253:
254: l_table_name := 'BIM_I_SOURCE_CODES';
255: bis_collection_utilities.log('Running Initial Load of Source Codes');

Line 254: l_table_name := 'BIM_I_SOURCE_CODES';

250:
251: --EXECUTE IMMEDIATE 'TRUNCATE TABLE bim.bim_i_source_codes ';
252:
253:
254: l_table_name := 'BIM_I_SOURCE_CODES';
255: bis_collection_utilities.log('Running Initial Load of Source Codes');
256:
257: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.BIM_I_SOURCE_CODES';
258:

Line 257: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.BIM_I_SOURCE_CODES';

253:
254: l_table_name := 'BIM_I_SOURCE_CODES';
255: bis_collection_utilities.log('Running Initial Load of Source Codes');
256:
257: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.BIM_I_SOURCE_CODES';
258:
259: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SOURCE_CODE');
260:
261: INSERT /*+ append parallel */

Line 262: INTO BIM_I_SOURCE_CODES SRC

258:
259: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SOURCE_CODE');
260:
261: INSERT /*+ append parallel */
262: INTO BIM_I_SOURCE_CODES SRC
263: (
264: creation_date,
265: last_update_date,
266: created_by,

Line 659: UPDATE BIM_I_SOURCE_CODES code

655: COMMIT;
656:
657: --handle categories belong to Reporting category set
658:
659: UPDATE BIM_I_SOURCE_CODES code
660: SET code.category_id
661: = (SELECT nvl(prod.category_id,-1) category_id
662: FROM
663: ams_act_products prod

Line 679: UPDATE BIM_I_SOURCE_CODES code

675: AND prod.arc_act_product_used_by = object_type
676: AND prod.primary_product_flag = 'Y'
677: );
678:
679: UPDATE BIM_I_SOURCE_CODES code
680: SET code.category_id
681: = (SELECT nvl(prod.category_id,-1) category_id
682: FROM
683: ams_act_products prod

Line 711: --l_table_name := 'BIM_I_SOURCE_CODES';

707: );
708:
709: /***************************************************************/
710:
711: --l_table_name := 'BIM_I_SOURCE_CODES';
712: --fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
713: --fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
714: --fnd_file.put_line(fnd_file.log,fnd_message.get);
715: bis_collection_utilities.log('Before Analyze of the table BIM_I_SOURCE_CODES');

Line 715: bis_collection_utilities.log('Before Analyze of the table BIM_I_SOURCE_CODES');

711: --l_table_name := 'BIM_I_SOURCE_CODES';
712: --fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
713: --fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
714: --fnd_file.put_line(fnd_file.log,fnd_message.get);
715: bis_collection_utilities.log('Before Analyze of the table BIM_I_SOURCE_CODES');
716:
717: --Analyze the facts table
718: DBMS_STATS.gather_table_stats('BIM','BIM_I_SOURCE_CODES', estimate_percent => 5,
719: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);

Line 718: DBMS_STATS.gather_table_stats('BIM','BIM_I_SOURCE_CODES', estimate_percent => 5,

714: --fnd_file.put_line(fnd_file.log,fnd_message.get);
715: bis_collection_utilities.log('Before Analyze of the table BIM_I_SOURCE_CODES');
716:
717: --Analyze the facts table
718: DBMS_STATS.gather_table_stats('BIM','BIM_I_SOURCE_CODES', estimate_percent => 5,
719: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
720:
721: --EXECUTE IMMEDIATE ('TRUNCATE TABLE '||l_schema||'.MLOG$_BIM_I_SOURCE_CODES');
722:

Line 721: --EXECUTE IMMEDIATE ('TRUNCATE TABLE '||l_schema||'.MLOG$_BIM_I_SOURCE_CODES');

717: --Analyze the facts table
718: DBMS_STATS.gather_table_stats('BIM','BIM_I_SOURCE_CODES', estimate_percent => 5,
719: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
720:
721: --EXECUTE IMMEDIATE ('TRUNCATE TABLE '||l_schema||'.MLOG$_BIM_I_SOURCE_CODES');
722:
723: /* Recreating Indexes */
724: -- BIM_UTL_PKG.CREATE_INDEX('BIM_I_SOURCE_CODES');
725:

Line 724: -- BIM_UTL_PKG.CREATE_INDEX('BIM_I_SOURCE_CODES');

720:
721: --EXECUTE IMMEDIATE ('TRUNCATE TABLE '||l_schema||'.MLOG$_BIM_I_SOURCE_CODES');
722:
723: /* Recreating Indexes */
724: -- BIM_UTL_PKG.CREATE_INDEX('BIM_I_SOURCE_CODES');
725:
726: /************--Start--********To get Resource ids of Active Employees***************************/
727:
728: /*

Line 882: DELETE FROM bim_i_source_codes WHERE trunc(obj_last_update_date) = p_start_date;

878: -- Initialize API return status to SUCCESS
879: x_return_status := FND_API.G_RET_STS_SUCCESS;
880:
881:
882: DELETE FROM bim_i_source_codes WHERE trunc(obj_last_update_date) = p_start_date;
883:
884:
885: l_table_name := 'BIM_I_SOURCE_CODES';
886: bis_collection_utilities.log('Running Incremental Load of Source Codes');

Line 885: l_table_name := 'BIM_I_SOURCE_CODES';

881:
882: DELETE FROM bim_i_source_codes WHERE trunc(obj_last_update_date) = p_start_date;
883:
884:
885: l_table_name := 'BIM_I_SOURCE_CODES';
886: bis_collection_utilities.log('Running Incremental Load of Source Codes');
887:
888: MERGE INTO bim_i_source_codes facts
889: USING (

Line 888: MERGE INTO bim_i_source_codes facts

884:
885: l_table_name := 'BIM_I_SOURCE_CODES';
886: bis_collection_utilities.log('Running Incremental Load of Source Codes');
887:
888: MERGE INTO bim_i_source_codes facts
889: USING (
890: SELECT
891: sysdate creation_date
892: ,sysdate last_update_date

Line 1355: UPDATE BIM_I_SOURCE_CODES code

1351: COMMIT;
1352:
1353: --handle categories belong to Reporting category set
1354:
1355: UPDATE BIM_I_SOURCE_CODES code
1356: SET code.category_id
1357: = (SELECT nvl(prod.category_id,-1) category_id
1358: FROM
1359: ams_act_products prod

Line 1389: UPDATE BIM_I_SOURCE_CODES code

1385: AND (prod.last_update_date between p_start_date and p_end_date
1386: OR code.obj_last_update_date between p_start_date and p_end_date)
1387: );
1388:
1389: UPDATE BIM_I_SOURCE_CODES code
1390: SET code.category_id
1391: = (SELECT nvl(prod.category_id,-1) category_id
1392: FROM
1393: ams_act_products prod

Line 1413: UPDATE BIM_I_SOURCE_CODES code

1409: AND (prod.last_update_date between p_start_date and p_end_date
1410: OR code.obj_last_update_date between p_start_date and p_end_date)
1411: );
1412:
1413: UPDATE BIM_I_SOURCE_CODES code
1414: SET code.category_id = -1
1415: WHERE NOT EXISTS (select 1
1416: FROM
1417: ams_act_products prod

Line 1448: bis_collection_utilities.log('Before Analyze of the table BIM_I_SOURCE_CODES');

1444:
1445: /***************************************************************/
1446:
1447:
1448: bis_collection_utilities.log('Before Analyze of the table BIM_I_SOURCE_CODES');
1449:
1450: --Analyze the facts table
1451: DBMS_STATS.gather_table_stats('BIM','BIM_I_SOURCE_CODES', estimate_percent => 5,
1452: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);

Line 1451: DBMS_STATS.gather_table_stats('BIM','BIM_I_SOURCE_CODES', estimate_percent => 5,

1447:
1448: bis_collection_utilities.log('Before Analyze of the table BIM_I_SOURCE_CODES');
1449:
1450: --Analyze the facts table
1451: DBMS_STATS.gather_table_stats('BIM','BIM_I_SOURCE_CODES', estimate_percent => 5,
1452: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
1453:
1454: /************--Start--********To get Resource ids of Active Employees***************************/
1455: