PACKAGE BODY: APPS.BIV_DBI_TMPL_SEC

Source

1 package body biv_dbi_tmpl_sec as
2 /* $Header: bivsrvrsecb.pls 115.1 2004/02/25 01:57:23 kreardon noship $ */
3 
4 function get_type_sec_where_clause
5 return varchar2
6 is
7 begin
8 
9 /**
10 
11   -- -----------
12   -- 11.5.9 code
13   -- -----------
14 
15   if nvl(fnd_profile.value('CS_SR_USE_TYPE_RESPON_SETUP'),'NO') = 'NO' then
16     return null;
17   end if;
18 
19   return '
20 and exists ( select 1
21              from cs_sr_type_mapping m
22              where m.incident_type_id = fact.incident_type_id
23              and m.responsibility_id = fnd_global.resp_id
24              and trunc(sysdate) between trunc(nvl(m.start_date, sysdate))
25                                     and trunc(nvl(m.end_date,sysdate))
26            )';
27 
28 **/
29 
30   -- -------------
31   -- 11.5.10+ code
32   -- -------------
33 
34 return '
35 and exists
36    ( select 1
37      from cs_incident_types_vl_sec m
38      where incident_subtype = ''INC''
39      and m.incident_type_id = fact.incident_type_id
40    )';
41 
42 end get_type_sec_where_clause;
43 
44 end biv_dbi_tmpl_sec;