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 5317: insert into AK_REGIONS_TL (

5313: -- dbms_output.put_line(G_PKG_NAME || 'Error - First insert failed');
5314: raise FND_API.G_EXC_ERROR;
5315: end if;
5316:
5317: insert into AK_REGIONS_TL (
5318: REGION_APPLICATION_ID,
5319: REGION_CODE,
5320: LANGUAGE,
5321: NAME,

Line 5345: from AK_REGIONS_TL T

5341: from FND_LANGUAGES L
5342: where L.INSTALLED_FLAG in ('I', 'B')
5343: and not exists
5344: (select NULL
5345: from AK_REGIONS_TL T
5346: where T.REGION_APPLICATION_ID = p_region_application_id
5347: and T.REGION_CODE = p_region_code
5348: and T.LANGUAGE = L.LANGUAGE_CODE);
5349:

Line 6283: delete from ak_regions_tl

6279: end if;
6280: raise FND_API.G_EXC_ERROR;
6281: end if;
6282:
6283: delete from ak_regions_tl
6284: where region_application_id = p_region_application_id
6285: and region_code = p_region_code;
6286:
6287: if (sql%notfound) then

Line 8356: from AK_REGIONS_TL

8352: and REGION_CODE = p_region_code
8353: for update of REGION_STYLE;
8354: cursor l_get_tl_row_csr (lang_parm varchar2) is
8355: select *
8356: from AK_REGIONS_TL
8357: where REGION_APPLICATION_ID = p_region_application_id
8358: and REGION_CODE = p_region_code
8359: and LANGUAGE = lang_parm
8360: for update of NAME;

Line 8366: l_regions_tl_rec AK_REGIONS_TL%ROWTYPE;

8362: l_api_name CONSTANT varchar2(30) := 'Update_Region';
8363: l_created_by number;
8364: l_creation_date date;
8365: l_regions_rec AK_REGIONS%ROWTYPE;
8366: l_regions_tl_rec AK_REGIONS_TL%ROWTYPE;
8367: l_isform_flag VARCHAR2(1) := 'N';
8368: l_lang varchar2(30);
8369: l_last_update_date date;
8370: l_last_update_login number;

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

8403: raise FND_API.G_EXC_ERROR;
8404: end if;
8405: close l_get_row_csr;
8406:
8407: --** retrieve ak_regions_tl row if it exists **
8408: open l_get_tl_row_csr(l_lang);
8409: fetch l_get_tl_row_csr into l_regions_tl_rec;
8410: if (l_get_tl_row_csr%notfound) then
8411: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 8743: update AK_REGIONS_TL set

8739: end if;
8740: raise FND_API.G_EXC_ERROR;
8741: end if;
8742:
8743: update AK_REGIONS_TL set
8744: NAME = l_regions_tl_rec.name,
8745: DESCRIPTION = l_regions_tl_rec.description,
8746: LAST_UPDATE_DATE = l_last_update_date,
8747: LAST_UPDATED_BY = l_last_updated_by,