APPS.IGS_SC_BULK_ASSIGN dependencies on WF_LOCAL_USER_ROLES

Line 266: FROM WF_LOCAL_USER_ROLES

262:
263: CURSOR DUP_ROLES_CHK_C(UserId NUMBER,RoleName VARCHAR2,RolrOrgSystem VARCHAR2,
264: RoleOrgSysId NUMBER, UsrOrgSystem VARCHAR2,UsrName VARCHAR2) IS
265: SELECT 1, START_DATE /*while assigning roles check if person is associated with mul FND USER */
266: FROM WF_LOCAL_USER_ROLES
267: WHERE user_orig_system_id =UserId AND
268: user_name=UsrName AND
269: role_name= RoleName AND
270: user_orig_system = UsrOrgSystem AND

Line 563: /*Now iterate through UserRoles array to insert record into wf_local_user_roles */

559: FND_MESSAGE.SET_TOKEN('PERS_NUM',l_person_num);
560: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
561: ELSE
562:
563: /*Now iterate through UserRoles array to insert record into wf_local_user_roles */
564: FOR i IN 1..l_usrroles_array.COUNT
565: LOOP
566: IF l_enddate_array(i) IS NULL THEN
567: l_Inf_date := null ; --remove the logic for infinite date.