4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_REPORT_TEMPLATES_V Record Spec
7: TYPE rtmpv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,report_id NUMBER := OKC_API.G_MISS_NUM
10: ,template_set_id NUMBER := OKC_API.G_MISS_NUM
11: ,template_set_type OKS_REPORT_TEMPLATES_V.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,start_date OKS_REPORT_TEMPLATES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
5: ---------------------------------------------------------------------------
6: -- OKS_REPORT_TEMPLATES_V Record Spec
7: TYPE rtmpv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,report_id NUMBER := OKC_API.G_MISS_NUM
10: ,template_set_id NUMBER := OKC_API.G_MISS_NUM
11: ,template_set_type OKS_REPORT_TEMPLATES_V.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,start_date OKS_REPORT_TEMPLATES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,end_date OKS_REPORT_TEMPLATES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
6: -- OKS_REPORT_TEMPLATES_V Record Spec
7: TYPE rtmpv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,report_id NUMBER := OKC_API.G_MISS_NUM
10: ,template_set_id NUMBER := OKC_API.G_MISS_NUM
11: ,template_set_type OKS_REPORT_TEMPLATES_V.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,start_date OKS_REPORT_TEMPLATES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,end_date OKS_REPORT_TEMPLATES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,report_duration NUMBER := OKC_API.G_MISS_NUM
7: TYPE rtmpv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,report_id NUMBER := OKC_API.G_MISS_NUM
10: ,template_set_id NUMBER := OKC_API.G_MISS_NUM
11: ,template_set_type OKS_REPORT_TEMPLATES_V.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,start_date OKS_REPORT_TEMPLATES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,end_date OKS_REPORT_TEMPLATES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,report_duration NUMBER := OKC_API.G_MISS_NUM
15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,report_id NUMBER := OKC_API.G_MISS_NUM
10: ,template_set_id NUMBER := OKC_API.G_MISS_NUM
11: ,template_set_type OKS_REPORT_TEMPLATES_V.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,start_date OKS_REPORT_TEMPLATES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,end_date OKS_REPORT_TEMPLATES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,report_duration NUMBER := OKC_API.G_MISS_NUM
15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
16: ,sts_code OKS_REPORT_TEMPLATES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
9: ,report_id NUMBER := OKC_API.G_MISS_NUM
10: ,template_set_id NUMBER := OKC_API.G_MISS_NUM
11: ,template_set_type OKS_REPORT_TEMPLATES_V.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,start_date OKS_REPORT_TEMPLATES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,end_date OKS_REPORT_TEMPLATES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,report_duration NUMBER := OKC_API.G_MISS_NUM
15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
16: ,sts_code OKS_REPORT_TEMPLATES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
10: ,template_set_id NUMBER := OKC_API.G_MISS_NUM
11: ,template_set_type OKS_REPORT_TEMPLATES_V.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,start_date OKS_REPORT_TEMPLATES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,end_date OKS_REPORT_TEMPLATES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,report_duration NUMBER := OKC_API.G_MISS_NUM
15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
16: ,sts_code OKS_REPORT_TEMPLATES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
18: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
11: ,template_set_type OKS_REPORT_TEMPLATES_V.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: ,start_date OKS_REPORT_TEMPLATES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,end_date OKS_REPORT_TEMPLATES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,report_duration NUMBER := OKC_API.G_MISS_NUM
15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
16: ,sts_code OKS_REPORT_TEMPLATES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
18: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
19: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
12: ,start_date OKS_REPORT_TEMPLATES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,end_date OKS_REPORT_TEMPLATES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,report_duration NUMBER := OKC_API.G_MISS_NUM
15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
16: ,sts_code OKS_REPORT_TEMPLATES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
18: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
19: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
20: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
13: ,end_date OKS_REPORT_TEMPLATES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,report_duration NUMBER := OKC_API.G_MISS_NUM
15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
16: ,sts_code OKS_REPORT_TEMPLATES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
18: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
19: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
20: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
14: ,report_duration NUMBER := OKC_API.G_MISS_NUM
15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
16: ,sts_code OKS_REPORT_TEMPLATES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
18: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
19: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
20: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_REPORT_TEMPLATES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,report_period OKS_REPORT_TEMPLATES_V.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
16: ,sts_code OKS_REPORT_TEMPLATES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
18: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
19: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
20: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_REPORT_TEMPLATES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
16: ,sts_code OKS_REPORT_TEMPLATES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
18: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
19: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
20: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_REPORT_TEMPLATES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
24: ,last_update_date OKS_REPORT_TEMPLATES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
18: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
19: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
20: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_REPORT_TEMPLATES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
24: ,last_update_date OKS_REPORT_TEMPLATES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
18: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
19: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
20: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_REPORT_TEMPLATES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
24: ,last_update_date OKS_REPORT_TEMPLATES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
26: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
19: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
20: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_REPORT_TEMPLATES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
24: ,last_update_date OKS_REPORT_TEMPLATES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
26: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
27: G_MISS_rtmpv_rec rtmpv_rec_type;
20: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_REPORT_TEMPLATES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
24: ,last_update_date OKS_REPORT_TEMPLATES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
26: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
27: G_MISS_rtmpv_rec rtmpv_rec_type;
28: TYPE rtmpv_tbl_type IS TABLE OF rtmpv_rec_type
21: ,created_by NUMBER := OKC_API.G_MISS_NUM
22: ,creation_date OKS_REPORT_TEMPLATES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
24: ,last_update_date OKS_REPORT_TEMPLATES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
26: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
27: G_MISS_rtmpv_rec rtmpv_rec_type;
28: TYPE rtmpv_tbl_type IS TABLE OF rtmpv_rec_type
29: INDEX BY BINARY_INTEGER;
22: ,creation_date OKS_REPORT_TEMPLATES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
24: ,last_update_date OKS_REPORT_TEMPLATES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
25: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
26: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
27: G_MISS_rtmpv_rec rtmpv_rec_type;
28: TYPE rtmpv_tbl_type IS TABLE OF rtmpv_rec_type
29: INDEX BY BINARY_INTEGER;
30: -- OKS_REPORT_TEMPLATES Record Spec
28: TYPE rtmpv_tbl_type IS TABLE OF rtmpv_rec_type
29: INDEX BY BINARY_INTEGER;
30: -- OKS_REPORT_TEMPLATES Record Spec
31: TYPE rtmp_rec_type IS RECORD (
32: id NUMBER := OKC_API.G_MISS_NUM
33: ,report_id NUMBER := OKC_API.G_MISS_NUM
34: ,template_set_id NUMBER := OKC_API.G_MISS_NUM
35: ,template_set_type OKS_REPORT_TEMPLATES.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
36: ,start_date OKS_REPORT_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE
29: INDEX BY BINARY_INTEGER;
30: -- OKS_REPORT_TEMPLATES Record Spec
31: TYPE rtmp_rec_type IS RECORD (
32: id NUMBER := OKC_API.G_MISS_NUM
33: ,report_id NUMBER := OKC_API.G_MISS_NUM
34: ,template_set_id NUMBER := OKC_API.G_MISS_NUM
35: ,template_set_type OKS_REPORT_TEMPLATES.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
36: ,start_date OKS_REPORT_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,end_date OKS_REPORT_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE
30: -- OKS_REPORT_TEMPLATES Record Spec
31: TYPE rtmp_rec_type IS RECORD (
32: id NUMBER := OKC_API.G_MISS_NUM
33: ,report_id NUMBER := OKC_API.G_MISS_NUM
34: ,template_set_id NUMBER := OKC_API.G_MISS_NUM
35: ,template_set_type OKS_REPORT_TEMPLATES.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
36: ,start_date OKS_REPORT_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,end_date OKS_REPORT_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,report_duration NUMBER := OKC_API.G_MISS_NUM
31: TYPE rtmp_rec_type IS RECORD (
32: id NUMBER := OKC_API.G_MISS_NUM
33: ,report_id NUMBER := OKC_API.G_MISS_NUM
34: ,template_set_id NUMBER := OKC_API.G_MISS_NUM
35: ,template_set_type OKS_REPORT_TEMPLATES.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
36: ,start_date OKS_REPORT_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,end_date OKS_REPORT_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,report_duration NUMBER := OKC_API.G_MISS_NUM
39: ,report_period OKS_REPORT_TEMPLATES.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
32: id NUMBER := OKC_API.G_MISS_NUM
33: ,report_id NUMBER := OKC_API.G_MISS_NUM
34: ,template_set_id NUMBER := OKC_API.G_MISS_NUM
35: ,template_set_type OKS_REPORT_TEMPLATES.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
36: ,start_date OKS_REPORT_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,end_date OKS_REPORT_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,report_duration NUMBER := OKC_API.G_MISS_NUM
39: ,report_period OKS_REPORT_TEMPLATES.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code OKS_REPORT_TEMPLATES.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
33: ,report_id NUMBER := OKC_API.G_MISS_NUM
34: ,template_set_id NUMBER := OKC_API.G_MISS_NUM
35: ,template_set_type OKS_REPORT_TEMPLATES.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
36: ,start_date OKS_REPORT_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,end_date OKS_REPORT_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,report_duration NUMBER := OKC_API.G_MISS_NUM
39: ,report_period OKS_REPORT_TEMPLATES.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code OKS_REPORT_TEMPLATES.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
34: ,template_set_id NUMBER := OKC_API.G_MISS_NUM
35: ,template_set_type OKS_REPORT_TEMPLATES.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
36: ,start_date OKS_REPORT_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,end_date OKS_REPORT_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,report_duration NUMBER := OKC_API.G_MISS_NUM
39: ,report_period OKS_REPORT_TEMPLATES.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code OKS_REPORT_TEMPLATES.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
42: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
35: ,template_set_type OKS_REPORT_TEMPLATES.TEMPLATE_SET_TYPE%TYPE := OKC_API.G_MISS_CHAR
36: ,start_date OKS_REPORT_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,end_date OKS_REPORT_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,report_duration NUMBER := OKC_API.G_MISS_NUM
39: ,report_period OKS_REPORT_TEMPLATES.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code OKS_REPORT_TEMPLATES.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
42: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
43: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
36: ,start_date OKS_REPORT_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,end_date OKS_REPORT_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,report_duration NUMBER := OKC_API.G_MISS_NUM
39: ,report_period OKS_REPORT_TEMPLATES.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code OKS_REPORT_TEMPLATES.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
42: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
43: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
44: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
37: ,end_date OKS_REPORT_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,report_duration NUMBER := OKC_API.G_MISS_NUM
39: ,report_period OKS_REPORT_TEMPLATES.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code OKS_REPORT_TEMPLATES.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
42: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
43: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
44: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
38: ,report_duration NUMBER := OKC_API.G_MISS_NUM
39: ,report_period OKS_REPORT_TEMPLATES.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code OKS_REPORT_TEMPLATES.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
42: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
43: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
44: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_REPORT_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,report_period OKS_REPORT_TEMPLATES.REPORT_PERIOD%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code OKS_REPORT_TEMPLATES.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
42: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
43: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
44: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_REPORT_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
40: ,sts_code OKS_REPORT_TEMPLATES.STS_CODE%TYPE := OKC_API.G_MISS_CHAR
41: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
42: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
43: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
44: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_REPORT_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
48: ,last_update_date OKS_REPORT_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,process_code OKS_REPORT_TEMPLATES_V.process_code%TYPE := OKC_API.G_MISS_CHAR
42: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
43: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
44: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_REPORT_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
48: ,last_update_date OKS_REPORT_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
42: ,applies_to OKS_REPORT_TEMPLATES_V.applies_to%TYPE := OKC_API.G_MISS_CHAR
43: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
44: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_REPORT_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
48: ,last_update_date OKS_REPORT_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
43: ,attachment_name OKS_REPORT_TEMPLATES_V.attachment_name%TYPE := OKC_API.G_MISS_CHAR
44: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_REPORT_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
48: ,last_update_date OKS_REPORT_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
51: G_MISS_rtmp_rec rtmp_rec_type;
44: ,message_template_id NUMBER := OKC_API.G_MISS_NUM
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_REPORT_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
48: ,last_update_date OKS_REPORT_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
51: G_MISS_rtmp_rec rtmp_rec_type;
52: TYPE rtmp_tbl_type IS TABLE OF rtmp_rec_type
45: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,creation_date OKS_REPORT_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
48: ,last_update_date OKS_REPORT_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
51: G_MISS_rtmp_rec rtmp_rec_type;
52: TYPE rtmp_tbl_type IS TABLE OF rtmp_rec_type
53: INDEX BY BINARY_INTEGER;
46: ,creation_date OKS_REPORT_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
48: ,last_update_date OKS_REPORT_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
51: G_MISS_rtmp_rec rtmp_rec_type;
52: TYPE rtmp_tbl_type IS TABLE OF rtmp_rec_type
53: INDEX BY BINARY_INTEGER;
54: ---------------------------------------------------------------------------
53: INDEX BY BINARY_INTEGER;
54: ---------------------------------------------------------------------------
55: -- GLOBAL MESSAGE CONSTANTS
56: ---------------------------------------------------------------------------
57: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
54: ---------------------------------------------------------------------------
55: -- GLOBAL MESSAGE CONSTANTS
56: ---------------------------------------------------------------------------
57: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
55: -- GLOBAL MESSAGE CONSTANTS
56: ---------------------------------------------------------------------------
57: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
56: ---------------------------------------------------------------------------
57: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
57: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
58: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
66: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
59: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
66: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
67: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
60: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
66: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
67: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
68: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
61: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
66: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
67: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
68: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
69: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
62: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
63: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
64: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
65: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
66: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
67: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
68: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
69: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
70:
76: ---------------------------------------------------------------------------
77: -- GLOBAL VARIABLES
78: ---------------------------------------------------------------------------
79: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_REPORT_TEMPLATES_PVT';
80: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
81: ---------------------------------------------------------------------------
82: -- Procedures and Functions
83: ---------------------------------------------------------------------------
84:
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_rtmpv_tbl IN rtmpv_tbl_type,
103: x_rtmpv_tbl OUT NOCOPY rtmpv_tbl_type,
104: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
105: PROCEDURE insert_row(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2,
108: x_return_status OUT NOCOPY VARCHAR2,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_rtmpv_tbl IN rtmpv_tbl_type,
127: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
128: PROCEDURE lock_row(
129: p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2,
131: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_rtmpv_tbl IN rtmpv_tbl_type,
150: x_rtmpv_tbl OUT NOCOPY rtmpv_tbl_type,
151: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
152: PROCEDURE update_row(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2,
155: x_return_status OUT NOCOPY VARCHAR2,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_rtmpv_tbl IN rtmpv_tbl_type,
174: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
175: PROCEDURE delete_row(
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2,
178: x_return_status OUT NOCOPY VARCHAR2,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_rtmpv_tbl IN rtmpv_tbl_type,
196: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
197: PROCEDURE validate_row(
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2,
200: x_return_status OUT NOCOPY VARCHAR2,