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_PEOPLE

Line 85: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_PEOPLE');

81: BEGIN
82:
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');

Line 113: per_empdir_people p

109: FOR I IN 1 .. p_cnt LOOP
110: BEGIN
111: SELECT count(unique a.person_id)-1 INTO cntTbl.cnt(I)
112: FROM per_empdir_assignments a,
113: per_empdir_people p
114: WHERE a.orig_system = cntTbl.orig_system(I)
115: AND a.active = 'Y'
116: and a.PERSON_ID = p.orig_system_ID
117: and p.active = 'Y'

Line 131: UPDATE per_empdir_people

127: END;
128: END LOOP;
129:
130: FORALL I IN 1 .. p_cnt
131: UPDATE per_empdir_people
132: SET total_reports = cntTbl.cnt(I)
133: WHERE rowid = cntTbl.row_id(I);
134:
135: EXCEPTION WHEN OTHERS THEN

Line 153: FROM per_empdir_people p

149: SELECT rowid
150: ,orig_system
151: ,orig_system_id
152: ,null cnt
153: FROM per_empdir_people p
154: WHERE active = 'Y'
155: AND p.orig_system = p_source_system;
156:
157: BEGIN

Line 162: UPDATE per_empdir_people p

158:
159:
160: write_log(1, 'Begin Compute Directs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
161:
162: UPDATE per_empdir_people p
163: SET direct_reports = (SELECT count(*)
164: FROM per_empdir_assignments a, per_empdir_people rp
165: WHERE supervisor_id = p.orig_system_id
166: AND a.orig_system = p.orig_system

Line 164: FROM per_empdir_assignments a, per_empdir_people rp

160: write_log(1, 'Begin Compute Directs: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
161:
162: UPDATE per_empdir_people p
163: SET direct_reports = (SELECT count(*)
164: FROM per_empdir_assignments a, per_empdir_people rp
165: WHERE supervisor_id = p.orig_system_id
166: AND a.orig_system = p.orig_system
167: AND a.active = 'Y'
168: -- AND a.primary_flag = 'Y'

Line 1864: INSERT INTO per_empdir_people values (

1860:
1861: g_date := trunc(SYSDATE);
1862:
1863: FORALL I IN 1 .. p_cnt
1864: INSERT INTO per_empdir_people values (
1865: personTbl.person_key(I)
1866: ,personTbl.orig_system(I)
1867: ,personTbl.orig_sytem_id(I)
1868: ,personTbl.business_group_id(I)

Line 1989: UPDATE per_empdir_people

1985:
1986: g_date := trunc(SYSDATE);
1987:
1988: FORALL I IN 1 .. p_cnt
1989: UPDATE per_empdir_people
1990: SET person_key = personTbl.person_key(I)
1991: ,orig_system = personTbl.orig_system(I)
1992: ,orig_system_id = personTbl.orig_sytem_id(I)
1993: ,business_group_id = personTbl.business_group_id(I)

Line 2278: ' ,hr_organization_information oi, per_empdir_people hrdp' ||

2274: 'ppf.per_information27, ppf.per_information28, ppf.per_information29, ppf.per_information30' ||
2275: ',hrdp.direct_reports' ||
2276: ',hrdp.total_reports ' ||
2277: ' FROM per_people_f ppf, per_phones ph' ||
2278: ' ,hr_organization_information oi, per_empdir_people hrdp' ||
2279: ' WHERE :1 BETWEEN effective_start_date AND effective_end_date' ||
2280: ' AND hrdp.orig_system = ''' || g_srcSystem || '''' ||
2281: ' AND ppf.person_id = hrdp.orig_system_id' ||
2282: ' AND (ppf.object_version_number <> hrdp.object_version_number OR' ||

Line 2382: '/* Picking up not exists from per_empdir_people */' ||

2378: ' AND ppf.person_id NOT IN' ||
2379: ' (SELECT person_id FROM per_all_people_f ippf' ||
2380: ' WHERE :4 BETWEEN effective_start_date AND effective_end_date' ||
2381: ' GROUP BY person_id HAVING count(*) > 1)' ||
2382: '/* Picking up not exists from per_empdir_people */' ||
2383: ' AND NOT EXISTS (SELECT ''e'' from per_empdir_people ip' ||
2384: ' WHERE ip.orig_system_id = ppf.person_id' ||
2385: ' AND ip.orig_system = ''' || g_srcSystem || ''')';
2386: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN

Line 2383: ' AND NOT EXISTS (SELECT ''e'' from per_empdir_people ip' ||

2379: ' (SELECT person_id FROM per_all_people_f ippf' ||
2380: ' WHERE :4 BETWEEN effective_start_date AND effective_end_date' ||
2381: ' GROUP BY person_id HAVING count(*) > 1)' ||
2382: '/* Picking up not exists from per_empdir_people */' ||
2383: ' AND NOT EXISTS (SELECT ''e'' from per_empdir_people ip' ||
2384: ' WHERE ip.orig_system_id = ppf.person_id' ||
2385: ' AND ip.orig_system = ''' || g_srcSystem || ''')';
2386: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN
2387: query_str := query_str || ' AND ppf.person_id NOT IN '||

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

2587: ,retcode
2588: ,p_eff_date
2589: );
2590:
2591: write_log(1, 'Total # of records updated for per_empdir_people: '||l_cnt);
2592: write_log(2, 'Total # of records updated for per_empdir_people: '||l_cnt);
2593:
2594: bulk_process_per_people(
2595: 2

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

2588: ,p_eff_date
2589: );
2590:
2591: write_log(1, 'Total # of records updated for per_empdir_people: '||l_cnt);
2592: write_log(2, 'Total # of records updated for per_empdir_people: '||l_cnt);
2593:
2594: bulk_process_per_people(
2595: 2
2596: ,l_cnt

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

2598: ,retcode
2599: ,p_eff_date
2600: );
2601:
2602: write_log(1, 'Total # of new records processed for per_empdir_people: '||l_cnt);
2603: write_log(2, 'Total # of new records processed for per_empdir_people: '||l_cnt);
2604: write_log(1, 'End merge per people: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2605:
2606:

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

2599: ,p_eff_date
2600: );
2601:
2602: write_log(1, 'Total # of new records processed for per_empdir_people: '||l_cnt);
2603: write_log(2, 'Total # of new records processed for per_empdir_people: '||l_cnt);
2604: write_log(1, 'End merge per people: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2605:
2606:
2607: EXCEPTION WHEN OTHERS THEN

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

2623:
2624:
2625: write_log(1, 'Begin populating per people: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2626:
2627: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_PEOPLE TRUNCATE PARTITION internal REUSE STORAGE';
2628: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PEOPLE_PK REBUILD';
2629: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PEOPLE_N1 REBUILD';
2630:
2631: bulk_process_per_people(

Line 2628: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PEOPLE_PK REBUILD';

2624:
2625: write_log(1, 'Begin populating per people: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2626:
2627: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_PEOPLE TRUNCATE PARTITION internal REUSE STORAGE';
2628: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PEOPLE_PK REBUILD';
2629: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PEOPLE_N1 REBUILD';
2630:
2631: bulk_process_per_people(
2632: 0

Line 2629: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PEOPLE_N1 REBUILD';

2625: write_log(1, 'Begin populating per people: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2626:
2627: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_PEOPLE TRUNCATE PARTITION internal REUSE STORAGE';
2628: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PEOPLE_PK REBUILD';
2629: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PEOPLE_N1 REBUILD';
2630:
2631: bulk_process_per_people(
2632: 0
2633: ,l_cnt

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

2635: ,retcode
2636: ,p_eff_date
2637: );
2638:
2639: write_log(1, 'Total # of records processed for per_empdir_people: '||l_cnt);
2640: write_log(2, 'Total # of records processed for per_empdir_people: '||l_cnt);
2641: write_log(1, 'End populating per people: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2642:
2643: EXCEPTION WHEN OTHERS THEN

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

2636: ,p_eff_date
2637: );
2638:
2639: write_log(1, 'Total # of records processed for per_empdir_people: '||l_cnt);
2640: write_log(2, 'Total # of records processed for per_empdir_people: '||l_cnt);
2641: write_log(1, 'End populating per people: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
2642:
2643: EXCEPTION WHEN OTHERS THEN
2644: errbuf := errbuf||SQLERRM;

Line 3677: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_PEOPLE_WHO DISABLE';

3673:
3674: BEGIN
3675: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_ASSIGNMENTS_WHO DISABLE';
3676: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_LOCATIONS_WHO DISABLE';
3677: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_PEOPLE_WHO DISABLE';
3678: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_PHONES_WHO DISABLE';
3679:
3680: EXCEPTION WHEN OTHERS THEN
3681: NULL;

Line 3695: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PEOPLE_N1 REBUILD PARAMETERS(''sync'')';

3691: ,retcode
3692: ,l_eff_date
3693: );
3694:
3695: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PEOPLE_N1 REBUILD PARAMETERS(''sync'')';
3696:
3697: populate_per_asg(
3698: errbuf
3699: ,retcode

Line 3768: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PEOPLE_N1 REBUILD PARAMETERS(''sync'') ONLINE';

3764: ,retcode
3765: ,l_eff_date
3766: );
3767:
3768: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_PEOPLE_N1 REBUILD PARAMETERS(''sync'') ONLINE';
3769:
3770: merge_per_asg(
3771: errbuf
3772: ,retcode