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 4554: insert into AK_REGION_ITEMS_TL (

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

Line 4588: from AK_REGION_ITEMS_TL T

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

Line 5937: delete from ak_region_items_tl

5933: end if;
5934: raise FND_API.G_EXC_ERROR;
5935: end if;
5936:
5937: delete from ak_region_items_tl
5938: where region_application_id = p_region_application_id
5939: and region_code = p_region_code
5940: and attribute_application_id = p_attribute_application_id
5941: and attribute_code = p_attribute_code;

Line 7451: from AK_REGION_ITEMS_TL

7447: and ATTRIBUTE_CODE = p_attribute_code
7448: for update of DISPLAY_SEQUENCE;
7449: cursor l_get_tl_row_csr (lang_parm varchar2) is
7450: select *
7451: from AK_REGION_ITEMS_TL
7452: where REGION_APPLICATION_ID = p_region_application_id
7453: and REGION_CODE = p_region_code
7454: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
7455: and ATTRIBUTE_CODE = p_attribute_code

Line 7463: l_items_tl_rec ak_region_items_tl%ROWTYPE;

7459: l_api_name CONSTANT varchar2(30) := 'Update_Item';
7460: l_created_by number;
7461: l_creation_date date;
7462: l_items_rec ak_region_items%ROWTYPE;
7463: l_items_tl_rec ak_region_items_tl%ROWTYPE;
7464: l_error boolean;
7465: l_lang varchar2(30);
7466: l_last_update_date date;
7467: l_last_update_login number;

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

7505: raise FND_API.G_EXC_ERROR;
7506: end if;
7507: close l_get_row_csr;
7508:
7509: --** retrieve ak_region_items_tl row if it exists **
7510: open l_get_tl_row_csr(l_lang);
7511: fetch l_get_tl_row_csr into l_items_tl_rec;
7512: if (l_get_tl_row_csr%notfound) then
7513: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 8172: update AK_REGION_ITEMS_TL set

8168: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
8169: raise FND_API.G_EXC_ERROR;
8170: end if;
8171:
8172: update AK_REGION_ITEMS_TL set
8173: ATTRIBUTE_LABEL_LONG = l_items_tl_rec.attribute_label_long,
8174: ATTRIBUTE_LABEL_SHORT = l_items_tl_rec.attribute_label_short,
8175: DESCRIPTION = l_items_tl_rec.description,
8176: LAST_UPDATED_BY = l_last_updated_by,