2699: null;
2700: end if;
2701:
2702: select userenv('LANG') into l_lang
2703: from dual;
2704:
2705: insert into AK_CUSTOMIZATIONS (
2706: CUSTOMIZATION_APPLICATION_ID,
2707: CUSTOMIZATION_CODE,
3039: null;
3040: end if;
3041:
3042: select userenv('LANG') into l_lang
3043: from dual;
3044:
3045: insert into AK_CUSTOM_REGIONS (
3046: CUSTOMIZATION_APPLICATION_ID,
3047: CUSTOMIZATION_CODE,
3371: null;
3372: end if;
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,
3728: null;
3729: end if;
3730:
3731: select userenv('LANG') into l_lang
3732: from dual;
3733:
3734: insert into AK_CRITERIA (
3735: CUSTOMIZATION_APPLICATION_ID,
3736: CUSTOMIZATION_CODE,
4250:
4251: savepoint start_update_custom;
4252:
4253: select userenv('LANG') into l_lang
4254: from dual;
4255:
4256: --** retrieve ak_customizations row if it exists **
4257: open l_get_row_csr;
4258: fetch l_get_row_csr into l_custom_rec;
4646:
4647: savepoint start_update_cust_region;
4648:
4649: select userenv('LANG') into l_lang
4650: from dual;
4651:
4652: --** retrieve ak_custom_regions row if it exists **
4653: open l_get_row_csr;
4654: fetch l_get_row_csr into l_cust_region_rec;
4967:
4968: savepoint start_update_cust_reg_item;
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;