APPS.OKL_ASO_PVT dependencies on FND_API

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 145: IF l_asov_rec.asset_id = FND_API.G_MISS_NUM THEN

141: END IF;
142: IF l_asov_rec.attribute15 = FND_API.G_MISS_CHAR THEN
143: l_asov_rec.attribute15 := NULL;
144: END IF;
145: IF l_asov_rec.asset_id = FND_API.G_MISS_NUM THEN
146: l_asov_rec.asset_id := NULL;
147: END IF;
148: IF l_asov_rec.inv_item_id = FND_API.G_MISS_NUM THEN
149: l_asov_rec.inv_item_id := NULL;

Line 148: IF l_asov_rec.inv_item_id = FND_API.G_MISS_NUM THEN

144: END IF;
145: IF l_asov_rec.asset_id = FND_API.G_MISS_NUM THEN
146: l_asov_rec.asset_id := NULL;
147: END IF;
148: IF l_asov_rec.inv_item_id = FND_API.G_MISS_NUM THEN
149: l_asov_rec.inv_item_id := NULL;
150: END IF;
151: IF l_asov_rec.supplier_id = FND_API.G_MISS_NUM THEN
152: l_asov_rec.supplier_id := NULL;

Line 151: IF l_asov_rec.supplier_id = FND_API.G_MISS_NUM THEN

147: END IF;
148: IF l_asov_rec.inv_item_id = FND_API.G_MISS_NUM THEN
149: l_asov_rec.inv_item_id := NULL;
150: END IF;
151: IF l_asov_rec.supplier_id = FND_API.G_MISS_NUM THEN
152: l_asov_rec.supplier_id := NULL;
153: END IF;
154: IF l_asov_rec.primary_component = FND_API.G_MISS_CHAR THEN
155: l_asov_rec.primary_component := NULL;

Line 154: IF l_asov_rec.primary_component = FND_API.G_MISS_CHAR THEN

150: END IF;
151: IF l_asov_rec.supplier_id = FND_API.G_MISS_NUM THEN
152: l_asov_rec.supplier_id := NULL;
153: END IF;
154: IF l_asov_rec.primary_component = FND_API.G_MISS_CHAR THEN
155: l_asov_rec.primary_component := NULL;
156: END IF;
157: IF l_asov_rec.unit_cost = FND_API.G_MISS_NUM THEN
158: l_asov_rec.unit_cost := NULL;

Line 157: IF l_asov_rec.unit_cost = FND_API.G_MISS_NUM THEN

153: END IF;
154: IF l_asov_rec.primary_component = FND_API.G_MISS_CHAR THEN
155: l_asov_rec.primary_component := NULL;
156: END IF;
157: IF l_asov_rec.unit_cost = FND_API.G_MISS_NUM THEN
158: l_asov_rec.unit_cost := NULL;
159: END IF;
160: IF l_asov_rec.number_of_units = FND_API.G_MISS_NUM THEN
161: l_asov_rec.number_of_units := NULL;

Line 160: IF l_asov_rec.number_of_units = FND_API.G_MISS_NUM THEN

156: END IF;
157: IF l_asov_rec.unit_cost = FND_API.G_MISS_NUM THEN
158: l_asov_rec.unit_cost := NULL;
159: END IF;
160: IF l_asov_rec.number_of_units = FND_API.G_MISS_NUM THEN
161: l_asov_rec.number_of_units := NULL;
162: END IF;
163: IF l_asov_rec.manufacturer_name = FND_API.G_MISS_CHAR THEN
164: l_asov_rec.manufacturer_name := NULL;

Line 163: IF l_asov_rec.manufacturer_name = FND_API.G_MISS_CHAR THEN

159: END IF;
160: IF l_asov_rec.number_of_units = FND_API.G_MISS_NUM THEN
161: l_asov_rec.number_of_units := NULL;
162: END IF;
163: IF l_asov_rec.manufacturer_name = FND_API.G_MISS_CHAR THEN
164: l_asov_rec.manufacturer_name := NULL;
165: END IF;
166: IF l_asov_rec.year_manufactured = FND_API.G_MISS_NUM THEN
167: l_asov_rec.year_manufactured := NULL;

Line 166: IF l_asov_rec.year_manufactured = FND_API.G_MISS_NUM THEN

162: END IF;
163: IF l_asov_rec.manufacturer_name = FND_API.G_MISS_CHAR THEN
164: l_asov_rec.manufacturer_name := NULL;
165: END IF;
166: IF l_asov_rec.year_manufactured = FND_API.G_MISS_NUM THEN
167: l_asov_rec.year_manufactured := NULL;
168: END IF;
169: IF l_asov_rec.model_number = FND_API.G_MISS_CHAR THEN
170: l_asov_rec.model_number := NULL;

Line 169: IF l_asov_rec.model_number = FND_API.G_MISS_CHAR THEN

165: END IF;
166: IF l_asov_rec.year_manufactured = FND_API.G_MISS_NUM THEN
167: l_asov_rec.year_manufactured := NULL;
168: END IF;
169: IF l_asov_rec.model_number = FND_API.G_MISS_CHAR THEN
170: l_asov_rec.model_number := NULL;
171: END IF;
172: IF l_asov_rec.short_description = FND_API.G_MISS_CHAR THEN
173: l_asov_rec.short_description := NULL;

Line 172: IF l_asov_rec.short_description = FND_API.G_MISS_CHAR THEN

168: END IF;
169: IF l_asov_rec.model_number = FND_API.G_MISS_CHAR THEN
170: l_asov_rec.model_number := NULL;
171: END IF;
172: IF l_asov_rec.short_description = FND_API.G_MISS_CHAR THEN
173: l_asov_rec.short_description := NULL;
174: END IF;
175: IF l_asov_rec.description = FND_API.G_MISS_CHAR THEN
176: l_asov_rec.description := NULL;

Line 175: IF l_asov_rec.description = FND_API.G_MISS_CHAR THEN

171: END IF;
172: IF l_asov_rec.short_description = FND_API.G_MISS_CHAR THEN
173: l_asov_rec.short_description := NULL;
174: END IF;
175: IF l_asov_rec.description = FND_API.G_MISS_CHAR THEN
176: l_asov_rec.description := NULL;
177: END IF;
178: IF l_asov_rec.comments = FND_API.G_MISS_CHAR THEN
179: l_asov_rec.comments := NULL;

Line 178: IF l_asov_rec.comments = FND_API.G_MISS_CHAR THEN

174: END IF;
175: IF l_asov_rec.description = FND_API.G_MISS_CHAR THEN
176: l_asov_rec.description := NULL;
177: END IF;
178: IF l_asov_rec.comments = FND_API.G_MISS_CHAR THEN
179: l_asov_rec.comments := NULL;
180: END IF;
181:
182: RETURN l_asov_rec;

Line 1127: IF x_asov_rec.attribute_category = FND_API.G_MISS_CHAR THEN

1123: ELSIF l_return_status = G_RET_STS_ERROR THEN
1124: RAISE OKL_API.G_EXCEPTION_ERROR;
1125: END IF;
1126:
1127: IF x_asov_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1128: x_asov_rec.attribute_category := l_db_asov_rec.attribute_category;
1129: END IF;
1130: IF x_asov_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1131: x_asov_rec.attribute1 := l_db_asov_rec.attribute1;

Line 1130: IF x_asov_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1126:
1127: IF x_asov_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1128: x_asov_rec.attribute_category := l_db_asov_rec.attribute_category;
1129: END IF;
1130: IF x_asov_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1131: x_asov_rec.attribute1 := l_db_asov_rec.attribute1;
1132: END IF;
1133: IF x_asov_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1134: x_asov_rec.attribute2 := l_db_asov_rec.attribute2;

Line 1133: IF x_asov_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1129: END IF;
1130: IF x_asov_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1131: x_asov_rec.attribute1 := l_db_asov_rec.attribute1;
1132: END IF;
1133: IF x_asov_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1134: x_asov_rec.attribute2 := l_db_asov_rec.attribute2;
1135: END IF;
1136: IF x_asov_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1137: x_asov_rec.attribute3 := l_db_asov_rec.attribute3;

Line 1136: IF x_asov_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1132: END IF;
1133: IF x_asov_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1134: x_asov_rec.attribute2 := l_db_asov_rec.attribute2;
1135: END IF;
1136: IF x_asov_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1137: x_asov_rec.attribute3 := l_db_asov_rec.attribute3;
1138: END IF;
1139: IF x_asov_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1140: x_asov_rec.attribute4 := l_db_asov_rec.attribute4;

Line 1139: IF x_asov_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1135: END IF;
1136: IF x_asov_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1137: x_asov_rec.attribute3 := l_db_asov_rec.attribute3;
1138: END IF;
1139: IF x_asov_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1140: x_asov_rec.attribute4 := l_db_asov_rec.attribute4;
1141: END IF;
1142: IF x_asov_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1143: x_asov_rec.attribute5 := l_db_asov_rec.attribute5;

Line 1142: IF x_asov_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1138: END IF;
1139: IF x_asov_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1140: x_asov_rec.attribute4 := l_db_asov_rec.attribute4;
1141: END IF;
1142: IF x_asov_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1143: x_asov_rec.attribute5 := l_db_asov_rec.attribute5;
1144: END IF;
1145: IF x_asov_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1146: x_asov_rec.attribute6 := l_db_asov_rec.attribute6;

Line 1145: IF x_asov_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1141: END IF;
1142: IF x_asov_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1143: x_asov_rec.attribute5 := l_db_asov_rec.attribute5;
1144: END IF;
1145: IF x_asov_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1146: x_asov_rec.attribute6 := l_db_asov_rec.attribute6;
1147: END IF;
1148: IF x_asov_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1149: x_asov_rec.attribute7 := l_db_asov_rec.attribute7;

Line 1148: IF x_asov_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1144: END IF;
1145: IF x_asov_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1146: x_asov_rec.attribute6 := l_db_asov_rec.attribute6;
1147: END IF;
1148: IF x_asov_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1149: x_asov_rec.attribute7 := l_db_asov_rec.attribute7;
1150: END IF;
1151: IF x_asov_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1152: x_asov_rec.attribute8 := l_db_asov_rec.attribute8;

Line 1151: IF x_asov_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1147: END IF;
1148: IF x_asov_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1149: x_asov_rec.attribute7 := l_db_asov_rec.attribute7;
1150: END IF;
1151: IF x_asov_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1152: x_asov_rec.attribute8 := l_db_asov_rec.attribute8;
1153: END IF;
1154: IF x_asov_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1155: x_asov_rec.attribute9 := l_db_asov_rec.attribute9;

Line 1154: IF x_asov_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1150: END IF;
1151: IF x_asov_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1152: x_asov_rec.attribute8 := l_db_asov_rec.attribute8;
1153: END IF;
1154: IF x_asov_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1155: x_asov_rec.attribute9 := l_db_asov_rec.attribute9;
1156: END IF;
1157: IF x_asov_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1158: x_asov_rec.attribute10 := l_db_asov_rec.attribute10;

Line 1157: IF x_asov_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1153: END IF;
1154: IF x_asov_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1155: x_asov_rec.attribute9 := l_db_asov_rec.attribute9;
1156: END IF;
1157: IF x_asov_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1158: x_asov_rec.attribute10 := l_db_asov_rec.attribute10;
1159: END IF;
1160: IF x_asov_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1161: x_asov_rec.attribute11 := l_db_asov_rec.attribute11;

Line 1160: IF x_asov_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1156: END IF;
1157: IF x_asov_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1158: x_asov_rec.attribute10 := l_db_asov_rec.attribute10;
1159: END IF;
1160: IF x_asov_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1161: x_asov_rec.attribute11 := l_db_asov_rec.attribute11;
1162: END IF;
1163: IF x_asov_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1164: x_asov_rec.attribute12 := l_db_asov_rec.attribute12;

Line 1163: IF x_asov_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1159: END IF;
1160: IF x_asov_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1161: x_asov_rec.attribute11 := l_db_asov_rec.attribute11;
1162: END IF;
1163: IF x_asov_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1164: x_asov_rec.attribute12 := l_db_asov_rec.attribute12;
1165: END IF;
1166: IF x_asov_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1167: x_asov_rec.attribute13 := l_db_asov_rec.attribute13;

Line 1166: IF x_asov_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1162: END IF;
1163: IF x_asov_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1164: x_asov_rec.attribute12 := l_db_asov_rec.attribute12;
1165: END IF;
1166: IF x_asov_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1167: x_asov_rec.attribute13 := l_db_asov_rec.attribute13;
1168: END IF;
1169: IF x_asov_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1170: x_asov_rec.attribute14 := l_db_asov_rec.attribute14;

Line 1169: IF x_asov_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1165: END IF;
1166: IF x_asov_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1167: x_asov_rec.attribute13 := l_db_asov_rec.attribute13;
1168: END IF;
1169: IF x_asov_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1170: x_asov_rec.attribute14 := l_db_asov_rec.attribute14;
1171: END IF;
1172: IF x_asov_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1173: x_asov_rec.attribute15 := l_db_asov_rec.attribute15;

Line 1172: IF x_asov_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1168: END IF;
1169: IF x_asov_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1170: x_asov_rec.attribute14 := l_db_asov_rec.attribute14;
1171: END IF;
1172: IF x_asov_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1173: x_asov_rec.attribute15 := l_db_asov_rec.attribute15;
1174: END IF;
1175: IF x_asov_rec.asset_id = FND_API.G_MISS_NUM THEN
1176: x_asov_rec.asset_id := l_db_asov_rec.asset_id;

Line 1175: IF x_asov_rec.asset_id = FND_API.G_MISS_NUM THEN

1171: END IF;
1172: IF x_asov_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1173: x_asov_rec.attribute15 := l_db_asov_rec.attribute15;
1174: END IF;
1175: IF x_asov_rec.asset_id = FND_API.G_MISS_NUM THEN
1176: x_asov_rec.asset_id := l_db_asov_rec.asset_id;
1177: END IF;
1178: IF x_asov_rec.inv_item_id = FND_API.G_MISS_NUM THEN
1179: x_asov_rec.inv_item_id := l_db_asov_rec.inv_item_id;

Line 1178: IF x_asov_rec.inv_item_id = FND_API.G_MISS_NUM THEN

1174: END IF;
1175: IF x_asov_rec.asset_id = FND_API.G_MISS_NUM THEN
1176: x_asov_rec.asset_id := l_db_asov_rec.asset_id;
1177: END IF;
1178: IF x_asov_rec.inv_item_id = FND_API.G_MISS_NUM THEN
1179: x_asov_rec.inv_item_id := l_db_asov_rec.inv_item_id;
1180: END IF;
1181: IF x_asov_rec.supplier_id = FND_API.G_MISS_NUM THEN
1182: x_asov_rec.supplier_id := l_db_asov_rec.supplier_id;

Line 1181: IF x_asov_rec.supplier_id = FND_API.G_MISS_NUM THEN

1177: END IF;
1178: IF x_asov_rec.inv_item_id = FND_API.G_MISS_NUM THEN
1179: x_asov_rec.inv_item_id := l_db_asov_rec.inv_item_id;
1180: END IF;
1181: IF x_asov_rec.supplier_id = FND_API.G_MISS_NUM THEN
1182: x_asov_rec.supplier_id := l_db_asov_rec.supplier_id;
1183: END IF;
1184: IF x_asov_rec.primary_component = FND_API.G_MISS_CHAR THEN
1185: x_asov_rec.primary_component := l_db_asov_rec.primary_component;

Line 1184: IF x_asov_rec.primary_component = FND_API.G_MISS_CHAR THEN

1180: END IF;
1181: IF x_asov_rec.supplier_id = FND_API.G_MISS_NUM THEN
1182: x_asov_rec.supplier_id := l_db_asov_rec.supplier_id;
1183: END IF;
1184: IF x_asov_rec.primary_component = FND_API.G_MISS_CHAR THEN
1185: x_asov_rec.primary_component := l_db_asov_rec.primary_component;
1186: END IF;
1187: IF x_asov_rec.unit_cost = FND_API.G_MISS_NUM THEN
1188: x_asov_rec.unit_cost := l_db_asov_rec.unit_cost;

Line 1187: IF x_asov_rec.unit_cost = FND_API.G_MISS_NUM THEN

1183: END IF;
1184: IF x_asov_rec.primary_component = FND_API.G_MISS_CHAR THEN
1185: x_asov_rec.primary_component := l_db_asov_rec.primary_component;
1186: END IF;
1187: IF x_asov_rec.unit_cost = FND_API.G_MISS_NUM THEN
1188: x_asov_rec.unit_cost := l_db_asov_rec.unit_cost;
1189: END IF;
1190: IF x_asov_rec.number_of_units = FND_API.G_MISS_NUM THEN
1191: x_asov_rec.number_of_units := l_db_asov_rec.number_of_units;

Line 1190: IF x_asov_rec.number_of_units = FND_API.G_MISS_NUM THEN

1186: END IF;
1187: IF x_asov_rec.unit_cost = FND_API.G_MISS_NUM THEN
1188: x_asov_rec.unit_cost := l_db_asov_rec.unit_cost;
1189: END IF;
1190: IF x_asov_rec.number_of_units = FND_API.G_MISS_NUM THEN
1191: x_asov_rec.number_of_units := l_db_asov_rec.number_of_units;
1192: END IF;
1193: IF x_asov_rec.manufacturer_name = FND_API.G_MISS_CHAR THEN
1194: x_asov_rec.manufacturer_name := l_db_asov_rec.manufacturer_name;

Line 1193: IF x_asov_rec.manufacturer_name = FND_API.G_MISS_CHAR THEN

1189: END IF;
1190: IF x_asov_rec.number_of_units = FND_API.G_MISS_NUM THEN
1191: x_asov_rec.number_of_units := l_db_asov_rec.number_of_units;
1192: END IF;
1193: IF x_asov_rec.manufacturer_name = FND_API.G_MISS_CHAR THEN
1194: x_asov_rec.manufacturer_name := l_db_asov_rec.manufacturer_name;
1195: END IF;
1196: IF x_asov_rec.year_manufactured = FND_API.G_MISS_NUM THEN
1197: x_asov_rec.year_manufactured := l_db_asov_rec.year_manufactured;

Line 1196: IF x_asov_rec.year_manufactured = FND_API.G_MISS_NUM THEN

1192: END IF;
1193: IF x_asov_rec.manufacturer_name = FND_API.G_MISS_CHAR THEN
1194: x_asov_rec.manufacturer_name := l_db_asov_rec.manufacturer_name;
1195: END IF;
1196: IF x_asov_rec.year_manufactured = FND_API.G_MISS_NUM THEN
1197: x_asov_rec.year_manufactured := l_db_asov_rec.year_manufactured;
1198: END IF;
1199: IF x_asov_rec.model_number = FND_API.G_MISS_CHAR THEN
1200: x_asov_rec.model_number := l_db_asov_rec.model_number;

Line 1199: IF x_asov_rec.model_number = FND_API.G_MISS_CHAR THEN

1195: END IF;
1196: IF x_asov_rec.year_manufactured = FND_API.G_MISS_NUM THEN
1197: x_asov_rec.year_manufactured := l_db_asov_rec.year_manufactured;
1198: END IF;
1199: IF x_asov_rec.model_number = FND_API.G_MISS_CHAR THEN
1200: x_asov_rec.model_number := l_db_asov_rec.model_number;
1201: END IF;
1202: IF x_asov_rec.short_description = FND_API.G_MISS_CHAR THEN
1203: x_asov_rec.short_description := l_db_asov_rec.short_description;

Line 1202: IF x_asov_rec.short_description = FND_API.G_MISS_CHAR THEN

1198: END IF;
1199: IF x_asov_rec.model_number = FND_API.G_MISS_CHAR THEN
1200: x_asov_rec.model_number := l_db_asov_rec.model_number;
1201: END IF;
1202: IF x_asov_rec.short_description = FND_API.G_MISS_CHAR THEN
1203: x_asov_rec.short_description := l_db_asov_rec.short_description;
1204: END IF;
1205: IF x_asov_rec.description = FND_API.G_MISS_CHAR THEN
1206: x_asov_rec.description := l_db_asov_rec.description;

Line 1205: IF x_asov_rec.description = FND_API.G_MISS_CHAR THEN

1201: END IF;
1202: IF x_asov_rec.short_description = FND_API.G_MISS_CHAR THEN
1203: x_asov_rec.short_description := l_db_asov_rec.short_description;
1204: END IF;
1205: IF x_asov_rec.description = FND_API.G_MISS_CHAR THEN
1206: x_asov_rec.description := l_db_asov_rec.description;
1207: END IF;
1208: IF x_asov_rec.comments = FND_API.G_MISS_CHAR THEN
1209: x_asov_rec.comments := l_db_asov_rec.comments;

Line 1208: IF x_asov_rec.comments = FND_API.G_MISS_CHAR THEN

1204: END IF;
1205: IF x_asov_rec.description = FND_API.G_MISS_CHAR THEN
1206: x_asov_rec.description := l_db_asov_rec.description;
1207: END IF;
1208: IF x_asov_rec.comments = FND_API.G_MISS_CHAR THEN
1209: x_asov_rec.comments := l_db_asov_rec.comments;
1210: END IF;
1211:
1212: RETURN l_return_status;