APPS.OKL_ASS_PVT dependencies on FND_API

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 145: IF l_assv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN

141: END IF;
142: IF l_assv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
143: l_assv_rec.attribute15 := NULL;
144: END IF;
145: IF l_assv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN
146: l_assv_rec.parent_object_code := NULL;
147: END IF;
148: IF l_assv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
149: l_assv_rec.parent_object_id := NULL;

Line 148: IF l_assv_rec.parent_object_id = FND_API.G_MISS_NUM THEN

144: END IF;
145: IF l_assv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN
146: l_assv_rec.parent_object_code := NULL;
147: END IF;
148: IF l_assv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
149: l_assv_rec.parent_object_id := NULL;
150: END IF;
151: IF l_assv_rec.asset_number = FND_API.G_MISS_CHAR THEN
152: l_assv_rec.asset_number := NULL;

Line 151: IF l_assv_rec.asset_number = FND_API.G_MISS_CHAR THEN

147: END IF;
148: IF l_assv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
149: l_assv_rec.parent_object_id := NULL;
150: END IF;
151: IF l_assv_rec.asset_number = FND_API.G_MISS_CHAR THEN
152: l_assv_rec.asset_number := NULL;
153: END IF;
154: IF l_assv_rec.install_site_id = FND_API.G_MISS_NUM THEN
155: l_assv_rec.install_site_id := NULL;

Line 154: IF l_assv_rec.install_site_id = FND_API.G_MISS_NUM THEN

150: END IF;
151: IF l_assv_rec.asset_number = FND_API.G_MISS_CHAR THEN
152: l_assv_rec.asset_number := NULL;
153: END IF;
154: IF l_assv_rec.install_site_id = FND_API.G_MISS_NUM THEN
155: l_assv_rec.install_site_id := NULL;
156: END IF;
157: IF l_assv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN
158: l_assv_rec.structured_pricing := NULL;

Line 157: IF l_assv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN

153: END IF;
154: IF l_assv_rec.install_site_id = FND_API.G_MISS_NUM THEN
155: l_assv_rec.install_site_id := NULL;
156: END IF;
157: IF l_assv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN
158: l_assv_rec.structured_pricing := NULL;
159: END IF;
160: IF l_assv_rec.rate_template_id = FND_API.G_MISS_NUM THEN
161: l_assv_rec.rate_template_id := NULL;

Line 160: IF l_assv_rec.rate_template_id = FND_API.G_MISS_NUM THEN

156: END IF;
157: IF l_assv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN
158: l_assv_rec.structured_pricing := NULL;
159: END IF;
160: IF l_assv_rec.rate_template_id = FND_API.G_MISS_NUM THEN
161: l_assv_rec.rate_template_id := NULL;
162: END IF;
163: IF l_assv_rec.rate_card_id = FND_API.G_MISS_NUM THEN
164: l_assv_rec.rate_card_id := NULL;

Line 163: IF l_assv_rec.rate_card_id = FND_API.G_MISS_NUM THEN

159: END IF;
160: IF l_assv_rec.rate_template_id = FND_API.G_MISS_NUM THEN
161: l_assv_rec.rate_template_id := NULL;
162: END IF;
163: IF l_assv_rec.rate_card_id = FND_API.G_MISS_NUM THEN
164: l_assv_rec.rate_card_id := NULL;
165: END IF;
166: IF l_assv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
167: l_assv_rec.lease_rate_factor := NULL;

Line 166: IF l_assv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN

162: END IF;
163: IF l_assv_rec.rate_card_id = FND_API.G_MISS_NUM THEN
164: l_assv_rec.rate_card_id := NULL;
165: END IF;
166: IF l_assv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
167: l_assv_rec.lease_rate_factor := NULL;
168: END IF;
169: IF l_assv_rec.target_arrears = FND_API.G_MISS_CHAR THEN
170: l_assv_rec.target_arrears := NULL;

Line 169: IF l_assv_rec.target_arrears = FND_API.G_MISS_CHAR THEN

165: END IF;
166: IF l_assv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
167: l_assv_rec.lease_rate_factor := NULL;
168: END IF;
169: IF l_assv_rec.target_arrears = FND_API.G_MISS_CHAR THEN
170: l_assv_rec.target_arrears := NULL;
171: END IF;
172: IF l_assv_rec.oec = FND_API.G_MISS_NUM THEN
173: l_assv_rec.oec := NULL;

Line 172: IF l_assv_rec.oec = FND_API.G_MISS_NUM THEN

168: END IF;
169: IF l_assv_rec.target_arrears = FND_API.G_MISS_CHAR THEN
170: l_assv_rec.target_arrears := NULL;
171: END IF;
172: IF l_assv_rec.oec = FND_API.G_MISS_NUM THEN
173: l_assv_rec.oec := NULL;
174: END IF;
175: IF l_assv_rec.oec_percentage = FND_API.G_MISS_NUM THEN
176: l_assv_rec.oec_percentage := NULL;

Line 175: IF l_assv_rec.oec_percentage = FND_API.G_MISS_NUM THEN

171: END IF;
172: IF l_assv_rec.oec = FND_API.G_MISS_NUM THEN
173: l_assv_rec.oec := NULL;
174: END IF;
175: IF l_assv_rec.oec_percentage = FND_API.G_MISS_NUM THEN
176: l_assv_rec.oec_percentage := NULL;
177: END IF;
178: IF l_assv_rec.end_of_term_value_default = FND_API.G_MISS_NUM THEN
179: l_assv_rec.end_of_term_value_default := NULL;

Line 178: IF l_assv_rec.end_of_term_value_default = FND_API.G_MISS_NUM THEN

174: END IF;
175: IF l_assv_rec.oec_percentage = FND_API.G_MISS_NUM THEN
176: l_assv_rec.oec_percentage := NULL;
177: END IF;
178: IF l_assv_rec.end_of_term_value_default = FND_API.G_MISS_NUM THEN
179: l_assv_rec.end_of_term_value_default := NULL;
180: END IF;
181: IF l_assv_rec.end_of_term_value = FND_API.G_MISS_NUM THEN
182: l_assv_rec.end_of_term_value := NULL;

Line 181: IF l_assv_rec.end_of_term_value = FND_API.G_MISS_NUM THEN

177: END IF;
178: IF l_assv_rec.end_of_term_value_default = FND_API.G_MISS_NUM THEN
179: l_assv_rec.end_of_term_value_default := NULL;
180: END IF;
181: IF l_assv_rec.end_of_term_value = FND_API.G_MISS_NUM THEN
182: l_assv_rec.end_of_term_value := NULL;
183: END IF;
184: IF l_assv_rec.orig_asset_id = FND_API.G_MISS_NUM THEN
185: l_assv_rec.orig_asset_id := NULL;

Line 184: IF l_assv_rec.orig_asset_id = FND_API.G_MISS_NUM THEN

180: END IF;
181: IF l_assv_rec.end_of_term_value = FND_API.G_MISS_NUM THEN
182: l_assv_rec.end_of_term_value := NULL;
183: END IF;
184: IF l_assv_rec.orig_asset_id = FND_API.G_MISS_NUM THEN
185: l_assv_rec.orig_asset_id := NULL;
186: END IF;
187: IF l_assv_rec.target_amount = FND_API.G_MISS_NUM THEN
188: l_assv_rec.target_amount := NULL;

Line 187: IF l_assv_rec.target_amount = FND_API.G_MISS_NUM THEN

183: END IF;
184: IF l_assv_rec.orig_asset_id = FND_API.G_MISS_NUM THEN
185: l_assv_rec.orig_asset_id := NULL;
186: END IF;
187: IF l_assv_rec.target_amount = FND_API.G_MISS_NUM THEN
188: l_assv_rec.target_amount := NULL;
189: END IF;
190: IF l_assv_rec.target_frequency = FND_API.G_MISS_CHAR THEN
191: l_assv_rec.target_frequency := NULL;

Line 190: IF l_assv_rec.target_frequency = FND_API.G_MISS_CHAR THEN

186: END IF;
187: IF l_assv_rec.target_amount = FND_API.G_MISS_NUM THEN
188: l_assv_rec.target_amount := NULL;
189: END IF;
190: IF l_assv_rec.target_frequency = FND_API.G_MISS_CHAR THEN
191: l_assv_rec.target_frequency := NULL;
192: END IF;
193: IF l_assv_rec.short_description = FND_API.G_MISS_CHAR THEN
194: l_assv_rec.short_description := NULL;

Line 193: IF l_assv_rec.short_description = FND_API.G_MISS_CHAR THEN

189: END IF;
190: IF l_assv_rec.target_frequency = FND_API.G_MISS_CHAR THEN
191: l_assv_rec.target_frequency := NULL;
192: END IF;
193: IF l_assv_rec.short_description = FND_API.G_MISS_CHAR THEN
194: l_assv_rec.short_description := NULL;
195: END IF;
196: IF l_assv_rec.description = FND_API.G_MISS_CHAR THEN
197: l_assv_rec.description := NULL;

Line 196: IF l_assv_rec.description = FND_API.G_MISS_CHAR THEN

192: END IF;
193: IF l_assv_rec.short_description = FND_API.G_MISS_CHAR THEN
194: l_assv_rec.short_description := NULL;
195: END IF;
196: IF l_assv_rec.description = FND_API.G_MISS_CHAR THEN
197: l_assv_rec.description := NULL;
198: END IF;
199: IF l_assv_rec.comments = FND_API.G_MISS_CHAR THEN
200: l_assv_rec.comments := NULL;

Line 199: IF l_assv_rec.comments = FND_API.G_MISS_CHAR THEN

195: END IF;
196: IF l_assv_rec.description = FND_API.G_MISS_CHAR THEN
197: l_assv_rec.description := NULL;
198: END IF;
199: IF l_assv_rec.comments = FND_API.G_MISS_CHAR THEN
200: l_assv_rec.comments := NULL;
201: END IF;
202:
203: RETURN l_assv_rec;

Line 1226: IF x_assv_rec.attribute_category = FND_API.G_MISS_CHAR THEN

1222: ELSIF l_return_status = G_RET_STS_ERROR THEN
1223: RAISE OKL_API.G_EXCEPTION_ERROR;
1224: END IF;
1225:
1226: IF x_assv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1227: x_assv_rec.attribute_category := l_db_assv_rec.attribute_category;
1228: END IF;
1229: IF x_assv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1230: x_assv_rec.attribute1 := l_db_assv_rec.attribute1;

Line 1229: IF x_assv_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1225:
1226: IF x_assv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1227: x_assv_rec.attribute_category := l_db_assv_rec.attribute_category;
1228: END IF;
1229: IF x_assv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1230: x_assv_rec.attribute1 := l_db_assv_rec.attribute1;
1231: END IF;
1232: IF x_assv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1233: x_assv_rec.attribute2 := l_db_assv_rec.attribute2;

Line 1232: IF x_assv_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1228: END IF;
1229: IF x_assv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1230: x_assv_rec.attribute1 := l_db_assv_rec.attribute1;
1231: END IF;
1232: IF x_assv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1233: x_assv_rec.attribute2 := l_db_assv_rec.attribute2;
1234: END IF;
1235: IF x_assv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1236: x_assv_rec.attribute3 := l_db_assv_rec.attribute3;

Line 1235: IF x_assv_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1231: END IF;
1232: IF x_assv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1233: x_assv_rec.attribute2 := l_db_assv_rec.attribute2;
1234: END IF;
1235: IF x_assv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1236: x_assv_rec.attribute3 := l_db_assv_rec.attribute3;
1237: END IF;
1238: IF x_assv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1239: x_assv_rec.attribute4 := l_db_assv_rec.attribute4;

Line 1238: IF x_assv_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1234: END IF;
1235: IF x_assv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1236: x_assv_rec.attribute3 := l_db_assv_rec.attribute3;
1237: END IF;
1238: IF x_assv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1239: x_assv_rec.attribute4 := l_db_assv_rec.attribute4;
1240: END IF;
1241: IF x_assv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1242: x_assv_rec.attribute5 := l_db_assv_rec.attribute5;

Line 1241: IF x_assv_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1237: END IF;
1238: IF x_assv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1239: x_assv_rec.attribute4 := l_db_assv_rec.attribute4;
1240: END IF;
1241: IF x_assv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1242: x_assv_rec.attribute5 := l_db_assv_rec.attribute5;
1243: END IF;
1244: IF x_assv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1245: x_assv_rec.attribute6 := l_db_assv_rec.attribute6;

Line 1244: IF x_assv_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1240: END IF;
1241: IF x_assv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1242: x_assv_rec.attribute5 := l_db_assv_rec.attribute5;
1243: END IF;
1244: IF x_assv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1245: x_assv_rec.attribute6 := l_db_assv_rec.attribute6;
1246: END IF;
1247: IF x_assv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1248: x_assv_rec.attribute7 := l_db_assv_rec.attribute7;

Line 1247: IF x_assv_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1243: END IF;
1244: IF x_assv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1245: x_assv_rec.attribute6 := l_db_assv_rec.attribute6;
1246: END IF;
1247: IF x_assv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1248: x_assv_rec.attribute7 := l_db_assv_rec.attribute7;
1249: END IF;
1250: IF x_assv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1251: x_assv_rec.attribute8 := l_db_assv_rec.attribute8;

Line 1250: IF x_assv_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1246: END IF;
1247: IF x_assv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1248: x_assv_rec.attribute7 := l_db_assv_rec.attribute7;
1249: END IF;
1250: IF x_assv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1251: x_assv_rec.attribute8 := l_db_assv_rec.attribute8;
1252: END IF;
1253: IF x_assv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1254: x_assv_rec.attribute9 := l_db_assv_rec.attribute9;

Line 1253: IF x_assv_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1249: END IF;
1250: IF x_assv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1251: x_assv_rec.attribute8 := l_db_assv_rec.attribute8;
1252: END IF;
1253: IF x_assv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1254: x_assv_rec.attribute9 := l_db_assv_rec.attribute9;
1255: END IF;
1256: IF x_assv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1257: x_assv_rec.attribute10 := l_db_assv_rec.attribute10;

Line 1256: IF x_assv_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1252: END IF;
1253: IF x_assv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1254: x_assv_rec.attribute9 := l_db_assv_rec.attribute9;
1255: END IF;
1256: IF x_assv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1257: x_assv_rec.attribute10 := l_db_assv_rec.attribute10;
1258: END IF;
1259: IF x_assv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1260: x_assv_rec.attribute11 := l_db_assv_rec.attribute11;

Line 1259: IF x_assv_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1255: END IF;
1256: IF x_assv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1257: x_assv_rec.attribute10 := l_db_assv_rec.attribute10;
1258: END IF;
1259: IF x_assv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1260: x_assv_rec.attribute11 := l_db_assv_rec.attribute11;
1261: END IF;
1262: IF x_assv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1263: x_assv_rec.attribute12 := l_db_assv_rec.attribute12;

Line 1262: IF x_assv_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1258: END IF;
1259: IF x_assv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1260: x_assv_rec.attribute11 := l_db_assv_rec.attribute11;
1261: END IF;
1262: IF x_assv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1263: x_assv_rec.attribute12 := l_db_assv_rec.attribute12;
1264: END IF;
1265: IF x_assv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1266: x_assv_rec.attribute13 := l_db_assv_rec.attribute13;

Line 1265: IF x_assv_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1261: END IF;
1262: IF x_assv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1263: x_assv_rec.attribute12 := l_db_assv_rec.attribute12;
1264: END IF;
1265: IF x_assv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1266: x_assv_rec.attribute13 := l_db_assv_rec.attribute13;
1267: END IF;
1268: IF x_assv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1269: x_assv_rec.attribute14 := l_db_assv_rec.attribute14;

Line 1268: IF x_assv_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1264: END IF;
1265: IF x_assv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1266: x_assv_rec.attribute13 := l_db_assv_rec.attribute13;
1267: END IF;
1268: IF x_assv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1269: x_assv_rec.attribute14 := l_db_assv_rec.attribute14;
1270: END IF;
1271: IF x_assv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1272: x_assv_rec.attribute15 := l_db_assv_rec.attribute15;

Line 1271: IF x_assv_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1267: END IF;
1268: IF x_assv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1269: x_assv_rec.attribute14 := l_db_assv_rec.attribute14;
1270: END IF;
1271: IF x_assv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1272: x_assv_rec.attribute15 := l_db_assv_rec.attribute15;
1273: END IF;
1274: IF x_assv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN
1275: x_assv_rec.parent_object_code := l_db_assv_rec.parent_object_code;

Line 1274: IF x_assv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN

1270: END IF;
1271: IF x_assv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1272: x_assv_rec.attribute15 := l_db_assv_rec.attribute15;
1273: END IF;
1274: IF x_assv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN
1275: x_assv_rec.parent_object_code := l_db_assv_rec.parent_object_code;
1276: END IF;
1277: IF x_assv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
1278: x_assv_rec.parent_object_id := l_db_assv_rec.parent_object_id;

Line 1277: IF x_assv_rec.parent_object_id = FND_API.G_MISS_NUM THEN

1273: END IF;
1274: IF x_assv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN
1275: x_assv_rec.parent_object_code := l_db_assv_rec.parent_object_code;
1276: END IF;
1277: IF x_assv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
1278: x_assv_rec.parent_object_id := l_db_assv_rec.parent_object_id;
1279: END IF;
1280: IF x_assv_rec.asset_number = FND_API.G_MISS_CHAR THEN
1281: x_assv_rec.asset_number := l_db_assv_rec.asset_number;

Line 1280: IF x_assv_rec.asset_number = FND_API.G_MISS_CHAR THEN

1276: END IF;
1277: IF x_assv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
1278: x_assv_rec.parent_object_id := l_db_assv_rec.parent_object_id;
1279: END IF;
1280: IF x_assv_rec.asset_number = FND_API.G_MISS_CHAR THEN
1281: x_assv_rec.asset_number := l_db_assv_rec.asset_number;
1282: END IF;
1283: IF x_assv_rec.install_site_id = FND_API.G_MISS_NUM THEN
1284: x_assv_rec.install_site_id := l_db_assv_rec.install_site_id;

Line 1283: IF x_assv_rec.install_site_id = FND_API.G_MISS_NUM THEN

1279: END IF;
1280: IF x_assv_rec.asset_number = FND_API.G_MISS_CHAR THEN
1281: x_assv_rec.asset_number := l_db_assv_rec.asset_number;
1282: END IF;
1283: IF x_assv_rec.install_site_id = FND_API.G_MISS_NUM THEN
1284: x_assv_rec.install_site_id := l_db_assv_rec.install_site_id;
1285: END IF;
1286: IF x_assv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN
1287: x_assv_rec.structured_pricing := l_db_assv_rec.structured_pricing;

Line 1286: IF x_assv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN

1282: END IF;
1283: IF x_assv_rec.install_site_id = FND_API.G_MISS_NUM THEN
1284: x_assv_rec.install_site_id := l_db_assv_rec.install_site_id;
1285: END IF;
1286: IF x_assv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN
1287: x_assv_rec.structured_pricing := l_db_assv_rec.structured_pricing;
1288: END IF;
1289: IF x_assv_rec.rate_template_id = FND_API.G_MISS_NUM THEN
1290: x_assv_rec.rate_template_id := l_db_assv_rec.rate_template_id;

Line 1289: IF x_assv_rec.rate_template_id = FND_API.G_MISS_NUM THEN

1285: END IF;
1286: IF x_assv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN
1287: x_assv_rec.structured_pricing := l_db_assv_rec.structured_pricing;
1288: END IF;
1289: IF x_assv_rec.rate_template_id = FND_API.G_MISS_NUM THEN
1290: x_assv_rec.rate_template_id := l_db_assv_rec.rate_template_id;
1291: END IF;
1292: IF x_assv_rec.rate_card_id = FND_API.G_MISS_NUM THEN
1293: x_assv_rec.rate_card_id := l_db_assv_rec.rate_card_id;

Line 1292: IF x_assv_rec.rate_card_id = FND_API.G_MISS_NUM THEN

1288: END IF;
1289: IF x_assv_rec.rate_template_id = FND_API.G_MISS_NUM THEN
1290: x_assv_rec.rate_template_id := l_db_assv_rec.rate_template_id;
1291: END IF;
1292: IF x_assv_rec.rate_card_id = FND_API.G_MISS_NUM THEN
1293: x_assv_rec.rate_card_id := l_db_assv_rec.rate_card_id;
1294: END IF;
1295: IF x_assv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
1296: x_assv_rec.lease_rate_factor := l_db_assv_rec.lease_rate_factor;

Line 1295: IF x_assv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN

1291: END IF;
1292: IF x_assv_rec.rate_card_id = FND_API.G_MISS_NUM THEN
1293: x_assv_rec.rate_card_id := l_db_assv_rec.rate_card_id;
1294: END IF;
1295: IF x_assv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
1296: x_assv_rec.lease_rate_factor := l_db_assv_rec.lease_rate_factor;
1297: END IF;
1298: IF x_assv_rec.target_arrears = FND_API.G_MISS_CHAR THEN
1299: x_assv_rec.target_arrears := l_db_assv_rec.target_arrears;

Line 1298: IF x_assv_rec.target_arrears = FND_API.G_MISS_CHAR THEN

1294: END IF;
1295: IF x_assv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
1296: x_assv_rec.lease_rate_factor := l_db_assv_rec.lease_rate_factor;
1297: END IF;
1298: IF x_assv_rec.target_arrears = FND_API.G_MISS_CHAR THEN
1299: x_assv_rec.target_arrears := l_db_assv_rec.target_arrears;
1300: END IF;
1301: IF x_assv_rec.oec = FND_API.G_MISS_NUM THEN
1302: x_assv_rec.oec := l_db_assv_rec.oec;

Line 1301: IF x_assv_rec.oec = FND_API.G_MISS_NUM THEN

1297: END IF;
1298: IF x_assv_rec.target_arrears = FND_API.G_MISS_CHAR THEN
1299: x_assv_rec.target_arrears := l_db_assv_rec.target_arrears;
1300: END IF;
1301: IF x_assv_rec.oec = FND_API.G_MISS_NUM THEN
1302: x_assv_rec.oec := l_db_assv_rec.oec;
1303: END IF;
1304: IF x_assv_rec.oec_percentage = FND_API.G_MISS_NUM THEN
1305: x_assv_rec.oec_percentage := l_db_assv_rec.oec_percentage;

Line 1304: IF x_assv_rec.oec_percentage = FND_API.G_MISS_NUM THEN

1300: END IF;
1301: IF x_assv_rec.oec = FND_API.G_MISS_NUM THEN
1302: x_assv_rec.oec := l_db_assv_rec.oec;
1303: END IF;
1304: IF x_assv_rec.oec_percentage = FND_API.G_MISS_NUM THEN
1305: x_assv_rec.oec_percentage := l_db_assv_rec.oec_percentage;
1306: END IF;
1307: IF x_assv_rec.end_of_term_value_default = FND_API.G_MISS_NUM THEN
1308: x_assv_rec.end_of_term_value_default := l_db_assv_rec.end_of_term_value_default;

Line 1307: IF x_assv_rec.end_of_term_value_default = FND_API.G_MISS_NUM THEN

1303: END IF;
1304: IF x_assv_rec.oec_percentage = FND_API.G_MISS_NUM THEN
1305: x_assv_rec.oec_percentage := l_db_assv_rec.oec_percentage;
1306: END IF;
1307: IF x_assv_rec.end_of_term_value_default = FND_API.G_MISS_NUM THEN
1308: x_assv_rec.end_of_term_value_default := l_db_assv_rec.end_of_term_value_default;
1309: END IF;
1310: IF x_assv_rec.end_of_term_value = FND_API.G_MISS_NUM THEN
1311: x_assv_rec.end_of_term_value := l_db_assv_rec.end_of_term_value;

Line 1310: IF x_assv_rec.end_of_term_value = FND_API.G_MISS_NUM THEN

1306: END IF;
1307: IF x_assv_rec.end_of_term_value_default = FND_API.G_MISS_NUM THEN
1308: x_assv_rec.end_of_term_value_default := l_db_assv_rec.end_of_term_value_default;
1309: END IF;
1310: IF x_assv_rec.end_of_term_value = FND_API.G_MISS_NUM THEN
1311: x_assv_rec.end_of_term_value := l_db_assv_rec.end_of_term_value;
1312: END IF;
1313: IF x_assv_rec.orig_asset_id = FND_API.G_MISS_NUM THEN
1314: x_assv_rec.orig_asset_id := l_db_assv_rec.orig_asset_id;

Line 1313: IF x_assv_rec.orig_asset_id = FND_API.G_MISS_NUM THEN

1309: END IF;
1310: IF x_assv_rec.end_of_term_value = FND_API.G_MISS_NUM THEN
1311: x_assv_rec.end_of_term_value := l_db_assv_rec.end_of_term_value;
1312: END IF;
1313: IF x_assv_rec.orig_asset_id = FND_API.G_MISS_NUM THEN
1314: x_assv_rec.orig_asset_id := l_db_assv_rec.orig_asset_id;
1315: END IF;
1316: IF x_assv_rec.target_amount = FND_API.G_MISS_NUM THEN
1317: x_assv_rec.target_amount := l_db_assv_rec.target_amount;

Line 1316: IF x_assv_rec.target_amount = FND_API.G_MISS_NUM THEN

1312: END IF;
1313: IF x_assv_rec.orig_asset_id = FND_API.G_MISS_NUM THEN
1314: x_assv_rec.orig_asset_id := l_db_assv_rec.orig_asset_id;
1315: END IF;
1316: IF x_assv_rec.target_amount = FND_API.G_MISS_NUM THEN
1317: x_assv_rec.target_amount := l_db_assv_rec.target_amount;
1318: END IF;
1319: IF x_assv_rec.target_frequency = FND_API.G_MISS_CHAR THEN
1320: x_assv_rec.target_frequency := l_db_assv_rec.target_frequency;

Line 1319: IF x_assv_rec.target_frequency = FND_API.G_MISS_CHAR THEN

1315: END IF;
1316: IF x_assv_rec.target_amount = FND_API.G_MISS_NUM THEN
1317: x_assv_rec.target_amount := l_db_assv_rec.target_amount;
1318: END IF;
1319: IF x_assv_rec.target_frequency = FND_API.G_MISS_CHAR THEN
1320: x_assv_rec.target_frequency := l_db_assv_rec.target_frequency;
1321: END IF;
1322: IF x_assv_rec.short_description = FND_API.G_MISS_CHAR THEN
1323: x_assv_rec.short_description := l_db_assv_rec.short_description;

Line 1322: IF x_assv_rec.short_description = FND_API.G_MISS_CHAR THEN

1318: END IF;
1319: IF x_assv_rec.target_frequency = FND_API.G_MISS_CHAR THEN
1320: x_assv_rec.target_frequency := l_db_assv_rec.target_frequency;
1321: END IF;
1322: IF x_assv_rec.short_description = FND_API.G_MISS_CHAR THEN
1323: x_assv_rec.short_description := l_db_assv_rec.short_description;
1324: END IF;
1325: IF x_assv_rec.description = FND_API.G_MISS_CHAR THEN
1326: x_assv_rec.description := l_db_assv_rec.description;

Line 1325: IF x_assv_rec.description = FND_API.G_MISS_CHAR THEN

1321: END IF;
1322: IF x_assv_rec.short_description = FND_API.G_MISS_CHAR THEN
1323: x_assv_rec.short_description := l_db_assv_rec.short_description;
1324: END IF;
1325: IF x_assv_rec.description = FND_API.G_MISS_CHAR THEN
1326: x_assv_rec.description := l_db_assv_rec.description;
1327: END IF;
1328: IF x_assv_rec.comments = FND_API.G_MISS_CHAR THEN
1329: x_assv_rec.comments := l_db_assv_rec.comments;

Line 1328: IF x_assv_rec.comments = FND_API.G_MISS_CHAR THEN

1324: END IF;
1325: IF x_assv_rec.description = FND_API.G_MISS_CHAR THEN
1326: x_assv_rec.description := l_db_assv_rec.description;
1327: END IF;
1328: IF x_assv_rec.comments = FND_API.G_MISS_CHAR THEN
1329: x_assv_rec.comments := l_db_assv_rec.comments;
1330: END IF;
1331:
1332: RETURN l_return_status;