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 3448: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_schema_owner||'.PER_EMPDIR_IMAGES';

3444: write_log(1, 'Begin populating per images: '||to_char(SYSDATE, 'DD/MM/RRRR
3445: HH:MI:SS'));
3446:
3447: --fix for bug 6066127
3448: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_schema_owner||'.PER_EMPDIR_IMAGES';
3449: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_IMAGES_PK REBUILD';
3450: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_IMAGES_U1 REBUILD';
3451:
3452: /* inserting the blob columns from per_images to per_empdir_images if not exist

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

3445: HH:MI:SS'));
3446:
3447: --fix for bug 6066127
3448: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_schema_owner||'.PER_EMPDIR_IMAGES';
3449: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_IMAGES_PK REBUILD';
3450: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_IMAGES_U1 REBUILD';
3451:
3452: /* inserting the blob columns from per_images to per_empdir_images if not exist
3453: * * already*/

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

3446:
3447: --fix for bug 6066127
3448: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_schema_owner||'.PER_EMPDIR_IMAGES';
3449: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_IMAGES_PK REBUILD';
3450: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_IMAGES_U1 REBUILD';
3451:
3452: /* inserting the blob columns from per_images to per_empdir_images if not exist
3453: * * already*/
3454:

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

3448: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_schema_owner||'.PER_EMPDIR_IMAGES';
3449: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_IMAGES_PK REBUILD';
3450: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_IMAGES_U1 REBUILD';
3451:
3452: /* inserting the blob columns from per_images to per_empdir_images if not exist
3453: * * already*/
3454:
3455: INSERT INTO per_empdir_images
3456: (image_id,

Line 3455: INSERT INTO per_empdir_images

3451:
3452: /* inserting the blob columns from per_images to per_empdir_images if not exist
3453: * * already*/
3454:
3455: INSERT INTO per_empdir_images
3456: (image_id,
3457: orig_system,
3458: orig_system_id,
3459: image_name,

Line 3463: SELECT per_empdir_images_s.nextval

3459: image_name,
3460: content_type,
3461: image,
3462: object_version_number)
3463: SELECT per_empdir_images_s.nextval
3464: ,'PER'
3465: ,pi.parent_id
3466: ,pi.parent_id
3467: ,null

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

3468: ,pi.image
3469: ,1
3470: FROM per_images pi
3471: WHERE pi.table_name='PER_PEOPLE_F'
3472: AND NOT EXISTS ( SELECT 'X'FROM per_empdir_images pei
3473: WHERE pei.orig_system='PER'
3474: AND pei.orig_system_id=pi.parent_id);
3475:
3476:

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

3477:
3478: l_cnt := sql%rowcount;
3479: COMMIT;
3480:
3481: write_log(1, 'Total # of new records processed for per_empdir_images:
3482: '||l_cnt);
3483: write_log(2, 'Total # of new records processed for per_empdir_images:
3484: '||l_cnt);
3485: write_log(1, 'End populating per images: '||to_char(SYSDATE, 'DD/MM/RRRR

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

3479: COMMIT;
3480:
3481: write_log(1, 'Total # of new records processed for per_empdir_images:
3482: '||l_cnt);
3483: write_log(2, 'Total # of new records processed for per_empdir_images:
3484: '||l_cnt);
3485: write_log(1, 'End populating per images: '||to_char(SYSDATE, 'DD/MM/RRRR
3486: HH:MI:SS'));
3487:

Line 3488: delete from per_empdir_images

3484: '||l_cnt);
3485: write_log(1, 'End populating per images: '||to_char(SYSDATE, 'DD/MM/RRRR
3486: HH:MI:SS'));
3487:
3488: delete from per_empdir_images
3489: where orig_system_id not in(
3490: select parent_id from per_images
3491: where table_name='PER_PEOPLE_F')
3492: and orig_system = 'PER' ;

Line 3524: From per_images pi,per_empdir_images pei

3520: L_CREATION_DATE DATE;
3521:
3522: Cursor update_emp_dirimages_cur is
3523: Select pi.parent_id parent_id
3524: From per_images pi,per_empdir_images pei
3525: Where pi.table_name='PER_PEOPLE_F'
3526: And pi.parent_id =pei.orig_system_id
3527: And pei.orig_system='PER'
3528: And trunc(pei.last_update_date) <= trunc(sysdate);

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

3531: BEGIN
3532:
3533: write_log(1, 'Begin merging per images: '||to_char(SYSDATE, 'DD/MM/RRRR
3534: HH:MI:SS'));
3535: /* updating the blob columns from per_images to per_empdir_images if exist */
3536:
3537:
3538: FOR update_emp_dirimages_rec IN update_emp_dirimages_cur
3539: LOOP

Line 3546: FROM PER_EMPDIR_IMAGES

3542: NVL(OBJECT_VERSION_NUMBER,0),NVL(LAST_UPDATE_DATE,SYSDATE),
3543: NVL(LAST_UPDATED_BY,0),NVL(LAST_UPDATE_LOGIN,0),NVL(CREATED_BY,0),NVL(CREATION_DATE,SYSDATE) INTO
3544: L_IMAGE_ID,L_ORIG_SYSTEM,L_ORIG_SYSTEM_ID,L_IMAGE_NAME,L_CONTENT_TYPE,L_OBJECT_VERSION_NUMBER,L_LAST_UPDATE_DATE,
3545: L_LAST_UPDATED_BY,L_LAST_UPDATE_LOGIN,L_CREATED_BY,L_CREATION_DATE
3546: FROM PER_EMPDIR_IMAGES
3547: WHERE ORIG_SYSTEM_ID = update_emp_dirimages_rec.parent_id
3548: AND orig_system='PER';
3549:
3550: DELETE FROM PER_EMPDIR_IMAGES

Line 3550: DELETE FROM PER_EMPDIR_IMAGES

3546: FROM PER_EMPDIR_IMAGES
3547: WHERE ORIG_SYSTEM_ID = update_emp_dirimages_rec.parent_id
3548: AND orig_system='PER';
3549:
3550: DELETE FROM PER_EMPDIR_IMAGES
3551: WHERE ORIG_SYSTEM_ID = update_emp_dirimages_rec.parent_id
3552: AND orig_system='PER';
3553:
3554: INSERT INTO PER_EMPDIR_IMAGES

Line 3554: INSERT INTO PER_EMPDIR_IMAGES

3550: DELETE FROM PER_EMPDIR_IMAGES
3551: WHERE ORIG_SYSTEM_ID = update_emp_dirimages_rec.parent_id
3552: AND orig_system='PER';
3553:
3554: INSERT INTO PER_EMPDIR_IMAGES
3555: (IMAGE_ID,ORIG_SYSTEM,ORIG_SYSTEM_ID,IMAGE_NAME,CONTENT_TYPE,IMAGE,OBJECT_VERSION_NUMBER,LAST_UPDATE_DATE,
3556: LAST_UPDATED_BY,LAST_UPDATE_LOGIN,CREATED_BY,CREATION_DATE)
3557: SELECT L_IMAGE_ID,L_ORIG_SYSTEM,L_ORIG_SYSTEM_ID,L_IMAGE_NAME,L_CONTENT_TYPE,
3558: image,

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

3572:
3573: COMMIT;
3574:
3575:
3576: write_log(1, 'Total # of records updated for per_empdir_images: '||l_cnt);
3577: write_log(2, 'Total # of records updated for per_empdir_images: '||l_cnt);
3578: /* inserting the blob columns from per_images to per_empdir_images if not exist
3579: * * already*/
3580: l_cnt :=0;

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

3573: COMMIT;
3574:
3575:
3576: write_log(1, 'Total # of records updated for per_empdir_images: '||l_cnt);
3577: write_log(2, 'Total # of records updated for per_empdir_images: '||l_cnt);
3578: /* inserting the blob columns from per_images to per_empdir_images if not exist
3579: * * already*/
3580: l_cnt :=0;
3581: INSERT INTO per_empdir_images

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

3574:
3575:
3576: write_log(1, 'Total # of records updated for per_empdir_images: '||l_cnt);
3577: write_log(2, 'Total # of records updated for per_empdir_images: '||l_cnt);
3578: /* inserting the blob columns from per_images to per_empdir_images if not exist
3579: * * already*/
3580: l_cnt :=0;
3581: INSERT INTO per_empdir_images
3582: (image_id,

Line 3581: INSERT INTO per_empdir_images

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

Line 3589: SELECT per_empdir_images_s.nextval

3585: image_name,
3586: content_type,
3587: image,
3588: object_version_number)
3589: SELECT per_empdir_images_s.nextval
3590: ,'PER'
3591: ,pi.parent_id
3592: ,pi.parent_id
3593: ,null

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

3594: ,pi.image
3595: ,1
3596: FROM per_images pi
3597: WHERE pi.table_name='PER_PEOPLE_F'
3598: AND NOT EXISTS ( SELECT 'X'FROM per_empdir_images pei
3599: WHERE pei.orig_system='PER'
3600: AND pei.orig_system_id=pi.parent_id);
3601:
3602: l_cnt := sql%rowcount;

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

3601:
3602: l_cnt := sql%rowcount;
3603: COMMIT;
3604:
3605: write_log(1, 'Total # of new records processed for per_empdir_images:
3606: '||l_cnt);
3607: write_log(2, 'Total # of new records processed for per_empdir_images:
3608: '||l_cnt);
3609: write_log(1, 'End merge per images: '||to_char(SYSDATE, 'DD/MM/RRRR

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

3603: COMMIT;
3604:
3605: write_log(1, 'Total # of new records processed for per_empdir_images:
3606: '||l_cnt);
3607: write_log(2, 'Total # of new records processed for per_empdir_images:
3608: '||l_cnt);
3609: write_log(1, 'End merge per images: '||to_char(SYSDATE, 'DD/MM/RRRR
3610: HH:MI:SS'));
3611:

Line 3612: delete from per_empdir_images

3608: '||l_cnt);
3609: write_log(1, 'End merge per images: '||to_char(SYSDATE, 'DD/MM/RRRR
3610: HH:MI:SS'));
3611:
3612: delete from per_empdir_images
3613: where orig_system_id not in(
3614: select parent_id from per_images
3615: where table_name='PER_PEOPLE_F')
3616: and orig_system = 'PER' ;