[Home] [Help]
PACKAGE: APPS.OKC_VERSION_PUB
Source
1 package okc_version_pub as
2 /* $Header: OKCPVERS.pls 120.0 2005/05/25 23:06:23 appldev noship $ */
3
4 subtype cvmv_rec_type is okc_version_pvt.cvmv_rec_type;
5 subtype cvmv_tbl_type is okc_cvm_pvt.cvmv_tbl_type;
6
7 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
8 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9 G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10 G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
11 G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
12
13
14 --Procedures pertaining to versioning a contract
15
16 PROCEDURE version_contract(
17 p_api_version IN NUMBER,
18 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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 p_cvmv_rec IN cvmv_rec_type,
23 p_commit IN VARCHAR2 DEFAULT OKC_API.G_TRUE,
24 x_cvmv_rec OUT NOCOPY cvmv_rec_type);
25
26 PROCEDURE version_contract(
27 p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 p_cvmv_tbl IN cvmv_tbl_type,
33 p_commit IN VARCHAR2 DEFAULT OKC_API.G_TRUE,
34 x_cvmv_tbl OUT NOCOPY cvmv_tbl_type);
35
36 PROCEDURE save_version(
37 p_chr_id IN NUMBER,
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 p_commit IN VARCHAR2 DEFAULT OKC_API.G_TRUE,
43 x_msg_data OUT NOCOPY VARCHAR2);
44
45 PROCEDURE erase_saved_version(
46 p_chr_id IN NUMBER,
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 p_commit IN VARCHAR2 DEFAULT OKC_API.G_TRUE,
52 x_msg_data OUT NOCOPY VARCHAR2);
53
54 PROCEDURE restore_version(
55 p_chr_id IN NUMBER,
56 p_api_version IN NUMBER,
57 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 p_commit IN VARCHAR2 DEFAULT OKC_API.G_TRUE,
61 x_msg_data OUT NOCOPY VARCHAR2);
62
63
64 END okc_version_pub;