DBA Data[Home] [Help]

APPS.AK_OBJECT_ATTRIBUTE_NAVIGA_PKG dependencies on AK_OBJECT_ATTRIBUTE_NAVIGATION

Line 37: CURSOR C IS SELECT rowid FROM AK_OBJECT_ATTRIBUTE_NAVIGATION

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:

Line 45: INSERT INTO AK_OBJECT_ATTRIBUTE_NAVIGATION(

41:
42: BEGIN
43:
44:
45: INSERT INTO AK_OBJECT_ATTRIBUTE_NAVIGATION(
46:
47: database_object_name,
48: attribute_application_id,
49: attribute_code,

Line 132: FROM AK_OBJECT_ATTRIBUTE_NAVIGATION

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:

Line 205: UPDATE AK_OBJECT_ATTRIBUTE_NAVIGATION

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,

Line 242: DELETE FROM AK_OBJECT_ATTRIBUTE_NAVIGATION

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;