APPS.AK_OBJECT3_PVT dependencies on AK_OBJECTS

Line 70: from AK_OBJECTS

66: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
67: ) is
68: cursor l_get_row_csr (lang_parm varchar2) is
69: select *
70: from AK_OBJECTS
71: where DATABASE_OBJECT_NAME = p_database_object_name
72: for update of APPLICATION_ID;
73: cursor l_get_tl_row_csr (lang_parm varchar2) is
74: select *

Line 75: from AK_OBJECTS_TL

71: where DATABASE_OBJECT_NAME = p_database_object_name
72: for update of APPLICATION_ID;
73: cursor l_get_tl_row_csr (lang_parm varchar2) is
74: select *
75: from AK_OBJECTS_TL
76: where DATABASE_OBJECT_NAME = p_database_object_name
77: and LANGUAGE = lang_parm
78: for update of NAME;
79: l_api_version_number CONSTANT number := 1.0;

Line 83: l_objects_rec AK_OBJECTS%ROWTYPE;

79: l_api_version_number CONSTANT number := 1.0;
80: l_api_name CONSTANT varchar2(30) := 'Update_Object';
81: l_created_by number;
82: l_creation_date date;
83: l_objects_rec AK_OBJECTS%ROWTYPE;
84: l_objects_tl_rec AK_OBJECTS_TL%ROWTYPE;
85: l_lang varchar2(30);
86: l_last_update_date date;
87: l_last_update_login number;

Line 84: l_objects_tl_rec AK_OBJECTS_TL%ROWTYPE;

80: l_api_name CONSTANT varchar2(30) := 'Update_Object';
81: l_created_by number;
82: l_creation_date date;
83: l_objects_rec AK_OBJECTS%ROWTYPE;
84: l_objects_tl_rec AK_OBJECTS_TL%ROWTYPE;
85: l_lang varchar2(30);
86: l_last_update_date date;
87: l_last_update_login number;
88: l_last_updated_by number;

Line 110: --** retrieve ak_objects row if it exists **

106:
107: select userenv('LANG') into l_lang
108: from dual;
109:
110: --** retrieve ak_objects row if it exists **
111: open l_get_row_csr(l_lang);
112: fetch l_get_row_csr into l_objects_rec;
113: if (l_get_row_csr%notfound) then
114: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 124: --** retrieve ak_objects_tl row if it exists **

120: raise FND_API.G_EXC_ERROR;
121: end if;
122: close l_get_row_csr;
123:
124: --** retrieve ak_objects_tl row if it exists **
125: open l_get_tl_row_csr(l_lang);
126: fetch l_get_tl_row_csr into l_objects_tl_rec;
127: if (l_get_tl_row_csr%notfound) then
128: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 296: update AK_OBJECTS set

292: p_db_last_update_date => l_objects_rec.last_update_date,
293: p_last_update_login => l_last_update_login,
294: p_create_or_update => 'UPDATE') then
295:
296: update AK_OBJECTS set
297: APPLICATION_ID = l_objects_rec.application_id,
298: PRIMARY_KEY_NAME = l_objects_rec.primary_key_name,
299: DEFAULTING_API_PKG = l_objects_rec.defaulting_api_pkg,
300: DEFAULTING_API_PROC = l_objects_rec.defaulting_api_proc,

Line 331: update AK_OBJECTS_TL set

327: end if;
328: raise FND_API.G_EXC_ERROR;
329: end if;
330:
331: update AK_OBJECTS_TL set
332: NAME = l_objects_tl_rec.name,
333: DESCRIPTION = l_objects_tl_rec.description,
334: LAST_UPDATE_DATE = l_last_update_date,
335: LAST_UPDATED_BY = l_last_updated_by,

Line 3845: from ak_objects ao, ak_objects_tl aot

3841: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
3842: select ao.last_updated_by, aot.last_updated_by,
3843: ao.last_update_date, aot.last_update_date
3844: into l_user_id1, l_user_id2, l_update1, l_update2
3845: from ak_objects ao, ak_objects_tl aot
3846: where ao.database_object_name = l_object_tbl(l_index).database_object_name
3847: and ao.database_object_name = aot.database_object_name
3848: and aot.language = userenv('LANG');
3849: /*if (( l_user_id1 = 1 or l_user_id1 = 2 ) and