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_ORGANIZATIONS

Line 87: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ORGANIZATIONS');

83: write_log(1, 'Begin gathering stats: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
84:
85: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_PEOPLE');
86: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ASSIGNMENTS');
87: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ORGANIZATIONS');
88: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_JOBS');
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');

Line 1278: UPDATE per_empdir_organizations

1274:
1275: g_date := trunc(SYSDATE);
1276:
1277: FORALL I IN 1 .. p_cnt
1278: UPDATE per_empdir_organizations
1279: SET orig_system = orgTbl.orig_system(I)
1280: ,orig_system_id = orgTbl.orig_system_id(I)
1281: ,business_group_id = orgTbl.business_group_id(I)
1282: ,location_id = orgTbl.location_id(I)

Line 1342: INSERT INTO per_empdir_organizations values (

1338: BEGIN
1339: g_date := trunc(SYSDATE);
1340:
1341: FORALL I IN 1 .. p_cnt
1342: INSERT INTO per_empdir_organizations values (
1343: orgTbl.orig_system(I)
1344: ,orgTbl.orig_system_id(I)
1345: ,orgTbl.business_group_id(I)
1346: ,orgTbl.location_id(I)

Line 1427: query_str := query_str || ' AND EXISTS (SELECT ''e'' FROM per_empdir_organizations io '||

1423: END IF;
1424: IF (p_mode = 0) THEN
1425: OPEN p_cursor FOR query_str;
1426: ELSIF (p_mode = 1) THEN
1427: query_str := query_str || ' AND EXISTS (SELECT ''e'' FROM per_empdir_organizations io '||
1428: ' WHERE io.orig_system_id = hou.organization_id' ||
1429: ' AND io.orig_system = ''' || g_srcSystem || '''' ||
1430: ' AND io.object_version_number <> hou.object_version_number)';
1431: OPEN p_cursor FOR query_str;

Line 1433: query_str := query_str || ' AND NOT EXISTS (SELECT ''e'' FROM per_empdir_organizations io '||

1429: ' AND io.orig_system = ''' || g_srcSystem || '''' ||
1430: ' AND io.object_version_number <> hou.object_version_number)';
1431: OPEN p_cursor FOR query_str;
1432: ELSIF (p_mode = 2) THEN
1433: query_str := query_str || ' AND NOT EXISTS (SELECT ''e'' FROM per_empdir_organizations io '||
1434: ' WHERE io.orig_system_id = houtl.organization_id'||
1435: ' AND io.orig_system = ''' || g_srcSystem || ''')';
1436:
1437: OPEN p_cursor FOR query_str;

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

3023: ,retcode
3024: ,p_eff_date
3025: );
3026:
3027: write_log(1, 'Total # of records updated for per_empdir_organizations: '||l_cnt);
3028: write_log(2, 'Total # of records updated for per_empdir_organizations: '||l_cnt);
3029:
3030: bulk_process_hr_orgs(
3031: 2

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

3024: ,p_eff_date
3025: );
3026:
3027: write_log(1, 'Total # of records updated for per_empdir_organizations: '||l_cnt);
3028: write_log(2, 'Total # of records updated for per_empdir_organizations: '||l_cnt);
3029:
3030: bulk_process_hr_orgs(
3031: 2
3032: ,l_cnt

Line 3038: write_log(1, 'Total # of new records processed for per_empdir_organizations: '||l_cnt);

3034: ,retcode
3035: ,p_eff_date
3036: );
3037:
3038: write_log(1, 'Total # of new records processed for per_empdir_organizations: '||l_cnt);
3039: write_log(2, 'Total # of new records processed for per_empdir_organizations: '||l_cnt);
3040: write_log(1, 'End merge hr organizations: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3041:
3042: EXCEPTION WHEN OTHERS THEN

Line 3039: write_log(2, 'Total # of new records processed for per_empdir_organizations: '||l_cnt);

3035: ,p_eff_date
3036: );
3037:
3038: write_log(1, 'Total # of new records processed for per_empdir_organizations: '||l_cnt);
3039: write_log(2, 'Total # of new records processed for per_empdir_organizations: '||l_cnt);
3040: write_log(1, 'End merge hr organizations: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3041:
3042: EXCEPTION WHEN OTHERS THEN
3043: errbuf := errbuf||SQLERRM;

Line 3147: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_ORGANIZATIONS TRUNCATE PARTITION internal REUSE STORAGE';

3143:
3144: BEGIN
3145:
3146: write_log(1, 'Begin populating hr orgs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3147: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_ORGANIZATIONS TRUNCATE PARTITION internal REUSE STORAGE';
3148: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_ORGANIZATIONS_PK REBUILD';
3149:
3150: g_date := trunc(SYSDATE);
3151:

Line 3148: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_ORGANIZATIONS_PK REBUILD';

3144: BEGIN
3145:
3146: write_log(1, 'Begin populating hr orgs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3147: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_ORGANIZATIONS TRUNCATE PARTITION internal REUSE STORAGE';
3148: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_ORGANIZATIONS_PK REBUILD';
3149:
3150: g_date := trunc(SYSDATE);
3151:
3152: bulk_process_hr_orgs(

Line 3160: write_log(1, 'Total # of records processed for per_empdir_organizations: '||l_cnt);

3156: ,retcode
3157: ,p_eff_date
3158: );
3159:
3160: write_log(1, 'Total # of records processed for per_empdir_organizations: '||l_cnt);
3161: write_log(2, 'Total # of records processed for per_empdir_organizations: '||l_cnt);
3162: write_log(1, 'End populating hr orgs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3163:
3164: EXCEPTION WHEN OTHERS THEN

Line 3161: write_log(2, 'Total # of records processed for per_empdir_organizations: '||l_cnt);

3157: ,p_eff_date
3158: );
3159:
3160: write_log(1, 'Total # of records processed for per_empdir_organizations: '||l_cnt);
3161: write_log(2, 'Total # of records processed for per_empdir_organizations: '||l_cnt);
3162: write_log(1, 'End populating hr orgs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3163:
3164: EXCEPTION WHEN OTHERS THEN
3165: errbuf := errbuf||SQLERRM;