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 31: WF_CACHE.Reset;

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

Line 243: WF_CACHE.Reset;

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

Line 437: WF_CACHE.Reset;

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

Line 578: WF_CACHE.Reset;

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

Line 729: WF_CACHE.Reset;

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

Line 898: WF_CACHE.Reset;

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

Line 1120: WF_CACHE.Reset;

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

Line 1589: WF_CACHE.Reset;

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

Line 1752: WF_CACHE.Reset;

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

Line 2012: WF_CACHE.Reset;

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

Line 2158: WF_CACHE.Reset;

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

Line 2275: WF_CACHE.Reset;

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

Line 2321: WF_CACHE.Reset;

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

Line 2367: WF_CACHE.Reset;

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

Line 2415: WF_CACHE.Reset;

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

Line 2494: WF_CACHE.Reset;

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

Line 2539: WF_CACHE.Reset;

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

Line 2590: WF_CACHE.Reset;

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

Line 2707: WF_CACHE.Reset;

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

Line 2759: WF_CACHE.Reset;

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

Line 2833: WF_CACHE.Reset;

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

Line 2885: WF_CACHE.Reset;

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

Line 2935: WF_CACHE.Reset;

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

Line 3968: WF_CACHE.Reset;

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

Line 4493: WF_CACHE.Reset;

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

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

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

Line 4672: if (NOT WF_CACHE.BeginTransaction) then

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

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

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

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

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

Line 4686: if (NOT WF_CACHE.EndTransaction) then

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