[Home] [Help]
PACKAGE: APPS.OKL_CONTRACT_PROD_OPTNS_PUB
Source
1 PACKAGE OKL_CONTRACT_PROD_OPTNS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPCSPS.pls 115.2 2002/02/25 10:12:31 pkm ship $ */
3
4 subtype cspv_rec_type is OKL_CONTRACT_PROD_OPTNS_PVT.cspv_rec_type;
5 subtype cspv_tbl_type is OKL_CONTRACT_PROD_OPTNS_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
16 -- Global variables for user hooks
17 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CONTRACT_PROD_OPTNS_PUB';
18 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
19 g_cspv_rec cspv_rec_type;
20 g_cspv_tbl cspv_tbl_type;
21
22
23 PROCEDURE create_contract_option(
24 p_api_version IN NUMBER,
25 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2,
29 p_cspv_rec IN cspv_rec_type,
30 x_cspv_rec OUT NOCOPY cspv_rec_type);
31
32 PROCEDURE create_contract_option(
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 p_cspv_tbl IN cspv_tbl_type,
39 x_cspv_tbl OUT NOCOPY cspv_tbl_type);
40
41 PROCEDURE update_contract_option(
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2,
47 p_cspv_rec IN cspv_rec_type,
48 x_cspv_rec OUT NOCOPY cspv_rec_type);
49
50 PROCEDURE update_contract_option(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_cspv_tbl IN cspv_tbl_type,
57 x_cspv_tbl OUT NOCOPY cspv_tbl_type);
58
59 PROCEDURE delete_contract_option(
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_cspv_rec IN cspv_rec_type);
66
67 PROCEDURE delete_contract_option(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_cspv_tbl IN cspv_tbl_type);
74
75 PROCEDURE lock_contract_option(
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2,
81 p_cspv_rec IN cspv_rec_type);
82
83 procedure lock_contract_option(
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2,
89 p_cspv_tbl IN cspv_tbl_type);
90
91 PROCEDURE validate_contract_option(
92 p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 p_cspv_rec IN cspv_rec_type);
98
99 procedure validate_contract_option(
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 p_cspv_tbl IN cspv_tbl_type);
106
107 END OKL_CONTRACT_PROD_OPTNS_PUB;