[Home] [Help]
185: l_function varchar2(2000);
186: begin
187: select name
188: into l_function
189: from ak_regions_vl
190: where region_code = pRegionCode;
191:
192: l_function := substr(l_function, instr(l_function, '[')+1, instr(l_function, ']')-instr(l_function,'[')-1);
193: if l_function is not null then
742: return varchar2
743: is
744: CURSOR c_akregion IS
745: SELECT attribute9
746: FROM ak_regions
747: WHERE region_code = p_region_code;
748: l_render_type varchar2(2000);
749: l_subtotal varchar2(2000);
750: BEGIN
782: -- nbarik 01/10/03 Portlet Builder
783: FUNCTION getRegionApplicationId(pRegionCode IN VARCHAR2) RETURN NUMBER IS
784:
785: CURSOR region_app_id_cursor(cp_region_code VARCHAR2) IS
786: SELECT region_application_id FROM ak_regions
787: WHERE region_code = cp_region_code;
788:
789: l_region_app_id NUMBER;
790:
1287: -- gbhaloti 05/25/04 Generic Report Designer
1288: FUNCTION getRegionApplicationName(pRegionCode IN VARCHAR2) RETURN VARCHAR2 IS
1289:
1290: CURSOR region_app_name_cursor(cp_region_code VARCHAR2) IS
1291: SELECT application_name FROM ak_regions R, fnd_application_vl A
1292: WHERE R.region_code = cp_region_code AND R.region_application_id = A.application_id;
1293:
1294: l_code VARCHAR2(3);
1295:
1332:
1333: FUNCTION getRegionDataSourceType(pRegionCode IN VARCHAR2) RETURN VARCHAR2 IS
1334:
1335: CURSOR source_type_cursor(cp_region_code VARCHAR2) IS
1336: SELECT attribute10 FROM ak_regions
1337: WHERE region_code = cp_region_code;
1338:
1339: l_source_type VARCHAR2(150);
1340: