APPS.EDR_PSIG_PAGE_FLOW dependencies on WF_DIRECTORY

Line 776: l_userlist WF_DIRECTORY.UserTable;

772: SELECT distinct USER_NAME from EDR_ESIGNATURES where to_char(event_id)=l_item_key;
773:
774: l_requester VARCHAR2(4000) ;
775: l_user varchar2(100);
776: l_userlist WF_DIRECTORY.UserTable;
777: ui number := 1;
778:
779: l_display_name varchar2(240);
780: l_group varchar2(240);

Line 1184: WF_DIRECTORY.GETROLEDISPLAYNAME(WF_ENGINE.context_text));

1180:
1181:
1182: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,
1183: '#WF_SIGNER_ROLE_DISPLAY_NAME',
1184: WF_DIRECTORY.GETROLEDISPLAYNAME(WF_ENGINE.context_text));
1185: /* SKARIMIS Get the user List */
1186: OPEN GET_USER;
1187: LOOP
1188: fetch GET_USER into l_user;

Line 1199: If (wf_directory.getRoleDisplayName('EDRPSIG_ROLE') is NULL) then

1195: CLOSE GET_USER;
1196:
1197: /* Create ADHOC group */
1198:
1199: If (wf_directory.getRoleDisplayName('EDRPSIG_ROLE') is NULL) then
1200: /* Start Creating the Role */
1201:
1202: wf_directory.CreateAdHocRole2(role_name=>l_group,
1203: role_display_name=>l_display_name,

Line 1202: wf_directory.CreateAdHocRole2(role_name=>l_group,

1198:
1199: If (wf_directory.getRoleDisplayName('EDRPSIG_ROLE') is NULL) then
1200: /* Start Creating the Role */
1201:
1202: wf_directory.CreateAdHocRole2(role_name=>l_group,
1203: role_display_name=>l_display_name,
1204: role_users=>l_userlist,
1205: expiration_date=>NULL);
1206:

Line 1208: wf_directory.RemoveUsersFromAdHocRole(role_name=>'EDRPSIG_ROLE',

1204: role_users=>l_userlist,
1205: expiration_date=>NULL);
1206:
1207: ELSE
1208: wf_directory.RemoveUsersFromAdHocRole(role_name=>'EDRPSIG_ROLE',
1209: role_users=>NULL);
1210:
1211: wf_directory.AddUsersToAdHocRole2(role_name=>'EDRPSIG_ROLE',
1212: role_users=>l_userlist);

Line 1211: wf_directory.AddUsersToAdHocRole2(role_name=>'EDRPSIG_ROLE',

1207: ELSE
1208: wf_directory.RemoveUsersFromAdHocRole(role_name=>'EDRPSIG_ROLE',
1209: role_users=>NULL);
1210:
1211: wf_directory.AddUsersToAdHocRole2(role_name=>'EDRPSIG_ROLE',
1212: role_users=>l_userlist);
1213: END IF;
1214:
1215: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,

Line 1395: wf_directory.RemoveUsersFromAdHocRole(role_name=>'EDRPSIG_ROLE', role_users=>NULL);

1391:
1392: IF p_funcmode = 'RUN' THEN
1393: /* Skarimis */
1394:
1395: wf_directory.RemoveUsersFromAdHocRole(role_name=>'EDRPSIG_ROLE', role_users=>NULL);
1396:
1397: /* Skarimis */
1398:
1399: /* Change following code to derieve Timezone info */

Line 1902: l_userlist WF_DIRECTORY.UserTable;

1898: SELECT distinct USER_NAME from EDR_ESIGNATURES where to_char(event_id)=l_item_key;
1899:
1900: l_requester VARCHAR2(4000);
1901: l_user varchar2(100);
1902: l_userlist WF_DIRECTORY.UserTable;
1903: ui number := 1;
1904: l_display_name varchar2(240);
1905: l_group varchar2(240);
1906: l_ESIGN_ID VARCHAR2(30);

Line 1942: If (wf_directory.getRoleDisplayName('EDRPSIG_ROLE') is NULL) then

1938: CLOSE GET_USER;
1939:
1940: /* Create ADHOC group */
1941:
1942: If (wf_directory.getRoleDisplayName('EDRPSIG_ROLE') is NULL) then
1943: /* Start Creating the Role */
1944:
1945: wf_directory.CreateAdHocRole2(role_name=>l_group,
1946: role_display_name=>l_display_name,

Line 1945: wf_directory.CreateAdHocRole2(role_name=>l_group,

1941:
1942: If (wf_directory.getRoleDisplayName('EDRPSIG_ROLE') is NULL) then
1943: /* Start Creating the Role */
1944:
1945: wf_directory.CreateAdHocRole2(role_name=>l_group,
1946: role_display_name=>l_display_name,
1947: role_users=>l_userlist,
1948: expiration_date=>NULL);
1949: ELSE

Line 1950: wf_directory.RemoveUsersFromAdHocRole(role_name=>'EDRPSIG_ROLE',

1946: role_display_name=>l_display_name,
1947: role_users=>l_userlist,
1948: expiration_date=>NULL);
1949: ELSE
1950: wf_directory.RemoveUsersFromAdHocRole(role_name=>'EDRPSIG_ROLE',
1951: role_users=>NULL);
1952: wf_directory.AddUsersToAdHocRole2(role_name=>'EDRPSIG_ROLE',
1953: role_users=>l_userlist);
1954: END IF;

Line 1952: wf_directory.AddUsersToAdHocRole2(role_name=>'EDRPSIG_ROLE',

1948: expiration_date=>NULL);
1949: ELSE
1950: wf_directory.RemoveUsersFromAdHocRole(role_name=>'EDRPSIG_ROLE',
1951: role_users=>NULL);
1952: wf_directory.AddUsersToAdHocRole2(role_name=>'EDRPSIG_ROLE',
1953: role_users=>l_userlist);
1954: END IF;
1955:
1956: SET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,