DBA Data[Home] [Help]

APPS.OKE_POOLS_PARTIES_PUB dependencies on OKE_API

Line 5: G_APP_NAME CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;

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;

Line 18: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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:

Line 28: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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:

Line 42: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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,

Line 52: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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,

Line 64: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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

Line 73: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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

Line 81: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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

Line 90: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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

Line 98: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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

Line 109: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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:

Line 119: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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:

Line 163: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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,

Line 173: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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,

Line 184: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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

Line 193: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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

Line 201: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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

Line 210: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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

Line 218: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

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