1 PACKAGE psp_enc_assignment_changes AUTHID CURRENT_USER AS
2 /* $Header: PSPENETS.pls 120.4.12020000.3 2012/07/04 09:08:12 amnaraya ship $ */
3
4 PROCEDURE element_entries_inserts
5 (p_assignment_id IN NUMBER,
6 p_element_link_id IN NUMBER,
7 p_effective_date IN DATE); -- added for Bug 3452760
8
9
10 PROCEDURE element_entries_updates
11 (p_assignment_id_o IN NUMBER,
12 p_element_link_id_o IN NUMBER,
13 p_effective_date IN DATE); -- added for Bug 3452760
14
15
16 PROCEDURE element_entries_deletes
17 (p_assignment_id_o IN NUMBER,
18 p_element_link_id_o IN NUMBER,
19 p_effective_date IN DATE); -- added for Bug 3452760
20
21 -- Introduced the procedure Assignment_updates , Assignment_deletes for Bug 3075435
22 PROCEDURE assignment_updates
23 (p_old_payroll_id IN NUMBER,
24 p_new_payroll_id IN NUMBER,
25 p_old_organization_id IN NUMBER,
26 p_new_organization_id IN NUMBER,
27 p_old_asg_status_type_id IN NUMBER,
28 p_new_asg_status_type_id IN NUMBER,
29 p_new_assignment_id IN NUMBER,
30 p_new_period_of_service_id IN NUMBER,
31 p_new_effective_end_date IN DATE,
32 p_new_primary_flag IN VARCHAR2, ---- added 2 params for 3184075
33 p_new_person_id IN NUMBER,
34 p_old_grade_id IN NUMBER, -- for bug 4719330
35 p_new_grade_id IN NUMBER); -- for bug 4719330
36
37 PROCEDURE assignment_deletes
38 (p_new_assignment_id IN NUMBER,
39 p_old_assignment_id IN NUMBER,
40 p_old_payroll_id IN NUMBER,
41 p_old_effective_start_date IN DATE,
42 p_old_person_id IN NUMBER,
43 p_old_effective_end_date IN DATE -- Bug 12969737
44 );
45
46 /***** Added for bug -- for bug 4719330 *****************/
47
48 Procedure Asig_grade_point_update
49 (p_assignment_id IN NUMBER,
50 p_new_effective_start_date IN DATE,
51 p_new_effective_end_date IN DATE ,
52 p_old_effective_end_date IN DATE);
53 /****** End of Addition for bug -- for bug 4719330 *****************/
54
55
56
57
58 END psp_enc_assignment_changes;
[Home] [Help]