7:
8:
9: PROCEDURE process_rule_group_rules(
10: p_api_version IN NUMBER,
11: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
12: x_return_status OUT NOCOPY VARCHAR2,
13: x_msg_count OUT NOCOPY NUMBER,
14: x_msg_data OUT NOCOPY VARCHAR2,
15: p_chr_id IN NUMBER,
27: l_proc_name VARCHAR2(35) := 'PROCESS_RULE_GROUP_RULES';
28: l_api_version CONSTANT VARCHAR2(30) := p_api_version;
29:
30: BEGIN
31: x_return_status := OKC_API.G_RET_STS_SUCCESS;
32: -- call START_ACTIVITY to create savepoint, check compatibility
33: -- and initialize message list
34: x_return_status := OKC_API.START_ACTIVITY(
35: p_api_name => l_api_name,
30: BEGIN
31: x_return_status := OKC_API.G_RET_STS_SUCCESS;
32: -- call START_ACTIVITY to create savepoint, check compatibility
33: -- and initialize message list
34: x_return_status := OKC_API.START_ACTIVITY(
35: p_api_name => l_api_name,
36: p_pkg_name => G_PKG_NAME,
37: p_init_msg_list => p_init_msg_list,
38: l_api_version => l_api_version,
40: p_api_type => G_API_TYPE,
41: x_return_status => x_return_status);
42:
43: -- check if activity started successfully
44: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
45: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
46: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
47: raise OKC_API.G_EXCEPTION_ERROR;
48: END IF;
41: x_return_status => x_return_status);
42:
43: -- check if activity started successfully
44: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
45: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
46: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
47: raise OKC_API.G_EXCEPTION_ERROR;
48: END IF;
49:
42:
43: -- check if activity started successfully
44: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
45: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
46: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
47: raise OKC_API.G_EXCEPTION_ERROR;
48: END IF;
49:
50:
43: -- check if activity started successfully
44: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
45: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
46: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
47: raise OKC_API.G_EXCEPTION_ERROR;
48: END IF;
49:
50:
51: OKL_RGRP_RULES_PROCESS_PVT.process_rule_group_rules(
59: p_cpl_id => p_cpl_id,
60: p_rrd_id => p_rrd_id,
61: p_rgr_tbl => p_rgr_tbl);
62:
63: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
64: RAISE OKC_API.G_EXCEPTION_ERROR;
65: END IF;
66:
67: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
60: p_rrd_id => p_rrd_id,
61: p_rgr_tbl => p_rgr_tbl);
62:
63: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
64: RAISE OKC_API.G_EXCEPTION_ERROR;
65: END IF;
66:
67: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
68: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
68: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
69: x_msg_data => x_msg_data);
70:
71: EXCEPTION
72: when OKC_API.G_EXCEPTION_ERROR then
73: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
74: p_api_name => l_api_name,
75: p_pkg_name => G_PKG_NAME,
76: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
69: x_msg_data => x_msg_data);
70:
71: EXCEPTION
72: when OKC_API.G_EXCEPTION_ERROR then
73: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
74: p_api_name => l_api_name,
75: p_pkg_name => G_PKG_NAME,
76: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
77: x_msg_count => x_msg_count,
72: when OKC_API.G_EXCEPTION_ERROR then
73: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
74: p_api_name => l_api_name,
75: p_pkg_name => G_PKG_NAME,
76: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
77: x_msg_count => x_msg_count,
78: x_msg_data => x_msg_data,
79: p_api_type => G_API_TYPE);
80:
77: x_msg_count => x_msg_count,
78: x_msg_data => x_msg_data,
79: p_api_type => G_API_TYPE);
80:
81: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
82: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
83: p_api_name => l_api_name,
84: p_pkg_name => G_PKG_NAME,
85: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
78: x_msg_data => x_msg_data,
79: p_api_type => G_API_TYPE);
80:
81: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
82: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
83: p_api_name => l_api_name,
84: p_pkg_name => G_PKG_NAME,
85: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
86: x_msg_count => x_msg_count,
81: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
82: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
83: p_api_name => l_api_name,
84: p_pkg_name => G_PKG_NAME,
85: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
86: x_msg_count => x_msg_count,
87: x_msg_data => x_msg_data,
88: p_api_type => G_API_TYPE);
89:
87: x_msg_data => x_msg_data,
88: p_api_type => G_API_TYPE);
89:
90: when OTHERS then
91: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
92: p_api_name => l_api_name,
93: p_pkg_name => G_PKG_NAME,
94: p_exc_name => 'OTHERS',
95: x_msg_count => x_msg_count,
99: END process_rule_group_rules;
100:
101: PROCEDURE process_template_rules(
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_id IN NUMBER,
118: l_proc_name VARCHAR2(35) := 'PROCESS_TEMPLATE_RULES';
119:
120: BEGIN
121:
122: x_return_status := OKC_API.G_RET_STS_SUCCESS;
123: -- call START_ACTIVITY to create savepoint, check compatibility
124: -- and initialize message list
125: x_return_status := OKC_API.START_ACTIVITY(
126: p_api_name => l_api_name,
121:
122: x_return_status := OKC_API.G_RET_STS_SUCCESS;
123: -- call START_ACTIVITY to create savepoint, check compatibility
124: -- and initialize message list
125: x_return_status := OKC_API.START_ACTIVITY(
126: p_api_name => l_api_name,
127: p_pkg_name => G_PKG_NAME,
128: p_init_msg_list => p_init_msg_list,
129: l_api_version => l_api_version,
131: p_api_type => G_API_TYPE,
132: x_return_status => x_return_status);
133:
134: -- check if activity started successfully
135: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
136: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
137: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
138: raise OKC_API.G_EXCEPTION_ERROR;
139: END IF;
132: x_return_status => x_return_status);
133:
134: -- check if activity started successfully
135: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
136: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
137: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
138: raise OKC_API.G_EXCEPTION_ERROR;
139: END IF;
140:
133:
134: -- check if activity started successfully
135: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
136: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
137: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
138: raise OKC_API.G_EXCEPTION_ERROR;
139: END IF;
140:
141:
134: -- check if activity started successfully
135: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
136: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
137: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
138: raise OKC_API.G_EXCEPTION_ERROR;
139: END IF;
140:
141:
142: OKL_RGRP_RULES_PROCESS_PVT.process_template_rules(
149: p_rgr_tbl => p_rgr_tbl,
150: x_rgr_tbl => x_rgr_tbl);
151:
152:
153: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
154: RAISE OKC_API.G_EXCEPTION_ERROR;
155: END IF;
156:
157: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
150: x_rgr_tbl => x_rgr_tbl);
151:
152:
153: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
154: RAISE OKC_API.G_EXCEPTION_ERROR;
155: END IF;
156:
157: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
158: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
158: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
159: x_msg_data => x_msg_data);
160:
161: EXCEPTION
162: when OKC_API.G_EXCEPTION_ERROR then
163: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
164: p_api_name => l_api_name,
165: p_pkg_name => G_PKG_NAME,
166: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
159: x_msg_data => x_msg_data);
160:
161: EXCEPTION
162: when OKC_API.G_EXCEPTION_ERROR then
163: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
164: p_api_name => l_api_name,
165: p_pkg_name => G_PKG_NAME,
166: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
167: x_msg_count => x_msg_count,
162: when OKC_API.G_EXCEPTION_ERROR then
163: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
164: p_api_name => l_api_name,
165: p_pkg_name => G_PKG_NAME,
166: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
167: x_msg_count => x_msg_count,
168: x_msg_data => x_msg_data,
169: p_api_type => G_API_TYPE);
170:
167: x_msg_count => x_msg_count,
168: x_msg_data => x_msg_data,
169: p_api_type => G_API_TYPE);
170:
171: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
172: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
173: p_api_name => l_api_name,
174: p_pkg_name => G_PKG_NAME,
175: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
168: x_msg_data => x_msg_data,
169: p_api_type => G_API_TYPE);
170:
171: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
172: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
173: p_api_name => l_api_name,
174: p_pkg_name => G_PKG_NAME,
175: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
176: x_msg_count => x_msg_count,
171: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
172: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
173: p_api_name => l_api_name,
174: p_pkg_name => G_PKG_NAME,
175: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
176: x_msg_count => x_msg_count,
177: x_msg_data => x_msg_data,
178: p_api_type => G_API_TYPE);
179:
177: x_msg_data => x_msg_data,
178: p_api_type => G_API_TYPE);
179:
180: when OTHERS then
181: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
182: p_api_name => l_api_name,
183: p_pkg_name => G_PKG_NAME,
184: p_exc_name => 'OTHERS',
185: x_msg_count => x_msg_count,
189: END process_template_rules;
190:
191: FUNCTION get_header_rule_group_id(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_chr_id IN NUMBER,