33: X_Attribute14 VARCHAR2,
34: X_Attribute15 VARCHAR2
35:
36: ) IS
37: CURSOR C IS SELECT rowid FROM AK_OBJECT_ATTRIBUTE_NAVIGATION
38: WHERE database_object_name = X_Database_Object_Name
39: AND attribute_application_id = X_Attribute_Application_Id
40: AND attribute_code = X_Attribute_Code;
41:
41:
42: BEGIN
43:
44:
45: INSERT INTO AK_OBJECT_ATTRIBUTE_NAVIGATION(
46:
47: database_object_name,
48: attribute_application_id,
49: attribute_code,
128: X_To_Region_Code VARCHAR2
129: ) IS
130: CURSOR C IS
131: SELECT *
132: FROM AK_OBJECT_ATTRIBUTE_NAVIGATION
133: WHERE rowid = X_Rowid
134: FOR UPDATE of Database_Object_Name NOWAIT;
135: Recinfo C%ROWTYPE;
136:
201: X_Attribute15 VARCHAR2
202:
203: ) IS
204: BEGIN
205: UPDATE AK_OBJECT_ATTRIBUTE_NAVIGATION
206: SET
207: database_object_name = X_Database_Object_Name,
208: attribute_application_id = X_Attribute_Application_Id,
209: attribute_code = X_Attribute_Code,
238: end if;
239: END Update_Row;
240: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
241: BEGIN
242: DELETE FROM AK_OBJECT_ATTRIBUTE_NAVIGATION
243: WHERE rowid = X_Rowid;
244:
245: if (SQL%NOTFOUND) then
246: Raise NO_DATA_FOUND;