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 323: UPDATE per_empdir_positions

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

Line 386: INSERT INTO per_empdir_positions values (

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

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

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

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

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

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

2984: ,retcode
2985: ,p_eff_date
2986: );
2987:
2988: write_log(1, 'Total # of records updated for per_empdir_positions: '||l_cnt);
2989: write_log(2, 'Total # of records updated for per_empdir_positions: '||l_cnt);
2990:
2991: bulk_process_hr_pos(
2992: 2

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

2985: ,p_eff_date
2986: );
2987:
2988: write_log(1, 'Total # of records updated for per_empdir_positions: '||l_cnt);
2989: write_log(2, 'Total # of records updated for per_empdir_positions: '||l_cnt);
2990:
2991: bulk_process_hr_pos(
2992: 2
2993: ,l_cnt

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

2995: ,retcode
2996: ,p_eff_date
2997: );
2998:
2999: write_log(1, 'Total # of new records processed for per_empdir_positions: '||l_cnt);
3000: write_log(2, 'Total # of new records processed for per_empdir_positions: '||l_cnt);
3001: write_log(1, 'End merge per pos: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3002:
3003: EXCEPTION WHEN OTHERS THEN

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

2996: ,p_eff_date
2997: );
2998:
2999: write_log(1, 'Total # of new records processed for per_empdir_positions: '||l_cnt);
3000: write_log(2, 'Total # of new records processed for per_empdir_positions: '||l_cnt);
3001: write_log(1, 'End merge per pos: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3002:
3003: EXCEPTION WHEN OTHERS THEN
3004: errbuf := errbuf||SQLERRM;

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

3367: BEGIN
3368:
3369: write_log(1, 'Begin populating per pos: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3370:
3371: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_POSITIONS TRUNCATE PARTITION internal REUSE STORAGE';
3372: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_POSITIONS_PK REBUILD';
3373:
3374: g_date := trunc(SYSDATE);
3375:

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

3368:
3369: write_log(1, 'Begin populating per pos: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3370:
3371: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_POSITIONS TRUNCATE PARTITION internal REUSE STORAGE';
3372: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_POSITIONS_PK REBUILD';
3373:
3374: g_date := trunc(SYSDATE);
3375:
3376: bulk_process_hr_pos(

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

3380: ,retcode
3381: ,p_eff_date
3382: );
3383:
3384: write_log(1, 'Total # of records processed for per_empdir_positions: '||l_cnt);
3385: write_log(2, 'Total # of records processed for per_empdir_positions: '||l_cnt);
3386: write_log(1, 'End populating per pos: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3387:
3388: EXCEPTION WHEN OTHERS THEN

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

3381: ,p_eff_date
3382: );
3383:
3384: write_log(1, 'Total # of records processed for per_empdir_positions: '||l_cnt);
3385: write_log(2, 'Total # of records processed for per_empdir_positions: '||l_cnt);
3386: write_log(1, 'End populating per pos: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3387:
3388: EXCEPTION WHEN OTHERS THEN
3389: errbuf := errbuf||SQLERRM;