APPS.AK_CUSTOM_PVT dependencies on AK_CUSTOM_REGIONS_TL

Line 1144: from AK_CUSTOM_REGIONS_TL

1140: and CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
1141: and CUSTOMIZATION_CODE = p_custom_code;
1142: cursor l_get_cust_region_tl_csr(property_name_param varchar2) is
1143: select *
1144: from AK_CUSTOM_REGIONS_TL
1145: where REGION_APPLICATION_ID = p_region_application_id
1146: and REGION_CODE = p_region_code
1147: and CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
1148: and CUSTOMIZATION_CODE = p_custom_code

Line 1155: l_cust_region_tl_rec AK_CUSTOM_REGIONS_TL%ROWTYPE;

1151: l_api_name CONSTANT varchar2(30) := 'Write_Cust_Region_to_buffer';
1152: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1153: l_index NUMBER;
1154: l_cust_region_rec AK_CUSTOM_REGIONS%ROWTYPE;
1155: l_cust_region_tl_rec AK_CUSTOM_REGIONS_TL%ROWTYPE;
1156: l_return_status varchar2(1);
1157: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
1158: begin
1159: -- Retrieve customization region information from the database

Line 3092: insert into AK_CUSTOM_REGIONS_TL (

3088: --dbms_output.put_line(l_api_name || 'Error - row already exists');
3089: raise FND_API.G_EXC_ERROR;
3090: end if;
3091:
3092: insert into AK_CUSTOM_REGIONS_TL (
3093: CUSTOMIZATION_APPLICATION_ID,
3094: CUSTOMIZATION_CODE,
3095: REGION_APPLICATION_ID,
3096: REGION_CODE,

Line 3124: from AK_CUSTOM_REGIONS_TL T

3120: from FND_LANGUAGES L
3121: where L.INSTALLED_FLAG in ('I', 'B')
3122: and not exists
3123: (select NULL
3124: from AK_CUSTOM_REGIONS_TL T
3125: where T.CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
3126: and T.CUSTOMIZATION_CODE = p_custom_code
3127: and T.REGION_APPLICATION_ID = p_region_appl_id
3128: and T.REGION_CODE = p_region_code

Line 4467: delete AK_CUSTOM_REGIONS_TL

4463: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
4464: raise FND_API.G_EXC_ERROR;
4465: end if;
4466:
4467: delete AK_CUSTOM_REGIONS_TL
4468: where REGION_APPLICATION_ID = p_region_application_id
4469: and REGION_CODE = p_region_code
4470: and CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
4471: and CUSTOMIZATION_CODE = p_custom_code;

Line 4611: from AK_CUSTOM_REGIONS_TL

4607: and PROPERTY_NAME = p_property_name
4608: for update of PROPERTY_VARCHAR2_VALUE;
4609: cursor l_get_tl_row_csr (lang_parm varchar2) is
4610: select *
4611: from AK_CUSTOM_REGIONS_TL
4612: where CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
4613: and CUSTOMIZATION_CODE = p_custom_code
4614: and REGION_APPLICATION_ID = p_region_application_id
4615: and REGION_CODE = p_region_code

Line 4624: l_cust_region_tl_rec ak_custom_regions_tl%ROWTYPE;

4620: l_api_name CONSTANT varchar2(30) := 'Update_Custom';
4621: l_created_by number;
4622: l_creation_date date;
4623: l_cust_region_rec ak_custom_regions%ROWTYPE;
4624: l_cust_region_tl_rec ak_custom_regions_tl%ROWTYPE;
4625: l_error boolean;
4626: l_lang varchar2(30);
4627: l_last_update_date date;
4628: l_last_update_login number;

Line 4666: --** retrieve ak_custom_regions_tl row if it exists **

4662: raise FND_API.G_EXC_ERROR;
4663: end if;
4664: close l_get_row_csr;
4665:
4666: --** retrieve ak_custom_regions_tl row if it exists **
4667: open l_get_tl_row_csr(l_lang);
4668: fetch l_get_tl_row_csr into l_cust_region_tl_rec;
4669: if (l_get_tl_row_csr%notfound) then
4670: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 4791: update AK_CUSTOM_REGIONS_TL set

4787: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
4788: raise FND_API.G_EXC_ERROR;
4789: end if;
4790:
4791: update AK_CUSTOM_REGIONS_TL set
4792: PROPERTY_VARCHAR2_VALUE = l_cust_region_tl_rec.property_varchar2_value,
4793: LAST_UPDATE_DATE = l_last_update_date,
4794: LAST_UPDATED_BY = l_last_updated_by,
4795: LAST_UPDATE_LOGIN = l_last_update_login,