DBA Data[Home] [Help]

APPS.FUN_OPEN_INTERFACE_PKG dependencies on FUN_INTERFACE_CONTROLS

Line 903: update fun_interface_controls

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;

Line 1011: Delete from fun_interface_controls where source = p_source

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