PACKAGE: APPS.XTR_XTRFXAVG_XMLP_PKG

Source

1 PACKAGE XTR_XTRFXAVG_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTRFXAVGS.pls 120.1 2007/12/28 12:48:19 npannamp noship $ */
3   REPORT_SHORT_NAME VARCHAR2(240);
4 
5 
6   CURRENCY_A2 VARCHAR2(15) := '%';
7 
8   CURRENCY_B2 VARCHAR2(15);
9 
10   SHOW_DETAILS VARCHAR2(40);
11 
12   Z2BASE_BUY_AMT VARCHAR2(100);
13 
14   Z2BUY_CCY VARCHAR2(100);
15 
16   Z2BASE_NET_AMT VARCHAR2(100);
17 
18   Z2SELL_CCY VARCHAR2(100);
19 
20   Z2END_OF_REPORT VARCHAR2(100);
21 
22   Z2BUY_AMT VARCHAR2(100);
23 
24   Z2SELL_AMT VARCHAR2(100);
25 
26   Z2CONTRA_NET_AMT VARCHAR2(100);
27 
28   Z1PARAMETERS VARCHAR2(300);
29 
30   Z1CONTRACTS VARCHAR2(300);
31 
32   Z1NOTE_ALL_AMOUNTS VARCHAR2(300);
33 
34   Z1BETWEEN VARCHAR2(300);
35 
36   Z1AND VARCHAR2(300);
37 
38   Z1REF_CCY VARCHAR2(300);
39 
40   Z1COUNTER_CCY VARCHAR2(300);
41 
42   Z1SHOW_TRANSACTIONS VARCHAR2(300);
43 
44   Z2CURRENCY VARCHAR2(100);
45 
46   Z2BASE_CCY VARCHAR2(100);
47 
48   Z2CONTRA_SALES_AMT VARCHAR2(100);
49 
50   Z2AVG_RATE VARCHAR2(100);
51 
52   Z2DEAL_NOS VARCHAR2(100);
53 
54   Z2TRANS_DATE VARCHAR2(100);
55 
56   Z2VALUE_DATE VARCHAR2(100);
57 
58   Z2CPARTY VARCHAR2(100);
59 
60   Z2BASE_SALES_AMT VARCHAR2(100);
61 
62   Z2CONTRA_BUY_AMT VARCHAR2(100);
63 
64   Z2RATE VARCHAR2(100);
65 
66   Z2PAGE VARCHAR2(100);
67 
68   SHOW_DETAILS2 VARCHAR2(40) := 'Y';
69 
70   MATURING_FROM2 DATE;
71 
72   MATURING_TO2 DATE;
73 
74   DATE_BASE2 VARCHAR2(240);
75 
76   P_CONC_REQUEST_ID NUMBER;
77 
78   COMPANY_NAME_HEADER VARCHAR2(80);
79 
80   P_SQL_TRACE VARCHAR2(32767);
81 
82   P_DISPLAY_DEBUG VARCHAR2(32767);
83 
84   P_REFERENCE_DATE_FROM VARCHAR2(32767);
85   P_REFERENCE_DATE_FROM_1 VARCHAR2(32767);
86 
87   P_REFERENCE_DATE_TO VARCHAR2(32767);
88   P_REFERENCE_DATE_TO_1 VARCHAR2(32767);
89 
90   P_REFERENCE_CURRENCY VARCHAR2(32767);
91 
92   P_COUNTER_CURRENCY VARCHAR2(32767);
93 
94   P_SHOW_CONTRACTS VARCHAR2(32767);
95 
96   P_COMPANY VARCHAR2(40);
97 
98   P_DATE_TYPE VARCHAR2(32767);
99 
100   REPORT_DATE VARCHAR2(100);
101 
102   Z1COMPANY VARCHAR2(300);
103 
104   P_FACTOR VARCHAR2(10);
105 
106   AMT_UNIT2 NUMBER;
107 
108   LP_FACTOR_DESC VARCHAR2(32767);
109 
110   Z1P_FACTOR VARCHAR2(100);
111 
112   Z2AVG_RATE_SELL VARCHAR2(100);
113 
114   Z2AVG_RATE_CROSS VARCHAR2(100);
115 
116   BASE_NET_AMT NUMBER;
117 
118   CONTRA_NET_AMT NUMBER;
119 
120   AVG_RATE3 NUMBER;
121 
122   CP_PARA VARCHAR2(30);
123 
124   FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
125 
126   FUNCTION BEFOREREPORT RETURN BOOLEAN;
127 
128   FUNCTION AVG_RATE1FORMULA(BASE_BUY_AMT IN NUMBER
129                            ,CONTRA_SALES_AMT IN NUMBER) RETURN NUMBER;
130 
131   FUNCTION AVG_RATE2FORMULA(BASE_SALES_AMT IN NUMBER
132                            ,CONTRA_BUY_AMT IN NUMBER) RETURN NUMBER;
133 
134   FUNCTION CALCFORMULA(BASE_BUY_AMT IN NUMBER
135                       ,BASE_SALES_AMT IN NUMBER
136                       ,CONTRA_BUY_AMT IN NUMBER
137                       ,CONTRA_SALES_AMT IN NUMBER) RETURN VARCHAR2;
138 
139   FUNCTION AFTERPFORM RETURN BOOLEAN;
140 
141   FUNCTION AFTERREPORT RETURN BOOLEAN;
142 
143   FUNCTION DATA_BASE_ON_MDFORMULA RETURN VARCHAR2;
144 
145   FUNCTION BASE_NET_AMT_P RETURN NUMBER;
146 
147   FUNCTION CONTRA_NET_AMT_P RETURN NUMBER;
148 
149   FUNCTION AVG_RATE3_P RETURN NUMBER;
150 
151   FUNCTION CP_PARA_P RETURN VARCHAR2;
152 
153 END XTR_XTRFXAVG_XMLP_PKG;
154 
155