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_REGION_ITEMS

Line 298: from AK_REGION_ITEMS

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
298: from AK_REGION_ITEMS
299: where region_application_id = p_region_application_id
300: and region_code = p_region_code
301: and display_sequence = p_display_sequence
302: and ( (attribute_application_id <> p_attribute_application_id)

Line 1946: from AK_REGION_ITEMS

1942: p_nls_language IN VARCHAR2
1943: ) is
1944: cursor l_get_items_csr is
1945: select *
1946: from AK_REGION_ITEMS
1947: where REGION_APPLICATION_ID = p_region_application_id
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

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 1977: from ak_category_usages acu, ak_region_items ari

1973: region_code_param varchar2,
1974: attribute_appl_id_param number,
1975: attribute_code_param varchar2) is
1976: select 1
1977: from ak_category_usages acu, ak_region_items ari
1978: where acu.region_code = region_code_param
1979: and acu.region_application_id = region_appl_id_param
1980: and acu.attribute_code = attribute_code_param
1981: and acu.attribute_application_id = attribute_appl_id_param

Line 1992: l_items_rec AK_REGION_ITEMS%ROWTYPE;

1988:
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;

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 4357: insert into AK_REGION_ITEMS (

4353:
4354: select userenv('LANG') into l_lang
4355: from dual;
4356:
4357: insert into AK_REGION_ITEMS (
4358: REGION_APPLICATION_ID,
4359: REGION_CODE,
4360: ATTRIBUTE_APPLICATION_ID,
4361: ATTRIBUTE_CODE,

Line 4557: insert into AK_REGION_ITEMS_TL (

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

Line 4591: from AK_REGION_ITEMS_TL T

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

Line 5934: delete from ak_region_items

5930: --
5931: -- delete region item once we checked that there are no references
5932: -- to it, or all references have been deleted.
5933: --
5934: delete from ak_region_items
5935: where region_application_id = p_region_application_id
5936: and region_code = p_region_code
5937: and attribute_application_id = p_attribute_application_id
5938: and attribute_code = p_attribute_code;

Line 5948: delete from ak_region_items_tl

5944: end if;
5945: raise FND_API.G_EXC_ERROR;
5946: end if;
5947:
5948: delete from ak_region_items_tl
5949: where region_application_id = p_region_application_id
5950: and region_code = p_region_code
5951: and attribute_application_id = p_attribute_application_id
5952: and attribute_code = p_attribute_code;

Line 6045: from AK_REGION_ITEMS

6041: p_delete_cascade IN VARCHAR2
6042: ) is
6043: cursor l_is_region_a_child_csr is
6044: select region_code, region_application_id
6045: from AK_REGION_ITEMS
6046: where region_code <> p_region_code
6047: and region_application_id <> p_region_application_id
6048: and (lov_region_code = p_region_code
6049: and lov_region_application_id = p_region_application_id)

Line 6059: from AK_REGION_ITEMS

6055: where region_application_id = p_region_application_id
6056: and region_code = p_region_code;
6057: cursor l_get_items_csr is
6058: select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
6059: from AK_REGION_ITEMS
6060: where region_application_id = p_region_application_id
6061: and region_code = p_region_code;
6062: cursor l_get_navigations_csr is
6063: select DATABASE_OBJECT_NAME, ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE,

Line 6143: -- AK_REGION_ITEMS

6139: -- If we are not deleting any referencing records, we cannot
6140: -- delete the region if it is being referenced in any of
6141: -- following tables.
6142: --
6143: -- AK_REGION_ITEMS
6144: --
6145: open l_get_items_csr;
6146: fetch l_get_items_csr into l_attribute_application_id, l_attribute_code;
6147: if l_get_items_csr%found then

Line 6408: from AK_REGION_ITEMS

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
6408: from AK_REGION_ITEMS
6409: where region_application_id = region_appl_id_param
6410: and region_code = region_code_param
6411: and object_attribute_flag = 'N';
6412: cursor l_get_target_regions_csr (region_appl_id_param number,

Line 6428: from AK_REGION_ITEMS

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
6427: select distinct lov_region_application_id, lov_region_code
6428: from AK_REGION_ITEMS
6429: where region_application_id = region_appl_id_param
6430: and region_code = region_code_param
6431: and lov_region_application_id is not null
6432: and lov_region_code is not null;

Line 6445: from AK_REGION_ITEMS ar, AK_ATTRIBUTES aa

6441: and aoa.lov_region_code is not null;
6442: cursor l_get_attr_lov_regions_csr (region_appl_id_param number,
6443: region_code_param varchar2) is
6444: select distinct aa.lov_region_application_id, aa.lov_region_code
6445: from AK_REGION_ITEMS ar, AK_ATTRIBUTES aa
6446: where ar.region_application_id = region_appl_id_param
6447: and ar.region_code = region_code_param
6448: and ar.object_attribute_flag = 'N'
6449: and ar.attribute_application_id = aa.attribute_application_id

Line 6457: from ak_region_items

6453: cursor l_get_lov_region_items_csr (region_appl_id_param number,
6454: region_code_param varchar2) is
6455: select region_application_id, region_code, attribute_application_id,
6456: attribute_code
6457: from ak_region_items
6458: where region_application_id = region_appl_id_param
6459: and region_code = region_code_param
6460: and object_attribute_flag = 'N'
6461: and lov_region_application_id is not null

Line 6927: from AK_REGION_ITEMS

6923: p_attribute_code IN VARCHAR2
6924: ) return BOOLEAN is
6925: cursor l_check_csr is
6926: select 1
6927: from AK_REGION_ITEMS
6928: where region_application_id = p_region_application_id
6929: and region_code = p_region_code
6930: and attribute_application_id = p_attribute_application_id
6931: and attribute_code = p_attribute_code;

Line 7454: from AK_REGION_ITEMS

7450: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
7451: ) is
7452: cursor l_get_row_csr is
7453: select *
7454: from AK_REGION_ITEMS
7455: where REGION_APPLICATION_ID = p_region_application_id
7456: and REGION_CODE = p_region_code
7457: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
7458: and ATTRIBUTE_CODE = p_attribute_code

Line 7462: from AK_REGION_ITEMS_TL

7458: and ATTRIBUTE_CODE = p_attribute_code
7459: for update of DISPLAY_SEQUENCE;
7460: cursor l_get_tl_row_csr (lang_parm varchar2) is
7461: select *
7462: from AK_REGION_ITEMS_TL
7463: where REGION_APPLICATION_ID = p_region_application_id
7464: and REGION_CODE = p_region_code
7465: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
7466: and ATTRIBUTE_CODE = p_attribute_code

Line 7473: l_items_rec ak_region_items%ROWTYPE;

7469: l_api_version_number CONSTANT number := 1.0;
7470: l_api_name CONSTANT varchar2(30) := 'Update_Item';
7471: l_created_by number;
7472: l_creation_date date;
7473: l_items_rec ak_region_items%ROWTYPE;
7474: l_items_tl_rec ak_region_items_tl%ROWTYPE;
7475: l_error boolean;
7476: l_lang varchar2(30);
7477: l_last_update_date date;

Line 7474: l_items_tl_rec ak_region_items_tl%ROWTYPE;

7470: l_api_name CONSTANT varchar2(30) := 'Update_Item';
7471: l_created_by number;
7472: l_creation_date date;
7473: l_items_rec ak_region_items%ROWTYPE;
7474: l_items_tl_rec ak_region_items_tl%ROWTYPE;
7475: l_error boolean;
7476: l_lang varchar2(30);
7477: l_last_update_date date;
7478: l_last_update_login number;

Line 7506: -- retrieve ak_region_items row if it exists

7502:
7503: select userenv('LANG') into l_lang
7504: from dual;
7505:
7506: --** retrieve ak_region_items row if it exists **
7507: open l_get_row_csr;
7508: fetch l_get_row_csr into l_items_rec;
7509: if (l_get_row_csr%notfound) then
7510: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 7520: -- retrieve ak_region_items_tl row if it exists

7516: raise FND_API.G_EXC_ERROR;
7517: end if;
7518: close l_get_row_csr;
7519:
7520: --** retrieve ak_region_items_tl row if it exists **
7521: open l_get_tl_row_csr(l_lang);
7522: fetch l_get_tl_row_csr into l_items_tl_rec;
7523: if (l_get_tl_row_csr%notfound) then
7524: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 8087: update AK_REGION_ITEMS set

8083: p_db_last_update_date => l_items_rec.last_update_date,
8084: p_last_update_login => l_last_update_login,
8085: p_create_or_update => l_create_or_update) then
8086:
8087: update AK_REGION_ITEMS set
8088: DISPLAY_SEQUENCE = l_items_rec.display_sequence,
8089: NODE_DISPLAY_FLAG = l_items_rec.node_display_flag,
8090: NODE_QUERY_FLAG = l_items_rec.node_query_flag,
8091: ATTRIBUTE_LABEL_LENGTH = l_items_rec.attribute_label_length,

Line 8186: update AK_REGION_ITEMS_TL set

8182: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
8183: raise FND_API.G_EXC_ERROR;
8184: end if;
8185:
8186: update AK_REGION_ITEMS_TL set
8187: ATTRIBUTE_LABEL_LONG = l_items_tl_rec.attribute_label_long,
8188: ATTRIBUTE_LABEL_SHORT = l_items_tl_rec.attribute_label_short,
8189: DESCRIPTION = l_items_tl_rec.description,
8190: LAST_UPDATED_BY = l_last_updated_by,

Line 8879: from AK_REGION_ITEMS

8875: ) IS
8876: cursor l_get_ri_nested_regions_csr (region_appl_id_param number,
8877: region_code_param varchar2) is
8878: select distinct nested_region_application_id, nested_region_code
8879: from AK_REGION_ITEMS
8880: where region_application_id = region_appl_id_param
8881: and region_code = region_code_param
8882: and nested_region_application_id is not null
8883: and nested_region_code is not null;