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 3257: from ak_region_items ari, ak_region_items_tl arit

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

Line 3689: from ak_region_items

3685: cursor l_ri_csr ( region_code_param IN VARCHAR2,
3686: region_application_id_param IN NUMBER,
3687: display_sequence_param IN NUMBER) is
3688: select *
3689: from ak_region_items
3690: where region_code = region_code_param
3691: and region_application_id = region_application_id_param
3692: and display_sequence = display_sequence_param;
3693:

Line 3700: from ak_region_items_tl

3696: attribute_code_param IN VARCHAR2,
3697: attribute_application_id_param IN NUMBER,
3698: lang_param IN VARCHAR2) is
3699: select *
3700: from ak_region_items_tl
3701: where region_code = region_code_param
3702: and region_application_id = region_application_id_param
3703: and attribute_code = attribute_code_param
3704: and attribute_application_id = attribute_application_id_param

Line 3711: l_ri_rec ak_region_items%ROWTYPE;

3707: l_lang varchar2(30);
3708: l_api_name CONSTANT varchar2(30) := 'Check_Display_Sequence';
3709: l_new_display_sequence NUMBER;
3710: l_return_status VARCHAR2(1);
3711: l_ri_rec ak_region_items%ROWTYPE;
3712: l_orig_ri_rec ak_region_items%ROWTYPE;
3713: l_ri_tl_rec ak_region_items_tl%ROWTYPE;
3714:
3715: begin

Line 3712: l_orig_ri_rec ak_region_items%ROWTYPE;

3708: l_api_name CONSTANT varchar2(30) := 'Check_Display_Sequence';
3709: l_new_display_sequence NUMBER;
3710: l_return_status VARCHAR2(1);
3711: l_ri_rec ak_region_items%ROWTYPE;
3712: l_orig_ri_rec ak_region_items%ROWTYPE;
3713: l_ri_tl_rec ak_region_items_tl%ROWTYPE;
3714:
3715: begin
3716: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3713: l_ri_tl_rec ak_region_items_tl%ROWTYPE;

3709: l_new_display_sequence NUMBER;
3710: l_return_status VARCHAR2(1);
3711: l_ri_rec ak_region_items%ROWTYPE;
3712: l_orig_ri_rec ak_region_items%ROWTYPE;
3713: l_ri_tl_rec ak_region_items_tl%ROWTYPE;
3714:
3715: begin
3716: l_return_status := FND_API.G_RET_STS_SUCCESS;
3717: open l_ri_csr( p_region_code,

Line 4101: from AK_REGION_ITEMS

4097: cursor l_check_region_item_csr (param_region_code in varchar2,
4098: param_region_appl_id in number, param_attr_appl_id in number,
4099: param_attr_code in varchar2) is
4100: select 1
4101: from AK_REGION_ITEMS
4102: where region_application_id = param_region_appl_id
4103: and region_code = param_region_code
4104: and attribute_application_id = param_attr_appl_id
4105: and attribute_code = param_attr_code;

Line 4289: from AK_REGION_ITEMS

4285:
4286: cursor l_check_region_item_csr (param_region_code in varchar2, param_region_appl_id in number,
4287: param_attr_code in varchar2, param_attr_appl_id number) is
4288: select 1
4289: from AK_REGION_ITEMS
4290: where region_application_id = param_region_appl_id
4291: and region_code = param_region_code
4292: and attribute_application_id = param_attr_appl_id;
4293:

Line 5673: from AK_REGION_ITEMS

5669:
5670: cursor l_check_region_item_csr (param_region_code in varchar2, param_region_appl_id in number,
5671: param_attr_code in varchar2, param_attr_appl_id number) is
5672: select item_style
5673: from AK_REGION_ITEMS
5674: where region_application_id = param_region_appl_id
5675: and region_code = param_region_code
5676: and attribute_application_id = param_attr_appl_id
5677: and attribute_code = param_attr_code;