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_CUSTOM_PVT dependencies on AK_CUSTOM_REGION_ITEMS

Line 1349: from AK_CUSTOM_REGION_ITEMS

1345: p_nls_language IN VARCHAR2
1346: ) is
1347: cursor l_get_cust_region_item_csr is
1348: select *
1349: from AK_CUSTOM_REGION_ITEMS
1350: where REGION_APPLICATION_ID = p_region_application_id
1351: and REGION_CODE = p_region_code
1352: and CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
1353: and CUSTOMIZATION_CODE = p_custom_code;

Line 1358: from AK_CUSTOM_REGION_ITEMS_TL

1354: cursor l_get_cust_region_item_tl_csr(param_attr_appl_id number,
1355: param_attr_code varchar2,
1356: param_property_name varchar2) is
1357: select *
1358: from AK_CUSTOM_REGION_ITEMS_TL
1359: where REGION_APPLICATION_ID = p_region_application_id
1360: and REGION_CODE = p_region_code
1361: and CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
1362: and CUSTOMIZATION_CODE = p_custom_code

Line 1370: l_cust_region_item_rec AK_CUSTOM_REGION_ITEMS%ROWTYPE;

1366: and LANGUAGE = p_nls_language;
1367: l_api_name CONSTANT varchar2(30) := 'Write_Cust_Reg_Item_to_buffer';
1368: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1369: l_index NUMBER;
1370: l_cust_region_item_rec AK_CUSTOM_REGION_ITEMS%ROWTYPE;
1371: l_cust_region_item_tl_rec AK_CUSTOM_REGION_ITEMS_TL%ROWTYPE;
1372: l_return_status varchar2(1);
1373: begin
1374: -- Retrieve customization region item information from the database

Line 1371: l_cust_region_item_tl_rec AK_CUSTOM_REGION_ITEMS_TL%ROWTYPE;

1367: l_api_name CONSTANT varchar2(30) := 'Write_Cust_Reg_Item_to_buffer';
1368: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1369: l_index NUMBER;
1370: l_cust_region_item_rec AK_CUSTOM_REGION_ITEMS%ROWTYPE;
1371: l_cust_region_item_tl_rec AK_CUSTOM_REGION_ITEMS_TL%ROWTYPE;
1372: l_return_status varchar2(1);
1373: begin
1374: -- Retrieve customization region item information from the database
1375:

Line 3377: insert into AK_CUSTOM_REGION_ITEMS (

3373:
3374: select userenv('LANG') into l_lang
3375: from dual;
3376:
3377: insert into AK_CUSTOM_REGION_ITEMS (
3378: CUSTOMIZATION_APPLICATION_ID,
3379: CUSTOMIZATION_CODE,
3380: REGION_APPLICATION_ID,
3381: REGION_CODE,

Line 3430: insert into AK_CUSTOM_REGION_ITEMS_TL (

3426: --dbms_output.put_line(l_api_name || 'Error - row already exists');
3427: raise FND_API.G_EXC_ERROR;
3428: end if;
3429:
3430: insert into AK_CUSTOM_REGION_ITEMS_TL (
3431: CUSTOMIZATION_APPLICATION_ID,
3432: CUSTOMIZATION_CODE,
3433: REGION_APPLICATION_ID,
3434: REGION_CODE,

Line 3466: from AK_CUSTOM_REGION_ITEMS_TL T

3462: from FND_LANGUAGES L
3463: where L.INSTALLED_FLAG in ('I', 'B')
3464: and not exists
3465: (select NULL
3466: from AK_CUSTOM_REGION_ITEMS_TL T
3467: where T.CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
3468: and T.CUSTOMIZATION_CODE = p_custom_code
3469: and T.REGION_APPLICATION_ID = p_region_appl_id
3470: and T.REGION_CODE = p_region_code

Line 4024: from AK_CUSTOM_REGION_ITEMS

4020: p_property_name IN VARCHAR2
4021: ) return BOOLEAN is
4022: cursor l_check_csr is
4023: select 1
4024: from AK_CUSTOM_REGION_ITEMS
4025: where region_application_id = p_region_application_id
4026: and region_code = p_region_code
4027: and customization_application_id = p_custom_appl_id
4028: and customization_code = p_custom_code

Line 4433: delete AK_CUSTOM_REGION_ITEMS

4429: and REGION_CODE = p_region_code
4430: and CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
4431: and CUSTOMIZATION_CODE = p_custom_code;
4432:
4433: delete AK_CUSTOM_REGION_ITEMS
4434: where REGION_APPLICATION_ID = p_region_application_id
4435: and REGION_CODE = p_region_code
4436: and CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
4437: and CUSTOMIZATION_CODE = p_custom_code;

Line 4473: delete AK_CUSTOM_REGION_ITEMS_TL

4469: and REGION_CODE = p_region_code
4470: and CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
4471: and CUSTOMIZATION_CODE = p_custom_code;
4472:
4473: delete AK_CUSTOM_REGION_ITEMS_TL
4474: where REGION_APPLICATION_ID = p_region_application_id
4475: and REGION_CODE = p_region_code
4476: and CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
4477: and CUSTOMIZATION_CODE = p_custom_code;

Line 4919: from AK_CUSTOM_REGION_ITEMS

4915: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
4916: ) is
4917: cursor l_get_row_csr is
4918: select *
4919: from AK_CUSTOM_REGION_ITEMS
4920: where CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
4921: and CUSTOMIZATION_CODE = p_custom_code
4922: and REGION_APPLICATION_ID = p_region_application_id
4923: and REGION_CODE = p_region_code

Line 4930: from AK_CUSTOM_REGION_ITEMS_TL

4926: and PROPERTY_NAME = p_property_name
4927: for update of PROPERTY_VARCHAR2_VALUE;
4928: cursor l_get_tl_row_csr (lang_parm varchar2) is
4929: select *
4930: from AK_CUSTOM_REGION_ITEMS_TL
4931: where CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
4932: and CUSTOMIZATION_CODE = p_custom_code
4933: and REGION_APPLICATION_ID = p_region_application_id
4934: and REGION_CODE = p_region_code

Line 4944: l_cust_reg_item_rec ak_custom_region_items%ROWTYPE;

4940: l_api_version_number CONSTANT number := 1.0;
4941: l_api_name CONSTANT varchar2(30) := 'Update_Cust_Reg_Item';
4942: l_created_by number;
4943: l_creation_date date;
4944: l_cust_reg_item_rec ak_custom_region_items%ROWTYPE;
4945: l_cust_reg_item_tl_rec ak_custom_region_items_tl%ROWTYPE;
4946: l_error boolean;
4947: l_lang varchar2(30);
4948: l_last_update_date date;

Line 4945: l_cust_reg_item_tl_rec ak_custom_region_items_tl%ROWTYPE;

4941: l_api_name CONSTANT varchar2(30) := 'Update_Cust_Reg_Item';
4942: l_created_by number;
4943: l_creation_date date;
4944: l_cust_reg_item_rec ak_custom_region_items%ROWTYPE;
4945: l_cust_reg_item_tl_rec ak_custom_region_items_tl%ROWTYPE;
4946: l_error boolean;
4947: l_lang varchar2(30);
4948: l_last_update_date date;
4949: l_last_update_login number;

Line 4973: -- retrieve ak_custom_region_items row if it exists

4969:
4970: select userenv('LANG') into l_lang
4971: from dual;
4972:
4973: --** retrieve ak_custom_region_items row if it exists **
4974: open l_get_row_csr;
4975: fetch l_get_row_csr into l_cust_reg_item_rec;
4976: if (l_get_row_csr%notfound) then
4977: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 4987: -- retrieve ak_custom_region_items_tl row if it exists

4983: raise FND_API.G_EXC_ERROR;
4984: end if;
4985: close l_get_row_csr;
4986:
4987: --** retrieve ak_custom_region_items_tl row if it exists **
4988: open l_get_tl_row_csr(l_lang);
4989: fetch l_get_tl_row_csr into l_cust_reg_item_tl_rec;
4990: if (l_get_tl_row_csr%notfound) then
4991: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 5093: update AK_CUSTOM_REGION_ITEMS set

5089: p_create_or_update => 'UPDATE') then
5090: null;
5091: end if;
5092:
5093: update AK_CUSTOM_REGION_ITEMS set
5094: PROPERTY_VARCHAR2_VALUE = l_cust_reg_item_rec.property_varchar2_value,
5095: PROPERTY_NUMBER_VALUE = l_cust_reg_item_rec.property_number_value,
5096: PROPERTY_DATE_VALUE = l_cust_reg_item_rec.property_date_value,
5097: LAST_UPDATE_DATE = l_last_update_date,

Line 5116: update AK_CUSTOM_REGION_ITEMS_TL set

5112: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
5113: raise FND_API.G_EXC_ERROR;
5114: end if;
5115:
5116: update AK_CUSTOM_REGION_ITEMS_TL set
5117: PROPERTY_VARCHAR2_VALUE = l_cust_reg_item_tl_rec.property_varchar2_value,
5118: LAST_UPDATE_DATE = l_last_update_date,
5119: LAST_UPDATED_BY = l_last_updated_by,
5120: LAST_UPDATE_LOGIN = l_last_update_login,