APPS.FND_SIGNON dependencies on FND_USER_DESKTOP_OBJECTS

Line 558: delete from FND_USER_DESKTOP_OBJECTS

554: is
555: begin
556: if (func_name is null) then
557: -- Delete if value nulled out
558: delete from FND_USER_DESKTOP_OBJECTS
559: where USER_ID = update_desktop_object.user_id
560: and APPLICATION_ID = update_desktop_object.appl_id
561: and RESPONSIBILITY_ID = update_desktop_object.resp_id
562: and TYPE = 'FUNCTION'

Line 566: update FND_USER_DESKTOP_OBJECTS set

562: and TYPE = 'FUNCTION'
563: and SEQUENCE = update_desktop_object.func_sequence;
564: else
565: -- Try for update
566: update FND_USER_DESKTOP_OBJECTS set
567: FUNCTION_NAME = update_desktop_object.func_name,
568: LAST_UPDATE_DATE = sysdate,
569: LAST_UPDATED_BY = update_desktop_object.user_id,
570: LAST_UPDATE_LOGIN = update_desktop_object.login_id

Line 579: insert into FND_USER_DESKTOP_OBJECTS (

575: and SEQUENCE = update_desktop_object.func_sequence;
576:
577: if (sql%rowcount = 0) then
578: -- Insert new row if not found
579: insert into FND_USER_DESKTOP_OBJECTS (
580: DESKTOP_OBJECT_ID,
581: USER_ID,
582: APPLICATION_ID,
583: RESPONSIBILITY_ID,