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.PQH_FR_ASSIGNMENT_API dependencies on PQH_FR_UTILITY

Line 79: If (pqh_fr_utility.is_worker_employee(p_person_id,p_effective_date)) then

75: --
76: l_ovn := p_object_version_number;
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

Line 111: ElsIf (pqh_fr_utility.is_worker_cwk(p_person_id,p_effective_date)) Then

107: and p_effective_date between effective_start_date and effective_end_date
108: and assignment_id = p_assignment_id
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

Line 315: If (pqh_fr_utility.is_worker_employee(p_person_id,p_effective_date)) Then

311: pqh_fr_assignment_chk.chk_position(p_position_id,p_person_id,p_effective_date);
312: pqh_fr_assignment_chk.chk_Identifier(l_identifier);
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

Line 354: ElsIf (pqh_fr_utility.is_worker_cwk(p_person_id,p_effective_date)) Then

350: ,p_comment_id => l_comment_id
351: ,p_other_manager_warning => l_other_manager_warning
352: );
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

Line 418: p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',l_admin_career_id),

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: ) ;

Line 597: If (pqh_fr_utility.is_worker_cwk(p_person_id,p_effective_date)) Then

593: l_normal_hours := l_normal_hours * p_percent_effected/100;
594:
595: If (l_old_primary_affectation='Y' and p_primary_affectation = 'Y') Then
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: (

Line 624: ,p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_id)

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:

Line 653: ElsIf (pqh_fr_utility.is_worker_employee(p_person_id,p_effective_date)) Then

649: ,p_other_manager_warning => l_other_manager_warning2
650: ,p_org_now_no_manager_warning => l_other_manager_warning2
651: ,p_hourly_salaried_warning => l_other_manager_warning2 );
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: (

Line 681: ,p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_id)

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:

Line 724: p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',l_admin_career_id),

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: ) ;

Line 732: If (pqh_fr_utility.is_worker_employee(p_person_id,p_effective_date)) Then

728: ) ;
729:
730: ElsIf (l_old_primary_affectation='N' and p_primary_affectation = 'N') Then
731: --
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

Line 761: ,p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_id)

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

Line 789: ElsIf pqh_fr_utility.is_worker_cwk(p_person_id,p_effective_date) then

785: ,p_effective_end_date => p_effective_end_date
786: ,p_no_managers_warning => l_other_manager_warning
787: ,p_other_manager_warning => l_other_manager_warning2 );
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: (

Line 817: ,p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_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:

Line 855: If pqh_fr_utility.is_worker_employee(p_person_id,p_effective_date) Then

851:
852: --
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

Line 882: ,p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_id)

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:

Line 912: ElsIf pqh_fr_utility.is_worker_cwk(p_person_id,p_effective_date) Then

908: ,p_no_managers_warning => l_other_manager_warning
909: ,p_other_manager_warning => l_other_manager_warning2 );
910:
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: (

Line 939: ,p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_id)

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

Line 985: p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',l_admin_career_id),

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: ) ;

Line 1003: p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',l_admin_career_id),

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: ) ;

Line 1009: If (pqh_fr_utility.is_worker_employee(p_person_id,p_effective_date)) then

1005: p_person_id => p_person_id,
1006: p_supervisor_id => p_supervisor_id
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

Line 1036: ,p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_id)

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:

Line 1065: ElsIf pqh_fr_utility.is_worker_cwk(p_person_id,p_effective_date) Then

1061: ,p_effective_end_date => p_effective_end_date
1062: ,p_no_managers_warning => l_other_manager_warning
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

Line 1091: ,p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_id)

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:

Line 1320: l_datetrack_mode := pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',p_assignment_id);

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

Line 1650: pqh_fr_utility.get_datetrack_mode (p_effective_date,

1646: );
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: );

Line 1766: pqh_fr_utility.get_datetrack_mode

1762: IF p_step_id IS NOT NULL AND placement_record.placement_id IS NOT NULL
1763: -- IF placement_record.placement_id IS NOT NULL
1764: THEN
1765: l_datetrack_mode :=
1766: pqh_fr_utility.get_datetrack_mode
1767: (p_effective_date,
1768: 'PER_SPINAL_POINT_PLACEMENTS_F',
1769: 'PLACEMENT_ID',
1770: placement_record.placement_id

Line 1937: If (pqh_fr_utility.is_worker_employee(l_person_id,p_effective_date)) Then

1933: -- on primary assignment
1934: -- else Position details will be copied to Affecation details
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

Line 1954: ElsIf (pqh_fr_utility.is_worker_cwk(l_person_id,p_effective_date)) Then

1950: ,p_entries_changed_warning => l_entries_changed_warning
1951: ,p_pay_proposal_warning => l_pay_proposal_warning
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

Line 1996: p_datetrack_update_mode => pqh_fr_utility.get_DateTrack_Mode(p_effective_date,'PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_ID',l_admin_career_id),

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:

Line 2099: If (pqh_fr_utility.is_worker_employee(l_person_id,p_effective_date)) Then

2095: l_organization_id, l_job_id, l_position_id;
2096: Close common_info_csr;*/
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

Line 2106: ,p_datetrack_update_mode => pqh_fr_utility.get_datetrack_mode(p_effective_date => p_effective_date

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
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

Line 2116: ElsIf (pqh_fr_utility.is_worker_cwk(l_person_id,p_effective_date)) Then

2112: ,p_effective_start_date => p_effective_start_date
2113: ,p_effective_end_date => p_effective_end_date
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

Line 2123: ,p_datetrack_update_mode => pqh_fr_utility.get_datetrack_mode(p_effective_date => p_effective_date

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
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

Line 2261: If (pqh_fr_utility.is_worker_employee(l_person_id,p_effective_date)) Then

2257: pqh_fr_assignment_chk.chk_situation(l_person_id,p_effective_date);
2258: pqh_fr_assignment_chk.chk_percent_affected(l_percent_affected, l_person_id, p_effective_date);
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

Line 2268: ,p_datetrack_update_mode => pqh_fr_utility.get_datetrack_mode(p_effective_date => p_effective_date

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
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

Line 2278: ElsIf (pqh_fr_utility.is_worker_cwk(l_person_id,p_effective_date)) Then

2274: ,p_effective_start_date => p_effective_start_date
2275: ,p_effective_end_date => p_effective_end_date
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

Line 2285: ,p_datetrack_update_mode => pqh_fr_utility.get_datetrack_mode(p_effective_date => p_effective_date

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
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