APPS.AK_UNIQUE_KEYS_PKG dependencies on AK_UNIQUE_KEYS

Line 1: PACKAGE BODY AK_UNIQUE_KEYS_PKG as

1: PACKAGE BODY AK_UNIQUE_KEYS_PKG as
2: /* $Header: AKDOBPKB.pls 120.2 2005/09/29 13:59:56 tshort ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Unique_Key_Name VARCHAR2,

Line 30: CURSOR C IS SELECT rowid FROM AK_UNIQUE_KEYS

26: X_Attribute13 VARCHAR2,
27: X_Attribute14 VARCHAR2,
28: X_Attribute15 VARCHAR2
29: ) IS
30: CURSOR C IS SELECT rowid FROM AK_UNIQUE_KEYS
31: WHERE unique_key_name = X_Unique_Key_Name;
32:
33: BEGIN
34:

Line 36: INSERT INTO AK_UNIQUE_KEYS(

32:
33: BEGIN
34:
35:
36: INSERT INTO AK_UNIQUE_KEYS(
37: unique_key_name,
38: database_object_name,
39: application_id,
40: last_update_date,

Line 105: FROM AK_UNIQUE_KEYS

101: X_Application_Id NUMBER
102: ) IS
103: CURSOR C IS
104: SELECT *
105: FROM AK_UNIQUE_KEYS
106: WHERE rowid = X_Rowid
107: FOR UPDATE of Unique_Key_Name NOWAIT;
108: Recinfo C%ROWTYPE;
109:

Line 159: UPDATE AK_UNIQUE_KEYS

155: X_Attribute14 VARCHAR2,
156: X_Attribute15 VARCHAR2
157: ) IS
158: BEGIN
159: UPDATE AK_UNIQUE_KEYS
160: SET
161: unique_key_name = X_Unique_Key_Name,
162: database_object_name = X_Database_Object_Name,
163: application_id = X_Application_Id,

Line 191: DELETE FROM AK_UNIQUE_KEYS

187: end if;
188: END Update_Row;
189: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
190: BEGIN
191: DELETE FROM AK_UNIQUE_KEYS
192: WHERE rowid = X_Rowid;
193:
194: if (SQL%NOTFOUND) then
195: Raise NO_DATA_FOUND;

Line 200: END AK_UNIQUE_KEYS_PKG;

196: end if;
197: END Delete_Row;
198:
199:
200: END AK_UNIQUE_KEYS_PKG;