[Home] [Help]
PACKAGE: APPS.OKL_SEC_AGREMNT_BOOK_PVT
Source
1 Package OKL_SEC_AGREMNT_BOOK_PVT as
2 /* $Header: OKLRSZBS.pls 120.3 2007/12/21 14:10:23 kthiruva ship $ */
3
4 -- Global variables for user hooks
5 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SEC_AGREMNT_BOOK_PVT';
6 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
7
8 SUCCESS_MESSAGE EXCEPTION;
9
10 Cursor pool_csr ( chrId NUMBER ) IS
11 Select pools.id
12 from OKL_POOLS pools
13 where pools.khr_id = chrId;
14
15 Procedure execute_qa_check_list(
16 p_api_version IN NUMBER,
17 p_init_msg_list IN VARCHAR2,
18 x_return_status OUT NOCOPY VARCHAR2,
19 x_msg_count OUT NOCOPY NUMBER,
20 x_msg_data OUT NOCOPY VARCHAR2,
21 p_qcl_id IN NUMBER,
22 p_chr_id IN NUMBER,
23 x_msg_tbl OUT NOCOPY OKL_QA_CHECK_PUB.msg_tbl_type);
24
25 Procedure activate_contract(
26 p_api_version IN NUMBER,
27 p_init_msg_list IN VARCHAR2,
28 x_return_status OUT NOCOPY VARCHAR2,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2,
31 p_chr_id IN VARCHAR2);
32
33 Procedure check_reconciled(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_chr_id IN VARCHAR2);
40
41 Procedure check_event(
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2,
47 p_event IN VARCHAR2,
48 p_chr_id IN VARCHAR2);
49
50 --Added by kthiruva on 18-Dec-2007
51 -- New method to validate an add request on an active investor agreement
52 --Bug 6691554 - Start of Changes
53 Procedure validate_add_request(
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_chr_id IN NUMBER);
60 -- Bug 6691554 - End of Changes
61
62 End OKL_SEC_AGREMNT_BOOK_PVT;
63