APPS.JTF_DECLARATIVE_DIAGNOSTIC dependencies on JTF_DIAGNOSTIC_DECL_TEST_STEPS

Line 1186: FROM jtf_diagnostic_decl_test_steps

1182:
1183: BEGIN
1184: SELECT COUNT(*)
1185: INTO v_numofrows
1186: FROM jtf_diagnostic_decl_test_steps
1187: WHERE APPID = P_APPID
1188: and GROUPNAME = P_GROUPNAME
1189: and TESTCLASSNAME = P_TESTCLASSNAME;
1190:

Line 1198: UPDATE jtf_diagnostic_decl_test_steps

1194:
1195: LOOP
1196: IF P_STEPSEQARRAY.EXISTS(v_index) THEN
1197:
1198: UPDATE jtf_diagnostic_decl_test_steps
1199: SET EXECUTION_SEQUENCE = v_index,
1200: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
1201: LAST_UPDATE_DATE = SYSDATE,
1202: LAST_UPDATED_BY = P_LUBID

Line 1284: -- jtf_diagnostic_decl_test_steps table

1280:
1281:
1282: ------------------------------------------------------------
1283: -- procedure to insert the count step type into the
1284: -- jtf_diagnostic_decl_test_steps table
1285: ------------------------------------------------------------
1286: PROCEDURE insert_core_steps(
1287: qAppID IN VARCHAR2,
1288: newTestName IN VARCHAR2,

Line 1304: v_ordernumber jtf_diagnostic_decl_test_steps.EXECUTION_SEQUENCE%TYPE;

1300: val2 IN VARCHAR2,
1301: isUpdate IN VARCHAR2,
1302: P_LUBID IN NUMBER) IS
1303:
1304: v_ordernumber jtf_diagnostic_decl_test_steps.EXECUTION_SEQUENCE%TYPE;
1305: v_temp number;
1306: v_temp_char varchar(1000);
1307:
1308: BEGIN

Line 1315: from jtf_diagnostic_decl_test_steps

1311: -- making sure that the record is unique
1312: -- by checking if it already exists
1313:
1314: select count(*) into v_temp
1315: from jtf_diagnostic_decl_test_steps
1316: where appid = qAppID
1317: and groupname = addToGroupName
1318: and testclassname = newTestName
1319: and TESTSTEPNAME = newStepName;

Line 1341: update jtf_diagnostic_decl_test_steps

1337: and groupname = addToGroupName
1338: and testclassname = newTestName
1339: and TESTSTEPNAME = newStepName;
1340:
1341: update jtf_diagnostic_decl_test_steps
1342: set
1343: STEP_TYPE = stepType,
1344: STEP_DESCRIPTION = newStepDesc,
1345: ERROR_TYPE = errorType,

Line 1368: from jtf_diagnostic_decl_test_steps

1364: -- getting the next sequence number for
1365: -- inserting into the DB
1366:
1367: select count(*) into v_ordernumber
1368: from jtf_diagnostic_decl_test_steps
1369: where appid = qAppID
1370: and groupname = addToGroupName
1371: and testclassname = newTestName;
1372:

Line 1378: insert into jtf_diagnostic_decl_test_steps

1374: v_ordernumber := 1;
1375: else v_ordernumber := v_ordernumber + 1;
1376: end if;
1377:
1378: insert into jtf_diagnostic_decl_test_steps
1379: (
1380: APPID,
1381: GROUPNAME,
1382: TESTCLASSNAME,

Line 1444: from jtf_diagnostic_decl_test_steps

1440:
1441: cursor testlist is
1442:
1443: select TESTSTEPNAME, STEP_DESCRIPTION
1444: from jtf_diagnostic_decl_test_steps
1445: where APPID like p_appid
1446: and GROUPNAME = p_GROUPNAME
1447: and TESTCLASSNAME = p_TESTCLASSNAME
1448: order by EXECUTION_SEQUENCE;

Line 1486: from jtf_diagnostic_decl_test_steps

1482: LOOP
1483: IF P_DELSTEPARRAY.EXISTS(v_index) THEN
1484:
1485: select distinct EXECUTION_SEQUENCE into v_execution_sequence
1486: from jtf_diagnostic_decl_test_steps
1487: where APPID = P_APPID and groupname = P_GROUPNAME
1488: and TESTCLASSNAME = P_TESTCLASSNAME and
1489: TESTSTEPNAME = P_DELSTEPARRAY(v_index);
1490:

Line 1492: from jtf_diagnostic_decl_test_steps

1488: and TESTCLASSNAME = P_TESTCLASSNAME and
1489: TESTSTEPNAME = P_DELSTEPARRAY(v_index);
1490:
1491: select step_type into v_step_type
1492: from jtf_diagnostic_decl_test_steps
1493: where APPID = P_APPID and groupname = P_GROUPNAME
1494: and TESTCLASSNAME = P_TESTCLASSNAME and
1495: TESTSTEPNAME = P_DELSTEPARRAY(v_index);
1496:

Line 1504: from jtf_diagnostic_decl_test_steps

1500:
1501: IF v_step_type = 'DIAGNOSTICTEST' THEN
1502:
1503: select table_view_name into v_diagnostic_testname
1504: from jtf_diagnostic_decl_test_steps
1505: where APPID = P_APPID and groupname = P_GROUPNAME
1506: and TESTCLASSNAME = P_TESTCLASSNAME and
1507: TESTSTEPNAME = P_DELSTEPARRAY(v_index);
1508:

Line 1520: delete from jtf_diagnostic_decl_test_steps where

1516: and TESTCLASSNAME = v_diagnostic_testname;
1517:
1518: END IF;
1519:
1520: delete from jtf_diagnostic_decl_test_steps where
1521: APPID = P_APPID
1522: and GROUPNAME = P_GROUPNAME
1523: and TESTCLASSNAME = P_TESTCLASSNAME
1524: and TESTSTEPNAME = P_DELSTEPARRAY(v_index);

Line 1538: update jtf_diagnostic_decl_test_steps

1534: || P_DELSTEPARRAY(v_index));
1535:
1536: END IF;
1537:
1538: update jtf_diagnostic_decl_test_steps
1539: set EXECUTION_SEQUENCE = (EXECUTION_SEQUENCE - 1),
1540: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
1541: LAST_UPDATE_DATE = SYSDATE
1542: where EXECUTION_SEQUENCE > v_execution_sequence