[Home] [Help]
PACKAGE: APPS.AR_ARXREV_XMLP_PKG
Source
1 PACKAGE AR_ARXREV_XMLP_PKG AS
2 /* $Header: ARXREVS.pls 120.0 2007/12/27 14:05:47 abraghun noship $ */
3 P_CONC_REQUEST_ID number;
4 P_REV_GL_START_DATE date;
5 P_REV_GL_END_DATE date;
6 P_REV_GL_START_DATE1 varchar2(10);
7 P_REV_GL_END_DATE1 varchar2(10);
8 P_CURR_LOW varchar2(32767);
9 P_CURR_HIGH varchar2(32767);
10 P_BANK_ACCOUNT_LOW varchar2(100);
11 P_BANK_ACCOUNT_HIGH varchar2(100);
12 lp_curr_high varchar2(600) := ' ';
13 lp_curr_low varchar2(500) := ' ';
14 lp_bank_account_low varchar2(500) := ' ';
15 lp_rev_gl_start_date_dm varchar2(500) := ' ';
16 lp_rev_gl_start_date varchar2(600) := ' ';
17 lp_rev_gl_end_date varchar2(500) := ' ';
18 P_ORDER_BY varchar2(50);
19 lp_rev_gl_end_date_dm varchar2(600) := ' ';
20 CURRENCY1 varchar2(40);
21 CURRENCY2 varchar2(40);
22 l_order_rpt_by varchar2(10);
23 P_CUST_LOW varchar2(32767);
24 P_CUST_HIGH varchar2(32767);
25 lp_customer_low varchar2(300) := ' ';
26 lp_customer_high varchar2(300) := ' ';
27 lp_reason varchar2(300) := ' ';
28 P_REASON varchar2(30);
29 lp_bank_account_high varchar2(500) := ' ';
30 c_cash_amt_func number := 0 ;
31 c_cash_amt number := 0 ;
32 c_misc_amt_func number := 0 ;
33 c_misc_amt number := 0 ;
34 c_nsf_amt_func number := 0 ;
35 c_nsf_amt number := 0 ;
36 c_rev_amt_func number;
37 c_rev_amt number := 0 ;
38 c_stop_amt_func number := 0 ;
39 c_stop_amt number := 0 ;
40 c_cash_dm_amt_func number;
41 c_misc_dm_amt_func number;
42 c_nsf_dm_amt_func number;
43 c_rev_dm_amt_func number;
44 c_stop_dm_amt_func number;
45 c_cash_dm_amt number;
46 c_misc_dm_amt number;
47 c_nsf_dm_amt number;
48 c_rev_dm_amt number := 0 ;
49 c_stop_dm_amt number := 0 ;
50 RP_COMPANY_NAME varchar2(50);
51 RP_REPORT_NAME varchar2(80);
52 RP_DATA_FOUND varchar2(300);
53 RP_DATE_RANGE varchar2(2100);
54 RP_SUB_TITLE varchar2(100);
55 RP_DATA_FOUND_DM varchar2(100);
56 RP_CUST_DATA_FOUND varchar2(32767);
57 RP_CUST_DATA_FOUND_DM varchar2(32767);
58 RPD_FUNC_AMT varchar2(16);
59 RPD_CASH_AMT_FUNC varchar2(16);
60 RPD_MISC_AMT_FUNC varchar2(16);
61 RPD_NSF_AMT_FUNC varchar2(16);
62 RPD_REV_AMT_FUNC varchar2(16);
63 RPD_STOP_AMT_FUNC varchar2(16);
64 RPD_FUNC_DM_AMT varchar2(16);
65 RPD_CASH_DM_AMT_FUNC varchar2(16);
66 RPD_MISC_DM_AMT_FUNC varchar2(16);
67 RPD_NSF_DM_AMT_FUNC varchar2(16);
68 RPD_REV_DM_AMT_FUNC varchar2(16);
69 RPD_STOP_DM_AMT_FUNC varchar2(16);
70 RPD_CUST_FUNC varchar2(16);
71 RPD_DM_CUST_FUNC varchar2(16);
72 rp_none varchar2(2100);
73 rp_sum_for varchar2(2100);
74 function BeforeReport return boolean ;
75 function AfterReport return boolean ;
76 function report_nameformula(Company_Name in varchar2) return varchar2 ;
77 function AfterPForm return boolean ;
78 function c_calc_amountformula(r_type in varchar2, amount in number, functional_amount in number, reversal_category in varchar2) return number ;
79 function c_summary_label_bankformula(bank_name in varchar2) return varchar2 ;
80 function c_dm_calc_amountformula(rev_type in varchar2, Amount_B in number, functional_Amount_B in number, Reversal_category_B in varchar2) return number ;
81 function c_summary_label_bank_dmformula(Bank_name_b in varchar2) return varchar2 ;
82 function c_qcd_summary_label_custformul(QCD_DUMMY_NAME in varchar2) return varchar2 ;
83 function c_qcr_summary_label_custformul(QCR_DUMMY_NAME in varchar2) return varchar2 ;
84 Function c_cash_amt_func_p return number;
85 Function c_cash_amt_p return number;
86 Function c_misc_amt_func_p return number;
87 Function c_misc_amt_p return number;
88 Function c_nsf_amt_func_p return number;
89 Function c_nsf_amt_p return number;
90 Function c_rev_amt_func_p return number;
91 Function c_rev_amt_p return number;
92 Function c_stop_amt_func_p return number;
93 Function c_stop_amt_p return number;
94 Function c_cash_dm_amt_func_p return number;
95 Function c_misc_dm_amt_func_p return number;
96 Function c_nsf_dm_amt_func_p return number;
97 Function c_rev_dm_amt_func_p return number;
98 Function c_stop_dm_amt_func_p return number;
99 Function c_cash_dm_amt_p return number;
100 Function c_misc_dm_amt_p return number;
101 Function c_nsf_dm_amt_p return number;
102 Function c_rev_dm_amt_p return number;
103 Function c_stop_dm_amt_p return number;
104 Function RP_COMPANY_NAME_p return varchar2;
105 Function RP_REPORT_NAME_p return varchar2;
106 Function RP_DATA_FOUND_p return varchar2;
107 Function RP_DATE_RANGE_p return varchar2;
108 Function RP_SUB_TITLE_p return varchar2;
109 Function RP_DATA_FOUND_DM_p return varchar2;
110 Function RP_CUST_DATA_FOUND_p return varchar2;
111 Function RP_CUST_DATA_FOUND_DM_p return varchar2;
112 Function RPD_FUNC_AMT_p return varchar2;
113 Function RPD_CASH_AMT_FUNC_p return varchar2;
114 Function RPD_MISC_AMT_FUNC_p return varchar2;
115 Function RPD_NSF_AMT_FUNC_p return varchar2;
116 Function RPD_REV_AMT_FUNC_p return varchar2;
117 Function RPD_STOP_AMT_FUNC_p return varchar2;
118 Function RPD_FUNC_DM_AMT_p return varchar2;
119 Function RPD_CASH_DM_AMT_FUNC_p return varchar2;
120 Function RPD_MISC_DM_AMT_FUNC_p return varchar2;
121 Function RPD_NSF_DM_AMT_FUNC_p return varchar2;
122 Function RPD_REV_DM_AMT_FUNC_p return varchar2;
123 Function RPD_STOP_DM_AMT_FUNC_p return varchar2;
124 Function RPD_CUST_FUNC_p return varchar2;
125 Function RPD_DM_CUST_FUNC_p return varchar2;
126 Function rp_none_p return varchar2;
127 Function rp_sum_for_p return varchar2;
128 END AR_ARXREV_XMLP_PKG;
129