[Home] [Help]
PACKAGE: APPS.OKL_VP_RULE_PUB
Source
1 PACKAGE OKL_VP_RULE_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPRLGS.pls 115.5 2002/12/18 12:33:14 kjinger noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES, needed for Public API's only
5 ---------------------------------------------------------------------------
6 -- G_MISS_CLOB CLOB;
7 -- complex entity object subtype definitions
8 SUBTYPE rgpv_rec_type IS OKL_VP_RULE_PVT.rgpv_rec_type;
9 SUBTYPE rgpv_tbl_type IS OKL_VP_RULE_PVT.rgpv_tbl_type;
10
11 ---------------------------------------------------------------------------
12 -- GLOBAL MESSAGE CONSTANTS
13 ---------------------------------------------------------------------------
14 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
15 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
16 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
17 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
18 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
19 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
20 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
21 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
22 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
23 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
24 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
25 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
26 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
27 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
28 ------------------------------------------------------------------------------------
29 -- GLOBAL EXCEPTION
30 ---------------------------------------------------------------------------
31 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
32 -- GLOBAL VARIABLES
33 ---------------------------------------------------------------------------
34 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_RULE_PUB';
35 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
36
37 g_rgpv_rec rgpv_rec_type;
38 -- public procedure declarations
39
40 PROCEDURE create_rule_group(
41 p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_rgpv_rec IN rgpv_rec_type,
47 x_rgpv_rec OUT NOCOPY rgpv_rec_type);
48 PROCEDURE create_rule_group(
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_rgpv_tbl IN rgpv_tbl_type,
55 x_rgpv_tbl OUT NOCOPY rgpv_tbl_type);
56 PROCEDURE update_rule_group(
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_rgpv_rec IN rgpv_rec_type,
63 x_rgpv_rec OUT NOCOPY rgpv_rec_type);
64 PROCEDURE update_rule_group(
65 p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 p_rgpv_tbl IN rgpv_tbl_type,
71 x_rgpv_tbl OUT NOCOPY rgpv_tbl_type);
72 PROCEDURE delete_rule_group(
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 p_rgpv_rec IN rgpv_rec_type);
79 PROCEDURE delete_rule_group(
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_rgpv_tbl IN rgpv_tbl_type);
86
87
88 END OKL_VP_RULE_PUB;