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

5198:
5199: select userenv('LANG') into l_lang
5200: from dual;
5201:
5202: insert into AK_REGIONS (
5203: REGION_APPLICATION_ID,
5204: REGION_CODE,
5205: DATABASE_OBJECT_NAME,
5206: REGION_STYLE,

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

6278: --
6279: -- delete region item once we checked that there are no references
6280: -- to it, or all references have been deleted.
6281: --
6282: delete from ak_regions
6283: where region_application_id = p_region_application_id
6284: and region_code = p_region_code;
6285:
6286: if (sql%notfound) then

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

6399: p_get_object_flag IN VARCHAR2
6400: ) is
6401: cursor l_get_region_list_csr (application_id number) is
6402: select region_application_id, region_code
6403: from AK_REGIONS
6404: where REGION_APPLICATION_ID = application_id;
6405: cursor l_get_region_items_csr (region_appl_id_param number,
6406: region_code_param varchar2) is
6407: select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE

Line 6415: from AK_OBJECT_ATTRIBUTE_NAVIGATION aoan, AK_REGIONS ar

6411: and object_attribute_flag = 'N';
6412: cursor l_get_target_regions_csr (region_appl_id_param number,
6413: region_code_param varchar2) is
6414: select distinct to_region_appl_id, to_region_code
6415: from AK_OBJECT_ATTRIBUTE_NAVIGATION aoan, AK_REGIONS ar
6416: where ar.region_application_id = region_appl_id_param
6417: and ar.region_code = region_code_param
6418: and aoan.database_object_name = ar.database_object_name;
6419: cursor l_get_database_object_name_csr (region_appl_id_param number,

Line 6422: from AK_REGIONS

6418: and aoan.database_object_name = ar.database_object_name;
6419: cursor l_get_database_object_name_csr (region_appl_id_param number,
6420: region_code_param varchar2) is
6421: select DATABASE_OBJECT_NAME
6422: from AK_REGIONS
6423: where region_application_id = region_appl_id_param
6424: and region_code = region_code_param;
6425: cursor l_get_ri_lov_regions_csr (region_appl_id_param number,
6426: region_code_param varchar2) is

Line 6436: from AK_REGIONS ar, AK_OBJECT_ATTRIBUTES aoa

6432: and lov_region_code is not null;
6433: cursor l_get_oa_lov_regions_csr (region_appl_id_param number,
6434: region_code_param varchar2) is
6435: select distinct aoa.lov_region_application_id, aoa.lov_region_code
6436: from AK_REGIONS ar, AK_OBJECT_ATTRIBUTES aoa
6437: where ar.region_application_id = region_appl_id_param
6438: and ar.region_code = region_code_param
6439: and ar.database_object_name = aoa.database_object_name
6440: and aoa.lov_region_application_id is not null

Line 6999: from AK_REGIONS

6995: p_region_code IN VARCHAR2
6996: ) return BOOLEAN is
6997: cursor l_check_region_csr is
6998: select 1
6999: from AK_REGIONS
7000: where region_application_id = p_region_application_id
7001: and region_code = p_region_code;
7002: l_api_version_number CONSTANT number := 1.0;
7003: l_api_name CONSTANT varchar2(30) := 'Region_Exists';

Line 8367: from AK_REGIONS

8363: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
8364: ) is
8365: cursor l_get_row_csr is
8366: select *
8367: from AK_REGIONS
8368: where REGION_APPLICATION_ID = p_region_application_id
8369: and REGION_CODE = p_region_code
8370: for update of REGION_STYLE;
8371: cursor l_get_tl_row_csr (lang_parm varchar2) is

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

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

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

8406:
8407: select userenv('LANG') into l_lang
8408: from dual;
8409:
8410: --** retrieve ak_regions row if it exists **
8411: open l_get_row_csr;
8412: fetch l_get_row_csr into l_regions_rec;
8413: if (l_get_row_csr%notfound) then
8414: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

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

8699: p_db_last_update_date => l_regions_rec.last_update_date,
8700: p_last_update_login => l_last_update_login,
8701: p_create_or_update => 'UPDATE') then
8702:
8703: update AK_REGIONS set
8704: DATABASE_OBJECT_NAME = l_regions_rec.database_object_name,
8705: REGION_STYLE = l_regions_rec.region_style,
8706: ICX_CUSTOM_CALL = l_regions_rec.icx_custom_call,
8707: NUM_COLUMNS = l_regions_rec.num_columns,

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,

Line 8887: from ak_regions_vl

8883: and nested_region_code is not null;
8884: cursor l_get_non_train_region_csr(region_appl_id_param number,
8885: region_code_param varchar2) is
8886: select region_application_id, region_code
8887: from ak_regions_vl
8888: where region_application_id = region_appl_id_param
8889: and region_code = region_code_param
8890: and region_style <> 'TRAIN';
8891: l_return_status varchar2(1);