APPS.JTF_DIAGNOSTIC dependencies on XMLTYPE

Line 1460: f_meta_data xmltype;

1456: V_SOURCETYPE BINARY_INTEGER := 2;
1457: v_ordernumber jtf_diagnostic_test.ordernumber%TYPE;
1458: l_sensitivity number;
1459: f_end_date date;
1460: f_meta_data xmltype;
1461:
1462: BEGIN
1463:
1464: -- Check for groupname validity

Line 1504: F_META_DATA := XMLTYPE(P_META_DATA);

1500: F_END_DATE := P_END_DATE;
1501: END IF;
1502:
1503: IF P_META_DATA is not null then
1504: F_META_DATA := XMLTYPE(P_META_DATA);
1505: END IF;
1506:
1507: -- if flow of control reaches here, insert the testcase
1508: -- to the group

Line 1536: SYSDATE,xmltype(p_valid_apps_xml),F_END_DATE,F_META_DATA);

1532: decode(v_ordernumber, null, 1, v_ordernumber),
1533: p_test_type, p_testclassname,
1534: 0, l_sensitivity, 1, p_lubid,
1535: SYSDATE, p_lubid, NULL,
1536: SYSDATE,xmltype(p_valid_apps_xml),F_END_DATE,F_META_DATA);
1537:
1538: -- commit;
1539:
1540: END INSERT_TESTCASE;

Line 2284: f_meta_data xmltype;

2280: c_testclassname varchar2(1500);
2281: DOINSERT boolean;
2282: l_sensitivity number;
2283: f_end_date date;
2284: f_meta_data xmltype;
2285:
2286: cursor C_GET_PROD_NAMES (l_appid varchar2,
2287: l_groupname varchar2,
2288: l_filename varchar2,

Line 2323: F_META_DATA := XMLTYPE(P_META_DATA);

2319: if p_end_date is not null then
2320: f_end_date := to_date(p_end_date, 'YYYY/MM/DD');
2321: end if;
2322: IF P_META_DATA is not null then
2323: F_META_DATA := XMLTYPE(P_META_DATA);
2324: END IF;
2325:
2326: if (p_sensitivity is null) then
2327: GET_GROUP_SENSITIVITY(p_appid,p_groupname,

Line 2364: valid_applications = xmltype(P_VALID_APPLICATIONS),

2360: TOTALARGUMENTROWS = p_TOTALARGUMENTROWS,
2361: TESTTYPE = p_TESTTYPE,
2362: sensitivity = l_sensitivity,
2363: security_group_id = to_number(P_SEC_GRP_ID),
2364: valid_applications = xmltype(P_VALID_APPLICATIONS),
2365: end_date = f_end_date,
2366: test_metadata = f_meta_data
2367: where appid = p_appid and groupname = p_groupname
2368: and testclassname = p_testclassname;

Line 2470: xmltype(P_VALID_APPLICATIONS),

2466: f_luby,
2467: null,
2468: f_ludate,
2469: to_number(P_SEC_GRP_ID),
2470: xmltype(P_VALID_APPLICATIONS),
2471: f_end_date,
2472: f_meta_data);
2473: else
2474: insert into jtf_diagnostic_test(

Line 3393: xml = XMLTYPE(P_XML),

3389:
3390: BEGIN
3391: update jtf_diagnostic_testset
3392: set description = P_DESCRIPTION,
3393: xml = XMLTYPE(P_XML),
3394: last_updated_by = P_LAST_UPDATED_BY,
3395: last_update_date = P_LAST_UPDATED_DATE
3396: where name = P_NAME;
3397: END UPDATE_TESTSET;

Line 3426: ( P_NAME , P_DESCRIPTION, XMLType(P_XML), P_CREATED_BY, P_CREATION_DATE,

3422: insert into jtf_diagnostic_testset
3423: (NAME, DESCRIPTION, XML, CREATED_BY, CREATION_DATE,
3424: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, LAST_UPDATE_DATE)
3425: values
3426: ( P_NAME , P_DESCRIPTION, XMLType(P_XML), P_CREATED_BY, P_CREATION_DATE,
3427: P_LAST_UPDATE_LOGIN, P_LAST_UPDATED_BY, P_LAST_UPDATED_DATE);
3428: END INSERT_TESTSET;
3429:
3430: -- ---------------------------------------------------------------------------------------

Line 3461: SET VALID_APPLICATIONS = XMLTYPE(P_VALIDAPPS),

3457:
3458: BEGIN
3459:
3460: UPDATE JTF_DIAGNOSTIC_TEST
3461: SET VALID_APPLICATIONS = XMLTYPE(P_VALIDAPPS),
3462: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
3463: LAST_UPDATE_DATE = P_LAST_UPDATED_DATE
3464: WHERE APPID = P_APPSHORTNAME
3465: AND GROUPNAME = P_GROUPNAME

Line 3478: P_VALID_APPS_XML XMLTYPE) RETURN NUMBER IS

3474: -- and checks if user is having the privilege to execute the test
3475: -- ------------------------------------------------------------------------------------------
3476: FUNCTION VALIDATE_APPLICATIONS(
3477: P_SENSITIVITY NUMBER,
3478: P_VALID_APPS_XML XMLTYPE) RETURN NUMBER IS
3479:
3480: -- a cursor pointing to list of applications which are valid for
3481: -- user obtained using USER_NAME
3482: cursor valid_user_apps_cursor is