APPS.OKE_NOTIFICATIONS_PKG dependencies on OKE_NOTIFICATIONS

Line 1: package body OKE_NOTIFICATIONS_PKG as

1: package body OKE_NOTIFICATIONS_PKG as
2: /* $Header: OKEONXXB.pls 115.0 2003/10/22 22:26:13 ybchen noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2
5: , X_ID in NUMBER

Line 19: cursor C is select ROWID from OKE_NOTIFICATIONS

15: , X_DURATION_DAYS in NUMBER
16: , X_RECIPIENT in VARCHAR2
17: , X_ROLE_ID in NUMBER
18: ) is
19: cursor C is select ROWID from OKE_NOTIFICATIONS
20: where ID = X_ID
21: ;
22: begin
23: insert into OKE_NOTIFICATIONS (

Line 23: insert into OKE_NOTIFICATIONS (

19: cursor C is select ROWID from OKE_NOTIFICATIONS
20: where ID = X_ID
21: ;
22: begin
23: insert into OKE_NOTIFICATIONS (
24: ID
25: , SOURCE_CODE
26: , USAGE_CODE
27: , CREATION_DATE

Line 81: from OKE_NOTIFICATIONS

77: , BEFORE_AFTER
78: , DURATION_DAYS
79: , RECIPIENT
80: , ROLE_ID
81: from OKE_NOTIFICATIONS
82: where ID = X_ID
83: for update nowait;
84:
85: recinfo c%rowtype;

Line 135: update OKE_NOTIFICATIONS

131: , X_ROLE_ID in NUMBER
132: )
133: is
134: begin
135: update OKE_NOTIFICATIONS
136: set
137: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
138: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
139: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 158: delete OKE_NOTIFICATIONS

154: procedure DELETE_ROW (
155: X_ID in NUMBER
156: ) is
157: begin
158: delete OKE_NOTIFICATIONS
159: where ID = X_ID
160: ;
161:
162: if (sql%notfound) then

Line 168: end OKE_NOTIFICATIONS_PKG;

164: end if;
165:
166: end DELETE_ROW;
167:
168: end OKE_NOTIFICATIONS_PKG;