APPS.CS_CF_UPG_BUGFIX1_PKG dependencies on AK_REGION_ITEMS

Line 37: l_node_display_flag AK_REGION_ITEMS.node_display_flag%TYPE;

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;
40:
41: CURSOR get_regions (p_region_code IN VARCHAR2, p_suffix IN VARCHAR2) IS

Line 38: l_required_flag AK_REGION_ITEMS.required_flag%TYPE;

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;
40:
41: CURSOR get_regions (p_region_code IN VARCHAR2, p_suffix IN VARCHAR2) IS
42: SELECT region_code

Line 54: FROM ak_region_items

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
54: FROM ak_region_items
55: WHERE region_code = p_region_code
56: AND region_application_id = p_region_application_id
57: AND attribute_code = p_attribute_code
58: AND attribute_application_id = p_attribute_application_id;