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 1282: UPDATE per_empdir_organizations

1278:
1279: g_date := trunc(SYSDATE);
1280:
1281: FORALL I IN 1 .. p_cnt
1282: UPDATE per_empdir_organizations
1283: SET orig_system = orgTbl.orig_system(I)
1284: ,orig_system_id = orgTbl.orig_system_id(I)
1285: ,business_group_id = orgTbl.business_group_id(I)
1286: ,location_id = orgTbl.location_id(I)

Line 1346: INSERT INTO per_empdir_organizations values (

1342: BEGIN
1343: g_date := trunc(SYSDATE);
1344:
1345: FORALL I IN 1 .. p_cnt
1346: INSERT INTO per_empdir_organizations values (
1347: orgTbl.orig_system(I)
1348: ,orgTbl.orig_system_id(I)
1349: ,orgTbl.business_group_id(I)
1350: ,orgTbl.location_id(I)

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

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

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

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

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

3029: ,retcode
3030: ,p_eff_date
3031: );
3032:
3033: write_log(1, 'Total # of records updated for per_empdir_organizations: '||l_cnt);
3034: write_log(2, 'Total # of records updated for per_empdir_organizations: '||l_cnt);
3035:
3036: bulk_process_hr_orgs(
3037: 2

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

3030: ,p_eff_date
3031: );
3032:
3033: write_log(1, 'Total # of records updated for per_empdir_organizations: '||l_cnt);
3034: write_log(2, 'Total # of records updated for per_empdir_organizations: '||l_cnt);
3035:
3036: bulk_process_hr_orgs(
3037: 2
3038: ,l_cnt

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

3040: ,retcode
3041: ,p_eff_date
3042: );
3043:
3044: write_log(1, 'Total # of new records processed for per_empdir_organizations: '||l_cnt);
3045: write_log(2, 'Total # of new records processed for per_empdir_organizations: '||l_cnt);
3046: write_log(1, 'End merge hr organizations: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3047:
3048: EXCEPTION WHEN OTHERS THEN

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

3041: ,p_eff_date
3042: );
3043:
3044: write_log(1, 'Total # of new records processed for per_empdir_organizations: '||l_cnt);
3045: write_log(2, 'Total # of new records processed for per_empdir_organizations: '||l_cnt);
3046: write_log(1, 'End merge hr organizations: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3047:
3048: EXCEPTION WHEN OTHERS THEN
3049: errbuf := errbuf||SQLERRM;

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

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

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

3150: BEGIN
3151:
3152: write_log(1, 'Begin populating hr orgs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3153: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_ORGANIZATIONS TRUNCATE PARTITION internal REUSE STORAGE';
3154: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_ORGANIZATIONS_PK REBUILD';
3155:
3156: g_date := trunc(SYSDATE);
3157:
3158: bulk_process_hr_orgs(

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

3162: ,retcode
3163: ,p_eff_date
3164: );
3165:
3166: write_log(1, 'Total # of records processed for per_empdir_organizations: '||l_cnt);
3167: write_log(2, 'Total # of records processed for per_empdir_organizations: '||l_cnt);
3168: write_log(1, 'End populating hr orgs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3169:
3170: EXCEPTION WHEN OTHERS THEN

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

3163: ,p_eff_date
3164: );
3165:
3166: write_log(1, 'Total # of records processed for per_empdir_organizations: '||l_cnt);
3167: write_log(2, 'Total # of records processed for per_empdir_organizations: '||l_cnt);
3168: write_log(1, 'End populating hr orgs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3169:
3170: EXCEPTION WHEN OTHERS THEN
3171: errbuf := errbuf||SQLERRM;