1 PACKAGE psp_enc_assignment_changes AS
2 /* $Header: PSPENETS.pls 120.2.12010000.3 2008/08/05 10:11:14 ubhat 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
44 /***** Added for bug -- for bug 4719330 *****************/
45
46 Procedure Asig_grade_point_update
47 (p_assignment_id IN NUMBER,
48 p_new_effective_start_date IN DATE,
49 p_new_effective_end_date IN DATE ,
50 p_old_effective_end_date IN DATE);
51 /****** End of Addition for bug -- for bug 4719330 *****************/
52
53
54
55
56 END psp_enc_assignment_changes;