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_PERSON_DEPLOYMENT_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 896: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

892: --variables for OUT and INOUT in API calls
893: l_cagr_grade_def_id number;
894: l_cagr_concatenated_segments varchar2(2000);
895: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
896: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
897: l_comment_id per_all_assignments_f.comment_id%TYPE;
898: l_host_per_comment_id number;
899: l_host_asg_sequence number;
900: l_host_asg_number per_all_assignments_f.assignment_number%type;

Line 897: l_comment_id per_all_assignments_f.comment_id%TYPE;

893: l_cagr_grade_def_id number;
894: l_cagr_concatenated_segments varchar2(2000);
895: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
896: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
897: l_comment_id per_all_assignments_f.comment_id%TYPE;
898: l_host_per_comment_id number;
899: l_host_asg_sequence number;
900: l_host_asg_number per_all_assignments_f.assignment_number%type;
901: l_assignment_status_type_id number;

Line 900: l_host_asg_number per_all_assignments_f.assignment_number%type;

896: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
897: l_comment_id per_all_assignments_f.comment_id%TYPE;
898: l_host_per_comment_id number;
899: l_host_asg_sequence number;
900: l_host_asg_number per_all_assignments_f.assignment_number%type;
901: l_assignment_status_type_id number;
902: l_special_ceiling_step_id number;
903: l_group_name pay_people_groups.group_name%TYPE;
904: l_host_contact_person_id number;

Line 941: l_created_by per_all_assignments_f.created_by%TYPE;

937: l_proposed_salary_warning boolean;
938: l_approved_warning boolean;
939: l_payroll_warning boolean;
940: --new variables declared
941: l_created_by per_all_assignments_f.created_by%TYPE;
942: l_creation_date per_all_assignments_f.creation_date%TYPE;
943: l_last_update_date per_all_assignments_f.last_update_date%TYPE;
944: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
945: l_last_update_login per_all_assignments_f.last_update_login%TYPE;

Line 942: l_creation_date per_all_assignments_f.creation_date%TYPE;

938: l_approved_warning boolean;
939: l_payroll_warning boolean;
940: --new variables declared
941: l_created_by per_all_assignments_f.created_by%TYPE;
942: l_creation_date per_all_assignments_f.creation_date%TYPE;
943: l_last_update_date per_all_assignments_f.last_update_date%TYPE;
944: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
945: l_last_update_login per_all_assignments_f.last_update_login%TYPE;
946: l_payroll_id_updated BOOLEAN;

Line 943: l_last_update_date per_all_assignments_f.last_update_date%TYPE;

939: l_payroll_warning boolean;
940: --new variables declared
941: l_created_by per_all_assignments_f.created_by%TYPE;
942: l_creation_date per_all_assignments_f.creation_date%TYPE;
943: l_last_update_date per_all_assignments_f.last_update_date%TYPE;
944: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
945: l_last_update_login per_all_assignments_f.last_update_login%TYPE;
946: l_payroll_id_updated BOOLEAN;
947: l_business_group_id hr_all_organization_units.organization_id%TYPE;

Line 944: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;

940: --new variables declared
941: l_created_by per_all_assignments_f.created_by%TYPE;
942: l_creation_date per_all_assignments_f.creation_date%TYPE;
943: l_last_update_date per_all_assignments_f.last_update_date%TYPE;
944: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
945: l_last_update_login per_all_assignments_f.last_update_login%TYPE;
946: l_payroll_id_updated BOOLEAN;
947: l_business_group_id hr_all_organization_units.organization_id%TYPE;
948: l_validation_start_date DATE;

Line 945: l_last_update_login per_all_assignments_f.last_update_login%TYPE;

941: l_created_by per_all_assignments_f.created_by%TYPE;
942: l_creation_date per_all_assignments_f.creation_date%TYPE;
943: l_last_update_date per_all_assignments_f.last_update_date%TYPE;
944: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
945: l_last_update_login per_all_assignments_f.last_update_login%TYPE;
946: l_payroll_id_updated BOOLEAN;
947: l_business_group_id hr_all_organization_units.organization_id%TYPE;
948: l_validation_start_date DATE;
949: l_validation_end_date DATE;

Line 1010: from per_all_assignments_f paaf

1006: papf.effective_start_date and papf.effective_end_date;
1007: --
1008: cursor csr_host_asg_ovn(p_assignment_id number) is
1009: select paaf.object_version_number
1010: from per_all_assignments_f paaf
1011: where paaf.assignment_id = p_assignment_id
1012: and l_dpl_rec.start_date between
1013: paaf.effective_start_date and paaf.effective_end_date;
1014: --

Line 1017: from per_all_assignments_f paaf,

1013: paaf.effective_start_date and paaf.effective_end_date;
1014: --
1015: cursor csr_active_home_asgs(p_person_id number) is
1016: select paaf.assignment_id, paaf.object_version_number
1017: from per_all_assignments_f paaf,
1018: per_assignment_status_types past
1019: where paaf.person_id = p_person_id
1020: and l_dpl_rec.start_date between
1021: paaf.effective_start_date and paaf.effective_end_date

Line 1074: from per_all_assignments_f asg

1070: l_eit_details csr_eit_details%rowtype;
1071: --
1072: /* cursor csr_direct_reports(p_person_id number, p_effective_date date) is
1073: select asg.assignment_id, asg.effective_start_date
1074: from per_all_assignments_f asg
1075: where asg.supervisor_id = p_person_id
1076: and asg.effective_end_date > p_effective_date;*/
1077: --
1078: cursor csr_direct_reports(p_person_id number, p_start_date date) is

Line 1080: from per_all_assignments_f asg

1076: and asg.effective_end_date > p_effective_date;*/
1077: --
1078: cursor csr_direct_reports(p_person_id number, p_start_date date) is
1079: select *
1080: from per_all_assignments_f asg
1081: where asg.supervisor_id = p_person_id
1082: and p_start_date between asg.effective_start_date and asg.effective_end_date;
1083:
1084: ------------------

Line 1087: from per_all_assignments_f asg

1083:
1084: ------------------
1085: cursor csr_fut_dt_rows(p_person_id number, p_start_date date) is
1086: select asg.assignment_id, asg.effective_start_date,asg.effective_end_date
1087: from per_all_assignments_f asg
1088: where asg.supervisor_id = p_person_id
1089: and asg.effective_start_date > p_start_date;
1090: -----
1091:

Line 1309: update per_all_assignments_f

1305: --Moved this logic at later stage
1306: /* if nvl(l_dpl_rec.retain_direct_reports,'N') = 'Y' then
1307: for l_reports in csr_direct_reports
1308: (l_dpl_rec.from_person_id,l_dpl_rec.start_date) loop
1309: update per_all_assignments_f
1310: set supervisor_id = l_host_person_id,
1311: supervisor_assignment_id =
1312: decode(supervisor_assignment_id,null,null,l_host_assignment_id),
1313: object_version_number = object_version_number+1

Line 1462: from per_all_assignments_f

1458: /*Start of code for bug#16461888*/
1459:
1460: Select count(effective_start_date)
1461: into l_later_count
1462: from per_all_assignments_f
1463: where assignment_id = l_reports.assignment_id
1464: and effective_start_date > (select effective_end_date
1465: from per_all_assignments_f
1466: where assignment_id = l_reports.assignment_id

Line 1465: from per_all_assignments_f

1461: into l_later_count
1462: from per_all_assignments_f
1463: where assignment_id = l_reports.assignment_id
1464: and effective_start_date > (select effective_end_date
1465: from per_all_assignments_f
1466: where assignment_id = l_reports.assignment_id
1467: and l_dpl_rec.start_date between effective_start_date and effective_end_date);
1468:
1469: if (l_later_count > 0 ) then

Line 1485: update per_all_assignments_f

1481:
1482:
1483: if l_datetrack_update_mode = 'CORRECTION' then
1484:
1485: update per_all_assignments_f
1486: set supervisor_id = l_host_person_id,
1487: supervisor_assignment_id =
1488: decode(supervisor_assignment_id,null,null,l_host_assignment_id),
1489: object_version_number = object_version_number+1

Line 1551: update per_all_assignments_f

1547:
1548: --now write code to handle future dt rows
1549: for l_fut_dt_rows in csr_fut_dt_rows(l_dpl_rec.from_person_id,l_dpl_rec.start_date)
1550: loop
1551: update per_all_assignments_f
1552: set supervisor_id = l_host_person_id,
1553: supervisor_assignment_id =
1554: decode(supervisor_assignment_id,null,null,l_host_assignment_id),
1555: object_version_number = object_version_number+1

Line 2198: from per_all_assignments_f paaf,

2194: l_dpl_rec csr_person_deployment%rowtype;
2195: --
2196: cursor csr_susp_home_asgs(p_person_deployment_id number) is
2197: select paaf.assignment_id, paaf.effective_start_date
2198: from per_all_assignments_f paaf,
2199: per_assignment_status_types past
2200: where paaf.person_id = L_DPL_REC.FROM_PERSON_ID
2201: and paaf.effective_start_date = L_DPL_REC.START_DATE
2202: and paaf.assignment_status_type_id = past.assignment_status_type_id

Line 2208: from per_all_assignments_f paaf

2204: --
2205: cursor csr_overlap_asg_update
2206: (p_assignment_id number, p_old_date date, p_new_date date) is
2207: select 1
2208: from per_all_assignments_f paaf
2209: where paaf.assignment_id = p_assignment_id
2210: and paaf.effective_end_date = p_old_date-1
2211: and paaf.effective_start_date >= p_new_date;
2212: --

Line 2215: from per_all_assignments_f asg,

2211: and paaf.effective_start_date >= p_new_date;
2212: --
2213: cursor csr_host_assignments(p_start_date date) is
2214: select asg.assignment_id,asg.object_version_number,asg.effective_start_date
2215: from per_all_assignments_f asg,
2216: hr_person_deployments pdt,
2217: per_periods_of_service pds
2218: where asg.person_id = pdt.to_person_id
2219: and pdt.person_deployment_id = p_person_deployment_id

Line 2332: update per_all_assignments_f paaf

2328: (l_asg.assignment_id,l_dpl_rec.start_date,l_start_date_in);
2329: fetch csr_overlap_asg_update into l_dummy;
2330: if csr_overlap_asg_update%notfound then
2331: --
2332: update per_all_assignments_f paaf
2333: set paaf.effective_start_date = l_start_date_in
2334: where paaf.assignment_id = l_asg.assignment_id
2335: and paaf.effective_start_date = l_dpl_rec.start_date;
2336: --

Line 2337: update per_all_assignments_f paaf

2333: set paaf.effective_start_date = l_start_date_in
2334: where paaf.assignment_id = l_asg.assignment_id
2335: and paaf.effective_start_date = l_dpl_rec.start_date;
2336: --
2337: update per_all_assignments_f paaf
2338: set paaf.effective_end_date = l_start_date_in-1
2339: where paaf.assignment_id = l_asg.assignment_id
2340: and paaf.effective_end_date = l_dpl_rec.start_date-1;
2341: --

Line 2539: from per_all_assignments_f paaf,

2535: -- start of deployment, but ignore others
2536: --
2537: cursor csr_susp_home_asgs(p_person_id number) is
2538: select paaf.assignment_id, paaf.object_version_number
2539: from per_all_assignments_f paaf,
2540: per_assignment_status_types past
2541: where paaf.person_id = p_person_id
2542: and L_END_DATE_IN between
2543: paaf.effective_start_date and paaf.effective_end_date

Line 2549: from per_all_assignments_f paaf1,

2545: and paaf.assignment_status_type_id = past.assignment_status_type_id
2546: and past.per_system_status = 'SUSP_ASSIGN'
2547: and exists
2548: (select 1
2549: from per_all_assignments_f paaf1,
2550: per_assignment_status_types past1
2551: where paaf1.assignment_id = paaf.assignment_id
2552: and paaf1.effective_start_date = L_DPL_REC.START_DATE
2553: and paaf1.assignment_status_type_id = past1.assignment_status_type_id

Line 2557: from per_all_assignments_f paaf2,

2553: and paaf1.assignment_status_type_id = past1.assignment_status_type_id
2554: and past1.per_system_status = 'SUSP_ASSIGN')
2555: and exists
2556: (select 1
2557: from per_all_assignments_f paaf2,
2558: per_assignment_status_types past2
2559: where paaf2.assignment_id = paaf.assignment_id
2560: and paaf2.effective_end_date = L_DPL_REC.START_DATE-1
2561: and paaf2.assignment_status_type_id = past2.assignment_status_type_id