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_PHONES

Line 90: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_PHONES');

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

Line 2758: UPDATE per_empdir_phones p

2754: write_log(1, 'Begin merge per phones: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2755:
2756: g_date := trunc(SYSDATE);
2757:
2758: UPDATE per_empdir_phones p
2759: SET (orig_system, orig_system_id, date_from, date_to, phone_type, phone_number,
2760: phone_key, parent_id, parent_table, object_version_number,
2761: partition_id, request_id, program_application_id, program_id,
2762: program_update_date, last_update_date, last_updated_by,

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

2779:
2780: l_cnt := sql%rowcount;
2781: COMMIT;
2782:
2783: write_log(1, 'Total # of records updated for per_empdir_phones: '||l_cnt);
2784: write_log(2, 'Total # of records updated for per_empdir_phones: '||l_cnt);
2785:
2786: INSERT /*+ parallel(hrd) append */ INTO per_empdir_phones hrd(
2787: ORIG_SYSTEM ,

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

2780: l_cnt := sql%rowcount;
2781: COMMIT;
2782:
2783: write_log(1, 'Total # of records updated for per_empdir_phones: '||l_cnt);
2784: write_log(2, 'Total # of records updated for per_empdir_phones: '||l_cnt);
2785:
2786: INSERT /*+ parallel(hrd) append */ INTO per_empdir_phones hrd(
2787: ORIG_SYSTEM ,
2788: ORIG_SYSTEM_ID ,

Line 2786: INSERT /+ parallel(hrd) append / INTO per_empdir_phones hrd(

2782:
2783: write_log(1, 'Total # of records updated for per_empdir_phones: '||l_cnt);
2784: write_log(2, 'Total # of records updated for per_empdir_phones: '||l_cnt);
2785:
2786: INSERT /*+ parallel(hrd) append */ INTO per_empdir_phones hrd(
2787: ORIG_SYSTEM ,
2788: ORIG_SYSTEM_ID ,
2789: DATE_FROM,
2790: DATE_TO ,

Line 2830: /* Picking up not exists from per_empdir_phones */

2826: g_user_id,
2827: g_date
2828: FROM per_phones ph
2829: WHERE p_eff_date BETWEEN DATE_FROM AND nvl(DATE_TO, p_eff_date+1)
2830: /* Picking up not exists from per_empdir_phones */
2831: AND NOT EXISTS (SELECT 'e' from per_empdir_phones iph
2832: WHERE iph.orig_system_id = ph.phone_id
2833: AND iph.orig_system = g_srcSystem);
2834:

Line 2831: AND NOT EXISTS (SELECT 'e' from per_empdir_phones iph

2827: g_date
2828: FROM per_phones ph
2829: WHERE p_eff_date BETWEEN DATE_FROM AND nvl(DATE_TO, p_eff_date+1)
2830: /* Picking up not exists from per_empdir_phones */
2831: AND NOT EXISTS (SELECT 'e' from per_empdir_phones iph
2832: WHERE iph.orig_system_id = ph.phone_id
2833: AND iph.orig_system = g_srcSystem);
2834:
2835: l_cnt := sql%rowcount;

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

2834:
2835: l_cnt := sql%rowcount;
2836: COMMIT;
2837:
2838: write_log(1, 'Total # of new records processed for per_empdir_phones: '||l_cnt);
2839: write_log(2, 'Total # of new records processed for per_empdir_phones: '||l_cnt);
2840: write_log(1, 'End merge per phones: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2841:
2842: EXCEPTION WHEN OTHERS THEN

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

2835: l_cnt := sql%rowcount;
2836: COMMIT;
2837:
2838: write_log(1, 'Total # of new records processed for per_empdir_phones: '||l_cnt);
2839: write_log(2, 'Total # of new records processed for per_empdir_phones: '||l_cnt);
2840: write_log(1, 'End merge per phones: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2841:
2842: EXCEPTION WHEN OTHERS THEN
2843: errbuf := errbuf||SQLERRM;

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

3181:
3182:
3183: write_log(1, 'Begin populating per phones: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3184:
3185: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_PHONES TRUNCATE PARTITION internal REUSE STORAGE';
3186: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PHONES_PK REBUILD';
3187:
3188: g_date := trunc(SYSDATE);
3189:

Line 3186: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PHONES_PK REBUILD';

3182:
3183: write_log(1, 'Begin populating per phones: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3184:
3185: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_PHONES TRUNCATE PARTITION internal REUSE STORAGE';
3186: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PHONES_PK REBUILD';
3187:
3188: g_date := trunc(SYSDATE);
3189:
3190: INSERT /*+ parallel(hrd) append */ INTO per_empdir_phones hrd(

Line 3190: INSERT /+ parallel(hrd) append / INTO per_empdir_phones hrd(

3186: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PHONES_PK REBUILD';
3187:
3188: g_date := trunc(SYSDATE);
3189:
3190: INSERT /*+ parallel(hrd) append */ INTO per_empdir_phones hrd(
3191: ORIG_SYSTEM ,
3192: ORIG_SYSTEM_ID ,
3193: DATE_FROM,
3194: DATE_TO ,

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

3235:
3236: l_cnt := sql%rowcount;
3237: COMMIT;
3238:
3239: write_log(1, 'Total # of records processed for per_empdir_phones: '||l_cnt);
3240: write_log(2, 'Total # of records processed for per_empdir_phones: '||l_cnt);
3241: write_log(1, 'End populating per phones: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3242:
3243: EXCEPTION WHEN OTHERS THEN

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

3236: l_cnt := sql%rowcount;
3237: COMMIT;
3238:
3239: write_log(1, 'Total # of records processed for per_empdir_phones: '||l_cnt);
3240: write_log(2, 'Total # of records processed for per_empdir_phones: '||l_cnt);
3241: write_log(1, 'End populating per phones: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3242:
3243: EXCEPTION WHEN OTHERS THEN
3244: errbuf := errbuf||SQLERRM;

Line 3672: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_PHONES_WHO DISABLE';

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
3675: NULL;
3676: END;