578: is
579: begin
580: if (func_name is null) then
581: -- Delete if value nulled out
582: delete from FND_USER_DESKTOP_OBJECTS
583: where USER_ID = update_desktop_object.user_id
584: and APPLICATION_ID = update_desktop_object.appl_id
585: and RESPONSIBILITY_ID = update_desktop_object.resp_id
586: and TYPE = 'FUNCTION'
586: and TYPE = 'FUNCTION'
587: and SEQUENCE = update_desktop_object.func_sequence;
588: else
589: -- Try for update
590: update FND_USER_DESKTOP_OBJECTS set
591: FUNCTION_NAME = update_desktop_object.func_name,
592: LAST_UPDATE_DATE = sysdate,
593: LAST_UPDATED_BY = update_desktop_object.user_id,
594: LAST_UPDATE_LOGIN = update_desktop_object.login_id
599: and SEQUENCE = update_desktop_object.func_sequence;
600:
601: if (sql%rowcount = 0) then
602: -- Insert new row if not found
603: insert into FND_USER_DESKTOP_OBJECTS (
604: DESKTOP_OBJECT_ID,
605: USER_ID,
606: APPLICATION_ID,
607: RESPONSIBILITY_ID,