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.PER_QH_MAINTAIN_UPDATE dependencies on PER_PERIODS_OF_PLACEMENT

Line 35: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE

31: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
32: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
33: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925
34: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
35: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
36: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
37: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
38: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
39: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE

Line 731: l_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE;

727: ) IS
728: --
729: l_person_id NUMBER;
730: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
731: l_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE;
732: l_employee_number per_all_people_f.employee_number%TYPE;
733: l_applicant_number per_all_people_f.applicant_number%TYPE;
734: l_npw_number per_all_people_f.npw_number%TYPE;
735: l_per_effective_start_date DATE;

Line 2737: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE

2733: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
2734: ,p_npw_number IN per_all_people_f.npw_number%TYPE
2735: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
2736: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
2737: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2738: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2739: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
2740: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
2741: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE

Line 3430: l_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE;

3426: ,p_gsp_post_process_warning OUT NOCOPY VARCHAR2
3427: ) IS
3428: --
3429: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
3430: l_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE;
3431: l_employee_number per_all_people_f.employee_number%TYPE;
3432: l_npw_number per_all_people_f.npw_number%TYPE := p_npw_number;
3433: l_per_effective_start_date DATE;
3434: l_per_effective_end_date DATE;

Line 7048: ,p_placement_date_start per_periods_of_placement.date_start%TYPE

7044: ,p_per_validation_start_date OUT NOCOPY DATE
7045: ,p_per_validation_end_date OUT NOCOPY DATE
7046: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
7047: --CWK
7048: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
7049: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7050: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
7051: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
7052: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE

Line 7049: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE

7045: ,p_per_validation_end_date OUT NOCOPY DATE
7046: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
7047: --CWK
7048: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
7049: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7050: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
7051: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
7052: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
7053: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE

Line 7107: l_period_of_placement_id per_periods_of_placement.period_of_placement_id%TYPE;

7103: l_proc VARCHAR2(72) := g_package||'lock_maintain_data';
7104: l_per_datetrack_update_mode VARCHAR2(30);
7105: l_asg_datetrack_update_mode VARCHAR2(30);
7106: l_rate_datetrack_update_mode VARCHAR2(30);
7107: l_period_of_placement_id per_periods_of_placement.period_of_placement_id%TYPE;
7108: l_rate_validation_start_date DATE;
7109: l_rate_validation_end_date DATE;
7110: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
7111: --

Line 7116: FROM per_periods_of_placement

7112: CURSOR csr_pdp_rec
7113: (p_person_id NUMBER
7114: ,p_placement_date_start DATE) IS
7115: SELECT period_of_placement_id
7116: FROM per_periods_of_placement
7117: WHERE person_id = p_person_id
7118: AND date_start = p_placement_date_start;
7119:
7120: CURSOR csr_pds_rec