1 PACKAGE pqp_ini_bal AUTHID CURRENT_USER AS
2 /* $Header: pqpbladj.pkh 115.6 2003/07/11 11:57:59 jcpereir noship $*/
3
4 TYPE r_err_info is Record
5 ( element_name VARCHAR2(80)
6 ,business_group_id NUMBER
7 ,assignment_id NUMBER
8 );
9
10 -- This Table is used for storing information of errored out entries
11 TYPE t_err_info is Table of r_err_info
12 INDEX BY binary_integer ;
13
14 TYPE r_element_cache is Record
15 ( element_name VARCHAR2(80)
16 ,business_group_id NUMBER
17 ,effective_date Date
18 ,element_type_id NUMBER
19 );
20
21 -- This Table is used as a Cache to retrieve the Element Type Id , for given Element Name
22 TYPE t_element_cache is Table of r_element_cache
23 INDEX BY binary_integer;
24
25 g_element_cache t_element_cache;
26
27 TYPE r_payroll_det_cache is Record
28 ( assignment_id NUMBER
29 ,business_group_id NUMBER
30 ,payroll_id NUMBER
31 ,consolidation_set_id NUMBER
32 ,effective_date DATE);
33
34 -- This Table is used as a Cache to retrieve the Payroll Details , for given Assignment
35 TYPE t_payroll_det_cache is Table of r_payroll_det_cache
36 INDEX BY binary_integer ;
37
38 g_payroll_det_cache t_payroll_det_cache;
39
40 TYPE r_comp_act_miles is Record
41 ( element_name VARCHAR2(80)
42 ,total_act_miles NUMBER);
43
44 -- This Table is used as a Cache to retrieve the Payroll Details , for given Assignment
45 TYPE t_comp_act_miles is Table of r_comp_act_miles
46 INDEX BY binary_integer ;
47
48 g_comp_act_miles t_comp_act_miles;
49
50
51 TYPE r_bal_info is Record
52 ( PAYE_Taxable VARCHAR2(1)
53 ,Ownership_Type VARCHAR2(3)
54 ,Vehicle_Type VARCHAR2(3)
55 ,Usage_Type VARCHAR2(1)
56 ,Element_Name VARCHAR2(80)
57 ,Processed_Miles NUMBER(11,2)
58 ,Processed_Act_Miles NUMBER(11,2)
59 ,Processed_Amt NUMBER(11,2)
60 ,IRAM_Amt NUMBER(11,2)
61 ,NI_Amt NUMBER(11,2)
62 ,Taxable_Amt NUMBER(11,2)
63 ,Addl_Pasg NUMBER(9)
64 ,Addl_Pasg_Amt NUMBER(11,2)
65 ,Addl_Ni_Amt NUMBER(11,2)
66 ,Addl_Tax_Amt NUMBER(11,2)
67 ,Addl_Pasg_Miles NUMBER(11,2)
68 ,Addl_Pasg_Act_Miles NUMBER(11,2)
69 ,effective_date DATE
70 ,business_group_id NUMBER
71 ,assignment_id NUMBER
72 ,run_result_id NUMBER
73 );
74
75 TYPE t_bal_info is Table of r_bal_info
76 INDEX BY binary_integer ;
77
78 g_sum_bal_info t_bal_info;
79
80 -- These variables will contain sum of PAYE Taxable Claimed miles.
81 -- These will be used to get the Mileage Band for the given PAYE Taxable claim
82 comp_tot_paye_tax_cl_miles NUMBER;
83 priv_tot_paye_tax_cl_miles NUMBER;
84
85 /*TYPE r_input_val is Record
86 ( input_value_id1 pay_element_entry_values_f .input_value_id%TYPE
87 ,input_value_id2 pay_element_entry_values_f .input_value_id%TYPE
88 ,input_value_id3 pay_element_entry_values_f .input_value_id%TYPE
89 ,input_value_id4 pay_element_entry_values_f .input_value_id%TYPE
90 ,input_value_id5 pay_element_entry_values_f .input_value_id%TYPE
91 ,input_value_id6 pay_element_entry_values_f .input_value_id%TYPE
92 ,input_value_id7 pay_element_entry_values_f .input_value_id%TYPE
93 ,input_value_id8 pay_element_entry_values_f .input_value_id%TYPE
94 ,input_value_id9 pay_element_entry_values_f .input_value_id%TYPE
95 ,input_value_id10 pay_element_entry_values_f .input_value_id%TYPE
96 ,input_value_id11 pay_element_entry_values_f .input_value_id%TYPE
97 ,input_value_id12 pay_element_entry_values_f .input_value_id%TYPE
98 ,input_value_id13 pay_element_entry_values_f .input_value_id%TYPE
99 ,input_value_id14 pay_element_entry_values_f .input_value_id%TYPE
100 ,input_value_id15 pay_element_entry_values_f .input_value_id%TYPE
101 ,entry_id1 pay_element_entry_values_f .element_entry_id%TYPE
102 ,entry_id2 pay_element_entry_values_f .element_entry_id%TYPE
103 ,entry_id3 pay_element_entry_values_f .element_entry_id%TYPE
104 ,entry_id4 pay_element_entry_values_f .element_entry_id%TYPE
105 ,entry_id5 pay_element_entry_values_f .element_entry_id%TYPE
106 ,entry_id6 pay_element_entry_values_f .element_entry_id%TYPE
107 ,entry_id7 pay_element_entry_values_f .element_entry_id%TYPE
108 ,entry_id8 pay_element_entry_values_f .element_entry_id%TYPE
109 ,entry_id9 pay_element_entry_values_f .element_entry_id%TYPE
110 ,entry_id10 pay_element_entry_values_f .element_entry_id%TYPE
111 ,entry_id11 pay_element_entry_values_f .element_entry_id%TYPE
112 ,entry_id12 pay_element_entry_values_f .element_entry_id%TYPE
113 ,entry_id13 pay_element_entry_values_f .element_entry_id%TYPE
114 ,entry_id14 pay_element_entry_values_f .element_entry_id%TYPE
115 ,entry_id15 pay_element_entry_values_f .element_entry_id%TYPE
116 );*/
117 TYPE r_input_val is Record
118 ( input_value_id pay_element_entry_values_f .input_value_id%TYPE
119 );
120
121 TYPE t_input_val is Table of r_input_val
122 INDEX BY binary_integer ;
123
124 PROCEDURE Initialize_Balances(p_business_group_id IN NUMBER);
125
126 TYPE r_balance_cache is Record
127 ( balance_name VARCHAR2(80)
128 ,balance_type_id NUMBER
129 );
130
131 TYPE t_balance_cache is Table of r_balance_cache
132 INDEX BY binary_integer;
133
134 g_balance_cache t_balance_cache;
135
136 FUNCTION get_balance_value (p_assignment_id IN NUMBER
137 ,p_balance_name IN VARCHAR2
138 )
139 return NUMBER;
140
141
142 PROCEDURE create_element_entry
143 ( p_effective_date IN DATE
144 ,p_business_group_id IN NUMBER
145 ,p_assignment_id IN NUMBER
146 ,p_element_name IN VARCHAR2
147 ,p_base_element_name IN VARCHAR2
148 ,p_entry_value1 IN VARCHAR2
149 ,p_entry_value2 IN VARCHAR2
150 ,p_entry_value3 IN VARCHAR2
151 ,p_entry_value4 IN VARCHAR2
152 ,p_entry_value5 IN VARCHAR2
153 ,p_entry_value6 IN VARCHAR2
154 ,p_entry_value7 IN VARCHAR2
155 ,p_entry_value8 IN VARCHAR2
156 ,p_entry_value9 IN VARCHAR2
157 ,p_entry_value10 IN VARCHAR2
158 ,p_entry_value11 IN VARCHAR2
159 ,p_entry_value12 IN VARCHAR2
160 ,p_entry_value13 IN VARCHAR2
161 ,p_entry_value14 IN VARCHAR2
162 ,p_entry_value15 IN VARCHAR2
163 );
164
165 TYPE r_input_val_cache is Record
166 ( element_type_id NUMBER
167 ,input_val_id1 pay_element_entry_values_f .input_value_id%TYPE
168 ,input_val_id2 pay_element_entry_values_f .input_value_id%TYPE
169 ,input_val_id3 pay_element_entry_values_f .input_value_id%TYPE
170 ,input_val_id4 pay_element_entry_values_f .input_value_id%TYPE
171 ,input_val_id5 pay_element_entry_values_f .input_value_id%TYPE
172 ,input_val_id6 pay_element_entry_values_f .input_value_id%TYPE
173 ,input_val_id7 pay_element_entry_values_f .input_value_id%TYPE
174 ,input_val_id8 pay_element_entry_values_f .input_value_id%TYPE
175 ,input_val_id9 pay_element_entry_values_f .input_value_id%TYPE
176 ,input_val_id10 pay_element_entry_values_f .input_value_id%TYPE
177 ,input_val_id11 pay_element_entry_values_f .input_value_id%TYPE
178 ,input_val_id12 pay_element_entry_values_f .input_value_id%TYPE
179 ,input_val_id13 pay_element_entry_values_f .input_value_id%TYPE
180 ,input_val_id14 pay_element_entry_values_f .input_value_id%TYPE
181 ,input_val_id15 pay_element_entry_values_f .input_value_id%TYPE
182 );
183
184 -- This Table is used as a Cache to retrieve the Input Value Ids , for a given Element
185 TYPE t_input_val_cache is Table of r_input_val_cache
186 INDEX BY binary_integer;
187
188 g_input_val_cache t_input_val_cache;
189
190 PROCEDURE route_balance_amt ;
191 FUNCTION get_element_id (p_business_group_id IN NUMBER
192 ,p_element_name IN VARCHAR2
193 ,p_effective_date IN DATE
194 )
195 RETURN NUMBER;
196 END;