[Home] [Help]
662: null;
663: end if;
664:
665: select userenv('LANG') into l_lang
666: from dual;
667:
668: insert into AK_FLOWS (
669: FLOW_APPLICATION_ID,
670: FLOW_CODE,
1095: null;
1096: end if;
1097:
1098: select userenv('LANG') into l_lang
1099: from dual;
1100:
1101: insert into AK_FLOW_PAGES (
1102: FLOW_APPLICATION_ID,
1103: FLOW_CODE,
1641: null;
1642: end if;
1643:
1644: select userenv('LANG') into l_lang
1645: from dual;
1646:
1647: insert into AK_FLOW_PAGE_REGIONS (
1648: FLOW_APPLICATION_ID,
1649: FLOW_CODE,
2159: null;
2160: end if;
2161:
2162: select userenv('LANG') into l_lang
2163: from dual;
2164:
2165: insert into AK_FLOW_PAGE_REGION_ITEMS (
2166: FLOW_APPLICATION_ID,
2167: FLOW_CODE,
2570: null;
2571: end if;
2572:
2573: select userenv('LANG') into l_lang
2574: from dual;
2575:
2576: insert into AK_FLOW_REGION_RELATIONS (
2577: FLOW_APPLICATION_ID,
2578: FLOW_CODE,
4195:
4196: savepoint start_update_flow;
4197:
4198: select userenv('LANG') into l_lang
4199: from dual;
4200:
4201: --
4202: -- retrieve ak_flows row if it exists
4203: --
4596:
4597: savepoint start_update_page;
4598:
4599: select userenv('LANG') into l_lang
4600: from dual;
4601:
4602: --
4603: -- retrieve ak_flow_pages row if it exists
4604: --
5061:
5062: savepoint start_update_page_region;
5063:
5064: select userenv('LANG') into l_lang
5065: from dual;
5066:
5067: --
5068: -- retrieve ak_flow_page_regions row if it exists
5069: --
5626:
5627: savepoint start_update_item;
5628:
5629: select userenv('LANG') into l_lang
5630: from dual;
5631:
5632: --
5633: -- retrieve ak_flow_page_region_items row if it exists
5634: --
6045:
6046: savepoint start_update_relation;
6047:
6048: select userenv('LANG') into l_lang
6049: from dual;
6050:
6051: --** retrieve ak_flow_region_relations row if it exists **
6052: open l_get_row_csr;
6053: fetch l_get_row_csr into l_relations_rec;