[Home] [Help]
PACKAGE: APPS.XTR_XTRCCYGL_XMLP_PKG
Source
1 PACKAGE XTR_XTRCCYGL_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTRCCYGLS.pls 120.1 2007/12/28 12:43:17 npannamp noship $ */
3 P_GROUPBY VARCHAR2(40);
4
5 P_REALIZED_FLAG VARCHAR2(40);
6 P_REALIZED_FLAG_T VARCHAR2(40);
7 P_BATCH_ID_FROM NUMBER;
8
9 P_BATCH_ID_TO NUMBER;
10
11 P_DATE_FROM VARCHAR2(32767);
12 P_DATE_FROM_T VARCHAR2(32767);
13 P_DATE_TO VARCHAR2(32767);
14 P_DATE_TO_T VARCHAR2(32767);
15 P_CURRENCY VARCHAR2(40);
16
17 P_DEAL_TYPE VARCHAR2(40);
18
19 P_PORTFOLIO VARCHAR2(40);
20
21 P_COMPANY VARCHAR2(40);
22
23 P_CONC_REQUEST_ID NUMBER;
24
25 P_SQL_TRACE NUMBER;
26
27 Z2COMPANY VARCHAR2(300);
28
29 Z2PORTFOLIO VARCHAR2(300);
30
31 Z2DEAL_TYPE VARCHAR2(300);
32
33 Z2DEAL_SUBTYPE VARCHAR2(300);
34
35 Z2PRODUCT_TYPE VARCHAR2(300);
36
37 Z2REFERENCE VARCHAR2(300);
38
39 Z2PRDEND VARCHAR2(300);
40
41 Z2BUY VARCHAR2(300);
42
43 Z2SELL VARCHAR2(300);
44
45 Z2REPORT_PRD VARCHAR2(300);
46
47 Z2REVAL_CCY VARCHAR2(300);
48
49 Z2CCY VARCHAR2(300);
50
51 Z2AMOUNT VARCHAR2(300);
52
53 Z2TRANS VARCHAR2(300);
54
55 Z2BEGIN VARCHAR2(300);
56
57 Z2END VARCHAR2(300);
58
59 Z2TOTAL VARCHAR2(300);
60
61 Z2FAIR_VALUE VARCHAR2(300);
62
63 Z2GAIN_LOSS VARCHAR2(300);
64
65 P_FACTOR VARCHAR2(32767);
66
67 P_UNIT NUMBER := 1;
68
69 P_PRODUCT_TYPE VARCHAR2(40);
70
71 Z2REALIZED_FLAG VARCHAR2(300);
72
73 Z2END_OF_REPORT VARCHAR2(300);
74
75 Z2NO_DATA_FOUND VARCHAR2(300);
76
77 Z1FACTOR VARCHAR2(300);
78
79 Z1REAL_UNREAL VARCHAR2(300);
80
81 Z1DATE_FROM VARCHAR2(300);
82
83 Z1DATE_TO VARCHAR2(300);
84
85 Z1BATCH_ID_FROM VARCHAR2(300);
86
87 Z1BATCH_ID_TO VARCHAR2(300);
88
89 Z1PARA_GROUPING VARCHAR2(500);
90
91 P_USER_DEAL_TYPE VARCHAR2(30);
92
93 P_USER_DEAL_SUBTYPE VARCHAR2(30);
94
95 P_USER_COMPANY VARCHAR2(30);
96
97 P_USER_FACTOR VARCHAR2(32767);
98
99 P_USER_GROUPBY VARCHAR2(50);
100
101 Z2START VARCHAR2(300);
102
103 Z2GL_RATE VARCHAR2(300);
104
105 Z2SOB_CCY VARCHAR2(300);
106
107 P_USER_DATE_FROM VARCHAR2(32767);
108
109 P_USER_DATE_TO VARCHAR2(32767);
110
111 Z2CCY_SHT VARCHAR2(80);
112
113 Z2PERIOD VARCHAR2(300);
114
115 Z1REPHEAD_REAL VARCHAR2(1000);
116
117 Z1REPHEAD_UNREAL VARCHAR2(1000);
118
119 FUNCTION AFTERPFORM RETURN BOOLEAN;
120
121 FUNCTION BEFOREREPORT RETURN BOOLEAN;
122
123 FUNCTION AFTERREPORT RETURN BOOLEAN;
124
125 FUNCTION C_DATEFORMATFORMULA(C_DATEFORMAT IN VARCHAR2) RETURN CHAR;
126
127 FUNCTION CO_SHT_NAMEFORMULA(COMPANY IN VARCHAR2) RETURN CHAR;
128
129 FUNCTION C_REPORT_NAMEFORMULA RETURN CHAR;
130
131 FUNCTION USER_DEAL_SUBTYPEFORMULA(DEAL_SUBTYPE_P IN VARCHAR2
132 ,DEAL_TYPE_P IN VARCHAR2) RETURN CHAR;
133
134 FUNCTION USER_DEAL_TYPEFORMULA(DEAL_TYPE_P IN VARCHAR2) RETURN CHAR;
135
136 FUNCTION FAIR_VALUEFORMULA(COMPANY_P IN VARCHAR2
137 ,REF_NUMBER_P IN VARCHAR2
138 ,PERIOD_END_P IN DATE
139 ,BATCH_ID_P IN NUMBER
140 ,DEAL_TYPE IN VARCHAR2) RETURN NUMBER;
141
142 FUNCTION BEGIN_RATEFORMULA(COMPANY IN VARCHAR2
143 ,REF_NUMBER_p IN VARCHAR2
144 ,PERIOD_START_P IN DATE
145 ,DEAL_TYPE IN VARCHAR2) RETURN NUMBER;
146
147 FUNCTION END_RATEFORMULA(COMPANY_P IN VARCHAR2
148 ,REF_NUMBER_p IN VARCHAR2
149 ,PERIOD_END_p IN DATE
150 ,DEAL_TYPE IN VARCHAR2) RETURN NUMBER;
151
152 FUNCTION REPORT_PRDFORMULA(C_DATEFORMAT IN VARCHAR2) RETURN CHAR;
153
154 FUNCTION SOB_CCYFORMULA(COMPANY IN VARCHAR2) RETURN CHAR;
155
156 FUNCTION FAIR_VALUE_RNDFORMULA(REVAL_CCY IN VARCHAR2
157 ,FAIR_VALUE IN NUMBER) RETURN NUMBER;
158
159 FUNCTION GAIN_LOSS_RNDFORMULA(REVAL_CCY IN VARCHAR2
160 ,GAIN_LOSS IN NUMBER) RETURN NUMBER;
161
162 FUNCTION BASE_AMT_RNDFORMULA(REVAL_CCY IN VARCHAR2
163 ,BASE_AMOUNT IN NUMBER) RETURN NUMBER;
164
165 END XTR_XTRCCYGL_XMLP_PKG;
166