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

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

Line 4554: insert into AK_REGION_ITEMS_TL (

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

Line 4588: from AK_REGION_ITEMS_TL T

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

Line 5923: delete from ak_region_items

5919: --
5920: -- delete region item once we checked that there are no references
5921: -- to it, or all references have been deleted.
5922: --
5923: delete from ak_region_items
5924: where region_application_id = p_region_application_id
5925: and region_code = p_region_code
5926: and attribute_application_id = p_attribute_application_id
5927: and attribute_code = p_attribute_code;

Line 5937: delete from ak_region_items_tl

5933: end if;
5934: raise FND_API.G_EXC_ERROR;
5935: end if;
5936:
5937: delete from ak_region_items_tl
5938: where region_application_id = p_region_application_id
5939: and region_code = p_region_code
5940: and attribute_application_id = p_attribute_application_id
5941: and attribute_code = p_attribute_code;

Line 6034: from AK_REGION_ITEMS

6030: p_delete_cascade IN VARCHAR2
6031: ) is
6032: cursor l_is_region_a_child_csr is
6033: select region_code, region_application_id
6034: from AK_REGION_ITEMS
6035: where region_code <> p_region_code
6036: and region_application_id <> p_region_application_id
6037: and (lov_region_code = p_region_code
6038: and lov_region_application_id = p_region_application_id)

Line 6048: from AK_REGION_ITEMS

6044: where region_application_id = p_region_application_id
6045: and region_code = p_region_code;
6046: cursor l_get_items_csr is
6047: select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
6048: from AK_REGION_ITEMS
6049: where region_application_id = p_region_application_id
6050: and region_code = p_region_code;
6051: cursor l_get_navigations_csr is
6052: select DATABASE_OBJECT_NAME, ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE,

Line 6132: -- AK_REGION_ITEMS

6128: -- If we are not deleting any referencing records, we cannot
6129: -- delete the region if it is being referenced in any of
6130: -- following tables.
6131: --
6132: -- AK_REGION_ITEMS
6133: --
6134: open l_get_items_csr;
6135: fetch l_get_items_csr into l_attribute_application_id, l_attribute_code;
6136: if l_get_items_csr%found then

Line 6397: from AK_REGION_ITEMS

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
6397: from AK_REGION_ITEMS
6398: where region_application_id = region_appl_id_param
6399: and region_code = region_code_param
6400: and object_attribute_flag = 'N';
6401: cursor l_get_target_regions_csr (region_appl_id_param number,

Line 6417: from AK_REGION_ITEMS

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
6416: select distinct lov_region_application_id, lov_region_code
6417: from AK_REGION_ITEMS
6418: where region_application_id = region_appl_id_param
6419: and region_code = region_code_param
6420: and lov_region_application_id is not null
6421: and lov_region_code is not null;

Line 6434: from AK_REGION_ITEMS ar, AK_ATTRIBUTES aa

6430: and aoa.lov_region_code is not null;
6431: cursor l_get_attr_lov_regions_csr (region_appl_id_param number,
6432: region_code_param varchar2) is
6433: select distinct aa.lov_region_application_id, aa.lov_region_code
6434: from AK_REGION_ITEMS ar, AK_ATTRIBUTES aa
6435: where ar.region_application_id = region_appl_id_param
6436: and ar.region_code = region_code_param
6437: and ar.object_attribute_flag = 'N'
6438: and ar.attribute_application_id = aa.attribute_application_id

Line 6446: from ak_region_items

6442: cursor l_get_lov_region_items_csr (region_appl_id_param number,
6443: region_code_param varchar2) is
6444: select region_application_id, region_code, attribute_application_id,
6445: attribute_code
6446: from ak_region_items
6447: where region_application_id = region_appl_id_param
6448: and region_code = region_code_param
6449: and object_attribute_flag = 'N'
6450: and lov_region_application_id is not null

Line 6916: from AK_REGION_ITEMS

6912: p_attribute_code IN VARCHAR2
6913: ) return BOOLEAN is
6914: cursor l_check_csr is
6915: select 1
6916: from AK_REGION_ITEMS
6917: where region_application_id = p_region_application_id
6918: and region_code = p_region_code
6919: and attribute_application_id = p_attribute_application_id
6920: and attribute_code = p_attribute_code;

Line 7443: from AK_REGION_ITEMS

7439: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
7440: ) is
7441: cursor l_get_row_csr is
7442: select *
7443: from AK_REGION_ITEMS
7444: where REGION_APPLICATION_ID = p_region_application_id
7445: and REGION_CODE = p_region_code
7446: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
7447: and ATTRIBUTE_CODE = p_attribute_code

Line 7451: from AK_REGION_ITEMS_TL

7447: and ATTRIBUTE_CODE = p_attribute_code
7448: for update of DISPLAY_SEQUENCE;
7449: cursor l_get_tl_row_csr (lang_parm varchar2) is
7450: select *
7451: from AK_REGION_ITEMS_TL
7452: where REGION_APPLICATION_ID = p_region_application_id
7453: and REGION_CODE = p_region_code
7454: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
7455: and ATTRIBUTE_CODE = p_attribute_code

Line 7462: l_items_rec ak_region_items%ROWTYPE;

7458: l_api_version_number CONSTANT number := 1.0;
7459: l_api_name CONSTANT varchar2(30) := 'Update_Item';
7460: l_created_by number;
7461: l_creation_date date;
7462: l_items_rec ak_region_items%ROWTYPE;
7463: l_items_tl_rec ak_region_items_tl%ROWTYPE;
7464: l_error boolean;
7465: l_lang varchar2(30);
7466: l_last_update_date date;

Line 7463: l_items_tl_rec ak_region_items_tl%ROWTYPE;

7459: l_api_name CONSTANT varchar2(30) := 'Update_Item';
7460: l_created_by number;
7461: l_creation_date date;
7462: l_items_rec ak_region_items%ROWTYPE;
7463: l_items_tl_rec ak_region_items_tl%ROWTYPE;
7464: l_error boolean;
7465: l_lang varchar2(30);
7466: l_last_update_date date;
7467: l_last_update_login number;

Line 7495: -- retrieve ak_region_items row if it exists

7491:
7492: select userenv('LANG') into l_lang
7493: from dual;
7494:
7495: --** retrieve ak_region_items row if it exists **
7496: open l_get_row_csr;
7497: fetch l_get_row_csr into l_items_rec;
7498: if (l_get_row_csr%notfound) then
7499: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 7509: -- retrieve ak_region_items_tl row if it exists

7505: raise FND_API.G_EXC_ERROR;
7506: end if;
7507: close l_get_row_csr;
7508:
7509: --** retrieve ak_region_items_tl row if it exists **
7510: open l_get_tl_row_csr(l_lang);
7511: fetch l_get_tl_row_csr into l_items_tl_rec;
7512: if (l_get_tl_row_csr%notfound) then
7513: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 8073: update AK_REGION_ITEMS set

8069: p_db_last_update_date => l_items_rec.last_update_date,
8070: p_last_update_login => l_last_update_login,
8071: p_create_or_update => l_create_or_update) then
8072:
8073: update AK_REGION_ITEMS set
8074: DISPLAY_SEQUENCE = l_items_rec.display_sequence,
8075: NODE_DISPLAY_FLAG = l_items_rec.node_display_flag,
8076: NODE_QUERY_FLAG = l_items_rec.node_query_flag,
8077: ATTRIBUTE_LABEL_LENGTH = l_items_rec.attribute_label_length,

Line 8172: update AK_REGION_ITEMS_TL set

8168: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
8169: raise FND_API.G_EXC_ERROR;
8170: end if;
8171:
8172: update AK_REGION_ITEMS_TL set
8173: ATTRIBUTE_LABEL_LONG = l_items_tl_rec.attribute_label_long,
8174: ATTRIBUTE_LABEL_SHORT = l_items_tl_rec.attribute_label_short,
8175: DESCRIPTION = l_items_tl_rec.description,
8176: LAST_UPDATED_BY = l_last_updated_by,

Line 8856: from AK_REGION_ITEMS

8852: ) IS
8853: cursor l_get_ri_nested_regions_csr (region_appl_id_param number,
8854: region_code_param varchar2) is
8855: select distinct nested_region_application_id, nested_region_code
8856: from AK_REGION_ITEMS
8857: where region_application_id = region_appl_id_param
8858: and region_code = region_code_param
8859: and nested_region_application_id is not null
8860: and nested_region_code is not null;