[Home] [Help]
934: end if;
935: raise FND_API.G_EXC_ERROR;
936: end if;
937:
938: insert into AK_ATTRIBUTES_TL (
939: ATTRIBUTE_APPLICATION_ID,
940: ATTRIBUTE_CODE,
941: LANGUAGE,
942: NAME,
966: from FND_LANGUAGES L
967: where L.INSTALLED_FLAG in ('I', 'B')
968: and not exists
969: (select NULL
970: from AK_ATTRIBUTES_TL T
971: where T.ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
972: and T.ATTRIBUTE_CODE = p_attribute_code
973: and T.LANGUAGE = L.LANGUAGE_CODE);
974:
1287: end if;
1288: raise FND_API.G_EXC_ERROR;
1289: end if;
1290:
1291: delete from ak_attributes_tl
1292: where attribute_application_id = p_attribute_application_id
1293: and attribute_code = p_attribute_code;
1294:
1295: if (sql%notfound) then
1360: procedure WRITE_TO_BUFFER (
1361: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1362: p_return_status OUT NOCOPY VARCHAR2,
1363: p_attributes_rec IN ak_attributes%ROWTYPE,
1364: p_attributes_tl_rec IN ak_attributes_tl%ROWTYPE
1365: ) is
1366: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
1367: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1368: l_index NUMBER;
1852: cursor l_get_tl_csr (appl_id_parm number,
1853: attr_code_parm varchar2,
1854: lang_parm varchar2) is
1855: select *
1856: from AK_ATTRIBUTES_TL
1857: where ATTRIBUTE_APPLICATION_ID = appl_id_parm
1858: and ATTRIBUTE_CODE = attr_code_parm
1859: and LANGUAGE = lang_parm;
1860: cursor l_get_tlp_csr (appl_id_parm number,
1860: cursor l_get_tlp_csr (appl_id_parm number,
1861: attr_code_parm varchar2,
1862: lang_parm varchar2) is
1863: select *
1864: from AK_ATTRIBUTES_TL
1865: where ATTRIBUTE_APPLICATION_ID = appl_id_parm
1866: and ATTRIBUTE_CODE like attr_code_parm
1867: and LANGUAGE = lang_parm;
1868: cursor l_percent_check (attr_code_parm varchar2) is
1874: l_attribute_found BOOLEAN;
1875: i number;
1876: l_attribute_appl_id NUMBER;
1877: l_attributes_rec ak_attributes%ROWTYPE;
1878: l_attributes_tl_rec ak_attributes_tl%ROWTYPE;
1879: l_return_status varchar2(1);
1880: l_select_by_appl_id BOOLEAN;
1881: l_percent NUMBER;
1882: begin
2612: if (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
2613: select aa.last_updated_by, aat.last_updated_by,
2614: aa.last_update_date, aat.last_update_date
2615: into l_user_id1, l_user_id2, l_update1, l_update2
2616: from ak_attributes aa, ak_attributes_tl aat
2617: where aa.attribute_code = l_attribute_rec.attribute_code
2618: and aa.attribute_application_id = l_attribute_rec.attribute_application_id
2619: and aa.attribute_code = aat.attribute_code
2620: and aa.attribute_application_id = aat.attribute_application_id
3123: and ATTRIBUTE_CODE = p_attribute_code
3124: for update of ATTRIBUTE_APPLICATION_ID;
3125: cursor l_get_tl_row_csr (lang_parm varchar2) is
3126: select *
3127: from AK_ATTRIBUTES_TL
3128: where ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
3129: and ATTRIBUTE_CODE = p_attribute_code
3130: and LANGUAGE = lang_parm
3131: for update of ATTRIBUTE_APPLICATION_ID;
3146: and ri.to_url_attribute_code = p_attribute_code;
3147: l_api_version_number CONSTANT number := 1.0;
3148: l_api_name CONSTANT varchar2(30) := 'Update_Attribute';
3149: l_attributes_rec ak_attributes%ROWTYPE;
3150: l_attributes_tl_rec ak_attributes_tl%ROWTYPE;
3151: l_created_by number;
3152: l_creation_date date;
3153: l_dummy number;
3154: l_error boolean;
3193: end if;
3194: close l_get_row_csr;
3195:
3196: --
3197: -- retrieve ak_attributes_tl row if it exists
3198: --
3199: open l_get_tl_row_csr(l_lang);
3200: fetch l_get_tl_row_csr into l_attributes_tl_rec;
3201: if (l_get_tl_row_csr%notfound) then
3565: end if;
3566: raise FND_API.G_EXC_ERROR;
3567: end if;
3568:
3569: update AK_ATTRIBUTES_TL set
3570: NAME = l_attributes_tl_rec.name,
3571: ATTRIBUTE_LABEL_LONG = l_attributes_tl_rec.attribute_label_long,
3572: ATTRIBUTE_LABEL_SHORT = l_attributes_tl_rec.attribute_label_short,
3573: DESCRIPTION = l_attributes_tl_rec.description,