APPS.AK_REGION_PVT dependencies on AK_REGION_ITEMS_TL

Line 1952: from AK_REGION_ITEMS_TL

1948: and REGION_CODE = p_region_code;
1949: cursor l_get_item_tl_csr (attribute_appl_id_param number,
1950: attribute_code_param varchar2) is
1951: select *
1952: from AK_REGION_ITEMS_TL
1953: where REGION_APPLICATION_ID = p_region_application_id
1954: and REGION_CODE = p_region_code
1955: and ATTRIBUTE_APPLICATION_ID = attribute_appl_id_param
1956: and ATTRIBUTE_CODE = attribute_code_param

Line 1993: l_items_tl_rec AK_REGION_ITEMS_TL%ROWTYPE;

1989: l_api_name CONSTANT varchar2(30) := 'Write_Item_to_buffer';
1990: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1991: l_index NUMBER;
1992: l_items_rec AK_REGION_ITEMS%ROWTYPE;
1993: l_items_tl_rec AK_REGION_ITEMS_TL%ROWTYPE;
1994: l_return_status varchar2(1);
1995: l_write_relation_flag boolean := false;
1996: l_write_category_usages_flag boolean := false;
1997: begin

Line 4557: insert into AK_REGION_ITEMS_TL (

4553: --dbms_output.put_line(l_api_name || 'Error - row already exists');
4554: raise FND_API.G_EXC_ERROR;
4555: end if;
4556:
4557: insert into AK_REGION_ITEMS_TL (
4558: REGION_APPLICATION_ID,
4559: REGION_CODE,
4560: ATTRIBUTE_APPLICATION_ID,
4561: ATTRIBUTE_CODE,

Line 4591: from AK_REGION_ITEMS_TL T

4587: from FND_LANGUAGES L
4588: where L.INSTALLED_FLAG in ('I', 'B')
4589: and not exists
4590: (select NULL
4591: from AK_REGION_ITEMS_TL T
4592: where T.REGION_APPLICATION_ID = p_region_application_id
4593: and T.REGION_CODE = p_region_code
4594: and T.ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
4595: and T.ATTRIBUTE_CODE = p_attribute_code

Line 5948: delete from ak_region_items_tl

5944: end if;
5945: raise FND_API.G_EXC_ERROR;
5946: end if;
5947:
5948: delete from ak_region_items_tl
5949: where region_application_id = p_region_application_id
5950: and region_code = p_region_code
5951: and attribute_application_id = p_attribute_application_id
5952: and attribute_code = p_attribute_code;

Line 7462: from AK_REGION_ITEMS_TL

7458: and ATTRIBUTE_CODE = p_attribute_code
7459: for update of DISPLAY_SEQUENCE;
7460: cursor l_get_tl_row_csr (lang_parm varchar2) is
7461: select *
7462: from AK_REGION_ITEMS_TL
7463: where REGION_APPLICATION_ID = p_region_application_id
7464: and REGION_CODE = p_region_code
7465: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
7466: and ATTRIBUTE_CODE = p_attribute_code

Line 7474: l_items_tl_rec ak_region_items_tl%ROWTYPE;

7470: l_api_name CONSTANT varchar2(30) := 'Update_Item';
7471: l_created_by number;
7472: l_creation_date date;
7473: l_items_rec ak_region_items%ROWTYPE;
7474: l_items_tl_rec ak_region_items_tl%ROWTYPE;
7475: l_error boolean;
7476: l_lang varchar2(30);
7477: l_last_update_date date;
7478: l_last_update_login number;

Line 7520: --** retrieve ak_region_items_tl row if it exists **

7516: raise FND_API.G_EXC_ERROR;
7517: end if;
7518: close l_get_row_csr;
7519:
7520: --** retrieve ak_region_items_tl row if it exists **
7521: open l_get_tl_row_csr(l_lang);
7522: fetch l_get_tl_row_csr into l_items_tl_rec;
7523: if (l_get_tl_row_csr%notfound) then
7524: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 8186: update AK_REGION_ITEMS_TL set

8182: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
8183: raise FND_API.G_EXC_ERROR;
8184: end if;
8185:
8186: update AK_REGION_ITEMS_TL set
8187: ATTRIBUTE_LABEL_LONG = l_items_tl_rec.attribute_label_long,
8188: ATTRIBUTE_LABEL_SHORT = l_items_tl_rec.attribute_label_short,
8189: DESCRIPTION = l_items_tl_rec.description,
8190: LAST_UPDATED_BY = l_last_updated_by,