100: into l_to_date
101: from dual;
102:
103: /*
104: htp.p(l_from_date);
105: htp.br;
106: htp.p(l_to_date);
107: htp.br;
108: */
101: from dual;
102:
103: /*
104: htp.p(l_from_date);
105: htp.br;
106: htp.p(l_to_date);
107: htp.br;
108: */
109:
102:
103: /*
104: htp.p(l_from_date);
105: htp.br;
106: htp.p(l_to_date);
107: htp.br;
108: */
109:
110: if (icx_sec.validateSession(c_function_code => 'JTF_TERR_CHGS_RPT', c_validate_only => 'Y')) then
103: /*
104: htp.p(l_from_date);
105: htp.br;
106: htp.p(l_to_date);
107: htp.br;
108: */
109:
110: if (icx_sec.validateSession(c_function_code => 'JTF_TERR_CHGS_RPT', c_validate_only => 'Y')) then
111: if l_response = 'Excel' then
112: xls(l_from_date,l_to_date);
113: else
114: --dbms_session.set_sql_trace(TRUE);
115: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
116: htp.htmlopen;
117: htp.headOpen;
118: htp.title('Territory Changes Report');
119: htp.headClose;
120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
113: else
114: --dbms_session.set_sql_trace(TRUE);
115: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
116: htp.htmlopen;
117: htp.headOpen;
118: htp.title('Territory Changes Report');
119: htp.headClose;
120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
114: --dbms_session.set_sql_trace(TRUE);
115: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
116: htp.htmlopen;
117: htp.headOpen;
118: htp.title('Territory Changes Report');
119: htp.headClose;
120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
122: --htp.formHidden( cname => 'p_manager', cvalue => p_manager);
115: l_agent := owa_util.get_cgi_env('SCRIPT_NAME');
116: htp.htmlopen;
117: htp.headOpen;
118: htp.title('Territory Changes Report');
119: htp.headClose;
120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
122: --htp.formHidden( cname => 'p_manager', cvalue => p_manager);
123: htp.formHidden( cname => 'l_from_date', cvalue => l_from_date);
116: htp.htmlopen;
117: htp.headOpen;
118: htp.title('Territory Changes Report');
119: htp.headClose;
120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
122: --htp.formHidden( cname => 'p_manager', cvalue => p_manager);
123: htp.formHidden( cname => 'l_from_date', cvalue => l_from_date);
124: htp.formHidden( cname => 'l_to_date', cvalue => l_to_date);
117: htp.headOpen;
118: htp.title('Territory Changes Report');
119: htp.headClose;
120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
122: --htp.formHidden( cname => 'p_manager', cvalue => p_manager);
123: htp.formHidden( cname => 'l_from_date', cvalue => l_from_date);
124: htp.formHidden( cname => 'l_to_date', cvalue => l_to_date);
125: htp.formClose;
118: htp.title('Territory Changes Report');
119: htp.headClose;
120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
122: --htp.formHidden( cname => 'p_manager', cvalue => p_manager);
123: htp.formHidden( cname => 'l_from_date', cvalue => l_from_date);
124: htp.formHidden( cname => 'l_to_date', cvalue => l_to_date);
125: htp.formClose;
126: */
119: htp.headClose;
120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
122: --htp.formHidden( cname => 'p_manager', cvalue => p_manager);
123: htp.formHidden( cname => 'l_from_date', cvalue => l_from_date);
124: htp.formHidden( cname => 'l_to_date', cvalue => l_to_date);
125: htp.formClose;
126: */
127: htp.p('
120: htp.bodyopen(cattributes=>'bgcolor="#CCCCCC"');
121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
122: --htp.formHidden( cname => 'p_manager', cvalue => p_manager);
123: htp.formHidden( cname => 'l_from_date', cvalue => l_from_date);
124: htp.formHidden( cname => 'l_to_date', cvalue => l_to_date);
125: htp.formClose;
126: */
127: htp.p('
121: /*htp.formOpen( curl => l_agent||'/'||'as_ofl_terr_changes_report.xls', cmethod => 'POST', cattributes => ' name="excel"');
122: --htp.formHidden( cname => 'p_manager', cvalue => p_manager);
123: htp.formHidden( cname => 'l_from_date', cvalue => l_from_date);
124: htp.formHidden( cname => 'l_to_date', cvalue => l_to_date);
125: htp.formClose;
126: */
127: htp.p('
123: htp.formHidden( cname => 'l_from_date', cvalue => l_from_date);
124: htp.formHidden( cname => 'l_to_date', cvalue => l_to_date);
125: htp.formClose;
126: */
127: htp.p('
124: htp.formHidden( cname => 'l_to_date', cvalue => l_to_date);
125: htp.formClose;
126: */
127: htp.p('
125: htp.formClose;
126: */
127: htp.p('
126: */
127: htp.p('
127: htp.p('
128: htp.tableOpen('border="0" ');
129: htp.tableRowOpen( calign => 'TOP' );
130: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
131: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
132: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
133: htp.tableRowClose;
134: htp.tableClose;
135: htp.br;
136:
129: htp.tableRowOpen( calign => 'TOP' );
130: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
131: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
132: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
133: htp.tableRowClose;
134: htp.tableClose;
135: htp.br;
136:
137:
130: --htp.tableData( htf.img(curl=>g_image_prefix||'oppty.gif'));
131: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
132: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
133: htp.tableRowClose;
134: htp.tableClose;
135: htp.br;
136:
137:
138: htp.tableOpen (cattributes => 'COLS=4 border="1" width="100%"');
131: htp.tableData( '' || 'Territory Changes Report', cnowrap => 'TRUE');
132: --htp.tabledata(htf.anchor('JavaScript:document.excel.submit();',htf.img(curl=>g_image_prefix||'up_excel.gif')),calign=>'Right',cattributes=>'width="100%"');
133: htp.tableRowClose;
134: htp.tableClose;
135: htp.br;
136:
137:
138: htp.tableOpen (cattributes => 'COLS=4 border="1" width="100%"');
139: fnd_client_info.set_org_context(fnd_profile.value_wnps('ORG_ID'));
134: htp.tableClose;
135: htp.br;
136:
137:
138: htp.tableOpen (cattributes => 'COLS=4 border="1" width="100%"');
139: fnd_client_info.set_org_context(fnd_profile.value_wnps('ORG_ID'));
140: -- display territories
141: l_rec_count := 0;
142: FOR rec_terr in cur_territory(l_from_date, l_to_date) loop
139: fnd_client_info.set_org_context(fnd_profile.value_wnps('ORG_ID'));
140: -- display territories
141: l_rec_count := 0;
142: FOR rec_terr in cur_territory(l_from_date, l_to_date) loop
143: htp.tableRowOpen;
144: htp.p('
140: -- display territories
141: l_rec_count := 0;
142: FOR rec_terr in cur_territory(l_from_date, l_to_date) loop
143: htp.tableRowOpen;
144: htp.p('
145: htp.p('
146: htp.p(rec_terr.name);
147: htp.p('
148: htp.p('
149: htp.p('Rank: ' ||rec_terr.rank);
150: htp.p('
151: htp.p('
152: htp.p('Type: ' ||rec_terr.terr_type_name);
153: htp.p('');
154: htp.p('
159: l_rec_count := l_rec_count + 1;
160:
161: -- display sales reps
162: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
163: htp.tableRowOpen;
164: htp.p('
165: htp.p(rec_get_salesrep.resource_name);
166: htp.p('');
170: --htp.tableRowClose;
171: END LOOP;
172: -- display qualifiers
173: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
174: htp.tableRowOpen;
175: htp.p('
176: htp.p('
177: htp.p(rec_get_terr_qual.qualifier_name);
178: htp.p('');
187: l_convert_to_id_flag := rec_get_terr_values.convert_to_id_flag;
188:
189: If (l_display_type = 'CHAR') then
190: If (l_convert_to_id_flag = 'Y') then
191: htp.tableRowOpen;
192: htp.p('
193: htp.p(rec_get_terr_values.comparison_operator);
194: htp.p('
195: htp.p('
196: htp.p(rec_get_terr_values.low_value_char_desc);
197: htp.p('
198: htp.p('
199: htp.p(rec_get_terr_values.low_value_char_id);
200: htp.p('
202: htp.p('');
203: htp.p('
204: htp.tableRowClose;
205: else -- (l_convert_to_id_flag = 'N')
206: htp.tableRowOpen;
207: htp.p('
208: htp.p(rec_get_terr_values.comparison_operator);
209: htp.p('
210: htp.p('
211: htp.p(rec_get_terr_values.low_value_char_desc);
212: htp.p('
213: htp.p('
214: htp.p(rec_get_terr_values.high_value_char_desc);
215: htp.p('');
218: htp.p('
219: htp.tableRowClose;
220: End if;
221: elsif (l_display_type = 'INTEREST_TYPE') then
222: htp.tableRowOpen;
223: htp.p('
224: htp.p(rec_get_terr_values.comparison_operator);
225: htp.p('
226: htp.p('
227: htp.p(rec_get_terr_values.interest_type);
228: htp.p('
229: htp.p('
230: htp.p(rec_get_terr_values.primary_interest_code);
231: htp.p('
233: htp.p(rec_get_terr_values.secondary_interest_code);
234: htp.p('
235: htp.tableRowClose;
236: elsif (l_display_type = 'NUMBER') then
237: htp.tableRowOpen;
238: htp.p('
239: htp.p(rec_get_terr_values.comparison_operator);
240: htp.p('
241: htp.p('
242: htp.p(rec_get_terr_values.low_value_number);
243: htp.p('
244: htp.p('
245: htp.p(rec_get_terr_values.high_value_number);
246: htp.p('
248: htp.p('');
249: htp.p('
250: htp.tableRowClose;
251: elsif (l_display_type = 'CURRENCY') then
252: htp.tableRowOpen;
253: htp.p('
254: htp.p(rec_get_terr_values.comparison_operator);
255: htp.p('
256: htp.p('
257: htp.p(rec_get_terr_values.low_value_number);
258: htp.p('
259: htp.p('
260: htp.p(rec_get_terr_values.high_value_number);
261: htp.p('
263: htp.p(rec_get_terr_values.currency_code);
264: htp.p('
265: htp.tableRowClose;
266: else
267: htp.tableRowOpen;
273: END LOOP;
276: If l_rec_count = 0 then
279:
280: htp.tableClose;
281:
282: /*
283: htp.tableOpen (cattributes => 'border="1" width="100%"');
284: htp.tableRowOpen;
285: htp.p('
286: htp.p('
287: htp.p('
288: --htp.p('
289: htp.p('
290: htp.p('
293: htp.p('
294: htp.tableRowClose;
295: -- display territories
296: for rec_territory in cur_territory(l_from_date, l_to_date) loop
297: htp.tableRowOpen;
298: htp.p('
302: htp.tableRowClose;
304:
305: -- DBMS_SQL.CLOSE_CURSOR(cid);
306: htp.tableClose;
307: */
310: htp.bodyClose;
316: -- dbms_session.set_sql_trace(FALSE);
318: EXCEPTION
394: SELECT FND_GLOBAL.TAB
403: FOR rec_terr in cur_territory(l_from_date, l_to_date) loop
404: /*
409: v_tabrow := null;
415: v_tabrow := v_tabrow||rec_terr.name||v_tab;
421: v_tabrow := v_tabrow||h1_divider||v_tab;
430: v_tabrow := null;
434: htp.p(v_tabrow);
438: htp.p(v_tabrow);
442: htp.p(v_tabrow); -- put in a CR before each qualifier
445: --v_tabrow := v_tabrow||rec_get_terr_qual.terr_qual_id||v_tab;
461: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
468: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
477: v_tabrow := v_tabrow||rec_get_terr_values.interest_type||v_tab;
484: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
492: v_tabrow := v_tabrow||rec_get_terr_values.low_value_number||v_tab;
496: htp.p(v_tabrow);
504: END LOOP;
510:
512: exception
141: l_rec_count := 0;
142: FOR rec_terr in cur_territory(l_from_date, l_to_date) loop
143: htp.tableRowOpen;
144: htp.p('');
145: htp.p(''); ');
146: htp.p(rec_terr.name);
147: htp.p('
148: htp.p('');
Line 145: htp.p('
');
142: FOR rec_terr in cur_territory(l_from_date, l_to_date) loop
143: htp.tableRowOpen;
144: htp.p('');
145: htp.p(''); ');
146: htp.p(rec_terr.name);
147: htp.p('
148: htp.p('');
149: htp.p('Rank: ' ||rec_terr.rank);
Line 146: htp.p(rec_terr.name);
143: htp.tableRowOpen;
144: htp.p('');
145: htp.p(''); ');
146: htp.p(rec_terr.name);
147: htp.p('
148: htp.p(''); ');
149: htp.p('Rank: ' ||rec_terr.rank);
150: htp.p('
Line 147: htp.p('');
144: htp.p('');
145: htp.p(''); ');
146: htp.p(rec_terr.name);
147: htp.p('
148: htp.p(''); ');
149: htp.p('Rank: ' ||rec_terr.rank);
150: htp.p('
151: htp.p('');
Line 148: htp.p('
');
');
145: htp.p(''); ');
146: htp.p(rec_terr.name);
147: htp.p('
148: htp.p(''); ');
149: htp.p('Rank: ' ||rec_terr.rank);
150: htp.p('
151: htp.p('');
152: htp.p('Type: ' ||rec_terr.terr_type_name);
Line 149: htp.p('Rank: ' ||rec_terr.rank);
'); ');
146: htp.p(rec_terr.name);
147: htp.p('
148: htp.p(''); ');
149: htp.p('Rank: ' ||rec_terr.rank);
150: htp.p('
151: htp.p(''); ');
152: htp.p('Type: ' ||rec_terr.terr_type_name);
153: htp.p('
Line 150: htp.p('');
147: htp.p('');
148: htp.p(''); ');
149: htp.p('Rank: ' ||rec_terr.rank);
150: htp.p('
151: htp.p(''); ');
152: htp.p('Type: ' ||rec_terr.terr_type_name);
153: htp.p('
154: htp.p(''); ');
Line 151: htp.p('
'); ');
148: htp.p(''); ');
149: htp.p('Rank: ' ||rec_terr.rank);
150: htp.p('
151: htp.p(''); ');
152: htp.p('Type: ' ||rec_terr.terr_type_name);
153: htp.p('
154: htp.p('');
155: htp.p('Created: ' ||rec_terr.creation_date);
Line 152: htp.p('Type: ' ||rec_terr.terr_type_name);
'); ');
149: htp.p('Rank: ' ||rec_terr.rank);
150: htp.p('
151: htp.p(''); ');
152: htp.p('Type: ' ||rec_terr.terr_type_name);
153: htp.p('
154: htp.p(''); ');
155: htp.p('Created: ' ||rec_terr.creation_date);
156: htp.p('Updated: ' ||rec_terr.last_update_date);
Line 153: htp.p('
150: htp.p('
151: htp.p(''); ');
152: htp.p('Type: ' ||rec_terr.terr_type_name);
153: htp.p('
154: htp.p(''); ');
155: htp.p('Created: ' ||rec_terr.creation_date);
156: htp.p('Updated: ' ||rec_terr.last_update_date);
157: htp.p('
Line 154: htp.p('
'); ');
151: htp.p(''); ');
152: htp.p('Type: ' ||rec_terr.terr_type_name);
153: htp.p('
154: htp.p(''); ');
155: htp.p('Created: ' ||rec_terr.creation_date);
156: htp.p('Updated: ' ||rec_terr.last_update_date);
157: htp.p('
158: htp.tableRowClose;
Line 155: htp.p('Created: ' ||rec_terr.creation_date);
'); ');
152: htp.p('Type: ' ||rec_terr.terr_type_name);
153: htp.p('
154: htp.p(''); ');
155: htp.p('Created: ' ||rec_terr.creation_date);
156: htp.p('Updated: ' ||rec_terr.last_update_date);
157: htp.p('
158: htp.tableRowClose;
159: l_rec_count := l_rec_count + 1;
Line 156: htp.p('Updated: ' ||rec_terr.last_update_date);
153: htp.p('');
154: htp.p(''); ');
155: htp.p('Created: ' ||rec_terr.creation_date);
156: htp.p('Updated: ' ||rec_terr.last_update_date);
157: htp.p('
158: htp.tableRowClose;
159: l_rec_count := l_rec_count + 1;
160:
Line 157: htp.p('');
154: htp.p(''); ');
155: htp.p('Created: ' ||rec_terr.creation_date);
156: htp.p('Updated: ' ||rec_terr.last_update_date);
157: htp.p('
158: htp.tableRowClose;
159: l_rec_count := l_rec_count + 1;
160:
161: -- display sales reps
Line 158: htp.tableRowClose;
'); ');
155: htp.p('Created: ' ||rec_terr.creation_date);
156: htp.p('Updated: ' ||rec_terr.last_update_date);
157: htp.p('
158: htp.tableRowClose;
159: l_rec_count := l_rec_count + 1;
160:
161: -- display sales reps
162: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
Line 163: htp.tableRowOpen;
160:
161: -- display sales reps
162: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
163: htp.tableRowOpen;
164: htp.p(' ');
165: htp.p(rec_get_salesrep.resource_name);
166: htp.p('
167: --htp.p('');
Line 164: htp.p('
');
161: -- display sales reps
162: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
163: htp.tableRowOpen;
164: htp.p(' ');
165: htp.p(rec_get_salesrep.resource_name);
166: htp.p('
167: --htp.p('');
168: --htp.p(rec_get_salesrep.resource_id);
Line 165: htp.p(rec_get_salesrep.resource_name);
162: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
163: htp.tableRowOpen;
164: htp.p(' ');
165: htp.p(rec_get_salesrep.resource_name);
166: htp.p('
167: --htp.p(''); ');
168: --htp.p(rec_get_salesrep.resource_id);
169: --htp.p('
Line 166: htp.p('
163: htp.tableRowOpen;
164: htp.p(' ');
165: htp.p(rec_get_salesrep.resource_name);
166: htp.p('
167: --htp.p(''); ');
168: --htp.p(rec_get_salesrep.resource_id);
169: --htp.p('
170: --htp.tableRowClose;
Line 167: --htp.p('
');
164: htp.p(' ');
165: htp.p(rec_get_salesrep.resource_name);
166: htp.p('
167: --htp.p(''); ');
168: --htp.p(rec_get_salesrep.resource_id);
169: --htp.p('
170: --htp.tableRowClose;
171: END LOOP;
Line 168: --htp.p(rec_get_salesrep.resource_id);
');
165: htp.p(rec_get_salesrep.resource_name);
166: htp.p('
167: --htp.p(''); ');
168: --htp.p(rec_get_salesrep.resource_id);
169: --htp.p('
170: --htp.tableRowClose;
171: END LOOP;
172: -- display qualifiers
Line 169: --htp.p('');
166: htp.p('');
167: --htp.p(''); ');
168: --htp.p(rec_get_salesrep.resource_id);
169: --htp.p('
170: --htp.tableRowClose;
171: END LOOP;
172: -- display qualifiers
173: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
Line 170: --htp.tableRowClose;
167: --htp.p(''); ');
168: --htp.p(rec_get_salesrep.resource_id);
169: --htp.p('
170: --htp.tableRowClose;
171: END LOOP;
172: -- display qualifiers
173: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
174: htp.tableRowOpen;
Line 174: htp.tableRowOpen;
171: END LOOP;
172: -- display qualifiers
173: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
174: htp.tableRowOpen;
175: htp.p('');
176: htp.p(''); ');
177: htp.p(rec_get_terr_qual.qualifier_name);
178: htp.p('
Line 175: htp.p('
');
172: -- display qualifiers
173: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
174: htp.tableRowOpen;
175: htp.p('');
176: htp.p(''); ');
177: htp.p(rec_get_terr_qual.qualifier_name);
178: htp.p('
179: --htp.p('');
Line 176: htp.p('
');
173: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
174: htp.tableRowOpen;
175: htp.p('');
176: htp.p(''); ');
177: htp.p(rec_get_terr_qual.qualifier_name);
178: htp.p('
179: --htp.p('');
180: --htp.p('Terr_qual_id: ' ||rec_get_terr_qual.terr_qual_id);
Line 177: htp.p(rec_get_terr_qual.qualifier_name);
174: htp.tableRowOpen;
175: htp.p('');
176: htp.p(''); ');
177: htp.p(rec_get_terr_qual.qualifier_name);
178: htp.p('
179: --htp.p(''); ');
180: --htp.p('Terr_qual_id: ' ||rec_get_terr_qual.terr_qual_id);
181: --htp.p('
Line 178: htp.p('');
175: htp.p('');
176: htp.p(''); ');
177: htp.p(rec_get_terr_qual.qualifier_name);
178: htp.p('
179: --htp.p(''); ');
180: --htp.p('Terr_qual_id: ' ||rec_get_terr_qual.terr_qual_id);
181: --htp.p('
182: htp.tableRowClose;
Line 179: --htp.p('
');
');
176: htp.p(''); ');
177: htp.p(rec_get_terr_qual.qualifier_name);
178: htp.p('
179: --htp.p(''); ');
180: --htp.p('Terr_qual_id: ' ||rec_get_terr_qual.terr_qual_id);
181: --htp.p('
182: htp.tableRowClose;
183: -- display qualifier values
Line 180: --htp.p('Terr_qual_id: ' ||rec_get_terr_qual.terr_qual_id);
'); ');
177: htp.p(rec_get_terr_qual.qualifier_name);
178: htp.p('
179: --htp.p(''); ');
180: --htp.p('Terr_qual_id: ' ||rec_get_terr_qual.terr_qual_id);
181: --htp.p('
182: htp.tableRowClose;
183: -- display qualifier values
184: FOR rec_get_terr_values in c_get_terr_values(rec_get_terr_qual.terr_qual_id) loop
Line 181: --htp.p('');
178: htp.p('');
179: --htp.p(''); ');
180: --htp.p('Terr_qual_id: ' ||rec_get_terr_qual.terr_qual_id);
181: --htp.p('
182: htp.tableRowClose;
183: -- display qualifier values
184: FOR rec_get_terr_values in c_get_terr_values(rec_get_terr_qual.terr_qual_id) loop
185: -- output qualifier values according to display_type and convert_to_id_flag
Line 182: htp.tableRowClose;
179: --htp.p(''); ');
180: --htp.p('Terr_qual_id: ' ||rec_get_terr_qual.terr_qual_id);
181: --htp.p('
182: htp.tableRowClose;
183: -- display qualifier values
184: FOR rec_get_terr_values in c_get_terr_values(rec_get_terr_qual.terr_qual_id) loop
185: -- output qualifier values according to display_type and convert_to_id_flag
186: l_display_type := rec_get_terr_values.display_type;
Line 191: htp.tableRowOpen;
188:
189: If (l_display_type = 'CHAR') then
190: If (l_convert_to_id_flag = 'Y') then
191: htp.tableRowOpen;
192: htp.p(' ');
193: htp.p(rec_get_terr_values.comparison_operator);
194: htp.p('
195: htp.p(' ');
Line 192: htp.p('
');
189: If (l_display_type = 'CHAR') then
190: If (l_convert_to_id_flag = 'Y') then
191: htp.tableRowOpen;
192: htp.p(' ');
193: htp.p(rec_get_terr_values.comparison_operator);
194: htp.p('
195: htp.p(' ');
196: htp.p(rec_get_terr_values.low_value_char_desc);
Line 193: htp.p(rec_get_terr_values.comparison_operator);
190: If (l_convert_to_id_flag = 'Y') then
191: htp.tableRowOpen;
192: htp.p(' ');
193: htp.p(rec_get_terr_values.comparison_operator);
194: htp.p('
195: htp.p(' ');
196: htp.p(rec_get_terr_values.low_value_char_desc);
197: htp.p('
Line 194: htp.p('
191: htp.tableRowOpen;
192: htp.p(' ');
193: htp.p(rec_get_terr_values.comparison_operator);
194: htp.p('
195: htp.p(' ');
196: htp.p(rec_get_terr_values.low_value_char_desc);
197: htp.p('
198: htp.p(''); ');
Line 195: htp.p('
');
192: htp.p(' ');
193: htp.p(rec_get_terr_values.comparison_operator);
194: htp.p('
195: htp.p(' ');
196: htp.p(rec_get_terr_values.low_value_char_desc);
197: htp.p('
198: htp.p('');
199: htp.p(rec_get_terr_values.low_value_char_id);
Line 196: htp.p(rec_get_terr_values.low_value_char_desc);
');
193: htp.p(rec_get_terr_values.comparison_operator);
194: htp.p('
195: htp.p(' ');
196: htp.p(rec_get_terr_values.low_value_char_desc);
197: htp.p('
198: htp.p(''); ');
199: htp.p(rec_get_terr_values.low_value_char_id);
200: htp.p('
Line 197: htp.p('
194: htp.p('
195: htp.p(' ');
196: htp.p(rec_get_terr_values.low_value_char_desc);
197: htp.p('
198: htp.p(''); ');
199: htp.p(rec_get_terr_values.low_value_char_id);
200: htp.p('
201: htp.p(' ');
Line 198: htp.p('
'); ');
195: htp.p(' ');
196: htp.p(rec_get_terr_values.low_value_char_desc);
197: htp.p('
198: htp.p(''); ');
199: htp.p(rec_get_terr_values.low_value_char_id);
200: htp.p('
201: htp.p(' ');
202: htp.p('');
Line 199: htp.p(rec_get_terr_values.low_value_char_id);
');
196: htp.p(rec_get_terr_values.low_value_char_desc);
197: htp.p('
198: htp.p(''); ');
199: htp.p(rec_get_terr_values.low_value_char_id);
200: htp.p('
201: htp.p(' ');
202: htp.p('');
203: htp.p('
Line 200: htp.p('
197: htp.p('
198: htp.p(''); ');
199: htp.p(rec_get_terr_values.low_value_char_id);
200: htp.p('
201: htp.p(' ');
202: htp.p('');
203: htp.p('
204: htp.tableRowClose;
Line 201: htp.p('
');
198: htp.p(''); ');
199: htp.p(rec_get_terr_values.low_value_char_id);
200: htp.p('
201: htp.p(' ');
202: htp.p('');
203: htp.p('
204: htp.tableRowClose;
205: else -- (l_convert_to_id_flag = 'N')
Line 202: htp.p('');
'); ');
199: htp.p(rec_get_terr_values.low_value_char_id);
200: htp.p('
201: htp.p(' ');
202: htp.p('');
203: htp.p('
204: htp.tableRowClose;
205: else -- (l_convert_to_id_flag = 'N')
206: htp.tableRowOpen;
Line 203: htp.p('
200: htp.p('
201: htp.p(' ');
202: htp.p('');
203: htp.p('
204: htp.tableRowClose;
205: else -- (l_convert_to_id_flag = 'N')
206: htp.tableRowOpen;
207: htp.p(' ');
Line 204: htp.tableRowClose;
201: htp.p(' ');
202: htp.p('');
203: htp.p('
204: htp.tableRowClose;
205: else -- (l_convert_to_id_flag = 'N')
206: htp.tableRowOpen;
207: htp.p(' ');
208: htp.p(rec_get_terr_values.comparison_operator);
Line 206: htp.tableRowOpen;
203: htp.p('
204: htp.tableRowClose;
205: else -- (l_convert_to_id_flag = 'N')
206: htp.tableRowOpen;
207: htp.p(' ');
208: htp.p(rec_get_terr_values.comparison_operator);
209: htp.p('
210: htp.p(' ');
Line 207: htp.p('
');
204: htp.tableRowClose;
205: else -- (l_convert_to_id_flag = 'N')
206: htp.tableRowOpen;
207: htp.p(' ');
208: htp.p(rec_get_terr_values.comparison_operator);
209: htp.p('
210: htp.p(' ');
211: htp.p(rec_get_terr_values.low_value_char_desc);
Line 208: htp.p(rec_get_terr_values.comparison_operator);
205: else -- (l_convert_to_id_flag = 'N')
206: htp.tableRowOpen;
207: htp.p(' ');
208: htp.p(rec_get_terr_values.comparison_operator);
209: htp.p('
210: htp.p(' ');
211: htp.p(rec_get_terr_values.low_value_char_desc);
212: htp.p('
Line 209: htp.p('
206: htp.tableRowOpen;
207: htp.p(' ');
208: htp.p(rec_get_terr_values.comparison_operator);
209: htp.p('
210: htp.p(' ');
211: htp.p(rec_get_terr_values.low_value_char_desc);
212: htp.p('
213: htp.p(''); ');
Line 210: htp.p('
');
207: htp.p(' ');
208: htp.p(rec_get_terr_values.comparison_operator);
209: htp.p('
210: htp.p(' ');
211: htp.p(rec_get_terr_values.low_value_char_desc);
212: htp.p('
213: htp.p('');
214: htp.p(rec_get_terr_values.high_value_char_desc);
Line 211: htp.p(rec_get_terr_values.low_value_char_desc);
');
208: htp.p(rec_get_terr_values.comparison_operator);
209: htp.p('
210: htp.p(' ');
211: htp.p(rec_get_terr_values.low_value_char_desc);
212: htp.p('
213: htp.p(''); ');
214: htp.p(rec_get_terr_values.high_value_char_desc);
215: htp.p('
Line 212: htp.p('
209: htp.p('
210: htp.p(' ');
211: htp.p(rec_get_terr_values.low_value_char_desc);
212: htp.p('
213: htp.p(''); ');
214: htp.p(rec_get_terr_values.high_value_char_desc);
215: htp.p('
216: htp.p(' ');
Line 213: htp.p('
'); ');
210: htp.p(' ');
211: htp.p(rec_get_terr_values.low_value_char_desc);
212: htp.p('
213: htp.p(''); ');
214: htp.p(rec_get_terr_values.high_value_char_desc);
215: htp.p('
216: htp.p(' ');
217: htp.p('');
Line 214: htp.p(rec_get_terr_values.high_value_char_desc);
');
211: htp.p(rec_get_terr_values.low_value_char_desc);
212: htp.p('
213: htp.p(''); ');
214: htp.p(rec_get_terr_values.high_value_char_desc);
215: htp.p('
216: htp.p(' ');
217: htp.p('');
218: htp.p('
Line 215: htp.p('
212: htp.p('
213: htp.p(''); ');
214: htp.p(rec_get_terr_values.high_value_char_desc);
215: htp.p('
216: htp.p(' ');
217: htp.p('');
218: htp.p('
219: htp.tableRowClose;
Line 216: htp.p('
');
213: htp.p(''); ');
214: htp.p(rec_get_terr_values.high_value_char_desc);
215: htp.p('
216: htp.p(' ');
217: htp.p('');
218: htp.p('
219: htp.tableRowClose;
220: End if;
Line 217: htp.p('');
'); ');
214: htp.p(rec_get_terr_values.high_value_char_desc);
215: htp.p('
216: htp.p(' ');
217: htp.p('');
218: htp.p('
219: htp.tableRowClose;
220: End if;
221: elsif (l_display_type = 'INTEREST_TYPE') then
Line 218: htp.p('
215: htp.p('');
216: htp.p(' ');
217: htp.p('');
218: htp.p('
219: htp.tableRowClose;
220: End if;
221: elsif (l_display_type = 'INTEREST_TYPE') then
222: htp.tableRowOpen;
Line 219: htp.tableRowClose;
216: htp.p(' ');
217: htp.p('');
218: htp.p('
219: htp.tableRowClose;
220: End if;
221: elsif (l_display_type = 'INTEREST_TYPE') then
222: htp.tableRowOpen;
223: htp.p(' ');
Line 222: htp.tableRowOpen;
219: htp.tableRowClose;
220: End if;
221: elsif (l_display_type = 'INTEREST_TYPE') then
222: htp.tableRowOpen;
223: htp.p(' ');
224: htp.p(rec_get_terr_values.comparison_operator);
225: htp.p('
226: htp.p(' ');
Line 223: htp.p('
');
220: End if;
221: elsif (l_display_type = 'INTEREST_TYPE') then
222: htp.tableRowOpen;
223: htp.p(' ');
224: htp.p(rec_get_terr_values.comparison_operator);
225: htp.p('
226: htp.p(' ');
227: htp.p(rec_get_terr_values.interest_type);
Line 224: htp.p(rec_get_terr_values.comparison_operator);
221: elsif (l_display_type = 'INTEREST_TYPE') then
222: htp.tableRowOpen;
223: htp.p(' ');
224: htp.p(rec_get_terr_values.comparison_operator);
225: htp.p('
226: htp.p(' ');
227: htp.p(rec_get_terr_values.interest_type);
228: htp.p('
Line 225: htp.p('
222: htp.tableRowOpen;
223: htp.p(' ');
224: htp.p(rec_get_terr_values.comparison_operator);
225: htp.p('
226: htp.p(' ');
227: htp.p(rec_get_terr_values.interest_type);
228: htp.p('
229: htp.p(''); ');
Line 226: htp.p('
');
223: htp.p(' ');
224: htp.p(rec_get_terr_values.comparison_operator);
225: htp.p('
226: htp.p(' ');
227: htp.p(rec_get_terr_values.interest_type);
228: htp.p('
229: htp.p('');
230: htp.p(rec_get_terr_values.primary_interest_code);
Line 227: htp.p(rec_get_terr_values.interest_type);
');
224: htp.p(rec_get_terr_values.comparison_operator);
225: htp.p('
226: htp.p(' ');
227: htp.p(rec_get_terr_values.interest_type);
228: htp.p('
229: htp.p(''); ');
230: htp.p(rec_get_terr_values.primary_interest_code);
231: htp.p('
Line 228: htp.p('
225: htp.p('
226: htp.p(' ');
227: htp.p(rec_get_terr_values.interest_type);
228: htp.p('
229: htp.p(''); ');
230: htp.p(rec_get_terr_values.primary_interest_code);
231: htp.p('
232: htp.p(' ');
Line 229: htp.p('
'); ');
226: htp.p(' ');
227: htp.p(rec_get_terr_values.interest_type);
228: htp.p('
229: htp.p(''); ');
230: htp.p(rec_get_terr_values.primary_interest_code);
231: htp.p('
232: htp.p(' ');
233: htp.p(rec_get_terr_values.secondary_interest_code);
Line 230: htp.p(rec_get_terr_values.primary_interest_code);
');
227: htp.p(rec_get_terr_values.interest_type);
228: htp.p('
229: htp.p(''); ');
230: htp.p(rec_get_terr_values.primary_interest_code);
231: htp.p('
232: htp.p(' ');
233: htp.p(rec_get_terr_values.secondary_interest_code);
234: htp.p('
Line 231: htp.p('
228: htp.p('
229: htp.p(''); ');
230: htp.p(rec_get_terr_values.primary_interest_code);
231: htp.p('
232: htp.p(' ');
233: htp.p(rec_get_terr_values.secondary_interest_code);
234: htp.p('
235: htp.tableRowClose;
Line 232: htp.p('
');
229: htp.p(''); ');
230: htp.p(rec_get_terr_values.primary_interest_code);
231: htp.p('
232: htp.p(' ');
233: htp.p(rec_get_terr_values.secondary_interest_code);
234: htp.p('
235: htp.tableRowClose;
236: elsif (l_display_type = 'NUMBER') then
Line 233: htp.p(rec_get_terr_values.secondary_interest_code);
'); ');
230: htp.p(rec_get_terr_values.primary_interest_code);
231: htp.p('
232: htp.p(' ');
233: htp.p(rec_get_terr_values.secondary_interest_code);
234: htp.p('
235: htp.tableRowClose;
236: elsif (l_display_type = 'NUMBER') then
237: htp.tableRowOpen;
Line 234: htp.p('
231: htp.p('
232: htp.p(' ');
233: htp.p(rec_get_terr_values.secondary_interest_code);
234: htp.p('
235: htp.tableRowClose;
236: elsif (l_display_type = 'NUMBER') then
237: htp.tableRowOpen;
238: htp.p(' ');
Line 235: htp.tableRowClose;
232: htp.p(' ');
233: htp.p(rec_get_terr_values.secondary_interest_code);
234: htp.p('
235: htp.tableRowClose;
236: elsif (l_display_type = 'NUMBER') then
237: htp.tableRowOpen;
238: htp.p(' ');
239: htp.p(rec_get_terr_values.comparison_operator);
Line 237: htp.tableRowOpen;
234: htp.p('
235: htp.tableRowClose;
236: elsif (l_display_type = 'NUMBER') then
237: htp.tableRowOpen;
238: htp.p(' ');
239: htp.p(rec_get_terr_values.comparison_operator);
240: htp.p('
241: htp.p(' ');
Line 238: htp.p('
');
235: htp.tableRowClose;
236: elsif (l_display_type = 'NUMBER') then
237: htp.tableRowOpen;
238: htp.p(' ');
239: htp.p(rec_get_terr_values.comparison_operator);
240: htp.p('
241: htp.p(' ');
242: htp.p(rec_get_terr_values.low_value_number);
Line 239: htp.p(rec_get_terr_values.comparison_operator);
236: elsif (l_display_type = 'NUMBER') then
237: htp.tableRowOpen;
238: htp.p(' ');
239: htp.p(rec_get_terr_values.comparison_operator);
240: htp.p('
241: htp.p(' ');
242: htp.p(rec_get_terr_values.low_value_number);
243: htp.p('
Line 240: htp.p('
237: htp.tableRowOpen;
238: htp.p(' ');
239: htp.p(rec_get_terr_values.comparison_operator);
240: htp.p('
241: htp.p(' ');
242: htp.p(rec_get_terr_values.low_value_number);
243: htp.p('
244: htp.p(''); ');
Line 241: htp.p('
');
238: htp.p(' ');
239: htp.p(rec_get_terr_values.comparison_operator);
240: htp.p('
241: htp.p(' ');
242: htp.p(rec_get_terr_values.low_value_number);
243: htp.p('
244: htp.p('');
245: htp.p(rec_get_terr_values.high_value_number);
Line 242: htp.p(rec_get_terr_values.low_value_number);
');
239: htp.p(rec_get_terr_values.comparison_operator);
240: htp.p('
241: htp.p(' ');
242: htp.p(rec_get_terr_values.low_value_number);
243: htp.p('
244: htp.p(''); ');
245: htp.p(rec_get_terr_values.high_value_number);
246: htp.p('
Line 243: htp.p('
240: htp.p('
241: htp.p(' ');
242: htp.p(rec_get_terr_values.low_value_number);
243: htp.p('
244: htp.p(''); ');
245: htp.p(rec_get_terr_values.high_value_number);
246: htp.p('
247: htp.p(' ');
Line 244: htp.p('
'); ');
241: htp.p(' ');
242: htp.p(rec_get_terr_values.low_value_number);
243: htp.p('
244: htp.p(''); ');
245: htp.p(rec_get_terr_values.high_value_number);
246: htp.p('
247: htp.p(' ');
248: htp.p('');
Line 245: htp.p(rec_get_terr_values.high_value_number);
');
242: htp.p(rec_get_terr_values.low_value_number);
243: htp.p('
244: htp.p(''); ');
245: htp.p(rec_get_terr_values.high_value_number);
246: htp.p('
247: htp.p(' ');
248: htp.p('');
249: htp.p('
Line 246: htp.p('
243: htp.p('
244: htp.p(''); ');
245: htp.p(rec_get_terr_values.high_value_number);
246: htp.p('
247: htp.p(' ');
248: htp.p('');
249: htp.p('
250: htp.tableRowClose;
Line 247: htp.p('
');
244: htp.p(''); ');
245: htp.p(rec_get_terr_values.high_value_number);
246: htp.p('
247: htp.p(' ');
248: htp.p('');
249: htp.p('
250: htp.tableRowClose;
251: elsif (l_display_type = 'CURRENCY') then
Line 248: htp.p('');
'); ');
245: htp.p(rec_get_terr_values.high_value_number);
246: htp.p('
247: htp.p(' ');
248: htp.p('');
249: htp.p('
250: htp.tableRowClose;
251: elsif (l_display_type = 'CURRENCY') then
252: htp.tableRowOpen;
Line 249: htp.p('
246: htp.p('');
247: htp.p(' ');
248: htp.p('');
249: htp.p('
250: htp.tableRowClose;
251: elsif (l_display_type = 'CURRENCY') then
252: htp.tableRowOpen;
253: htp.p(' ');
Line 250: htp.tableRowClose;
247: htp.p(' ');
248: htp.p('');
249: htp.p('
250: htp.tableRowClose;
251: elsif (l_display_type = 'CURRENCY') then
252: htp.tableRowOpen;
253: htp.p(' ');
254: htp.p(rec_get_terr_values.comparison_operator);
Line 252: htp.tableRowOpen;
249: htp.p('
250: htp.tableRowClose;
251: elsif (l_display_type = 'CURRENCY') then
252: htp.tableRowOpen;
253: htp.p(' ');
254: htp.p(rec_get_terr_values.comparison_operator);
255: htp.p('
256: htp.p(' ');
Line 253: htp.p('
');
250: htp.tableRowClose;
251: elsif (l_display_type = 'CURRENCY') then
252: htp.tableRowOpen;
253: htp.p(' ');
254: htp.p(rec_get_terr_values.comparison_operator);
255: htp.p('
256: htp.p(' ');
257: htp.p(rec_get_terr_values.low_value_number);
Line 254: htp.p(rec_get_terr_values.comparison_operator);
251: elsif (l_display_type = 'CURRENCY') then
252: htp.tableRowOpen;
253: htp.p(' ');
254: htp.p(rec_get_terr_values.comparison_operator);
255: htp.p('
256: htp.p(' ');
257: htp.p(rec_get_terr_values.low_value_number);
258: htp.p('
Line 255: htp.p('
252: htp.tableRowOpen;
253: htp.p(' ');
254: htp.p(rec_get_terr_values.comparison_operator);
255: htp.p('
256: htp.p(' ');
257: htp.p(rec_get_terr_values.low_value_number);
258: htp.p('
259: htp.p(''); ');
Line 256: htp.p('
');
253: htp.p(' ');
254: htp.p(rec_get_terr_values.comparison_operator);
255: htp.p('
256: htp.p(' ');
257: htp.p(rec_get_terr_values.low_value_number);
258: htp.p('
259: htp.p('');
260: htp.p(rec_get_terr_values.high_value_number);
Line 257: htp.p(rec_get_terr_values.low_value_number);
');
254: htp.p(rec_get_terr_values.comparison_operator);
255: htp.p('
256: htp.p(' ');
257: htp.p(rec_get_terr_values.low_value_number);
258: htp.p('
259: htp.p(''); ');
260: htp.p(rec_get_terr_values.high_value_number);
261: htp.p('
Line 258: htp.p('
255: htp.p('
256: htp.p(' ');
257: htp.p(rec_get_terr_values.low_value_number);
258: htp.p('
259: htp.p(''); ');
260: htp.p(rec_get_terr_values.high_value_number);
261: htp.p('
262: htp.p(' ');
Line 259: htp.p('
'); ');
256: htp.p(' ');
257: htp.p(rec_get_terr_values.low_value_number);
258: htp.p('
259: htp.p(''); ');
260: htp.p(rec_get_terr_values.high_value_number);
261: htp.p('
262: htp.p(' ');
263: htp.p(rec_get_terr_values.currency_code);
Line 260: htp.p(rec_get_terr_values.high_value_number);
');
257: htp.p(rec_get_terr_values.low_value_number);
258: htp.p('
259: htp.p(''); ');
260: htp.p(rec_get_terr_values.high_value_number);
261: htp.p('
262: htp.p(' ');
263: htp.p(rec_get_terr_values.currency_code);
264: htp.p('
Line 261: htp.p('
258: htp.p('
259: htp.p(''); ');
260: htp.p(rec_get_terr_values.high_value_number);
261: htp.p('
262: htp.p(' ');
263: htp.p(rec_get_terr_values.currency_code);
264: htp.p('
265: htp.tableRowClose;
Line 262: htp.p('
');
259: htp.p(''); ');
260: htp.p(rec_get_terr_values.high_value_number);
261: htp.p('
262: htp.p(' ');
263: htp.p(rec_get_terr_values.currency_code);
264: htp.p('
265: htp.tableRowClose;
266: else
Line 263: htp.p(rec_get_terr_values.currency_code);
'); ');
260: htp.p(rec_get_terr_values.high_value_number);
261: htp.p('
262: htp.p(' ');
263: htp.p(rec_get_terr_values.currency_code);
264: htp.p('
265: htp.tableRowClose;
266: else
267: htp.tableRowOpen;
Line 264: htp.p('
261: htp.p('');
262: htp.p(' ');
263: htp.p(rec_get_terr_values.currency_code);
264: htp.p('
265: htp.tableRowClose;
266: else
267: htp.tableRowOpen;
268: htp.p(' ');
Line 265: htp.tableRowClose;
262: htp.p(' ');
263: htp.p(rec_get_terr_values.currency_code);
264: htp.p('
265: htp.tableRowClose;
266: else
267: htp.tableRowOpen;
268: htp.p(' ');
269: htp.p('NO DATA DISPLAYED');
Line 267: htp.tableRowOpen;
264: htp.p('
265: htp.tableRowClose;
266: else
267: htp.tableRowOpen;
268: htp.p(' ');
269: htp.p('NO DATA DISPLAYED');
270: htp.p('
271: htp.tableRowClose;
Line 268: htp.p('
');
265: htp.tableRowClose;
266: else
267: htp.tableRowOpen;
268: htp.p(' ');
269: htp.p('NO DATA DISPLAYED');
270: htp.p('
271: htp.tableRowClose;
272: end if;
Line 269: htp.p('NO DATA DISPLAYED');
266: else
267: htp.tableRowOpen;
268: htp.p(' ');
269: htp.p('NO DATA DISPLAYED');
270: htp.p('
271: htp.tableRowClose;
272: end if;
273: END LOOP;
Line 270: htp.p('');
267: htp.tableRowOpen;
268: htp.p(' ');
269: htp.p('NO DATA DISPLAYED');
270: htp.p('
271: htp.tableRowClose;
272: end if;
273: END LOOP;
274: END LOOP;
Line 271: htp.tableRowClose;
268: htp.p(' ');
269: htp.p('NO DATA DISPLAYED');
270: htp.p('
271: htp.tableRowClose;
272: end if;
273: END LOOP;
274: END LOOP;
275: END LOOP;
Line 277: htp.p('No territories meet search criteria.');
274: END LOOP;
275: END LOOP;
276: If l_rec_count = 0 then
277: htp.p('No territories meet search criteria.');
278: End if;
279:
280: htp.tableClose;
281:
Line 280: htp.tableClose;
277: htp.p('No territories meet search criteria.');
278: End if;
279:
280: htp.tableClose;
281:
282: /*
283: htp.tableOpen (cattributes => 'border="1" width="100%"');
284: htp.tableRowOpen;
Line 283: htp.tableOpen (cattributes => 'border="1" width="100%"');
280: htp.tableClose;
281:
282: /*
283: htp.tableOpen (cattributes => 'border="1" width="100%"');
284: htp.tableRowOpen;
285: htp.p('');
286: htp.p('Territory Name ');
287: htp.p('SalesRep ');
Line 284: htp.tableRowOpen;
281:
282: /*
283: htp.tableOpen (cattributes => 'border="1" width="100%"');
284: htp.tableRowOpen;
285: htp.p('');
286: htp.p('Territory Name ');
287: htp.p('SalesRep ');
288: --htp.p('Group Name ');
Line 285: htp.p('
');
282: /*
283: htp.tableOpen (cattributes => 'border="1" width="100%"');
284: htp.tableRowOpen;
285: htp.p('');
286: htp.p('Territory Name ');
287: htp.p('SalesRep ');
288: --htp.p('Group Name ');
289: htp.p('Territory Type ');
Line 286: htp.p('
Territory Name ');
283: htp.tableOpen (cattributes => 'border="1" width="100%"');
284: htp.tableRowOpen;
285: htp.p('');
286: htp.p('Territory Name ');
287: htp.p('SalesRep ');
288: --htp.p('Group Name ');
289: htp.p('Territory Type ');
290: htp.p('Qualifier Name ');
Line 287: htp.p('
SalesRep ');
284: htp.tableRowOpen;
285: htp.p('');
286: htp.p('Territory Name ');
287: htp.p('SalesRep ');
288: --htp.p('Group Name ');
289: htp.p('Territory Type ');
290: htp.p('Qualifier Name ');
291: htp.p('Value1 ');
Line 288: --htp.p('
Group Name ');
285: htp.p('');
286: htp.p('Territory Name ');
287: htp.p('SalesRep ');
288: --htp.p('Group Name ');
289: htp.p('Territory Type ');
290: htp.p('Qualifier Name ');
291: htp.p('Value1 ');
292: htp.p('Value2 ');
Line 289: htp.p('
Territory Type ');
');
286: htp.p('Territory Name ');
287: htp.p('SalesRep ');
288: --htp.p('Group Name ');
289: htp.p('Territory Type ');
290: htp.p('Qualifier Name ');
291: htp.p('Value1 ');
292: htp.p('Value2 ');
293: htp.p('Created/Updates ');
Line 290: htp.p('
Qualifier Name ');
Territory Name ');
287: htp.p('SalesRep ');
288: --htp.p('Group Name ');
289: htp.p('Territory Type ');
290: htp.p('Qualifier Name ');
291: htp.p('Value1 ');
292: htp.p('Value2 ');
293: htp.p('Created/Updates ');
294: htp.tableRowClose;
Line 291: htp.p('
Value1 ');
SalesRep ');
288: --htp.p('Group Name ');
289: htp.p('Territory Type ');
290: htp.p('Qualifier Name ');
291: htp.p('Value1 ');
292: htp.p('Value2 ');
293: htp.p('Created/Updates ');
294: htp.tableRowClose;
295: -- display territories
Line 292: htp.p('
Value2 ');
Group Name ');
289: htp.p('Territory Type ');
290: htp.p('Qualifier Name ');
291: htp.p('Value1 ');
292: htp.p('Value2 ');
293: htp.p('Created/Updates ');
294: htp.tableRowClose;
295: -- display territories
296: for rec_territory in cur_territory(l_from_date, l_to_date) loop
Line 293: htp.p('
Created/Updates ');
Territory Type ');
290: htp.p('Qualifier Name ');
291: htp.p('Value1 ');
292: htp.p('Value2 ');
293: htp.p('Created/Updates ');
294: htp.tableRowClose;
295: -- display territories
296: for rec_territory in cur_territory(l_from_date, l_to_date) loop
297: htp.tableRowOpen;
Line 294: htp.tableRowClose;
Qualifier Name ');
291: htp.p('Value1 ');
292: htp.p('Value2 ');
293: htp.p('Created/Updates ');
294: htp.tableRowClose;
295: -- display territories
296: for rec_territory in cur_territory(l_from_date, l_to_date) loop
297: htp.tableRowOpen;
298: htp.p('');
Line 297: htp.tableRowOpen;
Created/Updates ');
294: htp.tableRowClose;
295: -- display territories
296: for rec_territory in cur_territory(l_from_date, l_to_date) loop
297: htp.tableRowOpen;
298: htp.p(''); ');
299: htp.p(rec_territory.name||'/' ||rec_territory.terr_id || ' - ' || rec_territory.last_update_date);
300: htp.p('
301: htp.br;
Line 298: htp.p('
');
295: -- display territories
296: for rec_territory in cur_territory(l_from_date, l_to_date) loop
297: htp.tableRowOpen;
298: htp.p(''); ');
299: htp.p(rec_territory.name||'/' ||rec_territory.terr_id || ' - ' || rec_territory.last_update_date);
300: htp.p('
301: htp.br;
302: htp.tableRowClose;
Line 299: htp.p(rec_territory.name||'/' ||rec_territory.terr_id || ' - ' || rec_territory.last_update_date);
296: for rec_territory in cur_territory(l_from_date, l_to_date) loop
297: htp.tableRowOpen;
298: htp.p(''); ');
299: htp.p(rec_territory.name||'/' ||rec_territory.terr_id || ' - ' || rec_territory.last_update_date);
300: htp.p('
301: htp.br;
302: htp.tableRowClose;
303: end loop;
Line 300: htp.p('');
297: htp.tableRowOpen;
298: htp.p(''); ');
299: htp.p(rec_territory.name||'/' ||rec_territory.terr_id || ' - ' || rec_territory.last_update_date);
300: htp.p('
301: htp.br;
302: htp.tableRowClose;
303: end loop;
304:
Line 301: htp.br;
298: htp.p(''); ');
299: htp.p(rec_territory.name||'/' ||rec_territory.terr_id || ' - ' || rec_territory.last_update_date);
300: htp.p('
301: htp.br;
302: htp.tableRowClose;
303: end loop;
304:
305: -- DBMS_SQL.CLOSE_CURSOR(cid);
Line 302: htp.tableRowClose;
'); ');
299: htp.p(rec_territory.name||'/' ||rec_territory.terr_id || ' - ' || rec_territory.last_update_date);
300: htp.p('
301: htp.br;
302: htp.tableRowClose;
303: end loop;
304:
305: -- DBMS_SQL.CLOSE_CURSOR(cid);
306: htp.tableClose;
Line 306: htp.tableClose;
303: end loop;
304:
305: -- DBMS_SQL.CLOSE_CURSOR(cid);
306: htp.tableClose;
307: */
308: htp.Br;
309: -- htp.p(p_count - 1||' records found');
310: htp.bodyClose;
Line 308: htp.Br;
305: -- DBMS_SQL.CLOSE_CURSOR(cid);
306: htp.tableClose;
307: */
308: htp.Br;
309: -- htp.p(p_count - 1||' records found');
310: htp.bodyClose;
311: htp.htmlClose;
312: end if;
Line 309: -- htp.p(p_count - 1||' records found');
306: htp.tableClose;
307: */
308: htp.Br;
309: -- htp.p(p_count - 1||' records found');
310: htp.bodyClose;
311: htp.htmlClose;
312: end if;
313: else
Line 310: htp.bodyClose;
307: */
308: htp.Br;
309: -- htp.p(p_count - 1||' records found');
310: htp.bodyClose;
311: htp.htmlClose;
312: end if;
313: else
314: htp.p('Invalid session');
Line 311: htp.htmlClose;
308: htp.Br;
309: -- htp.p(p_count - 1||' records found');
310: htp.bodyClose;
311: htp.htmlClose;
312: end if;
313: else
314: htp.p('Invalid session');
315: end if;
Line 314: htp.p('Invalid session');
311: htp.htmlClose;
312: end if;
313: else
314: htp.p('Invalid session');
315: end if;
316: -- dbms_session.set_sql_trace(FALSE);
317:
318: EXCEPTION
Line 320: htp.print('Territory Changes Report: No Data Found!!!');
317:
318: EXCEPTION
319: when no_data_found then
320: htp.print('Territory Changes Report: No Data Found!!!');
321: when others then
322: htp.print('report_wrapper: ' || substr(SQLERRM, 1,200));
323: END;
324:
Line 322: htp.print('report_wrapper: ' || substr(SQLERRM, 1,200));
319: when no_data_found then
320: htp.print('Territory Changes Report: No Data Found!!!');
321: when others then
322: htp.print('report_wrapper: ' || substr(SQLERRM, 1,200));
323: END;
324:
325: ----------------------------------------------------------------------------------------------------------------------
326: PROCEDURE XLS (
Line 398: --htp.p(v_tabrow);
395: INTO v_tab
396: from dual;
397:
398: --htp.p(v_tabrow);
399: v_tabrow := null;
400: -- display territories
401: l_rec_count := 0;
402:
Line 407: htp.p(v_tabrow);
404: /*
405: if cur_territory%rowcount > 1 then
406: v_tabrow := v_tabrow||' '||v_tab;
407: htp.p(v_tabrow);
408: htp.p(v_tabrow);
409: v_tabrow := null;
410: end if;
411: */
Line 408: htp.p(v_tabrow);
405: if cur_territory%rowcount > 1 then
406: v_tabrow := v_tabrow||' '||v_tab;
407: htp.p(v_tabrow);
408: htp.p(v_tabrow);
409: v_tabrow := null;
410: end if;
411: */
412: v_tabrow := null;
Line 413: htp.p(v_tabrow); -- add a blank before each territory
410: end if;
411: */
412: v_tabrow := null;
413: htp.p(v_tabrow); -- add a blank before each territory
414: v_tabrow := null;
415: v_tabrow := v_tabrow||rec_terr.name||v_tab;
416: v_tabrow := v_tabrow||'Rank: '||rec_terr.rank||v_tab;
417: v_tabrow := v_tabrow||'Type: '||rec_terr.terr_type_name||v_tab;
Line 419: htp.p(v_tabrow); -- print out prepared line
416: v_tabrow := v_tabrow||'Rank: '||rec_terr.rank||v_tab;
417: v_tabrow := v_tabrow||'Type: '||rec_terr.terr_type_name||v_tab;
418: v_tabrow := v_tabrow||'Created: '||rec_terr.creation_date||' Updated: '||rec_terr.last_update_date||v_tab;
419: htp.p(v_tabrow); -- print out prepared line
420: v_tabrow := null;
421: v_tabrow := v_tabrow||h1_divider||v_tab;
422: v_tabrow := v_tabrow||h1_divider||v_tab;
423: v_tabrow := v_tabrow||h1_divider||v_tab;
Line 425: htp.p(v_tabrow); -- divider since we dont' know how to format rows in XLS
422: v_tabrow := v_tabrow||h1_divider||v_tab;
423: v_tabrow := v_tabrow||h1_divider||v_tab;
424: v_tabrow := v_tabrow||h1_divider||v_tab;
425: htp.p(v_tabrow); -- divider since we dont' know how to format rows in XLS
426: -- display sales reps
427: l_counter2 := 0;
428: FOR rec_get_salesrep in c_get_salesrep(rec_terr.terr_id) loop
429: l_counter2 := l_counter2 + 1;
Line 434: htp.p(v_tabrow);
431: v_tabrow := v_tabrow||rec_get_salesrep.resource_name||v_tab;
432: --v_tabrow := v_tabrow||rec_get_salesrep.resource_name||'l_counter2: '||l_counter2||v_tab;
433: --v_tabrow := v_tabrow||rec_get_salesrep.resource_id||v_tab;
434: htp.p(v_tabrow);
435: END LOOP;
436: v_tabrow := null;
437: v_tabrow := v_tabrow||h2_divider||v_tab;
438: htp.p(v_tabrow);
Line 438: htp.p(v_tabrow);
435: END LOOP;
436: v_tabrow := null;
437: v_tabrow := v_tabrow||h2_divider||v_tab;
438: htp.p(v_tabrow);
439: -- display qualifiers
440: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
441: v_tabrow := null;
442: htp.p(v_tabrow); -- put in a CR before each qualifier
Line 442: htp.p(v_tabrow); -- put in a CR before each qualifier
439: -- display qualifiers
440: FOR rec_get_terr_qual in c_get_terr_qual(rec_terr.terr_id) loop
441: v_tabrow := null;
442: htp.p(v_tabrow); -- put in a CR before each qualifier
443: v_tabrow := null;
444: v_tabrow := v_tabrow||rec_get_terr_qual.qualifier_name||v_tab;
445: --v_tabrow := v_tabrow||rec_get_terr_qual.terr_qual_id||v_tab;
446: htp.p(v_tabrow);
Line 446: htp.p(v_tabrow);
443: v_tabrow := null;
444: v_tabrow := v_tabrow||rec_get_terr_qual.qualifier_name||v_tab;
445: --v_tabrow := v_tabrow||rec_get_terr_qual.terr_qual_id||v_tab;
446: htp.p(v_tabrow);
447: v_tabrow := null;
448: v_tabrow := v_tabrow||h3_divider||v_tab;
449: htp.p(v_tabrow);
450:
Line 449: htp.p(v_tabrow);
446: htp.p(v_tabrow);
447: v_tabrow := null;
448: v_tabrow := v_tabrow||h3_divider||v_tab;
449: htp.p(v_tabrow);
450:
451: -- display qualifier values
452: l_counter := 0;
453: FOR rec_get_terr_values in c_get_terr_values(rec_get_terr_qual.terr_qual_id) loop
Line 465: htp.p(v_tabrow);
462: v_tabrow := v_tabrow||rec_get_terr_values.low_value_char_desc||v_tab;
463: --v_tabrow := v_tabrow||rec_get_terr_values.low_value_char_id|| 'CHAR_Y l_counter:'||l_counter|| v_tab;
464: v_tabrow := v_tabrow||rec_get_terr_values.low_value_char_id||v_tab;
465: htp.p(v_tabrow);
466: else -- (l_convert_to_id_flag = 'N')
467: v_tabrow := null;
468: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
469: v_tabrow := v_tabrow||rec_get_terr_values.low_value_char_desc||v_tab;
Line 472: htp.p(v_tabrow);
469: v_tabrow := v_tabrow||rec_get_terr_values.low_value_char_desc||v_tab;
470: --v_tabrow := v_tabrow||rec_get_terr_values.high_value_char_desc|| 'CHAR_N l_counter:'||l_counter|| v_tab;
471: v_tabrow := v_tabrow||rec_get_terr_values.high_value_char_desc||v_tab;
472: htp.p(v_tabrow);
473: End if;
474: elsif (l_display_type = 'INTEREST_TYPE') then
475: v_tabrow := null;
476: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
Line 481: htp.p(v_tabrow);
478: v_tabrow := v_tabrow||rec_get_terr_values.primary_interest_code||v_tab;
479: --v_tabrow := v_tabrow||rec_get_terr_values.secondary_interest_code|| 'INT_T l_counter:'||l_counter|| v_tab;
480: v_tabrow := v_tabrow||rec_get_terr_values.secondary_interest_code||v_tab;
481: htp.p(v_tabrow);
482: elsif (l_display_type = 'NUMBER') then
483: v_tabrow := null;
484: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
485: v_tabrow := v_tabrow||rec_get_terr_values.low_value_number||v_tab;
Line 488: htp.p(v_tabrow);
485: v_tabrow := v_tabrow||rec_get_terr_values.low_value_number||v_tab;
486: --v_tabrow := v_tabrow||rec_get_terr_values.high_value_number|| 'NUM l_counter:'||l_counter|| v_tab;
487: v_tabrow := v_tabrow||rec_get_terr_values.high_value_number||v_tab;
488: htp.p(v_tabrow);
489: elsif (l_display_type = 'CURRENCY') then
490: v_tabrow := null;
491: v_tabrow := v_tabrow||rec_get_terr_values.comparison_operator||v_tab;
492: v_tabrow := v_tabrow||rec_get_terr_values.low_value_number||v_tab;
Line 496: htp.p(v_tabrow);
493: v_tabrow := v_tabrow||rec_get_terr_values.high_value_number||v_tab;
494: --v_tabrow := v_tabrow||rec_get_terr_values.currency_code|| 'CUR l_counter:'||l_counter|| v_tab;
495: v_tabrow := v_tabrow||rec_get_terr_values.currency_code||v_tab;
496: htp.p(v_tabrow);
497: else
498: v_tabrow := null;
499: v_tabrow := v_tabrow||'NO DATA DISPLAYED'||v_tab;
500: htp.p(v_tabrow);
Line 500: htp.p(v_tabrow);
497: else
498: v_tabrow := null;
499: v_tabrow := v_tabrow||'NO DATA DISPLAYED'||v_tab;
500: htp.p(v_tabrow);
501: end if;
502: END LOOP;
503: END LOOP;
504: END LOOP;
Line 508: htp.p(v_tabrow);
505: If l_rec_count = 0 then
506: v_tabrow := null;
507: v_tabrow := v_tabrow||'No territories meet search criteria.'||v_tab;
508: htp.p(v_tabrow);
509: End if;
510:
511:
512: exception
Line 514: htp.print('Territory Changes excel: No Data Found!!!');
511:
512: exception
513: when no_data_found then
514: htp.print('Territory Changes excel: No Data Found!!!');
515: when others then
516: htp.print('Territory Changes excel: '||substr(SQLERRM, 1,200));
517: END XLS;
518:
Line 516: htp.print('Territory Changes excel: '||substr(SQLERRM, 1,200));
513: when no_data_found then
514: htp.print('Territory Changes excel: No Data Found!!!');
515: when others then
516: htp.print('Territory Changes excel: '||substr(SQLERRM, 1,200));
517: END XLS;
518:
519:
520: END;