[Home] [Help]
PACKAGE: APPS.OKL_SEC_CONCURRENT_PVT
Source
1 PACKAGE OKL_SEC_CONCURRENT_PVT AS
2 /* $Header: OKLRSZOS.pls 120.2 2006/02/07 00:04:28 fmiao noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- Record type which holds the account generator rule lines.
7 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
8 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
9 G_EXPECTED_ERROR CONSTANT VARCHAR2(28) := 'OKL_CONTRACTS_EXPECTED_ERROR';
10 G_CONFIRM_PROCESS CONSTANT VARCHAR2(19) := 'OKL_CONFIRM_PROCESS';
11 G_PROCESS_START CONSTANT VARCHAR2(17) := 'OKL_PROCESS_START';
12 G_PROCESS_END CONSTANT VARCHAR2(15) := 'OKL_PROCESS_END';
13 G_TOTAL_ROWS_PROCESSED CONSTANT VARCHAR2(24) := 'OKL_TOTAL_ROWS_PROCESSED';
14
15 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
16 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
17
18 ----------------------------------------------------------------------------
19 -- GLOBAL VARIABLES
20 ----------------------------------------------------------------------------
21 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SEC_CONCURRENT_PVT';
22 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
23
24 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
25 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
26 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
27 G_EXCEPTION_ERROR EXCEPTION;
28 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
29
30 G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
31 G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
32 G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
33 G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
34
35 G_BUYBACK_ERROR CONSTANT VARCHAR2(20) := 'OKL_BUYBACK_ERROR';
36
37 ----------------------------------------------------------------------------
38 -- Global Exception
39 ----------------------------------------------------------------------------
40 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
41
42 TYPE error_message_type IS TABLE OF VARCHAR2(2000)
43 INDEX BY BINARY_INTEGER;
44
45 ----------------------------------------------------------------------------
46 -- Procedures and Functions
47 ------------------------------------------------------------------------------
48 ----------------------------------------------------------------------------------
49 -- Start of comments
50 --
51 -- Procedure Name : BUYBACK_AGREEMENT
52 -- Description : This is a wrapper procedure for concurrent program to call private API
53 -- Business Rules :
54 -- Parameters :
55 -- Version : 1.0
56 -- End of comments
57 ----------------------------------------------------------------------------------
58
59 PROCEDURE BUYBACK_AGREEMENT(x_errbuf OUT NOCOPY VARCHAR2
60 ,x_retcode OUT NOCOPY NUMBER
61 ,p_khr_id IN VARCHAR2);
62
63
64
65 -- fmiao bug: 4748514 start
66 ----------------------------------------------------------------------------------
67 -- Start of comments
68 --
69 -- Procedure Name : activate_agreement_ui
70 -- Description : Activate investor agreement
71 -- This is a wrapper procedure for concurrent program call from jsp/UI
72 -- Business Rules :
73 -- Parameters :
74 -- Version : 1.0
75 -- End of comments
76 ----------------------------------------------------------------------------------
77
78 PROCEDURE activate_agreement_ui(
79 p_api_version IN NUMBER
80 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
81 ,x_return_status OUT nocopy VARCHAR2
82 ,x_msg_count OUT nocopy NUMBER
83 ,x_msg_data OUT nocopy VARCHAR2
84 ,x_request_id OUT nocopy NUMBER
85 -- agreement id --
86 ,p_chr_id IN NUMBER);
87
88 ----------------------------------------------------------------------------------
89 -- Start of comments
90 --
91 -- Procedure Name : activate_agreement
92 -- Description : This is a wrapper procedure to call the activate agreement API
93 -- to activate the agreement.
94 -- Business Rules :
95 -- Parameters :
96 -- Version : 1.0
97 -- End of comments
98 ----------------------------------------------------------------------------------
99
100 PROCEDURE activate_agreement(x_errbuf OUT NOCOPY VARCHAR2
101 ,x_retcode OUT NOCOPY NUMBER
102 ,p_chr_id IN VARCHAR2);
103 -- fmiao bug: 4748514 end
104
105 END OKL_SEC_CONCURRENT_PVT;