APPS.OKC_OC_INT_PUB SQL Statements

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

Line: 279

PROCEDURE update_quote_from_k(ERRBUF              OUT NOCOPY VARCHAR2
			     ,RETCODE             OUT NOCOPY NUMBER
                	--
                             ,p_contract_number   IN  OKC_K_HEADERS_B.ID%TYPE
                             -- p_contract_number is in fact equal to contract ID
                	--
                             ,p_quote_number      IN  OKX_QUOTE_HEADERS_V.ID1%TYPE
                             -- p_quote_number is in fact equal to quote ID
                	--
                             ,p_trace_mode        IN  VARCHAR2

                              ) IS

l_api_version           CONSTANT NUMBER := 1;

Line: 308

  OKC_OC_INT_PUB.update_quote_from_k(p_api_version   => l_api_version
                                    ,p_init_msg_list => OKC_API.G_FALSE
                                    ,p_commit        => OKC_API.G_FALSE
				--
                                    ,p_quote_id      => p_quote_number
                                    ,p_contract_id   => p_contract_number
				--
                                    ,p_trace_mode    => l_trace_mode
				--
                                    ,x_return_status => lx_return_status
                                    ,x_msg_count     => lx_msg_count
                                    ,x_msg_data      => lx_msg_data );

Line: 335

END update_quote_from_k;

Line: 341

PROCEDURE update_quote_from_k(p_api_version     IN  NUMBER
                             ,p_init_msg_list   IN  VARCHAR2
                             ,p_commit          IN  VARCHAR2
			--
                             ,p_quote_id        IN  OKX_QUOTE_HEADERS_V.id1%TYPE
                             ,p_contract_id     IN  OKC_K_HEADERS_B.ID%TYPE
			--
                             ,p_trace_mode      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) := 'UPDATE_Q_FROM_K';

Line: 371

** Business Flows( Update Quote API's were not ready.., Quote Status model
** was not ready etc..)
** Also it was agreed that this peice of code would be owned by iStore team
** if at a later date we had to support business flow that requires updating
** quote from a contract..
** Date: 09/13/2001
**  -- call START_ACTIVITY to create savepoint, check compatibility
**  -- and initialize message list
**  lx_return_status := OKC_API.START_ACTIVITY(
**					p_api_name      => l_api_name,
**					p_pkg_name      => g_pkg_name,
**					p_init_msg_list => p_init_msg_list,
**					l_api_version   => l_api_version,
**					p_api_version   => p_api_version,
**					p_api_type      => g_api_type,
**					x_return_status => lx_return_status);

Line: 409

**  OKC_OC_INT_KTQ_PVT.update_quote_from_k(
**					 p_api_version   => l_api_version
**                                        ,p_init_msg_list => OKC_API.G_FALSE
**				--
**                                        ,p_quote_id      => p_quote_id
**                                        ,p_contract_id   => p_contract_id
**				--
**                                        ,p_trace_mode    => l_trace_mode
**				--
**                                        ,x_return_status => lx_return_status
**                                        ,x_msg_count     => lx_msg_count
**                                        ,x_msg_data      => lx_msg_data  );

Line: 483

END update_quote_from_k;