[Home] [Help]
266: V_TEMP_TYPE NUMBER;
267:
268: CURSOR prereqlist is
269: select prereqid, type
270: from jtf_diagnostic_prereq
271: where sourceid = P_APP_OR_GROUP_NAME
272: and sourceappid = P_APPNAME;
273:
274:
408:
409: delete from jtf_diagnostic_arg
410: where appid = P_APP_NAME;
411:
412: delete from jtf_diagnostic_prereq
413: where sourceappid = P_APP_NAME;
414:
415: delete from jtf_diagnostic_prereq
416: where prereqid = P_APP_NAME;
411:
412: delete from jtf_diagnostic_prereq
413: where sourceappid = P_APP_NAME;
414:
415: delete from jtf_diagnostic_prereq
416: where prereqid = P_APP_NAME;
417:
418: END DELETE_APP;
419:
509: -- fix for bug 4606418, we were not cleaning
510: -- up the prereqs of a group at the time of deleting a
511: -- group
512:
513: delete from jtf_diagnostic_prereq
514: where sourceid = P_GROUP_NAME
515: and sourceappid = P_APP_NAME;
516:
517: END DELETE_GROUP;
891:
892: -- if flow of control has reached thus far, remove all records
893: -- for the sourceid supplied to the pl/sql layer
894:
895: delete from jtf_diagnostic_prereq
896: where sourceid = p_sourceid
897: and sourceappid = p_sourceappid;
898:
899: IF P_PREREQID IS NOT NULL AND P_PREREQID.COUNT > 0 THEN
1623: -- if reached this far, great. the record is valid and
1624: -- we can insert the record in the table
1625: -- need to complete the insert statement
1626:
1627: insert into jtf_diagnostic_prereq
1628: (SEQUENCE, SOURCEID, PREREQID,
1629: SOURCEAPPID, TYPE, OBJECT_VERSION_NUMBER,
1630: CREATED_BY, LAST_UPDATE_DATE,
1631: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE)
1629: SOURCEAPPID, TYPE, OBJECT_VERSION_NUMBER,
1630: CREATED_BY, LAST_UPDATE_DATE,
1631: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE)
1632: values
1633: (JTF_DIAGNOSTIC_PREREQ_S.NEXTVAL, P_SOURCEID,
1634: P_PREREQID(v_index), P_SOURCEAPPID, P_SOURCETYPE,
1635: 1, P_LUBID, SYSDATE, P_LUBID,
1636: P_LUBID, SYSDATE);
1637:
1714:
1715:
1716: -- if flow of control reaches here, it is alright to
1717: -- rename the group across jtf_diagnostic_group,
1718: -- jtf_diagnostic_test, jtf_diagnostic_arg, jtf_diagnostic_prereq
1719:
1720:
1721: update jtf_diagnostic_group
1722: set groupname = p_newgroupname,
1744:
1745: -- rename the sourceid and
1746: -- the prereqid
1747:
1748: update jtf_diagnostic_prereq
1749: set sourceid = p_newgroupname,
1750: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
1751: LAST_UPDATE_DATE = SYSDATE,
1752: LAST_UPDATED_BY = P_LUBID
1752: LAST_UPDATED_BY = P_LUBID
1753: where sourceid = p_groupname
1754: and sourceappid = p_appid;
1755:
1756: update jtf_diagnostic_prereq
1757: set prereqid = p_newgroupname,
1758: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
1759: LAST_UPDATE_DATE = SYSDATE,
1760: LAST_UPDATED_BY = P_LUBID
2389:
2390: begin
2391: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2392: into db_luby, db_ludate
2393: from jtf_diagnostic_prereq
2394: where sourceid = p_sourceid
2395: and prereqid = p_prereqid
2396: and SOURCEAPPID = p_SOURCEAPPID
2397: and type = p_type;
2406: p_cust_mode))
2407: then*/
2408: -- seed data must not be changed by customers.Hence overwriting data always
2409: -- so that it covers up any changes by mistake
2410: update jtf_diagnostic_prereq
2411: set last_updated_by = f_luby,
2412: last_update_date = f_ludate,
2413: object_version_number = object_version_number + 1,
2414: security_group_id = to_number(P_SEC_GRP_ID)
2423:
2424: when no_data_found then
2425: -- Record doesn't exist - insert in all cases
2426:
2427: insert into jtf_diagnostic_prereq(
2428: SEQUENCE,
2429: SOURCEID,
2430: PREREQID,
2431: SOURCEAPPID,
2437: LAST_UPDATE_LOGIN,
2438: CREATION_DATE,
2439: SECURITY_GROUP_ID)
2440: values(
2441: jtf_diagnostic_prereq_s.nextval,
2442: p_sourceid,
2443: p_prereqid,
2444: p_sourceappid,
2445: p_type,