1 PACKAGE OKS_KTO_INT_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKSPORDS.pls 120.1 2006/02/08 05:05:52 gchadha noship $ */
3
4
5
6 -------------------------------------------------------------------------------
7 --
8 -- APIs: K->O
9 --
10 -------------------------------------------------------------------------------
11
12 -- Procedure: create_order_from_k
13 -- Version: 1.0
14 -- Purpose: Create an order from a contract.
15 -- The first one is planned to be called by a Conc. Prog.
16 -- and calls itself the second one
17 -- Calls ASO_ORDER_PUB.CREATE_ORDER to create the order
18 -- In Parameters: p_contract_id Contract for which to create order
19 -- Out Parameters: x_order_id Id of created order
20 --
21 -------------------------------------------------------------------------------
22
23 PROCEDURE create_order_from_k(ERRBUF OUT NOCOPY VARCHAR2
24 ,RETCODE OUT NOCOPY NUMBER
25 ,p_contract_id IN okc_k_headers_b.ID%TYPE
26 ,p_default_date IN DATE DEFAULT OKC_API.G_MISS_DATE
27 ,P_Customer_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
28 ,P_Grp_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
29 ,P_org_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
30 ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
31 ,P_contract_hdr_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
32 -- Bug 4915691 --
33 ,P_contract_line_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
34 ,P_contract_line_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
35 -- Bug 4915691 --
36 );
37
38
39 PROCEDURE create_order_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
40 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
41 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
42 ,x_return_status OUT NOCOPY VARCHAR2
43 ,x_msg_count OUT NOCOPY NUMBER
44 ,x_msg_data OUT NOCOPY VARCHAR2
45 ,p_contract_id IN okc_k_headers_b.ID%TYPE
46 ,p_default_date IN DATE DEFAULT OKC_API.G_MISS_DATE
47 ,P_Customer_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
48 ,P_Grp_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
49 ,P_org_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
50 ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
51 ,P_contract_hdr_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
52 -- Bug 4915691 --
53 ,P_contract_line_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
54 ,P_contract_line_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
55
56 -- Bug 4915691 --
57
58 ,x_order_id OUT NOCOPY okx_order_headers_v.id1%TYPE
59 );
60
61 END OKS_KTO_INT_PUB;
62
63