APPS.JTF_DIAGNOSTICLOG dependencies on JTF_DIAGNOSTIC_STATS

Line 78: from JTF_DIAGNOSTIC_STATS where

74: V_FAIL_SEQ := P_SEQUENCE;
75: end if;
76:
77: select count(*) into V_RECORD_EXIST
78: from JTF_DIAGNOSTIC_STATS where
79: appName = P_APPNAME
80: and groupName = P_GROUPNAME
81: and testClassName = P_TESTCLASSNAME;
82:

Line 88: insert into JTF_DIAGNOSTIC_STATS(SEQUENCE, APPNAME, GROUPNAME, TESTCLASSNAME,

84:
85: select JTF_DIAGNOSTIC_LOG_S.nextval
86: into V_SEQUENCE from DUAL;
87:
88: insert into JTF_DIAGNOSTIC_STATS(SEQUENCE, APPNAME, GROUPNAME, TESTCLASSNAME,
89: TOTALRUN, TOTALFAIL, LASTEXECUTIONTIME, LASTSTATUS,
90: LASTREPORTSEQUENCEID, LASTFAILURETIME, LASTFAILURESEQUENCEID,
91: OBJECT_VERSION_NUMBER, CREATED_BY,
92: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE)

Line 102: update JTF_DIAGNOSTIC_STATS

98: else
99:
100: if (P_STATUS = 1 OR P_STATUS = 2) then
101:
102: update JTF_DIAGNOSTIC_STATS
103: set totalRun = totalRun + 1,
104: totalFail = totalFail + 1,
105: lastExecutionTime = P_TIME,
106: lastStatus = P_STATUS,

Line 117: update JTF_DIAGNOSTIC_STATS

113: and testClassName = P_TESTCLASSNAME;
114:
115: else
116:
117: update JTF_DIAGNOSTIC_STATS
118: set totalRun = totalRun + 1,
119: lastExecutionTime = P_TIME,
120: lastStatus = P_STATUS,
121: lastReportSequenceID = P_SEQUENCE,