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_IMAGES

Line 3443: PROCEDURE populate_per_images(

3439:
3440: END populate_per_jobs;
3441:
3442: --Fix for Bug#4380794
3443: PROCEDURE populate_per_images(
3444: errbuf OUT NOCOPY VARCHAR2
3445: ,retcode OUT NOCOPY VARCHAR2
3446: ) IS
3447: l_cnt NUMBER:= 0;

Line 3450: write_log(1, 'Begin populating per images: '||to_char(SYSDATE, 'DD/MM/RRRR

3446: ) IS
3447: l_cnt NUMBER:= 0;
3448: BEGIN
3449:
3450: write_log(1, 'Begin populating per images: '||to_char(SYSDATE, 'DD/MM/RRRR
3451: HH:MI:SS'));
3452:
3453: --fix for bug 6066127
3454: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_schema_owner||'.PER_EMPDIR_IMAGES';

Line 3458: /* inserting the blob columns from per_images to per_empdir_images if not exist

3454: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_schema_owner||'.PER_EMPDIR_IMAGES';
3455: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_IMAGES_PK REBUILD';
3456: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_IMAGES_U1 REBUILD';
3457:
3458: /* inserting the blob columns from per_images to per_empdir_images if not exist
3459: * * already*/
3460:
3461: INSERT INTO per_empdir_images
3462: (image_id,

Line 3476: FROM per_images pi

3472: ,pi.parent_id
3473: ,null
3474: ,pi.image
3475: ,1
3476: FROM per_images pi
3477: WHERE pi.table_name='PER_PEOPLE_F'
3478: AND NOT EXISTS ( SELECT 'X'FROM per_empdir_images pei
3479: WHERE pei.orig_system='PER'
3480: AND pei.orig_system_id=pi.parent_id);

Line 3491: write_log(1, 'End populating per images: '||to_char(SYSDATE, 'DD/MM/RRRR

3487: write_log(1, 'Total # of new records processed for per_empdir_images:
3488: '||l_cnt);
3489: write_log(2, 'Total # of new records processed for per_empdir_images:
3490: '||l_cnt);
3491: write_log(1, 'End populating per images: '||to_char(SYSDATE, 'DD/MM/RRRR
3492: HH:MI:SS'));
3493:
3494: delete from per_empdir_images
3495: where orig_system_id not in(

Line 3496: select parent_id from per_images

3492: HH:MI:SS'));
3493:
3494: delete from per_empdir_images
3495: where orig_system_id not in(
3496: select parent_id from per_images
3497: where table_name='PER_PEOPLE_F')
3498: and orig_system = 'PER' ;
3499: commit;
3500:

Line 3505: write_log(1, 'Error in populate_per_images: '||SQLCODE);

3501:
3502: EXCEPTION WHEN OTHERS THEN
3503: errbuf := errbuf||SQLERRM;
3504: retcode := '1';
3505: write_log(1, 'Error in populate_per_images: '||SQLCODE);
3506: write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
3507:
3508: END populate_per_images;
3509:

Line 3508: END populate_per_images;

3504: retcode := '1';
3505: write_log(1, 'Error in populate_per_images: '||SQLCODE);
3506: write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
3507:
3508: END populate_per_images;
3509:
3510: PROCEDURE merge_per_images(
3511: errbuf OUT NOCOPY VARCHAR2
3512: ,retcode OUT NOCOPY VARCHAR2

Line 3510: PROCEDURE merge_per_images(

3506: write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
3507:
3508: END populate_per_images;
3509:
3510: PROCEDURE merge_per_images(
3511: errbuf OUT NOCOPY VARCHAR2
3512: ,retcode OUT NOCOPY VARCHAR2
3513: ) IS
3514:

Line 3530: From per_images pi,per_empdir_images pei

3526: L_CREATION_DATE DATE;
3527:
3528: Cursor update_emp_dirimages_cur is
3529: Select pi.parent_id parent_id
3530: From per_images pi,per_empdir_images pei
3531: Where pi.table_name='PER_PEOPLE_F'
3532: And pi.parent_id =pei.orig_system_id
3533: And pei.orig_system='PER'
3534: And trunc(pei.last_update_date) <= trunc(sysdate);

Line 3539: write_log(1, 'Begin merging per images: '||to_char(SYSDATE, 'DD/MM/RRRR

3535:
3536:
3537: BEGIN
3538:
3539: write_log(1, 'Begin merging per images: '||to_char(SYSDATE, 'DD/MM/RRRR
3540: HH:MI:SS'));
3541: /* updating the blob columns from per_images to per_empdir_images if exist */
3542:
3543:

Line 3541: /* updating the blob columns from per_images to per_empdir_images if exist */

3537: BEGIN
3538:
3539: write_log(1, 'Begin merging per images: '||to_char(SYSDATE, 'DD/MM/RRRR
3540: HH:MI:SS'));
3541: /* updating the blob columns from per_images to per_empdir_images if exist */
3542:
3543:
3544: FOR update_emp_dirimages_rec IN update_emp_dirimages_cur
3545: LOOP

Line 3567: FROM per_images

3563: SELECT L_IMAGE_ID,L_ORIG_SYSTEM,L_ORIG_SYSTEM_ID,L_IMAGE_NAME,L_CONTENT_TYPE,
3564: image,
3565: L_OBJECT_VERSION_NUMBER,L_LAST_UPDATE_DATE,
3566: L_LAST_UPDATED_BY,L_LAST_UPDATE_LOGIN,L_CREATED_BY,L_CREATION_DATE
3567: FROM per_images
3568: WHERE table_name='PER_PEOPLE_F'
3569: AND PARENT_ID = update_emp_dirimages_rec.parent_id;
3570:
3571: l_cnt := l_cnt + 1;

Line 3584: /* inserting the blob columns from per_images to per_empdir_images if not exist

3580:
3581:
3582: write_log(1, 'Total # of records updated for per_empdir_images: '||l_cnt);
3583: write_log(2, 'Total # of records updated for per_empdir_images: '||l_cnt);
3584: /* inserting the blob columns from per_images to per_empdir_images if not exist
3585: * * already*/
3586: l_cnt :=0;
3587: INSERT INTO per_empdir_images
3588: (image_id,

Line 3602: FROM per_images pi

3598: ,pi.parent_id
3599: ,null
3600: ,pi.image
3601: ,1
3602: FROM per_images pi
3603: WHERE pi.table_name='PER_PEOPLE_F'
3604: AND NOT EXISTS ( SELECT 'X'FROM per_empdir_images pei
3605: WHERE pei.orig_system='PER'
3606: AND pei.orig_system_id=pi.parent_id);

Line 3615: write_log(1, 'End merge per images: '||to_char(SYSDATE, 'DD/MM/RRRR

3611: write_log(1, 'Total # of new records processed for per_empdir_images:
3612: '||l_cnt);
3613: write_log(2, 'Total # of new records processed for per_empdir_images:
3614: '||l_cnt);
3615: write_log(1, 'End merge per images: '||to_char(SYSDATE, 'DD/MM/RRRR
3616: HH:MI:SS'));
3617:
3618: delete from per_empdir_images
3619: where orig_system_id not in(

Line 3620: select parent_id from per_images

3616: HH:MI:SS'));
3617:
3618: delete from per_empdir_images
3619: where orig_system_id not in(
3620: select parent_id from per_images
3621: where table_name='PER_PEOPLE_F')
3622: and orig_system = 'PER' ;
3623: commit;
3624:

Line 3629: write_log(1, 'Error in merge_per_images: '||SQLCODE);

3625:
3626: EXCEPTION WHEN OTHERS THEN
3627: errbuf := errbuf||SQLERRM;
3628: retcode := '1';
3629: write_log(1, 'Error in merge_per_images: '||SQLCODE);
3630: write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
3631:
3632: END merge_per_images;
3633:

Line 3632: END merge_per_images;

3628: retcode := '1';
3629: write_log(1, 'Error in merge_per_images: '||SQLCODE);
3630: write_log(1, 'Error Msg: '||substr(SQLERRM,1,700));
3631:
3632: END merge_per_images;
3633:
3634: --End of fix for bug#4380794
3635:
3636: -- Global Members

Line 3741: populate_per_images(

3737: );
3738:
3739: --Fix for bug#4380794
3740: IF p_image_refresh = 'Y' THEN
3741: populate_per_images(
3742: errbuf
3743: ,retcode
3744: );
3745: END IF;

Line 3815: merge_per_images(

3811: );
3812:
3813: --FIX FOR BUG#4380794
3814: IF p_image_refresh = 'Y' THEN
3815: merge_per_images(
3816: errbuf
3817: ,retcode
3818: );
3819: END IF;