eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TERR_DIAGNOSTIC_TEST dependencies on JTF_DIAGNOSTIC_COREAPI

Line 270: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

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;

Line 272: JTF_DIAGNOSTIC_COREAPI.line_out('SUMMARY WARNING INFORMATION');

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:

Line 273: JTF_DIAGNOSTIC_COREAPI.line_out('========================================================');

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

Line 274: JTF_DIAGNOSTIC_COREAPI.brprint;

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:

Line 275: JTF_DIAGNOSTIC_COREAPI.brprint;

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;

Line 284: JTF_DIAGNOSTIC_COREAPI.line_out(' WARNINGS for '||l_meaning);

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:

Line 285: JTF_DIAGNOSTIC_COREAPI.brprint;

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

Line 286: JTF_DIAGNOSTIC_COREAPI.line_out(' ------------------------------------------------------------');

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:

Line 287: JTF_DIAGNOSTIC_COREAPI.brprint;

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)

Line 289: JTF_DIAGNOSTIC_COREAPI.line_out(' 1. '||l_meaning||' qualifiers using non-performant operators: ');

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

Line 295: JTF_DIAGNOSTIC_COREAPI.line_out('NONE');

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;

Line 297: 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: '                  ' ||

Line 298: JTF_DIAGNOSTIC_COREAPI.line_out(' Territory = ' ||vals_in_system.terr_name ||'; Qualifier = ' || vals_in_system.qual_name);

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||'''');

Line 299: JTF_DIAGNOSTIC_COREAPI.brprint;

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;

Line 300: JTF_DIAGNOSTIC_COREAPI.line_out(' ' ||

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;

Line 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

Line 305: JTF_DIAGNOSTIC_COREAPI.brprint;

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

Line 323: JTF_DIAGNOSTIC_COREAPI.line_out(' 2. No. of '||l_meaning||' qualifier values using % as a first char = '||l_percent_count);

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:

Line 324: JTF_DIAGNOSTIC_COREAPI.brprint;

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:

Line 325: JTF_DIAGNOSTIC_COREAPI.brprint;

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;

Line 331: JTF_DIAGNOSTIC_COREAPI.brprint;

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;

Line 333: JTF_DIAGNOSTIC_COREAPI.line_out('GENERAL INFORMATION');

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:

Line 334: JTF_DIAGNOSTIC_COREAPI.line_out('========================================================');

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

Line 335: JTF_DIAGNOSTIC_COREAPI.brprint;

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: --===========================

Line 336: 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: --===========================
340: SELECT COUNT(*)

Line 344: JTF_DIAGNOSTIC_COREAPI.line_out(' Total Number of Parties = '||l_parties);

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

Line 345: JTF_DIAGNOSTIC_COREAPI.brprint;

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: --================================

Line 346: JTF_DIAGNOSTIC_COREAPI.brprint;

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(*)

Line 354: JTF_DIAGNOSTIC_COREAPI.line_out(' Total Number of Party Sites = '||l_party_sites);

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

Line 355: JTF_DIAGNOSTIC_COREAPI.brprint;

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: --==============================

Line 356: JTF_DIAGNOSTIC_COREAPI.brprint;

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(*)

Line 364: JTF_DIAGNOSTIC_COREAPI.line_out( ' Total Number of Locations = '||l_locations);

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;

Line 365: 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:

Line 366: JTF_DIAGNOSTIC_COREAPI.brprint;

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

Line 368: JTF_DIAGNOSTIC_COREAPI.brprint;

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:

Line 377: JTF_DIAGNOSTIC_COREAPI.line_out('USAGE: '||l_meaning);

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:

Line 378: JTF_DIAGNOSTIC_COREAPI.line_out('========================================================');

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

Line 379: JTF_DIAGNOSTIC_COREAPI.brprint;

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');

Line 380: JTF_DIAGNOSTIC_COREAPI.brprint;

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;

Line 383: JTF_DIAGNOSTIC_COREAPI.line_out(' WARNINGS');

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:

Line 384: 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:
388: JTF_DIAGNOSTIC_COREAPI.line_out('  1. '||l_meaning||' qualifiers using non-performant operators: ');

Line 385: JTF_DIAGNOSTIC_COREAPI.line_out(' --------------------------------------------------------');

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:

Line 386: JTF_DIAGNOSTIC_COREAPI.brprint;

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)

Line 388: JTF_DIAGNOSTIC_COREAPI.line_out(' 1. '||l_meaning||' qualifiers using non-performant operators: ');

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;

Line 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: '                  ' ||

Line 393: JTF_DIAGNOSTIC_COREAPI.line_out(' Territory = ' ||vals_in_system.terr_name ||'; Qualifier = ' || vals_in_system.qual_name);

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||'''');

Line 394: JTF_DIAGNOSTIC_COREAPI.brprint;

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;

Line 395: JTF_DIAGNOSTIC_COREAPI.line_out(' ' ||

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;

Line 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

Line 400: JTF_DIAGNOSTIC_COREAPI.brprint;

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

Line 418: JTF_DIAGNOSTIC_COREAPI.line_out(' 2. No. of '||l_meaning||' qualifier values using % as a first char = '||l_percent_count);

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...

Line 419: JTF_DIAGNOSTIC_COREAPI.brprint;

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');

Line 420: JTF_DIAGNOSTIC_COREAPI.brprint;

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;

Line 423: JTF_DIAGNOSTIC_COREAPI.line_out(' ADDITIONAL INFORMATION');

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:

Line 424: 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:
428: --#1. Number of ACTIVE Territories

Line 425: JTF_DIAGNOSTIC_COREAPI.line_out(' --------------------------------------------------------');

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: --======================================

Line 426: JTF_DIAGNOSTIC_COREAPI.brprint;

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(*)

Line 438: JTF_DIAGNOSTIC_COREAPI.line_out(' 1. Number of ACTIVE '||l_meaning||' Territories = '||l_active_sales_terrs);

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

Line 439: JTF_DIAGNOSTIC_COREAPI.brprint;

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: --====================================================

Line 440: JTF_DIAGNOSTIC_COREAPI.brprint;

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:

Line 445: JTF_DIAGNOSTIC_COREAPI.line_out(' 2. Number of ACTIVE '||l_meaning||' Territories VALID for Assignment: ');

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;

Line 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;

Line 450: JTF_DIAGNOSTIC_COREAPI.line_out(' Transaction Type = ' || sales_terr.name || ', Territory Count = ' || sales_terr.terr_count);

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:

Line 452: JTF_DIAGNOSTIC_COREAPI.brprint;

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: --==============================================================

Line 453: JTF_DIAGNOSTIC_COREAPI.brprint;

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:

Line 458: JTF_DIAGNOSTIC_COREAPI.line_out(' 3. Number of ACTIVE '||l_meaning||' Territories VALID for Assignment, with Reps: ');

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;

Line 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;

Line 463: JTF_DIAGNOSTIC_COREAPI.line_out(' Transaction Type = ' || sales_terr_with_rep.name || ', Territory Count = ' || sales_terr_with_rep.terr_count);

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:

Line 465: JTF_DIAGNOSTIC_COREAPI.brprint;

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: --=====================================

Line 466: JTF_DIAGNOSTIC_COREAPI.brprint;

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(*)

Line 481: JTF_DIAGNOSTIC_COREAPI.line_out(' 4. Number of Values for ACTIVE '||l_meaning||' Territories = '||l_num_values);

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:

Line 482: JTF_DIAGNOSTIC_COREAPI.brprint;

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

Line 483: JTF_DIAGNOSTIC_COREAPI.brprint;

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: --=============================================

Line 497: JTF_DIAGNOSTIC_COREAPI.line_out( ' 5. Number of ACTIVE '||l_meaning||' Territory Resource Assignments = '||l_terr_res_assign);

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)

Line 498: JTF_DIAGNOSTIC_COREAPI.brprint;

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: --====================================================================

Line 499: JTF_DIAGNOSTIC_COREAPI.brprint;

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 (*)

Line 513: JTF_DIAGNOSTIC_COREAPI.line_out(' 6. Number of ACTIVE '||l_meaning||' Territory Resources (Total # of Active Reps) = '||l_active_reps);

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

Line 514: JTF_DIAGNOSTIC_COREAPI.brprint;

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: --========================================================

Line 515: JTF_DIAGNOSTIC_COREAPI.brprint;

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:

Line 520: JTF_DIAGNOSTIC_COREAPI.line_out(' 7. Number of ALL values for each '||l_meaning||' Qualifier: ');

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;

Line 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;

Line 525: JTF_DIAGNOSTIC_COREAPI.line_out(' '||num_values_rec.name || ' = ' || num_values_rec.value_count);

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:

Line 527: JTF_DIAGNOSTIC_COREAPI.brprint;

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: --=================================================================

Line 528: JTF_DIAGNOSTIC_COREAPI.brprint;

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:

Line 533: JTF_DIAGNOSTIC_COREAPI.line_out(' 8. Number of ALL values for each '||l_meaning||' Qualifier, per operator: ');

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;

Line 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;

Line 538: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_system.name || ' with '''||vals_in_system.operator ||''' Operator = '||vals_in_system.value_count);

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:

Line 540: JTF_DIAGNOSTIC_COREAPI.brprint;

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: --========================================================

Line 541: JTF_DIAGNOSTIC_COREAPI.brprint;

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:

Line 546: JTF_DIAGNOSTIC_COREAPI.line_out(' 9. Number of ACTIVE values for each '||l_meaning||' Qualifier: ');

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;

Line 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;

Line 551: JTF_DIAGNOSTIC_COREAPI.line_out(' '||num_values_rec.name || ' = ' || num_values_rec.value_count);

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:

Line 553: JTF_DIAGNOSTIC_COREAPI.brprint;

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: --=================================================================

Line 554: JTF_DIAGNOSTIC_COREAPI.brprint;

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:

Line 559: JTF_DIAGNOSTIC_COREAPI.line_out(' 10. Number of ACTIVE values for each '||l_meaning||' Qualifier, per operator: ');

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;

Line 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;

Line 564: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_system.name || ' with '''||vals_in_system.operator ||''' Operator = '||vals_in_system.value_count);

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:

Line 566: JTF_DIAGNOSTIC_COREAPI.brprint;

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

Line 567: JTF_DIAGNOSTIC_COREAPI.brprint;

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

Line 573: JTF_DIAGNOSTIC_COREAPI.line_out(' 11. Number of values for each Qualifier in MV (only for '||l_meaning||') : ');

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;

Line 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;

Line 578: JTF_DIAGNOSTIC_COREAPI.line_out(' '||vals_in_MV.name || ' = ' || vals_in_MV.value_count);

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:

Line 580: JTF_DIAGNOSTIC_COREAPI.brprint;

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

Line 581: JTF_DIAGNOSTIC_COREAPI.brprint;

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: --=============================================================

Line 586: JTF_DIAGNOSTIC_COREAPI.line_out(' 12. Number of Values for each Qualifier, per operator in MV (only for '||l_meaning||') : ');

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;

Line 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;

Line 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);

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:

Line 593: JTF_DIAGNOSTIC_COREAPI.brprint;

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;

Line 594: 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;

Line 597: JTF_DIAGNOSTIC_COREAPI.brprint;

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;

Line 604: JTF_DIAGNOSTIC_COREAPI.ERRORPRINT(sqlerrm);

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: