[Home] [Help]
PACKAGE: APPS.XTR_XTRIGSUM_XMLP_PKG
Source
1 PACKAGE XTR_XTRIGSUM_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: XTRIGSUMS.pls 120.1 2007/12/28 12:50:33 npannamp noship $ */
3 INPUT_FROM_DATE DATE;
4
5 INPUT_TO_DATE DATE;
6
7 SEL_COMP VARCHAR2(7);
8
9 SEL_PARTY VARCHAR2(7);
10
11 USE_DEFAULTS VARCHAR2(40);
12
13 REPORT_SHORT_NAME VARCHAR2(80);
14
15 REPORT_GROUP VARCHAR2(40);
16
17 REPORT_NOS VARCHAR2(40);
18
19 VERSION_NUM VARCHAR2(40);
20
21 Z1REPORT_NOS VARCHAR2(100);
22
23 Z2DAY VARCHAR2(100);
24
25 Z2PRIN VARCHAR2(100);
26
27 Z2ADJUSTMENT VARCHAR2(100);
28
29 Z2END_OF_REPORT VARCHAR2(100);
30
31 Z2BALANCE VARCHAR2(100);
32
33 Z2INTEREST VARCHAR2(100);
34
35 Z2INT_RATE VARCHAR2(100);
36
37 Z2SETTLED_ON VARCHAR2(100);
38
39 Z1PARAMETERS VARCHAR2(100);
40
41 Z1FOR_PERIOD VARCHAR2(100);
42
43 Z1TO VARCHAR2(100);
44
45 Z1COMPANY VARCHAR2(100);
46
47 Z1INTERGROUP_PARTY VARCHAR2(100);
48
49 Z2CURRENCY VARCHAR2(100);
50
51 Z2INTEREST_FOR_THE_PERIOD VARCHAR2(100);
52
53 Z2INTEREST_SETTLED VARCHAR2(100);
54
55 Z2DATE VARCHAR2(100);
56
57 Z2CCY VARCHAR2(100);
58
59 Z2INTEREST_BFWD VARCHAR2(100);
60
61 Z2INTEREST_CFWD VARCHAR2(100);
62
63 Z2PAGE VARCHAR2(100);
64
65 Z2REPORT VARCHAR2(100);
66
67 Z2REQUESTED_BY VARCHAR2(100);
68
69 Z2NOTE VARCHAR2(100);
70
71 P_PERIOD_FROM VARCHAR2(32767);
72 P_PERIOD_FROM_1 VARCHAR2(32767);
73
74 P_PERIOD_TO VARCHAR2(32767);
75 P_PERIOD_TO_1 VARCHAR2(32767);
76
77 P_COMPANY VARCHAR2(7);
78
79 P_INTERGROUP_PARTY VARCHAR2(7);
80
81 P_SQL_TRACE VARCHAR2(32767);
82
83 P_DISPLAY_DEBUG VARCHAR2(32767);
84
85 COMPANY_NAME_HEADER VARCHAR2(80);
86
87 PER_FROM DATE;
88
89 PER_TO DATE;
90
91 SEL_COMP2 VARCHAR2(7);
92
93 SEL_PARTY2 VARCHAR2(7);
94
95 P_CONC_REQUEST_ID NUMBER;
96
97 REPORT_SHORT_NAME2 VARCHAR2(240);
98
99 REPORT_DATE VARCHAR2(100);
100
101 P_INTAMT_RUNNING NUMBER;
102
103 P_SETAMT_RUNNING NUMBER;
104
105 P_COMBINATION VARCHAR2(100);
106
107 P_OLDEST_TRANSFER_DATE DATE;
108
109 P_PREV_DAY_COUNT_TYPE VARCHAR2(1);
110
111 P_PREV_PREV_DAY_COUNT_TYPE VARCHAR2(1);
112
113 CP_PARA VARCHAR2(32767);
114
115 FUNCTION CF_SET_PARAFORMULA RETURN VARCHAR2;
116
117 FUNCTION BEFOREREPORT RETURN BOOLEAN;
118
119 FUNCTION AFTERREPORT RETURN BOOLEAN;
120
121 FUNCTION BEFOREPFORM RETURN BOOLEAN;
122
123 FUNCTION AFTERPFORM RETURN BOOLEAN;
124
125 FUNCTION CF_INT_CFFORMULA(COMP_CODE IN VARCHAR2
126 ,PTY_CODE IN VARCHAR2
127 ,CCY IN VARCHAR2
128 ,CF_INTEREST_FOR_DUMMY_REC IN NUMBER
129 ,DAY_COUNT_TYPE IN VARCHAR2
130 ,ACC_INT_BF IN NUMBER) RETURN NUMBER;
131
132 FUNCTION FN_GET_DAYS(ANU_ST_DATE IN DATE) RETURN NUMBER;
133
134 FUNCTION CF_INTEREST_FOR_DUMMY_RECFORMU(CF_NO_OF_DAYS IN NUMBER
135 ,ROUNDING_FACTOR IN NUMBER
136 ,IG_YEAR_BASIS IN VARCHAR2
137 ,DAY_COUNT_TYPE IN VARCHAR2
138 ,SET_DATE IN DATE
139 ,PTY_CODE IN VARCHAR2
140 ,COMP_CODE IN VARCHAR2
141 ,CCY IN VARCHAR2
142 ,PRIN_ACTION IN VARCHAR2
143 ,CF_PRV_DAY IN DATE
144 ,TRANS_DATE IN DATE
145 ,BAL_BF IN NUMBER
146 ,CF_PRV_RATE IN NUMBER
147 ,ROUNDING_TYPE IN VARCHAR2) RETURN NUMBER;
148
149 FUNCTION CF_NO_OF_DAYSFORMULA(N_DAYS IN NUMBER
150 ,IG_YEAR_BASIS IN VARCHAR2
151 ,DAY_COUNT_TYPE IN VARCHAR2
152 ,SET_DATE IN DATE
153 ,PTY_CODE IN VARCHAR2
154 ,COMP_CODE IN VARCHAR2
155 ,CCY IN VARCHAR2
156 ,PRIN_ACTION IN VARCHAR2
157 ,CF_PRV_DAY IN DATE
158 ,TRANS_DATE IN DATE) RETURN NUMBER;
159
160 FUNCTION CF_PRV_DAYFORMULA(COMP_CODE IN VARCHAR2
161 ,PTY_CODE IN VARCHAR2
162 ,CCY IN VARCHAR2
163 ,TRANS_DATE IN DATE
164 ,TRANSACTION_NUMBER1 IN NUMBER) RETURN DATE;
165
166 FUNCTION CF_PRV_RATEFORMULA(COMP_CODE IN VARCHAR2
167 ,PTY_CODE IN VARCHAR2
168 ,CCY IN VARCHAR2
169 ,TRANS_DATE IN DATE) RETURN NUMBER;
170
171 FUNCTION BAL_BFFORMULA(COMP_CODE IN VARCHAR2
172 ,PTY_CODE IN VARCHAR2
173 ,CCY IN VARCHAR2
174 ,TRANS_DATE IN DATE) RETURN NUMBER;
175
176 FUNCTION CP_PARA_P RETURN VARCHAR2;
177
178 END XTR_XTRIGSUM_XMLP_PKG;
179