APPS.AK_CUSTOM_PVT dependencies on AK_CUSTOMIZATIONS_TL

Line 770: from AK_CUSTOMIZATIONS_TL

766: and CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
767: and CUSTOMIZATION_CODE = p_custom_code;
768: cursor l_get_custom_tl_csr is
769: select *
770: from AK_CUSTOMIZATIONS_TL
771: where REGION_APPLICATION_ID = p_region_application_id
772: and REGION_CODE = p_region_code
773: and CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
774: and CUSTOMIZATION_CODE = p_custom_code

Line 780: l_custom_tl_rec AK_CUSTOMIZATIONS_TL%ROWTYPE;

776: l_api_name CONSTANT varchar2(30) := 'Write_Custom_to_buffer';
777: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
778: l_index NUMBER;
779: l_custom_rec AK_CUSTOMIZATIONS%ROWTYPE;
780: l_custom_tl_rec AK_CUSTOMIZATIONS_TL%ROWTYPE;
781: l_return_status varchar2(1);
782: begin
783: -- Retrieve customization information from the database
784:

Line 2769: insert into AK_CUSTOMIZATIONS_TL (

2765: --dbms_output.put_line(l_api_name || 'Error - row already exists');
2766: raise FND_API.G_EXC_ERROR;
2767: end if;
2768:
2769: insert into AK_CUSTOMIZATIONS_TL (
2770: CUSTOMIZATION_APPLICATION_ID,
2771: CUSTOMIZATION_CODE,
2772: REGION_APPLICATION_ID,
2773: REGION_CODE,

Line 2801: from AK_CUSTOMIZATIONS_TL T

2797: from FND_LANGUAGES L
2798: where L.INSTALLED_FLAG in ('I', 'B')
2799: and not exists
2800: (select NULL
2801: from AK_CUSTOMIZATIONS_TL T
2802: where T.CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
2803: and T.CUSTOMIZATION_CODE = p_custom_code
2804: and T.REGION_APPLICATION_ID = p_region_appl_id
2805: and T.REGION_CODE = p_region_code

Line 4216: from AK_CUSTOMIZATIONS_TL

4212: and REGION_CODE = p_region_code
4213: for update of VERTICALIZATION_ID;
4214: cursor l_get_tl_row_csr (lang_parm varchar2) is
4215: select *
4216: from AK_CUSTOMIZATIONS_TL
4217: where CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
4218: and CUSTOMIZATION_CODE = p_custom_code
4219: and REGION_APPLICATION_ID = p_region_application_id
4220: and REGION_CODE = p_region_code

Line 4228: l_custom_tl_rec ak_customizations_tl%ROWTYPE;

4224: l_api_name CONSTANT varchar2(30) := 'Update_Custom';
4225: l_created_by number;
4226: l_creation_date date;
4227: l_custom_rec ak_customizations%ROWTYPE;
4228: l_custom_tl_rec ak_customizations_tl%ROWTYPE;
4229: l_error boolean;
4230: l_lang varchar2(30);
4231: l_last_update_date date;
4232: l_last_update_login number;

Line 4270: --** retrieve ak_customizations_tl row if it exists **

4266: raise FND_API.G_EXC_ERROR;
4267: end if;
4268: close l_get_row_csr;
4269:
4270: --** retrieve ak_customizations_tl row if it exists **
4271: open l_get_tl_row_csr(l_lang);
4272: fetch l_get_tl_row_csr into l_custom_tl_rec;
4273: if (l_get_tl_row_csr%notfound) then
4274: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 4479: update AK_CUSTOMIZATIONS_TL set

4475: and REGION_CODE = p_region_code
4476: and CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
4477: and CUSTOMIZATION_CODE = p_custom_code;
4478:
4479: update AK_CUSTOMIZATIONS_TL set
4480: NAME = l_custom_tl_rec.name,
4481: DESCRIPTION = l_custom_tl_rec.description,
4482: LAST_UPDATED_BY = l_last_updated_by,
4483: LAST_UPDATE_DATE = l_last_update_date,