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 2703: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE

2699: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
2700: ,p_npw_number IN per_all_people_f.npw_number%TYPE
2701: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
2702: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
2703: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2704: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2705: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
2706: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
2707: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE

Line 3396: l_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE;

3392: ,p_gsp_post_process_warning OUT NOCOPY VARCHAR2
3393: ) IS
3394: --
3395: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
3396: l_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE;
3397: l_employee_number per_all_people_f.employee_number%TYPE;
3398: l_npw_number per_all_people_f.npw_number%TYPE := p_npw_number;
3399: l_per_effective_start_date DATE;
3400: l_per_effective_end_date DATE;

Line 7008: ,p_placement_date_start per_periods_of_placement.date_start%TYPE

7004: ,p_per_validation_start_date OUT NOCOPY DATE
7005: ,p_per_validation_end_date OUT NOCOPY DATE
7006: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
7007: --CWK
7008: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
7009: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7010: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
7011: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
7012: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE

Line 7009: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE

7005: ,p_per_validation_end_date OUT NOCOPY DATE
7006: ,p_per_object_version_number per_all_people_f.object_version_number%TYPE
7007: --CWK
7008: ,p_placement_date_start per_periods_of_placement.date_start%TYPE
7009: ,p_pdp_object_version_number per_periods_of_placement.object_version_number%TYPE
7010: ,p_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE
7011: ,p_rate_effective_start_date pay_grade_rules_f.effective_start_date%TYPE
7012: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
7013: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE

Line 7067: l_period_of_placement_id per_periods_of_placement.period_of_placement_id%TYPE;

7063: l_proc VARCHAR2(72) := g_package||'lock_maintain_data';
7064: l_per_datetrack_update_mode VARCHAR2(30);
7065: l_asg_datetrack_update_mode VARCHAR2(30);
7066: l_rate_datetrack_update_mode VARCHAR2(30);
7067: l_period_of_placement_id per_periods_of_placement.period_of_placement_id%TYPE;
7068: l_rate_validation_start_date DATE;
7069: l_rate_validation_end_date DATE;
7070: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
7071: --

Line 7076: FROM per_periods_of_placement

7072: CURSOR csr_pdp_rec
7073: (p_person_id NUMBER
7074: ,p_placement_date_start DATE) IS
7075: SELECT period_of_placement_id
7076: FROM per_periods_of_placement
7077: WHERE person_id = p_person_id
7078: AND date_start = p_placement_date_start;
7079:
7080: CURSOR csr_pds_rec