899: );
900:
901: /*update control table with the request id */
902:
903: update fun_interface_controls
904: set request_id = v_request_id,
905: date_processed = sysdate
906: where source = p_source
907: and group_id = p_group_id;
1007: select count(*) into l_count
1008: from fun_interface_rejections;
1009:
1010: if l_count = 0 then
1011: Delete from fun_interface_controls where source = p_source
1012: and group_id = p_group_id;
1013: end if;
1014:
1015: EXCEPTION