APPS.OKL_SSC_CONTRACTS SQL Statements

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

Line: 10

SELECT meaning from fnd_lookups
where lookup_type ='OKL_ACCEPTANCE_METHOD'
and lookup_code = 'SELF_SERVICE';

Line: 35

OKL_CONTRACT_PUB.update_contract_header(
    p_api_version       => l_api_version,
    p_init_msg_list     => OKL_API.G_FALSE,
    x_return_status     => l_return_status,
    x_msg_count         => l_msg_count,
    x_msg_data          => l_msg_data,
    p_restricted_update => OKL_API.G_FALSE,
    p_chrv_rec          => l_chrv_rec,
    p_khrv_rec          => l_khrv_rec,
    p_edit_mode         => 'N',
    x_chrv_rec          => lx_chrv_rec,
    x_khrv_rec          => lx_khrv_rec);