eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_REGION_PVT dependencies on AK_REGIONS

Line 53: from AK_REGIONS

49: p_pass IN NUMBER := 2
50: ) return BOOLEAN is
51: cursor l_check_region_csr is
52: select region_style
53: from AK_REGIONS
54: where region_application_id = p_region_application_id
55: and region_code = p_region_code;
56:
57: l_api_version_number CONSTANT number := 1.0;

Line 293: from AK_REGIONS

289: p_pass IN NUMBER := 2
290: ) return BOOLEAN is
291: cursor l_check_region_csr is
292: select database_object_name
293: from AK_REGIONS
294: where region_application_id = p_region_application_id
295: and region_code = p_region_code;
296: cursor l_check_seq_csr is
297: select 1

Line 2842: from AK_REGIONS

2838: p_nls_language IN VARCHAR2
2839: ) is
2840: cursor l_get_region_csr is
2841: select *
2842: from AK_REGIONS
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 *

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 2854: l_regions_rec AK_REGIONS%ROWTYPE;

2850: and LANGUAGE = p_nls_language;
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

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 5193: insert into AK_REGIONS (

5189:
5190: select userenv('LANG') into l_lang
5191: from dual;
5192:
5193: insert into AK_REGIONS (
5194: REGION_APPLICATION_ID,
5195: REGION_CODE,
5196: DATABASE_OBJECT_NAME,
5197: REGION_STYLE,

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 6271: delete from ak_regions

6267: --
6268: -- delete region item once we checked that there are no references
6269: -- to it, or all references have been deleted.
6270: --
6271: delete from ak_regions
6272: where region_application_id = p_region_application_id
6273: and region_code = p_region_code;
6274:
6275: if (sql%notfound) then

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 6392: from AK_REGIONS

6388: p_get_object_flag IN VARCHAR2
6389: ) is
6390: cursor l_get_region_list_csr (application_id number) is
6391: select region_application_id, region_code
6392: from AK_REGIONS
6393: where REGION_APPLICATION_ID = application_id;
6394: cursor l_get_region_items_csr (region_appl_id_param number,
6395: region_code_param varchar2) is
6396: select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE

Line 6404: from AK_OBJECT_ATTRIBUTE_NAVIGATION aoan, AK_REGIONS ar

6400: and object_attribute_flag = 'N';
6401: cursor l_get_target_regions_csr (region_appl_id_param number,
6402: region_code_param varchar2) is
6403: select distinct to_region_appl_id, to_region_code
6404: from AK_OBJECT_ATTRIBUTE_NAVIGATION aoan, AK_REGIONS ar
6405: where ar.region_application_id = region_appl_id_param
6406: and ar.region_code = region_code_param
6407: and aoan.database_object_name = ar.database_object_name;
6408: cursor l_get_database_object_name_csr (region_appl_id_param number,

Line 6411: from AK_REGIONS

6407: and aoan.database_object_name = ar.database_object_name;
6408: cursor l_get_database_object_name_csr (region_appl_id_param number,
6409: region_code_param varchar2) is
6410: select DATABASE_OBJECT_NAME
6411: from AK_REGIONS
6412: where region_application_id = region_appl_id_param
6413: and region_code = region_code_param;
6414: cursor l_get_ri_lov_regions_csr (region_appl_id_param number,
6415: region_code_param varchar2) is

Line 6425: from AK_REGIONS ar, AK_OBJECT_ATTRIBUTES aoa

6421: and lov_region_code is not null;
6422: cursor l_get_oa_lov_regions_csr (region_appl_id_param number,
6423: region_code_param varchar2) is
6424: select distinct aoa.lov_region_application_id, aoa.lov_region_code
6425: from AK_REGIONS ar, AK_OBJECT_ATTRIBUTES aoa
6426: where ar.region_application_id = region_appl_id_param
6427: and ar.region_code = region_code_param
6428: and ar.database_object_name = aoa.database_object_name
6429: and aoa.lov_region_application_id is not null

Line 6988: from AK_REGIONS

6984: p_region_code IN VARCHAR2
6985: ) return BOOLEAN is
6986: cursor l_check_region_csr is
6987: select 1
6988: from AK_REGIONS
6989: where region_application_id = p_region_application_id
6990: and region_code = p_region_code;
6991: l_api_version_number CONSTANT number := 1.0;
6992: l_api_name CONSTANT varchar2(30) := 'Region_Exists';

Line 8350: from AK_REGIONS

8346: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
8347: ) is
8348: cursor l_get_row_csr is
8349: select *
8350: from AK_REGIONS
8351: where REGION_APPLICATION_ID = p_region_application_id
8352: and REGION_CODE = p_region_code
8353: for update of REGION_STYLE;
8354: cursor l_get_tl_row_csr (lang_parm varchar2) is

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 8365: l_regions_rec AK_REGIONS%ROWTYPE;

8361: l_api_version_number CONSTANT number := 1.0;
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;

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 8393: -- retrieve ak_regions row if it exists

8389:
8390: select userenv('LANG') into l_lang
8391: from dual;
8392:
8393: --** retrieve ak_regions row if it exists **
8394: open l_get_row_csr;
8395: fetch l_get_row_csr into l_regions_rec;
8396: if (l_get_row_csr%notfound) then
8397: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

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 8683: update AK_REGIONS set

8679: p_db_last_update_date => l_regions_rec.last_update_date,
8680: p_last_update_login => l_last_update_login,
8681: p_create_or_update => 'UPDATE') then
8682:
8683: update AK_REGIONS set
8684: DATABASE_OBJECT_NAME = l_regions_rec.database_object_name,
8685: REGION_STYLE = l_regions_rec.region_style,
8686: ICX_CUSTOM_CALL = l_regions_rec.icx_custom_call,
8687: NUM_COLUMNS = l_regions_rec.num_columns,

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,

Line 8864: from ak_regions_vl

8860: and nested_region_code is not null;
8861: cursor l_get_non_train_region_csr(region_appl_id_param number,
8862: region_code_param varchar2) is
8863: select region_application_id, region_code
8864: from ak_regions_vl
8865: where region_application_id = region_appl_id_param
8866: and region_code = region_code_param
8867: and region_style <> 'TRAIN';
8868: l_return_status varchar2(1);