DBA Data[Home] [Help]

APPS.JTF_DIAGNOSTIC dependencies on JTF_DIAGNOSTIC_DECL_STEP_COLS

Line 661: -- from the jtf_diagnostic_decl_step_cols table

657: and appid = P_APP_NAME
658: and testclassname = P_TEST_CLASS_NAME;
659:
660: -- cleanup all information about all teststeps of this testcase
661: -- from the jtf_diagnostic_decl_step_cols table
662:
663: delete from jtf_diagnostic_decl_step_cols
664: where groupname = P_GROUP_NAME
665: and appid = P_APP_NAME

Line 663: delete from jtf_diagnostic_decl_step_cols

659:
660: -- cleanup all information about all teststeps of this testcase
661: -- from the jtf_diagnostic_decl_step_cols table
662:
663: delete from jtf_diagnostic_decl_step_cols
664: where groupname = P_GROUP_NAME
665: and appid = P_APP_NAME
666: and testclassname = P_TEST_CLASS_NAME;
667:

Line 809: delete from jtf_diagnostic_decl_step_cols

805: and groupname = P_GROUPNAME
806: and testclassname = P_TESTCLASSNAME
807: and teststepname = P_TESTSTEPNAME;
808:
809: delete from jtf_diagnostic_decl_step_cols
810: where groupname = P_GROUPNAME
811: and appid = P_APPID
812: and testclassname = P_TESTCLASSNAME;
813:

Line 2030: update jtf_diagnostic_decl_step_cols

2026: LAST_UPDATED_BY = P_LUBID
2027: where groupname = p_groupname
2028: and appid = p_appid;
2029:
2030: update jtf_diagnostic_decl_step_cols
2031: set groupname = p_newgroupname,
2032: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
2033: LAST_UPDATE_DATE = SYSDATE,
2034: LAST_UPDATED_BY = P_LUBID

Line 2948: from jtf_diagnostic_decl_step_cols

2944:
2945: begin
2946: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2947: into db_luby, db_ludate
2948: from jtf_diagnostic_decl_step_cols
2949: where APPID = P_APPID
2950: and GROUPNAME = P_GROUPNAME
2951: and TESTCLASSNAME = P_TESTCLASSNAME
2952: and TESTSTEPNAME = P_TESTSTEPNAME

Line 2966: update jtf_diagnostic_decl_step_cols

2962: p_cust_mode))
2963: then*/
2964: -- seed data must not be changed by customers.Hence overwriting data always
2965: -- so that it covers up any changes by mistake
2966: update jtf_diagnostic_decl_step_cols
2967: set last_updated_by = f_luby,
2968: last_update_date = f_ludate,
2969: object_version_number = object_version_number + 1,
2970: security_group_id = to_number(P_SECURITY_GROUP_ID),

Line 2987: insert into jtf_diagnostic_decl_step_cols(

2983:
2984: when no_data_found then
2985: -- Record doesn't exist - insert in all cases
2986:
2987: insert into jtf_diagnostic_decl_step_cols(
2988: APPID,
2989: GROUPNAME,
2990: TESTCLASSNAME,
2991: TESTSTEPNAME,