eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_LAYOUTS_UPLOAD_PKG dependencies on HXC_LAYOUT_COMPONENTS

Line 98: RETURN hxc_layout_components.layout_component_id%TYPE

94: FUNCTION find_component_id
95: (p_component_name IN VARCHAR2
96: ,p_layout_name IN VARCHAR2
97: )
98: RETURN hxc_layout_components.layout_component_id%TYPE
99: IS
100: --
101: l_layout_component_id hxc_layout_components.layout_component_id%TYPE;
102: --

Line 101: l_layout_component_id hxc_layout_components.layout_component_id%TYPE;

97: )
98: RETURN hxc_layout_components.layout_component_id%TYPE
99: IS
100: --
101: l_layout_component_id hxc_layout_components.layout_component_id%TYPE;
102: --
103: BEGIN
104: --
105: IF p_component_name IS NULL THEN

Line 110: FROM hxc_layout_components comp

106: l_layout_component_id := NULL;
107: ELSE
108: SELECT layout_component_id
109: INTO l_layout_component_id
110: FROM hxc_layout_components comp
111: ,hxc_layouts lay
112: WHERE component_name = p_component_name
113: AND comp.layout_id = lay.layout_id
114: AND lay.layout_name = p_layout_name;

Line 224: FROM hxc_layout_components comp

220: -- delete rows from HXC_LAYOUT_COMP_PROMPTS
221: DELETE FROM hxc_layout_comp_prompts
222: WHERE layout_component_id IN
223: (SELECT comp.layout_component_id
224: FROM hxc_layout_components comp
225: WHERE comp.layout_id = l_layout_id);
226: --
227: -- delete rows from HXC_LAYOUT_COMP_QUALIFIERS
228: DELETE FROM hxc_layout_comp_qualifiers cq

Line 231: FROM hxc_layout_components comp

227: -- delete rows from HXC_LAYOUT_COMP_QUALIFIERS
228: DELETE FROM hxc_layout_comp_qualifiers cq
229: WHERE EXISTS
230: (SELECT comp.layout_component_id
231: FROM hxc_layout_components comp
232: WHERE comp.layout_id = l_layout_id
233: AND cq.layout_component_id = comp.layout_component_id);
234: --
235: -- delete rows from HXC_LAYOUT_COMPONENTS

Line 235: -- delete rows from HXC_LAYOUT_COMPONENTS

231: FROM hxc_layout_components comp
232: WHERE comp.layout_id = l_layout_id
233: AND cq.layout_component_id = comp.layout_component_id);
234: --
235: -- delete rows from HXC_LAYOUT_COMPONENTS
236: DELETE FROM hxc_layout_components
237: WHERE layout_id = l_layout_id;
238: --
239: IF ( NVL(l_modifier_level, 'ZZZ') = NVL(p_modifier_level, 'ZZZ') ) THEN

Line 236: DELETE FROM hxc_layout_components

232: WHERE comp.layout_id = l_layout_id
233: AND cq.layout_component_id = comp.layout_component_id);
234: --
235: -- delete rows from HXC_LAYOUT_COMPONENTS
236: DELETE FROM hxc_layout_components
237: WHERE layout_id = l_layout_id;
238: --
239: IF ( NVL(l_modifier_level, 'ZZZ') = NVL(p_modifier_level, 'ZZZ') ) THEN
240: hxc_layouts_upload_pkg.g_force_ok := TRUE;

Line 385: FROM hxc_layout_components lc

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;
387:
388:
389: l_layout_comp_definition_id HXC_LAYOUT_COMP_DEFINITIONS.LAYOUT_COMP_DEFINITION_ID%TYPE := NULL;

Line 482: l_parent_comp_id HXC_LAYOUT_COMPONENTS.PARENT_COMPONENT_ID%TYPE;

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;
486: l_object_version_number HXC_LAYOUT_COMPONENTS.OBJECT_VERSION_NUMBER%TYPE;

Line 485: l_layout_component_id HXC_LAYOUT_COMPONENTS.LAYOUT_COMPONENT_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
489: --

Line 486: l_object_version_number HXC_LAYOUT_COMPONENTS.OBJECT_VERSION_NUMBER%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
489: --
490: glb_debug := glb_debug || ' ' || P_COMPONENT_NAME;

Line 533: FROM hxc_layout_components comp

529: SELECT layout_component_id
530: ,comp.object_version_number
531: INTO l_layout_component_id
532: ,l_object_version_number
533: FROM hxc_layout_components comp
534: ,hxc_layouts lay
535: WHERE component_name = P_COMPONENT_NAME
536: AND comp.layout_id = lay.layout_id
537: AND layout_name = p_layout_name;

Line 631: l_layout_component_id HXC_LAYOUT_COMPONENTS.LAYOUT_COMPONENT_ID%TYPE;

627: ,P_CUSTOM_MODE IN VARCHAR2 DEFAULT NULL
628: )
629: IS
630: --
631: l_layout_component_id HXC_LAYOUT_COMPONENTS.LAYOUT_COMPONENT_ID%TYPE;
632: l_layout_comp_prompt_id HXC_LAYOUT_COMP_PROMPTS.LAYOUT_COMP_PROMPT_ID%TYPE;
633: l_object_version_number HXC_LAYOUT_COMP_PROMPTS.OBJECT_VERSION_NUMBER%TYPE;
634: l_region_app_id hxc_layout_comp_prompts.region_application_id%TYPE;
635: l_attribute_app_id hxc_layout_comp_prompts.attribute_application_id%TYPE;

Line 760: l_layout_component_id HXC_LAYOUT_COMPONENTS.LAYOUT_COMPONENT_ID%TYPE;

756: ,P_CUSTOM_MODE IN VARCHAR2 DEFAULT NULL
757: )
758: IS
759: --
760: l_layout_component_id HXC_LAYOUT_COMPONENTS.LAYOUT_COMPONENT_ID%TYPE;
761: l_layout_comp_qualifier_id HXC_LAYOUT_COMP_QUALIFIERS.LAYOUT_COMP_QUALIFIER_ID%TYPE;
762: l_object_version_number HXC_LAYOUT_COMP_QUALIFIERS.OBJECT_VERSION_NUMBER%TYPE;
763: --
764: BEGIN

Line 1073: FROM hxc_layout_components comp

1069: --
1070: -- delete rows from HXC_LAYOUT_COMP_PROMPTS
1071: DELETE FROM hxc_layout_comp_prompts
1072: WHERE layout_component_id IN (SELECT comp.layout_component_id
1073: FROM hxc_layout_components comp
1074: WHERE comp.layout_id =
1075: l_layout_id);
1076:
1077: --

Line 1081: FROM hxc_layout_components comp

1077: --
1078: -- delete rows from HXC_LAYOUT_COMP_QUALIFIERS
1079: DELETE FROM hxc_layout_comp_qualifiers cq
1080: WHERE EXISTS( SELECT comp.layout_component_id
1081: FROM hxc_layout_components comp
1082: WHERE comp.layout_id = l_layout_id
1083: AND cq.layout_component_id =
1084: comp.layout_component_id);
1085:

Line 1087: -- delete rows from HXC_LAYOUT_COMPONENTS

1083: AND cq.layout_component_id =
1084: comp.layout_component_id);
1085:
1086: --
1087: -- delete rows from HXC_LAYOUT_COMPONENTS
1088: DELETE FROM hxc_layout_components
1089: WHERE layout_id = l_layout_id;
1090:
1091: --

Line 1088: DELETE FROM hxc_layout_components

1084: comp.layout_component_id);
1085:
1086: --
1087: -- delete rows from HXC_LAYOUT_COMPONENTS
1088: DELETE FROM hxc_layout_components
1089: WHERE layout_id = l_layout_id;
1090:
1091: --
1092: IF (nvl(l_modifier_level, 'ZZZ') = nvl(p_modifier_level, 'ZZZ'))

Line 1297: FROM hxc_layout_components lc

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
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;

Line 1416: l_parent_comp_id hxc_layout_components.parent_component_id%TYPE;

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;
1420: l_object_version_number hxc_layout_components.object_version_number%TYPE;

Line 1419: l_layout_component_id hxc_layout_components.layout_component_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: --
1423: l_last_update_date_db DATE;

Line 1420: l_object_version_number hxc_layout_components.object_version_number%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: --
1423: l_last_update_date_db DATE;
1424: l_last_updated_by_db NUMBER(15);

Line 1479: FROM hxc_layout_components comp,

1475: INTO l_layout_component_id,
1476: l_object_version_number,
1477: l_last_update_date_db,
1478: l_last_updated_by_db
1479: FROM hxc_layout_components comp,
1480: hxc_layouts lay
1481: WHERE component_name = p_component_name
1482: AND comp.layout_id = lay.layout_id
1483: AND layout_name = p_layout_name;

Line 1592: l_layout_component_id hxc_layout_components.layout_component_id%TYPE;

1588: )
1589: IS
1590:
1591: --
1592: l_layout_component_id hxc_layout_components.layout_component_id%TYPE;
1593: l_layout_comp_prompt_id hxc_layout_comp_prompts.layout_comp_prompt_id%TYPE;
1594: l_object_version_number hxc_layout_comp_prompts.object_version_number%TYPE;
1595: l_region_app_id hxc_layout_comp_prompts.region_application_id%TYPE;
1596: l_attribute_app_id hxc_layout_comp_prompts.attribute_application_id%TYPE;

Line 1748: l_layout_component_id hxc_layout_components.layout_component_id%TYPE;

1744: )
1745: IS
1746:
1747: --
1748: l_layout_component_id hxc_layout_components.layout_component_id%TYPE;
1749: l_layout_comp_qualifier_id hxc_layout_comp_qualifiers.layout_comp_qualifier_id%TYPE;
1750: l_object_version_number hxc_layout_comp_qualifiers.object_version_number%TYPE;
1751:
1752: --