1 PACKAGE AR_ARXKIR_XMLP_PKG AS
2 /* $Header: ARXKIRS.pls 120.0 2007/12/27 13:55:31 abraghun noship $ */
3 P_SET_OF_BOOKS_ID VARCHAR2(40);
4
5 P_CURRENT_PERIOD VARCHAR2(40);
6
7 P_PRIOR_PERIOD VARCHAR2(40);
8
9 P_CONC_REQUEST_ID NUMBER;
10
11 P_PRIOR_PAST_DUE_AMOUNT NUMBER;
12
13 P_PRIOR_PAST_DUE_COUNT NUMBER;
14
15 CURRENT_GL_DATE VARCHAR2(40);
16
17 P_CURRENT_CUSTOMER_COUNT NUMBER;
18
19 P_PRIOR_CUSTOMER_COUNT NUMBER;
20
21 P_CURRENT_YEAR_CUSTOMER_COUNT NUMBER;
22
23 P_CURRENT_LOCATION_COUNT NUMBER;
24
25 P_PRIOR_LOCATION_COUNT NUMBER;
26
27 P_PRIOR_YEAR_COUNT NUMBER;
28
29 P_CURRENT_ON_HOLD_Y_COUNT NUMBER;
30
31 P_PRIOR_ON_HOLD_Y_COUNT NUMBER;
32
33 P_YEAR_ON_HOLD_Y_COUNT NUMBER;
34
35 P_CURRENT_ON_HOLD_N_COUNT NUMBER;
36
37 P_PRIOR_ON_HOLD_N_COUNT NUMBER;
38
39 P_YEAR_ON_HOLD_N_COUNT NUMBER;
40
41 P_CURRENT_PAY_PER_DAY NUMBER;
42
43 P_PRIOR_PAY_PER_DAY NUMBER;
44
45 P_PRIOR_BATCH_PER_DAY NUMBER;
46
47 P_CURRENT_BATCH_PER_DAY NUMBER;
48
49 P_CURRENT_PAY_PER_BATCH NUMBER;
50
51 P_PRIOR_PAY_PER_BATCH NUMBER;
52
53 PC_LOCATION_COUNT VARCHAR2(240);
54
55 PC_BATCH_PER_DAY_COUNT VARCHAR2(240);
56
57 PC_PAY_PER_BATCH VARCHAR2(240);
58
59 PC_PAY_PER_DAY VARCHAR2(240);
60
61 PC_CUSTOMER_COUNT VARCHAR2(240);
62
63 C_PRIOR_PAST_DUE_COUNT NUMBER;
64
65 C_PRIOR_PAST_DUE_AMOUNT NUMBER;
66
67 FUNCTION C_1FORMULA(CURRENT_PERIOD IN VARCHAR2
68 ,PRIOR_PERIOD IN VARCHAR2
69 ,CURRENT_YEAR IN NUMBER
70 ,SET_OF_BOOKS_ID_LP IN VARCHAR2
71 ,CURRENT_END_DATE IN DATE
72 ,CURRENT_START_DATE IN DATE
73 ,PRIOR_END_DATE IN DATE
74 ,PRIOR_START_DATE IN DATE) RETURN NUMBER;
75
76 FUNCTION PC_ON_HOLD_N_COUNTFORMULA RETURN VARCHAR2;
77
78 FUNCTION PC_ON_HOLD_Y_COUNTFORMULA RETURN VARCHAR2;
79
80 FUNCTION PC_NEW_INVOICES_COUNTFORMULA(PRIOR_NEW_INVOICES_COUNT IN NUMBER
81 ,CURRENT_NEW_INVOICES_COUN IN NUMBER) RETURN VARCHAR2;
82
83 FUNCTION PC_NEW_INVOICES_AMOUNTFORMULA(PRIOR_NEW_INVOICES_AMOUNT IN NUMBER
84 ,CURRENT_NEW_INVOICES_AMOU IN NUMBER) RETURN VARCHAR2;
85
86 FUNCTION PC_NEW_CREDIT_COUNTFORMULA(PRIOR_NEW_CREDIT_COUNT IN NUMBER
87 ,CURRENT_NEW_CREDIT_COUNT IN NUMBER) RETURN VARCHAR2;
88
89 FUNCTION PC_NEW_CREDIT_AMOUNTFORMULA(PRIOR_NEW_CREDIT_AMOUNT IN NUMBER
90 ,CURRENT_NEW_CREDIT_AMOUNT IN NUMBER) RETURN VARCHAR2;
91
92 FUNCTION PC_DUE_COUNTFORMULA(PRIOR_DUE_COUNT IN NUMBER
93 ,CURRENT_DUE_COUNT IN NUMBER) RETURN VARCHAR2;
94
95 FUNCTION PC_DUE_AMOUNTFORMULA(PRIOR_DUE_AMOUNT IN NUMBER
96 ,CURRENT_DUE_AMOUNT IN NUMBER) RETURN VARCHAR2;
97
98 FUNCTION PC_PAST_DUE_AMOUNTFORMULA(CURRENT_PAST_DUE_AMOUNT IN NUMBER) RETURN VARCHAR2;
99
100 FUNCTION PC_PAST_DUE_COUNTFORMULA(CURRENT_PAST_DUE_COUNT IN NUMBER) RETURN VARCHAR2;
101
102 FUNCTION PC_QC_COUNTFORMULA(PRIOR_QC_COUNT IN NUMBER
103 ,CURRENT_QC_COUNT IN NUMBER) RETURN VARCHAR2;
104
105 FUNCTION PC_QC_AMOUNTFORMULA(PRIOR_QC_AMOUNT IN NUMBER
106 ,CURRENT_QC_AMOUNT IN NUMBER) RETURN VARCHAR2;
107
108 FUNCTION PC_C_COUNTFORMULA(PRIOR_C_COUNT IN NUMBER
109 ,CURRENT_C_COUNT IN NUMBER) RETURN VARCHAR2;
110
111 FUNCTION PC_C_AMOUNTFORMULA(PRIOR_C_AMOUNT IN NUMBER
112 ,CURRENT_C_AMOUNT IN NUMBER) RETURN VARCHAR2;
113
114 FUNCTION PC_CR_COUNTFORMULA(PRIOR_CR_COUNT IN NUMBER
115 ,CURRENT_CR_COUNT IN NUMBER) RETURN VARCHAR2;
116
117 FUNCTION PC_CR_AMOUNTFORMULA(PRIOR_CR_AMOUNT IN NUMBER
118 ,CURRENT_CR_AMOUNT IN NUMBER) RETURN VARCHAR2;
119
120 FUNCTION PC_ADJUST_COUNTFORMULA(PRIOR_ADJUST_COUNT IN NUMBER
121 ,CURRENT_ADJUST_COUNT IN NUMBER) RETURN VARCHAR2;
122
123 FUNCTION PC_ADJUST_AMOUNTFORMULA(PRIOR_ADJUST_AMOUNT IN NUMBER
124 ,CURRENT_ADJUST_AMOUNT IN NUMBER) RETURN VARCHAR2;
125
126 FUNCTION PC_TYPE_AMOUNTFORMULA(PRIOR_TYPE_AMOUNT IN NUMBER
127 ,CURRENT_TYPE_AMOUNT IN NUMBER) RETURN VARCHAR2;
128
129 FUNCTION PC_PT_COUNTFORMULA(PRIOR_PT_COUNT IN NUMBER
130 ,CURRENT_PT_COUNT IN NUMBER) RETURN VARCHAR2;
131
132 FUNCTION PC_NSF_COUNTFORMULA(PRIOR_NSF_COUNT IN NUMBER
133 ,CURRENT_NSF_COUNT IN NUMBER) RETURN VARCHAR2;
134
135 FUNCTION PC_NSF_AMOUNTFORMULA(PRIOR_NSF_AMOUNT IN NUMBER
136 ,CURRENT_NSF_AMOUNT IN NUMBER) RETURN VARCHAR2;
137
138 FUNCTION PC_OR_AMOUNTFORMULA(PRIOR_OR_AMOUNT IN NUMBER
139 ,CURRENT_OR_AMOUNT IN NUMBER) RETURN VARCHAR2;
140
141 FUNCTION PC_OR_COUNTFORMULA(PRIOR_OR_COUNT IN NUMBER
142 ,CURRENT_OR_COUNT IN NUMBER) RETURN VARCHAR2;
143
144 FUNCTION PC_EDT_COUNTFORMULA(PRIOR_EDT_COUNT IN NUMBER
145 ,CURRENT_EDT_COUNT IN NUMBER) RETURN VARCHAR2;
146
147 FUNCTION PC_EDT_AMOUNTFORMULA(PRIOR_EDT_AMOUNT IN NUMBER
148 ,CURRENT_EDT_AMOUNT IN NUMBER) RETURN VARCHAR2;
149
150 FUNCTION PC_UDT_COUNTFORMULA(PRIOR_UDT_COUNT IN NUMBER
151 ,CURRENT_UDT_COUNT IN NUMBER) RETURN VARCHAR2;
152
153 FUNCTION PC_UDT_AMOUNTFORMULA(PRIOR_UDT_AMOUNT IN NUMBER
154 ,CURRENT_UDT_AMOUNT IN NUMBER) RETURN VARCHAR2;
155
156 FUNCTION PC1_CUSTOMER_COUNTFORMULA RETURN VARCHAR2;
157
158 FUNCTION PC1_LOCATION_COUNTFORMULA RETURN VARCHAR2;
159
160 FUNCTION PC1_PAY_PER_BATCHFORMULA RETURN VARCHAR2;
161
162 FUNCTION PC1_PAY_PER_DAYFORMULA RETURN VARCHAR2;
163
164 FUNCTION PC1_BATCH_PER_DAY_COUNTFORMULA RETURN VARCHAR2;
165
166 FUNCTION BEFOREREPORT RETURN BOOLEAN;
167
168 FUNCTION AFTERREPORT RETURN BOOLEAN;
169
170 FUNCTION PC_PRIOR_PAST_DUE_COUNTFORMULA RETURN NUMBER;
171
172 FUNCTION C_COPY_VALUEFORMULA(PRIOR_PAST_DUE_COUNT IN NUMBER
173 ,PRIOR_PAST_DUE_AMOUNT IN NUMBER) RETURN NUMBER;
174
175 FUNCTION P_CURRENT_CUSTOMER_COUNT_P RETURN NUMBER;
176
177 FUNCTION P_PRIOR_CUSTOMER_COUNT_P RETURN NUMBER;
178
179 FUNCTION P_CURRENT_YEAR_CUSTOMER_COUNTF RETURN NUMBER;
180
181 FUNCTION P_CURRENT_LOCATION_COUNT_P RETURN NUMBER;
182
183 FUNCTION P_PRIOR_LOCATION_COUNT_P RETURN NUMBER;
184
185 FUNCTION P_PRIOR_YEAR_COUNT_P RETURN NUMBER;
186
187 FUNCTION P_CURRENT_ON_HOLD_Y_COUNT_P RETURN NUMBER;
188
189 FUNCTION P_PRIOR_ON_HOLD_Y_COUNT_P RETURN NUMBER;
190
191 FUNCTION P_YEAR_ON_HOLD_Y_COUNT_P RETURN NUMBER;
192
193 FUNCTION P_CURRENT_ON_HOLD_N_COUNT_P RETURN NUMBER;
194
195 FUNCTION P_PRIOR_ON_HOLD_N_COUNT_P RETURN NUMBER;
196
197 FUNCTION P_YEAR_ON_HOLD_N_COUNT_P RETURN NUMBER;
198
199 FUNCTION P_CURRENT_PAY_PER_DAY_P RETURN NUMBER;
200
201 FUNCTION P_PRIOR_PAY_PER_DAY_P RETURN NUMBER;
202
203 FUNCTION P_PRIOR_BATCH_PER_DAY_P RETURN NUMBER;
204
205 FUNCTION P_CURRENT_BATCH_PER_DAY_P RETURN NUMBER;
206
207 FUNCTION P_CURRENT_PAY_PER_BATCH_P RETURN NUMBER;
208
209 FUNCTION P_PRIOR_PAY_PER_BATCH_P RETURN NUMBER;
210
211 FUNCTION PC_LOCATION_COUNT_P RETURN VARCHAR2;
212
213 FUNCTION PC_BATCH_PER_DAY_COUNT_P RETURN VARCHAR2;
214
215 FUNCTION PC_PAY_PER_BATCH_P RETURN VARCHAR2;
216
217 FUNCTION PC_PAY_PER_DAY_P RETURN VARCHAR2;
218
219 FUNCTION PC_CUSTOMER_COUNT_P RETURN VARCHAR2;
220
221 FUNCTION C_PRIOR_PAST_DUE_COUNT_P RETURN NUMBER;
222
223 FUNCTION C_PRIOR_PAST_DUE_AMOUNT_P RETURN NUMBER;
224
225 END AR_ARXKIR_XMLP_PKG;
226