eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AP_APXKIRKI_XMLP_PKG

Source


1 PACKAGE AP_APXKIRKI_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: APXKIRKIS.pls 120.0 2007/12/27 08:09:41 vjaganat noship $ */
3   P_DEBUG_SWITCH VARCHAR2(1);
4 
5   P_CONC_REQUEST_ID NUMBER := 0;
6 
7   P_MIN_PRECISION NUMBER := 0;
8 
9   P_FLEXDATA VARCHAR2(600);
10 
11   P_SET_OF_BOOKS_ID NUMBER;
12 
13   P_PERIOD_NAME VARCHAR2(25);
14 
15   P_INCLUDE_INVOICE_DETAIL VARCHAR2(1);
16 
17   P_ENTERED_BY NUMBER;
18 
19   P_PERIOD_ROWID VARCHAR2(32767);
20 
21   P_WHERE_CREATED_BY VARCHAR2(2000);
22 
23   P_WHERE_CREATED_BY_AERH VARCHAR2(2000);
24 
25   C_BASE_CURRENCY_CODE VARCHAR2(15);
26 
27   C_BASE_PRECISION NUMBER;
28 
29   C_BASE_MIN_ACCT_UNIT NUMBER;
30 
31   C_BASE_DESCRIPTION VARCHAR2(240);
32 
33   C_COMPANY_NAME_HEADER VARCHAR2(50);
34 
35   C_REPORT_START_DATE DATE;
36 
37   C_NLS_YES VARCHAR2(80);
38 
39   C_NLS_NO VARCHAR2(80);
40 
41   C_NLS_ALL VARCHAR2(80);
42 
43   C_NLS_NO_DATA_EXISTS VARCHAR2(240);
44 
45   C_REPORT_RUN_TIME VARCHAR2(8);
46 
47   C_CHART_OF_ACCOUNTS_ID NUMBER;
48 
49   C_MODULE VARCHAR2(25) := 'KEY INDICATORS';
50 
51   C_PERIOD_YEAR NUMBER;
52 
53   C_PRIOR_PERIOD_YEAR NUMBER;
54 
55   C_PERIOD_NUM NUMBER;
56 
57   C_PRIOR_PERIOD_NUM NUMBER;
58 
59   C_PRIOR_PERIOD_NAME VARCHAR2(25);
60 
61   C_PERIOD_TYPE VARCHAR2(25);
62 
63   C_START_DATE VARCHAR2(32767);
64 
65   C_PRIOR_START_DATE DATE;
66 
67   C_END_DATE VARCHAR2(32767);
68 
69   C_PRIOR_END_DATE DATE;
70 
71   C_STATUS VARCHAR2(32767);
72 
73   C_TOTAL_VENDORS NUMBER;
74 
75   C_TOTAL_INACTIVE NUMBER;
76 
77   C_TOTAL_ONE_TIME NUMBER;
78 
79   C_TOTAL_1099 NUMBER;
80 
81   C_TOTAL_VOIDED NUMBER;
82 
83   C_TOTAL_DISTS NUMBER;
84 
85   C_TOTAL_BATCHES NUMBER;
86 
87   C_TOTAL_INVOICES NUMBER;
88 
89   C_TOTAL_INVOICES_DLR NUMBER;
90 
91   C_TOTAL_INVOICE_HOLDS NUMBER;
92 
93   C_TOTAL_INVOICE_HOLDS_DLR NUMBER;
94 
95   C_TOTAL_CLEARED NUMBER;
96 
97   C_TOTAL_CLEARED_DLR NUMBER;
98 
99   C_STOPPED NUMBER;
100 
101   C_TOTAL_MAN_CHECKS NUMBER;
102 
103   C_TOTAL_MAN_CHECKS_DLR NUMBER;
104 
105   C_TOTAL_AUTO_CHECKS NUMBER;
106 
107   C_TOTAL_AUTO_CHECKS_DLR NUMBER;
108 
109   C_TOTAL_SPOILED NUMBER;
110 
111   C_TOTAL_OUTSTANDING NUMBER;
112 
113   C_TOTAL_PAID_INV NUMBER;
114 
115   C_TOTAL_DISCS_DLR NUMBER;
116 
117   C_TOTAL_DISCS NUMBER;
118 
119   C_TOTAL_SCHEDULED NUMBER;
120 
121   C_TOTAL_SITES NUMBER;
122 
123   C_TOTAL_MH NUMBER;
124 
125   C_TOTAL_MH_DLR NUMBER;
126 
127   C_MH_COUNT NUMBER;
128 
129   C_MH_AMOUNT NUMBER;
130 
131   C_TOTAL_MATCHED NUMBER;
132 
133   C_TOTAL_MATCHED_DLR NUMBER;
134 
135   C_NEW_COUNT NUMBER;
136 
137   C_NEW_AMOUNT NUMBER;
138 
139   C_VOID NUMBER;
140 
141   C_CLEARED NUMBER;
142 
143   C_CLEARED_DLR NUMBER;
144 
145   C_MANUAL_CHECKS NUMBER;
146 
147   C_TOTAL_STOPPED NUMBER;
148 
149   C_MANUAL_CHECKS_DLR NUMBER;
150 
151   C_AUTO_CHECKS NUMBER;
152 
153   C_AUTO_CHECKS_DLR NUMBER;
154 
155   C_NEW_SPOILED NUMBER;
156 
157   C_NEW_OUTSTANDING NUMBER;
158 
159   C_MANUAL_PAYMENTS NUMBER;
160 
161   C_MANUAL_PAYMENTS_DLR NUMBER;
162 
163   C_AUTO_PAYMENTS NUMBER;
164 
165   C_AUTO_PAYMENTS_DLR NUMBER;
166 
167   C_INVOICES NUMBER;
168 
169   C_DISCOUNT_DLR NUMBER;
170 
171   C_DISCOUNTS NUMBER;
172 
173   C_NEW_INVOICES NUMBER;
174 
175   C_TOTAL_DLR NUMBER;
176 
177   C_BATCHES NUMBER;
178 
179   C_NEW_ON_HOLD NUMBER;
180 
181   C_NEW_HOLD_DLR NUMBER;
182 
183   C_PAYMENT_SCHEDULES NUMBER;
184 
185   C_NEW_DISTS NUMBER;
186 
187   C_NEW_VENDORS NUMBER;
188 
189   C_NEW_INACTIVE NUMBER;
190 
191   C_NEW_ONE_TIME NUMBER;
192 
193   C_NEW_TYPE_1099_VENDORS NUMBER;
194 
195   C_OLD_VENDOR_SITES NUMBER;
196 
197   C_TOTAL_VENDORS_HELD NUMBER;
198 
199   C_NEW_VENDOR_SITES NUMBER;
200 
201   C_UPDATED_VENDORS NUMBER;
202 
203   C_UPDATED_SITES NUMBER;
204 
205   C_NEW_VENDORS_HELD NUMBER;
206 
207   C_OLD_INVOICES NUMBER;
208 
209   C_OLD_TOTAL_DLR NUMBER;
210 
211   C_OLD_DISTS NUMBER;
212 
213   C_OLD_BATCHES NUMBER;
214 
215   C_OLD_PAYMENT_SCHEDULES NUMBER;
216 
217   C_OLD_ON_HOLD NUMBER;
218 
219   C_OLD_HOLD_DLR NUMBER;
220 
221   C_OLD_COUNT NUMBER;
222 
223   C_OLD_AMOUNT NUMBER;
224 
225   C_OLD_MH_COUNT NUMBER;
226 
227   C_OLD_MH_AMOUNT NUMBER;
228 
229   C_OLD_VENDORS NUMBER;
230 
231   C_OLD_SITES NUMBER;
232 
233   C_INACTIVE NUMBER;
234 
235   C_ONE_TIME NUMBER;
236 
237   C_TYPE_1099_VENDORS NUMBER;
238 
239   C_VENDORS_HELD NUMBER;
240 
241   C_OLD_INVOICES_PAID NUMBER;
242 
243   C_OLD_AUTO_CHECKS NUMBER;
244 
245   C_OLD_MANUAL_CHECKS NUMBER;
246 
247   C_OLD_DISCOUNTS NUMBER;
248 
249   C_OLD_DISCOUNT_DLR NUMBER;
250 
251   C_OLD_VOID NUMBER;
252 
253   C_OLD_STOPPED NUMBER;
254 
255   C_OLD_SPOILED NUMBER;
256 
257   C_OLD_OUTSTANDING NUMBER;
258 
259   C_OLD_CLEARED NUMBER;
260 
261   C_OLD_CLEARED_DLR NUMBER;
262 
263   C_OLD_AUTO_CHECKS_DLR NUMBER;
264 
265   C_OLD_MANUAL_CHECKS_DLR NUMBER;
266 
267   C_AVERAGE_SITES NUMBER;
268 
269   C_AVERAGE_LINES NUMBER;
270 
271   C_AVERAGE_PAY_INV NUMBER;
272 
273   C_AVERAGE_PAY_CHK NUMBER;
274 
275   C_AVERAGE_MH NUMBER;
276 
277   C_TOTAL_SITE NUMBER;
278 
279   C_TOTAL_NEW_EXCEPTIONS NUMBER;
280 
281   C_TOTAL_OLD_EXCEPTIONS NUMBER;
282 
283   C_TOTAL_TOTAL_EXCEPTIONS NUMBER;
284 
285   C_TOTAL_NEW_EXCEPTIONS_DLR NUMBER;
286 
287   C_TOTAL_OLD_EXCEPTIONS_DLR NUMBER;
288 
289   C_TOTAL_TOTAL_EXCEPTIONS_DLR NUMBER;
290 
291   C_TOTAL_NEW_CHECKS NUMBER;
292 
293   C_TOTAL_OLD_CHECKS NUMBER;
294 
295   C_TOTAL_TOTAL_CHECKS NUMBER;
296 
297   C_TOTAL_NEW_CHECKS_DLR NUMBER;
298 
299   C_TOTAL_OLD_CHECKS_DLR NUMBER;
300 
301   C_TOTAL_TOTAL_CHECKS_DLR NUMBER;
302 
303   C_PERCENT_VENDORS NUMBER;
304 
305   C_PERCENT_SITES NUMBER;
306 
307   C_PERCENT_ONE_TIME NUMBER;
308 
309   C_PERCENT_1099 NUMBER;
310 
311   C_PERCENT_VENDORS_HELD NUMBER;
312 
313   C_PERCENT_INACTIVE NUMBER;
314 
315   C_PERCENT_INVOICES NUMBER;
316 
317   C_PERCENT_INVOICES_DLR NUMBER;
318 
319   C_PERCENT_MATCHED NUMBER;
320 
321   C_PERCENT_MATCHED_DLR NUMBER;
322 
323   C_PERCENT_DISTS NUMBER;
324 
325   C_PERCENT_SCHEDULED NUMBER;
326 
327   C_PERCENT_BATCHES NUMBER;
328 
329   C_PERCENT_INVOICE_HOLDS NUMBER;
330 
331   C_PERCENT_INVOICE_HOLDS_DLR NUMBER;
332 
333   C_PERCENT_MH NUMBER;
334 
335   C_PERCENT_MH_DLR NUMBER;
336 
337   C_PERCENT_MAN_CHECKS NUMBER;
338 
339   C_PERCENT_MAN_CHECKS_DLR NUMBER;
340 
341   C_PERCENT_AUTO_CHECKS NUMBER;
342 
343   C_PERCENT_AUTO_CHECKS_DLR NUMBER;
344 
345   C_PERCENT_PAID_INV NUMBER;
346 
347   C_PERCENT_DISCS NUMBER;
348 
349   C_PERCENT_DISCS_DLR NUMBER;
350 
351   C_PERCENT_VOIDED NUMBER;
352 
353   C_PERCENT_STOPPED NUMBER;
354 
355   C_PERCENT_SPOILED NUMBER;
356 
357   C_PERCENT_OUTSTANDING NUMBER;
358 
359   C_PERCENT_CLEARED NUMBER;
360 
361   C_PERCENT_CLEARED_DLR NUMBER;
362 
363   C_PERCENT_TOTAL_EXCEPTIONS NUMBER;
364 
365   C_PERCENT_TOTAL_EXCEPTIONS_DLR NUMBER;
366 
367   C_PERCENT_TOTAL_CHECKS NUMBER;
368 
369   C_PERCENT_TOTAL_CHECKS_DLR NUMBER;
370 
371   C_NLS_NA VARCHAR2(80);
372 
373   C_PRIOR_PERIOD_EXISTS VARCHAR2(1);
374 
375   C_NLS_END_OF_REPORT VARCHAR2(100);
376 
377   C_PRIOR_OLD_VENDOR_SITES NUMBER;
378 
379   C_PERCENT_ADDITIONAL_SITES NUMBER;
380 
381   C_TOTAL_ADDITIONAL_SITES NUMBER;
382 
383   C_PRIOR_VENDORS_UPDATED NUMBER;
384 
385   C_PRIOR_SITES_UPDATED NUMBER;
386 
387   C_PERCENT_VENDORS_UPDATED NUMBER;
388 
389   C_PERCENT_SITES_UPDATED NUMBER;
390 
391   C_TOTAL_VENDORS_UPDATED NUMBER;
392 
393   C_TOTAL_SITES_UPDATED NUMBER;
394 
395   C_SYSTEM_USER_NAME VARCHAR2(1000);
396 
397   C_TOTAL_REFUND_CHECKS NUMBER;
398 
399   C_TOTAL_REFUND_CHECKS_DLR NUMBER;
400 
401   C_TOTAL_OUTSTANDING_DLR NUMBER;
402 
403   C_NEW_OUTSTANDING_DLR NUMBER;
404 
405   C_NEW_REFUND_PAYMENTS NUMBER;
406 
407   C_NEW_REFUND_PAYMENTS_DLR NUMBER;
408 
409   C_OLD_OUTSTANDING_DLR NUMBER;
410 
411   C_OLD_REFUND_PAYMENTS NUMBER;
412 
413   C_OLD_REFUND_PAYMENTS_DLR NUMBER;
414 
415   C_PERCENT_OUTSTANDING_DLR NUMBER;
416 
417   C_PERCENT_REFUND_CHECKS NUMBER;
418 
419   C_PERCENT_REFUND_CHECKS_DLR NUMBER;
420 
421   C_NEW_LINES NUMBER;
422 
423   C_OLD_LINES NUMBER;
424 
425   C_PERCENT_LINES NUMBER;
426 
427   C_TOTAL_LINES NUMBER;
428 
429   C_OLD_LINES_VAR_COUNT NUMBER;
430 
431   C_OLD_LINES_VAR_AMOUNT NUMBER;
432 
433   C_LINE_TOTAL_VARS NUMBER;
434 
435   C_LINE_TOTAL_VARS_DLR NUMBER;
436 
437   C_LINE_VAR_COUNT NUMBER;
438 
439   C_LINE_VAR_AMOUNT NUMBER;
440 
441   C_OLD_DISTS_VAR_COUNT NUMBER;
442 
443   C_OLD_DISTS_VAR_AMOUNT NUMBER;
444 
445   C_DIST_TOTAL_VARS NUMBER;
446 
447   C_DIST_TOTAL_VARS_DLR NUMBER;
448 
449   C_DIST_VAR_COUNT NUMBER;
450 
451   C_DIST_VAR_AMOUNT NUMBER;
452 
453   C_PERCENT_LINE_VARS NUMBER;
454 
455   C_PERCENT_DIST_VARS NUMBER;
456 
457   C_PERCENT_LINE_VARS_DLR NUMBER;
458 
459   C_PERCENT_DIST_VARS_DLR NUMBER;
460 
461   C_AVERAGE_DISTS NUMBER;
462 
463   C_ORG_ID NUMBER;
464 
465   FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN;
466 
467   FUNCTION CUSTOM_INIT RETURN BOOLEAN;
468 
469   FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
470 
471   FUNCTION GET_NLS_STRINGS RETURN BOOLEAN;
472 
473   FUNCTION BEFOREREPORT RETURN BOOLEAN;
474 
475   FUNCTION AFTERREPORT RETURN BOOLEAN;
476 
477   FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
478 
479   FUNCTION CALCULATE_RUN_TIME RETURN BOOLEAN;
480 
481   FUNCTION PERIOD_DATA RETURN BOOLEAN;
482 
483   FUNCTION ALL_PERIOD RETURN BOOLEAN;
484 
485   FUNCTION MATCHING_HOLDS RETURN BOOLEAN;
486 
487   FUNCTION INVOICE_DATA RETURN BOOLEAN;
488 
489   FUNCTION VARIANCE_DATA RETURN BOOLEAN;
490 
491   FUNCTION CURRENT_PERIOD RETURN BOOLEAN;
492 
493   FUNCTION INSERT_KEY_IND RETURN BOOLEAN;
494 
495   FUNCTION UPDATE_KEY_IND RETURN BOOLEAN;
496 
497   FUNCTION PRIOR_PERIOD RETURN BOOLEAN;
498 
499   FUNCTION CALCULATE_STATISTICS RETURN BOOLEAN;
500 
501   FUNCTION AFTERPFORM RETURN BOOLEAN;
502 
503   FUNCTION CF_PER_CHANGE_AT_CURFORMULA(CS_CURR_INV_NUM IN NUMBER
504                                       ,CS_PRIOR_INV_NUM IN NUMBER) RETURN NUMBER;
505 
506   FUNCTION CF_PER_CHANGE_AT_CUR_AMTFORMUL(CS_CURR_INV_AMT IN NUMBER
507                                          ,CS_PRIOR_INV_AMT IN NUMBER) RETURN NUMBER;
508 
509   FUNCTION CF_PERCENT_CHANGE_NUMFORMULA(C_PRIOR_NUM_OF_INVOICES IN NUMBER
510                                        ,C_CURRENT_NUM_OF_INVOICES IN NUMBER) RETURN NUMBER;
511 
512   FUNCTION CF_PERCENT_CHANGE_AMOUNTFORMUL(C_PRIOR_INVOICE_AMOUNT IN NUMBER
513                                          ,C_CURRENT_INVOICE_AMOUNT IN NUMBER) RETURN NUMBER;
514 
515   FUNCTION CF_PERCENT_INV_USERFORMULA(CS_SUM_PRIOR_INV_NUM IN NUMBER
516                                      ,CS_SUM_CURR_INV_NUM IN NUMBER) RETURN NUMBER;
517 
518   FUNCTION CF_PERCENT_FUNC_AMT_USERFORMUL(CS_SUM_PRIOR_FUNC_AMT IN NUMBER
519                                          ,CS_SUM_CURR_FUNC_AMT IN NUMBER) RETURN NUMBER;
520 
521   FUNCTION CF_PERCENT_DISTFORMULA0006(CS_PRIOR_DIST IN NUMBER
522                                      ,CS_CURR_DIST IN NUMBER) RETURN CHAR;
523 
524   FUNCTION GET_SYSTEM_USER_NAME RETURN BOOLEAN;
525 
526   FUNCTION CF_DISPLAY_SOURCEFORMULA(C_INVOICE_SOURCE IN VARCHAR2) RETURN CHAR;
527 
528   FUNCTION GET_PERIOD_NAME_FROM_ROWID RETURN BOOLEAN;
529 
530   FUNCTION GET_WHERE_CONDITIONS RETURN BOOLEAN;
531 
532   FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
533 
534   FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
535 
536   FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
537 
538   FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
539 
540   FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
541 
542   FUNCTION C_REPORT_START_DATE_P RETURN DATE;
543 
544   FUNCTION C_NLS_YES_P RETURN VARCHAR2;
545 
546   FUNCTION C_NLS_NO_P RETURN VARCHAR2;
547 
548   FUNCTION C_NLS_ALL_P RETURN VARCHAR2;
549 
550   FUNCTION C_NLS_NO_DATA_EXISTS_P RETURN VARCHAR2;
551 
552   FUNCTION C_REPORT_RUN_TIME_P RETURN VARCHAR2;
553 
554   FUNCTION C_CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
555 
556   FUNCTION C_MODULE_P RETURN VARCHAR2;
557 
558   FUNCTION C_PERIOD_YEAR_P RETURN NUMBER;
559 
563 
560   FUNCTION C_PRIOR_PERIOD_YEAR_P RETURN NUMBER;
561 
562   FUNCTION C_PERIOD_NUM_P RETURN NUMBER;
564   FUNCTION C_PRIOR_PERIOD_NUM_P RETURN NUMBER;
565 
566   FUNCTION C_PRIOR_PERIOD_NAME_P RETURN VARCHAR2;
567 
568   FUNCTION C_PERIOD_TYPE_P RETURN VARCHAR2;
569 
570   FUNCTION C_START_DATE_P RETURN VARCHAR2;
571 
572   FUNCTION C_PRIOR_START_DATE_P RETURN DATE;
573 
574   FUNCTION C_END_DATE_P RETURN VARCHAR2;
575 
576   FUNCTION C_PRIOR_END_DATE_P RETURN DATE;
577 
578   FUNCTION C_STATUS_P RETURN VARCHAR2;
579 
580   FUNCTION C_TOTAL_VENDORS_P RETURN NUMBER;
581 
582   FUNCTION C_TOTAL_INACTIVE_P RETURN NUMBER;
583 
584   FUNCTION C_TOTAL_ONE_TIME_P RETURN NUMBER;
585 
586   FUNCTION C_TOTAL_1099_P RETURN NUMBER;
587 
588   FUNCTION C_TOTAL_VOIDED_P RETURN NUMBER;
589 
590   FUNCTION C_TOTAL_DISTS_P RETURN NUMBER;
591 
592   FUNCTION C_TOTAL_BATCHES_P RETURN NUMBER;
593 
594   FUNCTION C_TOTAL_INVOICES_P RETURN NUMBER;
595 
596   FUNCTION C_TOTAL_INVOICES_DLR_P RETURN NUMBER;
597 
598   FUNCTION C_TOTAL_INVOICE_HOLDS_P RETURN NUMBER;
599 
600   FUNCTION C_TOTAL_INVOICE_HOLDS_DLR_P RETURN NUMBER;
601 
602   FUNCTION C_TOTAL_CLEARED_P RETURN NUMBER;
603 
604   FUNCTION C_TOTAL_CLEARED_DLR_P RETURN NUMBER;
605 
606   FUNCTION C_STOPPED_P RETURN NUMBER;
607 
608   FUNCTION C_TOTAL_MAN_CHECKS_P RETURN NUMBER;
609 
610   FUNCTION C_TOTAL_MAN_CHECKS_DLR_P RETURN NUMBER;
611 
612   FUNCTION C_TOTAL_AUTO_CHECKS_P RETURN NUMBER;
613 
614   FUNCTION C_TOTAL_AUTO_CHECKS_DLR_P RETURN NUMBER;
615 
616   FUNCTION C_TOTAL_SPOILED_P RETURN NUMBER;
617 
618   FUNCTION C_TOTAL_OUTSTANDING_P RETURN NUMBER;
619 
620   FUNCTION C_TOTAL_PAID_INV_P RETURN NUMBER;
621 
622   FUNCTION C_TOTAL_DISCS_DLR_P RETURN NUMBER;
623 
624   FUNCTION C_TOTAL_DISCS_P RETURN NUMBER;
625 
626   FUNCTION C_TOTAL_SCHEDULED_P RETURN NUMBER;
627 
628   FUNCTION C_TOTAL_SITES_P RETURN NUMBER;
629 
630   FUNCTION C_TOTAL_MH_P RETURN NUMBER;
631 
632   FUNCTION C_TOTAL_MH_DLR_P RETURN NUMBER;
633 
634   FUNCTION C_MH_COUNT_P RETURN NUMBER;
635 
636   FUNCTION C_MH_AMOUNT_P RETURN NUMBER;
637 
638   FUNCTION C_TOTAL_MATCHED_P RETURN NUMBER;
639 
640   FUNCTION C_TOTAL_MATCHED_DLR_P RETURN NUMBER;
641 
642   FUNCTION C_NEW_COUNT_P RETURN NUMBER;
643 
644   FUNCTION C_NEW_AMOUNT_P RETURN NUMBER;
645 
646   FUNCTION C_VOID_P RETURN NUMBER;
647 
648   FUNCTION C_CLEARED_P RETURN NUMBER;
649 
650   FUNCTION C_CLEARED_DLR_P RETURN NUMBER;
651 
652   FUNCTION C_MANUAL_CHECKS_P RETURN NUMBER;
653 
654   FUNCTION C_TOTAL_STOPPED_P RETURN NUMBER;
655 
656   FUNCTION C_MANUAL_CHECKS_DLR_P RETURN NUMBER;
657 
658   FUNCTION C_AUTO_CHECKS_P RETURN NUMBER;
659 
660   FUNCTION C_AUTO_CHECKS_DLR_P RETURN NUMBER;
661 
662   FUNCTION C_NEW_SPOILED_P RETURN NUMBER;
663 
664   FUNCTION C_NEW_OUTSTANDING_P RETURN NUMBER;
665 
666   FUNCTION C_MANUAL_PAYMENTS_P RETURN NUMBER;
667 
668   FUNCTION C_MANUAL_PAYMENTS_DLR_P RETURN NUMBER;
669 
670   FUNCTION C_AUTO_PAYMENTS_P RETURN NUMBER;
671 
672   FUNCTION C_AUTO_PAYMENTS_DLR_P RETURN NUMBER;
673 
674   FUNCTION C_INVOICES_P RETURN NUMBER;
675 
676   FUNCTION C_DISCOUNT_DLR_P RETURN NUMBER;
677 
678   FUNCTION C_DISCOUNTS_P RETURN NUMBER;
679 
680   FUNCTION C_NEW_INVOICES_P RETURN NUMBER;
681 
682   FUNCTION C_TOTAL_DLR_P RETURN NUMBER;
683 
684   FUNCTION C_BATCHES_P RETURN NUMBER;
685 
686   FUNCTION C_NEW_ON_HOLD_P RETURN NUMBER;
687 
688   FUNCTION C_NEW_HOLD_DLR_P RETURN NUMBER;
689 
690   FUNCTION C_PAYMENT_SCHEDULES_P RETURN NUMBER;
691 
692   FUNCTION C_NEW_DISTS_P RETURN NUMBER;
693 
694   FUNCTION C_NEW_VENDORS_P RETURN NUMBER;
695 
696   FUNCTION C_NEW_INACTIVE_P RETURN NUMBER;
697 
698   FUNCTION C_NEW_ONE_TIME_P RETURN NUMBER;
699 
700   FUNCTION C_NEW_TYPE_1099_VENDORS_P RETURN NUMBER;
701 
702   FUNCTION C_OLD_VENDOR_SITES_P RETURN NUMBER;
703 
704   FUNCTION C_TOTAL_VENDORS_HELD_P RETURN NUMBER;
705 
706   FUNCTION C_NEW_VENDOR_SITES_P RETURN NUMBER;
707 
708   FUNCTION C_UPDATED_VENDORS_P RETURN NUMBER;
709 
710   FUNCTION C_UPDATED_SITES_P RETURN NUMBER;
711 
712   FUNCTION C_NEW_VENDORS_HELD_P RETURN NUMBER;
713 
714   FUNCTION C_OLD_INVOICES_P RETURN NUMBER;
715 
716   FUNCTION C_OLD_TOTAL_DLR_P RETURN NUMBER;
717 
718   FUNCTION C_OLD_DISTS_P RETURN NUMBER;
719 
720   FUNCTION C_OLD_BATCHES_P RETURN NUMBER;
721 
722   FUNCTION C_OLD_PAYMENT_SCHEDULES_P RETURN NUMBER;
723 
724   FUNCTION C_OLD_ON_HOLD_P RETURN NUMBER;
725 
726   FUNCTION C_OLD_HOLD_DLR_P RETURN NUMBER;
727 
728   FUNCTION C_OLD_COUNT_P RETURN NUMBER;
729 
730   FUNCTION C_OLD_AMOUNT_P RETURN NUMBER;
731 
735 
732   FUNCTION C_OLD_MH_COUNT_P RETURN NUMBER;
733 
734   FUNCTION C_OLD_MH_AMOUNT_P RETURN NUMBER;
736   FUNCTION C_OLD_VENDORS_P RETURN NUMBER;
737 
738   FUNCTION C_OLD_SITES_P RETURN NUMBER;
739 
740   FUNCTION C_INACTIVE_P RETURN NUMBER;
741 
742   FUNCTION C_ONE_TIME_P RETURN NUMBER;
743 
744   FUNCTION C_TYPE_1099_VENDORS_P RETURN NUMBER;
745 
746   FUNCTION C_VENDORS_HELD_P RETURN NUMBER;
747 
748   FUNCTION C_OLD_INVOICES_PAID_P RETURN NUMBER;
749 
750   FUNCTION C_OLD_AUTO_CHECKS_P RETURN NUMBER;
751 
752   FUNCTION C_OLD_MANUAL_CHECKS_P RETURN NUMBER;
753 
754   FUNCTION C_OLD_DISCOUNTS_P RETURN NUMBER;
755 
756   FUNCTION C_OLD_DISCOUNT_DLR_P RETURN NUMBER;
757 
758   FUNCTION C_OLD_VOID_P RETURN NUMBER;
759 
760   FUNCTION C_OLD_STOPPED_P RETURN NUMBER;
761 
762   FUNCTION C_OLD_SPOILED_P RETURN NUMBER;
763 
764   FUNCTION C_OLD_OUTSTANDING_P RETURN NUMBER;
765 
766   FUNCTION C_OLD_CLEARED_P RETURN NUMBER;
767 
768   FUNCTION C_OLD_CLEARED_DLR_P RETURN NUMBER;
769 
770   FUNCTION C_OLD_AUTO_CHECKS_DLR_P RETURN NUMBER;
771 
772   FUNCTION C_OLD_MANUAL_CHECKS_DLR_P RETURN NUMBER;
773 
774   FUNCTION C_AVERAGE_SITES_P RETURN NUMBER;
775 
776   FUNCTION C_AVERAGE_LINES_P RETURN NUMBER;
777 
778   FUNCTION C_AVERAGE_PAY_INV_P RETURN NUMBER;
779 
780   FUNCTION C_AVERAGE_PAY_CHK_P RETURN NUMBER;
781 
782   FUNCTION C_AVERAGE_MH_P RETURN NUMBER;
783 
784   FUNCTION C_TOTAL_SITE_P RETURN NUMBER;
785 
786   FUNCTION C_TOTAL_NEW_EXCEPTIONS_P RETURN NUMBER;
787 
788   FUNCTION C_TOTAL_OLD_EXCEPTIONS_P RETURN NUMBER;
789 
790   FUNCTION C_TOTAL_TOTAL_EXCEPTIONS_P RETURN NUMBER;
791 
792   FUNCTION C_TOTAL_NEW_EXCEPTIONS_DLR_P RETURN NUMBER;
793 
794   FUNCTION C_TOTAL_OLD_EXCEPTIONS_DLR_P RETURN NUMBER;
795 
796   FUNCTION C_TOTAL_TOTAL_EXCEPTIONS_DLR_P RETURN NUMBER;
797 
798   FUNCTION C_TOTAL_NEW_CHECKS_P RETURN NUMBER;
799 
800   FUNCTION C_TOTAL_OLD_CHECKS_P RETURN NUMBER;
801 
802   FUNCTION C_TOTAL_TOTAL_CHECKS_P RETURN NUMBER;
803 
804   FUNCTION C_TOTAL_NEW_CHECKS_DLR_P RETURN NUMBER;
805 
806   FUNCTION C_TOTAL_OLD_CHECKS_DLR_P RETURN NUMBER;
807 
808   FUNCTION C_TOTAL_TOTAL_CHECKS_DLR_P RETURN NUMBER;
809 
810   FUNCTION C_PERCENT_VENDORS_P RETURN NUMBER;
811 
812   FUNCTION C_PERCENT_SITES_P RETURN NUMBER;
813 
814   FUNCTION C_PERCENT_ONE_TIME_P RETURN NUMBER;
815 
816   FUNCTION C_PERCENT_1099_P RETURN NUMBER;
817 
818   FUNCTION C_PERCENT_VENDORS_HELD_P RETURN NUMBER;
819 
820   FUNCTION C_PERCENT_INACTIVE_P RETURN NUMBER;
821 
822   FUNCTION C_PERCENT_INVOICES_P RETURN NUMBER;
823 
824   FUNCTION C_PERCENT_INVOICES_DLR_P RETURN NUMBER;
825 
826   FUNCTION C_PERCENT_MATCHED_P RETURN NUMBER;
827 
828   FUNCTION C_PERCENT_MATCHED_DLR_P RETURN NUMBER;
829 
830   FUNCTION C_PERCENT_DISTS_P RETURN NUMBER;
831 
832   FUNCTION C_PERCENT_SCHEDULED_P RETURN NUMBER;
833 
834   FUNCTION C_PERCENT_BATCHES_P RETURN NUMBER;
835 
836   FUNCTION C_PERCENT_INVOICE_HOLDS_P RETURN NUMBER;
837 
838   FUNCTION C_PERCENT_INVOICE_HOLDS_DLR_P RETURN NUMBER;
839 
840   FUNCTION C_PERCENT_MH_P RETURN NUMBER;
841 
842   FUNCTION C_PERCENT_MH_DLR_P RETURN NUMBER;
843 
844   FUNCTION C_PERCENT_MAN_CHECKS_P RETURN NUMBER;
845 
846   FUNCTION C_PERCENT_MAN_CHECKS_DLR_P RETURN NUMBER;
847 
848   FUNCTION C_PERCENT_AUTO_CHECKS_P RETURN NUMBER;
849 
850   FUNCTION C_PERCENT_AUTO_CHECKS_DLR_P RETURN NUMBER;
851 
852   FUNCTION C_PERCENT_PAID_INV_P RETURN NUMBER;
853 
854   FUNCTION C_PERCENT_DISCS_P RETURN NUMBER;
855 
856   FUNCTION C_PERCENT_DISCS_DLR_P RETURN NUMBER;
857 
858   FUNCTION C_PERCENT_VOIDED_P RETURN NUMBER;
859 
860   FUNCTION C_PERCENT_STOPPED_P RETURN NUMBER;
861 
862   FUNCTION C_PERCENT_SPOILED_P RETURN NUMBER;
863 
864   FUNCTION C_PERCENT_OUTSTANDING_P RETURN NUMBER;
865 
866   FUNCTION C_PERCENT_CLEARED_P RETURN NUMBER;
867 
868   FUNCTION C_PERCENT_CLEARED_DLR_P RETURN NUMBER;
869 
870   FUNCTION C_PERCENT_TOTAL_EXCEPTIONS_P RETURN NUMBER;
871 
872   FUNCTION C_PERCENT_TOTAL_EXCEPTIONS_DL RETURN NUMBER;
873 
874   FUNCTION C_PERCENT_TOTAL_CHECKS_P RETURN NUMBER;
875 
876   FUNCTION C_PERCENT_TOTAL_CHECKS_DLR_P RETURN NUMBER;
877 
878   FUNCTION C_NLS_NA_P RETURN VARCHAR2;
879 
880   FUNCTION C_PRIOR_PERIOD_EXISTS_P RETURN VARCHAR2;
881 
882   FUNCTION C_NLS_END_OF_REPORT_P RETURN VARCHAR2;
883 
884   FUNCTION C_PRIOR_OLD_VENDOR_SITES_P RETURN NUMBER;
885 
886   FUNCTION C_PERCENT_ADDITIONAL_SITES_P RETURN NUMBER;
887 
888   FUNCTION C_TOTAL_ADDITIONAL_SITES_P RETURN NUMBER;
889 
890   FUNCTION C_PRIOR_VENDORS_UPDATED_P RETURN NUMBER;
891 
892   FUNCTION C_PRIOR_SITES_UPDATED_P RETURN NUMBER;
893 
894   FUNCTION C_PERCENT_VENDORS_UPDATED_P RETURN NUMBER;
895 
896   FUNCTION C_PERCENT_SITES_UPDATED_P RETURN NUMBER;
897 
898   FUNCTION C_TOTAL_VENDORS_UPDATED_P RETURN NUMBER;
899 
900   FUNCTION C_TOTAL_SITES_UPDATED_P RETURN NUMBER;
901 
902   FUNCTION C_SYSTEM_USER_NAME_P RETURN VARCHAR2;
903 
904   FUNCTION C_TOTAL_REFUND_CHECKS_P RETURN NUMBER;
905 
906   FUNCTION C_TOTAL_REFUND_CHECKS_DLR_P RETURN NUMBER;
907 
908   FUNCTION C_TOTAL_OUTSTANDING_DLR_P RETURN NUMBER;
909 
910   FUNCTION C_NEW_OUTSTANDING_DLR_P RETURN NUMBER;
911 
912   FUNCTION C_NEW_REFUND_PAYMENTS_P RETURN NUMBER;
913 
914   FUNCTION C_NEW_REFUND_PAYMENTS_DLR_P RETURN NUMBER;
915 
916   FUNCTION C_OLD_OUTSTANDING_DLR_P RETURN NUMBER;
917 
918   FUNCTION C_OLD_REFUND_PAYMENTS_P RETURN NUMBER;
919 
920   FUNCTION C_OLD_REFUND_PAYMENTS_DLR_P RETURN NUMBER;
921 
922   FUNCTION C_PERCENT_OUTSTANDING_DLR_P RETURN NUMBER;
923 
924   FUNCTION C_PERCENT_REFUND_CHECKS_P RETURN NUMBER;
925 
926   FUNCTION C_PERCENT_REFUND_CHECKS_DLR_P RETURN NUMBER;
927 
928   FUNCTION C_NEW_LINES_P RETURN NUMBER;
929 
930   FUNCTION C_OLD_LINES_P RETURN NUMBER;
931 
932   FUNCTION C_PERCENT_LINES_P RETURN NUMBER;
933 
934   FUNCTION C_TOTAL_LINES_P RETURN NUMBER;
935 
936   FUNCTION C_OLD_LINES_VAR_COUNT_P RETURN NUMBER;
937 
938   FUNCTION C_OLD_LINES_VAR_AMOUNT_P RETURN NUMBER;
939 
940   FUNCTION C_LINE_TOTAL_VARS_P RETURN NUMBER;
941 
942   FUNCTION C_LINE_TOTAL_VARS_DLR_P RETURN NUMBER;
943 
944   FUNCTION C_LINE_VAR_COUNT_P RETURN NUMBER;
945 
946   FUNCTION C_LINE_VAR_AMOUNT_P RETURN NUMBER;
947 
948   FUNCTION C_OLD_DISTS_VAR_COUNT_P RETURN NUMBER;
949 
950   FUNCTION C_OLD_DISTS_VAR_AMOUNT_P RETURN NUMBER;
951 
952   FUNCTION C_DIST_TOTAL_VARS_P RETURN NUMBER;
953 
954   FUNCTION C_DIST_TOTAL_VARS_DLR_P RETURN NUMBER;
955 
956   FUNCTION C_DIST_VAR_COUNT_P RETURN NUMBER;
957 
958   FUNCTION C_DIST_VAR_AMOUNT_P RETURN NUMBER;
959 
960   FUNCTION C_PERCENT_LINE_VARS_P RETURN NUMBER;
961 
962   FUNCTION C_PERCENT_DIST_VARS_P RETURN NUMBER;
963 
964   FUNCTION C_PERCENT_LINE_VARS_DLR_P RETURN NUMBER;
965 
966   FUNCTION C_PERCENT_DIST_VARS_DLR_P RETURN NUMBER;
967 
968   FUNCTION C_AVERAGE_DISTS_P RETURN NUMBER;
969 
970   FUNCTION C_ORG_ID_P RETURN NUMBER;
971 
972 END AP_APXKIRKI_XMLP_PKG;
973