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.JTF_TERR_DEFINITION_REPORT_PVT dependencies on HTP

Line 107: htp.htmlopen;

103: xls(l_srp,
104: l_qual);
105: else
106: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
107: htp.htmlopen;
108: htp.headOpen;
109: htp.title('Territory Definitions');
110:
111: htp.headClose;

Line 108: htp.headOpen;

104: l_qual);
105: else
106: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
107: htp.htmlopen;
108: htp.headOpen;
109: htp.title('Territory Definitions');
110:
111: htp.headClose;
112: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

Line 109: htp.title('Territory Definitions');

105: else
106: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
107: htp.htmlopen;
108: htp.headOpen;
109: htp.title('Territory Definitions');
110:
111: htp.headClose;
112: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
113: htp.formOpen( curl => l_agent||'/'||'jtf_terr_definition_report.xls', cmethod => 'POST', cattributes => ' name="excel"');

Line 111: htp.headClose;

107: htp.htmlopen;
108: htp.headOpen;
109: htp.title('Territory Definitions');
110:
111: htp.headClose;
112: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
113: htp.formOpen( curl => l_agent||'/'||'jtf_terr_definition_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
114: htp.formHidden( cname => 'p_srp', cvalue => l_srp);
115: --htp.formHidden( cname => 'p_sgrp', cvalue => l_sgrp);

Line 112: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');

108: htp.headOpen;
109: htp.title('Territory Definitions');
110:
111: htp.headClose;
112: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
113: htp.formOpen( curl => l_agent||'/'||'jtf_terr_definition_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
114: htp.formHidden( cname => 'p_srp', cvalue => l_srp);
115: --htp.formHidden( cname => 'p_sgrp', cvalue => l_sgrp);
116: htp.formHidden( cname => 'p_qual', cvalue => l_qual);

Line 113: htp.formOpen( curl => l_agent||'/'||'jtf_terr_definition_report.xls', cmethod => 'POST', cattributes => ' name="excel"');

109: htp.title('Territory Definitions');
110:
111: htp.headClose;
112: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
113: htp.formOpen( curl => l_agent||'/'||'jtf_terr_definition_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
114: htp.formHidden( cname => 'p_srp', cvalue => l_srp);
115: --htp.formHidden( cname => 'p_sgrp', cvalue => l_sgrp);
116: htp.formHidden( cname => 'p_qual', cvalue => l_qual);
117: htp.formClose;

Line 114: htp.formHidden( cname => 'p_srp', cvalue => l_srp);

110:
111: htp.headClose;
112: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
113: htp.formOpen( curl => l_agent||'/'||'jtf_terr_definition_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
114: htp.formHidden( cname => 'p_srp', cvalue => l_srp);
115: --htp.formHidden( cname => 'p_sgrp', cvalue => l_sgrp);
116: htp.formHidden( cname => 'p_qual', cvalue => l_qual);
117: htp.formClose;
118:

Line 115: --htp.formHidden( cname => 'p_sgrp', cvalue => l_sgrp);

111: htp.headClose;
112: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
113: htp.formOpen( curl => l_agent||'/'||'jtf_terr_definition_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
114: htp.formHidden( cname => 'p_srp', cvalue => l_srp);
115: --htp.formHidden( cname => 'p_sgrp', cvalue => l_sgrp);
116: htp.formHidden( cname => 'p_qual', cvalue => l_qual);
117: htp.formClose;
118:
119: htp.p('

');

Line 116: htp.formHidden( cname => 'p_qual', cvalue => l_qual);

112: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
113: htp.formOpen( curl => l_agent||'/'||'jtf_terr_definition_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
114: htp.formHidden( cname => 'p_srp', cvalue => l_srp);
115: --htp.formHidden( cname => 'p_sgrp', cvalue => l_sgrp);
116: htp.formHidden( cname => 'p_qual', cvalue => l_qual);
117: htp.formClose;
118:
119: htp.p('

');
120: htp.tableOpen('border="0" ');

Line 117: htp.formClose;

113: htp.formOpen( curl => l_agent||'/'||'jtf_terr_definition_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
114: htp.formHidden( cname => 'p_srp', cvalue => l_srp);
115: --htp.formHidden( cname => 'p_sgrp', cvalue => l_sgrp);
116: htp.formHidden( cname => 'p_qual', cvalue => l_qual);
117: htp.formClose;
118:
119: htp.p('

');
120: htp.tableOpen('border="0" ');
121: htp.tableRowOpen( calign => 'TOP' );

Line 119: htp.p('');

115: --htp.formHidden( cname => 'p_sgrp', cvalue => l_sgrp);
116: htp.formHidden( cname => 'p_qual', cvalue => l_qual);
117: htp.formClose;
118:
119: htp.p('

');
120: htp.tableOpen('border="0" ');
121: htp.tableRowOpen( calign => 'TOP' );
122: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
123: htp.tableData( '' || 'Territory Definitions Report', cnowrap => 'TRUE');

Line 120: htp.tableOpen('border="0" ');

116: htp.formHidden( cname => 'p_qual', cvalue => l_qual);
117: htp.formClose;
118:
119: htp.p('

');
120: htp.tableOpen('border="0" ');
121: htp.tableRowOpen( calign => 'TOP' );
122: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
123: htp.tableData( '' || 'Territory Definitions Report', cnowrap => 'TRUE');
124: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');

Line 121: htp.tableRowOpen( calign => 'TOP' );

117: htp.formClose;
118:
119: htp.p('

');
120: htp.tableOpen('border="0" ');
121: htp.tableRowOpen( calign => 'TOP' );
122: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
123: htp.tableData( '' || 'Territory Definitions Report', cnowrap => 'TRUE');
124: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
125: htp.tableRowClose;

Line 122: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));

118:
119: htp.p('

');
120: htp.tableOpen('border="0" ');
121: htp.tableRowOpen( calign => 'TOP' );
122: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
123: htp.tableData( '' || 'Territory Definitions Report', cnowrap => 'TRUE');
124: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
125: htp.tableRowClose;
126: /*

Line 123: htp.tableData( '' || 'Territory Definitions Report', cnowrap => 'TRUE');

119: htp.p('

');
120: htp.tableOpen('border="0" ');
121: htp.tableRowOpen( calign => 'TOP' );
122: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
123: htp.tableData( '' || 'Territory Definitions Report', cnowrap => 'TRUE');
124: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
125: htp.tableRowClose;
126: /*
127: htp.tableRowOpen( calign => 'TOP' );

Line 124: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');

120: htp.tableOpen('border="0" ');
121: htp.tableRowOpen( calign => 'TOP' );
122: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
123: htp.tableData( '' || 'Territory Definitions Report', cnowrap => 'TRUE');
124: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
125: htp.tableRowClose;
126: /*
127: htp.tableRowOpen( calign => 'TOP' );
128: htp.tableData('Usage: ' ||l_usg_name);

Line 125: htp.tableRowClose;

121: htp.tableRowOpen( calign => 'TOP' );
122: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
123: htp.tableData( '' || 'Territory Definitions Report', cnowrap => 'TRUE');
124: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
125: htp.tableRowClose;
126: /*
127: htp.tableRowOpen( calign => 'TOP' );
128: htp.tableData('Usage: ' ||l_usg_name);
129: htp.tableRowClose;

Line 127: htp.tableRowOpen( calign => 'TOP' );

123: htp.tableData( '' || 'Territory Definitions Report', cnowrap => 'TRUE');
124: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
125: htp.tableRowClose;
126: /*
127: htp.tableRowOpen( calign => 'TOP' );
128: htp.tableData('Usage: ' ||l_usg_name);
129: htp.tableRowClose;
130: */
131: htp.tableClose;

Line 128: htp.tableData('Usage: ' ||l_usg_name);

124: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
125: htp.tableRowClose;
126: /*
127: htp.tableRowOpen( calign => 'TOP' );
128: htp.tableData('Usage: ' ||l_usg_name);
129: htp.tableRowClose;
130: */
131: htp.tableClose;
132: htp.br;

Line 129: htp.tableRowClose;

125: htp.tableRowClose;
126: /*
127: htp.tableRowOpen( calign => 'TOP' );
128: htp.tableData('Usage: ' ||l_usg_name);
129: htp.tableRowClose;
130: */
131: htp.tableClose;
132: htp.br;
133:

Line 131: htp.tableClose;

127: htp.tableRowOpen( calign => 'TOP' );
128: htp.tableData('Usage: ' ||l_usg_name);
129: htp.tableRowClose;
130: */
131: htp.tableClose;
132: htp.br;
133:
134: htp.tableOpen (cattributes => 'COLS=4 border="1" width="100%"');
135: fnd_client_info.set_org_context(fnd_profile.value_wnps('ORG_ID'));

Line 132: htp.br;

128: htp.tableData('Usage: ' ||l_usg_name);
129: htp.tableRowClose;
130: */
131: htp.tableClose;
132: htp.br;
133:
134: htp.tableOpen (cattributes => 'COLS=4 border="1" width="100%"');
135: fnd_client_info.set_org_context(fnd_profile.value_wnps('ORG_ID'));
136: -- display territories

Line 134: htp.tableOpen (cattributes => 'COLS=4 border="1" width="100%"');

130: */
131: htp.tableClose;
132: htp.br;
133:
134: htp.tableOpen (cattributes => 'COLS=4 border="1" width="100%"');
135: fnd_client_info.set_org_context(fnd_profile.value_wnps('ORG_ID'));
136: -- display territories
137: l_rec_count := 0;
138: FOR rec_terr in cur_terr loop

Line 139: htp.tableRowOpen;

135: fnd_client_info.set_org_context(fnd_profile.value_wnps('ORG_ID'));
136: -- display territories
137: l_rec_count := 0;
138: FOR rec_terr in cur_terr loop
139: htp.tableRowOpen;
140: htp.p('');
141: htp.p('');
142: htp.p(rec_terr.name);
143: htp.p('');

Line 140: htp.p('');

136: -- display territories
137: l_rec_count := 0;
138: FOR rec_terr in cur_terr loop
139: htp.tableRowOpen;
140: htp.p('');
141: htp.p('');
142: htp.p(rec_terr.name);
143: htp.p('');
144: htp.p('');

Line 141: htp.p('');

137: l_rec_count := 0;
138: FOR rec_terr in cur_terr loop
139: htp.tableRowOpen;
140: htp.p('');
141: htp.p('');
142: htp.p(rec_terr.name);
143: htp.p('');
144: htp.p('');
145: htp.p('Rank: ' ||rec_terr.rank);

Line 142: htp.p(rec_terr.name);

138: FOR rec_terr in cur_terr loop
139: htp.tableRowOpen;
140: htp.p('');
141: htp.p('');
142: htp.p(rec_terr.name);
143: htp.p('');
144: htp.p('');
145: htp.p('Rank: ' ||rec_terr.rank);
146: htp.p('');

Line 143: htp.p('');

139: htp.tableRowOpen;
140: htp.p('');
141: htp.p('');
142: htp.p(rec_terr.name);
143: htp.p('');
144: htp.p('');
145: htp.p('Rank: ' ||rec_terr.rank);
146: htp.p('');
147: htp.tableRowClose;

Line 144: htp.p('');

140: htp.p('');
141: htp.p('');
142: htp.p(rec_terr.name);
143: htp.p('');
144: htp.p('');
145: htp.p('Rank: ' ||rec_terr.rank);
146: htp.p('');
147: htp.tableRowClose;
148: l_rec_count := l_rec_count + 1;

Line 145: htp.p('Rank: ' ||rec_terr.rank);

141: htp.p('');
142: htp.p(rec_terr.name);
143: htp.p('');
144: htp.p('');
145: htp.p('Rank: ' ||rec_terr.rank);
146: htp.p('');
147: htp.tableRowClose;
148: l_rec_count := l_rec_count + 1;
149: -- display sales reps

Line 146: htp.p('');

142: htp.p(rec_terr.name);
143: htp.p('');
144: htp.p('');
145: htp.p('Rank: ' ||rec_terr.rank);
146: htp.p('');
147: htp.tableRowClose;
148: l_rec_count := l_rec_count + 1;
149: -- display sales reps
150: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop

Line 147: htp.tableRowClose;

143: htp.p('');
144: htp.p('');
145: htp.p('Rank: ' ||rec_terr.rank);
146: htp.p('');
147: htp.tableRowClose;
148: l_rec_count := l_rec_count + 1;
149: -- display sales reps
150: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
151: htp.tableRowOpen;

Line 151: htp.tableRowOpen;

147: htp.tableRowClose;
148: l_rec_count := l_rec_count + 1;
149: -- display sales reps
150: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
151: htp.tableRowOpen;
152: htp.p('');
153: htp.p(rec_get_salesrep.resource_name);
154: htp.p('');
155: --htp.p('');

Line 152: htp.p('');

148: l_rec_count := l_rec_count + 1;
149: -- display sales reps
150: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
151: htp.tableRowOpen;
152: htp.p('');
153: htp.p(rec_get_salesrep.resource_name);
154: htp.p('');
155: --htp.p('');
156: --htp.p(rec_get_salesrep.resource_id);

Line 153: htp.p(rec_get_salesrep.resource_name);

149: -- display sales reps
150: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
151: htp.tableRowOpen;
152: htp.p('');
153: htp.p(rec_get_salesrep.resource_name);
154: htp.p('');
155: --htp.p('');
156: --htp.p(rec_get_salesrep.resource_id);
157: --htp.p('');

Line 154: htp.p('');

150: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
151: htp.tableRowOpen;
152: htp.p('');
153: htp.p(rec_get_salesrep.resource_name);
154: htp.p('');
155: --htp.p('');
156: --htp.p(rec_get_salesrep.resource_id);
157: --htp.p('');
158: --htp.tableRowClose;

Line 155: --htp.p('');

151: htp.tableRowOpen;
152: htp.p('');
153: htp.p(rec_get_salesrep.resource_name);
154: htp.p('');
155: --htp.p('');
156: --htp.p(rec_get_salesrep.resource_id);
157: --htp.p('');
158: --htp.tableRowClose;
159: END LOOP;

Line 156: --htp.p(rec_get_salesrep.resource_id);

152: htp.p('');
153: htp.p(rec_get_salesrep.resource_name);
154: htp.p('');
155: --htp.p('');
156: --htp.p(rec_get_salesrep.resource_id);
157: --htp.p('');
158: --htp.tableRowClose;
159: END LOOP;
160: -- display qualifiers

Line 157: --htp.p('');

153: htp.p(rec_get_salesrep.resource_name);
154: htp.p('');
155: --htp.p('');
156: --htp.p(rec_get_salesrep.resource_id);
157: --htp.p('');
158: --htp.tableRowClose;
159: END LOOP;
160: -- display qualifiers
161: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop

Line 158: --htp.tableRowClose;

154: htp.p('');
155: --htp.p('');
156: --htp.p(rec_get_salesrep.resource_id);
157: --htp.p('');
158: --htp.tableRowClose;
159: END LOOP;
160: -- display qualifiers
161: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
162: htp.tableRowOpen;

Line 162: htp.tableRowOpen;

158: --htp.tableRowClose;
159: END LOOP;
160: -- display qualifiers
161: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
162: htp.tableRowOpen;
163: htp.p('');
164: htp.p('');
165: htp.p(rec_get_terr_qual.qualifier_name);
166: htp.p('');

Line 163: htp.p('');

159: END LOOP;
160: -- display qualifiers
161: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
162: htp.tableRowOpen;
163: htp.p('');
164: htp.p('');
165: htp.p(rec_get_terr_qual.qualifier_name);
166: htp.p('');
167: if rec_get_terr_qual.qual_usg_id = -1012 then

Line 164: htp.p('');

160: -- display qualifiers
161: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
162: htp.tableRowOpen;
163: htp.p('');
164: htp.p('');
165: htp.p(rec_get_terr_qual.qualifier_name);
166: htp.p('');
167: if rec_get_terr_qual.qual_usg_id = -1012 then
168: htp.p('');

Line 165: htp.p(rec_get_terr_qual.qualifier_name);

161: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
162: htp.tableRowOpen;
163: htp.p('');
164: htp.p('');
165: htp.p(rec_get_terr_qual.qualifier_name);
166: htp.p('');
167: if rec_get_terr_qual.qual_usg_id = -1012 then
168: htp.p('');
169: htp.p('');

Line 166: htp.p('');

162: htp.tableRowOpen;
163: htp.p('');
164: htp.p('');
165: htp.p(rec_get_terr_qual.qualifier_name);
166: htp.p('');
167: if rec_get_terr_qual.qual_usg_id = -1012 then
168: htp.p('');
169: htp.p('');
170: htp.p('');

Line 168: htp.p('');

164: htp.p('');
165: htp.p(rec_get_terr_qual.qualifier_name);
166: htp.p('');
167: if rec_get_terr_qual.qual_usg_id = -1012 then
168: htp.p('');
169: htp.p('');
170: htp.p('');
171: htp.p('');
172: htp.p('Customer Name Range Group');

Line 169: htp.p('');

165: htp.p(rec_get_terr_qual.qualifier_name);
166: htp.p('');
167: if rec_get_terr_qual.qual_usg_id = -1012 then
168: htp.p('');
169: htp.p('');
170: htp.p('');
171: htp.p('');
172: htp.p('Customer Name Range Group');
173: htp.p('');

Line 170: htp.p('');

166: htp.p('');
167: if rec_get_terr_qual.qual_usg_id = -1012 then
168: htp.p('');
169: htp.p('');
170: htp.p('');
171: htp.p('');
172: htp.p('Customer Name Range Group');
173: htp.p('');
174: end if;

Line 171: htp.p('');

167: if rec_get_terr_qual.qual_usg_id = -1012 then
168: htp.p('');
169: htp.p('');
170: htp.p('');
171: htp.p('');
172: htp.p('Customer Name Range Group');
173: htp.p('');
174: end if;
175: htp.tableRowClose;

Line 172: htp.p('Customer Name Range Group');

168: htp.p('');
169: htp.p('');
170: htp.p('');
171: htp.p('');
172: htp.p('Customer Name Range Group');
173: htp.p('');
174: end if;
175: htp.tableRowClose;
176: -- display qualifier values

Line 173: htp.p('');

169: htp.p('');
170: htp.p('');
171: htp.p('');
172: htp.p('Customer Name Range Group');
173: htp.p('');
174: end if;
175: htp.tableRowClose;
176: -- display qualifier values
177: FOR rec_get_terr_values in c_get_terr_values(rec_get_terr_qual.terr_qual_id) loop

Line 175: htp.tableRowClose;

171: htp.p('');
172: htp.p('Customer Name Range Group');
173: htp.p('');
174: end if;
175: htp.tableRowClose;
176: -- display qualifier values
177: FOR rec_get_terr_values in c_get_terr_values(rec_get_terr_qual.terr_qual_id) loop
178: -- output qualifier values according to display_type and convert_to_id_flag
179: l_display_type := rec_get_terr_values.display_type;

Line 184: htp.tableRowOpen;

180: l_convert_to_id_flag := rec_get_terr_values.convert_to_id_flag;
181:
182: If (l_display_type = 'CHAR') then
183: If (l_convert_to_id_flag = 'Y') then
184: htp.tableRowOpen;
185: htp.p('');
186: htp.p(rec_get_terr_values.comparison_operator);
187: htp.p('');
188: htp.p('');

Line 185: htp.p('');

181:
182: If (l_display_type = 'CHAR') then
183: If (l_convert_to_id_flag = 'Y') then
184: htp.tableRowOpen;
185: htp.p('');
186: htp.p(rec_get_terr_values.comparison_operator);
187: htp.p('');
188: htp.p('');
189: htp.p(rec_get_terr_values.low_value_char_desc);

Line 186: htp.p(rec_get_terr_values.comparison_operator);

182: If (l_display_type = 'CHAR') then
183: If (l_convert_to_id_flag = 'Y') then
184: htp.tableRowOpen;
185: htp.p('');
186: htp.p(rec_get_terr_values.comparison_operator);
187: htp.p('');
188: htp.p('');
189: htp.p(rec_get_terr_values.low_value_char_desc);
190: htp.p('');

Line 187: htp.p('');

183: If (l_convert_to_id_flag = 'Y') then
184: htp.tableRowOpen;
185: htp.p('');
186: htp.p(rec_get_terr_values.comparison_operator);
187: htp.p('');
188: htp.p('');
189: htp.p(rec_get_terr_values.low_value_char_desc);
190: htp.p('');
191: htp.p('');

Line 188: htp.p('');

184: htp.tableRowOpen;
185: htp.p('');
186: htp.p(rec_get_terr_values.comparison_operator);
187: htp.p('');
188: htp.p('');
189: htp.p(rec_get_terr_values.low_value_char_desc);
190: htp.p('');
191: htp.p('');
192: htp.p(rec_get_terr_values.low_value_char_id);

Line 189: htp.p(rec_get_terr_values.low_value_char_desc);

185: htp.p('');
186: htp.p(rec_get_terr_values.comparison_operator);
187: htp.p('');
188: htp.p('');
189: htp.p(rec_get_terr_values.low_value_char_desc);
190: htp.p('');
191: htp.p('');
192: htp.p(rec_get_terr_values.low_value_char_id);
193: htp.p('');

Line 190: htp.p('');

186: htp.p(rec_get_terr_values.comparison_operator);
187: htp.p('');
188: htp.p('');
189: htp.p(rec_get_terr_values.low_value_char_desc);
190: htp.p('');
191: htp.p('');
192: htp.p(rec_get_terr_values.low_value_char_id);
193: htp.p('');
194: htp.p('');

Line 191: htp.p('');

187: htp.p('');
188: htp.p('');
189: htp.p(rec_get_terr_values.low_value_char_desc);
190: htp.p('');
191: htp.p('');
192: htp.p(rec_get_terr_values.low_value_char_id);
193: htp.p('');
194: htp.p('');
195: htp.p('');

Line 192: htp.p(rec_get_terr_values.low_value_char_id);

188: htp.p('');
189: htp.p(rec_get_terr_values.low_value_char_desc);
190: htp.p('');
191: htp.p('');
192: htp.p(rec_get_terr_values.low_value_char_id);
193: htp.p('');
194: htp.p('');
195: htp.p('');
196: htp.p('');

Line 193: htp.p('');

189: htp.p(rec_get_terr_values.low_value_char_desc);
190: htp.p('');
191: htp.p('');
192: htp.p(rec_get_terr_values.low_value_char_id);
193: htp.p('');
194: htp.p('');
195: htp.p('');
196: htp.p('');
197: htp.tableRowClose;

Line 194: htp.p('');

190: htp.p('');
191: htp.p('');
192: htp.p(rec_get_terr_values.low_value_char_id);
193: htp.p('');
194: htp.p('');
195: htp.p('');
196: htp.p('');
197: htp.tableRowClose;
198: else -- (l_convert_to_id_flag = 'N')

Line 195: htp.p('');

191: htp.p('');
192: htp.p(rec_get_terr_values.low_value_char_id);
193: htp.p('');
194: htp.p('');
195: htp.p('');
196: htp.p('');
197: htp.tableRowClose;
198: else -- (l_convert_to_id_flag = 'N')
199: htp.tableRowOpen;

Line 196: htp.p('');

192: htp.p(rec_get_terr_values.low_value_char_id);
193: htp.p('');
194: htp.p('');
195: htp.p('');
196: htp.p('');
197: htp.tableRowClose;
198: else -- (l_convert_to_id_flag = 'N')
199: htp.tableRowOpen;
200: htp.p('');

Line 197: htp.tableRowClose;

193: htp.p('');
194: htp.p('');
195: htp.p('');
196: htp.p('');
197: htp.tableRowClose;
198: else -- (l_convert_to_id_flag = 'N')
199: htp.tableRowOpen;
200: htp.p('');
201: htp.p(rec_get_terr_values.comparison_operator);

Line 199: htp.tableRowOpen;

195: htp.p('');
196: htp.p('');
197: htp.tableRowClose;
198: else -- (l_convert_to_id_flag = 'N')
199: htp.tableRowOpen;
200: htp.p('');
201: htp.p(rec_get_terr_values.comparison_operator);
202: htp.p('');
203: htp.p('');

Line 200: htp.p('');

196: htp.p('');
197: htp.tableRowClose;
198: else -- (l_convert_to_id_flag = 'N')
199: htp.tableRowOpen;
200: htp.p('');
201: htp.p(rec_get_terr_values.comparison_operator);
202: htp.p('');
203: htp.p('');
204: htp.p(rec_get_terr_values.low_value_char_desc);

Line 201: htp.p(rec_get_terr_values.comparison_operator);

197: htp.tableRowClose;
198: else -- (l_convert_to_id_flag = 'N')
199: htp.tableRowOpen;
200: htp.p('');
201: htp.p(rec_get_terr_values.comparison_operator);
202: htp.p('');
203: htp.p('');
204: htp.p(rec_get_terr_values.low_value_char_desc);
205: htp.p('');

Line 202: htp.p('');

198: else -- (l_convert_to_id_flag = 'N')
199: htp.tableRowOpen;
200: htp.p('');
201: htp.p(rec_get_terr_values.comparison_operator);
202: htp.p('');
203: htp.p('');
204: htp.p(rec_get_terr_values.low_value_char_desc);
205: htp.p('');
206: htp.p('');

Line 203: htp.p('');

199: htp.tableRowOpen;
200: htp.p('');
201: htp.p(rec_get_terr_values.comparison_operator);
202: htp.p('');
203: htp.p('');
204: htp.p(rec_get_terr_values.low_value_char_desc);
205: htp.p('');
206: htp.p('');
207: htp.p(rec_get_terr_values.high_value_char_desc);

Line 204: htp.p(rec_get_terr_values.low_value_char_desc);

200: htp.p('');
201: htp.p(rec_get_terr_values.comparison_operator);
202: htp.p('');
203: htp.p('');
204: htp.p(rec_get_terr_values.low_value_char_desc);
205: htp.p('');
206: htp.p('');
207: htp.p(rec_get_terr_values.high_value_char_desc);
208: htp.p('');

Line 205: htp.p('');

201: htp.p(rec_get_terr_values.comparison_operator);
202: htp.p('');
203: htp.p('');
204: htp.p(rec_get_terr_values.low_value_char_desc);
205: htp.p('');
206: htp.p('');
207: htp.p(rec_get_terr_values.high_value_char_desc);
208: htp.p('');
209: htp.p('');

Line 206: htp.p('');

202: htp.p('');
203: htp.p('');
204: htp.p(rec_get_terr_values.low_value_char_desc);
205: htp.p('');
206: htp.p('');
207: htp.p(rec_get_terr_values.high_value_char_desc);
208: htp.p('');
209: htp.p('');
210: htp.p(rec_get_terr_values.CNR_GROUP_NAME);

Line 207: htp.p(rec_get_terr_values.high_value_char_desc);

203: htp.p('');
204: htp.p(rec_get_terr_values.low_value_char_desc);
205: htp.p('');
206: htp.p('');
207: htp.p(rec_get_terr_values.high_value_char_desc);
208: htp.p('');
209: htp.p('');
210: htp.p(rec_get_terr_values.CNR_GROUP_NAME);
211: htp.p('');

Line 208: htp.p('');

204: htp.p(rec_get_terr_values.low_value_char_desc);
205: htp.p('');
206: htp.p('');
207: htp.p(rec_get_terr_values.high_value_char_desc);
208: htp.p('');
209: htp.p('');
210: htp.p(rec_get_terr_values.CNR_GROUP_NAME);
211: htp.p('');
212: htp.tableRowClose;

Line 209: htp.p('');

205: htp.p('');
206: htp.p('');
207: htp.p(rec_get_terr_values.high_value_char_desc);
208: htp.p('');
209: htp.p('');
210: htp.p(rec_get_terr_values.CNR_GROUP_NAME);
211: htp.p('');
212: htp.tableRowClose;
213: End if;

Line 210: htp.p(rec_get_terr_values.CNR_GROUP_NAME);

206: htp.p('');
207: htp.p(rec_get_terr_values.high_value_char_desc);
208: htp.p('');
209: htp.p('');
210: htp.p(rec_get_terr_values.CNR_GROUP_NAME);
211: htp.p('');
212: htp.tableRowClose;
213: End if;
214: elsif (l_display_type = 'INTEREST_TYPE') then

Line 211: htp.p('');

207: htp.p(rec_get_terr_values.high_value_char_desc);
208: htp.p('');
209: htp.p('');
210: htp.p(rec_get_terr_values.CNR_GROUP_NAME);
211: htp.p('');
212: htp.tableRowClose;
213: End if;
214: elsif (l_display_type = 'INTEREST_TYPE') then
215: htp.tableRowOpen;

Line 212: htp.tableRowClose;

208: htp.p('');
209: htp.p('');
210: htp.p(rec_get_terr_values.CNR_GROUP_NAME);
211: htp.p('');
212: htp.tableRowClose;
213: End if;
214: elsif (l_display_type = 'INTEREST_TYPE') then
215: htp.tableRowOpen;
216: htp.p('');

Line 215: htp.tableRowOpen;

211: htp.p('');
212: htp.tableRowClose;
213: End if;
214: elsif (l_display_type = 'INTEREST_TYPE') then
215: htp.tableRowOpen;
216: htp.p('');
217: htp.p(rec_get_terr_values.comparison_operator);
218: htp.p('');
219: htp.p('');

Line 216: htp.p('');

212: htp.tableRowClose;
213: End if;
214: elsif (l_display_type = 'INTEREST_TYPE') then
215: htp.tableRowOpen;
216: htp.p('');
217: htp.p(rec_get_terr_values.comparison_operator);
218: htp.p('');
219: htp.p('');
220: htp.p(rec_get_terr_values.interest_type);

Line 217: htp.p(rec_get_terr_values.comparison_operator);

213: End if;
214: elsif (l_display_type = 'INTEREST_TYPE') then
215: htp.tableRowOpen;
216: htp.p('');
217: htp.p(rec_get_terr_values.comparison_operator);
218: htp.p('');
219: htp.p('');
220: htp.p(rec_get_terr_values.interest_type);
221: htp.p('');

Line 218: htp.p('');

214: elsif (l_display_type = 'INTEREST_TYPE') then
215: htp.tableRowOpen;
216: htp.p('');
217: htp.p(rec_get_terr_values.comparison_operator);
218: htp.p('');
219: htp.p('');
220: htp.p(rec_get_terr_values.interest_type);
221: htp.p('');
222: htp.p('');

Line 219: htp.p('');

215: htp.tableRowOpen;
216: htp.p('');
217: htp.p(rec_get_terr_values.comparison_operator);
218: htp.p('');
219: htp.p('');
220: htp.p(rec_get_terr_values.interest_type);
221: htp.p('');
222: htp.p('');
223: htp.p(rec_get_terr_values.primary_interest_code);

Line 220: htp.p(rec_get_terr_values.interest_type);

216: htp.p('');
217: htp.p(rec_get_terr_values.comparison_operator);
218: htp.p('');
219: htp.p('');
220: htp.p(rec_get_terr_values.interest_type);
221: htp.p('');
222: htp.p('');
223: htp.p(rec_get_terr_values.primary_interest_code);
224: htp.p('');

Line 221: htp.p('');

217: htp.p(rec_get_terr_values.comparison_operator);
218: htp.p('');
219: htp.p('');
220: htp.p(rec_get_terr_values.interest_type);
221: htp.p('');
222: htp.p('');
223: htp.p(rec_get_terr_values.primary_interest_code);
224: htp.p('');
225: htp.p('');

Line 222: htp.p('');

218: htp.p('');
219: htp.p('');
220: htp.p(rec_get_terr_values.interest_type);
221: htp.p('');
222: htp.p('');
223: htp.p(rec_get_terr_values.primary_interest_code);
224: htp.p('');
225: htp.p('');
226: htp.p(rec_get_terr_values.secondary_interest_code);

Line 223: htp.p(rec_get_terr_values.primary_interest_code);

219: htp.p('');
220: htp.p(rec_get_terr_values.interest_type);
221: htp.p('');
222: htp.p('');
223: htp.p(rec_get_terr_values.primary_interest_code);
224: htp.p('');
225: htp.p('');
226: htp.p(rec_get_terr_values.secondary_interest_code);
227: htp.p('');

Line 224: htp.p('');

220: htp.p(rec_get_terr_values.interest_type);
221: htp.p('');
222: htp.p('');
223: htp.p(rec_get_terr_values.primary_interest_code);
224: htp.p('');
225: htp.p('');
226: htp.p(rec_get_terr_values.secondary_interest_code);
227: htp.p('');
228: htp.tableRowClose;

Line 225: htp.p('');

221: htp.p('');
222: htp.p('');
223: htp.p(rec_get_terr_values.primary_interest_code);
224: htp.p('');
225: htp.p('');
226: htp.p(rec_get_terr_values.secondary_interest_code);
227: htp.p('');
228: htp.tableRowClose;
229: elsif (l_display_type = 'NUMBER') then

Line 226: htp.p(rec_get_terr_values.secondary_interest_code);

222: htp.p('');
223: htp.p(rec_get_terr_values.primary_interest_code);
224: htp.p('');
225: htp.p('');
226: htp.p(rec_get_terr_values.secondary_interest_code);
227: htp.p('');
228: htp.tableRowClose;
229: elsif (l_display_type = 'NUMBER') then
230: htp.tableRowOpen;

Line 227: htp.p('');

223: htp.p(rec_get_terr_values.primary_interest_code);
224: htp.p('');
225: htp.p('');
226: htp.p(rec_get_terr_values.secondary_interest_code);
227: htp.p('');
228: htp.tableRowClose;
229: elsif (l_display_type = 'NUMBER') then
230: htp.tableRowOpen;
231: htp.p('');

Line 228: htp.tableRowClose;

224: htp.p('');
225: htp.p('');
226: htp.p(rec_get_terr_values.secondary_interest_code);
227: htp.p('');
228: htp.tableRowClose;
229: elsif (l_display_type = 'NUMBER') then
230: htp.tableRowOpen;
231: htp.p('');
232: htp.p(rec_get_terr_values.comparison_operator);

Line 230: htp.tableRowOpen;

226: htp.p(rec_get_terr_values.secondary_interest_code);
227: htp.p('');
228: htp.tableRowClose;
229: elsif (l_display_type = 'NUMBER') then
230: htp.tableRowOpen;
231: htp.p('');
232: htp.p(rec_get_terr_values.comparison_operator);
233: htp.p('');
234: htp.p('');

Line 231: htp.p('');

227: htp.p('');
228: htp.tableRowClose;
229: elsif (l_display_type = 'NUMBER') then
230: htp.tableRowOpen;
231: htp.p('');
232: htp.p(rec_get_terr_values.comparison_operator);
233: htp.p('');
234: htp.p('');
235: htp.p(rec_get_terr_values.low_value_number);

Line 232: htp.p(rec_get_terr_values.comparison_operator);

228: htp.tableRowClose;
229: elsif (l_display_type = 'NUMBER') then
230: htp.tableRowOpen;
231: htp.p('');
232: htp.p(rec_get_terr_values.comparison_operator);
233: htp.p('');
234: htp.p('');
235: htp.p(rec_get_terr_values.low_value_number);
236: htp.p('');

Line 233: htp.p('');

229: elsif (l_display_type = 'NUMBER') then
230: htp.tableRowOpen;
231: htp.p('');
232: htp.p(rec_get_terr_values.comparison_operator);
233: htp.p('');
234: htp.p('');
235: htp.p(rec_get_terr_values.low_value_number);
236: htp.p('');
237: htp.p('');

Line 234: htp.p('');

230: htp.tableRowOpen;
231: htp.p('');
232: htp.p(rec_get_terr_values.comparison_operator);
233: htp.p('');
234: htp.p('');
235: htp.p(rec_get_terr_values.low_value_number);
236: htp.p('');
237: htp.p('');
238: htp.p(rec_get_terr_values.high_value_number);

Line 235: htp.p(rec_get_terr_values.low_value_number);

231: htp.p('');
232: htp.p(rec_get_terr_values.comparison_operator);
233: htp.p('');
234: htp.p('');
235: htp.p(rec_get_terr_values.low_value_number);
236: htp.p('');
237: htp.p('');
238: htp.p(rec_get_terr_values.high_value_number);
239: htp.p('');

Line 236: htp.p('');

232: htp.p(rec_get_terr_values.comparison_operator);
233: htp.p('');
234: htp.p('');
235: htp.p(rec_get_terr_values.low_value_number);
236: htp.p('');
237: htp.p('');
238: htp.p(rec_get_terr_values.high_value_number);
239: htp.p('');
240: htp.p('');

Line 237: htp.p('');

233: htp.p('');
234: htp.p('');
235: htp.p(rec_get_terr_values.low_value_number);
236: htp.p('');
237: htp.p('');
238: htp.p(rec_get_terr_values.high_value_number);
239: htp.p('');
240: htp.p('');
241: htp.p('');

Line 238: htp.p(rec_get_terr_values.high_value_number);

234: htp.p('');
235: htp.p(rec_get_terr_values.low_value_number);
236: htp.p('');
237: htp.p('');
238: htp.p(rec_get_terr_values.high_value_number);
239: htp.p('');
240: htp.p('');
241: htp.p('');
242: htp.p('');

Line 239: htp.p('');

235: htp.p(rec_get_terr_values.low_value_number);
236: htp.p('');
237: htp.p('');
238: htp.p(rec_get_terr_values.high_value_number);
239: htp.p('');
240: htp.p('');
241: htp.p('');
242: htp.p('');
243: htp.tableRowClose;

Line 240: htp.p('');

236: htp.p('');
237: htp.p('');
238: htp.p(rec_get_terr_values.high_value_number);
239: htp.p('');
240: htp.p('');
241: htp.p('');
242: htp.p('');
243: htp.tableRowClose;
244: elsif (l_display_type = 'CURRENCY') then

Line 241: htp.p('');

237: htp.p('');
238: htp.p(rec_get_terr_values.high_value_number);
239: htp.p('');
240: htp.p('');
241: htp.p('');
242: htp.p('');
243: htp.tableRowClose;
244: elsif (l_display_type = 'CURRENCY') then
245: htp.tableRowOpen;

Line 242: htp.p('');

238: htp.p(rec_get_terr_values.high_value_number);
239: htp.p('');
240: htp.p('');
241: htp.p('');
242: htp.p('');
243: htp.tableRowClose;
244: elsif (l_display_type = 'CURRENCY') then
245: htp.tableRowOpen;
246: htp.p('');

Line 243: htp.tableRowClose;

239: htp.p('');
240: htp.p('');
241: htp.p('');
242: htp.p('');
243: htp.tableRowClose;
244: elsif (l_display_type = 'CURRENCY') then
245: htp.tableRowOpen;
246: htp.p('');
247: htp.p(rec_get_terr_values.comparison_operator);

Line 245: htp.tableRowOpen;

241: htp.p('');
242: htp.p('');
243: htp.tableRowClose;
244: elsif (l_display_type = 'CURRENCY') then
245: htp.tableRowOpen;
246: htp.p('');
247: htp.p(rec_get_terr_values.comparison_operator);
248: htp.p('');
249: htp.p('');

Line 246: htp.p('');

242: htp.p('');
243: htp.tableRowClose;
244: elsif (l_display_type = 'CURRENCY') then
245: htp.tableRowOpen;
246: htp.p('');
247: htp.p(rec_get_terr_values.comparison_operator);
248: htp.p('');
249: htp.p('');
250: htp.p(rec_get_terr_values.low_value_number);

Line 247: htp.p(rec_get_terr_values.comparison_operator);

243: htp.tableRowClose;
244: elsif (l_display_type = 'CURRENCY') then
245: htp.tableRowOpen;
246: htp.p('');
247: htp.p(rec_get_terr_values.comparison_operator);
248: htp.p('');
249: htp.p('');
250: htp.p(rec_get_terr_values.low_value_number);
251: htp.p('');

Line 248: htp.p('');

244: elsif (l_display_type = 'CURRENCY') then
245: htp.tableRowOpen;
246: htp.p('');
247: htp.p(rec_get_terr_values.comparison_operator);
248: htp.p('');
249: htp.p('');
250: htp.p(rec_get_terr_values.low_value_number);
251: htp.p('');
252: htp.p('');

Line 249: htp.p('');

245: htp.tableRowOpen;
246: htp.p('');
247: htp.p(rec_get_terr_values.comparison_operator);
248: htp.p('');
249: htp.p('');
250: htp.p(rec_get_terr_values.low_value_number);
251: htp.p('');
252: htp.p('');
253: htp.p(rec_get_terr_values.high_value_number);

Line 250: htp.p(rec_get_terr_values.low_value_number);

246: htp.p('');
247: htp.p(rec_get_terr_values.comparison_operator);
248: htp.p('');
249: htp.p('');
250: htp.p(rec_get_terr_values.low_value_number);
251: htp.p('');
252: htp.p('');
253: htp.p(rec_get_terr_values.high_value_number);
254: htp.p('');

Line 251: htp.p('');

247: htp.p(rec_get_terr_values.comparison_operator);
248: htp.p('');
249: htp.p('');
250: htp.p(rec_get_terr_values.low_value_number);
251: htp.p('');
252: htp.p('');
253: htp.p(rec_get_terr_values.high_value_number);
254: htp.p('');
255: htp.p('');

Line 252: htp.p('');

248: htp.p('');
249: htp.p('');
250: htp.p(rec_get_terr_values.low_value_number);
251: htp.p('');
252: htp.p('');
253: htp.p(rec_get_terr_values.high_value_number);
254: htp.p('');
255: htp.p('');
256: htp.p(rec_get_terr_values.currency_code);

Line 253: htp.p(rec_get_terr_values.high_value_number);

249: htp.p('');
250: htp.p(rec_get_terr_values.low_value_number);
251: htp.p('');
252: htp.p('');
253: htp.p(rec_get_terr_values.high_value_number);
254: htp.p('');
255: htp.p('');
256: htp.p(rec_get_terr_values.currency_code);
257: htp.p('');

Line 254: htp.p('');

250: htp.p(rec_get_terr_values.low_value_number);
251: htp.p('');
252: htp.p('');
253: htp.p(rec_get_terr_values.high_value_number);
254: htp.p('');
255: htp.p('');
256: htp.p(rec_get_terr_values.currency_code);
257: htp.p('');
258: htp.tableRowClose;

Line 255: htp.p('');

251: htp.p('');
252: htp.p('');
253: htp.p(rec_get_terr_values.high_value_number);
254: htp.p('');
255: htp.p('');
256: htp.p(rec_get_terr_values.currency_code);
257: htp.p('');
258: htp.tableRowClose;
259: -- bug#3175772

Line 256: htp.p(rec_get_terr_values.currency_code);

252: htp.p('');
253: htp.p(rec_get_terr_values.high_value_number);
254: htp.p('');
255: htp.p('');
256: htp.p(rec_get_terr_values.currency_code);
257: htp.p('');
258: htp.tableRowClose;
259: -- bug#3175772
260: elsif (l_display_type = 'DEP_2FIELDS_CHAR_2IDS') then

Line 257: htp.p('');

253: htp.p(rec_get_terr_values.high_value_number);
254: htp.p('');
255: htp.p('');
256: htp.p(rec_get_terr_values.currency_code);
257: htp.p('');
258: htp.tableRowClose;
259: -- bug#3175772
260: elsif (l_display_type = 'DEP_2FIELDS_CHAR_2IDS') then
261: If (l_convert_to_id_flag = 'Y') then

Line 258: htp.tableRowClose;

254: htp.p('');
255: htp.p('');
256: htp.p(rec_get_terr_values.currency_code);
257: htp.p('');
258: htp.tableRowClose;
259: -- bug#3175772
260: elsif (l_display_type = 'DEP_2FIELDS_CHAR_2IDS') then
261: If (l_convert_to_id_flag = 'Y') then
262: htp.tableRowOpen;

Line 262: htp.tableRowOpen;

258: htp.tableRowClose;
259: -- bug#3175772
260: elsif (l_display_type = 'DEP_2FIELDS_CHAR_2IDS') then
261: If (l_convert_to_id_flag = 'Y') then
262: htp.tableRowOpen;
263: htp.p('');
264: htp.p(rec_get_terr_values.comparison_operator);
265: htp.p('');
266: htp.p('');

Line 263: htp.p('');

259: -- bug#3175772
260: elsif (l_display_type = 'DEP_2FIELDS_CHAR_2IDS') then
261: If (l_convert_to_id_flag = 'Y') then
262: htp.tableRowOpen;
263: htp.p('');
264: htp.p(rec_get_terr_values.comparison_operator);
265: htp.p('');
266: htp.p('');
267: htp.p(rec_get_terr_values.value1_desc );

Line 264: htp.p(rec_get_terr_values.comparison_operator);

260: elsif (l_display_type = 'DEP_2FIELDS_CHAR_2IDS') then
261: If (l_convert_to_id_flag = 'Y') then
262: htp.tableRowOpen;
263: htp.p('');
264: htp.p(rec_get_terr_values.comparison_operator);
265: htp.p('');
266: htp.p('');
267: htp.p(rec_get_terr_values.value1_desc );
268: htp.p('');

Line 265: htp.p('');

261: If (l_convert_to_id_flag = 'Y') then
262: htp.tableRowOpen;
263: htp.p('');
264: htp.p(rec_get_terr_values.comparison_operator);
265: htp.p('');
266: htp.p('');
267: htp.p(rec_get_terr_values.value1_desc );
268: htp.p('');
269: htp.p('');

Line 266: htp.p('');

262: htp.tableRowOpen;
263: htp.p('');
264: htp.p(rec_get_terr_values.comparison_operator);
265: htp.p('');
266: htp.p('');
267: htp.p(rec_get_terr_values.value1_desc );
268: htp.p('');
269: htp.p('');
270: htp.p(rec_get_terr_values.value1_id);

Line 267: htp.p(rec_get_terr_values.value1_desc );

263: htp.p('');
264: htp.p(rec_get_terr_values.comparison_operator);
265: htp.p('');
266: htp.p('');
267: htp.p(rec_get_terr_values.value1_desc );
268: htp.p('');
269: htp.p('');
270: htp.p(rec_get_terr_values.value1_id);
271: htp.p('');

Line 268: htp.p('');

264: htp.p(rec_get_terr_values.comparison_operator);
265: htp.p('');
266: htp.p('');
267: htp.p(rec_get_terr_values.value1_desc );
268: htp.p('');
269: htp.p('');
270: htp.p(rec_get_terr_values.value1_id);
271: htp.p('');
272: htp.p('');

Line 269: htp.p('');

265: htp.p('');
266: htp.p('');
267: htp.p(rec_get_terr_values.value1_desc );
268: htp.p('');
269: htp.p('');
270: htp.p(rec_get_terr_values.value1_id);
271: htp.p('');
272: htp.p('');
273: htp.p('');

Line 270: htp.p(rec_get_terr_values.value1_id);

266: htp.p('');
267: htp.p(rec_get_terr_values.value1_desc );
268: htp.p('');
269: htp.p('');
270: htp.p(rec_get_terr_values.value1_id);
271: htp.p('');
272: htp.p('');
273: htp.p('');
274: htp.p('');

Line 271: htp.p('');

267: htp.p(rec_get_terr_values.value1_desc );
268: htp.p('');
269: htp.p('');
270: htp.p(rec_get_terr_values.value1_id);
271: htp.p('');
272: htp.p('');
273: htp.p('');
274: htp.p('');
275: htp.tableRowClose;

Line 272: htp.p('');

268: htp.p('');
269: htp.p('');
270: htp.p(rec_get_terr_values.value1_id);
271: htp.p('');
272: htp.p('');
273: htp.p('');
274: htp.p('');
275: htp.tableRowClose;
276: if rec_get_terr_values.value2_id is not null

Line 273: htp.p('');

269: htp.p('');
270: htp.p(rec_get_terr_values.value1_id);
271: htp.p('');
272: htp.p('');
273: htp.p('');
274: htp.p('');
275: htp.tableRowClose;
276: if rec_get_terr_values.value2_id is not null
277: then

Line 274: htp.p('');

270: htp.p(rec_get_terr_values.value1_id);
271: htp.p('');
272: htp.p('');
273: htp.p('');
274: htp.p('');
275: htp.tableRowClose;
276: if rec_get_terr_values.value2_id is not null
277: then
278: htp.tableRowOpen;

Line 275: htp.tableRowClose;

271: htp.p('');
272: htp.p('');
273: htp.p('');
274: htp.p('');
275: htp.tableRowClose;
276: if rec_get_terr_values.value2_id is not null
277: then
278: htp.tableRowOpen;
279: htp.p('');

Line 278: htp.tableRowOpen;

274: htp.p('');
275: htp.tableRowClose;
276: if rec_get_terr_values.value2_id is not null
277: then
278: htp.tableRowOpen;
279: htp.p('');
280: htp.p(rec_get_terr_values.comparison_operator);
281: htp.p('');
282: htp.p('');

Line 279: htp.p('');

275: htp.tableRowClose;
276: if rec_get_terr_values.value2_id is not null
277: then
278: htp.tableRowOpen;
279: htp.p('');
280: htp.p(rec_get_terr_values.comparison_operator);
281: htp.p('');
282: htp.p('');
283: htp.p(rec_get_terr_values.value2_desc );

Line 280: htp.p(rec_get_terr_values.comparison_operator);

276: if rec_get_terr_values.value2_id is not null
277: then
278: htp.tableRowOpen;
279: htp.p('');
280: htp.p(rec_get_terr_values.comparison_operator);
281: htp.p('');
282: htp.p('');
283: htp.p(rec_get_terr_values.value2_desc );
284: htp.p('');

Line 281: htp.p('');

277: then
278: htp.tableRowOpen;
279: htp.p('');
280: htp.p(rec_get_terr_values.comparison_operator);
281: htp.p('');
282: htp.p('');
283: htp.p(rec_get_terr_values.value2_desc );
284: htp.p('');
285: htp.p('');

Line 282: htp.p('');

278: htp.tableRowOpen;
279: htp.p('');
280: htp.p(rec_get_terr_values.comparison_operator);
281: htp.p('');
282: htp.p('');
283: htp.p(rec_get_terr_values.value2_desc );
284: htp.p('');
285: htp.p('');
286: htp.p(rec_get_terr_values.value2_id);

Line 283: htp.p(rec_get_terr_values.value2_desc );

279: htp.p('');
280: htp.p(rec_get_terr_values.comparison_operator);
281: htp.p('');
282: htp.p('');
283: htp.p(rec_get_terr_values.value2_desc );
284: htp.p('');
285: htp.p('');
286: htp.p(rec_get_terr_values.value2_id);
287: htp.p('');

Line 284: htp.p('');

280: htp.p(rec_get_terr_values.comparison_operator);
281: htp.p('');
282: htp.p('');
283: htp.p(rec_get_terr_values.value2_desc );
284: htp.p('');
285: htp.p('');
286: htp.p(rec_get_terr_values.value2_id);
287: htp.p('');
288: htp.p('');

Line 285: htp.p('');

281: htp.p('');
282: htp.p('');
283: htp.p(rec_get_terr_values.value2_desc );
284: htp.p('');
285: htp.p('');
286: htp.p(rec_get_terr_values.value2_id);
287: htp.p('');
288: htp.p('');
289: htp.p('');

Line 286: htp.p(rec_get_terr_values.value2_id);

282: htp.p('');
283: htp.p(rec_get_terr_values.value2_desc );
284: htp.p('');
285: htp.p('');
286: htp.p(rec_get_terr_values.value2_id);
287: htp.p('');
288: htp.p('');
289: htp.p('');
290: htp.p('');

Line 287: htp.p('');

283: htp.p(rec_get_terr_values.value2_desc );
284: htp.p('');
285: htp.p('');
286: htp.p(rec_get_terr_values.value2_id);
287: htp.p('');
288: htp.p('');
289: htp.p('');
290: htp.p('');
291: htp.tableRowClose;

Line 288: htp.p('');

284: htp.p('');
285: htp.p('');
286: htp.p(rec_get_terr_values.value2_id);
287: htp.p('');
288: htp.p('');
289: htp.p('');
290: htp.p('');
291: htp.tableRowClose;
292: end if;

Line 289: htp.p('');

285: htp.p('');
286: htp.p(rec_get_terr_values.value2_id);
287: htp.p('');
288: htp.p('');
289: htp.p('');
290: htp.p('');
291: htp.tableRowClose;
292: end if;
293:

Line 290: htp.p('');

286: htp.p(rec_get_terr_values.value2_id);
287: htp.p('');
288: htp.p('');
289: htp.p('');
290: htp.p('');
291: htp.tableRowClose;
292: end if;
293:
294: else -- (l_convert_to_id_flag = 'N')

Line 291: htp.tableRowClose;

287: htp.p('');
288: htp.p('');
289: htp.p('');
290: htp.p('');
291: htp.tableRowClose;
292: end if;
293:
294: else -- (l_convert_to_id_flag = 'N')
295: htp.tableRowOpen;

Line 295: htp.tableRowOpen;

291: htp.tableRowClose;
292: end if;
293:
294: else -- (l_convert_to_id_flag = 'N')
295: htp.tableRowOpen;
296: htp.p('');
297: htp.p(rec_get_terr_values.comparison_operator);
298: htp.p('');
299: htp.p('');

Line 296: htp.p('');

292: end if;
293:
294: else -- (l_convert_to_id_flag = 'N')
295: htp.tableRowOpen;
296: htp.p('');
297: htp.p(rec_get_terr_values.comparison_operator);
298: htp.p('');
299: htp.p('');
300: htp.p(rec_get_terr_values.low_value_char_desc);

Line 297: htp.p(rec_get_terr_values.comparison_operator);

293:
294: else -- (l_convert_to_id_flag = 'N')
295: htp.tableRowOpen;
296: htp.p('');
297: htp.p(rec_get_terr_values.comparison_operator);
298: htp.p('');
299: htp.p('');
300: htp.p(rec_get_terr_values.low_value_char_desc);
301: htp.p('');

Line 298: htp.p('');

294: else -- (l_convert_to_id_flag = 'N')
295: htp.tableRowOpen;
296: htp.p('');
297: htp.p(rec_get_terr_values.comparison_operator);
298: htp.p('');
299: htp.p('');
300: htp.p(rec_get_terr_values.low_value_char_desc);
301: htp.p('');
302: htp.p('');

Line 299: htp.p('');

295: htp.tableRowOpen;
296: htp.p('');
297: htp.p(rec_get_terr_values.comparison_operator);
298: htp.p('');
299: htp.p('');
300: htp.p(rec_get_terr_values.low_value_char_desc);
301: htp.p('');
302: htp.p('');
303: htp.p(rec_get_terr_values.high_value_char_desc);

Line 300: htp.p(rec_get_terr_values.low_value_char_desc);

296: htp.p('');
297: htp.p(rec_get_terr_values.comparison_operator);
298: htp.p('');
299: htp.p('');
300: htp.p(rec_get_terr_values.low_value_char_desc);
301: htp.p('');
302: htp.p('');
303: htp.p(rec_get_terr_values.high_value_char_desc);
304: htp.p('');

Line 301: htp.p('');

297: htp.p(rec_get_terr_values.comparison_operator);
298: htp.p('');
299: htp.p('');
300: htp.p(rec_get_terr_values.low_value_char_desc);
301: htp.p('');
302: htp.p('');
303: htp.p(rec_get_terr_values.high_value_char_desc);
304: htp.p('');
305: htp.p('');

Line 302: htp.p('');

298: htp.p('');
299: htp.p('');
300: htp.p(rec_get_terr_values.low_value_char_desc);
301: htp.p('');
302: htp.p('');
303: htp.p(rec_get_terr_values.high_value_char_desc);
304: htp.p('');
305: htp.p('');
306: htp.p(rec_get_terr_values.CNR_GROUP_NAME);

Line 303: htp.p(rec_get_terr_values.high_value_char_desc);

299: htp.p('');
300: htp.p(rec_get_terr_values.low_value_char_desc);
301: htp.p('');
302: htp.p('');
303: htp.p(rec_get_terr_values.high_value_char_desc);
304: htp.p('');
305: htp.p('');
306: htp.p(rec_get_terr_values.CNR_GROUP_NAME);
307: htp.p('');

Line 304: htp.p('');

300: htp.p(rec_get_terr_values.low_value_char_desc);
301: htp.p('');
302: htp.p('');
303: htp.p(rec_get_terr_values.high_value_char_desc);
304: htp.p('');
305: htp.p('');
306: htp.p(rec_get_terr_values.CNR_GROUP_NAME);
307: htp.p('');
308: htp.tableRowClose;

Line 305: htp.p('');

301: htp.p('');
302: htp.p('');
303: htp.p(rec_get_terr_values.high_value_char_desc);
304: htp.p('');
305: htp.p('');
306: htp.p(rec_get_terr_values.CNR_GROUP_NAME);
307: htp.p('');
308: htp.tableRowClose;
309: End if;

Line 306: htp.p(rec_get_terr_values.CNR_GROUP_NAME);

302: htp.p('');
303: htp.p(rec_get_terr_values.high_value_char_desc);
304: htp.p('');
305: htp.p('');
306: htp.p(rec_get_terr_values.CNR_GROUP_NAME);
307: htp.p('');
308: htp.tableRowClose;
309: End if;
310: else

Line 307: htp.p('');

303: htp.p(rec_get_terr_values.high_value_char_desc);
304: htp.p('');
305: htp.p('');
306: htp.p(rec_get_terr_values.CNR_GROUP_NAME);
307: htp.p('');
308: htp.tableRowClose;
309: End if;
310: else
311: htp.tableRowOpen;

Line 308: htp.tableRowClose;

304: htp.p('');
305: htp.p('');
306: htp.p(rec_get_terr_values.CNR_GROUP_NAME);
307: htp.p('');
308: htp.tableRowClose;
309: End if;
310: else
311: htp.tableRowOpen;
312: htp.p('');

Line 311: htp.tableRowOpen;

307: htp.p('');
308: htp.tableRowClose;
309: End if;
310: else
311: htp.tableRowOpen;
312: htp.p('');
313: htp.p('NO DATA DISPLAYED');
314: htp.p('');
315: htp.tableRowClose;

Line 312: htp.p('');

308: htp.tableRowClose;
309: End if;
310: else
311: htp.tableRowOpen;
312: htp.p('');
313: htp.p('NO DATA DISPLAYED');
314: htp.p('');
315: htp.tableRowClose;
316: end if;

Line 313: htp.p('NO DATA DISPLAYED');

309: End if;
310: else
311: htp.tableRowOpen;
312: htp.p('');
313: htp.p('NO DATA DISPLAYED');
314: htp.p('');
315: htp.tableRowClose;
316: end if;
317: END LOOP;

Line 314: htp.p('');

310: else
311: htp.tableRowOpen;
312: htp.p('');
313: htp.p('NO DATA DISPLAYED');
314: htp.p('');
315: htp.tableRowClose;
316: end if;
317: END LOOP;
318: END LOOP;

Line 315: htp.tableRowClose;

311: htp.tableRowOpen;
312: htp.p('');
313: htp.p('NO DATA DISPLAYED');
314: htp.p('');
315: htp.tableRowClose;
316: end if;
317: END LOOP;
318: END LOOP;
319: END LOOP;

Line 321: htp.p('No territories meet search criteria.');

317: END LOOP;
318: END LOOP;
319: END LOOP;
320: If l_rec_count = 0 then
321: htp.p('No territories meet search criteria.');
322: End if;
323:
324: htp.tableClose;
325: htp.bodyClose;

Line 324: htp.tableClose;

320: If l_rec_count = 0 then
321: htp.p('No territories meet search criteria.');
322: End if;
323:
324: htp.tableClose;
325: htp.bodyClose;
326: htp.htmlClose;
327: end if; -- whether we're using excel or not
328: else

Line 325: htp.bodyClose;

321: htp.p('No territories meet search criteria.');
322: End if;
323:
324: htp.tableClose;
325: htp.bodyClose;
326: htp.htmlClose;
327: end if; -- whether we're using excel or not
328: else
329: htp.p('Invalid session');

Line 326: htp.htmlClose;

322: End if;
323:
324: htp.tableClose;
325: htp.bodyClose;
326: htp.htmlClose;
327: end if; -- whether we're using excel or not
328: else
329: htp.p('Invalid session');
330: end if;

Line 329: htp.p('Invalid session');

325: htp.bodyClose;
326: htp.htmlClose;
327: end if; -- whether we're using excel or not
328: else
329: htp.p('Invalid session');
330: end if;
331: EXCEPTION
332: when no_data_found then
333: htp.p('Territory Definition Report: No Data Found!!!');

Line 333: htp.p('Territory Definition Report: No Data Found!!!');

329: htp.p('Invalid session');
330: end if;
331: EXCEPTION
332: when no_data_found then
333: htp.p('Territory Definition Report: No Data Found!!!');
334: htp.print('Territory Definition Report: No Data Found!!!');
335: when others then
336: htp.p('Territory Definition Report: No Data Found!!!');
337: htp.print('report_wrapper: ' || substr(SQLERRM, 1,200));

Line 334: htp.print('Territory Definition Report: No Data Found!!!');

330: end if;
331: EXCEPTION
332: when no_data_found then
333: htp.p('Territory Definition Report: No Data Found!!!');
334: htp.print('Territory Definition Report: No Data Found!!!');
335: when others then
336: htp.p('Territory Definition Report: No Data Found!!!');
337: htp.print('report_wrapper: ' || substr(SQLERRM, 1,200));
338: END report_wrapper;

Line 336: htp.p('Territory Definition Report: No Data Found!!!');

332: when no_data_found then
333: htp.p('Territory Definition Report: No Data Found!!!');
334: htp.print('Territory Definition Report: No Data Found!!!');
335: when others then
336: htp.p('Territory Definition Report: No Data Found!!!');
337: htp.print('report_wrapper: ' || substr(SQLERRM, 1,200));
338: END report_wrapper;
339:
340: /*----------------------------------------------------------------

Line 337: htp.print('report_wrapper: ' || substr(SQLERRM, 1,200));

333: htp.p('Territory Definition Report: No Data Found!!!');
334: htp.print('Territory Definition Report: No Data Found!!!');
335: when others then
336: htp.p('Territory Definition Report: No Data Found!!!');
337: htp.print('report_wrapper: ' || substr(SQLERRM, 1,200));
338: END report_wrapper;
339:
340: /*----------------------------------------------------------------
341: PROCEDURE XLS

Line 436: htp.p(v_tabrow);

432: FOR rec_terr in cur_terr loop
433: /*
434: if cur_terr%rowcount > 1 then
435: v_tabrow := v_tabrow||' '||v_tab;
436: htp.p(v_tabrow);
437: htp.p(v_tabrow);
438: v_tabrow := null;
439: end if;
440: */

Line 437: htp.p(v_tabrow);

433: /*
434: if cur_terr%rowcount > 1 then
435: v_tabrow := v_tabrow||' '||v_tab;
436: htp.p(v_tabrow);
437: htp.p(v_tabrow);
438: v_tabrow := null;
439: end if;
440: */
441: v_tabrow := null;

Line 442: htp.p(v_tabrow); -- add a blank before each territory

438: v_tabrow := null;
439: end if;
440: */
441: v_tabrow := null;
442: htp.p(v_tabrow); -- add a blank before each territory
443: v_tabrow := null;
444: v_tabrow := v_tabrow||rec_terr.name||v_tab;
445: v_tabrow := v_tabrow||'Rank: '||rec_terr.rank||v_tab;
446: htp.p(v_tabrow); -- print out prepared line

Line 446: htp.p(v_tabrow); -- print out prepared line

442: htp.p(v_tabrow); -- add a blank before each territory
443: v_tabrow := null;
444: v_tabrow := v_tabrow||rec_terr.name||v_tab;
445: v_tabrow := v_tabrow||'Rank: '||rec_terr.rank||v_tab;
446: htp.p(v_tabrow); -- print out prepared line
447: v_tabrow := null;
448: v_tabrow := v_tabrow||h1_divider||v_tab;
449: v_tabrow := v_tabrow||h1_divider||v_tab;
450: htp.p(v_tabrow); -- divider since we dont' know how to format rows in XLS

Line 450: htp.p(v_tabrow); -- divider since we dont' know how to format rows in XLS

446: htp.p(v_tabrow); -- print out prepared line
447: v_tabrow := null;
448: v_tabrow := v_tabrow||h1_divider||v_tab;
449: v_tabrow := v_tabrow||h1_divider||v_tab;
450: htp.p(v_tabrow); -- divider since we dont' know how to format rows in XLS
451: l_rec_count := l_rec_count + 1;
452: -- display sales reps
453: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
454: v_tabrow := null;

Line 457: htp.p(v_tabrow);

453: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
454: v_tabrow := null;
455: v_tabrow := v_tabrow||rec_get_salesrep.resource_name||v_tab;
456: --v_tabrow := v_tabrow||rec_get_salesrep.resource_id||v_tab;
457: htp.p(v_tabrow);
458: END LOOP;
459: v_tabrow := null;
460: v_tabrow := v_tabrow||h2_divider||v_tab;
461: htp.p(v_tabrow);

Line 461: htp.p(v_tabrow);

457: htp.p(v_tabrow);
458: END LOOP;
459: v_tabrow := null;
460: v_tabrow := v_tabrow||h2_divider||v_tab;
461: htp.p(v_tabrow);
462: -- display qualifiers
463: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
464: v_tabrow := null;
465: htp.p(v_tabrow); -- put in a CR before each qualifier

Line 465: htp.p(v_tabrow); -- put in a CR before each qualifier

461: htp.p(v_tabrow);
462: -- display qualifiers
463: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
464: v_tabrow := null;
465: htp.p(v_tabrow); -- put in a CR before each qualifier
466: v_tabrow := null;
467: v_tabrow := v_tabrow||rec_get_terr_qual.qualifier_name||v_tab;
468: --v_tabrow := v_tabrow||rec_get_terr_qual.terr_qual_id||v_tab;
469: if rec_get_terr_qual.qual_usg_id = -1012 then

Line 472: htp.p(v_tabrow);

468: --v_tabrow := v_tabrow||rec_get_terr_qual.terr_qual_id||v_tab;
469: if rec_get_terr_qual.qual_usg_id = -1012 then
470: v_tabrow := v_tabrow||v_tab||v_tab||'Customer Name Range Group'||v_tab;
471: end if;
472: htp.p(v_tabrow);
473: v_tabrow := null;
474: v_tabrow := v_tabrow||h3_divider||v_tab;
475: htp.p(v_tabrow);
476:

Line 475: htp.p(v_tabrow);

471: end if;
472: htp.p(v_tabrow);
473: v_tabrow := null;
474: v_tabrow := v_tabrow||h3_divider||v_tab;
475: htp.p(v_tabrow);
476:
477: -- display qualifier values
478: l_counter := 0;
479: FOR rec_get_terr_values in c_get_terr_values(rec_get_terr_qual.terr_qual_id) loop

Line 491: htp.p(v_tabrow);

487: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
488: v_tabrow := v_tabrow||rec_get_terr_values.low_value_char_desc||v_tab;
489: --v_tabrow := v_tabrow||rec_get_terr_values.low_value_char_id|| 'CHAR_Y l_counter:'||l_counter|| v_tab;
490: v_tabrow := v_tabrow||rec_get_terr_values.low_value_char_id||v_tab;
491: htp.p(v_tabrow);
492: else -- (l_convert_to_id_flag = 'N')
493: v_tabrow := null;
494: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
495: v_tabrow := v_tabrow||rec_get_terr_values.low_value_char_desc||v_tab;

Line 499: htp.p(v_tabrow);

495: v_tabrow := v_tabrow||rec_get_terr_values.low_value_char_desc||v_tab;
496: --v_tabrow := v_tabrow||rec_get_terr_values.high_value_char_desc|| 'CHAR_N l_counter:'||l_counter|| v_tab;
497: v_tabrow := v_tabrow||rec_get_terr_values.high_value_char_desc||v_tab;
498: v_tabrow := v_tabrow||rec_get_terr_values.cnr_group_name|| v_tab;
499: htp.p(v_tabrow);
500: End if;
501: elsif (l_display_type = 'INTEREST_TYPE') then
502: v_tabrow := null;
503: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;

Line 508: htp.p(v_tabrow);

504: v_tabrow := v_tabrow||rec_get_terr_values.interest_type||v_tab;
505: v_tabrow := v_tabrow||rec_get_terr_values.primary_interest_code||v_tab;
506: --v_tabrow := v_tabrow||rec_get_terr_values.secondary_interest_code|| 'INT_T l_counter:'||l_counter|| v_tab;
507: v_tabrow := v_tabrow||rec_get_terr_values.secondary_interest_code||v_tab;
508: htp.p(v_tabrow);
509: elsif (l_display_type = 'NUMBER') then
510: v_tabrow := null;
511: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
512: v_tabrow := v_tabrow||rec_get_terr_values.low_value_number||v_tab;

Line 515: htp.p(v_tabrow);

511: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
512: v_tabrow := v_tabrow||rec_get_terr_values.low_value_number||v_tab;
513: --v_tabrow := v_tabrow||rec_get_terr_values.high_value_number|| 'NUM l_counter:'||l_counter|| v_tab;
514: v_tabrow := v_tabrow||rec_get_terr_values.high_value_number||v_tab;
515: htp.p(v_tabrow);
516: elsif (l_display_type = 'CURRENCY') then
517: v_tabrow := null;
518: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
519: v_tabrow := v_tabrow||rec_get_terr_values.low_value_number||v_tab;

Line 523: htp.p(v_tabrow);

519: v_tabrow := v_tabrow||rec_get_terr_values.low_value_number||v_tab;
520: v_tabrow := v_tabrow||rec_get_terr_values.high_value_number||v_tab;
521: --v_tabrow := v_tabrow||rec_get_terr_values.currency_code|| 'CUR l_counter:'||l_counter|| v_tab;
522: v_tabrow := v_tabrow||rec_get_terr_values.currency_code||v_tab;
523: htp.p(v_tabrow);
524: else
525: v_tabrow := null;
526: v_tabrow := v_tabrow||'NO DATA DISPLAYED'||v_tab;
527: htp.p(v_tabrow);

Line 527: htp.p(v_tabrow);

523: htp.p(v_tabrow);
524: else
525: v_tabrow := null;
526: v_tabrow := v_tabrow||'NO DATA DISPLAYED'||v_tab;
527: htp.p(v_tabrow);
528: end if;
529: END LOOP;
530: END LOOP;
531: END LOOP;

Line 535: htp.p(v_tabrow);

531: END LOOP;
532: If l_rec_count = 0 then
533: v_tabrow := null;
534: v_tabrow := v_tabrow||'No territories meet search criteria.'||v_tab;
535: htp.p(v_tabrow);
536: End if;
537:
538: EXCEPTION
539: when no_data_found then

Line 540: htp.print('Territory Definition excel: No Data Found!!!');

536: End if;
537:
538: EXCEPTION
539: when no_data_found then
540: htp.print('Territory Definition excel: No Data Found!!!');
541: when others then
542: htp.print('Territory Definition excel: '||substr(SQLERRM, 1,200));
543: END XLS;
544:

Line 542: htp.print('Territory Definition excel: '||substr(SQLERRM, 1,200));

538: EXCEPTION
539: when no_data_found then
540: htp.print('Territory Definition excel: No Data Found!!!');
541: when others then
542: htp.print('Territory Definition excel: '||substr(SQLERRM, 1,200));
543: END XLS;
544:
545: END;