APPS.OKE_FUNDING_POOLS_PKG dependencies on OKE_FUNDING_POOLS

Line 1: package body OKE_FUNDING_POOLS_PKG as

1: package body OKE_FUNDING_POOLS_PKG as
2: /* $Header: OKEFDPLB.pls 115.5 2002/11/27 19:47:16 syho ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Funding_Pool_Id NUMBER,

Line 36: from OKE_FUNDING_POOLS

32: ) is
33:
34: cursor C is
35: select rowid
36: from OKE_FUNDING_POOLS
37: where funding_pool_id = X_Funding_Pool_Id;
38:
39: begin
40:

Line 41: insert into OKE_FUNDING_POOLS(

37: where funding_pool_id = X_Funding_Pool_Id;
38:
39: begin
40:
41: insert into OKE_FUNDING_POOLS(
42: funding_pool_id,
43: name,
44: description,
45: contact_person_id,

Line 157: from OKE_FUNDING_POOLS

153: attribute12,
154: attribute13,
155: attribute14,
156: attribute15
157: from OKE_FUNDING_POOLS
158: where funding_pool_id = X_Funding_Pool_Id
159: for update of funding_pool_id nowait;
160:
161: recinfo c%rowtype;

Line 253: update OKE_FUNDING_POOLS

249: ) is
250:
251: begin
252:
253: update OKE_FUNDING_POOLS
254: set
255: name = X_Name,
256: description = X_Description,
257: contact_person_id = X_Contact_Person_Id,

Line 290: DELETE FROM OKE_FUNDING_POOLS

286:
287: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
288: BEGIN
289:
290: DELETE FROM OKE_FUNDING_POOLS
291: WHERE rowid = X_Rowid;
292:
293: if (SQL%NOTFOUND) then
294: Raise NO_DATA_FOUND;

Line 303: end OKE_FUNDING_POOLS_PKG;

299: raise;
300:
301: END Delete_Row;
302:
303: end OKE_FUNDING_POOLS_PKG;