[Home] [Help]
PACKAGE: APPS.OKE_POOLS_PARTIES_PUB
Source
1 PACKAGE OKE_POOLS_PARTIES_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKEPPPPS.pls 115.5 2002/08/14 01:42:34 alaw ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_POOLS_PARTIES_PUB';
5 G_APP_NAME CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;
6
7
8 SUBTYPE pool_rec_type IS oke_pool_pvt.pool_rec_type;
9 SUBTYPE party_rec_type IS OKE_party_pvt.party_rec_type;
10
11 /* create_pool - creates new funding pool.
12 returns new funding_pool_id in x_pool_rec
13 */
14
15 PROCEDURE create_pool(
16
17 p_api_version IN NUMBER,
18 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_msg_count OUT NOCOPY NUMBER,
21 x_msg_data OUT NOCOPY VARCHAR2,
22
23 p_pool_rec IN oke_pool_pvt.pool_rec_type,
24 x_pool_rec OUT NOCOPY oke_pool_pvt.pool_rec_type);
25
26 PROCEDURE create_pool(
27 p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32
33 p_pool_tbl IN oke_pool_pvt.pool_tbl_type,
34 x_pool_tbl OUT NOCOPY oke_pool_pvt.pool_tbl_type);
35
36
37
38 /* updating currency code is not allowed */
39
40 PROCEDURE update_pool(
41 p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_pool_rec IN oke_pool_pvt.pool_rec_type,
47 x_pool_rec OUT NOCOPY oke_pool_pvt.pool_rec_type);
48
49
50 PROCEDURE update_pool(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_pool_tbl IN oke_pool_pvt.pool_tbl_type,
57 x_pool_tbl OUT NOCOPY oke_pool_pvt.pool_tbl_type);
58
59
60 -- cascading deletes
61
62 PROCEDURE delete_pool(
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_pool_rec IN oke_pool_pvt.pool_rec_type);
69
70
71 PROCEDURE delete_pool(
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 p_pool_tbl IN oke_pool_pvt.pool_tbl_type);
78
79 PROCEDURE delete_pool(
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_funding_pool_id IN NUMBER);
86
87
88 PROCEDURE lock_pool(
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 p_pool_rec IN OKE_POOL_PVT.pool_rec_type);
95
96 PROCEDURE lock_pool(
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 p_pool_tbl IN oke_pool_pvt.pool_tbl_type);
103
104
105
106 PROCEDURE create_party(
107
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113
114 p_party_rec IN oke_party_pvt.party_rec_type,
115 x_party_rec OUT NOCOPY oke_party_pvt.party_rec_type);
116
117 PROCEDURE create_party(
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123
124 p_party_tbl IN oke_party_pvt.party_tbl_type,
125 x_party_tbl OUT NOCOPY oke_party_pvt.party_tbl_type);
126
127
128 /*------------------------------------------------------------
129
130 updates -
131 funding_pool_id - not updatable
132 initial_amount - not updatable
133
134 currency_codes and conversions
135 - updatable only if no funding
136 sources children exists
137
138 conversion_date and _type must be specified
139 if currency is different from funding_pool
140
141 conversion_rate can never be specified
142
143 available_amount cannot be specified
144
145 if amount is specified
146 then amount will be changed to as specified
147 and available amount automatically changed
148 based on the difference between the old amount
149 and new amount
150
151
152 pool_party_id is used as the key for updating rows,
153 therefore must be specified.
154
155 -------------------------------------------------------------*/
156
157
158
159
160
161 PROCEDURE update_party(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 p_party_rec IN oke_party_pvt.party_rec_type,
168 x_party_rec OUT NOCOPY oke_party_pvt.party_rec_type);
169
170
171 PROCEDURE update_party(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_party_tbl IN oke_party_pvt.party_tbl_type,
178 x_party_tbl OUT NOCOPY oke_party_pvt.party_tbl_type);
179
180 -- cascading deletes
181
182 PROCEDURE delete_party(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_party_rec IN oke_party_pvt.party_rec_type);
189
190
191 PROCEDURE delete_party(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_party_tbl IN oke_party_pvt.party_tbl_type);
198
199 PROCEDURE delete_party(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_pool_party_id IN NUMBER);
206
207
208 PROCEDURE lock_party(
209 p_api_version IN NUMBER,
210 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2,
214 p_party_rec IN OKE_PARTY_PVT.party_rec_type);
215
216 PROCEDURE lock_party(
217 p_api_version IN NUMBER,
218 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2,
222 p_party_tbl IN oke_party_pvt.party_tbl_type);
223
224 END OKE_POOLS_PARTIES_PUB;
225