DBA Data[Home] [Help]

APPS.PV_BENFT_STATUS_CHANGE dependencies on WF_DIRECTORY

Line 9: * wf_directory.UserTable type.

5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvstchgb.pls';
6:
7: /**
8: * Procedure to convert comma separated user list to a
9: * wf_directory.UserTable type.
10: **/
11: PROCEDURE CONVERT_LIST_TO_TABLE(p_role_list IN VARCHAR2
12: ,x_role_list_tbl OUT NOCOPY wf_directory.UserTable);
13:

Line 12: ,x_role_list_tbl OUT NOCOPY wf_directory.UserTable);

8: * Procedure to convert comma separated user list to a
9: * wf_directory.UserTable type.
10: **/
11: PROCEDURE CONVERT_LIST_TO_TABLE(p_role_list IN VARCHAR2
12: ,x_role_list_tbl OUT NOCOPY wf_directory.UserTable);
13:
14:
15: PROCEDURE STATUS_CHANGE_notification(
16: p_api_version_number IN NUMBER,

Line 72: l_role_list_tbl WF_DIRECTORY.UserTable; --Bug 5124079

68: l_group_notify_id number;
69: l_context varchar2(1000);
70: l_has_notification boolean := false;
71:
72: l_role_list_tbl WF_DIRECTORY.UserTable; --Bug 5124079
73:
74: BEGIN
75: -- Standard call to check for call compatibility.
76:

Line 207: wf_directory.CreateAdHocRole2(role_name => l_adhoc_role,

203: 'END;'
204: using l_benefit_type, l_itemkey, p_entity_id, l_user_type, p_status;
205:
206: l_adhoc_role := l_itemkey;
207: wf_directory.CreateAdHocRole2(role_name => l_adhoc_role,
208: role_display_name => l_adhoc_role,
209: role_users => l_role_list_tbl);
210:
211: l_context := l_benefit_type || ':' || l_itemkey || ':';

Line 313: * to a wf_directory.UserTable with these names.

309: * Bug 5124097 requires the CreateAdHocRole2 API to be called
310: * instead od CreateAdHocRole so that usernames with blank
311: * spaces can be supported. So this procedure converts a
312: * comma separated list like JOHN SMITH,TOM JONES,JIM BATES
313: * to a wf_directory.UserTable with these names.
314: * - JOHN SMITH
315: * - TOM JONES
316: * - JIM BATES
317: * this is called by the STATUS_CHANGE_notification API just before

Line 323: ,x_role_list_tbl OUT NOCOPY wf_directory.UserTable)

319: *
320: * Updates : Made changes for Bug 5189270.
321: */
322: PROCEDURE CONVERT_LIST_TO_TABLE(p_role_list IN VARCHAR2
323: ,x_role_list_tbl OUT NOCOPY wf_directory.UserTable)
324: IS
325: l_index NUMBER := 1;
326: l_to_position NUMBER := 1;
327: l_from_position NUMBER := 1;