PACKAGE: APPS.XTR_XTRREVGL_XMLP_PKG

Source

1 PACKAGE XTR_XTRREVGL_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTRREVGLS.pls 120.1 2007/12/28 12:59:05 npannamp noship $ */
3   P_GROUPBY VARCHAR2(40);
4 
5   P_REALIZED_FLAG VARCHAR2(40);
6 
7   LP_REALIZED_FLAG VARCHAR2(40);
8 
9   P_BATCH_ID_FROM NUMBER;
10 
11   P_BATCH_ID_TO NUMBER;
12 
13   P_DATE_FROM VARCHAR2(32767);
14 
15   P_DATE_TO VARCHAR2(32767);
16 
17   P_CURRENCY VARCHAR2(40);
18 
19   P_DEAL_TYPE VARCHAR2(40);
20 
21   P_PORTFOLIO VARCHAR2(40);
22 
23   P_COMPANY VARCHAR2(40);
24 
25   P_CONC_REQUEST_ID NUMBER;
26 
27   P_SQL_TRACE NUMBER;
28 
29   Z2COMPANY VARCHAR2(300);
30 
31   Z2PORTFOLIO VARCHAR2(300);
32 
33   Z2DEAL_TYPE VARCHAR2(300);
34 
35   Z2DEAL_SUBTYPE VARCHAR2(300);
36 
37   Z2PRODUCT_TYPE VARCHAR2(300);
38 
39   Z2REFERENCE VARCHAR2(300);
40 
41   Z2DEAL_ENDDATE VARCHAR2(300);
42 
43   Z2BUY VARCHAR2(300);
44 
45   Z2SELL VARCHAR2(300);
46 
47   Z2REVAL_PRD VARCHAR2(300);
48 
49   Z2REVAL_CCY VARCHAR2(300);
50 
51   Z2CCY VARCHAR2(300);
52 
53   Z2AMOUNT VARCHAR2(300);
54 
55   Z2TRANS VARCHAR2(300);
56 
57   Z2BEGIN VARCHAR2(300);
58 
59   Z2END VARCHAR2(300);
60 
61   Z2TOTAL VARCHAR2(300);
62 
63   Z2FAIR_VALUE VARCHAR2(300);
64 
65   Z2GAIN_LOSS VARCHAR2(300);
66 
67   P_FACTOR VARCHAR2(32767);
68 
69   P_UNIT NUMBER := 1;
70 
71   P_PRODUCT_TYPE VARCHAR2(40);
72 
73   Z2REALIZED_FLAG VARCHAR2(300);
74 
75   Z2END_OF_REPORT VARCHAR2(300);
76 
77   Z2NO_DATA_FOUND VARCHAR2(300);
78 
79   Z1FACTOR VARCHAR2(300);
80 
81   Z1REAL_UNREAL VARCHAR2(300);
82 
83   Z1DATE_FROM VARCHAR2(300);
84 
85   Z1DATE_TO VARCHAR2(300);
86 
87   Z1BATCH_ID_FROM VARCHAR2(300);
88 
89   Z1BATCH_ID_TO VARCHAR2(300);
90 
91   Z1PARA_GROUPING VARCHAR2(500);
92 
93   P_USER_DEAL_TYPE VARCHAR2(30);
94 
95   P_USER_DEAL_SUBTYPE VARCHAR2(80);
96 
97   P_USER_COMPANY VARCHAR2(30);
98 
99   P_USER_FACTOR VARCHAR2(240);
100 
101   P_USER_GROUPBY VARCHAR2(240);
102 
103   P_USER_DATE_FROM VARCHAR2(32767);
104 
105   P_USER_DATE_TO VARCHAR2(32767);
106 
107   Z2CCY_SHT VARCHAR2(300);
108 
109   Z1REPHEAD_REAL VARCHAR2(1000);
110 
111   Z1REPHEAD_UNREAL VARCHAR2(1000);
112 
113   FUNCTION BEGIN_FVFORMULA(COMPANY IN VARCHAR2
114                           ,REF_NUMBER IN VARCHAR2
115                           ,PERIOD_START IN DATE
116                           ,DEAL_TYPE IN VARCHAR2) RETURN NUMBER;
117 
118   FUNCTION END_FVFORMULA(COMPANY IN VARCHAR2
119                         ,REF_NUMBER_1 IN VARCHAR2
120                         ,PERIOD_END_1 IN DATE) RETURN NUMBER;
121 
122   FUNCTION AFTERPFORM RETURN BOOLEAN;
123 
124   FUNCTION BEFOREREPORT RETURN BOOLEAN;
125 
126   FUNCTION AFTERREPORT RETURN BOOLEAN;
127 
128   FUNCTION C_DATEFORMATFORMULA(C_DATEFORMAT IN VARCHAR2) RETURN CHAR;
129 
130   FUNCTION CO_SHT_NAMEFORMULA(COMPANY IN VARCHAR2) RETURN CHAR;
131 
132   FUNCTION C_REPORT_NAMEFORMULA RETURN CHAR;
133 
134   FUNCTION C_REV_PERIODFORMULA(PERIOD_START IN DATE
135                               ,PERIOD_END IN DATE) RETURN CHAR;
136 
137   FUNCTION USER_DEAL_SUBTYPEFORMULA(DEAL_SUBTYPE_1 IN varchar2
138                                    ,DEAL_TYPE_1 IN VARCHAR2) RETURN CHAR;
139 
140   FUNCTION USER_DEAL_TYPEFORMULA(DEAL_TYPE_1 IN VARCHAR2) RETURN CHAR;
141 
142 END XTR_XTRREVGL_XMLP_PKG;
143