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_LAYOUTS_UPLOAD_PKG

Line 1: PACKAGE BODY hxc_layouts_upload_pkg AS

1: PACKAGE BODY hxc_layouts_upload_pkg AS
2: /* $Header: hxculaupl.pkb 120.2 2005/09/23 09:47:53 rchennur noship $ */
3:
4: glb_debug VARCHAR2(32000) := NULL;
5: l_modifier_level hxc_layouts.modifier_level%TYPE;

Line 240: hxc_layouts_upload_pkg.g_force_ok := TRUE;

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;
241: ELSE
242: hxc_layouts_upload_pkg.g_force_ok := FALSE;
243: END IF;
244: ---

Line 242: hxc_layouts_upload_pkg.g_force_ok := FALSE;

238: --
239: IF ( NVL(l_modifier_level, 'ZZZ') = NVL(p_modifier_level, 'ZZZ') ) THEN
240: hxc_layouts_upload_pkg.g_force_ok := TRUE;
241: ELSE
242: hxc_layouts_upload_pkg.g_force_ok := FALSE;
243: END IF;
244: ---
245: l_dummy :=NULL;
246:

Line 271: IF hxc_layouts_upload_pkg.g_force_ok THEN

267: ,P_DISPLAY_LAYOUT_NAME => P_DISPLAY_LAYOUT_NAME
268: );
269: END IF;
270: ELSE
271: IF hxc_layouts_upload_pkg.g_force_ok THEN
272: HXC_ULA_UPD.UPD
273: (P_LAYOUT_NAME => P_LAYOUT_NAME
274: ,P_APPLICATION_ID => l_application_id
275: ,P_LAYOUT_TYPE => P_LAYOUT_TYPE

Line 563: IF hxc_layouts_upload_pkg.g_force_ok THEN

559: ,P_ATTRIBUTE4 => P_ATTRIBUTE4
560: ,P_ATTRIBUTE5 => P_ATTRIBUTE5
561: );
562: ELSE
563: IF hxc_layouts_upload_pkg.g_force_ok THEN
564: HXC_ULC_UPD.UPD
565: (P_LAYOUT_ID => l_layout_id
566: ,P_PARENT_COMPONENT_ID => l_parent_comp_id
567: ,P_SEQUENCE => P_SEQUENCE

Line 586: END IF; -- hxc_layouts_upload_pkg.g_force_ok

582: ,P_ATTRIBUTE3 => P_ATTRIBUTE3
583: ,P_ATTRIBUTE4 => P_ATTRIBUTE4
584: ,P_ATTRIBUTE5 => P_ATTRIBUTE5
585: );
586: END IF; -- hxc_layouts_upload_pkg.g_force_ok
587: END IF; -- ( p_custom_mode = 'FORCE' )
588: EXCEPTION WHEN NO_DATA_FOUND THEN
589: HXC_ULC_INS.INS
590: (P_LAYOUT_ID => l_layout_id

Line 685: IF HXC_layouts_upload_pkg.g_force_ok THEN

681: ,P_LAYOUT_COMP_PROMPT_ID => l_layout_comp_prompt_id
682: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
683: );
684: ELSE
685: IF HXC_layouts_upload_pkg.g_force_ok THEN
686: HXC_ULP_UPD.UPD
687: (P_LAYOUT_COMPONENT_ID => l_layout_component_id
688: ,P_PROMPT_ALIAS => P_PROMPT_ALIAS
689: ,P_PROMPT_TYPE => P_PROMPT_TYPE

Line 697: END IF; -- HXC_layouts_upload_pkg.g_force_ok

693: ,p_attribute_application_id => l_attribute_app_id
694: ,P_LAYOUT_COMP_PROMPT_ID => l_layout_comp_prompt_id
695: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
696: );
697: END IF; -- HXC_layouts_upload_pkg.g_force_ok
698: END IF; -- p_custom_mode = 'FORCE'
699: EXCEPTION WHEN NO_DATA_FOUND THEN
700: --
701: -- Use the Row handler to insert the row

Line 825: IF HXC_layouts_upload_pkg.g_force_ok THEN

821: ,P_LAYOUT_COMP_QUALIFIER_ID => l_layout_comp_qualifier_id
822: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
823: );
824: ELSE
825: IF HXC_layouts_upload_pkg.g_force_ok THEN
826: HXC_ULQ_UPD.UPD
827: (P_LAYOUT_COMPONENT_ID => l_layout_component_id
828: ,P_QUALIFIER_NAME => P_QUALIFIER_NAME
829: ,P_QUALIFIER_ATTRIBUTE_CATEGORY => P_QUALIFIER_ATTRIBUTE_CATEGORY

Line 863: END IF; -- HXC_layouts_upload_pkg.g_force_ok

859: ,P_QUALIFIER_ATTRIBUTE30 => P_QUALIFIER_ATTRIBUTE30
860: ,P_LAYOUT_COMP_QUALIFIER_ID => l_layout_comp_qualifier_id
861: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
862: );
863: END IF; -- HXC_layouts_upload_pkg.g_force_ok
864: END IF; -- p_custom_mode = 'FORCE'
865: EXCEPTION WHEN NO_DATA_FOUND THEN
866: --
867: -- Use the Row handler to insert the row

Line 959: IF HXC_layouts_upload_pkg.g_force_ok THEN

955: ,P_LAYOUT_COMP_QUAL_RULE_ID => l_layout_comp_qual_rule_id
956: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
957: );
958: ELSE
959: IF HXC_layouts_upload_pkg.g_force_ok THEN
960: --
961: -- Use the row handler to update the rule data
962: --
963: HXC_ULR_UPD.UPD

Line 972: END IF; -- HXC_layouts_upload_pkg.g_force_ok

968: ,P_RULE_VALUE => P_RULE_VALUE
969: ,P_LAYOUT_COMP_QUAL_RULE_ID => l_layout_comp_qual_rule_id
970: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
971: );
972: END IF; -- HXC_layouts_upload_pkg.g_force_ok
973: END IF; -- p_custom_mode = 'FORCE'
974: EXCEPTION WHEN NO_DATA_FOUND THEN
975: --
976: -- Use the row handler to insert the rule data

Line 1094: hxc_layouts_upload_pkg.g_force_ok := TRUE;

1090:
1091: --
1092: IF (nvl(l_modifier_level, 'ZZZ') = nvl(p_modifier_level, 'ZZZ'))
1093: THEN
1094: hxc_layouts_upload_pkg.g_force_ok := TRUE;
1095: ELSE
1096: hxc_layouts_upload_pkg.g_force_ok := FALSE;
1097: END IF;
1098:

Line 1096: hxc_layouts_upload_pkg.g_force_ok := FALSE;

1092: IF (nvl(l_modifier_level, 'ZZZ') = nvl(p_modifier_level, 'ZZZ'))
1093: THEN
1094: hxc_layouts_upload_pkg.g_force_ok := TRUE;
1095: ELSE
1096: hxc_layouts_upload_pkg.g_force_ok := FALSE;
1097: END IF;
1098:
1099: ---
1100: l_dummy := NULL;

Line 1136: IF hxc_layouts_upload_pkg.g_force_ok

1132: p_display_layout_name=> p_display_layout_name
1133: );
1134: END IF;
1135: ELSE
1136: IF hxc_layouts_upload_pkg.g_force_ok
1137: THEN
1138: hxc_ula_upd.upd(
1139: p_layout_name=> p_layout_name,
1140: p_application_id=> l_application_id,

Line 1518: IF hxc_layouts_upload_pkg.g_force_ok

1514: p_attribute4=> p_attribute4,
1515: p_attribute5=> p_attribute5
1516: );
1517: ELSE
1518: IF hxc_layouts_upload_pkg.g_force_ok
1519: THEN
1520: hxc_ulc_upd.upd(
1521: p_layout_id=> l_layout_id,
1522: p_parent_component_id=> l_parent_comp_id,

Line 1542: END IF; -- hxc_layouts_upload_pkg.g_force_ok

1538: p_attribute3=> p_attribute3,
1539: p_attribute4=> p_attribute4,
1540: p_attribute5=> p_attribute5
1541: );
1542: END IF; -- hxc_layouts_upload_pkg.g_force_ok
1543: END IF; -- ( p_custom_mode = 'FORCE' )
1544: EXCEPTION
1545: WHEN no_data_found
1546: THEN

Line 1666: IF hxc_layouts_upload_pkg.g_force_ok

1662: p_layout_comp_prompt_id=> l_layout_comp_prompt_id,
1663: p_object_version_number=> l_object_version_number
1664: );
1665: ELSE
1666: IF hxc_layouts_upload_pkg.g_force_ok
1667: THEN
1668: hxc_ulp_upd.upd(
1669: p_layout_component_id=> l_layout_component_id,
1670: p_prompt_alias=> p_prompt_alias,

Line 1679: END IF; -- HXC_layouts_upload_pkg.g_force_ok

1675: p_attribute_application_id=> l_attribute_app_id,
1676: p_layout_comp_prompt_id=> l_layout_comp_prompt_id,
1677: p_object_version_number=> l_object_version_number
1678: );
1679: END IF; -- HXC_layouts_upload_pkg.g_force_ok
1680: END IF; -- p_custom_mode = 'FORCE'
1681: EXCEPTION
1682: WHEN no_data_found
1683: THEN

Line 1834: IF hxc_layouts_upload_pkg.g_force_ok

1830: p_layout_comp_qualifier_id=> l_layout_comp_qualifier_id,
1831: p_object_version_number=> l_object_version_number
1832: );
1833: ELSE
1834: IF hxc_layouts_upload_pkg.g_force_ok
1835: THEN
1836: hxc_ulq_upd.upd(
1837: p_layout_component_id=> l_layout_component_id,
1838: p_qualifier_name=> p_qualifier_name,

Line 1873: END IF; -- HXC_layouts_upload_pkg.g_force_ok

1869: p_qualifier_attribute30=> p_qualifier_attribute30,
1870: p_layout_comp_qualifier_id=> l_layout_comp_qualifier_id,
1871: p_object_version_number=> l_object_version_number
1872: );
1873: END IF; -- HXC_layouts_upload_pkg.g_force_ok
1874: END IF; -- p_custom_mode = 'FORCE'
1875: EXCEPTION
1876: WHEN no_data_found
1877: THEN

Line 1970: IF HXC_layouts_upload_pkg.g_force_ok THEN

1966: ,P_LAYOUT_COMP_QUAL_RULE_ID => l_layout_comp_qual_rule_id
1967: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1968: );
1969: ELSE
1970: IF HXC_layouts_upload_pkg.g_force_ok THEN
1971: --
1972: -- Use the row handler to update the rule data
1973: --
1974: HXC_ULR_UPD.UPD

Line 1983: END IF; -- HXC_layouts_upload_pkg.g_force_ok

1979: ,P_RULE_VALUE => P_RULE_VALUE
1980: ,P_LAYOUT_COMP_QUAL_RULE_ID => l_layout_comp_qual_rule_id
1981: ,P_OBJECT_VERSION_NUMBER => l_object_version_number
1982: );
1983: END IF; -- HXC_layouts_upload_pkg.g_force_ok
1984: END IF; -- p_custom_mode = 'FORCE'
1985: EXCEPTION WHEN NO_DATA_FOUND THEN
1986: --
1987: -- Use the row handler to insert the rule data

Line 2002: END hxc_layouts_upload_pkg;

1998: END;
1999: END LOAD_RULE_ROW;
2000: */
2001:
2002: END hxc_layouts_upload_pkg;