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_PHONES

Line 2179: ' FROM per_people_f ppf, per_phones ph, hr_organization_information oi' ||

2175: 'per_information21, per_information22, per_information23, per_information24, per_information25,' ||
2176: 'per_information26, per_information27, per_information28, per_information29, per_information30' ||
2177: ',NULL directs' ||
2178: ',NULL total' ||
2179: ' FROM per_people_f ppf, per_phones ph, hr_organization_information oi' ||
2180: ' WHERE :1 BETWEEN effective_start_date AND effective_end_date' ||
2181: ' AND (current_employee_flag = ''Y'' OR current_npw_flag = ''Y'')' ||
2182: ' AND ppf.business_group_id = oi.organization_id' ||
2183: ' AND oi.org_information_context = ''Business Group Information''' ||

Line 2273: ' FROM per_people_f ppf, per_phones ph' ||

2269: 'ppf.per_information23, ppf.per_information24, ppf.per_information25, ppf.per_information26,' ||
2270: 'ppf.per_information27, ppf.per_information28, ppf.per_information29, ppf.per_information30' ||
2271: ',hrdp.direct_reports' ||
2272: ',hrdp.total_reports ' ||
2273: ' FROM per_people_f ppf, per_phones ph' ||
2274: ' ,hr_organization_information oi, per_empdir_people hrdp' ||
2275: ' WHERE :1 BETWEEN effective_start_date AND effective_end_date' ||
2276: ' AND hrdp.orig_system = ''' || g_srcSystem || '''' ||
2277: ' AND ppf.person_id = hrdp.orig_system_id' ||

Line 2363: ' FROM per_people_f ppf, per_phones ph, hr_organization_information oi' ||

2359: 'per_information21, per_information22, per_information23, per_information24, per_information25,' ||
2360: 'per_information26, per_information27, per_information28, per_information29, per_information30' ||
2361: ',NULL directs' ||
2362: ',NULL total' ||
2363: ' FROM per_people_f ppf, per_phones ph, hr_organization_information oi' ||
2364: ' WHERE :1 BETWEEN effective_start_date AND effective_end_date' ||
2365: ' AND (current_employee_flag = ''Y'' OR current_npw_flag = ''Y'')' ||
2366: ' AND ppf.business_group_id = oi.organization_id' ||
2367: ' AND oi.org_information_context = ''Business Group Information''' ||

Line 2744: PROCEDURE merge_per_phones(

2740: write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
2741:
2742: END merge_per_loctl;
2743:
2744: PROCEDURE merge_per_phones(
2745: errbuf OUT NOCOPY VARCHAR2
2746: ,retcode OUT NOCOPY VARCHAR2
2747: ,p_eff_date IN DATE DEFAULT trunc(SYSDATE)
2748: ) IS

Line 2754: write_log(1, 'Begin merge per phones: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));

2750: l_cnt NUMBER:= 0;
2751:
2752: BEGIN
2753:
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

Line 2770: FROM per_phones ph

2766: nvl(translate(upper(phone_number),'ABCDEFGHIJKLMNOPQRSTUVWXYZ ,.-()x/\',' '),'##'),
2767: parent_id, parent_table, object_version_number, 1,
2768: g_request_id, g_prog_appl_id, g_prog_id, g_date,
2769: g_date, g_user_id, g_login_id, g_user_id, g_date
2770: FROM per_phones ph
2771: WHERE p_eff_date BETWEEN DATE_FROM AND nvl(DATE_TO, p_eff_date+1)
2772: AND ph.phone_id = p.orig_system_id
2773: AND p.orig_system = g_srcSystem)
2774: WHERE EXISTS (SELECT 'e' FROM per_phones oph

Line 2774: WHERE EXISTS (SELECT 'e' FROM per_phones oph

2770: FROM per_phones ph
2771: WHERE p_eff_date BETWEEN DATE_FROM AND nvl(DATE_TO, p_eff_date+1)
2772: AND ph.phone_id = p.orig_system_id
2773: AND p.orig_system = g_srcSystem)
2774: WHERE EXISTS (SELECT 'e' FROM per_phones oph
2775: WHERE p.object_version_number <> oph.object_version_number
2776: AND p.orig_system_id = oph.phone_id
2777: AND p.orig_system = g_srcSystem)
2778: AND p.orig_system = g_srcSystem;

Line 2828: FROM per_phones ph

2824: g_user_id,
2825: g_login_id,
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

Line 2840: write_log(1, 'End merge per phones: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));

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;
2844: retcode := '1';

Line 2845: write_log(1, 'Error in merge_per_phones: '||SQLCODE);

2841:
2842: EXCEPTION WHEN OTHERS THEN
2843: errbuf := errbuf||SQLERRM;
2844: retcode := '1';
2845: write_log(1, 'Error in merge_per_phones: '||SQLCODE);
2846: write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
2847:
2848: END merge_per_phones;
2849:

Line 2848: END merge_per_phones;

2844: retcode := '1';
2845: write_log(1, 'Error in merge_per_phones: '||SQLCODE);
2846: write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
2847:
2848: END merge_per_phones;
2849:
2850: PROCEDURE merge_per_locations(
2851: errbuf OUT NOCOPY VARCHAR2
2852: ,retcode OUT NOCOPY VARCHAR2

Line 3172: PROCEDURE populate_per_phones(

3168: write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
3169:
3170: END populate_hr_orgs;
3171:
3172: PROCEDURE populate_per_phones(
3173: errbuf OUT NOCOPY VARCHAR2
3174: ,retcode OUT NOCOPY VARCHAR2
3175: ,p_eff_date IN DATE DEFAULT trunc(SYSDATE)
3176: ) IS

Line 3183: write_log(1, 'Begin populating per phones: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));

3179:
3180: BEGIN
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:

Line 3232: FROM per_phones

3228: g_user_id,
3229: g_login_id,
3230: g_user_id,
3231: g_date
3232: FROM per_phones
3233: WHERE p_eff_date BETWEEN DATE_FROM AND nvl(DATE_TO, p_eff_date+1);
3234:
3235:
3236: l_cnt := sql%rowcount;

Line 3241: write_log(1, 'End populating per phones: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));

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;
3245: retcode := '1';

Line 3246: write_log(1, 'Error in populate_per_phones: '||SQLCODE);

3242:
3243: EXCEPTION WHEN OTHERS THEN
3244: errbuf := errbuf||SQLERRM;
3245: retcode := '1';
3246: write_log(1, 'Error in populate_per_phones: '||SQLCODE);
3247: write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
3248:
3249: END populate_per_phones;
3250:

Line 3249: END populate_per_phones;

3245: retcode := '1';
3246: write_log(1, 'Error in populate_per_phones: '||SQLCODE);
3247: write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
3248:
3249: END populate_per_phones;
3250:
3251: PROCEDURE populate_per_loctl(
3252: errbuf OUT NOCOPY VARCHAR2
3253: ,retcode OUT NOCOPY VARCHAR2

Line 3704: populate_per_phones(

3700: ,retcode
3701: ,l_eff_date
3702: );
3703:
3704: populate_per_phones(
3705: errbuf
3706: ,retcode
3707: ,l_eff_date
3708: );

Line 3777: merge_per_phones(

3773: ,retcode
3774: ,l_eff_date
3775: );
3776:
3777: merge_per_phones(
3778: errbuf
3779: ,retcode
3780: ,l_eff_date
3781: );