[Home] [Help]
62: -- Cursor to get the future assignment dates.
63:
64: cursor csr_fut_primary_asg is
65: Select effective_start_date from
66: per_all_assignments_f
67: where primary_flag = 'Y'
68: and person_id = p_person_id
69: and assignment_id = p_assignment_id
70: and effective_start_date > p_effective_date;
99: ,p_spp_delete_warning => l_spp_delete_warning
100: ,p_entries_changed_warning => l_entries_changed_warning
101: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
102: --
103: update per_all_assignments_f
104: set supervisor_id = p_supervisor_id
105: where
106: person_id = p_person_id
107: and p_effective_date between effective_start_date and effective_end_date
130: ,p_spp_delete_warning => l_spp_delete_warning
131: ,p_entries_changed_warning => l_entries_changed_warning
132: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
133:
134: update per_all_assignments_f
135: set supervisor_id = p_supervisor_id
136: where
137: person_id = p_person_id
138: and p_effective_date between effective_start_date and effective_end_date
147: loop
148: fetch csr_fut_primary_asg into l_fut_pri_start_date;
149: exit when csr_fut_primary_asg%notfound;
150:
151: update per_all_assignments_f
152: set position_id = p_position_id,
153: job_id = p_job_id,
154: organization_id = p_organization_id,
155: supervisor_id = p_supervisor_id
235:
236: cursor common_info_csr is
237: Select people_group_id, establishment_id , scl.segment10 FrEmpCategory,
238: assignment_id,object_version_number,normal_hours,frequency,business_group_id
239: from per_all_assignments_f asg, hr_soft_coding_keyflex scl
240: where person_id = p_person_id
241: and scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
242: and p_effective_date between effective_start_date and effective_end_date
243: and primary_flag ='Y';
414: p_primary_affectation => p_primary_affectation,
415: p_organization_id => p_organization_id,
416: p_job_id => p_job_id,
417: p_position_id => p_position_id,
418: p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',l_admin_career_id),
419: p_object_version_number => l_p_asg_ovn,
420: p_person_id => p_person_id,
421: p_supervisor_id => p_supervisor_id
422: ) ;
497:
498: cursor common_info_csr is
499: Select people_group_id, establishment_id , scl.segment10 FrEmpCategory,assignment_id
500: ,object_version_number,normal_hours
501: from per_all_assignments_f asg, hr_soft_coding_keyflex scl
502: where person_id = p_person_id
503: and scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
504: and p_effective_date between effective_start_date and effective_end_date
505: and primary_flag ='Y';
506: -- Note : CAGR_GRADE_DEF_ID is not used, assuming that will not be used by the customer, as the functionality is not delivered.
507:
508: Cursor earlier_affect_det_csr IS
509: Select segment27 PrimayAffectation
510: from per_all_assignments_f asg, hr_soft_coding_keyflex scl
511: where assignment_id = p_assignment_id
512: and scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
513: and p_effective_date between effective_start_date and effective_end_date;
514:
515:
516:
517: l_j_id number;
518: l_p_id number;
519: l_normal_hours per_all_assignments_f.normal_hours%type;
520: Begin
521:
522: hr_utility.set_location(' Entering:' || l_proc,10);
523: --
620:
621: hr_assignment_api.update_cwk_asg(
622: p_validate => p_validate
623: ,p_effective_date => p_effective_date
624: ,p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_id)
625: ,p_assignment_id => p_assignment_id
626: ,p_object_version_number => p_object_version_number
627: ,p_normal_hours => l_normal_hours
628:
677:
678: hr_assignment_api.update_emp_asg(
679: p_validate => p_validate
680: ,p_effective_date => p_effective_date
681: ,p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_id)
682: ,p_assignment_id => p_assignment_id
683: ,p_object_version_number => p_object_version_number
684: ,p_normal_hours => l_normal_hours
685:
720: p_primary_affectation => p_primary_affectation,
721: p_organization_id => p_organization_id,
722: p_job_id => p_job_id,
723: p_position_id => p_position_id,
724: p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',l_admin_career_id),
725: p_object_version_number => l_p_asg_ovn,
726: p_person_id => p_person_id,
727: p_supervisor_id => p_supervisor_id
728: ) ;
757:
758: hr_assignment_api.update_emp_asg(
759: p_validate => p_validate
760: ,p_effective_date => p_effective_date
761: ,p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_id)
762: ,p_assignment_id => p_assignment_id
763: ,p_object_version_number => p_object_version_number
764: ,p_normal_hours => l_normal_hours
765: ,p_supervisor_id => p_supervisor_id
813:
814: hr_assignment_api.update_cwk_asg(
815: p_validate => p_validate
816: ,p_effective_date => p_effective_date
817: ,p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_id)
818: ,p_assignment_id => p_assignment_id
819: ,p_object_version_number => p_object_version_number
820: ,p_normal_hours => l_normal_hours
821:
878:
879: hr_assignment_api.update_emp_asg(
880: p_validate => p_validate
881: ,p_effective_date => p_effective_date
882: ,p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_id)
883: ,p_assignment_id => p_assignment_id
884: ,p_object_version_number => p_object_version_number
885: ,p_normal_hours => l_normal_hours
886:
935:
936: hr_assignment_api.update_cwk_asg(
937: p_validate => p_validate
938: ,p_effective_date => p_effective_date
939: ,p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_id)
940: ,p_assignment_id => p_assignment_id
941: ,p_object_version_number => p_object_version_number
942: ,p_supervisor_id => p_supervisor_id
943: ,p_assignment_number => p_assignment_number
981: p_primary_affectation => p_primary_affectation,
982: p_organization_id => p_organization_id,
983: p_job_id => p_job_id,
984: p_position_id => p_position_id,
985: p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',l_admin_career_id),
986: p_object_version_number => l_p_asg_ovn,
987: p_person_id => p_person_id,
988: p_supervisor_id => p_supervisor_id
989: ) ;
999: p_primary_affectation => l_old_primary_affectation,
1000: p_organization_id => p_organization_id,
1001: p_job_id => p_job_id,
1002: p_position_id => null,
1003: p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',l_admin_career_id),
1004: p_object_version_number => l_p_asg_ovn,
1005: p_person_id => p_person_id,
1006: p_supervisor_id => p_supervisor_id
1007: ) ;
1032:
1033: hr_assignment_api.update_emp_asg(
1034: p_validate => p_validate
1035: ,p_effective_date => p_effective_date
1036: ,p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_id)
1037: ,p_assignment_id => p_assignment_id
1038: ,p_object_version_number => p_object_version_number
1039: ,p_normal_hours => l_normal_hours
1040:
1087:
1088: hr_assignment_api.update_cwk_asg(
1089: p_validate => p_validate
1090: ,p_effective_date => p_effective_date
1091: ,p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_id)
1092: ,p_assignment_id => p_assignment_id
1093: ,p_object_version_number => p_object_version_number
1094: ,p_normal_hours => l_normal_hours
1095:
1168: --
1169: --Cursor to fetch Current Assignment
1170: CURSOR csr_asg_information IS
1171: SELECT asg.assignment_type, ast.per_system_status
1172: FROM per_all_assignments_f asg,
1173: per_assignment_status_types ast
1174: WHERE asg.assignment_id = p_assignment_id
1175: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
1176: AND asg.assignment_status_type_id = ast.assignment_status_type_id;
1195: asg.establishment_id,
1196: scl.segment9 "Working Hours Share",
1197: scl.segment19 "Reason For Part",
1198: scl.segment20 "Comments"
1199: FROM per_all_assignments_f asg,
1200: hr_soft_coding_keyflex scl
1201: WHERE asg.assignment_id = p_assignment_id
1202: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id (+)
1203: AND asg.effective_start_date >= p_effective_end_date
1212: CURSOR csr_normal_working_hour IS
1213: SELECT normal_hours hours, normal_hours_frequency frequency
1214: FROM pqh_corps_definitions
1215: WHERE ben_pgm_id = (SELECT grade_ladder_pgm_id
1216: FROM per_all_assignments_f
1217: WHERE assignment_id = p_assignment_id
1218: AND p_effective_date BETWEEN effective_start_date AND effective_end_date)
1219: UNION
1220: SELECT fnd_number.canonical_to_number (org_information4) hours, 'M' frequency
1316: ,p_spp_delete_warning => l_spp_delete_warning
1317: ,p_entries_changed_warning => l_entries_changed_warning
1318: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
1319: --
1320: l_datetrack_mode := pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_id);
1321: --
1322: hr_assignment_api.update_emp_asg
1323: (p_validate => p_validate
1324: ,p_effective_date => p_effective_date
1520: --
1521: CURSOR csr_asg_information
1522: IS
1523: SELECT assignment_type
1524: FROM per_all_assignments_f
1525: WHERE assignment_id = p_assignment_id
1526: AND p_effective_date BETWEEN effective_start_date
1527: AND effective_end_date;
1528:
1539: CURSOR csr_old_assign_record
1540: IS
1541: SELECT grade_ladder_pgm_id, grade_id, normal_hours, frequency,
1542: segment10 employee_category
1543: FROM per_all_assignments_f, hr_soft_coding_keyflex
1544: WHERE assignment_id = p_assignment_id
1545: AND p_effective_date BETWEEN effective_start_date
1546: AND effective_end_date
1547: AND per_all_assignments_f.soft_coding_keyflex_id = hr_soft_coding_keyflex.soft_coding_keyflex_id(+);
1543: FROM per_all_assignments_f, hr_soft_coding_keyflex
1544: WHERE assignment_id = p_assignment_id
1545: AND p_effective_date BETWEEN effective_start_date
1546: AND effective_end_date
1547: AND per_all_assignments_f.soft_coding_keyflex_id = hr_soft_coding_keyflex.soft_coding_keyflex_id(+);
1548:
1549: --
1550: CURSOR csr_work_hrs_share IS
1551: SELECT nvl(scl.segment9,100) work_hour_share,
1551: SELECT nvl(scl.segment9,100) work_hour_share,
1552: nvl(employment_category,'CF') employment_category,
1553: normal_hours,
1554: frequency
1555: FROM per_all_assignments_f asg,
1556: hr_soft_coding_keyflex scl
1557: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1558: AND assignment_id = p_assignment_id
1559: AND p_effective_date between effective_start_date and effective_end_date
1647: END IF;
1648:
1649: l_datetrack_mode :=
1650: pqh_fr_utility.get_datetrack_mode (p_effective_date,
1651: 'PER_ALL_ASSIGNMENTS_F',
1652: 'ASSIGNMENT_ID',
1653: p_assignment_id
1654: );
1655:
1870:
1871:
1872: cursor info_admin_career_id is
1873: Select person_id, scl.segment26 admin_career_id, object_version_number
1874: from per_all_assignments_f asg, hr_soft_coding_keyflex scl
1875: where assignment_id = p_assignment_id
1876: and scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1877: and p_effective_date between effective_start_date and effective_end_date;
1878:
1879: cursor common_info_csr (p_person_id in number)is
1880: Select people_group_id, establishment_id , scl.segment10 FrEmpCategory,
1881: assignment_id,object_version_number,normal_hours,frequency,business_group_id,
1882: organization_id, job_id, position_id
1883: from per_all_assignments_f asg, hr_soft_coding_keyflex scl
1884: where person_id = p_person_id
1885: and scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1886: and p_effective_date between effective_start_date and effective_end_date
1887: and primary_flag ='Y';
1992: p_primary_affectation => p_primary_affectation,
1993: p_organization_id => l_organization_id,
1994: p_job_id => l_job_id,
1995: p_position_id => NULL,
1996: p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',l_admin_career_id),
1997: p_object_version_number => l_p_asg_ovn,
1998: p_person_id => l_person_id
1999: ) ;
2000:
2049:
2050:
2051: cursor info_admin_career_id is
2052: Select person_id, scl.segment26 admin_career_id, object_version_number
2053: from per_all_assignments_f asg, hr_soft_coding_keyflex scl
2054: where assignment_id = p_assignment_id
2055: and scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
2056: and p_effective_date between effective_start_date and effective_end_date;
2057:
2103: ,p_assignment_id => p_assignment_id
2104: ,p_effective_date => p_effective_date
2105: ,p_assignment_status_type_id => p_assignment_status_type_id
2106: ,p_datetrack_update_mode => pqh_fr_utility.get_datetrack_mode(p_effective_date => p_effective_date
2107: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
2108: ,p_base_key_column => 'ASSIGNMENT_ID'
2109: ,p_base_key_value => p_assignment_id)
2110: -- Following are Out Parameters
2111: ,p_object_version_number => l_obj_ver_no
2120: ,p_assignment_id => p_assignment_id
2121: ,p_effective_date => p_effective_date
2122: ,p_assignment_status_type_id => p_assignment_status_type_id
2123: ,p_datetrack_update_mode => pqh_fr_utility.get_datetrack_mode(p_effective_date => p_effective_date
2124: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
2125: ,p_base_key_column => 'ASSIGNMENT_ID'
2126: ,p_base_key_value => p_assignment_id)
2127: -- Following are Out Parameters
2128: ,p_object_version_number => l_obj_ver_no
2196: -- to the secondary assingment.
2197:
2198: cursor info_admin_career_id is
2199: Select person_id, scl.segment26 admin_career_id, object_version_number
2200: from per_all_assignments_f asg, hr_soft_coding_keyflex scl
2201: where assignment_id = p_assignment_id
2202: and scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
2203: and p_effective_date between effective_start_date and effective_end_date;
2204:
2204:
2205:
2206: Cursor assign_percent_affected is
2207: Select nvl(scl.segment25,0) Percenteffected
2208: From per_all_assignments_f assign,
2209: hr_soft_coding_keyflex scl
2210: Where person_id = l_person_id
2211: And assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2212: And assign.primary_flag = 'N'
2265: ,p_assignment_id => p_assignment_id
2266: ,p_effective_date => p_effective_date
2267: ,p_assignment_status_type_id => p_assignment_status_type_id
2268: ,p_datetrack_update_mode => pqh_fr_utility.get_datetrack_mode(p_effective_date => p_effective_date
2269: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
2270: ,p_base_key_column => 'ASSIGNMENT_ID'
2271: ,p_base_key_value => p_assignment_id)
2272: -- Following are Out Parameters
2273: ,p_object_version_number => l_obj_ver_no
2282: ,p_assignment_id => p_assignment_id
2283: ,p_effective_date => p_effective_date
2284: ,p_assignment_status_type_id => p_assignment_status_type_id
2285: ,p_datetrack_update_mode => pqh_fr_utility.get_datetrack_mode(p_effective_date => p_effective_date
2286: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
2287: ,p_base_key_column => 'ASSIGNMENT_ID'
2288: ,p_base_key_value => p_assignment_id)
2289: -- Following are Out Parameters
2290: ,p_object_version_number => l_obj_ver_no