1 Package OKS_OC_INT_KTO_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSRKTOS.pls 120.1 2006/02/08 04:28:24 gchadha noship $ */
3
4 g_rlt_typ_oh CONSTANT VARCHAR2(30) := 'OKX_ORDERHEAD';
5 g_rlt_typ_qh CONSTANT VARCHAR2(30) := 'OKX_QUOTEHEAD';
6 g_rlt_cod_osk CONSTANT VARCHAR2(30) := 'ORDERSHIPSCONTRACT';
7 g_rlt_cod_kfo CONSTANT VARCHAR2(30) := 'CONTRACTFORORDER';
8 g_rlt_typ_ql CONSTANT VARCHAR2(30) := 'OKX_QUOTELINE';
9 g_rlt_typ_ol CONSTANT VARCHAR2(30) := 'OKX_ORDERLINE';
10 g_aso_op_code_create CONSTANT VARCHAR2(30) := 'CREATE';
11 --
12 -- Global variables
13 --
14 l_contract_number okc_k_headers_b.contract_number%TYPE;
15 l_contract_number_modifier okc_k_headers_b.contract_number_modifier%TYPE;
16 l_order_number okx_order_headers_v.order_number%TYPE;
17
18
19 -------------------------------------------------------------------------------
20 -- Procedure: create_order_from_k
21 -- Version: 1.0
22 -- Purpose: Create an order from a contract by populating quote
23 -- input records from a contract as the initial
24 -- stage.
25 -- Calls ASO_ORDER_INT.CREATE_ORDER to create the order
26 --
27 -- In Parameters: p_contract_id Contract for which to create order
28 -- Out Parameters: x_order_id Id of created order
29 --
30 PROCEDURE create_order_from_k(
31 p_api_version IN NUMBER
32 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
33 ,x_return_status OUT NOCOPY VARCHAR2
34 ,x_msg_count OUT NOCOPY NUMBER
35 ,x_msg_data OUT NOCOPY VARCHAR2
36 ,p_contract_id IN okc_k_headers_b.ID%TYPE
37 ,p_default_date IN DATE DEFAULT OKC_API.G_MISS_DATE
38 ,P_Customer_id IN NUMBER
39 ,P_Grp_id IN NUMBER
40 ,P_org_id IN NUMBER
41 ,P_contract_hdr_id_lo IN NUMBER
42 ,P_contract_hdr_id_hi IN NUMBER
43 -- Bug 4915691 --
44 ,P_contract_line_id_lo in NUMBER
45 ,P_contract_line_id_hi in NUMBER
46 -- Bug 4915691 --
47 ,x_order_id OUT NOCOPY okx_order_headers_v.id1%TYPE
48 );
49 END OKS_OC_INT_KTO_PVT;