[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:
519: -- fix for bug 4606418, we were not cleaning
520: -- up the prereqs of a group at the time of deleting a
521: -- group
522:
523: delete from jtf_diagnostic_prereq
524: where sourceid = P_GROUP_NAME
525: and sourceappid = P_APP_NAME;
526:
527: ELSE
987:
988: -- if flow of control has reached thus far, remove all records
989: -- for the sourceid supplied to the pl/sql layer
990:
991: delete from jtf_diagnostic_prereq
992: where sourceid = p_sourceid
993: and sourceappid = p_sourceappid;
994:
995: IF P_PREREQID IS NOT NULL AND P_PREREQID.COUNT > 0 THEN
1881: -- if reached this far, great. the record is valid and
1882: -- we can insert the record in the table
1883: -- need to complete the insert statement
1884:
1885: insert into jtf_diagnostic_prereq
1886: (SEQUENCE, SOURCEID, PREREQID,
1887: SOURCEAPPID, TYPE, OBJECT_VERSION_NUMBER,
1888: CREATED_BY, LAST_UPDATE_DATE,
1889: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE)
1887: SOURCEAPPID, TYPE, OBJECT_VERSION_NUMBER,
1888: CREATED_BY, LAST_UPDATE_DATE,
1889: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE)
1890: values
1891: (JTF_DIAGNOSTIC_PREREQ_S.NEXTVAL, P_SOURCEID,
1892: P_PREREQID(v_index), P_SOURCEAPPID, P_SOURCETYPE,
1893: 1, P_LUBID, SYSDATE, P_LUBID,
1894: P_LUBID, SYSDATE);
1895:
1972:
1973:
1974: -- if flow of control reaches here, it is alright to
1975: -- rename the group across jtf_diagnostic_group,
1976: -- jtf_diagnostic_test, jtf_diagnostic_arg, jtf_diagnostic_prereq
1977:
1978:
1979: update jtf_diagnostic_group
1980: set groupname = p_newgroupname,
2002:
2003: -- rename the sourceid and
2004: -- the prereqid
2005:
2006: update jtf_diagnostic_prereq
2007: set sourceid = p_newgroupname,
2008: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
2009: LAST_UPDATE_DATE = SYSDATE,
2010: LAST_UPDATED_BY = P_LUBID
2010: LAST_UPDATED_BY = P_LUBID
2011: where sourceid = p_groupname
2012: and sourceappid = p_appid;
2013:
2014: update jtf_diagnostic_prereq
2015: set prereqid = p_newgroupname,
2016: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
2017: LAST_UPDATE_DATE = SYSDATE,
2018: LAST_UPDATED_BY = P_LUBID
2669:
2670: begin
2671: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2672: into db_luby, db_ludate
2673: from jtf_diagnostic_prereq
2674: where sourceid = p_sourceid
2675: and prereqid = p_prereqid
2676: and SOURCEAPPID = p_SOURCEAPPID
2677: and type = p_type;
2686: p_cust_mode))
2687: then*/
2688: -- seed data must not be changed by customers.Hence overwriting data always
2689: -- so that it covers up any changes by mistake
2690: update jtf_diagnostic_prereq
2691: set last_updated_by = f_luby,
2692: last_update_date = f_ludate,
2693: object_version_number = object_version_number + 1,
2694: security_group_id = to_number(P_SEC_GRP_ID)
2703:
2704: when no_data_found then
2705: -- Record doesn't exist - insert in all cases
2706:
2707: insert into jtf_diagnostic_prereq(
2708: SEQUENCE,
2709: SOURCEID,
2710: PREREQID,
2711: SOURCEAPPID,
2717: LAST_UPDATE_LOGIN,
2718: CREATION_DATE,
2719: SECURITY_GROUP_ID)
2720: values(
2721: jtf_diagnostic_prereq_s.nextval,
2722: p_sourceid,
2723: p_prereqid,
2724: p_sourceappid,
2725: p_type,