435:
436: check_extraneous_only boolean := false;
437:
438: -- SKHEMANI Use the cursor to cleanup the
439: -- entry in the JTF_DIAGNOSTIC_KB table
440:
441: -- there were extraneous decl_test_steps left
442: CURSOR TSTSTEPLIST IS
443: select testclassname, teststepname from jtf_diagnostic_decl_test_steps
505: end loop;
506: close GRPLIST;
507:
508: -- SKHEMANI Use the cursor to cleanup the
509: -- entries of all tests in the JTF_DIAGNOSTIC_KB table
510: -- pertaining to this group, if any
511:
512: FOR x in TSTLIST
513: LOOP
582:
583: IF (check_extraneous_only = FALSE) THEN
584: -- SKHEMANI if flow of control reaches here, then the test has been found
585: -- great... we will use this sequence number to cleanup the
586: -- entry in the JTF_DIAGNOSTIC_KB table
587:
588: select sequence into V_SEQUENCE
589: from jtf_diagnostic_test
590: where APPID = P_APP_NAME
592: and testclassname = P_TEST_CLASS_NAME
593: and rownum <= 1;
594:
595: -- SKHEMANI Use the stored sequence number to cleanup the
596: -- entry in the JTF_DIAGNOSTIC_KB table
597:
598: delete from jtf_diagnostic_kb where
599: sequence = V_SEQUENCE;
600:
594:
595: -- SKHEMANI Use the stored sequence number to cleanup the
596: -- entry in the JTF_DIAGNOSTIC_KB table
597:
598: delete from jtf_diagnostic_kb where
599: sequence = V_SEQUENCE;
600:
601:
602: -- populate the variable v_ordernum
3194:
3195: begin
3196: select LAST_UPDATED_BY, LAST_UPDATE_DATE
3197: into db_luby, db_ludate
3198: from jtf_diagnostic_kb
3199: where sequence = seq;
3200:
3201: -- Update record only as per standard
3202:
3208: p_cust_mode))
3209: then*/
3210: -- seed data must not be changed by customers.Hence overwriting data always
3211: -- so that it covers up any changes by mistake
3212: update jtf_diagnostic_kb
3213: set last_updated_by = f_luby,
3214: last_update_date = f_ludate,
3215: object_version_number = object_version_number + 1,
3216: USER_TEST_NAME = P_USER_TEST_NAME,
3239:
3240: when no_data_found then
3241: -- Record doesn't exist - insert in all cases
3242:
3243: insert into jtf_diagnostic_kb(
3244: SEQUENCE,
3245: USER_TEST_NAME,
3246: METALINK_NOTE,
3247: COMPETENCY,