APPS.JTF_DIAGNOSTIC_MIGRATE dependencies on JTF_DIAGNOSTIC_TEST

Line 499: select count(*) into v_count from jtf_diagnostic_test

495:
496: -- check if this already exists.
497: -- if not insert, else update
498:
499: select count(*) into v_count from jtf_diagnostic_test
500: where appid = P_ASN and groupname = P_GRPNAME and
501: testclassname = x.attribute_value;
502:
503: if v_last_migrate_date < x.last_update_date or v_count = 0 then

Line 515: from jtf_diagnostic_test

511:
512: -- ordernumber (max there in the database + 1)
513:
514: select MAX(ordernumber) into v_temp_ordnum
515: from jtf_diagnostic_test
516: where appid = p_asn
517: and groupname = p_grpname;
518: -- and testclassname = x.attribute_value;
519:

Line 574: insert into jtf_diagnostic_test(

570:
571: end if;
572:
573:
574: insert into jtf_diagnostic_test(
575: SEQUENCE, GROUPNAME, APPID,
576: ORDERNUMBER, TESTTYPE, TESTCLASSNAME,
577: TOTALARGUMENTROWS, OBJECT_VERSION_NUMBER,
578: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,

Line 581: jtf_diagnostic_test_s.nextval, p_grpname, p_asn,

577: TOTALARGUMENTROWS, OBJECT_VERSION_NUMBER,
578: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
579: LAST_UPDATE_LOGIN, CREATION_DATE)
580: values(
581: jtf_diagnostic_test_s.nextval, p_grpname, p_asn,
582: DECODE(v_temp_ordnum,null,1,v_temp_ordnum),
583: v_prev_attrib_value,
584: x.attribute_value,
585: v_temp_argrows, X.OBJECT_VERSION_NUMBER, X.created_by,

Line 592: update jtf_diagnostic_test set

588:
589: else
590:
591: -- just update the testcase
592: update jtf_diagnostic_test set
593: OBJECT_VERSION_NUMBER = x.OBJECT_VERSION_NUMBER,
594: LAST_UPDATE_DATE = x.LAST_UPDATE_DATE,
595: LAST_UPDATED_BY = x.LAST_UPDATED_BY
596: where appid = p_asn and groupname = p_grpname