PACKAGE BODY: APPS.DOM_COMMON_ATTACHMENT_SECURITY

Source

1 PACKAGE BODY DOM_COMMON_ATTACHMENT_SECURITY AS
2 /* $Header: DOMSECPB.pls 120.4 2006/09/20 13:54:38 sabatra noship $ */
3 /*---------------------------------------------------------------------------+
4  | This package contains APIs to reslove docuemnt security mappings          |
5  | based on fnd data security                                                |
6  +---------------------------------------------------------------------------*/
7 FUNCTION GET_ATTACHMENT_PRIVILAGES
8 (
9 p_entity_name IN VARCHAR2,
10 p_pk1_value IN VARCHAR2,
11 p_pk2_value IN VARCHAR2,
12 p_pk3_value IN VARCHAR2,
13 p_pk4_value IN VARCHAR2,
14 p_pk5_value IN VARCHAR2,
15 p_user_name IN VARCHAR2,
16 p_attachment_id IN NUMBER DEFAULT NULL
17 ) RETURN VARCHAR2
18 IS
19 l_function_name VARCHAR2(100);
20 l_function_returned VARCHAR2(300) default null;
21 BEGIN
22 
23 SELECT GET_ATTACH_ACCESS_PLSQL_API INTO l_function_name FROM dom_attachment_entities WHERE entity_name = p_entity_name;
24  EXECUTE IMMEDIATE      'select   '|| l_function_name  || '( :1 , :2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8) from dual' INTO l_function_returned USING IN p_entity_name,
25  IN p_pk1_value , IN p_pk2_value ,IN p_pk3_value ,IN p_pk4_value ,IN p_pk5_value , IN p_user_name ,IN p_attachment_id;
26 
27 RETURN l_function_returned;
28 EXCEPTION
29 WHEN OTHERS then
30 RETURN NULL;
31 
32 END get_attachment_privilages;
33 
34 
35 
36 
37 END DOM_COMMON_ATTACHMENT_SECURITY;