eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_PURGE dependencies on WF_PURGE

Line 1: package body WF_PURGE as

1: package body WF_PURGE as
2: /* $Header: wfprgb.pls 120.19.12020000.4 2013/02/01 17:46:09 alsosa ship $ */
3:
4: --Private Variables
5: l_docommit boolean;

Line 80: WHERE PERSISTENCE_TYPE = Wf_Purge.persistence_type and NAME=itemtype) WIT, WF_ITEMS WI

76: cursor item2purge is
77: SELECT WI.ITEM_TYPE, WI.ITEM_KEY
78: FROM (SELECT PERSISTENCE_DAYS, NAME
79: FROM WF_ITEM_TYPES
80: WHERE PERSISTENCE_TYPE = Wf_Purge.persistence_type and NAME=itemtype) WIT, WF_ITEMS WI
81: WHERE WI.ITEM_TYPE = WIT.NAME
82: AND WI.END_DATE <= enddate-nvl(WIT.PERSISTENCE_DAYS,0)
83: AND WI.END_DATE > xenddate
84: AND NOT EXISTS

Line 115: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)

111: (select null
112: from WF_ITEM_TYPES WIT
113: where WI.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0)<=enddate
114: and WI.ITEM_TYPE = WIT.NAME
115: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)
116: and not exists
117: (select null
118: from WF_ITEMS WI2
119: WHERE WI2.END_DATE IS NULL

Line 157: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)

153: (select null
154: from WF_ITEM_TYPES WIT
155: where WI.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0)<=enddate
156: and WI.ITEM_TYPE = WIT.NAME
157: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)
158: and not exists
159: (select null
160: from WF_ITEMS WI2
161: WHERE WI2.END_DATE IS NULL

Line 254: l_itemkeyTAB LIMIT wf_purge.commit_frequency;

250: if (force) then
251: -- Bug 4163328
252: -- Use bulk operations to improve performance
253: FETCH item4purge BULK COLLECT INTO l_itemtypeTAB,
254: l_itemkeyTAB LIMIT wf_purge.commit_frequency;
255: exit outer_purge when l_itemkeyTAB.COUNT = 0;
256:
257: -- JWSMITH bug 2070056
258: elsif (itemtype is not null and itemkey is null) then

Line 260: l_itemkeyTAB LIMIT wf_purge.commit_frequency;

256:
257: -- JWSMITH bug 2070056
258: elsif (itemtype is not null and itemkey is null) then
259: FETCH item2purge BULK COLLECT INTO l_itemtypeTAB,
260: l_itemkeyTAB LIMIT wf_purge.commit_frequency;
261: exit outer_purge when l_itemkeyTAB.COUNT = 0;
262:
263: -- CTILLEY bug 3228475
264: elsif (itemtype is not null) then

Line 266: l_itemkeyTAB LIMIT wf_purge.commit_frequency;

262:
263: -- CTILLEY bug 3228475
264: elsif (itemtype is not null) then
265: FETCH item3purge BULK COLLECT INTO l_itemtypeTAB,
266: l_itemkeyTAB LIMIT wf_purge.commit_frequency;
267: exit outer_purge when l_itemkeyTAB.COUNT = 0;
268:
269: else
270: FETCH item5purge BULK COLLECT INTO l_itemtypeTAB,

Line 271: l_itemkeyTAB LIMIT wf_purge.commit_frequency;

267: exit outer_purge when l_itemkeyTAB.COUNT = 0;
268:
269: else
270: FETCH item5purge BULK COLLECT INTO l_itemtypeTAB,
271: l_itemkeyTAB LIMIT wf_purge.commit_frequency;
272: exit outer_purge when l_itemkeyTAB.COUNT = 0;
273: end if;
274:
275: l_keycount := l_itemkeyTAB.COUNT;

Line 457: if (l_keycount >= wf_purge.commit_frequency) then

453: end;
454: --
455: end if;
456:
457: if (l_keycount >= wf_purge.commit_frequency) then
458: exit item_purge_loop;
459: elsif (l_keycount < wf_purge.commit_frequency) then
460: exit outer_purge;
461: end if;

Line 459: elsif (l_keycount < wf_purge.commit_frequency) then

455: end if;
456:
457: if (l_keycount >= wf_purge.commit_frequency) then
458: exit item_purge_loop;
459: elsif (l_keycount < wf_purge.commit_frequency) then
460: exit outer_purge;
461: end if;
462:
463: end loop item_purge_loop; -- item2purge or item3purge loop

Line 534: Wf_Core.Context('Wf_Purge', 'Items', itemtype, itemkey, to_char(enddate));

530: close item5purge;
531: end if;
532:
533:
534: Wf_Core.Context('Wf_Purge', 'Items', itemtype, itemkey, to_char(enddate));
535: raise;
536: end Items;
537:
538: --

Line 620: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type);

616: (select null
617: from WF_ITEM_TYPES WIT
618: where WA.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0)<=enddate
619: and WA.ITEM_TYPE = WIT.NAME
620: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type);
621:
622: --Use itemcurs1 if the rootname is 'ROOT'
623: cursor itemcurs1(begdate in date, enddate in date,
624: roottype in varchar2, rootname in varchar2) is

Line 983: Wf_Core.Context('Wf_Purge', 'Activities', itemtype, to_char(enddate));

979:
980: if (actcurs3%ISOPEN) then
981: close actcurs3;
982: end if;
983: Wf_Core.Context('Wf_Purge', 'Activities', itemtype, to_char(enddate));
984: raise;
985: end Activities;
986:
987: -- procedure entity_changes

Line 1002: wf_core.context('WF_PURGE', 'entity_changes', p_enddate);

998: exception
999: when no_data_found then
1000: null;
1001: when others then
1002: wf_core.context('WF_PURGE', 'entity_changes', p_enddate);
1003: raise;
1004: end;
1005:
1006: --

Line 1048: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)

1044: select null
1045: from WF_ITEM_TYPES WIT
1046: where WN.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0) <= enddate
1047: and WN.MESSAGE_TYPE = WIT.NAME
1048: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)
1049: or not exists(
1050: select null
1051: from WF_ITEM_TYPES WIT
1052: where WN.MESSAGE_TYPE = WIT.NAME))

Line 1078: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)

1074: select null
1075: from WF_ITEM_TYPES WIT
1076: where WN.END_DATE+nvl(WIT.PERSISTENCE_DAYS,0) <= enddate
1077: and WN.MESSAGE_TYPE = WIT.NAME
1078: and WIT.PERSISTENCE_TYPE = Wf_Purge.persistence_type)
1079: or not exists(
1080: select null
1081: from WF_ITEM_TYPES WIT
1082: where WN.MESSAGE_TYPE = WIT.NAME))

Line 1127: AND rownum < Wf_Purge.Commit_Frequency;

1123: FROM wf_item_activity_statuses_h wiash
1124: WHERE wiash.notification_id = wn.group_id)
1125: AND wn.end_date is null
1126: AND wn.begin_date <= enddate
1127: AND rownum < Wf_Purge.Commit_Frequency;
1128:
1129: --Bug 14392753: moved the exit point to here before the potential commit
1130: --happens as it will result in SQL%NOTFOUND set to TRUE.
1131: exit when (sql%NOTFOUND);

Line 1155: FETCH c1 BULK COLLECT INTO l_nidListTAB LIMIT wf_purge.commit_frequency;

1151:
1152: if (itemtype is not null) then
1153: -- Bug 4163328
1154: -- Use bulk operations to improve performance
1155: FETCH c1 BULK COLLECT INTO l_nidListTAB LIMIT wf_purge.commit_frequency;
1156: exit outer_ntf_loop when l_nidListTAB.COUNT = 0;
1157: else
1158: FETCH c2 BULK COLLECT INTO l_nidListTAB LIMIT wf_purge.commit_frequency;
1159: exit outer_ntf_loop when l_nidListTAB.COUNT = 0;

Line 1158: FETCH c2 BULK COLLECT INTO l_nidListTAB LIMIT wf_purge.commit_frequency;

1154: -- Use bulk operations to improve performance
1155: FETCH c1 BULK COLLECT INTO l_nidListTAB LIMIT wf_purge.commit_frequency;
1156: exit outer_ntf_loop when l_nidListTAB.COUNT = 0;
1157: else
1158: FETCH c2 BULK COLLECT INTO l_nidListTAB LIMIT wf_purge.commit_frequency;
1159: exit outer_ntf_loop when l_nidListTAB.COUNT = 0;
1160: end if;
1161:
1162: -- Delete notification attributes

Line 1195: if (l_nidListTAB.COUNT >= wf_purge.commit_frequency) then

1191: FORALL j in l_nidListTAB.FIRST..l_nidListTAB.LAST
1192: delete from WF_NOTIFICATIONS WN
1193: where WN.NOTIFICATION_ID = l_nidListTAB(j);
1194:
1195: if (l_nidListTAB.COUNT >= wf_purge.commit_frequency) then
1196: exit inner_ntf_loop;
1197: elsif (l_nidListTAB.COUNT < wf_purge.commit_frequency) then
1198: exit outer_ntf_loop;
1199: end if;

Line 1197: elsif (l_nidListTAB.COUNT < wf_purge.commit_frequency) then

1193: where WN.NOTIFICATION_ID = l_nidListTAB(j);
1194:
1195: if (l_nidListTAB.COUNT >= wf_purge.commit_frequency) then
1196: exit inner_ntf_loop;
1197: elsif (l_nidListTAB.COUNT < wf_purge.commit_frequency) then
1198: exit outer_ntf_loop;
1199: end if;
1200:
1201: end loop inner_ntf_loop;

Line 1230: Wf_Purge.AdHocDirectory(enddate);

1226: Fnd_Concurrent.Set_Preferred_RBS;
1227: end if;
1228:
1229: -- Purge AdHoc Users/Roles/User_Roles
1230: Wf_Purge.AdHocDirectory(enddate);
1231:
1232: exception
1233: when others then
1234: if (c1%ISOPEN) then

Line 1240: Wf_Core.Context('Wf_Purge', 'Notifications', itemtype, to_char(enddate));

1236: elsif (c2%ISOPEN) then
1237: close c2;
1238: end if;
1239:
1240: Wf_Core.Context('Wf_Purge', 'Notifications', itemtype, to_char(enddate));
1241: raise;
1242: end Notifications;
1243:
1244: --

Line 1304: wf_purge.abortErrorProcess(itemtype, itemkey);

1300:
1301: -- Bug 1636510
1302: -- Before attempting to purge items we will abort any error process
1303: -- if the activity that launched it is now complete.
1304: wf_purge.abortErrorProcess(itemtype, itemkey);
1305:
1306: l_docommit := docommit;
1307: l_runtimeonly := runtimeonly;
1308: wf_purge.items(itemtype=>itemtype, itemkey=>itemkey, enddate=>enddate, docommit=>docommit,purgesigs=>purgesigs);

Line 1308: wf_purge.items(itemtype=>itemtype, itemkey=>itemkey, enddate=>enddate, docommit=>docommit,purgesigs=>purgesigs);

1304: wf_purge.abortErrorProcess(itemtype, itemkey);
1305:
1306: l_docommit := docommit;
1307: l_runtimeonly := runtimeonly;
1308: wf_purge.items(itemtype=>itemtype, itemkey=>itemkey, enddate=>enddate, docommit=>docommit,purgesigs=>purgesigs);
1309:
1310: if (docommit) then
1311: commit;
1312: Fnd_Concurrent.Set_Preferred_RBS;

Line 1319: wf_purge.activities(itemtype=>itemtype, enddate=>enddate);

1315: --Purge design data only if runtime is
1316: --set to false
1317: if (not nvl(runtimeonly,TRUE)) then
1318: --also purge design data from activities
1319: wf_purge.activities(itemtype=>itemtype, enddate=>enddate);
1320: if (docommit) then
1321: commit;
1322: Fnd_Concurrent.Set_Preferred_RBS;
1323: end if;

Line 1326: Wf_Purge.Directory(end_date=>enddate, autocommit=>docommit);

1322: Fnd_Concurrent.Set_Preferred_RBS;
1323: end if;
1324:
1325: --Directory Information
1326: Wf_Purge.Directory(end_date=>enddate, autocommit=>docommit);
1327: if (docommit) then
1328: commit;
1329: Fnd_Concurrent.Set_Preferred_RBS;
1330: end if;

Line 1348: Wf_Core.Context('Wf_Purge', 'Total', itemtype, itemkey, to_char(enddate));

1344: entity_changes(enddate);
1345: end if;
1346: exception
1347: when others then
1348: Wf_Core.Context('Wf_Purge', 'Total', itemtype, itemkey, to_char(enddate));
1349: raise;
1350: end Total;
1351:
1352: --

Line 1373: wf_purge.persistence_type := 'PERM';

1369: runtimeonly in boolean,
1370: purgesigs in pls_integer)
1371: is
1372: begin
1373: wf_purge.persistence_type := 'PERM';
1374:
1375: -- Call Total with new args
1376: Wf_Purge.Total(
1377: itemtype,

Line 1376: Wf_Purge.Total(

1372: begin
1373: wf_purge.persistence_type := 'PERM';
1374:
1375: -- Call Total with new args
1376: Wf_Purge.Total(
1377: itemtype,
1378: itemkey,
1379: enddate,
1380: docommit,

Line 1385: wf_purge.persistence_type := 'TEMP';

1381: nvl(runtimeonly, TRUE),
1382: purgesigs);
1383:
1384: -- Reset persistence type to the default value
1385: wf_purge.persistence_type := 'TEMP';
1386:
1387: exception
1388: when others then
1389: -- Reset persistence type to the default value

Line 1390: wf_purge.persistence_type := 'TEMP';

1386:
1387: exception
1388: when others then
1389: -- Reset persistence type to the default value
1390: wf_purge.persistence_type := 'TEMP';
1391: Wf_Core.Context('Wf_Purge', 'TotalPERM', itemtype, itemkey,
1392: to_char(enddate));
1393: raise;
1394: end TotalPERM;

Line 1391: Wf_Core.Context('Wf_Purge', 'TotalPERM', itemtype, itemkey,

1387: exception
1388: when others then
1389: -- Reset persistence type to the default value
1390: wf_purge.persistence_type := 'TEMP';
1391: Wf_Core.Context('Wf_Purge', 'TotalPERM', itemtype, itemkey,
1392: to_char(enddate));
1393: raise;
1394: end TotalPERM;
1395:

Line 1433: wf_purge.persistence_type := x_persistence_type;

1429: begin
1430: -- Convert arguments from varchar2 to real type.
1431: enddate := sysdate - to_number(age);
1432:
1433: wf_purge.persistence_type := x_persistence_type;
1434: wf_purge.commit_frequency := x_commit_frequency;
1435:
1436: --If runtimeonly 'N' then purge both runtime
1437: --and design data

Line 1434: wf_purge.commit_frequency := x_commit_frequency;

1430: -- Convert arguments from varchar2 to real type.
1431: enddate := sysdate - to_number(age);
1432:
1433: wf_purge.persistence_type := x_persistence_type;
1434: wf_purge.commit_frequency := x_commit_frequency;
1435:
1436: --If runtimeonly 'N' then purge both runtime
1437: --and design data
1438: if (upper(runtimeonly) = 'Y') then

Line 1451: Wf_Purge.Total(

1447: l_purgeCacheData := TRUE;
1448: end if;
1449:
1450: -- Call Total with new args
1451: Wf_Purge.Total(
1452: itemtype,
1453: itemkey,
1454: enddate,
1455: true,

Line 1464: wf_purge.persistence_type := 'TEMP'; -- reset to the default value

1460:
1461: -- Return 0 for successful completion.
1462: errbuf := '';
1463: retcode := '0';
1464: wf_purge.persistence_type := 'TEMP'; -- reset to the default value
1465: wf_purge.commit_frequency := 1000; -- reset to the default value
1466:
1467: exception
1468: when others then

Line 1465: wf_purge.commit_frequency := 1000; -- reset to the default value

1461: -- Return 0 for successful completion.
1462: errbuf := '';
1463: retcode := '0';
1464: wf_purge.persistence_type := 'TEMP'; -- reset to the default value
1465: wf_purge.commit_frequency := 1000; -- reset to the default value
1466:
1467: exception
1468: when others then
1469: -- Retrieve error message into errbuf

Line 1481: wf_purge.persistence_type := 'TEMP';

1477: -- Return 2 for error.
1478: retcode := '2';
1479:
1480: -- Reset persistence type to the default value
1481: wf_purge.persistence_type := 'TEMP';
1482: end TotalConcurrent;
1483:
1484: --
1485: -- Directory

Line 1618: -- l_docommit is private to WF_PURGE. We will commit if either is true

1614: Wf_Core.Token('SYSDATE', to_char(sysdate));
1615: Wf_Core.Raise('WF_FUTURE_END_DATE');
1616: end if;
1617: -- autocommit is particular to this API and can be set from sql*plus whereas
1618: -- l_docommit is private to WF_PURGE. We will commit if either is true
1619: if (autocommit or l_docommit) then
1620: l_commit := true;
1621: end if;
1622:

Line 1633: fetch role_orig_system_cursor bulk collect into roleTab LIMIT wf_purge.commit_frequency;

1629: -- Delete rows in wf_local_user_roles by role_name and wf_local_roles
1630: -- by name as determined
1631: open role_orig_system_cursor(orig_system, end_date);
1632: loop
1633: fetch role_orig_system_cursor bulk collect into roleTab LIMIT wf_purge.commit_frequency;
1634: exit when roleTab.COUNT=0;
1635: for idx in roleTab.FIRST..roleTab.LAST loop
1636: delete from WF_LOCAL_USER_ROLES local
1637: where local.ROLE_NAME = roleTab(idx).name

Line 1658: fetch user_orig_system_cursor bulk collect into roleTab LIMIT wf_purge.commit_frequency;

1654: end loop;
1655: close role_orig_system_cursor;
1656: open user_orig_system_cursor (orig_system, end_date);
1657: loop
1658: fetch user_orig_system_cursor bulk collect into roleTab LIMIT wf_purge.commit_frequency;
1659: exit when roleTab.COUNT=0;
1660: for idx in roleTab.FIRST..roleTab.LAST loop
1661: delete from WF_LOCAL_USER_ROLES local
1662: where local.USER_NAME = roleTab(idx).name

Line 1685: limit wf_purge.commit_frequency;

1681:
1682: open expired_rel_orig_system_cursor (orig_system, end_date);
1683: loop
1684: fetch expired_rel_orig_system_cursor bulk collect into expRoleTab
1685: limit wf_purge.commit_frequency;
1686: exit when expRoleTab.COUNT=0;
1687: for idx in expRoleTab.FIRST..expRoleTab.LAST loop
1688: delete from WF_LOCAL_USER_ROLES local
1689: where local.USER_NAME = expRoleTab(idx).USER_NAME

Line 1716: fetch role_cursor bulk collect into roleTab limit WF_PURGE.COMMIT_FREQUENCY;

1712: -- Delete rows in wf_local_user_roles by role_name and wf_local_roles
1713: -- by name as determined
1714: open role_cursor;
1715: loop
1716: fetch role_cursor bulk collect into roleTab limit WF_PURGE.COMMIT_FREQUENCY;
1717: exit when roleTab.COUNT = 0;
1718: for idx in roleTab.FIRST..roleTab.LAST loop
1719: delete from WF_LOCAL_USER_ROLES local
1720: where local.ROLE_NAME = roleTab(idx).name

Line 1740: fetch user_cursor bulk collect into roleTab limit WF_PURGE.COMMIT_FREQUENCY;

1736: end loop;
1737: close role_cursor;
1738: open user_cursor;
1739: loop
1740: fetch user_cursor bulk collect into roleTab limit WF_PURGE.COMMIT_FREQUENCY;
1741: exit when roleTab.COUNT=0;
1742: for idx in roleTab.FIRST..roleTab.LAST loop
1743: delete from WF_LOCAL_USER_ROLES local
1744: where local.USER_NAME = roleTab(idx).name

Line 1766: WF_PURGE.COMMIT_FREQUENCY;

1762: close user_cursor;
1763: open expired_rel_cursor;
1764: loop
1765: fetch expired_rel_cursor bulk collect into expRoleTab limit
1766: WF_PURGE.COMMIT_FREQUENCY;
1767: exit when expRoleTab.COUNT=0;
1768: for idx in expRoleTab.FIRST..expRoleTab.LAST loop
1769: delete from WF_LOCAL_USER_ROLES local
1770: where local.USER_NAME = expRoleTab(idx).USER_NAME

Line 1811: wf_core.context('WF_PURGE', 'Directory', end_date);

1807: end if;
1808: if (expired_rel_cursor%isopen) then
1809: close expired_rel_cursor;
1810: end if;
1811: wf_core.context('WF_PURGE', 'Directory', end_date);
1812: raise;
1813: end Directory;
1814:
1815: --

Line 1825: Wf_Purge.Directory(end_date);

1821: procedure AdHocDirectory(
1822: end_date in date)
1823: is
1824: begin
1825: Wf_Purge.Directory(end_date);
1826: exception
1827: when OTHERS then
1828: wf_core.context('WF_PURGE', 'AdHocDirectory', end_date);
1829: raise;

Line 1828: wf_core.context('WF_PURGE', 'AdHocDirectory', end_date);

1824: begin
1825: Wf_Purge.Directory(end_date);
1826: exception
1827: when OTHERS then
1828: wf_core.context('WF_PURGE', 'AdHocDirectory', end_date);
1829: raise;
1830: end AdHocDirectory;
1831:
1832: --

Line 1871: wf_core.context('WF_PURGE', 'GetPurgeableCount', p_itemType);

1867: AND PRIOR WI2.PARENT_ITEM_KEY = WI2.ITEM_KEY);
1868: return l_purgeable;
1869: exception
1870: when OTHERS then
1871: wf_core.context('WF_PURGE', 'GetPurgeableCount', p_itemType);
1872: raise;
1873: end;
1874:
1875:

Line 2015: Wf_Core.Context('Wf_Purge', 'AbortErrorProcess', itemtype, itemkey);

2011: if (c_error3%ISOPEN) then
2012: close c_error3;
2013: end if;
2014:
2015: Wf_Core.Context('Wf_Purge', 'AbortErrorProcess', itemtype, itemkey);
2016: raise;
2017:
2018: end AbortErrorProcess;
2019:

Line 2027: -- -- Those requests will be removed with the WF_PURGE.Item API.

2023: -- --
2024: -- -- procedure ProvisionRequests
2025: -- -- Delete old provisiong requests with end_time before argument.
2026: -- -- These provisioning requests are not tied explicity to a item.
2027: -- -- Those requests will be removed with the WF_PURGE.Item API.
2028: -- --
2029: -- -- IN:
2030: -- -- context - The context to match for the requests to remove.
2031: -- -- enddate - Date to obsolete to

Line 2055: -- wf_core.context('WF_PURGE', 'ProvisionRequests');

2051: --
2052: -- begin
2053: --
2054: -- if (enddate > sysdate) then
2055: -- wf_core.context('WF_PURGE', 'ProvisionRequests');
2056: -- Wf_Core.Token('SYSDATE', to_char(sysdate));
2057: -- Wf_Core.Raise('WF_FUTURE_END_DATE');
2058: -- end if;
2059: --

Line 2082: -- ( docommit and (c1%rowcount = wf_purge.commit_frequency));

2078: -- delete from WF_PROV_REQUESTS
2079: -- where prov_request_id = l_prov_request_id;
2080: --
2081: -- exit inner_prv_loop when
2082: -- ( docommit and (c1%rowcount = wf_purge.commit_frequency));
2083: --
2084: -- end loop inner_prv_loop;
2085: --
2086: -- if c1%isopen then

Line 2112: -- wf_core.context('WF_PURGE','ProvisionRequests', context, enddate);

2108: -- when others then
2109: -- if c1%isopen then
2110: -- close c1;
2111: -- end if;
2112: -- wf_core.context('WF_PURGE','ProvisionRequests', context, enddate);
2113: -- end ProvisionRequests;
2114: --
2115: -- --
2116: -- -- ProvisionRequestsConcurrent

Line 2151: -- wf_purge.commit_frequency := x_commit_frequency;

2147: -- end if;
2148: --
2149: --
2150: -- if x_commit_frequency is not null or x_commit_frequency > 0 then
2151: -- wf_purge.commit_frequency := x_commit_frequency;
2152: -- end if;
2153: --
2154: -- -- Call provisionrequest with new args
2155: -- Wf_Purge.ProvisionRequests(context,

Line 2155: -- Wf_Purge.ProvisionRequests(context,

2151: -- wf_purge.commit_frequency := x_commit_frequency;
2152: -- end if;
2153: --
2154: -- -- Call provisionrequest with new args
2155: -- Wf_Purge.ProvisionRequests(context,
2156: -- enddate,
2157: -- true);
2158: --
2159: --

Line 2163: -- wf_purge.commit_frequency := 500; -- reset to the default value

2159: --
2160: -- -- Return 0 for successful completion.
2161: -- errbuf := '';
2162: -- retcode := '0';
2163: -- wf_purge.commit_frequency := 500; -- reset to the default value
2164: --
2165: -- exception
2166: -- when others then
2167: -- -- Retrieve error message into errbuf

Line 2179: -- wf_purge.commit_frequency := 500;

2175: -- -- Return 2 for error.
2176: -- retcode := '2';
2177:
2178: -- -- Reset commit frequency to the default value
2179: -- wf_purge.commit_frequency := 500;
2180: -- end ProvisionRequestsConcurrent;
2181:
2182:
2183:

Line 2184: end WF_PURGE;

2180: -- end ProvisionRequestsConcurrent;
2181:
2182:
2183:
2184: end WF_PURGE;