[Home] [Help]
1372: decode(v_ordernumber, null, 1, v_ordernumber),
1373: p_test_type, p_testclassname,
1374: 0, l_sensitivity, 1, p_lubid,
1375: SYSDATE, p_lubid, NULL,
1376: SYSDATE,xmltype(p_valid_apps_xml));
1377:
1378: -- commit;
1379:
1380: END INSERT_TESTCASE;
2091: TOTALARGUMENTROWS = p_TOTALARGUMENTROWS,
2092: TESTTYPE = p_TESTTYPE,
2093: sensitivity = l_sensitivity,
2094: security_group_id = to_number(P_SEC_GRP_ID),
2095: valid_applications = xmltype(P_VALID_APPLICATIONS)
2096: where appid = p_appid and groupname = p_groupname
2097: and testclassname = p_testclassname;
2098: else
2099:
2191: f_luby,
2192: null,
2193: f_ludate,
2194: to_number(P_SEC_GRP_ID),
2195: xmltype(P_VALID_APPLICATIONS));
2196: else
2197: insert into jtf_diagnostic_test(
2198: SEQUENCE,
2199: GROUPNAME,
3109:
3110: BEGIN
3111: update jtf_diagnostic_testset
3112: set description = P_DESCRIPTION,
3113: xml = XMLTYPE(P_XML),
3114: last_updated_by = P_LAST_UPDATED_BY,
3115: last_update_date = P_LAST_UPDATED_DATE
3116: where name = P_NAME;
3117: END UPDATE_TESTSET;
3142: insert into jtf_diagnostic_testset
3143: (NAME, DESCRIPTION, XML, CREATED_BY, CREATION_DATE,
3144: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, LAST_UPDATE_DATE)
3145: values
3146: ( P_NAME , P_DESCRIPTION, XMLType(P_XML), P_CREATED_BY, P_CREATION_DATE,
3147: P_LAST_UPDATE_LOGIN, P_LAST_UPDATED_BY, P_LAST_UPDATED_DATE);
3148: END INSERT_TESTSET;
3149:
3150: -- ---------------------------------------------------------------------------------------
3177:
3178: BEGIN
3179:
3180: UPDATE JTF_DIAGNOSTIC_TEST
3181: SET VALID_APPLICATIONS = XMLTYPE(P_VALIDAPPS),
3182: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
3183: LAST_UPDATE_DATE = P_LAST_UPDATED_DATE
3184: WHERE APPID = P_APPSHORTNAME
3185: AND GROUPNAME = P_GROUPNAME
3194: -- and checks if user is having the privilege to execute the test
3195: -- ------------------------------------------------------------------------------------------
3196: FUNCTION VALIDATE_APPLICATIONS(
3197: P_SENSITIVITY NUMBER,
3198: P_VALID_APPS_XML XMLTYPE) RETURN NUMBER IS
3199:
3200: -- a cursor pointing to list of applications which are valid for
3201: -- user obtained using USER_NAME
3202: cursor valid_user_apps_cursor is