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_REGION2_PVT dependencies on AK_REGION_ITEMS

Line 76: from AK_REGION_ITEMS

72: where name =p_category_name;
73: cursor l_get_region_item_csr (region_appl_id_param number,
74: region_code_param varchar2) is
75: select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
76: from AK_REGION_ITEMS
77: where region_application_id = region_appl_id_param
78: and region_code = region_code_param;
79: l_api_version_number CONSTANT number := 1.0;
80: l_api_name CONSTANT varchar2(30) := 'Upload_Region';

Line 2124: from ak_region_items ari, ak_region_items_tl arit

2120: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
2121: select ari.last_updated_by, arit.last_updated_by,
2122: ari.last_update_date, arit.last_update_date
2123: into l_user_id1, l_user_id2, l_update1, l_update2
2124: from ak_region_items ari, ak_region_items_tl arit
2125: where ari.region_code = l_item_tbl(l_index).region_code
2126: and ari.region_application_id = l_item_tbl(l_index).region_application_id
2127: and ari.attribute_code = l_item_tbl(l_index).attribute_code
2128: and ari.attribute_application_id = l_item_tbl(l_index).attribute_application_id

Line 3259: from ak_region_items ari, ak_region_items_tl arit

3255: elsif ( AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE ) then
3256: select ari.last_updated_by, arit.last_updated_by,
3257: ari.last_update_date, arit.last_update_date
3258: into l_user_id1, l_user_id2, l_update1, l_update2
3259: from ak_region_items ari, ak_region_items_tl arit
3260: where ari.region_code = G_ITEM_REDO_TBL(l_index).region_code
3261: and ari.region_application_id = G_ITEM_REDO_TBL(l_index).region_application_id
3262: and ari.attribute_code = G_ITEM_REDO_TBL(l_index).attribute_code
3263: and ari.attribute_application_id = G_ITEM_REDO_TBL(l_index).attribute_application_id

Line 3706: from ak_region_items

3702: cursor l_ri_csr ( region_code_param IN VARCHAR2,
3703: region_application_id_param IN NUMBER,
3704: display_sequence_param IN NUMBER) is
3705: select *
3706: from ak_region_items
3707: where region_code = region_code_param
3708: and region_application_id = region_application_id_param
3709: and display_sequence = display_sequence_param;
3710:

Line 3717: from ak_region_items_tl

3713: attribute_code_param IN VARCHAR2,
3714: attribute_application_id_param IN NUMBER,
3715: lang_param IN VARCHAR2) is
3716: select *
3717: from ak_region_items_tl
3718: where region_code = region_code_param
3719: and region_application_id = region_application_id_param
3720: and attribute_code = attribute_code_param
3721: and attribute_application_id = attribute_application_id_param

Line 3728: l_ri_rec ak_region_items%ROWTYPE;

3724: l_lang varchar2(30);
3725: l_api_name CONSTANT varchar2(30) := 'Check_Display_Sequence';
3726: l_new_display_sequence NUMBER;
3727: l_return_status VARCHAR2(1);
3728: l_ri_rec ak_region_items%ROWTYPE;
3729: l_orig_ri_rec ak_region_items%ROWTYPE;
3730: l_ri_tl_rec ak_region_items_tl%ROWTYPE;
3731:
3732: begin

Line 3729: l_orig_ri_rec ak_region_items%ROWTYPE;

3725: l_api_name CONSTANT varchar2(30) := 'Check_Display_Sequence';
3726: l_new_display_sequence NUMBER;
3727: l_return_status VARCHAR2(1);
3728: l_ri_rec ak_region_items%ROWTYPE;
3729: l_orig_ri_rec ak_region_items%ROWTYPE;
3730: l_ri_tl_rec ak_region_items_tl%ROWTYPE;
3731:
3732: begin
3733: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3730: l_ri_tl_rec ak_region_items_tl%ROWTYPE;

3726: l_new_display_sequence NUMBER;
3727: l_return_status VARCHAR2(1);
3728: l_ri_rec ak_region_items%ROWTYPE;
3729: l_orig_ri_rec ak_region_items%ROWTYPE;
3730: l_ri_tl_rec ak_region_items_tl%ROWTYPE;
3731:
3732: begin
3733: l_return_status := FND_API.G_RET_STS_SUCCESS;
3734: open l_ri_csr( p_region_code,

Line 4118: from AK_REGION_ITEMS

4114: cursor l_check_region_item_csr (param_region_code in varchar2,
4115: param_region_appl_id in number, param_attr_appl_id in number,
4116: param_attr_code in varchar2) is
4117: select 1
4118: from AK_REGION_ITEMS
4119: where region_application_id = param_region_appl_id
4120: and region_code = param_region_code
4121: and attribute_application_id = param_attr_appl_id
4122: and attribute_code = param_attr_code;

Line 4306: from AK_REGION_ITEMS

4302:
4303: cursor l_check_region_item_csr (param_region_code in varchar2, param_region_appl_id in number,
4304: param_attr_code in varchar2, param_attr_appl_id number) is
4305: select 1
4306: from AK_REGION_ITEMS
4307: where region_application_id = param_region_appl_id
4308: and region_code = param_region_code
4309: and attribute_application_id = param_attr_appl_id;
4310:

Line 5701: from AK_REGION_ITEMS

5697:
5698: cursor l_check_region_item_csr (param_region_code in varchar2, param_region_appl_id in number,
5699: param_attr_code in varchar2, param_attr_appl_id number) is
5700: select item_style
5701: from AK_REGION_ITEMS
5702: where region_application_id = param_region_appl_id
5703: and region_code = param_region_code
5704: and attribute_application_id = param_attr_appl_id
5705: and attribute_code = param_attr_code;