1 PACKAGE PAY_GB_PAYROLL_ACTIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: pypra04t.pkh 120.0.12010000.3 2009/06/23 10:37:35 rlingama 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 PROCEDURE get_report_balances (p_assignment_action_id in number,
125 p_business_group_id in number,
126 p_label_1 in out nocopy varchar2,
127 p_value_1 in out nocopy number,
128 p_label_2 in out nocopy varchar2,
129 p_value_2 in out nocopy number,
130 p_label_3 in out nocopy varchar2,
131 p_value_3 in out nocopy number,
132 p_label_4 in out nocopy varchar2,
133 p_value_4 in out nocopy number,
134 p_label_5 in out nocopy varchar2,
135 p_value_5 in out nocopy number,
136 p_label_6 in out nocopy varchar2,
137 p_value_6 in out nocopy number,
138 p_label_7 in out nocopy varchar2,
139 p_value_7 in out nocopy number,
140 p_label_8 in out nocopy varchar2,
141 p_value_8 in out nocopy number,
142 p_label_9 in out nocopy varchar2,
143 p_value_9 in out nocopy number,
144 p_label_a in out nocopy varchar2,
145 p_value_a in out nocopy number,
146 p_label_b in out nocopy varchar2,
147 p_value_b in out nocopy number,
148 p_label_c in out nocopy varchar2,
149 p_value_c in out nocopy number);
150
151 /* Start of bug 8497345*/
152
153 /* Defined the PL/SQL table in specifaction to access in PAYGBSOE form */
154 TYPE balance_name_table IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
155 TYPE balance_value_table IS TABLE OF NUMBER(12,2) INDEX BY BINARY_INTEGER;
156 /* Created overloaded procedure same as get_report_balances */
157 PROCEDURE get_report_balances (p_assignment_action_id in number,
158 p_business_group_id in number,
159 g_displayed_balance in out nocopy balance_name_table,
160 g_displayed_value in out nocopy balance_value_table);
161 /* End of bug 8497345*/
162
163 procedure add_new_soe_balance (p_business_group_id in number,
164 p_balance_name in varchar2,
165 p_dimension_name in varchar2);
166
167 procedure add_new_soe_balance (p_balance_name in varchar2,
168 p_dimension_name in varchar2);
169
170 END PAY_GB_PAYROLL_ACTIONS_PKG;