[Home] [Help]
634: and appid = P_APP_NAME
635: and testclassname = P_TEST_CLASS_NAME;
636:
637: -- cleanup all information about all teststeps of this testcase
638: -- from the jtf_diagnostic_decl_step_cols table
639:
640: delete from jtf_diagnostic_decl_step_cols
641: where groupname = P_GROUP_NAME
642: and appid = P_APP_NAME
636:
637: -- cleanup all information about all teststeps of this testcase
638: -- from the jtf_diagnostic_decl_step_cols table
639:
640: delete from jtf_diagnostic_decl_step_cols
641: where groupname = P_GROUP_NAME
642: and appid = P_APP_NAME
643: and testclassname = P_TEST_CLASS_NAME;
644:
1768: LAST_UPDATED_BY = P_LUBID
1769: where groupname = p_groupname
1770: and appid = p_appid;
1771:
1772: update jtf_diagnostic_decl_step_cols
1773: set groupname = p_newgroupname,
1774: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
1775: LAST_UPDATE_DATE = SYSDATE,
1776: LAST_UPDATED_BY = P_LUBID
2664:
2665: begin
2666: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2667: into db_luby, db_ludate
2668: from jtf_diagnostic_decl_step_cols
2669: where APPID = P_APPID
2670: and GROUPNAME = P_GROUPNAME
2671: and TESTCLASSNAME = P_TESTCLASSNAME
2672: and TESTSTEPNAME = P_TESTSTEPNAME
2682: p_cust_mode))
2683: then*/
2684: -- seed data must not be changed by customers.Hence overwriting data always
2685: -- so that it covers up any changes by mistake
2686: update jtf_diagnostic_decl_step_cols
2687: set last_updated_by = f_luby,
2688: last_update_date = f_ludate,
2689: object_version_number = object_version_number + 1,
2690: security_group_id = to_number(P_SECURITY_GROUP_ID),
2703:
2704: when no_data_found then
2705: -- Record doesn't exist - insert in all cases
2706:
2707: insert into jtf_diagnostic_decl_step_cols(
2708: APPID,
2709: GROUPNAME,
2710: TESTCLASSNAME,
2711: TESTSTEPNAME,