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 2660: UPDATE per_empdir_locations_tl loc

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

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

2680:
2681: l_cnt := sql%rowcount;
2682: COMMIT;
2683:
2684: write_log(1, 'Total # of records updated for per_empdir_locations_tl: '||l_cnt);
2685: write_log(2, 'Total # of records updated for per_empdir_locations_tl: '||l_cnt);
2686:
2687: INSERT /*+ parallel(loc) append */ INTO per_empdir_locations_tl loc(
2688: ORIG_SYSTEM,

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

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

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

2683:
2684: write_log(1, 'Total # of records updated for per_empdir_locations_tl: '||l_cnt);
2685: write_log(2, 'Total # of records updated for per_empdir_locations_tl: '||l_cnt);
2686:
2687: INSERT /*+ parallel(loc) append */ INTO per_empdir_locations_tl loc(
2688: ORIG_SYSTEM,
2689: ORIG_SYSTEM_ID,
2690: LOCATION_CODE,
2691: DESCRIPTION,

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

2721: FROM hr_locations_all_tl ltl, hr_locations_all l, per_empdir_locations pel
2722: WHERE ltl.location_id = l.location_id
2723: AND pel.orig_system_id = l.location_id
2724: AND pel.orig_system = g_srcSystem
2725: AND NOT EXISTS (SELECT 'e' from per_empdir_locations_tl il
2726: WHERE il.orig_system_id = ltl.location_id
2727: AND il.orig_system = g_srcSystem);
2728:
2729: l_cnt := sql%rowcount;

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

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

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

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

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

3258: BEGIN
3259:
3260:
3261: write_log(1, 'Begin populating per location tl: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3262: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_LOCATIONS_TL TRUNCATE PARTITION internal REUSE STORAGE';
3263: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_LOCATIONS_TL_PK REBUILD';
3264:
3265: g_date := trunc(SYSDATE);
3266:

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

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

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

3263: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_LOCATIONS_TL_PK REBUILD';
3264:
3265: g_date := trunc(SYSDATE);
3266:
3267: INSERT /*+ parallel(loc) append */ INTO per_empdir_locations_tl loc(
3268: ORIG_SYSTEM,
3269: ORIG_SYSTEM_ID,
3270: LOCATION_CODE,
3271: DESCRIPTION,

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

3303:
3304: l_cnt := sql%rowcount;
3305: COMMIT;
3306:
3307: write_log(1, 'Total # of records processed for per_empdir_locations_tl: '||l_cnt);
3308: write_log(2, 'Total # of records processed for per_empdir_locations_tl: '||l_cnt);
3309: write_log(1, 'End populating per locations tl: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3310:
3311: EXCEPTION WHEN OTHERS THEN

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

3304: l_cnt := sql%rowcount;
3305: COMMIT;
3306:
3307: write_log(1, 'Total # of records processed for per_empdir_locations_tl: '||l_cnt);
3308: write_log(2, 'Total # of records processed for per_empdir_locations_tl: '||l_cnt);
3309: write_log(1, 'End populating per locations tl: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3310:
3311: EXCEPTION WHEN OTHERS THEN
3312: errbuf := errbuf||SQLERRM;