APPS.AK_OBJECT3_PVT dependencies on AK_OBJECT_ATTRIBUTES

Line 483: from AK_OBJECT_ATTRIBUTES

479: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
480: ) is
481: cursor l_get_row_csr is
482: select *
483: from AK_OBJECT_ATTRIBUTES
484: where DATABASE_OBJECT_NAME = p_database_object_name
485: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
486: and ATTRIBUTE_CODE = p_attribute_code
487: for update of ATTRIBUTE_APPLICATION_ID;

Line 490: from AK_OBJECT_ATTRIBUTES_TL

486: and ATTRIBUTE_CODE = p_attribute_code
487: for update of ATTRIBUTE_APPLICATION_ID;
488: cursor l_get_tl_row_csr (lang_parm varchar2) is
489: select *
490: from AK_OBJECT_ATTRIBUTES_TL
491: where DATABASE_OBJECT_NAME = p_database_object_name
492: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
493: and ATTRIBUTE_CODE = p_attribute_code
494: and LANGUAGE = lang_parm

Line 498: l_attributes_rec ak_object_attributes%ROWTYPE;

494: and LANGUAGE = lang_parm
495: for update of ATTRIBUTE_APPLICATION_ID;
496: l_api_version_number CONSTANT number := 1.0;
497: l_api_name CONSTANT varchar2(30) := 'Update_Attribute';
498: l_attributes_rec ak_object_attributes%ROWTYPE;
499: l_attributes_tl_rec ak_object_attributes_tl%ROWTYPE;
500: l_created_by number;
501: l_creation_date date;
502: l_dummy number;

Line 499: l_attributes_tl_rec ak_object_attributes_tl%ROWTYPE;

495: for update of ATTRIBUTE_APPLICATION_ID;
496: l_api_version_number CONSTANT number := 1.0;
497: l_api_name CONSTANT varchar2(30) := 'Update_Attribute';
498: l_attributes_rec ak_object_attributes%ROWTYPE;
499: l_attributes_tl_rec ak_object_attributes_tl%ROWTYPE;
500: l_created_by number;
501: l_creation_date date;
502: l_dummy number;
503: l_error boolean;

Line 529: --** retrieve ak_object_attributes row if it exists **

525:
526: select userenv('LANG') into l_lang
527: from dual;
528:
529: --** retrieve ak_object_attributes row if it exists **
530: open l_get_row_csr;
531: fetch l_get_row_csr into l_attributes_rec;
532: if (l_get_row_csr%notfound) then
533: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 543: --** retrieve ak_object_attributes_tl row if it exists **

539: raise FND_API.G_EXC_ERROR;
540: end if;
541: close l_get_row_csr;
542:
543: --** retrieve ak_object_attributes_tl row if it exists **
544: open l_get_tl_row_csr(l_lang);
545: fetch l_get_tl_row_csr into l_attributes_tl_rec;
546: if (l_get_tl_row_csr%notfound) then
547: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 799: update AK_OBJECT_ATTRIBUTES set

795: p_db_last_update_date => l_attributes_rec.last_update_date,
796: p_last_update_login => l_last_update_login,
797: p_create_or_update => 'UPDATE') then
798:
799: update AK_OBJECT_ATTRIBUTES set
800: COLUMN_NAME = l_attributes_rec.column_name,
801: ATTRIBUTE_LABEL_LENGTH = l_attributes_rec.attribute_label_length,
802: DISPLAY_VALUE_LENGTH = l_attributes_rec.display_value_length,
803: BOLD = l_attributes_rec.bold,

Line 856: update AK_OBJECT_ATTRIBUTES_TL set

852: -- dbms_output.put_line('Row does not exist during update');
853: raise FND_API.G_EXC_ERROR;
854: end if;
855:
856: update AK_OBJECT_ATTRIBUTES_TL set
857: ATTRIBUTE_LABEL_LONG = l_attributes_tl_rec.attribute_label_long,
858: ATTRIBUTE_LABEL_SHORT = l_attributes_tl_rec.attribute_label_short,
859: LAST_UPDATED_BY = l_last_updated_by,
860: LAST_UPDATE_DATE = l_last_update_date,

Line 4078: from ak_object_attributes aoa, ak_object_attributes_tl aoat

4074: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
4075: select aoa.last_updated_by, aoat.last_updated_by,
4076: aoa.last_update_date, aoat.last_update_date
4077: into l_user_id1, l_user_id2, l_update1, l_update2
4078: from ak_object_attributes aoa, ak_object_attributes_tl aoat
4079: where aoa.database_object_name = l_attribute_tbl(l_index).database_object_name
4080: and aoa.attribute_code = l_attribute_tbl(l_index).attribute_code
4081: and aoa.attribute_application_id = l_attribute_tbl(l_index).attribute_appl_id
4082: and aoa.database_object_name = aoat.database_object_name