1 PACKAGE ONT_OEXOEASR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: OEXOEASRS.pls 120.1 2007/12/25 07:13:30 npannamp noship $ */
3 P_CONC_REQUEST_ID NUMBER := 0;
4 P_SOB_ID NUMBER;
5 P_AGREEMENT_LOW VARCHAR2(50);
6 P_AGREEMENT_HIGH VARCHAR2(50);
7 P_AGREEMENT_TYPE VARCHAR2(30);
8 P_PURCHASE_NUM VARCHAR2(32767);
9 P_CUSTOMER_NAME_LOW VARCHAR2(360);
10 P_CUSTOMER_NAME_HIGH VARCHAR2(360);
11 P_USE_FUNCTIONAL_CURRENCY VARCHAR2(32767);
12 P_SALESPERSON VARCHAR2(30);
13 P_INTERFACE_LINE_CONTEXT VARCHAR2(50);
14 LP_AGREEMENT_RANGE VARCHAR2(200):='and 1=1';
15 LP_CUSTOMER_RANGE VARCHAR2(200) :='and 1=1';
16 LP_AGREEMENT_TYPE VARCHAR2(200) :='and 1=1';
17 LP_PURCHASE_NUM VARCHAR2(200) :='and 1=1';
18 LP_SALESPERSON VARCHAR2(200) :='and 1=1';
19 LP_AGREEMENT_TYPE_DSP VARCHAR2(1000);
20 P_ORDER_NUMBER_HIGH VARCHAR2(32767);
21 P_ORDER_NUMBER_LOW VARCHAR2(32767);
22 LP_ORDER_NUMBER_RANGE VARCHAR2(1000) :='and 1=1';
23 C_QTY_ORDERED NUMBER;
24 C_QTY_SHIPPED NUMBER;
25 C_QTY_SHIPPED_DSP VARCHAR2(13);
26 C_QTY_ORDERED_DSP VARCHAR2(13);
27 C_QTY_INVOICED_DSP VARCHAR2(13);
28 C_QTY_INVOICED NUMBER;
29 RP_REPORT_NAME VARCHAR2(240);
30 RP_SUB_TITLE VARCHAR2(80);
31 RP_COMPANY_NAME VARCHAR2(50);
32 RP_FUNCTIONAL_CURRENCY VARCHAR2(20);
33 RP_DATA_FOUND VARCHAR2(300);
34 RP_CUSTOMER_NAME_RANGE VARCHAR2(120);
35 RP_AGREEMENT_RANGE VARCHAR2(120);
36 RP_AGREEMENT_NAME_LOW VARCHAR2(50);
37 RP_AGREEMENT_NAME_HIGH VARCHAR2(50);
38 FUNCTION BEFOREREPORT RETURN BOOLEAN;
39 FUNCTION AFTERREPORT RETURN BOOLEAN;
40 FUNCTION P_SOB_IDVALIDTRIGGER RETURN BOOLEAN;
41 FUNCTION P_USE_FUNCTIONAL_CURRENCYVALID RETURN BOOLEAN;
42 FUNCTION P_INTERFACE_LINE_CONTEXTVALIDT RETURN BOOLEAN;
43 FUNCTION C_USE_CURRENCYFORMULA(CURRENCY2 IN VARCHAR2) RETURN VARCHAR2;
44 FUNCTION C_DATA_NOT_FOUNDFORMULA(CURRENCY2 IN VARCHAR2) RETURN NUMBER;
45 FUNCTION AFTERPFORM RETURN BOOLEAN;
46 FUNCTION RP_USE_FUNCTIONAL_CURRENCYFORM RETURN VARCHAR2;
47 FUNCTION BEFOREPFORM RETURN BOOLEAN;
48 FUNCTION C_QTY_ORDERED_P RETURN NUMBER;
49 FUNCTION C_QTY_SHIPPED_P RETURN NUMBER;
50 FUNCTION C_QTY_SHIPPED_DSP_P RETURN VARCHAR2;
51 FUNCTION C_QTY_ORDERED_DSP_P RETURN VARCHAR2;
52 FUNCTION C_QTY_INVOICED_DSP_P RETURN VARCHAR2;
53 FUNCTION C_QTY_INVOICED_P RETURN NUMBER;
54 FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
55 FUNCTION RP_SUB_TITLE_P RETURN VARCHAR2;
56 FUNCTION RP_COMPANY_NAME_P RETURN VARCHAR2;
57 FUNCTION RP_FUNCTIONAL_CURRENCY_P RETURN VARCHAR2;
58 FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
59 FUNCTION RP_CUSTOMER_NAME_RANGE_P RETURN VARCHAR2;
60 FUNCTION RP_AGREEMENT_RANGE_P RETURN VARCHAR2;
61 FUNCTION RP_AGREEMENT_NAME_LOW_P RETURN VARCHAR2;
62 FUNCTION RP_AGREEMENT_NAME_HIGH_P RETURN VARCHAR2;
63 FUNCTION IS_FIXED_RATE(X_FROM_CURRENCY IN VARCHAR2
64 ,X_TO_CURRENCY IN VARCHAR2
65 ,X_EFFECTIVE_DATE IN DATE) RETURN VARCHAR2;
66 /*PROCEDURE GET_RELATION(X_FROM_CURRENCY IN VARCHAR2
67 ,X_TO_CURRENCY IN VARCHAR2
68 ,X_EFFECTIVE_DATE IN DATE
69 ,X_FIXED_RATE IN OUT NOCOPY BOOLEAN
70 ,X_RELATIONSHIP IN OUT NOCOPY VARCHAR2);*/
71 FUNCTION GET_EURO_CODE RETURN VARCHAR2;
72 FUNCTION GET_RATE(X_FROM_CURRENCY IN VARCHAR2
73 ,X_TO_CURRENCY IN VARCHAR2
74 ,X_CONVERSION_DATE IN DATE
75 ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
76 FUNCTION GET_RATE(X_SET_OF_BOOKS_ID IN NUMBER
77 ,X_FROM_CURRENCY IN VARCHAR2
78 ,X_CONVERSION_DATE IN DATE
79 ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER;
80 FUNCTION CONVERT_AMOUNT(X_FROM_CURRENCY IN VARCHAR2
81 ,X_TO_CURRENCY IN VARCHAR2
82 ,X_CONVERSION_DATE IN DATE
83 ,X_CONVERSION_TYPE IN VARCHAR2
84 ,X_AMOUNT IN NUMBER) RETURN NUMBER;
85 FUNCTION CONVERT_AMOUNT(X_SET_OF_BOOKS_ID IN NUMBER
86 ,X_FROM_CURRENCY IN VARCHAR2
87 ,X_CONVERSION_DATE IN DATE
88 ,X_CONVERSION_TYPE IN VARCHAR2
89 ,X_AMOUNT IN NUMBER) RETURN NUMBER;
90 FUNCTION GET_DERIVE_TYPE(SOB_ID IN NUMBER
91 ,PERIOD IN VARCHAR2
92 ,CURR_CODE IN VARCHAR2) RETURN VARCHAR2;
93 --added
94 function C_CONVERT_AMOUNTFormula(p_use_functional_currency in varchar2,qty_ordered in number ,qty_invoiced in number ,qty_shipped in number ,
95 currency2 IN VARCHAR2,rp_functional_currency IN VARCHAR2,conversion_rate in number,p_sob_id in number
96 ,order_date in date,conversion_type_code in varchar2) return Number;
97 END ONT_OEXOEASR_XMLP_PKG;
98