1 PACKAGE FEM_PARTY_PROFITABILITY_PKG as
2 -- $Header: femprfTS.pls 120.0 2005/06/06 21:50:58 appldev noship $
3
4
5
6 PROCEDURE Insert_Row(
7 x_Rowid IN OUT NOCOPY VARCHAR2,
8 x_PARTY_ID NUMBER,
9 x_LAST_UPDATE_DATE DATE,
10 x_LAST_UPDATED_BY NUMBER,
11 x_CREATION_DATE DATE,
12 x_CREATED_BY NUMBER,
13 x_LAST_UPDATE_LOGIN NUMBER,
14 x_PROFIT NUMBER,
15 x_PROFIT_PCT NUMBER,
16 x_RELATIONSHIP_EXPENSE NUMBER,
17 x_TOTAL_EQUITY NUMBER,
18 x_TOTAL_GROSS_CONTRIB NUMBER,
19 x_TOTAL_ROE NUMBER,
20 x_CONTRIB_AFTER_CPTL_CHG NUMBER,
21 x_PARTNER_VALUE_INDEX NUMBER,
22 x_ISO_CURRENCY_CD VARCHAR2,
23 x_REVENUE1 NUMBER,
24 x_REVENUE2 NUMBER,
25 x_REVENUE3 NUMBER,
26 x_REVENUE4 NUMBER,
27 x_REVENUE5 NUMBER,
28 x_REVENUE_TOTAL NUMBER,
29 x_EXPENSE1 NUMBER,
30 x_EXPENSE2 NUMBER,
31 x_EXPENSE3 NUMBER,
32 x_EXPENSE4 NUMBER,
33 x_EXPENSE5 NUMBER,
34 x_EXPENSE_TOTAL NUMBER,
35 x_PROFIT1 NUMBER,
36 x_PROFIT2 NUMBER,
37 x_PROFIT3 NUMBER,
38 x_PROFIT4 NUMBER,
39 x_PROFIT5 NUMBER,
40 x_PROFIT_TOTAL NUMBER,
41 x_CACC1 NUMBER,
42 x_CACC2 NUMBER,
43 x_CACC3 NUMBER,
44 x_CACC4 NUMBER,
45 x_CACC5 NUMBER,
46 x_CACC_TOTAL NUMBER,
47 x_BALANCE1 NUMBER,
48 x_BALANCE2 NUMBER,
49 x_BALANCE3 NUMBER,
50 x_BALANCE4 NUMBER,
51 x_BALANCE5 NUMBER,
52 x_ACCOUNTS1 NUMBER,
53 x_ACCOUNTS2 NUMBER,
54 x_ACCOUNTS3 NUMBER,
55 x_ACCOUNTS4 NUMBER,
56 x_ACCOUNTS5 NUMBER,
57 x_TRANSACTION1 NUMBER,
58 x_TRANSACTION2 NUMBER,
59 x_TRANSACTION3 NUMBER,
60 x_TRANSACTION4 NUMBER,
61 x_TRANSACTION5 NUMBER,
62 x_RATIO1 NUMBER,
63 x_RATIO2 NUMBER,
64 x_RATIO3 NUMBER,
65 x_RATIO4 NUMBER,
66 x_RATIO5 NUMBER,
67 x_VALUE1 NUMBER,
68 x_VALUE2 NUMBER,
69 x_VALUE3 NUMBER,
70 x_VALUE4 NUMBER,
71 x_VALUE5 NUMBER,
72 x_YTD1 NUMBER,
73 x_YTD2 NUMBER,
74 x_YTD3 NUMBER,
75 x_YTD4 NUMBER,
76 x_YTD5 NUMBER,
77 x_LTD1 NUMBER,
78 x_LTD2 NUMBER,
79 x_LTD3 NUMBER,
80 x_LTD4 NUMBER,
81 x_LTD5 NUMBER);
82
83
84 PROCEDURE Lock_Row(
85 x_Rowid VARCHAR2,
86 x_PARTY_ID NUMBER,
87 x_LAST_UPDATE_DATE DATE,
88 x_LAST_UPDATED_BY NUMBER,
89 x_CREATION_DATE DATE,
90 x_CREATED_BY NUMBER,
91 x_LAST_UPDATE_LOGIN NUMBER,
92 x_PROFIT NUMBER,
93 x_PROFIT_PCT NUMBER,
94 x_RELATIONSHIP_EXPENSE NUMBER,
95 x_TOTAL_EQUITY NUMBER,
96 x_TOTAL_GROSS_CONTRIB NUMBER,
97 x_TOTAL_ROE NUMBER,
98 x_CONTRIB_AFTER_CPTL_CHG NUMBER,
99 x_PARTNER_VALUE_INDEX NUMBER,
100 x_ISO_CURRENCY_CD VARCHAR2,
101 x_REVENUE1 NUMBER,
102 x_REVENUE2 NUMBER,
103 x_REVENUE3 NUMBER,
104 x_REVENUE4 NUMBER,
105 x_REVENUE5 NUMBER,
106 x_REVENUE_TOTAL NUMBER,
107 x_EXPENSE1 NUMBER,
108 x_EXPENSE2 NUMBER,
109 x_EXPENSE3 NUMBER,
110 x_EXPENSE4 NUMBER,
111 x_EXPENSE5 NUMBER,
112 x_EXPENSE_TOTAL NUMBER,
113 x_PROFIT1 NUMBER,
114 x_PROFIT2 NUMBER,
115 x_PROFIT3 NUMBER,
116 x_PROFIT4 NUMBER,
117 x_PROFIT5 NUMBER,
118 x_PROFIT_TOTAL NUMBER,
119 x_CACC1 NUMBER,
120 x_CACC2 NUMBER,
121 x_CACC3 NUMBER,
122 x_CACC4 NUMBER,
123 x_CACC5 NUMBER,
124 x_CACC_TOTAL NUMBER,
125 x_BALANCE1 NUMBER,
126 x_BALANCE2 NUMBER,
127 x_BALANCE3 NUMBER,
128 x_BALANCE4 NUMBER,
129 x_BALANCE5 NUMBER,
130 x_ACCOUNTS1 NUMBER,
131 x_ACCOUNTS2 NUMBER,
132 x_ACCOUNTS3 NUMBER,
133 x_ACCOUNTS4 NUMBER,
134 x_ACCOUNTS5 NUMBER,
135 x_TRANSACTION1 NUMBER,
136 x_TRANSACTION2 NUMBER,
137 x_TRANSACTION3 NUMBER,
138 x_TRANSACTION4 NUMBER,
139 x_TRANSACTION5 NUMBER,
140 x_RATIO1 NUMBER,
141 x_RATIO2 NUMBER,
142 x_RATIO3 NUMBER,
143 x_RATIO4 NUMBER,
144 x_RATIO5 NUMBER,
145 x_VALUE1 NUMBER,
146 x_VALUE2 NUMBER,
147 x_VALUE3 NUMBER,
148 x_VALUE4 NUMBER,
149 x_VALUE5 NUMBER,
150 x_YTD1 NUMBER,
151 x_YTD2 NUMBER,
152 x_YTD3 NUMBER,
153 x_YTD4 NUMBER,
154 x_YTD5 NUMBER,
155 x_LTD1 NUMBER,
156 x_LTD2 NUMBER,
157 x_LTD3 NUMBER,
158 x_LTD4 NUMBER,
159 x_LTD5 NUMBER);
160
161
162
163 PROCEDURE Update_Row(
164 x_Rowid VARCHAR2,
165 x_PARTY_ID NUMBER,
166 x_LAST_UPDATE_DATE DATE,
167 x_LAST_UPDATED_BY NUMBER,
168 x_CREATION_DATE DATE,
169 x_CREATED_BY NUMBER,
170 x_LAST_UPDATE_LOGIN NUMBER,
171 x_PROFIT NUMBER,
172 x_PROFIT_PCT NUMBER,
173 x_RELATIONSHIP_EXPENSE NUMBER,
174 x_TOTAL_EQUITY NUMBER,
175 x_TOTAL_GROSS_CONTRIB NUMBER,
176 x_TOTAL_ROE NUMBER,
177 x_CONTRIB_AFTER_CPTL_CHG NUMBER,
178 x_PARTNER_VALUE_INDEX NUMBER,
179 x_ISO_CURRENCY_CD VARCHAR2,
180 x_REVENUE1 NUMBER,
181 x_REVENUE2 NUMBER,
182 x_REVENUE3 NUMBER,
183 x_REVENUE4 NUMBER,
184 x_REVENUE5 NUMBER,
185 x_REVENUE_TOTAL NUMBER,
186 x_EXPENSE1 NUMBER,
187 x_EXPENSE2 NUMBER,
188 x_EXPENSE3 NUMBER,
189 x_EXPENSE4 NUMBER,
190 x_EXPENSE5 NUMBER,
191 x_EXPENSE_TOTAL NUMBER,
192 x_PROFIT1 NUMBER,
193 x_PROFIT2 NUMBER,
194 x_PROFIT3 NUMBER,
195 x_PROFIT4 NUMBER,
196 x_PROFIT5 NUMBER,
197 x_PROFIT_TOTAL NUMBER,
198 x_CACC1 NUMBER,
199 x_CACC2 NUMBER,
200 x_CACC3 NUMBER,
201 x_CACC4 NUMBER,
202 x_CACC5 NUMBER,
203 x_CACC_TOTAL NUMBER,
204 x_BALANCE1 NUMBER,
205 x_BALANCE2 NUMBER,
206 x_BALANCE3 NUMBER,
207 x_BALANCE4 NUMBER,
208 x_BALANCE5 NUMBER,
209 x_ACCOUNTS1 NUMBER,
210 x_ACCOUNTS2 NUMBER,
211 x_ACCOUNTS3 NUMBER,
212 x_ACCOUNTS4 NUMBER,
213 x_ACCOUNTS5 NUMBER,
214 x_TRANSACTION1 NUMBER,
215 x_TRANSACTION2 NUMBER,
216 x_TRANSACTION3 NUMBER,
217 x_TRANSACTION4 NUMBER,
218 x_TRANSACTION5 NUMBER,
219 x_RATIO1 NUMBER,
220 x_RATIO2 NUMBER,
221 x_RATIO3 NUMBER,
222 x_RATIO4 NUMBER,
223 x_RATIO5 NUMBER,
224 x_VALUE1 NUMBER,
225 x_VALUE2 NUMBER,
226 x_VALUE3 NUMBER,
227 x_VALUE4 NUMBER,
228 x_VALUE5 NUMBER,
229 x_YTD1 NUMBER,
230 x_YTD2 NUMBER,
231 x_YTD3 NUMBER,
232 x_YTD4 NUMBER,
233 x_YTD5 NUMBER,
234 x_LTD1 NUMBER,
235 x_LTD2 NUMBER,
236 x_LTD3 NUMBER,
237 x_LTD4 NUMBER,
238 x_LTD5 NUMBER);
239
240
241
242 PROCEDURE Delete_Row(x_PARTY_ID NUMBER);
243
244 END FEM_PARTY_PROFITABILITY_PKG;
|
|
|