[Home] [Help]
115: )
116: IS
117: CURSOR c_plsql IS
118: SELECT attribute8 plsql_function
119: from ak_Regions
120: where region_code = p_region_Code;
121:
122: CURSOR base_column_cursor(cpAttributeCode varchar2) IS
123: SELECT attribute3 base_column
616: l_count number := 0;
617: l_plsql_function varchar2(2000);
618: CURSOR c_viewby IS
619: SELECT attribute1 disable_viewby, attribute8 plsql_function
620: from ak_Regions
621: where region_code = p_region_Code;
622: CURSOR c_rankparam(pRegionCode in varchar2) IS
623: SELECT attribute_code, attribute2 from ak_region_items
624: WHERE display_Sequence = (select min(display_sequence)
1704: ) IS
1705:
1706: CURSOR c_viewby IS
1707: SELECT attribute1 disable_viewby, attribute8 plsql_function
1708: from ak_Regions
1709: where region_code = p_region_Code;
1710:
1711: CURSOR c_rankparam(pRegionCode in varchar2) IS
1712: SELECT attribute_code, attribute2 from ak_region_items