APPS.JTF_DECLARATIVE_DIAGNOSTIC dependencies on JTF_DIAGNOSTIC_DECL_STEP_COLS

Line 30: delete from jtf_diagnostic_decl_step_cols

26:
27: BEGIN
28:
29: if isupdate = 'TRUE' then
30: delete from jtf_diagnostic_decl_step_cols
31: where
32: appid = P_APPID
33: and groupname = p_groupname
34: and testclassname = p_testclassname

Line 44: insert into jtf_diagnostic_decl_step_cols

40:
41: LOOP
42: IF P_COLNAMES_ARRAY.EXISTS(V_INDEX) THEN
43:
44: insert into jtf_diagnostic_decl_step_cols
45: (
46: APPID,
47: GROUPNAME,
48: TESTCLASSNAME,

Line 358: from jtf_diagnostic_decl_step_cols

354:
355: cursor datalist is
356: select COLUMN_NAME, LOGICAL_OPERATOR,
357: VALIDATION_VAL1, VALIDATION_VAL2
358: from jtf_diagnostic_decl_step_cols
359: where APPID = appshtname
360: and GROUPNAME = grpname
361: and TESTCLASSNAME = testclsname
362: and TESTSTEPNAME = teststpname;

Line 1326: -- jtf_diagnostic_arg and jtf_diagnostic_decl_step_cols

1322: raise_application_error(-20000, 'Step name already exists in testcase');
1323: elsif isupdate = 'TRUE' and v_temp > 0 then
1324:
1325: -- first cleanup all information from the
1326: -- jtf_diagnostic_arg and jtf_diagnostic_decl_step_cols
1327:
1328: v_temp_char := newTestName || '/' || newStepName || '{-STEP/CLASS-}%';
1329:
1330: delete from jtf_diagnostic_arg where

Line 1335: delete from jtf_diagnostic_decl_step_cols

1331: APPID = qAppID
1332: and GROUPNAME = addToGroupName
1333: and TESTCLASSNAME like v_temp_char;
1334:
1335: delete from jtf_diagnostic_decl_step_cols
1336: where appid = qAppID
1337: and groupname = addToGroupName
1338: and testclassname = newTestName
1339: and TESTSTEPNAME = newStepName;

Line 1553: delete from jtf_diagnostic_decl_step_cols where

1549: -- step type then the column table is also
1550: -- cleaned up well.
1551:
1552: IF v_step_type = 'COLUMN' THEN
1553: delete from jtf_diagnostic_decl_step_cols where
1554: APPID = P_APPID
1555: and GROUPNAME = P_GROUPNAME
1556: and TESTCLASSNAME = P_TESTCLASSNAME
1557: and TESTSTEPNAME = P_DELSTEPARRAY(v_index);