1 PACKAGE BODY OKC_OC_INT_KTO_PVT AS
2 /* $Header: OKCRKTOB.pls 120.1 2005/10/04 20:00:08 smallya noship $ */
3
4 -- Tables to hold bill to and ship to information at the header level
5 --
6
7 -------------------------------------------------------------------------------
8 -- Procedure: create_order_from_k
9 -- Version: 1.0
10 -- Purpose: Create an order from a contract by populating quote
11 -- input records from a contract as the initial
12 -- stage.
13 -- Provides process 2.1 in data flow diagram in HLD.
14 -- Create Relationships from ordering contract to order
15 -- May also create subject-to relationship from order
16 -- to master contract if ordering contract is subject
17 -- to a master contract
18 -- Calls ASO_ORDER_PUB.CREATE_ORDER to create the order
19 -- In Parameters: p_contract_id Contract for which to create order
20 -- p_rel_type Relationship type used to decide on
21 -- which kind of order to create
22 -- Out Parameters: x_order_id Id of created order
23 --
24 PROCEDURE create_order_from_k(
25 p_api_version IN NUMBER
26 ,p_init_msg_list IN VARCHAR2
27 ,x_return_status OUT NOCOPY VARCHAR2
28 ,x_msg_count OUT NOCOPY NUMBER
29 ,x_msg_data OUT NOCOPY VARCHAR2
30 --
31 ,p_contract_id IN okc_k_headers_b.ID%TYPE
32 ,p_rel_type IN okc_k_rel_objs.rty_code%TYPE
33 --
34 ,p_trace_mode IN VARCHAR2
35 ,x_order_id OUT NOCOPY okx_order_headers_v.id1%TYPE
36 )
37 IS
38 BEGIN
39 NULL;
40 END create_order_from_k;
41
42
43 --
44 -- Create new procedure to create relationships
45 --
46 PROCEDURE create_k_relationships(p_api_version IN NUMBER
47 ,p_init_msg_list IN VARCHAR2
48 ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE
49 ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE
50 ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
51 ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB
52 ,p_order_id IN OKX_ORDER_HEADERS_V.ID1%TYPE
53 ,p_order_line_tab IN OKC_OC_INT_PUB.OKC_ORDER_LINE_TAB
54 ,x_return_status OUT NOCOPY VARCHAR2
55 ,x_msg_count OUT NOCOPY NUMBER
56 ,x_msg_data OUT NOCOPY VARCHAR2
57 ) IS
58
59 BEGIN
60 NULL;
61 END;
62
63 END OKC_OC_INT_KTO_PVT;