APPS.UMX_REG_REQUESTS_PVT dependencies on AK_WEB_USER_SEC_ATTR_VALUES

Line 619: UPDATE AK_WEB_USER_SEC_ATTR_VALUES

615: -- Changes for employee security attributes ( For HRMS Employee)
616: -- populate both the default security attributes with employee_id as value.
617: BEGIN
618: -- ICX_HR_PERSON_ID
619: UPDATE AK_WEB_USER_SEC_ATTR_VALUES
620: SET NUMBER_VALUE = eid ,
621: LAST_UPDATED_BY = fnd_global.user_id,
622: LAST_UPDATE_DATE = SYSDATE ,
623: LAST_UPDATE_LOGIN = fnd_global.login_id

Line 630: INTO ak_web_user_sec_attr_values

626: AND ATTRIBUTE_APPLICATION_ID = 178;
627:
628: IF (sql%rowcount = 0) THEN
629: INSERT
630: INTO ak_web_user_sec_attr_values
631: (
632: web_user_id ,
633: attribute_code ,
634: attribute_application_id,

Line 657: UPDATE AK_WEB_USER_SEC_ATTR_VALUES

653: );
654:
655: END IF;
656: -- TO_PERSON_ID
657: UPDATE AK_WEB_USER_SEC_ATTR_VALUES
658: SET NUMBER_VALUE = eid ,
659: LAST_UPDATED_BY =fnd_global.user_id,
660: LAST_UPDATE_DATE = SYSDATE ,
661: LAST_UPDATE_LOGIN = fnd_global.login_id

Line 668: INTO ak_web_user_sec_attr_values

664: AND ATTRIBUTE_APPLICATION_ID = 178;
665:
666: IF (sql%rowcount = 0) THEN
667: INSERT
668: INTO ak_web_user_sec_attr_values
669: (
670: web_user_id ,
671: attribute_code ,
672: attribute_application_id,