30: ------------------
31:
32: -- Do not include WHO columns in the base table record structure
33: TYPE vld_rec_type IS RECORD (
34: id okl_validations_b.id%TYPE
35: ,object_version_number okl_validations_b.object_version_number%TYPE
36: ,attribute_category okl_validations_b.attribute_category%TYPE
37: ,attribute1 okl_validations_b.attribute1%TYPE
38: ,attribute2 okl_validations_b.attribute2%TYPE
31:
32: -- Do not include WHO columns in the base table record structure
33: TYPE vld_rec_type IS RECORD (
34: id okl_validations_b.id%TYPE
35: ,object_version_number okl_validations_b.object_version_number%TYPE
36: ,attribute_category okl_validations_b.attribute_category%TYPE
37: ,attribute1 okl_validations_b.attribute1%TYPE
38: ,attribute2 okl_validations_b.attribute2%TYPE
39: ,attribute3 okl_validations_b.attribute3%TYPE
32: -- Do not include WHO columns in the base table record structure
33: TYPE vld_rec_type IS RECORD (
34: id okl_validations_b.id%TYPE
35: ,object_version_number okl_validations_b.object_version_number%TYPE
36: ,attribute_category okl_validations_b.attribute_category%TYPE
37: ,attribute1 okl_validations_b.attribute1%TYPE
38: ,attribute2 okl_validations_b.attribute2%TYPE
39: ,attribute3 okl_validations_b.attribute3%TYPE
40: ,attribute4 okl_validations_b.attribute4%TYPE
33: TYPE vld_rec_type IS RECORD (
34: id okl_validations_b.id%TYPE
35: ,object_version_number okl_validations_b.object_version_number%TYPE
36: ,attribute_category okl_validations_b.attribute_category%TYPE
37: ,attribute1 okl_validations_b.attribute1%TYPE
38: ,attribute2 okl_validations_b.attribute2%TYPE
39: ,attribute3 okl_validations_b.attribute3%TYPE
40: ,attribute4 okl_validations_b.attribute4%TYPE
41: ,attribute5 okl_validations_b.attribute5%TYPE
34: id okl_validations_b.id%TYPE
35: ,object_version_number okl_validations_b.object_version_number%TYPE
36: ,attribute_category okl_validations_b.attribute_category%TYPE
37: ,attribute1 okl_validations_b.attribute1%TYPE
38: ,attribute2 okl_validations_b.attribute2%TYPE
39: ,attribute3 okl_validations_b.attribute3%TYPE
40: ,attribute4 okl_validations_b.attribute4%TYPE
41: ,attribute5 okl_validations_b.attribute5%TYPE
42: ,attribute6 okl_validations_b.attribute6%TYPE
35: ,object_version_number okl_validations_b.object_version_number%TYPE
36: ,attribute_category okl_validations_b.attribute_category%TYPE
37: ,attribute1 okl_validations_b.attribute1%TYPE
38: ,attribute2 okl_validations_b.attribute2%TYPE
39: ,attribute3 okl_validations_b.attribute3%TYPE
40: ,attribute4 okl_validations_b.attribute4%TYPE
41: ,attribute5 okl_validations_b.attribute5%TYPE
42: ,attribute6 okl_validations_b.attribute6%TYPE
43: ,attribute7 okl_validations_b.attribute7%TYPE
36: ,attribute_category okl_validations_b.attribute_category%TYPE
37: ,attribute1 okl_validations_b.attribute1%TYPE
38: ,attribute2 okl_validations_b.attribute2%TYPE
39: ,attribute3 okl_validations_b.attribute3%TYPE
40: ,attribute4 okl_validations_b.attribute4%TYPE
41: ,attribute5 okl_validations_b.attribute5%TYPE
42: ,attribute6 okl_validations_b.attribute6%TYPE
43: ,attribute7 okl_validations_b.attribute7%TYPE
44: ,attribute8 okl_validations_b.attribute8%TYPE
37: ,attribute1 okl_validations_b.attribute1%TYPE
38: ,attribute2 okl_validations_b.attribute2%TYPE
39: ,attribute3 okl_validations_b.attribute3%TYPE
40: ,attribute4 okl_validations_b.attribute4%TYPE
41: ,attribute5 okl_validations_b.attribute5%TYPE
42: ,attribute6 okl_validations_b.attribute6%TYPE
43: ,attribute7 okl_validations_b.attribute7%TYPE
44: ,attribute8 okl_validations_b.attribute8%TYPE
45: ,attribute9 okl_validations_b.attribute9%TYPE
38: ,attribute2 okl_validations_b.attribute2%TYPE
39: ,attribute3 okl_validations_b.attribute3%TYPE
40: ,attribute4 okl_validations_b.attribute4%TYPE
41: ,attribute5 okl_validations_b.attribute5%TYPE
42: ,attribute6 okl_validations_b.attribute6%TYPE
43: ,attribute7 okl_validations_b.attribute7%TYPE
44: ,attribute8 okl_validations_b.attribute8%TYPE
45: ,attribute9 okl_validations_b.attribute9%TYPE
46: ,attribute10 okl_validations_b.attribute10%TYPE
39: ,attribute3 okl_validations_b.attribute3%TYPE
40: ,attribute4 okl_validations_b.attribute4%TYPE
41: ,attribute5 okl_validations_b.attribute5%TYPE
42: ,attribute6 okl_validations_b.attribute6%TYPE
43: ,attribute7 okl_validations_b.attribute7%TYPE
44: ,attribute8 okl_validations_b.attribute8%TYPE
45: ,attribute9 okl_validations_b.attribute9%TYPE
46: ,attribute10 okl_validations_b.attribute10%TYPE
47: ,attribute11 okl_validations_b.attribute11%TYPE
40: ,attribute4 okl_validations_b.attribute4%TYPE
41: ,attribute5 okl_validations_b.attribute5%TYPE
42: ,attribute6 okl_validations_b.attribute6%TYPE
43: ,attribute7 okl_validations_b.attribute7%TYPE
44: ,attribute8 okl_validations_b.attribute8%TYPE
45: ,attribute9 okl_validations_b.attribute9%TYPE
46: ,attribute10 okl_validations_b.attribute10%TYPE
47: ,attribute11 okl_validations_b.attribute11%TYPE
48: ,attribute12 okl_validations_b.attribute12%TYPE
41: ,attribute5 okl_validations_b.attribute5%TYPE
42: ,attribute6 okl_validations_b.attribute6%TYPE
43: ,attribute7 okl_validations_b.attribute7%TYPE
44: ,attribute8 okl_validations_b.attribute8%TYPE
45: ,attribute9 okl_validations_b.attribute9%TYPE
46: ,attribute10 okl_validations_b.attribute10%TYPE
47: ,attribute11 okl_validations_b.attribute11%TYPE
48: ,attribute12 okl_validations_b.attribute12%TYPE
49: ,attribute13 okl_validations_b.attribute13%TYPE
42: ,attribute6 okl_validations_b.attribute6%TYPE
43: ,attribute7 okl_validations_b.attribute7%TYPE
44: ,attribute8 okl_validations_b.attribute8%TYPE
45: ,attribute9 okl_validations_b.attribute9%TYPE
46: ,attribute10 okl_validations_b.attribute10%TYPE
47: ,attribute11 okl_validations_b.attribute11%TYPE
48: ,attribute12 okl_validations_b.attribute12%TYPE
49: ,attribute13 okl_validations_b.attribute13%TYPE
50: ,attribute14 okl_validations_b.attribute14%TYPE
43: ,attribute7 okl_validations_b.attribute7%TYPE
44: ,attribute8 okl_validations_b.attribute8%TYPE
45: ,attribute9 okl_validations_b.attribute9%TYPE
46: ,attribute10 okl_validations_b.attribute10%TYPE
47: ,attribute11 okl_validations_b.attribute11%TYPE
48: ,attribute12 okl_validations_b.attribute12%TYPE
49: ,attribute13 okl_validations_b.attribute13%TYPE
50: ,attribute14 okl_validations_b.attribute14%TYPE
51: ,attribute15 okl_validations_b.attribute15%TYPE
44: ,attribute8 okl_validations_b.attribute8%TYPE
45: ,attribute9 okl_validations_b.attribute9%TYPE
46: ,attribute10 okl_validations_b.attribute10%TYPE
47: ,attribute11 okl_validations_b.attribute11%TYPE
48: ,attribute12 okl_validations_b.attribute12%TYPE
49: ,attribute13 okl_validations_b.attribute13%TYPE
50: ,attribute14 okl_validations_b.attribute14%TYPE
51: ,attribute15 okl_validations_b.attribute15%TYPE
52: ,validation_set_id okl_validations_b.validation_set_id%TYPE
45: ,attribute9 okl_validations_b.attribute9%TYPE
46: ,attribute10 okl_validations_b.attribute10%TYPE
47: ,attribute11 okl_validations_b.attribute11%TYPE
48: ,attribute12 okl_validations_b.attribute12%TYPE
49: ,attribute13 okl_validations_b.attribute13%TYPE
50: ,attribute14 okl_validations_b.attribute14%TYPE
51: ,attribute15 okl_validations_b.attribute15%TYPE
52: ,validation_set_id okl_validations_b.validation_set_id%TYPE
53: ,function_id okl_validations_b.function_id%TYPE
46: ,attribute10 okl_validations_b.attribute10%TYPE
47: ,attribute11 okl_validations_b.attribute11%TYPE
48: ,attribute12 okl_validations_b.attribute12%TYPE
49: ,attribute13 okl_validations_b.attribute13%TYPE
50: ,attribute14 okl_validations_b.attribute14%TYPE
51: ,attribute15 okl_validations_b.attribute15%TYPE
52: ,validation_set_id okl_validations_b.validation_set_id%TYPE
53: ,function_id okl_validations_b.function_id%TYPE
54: ,failure_severity okl_validations_b.failure_severity%TYPE
47: ,attribute11 okl_validations_b.attribute11%TYPE
48: ,attribute12 okl_validations_b.attribute12%TYPE
49: ,attribute13 okl_validations_b.attribute13%TYPE
50: ,attribute14 okl_validations_b.attribute14%TYPE
51: ,attribute15 okl_validations_b.attribute15%TYPE
52: ,validation_set_id okl_validations_b.validation_set_id%TYPE
53: ,function_id okl_validations_b.function_id%TYPE
54: ,failure_severity okl_validations_b.failure_severity%TYPE
55: );
48: ,attribute12 okl_validations_b.attribute12%TYPE
49: ,attribute13 okl_validations_b.attribute13%TYPE
50: ,attribute14 okl_validations_b.attribute14%TYPE
51: ,attribute15 okl_validations_b.attribute15%TYPE
52: ,validation_set_id okl_validations_b.validation_set_id%TYPE
53: ,function_id okl_validations_b.function_id%TYPE
54: ,failure_severity okl_validations_b.failure_severity%TYPE
55: );
56:
49: ,attribute13 okl_validations_b.attribute13%TYPE
50: ,attribute14 okl_validations_b.attribute14%TYPE
51: ,attribute15 okl_validations_b.attribute15%TYPE
52: ,validation_set_id okl_validations_b.validation_set_id%TYPE
53: ,function_id okl_validations_b.function_id%TYPE
54: ,failure_severity okl_validations_b.failure_severity%TYPE
55: );
56:
57: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
50: ,attribute14 okl_validations_b.attribute14%TYPE
51: ,attribute15 okl_validations_b.attribute15%TYPE
52: ,validation_set_id okl_validations_b.validation_set_id%TYPE
53: ,function_id okl_validations_b.function_id%TYPE
54: ,failure_severity okl_validations_b.failure_severity%TYPE
55: );
56:
57: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
58: TYPE vldtl_rec_type IS RECORD (
63: );
64:
65: -- view record structure
66: TYPE vldv_rec_type IS RECORD (
67: id okl_validations_b.id%TYPE
68: ,object_version_number okl_validations_b.object_version_number%TYPE
69: ,attribute_category okl_validations_b.attribute_category%TYPE
70: ,attribute1 okl_validations_b.attribute1%TYPE
71: ,attribute2 okl_validations_b.attribute2%TYPE
64:
65: -- view record structure
66: TYPE vldv_rec_type IS RECORD (
67: id okl_validations_b.id%TYPE
68: ,object_version_number okl_validations_b.object_version_number%TYPE
69: ,attribute_category okl_validations_b.attribute_category%TYPE
70: ,attribute1 okl_validations_b.attribute1%TYPE
71: ,attribute2 okl_validations_b.attribute2%TYPE
72: ,attribute3 okl_validations_b.attribute3%TYPE
65: -- view record structure
66: TYPE vldv_rec_type IS RECORD (
67: id okl_validations_b.id%TYPE
68: ,object_version_number okl_validations_b.object_version_number%TYPE
69: ,attribute_category okl_validations_b.attribute_category%TYPE
70: ,attribute1 okl_validations_b.attribute1%TYPE
71: ,attribute2 okl_validations_b.attribute2%TYPE
72: ,attribute3 okl_validations_b.attribute3%TYPE
73: ,attribute4 okl_validations_b.attribute4%TYPE
66: TYPE vldv_rec_type IS RECORD (
67: id okl_validations_b.id%TYPE
68: ,object_version_number okl_validations_b.object_version_number%TYPE
69: ,attribute_category okl_validations_b.attribute_category%TYPE
70: ,attribute1 okl_validations_b.attribute1%TYPE
71: ,attribute2 okl_validations_b.attribute2%TYPE
72: ,attribute3 okl_validations_b.attribute3%TYPE
73: ,attribute4 okl_validations_b.attribute4%TYPE
74: ,attribute5 okl_validations_b.attribute5%TYPE
67: id okl_validations_b.id%TYPE
68: ,object_version_number okl_validations_b.object_version_number%TYPE
69: ,attribute_category okl_validations_b.attribute_category%TYPE
70: ,attribute1 okl_validations_b.attribute1%TYPE
71: ,attribute2 okl_validations_b.attribute2%TYPE
72: ,attribute3 okl_validations_b.attribute3%TYPE
73: ,attribute4 okl_validations_b.attribute4%TYPE
74: ,attribute5 okl_validations_b.attribute5%TYPE
75: ,attribute6 okl_validations_b.attribute6%TYPE
68: ,object_version_number okl_validations_b.object_version_number%TYPE
69: ,attribute_category okl_validations_b.attribute_category%TYPE
70: ,attribute1 okl_validations_b.attribute1%TYPE
71: ,attribute2 okl_validations_b.attribute2%TYPE
72: ,attribute3 okl_validations_b.attribute3%TYPE
73: ,attribute4 okl_validations_b.attribute4%TYPE
74: ,attribute5 okl_validations_b.attribute5%TYPE
75: ,attribute6 okl_validations_b.attribute6%TYPE
76: ,attribute7 okl_validations_b.attribute7%TYPE
69: ,attribute_category okl_validations_b.attribute_category%TYPE
70: ,attribute1 okl_validations_b.attribute1%TYPE
71: ,attribute2 okl_validations_b.attribute2%TYPE
72: ,attribute3 okl_validations_b.attribute3%TYPE
73: ,attribute4 okl_validations_b.attribute4%TYPE
74: ,attribute5 okl_validations_b.attribute5%TYPE
75: ,attribute6 okl_validations_b.attribute6%TYPE
76: ,attribute7 okl_validations_b.attribute7%TYPE
77: ,attribute8 okl_validations_b.attribute8%TYPE
70: ,attribute1 okl_validations_b.attribute1%TYPE
71: ,attribute2 okl_validations_b.attribute2%TYPE
72: ,attribute3 okl_validations_b.attribute3%TYPE
73: ,attribute4 okl_validations_b.attribute4%TYPE
74: ,attribute5 okl_validations_b.attribute5%TYPE
75: ,attribute6 okl_validations_b.attribute6%TYPE
76: ,attribute7 okl_validations_b.attribute7%TYPE
77: ,attribute8 okl_validations_b.attribute8%TYPE
78: ,attribute9 okl_validations_b.attribute9%TYPE
71: ,attribute2 okl_validations_b.attribute2%TYPE
72: ,attribute3 okl_validations_b.attribute3%TYPE
73: ,attribute4 okl_validations_b.attribute4%TYPE
74: ,attribute5 okl_validations_b.attribute5%TYPE
75: ,attribute6 okl_validations_b.attribute6%TYPE
76: ,attribute7 okl_validations_b.attribute7%TYPE
77: ,attribute8 okl_validations_b.attribute8%TYPE
78: ,attribute9 okl_validations_b.attribute9%TYPE
79: ,attribute10 okl_validations_b.attribute10%TYPE
72: ,attribute3 okl_validations_b.attribute3%TYPE
73: ,attribute4 okl_validations_b.attribute4%TYPE
74: ,attribute5 okl_validations_b.attribute5%TYPE
75: ,attribute6 okl_validations_b.attribute6%TYPE
76: ,attribute7 okl_validations_b.attribute7%TYPE
77: ,attribute8 okl_validations_b.attribute8%TYPE
78: ,attribute9 okl_validations_b.attribute9%TYPE
79: ,attribute10 okl_validations_b.attribute10%TYPE
80: ,attribute11 okl_validations_b.attribute11%TYPE
73: ,attribute4 okl_validations_b.attribute4%TYPE
74: ,attribute5 okl_validations_b.attribute5%TYPE
75: ,attribute6 okl_validations_b.attribute6%TYPE
76: ,attribute7 okl_validations_b.attribute7%TYPE
77: ,attribute8 okl_validations_b.attribute8%TYPE
78: ,attribute9 okl_validations_b.attribute9%TYPE
79: ,attribute10 okl_validations_b.attribute10%TYPE
80: ,attribute11 okl_validations_b.attribute11%TYPE
81: ,attribute12 okl_validations_b.attribute12%TYPE
74: ,attribute5 okl_validations_b.attribute5%TYPE
75: ,attribute6 okl_validations_b.attribute6%TYPE
76: ,attribute7 okl_validations_b.attribute7%TYPE
77: ,attribute8 okl_validations_b.attribute8%TYPE
78: ,attribute9 okl_validations_b.attribute9%TYPE
79: ,attribute10 okl_validations_b.attribute10%TYPE
80: ,attribute11 okl_validations_b.attribute11%TYPE
81: ,attribute12 okl_validations_b.attribute12%TYPE
82: ,attribute13 okl_validations_b.attribute13%TYPE
75: ,attribute6 okl_validations_b.attribute6%TYPE
76: ,attribute7 okl_validations_b.attribute7%TYPE
77: ,attribute8 okl_validations_b.attribute8%TYPE
78: ,attribute9 okl_validations_b.attribute9%TYPE
79: ,attribute10 okl_validations_b.attribute10%TYPE
80: ,attribute11 okl_validations_b.attribute11%TYPE
81: ,attribute12 okl_validations_b.attribute12%TYPE
82: ,attribute13 okl_validations_b.attribute13%TYPE
83: ,attribute14 okl_validations_b.attribute14%TYPE
76: ,attribute7 okl_validations_b.attribute7%TYPE
77: ,attribute8 okl_validations_b.attribute8%TYPE
78: ,attribute9 okl_validations_b.attribute9%TYPE
79: ,attribute10 okl_validations_b.attribute10%TYPE
80: ,attribute11 okl_validations_b.attribute11%TYPE
81: ,attribute12 okl_validations_b.attribute12%TYPE
82: ,attribute13 okl_validations_b.attribute13%TYPE
83: ,attribute14 okl_validations_b.attribute14%TYPE
84: ,attribute15 okl_validations_b.attribute15%TYPE
77: ,attribute8 okl_validations_b.attribute8%TYPE
78: ,attribute9 okl_validations_b.attribute9%TYPE
79: ,attribute10 okl_validations_b.attribute10%TYPE
80: ,attribute11 okl_validations_b.attribute11%TYPE
81: ,attribute12 okl_validations_b.attribute12%TYPE
82: ,attribute13 okl_validations_b.attribute13%TYPE
83: ,attribute14 okl_validations_b.attribute14%TYPE
84: ,attribute15 okl_validations_b.attribute15%TYPE
85: ,validation_set_id okl_validations_b.validation_set_id%TYPE
78: ,attribute9 okl_validations_b.attribute9%TYPE
79: ,attribute10 okl_validations_b.attribute10%TYPE
80: ,attribute11 okl_validations_b.attribute11%TYPE
81: ,attribute12 okl_validations_b.attribute12%TYPE
82: ,attribute13 okl_validations_b.attribute13%TYPE
83: ,attribute14 okl_validations_b.attribute14%TYPE
84: ,attribute15 okl_validations_b.attribute15%TYPE
85: ,validation_set_id okl_validations_b.validation_set_id%TYPE
86: ,function_id okl_validations_b.function_id%TYPE
79: ,attribute10 okl_validations_b.attribute10%TYPE
80: ,attribute11 okl_validations_b.attribute11%TYPE
81: ,attribute12 okl_validations_b.attribute12%TYPE
82: ,attribute13 okl_validations_b.attribute13%TYPE
83: ,attribute14 okl_validations_b.attribute14%TYPE
84: ,attribute15 okl_validations_b.attribute15%TYPE
85: ,validation_set_id okl_validations_b.validation_set_id%TYPE
86: ,function_id okl_validations_b.function_id%TYPE
87: ,failure_severity okl_validations_b.failure_severity%TYPE
80: ,attribute11 okl_validations_b.attribute11%TYPE
81: ,attribute12 okl_validations_b.attribute12%TYPE
82: ,attribute13 okl_validations_b.attribute13%TYPE
83: ,attribute14 okl_validations_b.attribute14%TYPE
84: ,attribute15 okl_validations_b.attribute15%TYPE
85: ,validation_set_id okl_validations_b.validation_set_id%TYPE
86: ,function_id okl_validations_b.function_id%TYPE
87: ,failure_severity okl_validations_b.failure_severity%TYPE
88: ,short_description okl_validations_tl.short_description%TYPE
81: ,attribute12 okl_validations_b.attribute12%TYPE
82: ,attribute13 okl_validations_b.attribute13%TYPE
83: ,attribute14 okl_validations_b.attribute14%TYPE
84: ,attribute15 okl_validations_b.attribute15%TYPE
85: ,validation_set_id okl_validations_b.validation_set_id%TYPE
86: ,function_id okl_validations_b.function_id%TYPE
87: ,failure_severity okl_validations_b.failure_severity%TYPE
88: ,short_description okl_validations_tl.short_description%TYPE
89: ,description okl_validations_tl.description%TYPE
82: ,attribute13 okl_validations_b.attribute13%TYPE
83: ,attribute14 okl_validations_b.attribute14%TYPE
84: ,attribute15 okl_validations_b.attribute15%TYPE
85: ,validation_set_id okl_validations_b.validation_set_id%TYPE
86: ,function_id okl_validations_b.function_id%TYPE
87: ,failure_severity okl_validations_b.failure_severity%TYPE
88: ,short_description okl_validations_tl.short_description%TYPE
89: ,description okl_validations_tl.description%TYPE
90: ,comments okl_validations_tl.comments%TYPE
83: ,attribute14 okl_validations_b.attribute14%TYPE
84: ,attribute15 okl_validations_b.attribute15%TYPE
85: ,validation_set_id okl_validations_b.validation_set_id%TYPE
86: ,function_id okl_validations_b.function_id%TYPE
87: ,failure_severity okl_validations_b.failure_severity%TYPE
88: ,short_description okl_validations_tl.short_description%TYPE
89: ,description okl_validations_tl.description%TYPE
90: ,comments okl_validations_tl.comments%TYPE
91: );