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

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 5: l_modifier_level hxc_layouts.modifier_level%TYPE;

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;
6: g_debug boolean :=hr_utility.debug_enabled;
7:
8: -- =================================================================
9: -- == find_application_id

Line 44: RETURN hxc_layouts.layout_id%TYPE

40: -- =================================================================
41: FUNCTION find_layout_id
42: (p_layout_name IN VARCHAR2
43: )
44: RETURN hxc_layouts.layout_id%TYPE
45: IS
46: --
47: l_layout_id HXC_LAYOUTS.LAYOUT_ID%TYPE;
48: --

Line 47: l_layout_id HXC_LAYOUTS.LAYOUT_ID%TYPE;

43: )
44: RETURN hxc_layouts.layout_id%TYPE
45: IS
46: --
47: l_layout_id HXC_LAYOUTS.LAYOUT_ID%TYPE;
48: --
49: BEGIN
50: SELECT layout_id
51: INTO l_layout_id

Line 52: FROM hxc_layouts

48: --
49: BEGIN
50: SELECT layout_id
51: INTO l_layout_id
52: FROM hxc_layouts
53: WHERE layout_name = p_layout_name;
54: --
55: RETURN l_layout_id;
56: --

Line 111: ,hxc_layouts lay

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;
115: END IF;

Line 170: l_layout_id HXC_LAYOUTS.LAYOUT_ID%TYPE;

166: ,p_custom_mode IN VARCHAR2 DEFAULT NULL
167: )
168: IS
169: --
170: l_layout_id HXC_LAYOUTS.LAYOUT_ID%TYPE;
171: l_object_version_number HXC_LAYOUTS.OBJECT_VERSION_NUMBER%TYPE;
172: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
173: l_dummy varchar2(3);
174:

Line 171: l_object_version_number HXC_LAYOUTS.OBJECT_VERSION_NUMBER%TYPE;

167: )
168: IS
169: --
170: l_layout_id HXC_LAYOUTS.LAYOUT_ID%TYPE;
171: l_object_version_number HXC_LAYOUTS.OBJECT_VERSION_NUMBER%TYPE;
172: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
173: l_dummy varchar2(3);
174:
175: CURSOR C_DISPLAY_NAME(p_layout_id IN NUMBER)

Line 181: FROM hxc_layouts_tl

177:
178: SELECT 'yes'
179: FROM dual
180: WHERE EXISTS (SELECT 'x'
181: FROM hxc_layouts_tl
182: WHERE layout_id = p_layout_id
183: and DISPLAY_LAYOUT_NAME <> P_DISPLAY_LAYOUT_NAME --added
184: AND userenv('LANG') in ( language, source_lang )
185: );

Line 214: FROM hxc_layouts

210: ,object_version_number
211: INTO l_modifier_level
212: ,l_layout_id
213: ,l_object_version_number
214: FROM hxc_layouts
215: WHERE layout_name = p_layout_name
216: AND application_id = l_application_id;
217: --
218: -- Remove all components for the layout if it already exists

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 319: l_layout_id HXC_LAYOUTS.LAYOUT_ID%TYPE;

315: ,P_CUSTOM_MODE IN VARCHAR2
316: )
317: IS
318: --
319: l_layout_id HXC_LAYOUTS.LAYOUT_ID%TYPE;
320: l_dummy varchar2(3);
321: --
322: BEGIN
323: --

Line 337: FROM hxc_layouts_tl

333: SELECT 'yes'
334: INTO l_dummy
335: FROM dual
336: WHERE EXISTS (SELECT 'x'
337: FROM hxc_layouts_tl
338: WHERE layout_id = l_layout_id
339: and DISPLAY_LAYOUT_NAME <> P_DISPLAY_LAYOUT_NAME --added
340: AND userenv('LANG') in ( language, source_lang )
341: );

Line 480: l_layout_id HXC_LAYOUTS.LAYOUT_ID%TYPE;

476: ,P_CUSTOM_MODE IN VARCHAR2
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;

Line 534: ,hxc_layouts lay

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

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 1008: l_layout_id hxc_layouts.layout_id%TYPE;

1004: )
1005: IS
1006:
1007: --
1008: l_layout_id hxc_layouts.layout_id%TYPE;
1009: l_object_version_number hxc_layouts.object_version_number%TYPE;
1010: l_application_id fnd_application.application_id%TYPE;
1011: l_dummy VARCHAR2(3);
1012: l_last_update_date_db DATE;

Line 1009: l_object_version_number hxc_layouts.object_version_number%TYPE;

1005: IS
1006:
1007: --
1008: l_layout_id hxc_layouts.layout_id%TYPE;
1009: l_object_version_number hxc_layouts.object_version_number%TYPE;
1010: l_application_id fnd_application.application_id%TYPE;
1011: l_dummy VARCHAR2(3);
1012: l_last_update_date_db DATE;
1013: l_last_updated_by_db NUMBER(15);

Line 1022: FROM hxc_layouts_tl

1018: IS
1019: SELECT 'yes'
1020: FROM dual
1021: WHERE EXISTS( SELECT 'x'
1022: FROM hxc_layouts_tl
1023: WHERE layout_id = p_layout_id
1024: AND display_layout_name <>
1025: p_display_layout_name --added
1026: AND userenv('LANG') IN (LANGUAGE, source_lang));

Line 1063: FROM hxc_layouts

1059: l_layout_id,
1060: l_object_version_number,
1061: l_last_update_date_db,
1062: l_last_updated_by_db
1063: FROM hxc_layouts
1064: WHERE layout_name = p_layout_name
1065: AND application_id = l_application_id;
1066:
1067: --

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 1192: l_layout_id hxc_layouts.layout_id%TYPE;

1188: )
1189: IS
1190:
1191: --
1192: l_layout_id hxc_layouts.layout_id%TYPE;
1193: l_dummy VARCHAR2(3);
1194: l_last_update_date_db DATE;
1195: l_last_updated_by_db NUMBER(15);
1196: l_last_updated_by_f NUMBER(15);

Line 1216: FROM hxc_layouts_tl

1212: SELECT 'yes'
1213: INTO l_dummy
1214: FROM dual
1215: WHERE EXISTS( SELECT 'x'
1216: FROM hxc_layouts_tl
1217: WHERE layout_id = l_layout_id
1218: AND display_layout_name <>
1219: p_display_layout_name --added
1220: AND userenv('LANG') IN (LANGUAGE, source_lang));

Line 1227: FROM hxc_layouts_tl

1223: SELECT last_update_date,
1224: last_updated_by
1225: INTO l_last_update_date_db,
1226: l_last_updated_by_db
1227: FROM hxc_layouts_tl
1228: WHERE layout_id = l_layout_id
1229: AND display_layout_name <> p_display_layout_name --added
1230: AND userenv('LANG') = LANGUAGE;
1231:

Line 1414: l_layout_id hxc_layouts.layout_id%TYPE;

1410: )
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;

Line 1480: hxc_layouts lay

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

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;