DBA Data[Home] [Help]

PACKAGE: APPS.OKC_VERSION_PVT

Source


1 package okc_version_pvt AUTHID CURRENT_USER as
2 /* $Header: OKCRVERS.pls 120.0 2005/05/25 22:58:25 appldev noship $ */
3 
4 subtype cvmv_rec_type is okc_cvm_pvt.cvmv_rec_type;
5 
6   -- GLOBAL VARIABLES
7   ---------------------------------------------------------------------------
8   G_UNEXPECTED_ERROR           CONSTANT   varchar2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
9   G_PKG_NAME			CONSTANT VARCHAR2(200) := 'OKC_VERSION_PVT';
10   G_APP_NAME			CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
11   G_SQLERRM_TOKEN              CONSTANT   varchar2(200) := 'SQLerrm';
12   G_SQLCODE_TOKEN              CONSTANT   varchar2(200) := 'SQLcode';
13   G_COL_NAME_TOKEN		CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
14   G_EXCEPTION_HALT_VALIDATION           EXCEPTION;
15   ---------------------------------------------------------------------------
16 
17 --Procedures pertaining to versioning a contract
18 
19 PROCEDURE version_contract(
20 	p_api_version 		IN  NUMBER,
21 	p_init_msg_list 	IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
22 	x_return_status	OUT NOCOPY VARCHAR2,
23 	x_msg_count		OUT NOCOPY NUMBER,
24 	x_msg_data		OUT NOCOPY VARCHAR2,
25      p_cvmv_rec          IN  cvmv_rec_type,
26      x_cvmv_rec          OUT NOCOPY cvmv_rec_type,
27      p_commit 		     IN  VARCHAR2 DEFAULT OKC_API.G_TRUE);
28 
29 
30 PROCEDURE save_version(
31     p_chr_id 				IN NUMBER,
32     p_api_version                  IN NUMBER,
33     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
34     x_return_status                OUT NOCOPY VARCHAR2,
35     x_msg_count                    OUT NOCOPY NUMBER,
36     x_msg_data                     OUT NOCOPY VARCHAR2,
37     p_commit 				IN VARCHAR2 DEFAULT OKC_API.G_TRUE);
38 
39 PROCEDURE erase_saved_version(
40     p_chr_id 				IN NUMBER,
41     p_api_version                  IN NUMBER,
42     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
43     x_return_status                OUT NOCOPY VARCHAR2,
44     x_msg_count                    OUT NOCOPY NUMBER,
45     x_msg_data                     OUT NOCOPY VARCHAR2,
46     p_commit 				IN VARCHAR2 DEFAULT OKC_API.G_TRUE);
47 
48 PROCEDURE restore_version(
49     p_chr_id 				IN NUMBER,
50     p_api_version                  IN NUMBER,
51     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
52     x_return_status                OUT NOCOPY VARCHAR2,
53     x_msg_count                    OUT NOCOPY NUMBER,
54     x_msg_data                     OUT NOCOPY VARCHAR2,
55     p_commit 				IN VARCHAR2 DEFAULT OKC_API.G_TRUE);
56 
57 Procedure delete_version (p_chr_id        IN NUMBER,
58                           p_major_version IN NUMBER,
59                           p_minor_version IN NUMBER,
60                           p_called_from   IN VARCHAR2);
61 
62 PROCEDURE Set_Attach_Session_Vars(p_chr_id NUMBER);
63 
64 END okc_version_pvt;