APPS.OKE_K_USER_ATTRIBUTES_PKG dependencies on OKE_K_USER_ATTRIBUTES

Line 1: PACKAGE BODY OKE_K_USER_ATTRIBUTES_PKG AS

1: PACKAGE BODY OKE_K_USER_ATTRIBUTES_PKG AS
2: /* $Header: OKEKUATB.pls 115.5 2002/11/20 20:28:54 who ship $ */
3: PROCEDURE INSERT_ROW
4: ( X_ROWID IN OUT NOCOPY VARCHAR2
5: , X_K_USER_ATTRIBUTE_ID IN OUT NOCOPY NUMBER

Line 49: FROM oke_k_user_attributes

45: ) IS
46:
47: CURSOR c IS
48: SELECT rowid
49: FROM oke_k_user_attributes
50: WHERE k_user_attribute_id = X_K_USER_ATTRIBUTE_ID;
51:
52: BEGIN
53:

Line 54: SELECT oke_k_user_attributes_s.nextval

50: WHERE k_user_attribute_id = X_K_USER_ATTRIBUTE_ID;
51:
52: BEGIN
53:
54: SELECT oke_k_user_attributes_s.nextval
55: , 1
56: INTO X_K_USER_ATTRIBUTE_ID
57: , X_RECORD_VERSION_NUMBER
58: FROM dual;

Line 60: INSERT INTO oke_k_user_attributes

56: INTO X_K_USER_ATTRIBUTE_ID
57: , X_RECORD_VERSION_NUMBER
58: FROM dual;
59:
60: INSERT INTO oke_k_user_attributes
61: ( K_USER_ATTRIBUTE_ID
62: , CREATION_DATE
63: , CREATED_BY
64: , LAST_UPDATE_DATE

Line 162: FROM oke_k_user_attributes

158: ) IS
159:
160: CURSOR c IS
161: SELECT record_version_number
162: FROM oke_k_user_attributes
163: WHERE ROWID = X_rowid
164: FOR UPDATE OF record_version_number NOWAIT;
165: RecInfo c%rowtype;
166:

Line 231: UPDATE oke_k_user_attributes

227: ) IS
228:
229: BEGIN
230:
231: UPDATE oke_k_user_attributes
232: SET K_USER_ATTRIBUTE_ID = X_K_USER_ATTRIBUTE_ID
233: , LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
234: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
235: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 287: DELETE FROM oke_k_user_attributes

283: ) IS
284:
285: BEGIN
286:
287: DELETE FROM oke_k_user_attributes
288: WHERE k_user_attribute_id = X_K_USER_ATTRIBUTE_ID;
289:
290: IF ( sql%notfound ) THEN
291: RAISE no_data_found;

Line 296: END OKE_K_USER_ATTRIBUTES_PKG;

292: END IF;
293:
294: END DELETE_ROW;
295:
296: END OKE_K_USER_ATTRIBUTES_PKG;