[Home] [Help]
PACKAGE: APPS.XTR_XTRREVGL_XMLP_PKG
Source
1 PACKAGE XTR_XTRREVGL_XMLP_PKG 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