DBA Data[Home] [Help]

APPS.HXC_LAYOUTS_UPLOAD_PKG dependencies on HXC_LAYOUT_COMP_DEFINITIONS

Line 70: RETURN hxc_layout_comp_definitions.layout_comp_definition_id%TYPE

66: FUNCTION find_component_definition_id
67: (p_component_type IN VARCHAR2
68: ,p_render_type IN VARCHAR2
69: )
70: RETURN hxc_layout_comp_definitions.layout_comp_definition_id%TYPE
71: IS
72: --
73: l_layout_comp_definition_id hxc_layout_comp_definitions.layout_comp_definition_id%TYPE;
74: --

Line 73: l_layout_comp_definition_id hxc_layout_comp_definitions.layout_comp_definition_id%TYPE;

69: )
70: RETURN hxc_layout_comp_definitions.layout_comp_definition_id%TYPE
71: IS
72: --
73: l_layout_comp_definition_id hxc_layout_comp_definitions.layout_comp_definition_id%TYPE;
74: --
75: BEGIN
76: --
77: SELECT layout_comp_definition_id

Line 79: FROM hxc_layout_comp_definitions

75: BEGIN
76: --
77: SELECT layout_comp_definition_id
78: INTO l_layout_comp_definition_id
79: FROM hxc_layout_comp_definitions
80: WHERE component_type = p_component_type
81: AND render_type = p_render_type;
82: --
83: RETURN l_layout_comp_definition_id;

Line 377: FROM hxc_layout_comp_definitions

373: --
374: CURSOR C_COMP_DEF IS
375: SELECT layout_comp_definition_id
376: ,object_version_number
377: FROM hxc_layout_comp_definitions
378: WHERE component_type = p_component_type
379: AND render_type = p_render_type;
380:
381:

Line 382: CURSOR C_FORCE_OK (p_layout_comp_definition_id HXC_LAYOUT_COMP_DEFINITIONS.LAYOUT_COMP_DEFINITION_ID%TYPE)

378: WHERE component_type = p_component_type
379: AND render_type = p_render_type;
380:
381:
382: CURSOR C_FORCE_OK (p_layout_comp_definition_id HXC_LAYOUT_COMP_DEFINITIONS.LAYOUT_COMP_DEFINITION_ID%TYPE)
383: IS
384: SELECT 'N'
385: FROM hxc_layout_components lc
386: WHERE lc.layout_comp_definition_id = p_layout_comp_definition_id;

Line 389: l_layout_comp_definition_id HXC_LAYOUT_COMP_DEFINITIONS.LAYOUT_COMP_DEFINITION_ID%TYPE := NULL;

385: FROM hxc_layout_components lc
386: WHERE lc.layout_comp_definition_id = p_layout_comp_definition_id;
387:
388:
389: l_layout_comp_definition_id HXC_LAYOUT_COMP_DEFINITIONS.LAYOUT_COMP_DEFINITION_ID%TYPE := NULL;
390: l_object_version_number HXC_LAYOUT_COMP_DEFINITIONS.OBJECT_VERSION_NUMBER%TYPE;
391: l_force_ok VARCHAR2(1) := 'Y';
392: --
393: BEGIN

Line 390: l_object_version_number HXC_LAYOUT_COMP_DEFINITIONS.OBJECT_VERSION_NUMBER%TYPE;

386: WHERE lc.layout_comp_definition_id = p_layout_comp_definition_id;
387:
388:
389: l_layout_comp_definition_id HXC_LAYOUT_COMP_DEFINITIONS.LAYOUT_COMP_DEFINITION_ID%TYPE := NULL;
390: l_object_version_number HXC_LAYOUT_COMP_DEFINITIONS.OBJECT_VERSION_NUMBER%TYPE;
391: l_force_ok VARCHAR2(1) := 'Y';
392: --
393: BEGIN
394: --

Line 481: l_layout_comp_definition_id HXC_LAYOUT_COMP_DEFINITIONS.LAYOUT_COMP_DEFINITION_ID%TYPE;

477: )
478: IS
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;

Line 1288: FROM hxc_layout_comp_definitions

1284: SELECT layout_comp_definition_id,
1285: object_version_number,
1286: last_update_date,
1287: last_updated_by
1288: FROM hxc_layout_comp_definitions
1289: WHERE component_type = p_component_type
1290: AND render_type = p_render_type;
1291:
1292: CURSOR c_force_ok(

Line 1293: p_layout_comp_definition_id hxc_layout_comp_definitions.layout_comp_definition_id%TYPE

1289: WHERE component_type = p_component_type
1290: AND render_type = p_render_type;
1291:
1292: CURSOR c_force_ok(
1293: p_layout_comp_definition_id hxc_layout_comp_definitions.layout_comp_definition_id%TYPE
1294: )
1295: IS
1296: SELECT 'N'
1297: FROM hxc_layout_components lc

Line 1300: l_layout_comp_definition_id hxc_layout_comp_definitions.layout_comp_definition_id%TYPE

1296: SELECT 'N'
1297: FROM hxc_layout_components lc
1298: WHERE lc.layout_comp_definition_id = p_layout_comp_definition_id;
1299:
1300: l_layout_comp_definition_id hxc_layout_comp_definitions.layout_comp_definition_id%TYPE
1301: := NULL;
1302: l_object_version_number hxc_layout_comp_definitions.object_version_number%TYPE;
1303: l_force_ok VARCHAR2(1) := 'Y';
1304:

Line 1302: l_object_version_number hxc_layout_comp_definitions.object_version_number%TYPE;

1298: WHERE lc.layout_comp_definition_id = p_layout_comp_definition_id;
1299:
1300: l_layout_comp_definition_id hxc_layout_comp_definitions.layout_comp_definition_id%TYPE
1301: := NULL;
1302: l_object_version_number hxc_layout_comp_definitions.object_version_number%TYPE;
1303: l_force_ok VARCHAR2(1) := 'Y';
1304:
1305: --
1306: BEGIN

Line 1415: l_layout_comp_definition_id hxc_layout_comp_definitions.layout_comp_definition_id%TYPE;

1411: IS
1412:
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;