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.

[Home] [Help]

APPS.HXC_LAYOUTS_UPLOAD_PKG dependencies on HXC_LAYOUT_COMP_QUALIFIERS

Line 131: ,p_layout_component_id IN hxc_layout_comp_qualifiers.layout_component_id%TYPE

127: -- == find_comp_qualifier_id
128: -- =================================================================
129: FUNCTION find_comp_qualifier_id
130: (p_comp_qualifier_name IN VARCHAR2
131: ,p_layout_component_id IN hxc_layout_comp_qualifiers.layout_component_id%TYPE
132: )
133: RETURN hxc_layout_comp_qualifiers.layout_comp_qualifier_id%TYPE
134: IS
135: --

Line 133: RETURN hxc_layout_comp_qualifiers.layout_comp_qualifier_id%TYPE

129: FUNCTION find_comp_qualifier_id
130: (p_comp_qualifier_name IN VARCHAR2
131: ,p_layout_component_id IN hxc_layout_comp_qualifiers.layout_component_id%TYPE
132: )
133: RETURN hxc_layout_comp_qualifiers.layout_comp_qualifier_id%TYPE
134: IS
135: --
136: l_layout_comp_qualifier_id hxc_layout_comp_qualifiers.layout_comp_qualifier_id%TYPE;
137: --

Line 136: l_layout_comp_qualifier_id hxc_layout_comp_qualifiers.layout_comp_qualifier_id%TYPE;

132: )
133: RETURN hxc_layout_comp_qualifiers.layout_comp_qualifier_id%TYPE
134: IS
135: --
136: l_layout_comp_qualifier_id hxc_layout_comp_qualifiers.layout_comp_qualifier_id%TYPE;
137: --
138: BEGIN
139: --
140: SELECT layout_comp_qualifier_id

Line 142: FROM hxc_layout_comp_qualifiers

138: BEGIN
139: --
140: SELECT layout_comp_qualifier_id
141: INTO l_layout_comp_qualifier_id
142: FROM hxc_layout_comp_qualifiers
143: WHERE qualifier_name = p_comp_qualifier_name
144: AND layout_component_id = p_layout_component_id;
145: --
146: RETURN l_layout_comp_qualifier_id;

Line 227: -- delete rows from HXC_LAYOUT_COMP_QUALIFIERS

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
229: WHERE EXISTS
230: (SELECT comp.layout_component_id
231: FROM hxc_layout_components comp

Line 228: DELETE FROM hxc_layout_comp_qualifiers cq

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
229: WHERE EXISTS
230: (SELECT comp.layout_component_id
231: FROM hxc_layout_components comp
232: WHERE comp.layout_id = l_layout_id

Line 761: l_layout_comp_qualifier_id HXC_LAYOUT_COMP_QUALIFIERS.LAYOUT_COMP_QUALIFIER_ID%TYPE;

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

Line 762: l_object_version_number HXC_LAYOUT_COMP_QUALIFIERS.OBJECT_VERSION_NUMBER%TYPE;

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
765: --
766: -- Find the component ID

Line 779: FROM HXC_LAYOUT_COMP_QUALIFIERS

775: SELECT layout_comp_qualifier_id
776: ,object_version_number
777: INTO l_layout_comp_qualifier_id
778: ,l_object_version_number
779: FROM HXC_LAYOUT_COMP_QUALIFIERS
780: WHERE qualifier_name = p_qualifier_name
781: and layout_component_id = l_layout_component_id;
782:
783: IF (p_custom_mode = 'FORCE') THEN

Line 924: l_layout_comp_qualifier_id HXC_LAYOUT_COMP_QUALIFIERS.LAYOUT_COMP_QUALIFIER_ID%TYPE;

920: ,P_CUSTOM_MODE IN VARCHAR2
921: )
922: IS
923: --
924: l_layout_comp_qualifier_id HXC_LAYOUT_COMP_QUALIFIERS.LAYOUT_COMP_QUALIFIER_ID%TYPE;
925: l_layout_comp_qual_rule_id HXC_LAYOUT_COMP_QUAL_RULES.LAYOUT_COMP_QUAL_RULE_ID%TYPE;
926: l_object_version_number HXC_LAYOUT_COMP_QUAL_RULES.OBJECT_VERSION_NUMBER%TYPE;
927: --
928: BEGIN

Line 1078: -- delete rows from HXC_LAYOUT_COMP_QUALIFIERS

1074: WHERE comp.layout_id =
1075: l_layout_id);
1076:
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

Line 1079: DELETE FROM hxc_layout_comp_qualifiers cq

1075: l_layout_id);
1076:
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 =

Line 1749: l_layout_comp_qualifier_id hxc_layout_comp_qualifiers.layout_comp_qualifier_id%TYPE;

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: --
1753: l_last_update_date_db DATE;

Line 1750: l_object_version_number hxc_layout_comp_qualifiers.object_version_number%TYPE;

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: --
1753: l_last_update_date_db DATE;
1754: l_last_updated_by_db NUMBER(15);

Line 1780: FROM hxc_layout_comp_qualifiers

1776: INTO l_layout_comp_qualifier_id,
1777: l_object_version_number,
1778: l_last_update_date_db,
1779: l_last_updated_by_db
1780: FROM hxc_layout_comp_qualifiers
1781: WHERE qualifier_name = p_qualifier_name
1782: AND layout_component_id = l_layout_component_id;
1783:
1784: IF (fnd_load_util.upload_test(

Line 1935: l_layout_comp_qualifier_id HXC_LAYOUT_COMP_QUALIFIERS.LAYOUT_COMP_QUALIFIER_ID%TYPE;

1931: ,P_CUSTOM_MODE IN VARCHAR2
1932: )
1933: IS
1934: --
1935: l_layout_comp_qualifier_id HXC_LAYOUT_COMP_QUALIFIERS.LAYOUT_COMP_QUALIFIER_ID%TYPE;
1936: l_layout_comp_qual_rule_id HXC_LAYOUT_COMP_QUAL_RULES.LAYOUT_COMP_QUAL_RULE_ID%TYPE;
1937: l_object_version_number HXC_LAYOUT_COMP_QUAL_RULES.OBJECT_VERSION_NUMBER%TYPE;
1938: --
1939: BEGIN