APPS.HXC_LOV_MIGRATION dependencies on AK_REGIONS

Line 39: (p_region_code IN ak_regions_vl.region_code%TYPE

35: -- =================================================================
36: -- == get_region_row
37: -- =================================================================
38: FUNCTION get_region_row
39: (p_region_code IN ak_regions_vl.region_code%TYPE
40: ,p_application_id IN fnd_application.application_id%TYPE
41: )
42: RETURN ak_regions_vl%ROWTYPE
43: IS

Line 42: RETURN ak_regions_vl%ROWTYPE

38: FUNCTION get_region_row
39: (p_region_code IN ak_regions_vl.region_code%TYPE
40: ,p_application_id IN fnd_application.application_id%TYPE
41: )
42: RETURN ak_regions_vl%ROWTYPE
43: IS
44: l_region_row ak_regions_vl%ROWTYPE;
45: BEGIN
46: SELECT *

Line 44: l_region_row ak_regions_vl%ROWTYPE;

40: ,p_application_id IN fnd_application.application_id%TYPE
41: )
42: RETURN ak_regions_vl%ROWTYPE
43: IS
44: l_region_row ak_regions_vl%ROWTYPE;
45: BEGIN
46: SELECT *
47: INTO l_region_row
48: FROM ak_regions_vl

Line 48: FROM ak_regions_vl

44: l_region_row ak_regions_vl%ROWTYPE;
45: BEGIN
46: SELECT *
47: INTO l_region_row
48: FROM ak_regions_vl
49: WHERE region_code = p_region_code
50: AND region_application_id = p_application_id;
51:
52: -- check region is an LOV region

Line 67: (p_region_code IN ak_regions_vl.region_code%TYPE

63: FND_MESSAGE.RAISE_ERROR;
64: END get_region_row;
65:
66: PROCEDURE migrate_region
67: (p_region_code IN ak_regions_vl.region_code%TYPE
68: ,p_application_id IN fnd_application.application_id%TYPE
69: )
70: IS
71: --

Line 72: region_row ak_regions_vl%ROWTYPE;

68: ,p_application_id IN fnd_application.application_id%TYPE
69: )
70: IS
71: --
72: region_row ak_regions_vl%ROWTYPE;
73:
74: region_obj jdr_docbuilder.DOCUMENT;
75: top_level_element jdr_docbuilder.ELEMENT;
76: table_element jdr_docbuilder.ELEMENT;

Line 192: (p_region_code IN AK_REGIONS_VL.REGION_CODE%TYPE

188:
189: END migrate_region;
190:
191: FUNCTION mds_doc_exists
192: (p_region_code IN AK_REGIONS_VL.REGION_CODE%TYPE
193: )
194: RETURN BOOLEAN
195: IS
196: BEGIN

Line 206: (p_region_code IN AK_REGIONS_VL.REGION_CODE%TYPE DEFAULT NULL

202: -- =================================================================
203: -- == migrate_lov_region
204: -- =================================================================
205: PROCEDURE migrate_lov_region
206: (p_region_code IN AK_REGIONS_VL.REGION_CODE%TYPE DEFAULT NULL
207: ,p_region_app_short_name IN FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE DEFAULT NULL
208: ,p_force IN VARCHAR2 DEFAULT NULL
209: )
210: IS

Line 218: FROM ak_regions

214: l_force BOOLEAN := FALSE;
215: --
216: CURSOR csr_get_regions IS
217: SELECT region_code
218: FROM ak_regions
219: WHERE region_application_id = 809
220: AND region_style = 'LOV'
221: AND region_code NOT IN
222: ('HXCAPPROVALPEOPLELOV'