266:
267: --This set-up of the CLOB must be done
268: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
269: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
270: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
271:
272: JTF_DIAGNOSTIC_COREAPI.line_out('SUMMARY WARNING INFORMATION');
273: JTF_DIAGNOSTIC_COREAPI.line_out('========================================================');
274: JTF_DIAGNOSTIC_COREAPI.brprint;
268: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
269: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
270: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
271:
272: JTF_DIAGNOSTIC_COREAPI.line_out('SUMMARY WARNING INFORMATION');
273: JTF_DIAGNOSTIC_COREAPI.line_out('========================================================');
274: JTF_DIAGNOSTIC_COREAPI.brprint;
275: JTF_DIAGNOSTIC_COREAPI.brprint;
276:
269: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
270: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
271:
272: JTF_DIAGNOSTIC_COREAPI.line_out('SUMMARY WARNING INFORMATION');
273: JTF_DIAGNOSTIC_COREAPI.line_out('========================================================');
274: JTF_DIAGNOSTIC_COREAPI.brprint;
275: JTF_DIAGNOSTIC_COREAPI.brprint;
276:
277: for sources in C_Usages loop
270: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
271:
272: JTF_DIAGNOSTIC_COREAPI.line_out('SUMMARY WARNING INFORMATION');
273: JTF_DIAGNOSTIC_COREAPI.line_out('========================================================');
274: JTF_DIAGNOSTIC_COREAPI.brprint;
275: JTF_DIAGNOSTIC_COREAPI.brprint;
276:
277: for sources in C_Usages loop
278:
271:
272: JTF_DIAGNOSTIC_COREAPI.line_out('SUMMARY WARNING INFORMATION');
273: JTF_DIAGNOSTIC_COREAPI.line_out('========================================================');
274: JTF_DIAGNOSTIC_COREAPI.brprint;
275: JTF_DIAGNOSTIC_COREAPI.brprint;
276:
277: for sources in C_Usages loop
278:
279: l_source_id := sources.source_id;
280: l_lookup_code := sources.lookup_code;
281: l_meaning := sources.meaning;
282:
283: --show warnings for each usage here
284: JTF_DIAGNOSTIC_COREAPI.line_out(' WARNINGS for '||l_meaning);
285: JTF_DIAGNOSTIC_COREAPI.brprint;
286: JTF_DIAGNOSTIC_COREAPI.line_out(' ------------------------------------------------------------');
287: JTF_DIAGNOSTIC_COREAPI.brprint;
288:
281: l_meaning := sources.meaning;
282:
283: --show warnings for each usage here
284: JTF_DIAGNOSTIC_COREAPI.line_out(' WARNINGS for '||l_meaning);
285: JTF_DIAGNOSTIC_COREAPI.brprint;
286: JTF_DIAGNOSTIC_COREAPI.line_out(' ------------------------------------------------------------');
287: JTF_DIAGNOSTIC_COREAPI.brprint;
288:
289: JTF_DIAGNOSTIC_COREAPI.line_out(' 1. '||l_meaning||' qualifiers using non-performant operators: ');
282:
283: --show warnings for each usage here
284: JTF_DIAGNOSTIC_COREAPI.line_out(' WARNINGS for '||l_meaning);
285: JTF_DIAGNOSTIC_COREAPI.brprint;
286: JTF_DIAGNOSTIC_COREAPI.line_out(' ------------------------------------------------------------');
287: JTF_DIAGNOSTIC_COREAPI.brprint;
288:
289: JTF_DIAGNOSTIC_COREAPI.line_out(' 1. '||l_meaning||' qualifiers using non-performant operators: ');
290:
283: --show warnings for each usage here
284: JTF_DIAGNOSTIC_COREAPI.line_out(' WARNINGS for '||l_meaning);
285: JTF_DIAGNOSTIC_COREAPI.brprint;
286: JTF_DIAGNOSTIC_COREAPI.line_out(' ------------------------------------------------------------');
287: JTF_DIAGNOSTIC_COREAPI.brprint;
288:
289: JTF_DIAGNOSTIC_COREAPI.line_out(' 1. '||l_meaning||' qualifiers using non-performant operators: ');
290:
291: for vals_in_system in C_values_in_system_warnings(l_source_id)
285: JTF_DIAGNOSTIC_COREAPI.brprint;
286: JTF_DIAGNOSTIC_COREAPI.line_out(' ------------------------------------------------------------');
287: JTF_DIAGNOSTIC_COREAPI.brprint;
288:
289: JTF_DIAGNOSTIC_COREAPI.line_out(' 1. '||l_meaning||' qualifiers using non-performant operators: ');
290:
291: for vals_in_system in C_values_in_system_warnings(l_source_id)
292: loop
293: if C_values_in_system_warnings%notfound
291: for vals_in_system in C_values_in_system_warnings(l_source_id)
292: loop
293: if C_values_in_system_warnings%notfound
294: then
295: JTF_DIAGNOSTIC_COREAPI.line_out('NONE');
296: end if;
297: JTF_DIAGNOSTIC_COREAPI.brprint;
298: JTF_DIAGNOSTIC_COREAPI.line_out(' Territory = ' ||vals_in_system.terr_name ||'; Qualifier = ' || vals_in_system.qual_name);
299: JTF_DIAGNOSTIC_COREAPI.brprint;
293: if C_values_in_system_warnings%notfound
294: then
295: JTF_DIAGNOSTIC_COREAPI.line_out('NONE');
296: end if;
297: JTF_DIAGNOSTIC_COREAPI.brprint;
298: JTF_DIAGNOSTIC_COREAPI.line_out(' Territory = ' ||vals_in_system.terr_name ||'; Qualifier = ' || vals_in_system.qual_name);
299: JTF_DIAGNOSTIC_COREAPI.brprint;
300: JTF_DIAGNOSTIC_COREAPI.line_out(' ' ||
301: ' ' ||
294: then
295: JTF_DIAGNOSTIC_COREAPI.line_out('NONE');
296: end if;
297: JTF_DIAGNOSTIC_COREAPI.brprint;
298: JTF_DIAGNOSTIC_COREAPI.line_out(' Territory = ' ||vals_in_system.terr_name ||'; Qualifier = ' || vals_in_system.qual_name);
299: JTF_DIAGNOSTIC_COREAPI.brprint;
300: JTF_DIAGNOSTIC_COREAPI.line_out(' ' ||
301: ' ' ||
302: ' Operator = '''|| vals_in_system.operator||'''');
295: JTF_DIAGNOSTIC_COREAPI.line_out('NONE');
296: end if;
297: JTF_DIAGNOSTIC_COREAPI.brprint;
298: JTF_DIAGNOSTIC_COREAPI.line_out(' Territory = ' ||vals_in_system.terr_name ||'; Qualifier = ' || vals_in_system.qual_name);
299: JTF_DIAGNOSTIC_COREAPI.brprint;
300: JTF_DIAGNOSTIC_COREAPI.line_out(' ' ||
301: ' ' ||
302: ' Operator = '''|| vals_in_system.operator||'''');
303: end loop;
296: end if;
297: JTF_DIAGNOSTIC_COREAPI.brprint;
298: JTF_DIAGNOSTIC_COREAPI.line_out(' Territory = ' ||vals_in_system.terr_name ||'; Qualifier = ' || vals_in_system.qual_name);
299: JTF_DIAGNOSTIC_COREAPI.brprint;
300: JTF_DIAGNOSTIC_COREAPI.line_out(' ' ||
301: ' ' ||
302: ' Operator = '''|| vals_in_system.operator||'''');
303: end loop;
304: JTF_DIAGNOSTIC_COREAPI.brprint;
300: JTF_DIAGNOSTIC_COREAPI.line_out(' ' ||
301: ' ' ||
302: ' Operator = '''|| vals_in_system.operator||'''');
303: end loop;
304: JTF_DIAGNOSTIC_COREAPI.brprint;
305: JTF_DIAGNOSTIC_COREAPI.brprint;
306:
307: select count(*)
308: into l_percent_count
301: ' ' ||
302: ' Operator = '''|| vals_in_system.operator||'''');
303: end loop;
304: JTF_DIAGNOSTIC_COREAPI.brprint;
305: JTF_DIAGNOSTIC_COREAPI.brprint;
306:
307: select count(*)
308: into l_percent_count
309: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq
319: and jqu.org_id = -3113
320: and SUBSTR(jtv.low_value_char,0,1) = '%'
321: and jtv.comparison_operator = 'LIKE';
322:
323: JTF_DIAGNOSTIC_COREAPI.line_out(' 2. No. of '||l_meaning||' qualifier values using % as a first char = '||l_percent_count);
324: JTF_DIAGNOSTIC_COREAPI.brprint;
325: JTF_DIAGNOSTIC_COREAPI.brprint;
326:
327:
320: and SUBSTR(jtv.low_value_char,0,1) = '%'
321: and jtv.comparison_operator = 'LIKE';
322:
323: JTF_DIAGNOSTIC_COREAPI.line_out(' 2. No. of '||l_meaning||' qualifier values using % as a first char = '||l_percent_count);
324: JTF_DIAGNOSTIC_COREAPI.brprint;
325: JTF_DIAGNOSTIC_COREAPI.brprint;
326:
327:
328:
321: and jtv.comparison_operator = 'LIKE';
322:
323: JTF_DIAGNOSTIC_COREAPI.line_out(' 2. No. of '||l_meaning||' qualifier values using % as a first char = '||l_percent_count);
324: JTF_DIAGNOSTIC_COREAPI.brprint;
325: JTF_DIAGNOSTIC_COREAPI.brprint;
326:
327:
328:
329: end loop;
327:
328:
329: end loop;
330:
331: JTF_DIAGNOSTIC_COREAPI.brprint;
332:
333: JTF_DIAGNOSTIC_COREAPI.line_out('GENERAL INFORMATION');
334: JTF_DIAGNOSTIC_COREAPI.line_out('========================================================');
335: JTF_DIAGNOSTIC_COREAPI.brprint;
329: end loop;
330:
331: JTF_DIAGNOSTIC_COREAPI.brprint;
332:
333: JTF_DIAGNOSTIC_COREAPI.line_out('GENERAL INFORMATION');
334: JTF_DIAGNOSTIC_COREAPI.line_out('========================================================');
335: JTF_DIAGNOSTIC_COREAPI.brprint;
336: JTF_DIAGNOSTIC_COREAPI.brprint;
337:
330:
331: JTF_DIAGNOSTIC_COREAPI.brprint;
332:
333: JTF_DIAGNOSTIC_COREAPI.line_out('GENERAL INFORMATION');
334: JTF_DIAGNOSTIC_COREAPI.line_out('========================================================');
335: JTF_DIAGNOSTIC_COREAPI.brprint;
336: JTF_DIAGNOSTIC_COREAPI.brprint;
337:
338: --Total Number of Parties
331: JTF_DIAGNOSTIC_COREAPI.brprint;
332:
333: JTF_DIAGNOSTIC_COREAPI.line_out('GENERAL INFORMATION');
334: JTF_DIAGNOSTIC_COREAPI.line_out('========================================================');
335: JTF_DIAGNOSTIC_COREAPI.brprint;
336: JTF_DIAGNOSTIC_COREAPI.brprint;
337:
338: --Total Number of Parties
339: --===========================
332:
333: JTF_DIAGNOSTIC_COREAPI.line_out('GENERAL INFORMATION');
334: JTF_DIAGNOSTIC_COREAPI.line_out('========================================================');
335: JTF_DIAGNOSTIC_COREAPI.brprint;
336: JTF_DIAGNOSTIC_COREAPI.brprint;
337:
338: --Total Number of Parties
339: --===========================
340: SELECT COUNT(*)
340: SELECT COUNT(*)
341: into l_parties
342: FROM hz_parties;
343:
344: JTF_DIAGNOSTIC_COREAPI.line_out(' Total Number of Parties = '||l_parties);
345: JTF_DIAGNOSTIC_COREAPI.brprint;
346: JTF_DIAGNOSTIC_COREAPI.brprint;
347:
348: --Total Number of Party Sites
341: into l_parties
342: FROM hz_parties;
343:
344: JTF_DIAGNOSTIC_COREAPI.line_out(' Total Number of Parties = '||l_parties);
345: JTF_DIAGNOSTIC_COREAPI.brprint;
346: JTF_DIAGNOSTIC_COREAPI.brprint;
347:
348: --Total Number of Party Sites
349: --================================
342: FROM hz_parties;
343:
344: JTF_DIAGNOSTIC_COREAPI.line_out(' Total Number of Parties = '||l_parties);
345: JTF_DIAGNOSTIC_COREAPI.brprint;
346: JTF_DIAGNOSTIC_COREAPI.brprint;
347:
348: --Total Number of Party Sites
349: --================================
350: SELECT COUNT(*)
350: SELECT COUNT(*)
351: into l_party_sites
352: FROM hz_party_sites;
353:
354: JTF_DIAGNOSTIC_COREAPI.line_out(' Total Number of Party Sites = '||l_party_sites);
355: JTF_DIAGNOSTIC_COREAPI.brprint;
356: JTF_DIAGNOSTIC_COREAPI.brprint;
357:
358: --Total Number of Locations
351: into l_party_sites
352: FROM hz_party_sites;
353:
354: JTF_DIAGNOSTIC_COREAPI.line_out(' Total Number of Party Sites = '||l_party_sites);
355: JTF_DIAGNOSTIC_COREAPI.brprint;
356: JTF_DIAGNOSTIC_COREAPI.brprint;
357:
358: --Total Number of Locations
359: --==============================
352: FROM hz_party_sites;
353:
354: JTF_DIAGNOSTIC_COREAPI.line_out(' Total Number of Party Sites = '||l_party_sites);
355: JTF_DIAGNOSTIC_COREAPI.brprint;
356: JTF_DIAGNOSTIC_COREAPI.brprint;
357:
358: --Total Number of Locations
359: --==============================
360: SELECT COUNT(*)
360: SELECT COUNT(*)
361: into l_locations
362: FROM hz_locations;
363:
364: JTF_DIAGNOSTIC_COREAPI.line_out( ' Total Number of Locations = '||l_locations);
365: JTF_DIAGNOSTIC_COREAPI.brprint;
366: JTF_DIAGNOSTIC_COREAPI.brprint;
367:
368: JTF_DIAGNOSTIC_COREAPI.brprint;
361: into l_locations
362: FROM hz_locations;
363:
364: JTF_DIAGNOSTIC_COREAPI.line_out( ' Total Number of Locations = '||l_locations);
365: JTF_DIAGNOSTIC_COREAPI.brprint;
366: JTF_DIAGNOSTIC_COREAPI.brprint;
367:
368: JTF_DIAGNOSTIC_COREAPI.brprint;
369:
362: FROM hz_locations;
363:
364: JTF_DIAGNOSTIC_COREAPI.line_out( ' Total Number of Locations = '||l_locations);
365: JTF_DIAGNOSTIC_COREAPI.brprint;
366: JTF_DIAGNOSTIC_COREAPI.brprint;
367:
368: JTF_DIAGNOSTIC_COREAPI.brprint;
369:
370: -- for Usage specific information
364: JTF_DIAGNOSTIC_COREAPI.line_out( ' Total Number of Locations = '||l_locations);
365: JTF_DIAGNOSTIC_COREAPI.brprint;
366: JTF_DIAGNOSTIC_COREAPI.brprint;
367:
368: JTF_DIAGNOSTIC_COREAPI.brprint;
369:
370: -- for Usage specific information
371: for sources in C_Usages loop
372:
373: l_source_id := sources.source_id;
374: l_lookup_code := sources.lookup_code;
375: l_meaning := sources.meaning;
376:
377: JTF_DIAGNOSTIC_COREAPI.line_out('USAGE: '||l_meaning);
378: JTF_DIAGNOSTIC_COREAPI.line_out('========================================================');
379: JTF_DIAGNOSTIC_COREAPI.brprint;
380: JTF_DIAGNOSTIC_COREAPI.brprint;
381:
374: l_lookup_code := sources.lookup_code;
375: l_meaning := sources.meaning;
376:
377: JTF_DIAGNOSTIC_COREAPI.line_out('USAGE: '||l_meaning);
378: JTF_DIAGNOSTIC_COREAPI.line_out('========================================================');
379: JTF_DIAGNOSTIC_COREAPI.brprint;
380: JTF_DIAGNOSTIC_COREAPI.brprint;
381:
382: --show warnings for each usage here
375: l_meaning := sources.meaning;
376:
377: JTF_DIAGNOSTIC_COREAPI.line_out('USAGE: '||l_meaning);
378: JTF_DIAGNOSTIC_COREAPI.line_out('========================================================');
379: JTF_DIAGNOSTIC_COREAPI.brprint;
380: JTF_DIAGNOSTIC_COREAPI.brprint;
381:
382: --show warnings for each usage here
383: JTF_DIAGNOSTIC_COREAPI.line_out(' WARNINGS');
376:
377: JTF_DIAGNOSTIC_COREAPI.line_out('USAGE: '||l_meaning);
378: JTF_DIAGNOSTIC_COREAPI.line_out('========================================================');
379: JTF_DIAGNOSTIC_COREAPI.brprint;
380: JTF_DIAGNOSTIC_COREAPI.brprint;
381:
382: --show warnings for each usage here
383: JTF_DIAGNOSTIC_COREAPI.line_out(' WARNINGS');
384: JTF_DIAGNOSTIC_COREAPI.brprint;
379: JTF_DIAGNOSTIC_COREAPI.brprint;
380: JTF_DIAGNOSTIC_COREAPI.brprint;
381:
382: --show warnings for each usage here
383: JTF_DIAGNOSTIC_COREAPI.line_out(' WARNINGS');
384: JTF_DIAGNOSTIC_COREAPI.brprint;
385: JTF_DIAGNOSTIC_COREAPI.line_out(' --------------------------------------------------------');
386: JTF_DIAGNOSTIC_COREAPI.brprint;
387:
380: JTF_DIAGNOSTIC_COREAPI.brprint;
381:
382: --show warnings for each usage here
383: JTF_DIAGNOSTIC_COREAPI.line_out(' WARNINGS');
384: JTF_DIAGNOSTIC_COREAPI.brprint;
385: JTF_DIAGNOSTIC_COREAPI.line_out(' --------------------------------------------------------');
386: JTF_DIAGNOSTIC_COREAPI.brprint;
387:
388: JTF_DIAGNOSTIC_COREAPI.line_out(' 1. '||l_meaning||' qualifiers using non-performant operators: ');
381:
382: --show warnings for each usage here
383: JTF_DIAGNOSTIC_COREAPI.line_out(' WARNINGS');
384: JTF_DIAGNOSTIC_COREAPI.brprint;
385: JTF_DIAGNOSTIC_COREAPI.line_out(' --------------------------------------------------------');
386: JTF_DIAGNOSTIC_COREAPI.brprint;
387:
388: JTF_DIAGNOSTIC_COREAPI.line_out(' 1. '||l_meaning||' qualifiers using non-performant operators: ');
389:
382: --show warnings for each usage here
383: JTF_DIAGNOSTIC_COREAPI.line_out(' WARNINGS');
384: JTF_DIAGNOSTIC_COREAPI.brprint;
385: JTF_DIAGNOSTIC_COREAPI.line_out(' --------------------------------------------------------');
386: JTF_DIAGNOSTIC_COREAPI.brprint;
387:
388: JTF_DIAGNOSTIC_COREAPI.line_out(' 1. '||l_meaning||' qualifiers using non-performant operators: ');
389:
390: for vals_in_system in C_values_in_system_warnings(l_source_id)
384: JTF_DIAGNOSTIC_COREAPI.brprint;
385: JTF_DIAGNOSTIC_COREAPI.line_out(' --------------------------------------------------------');
386: JTF_DIAGNOSTIC_COREAPI.brprint;
387:
388: JTF_DIAGNOSTIC_COREAPI.line_out(' 1. '||l_meaning||' qualifiers using non-performant operators: ');
389:
390: for vals_in_system in C_values_in_system_warnings(l_source_id)
391: loop
392: JTF_DIAGNOSTIC_COREAPI.brprint;
388: JTF_DIAGNOSTIC_COREAPI.line_out(' 1. '||l_meaning||' qualifiers using non-performant operators: ');
389:
390: for vals_in_system in C_values_in_system_warnings(l_source_id)
391: loop
392: JTF_DIAGNOSTIC_COREAPI.brprint;
393: JTF_DIAGNOSTIC_COREAPI.line_out(' Territory = ' ||vals_in_system.terr_name ||'; Qualifier = ' || vals_in_system.qual_name);
394: JTF_DIAGNOSTIC_COREAPI.brprint;
395: JTF_DIAGNOSTIC_COREAPI.line_out(' ' ||
396: ' ' ||
389:
390: for vals_in_system in C_values_in_system_warnings(l_source_id)
391: loop
392: JTF_DIAGNOSTIC_COREAPI.brprint;
393: JTF_DIAGNOSTIC_COREAPI.line_out(' Territory = ' ||vals_in_system.terr_name ||'; Qualifier = ' || vals_in_system.qual_name);
394: JTF_DIAGNOSTIC_COREAPI.brprint;
395: JTF_DIAGNOSTIC_COREAPI.line_out(' ' ||
396: ' ' ||
397: ' Operator = '''|| vals_in_system.operator||'''');
390: for vals_in_system in C_values_in_system_warnings(l_source_id)
391: loop
392: JTF_DIAGNOSTIC_COREAPI.brprint;
393: JTF_DIAGNOSTIC_COREAPI.line_out(' Territory = ' ||vals_in_system.terr_name ||'; Qualifier = ' || vals_in_system.qual_name);
394: JTF_DIAGNOSTIC_COREAPI.brprint;
395: JTF_DIAGNOSTIC_COREAPI.line_out(' ' ||
396: ' ' ||
397: ' Operator = '''|| vals_in_system.operator||'''');
398: end loop;
391: loop
392: JTF_DIAGNOSTIC_COREAPI.brprint;
393: JTF_DIAGNOSTIC_COREAPI.line_out(' Territory = ' ||vals_in_system.terr_name ||'; Qualifier = ' || vals_in_system.qual_name);
394: JTF_DIAGNOSTIC_COREAPI.brprint;
395: JTF_DIAGNOSTIC_COREAPI.line_out(' ' ||
396: ' ' ||
397: ' Operator = '''|| vals_in_system.operator||'''');
398: end loop;
399: JTF_DIAGNOSTIC_COREAPI.brprint;
395: JTF_DIAGNOSTIC_COREAPI.line_out(' ' ||
396: ' ' ||
397: ' Operator = '''|| vals_in_system.operator||'''');
398: end loop;
399: JTF_DIAGNOSTIC_COREAPI.brprint;
400: JTF_DIAGNOSTIC_COREAPI.brprint;
401:
402: select count(*)
403: into l_percent_count
396: ' ' ||
397: ' Operator = '''|| vals_in_system.operator||'''');
398: end loop;
399: JTF_DIAGNOSTIC_COREAPI.brprint;
400: JTF_DIAGNOSTIC_COREAPI.brprint;
401:
402: select count(*)
403: into l_percent_count
404: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq
414: and jqu.org_id = -3113
415: and SUBSTR(jtv.low_value_char,0,1) = '%'
416: and jtv.comparison_operator = 'LIKE';
417:
418: JTF_DIAGNOSTIC_COREAPI.line_out(' 2. No. of '||l_meaning||' qualifier values using % as a first char = '||l_percent_count);
419: JTF_DIAGNOSTIC_COREAPI.brprint;
420: JTF_DIAGNOSTIC_COREAPI.brprint;
421:
422: --show other informational info here...
415: and SUBSTR(jtv.low_value_char,0,1) = '%'
416: and jtv.comparison_operator = 'LIKE';
417:
418: JTF_DIAGNOSTIC_COREAPI.line_out(' 2. No. of '||l_meaning||' qualifier values using % as a first char = '||l_percent_count);
419: JTF_DIAGNOSTIC_COREAPI.brprint;
420: JTF_DIAGNOSTIC_COREAPI.brprint;
421:
422: --show other informational info here...
423: JTF_DIAGNOSTIC_COREAPI.line_out(' ADDITIONAL INFORMATION');
416: and jtv.comparison_operator = 'LIKE';
417:
418: JTF_DIAGNOSTIC_COREAPI.line_out(' 2. No. of '||l_meaning||' qualifier values using % as a first char = '||l_percent_count);
419: JTF_DIAGNOSTIC_COREAPI.brprint;
420: JTF_DIAGNOSTIC_COREAPI.brprint;
421:
422: --show other informational info here...
423: JTF_DIAGNOSTIC_COREAPI.line_out(' ADDITIONAL INFORMATION');
424: JTF_DIAGNOSTIC_COREAPI.brprint;
419: JTF_DIAGNOSTIC_COREAPI.brprint;
420: JTF_DIAGNOSTIC_COREAPI.brprint;
421:
422: --show other informational info here...
423: JTF_DIAGNOSTIC_COREAPI.line_out(' ADDITIONAL INFORMATION');
424: JTF_DIAGNOSTIC_COREAPI.brprint;
425: JTF_DIAGNOSTIC_COREAPI.line_out(' --------------------------------------------------------');
426: JTF_DIAGNOSTIC_COREAPI.brprint;
427:
420: JTF_DIAGNOSTIC_COREAPI.brprint;
421:
422: --show other informational info here...
423: JTF_DIAGNOSTIC_COREAPI.line_out(' ADDITIONAL INFORMATION');
424: JTF_DIAGNOSTIC_COREAPI.brprint;
425: JTF_DIAGNOSTIC_COREAPI.line_out(' --------------------------------------------------------');
426: JTF_DIAGNOSTIC_COREAPI.brprint;
427:
428: --#1. Number of ACTIVE Territories
421:
422: --show other informational info here...
423: JTF_DIAGNOSTIC_COREAPI.line_out(' ADDITIONAL INFORMATION');
424: JTF_DIAGNOSTIC_COREAPI.brprint;
425: JTF_DIAGNOSTIC_COREAPI.line_out(' --------------------------------------------------------');
426: JTF_DIAGNOSTIC_COREAPI.brprint;
427:
428: --#1. Number of ACTIVE Territories
429: --======================================
422: --show other informational info here...
423: JTF_DIAGNOSTIC_COREAPI.line_out(' ADDITIONAL INFORMATION');
424: JTF_DIAGNOSTIC_COREAPI.brprint;
425: JTF_DIAGNOSTIC_COREAPI.line_out(' --------------------------------------------------------');
426: JTF_DIAGNOSTIC_COREAPI.brprint;
427:
428: --#1. Number of ACTIVE Territories
429: --======================================
430: select count(*)
434: and jtua.source_id = l_source_id
435: and jta.start_date_active <= SYSDATE
436: AND NVL(jta.end_date_active, SYSDATE) >= SYSDATE;
437:
438: JTF_DIAGNOSTIC_COREAPI.line_out(' 1. Number of ACTIVE '||l_meaning||' Territories = '||l_active_sales_terrs);
439: JTF_DIAGNOSTIC_COREAPI.brprint;
440: JTF_DIAGNOSTIC_COREAPI.brprint;
441:
442: --#2. Number of VALID Territories for Assignment
435: and jta.start_date_active <= SYSDATE
436: AND NVL(jta.end_date_active, SYSDATE) >= SYSDATE;
437:
438: JTF_DIAGNOSTIC_COREAPI.line_out(' 1. Number of ACTIVE '||l_meaning||' Territories = '||l_active_sales_terrs);
439: JTF_DIAGNOSTIC_COREAPI.brprint;
440: JTF_DIAGNOSTIC_COREAPI.brprint;
441:
442: --#2. Number of VALID Territories for Assignment
443: --====================================================
436: AND NVL(jta.end_date_active, SYSDATE) >= SYSDATE;
437:
438: JTF_DIAGNOSTIC_COREAPI.line_out(' 1. Number of ACTIVE '||l_meaning||' Territories = '||l_active_sales_terrs);
439: JTF_DIAGNOSTIC_COREAPI.brprint;
440: JTF_DIAGNOSTIC_COREAPI.brprint;
441:
442: --#2. Number of VALID Territories for Assignment
443: --====================================================
444:
441:
442: --#2. Number of VALID Territories for Assignment
443: --====================================================
444:
445: JTF_DIAGNOSTIC_COREAPI.line_out(' 2. Number of ACTIVE '||l_meaning||' Territories VALID for Assignment: ');
446:
447: for sales_terr in C_valid_terrs(l_source_id)
448: loop
449: JTF_DIAGNOSTIC_COREAPI.brprint;
445: JTF_DIAGNOSTIC_COREAPI.line_out(' 2. Number of ACTIVE '||l_meaning||' Territories VALID for Assignment: ');
446:
447: for sales_terr in C_valid_terrs(l_source_id)
448: loop
449: JTF_DIAGNOSTIC_COREAPI.brprint;
450: JTF_DIAGNOSTIC_COREAPI.line_out(' Transaction Type = ' || sales_terr.name || ', Territory Count = ' || sales_terr.terr_count);
451: end loop;
452: JTF_DIAGNOSTIC_COREAPI.brprint;
453: JTF_DIAGNOSTIC_COREAPI.brprint;
446:
447: for sales_terr in C_valid_terrs(l_source_id)
448: loop
449: JTF_DIAGNOSTIC_COREAPI.brprint;
450: JTF_DIAGNOSTIC_COREAPI.line_out(' Transaction Type = ' || sales_terr.name || ', Territory Count = ' || sales_terr.terr_count);
451: end loop;
452: JTF_DIAGNOSTIC_COREAPI.brprint;
453: JTF_DIAGNOSTIC_COREAPI.brprint;
454:
448: loop
449: JTF_DIAGNOSTIC_COREAPI.brprint;
450: JTF_DIAGNOSTIC_COREAPI.line_out(' Transaction Type = ' || sales_terr.name || ', Territory Count = ' || sales_terr.terr_count);
451: end loop;
452: JTF_DIAGNOSTIC_COREAPI.brprint;
453: JTF_DIAGNOSTIC_COREAPI.brprint;
454:
455: --#3. Number of VALID Sales Territories with Reps for Assignment
456: --==============================================================
449: JTF_DIAGNOSTIC_COREAPI.brprint;
450: JTF_DIAGNOSTIC_COREAPI.line_out(' Transaction Type = ' || sales_terr.name || ', Territory Count = ' || sales_terr.terr_count);
451: end loop;
452: JTF_DIAGNOSTIC_COREAPI.brprint;
453: JTF_DIAGNOSTIC_COREAPI.brprint;
454:
455: --#3. Number of VALID Sales Territories with Reps for Assignment
456: --==============================================================
457:
454:
455: --#3. Number of VALID Sales Territories with Reps for Assignment
456: --==============================================================
457:
458: JTF_DIAGNOSTIC_COREAPI.line_out(' 3. Number of ACTIVE '||l_meaning||' Territories VALID for Assignment, with Reps: ');
459:
460: for sales_terr_with_rep in C_valid_terrs_with_reps(l_source_id)
461: loop
462: JTF_DIAGNOSTIC_COREAPI.brprint;
458: JTF_DIAGNOSTIC_COREAPI.line_out(' 3. Number of ACTIVE '||l_meaning||' Territories VALID for Assignment, with Reps: ');
459:
460: for sales_terr_with_rep in C_valid_terrs_with_reps(l_source_id)
461: loop
462: JTF_DIAGNOSTIC_COREAPI.brprint;
463: JTF_DIAGNOSTIC_COREAPI.line_out(' Transaction Type = ' || sales_terr_with_rep.name || ', Territory Count = ' || sales_terr_with_rep.terr_count);
464: end loop;
465: JTF_DIAGNOSTIC_COREAPI.brprint;
466: JTF_DIAGNOSTIC_COREAPI.brprint;
459:
460: for sales_terr_with_rep in C_valid_terrs_with_reps(l_source_id)
461: loop
462: JTF_DIAGNOSTIC_COREAPI.brprint;
463: JTF_DIAGNOSTIC_COREAPI.line_out(' Transaction Type = ' || sales_terr_with_rep.name || ', Territory Count = ' || sales_terr_with_rep.terr_count);
464: end loop;
465: JTF_DIAGNOSTIC_COREAPI.brprint;
466: JTF_DIAGNOSTIC_COREAPI.brprint;
467:
461: loop
462: JTF_DIAGNOSTIC_COREAPI.brprint;
463: JTF_DIAGNOSTIC_COREAPI.line_out(' Transaction Type = ' || sales_terr_with_rep.name || ', Territory Count = ' || sales_terr_with_rep.terr_count);
464: end loop;
465: JTF_DIAGNOSTIC_COREAPI.brprint;
466: JTF_DIAGNOSTIC_COREAPI.brprint;
467:
468: --#4. Total Number of Values in System
469: --=====================================
462: JTF_DIAGNOSTIC_COREAPI.brprint;
463: JTF_DIAGNOSTIC_COREAPI.line_out(' Transaction Type = ' || sales_terr_with_rep.name || ', Territory Count = ' || sales_terr_with_rep.terr_count);
464: end loop;
465: JTF_DIAGNOSTIC_COREAPI.brprint;
466: JTF_DIAGNOSTIC_COREAPI.brprint;
467:
468: --#4. Total Number of Values in System
469: --=====================================
470: select count(*)
477: and jtu.terr_id = jt.terr_id
478: and jt.start_date_active <= SYSDATE
479: AND NVL(jt.end_date_active, SYSDATE + 1) >= SYSDATE );
480:
481: JTF_DIAGNOSTIC_COREAPI.line_out(' 4. Number of Values for ACTIVE '||l_meaning||' Territories = '||l_num_values);
482: JTF_DIAGNOSTIC_COREAPI.brprint;
483: JTF_DIAGNOSTIC_COREAPI.brprint;
484:
485:
478: and jt.start_date_active <= SYSDATE
479: AND NVL(jt.end_date_active, SYSDATE + 1) >= SYSDATE );
480:
481: JTF_DIAGNOSTIC_COREAPI.line_out(' 4. Number of Values for ACTIVE '||l_meaning||' Territories = '||l_num_values);
482: JTF_DIAGNOSTIC_COREAPI.brprint;
483: JTF_DIAGNOSTIC_COREAPI.brprint;
484:
485:
486: --#5. Total # of Territory Resource Assignments
479: AND NVL(jt.end_date_active, SYSDATE + 1) >= SYSDATE );
480:
481: JTF_DIAGNOSTIC_COREAPI.line_out(' 4. Number of Values for ACTIVE '||l_meaning||' Territories = '||l_num_values);
482: JTF_DIAGNOSTIC_COREAPI.brprint;
483: JTF_DIAGNOSTIC_COREAPI.brprint;
484:
485:
486: --#5. Total # of Territory Resource Assignments
487: --=============================================
493: AND EXISTS ( SELECT jtdr.terr_id
494: FROM jtf_terr_denorm_rules_all jtdr
495: WHERE jtdr.source_id = l_source_id );
496:
497: JTF_DIAGNOSTIC_COREAPI.line_out( ' 5. Number of ACTIVE '||l_meaning||' Territory Resource Assignments = '||l_terr_res_assign);
498: JTF_DIAGNOSTIC_COREAPI.brprint;
499: JTF_DIAGNOSTIC_COREAPI.brprint;
500:
501: --#6. Total # of DISTINCT Territory Resources (Total # of Active Reps)
494: FROM jtf_terr_denorm_rules_all jtdr
495: WHERE jtdr.source_id = l_source_id );
496:
497: JTF_DIAGNOSTIC_COREAPI.line_out( ' 5. Number of ACTIVE '||l_meaning||' Territory Resource Assignments = '||l_terr_res_assign);
498: JTF_DIAGNOSTIC_COREAPI.brprint;
499: JTF_DIAGNOSTIC_COREAPI.brprint;
500:
501: --#6. Total # of DISTINCT Territory Resources (Total # of Active Reps)
502: --====================================================================
495: WHERE jtdr.source_id = l_source_id );
496:
497: JTF_DIAGNOSTIC_COREAPI.line_out( ' 5. Number of ACTIVE '||l_meaning||' Territory Resource Assignments = '||l_terr_res_assign);
498: JTF_DIAGNOSTIC_COREAPI.brprint;
499: JTF_DIAGNOSTIC_COREAPI.brprint;
500:
501: --#6. Total # of DISTINCT Territory Resources (Total # of Active Reps)
502: --====================================================================
503: SELECT COUNT (*)
509: AND EXISTS ( SELECT jtdr.terr_id
510: FROM jtf_terr_denorm_rules_all jtdr
511: WHERE jtdr.source_id = l_source_id ) );
512:
513: JTF_DIAGNOSTIC_COREAPI.line_out(' 6. Number of ACTIVE '||l_meaning||' Territory Resources (Total # of Active Reps) = '||l_active_reps);
514: JTF_DIAGNOSTIC_COREAPI.brprint;
515: JTF_DIAGNOSTIC_COREAPI.brprint;
516:
517: --#7. Total Number of Values per each Qualifier in System
510: FROM jtf_terr_denorm_rules_all jtdr
511: WHERE jtdr.source_id = l_source_id ) );
512:
513: JTF_DIAGNOSTIC_COREAPI.line_out(' 6. Number of ACTIVE '||l_meaning||' Territory Resources (Total # of Active Reps) = '||l_active_reps);
514: JTF_DIAGNOSTIC_COREAPI.brprint;
515: JTF_DIAGNOSTIC_COREAPI.brprint;
516:
517: --#7. Total Number of Values per each Qualifier in System
518: --========================================================
511: WHERE jtdr.source_id = l_source_id ) );
512:
513: JTF_DIAGNOSTIC_COREAPI.line_out(' 6. Number of ACTIVE '||l_meaning||' Territory Resources (Total # of Active Reps) = '||l_active_reps);
514: JTF_DIAGNOSTIC_COREAPI.brprint;
515: JTF_DIAGNOSTIC_COREAPI.brprint;
516:
517: --#7. Total Number of Values per each Qualifier in System
518: --========================================================
519:
516:
517: --#7. Total Number of Values per each Qualifier in System
518: --========================================================
519:
520: JTF_DIAGNOSTIC_COREAPI.line_out(' 7. Number of ALL values for each '||l_meaning||' Qualifier: ');
521:
522: for num_values_rec in C_num_values_ALL(l_source_id)
523: loop
524: JTF_DIAGNOSTIC_COREAPI.brprint;
520: JTF_DIAGNOSTIC_COREAPI.line_out(' 7. Number of ALL values for each '||l_meaning||' Qualifier: ');
521:
522: for num_values_rec in C_num_values_ALL(l_source_id)
523: loop
524: JTF_DIAGNOSTIC_COREAPI.brprint;
525: JTF_DIAGNOSTIC_COREAPI.line_out(' '||num_values_rec.name || ' = ' || num_values_rec.value_count);
526: end loop;
527: JTF_DIAGNOSTIC_COREAPI.brprint;
528: JTF_DIAGNOSTIC_COREAPI.brprint;
521:
522: for num_values_rec in C_num_values_ALL(l_source_id)
523: loop
524: JTF_DIAGNOSTIC_COREAPI.brprint;
525: JTF_DIAGNOSTIC_COREAPI.line_out(' '||num_values_rec.name || ' = ' || num_values_rec.value_count);
526: end loop;
527: JTF_DIAGNOSTIC_COREAPI.brprint;
528: JTF_DIAGNOSTIC_COREAPI.brprint;
529:
523: loop
524: JTF_DIAGNOSTIC_COREAPI.brprint;
525: JTF_DIAGNOSTIC_COREAPI.line_out(' '||num_values_rec.name || ' = ' || num_values_rec.value_count);
526: end loop;
527: JTF_DIAGNOSTIC_COREAPI.brprint;
528: JTF_DIAGNOSTIC_COREAPI.brprint;
529:
530: --#8. Total Number of Values per each Qualifier Operator in System
531: --=================================================================
524: JTF_DIAGNOSTIC_COREAPI.brprint;
525: JTF_DIAGNOSTIC_COREAPI.line_out(' '||num_values_rec.name || ' = ' || num_values_rec.value_count);
526: end loop;
527: JTF_DIAGNOSTIC_COREAPI.brprint;
528: JTF_DIAGNOSTIC_COREAPI.brprint;
529:
530: --#8. Total Number of Values per each Qualifier Operator in System
531: --=================================================================
532:
529:
530: --#8. Total Number of Values per each Qualifier Operator in System
531: --=================================================================
532:
533: JTF_DIAGNOSTIC_COREAPI.line_out(' 8. Number of ALL values for each '||l_meaning||' Qualifier, per operator: ');
534:
535: for vals_in_system in C_values_in_system_ALL(l_source_id)
536: loop
537: JTF_DIAGNOSTIC_COREAPI.brprint;
533: JTF_DIAGNOSTIC_COREAPI.line_out(' 8. Number of ALL values for each '||l_meaning||' Qualifier, per operator: ');
534:
535: for vals_in_system in C_values_in_system_ALL(l_source_id)
536: loop
537: JTF_DIAGNOSTIC_COREAPI.brprint;
538: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_system.name || ' with '''||vals_in_system.operator ||''' Operator = '||vals_in_system.value_count);
539: end loop;
540: JTF_DIAGNOSTIC_COREAPI.brprint;
541: JTF_DIAGNOSTIC_COREAPI.brprint;
534:
535: for vals_in_system in C_values_in_system_ALL(l_source_id)
536: loop
537: JTF_DIAGNOSTIC_COREAPI.brprint;
538: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_system.name || ' with '''||vals_in_system.operator ||''' Operator = '||vals_in_system.value_count);
539: end loop;
540: JTF_DIAGNOSTIC_COREAPI.brprint;
541: JTF_DIAGNOSTIC_COREAPI.brprint;
542:
536: loop
537: JTF_DIAGNOSTIC_COREAPI.brprint;
538: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_system.name || ' with '''||vals_in_system.operator ||''' Operator = '||vals_in_system.value_count);
539: end loop;
540: JTF_DIAGNOSTIC_COREAPI.brprint;
541: JTF_DIAGNOSTIC_COREAPI.brprint;
542:
543: --#9. Total Number of Values per each Qualifier in System
544: --========================================================
537: JTF_DIAGNOSTIC_COREAPI.brprint;
538: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_system.name || ' with '''||vals_in_system.operator ||''' Operator = '||vals_in_system.value_count);
539: end loop;
540: JTF_DIAGNOSTIC_COREAPI.brprint;
541: JTF_DIAGNOSTIC_COREAPI.brprint;
542:
543: --#9. Total Number of Values per each Qualifier in System
544: --========================================================
545:
542:
543: --#9. Total Number of Values per each Qualifier in System
544: --========================================================
545:
546: JTF_DIAGNOSTIC_COREAPI.line_out(' 9. Number of ACTIVE values for each '||l_meaning||' Qualifier: ');
547:
548: for num_values_rec in C_num_values(l_source_id)
549: loop
550: JTF_DIAGNOSTIC_COREAPI.brprint;
546: JTF_DIAGNOSTIC_COREAPI.line_out(' 9. Number of ACTIVE values for each '||l_meaning||' Qualifier: ');
547:
548: for num_values_rec in C_num_values(l_source_id)
549: loop
550: JTF_DIAGNOSTIC_COREAPI.brprint;
551: JTF_DIAGNOSTIC_COREAPI.line_out(' '||num_values_rec.name || ' = ' || num_values_rec.value_count);
552: end loop;
553: JTF_DIAGNOSTIC_COREAPI.brprint;
554: JTF_DIAGNOSTIC_COREAPI.brprint;
547:
548: for num_values_rec in C_num_values(l_source_id)
549: loop
550: JTF_DIAGNOSTIC_COREAPI.brprint;
551: JTF_DIAGNOSTIC_COREAPI.line_out(' '||num_values_rec.name || ' = ' || num_values_rec.value_count);
552: end loop;
553: JTF_DIAGNOSTIC_COREAPI.brprint;
554: JTF_DIAGNOSTIC_COREAPI.brprint;
555:
549: loop
550: JTF_DIAGNOSTIC_COREAPI.brprint;
551: JTF_DIAGNOSTIC_COREAPI.line_out(' '||num_values_rec.name || ' = ' || num_values_rec.value_count);
552: end loop;
553: JTF_DIAGNOSTIC_COREAPI.brprint;
554: JTF_DIAGNOSTIC_COREAPI.brprint;
555:
556: --#10. Total Number of Values per each Qualifier Operator in System
557: --=================================================================
550: JTF_DIAGNOSTIC_COREAPI.brprint;
551: JTF_DIAGNOSTIC_COREAPI.line_out(' '||num_values_rec.name || ' = ' || num_values_rec.value_count);
552: end loop;
553: JTF_DIAGNOSTIC_COREAPI.brprint;
554: JTF_DIAGNOSTIC_COREAPI.brprint;
555:
556: --#10. Total Number of Values per each Qualifier Operator in System
557: --=================================================================
558:
555:
556: --#10. Total Number of Values per each Qualifier Operator in System
557: --=================================================================
558:
559: JTF_DIAGNOSTIC_COREAPI.line_out(' 10. Number of ACTIVE values for each '||l_meaning||' Qualifier, per operator: ');
560:
561: for vals_in_system in C_values_in_system(l_source_id)
562: loop
563: JTF_DIAGNOSTIC_COREAPI.brprint;
559: JTF_DIAGNOSTIC_COREAPI.line_out(' 10. Number of ACTIVE values for each '||l_meaning||' Qualifier, per operator: ');
560:
561: for vals_in_system in C_values_in_system(l_source_id)
562: loop
563: JTF_DIAGNOSTIC_COREAPI.brprint;
564: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_system.name || ' with '''||vals_in_system.operator ||''' Operator = '||vals_in_system.value_count);
565: end loop;
566: JTF_DIAGNOSTIC_COREAPI.brprint;
567: JTF_DIAGNOSTIC_COREAPI.brprint;
560:
561: for vals_in_system in C_values_in_system(l_source_id)
562: loop
563: JTF_DIAGNOSTIC_COREAPI.brprint;
564: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_system.name || ' with '''||vals_in_system.operator ||''' Operator = '||vals_in_system.value_count);
565: end loop;
566: JTF_DIAGNOSTIC_COREAPI.brprint;
567: JTF_DIAGNOSTIC_COREAPI.brprint;
568:
562: loop
563: JTF_DIAGNOSTIC_COREAPI.brprint;
564: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_system.name || ' with '''||vals_in_system.operator ||''' Operator = '||vals_in_system.value_count);
565: end loop;
566: JTF_DIAGNOSTIC_COREAPI.brprint;
567: JTF_DIAGNOSTIC_COREAPI.brprint;
568:
569:
570: if l_source_id = -1001 then --sales
563: JTF_DIAGNOSTIC_COREAPI.brprint;
564: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_system.name || ' with '''||vals_in_system.operator ||''' Operator = '||vals_in_system.value_count);
565: end loop;
566: JTF_DIAGNOSTIC_COREAPI.brprint;
567: JTF_DIAGNOSTIC_COREAPI.brprint;
568:
569:
570: if l_source_id = -1001 then --sales
571: --Total Number of values per Qualifier in MV
569:
570: if l_source_id = -1001 then --sales
571: --Total Number of values per Qualifier in MV
572: --==============================================
573: JTF_DIAGNOSTIC_COREAPI.line_out(' 11. Number of values for each Qualifier in MV (only for '||l_meaning||') : ');
574:
575: for vals_in_MV in C_values_in_MV
576: loop
577: JTF_DIAGNOSTIC_COREAPI.brprint;
573: JTF_DIAGNOSTIC_COREAPI.line_out(' 11. Number of values for each Qualifier in MV (only for '||l_meaning||') : ');
574:
575: for vals_in_MV in C_values_in_MV
576: loop
577: JTF_DIAGNOSTIC_COREAPI.brprint;
578: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_MV.name || ' = ' || vals_in_MV.value_count);
579: end loop;
580: JTF_DIAGNOSTIC_COREAPI.brprint;
581: JTF_DIAGNOSTIC_COREAPI.brprint;
574:
575: for vals_in_MV in C_values_in_MV
576: loop
577: JTF_DIAGNOSTIC_COREAPI.brprint;
578: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_MV.name || ' = ' || vals_in_MV.value_count);
579: end loop;
580: JTF_DIAGNOSTIC_COREAPI.brprint;
581: JTF_DIAGNOSTIC_COREAPI.brprint;
582:
576: loop
577: JTF_DIAGNOSTIC_COREAPI.brprint;
578: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_MV.name || ' = ' || vals_in_MV.value_count);
579: end loop;
580: JTF_DIAGNOSTIC_COREAPI.brprint;
581: JTF_DIAGNOSTIC_COREAPI.brprint;
582:
583:
584: --Total Number of Values per each Qualifier Operator in MV
577: JTF_DIAGNOSTIC_COREAPI.brprint;
578: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_MV.name || ' = ' || vals_in_MV.value_count);
579: end loop;
580: JTF_DIAGNOSTIC_COREAPI.brprint;
581: JTF_DIAGNOSTIC_COREAPI.brprint;
582:
583:
584: --Total Number of Values per each Qualifier Operator in MV
585: --=============================================================
582:
583:
584: --Total Number of Values per each Qualifier Operator in MV
585: --=============================================================
586: JTF_DIAGNOSTIC_COREAPI.line_out(' 12. Number of Values for each Qualifier, per operator in MV (only for '||l_meaning||') : ');
587:
588: for vals_in_MV_per_qual in C_values_in_MV_per_qual
589: loop
590: JTF_DIAGNOSTIC_COREAPI.brprint;
586: JTF_DIAGNOSTIC_COREAPI.line_out(' 12. Number of Values for each Qualifier, per operator in MV (only for '||l_meaning||') : ');
587:
588: for vals_in_MV_per_qual in C_values_in_MV_per_qual
589: loop
590: JTF_DIAGNOSTIC_COREAPI.brprint;
591: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_MV_per_qual.name || ' with '''|| vals_in_MV_per_qual.operator||''' Operator = '|| vals_in_MV_per_qual.value_count);
592: end loop;
593: JTF_DIAGNOSTIC_COREAPI.brprint;
594: JTF_DIAGNOSTIC_COREAPI.brprint;
587:
588: for vals_in_MV_per_qual in C_values_in_MV_per_qual
589: loop
590: JTF_DIAGNOSTIC_COREAPI.brprint;
591: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_MV_per_qual.name || ' with '''|| vals_in_MV_per_qual.operator||''' Operator = '|| vals_in_MV_per_qual.value_count);
592: end loop;
593: JTF_DIAGNOSTIC_COREAPI.brprint;
594: JTF_DIAGNOSTIC_COREAPI.brprint;
595:
589: loop
590: JTF_DIAGNOSTIC_COREAPI.brprint;
591: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_MV_per_qual.name || ' with '''|| vals_in_MV_per_qual.operator||''' Operator = '|| vals_in_MV_per_qual.value_count);
592: end loop;
593: JTF_DIAGNOSTIC_COREAPI.brprint;
594: JTF_DIAGNOSTIC_COREAPI.brprint;
595:
596: end if;
597: JTF_DIAGNOSTIC_COREAPI.brprint;
590: JTF_DIAGNOSTIC_COREAPI.brprint;
591: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_MV_per_qual.name || ' with '''|| vals_in_MV_per_qual.operator||''' Operator = '|| vals_in_MV_per_qual.value_count);
592: end loop;
593: JTF_DIAGNOSTIC_COREAPI.brprint;
594: JTF_DIAGNOSTIC_COREAPI.brprint;
595:
596: end if;
597: JTF_DIAGNOSTIC_COREAPI.brprint;
598: end loop;
593: JTF_DIAGNOSTIC_COREAPI.brprint;
594: JTF_DIAGNOSTIC_COREAPI.brprint;
595:
596: end if;
597: JTF_DIAGNOSTIC_COREAPI.brprint;
598: end loop;
599:
600: statusStr := 'SUCCESS';
601: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
600: statusStr := 'SUCCESS';
601: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
602: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
603: EXCEPTION when others then
604: JTF_DIAGNOSTIC_COREAPI.ERRORPRINT(sqlerrm);
605: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
606: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport('FAILURE','Exception thrown',fixInfo,isFatal);
607: END runTest;
608: