APPS.JTF_DIAGNOSTIC dependencies on JTF_DIAGNOSTIC_DECL_TEST_STEPS

Line 630: -- from the jtf_diagnostic_decl_test_steps table

626: and appid = P_APP_NAME
627: and testclassname = P_TEST_CLASS_NAME;
628:
629: -- cleanup all information about all teststeps of this testcase
630: -- from the jtf_diagnostic_decl_test_steps table
631:
632: delete from jtf_diagnostic_decl_test_steps
633: where groupname = P_GROUP_NAME
634: and appid = P_APP_NAME

Line 632: delete from jtf_diagnostic_decl_test_steps

628:
629: -- cleanup all information about all teststeps of this testcase
630: -- from the jtf_diagnostic_decl_test_steps table
631:
632: delete from jtf_diagnostic_decl_test_steps
633: where groupname = P_GROUP_NAME
634: and appid = P_APP_NAME
635: and testclassname = P_TEST_CLASS_NAME;
636:

Line 1764: update jtf_diagnostic_decl_test_steps

1760: LAST_UPDATED_BY = P_LUBID
1761: where prereqid = p_groupname
1762: and sourceappid = p_appid;
1763:
1764: update jtf_diagnostic_decl_test_steps
1765: set groupname = p_newgroupname,
1766: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
1767: LAST_UPDATE_DATE = SYSDATE,
1768: LAST_UPDATED_BY = P_LUBID

Line 2510: from JTF_DIAGNOSTIC_DECL_TEST_STEPS

2506:
2507: begin
2508: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2509: into db_luby, db_ludate
2510: from JTF_DIAGNOSTIC_DECL_TEST_STEPS
2511: where APPID = P_APPID
2512: and GROUPNAME = P_GROUPNAME
2513: and TESTCLASSNAME = P_TESTCLASSNAME
2514: and TESTSTEPNAME = P_TESTSTEPNAME;

Line 2527: update JTF_DIAGNOSTIC_DECL_TEST_STEPS

2523: p_cust_mode))
2524: then*/
2525: -- seed data must not be changed by customers.Hence overwriting data always
2526: -- so that it covers up any changes by mistake
2527: update JTF_DIAGNOSTIC_DECL_TEST_STEPS
2528: set last_updated_by = f_luby,
2529: last_update_date = f_ludate,
2530: object_version_number = object_version_number + 1,
2531: security_group_id = to_number(P_SECURITY_GROUP_ID),

Line 2559: from JTF_DIAGNOSTIC_DECL_TEST_STEPS

2555: when no_data_found then
2556: -- Record doesn't exist - insert in all cases
2557:
2558: select MAX(EXECUTION_SEQUENCE) into v_EXECUTION_SEQUENCE
2559: from JTF_DIAGNOSTIC_DECL_TEST_STEPS
2560: where APPID = P_APPID
2561: and GROUPNAME = P_GROUPNAME
2562: and TESTCLASSNAME = P_TESTCLASSNAME;
2563:

Line 2569: insert into JTF_DIAGNOSTIC_DECL_TEST_STEPS(

2565: v_EXECUTION_SEQUENCE := 1;
2566: else v_EXECUTION_SEQUENCE := v_EXECUTION_SEQUENCE + 1;
2567: end if;
2568:
2569: insert into JTF_DIAGNOSTIC_DECL_TEST_STEPS(
2570: APPID,
2571: GROUPNAME,
2572: TESTCLASSNAME,
2573: TESTSTEPNAME,