APPS.JTF_DIAGNOSTIC dependencies on JTF_DIAGNOSTIC_DECL_TEST_STEPS

Line 443: select testclassname, teststepname from jtf_diagnostic_decl_test_steps

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
444: where appid = P_APP_NAME
445: and groupname = P_GROUP_NAME;
446:
447: CURSOR TSTLIST IS

Line 653: -- from the jtf_diagnostic_decl_test_steps table

649:
650: END IF;
651:
652: -- cleanup all information about all teststeps of this testcase
653: -- from the jtf_diagnostic_decl_test_steps table
654:
655: delete from jtf_diagnostic_decl_test_steps
656: where groupname = P_GROUP_NAME
657: and appid = P_APP_NAME

Line 655: delete from jtf_diagnostic_decl_test_steps

651:
652: -- cleanup all information about all teststeps of this testcase
653: -- from the jtf_diagnostic_decl_test_steps table
654:
655: delete from jtf_diagnostic_decl_test_steps
656: where groupname = P_GROUP_NAME
657: and appid = P_APP_NAME
658: and testclassname = P_TEST_CLASS_NAME;
659:

Line 761: from jtf_diagnostic_decl_test_steps

757: v_reorder boolean;
758:
759: CURSOR DECLTESTLIST (c_ordernumber number) IS
760: select teststepname, execution_sequence
761: from jtf_diagnostic_decl_test_steps
762: where appid = P_APPID
763: and groupname = P_GROUPNAME
764: and testclassname = P_TESTCLASSNAME
765: and execution_sequence > c_ordernumber

Line 771: from jtf_diagnostic_decl_test_steps

767:
768: BEGIN
769:
770: select execution_sequence into v_ordernum
771: from jtf_diagnostic_decl_test_steps
772: where appid = P_APPID and groupname = P_GROUPNAME
773: and testclassname = P_TESTCLASSNAME and teststepname = P_TESTSTEPNAME;
774:
775: IF v_ordernum is null then

Line 781: delete from jtf_diagnostic_decl_test_steps

777: ELSE
778: v_reorder := true;
779: END IF;
780:
781: delete from jtf_diagnostic_decl_test_steps
782: where appid = P_APPID
783: and groupname = P_GROUPNAME
784: and testclassname = P_TESTCLASSNAME
785: and teststepname = P_TESTSTEPNAME;

Line 792: update jtf_diagnostic_decl_test_steps

788: open DECLTESTLIST(V_ORDERNUM);
789: loop
790: fetch DECLTESTLIST into l_teststepname, l_ordernumber;
791: exit when (DECLTESTLIST%notfound);
792: update jtf_diagnostic_decl_test_steps
793: set execution_sequence = (l_ordernumber - 1),
794: LAST_UPDATE_DATE = SYSDATE
795: where teststepname = l_teststepname
796: and appid = P_APPID

Line 803: delete from jtf_diagnostic_decl_test_steps

799: end loop;
800: close DECLTESTLIST;
801: END IF;
802:
803: delete from jtf_diagnostic_decl_test_steps
804: where appid = P_APPID
805: and groupname = P_GROUPNAME
806: and testclassname = P_TESTCLASSNAME
807: and teststepname = P_TESTSTEPNAME;

Line 2022: update jtf_diagnostic_decl_test_steps

2018: LAST_UPDATED_BY = P_LUBID
2019: where prereqid = p_groupname
2020: and sourceappid = p_appid;
2021:
2022: update jtf_diagnostic_decl_test_steps
2023: set groupname = p_newgroupname,
2024: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
2025: LAST_UPDATE_DATE = SYSDATE,
2026: LAST_UPDATED_BY = P_LUBID

Line 2790: from JTF_DIAGNOSTIC_DECL_TEST_STEPS

2786:
2787: begin
2788: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2789: into db_luby, db_ludate
2790: from JTF_DIAGNOSTIC_DECL_TEST_STEPS
2791: where APPID = P_APPID
2792: and GROUPNAME = P_GROUPNAME
2793: and TESTCLASSNAME = P_TESTCLASSNAME
2794: and TESTSTEPNAME = P_TESTSTEPNAME;

Line 2807: update JTF_DIAGNOSTIC_DECL_TEST_STEPS

2803: p_cust_mode))
2804: then*/
2805: -- seed data must not be changed by customers.Hence overwriting data always
2806: -- so that it covers up any changes by mistake
2807: update JTF_DIAGNOSTIC_DECL_TEST_STEPS
2808: set last_updated_by = f_luby,
2809: last_update_date = f_ludate,
2810: object_version_number = object_version_number + 1,
2811: security_group_id = to_number(P_SECURITY_GROUP_ID),

Line 2839: from JTF_DIAGNOSTIC_DECL_TEST_STEPS

2835: when no_data_found then
2836: -- Record doesn't exist - insert in all cases
2837:
2838: select MAX(EXECUTION_SEQUENCE) into v_EXECUTION_SEQUENCE
2839: from JTF_DIAGNOSTIC_DECL_TEST_STEPS
2840: where APPID = P_APPID
2841: and GROUPNAME = P_GROUPNAME
2842: and TESTCLASSNAME = P_TESTCLASSNAME;
2843:

Line 2849: insert into JTF_DIAGNOSTIC_DECL_TEST_STEPS(

2845: v_EXECUTION_SEQUENCE := 1;
2846: else v_EXECUTION_SEQUENCE := v_EXECUTION_SEQUENCE + 1;
2847: end if;
2848:
2849: insert into JTF_DIAGNOSTIC_DECL_TEST_STEPS(
2850: APPID,
2851: GROUPNAME,
2852: TESTCLASSNAME,
2853: TESTSTEPNAME,