PACKAGE: APPS.PA_COPY_CHANGE_DOC_PVT

Source

1 PACKAGE PA_COPY_CHANGE_DOC_PVT AUTHID CURRENT_USER AS
2 --$Header: PACICCDS.pls 120.2.12010000.1 2009/06/08 22:13:26 cklee noship $
3 
4 G_PKG_NAME CONSTANT VARCHAR2(200)     := 'OKL_VP_COPY_CONTRACT_PVT' ;
5 G_APP_NAME CONSTANT VARCHAR2(3)       :=  OKL_API.G_APP_NAME;
6 
7 /*
8 G_REQUIRED_VALUE                 CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
9 G_INVALID_VALUE                  CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
10 G_SQLERRM_TOKEN                  CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
11 G_SQLCODE_TOKEN                  CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
12 G_UNEXPECTED_ERROR               CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
13 G_UPPERCASE_REQUIRED             CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';
14 G_COL_NAME_TOKEN                 CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
15 */
16 G_EXCEPTION_HALT_VALIDATION       EXCEPTION;
17 
18 procedure copy_change_doc(
19         p_init_msg_list        IN     VARCHAR2 := fnd_api.g_true
20         ,p_commit               IN     VARCHAR2 := FND_API.g_false
21         ,p_validate_only        IN     VARCHAR2 := FND_API.g_true
22 
23         ,p_ci_id                IN     NUMBER
24         ,p_ci_number            IN     VARCHAR2
25         ,p_version_comments     IN     VARCHAR2
26         ,x_ci_id                OUT    NOCOPY NUMBER
27         ,x_version_number       OUT    NOCOPY NUMBER
28 
29         ,x_return_status        OUT    NOCOPY VARCHAR2
30         ,x_msg_count            OUT    NOCOPY NUMBER
31         ,x_msg_data             OUT    NOCOPY VARCHAR2
32 );
33 
34 procedure copy_change_doc(
35         p_init_msg_list        IN     VARCHAR2 := fnd_api.g_true
36         ,p_commit               IN     VARCHAR2 := FND_API.g_false
37         ,p_validate_only        IN     VARCHAR2 := FND_API.g_true
38 
39         ,p_ci_id                IN     NUMBER
40         ,p_src_ci_id                IN     NUMBER
41         ,x_ci_id                OUT    NOCOPY NUMBER
42         ,x_version_number       OUT    NOCOPY NUMBER
43 
44         ,x_return_status        OUT    NOCOPY VARCHAR2
45         ,x_msg_count            OUT    NOCOPY NUMBER
46         ,x_msg_data             OUT    NOCOPY VARCHAR2
47 );
48 procedure update_comments(
49         p_init_msg_list        IN     VARCHAR2 := fnd_api.g_true
50         ,p_commit               IN     VARCHAR2 := FND_API.g_false
51         ,p_validate_only        IN     VARCHAR2 := FND_API.g_true
52 
53         ,p_ci_id                IN     NUMBER
54         ,p_version_comments     IN    VARCHAR2
55 
56         ,x_return_status        OUT    NOCOPY VARCHAR2
57         ,x_msg_count            OUT    NOCOPY NUMBER
58         ,x_msg_data             OUT    NOCOPY VARCHAR2
59 );
60 END  PA_COPY_CHANGE_DOC_PVT;