[Home] [Help]
PACKAGE: APPS.ZPB_BISM
Source
1 PACKAGE ZPB_BISM AS
2 /* $Header: zpbbism.pls 120.2.12010.2 2006/08/03 12:14:56 appldev noship $ */
3
4 PKG_NAME CONSTANT VARCHAR2(8) := 'zpb_bism';
5
6 -- The privileges
7 LIST_PRIV CONSTANT INTEGER := 10;
8 READ_PRIV CONSTANT INTEGER := 20;
9 ADD_FOLDER_PRIV CONSTANT INTEGER := 30;
10 WRITE_PRIV CONSTANT INTEGER := 40;
11 LIST_PRIV CONSTANT INTEGER := 50;
12
13 LIST CONSTANT VARCHAR2(4) := 'LIST';
14 READ CONSTANT VARCHAR2(4) := 'READ';
15 ADD_FOLDER CONSTANT VARCHAR2(10) := 'ADD FOLDER';
16 WRITE CONSTANT VARCHAR2(5) := 'WRITE';
17 LIST_PRIV CONSTANT VARCHAR2(12) := 'FULL CONTROL';
18
19 -- The responsibilities and users.
20 ANALYST CONSTANT VARCHAR2(16):= 'ZPB_ANALYST_RESP';
21 MANAGER CONSTANT VARCHAR2(16):= 'ZPB_MANAGER_RESP';
22 CONTROLLER CONSTANT VARCHAR2(19):= 'ZPB_CONTROLLER_RESP';
23 SUPER_CONTROLLER CONSTANT VARCHAR2(25):= 'ZPB_SUPER_CONTROLLER_RESP';
24 BIBEANS_ROOT_USER CONSTANT VARCHAR2(4) := 'APPS';
25 BIBEANS_ROOT_FOLDER CONSTANT VARCHAR2(1) := '1';
26
27 -------------------------------------------------------------------------------
28 -- GET_BISM_SUBJECT_ID - Given a user_id eg. 1008187, returns the
29 -- bism subject id
30 --
31 -- IN: p_user_id - FND User id, integer
32 -- OUT: l_subject_id - bism_subjects.subject_id, raw
33 -------------------------------------------------------------------------------
34
35 FUNCTION get_bism_subject_id (
36 p_user_id IN fnd_user.user_id%TYPE)
37 return bism_subjects.subject_id%TYPE;
38
39 -------------------------------------------------------------------------------
40 -- GET_BISM_SUBJECT_ID - Given a varchar2 user_id eg. '1008187',
41 -- returns the raw bism subject id.
42 -- calls.
43 --
44 -- IN: p_user_id - FND User id, varchar2
45 -- OUT: l_subject_id - bism_subjects.subject_id, raw
46 -------------------------------------------------------------------------------
47
48 FUNCTION get_bism_subject_id (
49 p_user_id IN varchar2)
50 return bism_subjects.subject_id%TYPE;
51
52 -------------------------------------------------------------------------------
53 -- GET_BISM_SUBJECT_ID_FROM_NAME - Given a user_name eg. 'JSMITH', returns the
54 -- bism subject id
55 --
56 -- IN: p_user_name - FND User name e.g. JSMITH
57 -- OUT: l_subject_id - bism_subjects.subject_id, raw
58 -------------------------------------------------------------------------------
59
60 FUNCTION get_bism_subject_id_from_name (
61 p_user_name IN fnd_user.user_name%TYPE)
62 return bism_subjects.subject_id%TYPE;
63
64 -------------------------------------------------------------------------------
65 -- GET_BISM_SUBJECT_ID_FROM_RESP - Given a responsibility key eg. 'ZPB_MANAGER_RESP',
66 -- returns the bism subject id
67 --
68 -- IN: p_resp_key - FND responsibility key e.g. ZPB_MANAGER_RESP, varchar2
69 -- OUT: l_subject_id - bism_subjects.subject_id, raw
70 -------------------------------------------------------------------------------
71
72 FUNCTION get_bism_subject_id_from_resp (
73 p_resp_key IN fnd_responsibility.responsibility_key%TYPE)
74 return bism_subjects.subject_id%TYPE;
75
76 -------------------------------------------------------------------------------
77 -- GET_BISM_OBJECT_ID - Given an object path, returns the bism object id
78 --
79 -- IN: p_object_path - path 'oracle/apps/zpb/BusArea...'
80 -- IN: p_bism_subject_id - raw subject_id
81 -- OUT: l_folder_id - bism_subjects.folder_id, raw
82 -------------------------------------------------------------------------------
83
84 FUNCTION get_bism_object_id (
85 p_object_path IN varchar2,
86 p_bism_subject_id IN bism_subjects.subject_id%TYPE)
87 return bism_objects.folder_id%TYPE;
88
89 -------------------------------------------------------------------------------
90 -- GET_BISM_OBJECT_DESC - Given an object path, and apps numeric, returns the
91 -- object description.
92 --
93 -- IN: p_object_path - path 'oracle/apps/zpb/BusArea...'
94 -- IN: p_user_id - apps numeric id
95 -- OUT: l_bism_object_desc - varchar2
96 -------------------------------------------------------------------------------
97
98 FUNCTION get_bism_object_desc (
99 p_object_path IN varchar2,
100 p_user_id IN FND_USER.USER_ID%TYPE default NULL)
101 return BISM_OBJECTS.DESCRIPTION%TYPE;
102
103 -------------------------------------------------------------------------------
104 -- DELETE_BISM_OBJECT - Given a folder path, object_name and apps numeric
105 -- userid, deletes the BISM object
106 --
107 -- IN: p_folder_path - path 'oracle/apps/zpb/BusArea...', varchar2
108 -- IN: p_object_name - object name 'USERDIR', varchar2
109 -- IN: p_user_id - fnd_user.user_id, varchar2
110 -------------------------------------------------------------------------------
111
112 PROCEDURE delete_bism_object (
113 p_folder_path varchar2,
114 p_object_name BISM_OBJECTS.OBJECT_NAME%TYPE,
115 p_user_id varchar2 default NULL);
116
117
118 -------------------------------------------------------------------------------
119 -- DELETE_BISM_FOLDER - Given an folder path and user id,
120 -- deletes the BISM folder
121 --
122 -- IN: p_folder_path - path 'oracle/apps/zpb/BusArea25/...', varchar2
123 -- IN: p_user_id - fnd_user.user_id, number
124 -------------------------------------------------------------------------------
125
126 PROCEDURE delete_bism_folder (
127 p_folder_path varchar2,
128 p_user_id IN fnd_user.user_id%TYPE);
129
130 -------------------------------------------------------------------------------
131 -- DELETE_BISM_FOLDER_WO_SECURITY - Given an folder path and apps userid
132 -- deletes the BISM object using APPS id,
133 -- id has to be valid bibeans user but does
134 -- not require write access to folder for deletion.
135 --
136 -- IN: p_folder_path - path 'oracle/apps/zpb/BusArea25/...', varchar2
137 -- IN: p_user_id - fnd_user.user_id, integer
138 -------------------------------------------------------------------------------
139
140 PROCEDURE delete_bism_folder_wo_security (
141 p_folder_path varchar2,
142 p_user_id IN fnd_user.user_id%TYPE);
143
144 END ZPB_BISM;