eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VLS_PVT dependencies on FND_API

Line 97: IF l_vlsv_rec.attribute_category = FND_API.G_MISS_CHAR THEN

93: l_vlsv_rec := p_vlsv_rec;
94:
95: -- Not applicable to ID and OBJECT_VERSION_NUMBER
96:
97: IF l_vlsv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
98: l_vlsv_rec.attribute_category := NULL;
99: END IF;
100: IF l_vlsv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
101: l_vlsv_rec.attribute1 := NULL;

Line 100: IF l_vlsv_rec.attribute1 = FND_API.G_MISS_CHAR THEN

96:
97: IF l_vlsv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
98: l_vlsv_rec.attribute_category := NULL;
99: END IF;
100: IF l_vlsv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
101: l_vlsv_rec.attribute1 := NULL;
102: END IF;
103: IF l_vlsv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
104: l_vlsv_rec.attribute2 := NULL;

Line 103: IF l_vlsv_rec.attribute2 = FND_API.G_MISS_CHAR THEN

99: END IF;
100: IF l_vlsv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
101: l_vlsv_rec.attribute1 := NULL;
102: END IF;
103: IF l_vlsv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
104: l_vlsv_rec.attribute2 := NULL;
105: END IF;
106: IF l_vlsv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
107: l_vlsv_rec.attribute3 := NULL;

Line 106: IF l_vlsv_rec.attribute3 = FND_API.G_MISS_CHAR THEN

102: END IF;
103: IF l_vlsv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
104: l_vlsv_rec.attribute2 := NULL;
105: END IF;
106: IF l_vlsv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
107: l_vlsv_rec.attribute3 := NULL;
108: END IF;
109: IF l_vlsv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
110: l_vlsv_rec.attribute4 := NULL;

Line 109: IF l_vlsv_rec.attribute4 = FND_API.G_MISS_CHAR THEN

105: END IF;
106: IF l_vlsv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
107: l_vlsv_rec.attribute3 := NULL;
108: END IF;
109: IF l_vlsv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
110: l_vlsv_rec.attribute4 := NULL;
111: END IF;
112: IF l_vlsv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
113: l_vlsv_rec.attribute5 := NULL;

Line 112: IF l_vlsv_rec.attribute5 = FND_API.G_MISS_CHAR THEN

108: END IF;
109: IF l_vlsv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
110: l_vlsv_rec.attribute4 := NULL;
111: END IF;
112: IF l_vlsv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
113: l_vlsv_rec.attribute5 := NULL;
114: END IF;
115: IF l_vlsv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
116: l_vlsv_rec.attribute6 := NULL;

Line 115: IF l_vlsv_rec.attribute6 = FND_API.G_MISS_CHAR THEN

111: END IF;
112: IF l_vlsv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
113: l_vlsv_rec.attribute5 := NULL;
114: END IF;
115: IF l_vlsv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
116: l_vlsv_rec.attribute6 := NULL;
117: END IF;
118: IF l_vlsv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
119: l_vlsv_rec.attribute7 := NULL;

Line 118: IF l_vlsv_rec.attribute7 = FND_API.G_MISS_CHAR THEN

114: END IF;
115: IF l_vlsv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
116: l_vlsv_rec.attribute6 := NULL;
117: END IF;
118: IF l_vlsv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
119: l_vlsv_rec.attribute7 := NULL;
120: END IF;
121: IF l_vlsv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
122: l_vlsv_rec.attribute8 := NULL;

Line 121: IF l_vlsv_rec.attribute8 = FND_API.G_MISS_CHAR THEN

117: END IF;
118: IF l_vlsv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
119: l_vlsv_rec.attribute7 := NULL;
120: END IF;
121: IF l_vlsv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
122: l_vlsv_rec.attribute8 := NULL;
123: END IF;
124: IF l_vlsv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
125: l_vlsv_rec.attribute9 := NULL;

Line 124: IF l_vlsv_rec.attribute9 = FND_API.G_MISS_CHAR THEN

120: END IF;
121: IF l_vlsv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
122: l_vlsv_rec.attribute8 := NULL;
123: END IF;
124: IF l_vlsv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
125: l_vlsv_rec.attribute9 := NULL;
126: END IF;
127: IF l_vlsv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
128: l_vlsv_rec.attribute10 := NULL;

Line 127: IF l_vlsv_rec.attribute10 = FND_API.G_MISS_CHAR THEN

123: END IF;
124: IF l_vlsv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
125: l_vlsv_rec.attribute9 := NULL;
126: END IF;
127: IF l_vlsv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
128: l_vlsv_rec.attribute10 := NULL;
129: END IF;
130: IF l_vlsv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
131: l_vlsv_rec.attribute11 := NULL;

Line 130: IF l_vlsv_rec.attribute11 = FND_API.G_MISS_CHAR THEN

126: END IF;
127: IF l_vlsv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
128: l_vlsv_rec.attribute10 := NULL;
129: END IF;
130: IF l_vlsv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
131: l_vlsv_rec.attribute11 := NULL;
132: END IF;
133: IF l_vlsv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
134: l_vlsv_rec.attribute12 := NULL;

Line 133: IF l_vlsv_rec.attribute12 = FND_API.G_MISS_CHAR THEN

129: END IF;
130: IF l_vlsv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
131: l_vlsv_rec.attribute11 := NULL;
132: END IF;
133: IF l_vlsv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
134: l_vlsv_rec.attribute12 := NULL;
135: END IF;
136: IF l_vlsv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
137: l_vlsv_rec.attribute13 := NULL;

Line 136: IF l_vlsv_rec.attribute13 = FND_API.G_MISS_CHAR THEN

132: END IF;
133: IF l_vlsv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
134: l_vlsv_rec.attribute12 := NULL;
135: END IF;
136: IF l_vlsv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
137: l_vlsv_rec.attribute13 := NULL;
138: END IF;
139: IF l_vlsv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
140: l_vlsv_rec.attribute14 := NULL;

Line 139: IF l_vlsv_rec.attribute14 = FND_API.G_MISS_CHAR THEN

135: END IF;
136: IF l_vlsv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
137: l_vlsv_rec.attribute13 := NULL;
138: END IF;
139: IF l_vlsv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
140: l_vlsv_rec.attribute14 := NULL;
141: END IF;
142: IF l_vlsv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
143: l_vlsv_rec.attribute15 := NULL;

Line 142: IF l_vlsv_rec.attribute15 = FND_API.G_MISS_CHAR THEN

138: END IF;
139: IF l_vlsv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
140: l_vlsv_rec.attribute14 := NULL;
141: END IF;
142: IF l_vlsv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
143: l_vlsv_rec.attribute15 := NULL;
144: END IF;
145: IF l_vlsv_rec.org_id = FND_API.G_MISS_NUM THEN
146: l_vlsv_rec.org_id := NULL;

Line 145: IF l_vlsv_rec.org_id = FND_API.G_MISS_NUM THEN

141: END IF;
142: IF l_vlsv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
143: l_vlsv_rec.attribute15 := NULL;
144: END IF;
145: IF l_vlsv_rec.org_id = FND_API.G_MISS_NUM THEN
146: l_vlsv_rec.org_id := NULL;
147: END IF;
148: IF l_vlsv_rec.validation_set_name = FND_API.G_MISS_CHAR THEN
149: l_vlsv_rec.validation_set_name := NULL;

Line 148: IF l_vlsv_rec.validation_set_name = FND_API.G_MISS_CHAR THEN

144: END IF;
145: IF l_vlsv_rec.org_id = FND_API.G_MISS_NUM THEN
146: l_vlsv_rec.org_id := NULL;
147: END IF;
148: IF l_vlsv_rec.validation_set_name = FND_API.G_MISS_CHAR THEN
149: l_vlsv_rec.validation_set_name := NULL;
150: END IF;
151: IF l_vlsv_rec.effective_from = FND_API.G_MISS_DATE THEN
152: l_vlsv_rec.effective_from := NULL;

Line 151: IF l_vlsv_rec.effective_from = FND_API.G_MISS_DATE THEN

147: END IF;
148: IF l_vlsv_rec.validation_set_name = FND_API.G_MISS_CHAR THEN
149: l_vlsv_rec.validation_set_name := NULL;
150: END IF;
151: IF l_vlsv_rec.effective_from = FND_API.G_MISS_DATE THEN
152: l_vlsv_rec.effective_from := NULL;
153: END IF;
154: IF l_vlsv_rec.effective_to = FND_API.G_MISS_DATE THEN
155: l_vlsv_rec.effective_to := NULL;

Line 154: IF l_vlsv_rec.effective_to = FND_API.G_MISS_DATE THEN

150: END IF;
151: IF l_vlsv_rec.effective_from = FND_API.G_MISS_DATE THEN
152: l_vlsv_rec.effective_from := NULL;
153: END IF;
154: IF l_vlsv_rec.effective_to = FND_API.G_MISS_DATE THEN
155: l_vlsv_rec.effective_to := NULL;
156: END IF;
157: IF l_vlsv_rec.short_description = FND_API.G_MISS_CHAR THEN
158: l_vlsv_rec.short_description := NULL;

Line 157: IF l_vlsv_rec.short_description = FND_API.G_MISS_CHAR THEN

153: END IF;
154: IF l_vlsv_rec.effective_to = FND_API.G_MISS_DATE THEN
155: l_vlsv_rec.effective_to := NULL;
156: END IF;
157: IF l_vlsv_rec.short_description = FND_API.G_MISS_CHAR THEN
158: l_vlsv_rec.short_description := NULL;
159: END IF;
160: IF l_vlsv_rec.description = FND_API.G_MISS_CHAR THEN
161: l_vlsv_rec.description := NULL;

Line 160: IF l_vlsv_rec.description = FND_API.G_MISS_CHAR THEN

156: END IF;
157: IF l_vlsv_rec.short_description = FND_API.G_MISS_CHAR THEN
158: l_vlsv_rec.short_description := NULL;
159: END IF;
160: IF l_vlsv_rec.description = FND_API.G_MISS_CHAR THEN
161: l_vlsv_rec.description := NULL;
162: END IF;
163: IF l_vlsv_rec.comments = FND_API.G_MISS_CHAR THEN
164: l_vlsv_rec.comments := NULL;

Line 163: IF l_vlsv_rec.comments = FND_API.G_MISS_CHAR THEN

159: END IF;
160: IF l_vlsv_rec.description = FND_API.G_MISS_CHAR THEN
161: l_vlsv_rec.description := NULL;
162: END IF;
163: IF l_vlsv_rec.comments = FND_API.G_MISS_CHAR THEN
164: l_vlsv_rec.comments := NULL;
165: END IF;
166:
167: RETURN l_vlsv_rec;

Line 1080: IF x_vlsv_rec.attribute_category = FND_API.G_MISS_CHAR THEN

1076: ELSIF l_return_status = G_RET_STS_ERROR THEN
1077: RAISE OKL_API.G_EXCEPTION_ERROR;
1078: END IF;
1079:
1080: IF x_vlsv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1081: x_vlsv_rec.attribute_category := l_db_vlsv_rec.attribute_category;
1082: END IF;
1083: IF x_vlsv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1084: x_vlsv_rec.attribute1 := l_db_vlsv_rec.attribute1;

Line 1083: IF x_vlsv_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1079:
1080: IF x_vlsv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1081: x_vlsv_rec.attribute_category := l_db_vlsv_rec.attribute_category;
1082: END IF;
1083: IF x_vlsv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1084: x_vlsv_rec.attribute1 := l_db_vlsv_rec.attribute1;
1085: END IF;
1086: IF x_vlsv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1087: x_vlsv_rec.attribute2 := l_db_vlsv_rec.attribute2;

Line 1086: IF x_vlsv_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1082: END IF;
1083: IF x_vlsv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1084: x_vlsv_rec.attribute1 := l_db_vlsv_rec.attribute1;
1085: END IF;
1086: IF x_vlsv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1087: x_vlsv_rec.attribute2 := l_db_vlsv_rec.attribute2;
1088: END IF;
1089: IF x_vlsv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1090: x_vlsv_rec.attribute3 := l_db_vlsv_rec.attribute3;

Line 1089: IF x_vlsv_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1085: END IF;
1086: IF x_vlsv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1087: x_vlsv_rec.attribute2 := l_db_vlsv_rec.attribute2;
1088: END IF;
1089: IF x_vlsv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1090: x_vlsv_rec.attribute3 := l_db_vlsv_rec.attribute3;
1091: END IF;
1092: IF x_vlsv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1093: x_vlsv_rec.attribute4 := l_db_vlsv_rec.attribute4;

Line 1092: IF x_vlsv_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1088: END IF;
1089: IF x_vlsv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1090: x_vlsv_rec.attribute3 := l_db_vlsv_rec.attribute3;
1091: END IF;
1092: IF x_vlsv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1093: x_vlsv_rec.attribute4 := l_db_vlsv_rec.attribute4;
1094: END IF;
1095: IF x_vlsv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1096: x_vlsv_rec.attribute5 := l_db_vlsv_rec.attribute5;

Line 1095: IF x_vlsv_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1091: END IF;
1092: IF x_vlsv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1093: x_vlsv_rec.attribute4 := l_db_vlsv_rec.attribute4;
1094: END IF;
1095: IF x_vlsv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1096: x_vlsv_rec.attribute5 := l_db_vlsv_rec.attribute5;
1097: END IF;
1098: IF x_vlsv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1099: x_vlsv_rec.attribute6 := l_db_vlsv_rec.attribute6;

Line 1098: IF x_vlsv_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1094: END IF;
1095: IF x_vlsv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1096: x_vlsv_rec.attribute5 := l_db_vlsv_rec.attribute5;
1097: END IF;
1098: IF x_vlsv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1099: x_vlsv_rec.attribute6 := l_db_vlsv_rec.attribute6;
1100: END IF;
1101: IF x_vlsv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1102: x_vlsv_rec.attribute7 := l_db_vlsv_rec.attribute7;

Line 1101: IF x_vlsv_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1097: END IF;
1098: IF x_vlsv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1099: x_vlsv_rec.attribute6 := l_db_vlsv_rec.attribute6;
1100: END IF;
1101: IF x_vlsv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1102: x_vlsv_rec.attribute7 := l_db_vlsv_rec.attribute7;
1103: END IF;
1104: IF x_vlsv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1105: x_vlsv_rec.attribute8 := l_db_vlsv_rec.attribute8;

Line 1104: IF x_vlsv_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1100: END IF;
1101: IF x_vlsv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1102: x_vlsv_rec.attribute7 := l_db_vlsv_rec.attribute7;
1103: END IF;
1104: IF x_vlsv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1105: x_vlsv_rec.attribute8 := l_db_vlsv_rec.attribute8;
1106: END IF;
1107: IF x_vlsv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1108: x_vlsv_rec.attribute9 := l_db_vlsv_rec.attribute9;

Line 1107: IF x_vlsv_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1103: END IF;
1104: IF x_vlsv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1105: x_vlsv_rec.attribute8 := l_db_vlsv_rec.attribute8;
1106: END IF;
1107: IF x_vlsv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1108: x_vlsv_rec.attribute9 := l_db_vlsv_rec.attribute9;
1109: END IF;
1110: IF x_vlsv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1111: x_vlsv_rec.attribute10 := l_db_vlsv_rec.attribute10;

Line 1110: IF x_vlsv_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1106: END IF;
1107: IF x_vlsv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1108: x_vlsv_rec.attribute9 := l_db_vlsv_rec.attribute9;
1109: END IF;
1110: IF x_vlsv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1111: x_vlsv_rec.attribute10 := l_db_vlsv_rec.attribute10;
1112: END IF;
1113: IF x_vlsv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1114: x_vlsv_rec.attribute11 := l_db_vlsv_rec.attribute11;

Line 1113: IF x_vlsv_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1109: END IF;
1110: IF x_vlsv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1111: x_vlsv_rec.attribute10 := l_db_vlsv_rec.attribute10;
1112: END IF;
1113: IF x_vlsv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1114: x_vlsv_rec.attribute11 := l_db_vlsv_rec.attribute11;
1115: END IF;
1116: IF x_vlsv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1117: x_vlsv_rec.attribute12 := l_db_vlsv_rec.attribute12;

Line 1116: IF x_vlsv_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1112: END IF;
1113: IF x_vlsv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1114: x_vlsv_rec.attribute11 := l_db_vlsv_rec.attribute11;
1115: END IF;
1116: IF x_vlsv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1117: x_vlsv_rec.attribute12 := l_db_vlsv_rec.attribute12;
1118: END IF;
1119: IF x_vlsv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1120: x_vlsv_rec.attribute13 := l_db_vlsv_rec.attribute13;

Line 1119: IF x_vlsv_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1115: END IF;
1116: IF x_vlsv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1117: x_vlsv_rec.attribute12 := l_db_vlsv_rec.attribute12;
1118: END IF;
1119: IF x_vlsv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1120: x_vlsv_rec.attribute13 := l_db_vlsv_rec.attribute13;
1121: END IF;
1122: IF x_vlsv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1123: x_vlsv_rec.attribute14 := l_db_vlsv_rec.attribute14;

Line 1122: IF x_vlsv_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1118: END IF;
1119: IF x_vlsv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1120: x_vlsv_rec.attribute13 := l_db_vlsv_rec.attribute13;
1121: END IF;
1122: IF x_vlsv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1123: x_vlsv_rec.attribute14 := l_db_vlsv_rec.attribute14;
1124: END IF;
1125: IF x_vlsv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1126: x_vlsv_rec.attribute15 := l_db_vlsv_rec.attribute15;

Line 1125: IF x_vlsv_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1121: END IF;
1122: IF x_vlsv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1123: x_vlsv_rec.attribute14 := l_db_vlsv_rec.attribute14;
1124: END IF;
1125: IF x_vlsv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1126: x_vlsv_rec.attribute15 := l_db_vlsv_rec.attribute15;
1127: END IF;
1128: IF x_vlsv_rec.org_id = FND_API.G_MISS_NUM THEN
1129: x_vlsv_rec.org_id := l_db_vlsv_rec.org_id;

Line 1128: IF x_vlsv_rec.org_id = FND_API.G_MISS_NUM THEN

1124: END IF;
1125: IF x_vlsv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1126: x_vlsv_rec.attribute15 := l_db_vlsv_rec.attribute15;
1127: END IF;
1128: IF x_vlsv_rec.org_id = FND_API.G_MISS_NUM THEN
1129: x_vlsv_rec.org_id := l_db_vlsv_rec.org_id;
1130: END IF;
1131: IF x_vlsv_rec.validation_set_name = FND_API.G_MISS_CHAR THEN
1132: x_vlsv_rec.validation_set_name := l_db_vlsv_rec.validation_set_name;

Line 1131: IF x_vlsv_rec.validation_set_name = FND_API.G_MISS_CHAR THEN

1127: END IF;
1128: IF x_vlsv_rec.org_id = FND_API.G_MISS_NUM THEN
1129: x_vlsv_rec.org_id := l_db_vlsv_rec.org_id;
1130: END IF;
1131: IF x_vlsv_rec.validation_set_name = FND_API.G_MISS_CHAR THEN
1132: x_vlsv_rec.validation_set_name := l_db_vlsv_rec.validation_set_name;
1133: END IF;
1134: IF x_vlsv_rec.effective_from = FND_API.G_MISS_DATE THEN
1135: x_vlsv_rec.effective_from := l_db_vlsv_rec.effective_from;

Line 1134: IF x_vlsv_rec.effective_from = FND_API.G_MISS_DATE THEN

1130: END IF;
1131: IF x_vlsv_rec.validation_set_name = FND_API.G_MISS_CHAR THEN
1132: x_vlsv_rec.validation_set_name := l_db_vlsv_rec.validation_set_name;
1133: END IF;
1134: IF x_vlsv_rec.effective_from = FND_API.G_MISS_DATE THEN
1135: x_vlsv_rec.effective_from := l_db_vlsv_rec.effective_from;
1136: END IF;
1137: IF x_vlsv_rec.effective_to = FND_API.G_MISS_DATE THEN
1138: x_vlsv_rec.effective_to := l_db_vlsv_rec.effective_to;

Line 1137: IF x_vlsv_rec.effective_to = FND_API.G_MISS_DATE THEN

1133: END IF;
1134: IF x_vlsv_rec.effective_from = FND_API.G_MISS_DATE THEN
1135: x_vlsv_rec.effective_from := l_db_vlsv_rec.effective_from;
1136: END IF;
1137: IF x_vlsv_rec.effective_to = FND_API.G_MISS_DATE THEN
1138: x_vlsv_rec.effective_to := l_db_vlsv_rec.effective_to;
1139: END IF;
1140: IF x_vlsv_rec.short_description = FND_API.G_MISS_CHAR THEN
1141: x_vlsv_rec.short_description := l_db_vlsv_rec.short_description;

Line 1140: IF x_vlsv_rec.short_description = FND_API.G_MISS_CHAR THEN

1136: END IF;
1137: IF x_vlsv_rec.effective_to = FND_API.G_MISS_DATE THEN
1138: x_vlsv_rec.effective_to := l_db_vlsv_rec.effective_to;
1139: END IF;
1140: IF x_vlsv_rec.short_description = FND_API.G_MISS_CHAR THEN
1141: x_vlsv_rec.short_description := l_db_vlsv_rec.short_description;
1142: END IF;
1143: IF x_vlsv_rec.description = FND_API.G_MISS_CHAR THEN
1144: x_vlsv_rec.description := l_db_vlsv_rec.description;

Line 1143: IF x_vlsv_rec.description = FND_API.G_MISS_CHAR THEN

1139: END IF;
1140: IF x_vlsv_rec.short_description = FND_API.G_MISS_CHAR THEN
1141: x_vlsv_rec.short_description := l_db_vlsv_rec.short_description;
1142: END IF;
1143: IF x_vlsv_rec.description = FND_API.G_MISS_CHAR THEN
1144: x_vlsv_rec.description := l_db_vlsv_rec.description;
1145: END IF;
1146: IF x_vlsv_rec.comments = FND_API.G_MISS_CHAR THEN
1147: x_vlsv_rec.comments := l_db_vlsv_rec.comments;

Line 1146: IF x_vlsv_rec.comments = FND_API.G_MISS_CHAR THEN

1142: END IF;
1143: IF x_vlsv_rec.description = FND_API.G_MISS_CHAR THEN
1144: x_vlsv_rec.description := l_db_vlsv_rec.description;
1145: END IF;
1146: IF x_vlsv_rec.comments = FND_API.G_MISS_CHAR THEN
1147: x_vlsv_rec.comments := l_db_vlsv_rec.comments;
1148: END IF;
1149:
1150: RETURN l_return_status;