[Home] [Help]
PACKAGE: APPS.AR_ARXSOC2_XMLP_PKG
Source
1 PACKAGE AR_ARXSOC2_XMLP_PKG AS
2 /* $Header: ARXSOC2S.pls 120.0 2007/12/27 14:08:46 abraghun noship $ */
3 P_CONC_REQUEST_ID number;
4 P_DATE_LOW date;
5 P_DATE_HIGH date;
6 P_DATE_LOW1 varchar2(10);
7 P_DATE_HIGH1 varchar2(10);
8 P_BANK_ACCOUNT_NAME_LOW varchar2(80);
9 P_BANK_ACCOUNT_NAME_HIGH varchar2(80);
10 P_ORDER_BY varchar2(32767);
11 P_ORDER_BY_1 varchar2(32767);
12 P_SET_OF_BOOKS_ID number;
13 lp_bank_account_name_low varchar2(800):=' ';
14 lp_bank_account_name_high varchar2(800):=' ';
15 lp_date_low varchar2(200):=' ';
16 lp_date_high varchar2(200):=' ';
17 P_BANK_COUNT number:=0;
18 PH_ORDER_BY varchar2(32767);
19 p_actual_amount number;
20 p_unidentified_amount number;
21 p_misc_amount number;
22 p_nsf_amount number;
23 p_applied_count number;
24 p_unapplied_count number;
25 p_misc_count number;
26 pa_actual_amount number;
27 pa_unidentified_amount number;
28 pa_misc_amount number;
29 pa_nsf_amount number;
30 pa_applied_count number;
31 pa_unapplied_count number;
32 pa_misc_count number;
33 RP_COMPANY_NAME varchar2(50);
34 RP_REPORT_NAME varchar2(80);
35 RP_DATA_FOUND3 varchar2(300);
36 RP_DATE_RANGE varchar2(150);
37 RP_DATA_FOUND1 varchar2(300);
38 RP_DATA_FOUND2 varchar2(300);
39 RP_ORDER_BY varchar2(80);
40 function BeforeReport return boolean ;
41 function AfterReport return boolean ;
42 function report_nameformula(Company_Name in varchar2) return varchar2 ;
43 function c_difference_amountformula(c_rcpt_control_amount in number, c_actual_amount in number) return number ;
44 function c_summary_labelformula(Currency_A in varchar2) return varchar2 ;
45 function ca_difference_amountformula(c_rcpt_control_amount_B in number, ca_actual_amount in number) return number ;
46 function ca_summary_labelformula(Currency_B in varchar2) return varchar2 ;
47 function cf_data_not_foundformula(bank_account_name_C in varchar2) return number ;
48 function cr_data_foundformula(Currency_B in varchar2) return number ;
49 function cm_data_not_foundformula(Currency_A in varchar2) return number ;
50 function AfterPForm return boolean ;
51 function f_amountsformula(cr_status in varchar2, amount in number, cr_type in varchar2, reversal_category in varchar2, cash_receipt_id in number) return number ;
52 function c_unapplied_amountformula(c_unapplied_amount_A in number, c_on_account_amount in number, c_unidentified_amount in number) return number ;
53 function f_all_amountsformula(cr_status_BB in varchar2, amount_B in number, cr_type_B in varchar2, reversal_category_B in varchar2, cash_receipt_id_B in number) return number ;
54 function ca_unapplied_amountformula(ca_unapplied_amount_B in number, ca_on_account_amount in number, ca_unidentified_amount in number) return number ;
55 function Order_By_MeaningFormula return VARCHAR2 ;
56 Function p_actual_amount_p return number;
57 Function p_unidentified_amount_p return number;
58 Function p_misc_amount_p return number;
59 Function p_nsf_amount_p return number;
60 Function p_applied_count_p return number;
61 Function p_unapplied_count_p return number;
62 Function p_misc_count_p return number;
63 Function pa_actual_amount_p return number;
64 Function pa_unidentified_amount_p return number;
65 Function pa_misc_amount_p return number;
66 Function pa_nsf_amount_p return number;
67 Function pa_applied_count_p return number;
68 Function pa_unapplied_count_p return number;
69 Function pa_misc_count_p return number;
70 Function RP_COMPANY_NAME_p return varchar2;
71 Function RP_REPORT_NAME_p return varchar2;
72 Function RP_DATA_FOUND3_p return varchar2;
73 Function RP_DATE_RANGE_p return varchar2;
74 Function RP_DATA_FOUND1_p return varchar2;
75 Function RP_DATA_FOUND2_p return varchar2;
76 Function RP_ORDER_BY_p return varchar2;
77 END AR_ARXSOC2_XMLP_PKG;
78