APPS.JTF_DIAGNOSTICLOG dependencies on JTF_DIAGNOSTIC_LOG

Line 85: select JTF_DIAGNOSTIC_LOG_S.nextval

81: and testClassName = P_TESTCLASSNAME;
82:
83: if V_RECORD_EXIST = 0 then
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,

Line 164: select JTF_DIAGNOSTIC_LOG_S.nextval

160: ) IS
161: V_SEQUENCE NUMBER;
162:
163: BEGIN
164: select JTF_DIAGNOSTIC_LOG_S.nextval
165: into V_SEQUENCE from DUAL;
166:
167: insert into jtf_diagnostic_log( SEQUENCE, SESSIONID, MIDTIERNODE, APPNAME, GROUPNAME, TESTCLASSNAME, TIME, STATUS, MILLISCONSUMED, TESTMODE, TESTINDEX, INSTALLVERSION, TOOLVERSION, TESTVERSION, INPUTS, ERROR,
168: FIXINFO, REPORT, VERSIONS, DEPENDENCIES, OBJECT_VERSION_NUMBER,

Line 167: insert into jtf_diagnostic_log( SEQUENCE, SESSIONID, MIDTIERNODE, APPNAME, GROUPNAME, TESTCLASSNAME, TIME, STATUS, MILLISCONSUMED, TESTMODE, TESTINDEX, INSTALLVERSION, TOOLVERSION, TESTVERSION, INPUTS, ERROR,

163: BEGIN
164: select JTF_DIAGNOSTIC_LOG_S.nextval
165: into V_SEQUENCE from DUAL;
166:
167: insert into jtf_diagnostic_log( SEQUENCE, SESSIONID, MIDTIERNODE, APPNAME, GROUPNAME, TESTCLASSNAME, TIME, STATUS, MILLISCONSUMED, TESTMODE, TESTINDEX, INSTALLVERSION, TOOLVERSION, TESTVERSION, INPUTS, ERROR,
168: FIXINFO, REPORT, VERSIONS, DEPENDENCIES, OBJECT_VERSION_NUMBER,
169: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
170: CREATION_DATE) values ( V_SEQUENCE, P_SESSIONID,
171: P_MIDTIERNODE, P_APPNAME, P_GROUPNAME, P_TESTCLASSNAME, P_TIME, P_STATUS,

Line 189: from JTF_DIAGNOSTIC_LOG

185:
186: BEGIN
187:
188: select REPORT into P_REPORT
189: from JTF_DIAGNOSTIC_LOG
190: where sequence = P_SEQUENCE
191: for update;
192:
193: IF SQL%NOTFOUND THEN

Line 206: delete from jtf_diagnostic_log

202: ) IS
203:
204: BEGIN
205:
206: delete from jtf_diagnostic_log
207: where time <= P_EXPIRATION;
208:
209: END DELETE_EXPIRED_LOGS;
210: