APPS.HXC_LOV_MIGRATION dependencies on FND_APPLICATION

Line 11: RETURN fnd_application.application_id%TYPE

7: -- =================================================================
8: FUNCTION find_application_id
9: (p_application_short_name IN VARCHAR2
10: )
11: RETURN fnd_application.application_id%TYPE
12: IS
13: --
14: l_appl_id fnd_application.application_id%TYPE;
15: --

Line 14: l_appl_id fnd_application.application_id%TYPE;

10: )
11: RETURN fnd_application.application_id%TYPE
12: IS
13: --
14: l_appl_id fnd_application.application_id%TYPE;
15: --
16: BEGIN
17: --
18: IF p_application_short_name IS NULL THEN

Line 23: FROM fnd_application

19: l_appl_id := NULL;
20: ELSE
21: SELECT application_id
22: INTO l_appl_id
23: FROM fnd_application
24: WHERE application_short_name = P_APPLICATION_SHORT_NAME;
25: END IF;
26: --
27: RETURN l_appl_id;

Line 40: ,p_application_id IN fnd_application.application_id%TYPE

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
44: l_region_row ak_regions_vl%ROWTYPE;

Line 68: ,p_application_id IN fnd_application.application_id%TYPE

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: --
72: region_row ak_regions_vl%ROWTYPE;

Line 207: ,p_region_app_short_name IN FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE DEFAULT NULL

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
211: --

Line 212: region_app_id fnd_application.application_id%TYPE;

208: ,p_force IN VARCHAR2 DEFAULT NULL
209: )
210: IS
211: --
212: region_app_id fnd_application.application_id%TYPE;
213: l_app_short_name FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE DEFAULT NULL;
214: l_force BOOLEAN := FALSE;
215: --
216: CURSOR csr_get_regions IS

Line 213: l_app_short_name FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE DEFAULT NULL;

209: )
210: IS
211: --
212: region_app_id fnd_application.application_id%TYPE;
213: l_app_short_name FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE DEFAULT NULL;
214: l_force BOOLEAN := FALSE;
215: --
216: CURSOR csr_get_regions IS
217: SELECT region_code