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 895: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

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

Line 896: l_comment_id per_all_assignments_f.comment_id%TYPE;

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

Line 899: l_host_asg_number per_all_assignments_f.assignment_number%type;

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

Line 940: l_created_by per_all_assignments_f.created_by%TYPE;

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

Line 941: l_creation_date per_all_assignments_f.creation_date%TYPE;

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

Line 942: l_last_update_date per_all_assignments_f.last_update_date%TYPE;

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

Line 943: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;

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

Line 944: l_last_update_login per_all_assignments_f.last_update_login%TYPE;

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

Line 1008: from per_all_assignments_f paaf

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

Line 1015: from per_all_assignments_f paaf,

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

Line 1072: from per_all_assignments_f asg

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

Line 1078: from per_all_assignments_f asg

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

Line 1085: from per_all_assignments_f asg

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

Line 1304: update per_all_assignments_f

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

Line 1460: update per_all_assignments_f

1456:
1457:
1458: if l_datetrack_update_mode = 'CORRECTION' then
1459:
1460: update per_all_assignments_f
1461: set supervisor_id = l_host_person_id,
1462: supervisor_assignment_id =
1463: decode(supervisor_assignment_id,null,null,l_host_assignment_id),
1464: object_version_number = object_version_number+1

Line 1526: update per_all_assignments_f

1522:
1523: --now write code to handle future dt rows
1524: for l_fut_dt_rows in csr_fut_dt_rows(l_dpl_rec.from_person_id,l_dpl_rec.start_date)
1525: loop
1526: update per_all_assignments_f
1527: set supervisor_id = l_host_person_id,
1528: supervisor_assignment_id =
1529: decode(supervisor_assignment_id,null,null,l_host_assignment_id),
1530: object_version_number = object_version_number+1

Line 2173: from per_all_assignments_f paaf,

2169: l_dpl_rec csr_person_deployment%rowtype;
2170: --
2171: cursor csr_susp_home_asgs(p_person_deployment_id number) is
2172: select paaf.assignment_id, paaf.effective_start_date
2173: from per_all_assignments_f paaf,
2174: per_assignment_status_types past
2175: where paaf.person_id = L_DPL_REC.FROM_PERSON_ID
2176: and paaf.effective_start_date = L_DPL_REC.START_DATE
2177: and paaf.assignment_status_type_id = past.assignment_status_type_id

Line 2183: from per_all_assignments_f paaf

2179: --
2180: cursor csr_overlap_asg_update
2181: (p_assignment_id number, p_old_date date, p_new_date date) is
2182: select 1
2183: from per_all_assignments_f paaf
2184: where paaf.assignment_id = p_assignment_id
2185: and paaf.effective_end_date = p_old_date-1
2186: and paaf.effective_start_date >= p_new_date;
2187: --

Line 2190: from per_all_assignments_f asg,

2186: and paaf.effective_start_date >= p_new_date;
2187: --
2188: cursor csr_host_assignments(p_start_date date) is
2189: select asg.assignment_id,asg.object_version_number,asg.effective_start_date
2190: from per_all_assignments_f asg,
2191: hr_person_deployments pdt,
2192: per_periods_of_service pds
2193: where asg.person_id = pdt.to_person_id
2194: and pdt.person_deployment_id = p_person_deployment_id

Line 2307: update per_all_assignments_f paaf

2303: (l_asg.assignment_id,l_dpl_rec.start_date,l_start_date_in);
2304: fetch csr_overlap_asg_update into l_dummy;
2305: if csr_overlap_asg_update%notfound then
2306: --
2307: update per_all_assignments_f paaf
2308: set paaf.effective_start_date = l_start_date_in
2309: where paaf.assignment_id = l_asg.assignment_id
2310: and paaf.effective_start_date = l_dpl_rec.start_date;
2311: --

Line 2312: update per_all_assignments_f paaf

2308: set paaf.effective_start_date = l_start_date_in
2309: where paaf.assignment_id = l_asg.assignment_id
2310: and paaf.effective_start_date = l_dpl_rec.start_date;
2311: --
2312: update per_all_assignments_f paaf
2313: set paaf.effective_end_date = l_start_date_in-1
2314: where paaf.assignment_id = l_asg.assignment_id
2315: and paaf.effective_end_date = l_dpl_rec.start_date-1;
2316: --

Line 2514: from per_all_assignments_f paaf,

2510: -- start of deployment, but ignore others
2511: --
2512: cursor csr_susp_home_asgs(p_person_id number) is
2513: select paaf.assignment_id, paaf.object_version_number
2514: from per_all_assignments_f paaf,
2515: per_assignment_status_types past
2516: where paaf.person_id = p_person_id
2517: and L_END_DATE_IN between
2518: paaf.effective_start_date and paaf.effective_end_date

Line 2524: from per_all_assignments_f paaf1,

2520: and paaf.assignment_status_type_id = past.assignment_status_type_id
2521: and past.per_system_status = 'SUSP_ASSIGN'
2522: and exists
2523: (select 1
2524: from per_all_assignments_f paaf1,
2525: per_assignment_status_types past1
2526: where paaf1.assignment_id = paaf.assignment_id
2527: and paaf1.effective_start_date = L_DPL_REC.START_DATE
2528: and paaf1.assignment_status_type_id = past1.assignment_status_type_id

Line 2532: from per_all_assignments_f paaf2,

2528: and paaf1.assignment_status_type_id = past1.assignment_status_type_id
2529: and past1.per_system_status = 'SUSP_ASSIGN')
2530: and exists
2531: (select 1
2532: from per_all_assignments_f paaf2,
2533: per_assignment_status_types past2
2534: where paaf2.assignment_id = paaf.assignment_id
2535: and paaf2.effective_end_date = L_DPL_REC.START_DATE-1
2536: and paaf2.assignment_status_type_id = past2.assignment_status_type_id