81:
82: FUNCTION getRegionApplicationId(pRegionCode IN VARCHAR2) RETURN NUMBER IS
83:
84: CURSOR region_app_id_cursor(cp_region_code VARCHAR2) IS
85: SELECT region_application_id FROM ak_regions
86: WHERE region_code = cp_region_code;
87:
88: l_region_app_id NUMBER;
89:
166:
167: FUNCTION getRegionApplicationName(pRegionCode IN VARCHAR2) RETURN VARCHAR2 IS
168:
169: CURSOR region_app_name_cursor(cp_region_code VARCHAR2) IS
170: SELECT application_name FROM ak_regions R, fnd_application_vl A
171: WHERE R.region_code = cp_region_code AND R.region_application_id = A.application_id;
172:
173: l_code VARCHAR2(3);
174:
211:
212: FUNCTION getRegionDataSourceType(pRegionCode IN VARCHAR2) RETURN VARCHAR2 IS
213:
214: CURSOR source_type_cursor(cp_region_code VARCHAR2) IS
215: SELECT attribute10 FROM ak_regions
216: WHERE region_code = cp_region_code;
217:
218: l_source_type VARCHAR2(150);
219: