APPS.WF_DIAGNOSTICS dependencies on WF_BES_CACHE

Line 4171: -- Makes use of WF_BES_CACHE.GetSubscriptions.

4167:
4168: --
4169: -- Get_Evt_Subs_Cac_Info
4170: -- Gets the details of Subscriptions from the BES Cache
4171: -- Makes use of WF_BES_CACHE.GetSubscriptions.
4172: function Get_Evt_Subs_Cac_Info(p_event_name in varchar2)
4173: return varchar2
4174: is
4175: l_result varchar2(32000);

Line 4184: l_cells(1) := 'WH:Event Subscriptions using WF_BES_CACHE API';

4180: j pls_integer;
4181: l_agent_tmp varchar2(80);
4182:
4183: begin
4184: l_cells(1) := 'WH:Event Subscriptions using WF_BES_CACHE API';
4185: Get_table(l_cells, 1, 'H', l_result);
4186: l_cells.DELETE;
4187:
4188: l_cells(1) := '5%:Source Type';

Line 4202: l_subs_list := WF_BES_CACHE.GetSubscriptions(p_event_name, 'LOCAL', null);

4198: l_cells(11) := '10%:On Error Code';
4199: l_cells(12) := '10%:Action Code';
4200: j := 12;
4201:
4202: l_subs_list := WF_BES_CACHE.GetSubscriptions(p_event_name, 'LOCAL', null);
4203:
4204: if (l_subs_list is not null) then
4205: for i in 1..l_subs_list.COUNT loop
4206: l_cells(j+1) := l_subs_list(i).SOURCE_TYPE;