[Home] [Help]
PACKAGE: APPS.OKL_VAR_INT_PARAMS_PVT
Source
1 PACKAGE OKL_VAR_INT_PARAMS_PVT AS
2 /* $Header: OKLRVIRS.pls 120.1 2005/09/29 21:38:51 pjgomes noship $ */
3
4 SUBTYPE virv_rec_type IS okl_vir_pvt.virv_rec_type;
5 SUBTYPE virv_tbl_type IS okl_vir_pvt.virv_tbl_type;
6
7 ---------------------------------------------------------------------------
8 -- GLOBAL EXCEPTIONS
9 ---------------------------------------------------------------------------
10 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
11
12 ---------------------------------------------------------------------------
13 -- GLOBAL VARIABLES
14 ---------------------------------------------------------------------------
15 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VAR_INT_PARAMS_PVT';
16 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
17 G_API_TYPE CONSTANT VARCHAR2(30) := '_PVT';
18 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
19 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
20
21 ---------------------------------------------------------------------------
22 -- Procedures and Functions
23 ---------------------------------------------------------------------------
24
25 PROCEDURE create_var_int_params(p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 p_virv_rec IN virv_rec_type,
31 x_virv_rec OUT NOCOPY virv_rec_type);
32
33 PROCEDURE create_var_int_params(p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 p_virv_tbl IN virv_tbl_type,
39 x_virv_tbl OUT NOCOPY virv_tbl_type);
40
41 PROCEDURE update_var_int_params(p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_virv_rec IN virv_rec_type,
47 x_virv_rec OUT NOCOPY virv_rec_type);
48
49 PROCEDURE update_var_int_params(p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_virv_tbl IN virv_tbl_type,
55 x_virv_tbl OUT NOCOPY virv_tbl_type);
56
57 PROCEDURE delete_var_int_params(p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_virv_tbl IN virv_tbl_type
63 );
64
65 PROCEDURE validate_var_int_params(
66 p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 p_virv_rec IN virv_rec_type);
72
73 PROCEDURE validate_var_int_params(
74 p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 p_virv_tbl IN virv_tbl_type);
80
81 END OKL_VAR_INT_PARAMS_PVT;