DBA Data[Home] [Help]

APPS.PQH_FR_ASSIGNMENT_API dependencies on HR_ASSIGNMENT_API

Line 6: g_package varchar2(33) := ' hr_assignment_api.';

2: /* $Header: pqasgapi.pkb 120.1.12000000.2 2007/08/17 13:17:11 abhaduri noship $ */
3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := ' hr_assignment_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: --
10: -- Procedure update_primary_assg_affectation

Line 81: hr_assignment_api.update_emp_asg_criteria

77:
78: -- If Employee the following routine will be Called
79: If (pqh_fr_utility.is_worker_employee(p_person_id,p_effective_date)) then
80: --
81: hr_assignment_api.update_emp_asg_criteria
82: (
83: p_validate => p_validate
84: ,p_effective_date => p_effective_date
85: ,p_datetrack_update_mode => p_datetrack_update_mode

Line 113: hr_assignment_api.update_cwk_asg_criteria

109: and primary_flag = 'Y';
110:
111: ElsIf (pqh_fr_utility.is_worker_cwk(p_person_id,p_effective_date)) Then
112:
113: hr_assignment_api.update_cwk_asg_criteria
114: (
115: p_validate => p_validate
116: ,p_effective_date => p_effective_date
117: ,p_datetrack_update_mode => p_datetrack_update_mode

Line 317: hr_assignment_api.create_secondary_emp_asg(

313: pqh_fr_assignment_chk.chk_type(p_affectation_type,p_person_id,p_effective_date,p_position_id);
314:
315: If (pqh_fr_utility.is_worker_employee(p_person_id,p_effective_date)) Then
316: --
317: hr_assignment_api.create_secondary_emp_asg(
318: p_validate => p_validate
319: ,p_effective_date => p_effective_date
320: ,p_person_id => p_person_id
321: ,p_organization_id => p_organization_id

Line 357: hr_assignment_api.create_secondary_cwk_asg(

353: --
354: ElsIf (pqh_fr_utility.is_worker_cwk(p_person_id,p_effective_date)) Then
355: --
356:
357: hr_assignment_api.create_secondary_cwk_asg(
358: p_validate => p_validate
359: ,p_effective_date => p_effective_date
360: ,p_business_group_id => l_business_group_id
361: ,p_person_id => p_person_id

Line 600: hr_assignment_api.update_cwk_asg_criteria

596: --
597: If (pqh_fr_utility.is_worker_cwk(p_person_id,p_effective_date)) Then
598: --
599:
600: hr_assignment_api.update_cwk_asg_criteria
601: (
602: p_validate => p_validate
603: ,p_effective_date => p_effective_date
604: ,p_datetrack_update_mode => p_datetrack_update_mode

Line 621: hr_assignment_api.update_cwk_asg(

617: ,p_spp_delete_warning => l_spp_delete_warning
618: ,p_entries_changed_warning => l_entries_changed_warning
619: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
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

Line 656: hr_assignment_api.update_emp_asg_criteria

652:
653: ElsIf (pqh_fr_utility.is_worker_employee(p_person_id,p_effective_date)) Then
654:
655: --
656: hr_assignment_api.update_emp_asg_criteria
657: (
658: p_validate => p_validate
659: ,p_effective_date => p_effective_date
660: ,p_datetrack_update_mode => p_datetrack_update_mode

Line 678: hr_assignment_api.update_emp_asg(

674: ,p_spp_delete_warning => l_spp_delete_warning
675: ,p_entries_changed_warning => l_entries_changed_warning
676: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
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

Line 736: hr_assignment_api.update_emp_asg_criteria

732: If (pqh_fr_utility.is_worker_employee(p_person_id,p_effective_date)) Then
733: --
734: hr_utility.set_location('In condition when an no chages in primary affectation value assignment_id N ', 10);
735:
736: hr_assignment_api.update_emp_asg_criteria
737: (
738: p_validate => p_validate
739: ,p_effective_date => p_effective_date
740: ,p_datetrack_update_mode => p_datetrack_update_mode

Line 758: hr_assignment_api.update_emp_asg(

754: ,p_spp_delete_warning => l_spp_delete_warning
755: ,p_entries_changed_warning => l_entries_changed_warning
756: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
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

Line 792: hr_assignment_api.update_cwk_asg_criteria

788: --
789: ElsIf pqh_fr_utility.is_worker_cwk(p_person_id,p_effective_date) then
790: ---
791:
792: hr_assignment_api.update_cwk_asg_criteria
793: (
794: p_validate => p_validate
795: ,p_effective_date => p_effective_date
796: ,p_datetrack_update_mode => p_datetrack_update_mode

Line 814: hr_assignment_api.update_cwk_asg(

810: ,p_entries_changed_warning => l_entries_changed_warning
811: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
812:
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

Line 857: hr_assignment_api.update_emp_asg_criteria

853: PQH_FR_ASSIGNMENT_CHK.chk_primary_affectation(p_person_id, p_effective_date,l_admin_career_id);
854:
855: If pqh_fr_utility.is_worker_employee(p_person_id,p_effective_date) Then
856: --
857: hr_assignment_api.update_emp_asg_criteria
858: (
859: p_validate => p_validate
860: ,p_effective_date => p_effective_date
861: ,p_datetrack_update_mode => p_datetrack_update_mode

Line 879: hr_assignment_api.update_emp_asg(

875: ,p_spp_delete_warning => l_spp_delete_warning
876: ,p_entries_changed_warning => l_entries_changed_warning
877: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
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

Line 915: hr_assignment_api.update_cwk_asg_criteria

911: --
912: ElsIf pqh_fr_utility.is_worker_cwk(p_person_id,p_effective_date) Then
913: --
914:
915: hr_assignment_api.update_cwk_asg_criteria
916: (
917: p_validate => p_validate
918: ,p_effective_date => p_effective_date
919: ,p_datetrack_update_mode => p_datetrack_update_mode

Line 936: hr_assignment_api.update_cwk_asg(

932: ,p_spp_delete_warning => l_spp_delete_warning
933: ,p_entries_changed_warning => l_entries_changed_warning
934: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
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

Line 1011: hr_assignment_api.update_emp_asg_criteria

1007: ) ;
1008:
1009: If (pqh_fr_utility.is_worker_employee(p_person_id,p_effective_date)) then
1010: --
1011: hr_assignment_api.update_emp_asg_criteria
1012: (
1013: p_validate => p_validate
1014: ,p_effective_date => p_effective_date
1015: ,p_datetrack_update_mode => p_datetrack_update_mode

Line 1033: hr_assignment_api.update_emp_asg(

1029: ,p_spp_delete_warning => l_spp_delete_warning
1030: ,p_entries_changed_warning => l_entries_changed_warning
1031: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
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

Line 1067: hr_assignment_api.update_cwk_asg_criteria

1063: ,p_other_manager_warning => l_other_manager_warning2 );
1064: --
1065: ElsIf pqh_fr_utility.is_worker_cwk(p_person_id,p_effective_date) Then
1066: --
1067: hr_assignment_api.update_cwk_asg_criteria
1068: (
1069: p_validate => p_validate
1070: ,p_effective_date => p_effective_date
1071: ,p_datetrack_update_mode => p_datetrack_update_mode

Line 1088: hr_assignment_api.update_cwk_asg(

1084: ,p_spp_delete_warning => l_spp_delete_warning
1085: ,p_entries_changed_warning => l_entries_changed_warning
1086: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
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

Line 1301: hr_assignment_api.update_emp_asg_criteria

1297: */
1298: --
1299: IF l_asg_type = 'E' THEN
1300: --Employee Assignment
1301: hr_assignment_api.update_emp_asg_criteria
1302: (p_validate => p_validate
1303: ,p_effective_date => p_effective_date
1304: ,p_datetrack_update_mode => p_datetrack_update_mode
1305: ,p_assignment_id => p_assignment_id

Line 1322: hr_assignment_api.update_emp_asg

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
1325: ,p_datetrack_update_mode => l_datetrack_mode
1326: ,p_assignment_id => p_assignment_id

Line 1361: hr_assignment_api.update_emp_asg_criteria

1357: ,NVL(p_reason_for_parttime,-1),NVL(p_comments,-1))
1358: LOOP
1359: --
1360: l_ovn := l_asg_rec.object_version_number;
1361: hr_assignment_api.update_emp_asg_criteria
1362: (p_validate => p_validate
1363: ,p_effective_date => l_asg_rec.effective_start_date
1364: ,p_datetrack_update_mode => 'CORRECTION'
1365: ,p_assignment_id => l_asg_rec.assignment_id

Line 1382: hr_assignment_api.update_emp_asg

1378: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
1379: --
1380: l_datetrack_mode := 'CORRECTION';
1381: --
1382: hr_assignment_api.update_emp_asg
1383: (p_validate => p_validate
1384: ,p_effective_date => l_asg_rec.effective_start_date
1385: ,p_datetrack_update_mode => l_datetrack_mode
1386: ,p_assignment_id => l_asg_rec.assignment_id

Line 1412: hr_assignment_api.update_cwk_asg_criteria

1408: END LOOP;
1409: --
1410: ELSIF l_asg_type = 'C' THEN
1411: --
1412: hr_assignment_api.update_cwk_asg_criteria
1413: (p_validate => p_validate
1414: ,p_effective_date => p_effective_date
1415: ,p_datetrack_update_mode => p_datetrack_update_mode
1416: ,p_assignment_id => p_assignment_id

Line 1430: hr_assignment_api.update_cwk_asg

1426: ,p_spp_delete_warning => l_spp_delete_warning
1427: ,p_entries_changed_warning => l_entries_changed_warning
1428: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
1429: --
1430: hr_assignment_api.update_cwk_asg
1431: (p_validate => p_validate
1432: ,p_effective_date => p_effective_date
1433: ,p_datetrack_update_mode => p_datetrack_update_mode
1434: ,p_assignment_id => p_assignment_id

Line 1624: hr_assignment_api.update_emp_asg_criteria

1620: OR NVL (lr_old_assign_record.grade_id, -1) <> NVL (p_grade_id,
1621: -1)
1622: )
1623: THEN
1624: hr_assignment_api.update_emp_asg_criteria
1625: (p_validate => p_validate,
1626: p_effective_date => p_effective_date,
1627: p_datetrack_update_mode => p_datetrack_update_mode,
1628: p_assignment_id => p_assignment_id,

Line 1666: hr_assignment_api.update_emp_asg

1662: hr_api.g_varchar2) <>
1663: NVL (p_employee_category, hr_api.g_varchar2)
1664: )
1665: THEN
1666: hr_assignment_api.update_emp_asg
1667: (p_validate => p_validate,
1668: p_effective_date => p_effective_date,
1669: p_datetrack_update_mode => l_datetrack_mode,
1670: p_assignment_id => p_assignment_id,

Line 1697: hr_assignment_api.update_cwk_asg

1693: IF (NVL (lr_old_assign_record.employee_category, hr_api.g_varchar2) <>
1694: NVL (p_employee_category, hr_api.g_varchar2)
1695: )
1696: THEN
1697: hr_assignment_api.update_cwk_asg
1698: (p_validate => p_validate,
1699: p_effective_date => p_effective_date,
1700: p_datetrack_update_mode => p_datetrack_update_mode,
1701: p_assignment_id => p_assignment_id,

Line 1718: hr_assignment_api.update_cwk_asg_criteria

1714: p_other_manager_warning => l_other_manager_warning2,
1715: p_org_now_no_manager_warning => l_other_manager_warning2,
1716: p_hourly_salaried_warning => l_other_manager_warning2
1717: );
1718: hr_assignment_api.update_cwk_asg_criteria
1719: (p_validate => p_validate,
1720: p_effective_date => p_effective_date,
1721: p_datetrack_update_mode => p_datetrack_update_mode,
1722: p_assignment_id => p_assignment_id

Line 1939: hr_assignment_api.actual_termination_emp_asg(

1935: --
1936:
1937: If (pqh_fr_utility.is_worker_employee(l_person_id,p_effective_date)) Then
1938: --
1939: hr_assignment_api.actual_termination_emp_asg(
1940: p_validate => p_validate
1941: ,p_assignment_id => p_assignment_id
1942: ,p_actual_termination_date => p_effective_date
1943: ,p_assignment_status_type_id => p_assignment_status_type_id

Line 1956: hr_assignment_api.actual_termination_cwk_asg(

1952: );
1953: --
1954: ElsIf (pqh_fr_utility.is_worker_cwk(l_person_id,p_effective_date)) Then
1955: --
1956: hr_assignment_api.actual_termination_cwk_asg(
1957: p_validate => p_validate
1958: ,p_assignment_id => p_assignment_id
1959: ,p_actual_termination_date => p_effective_date
1960: ,p_assignment_status_type_id => p_assignment_status_type_id

Line 2101: hr_assignment_api.suspend_emp_asg(

2097:
2098:
2099: If (pqh_fr_utility.is_worker_employee(l_person_id,p_effective_date)) Then
2100: --
2101: hr_assignment_api.suspend_emp_asg(
2102: p_validate => p_validate
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

Line 2118: hr_assignment_api.suspend_cwk_asg(

2114: );
2115: --
2116: ElsIf (pqh_fr_utility.is_worker_cwk(l_person_id,p_effective_date)) Then
2117: --
2118: hr_assignment_api.suspend_cwk_asg(
2119: p_validate => p_validate
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

Line 2263: hr_assignment_api.activate_emp_asg(

2259:
2260:
2261: If (pqh_fr_utility.is_worker_employee(l_person_id,p_effective_date)) Then
2262: --
2263: hr_assignment_api.activate_emp_asg(
2264: p_validate => p_validate
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

Line 2280: hr_assignment_api.activate_cwk_asg(

2276: );
2277: --
2278: ElsIf (pqh_fr_utility.is_worker_cwk(l_person_id,p_effective_date)) Then
2279: --
2280: hr_assignment_api.activate_cwk_asg(
2281: p_validate => p_validate
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