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.

[Home] [Help]

APPS.PER_EMPDIR_SS dependencies on PER_PHONES

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

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

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

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

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

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

Line 2749: PROCEDURE merge_per_phones(

2745: write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
2746:
2747: END merge_per_loctl;
2748:
2749: PROCEDURE merge_per_phones(
2750: errbuf OUT NOCOPY VARCHAR2
2751: ,retcode OUT NOCOPY VARCHAR2
2752: ,p_eff_date IN DATE DEFAULT trunc(SYSDATE)
2753: ) IS

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

2755: l_cnt NUMBER:= 0;
2756:
2757: BEGIN
2758:
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

Line 2775: FROM per_phones ph

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

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

2775: FROM per_phones ph
2776: WHERE p_eff_date BETWEEN DATE_FROM AND nvl(DATE_TO, p_eff_date+1)
2777: AND ph.phone_id = p.orig_system_id
2778: AND p.orig_system = g_srcSystem)
2779: WHERE EXISTS (SELECT 'e' FROM per_phones oph
2780: WHERE p.object_version_number <> oph.object_version_number
2781: AND p_eff_date BETWEEN DATE_FROM AND nvl(DATE_TO, p_eff_date+1)-- Added for bug#13862147
2782: AND p.orig_system_id = oph.phone_id
2783: AND p.orig_system = g_srcSystem)

Line 2834: FROM per_phones ph

2830: g_user_id,
2831: g_login_id,
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

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

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

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

2847:
2848: EXCEPTION WHEN OTHERS THEN
2849: errbuf := errbuf||SQLERRM;
2850: retcode := '1';
2851: write_log(1, 'Error in merge_per_phones: '||SQLCODE);
2852: write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
2853:
2854: END merge_per_phones;
2855:

Line 2854: END merge_per_phones;

2850: retcode := '1';
2851: write_log(1, 'Error in merge_per_phones: '||SQLCODE);
2852: write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
2853:
2854: END merge_per_phones;
2855:
2856: PROCEDURE merge_per_locations(
2857: errbuf OUT NOCOPY VARCHAR2
2858: ,retcode OUT NOCOPY VARCHAR2

Line 3178: PROCEDURE populate_per_phones(

3174: write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
3175:
3176: END populate_hr_orgs;
3177:
3178: PROCEDURE populate_per_phones(
3179: errbuf OUT NOCOPY VARCHAR2
3180: ,retcode OUT NOCOPY VARCHAR2
3181: ,p_eff_date IN DATE DEFAULT trunc(SYSDATE)
3182: ) IS

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

3185:
3186: BEGIN
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:

Line 3238: FROM per_phones

3234: g_user_id,
3235: g_login_id,
3236: g_user_id,
3237: g_date
3238: FROM per_phones
3239: WHERE p_eff_date BETWEEN DATE_FROM AND nvl(DATE_TO, p_eff_date+1);
3240:
3241:
3242: l_cnt := sql%rowcount;

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

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

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

3248:
3249: EXCEPTION WHEN OTHERS THEN
3250: errbuf := errbuf||SQLERRM;
3251: retcode := '1';
3252: write_log(1, 'Error in populate_per_phones: '||SQLCODE);
3253: write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
3254:
3255: END populate_per_phones;
3256:

Line 3255: END populate_per_phones;

3251: retcode := '1';
3252: write_log(1, 'Error in populate_per_phones: '||SQLCODE);
3253: write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
3254:
3255: END populate_per_phones;
3256:
3257: PROCEDURE populate_per_loctl(
3258: errbuf OUT NOCOPY VARCHAR2
3259: ,retcode OUT NOCOPY VARCHAR2

Line 3710: populate_per_phones(

3706: ,retcode
3707: ,l_eff_date
3708: );
3709:
3710: populate_per_phones(
3711: errbuf
3712: ,retcode
3713: ,l_eff_date
3714: );

Line 3783: merge_per_phones(

3779: ,retcode
3780: ,l_eff_date
3781: );
3782:
3783: merge_per_phones(
3784: errbuf
3785: ,retcode
3786: ,l_eff_date
3787: );