82: l_lapv_rec := p_lapv_rec;
83:
84: -- Not applicable to ID and OBJECT_VERSION_NUMBER
85:
86: IF l_lapv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
87: l_lapv_rec.attribute_category := NULL;
88: END IF;
89: IF l_lapv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
90: l_lapv_rec.attribute1 := NULL;
85:
86: IF l_lapv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
87: l_lapv_rec.attribute_category := NULL;
88: END IF;
89: IF l_lapv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
90: l_lapv_rec.attribute1 := NULL;
91: END IF;
92: IF l_lapv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
93: l_lapv_rec.attribute2 := NULL;
88: END IF;
89: IF l_lapv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
90: l_lapv_rec.attribute1 := NULL;
91: END IF;
92: IF l_lapv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
93: l_lapv_rec.attribute2 := NULL;
94: END IF;
95: IF l_lapv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
96: l_lapv_rec.attribute3 := NULL;
91: END IF;
92: IF l_lapv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
93: l_lapv_rec.attribute2 := NULL;
94: END IF;
95: IF l_lapv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
96: l_lapv_rec.attribute3 := NULL;
97: END IF;
98: IF l_lapv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
99: l_lapv_rec.attribute4 := NULL;
94: END IF;
95: IF l_lapv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
96: l_lapv_rec.attribute3 := NULL;
97: END IF;
98: IF l_lapv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
99: l_lapv_rec.attribute4 := NULL;
100: END IF;
101: IF l_lapv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
102: l_lapv_rec.attribute5 := NULL;
97: END IF;
98: IF l_lapv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
99: l_lapv_rec.attribute4 := NULL;
100: END IF;
101: IF l_lapv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
102: l_lapv_rec.attribute5 := NULL;
103: END IF;
104: IF l_lapv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
105: l_lapv_rec.attribute6 := NULL;
100: END IF;
101: IF l_lapv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
102: l_lapv_rec.attribute5 := NULL;
103: END IF;
104: IF l_lapv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
105: l_lapv_rec.attribute6 := NULL;
106: END IF;
107: IF l_lapv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
108: l_lapv_rec.attribute7 := NULL;
103: END IF;
104: IF l_lapv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
105: l_lapv_rec.attribute6 := NULL;
106: END IF;
107: IF l_lapv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
108: l_lapv_rec.attribute7 := NULL;
109: END IF;
110: IF l_lapv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
111: l_lapv_rec.attribute8 := NULL;
106: END IF;
107: IF l_lapv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
108: l_lapv_rec.attribute7 := NULL;
109: END IF;
110: IF l_lapv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
111: l_lapv_rec.attribute8 := NULL;
112: END IF;
113: IF l_lapv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
114: l_lapv_rec.attribute9 := NULL;
109: END IF;
110: IF l_lapv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
111: l_lapv_rec.attribute8 := NULL;
112: END IF;
113: IF l_lapv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
114: l_lapv_rec.attribute9 := NULL;
115: END IF;
116: IF l_lapv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
117: l_lapv_rec.attribute10 := NULL;
112: END IF;
113: IF l_lapv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
114: l_lapv_rec.attribute9 := NULL;
115: END IF;
116: IF l_lapv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
117: l_lapv_rec.attribute10 := NULL;
118: END IF;
119: IF l_lapv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
120: l_lapv_rec.attribute11 := NULL;
115: END IF;
116: IF l_lapv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
117: l_lapv_rec.attribute10 := NULL;
118: END IF;
119: IF l_lapv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
120: l_lapv_rec.attribute11 := NULL;
121: END IF;
122: IF l_lapv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
123: l_lapv_rec.attribute12 := NULL;
118: END IF;
119: IF l_lapv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
120: l_lapv_rec.attribute11 := NULL;
121: END IF;
122: IF l_lapv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
123: l_lapv_rec.attribute12 := NULL;
124: END IF;
125: IF l_lapv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
126: l_lapv_rec.attribute13 := NULL;
121: END IF;
122: IF l_lapv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
123: l_lapv_rec.attribute12 := NULL;
124: END IF;
125: IF l_lapv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
126: l_lapv_rec.attribute13 := NULL;
127: END IF;
128: IF l_lapv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
129: l_lapv_rec.attribute14 := NULL;
124: END IF;
125: IF l_lapv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
126: l_lapv_rec.attribute13 := NULL;
127: END IF;
128: IF l_lapv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
129: l_lapv_rec.attribute14 := NULL;
130: END IF;
131: IF l_lapv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
132: l_lapv_rec.attribute15 := NULL;
127: END IF;
128: IF l_lapv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
129: l_lapv_rec.attribute14 := NULL;
130: END IF;
131: IF l_lapv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
132: l_lapv_rec.attribute15 := NULL;
133: END IF;
134: IF l_lapv_rec.reference_number = FND_API.G_MISS_CHAR THEN
135: l_lapv_rec.reference_number := NULL;
130: END IF;
131: IF l_lapv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
132: l_lapv_rec.attribute15 := NULL;
133: END IF;
134: IF l_lapv_rec.reference_number = FND_API.G_MISS_CHAR THEN
135: l_lapv_rec.reference_number := NULL;
136: END IF;
137: IF l_lapv_rec.application_status = FND_API.G_MISS_CHAR THEN
138: l_lapv_rec.application_status := NULL;
133: END IF;
134: IF l_lapv_rec.reference_number = FND_API.G_MISS_CHAR THEN
135: l_lapv_rec.reference_number := NULL;
136: END IF;
137: IF l_lapv_rec.application_status = FND_API.G_MISS_CHAR THEN
138: l_lapv_rec.application_status := NULL;
139: END IF;
140: IF l_lapv_rec.valid_from = FND_API.G_MISS_DATE THEN
141: l_lapv_rec.valid_from := NULL;
136: END IF;
137: IF l_lapv_rec.application_status = FND_API.G_MISS_CHAR THEN
138: l_lapv_rec.application_status := NULL;
139: END IF;
140: IF l_lapv_rec.valid_from = FND_API.G_MISS_DATE THEN
141: l_lapv_rec.valid_from := NULL;
142: END IF;
143: IF l_lapv_rec.valid_to = FND_API.G_MISS_DATE THEN
144: l_lapv_rec.valid_to := NULL;
139: END IF;
140: IF l_lapv_rec.valid_from = FND_API.G_MISS_DATE THEN
141: l_lapv_rec.valid_from := NULL;
142: END IF;
143: IF l_lapv_rec.valid_to = FND_API.G_MISS_DATE THEN
144: l_lapv_rec.valid_to := NULL;
145: END IF;
146: IF l_lapv_rec.org_id = FND_API.G_MISS_NUM THEN
147: l_lapv_rec.org_id := NULL;
142: END IF;
143: IF l_lapv_rec.valid_to = FND_API.G_MISS_DATE THEN
144: l_lapv_rec.valid_to := NULL;
145: END IF;
146: IF l_lapv_rec.org_id = FND_API.G_MISS_NUM THEN
147: l_lapv_rec.org_id := NULL;
148: END IF;
149: IF l_lapv_rec.inv_org_id = FND_API.G_MISS_NUM THEN
150: l_lapv_rec.inv_org_id := NULL;
145: END IF;
146: IF l_lapv_rec.org_id = FND_API.G_MISS_NUM THEN
147: l_lapv_rec.org_id := NULL;
148: END IF;
149: IF l_lapv_rec.inv_org_id = FND_API.G_MISS_NUM THEN
150: l_lapv_rec.inv_org_id := NULL;
151: END IF;
152: IF l_lapv_rec.prospect_id = FND_API.G_MISS_NUM THEN
153: l_lapv_rec.prospect_id := NULL;
148: END IF;
149: IF l_lapv_rec.inv_org_id = FND_API.G_MISS_NUM THEN
150: l_lapv_rec.inv_org_id := NULL;
151: END IF;
152: IF l_lapv_rec.prospect_id = FND_API.G_MISS_NUM THEN
153: l_lapv_rec.prospect_id := NULL;
154: END IF;
155: IF l_lapv_rec.prospect_address_id = FND_API.G_MISS_NUM THEN
156: l_lapv_rec.prospect_address_id := NULL;
151: END IF;
152: IF l_lapv_rec.prospect_id = FND_API.G_MISS_NUM THEN
153: l_lapv_rec.prospect_id := NULL;
154: END IF;
155: IF l_lapv_rec.prospect_address_id = FND_API.G_MISS_NUM THEN
156: l_lapv_rec.prospect_address_id := NULL;
157: END IF;
158: IF l_lapv_rec.cust_acct_id = FND_API.G_MISS_NUM THEN
159: l_lapv_rec.cust_acct_id := NULL;
154: END IF;
155: IF l_lapv_rec.prospect_address_id = FND_API.G_MISS_NUM THEN
156: l_lapv_rec.prospect_address_id := NULL;
157: END IF;
158: IF l_lapv_rec.cust_acct_id = FND_API.G_MISS_NUM THEN
159: l_lapv_rec.cust_acct_id := NULL;
160: END IF;
161: IF l_lapv_rec.industry_class = FND_API.G_MISS_CHAR THEN
162: l_lapv_rec.industry_class := NULL;
157: END IF;
158: IF l_lapv_rec.cust_acct_id = FND_API.G_MISS_NUM THEN
159: l_lapv_rec.cust_acct_id := NULL;
160: END IF;
161: IF l_lapv_rec.industry_class = FND_API.G_MISS_CHAR THEN
162: l_lapv_rec.industry_class := NULL;
163: END IF;
164: IF l_lapv_rec.industry_code = FND_API.G_MISS_CHAR THEN
165: l_lapv_rec.industry_code := NULL;
160: END IF;
161: IF l_lapv_rec.industry_class = FND_API.G_MISS_CHAR THEN
162: l_lapv_rec.industry_class := NULL;
163: END IF;
164: IF l_lapv_rec.industry_code = FND_API.G_MISS_CHAR THEN
165: l_lapv_rec.industry_code := NULL;
166: END IF;
167: IF l_lapv_rec.currency_code = FND_API.G_MISS_CHAR THEN
168: l_lapv_rec.currency_code := NULL;
163: END IF;
164: IF l_lapv_rec.industry_code = FND_API.G_MISS_CHAR THEN
165: l_lapv_rec.industry_code := NULL;
166: END IF;
167: IF l_lapv_rec.currency_code = FND_API.G_MISS_CHAR THEN
168: l_lapv_rec.currency_code := NULL;
169: END IF;
170: IF l_lapv_rec.currency_conversion_type = FND_API.G_MISS_CHAR THEN
171: l_lapv_rec.currency_conversion_type := NULL;
166: END IF;
167: IF l_lapv_rec.currency_code = FND_API.G_MISS_CHAR THEN
168: l_lapv_rec.currency_code := NULL;
169: END IF;
170: IF l_lapv_rec.currency_conversion_type = FND_API.G_MISS_CHAR THEN
171: l_lapv_rec.currency_conversion_type := NULL;
172: END IF;
173: IF l_lapv_rec.currency_conversion_rate = FND_API.G_MISS_NUM THEN
174: l_lapv_rec.currency_conversion_rate := NULL;
169: END IF;
170: IF l_lapv_rec.currency_conversion_type = FND_API.G_MISS_CHAR THEN
171: l_lapv_rec.currency_conversion_type := NULL;
172: END IF;
173: IF l_lapv_rec.currency_conversion_rate = FND_API.G_MISS_NUM THEN
174: l_lapv_rec.currency_conversion_rate := NULL;
175: END IF;
176: IF l_lapv_rec.currency_conversion_date = FND_API.G_MISS_DATE THEN
177: l_lapv_rec.currency_conversion_date := NULL;
172: END IF;
173: IF l_lapv_rec.currency_conversion_rate = FND_API.G_MISS_NUM THEN
174: l_lapv_rec.currency_conversion_rate := NULL;
175: END IF;
176: IF l_lapv_rec.currency_conversion_date = FND_API.G_MISS_DATE THEN
177: l_lapv_rec.currency_conversion_date := NULL;
178: END IF;
179: IF l_lapv_rec.leaseapp_template_id = FND_API.G_MISS_NUM THEN
180: l_lapv_rec.leaseapp_template_id := NULL;
175: END IF;
176: IF l_lapv_rec.currency_conversion_date = FND_API.G_MISS_DATE THEN
177: l_lapv_rec.currency_conversion_date := NULL;
178: END IF;
179: IF l_lapv_rec.leaseapp_template_id = FND_API.G_MISS_NUM THEN
180: l_lapv_rec.leaseapp_template_id := NULL;
181: END IF;
182: IF l_lapv_rec.parent_leaseapp_id = FND_API.G_MISS_NUM THEN
183: l_lapv_rec.parent_leaseapp_id := NULL;
178: END IF;
179: IF l_lapv_rec.leaseapp_template_id = FND_API.G_MISS_NUM THEN
180: l_lapv_rec.leaseapp_template_id := NULL;
181: END IF;
182: IF l_lapv_rec.parent_leaseapp_id = FND_API.G_MISS_NUM THEN
183: l_lapv_rec.parent_leaseapp_id := NULL;
184: END IF;
185: IF l_lapv_rec.credit_line_id = FND_API.G_MISS_NUM THEN
186: l_lapv_rec.credit_line_id := NULL;
181: END IF;
182: IF l_lapv_rec.parent_leaseapp_id = FND_API.G_MISS_NUM THEN
183: l_lapv_rec.parent_leaseapp_id := NULL;
184: END IF;
185: IF l_lapv_rec.credit_line_id = FND_API.G_MISS_NUM THEN
186: l_lapv_rec.credit_line_id := NULL;
187: END IF;
188: IF l_lapv_rec.program_agreement_id = FND_API.G_MISS_NUM THEN
189: l_lapv_rec.program_agreement_id := NULL;
184: END IF;
185: IF l_lapv_rec.credit_line_id = FND_API.G_MISS_NUM THEN
186: l_lapv_rec.credit_line_id := NULL;
187: END IF;
188: IF l_lapv_rec.program_agreement_id = FND_API.G_MISS_NUM THEN
189: l_lapv_rec.program_agreement_id := NULL;
190: END IF;
191: IF l_lapv_rec.master_lease_id = FND_API.G_MISS_NUM THEN
192: l_lapv_rec.master_lease_id := NULL;
187: END IF;
188: IF l_lapv_rec.program_agreement_id = FND_API.G_MISS_NUM THEN
189: l_lapv_rec.program_agreement_id := NULL;
190: END IF;
191: IF l_lapv_rec.master_lease_id = FND_API.G_MISS_NUM THEN
192: l_lapv_rec.master_lease_id := NULL;
193: END IF;
194: IF l_lapv_rec.sales_rep_id = FND_API.G_MISS_NUM THEN
195: l_lapv_rec.sales_rep_id := NULL;
190: END IF;
191: IF l_lapv_rec.master_lease_id = FND_API.G_MISS_NUM THEN
192: l_lapv_rec.master_lease_id := NULL;
193: END IF;
194: IF l_lapv_rec.sales_rep_id = FND_API.G_MISS_NUM THEN
195: l_lapv_rec.sales_rep_id := NULL;
196: END IF;
197: IF l_lapv_rec.sales_territory_id = FND_API.G_MISS_NUM THEN
198: l_lapv_rec.sales_territory_id := NULL;
193: END IF;
194: IF l_lapv_rec.sales_rep_id = FND_API.G_MISS_NUM THEN
195: l_lapv_rec.sales_rep_id := NULL;
196: END IF;
197: IF l_lapv_rec.sales_territory_id = FND_API.G_MISS_NUM THEN
198: l_lapv_rec.sales_territory_id := NULL;
199: END IF;
200: IF l_lapv_rec.originating_vendor_id = FND_API.G_MISS_NUM THEN
201: l_lapv_rec.originating_vendor_id := NULL;
196: END IF;
197: IF l_lapv_rec.sales_territory_id = FND_API.G_MISS_NUM THEN
198: l_lapv_rec.sales_territory_id := NULL;
199: END IF;
200: IF l_lapv_rec.originating_vendor_id = FND_API.G_MISS_NUM THEN
201: l_lapv_rec.originating_vendor_id := NULL;
202: END IF;
203: IF l_lapv_rec.lease_opportunity_id = FND_API.G_MISS_NUM THEN
204: l_lapv_rec.lease_opportunity_id := NULL;
199: END IF;
200: IF l_lapv_rec.originating_vendor_id = FND_API.G_MISS_NUM THEN
201: l_lapv_rec.originating_vendor_id := NULL;
202: END IF;
203: IF l_lapv_rec.lease_opportunity_id = FND_API.G_MISS_NUM THEN
204: l_lapv_rec.lease_opportunity_id := NULL;
205: END IF;
206: IF l_lapv_rec.short_description = FND_API.G_MISS_CHAR THEN
207: l_lapv_rec.short_description := NULL;
202: END IF;
203: IF l_lapv_rec.lease_opportunity_id = FND_API.G_MISS_NUM THEN
204: l_lapv_rec.lease_opportunity_id := NULL;
205: END IF;
206: IF l_lapv_rec.short_description = FND_API.G_MISS_CHAR THEN
207: l_lapv_rec.short_description := NULL;
208: END IF;
209: IF l_lapv_rec.comments = FND_API.G_MISS_CHAR THEN
210: l_lapv_rec.comments := NULL;
205: END IF;
206: IF l_lapv_rec.short_description = FND_API.G_MISS_CHAR THEN
207: l_lapv_rec.short_description := NULL;
208: END IF;
209: IF l_lapv_rec.comments = FND_API.G_MISS_CHAR THEN
210: l_lapv_rec.comments := NULL;
211: END IF;
212: --VARANGAN for bug#4747179
213: IF l_lapv_rec.cr_exp_days = FND_API.G_MISS_NUM THEN
209: IF l_lapv_rec.comments = FND_API.G_MISS_CHAR THEN
210: l_lapv_rec.comments := NULL;
211: END IF;
212: --VARANGAN for bug#4747179
213: IF l_lapv_rec.cr_exp_days = FND_API.G_MISS_NUM THEN
214: l_lapv_rec.cr_exp_days := NULL;
215: END IF;
216: --VARANGAN for bug#4747179
217: --Bug 4872271 PAGARG start
214: l_lapv_rec.cr_exp_days := NULL;
215: END IF;
216: --VARANGAN for bug#4747179
217: --Bug 4872271 PAGARG start
218: IF l_lapv_rec.action = FND_API.G_MISS_CHAR THEN
219: l_lapv_rec.action := NULL;
220: END IF;
221: IF l_lapv_rec.orig_status = FND_API.G_MISS_CHAR THEN
222: l_lapv_rec.orig_status := NULL;
217: --Bug 4872271 PAGARG start
218: IF l_lapv_rec.action = FND_API.G_MISS_CHAR THEN
219: l_lapv_rec.action := NULL;
220: END IF;
221: IF l_lapv_rec.orig_status = FND_API.G_MISS_CHAR THEN
222: l_lapv_rec.orig_status := NULL;
223: END IF;
224: --Bug 4872271 PAGARG end
225: RETURN l_lapv_rec;