PACKAGE: APPS.AR_ARXFXGL_XMLP_PKG

Source

1 PACKAGE AR_ARXFXGL_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARXFXGLS.pls 120.0 2007/12/27 13:51:42 abraghun noship $ */
3 	P_Customer_Id	number;
4 	P_Site_Use_Id	number;
5 	P_From_Receipt_Date	date;
6 	P_To_Receipt_Date	date;
7 	P_Receipt_Currency	varchar2(15);
8 	P_Rate_Type	varchar2(30);
9 	P_Conc_Request_Id	number;
10 	P_Set_Of_Books_Id	number;
11 	P_Customer_Number	varchar2(30);
12 	P_Customer_Name	varchar2(50);
13 	Where_Customer	varchar2(60) :=  'AND 1 = 1' ;
14 	P_Location	varchar2(40);
15 	Where_Location	varchar2(60) :=  'AND 1 = 1' ;
16 	Where_Date	varchar2(85) :=  'AND 1 = 1' ;
17 	Where_Currency	varchar2(60) :=  'AND 1 = 1' ;
18 	P_Exchange_Rate_Type	varchar2(30);
19 	Report_Name	varchar2(2000);
20 	Functional_Currency	varchar2(15);
21 	Set_Of_Books_Name	varchar2(30);
22 	Functional_Precision	number;
23 	function BeforeReport return boolean  ;
24 	PROCEDURE Build_Customer_Details  ;
25 	PROCEDURE Build_Location_Details  ;
26 	PROCEDURE Build_Rate_Type_Details  ;
27 	PROCEDURE BUILD_RECEIPT_DATE_DETAILS  ;
28 	PROCEDURE BUILD_CURRENCY_DETAILS  ;
29 	function cf_gain_loss_actualfo(Actual_Alloc_Receipt_Amt_Base in number, Trx_Amt_Applied_Base in number) return number  ;
30 	--function allocated_amount_rateformula(Rate_Sys_Curr_Rate in number) return number  ;
31 	function allocated_amount_rateformula(Trx_Amt_Applied IN NUMBER,Receipt_Precision IN NUMBER,Rate_Sys_Curr_Rate in number) return number;
32 	--function Sys_Cross_CurrencyFormula return Number  ;
33 	function Sys_Cross_CurrencyFormula(Trx_Currency IN VARCHAR2,Receipt_Currency IN VARCHAR2,Receipt_Date IN DATE) return Number;
34 	--function rate_alloc_receipt_amt_basefor(Rate_Sys_Curr_Rate in number) return number  ;
35 	function rate_alloc_receipt_amt_basefor(Rate_Sys_Curr_Rate in number,Rate_Alloc_Receipt_Amt IN NUMBER,Receipt_Exchange_Rate IN NUMBER) return number;
36 	function rate_gain_lossformula(Rate_Alloc_Receipt_Amt_Base in number, Trx_Amt_Applied_Base in number) return number  ;
37 	function absolute_differenceformula(Actual_Gain_Loss in number, Rate_Gain_Loss in number) return number  ;
38 	function actual_gainformula(Actual_Gain_Loss in number) return number  ;
39 	function actual_rate_lossformula(Actual_Gain_Loss in number) return number  ;
40 	function rate_gainformula(Rate_Gain_Loss in number) return number  ;
41 	function rate_lossformula(Rate_Gain_Loss in number) return number  ;
42 	PROCEDURE Get_Report_Name  ;
43 	PROCEDURE Get_SOB_Details  ;
44 	function rate_sys_curr_rate_dformula(Rate_Sys_Curr_Rate in number) return number  ;
45 	function actual_cross_curr_rate_dformul(Actual_Cross_Curr_Rate in number) return number  ;
46 	function AfterReport return boolean  ;
47 	Function P_Customer_Number_p return varchar2;
48 	Function P_Customer_Name_p return varchar2;
49 	Function Where_Customer_p return varchar2;
50 	Function P_Location_p return varchar2;
51 	Function Where_Location_p return varchar2;
52 	Function Where_Date_p return varchar2;
53 	Function Where_Currency_p return varchar2;
54 	Function P_Exchange_Rate_Type_p return varchar2;
55 	Function Report_Name_p return varchar2;
56 	Function Functional_Currency_p return varchar2;
57 	Function Set_Of_Books_Name_p return varchar2;
58 	Function Functional_Precision_p return number;
59 END AR_ARXFXGL_XMLP_PKG;
60