20:
21: ---------------------------------------------------------------------------
22: -- GLOBAL MESSAGE CONSTANTS
23: ---------------------------------------------------------------------------
24: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
21: ---------------------------------------------------------------------------
22: -- GLOBAL MESSAGE CONSTANTS
23: ---------------------------------------------------------------------------
24: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
22: -- GLOBAL MESSAGE CONSTANTS
23: ---------------------------------------------------------------------------
24: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
23: ---------------------------------------------------------------------------
24: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
24: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
25: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
33: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
26: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
33: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
34: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
27: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
33: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
34: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
35: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
28: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
33: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
34: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
35: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
36: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
29: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
32: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
33: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
34: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
35: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
36: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
37: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
43:
44: -- GLOBAL VARIABLES
45: ---------------------------------------------------------------------------
46: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_RULE_PUB';
47: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
48:
49: g_rulv_rec rulv_rec_type;
50: g_rgpv_rec rgpv_rec_type;
51: g_rmpv_rec rmpv_rec_type;
55: -- public procedure declarations
56:
57: PROCEDURE create_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_rulv_rec IN rulv_rec_type,
65: p_euro_conv_yn IN VARCHAR2);
66:
67: PROCEDURE create_rule(
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2,
73: p_rulv_rec IN rulv_rec_type,
74: x_rulv_rec OUT NOCOPY rulv_rec_type);
75:
76: PROCEDURE create_rule(
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2,
82: p_rulv_tbl IN rulv_tbl_type,
84: p_euro_conv_yn IN VARCHAR2);
85:
86: PROCEDURE create_rule(
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,
92: p_rulv_tbl IN rulv_tbl_type,
93: x_rulv_tbl OUT NOCOPY rulv_tbl_type);
94:
95: PROCEDURE update_rule(
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_rulv_rec IN rulv_rec_type,
102: x_rulv_rec OUT NOCOPY rulv_rec_type);
103:
104: PROCEDURE update_rule(
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_msg_count OUT NOCOPY NUMBER,
109: x_msg_data OUT NOCOPY VARCHAR2,
110: p_rulv_tbl IN rulv_tbl_type,
111: x_rulv_tbl OUT NOCOPY rulv_tbl_type);
112:
113: PROCEDURE validate_rule(
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_rulv_rec IN rulv_rec_type);
119: p_rulv_rec IN rulv_rec_type);
120:
121: PROCEDURE validate_rule(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_rulv_tbl IN rulv_tbl_type);
127: p_rulv_tbl IN rulv_tbl_type);
128:
129: PROCEDURE delete_rule(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_rulv_rec IN rulv_rec_type);
135: p_rulv_rec IN rulv_rec_type);
136:
137: PROCEDURE delete_rule(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_rulv_tbl IN rulv_tbl_type);
143: p_rulv_tbl IN rulv_tbl_type);
144:
145: PROCEDURE lock_rule(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_rulv_rec IN rulv_rec_type);
151: p_rulv_rec IN rulv_rec_type);
152:
153: PROCEDURE lock_rule(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_rulv_tbl IN rulv_tbl_type);
159: p_rulv_tbl IN rulv_tbl_type);
160:
161: PROCEDURE create_rule_group(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_rgpv_rec IN rgpv_rec_type,
168: x_rgpv_rec OUT NOCOPY rgpv_rec_type);
169:
170: PROCEDURE create_rule_group(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_rgpv_tbl IN rgpv_tbl_type,
177: x_rgpv_tbl OUT NOCOPY rgpv_tbl_type);
178:
179: PROCEDURE update_rule_group(
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_rgpv_rec IN rgpv_rec_type,
186: x_rgpv_rec OUT NOCOPY rgpv_rec_type);
187:
188: PROCEDURE update_rule_group(
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2,
194: p_rgpv_tbl IN rgpv_tbl_type,
195: x_rgpv_tbl OUT NOCOPY rgpv_tbl_type);
196:
197: PROCEDURE delete_rule_group(
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,
202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_rgpv_rec IN rgpv_rec_type);
203: p_rgpv_rec IN rgpv_rec_type);
204:
205: PROCEDURE delete_rule_group(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_rgpv_tbl IN rgpv_tbl_type);
211: p_rgpv_tbl IN rgpv_tbl_type);
212:
213: PROCEDURE lock_rule_group(
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_rgpv_rec IN rgpv_rec_type);
219: p_rgpv_rec IN rgpv_rec_type);
220:
221: PROCEDURE lock_rule_group(
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2,
227: p_rgpv_tbl IN rgpv_tbl_type);
227: p_rgpv_tbl IN rgpv_tbl_type);
228:
229: PROCEDURE validate_rule_group(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_rgpv_rec IN rgpv_rec_type);
235: p_rgpv_rec IN rgpv_rec_type);
236:
237: PROCEDURE validate_rule_group(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_rgpv_tbl IN rgpv_tbl_type);
243: p_rgpv_tbl IN rgpv_tbl_type);
244:
245: PROCEDURE create_rg_mode_pty_role(
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
248: x_return_status OUT NOCOPY VARCHAR2,
249: x_msg_count OUT NOCOPY NUMBER,
250: x_msg_data OUT NOCOPY VARCHAR2,
251: p_rmpv_rec IN rmpv_rec_type,
252: x_rmpv_rec OUT NOCOPY rmpv_rec_type);
253:
254: PROCEDURE create_rg_mode_pty_role(
255: p_api_version IN NUMBER,
256: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
257: x_return_status OUT NOCOPY VARCHAR2,
258: x_msg_count OUT NOCOPY NUMBER,
259: x_msg_data OUT NOCOPY VARCHAR2,
260: p_rmpv_tbl IN rmpv_tbl_type,
261: x_rmpv_tbl OUT NOCOPY rmpv_tbl_type);
262:
263: PROCEDURE update_rg_mode_pty_role(
264: p_api_version IN NUMBER,
265: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,
268: x_msg_data OUT NOCOPY VARCHAR2,
269: p_rmpv_rec IN rmpv_rec_type,
270: x_rmpv_rec OUT NOCOPY rmpv_rec_type);
271:
272: PROCEDURE update_rg_mode_pty_role(
273: p_api_version IN NUMBER,
274: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,
278: p_rmpv_tbl IN rmpv_tbl_type,
279: x_rmpv_tbl OUT NOCOPY rmpv_tbl_type);
280:
281: PROCEDURE delete_rg_mode_pty_role(
282: p_api_version IN NUMBER,
283: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2,
287: p_rmpv_rec IN rmpv_rec_type);
287: p_rmpv_rec IN rmpv_rec_type);
288:
289: PROCEDURE delete_rg_mode_pty_role(
290: p_api_version IN NUMBER,
291: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
292: x_return_status OUT NOCOPY VARCHAR2,
293: x_msg_count OUT NOCOPY NUMBER,
294: x_msg_data OUT NOCOPY VARCHAR2,
295: p_rmpv_tbl IN rmpv_tbl_type);
295: p_rmpv_tbl IN rmpv_tbl_type);
296:
297: PROCEDURE lock_rg_mode_pty_role(
298: p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_count OUT NOCOPY NUMBER,
302: x_msg_data OUT NOCOPY VARCHAR2,
303: p_rmpv_rec IN rmpv_rec_type);
303: p_rmpv_rec IN rmpv_rec_type);
304:
305: PROCEDURE lock_rg_mode_pty_role(
306: p_api_version IN NUMBER,
307: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,
310: x_msg_data OUT NOCOPY VARCHAR2,
311: p_rmpv_tbl IN rmpv_tbl_type);
311: p_rmpv_tbl IN rmpv_tbl_type);
312:
313: PROCEDURE validate_rg_mode_pty_role(
314: p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,
318: x_msg_data OUT NOCOPY VARCHAR2,
319: p_rmpv_rec IN rmpv_rec_type);
319: p_rmpv_rec IN rmpv_rec_type);
320:
321: PROCEDURE validate_rg_mode_pty_role(
322: p_api_version IN NUMBER,
323: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
324: x_return_status OUT NOCOPY VARCHAR2,
325: x_msg_count OUT NOCOPY NUMBER,
326: x_msg_data OUT NOCOPY VARCHAR2,
327: p_rmpv_tbl IN rmpv_tbl_type);
327: p_rmpv_tbl IN rmpv_tbl_type);
328:
329: PROCEDURE create_cover_time(
330: p_api_version IN NUMBER,
331: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
332: x_return_status OUT NOCOPY VARCHAR2,
333: x_msg_count OUT NOCOPY NUMBER,
334: x_msg_data OUT NOCOPY VARCHAR2,
335: p_ctiv_rec IN ctiv_rec_type,
336: x_ctiv_rec OUT NOCOPY ctiv_rec_type);
337:
338: PROCEDURE create_cover_time(
339: p_api_version IN NUMBER,
340: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
341: x_return_status OUT NOCOPY VARCHAR2,
342: x_msg_count OUT NOCOPY NUMBER,
343: x_msg_data OUT NOCOPY VARCHAR2,
344: p_ctiv_tbl IN ctiv_tbl_type,
345: x_ctiv_tbl OUT NOCOPY ctiv_tbl_type);
346:
347: PROCEDURE update_cover_time(
348: p_api_version IN NUMBER,
349: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
350: x_return_status OUT NOCOPY VARCHAR2,
351: x_msg_count OUT NOCOPY NUMBER,
352: x_msg_data OUT NOCOPY VARCHAR2,
353: p_ctiv_rec IN ctiv_rec_type,
354: x_ctiv_rec OUT NOCOPY ctiv_rec_type);
355:
356: PROCEDURE update_cover_time(
357: p_api_version IN NUMBER,
358: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
359: x_return_status OUT NOCOPY VARCHAR2,
360: x_msg_count OUT NOCOPY NUMBER,
361: x_msg_data OUT NOCOPY VARCHAR2,
362: p_ctiv_tbl IN ctiv_tbl_type,
363: x_ctiv_tbl OUT NOCOPY ctiv_tbl_type);
364:
365: PROCEDURE delete_cover_time(
366: p_api_version IN NUMBER,
367: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
368: x_return_status OUT NOCOPY VARCHAR2,
369: x_msg_count OUT NOCOPY NUMBER,
370: x_msg_data OUT NOCOPY VARCHAR2,
371: p_ctiv_rec IN ctiv_rec_type);
371: p_ctiv_rec IN ctiv_rec_type);
372:
373: PROCEDURE delete_cover_time(
374: p_api_version IN NUMBER,
375: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
376: x_return_status OUT NOCOPY VARCHAR2,
377: x_msg_count OUT NOCOPY NUMBER,
378: x_msg_data OUT NOCOPY VARCHAR2,
379: p_ctiv_tbl IN ctiv_tbl_type);
379: p_ctiv_tbl IN ctiv_tbl_type);
380:
381: PROCEDURE lock_cover_time(
382: p_api_version IN NUMBER,
383: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
384: x_return_status OUT NOCOPY VARCHAR2,
385: x_msg_count OUT NOCOPY NUMBER,
386: x_msg_data OUT NOCOPY VARCHAR2,
387: p_ctiv_rec IN ctiv_rec_type);
387: p_ctiv_rec IN ctiv_rec_type);
388:
389: PROCEDURE lock_cover_time(
390: p_api_version IN NUMBER,
391: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
392: x_return_status OUT NOCOPY VARCHAR2,
393: x_msg_count OUT NOCOPY NUMBER,
394: x_msg_data OUT NOCOPY VARCHAR2,
395: p_ctiv_tbl IN ctiv_tbl_type);
395: p_ctiv_tbl IN ctiv_tbl_type);
396:
397: PROCEDURE validate_cover_time(
398: p_api_version IN NUMBER,
399: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY NUMBER,
402: x_msg_data OUT NOCOPY VARCHAR2,
403: p_ctiv_rec IN ctiv_rec_type);
403: p_ctiv_rec IN ctiv_rec_type);
404:
405: PROCEDURE validate_cover_time(
406: p_api_version IN NUMBER,
407: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
408: x_return_status OUT NOCOPY VARCHAR2,
409: x_msg_count OUT NOCOPY NUMBER,
410: x_msg_data OUT NOCOPY VARCHAR2,
411: p_ctiv_tbl IN ctiv_tbl_type);
411: p_ctiv_tbl IN ctiv_tbl_type);
412:
413: PROCEDURE create_react_interval(
414: p_api_version IN NUMBER,
415: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
416: x_return_status OUT NOCOPY VARCHAR2,
417: x_msg_count OUT NOCOPY NUMBER,
418: x_msg_data OUT NOCOPY VARCHAR2,
419: p_rilv_rec IN rilv_rec_type,
420: x_rilv_rec OUT NOCOPY rilv_rec_type);
421:
422: PROCEDURE create_react_interval(
423: p_api_version IN NUMBER,
424: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
425: x_return_status OUT NOCOPY VARCHAR2,
426: x_msg_count OUT NOCOPY NUMBER,
427: x_msg_data OUT NOCOPY VARCHAR2,
428: p_rilv_tbl IN rilv_tbl_type,
429: x_rilv_tbl OUT NOCOPY rilv_tbl_type);
430:
431: PROCEDURE update_react_interval(
432: p_api_version IN NUMBER,
433: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
434: x_return_status OUT NOCOPY VARCHAR2,
435: x_msg_count OUT NOCOPY NUMBER,
436: x_msg_data OUT NOCOPY VARCHAR2,
437: p_rilv_rec IN rilv_rec_type,
438: x_rilv_rec OUT NOCOPY rilv_rec_type);
439:
440: PROCEDURE update_react_interval(
441: p_api_version IN NUMBER,
442: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
443: x_return_status OUT NOCOPY VARCHAR2,
444: x_msg_count OUT NOCOPY NUMBER,
445: x_msg_data OUT NOCOPY VARCHAR2,
446: p_rilv_tbl IN rilv_tbl_type,
447: x_rilv_tbl OUT NOCOPY rilv_tbl_type);
448:
449: PROCEDURE delete_react_interval(
450: p_api_version IN NUMBER,
451: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
452: x_return_status OUT NOCOPY VARCHAR2,
453: x_msg_count OUT NOCOPY NUMBER,
454: x_msg_data OUT NOCOPY VARCHAR2,
455: p_rilv_rec IN rilv_rec_type);
455: p_rilv_rec IN rilv_rec_type);
456:
457: PROCEDURE delete_react_interval(
458: p_api_version IN NUMBER,
459: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
460: x_return_status OUT NOCOPY VARCHAR2,
461: x_msg_count OUT NOCOPY NUMBER,
462: x_msg_data OUT NOCOPY VARCHAR2,
463: p_rilv_tbl IN rilv_tbl_type);
463: p_rilv_tbl IN rilv_tbl_type);
464:
465: PROCEDURE lock_react_interval(
466: p_api_version IN NUMBER,
467: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
468: x_return_status OUT NOCOPY VARCHAR2,
469: x_msg_count OUT NOCOPY NUMBER,
470: x_msg_data OUT NOCOPY VARCHAR2,
471: p_rilv_rec IN rilv_rec_type);
471: p_rilv_rec IN rilv_rec_type);
472:
473: PROCEDURE lock_react_interval(
474: p_api_version IN NUMBER,
475: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
476: x_return_status OUT NOCOPY VARCHAR2,
477: x_msg_count OUT NOCOPY NUMBER,
478: x_msg_data OUT NOCOPY VARCHAR2,
479: p_rilv_tbl IN rilv_tbl_type);
479: p_rilv_tbl IN rilv_tbl_type);
480:
481: PROCEDURE validate_react_interval(
482: p_api_version IN NUMBER,
483: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
484: x_return_status OUT NOCOPY VARCHAR2,
485: x_msg_count OUT NOCOPY NUMBER,
486: x_msg_data OUT NOCOPY VARCHAR2,
487: p_rilv_rec IN rilv_rec_type);
487: p_rilv_rec IN rilv_rec_type);
488:
489: PROCEDURE validate_react_interval(
490: p_api_version IN NUMBER,
491: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
492: x_return_status OUT NOCOPY VARCHAR2,
493: x_msg_count OUT NOCOPY NUMBER,
494: x_msg_data OUT NOCOPY VARCHAR2,
495: p_rilv_tbl IN rilv_tbl_type);