[Home] [Help]
PACKAGE: APPS.AR_RAXSKI_XMLP_PKG
Source
1 PACKAGE AR_RAXSKI_XMLP_PKG AS
2 /* $Header: RAXSKIS.pls 120.0 2007/12/27 14:33:38 abraghun noship $ */
3 P_CONC_REQUEST_ID number;
4 P_Set_of_Books_Id number;
5 P_Start_Date date;
6 P_End_Date date;
7 P_Prior_Start_Date date;
8 P_Prior_End_Date date;
9 --lp_start_date varchar2(200);
10 lp_start_date varchar2(1200):=' ';
11 --lp_end_date varchar2(200);
12 lp_end_date varchar2(1200):=' ';
13 --lp_start_currency_code varchar2(200);
14 lp_start_currency_code varchar2(1200):=' ';
15 --lp_end_currency_code varchar2(200);
16 lp_end_currency_code varchar2(1200):= ' ';
17 P_Start_Currency_Code varchar2(32767);
18 P_End_Currency_Code varchar2(32767);
19 Current_Inv_Period number;
20 Prior_Inv_Period number;
21 P_Percent_Change number;
22 Current_Inv_Sum number;
23 Prior_Inv_Sum number;
24 A_Percent_Change number;
25 Inv_Sum_TF number;
26 Current_Period number;
27 Prior_Period number;
28 C_Percent_Change number;
29 Current_Sum number;
30 Prior_Sum number;
31 S_Percent_Change number;
32 All_Sum_CTF number;
33 RP_COMPANY_NAME varchar2(350);
34 RP_REPORT_NAME varchar2(380);
35 RP_DATA_FOUND varchar2(300);
36 RP_SUB_TITLE varchar2(380);
37 V_Addresses number;
38 Prior_V_Addresses number;
39 Address_Total_Number number;
40 V_Customers number;
41 Prior_V_Customers number;
42 Cust_Total_Number number;
43 V_Inactive_Count number;
44 Customer_Change varchar2(32767);
45 Address_Change varchar2(32767);
46 Prior_V_Inactive_Count number;
47 Inactive_Count_Total_Number number;
48 Inactive_Count_Change varchar2(32767);
49 function report_nameformula(Company_Name in varchar2) return varchar2 ;
50 function BeforeReport return boolean ;
51 function AfterPForm return boolean ;
52 function Sub_TitleFormula return VARCHAR2 ;
53 function Sel_CustomersFormula return Number ;
54 --function sel_invoicesformula(inv_type in number, invoice_currency_code in varchar2, inv_sum in number) return number ;
55 function sel_invoicesformula(inv_type in number, invoice_currency_code_t in varchar2, inv_sum in number) return number ;
56 --function sel_trxformula(reason in varchar2, invoice_currency_code in varchar2, all_sum in number) return number ;
57 function sel_trxformula(reason in varchar2, invoice_currency_code_t in varchar2, all_sum_t in number) return number ;
58 function CF_NO_REASONFormula return VARCHAR2 ;
59 function sum_p_percent_change1formula(sum_prior_inv_period in number, sum_current_inv_period in number) return number ;
60 function sum_c_percent_change1formula(sum_prior_period in number, sum_current_period in number) return number ;
61 function sum_a_percent_change1formula(sum_prior_inv_sum in number, sum_current_inv_sum in number) return number ;
62 function sum_s_percent_change1formula(sum_prior_sum in number, sum_current_sum in number) return number ;
63 function AfterReport return boolean ;
64 Function Current_Inv_Period_p return number;
65 Function Prior_Inv_Period_p return number;
66 Function P_Percent_Change_p return number;
67 Function Current_Inv_Sum_p return number;
68 Function Prior_Inv_Sum_p return number;
69 Function A_Percent_Change_p return number;
70 Function Inv_Sum_TF_p return number;
71 Function Current_Period_p return number;
72 Function Prior_Period_p return number;
73 Function C_Percent_Change_p return number;
74 Function Current_Sum_p return number;
75 Function Prior_Sum_p return number;
76 Function S_Percent_Change_p return number;
77 Function All_Sum_CTF_p return number;
78 Function RP_COMPANY_NAME_p return varchar2;
79 Function RP_REPORT_NAME_p return varchar2;
80 Function RP_DATA_FOUND_p return varchar2;
81 Function RP_SUB_TITLE_p return varchar2;
82 Function V_Addresses_p return number;
83 Function Prior_V_Addresses_p return number;
84 Function Address_Total_Number_p return number;
85 Function V_Customers_p return number;
86 Function Prior_V_Customers_p return number;
87 Function Cust_Total_Number_p return number;
88 Function V_Inactive_Count_p return number;
89 Function Customer_Change_p return varchar2;
90 Function Address_Change_p return varchar2;
91 Function Prior_V_Inactive_Count_p return number;
92 Function Inactive_Count_Total_Number_p return number;
93 Function Inactive_Count_Change_p return varchar2;
94 END AR_RAXSKI_XMLP_PKG;
95