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 224: insert INTO per_empdir_jobs (ORIG_SYSTEM,

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

Line 1564: UPDATE per_empdir_jobs

1560:
1561: g_date := trunc(SYSDATE);
1562:
1563: FORALL I IN 1 .. p_cnt
1564: UPDATE per_empdir_jobs
1565: SET orig_system = jobTbl.orig_system(I)
1566: ,orig_system_id = jobTbl.orig_system_id(I)
1567: ,business_group_id = jobTbl.business_group_id(I)
1568: ,name = jobTbl.name(I)

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

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

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

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

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

2940: l_icnt := l_icnt + l_cnt;
2941:
2942: END LOOP;
2943:
2944: write_log(1, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);
2945: write_log(2, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);
2946: write_log(1, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);
2947: write_log(2, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);
2948: write_log(1, 'End merge per jobs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));

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

2941:
2942: END LOOP;
2943:
2944: write_log(1, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);
2945: write_log(2, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);
2946: write_log(1, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);
2947: write_log(2, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);
2948: write_log(1, 'End merge per jobs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2949:

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

2942: END LOOP;
2943:
2944: write_log(1, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);
2945: write_log(2, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);
2946: write_log(1, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);
2947: write_log(2, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);
2948: write_log(1, 'End merge per jobs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2949:
2950: EXCEPTION WHEN OTHERS THEN

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

2943:
2944: write_log(1, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);
2945: write_log(2, 'Total # of records updated for per_empdir_jobs: '||l_ucnt);
2946: write_log(1, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);
2947: write_log(2, 'Total # of new records processed for per_empdir_jobs: '||l_icnt);
2948: write_log(1, 'End merge per jobs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2949:
2950: EXCEPTION WHEN OTHERS THEN
2951: errbuf := errbuf||SQLERRM;

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

3399: BEGIN
3400:
3401:
3402: write_log(1, 'Begin populating per jobs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3403: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_JOBS TRUNCATE PARTITION internal REUSE STORAGE';
3404: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_JOBS_PK REBUILD';
3405:
3406: FOR I in c_organizations LOOP
3407:

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

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

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

3420: l_tcnt := l_tcnt + l_cnt;
3421:
3422: END LOOP;
3423:
3424: write_log(1, 'Total # of records processed for per_empdir_jobs: '||l_tcnt);
3425: write_log(2, 'Total # of records processed for per_empdir_jobs: '||l_tcnt);
3426: write_log(1, 'End populating per jobs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3427:
3428: EXCEPTION WHEN OTHERS THEN

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

3421:
3422: END LOOP;
3423:
3424: write_log(1, 'Total # of records processed for per_empdir_jobs: '||l_tcnt);
3425: write_log(2, 'Total # of records processed for per_empdir_jobs: '||l_tcnt);
3426: write_log(1, 'End populating per jobs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3427:
3428: EXCEPTION WHEN OTHERS THEN
3429: errbuf := errbuf||SQLERRM;