APPS.OKS_RENEW_UTIL_PUB SQL Statements

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

Line: 95

    PROCEDURE UPDATE_RENEWAL_STATUS (p_api_version IN NUMBER,
                                     p_init_msg_list IN VARCHAR2,
                                     x_return_status OUT NOCOPY VARCHAR2,
                                     x_msg_count OUT NOCOPY NUMBER,
                                     x_msg_data OUT NOCOPY VARCHAR2,
                                     P_CHR_ID IN NUMBER,
                                     P_RENEW_STATUS IN VARCHAR2,
                                     P_CHR_STATUS IN VARCHAR2)
    IS
    l_api_name CONSTANT VARCHAR2(30) := 'OKS_RENEW_UTIL';

Line: 137

        OKS_RENEW_UTIL_PVT.UPDATE_RENEWAL_STATUS(
                                                 x_return_status => x_Return_Status,
                                                 P_Chr_Id => P_Chr_Id,
                                                 P_renew_status => P_renew_status,
                                                 P_Chr_status => P_Chr_status
                                                 );

Line: 206

    PROCEDURE Can_Update_Contract(p_api_version IN NUMBER,
                                  p_init_msg_list IN VARCHAR2,
                                  p_chr_id IN NUMBER,
                                  x_can_update_yn OUT NOCOPY VARCHAR2,
                                  x_can_submit_yn OUT NOCOPY VARCHAR2,
                                  x_msg_count OUT NOCOPY NUMBER,
                                  x_msg_data OUT NOCOPY VARCHAR2,
                                  x_return_status OUT NOCOPY VARCHAR2) IS

    l_api_name CONSTANT VARCHAR2(30) := 'OKS_RENEW_UTIL_PUB';

Line: 250

        OKS_RENEW_UTIL_PVT.Can_Update_Contract(p_chr_id => p_chr_id,
                                               x_can_update_yn => x_can_update_yn,
                                               x_can_submit_yn => x_can_submit_yn,
                                               x_msg_count => x_msg_count,
                                               x_msg_data => x_msg_data,
                                               x_return_status => x_return_status);

Line: 319

    END Can_Update_Contract;