1 PACKAGE PERWSEPY_PKG AUTHID CURRENT_USER AS
2 /* $Header: pepyppkg.pkh 120.1.12000000.1 2007/01/22 02:24:03 appldev noship $ */
3
4 PROCEDURE CHECK_LENGTH(p_amount IN OUT NOCOPY NUMBER
5 ,p_uom IN VARCHAR2
6 ,p_currcode IN VARCHAR2);
7
8 PROCEDURE CALCULATE_PERCENTS_P (p_change_amount IN OUT NOCOPY NUMBER,
9 p_change_percent IN OUT NOCOPY NUMBER,
10 p_old_amount IN NUMBER,
11 p_new_amount IN OUT NOCOPY NUMBER,
12 p_multi_components IN OUT NOCOPY VARCHAR2,
13 p_components VARCHAR2);
14
15 PROCEDURE COMPONENT_AMOUNT_P (p_change_amount IN OUT NOCOPY NUMBER
16 ,p_old_amount IN NUMBER
17 ,p_uom IN VARCHAR2
18 ,p_currcode IN VARCHAR2
19 ,p_change_percent OUT NOCOPY NUMBER);
20
21 PROCEDURE COMPONENT_PERCENT_P (p_change_percent IN OUT NOCOPY NUMBER
22 ,p_old_amount IN NUMBER
23 ,p_change_amount OUT NOCOPY NUMBER
24 ,p_status IN VARCHAR2
25 ,p_uom IN VARCHAR2
26 ,p_currcode IN VARCHAR2);
27
28
29 ---------------------------------------------------------------------------------
30 /* Following procedure has been copied from per_pyp_bus.
31 Some of the restrictions has been commented in per_pyp_bus as enhancement in FPKRUP.
32 This need to be restriced for the old Salary Form.
33 Change made by abhshriv
34 */
35
36 procedure chk_assignment_id_change_date
37 (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
38 ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
39 ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
40 ,p_change_date in per_pay_proposals.change_date%TYPE
41 ,p_payroll_warning out nocopy boolean
42 ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
43 );
44
45 procedure chk_del_pay_proposal
46 (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
47 ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
48 ,p_salary_warning out nocopy boolean
49 );
50
51 procedure chk_delete_component
52 (p_component_id
53 in per_pay_proposal_components.component_id%TYPE
54 );
55
56 procedure chk_pay_basis_change_date
57 (p_assignment_id in per_pay_proposals.assignment_id%TYPE
58 ,p_change_date in per_pay_proposals.change_date%TYPE
59 );
60 ----------------------------------------------------------------------------------
61
62
63 PROCEDURE PROPOSED_SALARY_P (p_pay_proposal_id IN NUMBER
64 ,p_business_group_id IN NUMBER
65 ,p_assignment_id IN NUMBER
66 ,p_change_date IN DATE
67 ,p_proposed_salary IN OUT NOCOPY NUMBER
68 ,p_object_version_number IN NUMBER
69 ,p_old_amount IN NUMBER
70 ,p_uom IN VARCHAR2
71 ,p_currcode IN VARCHAR2
72 ,p_components IN OUT NOCOPY VARCHAR2
73 ,p_change_amount OUT NOCOPY NUMBER
74 ,p_change_percent OUT NOCOPY NUMBER);
75
76 PROCEDURE CHANGE_AMOUNT_P (p_change_amount IN OUT NOCOPY NUMBER
77 ,p_old_amount IN NUMBER
78 ,p_components IN OUT NOCOPY VARCHAR2
79 ,p_uom IN VARCHAR2
80 ,p_currcode IN VARCHAR2
81 ,p_new_amount OUT NOCOPY NUMBER
82 ,p_change_percent OUT NOCOPY NUMBER);
83
84 PROCEDURE CHANGE_PERCENT_P (p_change_percent IN OUT NOCOPY NUMBER
85 ,p_old_amount IN NUMBER
86 ,p_components IN OUT NOCOPY VARCHAR2
87 ,p_uom IN VARCHAR2
88 ,p_currcode IN VARCHAR2
89 ,p_new_amount OUT NOCOPY NUMBER
90 ,p_change_amount OUT NOCOPY NUMBER);
91
92 PROCEDURE CHANGE_DATE_P (p_pay_proposal_id IN NUMBER
93 ,p_business_group_id IN NUMBER
94 ,p_assignment_id IN NUMBER
95 ,p_change_date IN DATE
96 ,p_next_sal_review_date IN OUT NOCOPY DATE
97 ,p_object_version_number IN NUMBER
98 ,p_payroll_warning OUT NOCOPY BOOLEAN
99 ,p_inv_next_sal_date_warning OUT NOCOPY BOOLEAN);
100
101 PROCEDURE NEXT_SAL_REVIEW_DATE_P(p_pay_proposal_id NUMBER
102 ,p_business_group_id NUMBER
103 ,p_assignment_id NUMBER
104 ,p_change_date DATE
105 ,p_next_sal_review_date IN OUT NOCOPY DATE
106 ,p_object_version_number NUMBER
107 ,p_inv_next_sal_date_warning OUT NOCOPY BOOLEAN);
108
109 PROCEDURE APPROVED_P(p_pay_proposal_id IN NUMBER
110 ,p_business_group_id IN NUMBER
111 ,p_assignment_id IN NUMBER
112 ,p_change_date IN DATE
113 ,p_proposed_salary IN NUMBER
114 ,p_object_version_number IN NUMBER
115 ,p_approved IN VARCHAR2);
116
117 PROCEDURE COMPONENT_APPROVED_P(p_component_id IN NUMBER
118 ,p_approved IN VARCHAR2
119 ,p_component_reason IN VARCHAR2
120 ,p_change_amount IN NUMBER
121 ,p_change_percentage IN NUMBER
122 ,p_object_version_number IN NUMBER);
123
124 PROCEDURE check_for_unaproved(p_assignment_id NUMBER
125 ,l_error OUT NOCOPY BOOLEAN);
126
127 PROCEDURE CHECK_START_END_ASS_DATES(p_date IN DATE
128 ,p_assignment_id IN NUMBER
129 ,p_start_ass_date_err OUT NOCOPY BOOLEAN
130 ,p_end_ass_date_err OUT NOCOPY BOOLEAN);
131
132
133 END PERWSEPY_PKG;