[Home] [Help]
PACKAGE: APPS.OKL_CONTRACT_PROD_OPTNS_PVT
Source
1 PACKAGE OKL_CONTRACT_PROD_OPTNS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLCCSPS.pls 115.2 2002/02/25 10:12:12 pkm ship $ */
3
4 subtype cspv_rec_type is okl_csp_pvt.cspv_rec_type;
5 subtype cspv_tbl_type is okl_csp_pvt.cspv_tbl_type;
6
7 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
8 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
9 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
10 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
11 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
12 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
13 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
15 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CONTRACT_PROD_OPTNS_PVT';
16 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
17 ----------------------------------------------------------------------------------------------------
18 PROCEDURE create_contract_option(
19 p_api_version IN NUMBER,
20 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2,
24 p_cspv_rec IN cspv_rec_type,
25 x_cspv_rec OUT NOCOPY cspv_rec_type);
26
27 PROCEDURE create_contract_option(
28 p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 p_cspv_tbl IN cspv_tbl_type,
34 x_cspv_tbl OUT NOCOPY cspv_tbl_type);
35
36
37 PROCEDURE update_contract_option(
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 x_msg_data OUT NOCOPY VARCHAR2,
43 p_cspv_rec IN cspv_rec_type,
44 x_cspv_rec OUT NOCOPY cspv_rec_type);
45
46 PROCEDURE update_contract_option(
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 x_msg_data OUT NOCOPY VARCHAR2,
52 p_cspv_tbl IN cspv_tbl_type,
53 x_cspv_tbl OUT NOCOPY cspv_tbl_type);
54
55 PROCEDURE delete_contract_option(
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 x_msg_data OUT NOCOPY VARCHAR2,
61 p_cspv_rec IN cspv_rec_type);
62
63 PROCEDURE delete_contract_option(
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 p_cspv_tbl IN cspv_tbl_type);
70
71 PROCEDURE lock_contract_option(
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 p_cspv_rec IN cspv_rec_type);
78
79 procedure lock_contract_option(
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_cspv_tbl IN cspv_tbl_type);
86
87 PROCEDURE validate_contract_option(
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_cspv_rec IN cspv_rec_type);
94
95 procedure validate_contract_option(
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_cspv_tbl IN cspv_tbl_type);
102
103 END OKL_CONTRACT_PROD_OPTNS_PVT;