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

Line 91: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS');

87: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ORGANIZATIONS');
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'));

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 653: INSERT INTO per_empdir_locations values (

649: BEGIN
650: g_date := trunc(SYSDATE);
651:
652: FORALL I IN 1 .. p_cnt
653: INSERT INTO per_empdir_locations values (
654: locationTbl.orig_system(I)
655: ,locationTbl.orig_system_id(I)
656: ,locationTbl.business_group_id(I)
657: ,locationTbl.derived_locale(I)

Line 727: query_str := query_str || ' WHERE EXISTS (SELECT ''e'' FROM per_empdir_locations il' ||

723: END IF;
724:
725: OPEN p_cursor FOR query_str;
726: ELSIF (p_mode = 1) THEN
727: query_str := query_str || ' WHERE EXISTS (SELECT ''e'' FROM per_empdir_locations il' ||
728: ' WHERE il.orig_system_id = l.location_id'||
729: ' AND il.orig_system = ''' || g_srcSystem || '''' ||
730: ' AND il.object_version_number <> l.object_version_number)';
731: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN

Line 736: query_str := query_str || ' WHERE NOT EXISTS (SELECT ''e'' FROM per_empdir_locations il' ||

732: query_str := query_str || ' AND label_to_char(HR_ENTERPRISE) <> ''C::ENT''';
733: END IF;
734: OPEN p_cursor FOR query_str;
735: ELSIF (p_mode = 2) THEN
736: query_str := query_str || ' WHERE NOT EXISTS (SELECT ''e'' FROM per_empdir_locations il' ||
737: ' WHERE il.orig_system_id = l.location_id' ||
738: ' AND il.orig_system = ''' || g_srcSystem || ''')';
739: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN
740: query_str := query_str || ' AND label_to_char(HR_ENTERPRISE) <> ''C::ENT''';

Line 757: UPDATE per_empdir_locations

753:
754: g_date := trunc(SYSDATE);
755:
756: FORALL I IN 1 .. p_cnt
757: UPDATE per_empdir_locations
758: SET orig_system = locationTbl.orig_system(I)
759: ,orig_system_id = locationTbl.orig_system_id(I)
760: ,business_group_id = locationTbl.business_group_id(I)
761: ,derived_locale = locationTbl.derived_locale(I)

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 2721: FROM hr_locations_all_tl ltl, hr_locations_all l, per_empdir_locations pel

2717: g_request_id,
2718: g_prog_appl_id,
2719: g_prog_id,
2720: g_date
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

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 2873: write_log(1, 'Total # of records updated for per_empdir_locations: '||l_cnt);

2869: ,retcode
2870: ,p_eff_date
2871: );
2872:
2873: write_log(1, 'Total # of records updated for per_empdir_locations: '||l_cnt);
2874: write_log(2, 'Total # of records updated for per_empdir_locations: '||l_cnt);
2875:
2876: bulk_process_per_locations(
2877: 2

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

2870: ,p_eff_date
2871: );
2872:
2873: write_log(1, 'Total # of records updated for per_empdir_locations: '||l_cnt);
2874: write_log(2, 'Total # of records updated for per_empdir_locations: '||l_cnt);
2875:
2876: bulk_process_per_locations(
2877: 2
2878: ,l_cnt

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

2880: ,retcode
2881: ,p_eff_date
2882: );
2883:
2884: write_log(1, 'Total # of new records processed for per_empdir_locations: '||l_cnt);
2885: write_log(2, 'Total # of new records processed for per_empdir_locations: '||l_cnt);
2886: write_log(1, 'End merge per locations: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2887:
2888: EXCEPTION WHEN OTHERS THEN

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

2881: ,p_eff_date
2882: );
2883:
2884: write_log(1, 'Total # of new records processed for per_empdir_locations: '||l_cnt);
2885: write_log(2, 'Total # of new records processed for per_empdir_locations: '||l_cnt);
2886: write_log(1, 'End merge per locations: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2887:
2888: EXCEPTION WHEN OTHERS THEN
2889: 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;

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

3326:
3327: BEGIN
3328:
3329: write_log(1, 'Begin populating per locations: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3330: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_LOCATIONS TRUNCATE PARTITION internal REUSE STORAGE';
3331: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_LOCATIONS_PK REBUILD';
3332:
3333: bulk_process_per_locations(
3334: 0

Line 3331: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_LOCATIONS_PK REBUILD';

3327: BEGIN
3328:
3329: write_log(1, 'Begin populating per locations: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3330: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_LOCATIONS TRUNCATE PARTITION internal REUSE STORAGE';
3331: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_LOCATIONS_PK REBUILD';
3332:
3333: bulk_process_per_locations(
3334: 0
3335: ,l_cnt

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

3337: ,retcode
3338: ,p_eff_date
3339: );
3340:
3341: write_log(1, 'Total # of records processed for per_empdir_locations: '||l_cnt);
3342: write_log(2, 'Total # of records processed for per_empdir_locations: '||l_cnt);
3343: write_log(1, 'End populating per locations: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3344:
3345: EXCEPTION WHEN OTHERS THEN

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

3338: ,p_eff_date
3339: );
3340:
3341: write_log(1, 'Total # of records processed for per_empdir_locations: '||l_cnt);
3342: write_log(2, 'Total # of records processed for per_empdir_locations: '||l_cnt);
3343: write_log(1, 'End populating per locations: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3344:
3345: EXCEPTION WHEN OTHERS THEN
3346: errbuf := errbuf||SQLERRM;

Line 3670: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_LOCATIONS_WHO DISABLE';

3666: write_log(1, 'Process began @: '|| to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3667:
3668: BEGIN
3669: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_ASSIGNMENTS_WHO DISABLE';
3670: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_LOCATIONS_WHO DISABLE';
3671: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_PEOPLE_WHO DISABLE';
3672: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_PHONES_WHO DISABLE';
3673:
3674: EXCEPTION WHEN OTHERS THEN