APPS.ZPB_UTIL_PVT dependencies on WF_DIRECTORY

Line 140: -- P_UserTable WF_DIRECTORY.UserTable

136: -- IN
137: -- P_UserList VARCHAR2
138: -- OUT
139: -- RETURN
140: -- P_UserTable WF_DIRECTORY.UserTable
141: --
142:
143: procedure String_To_UserTable (p_UserList in VARCHAR2,
144: p_UserTable out NOCOPY WF_DIRECTORY.UserTable)

Line 144: p_UserTable out NOCOPY WF_DIRECTORY.UserTable)

140: -- P_UserTable WF_DIRECTORY.UserTable
141: --
142:
143: procedure String_To_UserTable (p_UserList in VARCHAR2,
144: p_UserTable out NOCOPY WF_DIRECTORY.UserTable)
145: is
146:
147: c1 integer;
148: u1 integer := 0;

Line 150: l_users WF_DIRECTORY.UserTable;

146:
147: c1 integer;
148: u1 integer := 0;
149: l_userList varchar2(32000);
150: l_users WF_DIRECTORY.UserTable;
151: l_sessionID number;
152:
153:
154:

Line 173: if wf_directory.useractive(l_userList) = TRUE then

169: if (c1 = 0) then
170:
171: -- b4948928 check if valid user. if not do not add it to table.
172: -- add it to expired list
173: if wf_directory.useractive(l_userList) = TRUE then
174: p_UserTable(u1) := l_userList;
175: u1 := u1 + 1;
176: else
177: set_expired_users(l_sessionID, l_userList);

Line 185: if wf_directory.useractive(substr(l_userList, 1, c1-1)) = TRUE then

181:
182: else
183: -- b4948928 check if valid user. if not do not add it to table.
184: -- add it to expired list
185: if wf_directory.useractive(substr(l_userList, 1, c1-1)) = TRUE then
186: p_UserTable(u1) := substr(l_userList, 1, c1-1);
187: u1 := u1 + 1;
188: else
189: set_expired_users(l_sessionID, substr(l_userList, 1, c1-1));

Line 205: -- instead of WF_DIRECTORY.String_To_UserTable

201: --
202: -- This procedure is written mainly to handle user names which include
203: -- 'Space' in them viz 'GOPI NATH'
204: -- Here, for converting role_users String to Table we call our private procedure
205: -- instead of WF_DIRECTORY.String_To_UserTable
206: -- IN
207: -- role_name - AdHoc role name
208: -- role_users - Space or comma delimited list of apps-based users
209: -- or adhoc users

Line 215: l_users WF_DIRECTORY.UserTable;

211: --
212: procedure AddUsersToAdHocRole(role_name in varchar2,
213: role_users in varchar2)
214: is
215: l_users WF_DIRECTORY.UserTable;
216:
217: begin
218:
219: if (role_users is NOT NULL) then

Line 223: WF_DIRECTORY.AddUsersToAdHocRole2(role_name=>AddUsersToAdHocRole.role_name,

219: if (role_users is NOT NULL) then
220: ZPB_UTIL_PVT.String_To_UserTable (p_UserList=>AddUsersToAdHocRole.role_users,
221: p_UserTable=>l_users);
222:
223: WF_DIRECTORY.AddUsersToAdHocRole2(role_name=>AddUsersToAdHocRole.role_name,
224: role_users=>l_users);
225: end if;
226:
227: exception