[Home] [Help]
247: BEGIN
248: FND_MSG_PUB.Initialize;
249: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
250:
251: INSERT INTO ak_customizations (
252: customization_application_id
253: ,customization_code
254: ,region_application_id
255: ,region_code
296: ,p_Customizations_Rec.developer_mode
297: );
298:
299:
300: INSERT INTO ak_customizations_tl (
301: customization_application_id
302: ,customization_code
303: ,region_application_id
304: ,region_code
328: FROM fnd_languages L
329: WHERE L.installed_flag IN ('I', 'B')
330: AND NOT EXISTS
331: (SELECT NULL
332: FROM ak_customizations_tl T
333: WHERE T.customization_application_id = p_Customizations_Rec.customization_application_id
334: AND T.customization_code = p_Customizations_Rec.customization_code
335: AND T.region_application_id = p_Customizations_Rec.region_application_id
336: AND T.region_code = p_Customizations_Rec.region_code
393: BEGIN
394: FND_MSG_PUB.Initialize;
395: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
396:
397: UPDATE ak_customizations SET
398: customization_application_id = p_Customizations_Rec.customization_application_id
399: ,customization_code = p_Customizations_Rec.customization_code
400: ,region_application_id = p_Customizations_Rec.region_application_id
401: ,region_code = p_Customizations_Rec.region_code
419: AND customization_code = p_Customizations_Rec.customization_code
420: AND region_application_id = p_Customizations_Rec.region_application_id
421: AND region_code = p_Customizations_Rec.region_code;
422:
423: UPDATE AK_CUSTOMIZATIONS_TL SET
424: name = p_Customizations_Rec.name
425: ,description = p_Customizations_Rec.description
426: ,last_updated_by = NVL(p_Customizations_Rec.last_updated_by,FND_GLOBAL.USER_ID)
427: ,last_update_date = NVL(p_Customizations_Rec.last_update_date,SYSDATE)