APPS.HXC_LAYOUTS_UPLOAD_PKG dependencies on FND_APPLICATION

Line 14: RETURN fnd_application.application_id%TYPE

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

Line 17: l_appl_id fnd_application.application_id%TYPE;

13: )
14: RETURN fnd_application.application_id%TYPE
15: IS
16: --
17: l_appl_id fnd_application.application_id%TYPE;
18: --
19: BEGIN
20: --
21: IF p_application_short_name IS NULL THEN

Line 26: FROM fnd_application

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

Line 172: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;

168: IS
169: --
170: l_layout_id HXC_LAYOUTS.LAYOUT_ID%TYPE;
171: l_object_version_number HXC_LAYOUTS.OBJECT_VERSION_NUMBER%TYPE;
172: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
173: l_dummy varchar2(3);
174:
175: CURSOR C_DISPLAY_NAME(p_layout_id IN NUMBER)
176: IS

Line 483: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;

479: --
480: l_layout_id HXC_LAYOUTS.LAYOUT_ID%TYPE;
481: l_layout_comp_definition_id HXC_LAYOUT_COMP_DEFINITIONS.LAYOUT_COMP_DEFINITION_ID%TYPE;
482: l_parent_comp_id HXC_LAYOUT_COMPONENTS.PARENT_COMPONENT_ID%TYPE;
483: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
484: l_attr_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
485: l_layout_component_id HXC_LAYOUT_COMPONENTS.LAYOUT_COMPONENT_ID%TYPE;
486: l_object_version_number HXC_LAYOUT_COMPONENTS.OBJECT_VERSION_NUMBER%TYPE;
487: --

Line 484: l_attr_application_id FND_APPLICATION.APPLICATION_ID%TYPE;

480: l_layout_id HXC_LAYOUTS.LAYOUT_ID%TYPE;
481: l_layout_comp_definition_id HXC_LAYOUT_COMP_DEFINITIONS.LAYOUT_COMP_DEFINITION_ID%TYPE;
482: l_parent_comp_id HXC_LAYOUT_COMPONENTS.PARENT_COMPONENT_ID%TYPE;
483: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
484: l_attr_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
485: l_layout_component_id HXC_LAYOUT_COMPONENTS.LAYOUT_COMPONENT_ID%TYPE;
486: l_object_version_number HXC_LAYOUT_COMPONENTS.OBJECT_VERSION_NUMBER%TYPE;
487: --
488: BEGIN

Line 1010: l_application_id fnd_application.application_id%TYPE;

1006:
1007: --
1008: l_layout_id hxc_layouts.layout_id%TYPE;
1009: l_object_version_number hxc_layouts.object_version_number%TYPE;
1010: l_application_id fnd_application.application_id%TYPE;
1011: l_dummy VARCHAR2(3);
1012: l_last_update_date_db DATE;
1013: l_last_updated_by_db NUMBER(15);
1014: l_last_updated_by_f NUMBER(15);

Line 1417: l_application_id fnd_application.application_id%TYPE;

1413: --
1414: l_layout_id hxc_layouts.layout_id%TYPE;
1415: l_layout_comp_definition_id hxc_layout_comp_definitions.layout_comp_definition_id%TYPE;
1416: l_parent_comp_id hxc_layout_components.parent_component_id%TYPE;
1417: l_application_id fnd_application.application_id%TYPE;
1418: l_attr_application_id fnd_application.application_id%TYPE;
1419: l_layout_component_id hxc_layout_components.layout_component_id%TYPE;
1420: l_object_version_number hxc_layout_components.object_version_number%TYPE;
1421:

Line 1418: l_attr_application_id fnd_application.application_id%TYPE;

1414: l_layout_id hxc_layouts.layout_id%TYPE;
1415: l_layout_comp_definition_id hxc_layout_comp_definitions.layout_comp_definition_id%TYPE;
1416: l_parent_comp_id hxc_layout_components.parent_component_id%TYPE;
1417: l_application_id fnd_application.application_id%TYPE;
1418: l_attr_application_id fnd_application.application_id%TYPE;
1419: l_layout_component_id hxc_layout_components.layout_component_id%TYPE;
1420: l_object_version_number hxc_layout_components.object_version_number%TYPE;
1421:
1422: --