[Home] [Help]
PACKAGE: APPS.OKL_VERSION_IB_PUB
Source
1 PACKAGE OKL_VERSION_IB_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPVIBS.pls 115.0 2002/02/04 19:07:55 pkm ship $ */
3
4 subtype vibv_rec_type is okl_version_ib_pvt.vibv_rec_type;
5 subtype vibv_tbl_type is okl_version_ib_pvt.vibv_tbl_type;
6
7
8 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
9 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
11 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
12 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
16
17 -- Global variables for user hooks
18 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VERSION_IB_PUB';
19 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
20 g_vibv_rec vibv_rec_type;
21 g_vibv_tbl vibv_tbl_type;
22
23
24 PROCEDURE create_version_ib(
25 p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 p_vibv_rec IN vibv_rec_type,
31 x_vibv_rec OUT NOCOPY vibv_rec_type);
32
33 PROCEDURE create_version_ib(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_vibv_tbl IN vibv_tbl_type,
40 x_vibv_tbl OUT NOCOPY vibv_tbl_type);
41
42
43 PROCEDURE update_version_ib(
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 p_vibv_rec IN vibv_rec_type,
50 x_vibv_rec OUT NOCOPY vibv_rec_type);
51
52 PROCEDURE update_version_ib(
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_vibv_tbl IN vibv_tbl_type,
59 x_vibv_tbl OUT NOCOPY vibv_tbl_type);
60
61 PROCEDURE delete_version_ib(
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_vibv_rec IN vibv_rec_type);
68
69 PROCEDURE delete_version_ib(
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 p_vibv_tbl IN vibv_tbl_type);
76
77 PROCEDURE lock_version_ib(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_vibv_rec IN vibv_rec_type);
84
85 procedure lock_version_ib(
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 p_vibv_tbl IN vibv_tbl_type);
92
93 PROCEDURE validate_version_ib(
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_vibv_rec IN vibv_rec_type);
100
101 procedure validate_version_ib(
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 p_vibv_tbl IN vibv_tbl_type);
108
109
110 END OKL_VERSION_IB_PUB;