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_CORE

Line 200: Wf_Core.Token('SYSDATE', to_char(sysdate));

196: xenddate := to_date(1, 'J');
197: -- Disallow future date in enddate
198: -- Avoid something being purged before its defined persistence period.
199: if (enddate > sysdate) then
200: Wf_Core.Token('SYSDATE', to_char(sysdate));
201: Wf_Core.Raise('WF_FUTURE_END_DATE');
202: end if;
203:
204: if ((itemkey is not null and (instr(itemkey,'%')>0 or itemtype is null))

Line 201: Wf_Core.Raise('WF_FUTURE_END_DATE');

197: -- Disallow future date in enddate
198: -- Avoid something being purged before its defined persistence period.
199: if (enddate > sysdate) then
200: Wf_Core.Token('SYSDATE', to_char(sysdate));
201: Wf_Core.Raise('WF_FUTURE_END_DATE');
202: end if;
203:
204: if ((itemkey is not null and (instr(itemkey,'%')>0 or itemtype is null))
205: or (instr(itemtype,'%')>0)) then

Line 206: wf_core.raise('WFSQL_ARGS');

202: end if;
203:
204: if ((itemkey is not null and (instr(itemkey,'%')>0 or itemtype is null))
205: or (instr(itemtype,'%')>0)) then
206: wf_core.raise('WFSQL_ARGS');
207: end if;
208:
209: -- Build ECX Purge sql
210: --

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 674: Wf_Core.Token('SYSDATE', to_char(sysdate));

670:
671: -- Disallow future date in enddate
672: -- Avoid something being purged before its defined persistence period.
673: if (enddate > sysdate) then
674: Wf_Core.Token('SYSDATE', to_char(sysdate));
675: Wf_Core.Raise('WF_FUTURE_END_DATE');
676: end if;
677:
678: -- Bug 3228475 Disallow partial values for itemtype and activity name

Line 675: Wf_Core.Raise('WF_FUTURE_END_DATE');

671: -- Disallow future date in enddate
672: -- Avoid something being purged before its defined persistence period.
673: if (enddate > sysdate) then
674: Wf_Core.Token('SYSDATE', to_char(sysdate));
675: Wf_Core.Raise('WF_FUTURE_END_DATE');
676: end if;
677:
678: -- Bug 3228475 Disallow partial values for itemtype and activity name
679: if ((itemtype is not null and (instr(name,'%')>0 or itemtype is null))

Line 681: Wf_Core.Raise('WFSQL_ARGS');

677:
678: -- Bug 3228475 Disallow partial values for itemtype and activity name
679: if ((itemtype is not null and (instr(name,'%')>0 or itemtype is null))
680: or (instr(itemtype,'%')>0)) then
681: Wf_Core.Raise('WFSQL_ARGS');
682: end if;
683: <>
684: loop
685: if (itemtype is not null and name is null) then

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 1103: Wf_Core.Token('SYSDATE', to_char(sysdate));

1099:
1100: -- Disallow future date in enddate
1101: -- Avoid something being purged before its defined persistence period.
1102: if (enddate > sysdate) then
1103: Wf_Core.Token('SYSDATE', to_char(sysdate));
1104: Wf_Core.Raise('WF_FUTURE_END_DATE');
1105: end if;
1106:
1107: -- Bug 3228475 Disallow partial values being passed for itemtype

Line 1104: Wf_Core.Raise('WF_FUTURE_END_DATE');

1100: -- Disallow future date in enddate
1101: -- Avoid something being purged before its defined persistence period.
1102: if (enddate > sysdate) then
1103: Wf_Core.Token('SYSDATE', to_char(sysdate));
1104: Wf_Core.Raise('WF_FUTURE_END_DATE');
1105: end if;
1106:
1107: -- Bug 3228475 Disallow partial values being passed for itemtype
1108: if (instr(itemtype,'%')>0) then

Line 1109: Wf_Core.Raise('WFSQL_ARGS');

1105: end if;
1106:
1107: -- Bug 3228475 Disallow partial values being passed for itemtype
1108: if (instr(itemtype,'%')>0) then
1109: Wf_Core.Raise('WFSQL_ARGS');
1110: end if;
1111:
1112: -- End date all the orphan notifications. This end dates all the notifications
1113: -- generated before the enddate parameter value.

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 1291: Wf_Core.Token('SYSDATE', to_char(sysdate));

1287:
1288: -- Disallow future date in enddate
1289: -- Avoid something being purged before its defined persistence period.
1290: if (enddate > sysdate) then
1291: Wf_Core.Token('SYSDATE', to_char(sysdate));
1292: Wf_Core.Raise('WF_FUTURE_END_DATE');
1293: end if;
1294:
1295: -- Bug 3228475 Disallow partial values from being passed

Line 1292: Wf_Core.Raise('WF_FUTURE_END_DATE');

1288: -- Disallow future date in enddate
1289: -- Avoid something being purged before its defined persistence period.
1290: if (enddate > sysdate) then
1291: Wf_Core.Token('SYSDATE', to_char(sysdate));
1292: Wf_Core.Raise('WF_FUTURE_END_DATE');
1293: end if;
1294:
1295: -- Bug 3228475 Disallow partial values from being passed
1296: if ((itemkey is not null and (instr(itemkey,'%')>0 or itemtype is null))

Line 1298: Wf_Core.Raise('WFSQL_ARGS');

1294:
1295: -- Bug 3228475 Disallow partial values from being passed
1296: if ((itemkey is not null and (instr(itemkey,'%')>0 or itemtype is null))
1297: or (instr(itemtype,'%')>0)) then
1298: Wf_Core.Raise('WFSQL_ARGS');
1299: end if;
1300:
1301: -- Bug 1636510
1302: -- Before attempting to purge items we will abort any error process

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 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 1470: wf_core.get_error(errname, errmsg, errstack);

1466:
1467: exception
1468: when others then
1469: -- Retrieve error message into errbuf
1470: wf_core.get_error(errname, errmsg, errstack);
1471: if (errmsg is not null) then
1472: errbuf := errmsg;
1473: else
1474: errbuf := sqlerrm;

Line 1614: Wf_Core.Token('SYSDATE', to_char(sysdate));

1610: begin
1611: -- Disallow future date in enddate
1612: -- Avoid something being purged before its expiration date.
1613: if (end_date > sysdate) then
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

Line 1615: Wf_Core.Raise('WF_FUTURE_END_DATE');

1611: -- Disallow future date in enddate
1612: -- Avoid something being purged before its expiration date.
1613: if (end_date > sysdate) then
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

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 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 1929: Wf_Core.Raise('WFSQL_ARGS');

1925: begin
1926:
1927: if ((itemkey is not null and (instr(itemkey,'%')>0 or itemtype is null))
1928: or (instr(itemtype,'%')>0)) then
1929: Wf_Core.Raise('WFSQL_ARGS');
1930: end if;
1931:
1932: -- Outer loop
1933: <>

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 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 2056: -- Wf_Core.Token('SYSDATE', to_char(sysdate));

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: --
2060: -- if context is null or length(context) = 0 then

Line 2057: -- Wf_Core.Raise('WF_FUTURE_END_DATE');

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: --
2060: -- if context is null or length(context) = 0 then
2061: -- l_context := '%';

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 2168: -- wf_core.get_error(errname, errmsg, errstack);

2164: --
2165: -- exception
2166: -- when others then
2167: -- -- Retrieve error message into errbuf
2168: -- wf_core.get_error(errname, errmsg, errstack);
2169: -- if (errmsg is not null) then
2170: -- errbuf := errmsg;
2171: -- else
2172: -- errbuf := sqlerrm;