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_JOBS

Line 88: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_JOBS');

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');
92: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_LOCATIONS_TL');

Line 227: insert INTO per_empdir_jobs (ORIG_SYSTEM,

223: g_date := trunc(SYSDATE);
224:
225: FORALL I IN 1 .. p_cnt
226:
227: insert INTO per_empdir_jobs (ORIG_SYSTEM,
228: ORIG_SYSTEM_ID,
229: BUSINESS_GROUP_ID,
230: JOB_DEFINITION_ID,
231: NAME ,

Line 1568: UPDATE per_empdir_jobs

1564:
1565: g_date := trunc(SYSDATE);
1566:
1567: FORALL I IN 1 .. p_cnt
1568: UPDATE per_empdir_jobs
1569: SET orig_system = jobTbl.orig_system(I)
1570: ,orig_system_id = jobTbl.orig_system_id(I)
1571: ,business_group_id = jobTbl.business_group_id(I)
1572: ,name = jobTbl.name(I)

Line 1635: 'AND EXISTS (SELECT ''e'' from per_empdir_jobs ij '||

1631: IF (p_mode = 0) THEN
1632: OPEN p_cursor FOR query_str USING p_busGrpId;
1633: ELSIF (p_mode = 1) THEN
1634: query_str := query_str ||
1635: 'AND EXISTS (SELECT ''e'' from per_empdir_jobs ij '||
1636: 'WHERE ij.orig_system_id = j.job_id '||
1637: 'AND ij.orig_system = '''||g_srcSystem||''' '||
1638: 'AND ij.object_version_number <> j.object_version_number) ';
1639: OPEN p_cursor FOR query_str USING p_busGrpId;

Line 1642: 'AND NOT EXISTS (SELECT ''e'' from per_empdir_jobs ij '||

1638: 'AND ij.object_version_number <> j.object_version_number) ';
1639: OPEN p_cursor FOR query_str USING p_busGrpId;
1640: ELSIF (p_mode = 2) THEN
1641: query_str := query_str ||
1642: 'AND NOT EXISTS (SELECT ''e'' from per_empdir_jobs ij '||
1643: 'WHERE ij.orig_system_id = j.job_id '||
1644: 'AND ij.orig_system = '''||g_srcSystem||''') ';
1645: OPEN p_cursor FOR query_str USING p_busGrpId;
1646: END IF;

Line 2950: write_log(1, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);

2946: l_icnt := l_icnt + l_cnt;
2947:
2948: END LOOP;
2949:
2950: write_log(1, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);
2951: write_log(2, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);
2952: write_log(1, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);
2953: write_log(2, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);
2954: write_log(1, 'End merge per jobs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));

Line 2951: write_log(2, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);

2947:
2948: END LOOP;
2949:
2950: write_log(1, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);
2951: write_log(2, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);
2952: write_log(1, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);
2953: write_log(2, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);
2954: write_log(1, 'End merge per jobs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2955:

Line 2952: write_log(1, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);

2948: END LOOP;
2949:
2950: write_log(1, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);
2951: write_log(2, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);
2952: write_log(1, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);
2953: write_log(2, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);
2954: write_log(1, 'End merge per jobs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2955:
2956: EXCEPTION WHEN OTHERS THEN

Line 2953: write_log(2, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);

2949:
2950: write_log(1, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);
2951: write_log(2, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);
2952: write_log(1, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);
2953: write_log(2, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);
2954: write_log(1, 'End merge per jobs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2955:
2956: EXCEPTION WHEN OTHERS THEN
2957: errbuf := errbuf||SQLERRM;

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

3405: BEGIN
3406:
3407:
3408: write_log(1, 'Begin populating per jobs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3409: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_JOBS TRUNCATE PARTITION internal REUSE STORAGE';
3410: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_JOBS_PK REBUILD';
3411:
3412: FOR I in c_organizations LOOP
3413:

Line 3410: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_JOBS_PK REBUILD';

3406:
3407:
3408: write_log(1, 'Begin populating per jobs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3409: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_JOBS TRUNCATE PARTITION internal REUSE STORAGE';
3410: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_JOBS_PK REBUILD';
3411:
3412: FOR I in c_organizations LOOP
3413:
3414: write_log(1,'Processing jobs for BusGrpId: '||I.organization_id||

Line 3430: write_log(1, 'Total # of records processed for per_empdir_jobs: '||l_tcnt);

3426: l_tcnt := l_tcnt + l_cnt;
3427:
3428: END LOOP;
3429:
3430: write_log(1, 'Total # of records processed for per_empdir_jobs: '||l_tcnt);
3431: write_log(2, 'Total # of records processed for per_empdir_jobs: '||l_tcnt);
3432: write_log(1, 'End populating per jobs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3433:
3434: EXCEPTION WHEN OTHERS THEN

Line 3431: write_log(2, 'Total # of records processed for per_empdir_jobs: '||l_tcnt);

3427:
3428: END LOOP;
3429:
3430: write_log(1, 'Total # of records processed for per_empdir_jobs: '||l_tcnt);
3431: write_log(2, 'Total # of records processed for per_empdir_jobs: '||l_tcnt);
3432: write_log(1, 'End populating per jobs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3433:
3434: EXCEPTION WHEN OTHERS THEN
3435: errbuf := errbuf||SQLERRM;