DBA Data[Home] [Help]

APPS.OKC_OC_INT_PUB dependencies on OKX_QUOTE_HEADERS_V

Line 48: lx_quote_id okx_quote_headers_v.id1%TYPE;

44: ) IS
45:
46: l_api_version CONSTANT NUMBER := 1;
47: l_rel_type OKC_K_REL_OBJS.rty_code%TYPE:=OKC_OC_INT_KTQ_PVT.g_rlt_cod_qrk;
48: lx_quote_id okx_quote_headers_v.id1%TYPE;
49:
50: BEGIN
51: --
52: -- call full version of create_quote_from_k

Line 91: lx_quote_id okx_quote_headers_v.id1%TYPE := NULL;

87: ,p_trace_mode IN VARCHAR2
88: ) IS
89:
90: l_api_version CONSTANT NUMBER := 1;
91: lx_quote_id okx_quote_headers_v.id1%TYPE := NULL;
92: lx_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
93: lx_msg_count NUMBER := 0;
94: lx_msg_data VARCHAR2(2000);
95: l_trace_mode VARCHAR2(1) := OKC_API.G_TRUE;

Line 148: ,x_quote_id OUT NOCOPY okx_quote_headers_v.id1%TYPE

144: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
145: ,p_rel_type IN OKC_K_REL_OBJS.rty_code%TYPE
146: --
147: ,p_trace_mode IN VARCHAR2
148: ,x_quote_id OUT NOCOPY okx_quote_headers_v.id1%TYPE
149: ) IS
150:
151: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_Q_FROM_K';
152: l_api_version CONSTANT NUMBER := 1;

Line 285: ,p_quote_number IN OKX_QUOTE_HEADERS_V.ID1%TYPE

281: --
282: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
283: -- p_contract_number is in fact equal to contract ID
284: --
285: ,p_quote_number IN OKX_QUOTE_HEADERS_V.ID1%TYPE
286: -- p_quote_number is in fact equal to quote ID
287: --
288: ,p_trace_mode IN VARCHAR2
289:

Line 345: ,p_quote_id IN OKX_QUOTE_HEADERS_V.id1%TYPE

341: PROCEDURE update_quote_from_k(p_api_version IN NUMBER
342: ,p_init_msg_list IN VARCHAR2
343: ,p_commit IN VARCHAR2
344: --
345: ,p_quote_id IN OKX_QUOTE_HEADERS_V.id1%TYPE
346: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
347: --
348: ,p_trace_mode IN VARCHAR2
349: --

Line 702: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1

698: -- Purpose: Create a contract from a quote.
699: -- This will be a wrapper for create_k_from_quote
700: -- procedure, created for running it as a conc prog.
701:
702: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
703: PROCEDURE create_k_from_quote(ERRBUF OUT NOCOPY VARCHAR2
704: ,RETCODE OUT NOCOPY NUMBER
705: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
706: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE

Line 705: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

701:
702: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
703: PROCEDURE create_k_from_quote(ERRBUF OUT NOCOPY VARCHAR2
704: ,RETCODE OUT NOCOPY NUMBER
705: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
706: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE
707: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
708: ,p_template_version IN NUMBER
709: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE

Line 773: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

769:
770: PROCEDURE create_k_from_quote(p_api_version IN NUMBER
771: ,p_init_msg_list IN VARCHAR2
772: ,p_commit IN VARCHAR2
773: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
774: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
775: ,p_template_version IN NUMBER
776: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE
777: ,p_terms_agreed_flag IN VARCHAR2

Line 902: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

898: --
899: PROCEDURE create_k_from_quote(p_api_version IN NUMBER
900: ,p_init_msg_list IN VARCHAR2
901: ,p_commit IN VARCHAR2
902: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
903: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
904: ,p_template_version IN NUMBER
905: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE
906: ,p_trace_mode IN VARCHAR2

Line 948: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

944: ,p_init_msg_list IN VARCHAR2
945: ,p_commit IN VARCHAR2
946: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE
947: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE
948: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
949: ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB
950: ,p_order_id IN OKX_ORDER_HEADERS_V.ID1%TYPE
951: ,p_order_line_tab IN OKC_OC_INT_PUB.OKC_ORDER_LINE_TAB
952: ,p_trace_mode IN VARCHAR2