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;
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:
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:
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,
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,
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);
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);
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);
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:
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:
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,
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,
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);
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);
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);