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_LOV_MIGRATION dependencies on JDR_DOCBUILDER

Line 74: region_obj jdr_docbuilder.DOCUMENT;

70: IS
71: --
72: region_row ak_regions_vl%ROWTYPE;
73:
74: region_obj jdr_docbuilder.DOCUMENT;
75: top_level_element jdr_docbuilder.ELEMENT;
76: table_element jdr_docbuilder.ELEMENT;
77: attribute_element jdr_docbuilder.ELEMENT;
78:

Line 75: top_level_element jdr_docbuilder.ELEMENT;

71: --
72: region_row ak_regions_vl%ROWTYPE;
73:
74: region_obj jdr_docbuilder.DOCUMENT;
75: top_level_element jdr_docbuilder.ELEMENT;
76: table_element jdr_docbuilder.ELEMENT;
77: attribute_element jdr_docbuilder.ELEMENT;
78:
79: mapping_obj jdr_docbuilder.DOCUMENT;

Line 76: table_element jdr_docbuilder.ELEMENT;

72: region_row ak_regions_vl%ROWTYPE;
73:
74: region_obj jdr_docbuilder.DOCUMENT;
75: top_level_element jdr_docbuilder.ELEMENT;
76: table_element jdr_docbuilder.ELEMENT;
77: attribute_element jdr_docbuilder.ELEMENT;
78:
79: mapping_obj jdr_docbuilder.DOCUMENT;
80: mapping_element jdr_docbuilder.ELEMENT;

Line 77: attribute_element jdr_docbuilder.ELEMENT;

73:
74: region_obj jdr_docbuilder.DOCUMENT;
75: top_level_element jdr_docbuilder.ELEMENT;
76: table_element jdr_docbuilder.ELEMENT;
77: attribute_element jdr_docbuilder.ELEMENT;
78:
79: mapping_obj jdr_docbuilder.DOCUMENT;
80: mapping_element jdr_docbuilder.ELEMENT;
81:

Line 79: mapping_obj jdr_docbuilder.DOCUMENT;

75: top_level_element jdr_docbuilder.ELEMENT;
76: table_element jdr_docbuilder.ELEMENT;
77: attribute_element jdr_docbuilder.ELEMENT;
78:
79: mapping_obj jdr_docbuilder.DOCUMENT;
80: mapping_element jdr_docbuilder.ELEMENT;
81:
82: l_document_name VARCHAR2(80);
83: result_code PLS_INTEGER;

Line 80: mapping_element jdr_docbuilder.ELEMENT;

76: table_element jdr_docbuilder.ELEMENT;
77: attribute_element jdr_docbuilder.ELEMENT;
78:
79: mapping_obj jdr_docbuilder.DOCUMENT;
80: mapping_element jdr_docbuilder.ELEMENT;
81:
82: l_document_name VARCHAR2(80);
83: result_code PLS_INTEGER;
84:

Line 102: mapping_obj := jdr_docbuilder.createChildDocument('/oracle/apps/hxc/regionMap/' || p_region_code);

98: -- verify the region exists, and is an LOV region and get the required attributes to set
99: region_row := get_region_row(p_region_code, p_application_id);
100:
101: -- create the ak-mds mapping
102: mapping_obj := jdr_docbuilder.createChildDocument('/oracle/apps/hxc/regionMap/' || p_region_code);
103: mapping_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'listOfValues');
104: jdr_docbuilder.setAttribute(mapping_element, 'docName', p_region_code);
105: jdr_docbuilder.setAttribute(mapping_element, 'extends', '/oracle/apps/hxc/selfservice/configui/webui/' || p_region_code);
106: jdr_docbuilder.setAttribute(mapping_element, 'user:akRegionStyle', 'LOV');

Line 103: mapping_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'listOfValues');

99: region_row := get_region_row(p_region_code, p_application_id);
100:
101: -- create the ak-mds mapping
102: mapping_obj := jdr_docbuilder.createChildDocument('/oracle/apps/hxc/regionMap/' || p_region_code);
103: mapping_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'listOfValues');
104: jdr_docbuilder.setAttribute(mapping_element, 'docName', p_region_code);
105: jdr_docbuilder.setAttribute(mapping_element, 'extends', '/oracle/apps/hxc/selfservice/configui/webui/' || p_region_code);
106: jdr_docbuilder.setAttribute(mapping_element, 'user:akRegionStyle', 'LOV');
107: jdr_docbuilder.setTopLevelElement(mapping_obj, mapping_element);

Line 104: jdr_docbuilder.setAttribute(mapping_element, 'docName', p_region_code);

100:
101: -- create the ak-mds mapping
102: mapping_obj := jdr_docbuilder.createChildDocument('/oracle/apps/hxc/regionMap/' || p_region_code);
103: mapping_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'listOfValues');
104: jdr_docbuilder.setAttribute(mapping_element, 'docName', p_region_code);
105: jdr_docbuilder.setAttribute(mapping_element, 'extends', '/oracle/apps/hxc/selfservice/configui/webui/' || p_region_code);
106: jdr_docbuilder.setAttribute(mapping_element, 'user:akRegionStyle', 'LOV');
107: jdr_docbuilder.setTopLevelElement(mapping_obj, mapping_element);
108:

Line 105: jdr_docbuilder.setAttribute(mapping_element, 'extends', '/oracle/apps/hxc/selfservice/configui/webui/' || p_region_code);

101: -- create the ak-mds mapping
102: mapping_obj := jdr_docbuilder.createChildDocument('/oracle/apps/hxc/regionMap/' || p_region_code);
103: mapping_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'listOfValues');
104: jdr_docbuilder.setAttribute(mapping_element, 'docName', p_region_code);
105: jdr_docbuilder.setAttribute(mapping_element, 'extends', '/oracle/apps/hxc/selfservice/configui/webui/' || p_region_code);
106: jdr_docbuilder.setAttribute(mapping_element, 'user:akRegionStyle', 'LOV');
107: jdr_docbuilder.setTopLevelElement(mapping_obj, mapping_element);
108:
109: -- save the MDS document

Line 106: jdr_docbuilder.setAttribute(mapping_element, 'user:akRegionStyle', 'LOV');

102: mapping_obj := jdr_docbuilder.createChildDocument('/oracle/apps/hxc/regionMap/' || p_region_code);
103: mapping_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'listOfValues');
104: jdr_docbuilder.setAttribute(mapping_element, 'docName', p_region_code);
105: jdr_docbuilder.setAttribute(mapping_element, 'extends', '/oracle/apps/hxc/selfservice/configui/webui/' || p_region_code);
106: jdr_docbuilder.setAttribute(mapping_element, 'user:akRegionStyle', 'LOV');
107: jdr_docbuilder.setTopLevelElement(mapping_obj, mapping_element);
108:
109: -- save the MDS document
110: result_code := jdr_docbuilder.save;

Line 107: jdr_docbuilder.setTopLevelElement(mapping_obj, mapping_element);

103: mapping_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'listOfValues');
104: jdr_docbuilder.setAttribute(mapping_element, 'docName', p_region_code);
105: jdr_docbuilder.setAttribute(mapping_element, 'extends', '/oracle/apps/hxc/selfservice/configui/webui/' || p_region_code);
106: jdr_docbuilder.setAttribute(mapping_element, 'user:akRegionStyle', 'LOV');
107: jdr_docbuilder.setTopLevelElement(mapping_obj, mapping_element);
108:
109: -- save the MDS document
110: result_code := jdr_docbuilder.save;
111:

Line 110: result_code := jdr_docbuilder.save;

106: jdr_docbuilder.setAttribute(mapping_element, 'user:akRegionStyle', 'LOV');
107: jdr_docbuilder.setTopLevelElement(mapping_obj, mapping_element);
108:
109: -- save the MDS document
110: result_code := jdr_docbuilder.save;
111:
112: IF result_code <> jdr_docbuilder.SUCCESS THEN
113: fnd_message.set_name('HXC', 'HXC_MDS_MAP_SAVE_FAILED');
114: fnd_message.raise_error;

Line 112: IF result_code <> jdr_docbuilder.SUCCESS THEN

108:
109: -- save the MDS document
110: result_code := jdr_docbuilder.save;
111:
112: IF result_code <> jdr_docbuilder.SUCCESS THEN
113: fnd_message.set_name('HXC', 'HXC_MDS_MAP_SAVE_FAILED');
114: fnd_message.raise_error;
115: END IF;
116:

Line 118: region_obj := jdr_docbuilder.createDocument('/oracle/apps/hxc/selfservice/configui/webui/' || p_region_code);

114: fnd_message.raise_error;
115: END IF;
116:
117: -- create the mds document object
118: region_obj := jdr_docbuilder.createDocument('/oracle/apps/hxc/selfservice/configui/webui/' || p_region_code);
119:
120: -- create the top level element
121: top_level_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'listOfValues');
122:

Line 121: top_level_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'listOfValues');

117: -- create the mds document object
118: region_obj := jdr_docbuilder.createDocument('/oracle/apps/hxc/selfservice/configui/webui/' || p_region_code);
119:
120: -- create the top level element
121: top_level_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'listOfValues');
122:
123: jdr_docbuilder.setAttribute(top_level_element, 'amDefName', region_row.applicationmodule_object_type);
124: jdr_docbuilder.setAttribute(top_level_element, 'controllerClass', region_row.region_object_type);
125: jdr_docbuilder.setAttribute(top_level_element, 'title', region_row.name);

Line 123: jdr_docbuilder.setAttribute(top_level_element, 'amDefName', region_row.applicationmodule_object_type);

119:
120: -- create the top level element
121: top_level_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'listOfValues');
122:
123: jdr_docbuilder.setAttribute(top_level_element, 'amDefName', region_row.applicationmodule_object_type);
124: jdr_docbuilder.setAttribute(top_level_element, 'controllerClass', region_row.region_object_type);
125: jdr_docbuilder.setAttribute(top_level_element, 'title', region_row.name);
126: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns', 'http://xmlns.oracle.com/jrad');
127: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:ui', 'http://xmlns.oracle.com/uix/ui');

Line 124: jdr_docbuilder.setAttribute(top_level_element, 'controllerClass', region_row.region_object_type);

120: -- create the top level element
121: top_level_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'listOfValues');
122:
123: jdr_docbuilder.setAttribute(top_level_element, 'amDefName', region_row.applicationmodule_object_type);
124: jdr_docbuilder.setAttribute(top_level_element, 'controllerClass', region_row.region_object_type);
125: jdr_docbuilder.setAttribute(top_level_element, 'title', region_row.name);
126: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns', 'http://xmlns.oracle.com/jrad');
127: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:ui', 'http://xmlns.oracle.com/uix/ui');
128: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:oa', 'http://xmlns.oracle.com/oa');

Line 125: jdr_docbuilder.setAttribute(top_level_element, 'title', region_row.name);

121: top_level_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'listOfValues');
122:
123: jdr_docbuilder.setAttribute(top_level_element, 'amDefName', region_row.applicationmodule_object_type);
124: jdr_docbuilder.setAttribute(top_level_element, 'controllerClass', region_row.region_object_type);
125: jdr_docbuilder.setAttribute(top_level_element, 'title', region_row.name);
126: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns', 'http://xmlns.oracle.com/jrad');
127: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:ui', 'http://xmlns.oracle.com/uix/ui');
128: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:oa', 'http://xmlns.oracle.com/oa');
129: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:user', 'http://xmlns.oracle.com/jrad/user');

Line 126: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns', 'http://xmlns.oracle.com/jrad');

122:
123: jdr_docbuilder.setAttribute(top_level_element, 'amDefName', region_row.applicationmodule_object_type);
124: jdr_docbuilder.setAttribute(top_level_element, 'controllerClass', region_row.region_object_type);
125: jdr_docbuilder.setAttribute(top_level_element, 'title', region_row.name);
126: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns', 'http://xmlns.oracle.com/jrad');
127: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:ui', 'http://xmlns.oracle.com/uix/ui');
128: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:oa', 'http://xmlns.oracle.com/oa');
129: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:user', 'http://xmlns.oracle.com/jrad/user');
130: jdr_docbuilder.setAttribute(top_level_element, 'file-version', '$Header: hxclovmig.pkb 115.3 2004/03/30 15:57:33 mstewart noship $');

Line 127: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:ui', 'http://xmlns.oracle.com/uix/ui');

123: jdr_docbuilder.setAttribute(top_level_element, 'amDefName', region_row.applicationmodule_object_type);
124: jdr_docbuilder.setAttribute(top_level_element, 'controllerClass', region_row.region_object_type);
125: jdr_docbuilder.setAttribute(top_level_element, 'title', region_row.name);
126: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns', 'http://xmlns.oracle.com/jrad');
127: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:ui', 'http://xmlns.oracle.com/uix/ui');
128: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:oa', 'http://xmlns.oracle.com/oa');
129: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:user', 'http://xmlns.oracle.com/jrad/user');
130: jdr_docbuilder.setAttribute(top_level_element, 'file-version', '$Header: hxclovmig.pkb 115.3 2004/03/30 15:57:33 mstewart noship $');
131: --jdr_docbuilder.setAttribute(top_level_element, 'version', '9.0.3.6.2_398');

Line 128: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:oa', 'http://xmlns.oracle.com/oa');

124: jdr_docbuilder.setAttribute(top_level_element, 'controllerClass', region_row.region_object_type);
125: jdr_docbuilder.setAttribute(top_level_element, 'title', region_row.name);
126: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns', 'http://xmlns.oracle.com/jrad');
127: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:ui', 'http://xmlns.oracle.com/uix/ui');
128: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:oa', 'http://xmlns.oracle.com/oa');
129: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:user', 'http://xmlns.oracle.com/jrad/user');
130: jdr_docbuilder.setAttribute(top_level_element, 'file-version', '$Header: hxclovmig.pkb 115.3 2004/03/30 15:57:33 mstewart noship $');
131: --jdr_docbuilder.setAttribute(top_level_element, 'version', '9.0.3.6.2_398');
132:

Line 129: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:user', 'http://xmlns.oracle.com/jrad/user');

125: jdr_docbuilder.setAttribute(top_level_element, 'title', region_row.name);
126: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns', 'http://xmlns.oracle.com/jrad');
127: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:ui', 'http://xmlns.oracle.com/uix/ui');
128: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:oa', 'http://xmlns.oracle.com/oa');
129: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:user', 'http://xmlns.oracle.com/jrad/user');
130: jdr_docbuilder.setAttribute(top_level_element, 'file-version', '$Header: hxclovmig.pkb 115.3 2004/03/30 15:57:33 mstewart noship $');
131: --jdr_docbuilder.setAttribute(top_level_element, 'version', '9.0.3.6.2_398');
132:
133: jdr_docbuilder.setTopLevelElement(region_obj, top_level_element);

Line 130: jdr_docbuilder.setAttribute(top_level_element, 'file-version', '$Header: hxclovmig.pkb 115.3 2004/03/30 15:57:33 mstewart noship $');

126: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns', 'http://xmlns.oracle.com/jrad');
127: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:ui', 'http://xmlns.oracle.com/uix/ui');
128: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:oa', 'http://xmlns.oracle.com/oa');
129: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:user', 'http://xmlns.oracle.com/jrad/user');
130: jdr_docbuilder.setAttribute(top_level_element, 'file-version', '$Header: hxclovmig.pkb 115.3 2004/03/30 15:57:33 mstewart noship $');
131: --jdr_docbuilder.setAttribute(top_level_element, 'version', '9.0.3.6.2_398');
132:
133: jdr_docbuilder.setTopLevelElement(region_obj, top_level_element);
134:

Line 131: --jdr_docbuilder.setAttribute(top_level_element, 'version', '9.0.3.6.2_398');

127: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:ui', 'http://xmlns.oracle.com/uix/ui');
128: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:oa', 'http://xmlns.oracle.com/oa');
129: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:user', 'http://xmlns.oracle.com/jrad/user');
130: jdr_docbuilder.setAttribute(top_level_element, 'file-version', '$Header: hxclovmig.pkb 115.3 2004/03/30 15:57:33 mstewart noship $');
131: --jdr_docbuilder.setAttribute(top_level_element, 'version', '9.0.3.6.2_398');
132:
133: jdr_docbuilder.setTopLevelElement(region_obj, top_level_element);
134:
135:

Line 133: jdr_docbuilder.setTopLevelElement(region_obj, top_level_element);

129: --jdr_docbuilder.setAttribute(top_level_element, 'xmlns:user', 'http://xmlns.oracle.com/jrad/user');
130: jdr_docbuilder.setAttribute(top_level_element, 'file-version', '$Header: hxclovmig.pkb 115.3 2004/03/30 15:57:33 mstewart noship $');
131: --jdr_docbuilder.setAttribute(top_level_element, 'version', '9.0.3.6.2_398');
132:
133: jdr_docbuilder.setTopLevelElement(region_obj, top_level_element);
134:
135:
136: table_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'table');
137: jdr_docbuilder.setAttribute(table_element, 'name', region_row.region_code);

Line 136: table_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'table');

132:
133: jdr_docbuilder.setTopLevelElement(region_obj, top_level_element);
134:
135:
136: table_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'table');
137: jdr_docbuilder.setAttribute(table_element, 'name', region_row.region_code);
138: jdr_docbuilder.setAttribute(table_element, 'id', region_row.region_code || '_lovTable');
139: jdr_docbuilder.setAttribute(table_element, 'akRegionCode', region_row.region_code);
140: jdr_docbuilder.setAttribute(table_element, 'regionName', region_row.name);

Line 137: jdr_docbuilder.setAttribute(table_element, 'name', region_row.region_code);

133: jdr_docbuilder.setTopLevelElement(region_obj, top_level_element);
134:
135:
136: table_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'table');
137: jdr_docbuilder.setAttribute(table_element, 'name', region_row.region_code);
138: jdr_docbuilder.setAttribute(table_element, 'id', region_row.region_code || '_lovTable');
139: jdr_docbuilder.setAttribute(table_element, 'akRegionCode', region_row.region_code);
140: jdr_docbuilder.setAttribute(table_element, 'regionName', region_row.name);
141: jdr_docbuilder.setAttribute(table_element, 'blockSize', region_row.num_rows_display);

Line 138: jdr_docbuilder.setAttribute(table_element, 'id', region_row.region_code || '_lovTable');

134:
135:
136: table_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'table');
137: jdr_docbuilder.setAttribute(table_element, 'name', region_row.region_code);
138: jdr_docbuilder.setAttribute(table_element, 'id', region_row.region_code || '_lovTable');
139: jdr_docbuilder.setAttribute(table_element, 'akRegionCode', region_row.region_code);
140: jdr_docbuilder.setAttribute(table_element, 'regionName', region_row.name);
141: jdr_docbuilder.setAttribute(table_element, 'blockSize', region_row.num_rows_display);
142: jdr_docbuilder.setAttribute(table_element, 'standalone', 'true');

Line 139: jdr_docbuilder.setAttribute(table_element, 'akRegionCode', region_row.region_code);

135:
136: table_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'table');
137: jdr_docbuilder.setAttribute(table_element, 'name', region_row.region_code);
138: jdr_docbuilder.setAttribute(table_element, 'id', region_row.region_code || '_lovTable');
139: jdr_docbuilder.setAttribute(table_element, 'akRegionCode', region_row.region_code);
140: jdr_docbuilder.setAttribute(table_element, 'regionName', region_row.name);
141: jdr_docbuilder.setAttribute(table_element, 'blockSize', region_row.num_rows_display);
142: jdr_docbuilder.setAttribute(table_element, 'standalone', 'true');
143:

Line 140: jdr_docbuilder.setAttribute(table_element, 'regionName', region_row.name);

136: table_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'table');
137: jdr_docbuilder.setAttribute(table_element, 'name', region_row.region_code);
138: jdr_docbuilder.setAttribute(table_element, 'id', region_row.region_code || '_lovTable');
139: jdr_docbuilder.setAttribute(table_element, 'akRegionCode', region_row.region_code);
140: jdr_docbuilder.setAttribute(table_element, 'regionName', region_row.name);
141: jdr_docbuilder.setAttribute(table_element, 'blockSize', region_row.num_rows_display);
142: jdr_docbuilder.setAttribute(table_element, 'standalone', 'true');
143:
144: jdr_docbuilder.addChild(top_level_element, jdr_docbuilder.UI_NS, 'contents', table_element);

Line 141: jdr_docbuilder.setAttribute(table_element, 'blockSize', region_row.num_rows_display);

137: jdr_docbuilder.setAttribute(table_element, 'name', region_row.region_code);
138: jdr_docbuilder.setAttribute(table_element, 'id', region_row.region_code || '_lovTable');
139: jdr_docbuilder.setAttribute(table_element, 'akRegionCode', region_row.region_code);
140: jdr_docbuilder.setAttribute(table_element, 'regionName', region_row.name);
141: jdr_docbuilder.setAttribute(table_element, 'blockSize', region_row.num_rows_display);
142: jdr_docbuilder.setAttribute(table_element, 'standalone', 'true');
143:
144: jdr_docbuilder.addChild(top_level_element, jdr_docbuilder.UI_NS, 'contents', table_element);
145:

Line 142: jdr_docbuilder.setAttribute(table_element, 'standalone', 'true');

138: jdr_docbuilder.setAttribute(table_element, 'id', region_row.region_code || '_lovTable');
139: jdr_docbuilder.setAttribute(table_element, 'akRegionCode', region_row.region_code);
140: jdr_docbuilder.setAttribute(table_element, 'regionName', region_row.name);
141: jdr_docbuilder.setAttribute(table_element, 'blockSize', region_row.num_rows_display);
142: jdr_docbuilder.setAttribute(table_element, 'standalone', 'true');
143:
144: jdr_docbuilder.addChild(top_level_element, jdr_docbuilder.UI_NS, 'contents', table_element);
145:
146: -- now loop through the child elements, adding a node for each one

Line 144: jdr_docbuilder.addChild(top_level_element, jdr_docbuilder.UI_NS, 'contents', table_element);

140: jdr_docbuilder.setAttribute(table_element, 'regionName', region_row.name);
141: jdr_docbuilder.setAttribute(table_element, 'blockSize', region_row.num_rows_display);
142: jdr_docbuilder.setAttribute(table_element, 'standalone', 'true');
143:
144: jdr_docbuilder.addChild(top_level_element, jdr_docbuilder.UI_NS, 'contents', table_element);
145:
146: -- now loop through the child elements, adding a node for each one
147: FOR region_attr_row IN csr_get_region_items(p_region_code, p_application_id) LOOP
148: attribute_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'messageStyledText');

Line 148: attribute_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'messageStyledText');

144: jdr_docbuilder.addChild(top_level_element, jdr_docbuilder.UI_NS, 'contents', table_element);
145:
146: -- now loop through the child elements, adding a node for each one
147: FOR region_attr_row IN csr_get_region_items(p_region_code, p_application_id) LOOP
148: attribute_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'messageStyledText');
149: IF region_attr_row.node_query_flag = 'Y' THEN
150: jdr_docbuilder.setAttribute(attribute_element, 'queryable', 'true');
151: END IF;
152:

Line 150: jdr_docbuilder.setAttribute(attribute_element, 'queryable', 'true');

146: -- now loop through the child elements, adding a node for each one
147: FOR region_attr_row IN csr_get_region_items(p_region_code, p_application_id) LOOP
148: attribute_element := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS, 'messageStyledText');
149: IF region_attr_row.node_query_flag = 'Y' THEN
150: jdr_docbuilder.setAttribute(attribute_element, 'queryable', 'true');
151: END IF;
152:
153: IF region_attr_row.node_display_flag = 'N' THEN
154: jdr_docbuilder.setAttribute(attribute_element, 'rendered', 'false');

Line 154: jdr_docbuilder.setAttribute(attribute_element, 'rendered', 'false');

150: jdr_docbuilder.setAttribute(attribute_element, 'queryable', 'true');
151: END IF;
152:
153: IF region_attr_row.node_display_flag = 'N' THEN
154: jdr_docbuilder.setAttribute(attribute_element, 'rendered', 'false');
155: END IF;
156:
157: jdr_docbuilder.setAttribute(attribute_element, 'vAlign', region_attr_row.vertical_alignment);
158: jdr_docbuilder.setAttribute(attribute_element, 'columns', region_attr_row.display_value_length);

Line 157: jdr_docbuilder.setAttribute(attribute_element, 'vAlign', region_attr_row.vertical_alignment);

153: IF region_attr_row.node_display_flag = 'N' THEN
154: jdr_docbuilder.setAttribute(attribute_element, 'rendered', 'false');
155: END IF;
156:
157: jdr_docbuilder.setAttribute(attribute_element, 'vAlign', region_attr_row.vertical_alignment);
158: jdr_docbuilder.setAttribute(attribute_element, 'columns', region_attr_row.display_value_length);
159: jdr_docbuilder.setAttribute(attribute_element, 'prompt', region_attr_row.attribute_label_long);
160:
161: IF region_attr_row.data_type IN ('NUMBER', 'DATE') THEN

Line 158: jdr_docbuilder.setAttribute(attribute_element, 'columns', region_attr_row.display_value_length);

154: jdr_docbuilder.setAttribute(attribute_element, 'rendered', 'false');
155: END IF;
156:
157: jdr_docbuilder.setAttribute(attribute_element, 'vAlign', region_attr_row.vertical_alignment);
158: jdr_docbuilder.setAttribute(attribute_element, 'columns', region_attr_row.display_value_length);
159: jdr_docbuilder.setAttribute(attribute_element, 'prompt', region_attr_row.attribute_label_long);
160:
161: IF region_attr_row.data_type IN ('NUMBER', 'DATE') THEN
162: jdr_docbuilder.setAttribute(attribute_element, 'dataType', region_attr_row.data_type);

Line 159: jdr_docbuilder.setAttribute(attribute_element, 'prompt', region_attr_row.attribute_label_long);

155: END IF;
156:
157: jdr_docbuilder.setAttribute(attribute_element, 'vAlign', region_attr_row.vertical_alignment);
158: jdr_docbuilder.setAttribute(attribute_element, 'columns', region_attr_row.display_value_length);
159: jdr_docbuilder.setAttribute(attribute_element, 'prompt', region_attr_row.attribute_label_long);
160:
161: IF region_attr_row.data_type IN ('NUMBER', 'DATE') THEN
162: jdr_docbuilder.setAttribute(attribute_element, 'dataType', region_attr_row.data_type);
163: END IF;

Line 162: jdr_docbuilder.setAttribute(attribute_element, 'dataType', region_attr_row.data_type);

158: jdr_docbuilder.setAttribute(attribute_element, 'columns', region_attr_row.display_value_length);
159: jdr_docbuilder.setAttribute(attribute_element, 'prompt', region_attr_row.attribute_label_long);
160:
161: IF region_attr_row.data_type IN ('NUMBER', 'DATE') THEN
162: jdr_docbuilder.setAttribute(attribute_element, 'dataType', region_attr_row.data_type);
163: END IF;
164:
165: jdr_docbuilder.setAttribute(attribute_element, 'rows', region_attr_row.display_height);
166: jdr_docbuilder.setAttribute(attribute_element, 'viewName', region_attr_row.view_usage_name);

Line 165: jdr_docbuilder.setAttribute(attribute_element, 'rows', region_attr_row.display_height);

161: IF region_attr_row.data_type IN ('NUMBER', 'DATE') THEN
162: jdr_docbuilder.setAttribute(attribute_element, 'dataType', region_attr_row.data_type);
163: END IF;
164:
165: jdr_docbuilder.setAttribute(attribute_element, 'rows', region_attr_row.display_height);
166: jdr_docbuilder.setAttribute(attribute_element, 'viewName', region_attr_row.view_usage_name);
167: jdr_docbuilder.setAttribute(attribute_element, 'viewAttr', region_attr_row.view_attribute_name);
168: jdr_docbuilder.setAttribute(attribute_element, 'maximumLength', region_attr_row.attribute_value_length);
169: jdr_docbuilder.setAttribute(attribute_element, 'id', region_attr_row.item_name);

Line 166: jdr_docbuilder.setAttribute(attribute_element, 'viewName', region_attr_row.view_usage_name);

162: jdr_docbuilder.setAttribute(attribute_element, 'dataType', region_attr_row.data_type);
163: END IF;
164:
165: jdr_docbuilder.setAttribute(attribute_element, 'rows', region_attr_row.display_height);
166: jdr_docbuilder.setAttribute(attribute_element, 'viewName', region_attr_row.view_usage_name);
167: jdr_docbuilder.setAttribute(attribute_element, 'viewAttr', region_attr_row.view_attribute_name);
168: jdr_docbuilder.setAttribute(attribute_element, 'maximumLength', region_attr_row.attribute_value_length);
169: jdr_docbuilder.setAttribute(attribute_element, 'id', region_attr_row.item_name);
170: jdr_docbuilder.setAttribute(attribute_element, 'promptTranslationExpansion', '100%');

Line 167: jdr_docbuilder.setAttribute(attribute_element, 'viewAttr', region_attr_row.view_attribute_name);

163: END IF;
164:
165: jdr_docbuilder.setAttribute(attribute_element, 'rows', region_attr_row.display_height);
166: jdr_docbuilder.setAttribute(attribute_element, 'viewName', region_attr_row.view_usage_name);
167: jdr_docbuilder.setAttribute(attribute_element, 'viewAttr', region_attr_row.view_attribute_name);
168: jdr_docbuilder.setAttribute(attribute_element, 'maximumLength', region_attr_row.attribute_value_length);
169: jdr_docbuilder.setAttribute(attribute_element, 'id', region_attr_row.item_name);
170: jdr_docbuilder.setAttribute(attribute_element, 'promptTranslationExpansion', '100%');
171: jdr_docbuilder.setAttribute(attribute_element, 'user:akAttributeCode', region_attr_row.attribute_code);

Line 168: jdr_docbuilder.setAttribute(attribute_element, 'maximumLength', region_attr_row.attribute_value_length);

164:
165: jdr_docbuilder.setAttribute(attribute_element, 'rows', region_attr_row.display_height);
166: jdr_docbuilder.setAttribute(attribute_element, 'viewName', region_attr_row.view_usage_name);
167: jdr_docbuilder.setAttribute(attribute_element, 'viewAttr', region_attr_row.view_attribute_name);
168: jdr_docbuilder.setAttribute(attribute_element, 'maximumLength', region_attr_row.attribute_value_length);
169: jdr_docbuilder.setAttribute(attribute_element, 'id', region_attr_row.item_name);
170: jdr_docbuilder.setAttribute(attribute_element, 'promptTranslationExpansion', '100%');
171: jdr_docbuilder.setAttribute(attribute_element, 'user:akAttributeCode', region_attr_row.attribute_code);
172: jdr_docbuilder.setAttribute(attribute_element, 'user:akAttributeApplicationId', region_attr_row.attribute_application_id);

Line 169: jdr_docbuilder.setAttribute(attribute_element, 'id', region_attr_row.item_name);

165: jdr_docbuilder.setAttribute(attribute_element, 'rows', region_attr_row.display_height);
166: jdr_docbuilder.setAttribute(attribute_element, 'viewName', region_attr_row.view_usage_name);
167: jdr_docbuilder.setAttribute(attribute_element, 'viewAttr', region_attr_row.view_attribute_name);
168: jdr_docbuilder.setAttribute(attribute_element, 'maximumLength', region_attr_row.attribute_value_length);
169: jdr_docbuilder.setAttribute(attribute_element, 'id', region_attr_row.item_name);
170: jdr_docbuilder.setAttribute(attribute_element, 'promptTranslationExpansion', '100%');
171: jdr_docbuilder.setAttribute(attribute_element, 'user:akAttributeCode', region_attr_row.attribute_code);
172: jdr_docbuilder.setAttribute(attribute_element, 'user:akAttributeApplicationId', region_attr_row.attribute_application_id);
173:

Line 170: jdr_docbuilder.setAttribute(attribute_element, 'promptTranslationExpansion', '100%');

166: jdr_docbuilder.setAttribute(attribute_element, 'viewName', region_attr_row.view_usage_name);
167: jdr_docbuilder.setAttribute(attribute_element, 'viewAttr', region_attr_row.view_attribute_name);
168: jdr_docbuilder.setAttribute(attribute_element, 'maximumLength', region_attr_row.attribute_value_length);
169: jdr_docbuilder.setAttribute(attribute_element, 'id', region_attr_row.item_name);
170: jdr_docbuilder.setAttribute(attribute_element, 'promptTranslationExpansion', '100%');
171: jdr_docbuilder.setAttribute(attribute_element, 'user:akAttributeCode', region_attr_row.attribute_code);
172: jdr_docbuilder.setAttribute(attribute_element, 'user:akAttributeApplicationId', region_attr_row.attribute_application_id);
173:
174: IF region_attr_row.data_type = 'DATE' THEN

Line 171: jdr_docbuilder.setAttribute(attribute_element, 'user:akAttributeCode', region_attr_row.attribute_code);

167: jdr_docbuilder.setAttribute(attribute_element, 'viewAttr', region_attr_row.view_attribute_name);
168: jdr_docbuilder.setAttribute(attribute_element, 'maximumLength', region_attr_row.attribute_value_length);
169: jdr_docbuilder.setAttribute(attribute_element, 'id', region_attr_row.item_name);
170: jdr_docbuilder.setAttribute(attribute_element, 'promptTranslationExpansion', '100%');
171: jdr_docbuilder.setAttribute(attribute_element, 'user:akAttributeCode', region_attr_row.attribute_code);
172: jdr_docbuilder.setAttribute(attribute_element, 'user:akAttributeApplicationId', region_attr_row.attribute_application_id);
173:
174: IF region_attr_row.data_type = 'DATE' THEN
175: jdr_docbuilder.setAttribute(attribute_element, 'tipType', 'dateFormat');

Line 172: jdr_docbuilder.setAttribute(attribute_element, 'user:akAttributeApplicationId', region_attr_row.attribute_application_id);

168: jdr_docbuilder.setAttribute(attribute_element, 'maximumLength', region_attr_row.attribute_value_length);
169: jdr_docbuilder.setAttribute(attribute_element, 'id', region_attr_row.item_name);
170: jdr_docbuilder.setAttribute(attribute_element, 'promptTranslationExpansion', '100%');
171: jdr_docbuilder.setAttribute(attribute_element, 'user:akAttributeCode', region_attr_row.attribute_code);
172: jdr_docbuilder.setAttribute(attribute_element, 'user:akAttributeApplicationId', region_attr_row.attribute_application_id);
173:
174: IF region_attr_row.data_type = 'DATE' THEN
175: jdr_docbuilder.setAttribute(attribute_element, 'tipType', 'dateFormat');
176: END IF;

Line 175: jdr_docbuilder.setAttribute(attribute_element, 'tipType', 'dateFormat');

171: jdr_docbuilder.setAttribute(attribute_element, 'user:akAttributeCode', region_attr_row.attribute_code);
172: jdr_docbuilder.setAttribute(attribute_element, 'user:akAttributeApplicationId', region_attr_row.attribute_application_id);
173:
174: IF region_attr_row.data_type = 'DATE' THEN
175: jdr_docbuilder.setAttribute(attribute_element, 'tipType', 'dateFormat');
176: END IF;
177:
178: jdr_docbuilder.addChild(table_element, jdr_docbuilder.UI_NS, 'contents', attribute_element);
179: END LOOP;

Line 178: jdr_docbuilder.addChild(table_element, jdr_docbuilder.UI_NS, 'contents', attribute_element);

174: IF region_attr_row.data_type = 'DATE' THEN
175: jdr_docbuilder.setAttribute(attribute_element, 'tipType', 'dateFormat');
176: END IF;
177:
178: jdr_docbuilder.addChild(table_element, jdr_docbuilder.UI_NS, 'contents', attribute_element);
179: END LOOP;
180:
181: -- save the MDS document
182: result_code := jdr_docbuilder.save;

Line 182: result_code := jdr_docbuilder.save;

178: jdr_docbuilder.addChild(table_element, jdr_docbuilder.UI_NS, 'contents', attribute_element);
179: END LOOP;
180:
181: -- save the MDS document
182: result_code := jdr_docbuilder.save;
183:
184: IF result_code <> jdr_docbuilder.SUCCESS THEN
185: fnd_message.set_name('HXC', 'HXC_MDS_SAVE_FAILED');
186: fnd_message.raise_error;

Line 184: IF result_code <> jdr_docbuilder.SUCCESS THEN

180:
181: -- save the MDS document
182: result_code := jdr_docbuilder.save;
183:
184: IF result_code <> jdr_docbuilder.SUCCESS THEN
185: fnd_message.set_name('HXC', 'HXC_MDS_SAVE_FAILED');
186: fnd_message.raise_error;
187: END IF;
188:

Line 198: RETURN jdr_docbuilder.documentExists('/oracle/apps/hxc/selfservice/configui/webui/' || p_region_code);

194: RETURN BOOLEAN
195: IS
196: BEGIN
197: --
198: RETURN jdr_docbuilder.documentExists('/oracle/apps/hxc/selfservice/configui/webui/' || p_region_code);
199: --
200: END mds_doc_exists;
201:
202: -- =================================================================