PACKAGE: APPS.OKC_VERSION_PUB

Source

1 package okc_version_pub AUTHID CURRENT_USER 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;