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.PER_EMPDIR_SS dependencies on PER_EMPDIR_LOCATIONS_TL

Line 92: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS_TL');

88: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_JOBS');
89: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_POSITIONS');
90: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_PHONES');
91: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS');
92: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS_TL');
93: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_IMAGES');
94:
95: write_log(1, 'End gathering stats: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
96:

Line 2665: UPDATE per_empdir_locations_tl loc

2661: write_log(1, 'Begin merge per loctl: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2662:
2663: g_date := trunc(SYSDATE);
2664:
2665: UPDATE per_empdir_locations_tl loc
2666: SET (orig_system, orig_system_id, location_code, description,
2667: language, source_lang, object_version_number, partition_id,
2668: last_update_date, last_update_by, created_by, creation_date,
2669: request_id, program_application_id, program_id, program_update_date)

Line 2689: write_log(1, 'Total # of records updated for per_empdir_locations_tl: '||l_cnt);

2685:
2686: l_cnt := sql%rowcount;
2687: COMMIT;
2688:
2689: write_log(1, 'Total # of records updated for per_empdir_locations_tl: '||l_cnt);
2690: write_log(2, 'Total # of records updated for per_empdir_locations_tl: '||l_cnt);
2691:
2692: INSERT /*+ parallel(loc) append */ INTO per_empdir_locations_tl loc(
2693: ORIG_SYSTEM,

Line 2690: write_log(2, 'Total # of records updated for per_empdir_locations_tl: '||l_cnt);

2686: l_cnt := sql%rowcount;
2687: COMMIT;
2688:
2689: write_log(1, 'Total # of records updated for per_empdir_locations_tl: '||l_cnt);
2690: write_log(2, 'Total # of records updated for per_empdir_locations_tl: '||l_cnt);
2691:
2692: INSERT /*+ parallel(loc) append */ INTO per_empdir_locations_tl loc(
2693: ORIG_SYSTEM,
2694: ORIG_SYSTEM_ID,

Line 2692: INSERT /+ parallel(loc) append / INTO per_empdir_locations_tl loc(

2688:
2689: write_log(1, 'Total # of records updated for per_empdir_locations_tl: '||l_cnt);
2690: write_log(2, 'Total # of records updated for per_empdir_locations_tl: '||l_cnt);
2691:
2692: INSERT /*+ parallel(loc) append */ INTO per_empdir_locations_tl loc(
2693: ORIG_SYSTEM,
2694: ORIG_SYSTEM_ID,
2695: LOCATION_CODE,
2696: DESCRIPTION,

Line 2730: AND NOT EXISTS (SELECT 'e' from per_empdir_locations_tl il

2726: FROM hr_locations_all_tl ltl, hr_locations_all l, per_empdir_locations pel
2727: WHERE ltl.location_id = l.location_id
2728: AND pel.orig_system_id = l.location_id
2729: AND pel.orig_system = g_srcSystem
2730: AND NOT EXISTS (SELECT 'e' from per_empdir_locations_tl il
2731: WHERE il.orig_system_id = ltl.location_id
2732: AND il.orig_system = g_srcSystem);
2733:
2734: l_cnt := sql%rowcount;

Line 2737: write_log(1, 'Total # of new records processed for per_empdir_locations_tl: '||l_cnt);

2733:
2734: l_cnt := sql%rowcount;
2735: COMMIT;
2736:
2737: write_log(1, 'Total # of new records processed for per_empdir_locations_tl: '||l_cnt);
2738: write_log(2, 'Total # of new records processed for per_empdir_locations_tl: '||l_cnt);
2739: write_log(1, 'End merge per loctl: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2740:
2741: EXCEPTION WHEN OTHERS THEN

Line 2738: write_log(2, 'Total # of new records processed for per_empdir_locations_tl: '||l_cnt);

2734: l_cnt := sql%rowcount;
2735: COMMIT;
2736:
2737: write_log(1, 'Total # of new records processed for per_empdir_locations_tl: '||l_cnt);
2738: write_log(2, 'Total # of new records processed for per_empdir_locations_tl: '||l_cnt);
2739: write_log(1, 'End merge per loctl: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2740:
2741: EXCEPTION WHEN OTHERS THEN
2742: errbuf := errbuf||SQLERRM;

Line 3268: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_LOCATIONS_TL TRUNCATE PARTITION internal REUSE STORAGE';

3264: BEGIN
3265:
3266:
3267: write_log(1, 'Begin populating per location tl: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3268: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_LOCATIONS_TL TRUNCATE PARTITION internal REUSE STORAGE';
3269: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_LOCATIONS_TL_PK REBUILD';
3270:
3271: g_date := trunc(SYSDATE);
3272:

Line 3269: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_LOCATIONS_TL_PK REBUILD';

3265:
3266:
3267: write_log(1, 'Begin populating per location tl: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3268: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_LOCATIONS_TL TRUNCATE PARTITION internal REUSE STORAGE';
3269: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_LOCATIONS_TL_PK REBUILD';
3270:
3271: g_date := trunc(SYSDATE);
3272:
3273: INSERT /*+ parallel(loc) append */ INTO per_empdir_locations_tl loc(

Line 3273: INSERT /+ parallel(loc) append / INTO per_empdir_locations_tl loc(

3269: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_LOCATIONS_TL_PK REBUILD';
3270:
3271: g_date := trunc(SYSDATE);
3272:
3273: INSERT /*+ parallel(loc) append */ INTO per_empdir_locations_tl loc(
3274: ORIG_SYSTEM,
3275: ORIG_SYSTEM_ID,
3276: LOCATION_CODE,
3277: DESCRIPTION,

Line 3313: write_log(1, 'Total # of records processed for per_empdir_locations_tl: '||l_cnt);

3309:
3310: l_cnt := sql%rowcount;
3311: COMMIT;
3312:
3313: write_log(1, 'Total # of records processed for per_empdir_locations_tl: '||l_cnt);
3314: write_log(2, 'Total # of records processed for per_empdir_locations_tl: '||l_cnt);
3315: write_log(1, 'End populating per locations tl: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3316:
3317: EXCEPTION WHEN OTHERS THEN

Line 3314: write_log(2, 'Total # of records processed for per_empdir_locations_tl: '||l_cnt);

3310: l_cnt := sql%rowcount;
3311: COMMIT;
3312:
3313: write_log(1, 'Total # of records processed for per_empdir_locations_tl: '||l_cnt);
3314: write_log(2, 'Total # of records processed for per_empdir_locations_tl: '||l_cnt);
3315: write_log(1, 'End populating per locations tl: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3316:
3317: EXCEPTION WHEN OTHERS THEN
3318: errbuf := errbuf||SQLERRM;