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 2763: UPDATE per_empdir_phones p

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

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

2785:
2786: l_cnt := sql%rowcount;
2787: COMMIT;
2788:
2789: write_log(1, 'Total # of records updated for per_empdir_phones: '||l_cnt);
2790: write_log(2, 'Total # of records updated for per_empdir_phones: '||l_cnt);
2791:
2792: INSERT /*+ parallel(hrd) append */ INTO per_empdir_phones hrd(
2793: ORIG_SYSTEM ,

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

2786: l_cnt := sql%rowcount;
2787: COMMIT;
2788:
2789: write_log(1, 'Total # of records updated for per_empdir_phones: '||l_cnt);
2790: write_log(2, 'Total # of records updated for per_empdir_phones: '||l_cnt);
2791:
2792: INSERT /*+ parallel(hrd) append */ INTO per_empdir_phones hrd(
2793: ORIG_SYSTEM ,
2794: ORIG_SYSTEM_ID ,

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

2788:
2789: write_log(1, 'Total # of records updated for per_empdir_phones: '||l_cnt);
2790: write_log(2, 'Total # of records updated for per_empdir_phones: '||l_cnt);
2791:
2792: INSERT /*+ parallel(hrd) append */ INTO per_empdir_phones hrd(
2793: ORIG_SYSTEM ,
2794: ORIG_SYSTEM_ID ,
2795: DATE_FROM,
2796: DATE_TO ,

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

2832: g_user_id,
2833: g_date
2834: FROM per_phones ph
2835: WHERE p_eff_date BETWEEN DATE_FROM AND nvl(DATE_TO, p_eff_date+1)
2836: /* Picking up not exists from per_empdir_phones */
2837: AND NOT EXISTS (SELECT 'e' from per_empdir_phones iph
2838: WHERE iph.orig_system_id = ph.phone_id
2839: AND iph.orig_system = g_srcSystem);
2840:

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

2833: g_date
2834: FROM per_phones ph
2835: WHERE p_eff_date BETWEEN DATE_FROM AND nvl(DATE_TO, p_eff_date+1)
2836: /* Picking up not exists from per_empdir_phones */
2837: AND NOT EXISTS (SELECT 'e' from per_empdir_phones iph
2838: WHERE iph.orig_system_id = ph.phone_id
2839: AND iph.orig_system = g_srcSystem);
2840:
2841: l_cnt := sql%rowcount;

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

2840:
2841: l_cnt := sql%rowcount;
2842: COMMIT;
2843:
2844: write_log(1, 'Total # of new records processed for per_empdir_phones: '||l_cnt);
2845: write_log(2, 'Total # of new records processed for per_empdir_phones: '||l_cnt);
2846: write_log(1, 'End merge per phones: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2847:
2848: EXCEPTION WHEN OTHERS THEN

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

2841: l_cnt := sql%rowcount;
2842: COMMIT;
2843:
2844: write_log(1, 'Total # of new records processed for per_empdir_phones: '||l_cnt);
2845: write_log(2, 'Total # of new records processed for per_empdir_phones: '||l_cnt);
2846: write_log(1, 'End merge per phones: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2847:
2848: EXCEPTION WHEN OTHERS THEN
2849: errbuf := errbuf||SQLERRM;

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

3187:
3188:
3189: write_log(1, 'Begin populating per phones: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3190:
3191: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_PHONES TRUNCATE PARTITION internal REUSE STORAGE';
3192: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PHONES_PK REBUILD';
3193:
3194: g_date := trunc(SYSDATE);
3195:

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

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

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

3192: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PHONES_PK REBUILD';
3193:
3194: g_date := trunc(SYSDATE);
3195:
3196: INSERT /*+ parallel(hrd) append */ INTO per_empdir_phones hrd(
3197: ORIG_SYSTEM ,
3198: ORIG_SYSTEM_ID ,
3199: DATE_FROM,
3200: DATE_TO ,

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

3241:
3242: l_cnt := sql%rowcount;
3243: COMMIT;
3244:
3245: write_log(1, 'Total # of records processed for per_empdir_phones: '||l_cnt);
3246: write_log(2, 'Total # of records processed for per_empdir_phones: '||l_cnt);
3247: write_log(1, 'End populating per phones: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3248:
3249: EXCEPTION WHEN OTHERS THEN

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

3242: l_cnt := sql%rowcount;
3243: COMMIT;
3244:
3245: write_log(1, 'Total # of records processed for per_empdir_phones: '||l_cnt);
3246: write_log(2, 'Total # of records processed for per_empdir_phones: '||l_cnt);
3247: write_log(1, 'End populating per phones: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3248:
3249: EXCEPTION WHEN OTHERS THEN
3250: errbuf := errbuf||SQLERRM;

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

3674: BEGIN
3675: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_ASSIGNMENTS_WHO DISABLE';
3676: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_LOCATIONS_WHO DISABLE';
3677: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_PEOPLE_WHO DISABLE';
3678: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_PHONES_WHO DISABLE';
3679:
3680: EXCEPTION WHEN OTHERS THEN
3681: NULL;
3682: END;