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_POSITIONS

Line 89: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_POSITIONS');

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

Line 320: UPDATE per_empdir_positions

316:
317: g_date := trunc(SYSDATE);
318:
319: FORALL I IN 1 .. p_cnt
320: UPDATE per_empdir_positions
321: SET orig_system = orgTbl.orig_system(I)
322: ,orig_system_id = posTbl.orig_system_id(I)
323: ,business_group_id = posTbl.business_group_id(I)
324: ,job_id = posTbl.job_id(I)

Line 383: INSERT INTO per_empdir_positions values (

379: BEGIN
380: g_date := trunc(SYSDATE);
381:
382: FORALL I IN 1 .. p_cnt
383: INSERT INTO per_empdir_positions values (
384: posTbl.orig_system(I)
385: ,posTbl.orig_system_id(I)
386: ,posTbl.business_group_id(I)
387: ,posTbl.job_id(I)

Line 470: query_str := query_str || ' AND EXISTS (SELECT ''e'' FROM per_empdir_positions ip'||

466: END IF;
467: IF (p_mode = 0) THEN
468: OPEN p_cursor FOR query_str using p_eff_date;
469: ELSIF (p_mode = 1) THEN
470: query_str := query_str || ' AND EXISTS (SELECT ''e'' FROM per_empdir_positions ip'||
471: ' WHERE ip.orig_system_id = p.position_id'||
472: ' AND ip.orig_system = ''' || g_srcSystem || '''' ||
473: ' AND ip.object_version_number <> p.object_version_number)';
474: OPEN p_cursor FOR query_str using p_eff_date;

Line 476: query_str := query_str || ' AND NOT EXISTS (SELECT ''e'' FROM per_empdir_positions ip'||

472: ' AND ip.orig_system = ''' || g_srcSystem || '''' ||
473: ' AND ip.object_version_number <> p.object_version_number)';
474: OPEN p_cursor FOR query_str using p_eff_date;
475: ELSIF (p_mode = 2) THEN
476: query_str := query_str || ' AND NOT EXISTS (SELECT ''e'' FROM per_empdir_positions ip'||
477: ' WHERE ip.orig_system_id = p.position_id'||
478: ' AND ip.orig_system = ''' || g_srcSystem || ''')';
479:
480: OPEN p_cursor FOR query_str using p_eff_date;

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

2978: ,retcode
2979: ,p_eff_date
2980: );
2981:
2982: write_log(1, 'Total # of records updated for per_empdir_positions: '||l_cnt);
2983: write_log(2, 'Total # of records updated for per_empdir_positions: '||l_cnt);
2984:
2985: bulk_process_hr_pos(
2986: 2

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

2979: ,p_eff_date
2980: );
2981:
2982: write_log(1, 'Total # of records updated for per_empdir_positions: '||l_cnt);
2983: write_log(2, 'Total # of records updated for per_empdir_positions: '||l_cnt);
2984:
2985: bulk_process_hr_pos(
2986: 2
2987: ,l_cnt

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

2989: ,retcode
2990: ,p_eff_date
2991: );
2992:
2993: write_log(1, 'Total # of new records processed for per_empdir_positions: '||l_cnt);
2994: write_log(2, 'Total # of new records processed for per_empdir_positions: '||l_cnt);
2995: write_log(1, 'End merge per pos: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2996:
2997: EXCEPTION WHEN OTHERS THEN

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

2990: ,p_eff_date
2991: );
2992:
2993: write_log(1, 'Total # of new records processed for per_empdir_positions: '||l_cnt);
2994: write_log(2, 'Total # of new records processed for per_empdir_positions: '||l_cnt);
2995: write_log(1, 'End merge per pos: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2996:
2997: EXCEPTION WHEN OTHERS THEN
2998: errbuf := errbuf||SQLERRM;

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

3361: BEGIN
3362:
3363: write_log(1, 'Begin populating per pos: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3364:
3365: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_POSITIONS TRUNCATE PARTITION internal REUSE STORAGE';
3366: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_POSITIONS_PK REBUILD';
3367:
3368: g_date := trunc(SYSDATE);
3369:

Line 3366: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_POSITIONS_PK REBUILD';

3362:
3363: write_log(1, 'Begin populating per pos: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3364:
3365: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_POSITIONS TRUNCATE PARTITION internal REUSE STORAGE';
3366: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_POSITIONS_PK REBUILD';
3367:
3368: g_date := trunc(SYSDATE);
3369:
3370: bulk_process_hr_pos(

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

3374: ,retcode
3375: ,p_eff_date
3376: );
3377:
3378: write_log(1, 'Total # of records processed for per_empdir_positions: '||l_cnt);
3379: write_log(2, 'Total # of records processed for per_empdir_positions: '||l_cnt);
3380: write_log(1, 'End populating per pos: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3381:
3382: EXCEPTION WHEN OTHERS THEN

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

3375: ,p_eff_date
3376: );
3377:
3378: write_log(1, 'Total # of records processed for per_empdir_positions: '||l_cnt);
3379: write_log(2, 'Total # of records processed for per_empdir_positions: '||l_cnt);
3380: write_log(1, 'End populating per pos: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3381:
3382: EXCEPTION WHEN OTHERS THEN
3383: errbuf := errbuf||SQLERRM;