1 PACKAGE BIS_RESPONSIBILITY_PVT AS
2 /* $Header: BISVRSPS.pls 120.0 2005/06/01 15:36:19 appldev noship $ */
3 --
4 /*
5 REM +=======================================================================+
6 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
7 REM | All rights reserved. |
8 REM +=======================================================================+
9 REM | FILENAME |
10 REM | BISVRSPS.pls |
11 REM | |
12 REM | DESCRIPTION |
13 REM | Private API for managing Responsibilities for PMF
14 REM |
15 REM | NOTES |
16 REM | |
17 REM | HISTORY |
18 REM | 15-MAR-99 Ansingha Creation
19 REM | 19-MAY-2005 visuri GSCC Issues bug 4363854 |
20 REM +=======================================================================+
21 */
22 --
23 G_WF_ROLE_AK_REGION CONSTANT VARCHAR2(200) := 'BIS_WF_ROLE';
24 G_WF_ROLE_SHORT_NAME_AK CONSTANT VARCHAR2(200) := 'P_ROLE_SHORT_NAME';
25 G_WF_ROLE_NAME_AK CONSTANT VARCHAR2(200) := 'P_ROLE_DISPLAY_NAME';
26
27 --
28 TYPE Responsibility_Rec_Type IS RECORD (
29 Responsibility_ID NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
30 , Responsibility_Short_Name VARCHAR2(30) := BIS_COMMON_UTILS.G_DEF_CHAR
31 , Responsibility_Name VARCHAR2(100) := BIS_COMMON_UTILS.G_DEF_CHAR
32
33 );
34
35 TYPE Responsibility_Tbl_Type IS TABLE of Responsibility_Rec_Type
36 INDEX BY BINARY_INTEGER;
37 --
38 TYPE Notify_Responsibility_Rec_Type IS RECORD (
39 Notify_Responsibility_ID NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
40 , Notify_Resp_Short_Name VARCHAR2(100) := BIS_COMMON_UTILS.G_DEF_CHAR
41 , Notify_Resp_Name VARCHAR2(240) := BIS_COMMON_UTILS.G_DEF_CHAR
42 );
43 --
44 --
45 TYPE Notify_Responsibility_Tbl_Type IS TABLE of Notify_Responsibility_Rec_Type
46
47 INDEX BY BINARY_INTEGER;
48 --
49 -- PROCEDUREs
50 -- Will retrieve web responsibilities only
51 Procedure Retrieve_User_Responsibilities
52 ( p_api_version IN NUMBER
53 , p_user_id IN NUMBER Default BIS_COMMON_UTILS.G_DEF_NUM
54 , x_Responsibility_Tbl OUT NOCOPY BIS_Responsibility_PVT.Responsibility_Tbl_Type
55 , x_return_status OUT NOCOPY VARCHAR2
56 , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_tbl_Type
57 );
58 --
59 -- PROCEDUREs
60 -- Will retrieve responsibilities of the given version
61 Procedure Retrieve_User_Responsibilities
62 ( p_api_version IN NUMBER
63 , p_user_id IN NUMBER Default BIS_COMMON_UTILS.G_DEF_NUM
64 , p_Responsibility_version IN VARCHAR
65 , x_Responsibility_Tbl OUT NOCOPY BIS_Responsibility_PVT.Responsibility_Tbl_Type
66 , x_return_status OUT NOCOPY VARCHAR2
67 , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_tbl_Type
68 );
69 --
70 --
71 -- PROCEDUREs
72 -- Will retrieve web responsibilities only
73 Procedure Retrieve_All_Responsibilities
74 ( p_api_version IN NUMBER
75 , x_Responsibility_Tbl OUT NOCOPY BIS_Responsibility_PVT.Responsibility_Tbl_Type
76 , x_return_status OUT NOCOPY VARCHAR2
77 , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_tbl_Type
78 );
79 --
80 -- PROCEDUREs
81 -- Will retrieve web responsibilities only
82 Procedure Retrieve_Responsibility
83 ( p_api_version IN NUMBER
84 , p_Responsibility_Rec IN BIS_Responsibility_PVT.Responsibility_rec_Type
85 , x_Responsibility_Rec OUT NOCOPY BIS_Responsibility_PVT.Responsibility_rec_Type
86 , x_return_status OUT NOCOPY VARCHAR2
87 , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_tbl_Type
88 );
89 --
90 -- WE NEED TO PASS IN THE ID ISTEAD OF TARGET_LEVEL_REC SO THAT WE
91 -- DO NOT HAVE CROSSREFRENCES. THAT HANGS THE DATABASE
92 PROCEDURE Validate_Def_Notify_Resp_Id
93 ( p_api_version IN NUMBER
94 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
95 , p_Def_Notify_Resp_Id IN NUMBER
96 , x_return_status OUT NOCOPY VARCHAR2
97 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
98 );
99 --
100 PROCEDURE Retrieve_Notify_Resp_Name
101 ( p_api_version IN NUMBER
102 , p_Notify_resp_short_name IN VARCHAR2
103 , x_Notify_resp_name OUT NOCOPY VARCHAR2
104 , x_return_status OUT NOCOPY VARCHAR2
105 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
106
107 );
108 --
109 PROCEDURE Validate_Notify_Resp_ID
110 ( p_api_version IN NUMBER
111 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
112 , p_Notify_Resp_ID IN NUMBER
113 , x_return_status OUT NOCOPY VARCHAR2
114 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
115 );
116 --
117 PROCEDURE Value_ID_Conversion
118 ( p_api_version IN NUMBER
119 , p_Responsibility_Short_Name IN VARCHAR2
120
121 , p_Responsibility_Name IN VARCHAR2
122 , x_Responsibility_ID OUT NOCOPY NUMBER
123 , x_return_status OUT NOCOPY VARCHAR2
124 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
125 );
126 --
127 PROCEDURE DFR_Value_ID_Conversion
128 ( p_api_version IN NUMBER
129 , p_DF_Responsibility_Short_Name IN VARCHAR2
130 , p_DF_Responsibility_Name IN VARCHAR2
131 , x_DF_Responsibility_ID OUT NOCOPY NUMBER
132 , x_return_status OUT NOCOPY VARCHAR2
133 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
134
135 );
136 --
137 -- removes the responsibilities from p_all_security
138 -- which are in p_security
139 PROCEDURE RemoveDuplicates
140 ( p_security in BIS_Responsibility_PVT.Responsibility_Tbl_type
141 , p_all_security in BIS_Responsibility_PVT.Responsibility_Tbl_type
142 , x_all_security out NOCOPY BIS_Responsibility_PVT.Responsibility_Tbl_type
143 );
144 --
145 --
146 Procedure Get_Notify_Resp_AK_Info
147 ( p_notify_responsibility_rec
148 IN BIS_Responsibility_PVT.Notify_Responsibility_Rec_type
149 , x_attribute_app_id OUT NOCOPY NUMBER
150 , x_attribute_code OUT NOCOPY VARCHAR2
151 , x_attribute_name OUT NOCOPY VARCHAR2
152 , x_region_app_id OUT NOCOPY NUMBER
153 , x_region_code OUT NOCOPY VARCHAR2
154 );
155 --
156 --
157 END BIS_RESPONSIBILITY_PVT;