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_ASSIGNMENTS

Line 86: fnd_stats.gather_table_stats(g_schema_owner,'PER_EMPDIR_ASSIGNMENTS');

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

Line 112: FROM per_empdir_assignments a

108:
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: WHERE a.orig_system = cntTbl.orig_system(I)
114: AND a.active = 'Y'
115: CONNECT BY PRIOR a.person_id = a.supervisor_id
116: AND a.orig_system = cntTbl.orig_system(I)

Line 161: FROM per_empdir_assignments a, per_empdir_people rp

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

Line 917: UPDATE per_empdir_assignments

913:
914: g_date := trunc(SYSDATE);
915:
916: FORALL I IN 1 .. p_cnt
917: UPDATE per_empdir_assignments
918: SET orig_system = asgTbl.orig_system(I)
919: ,orig_system_id = asgTbl.orig_system_id(I)
920: ,business_group_id = asgTbl.business_group_id(I)
921: ,position_id = asgTbl.position_id(I)

Line 998: INSERT INTO per_empdir_assignments values (

994: BEGIN
995: g_date := trunc(SYSDATE);
996:
997: FORALL I IN 1 .. p_cnt
998: INSERT INTO per_empdir_assignments values (
999: asgTbl.orig_system(I)
1000: ,asgTbl.orig_system_id(I)
1001: ,asgTbl.business_group_id(I)
1002: ,asgTbl.position_id(I)

Line 1121: query_str := query_str || ' AND EXISTS (SELECT ''e'' from per_empdir_assignments ia '||

1117: IF (p_mode = 0) THEN
1118: query_str := query_str || ' AND astatus.per_system_status <> ''TERM_ASSIGN''';
1119: OPEN p_cursor FOR query_str using p_eff_date,l_multi_asg,p_eff_date;
1120: ELSIF (p_mode = 1) THEN
1121: query_str := query_str || ' AND EXISTS (SELECT ''e'' from per_empdir_assignments ia '||
1122: ' WHERE ia.orig_system_id = paf.assignment_id'||
1123: ' AND ia.orig_system = ''' || g_srcSystem || ''''||
1124: ' AND ia.object_version_number <> paf.object_version_number)';
1125: OPEN p_cursor FOR query_str using p_eff_date,l_multi_asg,p_eff_date;

Line 1128: ' AND NOT EXISTS (SELECT ''e'' from per_empdir_assignments ia'||

1124: ' AND ia.object_version_number <> paf.object_version_number)';
1125: OPEN p_cursor FOR query_str using p_eff_date,l_multi_asg,p_eff_date;
1126: ELSIF (p_mode = 2) THEN
1127: query_str := query_str || ' AND astatus.per_system_status <> ''TERM_ASSIGN'''||
1128: ' AND NOT EXISTS (SELECT ''e'' from per_empdir_assignments ia'||
1129: ' WHERE ia.orig_system_id = paf.assignment_id'||
1130: ' AND ia.orig_system = ''' || g_srcSystem|| ''')';
1131: OPEN p_cursor FOR query_str using p_eff_date,l_multi_asg,p_eff_date;
1132: END IF;

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

3071: ,p_eff_date
3072: ,p_multi_asg
3073: );
3074:
3075: write_log(1, 'Total # of records updated for per_empdir_assignments: '||l_cnt);
3076: write_log(2, 'Total # of records updated for per_empdir_assignments: '||l_cnt);
3077:
3078: bulk_process_per_asg(
3079: 2

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

3072: ,p_multi_asg
3073: );
3074:
3075: write_log(1, 'Total # of records updated for per_empdir_assignments: '||l_cnt);
3076: write_log(2, 'Total # of records updated for per_empdir_assignments: '||l_cnt);
3077:
3078: bulk_process_per_asg(
3079: 2
3080: ,l_cnt

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

3083: ,p_eff_date
3084: ,p_multi_asg
3085: );
3086:
3087: write_log(1, 'Total # of new records processed for per_empdir_assignments: '||l_cnt);
3088: write_log(2, 'Total # of new records processed for per_empdir_assignments: '||l_cnt);
3089: write_log(1, 'End merge per assignments: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3090:
3091:

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

3084: ,p_multi_asg
3085: );
3086:
3087: write_log(1, 'Total # of new records processed for per_empdir_assignments: '||l_cnt);
3088: write_log(2, 'Total # of new records processed for per_empdir_assignments: '||l_cnt);
3089: write_log(1, 'End merge per assignments: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3090:
3091:
3092: EXCEPTION WHEN OTHERS THEN

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

3107:
3108: BEGIN
3109:
3110: write_log(1, 'Begin populating per assginments: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3111: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_ASSIGNMENTS TRUNCATE PARTITION internal REUSE STORAGE';
3112: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_ASSIGNMENTS_PK REBUILD';
3113:
3114: g_date := trunc(SYSDATE);
3115:

Line 3112: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_ASSIGNMENTS_PK REBUILD';

3108: BEGIN
3109:
3110: write_log(1, 'Begin populating per assginments: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3111: EXECUTE IMMEDIATE 'ALTER TABLE '||g_schema_owner||'.PER_EMPDIR_ASSIGNMENTS TRUNCATE PARTITION internal REUSE STORAGE';
3112: EXECUTE IMMEDIATE 'ALTER INDEX '||g_schema_owner||'.PER_EMPDIR_ASSIGNMENTS_PK REBUILD';
3113:
3114: g_date := trunc(SYSDATE);
3115:
3116: bulk_process_per_asg(

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

3121: ,p_eff_date
3122: ,p_multi_asg
3123: );
3124:
3125: write_log(1, 'Total # of records processed for per_empdir_assignments: '||l_cnt);
3126: write_log(2, 'Total # of records processed for per_empdir_assignments: '||l_cnt);
3127: write_log(1, 'End populating per asg: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3128:
3129: EXCEPTION WHEN OTHERS THEN

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

3122: ,p_multi_asg
3123: );
3124:
3125: write_log(1, 'Total # of records processed for per_empdir_assignments: '||l_cnt);
3126: write_log(2, 'Total # of records processed for per_empdir_assignments: '||l_cnt);
3127: write_log(1, 'End populating per asg: '||to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3128:
3129: EXCEPTION WHEN OTHERS THEN
3130: errbuf := errbuf||SQLERRM;

Line 3669: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_ASSIGNMENTS_WHO DISABLE';

3665:
3666: write_log(1, 'Process began @: '|| to_char(SYSDATE, 'DD/MM/RRRR HH:MI:SS'));
3667:
3668: BEGIN
3669: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_ASSIGNMENTS_WHO DISABLE';
3670: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_LOCATIONS_WHO DISABLE';
3671: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_PEOPLE_WHO DISABLE';
3672: EXECUTE IMMEDIATE 'ALTER TRIGGER PER_EMPDIR_PHONES_WHO DISABLE';
3673: