1 Package OKL_SPLIT_CONTRACT_PVT AUTHID CURRENT_USER as
2 /* $Header: OKLRSKHS.pls 115.6 2004/01/24 00:52:22 rravikir noship $ */
3
4 TYPE ktl_rec_type IS RECORD (line_number NUMBER := OKC_API.G_MISS_NUM,
5 contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
6 kle_id NUMBER := OKC_API.G_MISS_NUM);
7 TYPE ktl_tbl_type IS TABLE OF ktl_rec_type
8 INDEX BY BINARY_INTEGER;
9
10 PROCEDURE cancel_split_process (p_api_version IN NUMBER,
11 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
12 x_return_status OUT NOCOPY VARCHAR2,
13 x_msg_count OUT NOCOPY NUMBER,
14 x_msg_data OUT NOCOPY VARCHAR2,
15 p_contract_id IN OKC_K_HEADERS_V.ID%TYPE);
16
17 PROCEDURE check_split_process (p_api_version IN NUMBER,
18 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_msg_count OUT NOCOPY NUMBER,
21 x_msg_data OUT NOCOPY VARCHAR2,
22 x_process_action OUT NOCOPY VARCHAR2,
23 x_transaction_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,
24 x_child_chrid1 OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE,
25 x_child_chrid2 OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE,
26 p_contract_id IN OKC_K_HEADERS_V.ID%TYPE);
27
28 Procedure create_split_contract(
29 p_api_version IN NUMBER,
30 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_msg_data OUT NOCOPY VARCHAR2,
34 p_old_contract_number IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE,
35 p_new_khr_top_line IN ktl_tbl_type,
36 x_new_khr_top_line OUT NOCOPY ktl_tbl_type);
37
38 PROCEDURE set_context(
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43 p_resp_id IN NUMBER,
44 p_appl_id IN NUMBER,
45 p_user_id IN NUMBER,
46 x_return_status OUT NOCOPY VARCHAR2);
47
48 PROCEDURE post_split_contract(
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_commit IN VARCHAR2 DEFAULT OKL_API.G_TRUE,
55 p_new1_contract_id IN OKC_K_HEADERS_V.ID%TYPE,
56 p_new2_contract_id IN OKC_K_HEADERS_V.ID%TYPE,
57 x_trx1_number OUT NOCOPY NUMBER,
58 x_trx1_status OUT NOCOPY VARCHAR2,
59 x_trx2_number OUT NOCOPY NUMBER,
60 x_trx2_status OUT NOCOPY VARCHAR2);
61
62 End OKL_SPLIT_CONTRACT_PVT;