APPS.CS_CF_UPG_BUGFIX1_PKG dependencies on AK_REGIONS

Line 34: l_region_code AK_REGIONS.region_code%TYPE;

30: End Main;
31:
32: PROCEDURE Fix_Regions_Bugfix1(p_contextType IN VARCHAR2) IS
33:
34: l_region_code AK_REGIONS.region_code%TYPE;
35: l_newRegionCode AK_REGIONS.region_code%TYPE;
36: l_suffix VARCHAR2(2000);
37: l_node_display_flag AK_REGION_ITEMS.node_display_flag%TYPE;
38: l_required_flag AK_REGION_ITEMS.required_flag%TYPE;

Line 35: l_newRegionCode AK_REGIONS.region_code%TYPE;

31:
32: PROCEDURE Fix_Regions_Bugfix1(p_contextType IN VARCHAR2) IS
33:
34: l_region_code AK_REGIONS.region_code%TYPE;
35: l_newRegionCode AK_REGIONS.region_code%TYPE;
36: l_suffix VARCHAR2(2000);
37: l_node_display_flag AK_REGION_ITEMS.node_display_flag%TYPE;
38: l_required_flag AK_REGION_ITEMS.required_flag%TYPE;
39: l_count NUMBER := 0;

Line 43: FROM ak_regions

39: l_count NUMBER := 0;
40:
41: CURSOR get_regions (p_region_code IN VARCHAR2, p_suffix IN VARCHAR2) IS
42: SELECT region_code
43: FROM ak_regions
44: WHERE region_code like p_region_code || p_suffix || '%';
45:
46:
47: CURSOR region_exist (p_region_code IN VARCHAR2) IS

Line 49: FROM ak_regions where region_code = p_region_code;

45:
46:
47: CURSOR region_exist (p_region_code IN VARCHAR2) IS
48: SELECT count(*)
49: FROM ak_regions where region_code = p_region_code;
50:
51: CURSOR get_display_attributes(p_region_code IN VARCHAR2, p_region_application_id IN VARCHAR2,
52: p_attribute_code IN VARCHAR2, p_attribute_application_id IN VARCHAR2) IS
53: SELECT node_display_flag, required_flag