1 PACKAGE PAY_GB_PAYROLL_ACTIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: pypra04t.pkh 115.8 2002/12/11 11:14:54 ssivasu2 ship $ */
3 --
4 PROCEDURE total_payment(p_assignment_action_id in number,
5 p_total_payment out nocopy number);
6 PROCEDURE total_deduct(p_assignment_action_id in number,
7 p_total_deduct out nocopy number);
8
9 procedure get_database_items (p_assignment_id in number,
10 p_run_assignment_action_id in number,
11 p_date_earned in varchar2,
12 p_payroll_action_id in number,
13 p_tax_period in out nocopy varchar2,
14 p_tax_refno in out nocopy varchar2,
15 p_tax_code in out nocopy varchar2,
16 p_tax_basis in out nocopy varchar2,
17 p_ni_category in out nocopy varchar2);
18
19 PROCEDURE get_report_db_items (p_assignment_id in number,
20 p_run_assignment_action_id in number,
21 p_date_earned in varchar2,
22 p_payroll_action_id in number,
23 p_tax_period in out nocopy varchar2,
24 p_tax_refno in out nocopy varchar2,
25 p_tax_phone in out nocopy varchar2,
26 p_tax_code in out nocopy varchar2,
27 p_tax_basis in out nocopy varchar2,
28 p_ni_category in out nocopy varchar2);
29
30 PROCEDURE get_balance_items (p_assignment_action_id in number,
31 p_gross_pay in out nocopy number,
32 p_taxable_pay in out nocopy number,
33 p_paye in out nocopy number,
34 p_niable_pay in out nocopy number,
35 p_ni_paid in out nocopy number);
36
37 FUNCTION report_balance_items (p_balance_name in varchar2,
38 p_dimension in varchar2,
39 p_assignment_action_id in number)
40 return number;
41
42 -- overloaded version (definition prior to 99 EOY3)
43 PROCEDURE get_report_balances (p_assignment_action_id in number,
44 p_label_1 in out nocopy varchar2,
45 p_value_1 in out nocopy number,
46 p_label_2 in out nocopy varchar2,
47 p_value_2 in out nocopy number,
48 p_label_3 in out nocopy varchar2,
49 p_value_3 in out nocopy number,
50 p_label_4 in out nocopy varchar2,
51 p_value_4 in out nocopy number,
52 p_label_5 in out nocopy varchar2,
53 p_value_5 in out nocopy number,
54 p_label_6 in out nocopy varchar2,
55 p_value_6 in out nocopy number,
56 p_label_7 in out nocopy varchar2,
57 p_value_7 in out nocopy number,
58 p_label_8 in out nocopy varchar2,
59 p_value_8 in out nocopy number,
60 p_label_9 in out nocopy varchar2,
61 p_value_9 in out nocopy number,
62 p_label_a in out nocopy varchar2,
63 p_value_a in out nocopy number,
64 p_label_b in out nocopy varchar2,
65 p_value_b in out nocopy number,
66 p_label_c in out nocopy varchar2,
67 p_value_c in out nocopy number);
68
69 procedure formula_inputs_wf (p_session_date in date,
70 p_payroll_exists in out nocopy varchar2,
71 p_assignment_action_id in out nocopy number,
72 p_run_assignment_action_id in out nocopy number,
73 p_assignment_id in number,
74 p_payroll_action_id in out nocopy number,
75 p_date_earned in out nocopy varchar2);
76
77 procedure formula_inputs_hc (p_assignment_action_id in out nocopy number,
78 p_run_assignment_action_id in out nocopy number,
79 p_assignment_id in out nocopy number,
80 p_payroll_action_id in out nocopy number,
81 p_date_earned in out nocopy varchar2);
82
83 procedure get_home_add(p_person_id IN NUMBER,
84 p_add1 IN out nocopy VARCHAR2,
85 p_add2 IN out nocopy VARCHAR2,
86 p_add3 IN out nocopy VARCHAR2,
87 p_reg1 IN out nocopy VARCHAR2,
88 p_reg2 IN out nocopy VARCHAR2,
89 p_reg3 IN out nocopy VARCHAR2,
90 p_twnc IN out nocopy VARCHAR2);
91
92 procedure get_work_add(p_location_id IN NUMBER,
93 p_add1 IN out nocopy VARCHAR2,
94 p_add2 IN out nocopy VARCHAR2,
95 p_add3 IN out nocopy VARCHAR2,
96 p_reg1 IN out nocopy VARCHAR2,
97 p_reg2 IN out nocopy VARCHAR2,
98 p_reg3 IN out nocopy VARCHAR2,
99 p_twnc IN out nocopy VARCHAR2);
100
101 FUNCTION get_tax_details(p_run_assignment_action_id number,
102 p_input_value_id number,
103 p_paye_input_value_id number,
104 p_date_earned varchar2)
105 return varchar2;
106
107 procedure get_input_values_id;
108
109 ------------------------------------------------------------
110 function GET_SALARY ( p_pay_basis_id number,
111 p_assignment_id number,
112 p_effective_date date )
113 return varchar2;
114 pragma restrict_references (get_salary, WNPS, WNDS);
115 -------------------------------------------------------------------
116
117 function report_all_ni_balance (p_balance_name in varchar2,
118 p_assignment_action_id in number,
119 p_dimension in varchar2)
120 return number;
121
122 function report_employer_balance (p_assignment_action_id in number)
123 return number;
124
125 PROCEDURE get_report_balances (p_assignment_action_id in number,
126 p_business_group_id in number,
127 p_label_1 in out nocopy varchar2,
128 p_value_1 in out nocopy number,
129 p_label_2 in out nocopy varchar2,
130 p_value_2 in out nocopy number,
131 p_label_3 in out nocopy varchar2,
132 p_value_3 in out nocopy number,
133 p_label_4 in out nocopy varchar2,
134 p_value_4 in out nocopy number,
135 p_label_5 in out nocopy varchar2,
136 p_value_5 in out nocopy number,
137 p_label_6 in out nocopy varchar2,
138 p_value_6 in out nocopy number,
139 p_label_7 in out nocopy varchar2,
140 p_value_7 in out nocopy number,
141 p_label_8 in out nocopy varchar2,
142 p_value_8 in out nocopy number,
143 p_label_9 in out nocopy varchar2,
144 p_value_9 in out nocopy number,
145 p_label_a in out nocopy varchar2,
146 p_value_a in out nocopy number,
147 p_label_b in out nocopy varchar2,
148 p_value_b in out nocopy number,
149 p_label_c in out nocopy varchar2,
150 p_value_c in out nocopy number);
151
152 procedure add_new_soe_balance (p_business_group_id in number,
153 p_balance_name in varchar2,
154 p_dimension_name in varchar2);
155
156 procedure add_new_soe_balance (p_balance_name in varchar2,
157 p_dimension_name in varchar2);
158
159 END PAY_GB_PAYROLL_ACTIONS_PKG;