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_IMAGES

Line 93: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_IMAGES');

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:
95: write_log(1, 'End gathering stats: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
96:
97: EXCEPTION WHEN OTHERS THEN

Line 3454: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_schema_owner||'.PER_EMPDIR_IMAGES';

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';
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

Line 3455: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_IMAGES_PK REBUILD';

3451: HH:MI:SS'));
3452:
3453: --fix for bug 6066127
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*/

Line 3456: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_IMAGES_U1 REBUILD';

3452:
3453: --fix for bug 6066127
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:

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 3461: INSERT INTO per_empdir_images

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,
3463: orig_system,
3464: orig_system_id,
3465: image_name,

Line 3469: SELECT per_empdir_images_s.nextval

3465: image_name,
3466: content_type,
3467: image,
3468: object_version_number)
3469: SELECT per_empdir_images_s.nextval
3470: ,'PER'
3471: ,pi.parent_id
3472: ,pi.parent_id
3473: ,null

Line 3478: AND NOT EXISTS ( SELECT 'X'FROM per_empdir_images pei

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);
3481:
3482:

Line 3487: write_log(1, 'Total # of new records processed for per_empdir_images:

3483:
3484: l_cnt := sql%rowcount;
3485: COMMIT;
3486:
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

Line 3489: write_log(2, 'Total # of new records processed for per_empdir_images:

3485: COMMIT;
3486:
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:

Line 3494: delete from 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(
3496: select parent_id from per_images
3497: where table_name='PER_PEOPLE_F')
3498: and orig_system = 'PER' ;

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 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 3552: FROM PER_EMPDIR_IMAGES

3548: NVL(OBJECT_VERSION_NUMBER,0),NVL(LAST_UPDATE_DATE,SYSDATE),
3549: NVL(LAST_UPDATED_BY,0),NVL(LAST_UPDATE_LOGIN,0),NVL(CREATED_BY,0),NVL(CREATION_DATE,SYSDATE) INTO
3550: L_IMAGE_ID,L_ORIG_SYSTEM,L_ORIG_SYSTEM_ID,L_IMAGE_NAME,L_CONTENT_TYPE,L_OBJECT_VERSION_NUMBER,L_LAST_UPDATE_DATE,
3551: L_LAST_UPDATED_BY,L_LAST_UPDATE_LOGIN,L_CREATED_BY,L_CREATION_DATE
3552: FROM PER_EMPDIR_IMAGES
3553: WHERE ORIG_SYSTEM_ID = update_emp_dirimages_rec.parent_id
3554: AND orig_system='PER';
3555:
3556: DELETE FROM PER_EMPDIR_IMAGES

Line 3556: DELETE FROM PER_EMPDIR_IMAGES

3552: FROM PER_EMPDIR_IMAGES
3553: WHERE ORIG_SYSTEM_ID = update_emp_dirimages_rec.parent_id
3554: AND orig_system='PER';
3555:
3556: DELETE FROM PER_EMPDIR_IMAGES
3557: WHERE ORIG_SYSTEM_ID = update_emp_dirimages_rec.parent_id
3558: AND orig_system='PER';
3559:
3560: INSERT INTO PER_EMPDIR_IMAGES

Line 3560: INSERT INTO PER_EMPDIR_IMAGES

3556: DELETE FROM PER_EMPDIR_IMAGES
3557: WHERE ORIG_SYSTEM_ID = update_emp_dirimages_rec.parent_id
3558: AND orig_system='PER';
3559:
3560: INSERT INTO PER_EMPDIR_IMAGES
3561: (IMAGE_ID,ORIG_SYSTEM,ORIG_SYSTEM_ID,IMAGE_NAME,CONTENT_TYPE,IMAGE,OBJECT_VERSION_NUMBER,LAST_UPDATE_DATE,
3562: LAST_UPDATED_BY,LAST_UPDATE_LOGIN,CREATED_BY,CREATION_DATE)
3563: SELECT L_IMAGE_ID,L_ORIG_SYSTEM,L_ORIG_SYSTEM_ID,L_IMAGE_NAME,L_CONTENT_TYPE,
3564: image,

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

3578:
3579: COMMIT;
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;

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

3579: COMMIT;
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

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 3587: INSERT INTO per_empdir_images

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,
3589: orig_system,
3590: orig_system_id,
3591: image_name,

Line 3595: SELECT per_empdir_images_s.nextval

3591: image_name,
3592: content_type,
3593: image,
3594: object_version_number)
3595: SELECT per_empdir_images_s.nextval
3596: ,'PER'
3597: ,pi.parent_id
3598: ,pi.parent_id
3599: ,null

Line 3604: AND NOT EXISTS ( SELECT 'X'FROM per_empdir_images pei

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);
3607:
3608: l_cnt := sql%rowcount;

Line 3611: write_log(1, 'Total # of new records processed for per_empdir_images:

3607:
3608: l_cnt := sql%rowcount;
3609: COMMIT;
3610:
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

Line 3613: write_log(2, 'Total # of new records processed for per_empdir_images:

3609: COMMIT;
3610:
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:

Line 3618: delete from 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(
3620: select parent_id from per_images
3621: where table_name='PER_PEOPLE_F')
3622: and orig_system = 'PER' ;