[Home] [Help]
932: end if;
933: raise FND_API.G_EXC_ERROR;
934: end if;
935:
936: insert into AK_ATTRIBUTES_TL (
937: ATTRIBUTE_APPLICATION_ID,
938: ATTRIBUTE_CODE,
939: LANGUAGE,
940: NAME,
964: from FND_LANGUAGES L
965: where L.INSTALLED_FLAG in ('I', 'B')
966: and not exists
967: (select NULL
968: from AK_ATTRIBUTES_TL T
969: where T.ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
970: and T.ATTRIBUTE_CODE = p_attribute_code
971: and T.LANGUAGE = L.LANGUAGE_CODE);
972:
1283: end if;
1284: raise FND_API.G_EXC_ERROR;
1285: end if;
1286:
1287: delete from ak_attributes_tl
1288: where attribute_application_id = p_attribute_application_id
1289: and attribute_code = p_attribute_code;
1290:
1291: if (sql%notfound) then
1356: procedure WRITE_TO_BUFFER (
1357: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1358: p_return_status OUT NOCOPY VARCHAR2,
1359: p_attributes_rec IN ak_attributes%ROWTYPE,
1360: p_attributes_tl_rec IN ak_attributes_tl%ROWTYPE
1361: ) is
1362: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
1363: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1364: l_index NUMBER;
1848: cursor l_get_tl_csr (appl_id_parm number,
1849: attr_code_parm varchar2,
1850: lang_parm varchar2) is
1851: select *
1852: from AK_ATTRIBUTES_TL
1853: where ATTRIBUTE_APPLICATION_ID = appl_id_parm
1854: and ATTRIBUTE_CODE = attr_code_parm
1855: and LANGUAGE = lang_parm;
1856: cursor l_get_tlp_csr (appl_id_parm number,
1856: cursor l_get_tlp_csr (appl_id_parm number,
1857: attr_code_parm varchar2,
1858: lang_parm varchar2) is
1859: select *
1860: from AK_ATTRIBUTES_TL
1861: where ATTRIBUTE_APPLICATION_ID = appl_id_parm
1862: and ATTRIBUTE_CODE like attr_code_parm
1863: and LANGUAGE = lang_parm;
1864: cursor l_percent_check (attr_code_parm varchar2) is
1870: l_attribute_found BOOLEAN;
1871: i number;
1872: l_attribute_appl_id NUMBER;
1873: l_attributes_rec ak_attributes%ROWTYPE;
1874: l_attributes_tl_rec ak_attributes_tl%ROWTYPE;
1875: l_return_status varchar2(1);
1876: l_select_by_appl_id BOOLEAN;
1877: l_percent NUMBER;
1878: begin
2608: if (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
2609: select aa.last_updated_by, aat.last_updated_by,
2610: aa.last_update_date, aat.last_update_date
2611: into l_user_id1, l_user_id2, l_update1, l_update2
2612: from ak_attributes aa, ak_attributes_tl aat
2613: where aa.attribute_code = l_attribute_rec.attribute_code
2614: and aa.attribute_application_id = l_attribute_rec.attribute_application_id
2615: and aa.attribute_code = aat.attribute_code
2616: and aa.attribute_application_id = aat.attribute_application_id
3119: and ATTRIBUTE_CODE = p_attribute_code
3120: for update of ATTRIBUTE_APPLICATION_ID;
3121: cursor l_get_tl_row_csr (lang_parm varchar2) is
3122: select *
3123: from AK_ATTRIBUTES_TL
3124: where ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
3125: and ATTRIBUTE_CODE = p_attribute_code
3126: and LANGUAGE = lang_parm
3127: for update of ATTRIBUTE_APPLICATION_ID;
3142: and ri.to_url_attribute_code = p_attribute_code;
3143: l_api_version_number CONSTANT number := 1.0;
3144: l_api_name CONSTANT varchar2(30) := 'Update_Attribute';
3145: l_attributes_rec ak_attributes%ROWTYPE;
3146: l_attributes_tl_rec ak_attributes_tl%ROWTYPE;
3147: l_created_by number;
3148: l_creation_date date;
3149: l_dummy number;
3150: l_error boolean;
3189: end if;
3190: close l_get_row_csr;
3191:
3192: --
3193: -- retrieve ak_attributes_tl row if it exists
3194: --
3195: open l_get_tl_row_csr(l_lang);
3196: fetch l_get_tl_row_csr into l_attributes_tl_rec;
3197: if (l_get_tl_row_csr%notfound) then
3558: end if;
3559: raise FND_API.G_EXC_ERROR;
3560: end if;
3561:
3562: update AK_ATTRIBUTES_TL set
3563: NAME = l_attributes_tl_rec.name,
3564: ATTRIBUTE_LABEL_LONG = l_attributes_tl_rec.attribute_label_long,
3565: ATTRIBUTE_LABEL_SHORT = l_attributes_tl_rec.attribute_label_short,
3566: DESCRIPTION = l_attributes_tl_rec.description,