DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PUB SQL Statements

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

Line: 20

 FUNCTION update_target_contract(p_chr_id IN NUMBER) RETURN BOOLEAN IS
 BEGIN
   RETURN(OKC_COPY_CONTRACT_PVT.update_target_contract(p_chr_id));
Line: 23

 END update_target_contract;
Line: 734

 PROCEDURE UPDATE_TEMPLATE_CONTRACT (p_api_version   IN NUMBER,
                                     p_init_msg_list IN VARCHAR2,
                                     p_chr_id        IN NUMBER,
                                     p_start_date    IN DATE,
                                     p_end_date      IN DATE,
                                     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) := 'UPDATE_TEMPLATE_CONTRACT';
Line: 761

    OKC_COPY_CONTRACT_PVT.UPDATE_TEMPLATE_CONTRACT(p_api_version   => p_api_version,
				                   p_chr_id        => p_chr_id,
				                   p_start_date    => p_start_date,
				                   p_end_date      => p_end_date,
				                   x_msg_count     => x_msg_count,
				                   x_msg_data      => x_msg_data,
                                                   x_return_status => x_return_status);
Line: 805

  END  UPDATE_TEMPLATE_CONTRACT;