APPS.WF_DIAGNOSTICS dependencies on WF_BES_CACHE

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

3816:
3817: --
3818: -- Get_Evt_Subs_Cac_Info
3819: -- Gets the details of Subscriptions from the BES Cache
3820: -- Makes use of WF_BES_CACHE.GetSubscriptions.
3821: function Get_Evt_Subs_Cac_Info(p_event_name in varchar2)
3822: return varchar2
3823: is
3824: l_result varchar2(32000);

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

3829: j pls_integer;
3830: l_agent_tmp varchar2(80);
3831:
3832: begin
3833: l_cells(1) := 'WH:Event Subscriptions using WF_BES_CACHE API';
3834: Get_table(l_cells, 1, 'H', l_result);
3835: l_cells.DELETE;
3836:
3837: l_cells(1) := '5%:Source Type';

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

3847: l_cells(11) := '10%:On Error Code';
3848: l_cells(12) := '10%:Action Code';
3849: j := 12;
3850:
3851: l_subs_list := WF_BES_CACHE.GetSubscriptions(p_event_name, 'LOCAL', null);
3852:
3853: if (l_subs_list is not null) then
3854: for i in 1..l_subs_list.COUNT loop
3855: l_cells(j+1) := l_subs_list(i).SOURCE_TYPE;