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.HR_SECURITY_INTERNAL dependencies on PER_ALL_ASSIGNMENTS_F_PERF

Line 4752: l_paaf_name := 'per_all_assignments_f_perf';

4748: --
4749:
4750: --- Bug # 12739699 ---
4751: if NVL(fnd_profile.value('PER_SECURITY_ENHANCER'),'N') = 'PERF_ASG' then
4752: l_paaf_name := 'per_all_assignments_f_perf';
4753: else
4754: l_paaf_name := 'per_all_assignments_f';
4755: end if;
4756: --- Bug # 12739699 ---

Line 9433: DELETE FROM PER_ALL_ASSIGNMENTS_F_PERF;

9429: fnd_file.put_line(fnd_file.log,'p_table: '||p_table);
9430: hr_utility.set_location('Entering:'|| l_proc, 10);
9431: hr_utility.set_location('p_table:'|| p_table, 15);
9432: if p_table = 'ASG_PERF' then
9433: DELETE FROM PER_ALL_ASSIGNMENTS_F_PERF;
9434: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Deleted from PER_ALL_ASSIGNMENTS_F_PERF', 20);
9435: fnd_file.put_line(fnd_file.log,'Rows Deleted into PER_ALL_ASSIGNMENTS_F_PERF');
9436: INSERT INTO PER_ALL_ASSIGNMENTS_F_PERF
9437: (ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,

Line 9434: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Deleted from PER_ALL_ASSIGNMENTS_F_PERF', 20);

9430: hr_utility.set_location('Entering:'|| l_proc, 10);
9431: hr_utility.set_location('p_table:'|| p_table, 15);
9432: if p_table = 'ASG_PERF' then
9433: DELETE FROM PER_ALL_ASSIGNMENTS_F_PERF;
9434: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Deleted from PER_ALL_ASSIGNMENTS_F_PERF', 20);
9435: fnd_file.put_line(fnd_file.log,'Rows Deleted into PER_ALL_ASSIGNMENTS_F_PERF');
9436: INSERT INTO PER_ALL_ASSIGNMENTS_F_PERF
9437: (ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,
9438: POSITION_ID,SUPERVISOR_ID,ORGANIZATION_ID,ASSIGNMENT_STATUS_TYPE_ID,PRIMARY_FLAG,

Line 9435: fnd_file.put_line(fnd_file.log,'Rows Deleted into PER_ALL_ASSIGNMENTS_F_PERF');

9431: hr_utility.set_location('p_table:'|| p_table, 15);
9432: if p_table = 'ASG_PERF' then
9433: DELETE FROM PER_ALL_ASSIGNMENTS_F_PERF;
9434: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Deleted from PER_ALL_ASSIGNMENTS_F_PERF', 20);
9435: fnd_file.put_line(fnd_file.log,'Rows Deleted into PER_ALL_ASSIGNMENTS_F_PERF');
9436: INSERT INTO PER_ALL_ASSIGNMENTS_F_PERF
9437: (ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,
9438: POSITION_ID,SUPERVISOR_ID,ORGANIZATION_ID,ASSIGNMENT_STATUS_TYPE_ID,PRIMARY_FLAG,
9439: SUPERVISOR_ASSIGNMENT_ID,BUSINESS_GROUP_ID)

Line 9436: INSERT INTO PER_ALL_ASSIGNMENTS_F_PERF

9432: if p_table = 'ASG_PERF' then
9433: DELETE FROM PER_ALL_ASSIGNMENTS_F_PERF;
9434: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Deleted from PER_ALL_ASSIGNMENTS_F_PERF', 20);
9435: fnd_file.put_line(fnd_file.log,'Rows Deleted into PER_ALL_ASSIGNMENTS_F_PERF');
9436: INSERT INTO PER_ALL_ASSIGNMENTS_F_PERF
9437: (ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,
9438: POSITION_ID,SUPERVISOR_ID,ORGANIZATION_ID,ASSIGNMENT_STATUS_TYPE_ID,PRIMARY_FLAG,
9439: SUPERVISOR_ASSIGNMENT_ID,BUSINESS_GROUP_ID)
9440: SELECT ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,

Line 9443: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF', 30);

9439: SUPERVISOR_ASSIGNMENT_ID,BUSINESS_GROUP_ID)
9440: SELECT ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,
9441: POSITION_ID,SUPERVISOR_ID,ORGANIZATION_ID,ASSIGNMENT_STATUS_TYPE_ID,PRIMARY_FLAG,SUPERVISOR_ASSIGNMENT_ID,
9442: BUSINESS_GROUP_ID FROM PER_ALL_ASSIGNMENTS_F;
9443: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF', 30);
9444: fnd_file.put_line(fnd_file.log,'Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF');
9445: end if;
9446: hr_utility.set_location('Leaving:'|| l_proc, 90);
9447: exception

Line 9444: fnd_file.put_line(fnd_file.log,'Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF');

9440: SELECT ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,
9441: POSITION_ID,SUPERVISOR_ID,ORGANIZATION_ID,ASSIGNMENT_STATUS_TYPE_ID,PRIMARY_FLAG,SUPERVISOR_ASSIGNMENT_ID,
9442: BUSINESS_GROUP_ID FROM PER_ALL_ASSIGNMENTS_F;
9443: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF', 30);
9444: fnd_file.put_line(fnd_file.log,'Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF');
9445: end if;
9446: hr_utility.set_location('Leaving:'|| l_proc, 90);
9447: exception
9448: when others then