APPS.IEO_ICSM_CMD_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

        select status into node_status from IEO_NODES where node_id = p_node_id ;

Line: 24

        select status into server_status from IEO_SVR_RT_INFO where server_id = p_server_id ;

Line: 1022

    PROCEDURE DELETE_FILE
    (
        p_api_version       IN  NUMBER,
        p_init_msg_list     IN  VARCHAR2 Default FND_API.G_FALSE,
        p_commit            IN  VARCHAR2 Default FND_API.G_FALSE,

        p_node_id           IN  NUMBER,
        p_server_name       IN  VARCHAR2,
        p_file_name         IN  VARCHAR2,

        x_return_status     OUT NOCOPY VARCHAR2,
        x_msg_count         OUT NOCOPY NUMBER,
        x_msg_data          OUT NOCOPY VARCHAR2
    )
    IS
        l_api_name          CONSTANT VARCHAR2(30)   := 'DELETE_FILE';

Line: 1071

        xml_data := 'DELETE_FILE ' || p_server_name || ' ' || p_file_name;

Line: 1127

    END DELETE_FILE;