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_COMP_PROMPTS

Line 220: -- delete rows from HXC_LAYOUT_COMP_PROMPTS

216: AND application_id = l_application_id;
217: --
218: -- Remove all components for the layout if it already exists
219: --
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

Line 221: DELETE FROM hxc_layout_comp_prompts

217: --
218: -- Remove all components for the layout if it already exists
219: --
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);

Line 632: l_layout_comp_prompt_id HXC_LAYOUT_COMP_PROMPTS.LAYOUT_COMP_PROMPT_ID%TYPE;

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

Line 633: l_object_version_number HXC_LAYOUT_COMP_PROMPTS.OBJECT_VERSION_NUMBER%TYPE;

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;
636: --
637: BEGIN

Line 634: l_region_app_id hxc_layout_comp_prompts.region_application_id%TYPE;

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;
636: --
637: BEGIN
638: --

Line 635: l_attribute_app_id hxc_layout_comp_prompts.attribute_application_id%TYPE;

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;
636: --
637: BEGIN
638: --
639: -- Find the component ID

Line 663: FROM HXC_LAYOUT_COMP_PROMPTS lcp

659: SELECT lcp.layout_comp_prompt_id
660: ,lcp.object_version_number
661: INTO l_layout_comp_prompt_id
662: ,l_object_version_number
663: FROM HXC_LAYOUT_COMP_PROMPTS lcp
664: WHERE lcp.prompt_alias = p_prompt_alias
665: AND lcp.prompt_type = p_prompt_type
666: AND lcp.layout_component_id = l_layout_component_id;
667:

Line 1070: -- delete rows from HXC_LAYOUT_COMP_PROMPTS

1066:
1067: --
1068: -- Remove all components for the layout if it already exists
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 =

Line 1071: DELETE FROM hxc_layout_comp_prompts

1067: --
1068: -- Remove all components for the layout if it already exists
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);

Line 1593: l_layout_comp_prompt_id hxc_layout_comp_prompts.layout_comp_prompt_id%TYPE;

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

Line 1594: l_object_version_number hxc_layout_comp_prompts.object_version_number%TYPE;

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;
1597:
1598: --

Line 1595: l_region_app_id hxc_layout_comp_prompts.region_application_id%TYPE;

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;
1597:
1598: --
1599: l_last_update_date_db DATE;

Line 1596: l_attribute_app_id hxc_layout_comp_prompts.attribute_application_id%TYPE;

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;
1597:
1598: --
1599: l_last_update_date_db DATE;
1600: l_last_updated_by_db NUMBER(15);

Line 1637: FROM hxc_layout_comp_prompts lcp

1633: INTO l_layout_comp_prompt_id,
1634: l_object_version_number,
1635: l_last_update_date_db,
1636: l_last_updated_by_db
1637: FROM hxc_layout_comp_prompts lcp
1638: WHERE lcp.prompt_alias = p_prompt_alias
1639: AND lcp.prompt_type = p_prompt_type
1640: AND lcp.layout_component_id = l_layout_component_id;
1641: