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_LOAD dependencies on WF_CACHE

Line 32: WF_CACHE.Reset;

28: n_dname varchar2(80);
29: l_name varchar2(8);
30: begin
31: -- Reset any caches that might be running.
32: WF_CACHE.Reset;
33:
34: n_dname := x_display_name;
35: begin
36: select NAME, DISPLAY_NAME, NAME

Line 244: WF_CACHE.Reset;

240: l_name varchar2(30);
241: old_sequence number;
242: begin
243: -- Reset any caches that might be running.
244: WF_CACHE.Reset;
245:
246: -- Check for unique index violations
247: -- try to resolve the problem by appending '@'
248: -- to the incoming display name

Line 438: WF_CACHE.Reset;

434: n_dname varchar2(80);
435: l_name varchar2(30);
436: begin
437: -- Reset any caches that might be running.
438: WF_CACHE.Reset;
439:
440: -- Set the new display name
441: n_dname := x_display_name;
442:

Line 579: WF_CACHE.Reset;

575: n_dname varchar2(80);
576: l_name varchar2(30);
577: begin
578: -- Reset any caches that might be running.
579: WF_CACHE.Reset;
580:
581: -- Check for unique index violations
582: -- try to resolve the problem by appending '@'
583: -- to the incoming meaning

Line 730: WF_CACHE.Reset;

726: protection_level number;
727: customization_level number;
728: begin
729: -- Reset any caches that might be running.
730: WF_CACHE.Reset;
731:
732: -- Check protection level
733: x_level_error := 0;
734: begin

Line 899: WF_CACHE.Reset;

895: l_name varchar2(30);
896: old_sequence number;
897: begin
898: -- Reset any caches that might be running.
899: WF_CACHE.Reset;
900:
901: -- Check for unique index violations
902: -- try to resolve the problem by appending '@'
903: -- to the incoming display name

Line 1121: WF_CACHE.Reset;

1117: n_dname varchar2(240);
1118: l_name varchar2(30);
1119: begin
1120: -- Reset any caches that might be running.
1121: WF_CACHE.Reset;
1122:
1123: -- Check protection level,
1124: -- and get version number and begin/end-dates for version currently
1125: -- active for x_effective_date.

Line 1590: WF_CACHE.Reset;

1586: l_date_default date := '';
1587: old_sequence number;
1588: begin
1589: -- Reset any caches that might be running.
1590: WF_CACHE.Reset;
1591:
1592: -- Translate x_default to appropriate type
1593: if ((x_value_type = 'CONSTANT') and (x_type = 'NUMBER')) then
1594: l_number_default := to_number(x_default);

Line 1753: WF_CACHE.Reset;

1749:
1750: role_info_tbl wf_directory.wf_local_roles_tbl_type;
1751: begin
1752: -- Reset any caches that might be running.
1753: WF_CACHE.Reset;
1754:
1755: -- Check protection level
1756: x_level_error := 0;
1757: begin

Line 2013: WF_CACHE.Reset;

2009: l_number_value number := '';
2010: l_date_value date := '';
2011: begin
2012: -- Reset any caches that might be running.
2013: WF_CACHE.Reset;
2014:
2015: -- Translate x_value to appropriate type.
2016: -- First have to get the type of this activity attr.
2017: --

Line 2159: WF_CACHE.Reset;

2155: protection_level number;
2156: customization_level number;
2157: begin
2158: -- Reset any caches that might be running.
2159: WF_CACHE.Reset;
2160:
2161: -- Check protection level
2162: x_level_error := 0;
2163: begin

Line 2276: WF_CACHE.Reset;

2272: protection_level number;
2273: customization_level number;
2274: begin
2275: -- Reset any caches that might be running.
2276: WF_CACHE.Reset;
2277:
2278: -- Check protection level
2279: x_level_error := 0;
2280: select PROTECT_LEVEL, CUSTOM_LEVEL

Line 2322: WF_CACHE.Reset;

2318: protection_level number;
2319: customization_level number;
2320: begin
2321: -- Reset any caches that might be running.
2322: WF_CACHE.Reset;
2323:
2324: -- Check protection level
2325: x_level_error := 0;
2326: select PROTECT_LEVEL, CUSTOM_LEVEL

Line 2368: WF_CACHE.Reset;

2364: protection_level number;
2365: customization_level number;
2366: begin
2367: -- Reset any caches that might be running.
2368: WF_CACHE.Reset;
2369:
2370: X_LEVEL_ERROR := 0;
2371: select MIN(protect_level), MAX(custom_level)
2372: into protection_level, customization_level

Line 2416: WF_CACHE.Reset;

2412: pragma exception_init(fk_violation, -2292);
2413:
2414: begin
2415: -- Reset any caches that might be running.
2416: WF_CACHE.Reset;
2417:
2418: -- Check protection level
2419: x_level_error := 0;
2420: select PROTECT_LEVEL, CUSTOM_LEVEL, PERSISTENCE_TYPE

Line 2495: WF_CACHE.Reset;

2491: protection_level number;
2492: customization_level number;
2493: begin
2494: -- Reset any caches that might be running.
2495: WF_CACHE.Reset;
2496:
2497: -- Check protection level
2498: x_level_error := 0;
2499: select PROTECT_LEVEL, CUSTOM_LEVEL

Line 2540: WF_CACHE.Reset;

2536: protection_level number;
2537: customization_level number;
2538: begin
2539: -- Reset any caches that might be running.
2540: WF_CACHE.Reset;
2541:
2542: -- Check protection level
2543: x_level_error := 0;
2544: select PROTECT_LEVEL, CUSTOM_LEVEL

Line 2591: WF_CACHE.Reset;

2587: pragma exception_init(fk_violation, -2292);
2588:
2589: begin
2590: -- Reset any caches that might be running.
2591: WF_CACHE.Reset;
2592:
2593: -- Check protection level
2594: x_level_error := 0;
2595: select PROTECT_LEVEL, CUSTOM_LEVEL

Line 2708: WF_CACHE.Reset;

2704: protection_level NUMBER;
2705: customization_level NUMBER;
2706: begin
2707: -- Reset any caches that might be running.
2708: WF_CACHE.Reset;
2709:
2710: -- Check protection level
2711: x_level_error := 0;
2712: select PROTECT_LEVEL, CUSTOM_LEVEL

Line 2760: WF_CACHE.Reset;

2756: customization_level number;
2757: l_persistence_type varchar2(8);
2758: begin
2759: -- Reset any caches that might be running.
2760: WF_CACHE.Reset;
2761:
2762: -- Check protection level
2763: x_level_error := 0;
2764:

Line 2834: WF_CACHE.Reset;

2830: p_result_code in varchar2 )
2831: is
2832: begin
2833: -- Reset any caches that might be running.
2834: WF_CACHE.Reset;
2835:
2836: if (p_previous_step is null and p_next_step is null) then
2837: -- do not delete anything if both are null
2838: return;

Line 2886: WF_CACHE.Reset;

2882: l_icon_geometry varchar2(2000);
2883: comma_position number;
2884: begin
2885: -- Reset any caches that might be running.
2886: WF_CACHE.Reset;
2887:
2888: select ICON_GEOMETRY, ACTIVITY_NAME, INSTANCE_LABEL
2889: into l_icon_geometry, p_activity_name, p_instance_label
2890: from WF_PROCESS_ACTIVITIES

Line 2936: WF_CACHE.Reset;

2932: l_body varchar2(4000);
2933: l_html_body varchar2(4000);
2934: begin
2935: -- Reset any caches that might be running.
2936: WF_CACHE.Reset;
2937:
2938: Wf_Load.Get_Message(p_type, p_name, l_protect_level, l_custom_level,
2939: l_default_priority, l_display_name, l_description,
2940: l_subject, l_body, l_html_body);

Line 3969: WF_CACHE.Reset;

3965: l_runnable_flag varchar2(1);
3966: l_version number;
3967: begin
3968: -- Reset any caches that might be running.
3969: WF_CACHE.Reset;
3970:
3971: begin
3972: Wf_Load.GET_ACTIVITY (
3973: p_item_type=>p_item_type,

Line 4494: WF_CACHE.Reset;

4490: l_protect_level number;
4491: l_custom_level number;
4492: begin
4493: -- Reset any caches that might be running.
4494: WF_CACHE.Reset;
4495:
4496: -- Get Lookup
4497: Wf_Load.Get_Lookup(x_lookup_type, x_lookup_code,
4498: l_meaning, l_description, l_protect_level, l_custom_level);

Line 4666: -- Calls WF_CACHE.BeginTransaction() to control the calls to WF_CACHE.Reset()

4662:
4663: --
4664: -- BeginTransaction
4665: -- (PRIVATE)
4666: -- Calls WF_CACHE.BeginTransaction() to control the calls to WF_CACHE.Reset()
4667: -- so there is not unnecessary locking or update to WFCACHE_META_UPD.
4668: -- Calling this api mandates that EndTransaction is called BEFORE control is
4669: -- returned.
4670: PROCEDURE BeginTransaction

Line 4673: if (NOT WF_CACHE.BeginTransaction) then

4669: -- returned.
4670: PROCEDURE BeginTransaction
4671: is
4672: begin
4673: if (NOT WF_CACHE.BeginTransaction) then
4674: NULL; --We are ignoring a false condition but may later need to handle.
4675: end if;
4676: end;
4677:

Line 4681: -- Calls WF_CACHE.EndTransaction() to signal the end of the transaction and to

4677:
4678: --
4679: -- EndTransaction
4680: -- (PRIVATE)
4681: -- Calls WF_CACHE.EndTransaction() to signal the end of the transaction and to
4682: -- call WF_CACHE.Reset() which will update WFCACHE_META_UPD.
4683: -- WARNING: THIS API WILL ISSUE A COMMIT!
4684: PROCEDURE EndTransaction
4685: is

Line 4682: -- call WF_CACHE.Reset() which will update WFCACHE_META_UPD.

4678: --
4679: -- EndTransaction
4680: -- (PRIVATE)
4681: -- Calls WF_CACHE.EndTransaction() to signal the end of the transaction and to
4682: -- call WF_CACHE.Reset() which will update WFCACHE_META_UPD.
4683: -- WARNING: THIS API WILL ISSUE A COMMIT!
4684: PROCEDURE EndTransaction
4685: is
4686: begin

Line 4687: if (NOT WF_CACHE.EndTransaction) then

4683: -- WARNING: THIS API WILL ISSUE A COMMIT!
4684: PROCEDURE EndTransaction
4685: is
4686: begin
4687: if (NOT WF_CACHE.EndTransaction) then
4688: NULL; --We are ignoring a false condition but may later need to handle.
4689: end if;
4690: commit; --Commit the work.
4691: end;