93: l_vldv_rec := p_vldv_rec;
94:
95: -- Not applicable to ID and OBJECT_VERSION_NUMBER
96:
97: IF l_vldv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
98: l_vldv_rec.attribute_category := NULL;
99: END IF;
100: IF l_vldv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
101: l_vldv_rec.attribute1 := NULL;
96:
97: IF l_vldv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
98: l_vldv_rec.attribute_category := NULL;
99: END IF;
100: IF l_vldv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
101: l_vldv_rec.attribute1 := NULL;
102: END IF;
103: IF l_vldv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
104: l_vldv_rec.attribute2 := NULL;
99: END IF;
100: IF l_vldv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
101: l_vldv_rec.attribute1 := NULL;
102: END IF;
103: IF l_vldv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
104: l_vldv_rec.attribute2 := NULL;
105: END IF;
106: IF l_vldv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
107: l_vldv_rec.attribute3 := NULL;
102: END IF;
103: IF l_vldv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
104: l_vldv_rec.attribute2 := NULL;
105: END IF;
106: IF l_vldv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
107: l_vldv_rec.attribute3 := NULL;
108: END IF;
109: IF l_vldv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
110: l_vldv_rec.attribute4 := NULL;
105: END IF;
106: IF l_vldv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
107: l_vldv_rec.attribute3 := NULL;
108: END IF;
109: IF l_vldv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
110: l_vldv_rec.attribute4 := NULL;
111: END IF;
112: IF l_vldv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
113: l_vldv_rec.attribute5 := NULL;
108: END IF;
109: IF l_vldv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
110: l_vldv_rec.attribute4 := NULL;
111: END IF;
112: IF l_vldv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
113: l_vldv_rec.attribute5 := NULL;
114: END IF;
115: IF l_vldv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
116: l_vldv_rec.attribute6 := NULL;
111: END IF;
112: IF l_vldv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
113: l_vldv_rec.attribute5 := NULL;
114: END IF;
115: IF l_vldv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
116: l_vldv_rec.attribute6 := NULL;
117: END IF;
118: IF l_vldv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
119: l_vldv_rec.attribute7 := NULL;
114: END IF;
115: IF l_vldv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
116: l_vldv_rec.attribute6 := NULL;
117: END IF;
118: IF l_vldv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
119: l_vldv_rec.attribute7 := NULL;
120: END IF;
121: IF l_vldv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
122: l_vldv_rec.attribute8 := NULL;
117: END IF;
118: IF l_vldv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
119: l_vldv_rec.attribute7 := NULL;
120: END IF;
121: IF l_vldv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
122: l_vldv_rec.attribute8 := NULL;
123: END IF;
124: IF l_vldv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
125: l_vldv_rec.attribute9 := NULL;
120: END IF;
121: IF l_vldv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
122: l_vldv_rec.attribute8 := NULL;
123: END IF;
124: IF l_vldv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
125: l_vldv_rec.attribute9 := NULL;
126: END IF;
127: IF l_vldv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
128: l_vldv_rec.attribute10 := NULL;
123: END IF;
124: IF l_vldv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
125: l_vldv_rec.attribute9 := NULL;
126: END IF;
127: IF l_vldv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
128: l_vldv_rec.attribute10 := NULL;
129: END IF;
130: IF l_vldv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
131: l_vldv_rec.attribute11 := NULL;
126: END IF;
127: IF l_vldv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
128: l_vldv_rec.attribute10 := NULL;
129: END IF;
130: IF l_vldv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
131: l_vldv_rec.attribute11 := NULL;
132: END IF;
133: IF l_vldv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
134: l_vldv_rec.attribute12 := NULL;
129: END IF;
130: IF l_vldv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
131: l_vldv_rec.attribute11 := NULL;
132: END IF;
133: IF l_vldv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
134: l_vldv_rec.attribute12 := NULL;
135: END IF;
136: IF l_vldv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
137: l_vldv_rec.attribute13 := NULL;
132: END IF;
133: IF l_vldv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
134: l_vldv_rec.attribute12 := NULL;
135: END IF;
136: IF l_vldv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
137: l_vldv_rec.attribute13 := NULL;
138: END IF;
139: IF l_vldv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
140: l_vldv_rec.attribute14 := NULL;
135: END IF;
136: IF l_vldv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
137: l_vldv_rec.attribute13 := NULL;
138: END IF;
139: IF l_vldv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
140: l_vldv_rec.attribute14 := NULL;
141: END IF;
142: IF l_vldv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
143: l_vldv_rec.attribute15 := NULL;
138: END IF;
139: IF l_vldv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
140: l_vldv_rec.attribute14 := NULL;
141: END IF;
142: IF l_vldv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
143: l_vldv_rec.attribute15 := NULL;
144: END IF;
145: IF l_vldv_rec.validation_set_id = FND_API.G_MISS_NUM THEN
146: l_vldv_rec.validation_set_id := NULL;
141: END IF;
142: IF l_vldv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
143: l_vldv_rec.attribute15 := NULL;
144: END IF;
145: IF l_vldv_rec.validation_set_id = FND_API.G_MISS_NUM THEN
146: l_vldv_rec.validation_set_id := NULL;
147: END IF;
148: IF l_vldv_rec.function_id = FND_API.G_MISS_NUM THEN
149: l_vldv_rec.function_id := NULL;
144: END IF;
145: IF l_vldv_rec.validation_set_id = FND_API.G_MISS_NUM THEN
146: l_vldv_rec.validation_set_id := NULL;
147: END IF;
148: IF l_vldv_rec.function_id = FND_API.G_MISS_NUM THEN
149: l_vldv_rec.function_id := NULL;
150: END IF;
151: IF l_vldv_rec.failure_severity = FND_API.G_MISS_CHAR THEN
152: l_vldv_rec.failure_severity := NULL;
147: END IF;
148: IF l_vldv_rec.function_id = FND_API.G_MISS_NUM THEN
149: l_vldv_rec.function_id := NULL;
150: END IF;
151: IF l_vldv_rec.failure_severity = FND_API.G_MISS_CHAR THEN
152: l_vldv_rec.failure_severity := NULL;
153: END IF;
154: IF l_vldv_rec.short_description = FND_API.G_MISS_CHAR THEN
155: l_vldv_rec.short_description := NULL;
150: END IF;
151: IF l_vldv_rec.failure_severity = FND_API.G_MISS_CHAR THEN
152: l_vldv_rec.failure_severity := NULL;
153: END IF;
154: IF l_vldv_rec.short_description = FND_API.G_MISS_CHAR THEN
155: l_vldv_rec.short_description := NULL;
156: END IF;
157: IF l_vldv_rec.description = FND_API.G_MISS_CHAR THEN
158: l_vldv_rec.description := NULL;
153: END IF;
154: IF l_vldv_rec.short_description = FND_API.G_MISS_CHAR THEN
155: l_vldv_rec.short_description := NULL;
156: END IF;
157: IF l_vldv_rec.description = FND_API.G_MISS_CHAR THEN
158: l_vldv_rec.description := NULL;
159: END IF;
160: IF l_vldv_rec.comments = FND_API.G_MISS_CHAR THEN
161: l_vldv_rec.comments := NULL;
156: END IF;
157: IF l_vldv_rec.description = FND_API.G_MISS_CHAR THEN
158: l_vldv_rec.description := NULL;
159: END IF;
160: IF l_vldv_rec.comments = FND_API.G_MISS_CHAR THEN
161: l_vldv_rec.comments := NULL;
162: END IF;
163:
164: RETURN l_vldv_rec;
1029: ELSIF l_return_status = G_RET_STS_ERROR THEN
1030: RAISE OKL_API.G_EXCEPTION_ERROR;
1031: END IF;
1032:
1033: IF x_vldv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1034: x_vldv_rec.attribute_category := l_db_vldv_rec.attribute_category;
1035: END IF;
1036: IF x_vldv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1037: x_vldv_rec.attribute1 := l_db_vldv_rec.attribute1;
1032:
1033: IF x_vldv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1034: x_vldv_rec.attribute_category := l_db_vldv_rec.attribute_category;
1035: END IF;
1036: IF x_vldv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1037: x_vldv_rec.attribute1 := l_db_vldv_rec.attribute1;
1038: END IF;
1039: IF x_vldv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1040: x_vldv_rec.attribute2 := l_db_vldv_rec.attribute2;
1035: END IF;
1036: IF x_vldv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1037: x_vldv_rec.attribute1 := l_db_vldv_rec.attribute1;
1038: END IF;
1039: IF x_vldv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1040: x_vldv_rec.attribute2 := l_db_vldv_rec.attribute2;
1041: END IF;
1042: IF x_vldv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1043: x_vldv_rec.attribute3 := l_db_vldv_rec.attribute3;
1038: END IF;
1039: IF x_vldv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1040: x_vldv_rec.attribute2 := l_db_vldv_rec.attribute2;
1041: END IF;
1042: IF x_vldv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1043: x_vldv_rec.attribute3 := l_db_vldv_rec.attribute3;
1044: END IF;
1045: IF x_vldv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1046: x_vldv_rec.attribute4 := l_db_vldv_rec.attribute4;
1041: END IF;
1042: IF x_vldv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1043: x_vldv_rec.attribute3 := l_db_vldv_rec.attribute3;
1044: END IF;
1045: IF x_vldv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1046: x_vldv_rec.attribute4 := l_db_vldv_rec.attribute4;
1047: END IF;
1048: IF x_vldv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1049: x_vldv_rec.attribute5 := l_db_vldv_rec.attribute5;
1044: END IF;
1045: IF x_vldv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1046: x_vldv_rec.attribute4 := l_db_vldv_rec.attribute4;
1047: END IF;
1048: IF x_vldv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1049: x_vldv_rec.attribute5 := l_db_vldv_rec.attribute5;
1050: END IF;
1051: IF x_vldv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1052: x_vldv_rec.attribute6 := l_db_vldv_rec.attribute6;
1047: END IF;
1048: IF x_vldv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1049: x_vldv_rec.attribute5 := l_db_vldv_rec.attribute5;
1050: END IF;
1051: IF x_vldv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1052: x_vldv_rec.attribute6 := l_db_vldv_rec.attribute6;
1053: END IF;
1054: IF x_vldv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1055: x_vldv_rec.attribute7 := l_db_vldv_rec.attribute7;
1050: END IF;
1051: IF x_vldv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1052: x_vldv_rec.attribute6 := l_db_vldv_rec.attribute6;
1053: END IF;
1054: IF x_vldv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1055: x_vldv_rec.attribute7 := l_db_vldv_rec.attribute7;
1056: END IF;
1057: IF x_vldv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1058: x_vldv_rec.attribute8 := l_db_vldv_rec.attribute8;
1053: END IF;
1054: IF x_vldv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1055: x_vldv_rec.attribute7 := l_db_vldv_rec.attribute7;
1056: END IF;
1057: IF x_vldv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1058: x_vldv_rec.attribute8 := l_db_vldv_rec.attribute8;
1059: END IF;
1060: IF x_vldv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1061: x_vldv_rec.attribute9 := l_db_vldv_rec.attribute9;
1056: END IF;
1057: IF x_vldv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1058: x_vldv_rec.attribute8 := l_db_vldv_rec.attribute8;
1059: END IF;
1060: IF x_vldv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1061: x_vldv_rec.attribute9 := l_db_vldv_rec.attribute9;
1062: END IF;
1063: IF x_vldv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1064: x_vldv_rec.attribute10 := l_db_vldv_rec.attribute10;
1059: END IF;
1060: IF x_vldv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1061: x_vldv_rec.attribute9 := l_db_vldv_rec.attribute9;
1062: END IF;
1063: IF x_vldv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1064: x_vldv_rec.attribute10 := l_db_vldv_rec.attribute10;
1065: END IF;
1066: IF x_vldv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1067: x_vldv_rec.attribute11 := l_db_vldv_rec.attribute11;
1062: END IF;
1063: IF x_vldv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1064: x_vldv_rec.attribute10 := l_db_vldv_rec.attribute10;
1065: END IF;
1066: IF x_vldv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1067: x_vldv_rec.attribute11 := l_db_vldv_rec.attribute11;
1068: END IF;
1069: IF x_vldv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1070: x_vldv_rec.attribute12 := l_db_vldv_rec.attribute12;
1065: END IF;
1066: IF x_vldv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1067: x_vldv_rec.attribute11 := l_db_vldv_rec.attribute11;
1068: END IF;
1069: IF x_vldv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1070: x_vldv_rec.attribute12 := l_db_vldv_rec.attribute12;
1071: END IF;
1072: IF x_vldv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1073: x_vldv_rec.attribute13 := l_db_vldv_rec.attribute13;
1068: END IF;
1069: IF x_vldv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1070: x_vldv_rec.attribute12 := l_db_vldv_rec.attribute12;
1071: END IF;
1072: IF x_vldv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1073: x_vldv_rec.attribute13 := l_db_vldv_rec.attribute13;
1074: END IF;
1075: IF x_vldv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1076: x_vldv_rec.attribute14 := l_db_vldv_rec.attribute14;
1071: END IF;
1072: IF x_vldv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1073: x_vldv_rec.attribute13 := l_db_vldv_rec.attribute13;
1074: END IF;
1075: IF x_vldv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1076: x_vldv_rec.attribute14 := l_db_vldv_rec.attribute14;
1077: END IF;
1078: IF x_vldv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1079: x_vldv_rec.attribute15 := l_db_vldv_rec.attribute15;
1074: END IF;
1075: IF x_vldv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1076: x_vldv_rec.attribute14 := l_db_vldv_rec.attribute14;
1077: END IF;
1078: IF x_vldv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1079: x_vldv_rec.attribute15 := l_db_vldv_rec.attribute15;
1080: END IF;
1081: IF x_vldv_rec.validation_set_id = FND_API.G_MISS_NUM THEN
1082: x_vldv_rec.validation_set_id := l_db_vldv_rec.validation_set_id;
1077: END IF;
1078: IF x_vldv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1079: x_vldv_rec.attribute15 := l_db_vldv_rec.attribute15;
1080: END IF;
1081: IF x_vldv_rec.validation_set_id = FND_API.G_MISS_NUM THEN
1082: x_vldv_rec.validation_set_id := l_db_vldv_rec.validation_set_id;
1083: END IF;
1084: IF x_vldv_rec.function_id = FND_API.G_MISS_NUM THEN
1085: x_vldv_rec.function_id := l_db_vldv_rec.function_id;
1080: END IF;
1081: IF x_vldv_rec.validation_set_id = FND_API.G_MISS_NUM THEN
1082: x_vldv_rec.validation_set_id := l_db_vldv_rec.validation_set_id;
1083: END IF;
1084: IF x_vldv_rec.function_id = FND_API.G_MISS_NUM THEN
1085: x_vldv_rec.function_id := l_db_vldv_rec.function_id;
1086: END IF;
1087: IF x_vldv_rec.failure_severity = FND_API.G_MISS_CHAR THEN
1088: x_vldv_rec.failure_severity := l_db_vldv_rec.failure_severity;
1083: END IF;
1084: IF x_vldv_rec.function_id = FND_API.G_MISS_NUM THEN
1085: x_vldv_rec.function_id := l_db_vldv_rec.function_id;
1086: END IF;
1087: IF x_vldv_rec.failure_severity = FND_API.G_MISS_CHAR THEN
1088: x_vldv_rec.failure_severity := l_db_vldv_rec.failure_severity;
1089: END IF;
1090: IF x_vldv_rec.short_description = FND_API.G_MISS_CHAR THEN
1091: x_vldv_rec.short_description := l_db_vldv_rec.short_description;
1086: END IF;
1087: IF x_vldv_rec.failure_severity = FND_API.G_MISS_CHAR THEN
1088: x_vldv_rec.failure_severity := l_db_vldv_rec.failure_severity;
1089: END IF;
1090: IF x_vldv_rec.short_description = FND_API.G_MISS_CHAR THEN
1091: x_vldv_rec.short_description := l_db_vldv_rec.short_description;
1092: END IF;
1093: IF x_vldv_rec.description = FND_API.G_MISS_CHAR THEN
1094: x_vldv_rec.description := l_db_vldv_rec.description;
1089: END IF;
1090: IF x_vldv_rec.short_description = FND_API.G_MISS_CHAR THEN
1091: x_vldv_rec.short_description := l_db_vldv_rec.short_description;
1092: END IF;
1093: IF x_vldv_rec.description = FND_API.G_MISS_CHAR THEN
1094: x_vldv_rec.description := l_db_vldv_rec.description;
1095: END IF;
1096: IF x_vldv_rec.comments = FND_API.G_MISS_CHAR THEN
1097: x_vldv_rec.comments := l_db_vldv_rec.comments;
1092: END IF;
1093: IF x_vldv_rec.description = FND_API.G_MISS_CHAR THEN
1094: x_vldv_rec.description := l_db_vldv_rec.description;
1095: END IF;
1096: IF x_vldv_rec.comments = FND_API.G_MISS_CHAR THEN
1097: x_vldv_rec.comments := l_db_vldv_rec.comments;
1098: END IF;
1099:
1100: RETURN l_return_status;