[Home] [Help]
PACKAGE: APPS.OKC_RULE_DEF_PVT
Source
1 Package OKC_RULE_DEF_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCCRGDS.pls 120.0 2005/05/25 22:56:09 appldev noship $ */
3
4 -- simple entity object subtype definitions
5 subtype rgrv_rec_type is okc_rgr_pvt.rgrv_rec_type;
6 subtype rgrv_tbl_type is okc_rgr_pvt.rgrv_tbl_type;
7 subtype rdsv_rec_type is okc_rds_pvt.rdsv_rec_type;
8 subtype rdsv_tbl_type is okc_rds_pvt.rdsv_tbl_type;
9
10 ---------------------------------------------------------------------------
11 -- GLOBAL MESSAGE CONSTANTS
12 ---------------------------------------------------------------------------
13 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
14 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
15 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
16 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
17 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
18 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
23 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
24 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
25 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
26 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
27
28 ------------------------------------------------------------------------------------
29 -- GLOBAL EXCEPTION
30 ---------------------------------------------------------------------------
31 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
32
33 -- GLOBAL VARIABLES
34 ---------------------------------------------------------------------------
35 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_RULE_DEF_PVT';
36 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
37 ---------------------------------------------------------------------------
38
39 PROCEDURE create_rg_def_rule(
40 p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 p_rgrv_rec IN rgrv_rec_type,
46 x_rgrv_rec OUT NOCOPY rgrv_rec_type);
47
48 PROCEDURE update_rg_def_rule(
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_rgrv_rec IN rgrv_rec_type,
55 x_rgrv_rec OUT NOCOPY rgrv_rec_type);
56
57 PROCEDURE delete_rg_def_rule(
58 p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 p_rgrv_rec IN rgrv_rec_type);
64
65 PROCEDURE validate_rg_def_rule(
66 p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_rgrv_rec IN rgrv_rec_type);
72
73 PROCEDURE lock_rg_def_rule(
74 p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_rgrv_rec IN rgrv_rec_type);
80
81 PROCEDURE create_rd_source(
82 p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 p_rdsv_rec IN rdsv_rec_type,
88 x_rdsv_rec OUT NOCOPY rdsv_rec_type);
89
90 PROCEDURE update_rd_source(
91 p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2,
96 p_rdsv_rec IN rdsv_rec_type,
97 x_rdsv_rec OUT NOCOPY rdsv_rec_type);
98
99 PROCEDURE delete_rd_source(
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_rdsv_rec IN rdsv_rec_type);
106
107 PROCEDURE validate_rd_source(
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 p_rdsv_rec IN rdsv_rec_type);
114
115 PROCEDURE lock_rd_source(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_rdsv_rec IN rdsv_rec_type);
122
123 END okc_rule_def_pvt;