APPS.AK_REGION_PVT dependencies on AK_REGIONS_TL

Line 2847: from AK_REGIONS_TL

2843: where REGION_APPLICATION_ID = p_region_application_id
2844: and REGION_CODE = p_region_code;
2845: cursor l_get_region_tl_csr is
2846: select *
2847: from AK_REGIONS_TL
2848: where REGION_APPLICATION_ID = p_region_application_id
2849: and REGION_CODE = p_region_code
2850: and LANGUAGE = p_nls_language;
2851: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';

Line 2855: l_regions_tl_rec AK_REGIONS_TL%ROWTYPE;

2851: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
2852: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
2853: l_index NUMBER;
2854: l_regions_rec AK_REGIONS%ROWTYPE;
2855: l_regions_tl_rec AK_REGIONS_TL%ROWTYPE;
2856: l_return_status varchar2(1);
2857: begin
2858: -- Retrieve region information from the database
2859:

Line 5326: insert into AK_REGIONS_TL (

5322: -- dbms_output.put_line(G_PKG_NAME || 'Error - First insert failed');
5323: raise FND_API.G_EXC_ERROR;
5324: end if;
5325:
5326: insert into AK_REGIONS_TL (
5327: REGION_APPLICATION_ID,
5328: REGION_CODE,
5329: LANGUAGE,
5330: NAME,

Line 5354: from AK_REGIONS_TL T

5350: from FND_LANGUAGES L
5351: where L.INSTALLED_FLAG in ('I', 'B')
5352: and not exists
5353: (select NULL
5354: from AK_REGIONS_TL T
5355: where T.REGION_APPLICATION_ID = p_region_application_id
5356: and T.REGION_CODE = p_region_code
5357: and T.LANGUAGE = L.LANGUAGE_CODE);
5358:

Line 6294: delete from ak_regions_tl

6290: end if;
6291: raise FND_API.G_EXC_ERROR;
6292: end if;
6293:
6294: delete from ak_regions_tl
6295: where region_application_id = p_region_application_id
6296: and region_code = p_region_code;
6297:
6298: if (sql%notfound) then

Line 8373: from AK_REGIONS_TL

8369: and REGION_CODE = p_region_code
8370: for update of REGION_STYLE;
8371: cursor l_get_tl_row_csr (lang_parm varchar2) is
8372: select *
8373: from AK_REGIONS_TL
8374: where REGION_APPLICATION_ID = p_region_application_id
8375: and REGION_CODE = p_region_code
8376: and LANGUAGE = lang_parm
8377: for update of NAME;

Line 8383: l_regions_tl_rec AK_REGIONS_TL%ROWTYPE;

8379: l_api_name CONSTANT varchar2(30) := 'Update_Region';
8380: l_created_by number;
8381: l_creation_date date;
8382: l_regions_rec AK_REGIONS%ROWTYPE;
8383: l_regions_tl_rec AK_REGIONS_TL%ROWTYPE;
8384: l_isform_flag VARCHAR2(1) := 'N';
8385: l_lang varchar2(30);
8386: l_last_update_date date;
8387: l_last_update_login number;

Line 8424: --** retrieve ak_regions_tl row if it exists **

8420: raise FND_API.G_EXC_ERROR;
8421: end if;
8422: close l_get_row_csr;
8423:
8424: --** retrieve ak_regions_tl row if it exists **
8425: open l_get_tl_row_csr(l_lang);
8426: fetch l_get_tl_row_csr into l_regions_tl_rec;
8427: if (l_get_tl_row_csr%notfound) then
8428: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 8763: update AK_REGIONS_TL set

8759: end if;
8760: raise FND_API.G_EXC_ERROR;
8761: end if;
8762:
8763: update AK_REGIONS_TL set
8764: NAME = l_regions_tl_rec.name,
8765: DESCRIPTION = l_regions_tl_rec.description,
8766: LAST_UPDATE_DATE = l_last_update_date,
8767: LAST_UPDATED_BY = l_last_updated_by,