1 Package PQP_Iterative_Arrearage AUTHID CURRENT_USER As
2 /* $Header: pqpitarr.pkh 115.1 2003/05/29 23:43:06 rpinjala noship $ */
3
4 Type Ele_Data_Rec Is Record
5 (ele_entry_id Number
6 ,assignment_id Number
7 ,assignment_action_id Number
8 ,iter_count Number
9 ,max_amount Number
10 ,min_amount Number
11 ,maxdesired_amt Number
12 ,deduction_amount Number
13 ,actual_usercalc_amt Number
14 ,arrears_allowed Varchar2(2)
15 ,partial_allowed Varchar2(2)
16 ,stopper_flag Varchar2(2)
17 ,inserted_flag Varchar2(2)
18 ,calc_method Varchar2(150)
19 ,to_within Number
20 ,clr_add_amt Number
21 ,clr_rep_amt Number
22 ,formula_warning Varchar2(255)
23 ,warning_code Varchar2(10)
24 );
25 Type Ele_Data_Info Is Table Of Ele_Data_Rec
26 Index By Binary_Integer;
27 g_Element_Values Ele_Data_Info;
28
29 Type Arr_Data_Rec Is Record
30 (element_type_id Number
31 ,arrears_allowed Varchar2(2)
32 ,partial_allowed Varchar2(2)
33 );
34 Type Arr_Data_Info Is Table Of Arr_Data_Rec
35 Index By Binary_Integer;
36 g_Element_Arr_Values Arr_Data_Info;
37
38 Type Itr_Data_Rec Is Record
39 (iterative_method hr_organization_information.org_information1%TYPE
40 ,adjust_to_within Number
41 );
42 Type Itr_Data_Info Is Table Of Itr_Data_Rec
43 Index By Binary_Integer;
44 g_Itr_Method Itr_Data_Info;
45
46 g_pkg_name Varchar2(70):= 'PQP_Iterative_Arrearage.';
47 g_legislation_code Varchar2(3);
48
49 Function Arrearage
50 (p_eletype_id In Number -- Context Parameter 1
51 ,p_ele_entryid In Number -- Context Parameter 2
52 ,p_assignment_id In Number -- Context Parameter 3
53 ,p_business_grp_id In Number -- Context Parameter 4
54 ,p_assignment_action_Id In Number -- Context Parameter 5
55 ,p_date_earned In Date -- Context Parameter 6
56 ,p_net_asg_run In Number -- 1
57 ,p_maxarrears In Number
58 ,p_dedn_amt In Number
59 ,p_to_arrears In Out NoCopy Number
60 ,p_not_taken In Out NoCopy Number
61 ,p_arrears_taken In Out NoCopy Number
62 ,p_remaining_amount In Number Default 0 -- Optional Parameter 7
63 ,p_guaranteed_net In Number Default 0 -- Optional Parameter 8
64 ,p_partial_allowed In Varchar2 Default Null -- Optional Parameter 9
65 ,p_arrears_allowed In Varchar2 Default Null -- Optional Parameter 10
66 ) Return Number;
67
68 Function Iterative_Arrearage
69 (p_eletype_id In Number -- Context Parameter 1
70 ,p_ele_entryid In Number -- Context Parameter 2
71 ,p_assignment_id In Number -- Context Parameter 3
72 ,p_business_grp_id In Number -- Context Parameter 4
73 ,p_assignment_action_Id In Number -- Context Parameter 5
74 ,p_date_earned In Date -- Context Parameter 6
75 ,p_net_asg_run In Number -- 1
76 ,p_maxarrears In Number
77 ,p_dedn_amt In Number
78 ,p_maxdesired_amt In Number
79 ,p_iter_count In Number
80 ,p_inserted_flag In Varchar2
81 ,p_to_arrears In Out NoCopy Number
82 ,p_not_taken In Out NoCopy Number
83 ,p_arrears_taken In Out NoCopy Number
84 ,p_error_message Out NoCopy Varchar2
85 ,p_warning_message Out NoCopy Varchar2
86 ,p_remaining_amount In Number Default 0 -- Optional Parameter 12
87 ,p_guaranteed_net In Number Default 0 -- Optional Parameter 13
88 ,p_partial_allowed In Varchar2 Default Null -- Optional Parameter 14
89 ,p_arrears_allowed In Varchar2 Default Null -- Optional Parameter 15
90 ) Return Number;
91
92 Function Get_Arrearage_Options
93 (p_ele_type_id In Number -- Context Parameter 1
94 ,p_assignment_id In Number -- Context Parameter 2
95 ,p_business_grp_id In Number -- Context Parameter 3
96 ,p_effective_date In Date -- Context Parameter 4
97 ,p_arrears_allowed Out NoCopy Varchar2 --1
98 ,p_partial_allowed Out NoCopy Varchar2 --2
99 ,p_error_message Out NoCopy Varchar2 --3
100 ) Return Number;
101
102 Function Get_Formula_Warning_Mesg
103 (p_ele_entryid In Number -- Context Parameter
104 ,p_assignment_id In Number -- Context Parameter
105 ,p_business_grp_id In Number -- Context Parameter
106 ,p_eletype_id In Number -- Context Parameter
107 ,p_date_earned In Date -- Context Parameter
108 ,p_warning_message Out NoCopy Varchar2
109 ,p_warning_code Out NoCopy Varchar2
110 ) Return Number;
111
112 Function Get_Iteration_Values
113 (p_ele_entryid In Number -- Context Parameter 1
114 ,p_assignment_id In Number -- Context Parameter 2
115 ,p_business_grp_id In Number -- Context Parameter 3
116 ,p_eletype_id In Number -- Context Parameter 4
117 ,p_date_earned In Date -- Context Parameter 5
118 ,p_iter_count Out NoCopy Number -- 1
119 ,p_max_amount Out NoCopy Number
120 ,p_min_amount Out NoCopy Number
121 ,p_maxdesired_amt Out NoCopy Number
122 ,p_deduction_amount Out NoCopy Number
123 ,p_actual_usercalc_amt Out NoCopy Number
124 ,p_clr_add_amt Out NoCopy Number
125 ,p_clr_rep_amt Out NoCopy Number
126 ,p_stopper_flag Out NoCopy Varchar2
127 ,p_inserted_flag Out NoCopy Varchar2
128 ,p_arrears_allowed Out NoCopy Varchar2
129 ,p_partial_allowed Out NoCopy Varchar2
130 ,p_calc_method Out NoCopy Varchar2
131 ,p_to_within Out NoCopy Number
132 ,p_error_message Out NoCopy Varchar2
133 ,p_warning_message Out NoCopy Varchar2 -- 16
134 ) Return Number;
135
136 Function Set_Formula_Warning_Mesg
137 (p_ele_entryid In Number -- Context Parameter
138 ,p_assignment_id In Number -- Context Parameter
139 ,p_business_grp_id In Number -- Context Parameter
140 ,p_eletype_id In Number -- Context Parameter
141 ,p_date_earned In Date -- Context Parameter
142 ,p_warning_message In Varchar2
143 ,p_warning_code In Varchar2
144 ) Return Number;
145
146 Function Set_Iteration_Values
147 (p_ele_entryid In Number -- Context Parameter
148 ,p_assignment_id In Number -- Context Parameter
149 ,p_business_grp_id In Number -- Context Parameter
150 ,p_assignment_action_Id In Number -- Context Parameter
151 ,p_eletype_id In Number -- Context Parameter
152 ,p_date_earned In Date -- Context Parameter
153 ,p_iter_count In Number
154 ,p_max_amount In Number
155 ,p_min_amount In Number
156 ,p_maxdesired_amt In Number
157 ,p_deduction_amount In Number
158 ,p_actual_usercalc_amt In Number
159 ,p_clr_add_amt In Number
160 ,p_clr_rep_amt In Number
161 ,p_stopper_flag In Varchar2
162 ,p_inserted_flag In Varchar2
163 ,p_calc_method In Varchar2
164 ,p_to_within In Number
165 ,p_error_message Out NoCopy Varchar2
166 ,p_warning_message Out NoCopy Varchar2
167 ) Return Number;
168
169 Function Clear_Iteration_Values
170 (p_ele_entryid In Number -- Context Parameter
171 ,p_assignment_id In Number -- Context Parameter
172 ,p_assignment_action_id In Number -- Context Parameter
173 ,p_error_message Out NoCopy Varchar2
174 ,p_warning_message Out NoCopy Varchar2
175 ) Return Number;
176
177 Function Incr_Iteration_Count
178 (p_ele_entryid In Number -- Context Parameter
179 ,p_assignment_id In Number -- Context Parameter
180 ,p_error_message Out NoCopy Varchar2
181 ,p_warning_message Out NoCopy Varchar2
182 ) Return Number;
183
184 Function Stop_Iteration
185 (p_ele_entryid In Number -- Context Parameter
186 ,p_assignment_id In Number -- Context Parameter
187 ,p_error_message Out NoCopy Varchar2
188 ,p_warning_message Out NoCopy Varchar2
189 ) Return Number;
190
191 Function Get_Iteration_Count
192 (p_ele_entryid In Number -- Context Parameter
193 ,p_assignment_id In Number -- Context Parameter
194 ,p_error_message Out NoCopy Varchar2
195 ,p_warning_message Out NoCopy Varchar2
196 ) Return Number;
197
198 Function Get_Stopper_Flag
199 (p_ele_entryid In Number -- Context Parameter
200 ,p_assignment_id In Number -- Context Parameter
201 ,p_error_message Out NoCopy Varchar2
202 ,p_warning_message Out NoCopy Varchar2
203 ) Return Varchar2;
204
205 End PQP_Iterative_Arrearage;
206