APPS.OKL_LSQ_PVT dependencies on FND_API

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 145: IF l_lsqv_rec.reference_number = FND_API.G_MISS_CHAR THEN

141: END IF;
142: IF l_lsqv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
143: l_lsqv_rec.attribute15 := NULL;
144: END IF;
145: IF l_lsqv_rec.reference_number = FND_API.G_MISS_CHAR THEN
146: l_lsqv_rec.reference_number := NULL;
147: END IF;
148: IF l_lsqv_rec.status = FND_API.G_MISS_CHAR THEN
149: l_lsqv_rec.status := NULL;

Line 148: IF l_lsqv_rec.status = FND_API.G_MISS_CHAR THEN

144: END IF;
145: IF l_lsqv_rec.reference_number = FND_API.G_MISS_CHAR THEN
146: l_lsqv_rec.reference_number := NULL;
147: END IF;
148: IF l_lsqv_rec.status = FND_API.G_MISS_CHAR THEN
149: l_lsqv_rec.status := NULL;
150: END IF;
151: IF l_lsqv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN
152: l_lsqv_rec.parent_object_code := NULL;

Line 151: IF l_lsqv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN

147: END IF;
148: IF l_lsqv_rec.status = FND_API.G_MISS_CHAR THEN
149: l_lsqv_rec.status := NULL;
150: END IF;
151: IF l_lsqv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN
152: l_lsqv_rec.parent_object_code := NULL;
153: END IF;
154: IF l_lsqv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
155: l_lsqv_rec.parent_object_id := NULL;

Line 154: IF l_lsqv_rec.parent_object_id = FND_API.G_MISS_NUM THEN

150: END IF;
151: IF l_lsqv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN
152: l_lsqv_rec.parent_object_code := NULL;
153: END IF;
154: IF l_lsqv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
155: l_lsqv_rec.parent_object_id := NULL;
156: END IF;
157: IF l_lsqv_rec.valid_from = FND_API.G_MISS_DATE THEN
158: l_lsqv_rec.valid_from := NULL;

Line 157: IF l_lsqv_rec.valid_from = FND_API.G_MISS_DATE THEN

153: END IF;
154: IF l_lsqv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
155: l_lsqv_rec.parent_object_id := NULL;
156: END IF;
157: IF l_lsqv_rec.valid_from = FND_API.G_MISS_DATE THEN
158: l_lsqv_rec.valid_from := NULL;
159: END IF;
160: IF l_lsqv_rec.valid_to = FND_API.G_MISS_DATE THEN
161: l_lsqv_rec.valid_to := NULL;

Line 160: IF l_lsqv_rec.valid_to = FND_API.G_MISS_DATE THEN

156: END IF;
157: IF l_lsqv_rec.valid_from = FND_API.G_MISS_DATE THEN
158: l_lsqv_rec.valid_from := NULL;
159: END IF;
160: IF l_lsqv_rec.valid_to = FND_API.G_MISS_DATE THEN
161: l_lsqv_rec.valid_to := NULL;
162: END IF;
163: IF l_lsqv_rec.customer_bookclass = FND_API.G_MISS_CHAR THEN
164: l_lsqv_rec.customer_bookclass := NULL;

Line 163: IF l_lsqv_rec.customer_bookclass = FND_API.G_MISS_CHAR THEN

159: END IF;
160: IF l_lsqv_rec.valid_to = FND_API.G_MISS_DATE THEN
161: l_lsqv_rec.valid_to := NULL;
162: END IF;
163: IF l_lsqv_rec.customer_bookclass = FND_API.G_MISS_CHAR THEN
164: l_lsqv_rec.customer_bookclass := NULL;
165: END IF;
166: IF l_lsqv_rec.customer_taxowner = FND_API.G_MISS_CHAR THEN
167: l_lsqv_rec.customer_taxowner := NULL;

Line 166: IF l_lsqv_rec.customer_taxowner = FND_API.G_MISS_CHAR THEN

162: END IF;
163: IF l_lsqv_rec.customer_bookclass = FND_API.G_MISS_CHAR THEN
164: l_lsqv_rec.customer_bookclass := NULL;
165: END IF;
166: IF l_lsqv_rec.customer_taxowner = FND_API.G_MISS_CHAR THEN
167: l_lsqv_rec.customer_taxowner := NULL;
168: END IF;
169: IF l_lsqv_rec.expected_start_date = FND_API.G_MISS_DATE THEN
170: l_lsqv_rec.expected_start_date := NULL;

Line 169: IF l_lsqv_rec.expected_start_date = FND_API.G_MISS_DATE THEN

165: END IF;
166: IF l_lsqv_rec.customer_taxowner = FND_API.G_MISS_CHAR THEN
167: l_lsqv_rec.customer_taxowner := NULL;
168: END IF;
169: IF l_lsqv_rec.expected_start_date = FND_API.G_MISS_DATE THEN
170: l_lsqv_rec.expected_start_date := NULL;
171: END IF;
172: IF l_lsqv_rec.expected_funding_date = FND_API.G_MISS_DATE THEN
173: l_lsqv_rec.expected_funding_date := NULL;

Line 172: IF l_lsqv_rec.expected_funding_date = FND_API.G_MISS_DATE THEN

168: END IF;
169: IF l_lsqv_rec.expected_start_date = FND_API.G_MISS_DATE THEN
170: l_lsqv_rec.expected_start_date := NULL;
171: END IF;
172: IF l_lsqv_rec.expected_funding_date = FND_API.G_MISS_DATE THEN
173: l_lsqv_rec.expected_funding_date := NULL;
174: END IF;
175: IF l_lsqv_rec.expected_delivery_date = FND_API.G_MISS_DATE THEN
176: l_lsqv_rec.expected_delivery_date := NULL;

Line 175: IF l_lsqv_rec.expected_delivery_date = FND_API.G_MISS_DATE THEN

171: END IF;
172: IF l_lsqv_rec.expected_funding_date = FND_API.G_MISS_DATE THEN
173: l_lsqv_rec.expected_funding_date := NULL;
174: END IF;
175: IF l_lsqv_rec.expected_delivery_date = FND_API.G_MISS_DATE THEN
176: l_lsqv_rec.expected_delivery_date := NULL;
177: END IF;
178: IF l_lsqv_rec.pricing_method = FND_API.G_MISS_CHAR THEN
179: l_lsqv_rec.pricing_method := NULL;

Line 178: IF l_lsqv_rec.pricing_method = FND_API.G_MISS_CHAR THEN

174: END IF;
175: IF l_lsqv_rec.expected_delivery_date = FND_API.G_MISS_DATE THEN
176: l_lsqv_rec.expected_delivery_date := NULL;
177: END IF;
178: IF l_lsqv_rec.pricing_method = FND_API.G_MISS_CHAR THEN
179: l_lsqv_rec.pricing_method := NULL;
180: END IF;
181: IF l_lsqv_rec.term = FND_API.G_MISS_NUM THEN
182: l_lsqv_rec.term := NULL;

Line 181: IF l_lsqv_rec.term = FND_API.G_MISS_NUM THEN

177: END IF;
178: IF l_lsqv_rec.pricing_method = FND_API.G_MISS_CHAR THEN
179: l_lsqv_rec.pricing_method := NULL;
180: END IF;
181: IF l_lsqv_rec.term = FND_API.G_MISS_NUM THEN
182: l_lsqv_rec.term := NULL;
183: END IF;
184: IF l_lsqv_rec.product_id = FND_API.G_MISS_NUM THEN
185: l_lsqv_rec.product_id := NULL;

Line 184: IF l_lsqv_rec.product_id = FND_API.G_MISS_NUM THEN

180: END IF;
181: IF l_lsqv_rec.term = FND_API.G_MISS_NUM THEN
182: l_lsqv_rec.term := NULL;
183: END IF;
184: IF l_lsqv_rec.product_id = FND_API.G_MISS_NUM THEN
185: l_lsqv_rec.product_id := NULL;
186: END IF;
187: IF l_lsqv_rec.end_of_term_option_id = FND_API.G_MISS_NUM THEN
188: l_lsqv_rec.end_of_term_option_id := NULL;

Line 187: IF l_lsqv_rec.end_of_term_option_id = FND_API.G_MISS_NUM THEN

183: END IF;
184: IF l_lsqv_rec.product_id = FND_API.G_MISS_NUM THEN
185: l_lsqv_rec.product_id := NULL;
186: END IF;
187: IF l_lsqv_rec.end_of_term_option_id = FND_API.G_MISS_NUM THEN
188: l_lsqv_rec.end_of_term_option_id := NULL;
189: END IF;
190: IF l_lsqv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN
191: l_lsqv_rec.structured_pricing := NULL;

Line 190: IF l_lsqv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN

186: END IF;
187: IF l_lsqv_rec.end_of_term_option_id = FND_API.G_MISS_NUM THEN
188: l_lsqv_rec.end_of_term_option_id := NULL;
189: END IF;
190: IF l_lsqv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN
191: l_lsqv_rec.structured_pricing := NULL;
192: END IF;
193: IF l_lsqv_rec.line_level_pricing = FND_API.G_MISS_CHAR THEN
194: l_lsqv_rec.line_level_pricing := NULL;

Line 193: IF l_lsqv_rec.line_level_pricing = FND_API.G_MISS_CHAR THEN

189: END IF;
190: IF l_lsqv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN
191: l_lsqv_rec.structured_pricing := NULL;
192: END IF;
193: IF l_lsqv_rec.line_level_pricing = FND_API.G_MISS_CHAR THEN
194: l_lsqv_rec.line_level_pricing := NULL;
195: END IF;
196: IF l_lsqv_rec.rate_template_id = FND_API.G_MISS_NUM THEN
197: l_lsqv_rec.rate_template_id := NULL;

Line 196: IF l_lsqv_rec.rate_template_id = FND_API.G_MISS_NUM THEN

192: END IF;
193: IF l_lsqv_rec.line_level_pricing = FND_API.G_MISS_CHAR THEN
194: l_lsqv_rec.line_level_pricing := NULL;
195: END IF;
196: IF l_lsqv_rec.rate_template_id = FND_API.G_MISS_NUM THEN
197: l_lsqv_rec.rate_template_id := NULL;
198: END IF;
199: IF l_lsqv_rec.rate_card_id = FND_API.G_MISS_NUM THEN
200: l_lsqv_rec.rate_card_id := NULL;

Line 199: IF l_lsqv_rec.rate_card_id = FND_API.G_MISS_NUM THEN

195: END IF;
196: IF l_lsqv_rec.rate_template_id = FND_API.G_MISS_NUM THEN
197: l_lsqv_rec.rate_template_id := NULL;
198: END IF;
199: IF l_lsqv_rec.rate_card_id = FND_API.G_MISS_NUM THEN
200: l_lsqv_rec.rate_card_id := NULL;
201: END IF;
202: IF l_lsqv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
203: l_lsqv_rec.lease_rate_factor := NULL;

Line 202: IF l_lsqv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN

198: END IF;
199: IF l_lsqv_rec.rate_card_id = FND_API.G_MISS_NUM THEN
200: l_lsqv_rec.rate_card_id := NULL;
201: END IF;
202: IF l_lsqv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
203: l_lsqv_rec.lease_rate_factor := NULL;
204: END IF;
205: IF l_lsqv_rec.target_rate_type = FND_API.G_MISS_CHAR THEN
206: l_lsqv_rec.target_rate_type := NULL;

Line 205: IF l_lsqv_rec.target_rate_type = FND_API.G_MISS_CHAR THEN

201: END IF;
202: IF l_lsqv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
203: l_lsqv_rec.lease_rate_factor := NULL;
204: END IF;
205: IF l_lsqv_rec.target_rate_type = FND_API.G_MISS_CHAR THEN
206: l_lsqv_rec.target_rate_type := NULL;
207: END IF;
208: IF l_lsqv_rec.target_rate = FND_API.G_MISS_NUM THEN
209: l_lsqv_rec.target_rate := NULL;

Line 208: IF l_lsqv_rec.target_rate = FND_API.G_MISS_NUM THEN

204: END IF;
205: IF l_lsqv_rec.target_rate_type = FND_API.G_MISS_CHAR THEN
206: l_lsqv_rec.target_rate_type := NULL;
207: END IF;
208: IF l_lsqv_rec.target_rate = FND_API.G_MISS_NUM THEN
209: l_lsqv_rec.target_rate := NULL;
210: END IF;
211: IF l_lsqv_rec.target_amount = FND_API.G_MISS_NUM THEN
212: l_lsqv_rec.target_amount := NULL;

Line 211: IF l_lsqv_rec.target_amount = FND_API.G_MISS_NUM THEN

207: END IF;
208: IF l_lsqv_rec.target_rate = FND_API.G_MISS_NUM THEN
209: l_lsqv_rec.target_rate := NULL;
210: END IF;
211: IF l_lsqv_rec.target_amount = FND_API.G_MISS_NUM THEN
212: l_lsqv_rec.target_amount := NULL;
213: END IF;
214: IF l_lsqv_rec.target_frequency = FND_API.G_MISS_CHAR THEN
215: l_lsqv_rec.target_frequency := NULL;

Line 214: IF l_lsqv_rec.target_frequency = FND_API.G_MISS_CHAR THEN

210: END IF;
211: IF l_lsqv_rec.target_amount = FND_API.G_MISS_NUM THEN
212: l_lsqv_rec.target_amount := NULL;
213: END IF;
214: IF l_lsqv_rec.target_frequency = FND_API.G_MISS_CHAR THEN
215: l_lsqv_rec.target_frequency := NULL;
216: END IF;
217: IF l_lsqv_rec.target_arrears_yn = FND_API.G_MISS_CHAR THEN
218: l_lsqv_rec.target_arrears_yn := NULL;

Line 217: IF l_lsqv_rec.target_arrears_yn = FND_API.G_MISS_CHAR THEN

213: END IF;
214: IF l_lsqv_rec.target_frequency = FND_API.G_MISS_CHAR THEN
215: l_lsqv_rec.target_frequency := NULL;
216: END IF;
217: IF l_lsqv_rec.target_arrears_yn = FND_API.G_MISS_CHAR THEN
218: l_lsqv_rec.target_arrears_yn := NULL;
219: END IF;
220: IF l_lsqv_rec.target_periods = FND_API.G_MISS_NUM THEN
221: l_lsqv_rec.target_periods := NULL;

Line 220: IF l_lsqv_rec.target_periods = FND_API.G_MISS_NUM THEN

216: END IF;
217: IF l_lsqv_rec.target_arrears_yn = FND_API.G_MISS_CHAR THEN
218: l_lsqv_rec.target_arrears_yn := NULL;
219: END IF;
220: IF l_lsqv_rec.target_periods = FND_API.G_MISS_NUM THEN
221: l_lsqv_rec.target_periods := NULL;
222: END IF;
223: IF l_lsqv_rec.iir = FND_API.G_MISS_NUM THEN
224: l_lsqv_rec.iir := NULL;

Line 223: IF l_lsqv_rec.iir = FND_API.G_MISS_NUM THEN

219: END IF;
220: IF l_lsqv_rec.target_periods = FND_API.G_MISS_NUM THEN
221: l_lsqv_rec.target_periods := NULL;
222: END IF;
223: IF l_lsqv_rec.iir = FND_API.G_MISS_NUM THEN
224: l_lsqv_rec.iir := NULL;
225: END IF;
226: IF l_lsqv_rec.booking_yield = FND_API.G_MISS_NUM THEN
227: l_lsqv_rec.booking_yield := NULL;

Line 226: IF l_lsqv_rec.booking_yield = FND_API.G_MISS_NUM THEN

222: END IF;
223: IF l_lsqv_rec.iir = FND_API.G_MISS_NUM THEN
224: l_lsqv_rec.iir := NULL;
225: END IF;
226: IF l_lsqv_rec.booking_yield = FND_API.G_MISS_NUM THEN
227: l_lsqv_rec.booking_yield := NULL;
228: END IF;
229: IF l_lsqv_rec.pirr = FND_API.G_MISS_NUM THEN
230: l_lsqv_rec.pirr := NULL;

Line 229: IF l_lsqv_rec.pirr = FND_API.G_MISS_NUM THEN

225: END IF;
226: IF l_lsqv_rec.booking_yield = FND_API.G_MISS_NUM THEN
227: l_lsqv_rec.booking_yield := NULL;
228: END IF;
229: IF l_lsqv_rec.pirr = FND_API.G_MISS_NUM THEN
230: l_lsqv_rec.pirr := NULL;
231: END IF;
232: IF l_lsqv_rec.airr = FND_API.G_MISS_NUM THEN
233: l_lsqv_rec.airr := NULL;

Line 232: IF l_lsqv_rec.airr = FND_API.G_MISS_NUM THEN

228: END IF;
229: IF l_lsqv_rec.pirr = FND_API.G_MISS_NUM THEN
230: l_lsqv_rec.pirr := NULL;
231: END IF;
232: IF l_lsqv_rec.airr = FND_API.G_MISS_NUM THEN
233: l_lsqv_rec.airr := NULL;
234: END IF;
235: IF l_lsqv_rec.sub_iir = FND_API.G_MISS_NUM THEN
236: l_lsqv_rec.sub_iir := NULL;

Line 235: IF l_lsqv_rec.sub_iir = FND_API.G_MISS_NUM THEN

231: END IF;
232: IF l_lsqv_rec.airr = FND_API.G_MISS_NUM THEN
233: l_lsqv_rec.airr := NULL;
234: END IF;
235: IF l_lsqv_rec.sub_iir = FND_API.G_MISS_NUM THEN
236: l_lsqv_rec.sub_iir := NULL;
237: END IF;
238: IF l_lsqv_rec.sub_booking_yield = FND_API.G_MISS_NUM THEN
239: l_lsqv_rec.sub_booking_yield := NULL;

Line 238: IF l_lsqv_rec.sub_booking_yield = FND_API.G_MISS_NUM THEN

234: END IF;
235: IF l_lsqv_rec.sub_iir = FND_API.G_MISS_NUM THEN
236: l_lsqv_rec.sub_iir := NULL;
237: END IF;
238: IF l_lsqv_rec.sub_booking_yield = FND_API.G_MISS_NUM THEN
239: l_lsqv_rec.sub_booking_yield := NULL;
240: END IF;
241: IF l_lsqv_rec.sub_pirr = FND_API.G_MISS_NUM THEN
242: l_lsqv_rec.sub_pirr := NULL;

Line 241: IF l_lsqv_rec.sub_pirr = FND_API.G_MISS_NUM THEN

237: END IF;
238: IF l_lsqv_rec.sub_booking_yield = FND_API.G_MISS_NUM THEN
239: l_lsqv_rec.sub_booking_yield := NULL;
240: END IF;
241: IF l_lsqv_rec.sub_pirr = FND_API.G_MISS_NUM THEN
242: l_lsqv_rec.sub_pirr := NULL;
243: END IF;
244: IF l_lsqv_rec.sub_airr = FND_API.G_MISS_NUM THEN
245: l_lsqv_rec.sub_airr := NULL;

Line 244: IF l_lsqv_rec.sub_airr = FND_API.G_MISS_NUM THEN

240: END IF;
241: IF l_lsqv_rec.sub_pirr = FND_API.G_MISS_NUM THEN
242: l_lsqv_rec.sub_pirr := NULL;
243: END IF;
244: IF l_lsqv_rec.sub_airr = FND_API.G_MISS_NUM THEN
245: l_lsqv_rec.sub_airr := NULL;
246: END IF;
247: IF l_lsqv_rec.usage_category = FND_API.G_MISS_CHAR THEN
248: l_lsqv_rec.usage_category := NULL;

Line 247: IF l_lsqv_rec.usage_category = FND_API.G_MISS_CHAR THEN

243: END IF;
244: IF l_lsqv_rec.sub_airr = FND_API.G_MISS_NUM THEN
245: l_lsqv_rec.sub_airr := NULL;
246: END IF;
247: IF l_lsqv_rec.usage_category = FND_API.G_MISS_CHAR THEN
248: l_lsqv_rec.usage_category := NULL;
249: END IF;
250: IF l_lsqv_rec.usage_industry_class = FND_API.G_MISS_CHAR THEN
251: l_lsqv_rec.usage_industry_class := NULL;

Line 250: IF l_lsqv_rec.usage_industry_class = FND_API.G_MISS_CHAR THEN

246: END IF;
247: IF l_lsqv_rec.usage_category = FND_API.G_MISS_CHAR THEN
248: l_lsqv_rec.usage_category := NULL;
249: END IF;
250: IF l_lsqv_rec.usage_industry_class = FND_API.G_MISS_CHAR THEN
251: l_lsqv_rec.usage_industry_class := NULL;
252: END IF;
253: IF l_lsqv_rec.usage_industry_code = FND_API.G_MISS_CHAR THEN
254: l_lsqv_rec.usage_industry_code := NULL;

Line 253: IF l_lsqv_rec.usage_industry_code = FND_API.G_MISS_CHAR THEN

249: END IF;
250: IF l_lsqv_rec.usage_industry_class = FND_API.G_MISS_CHAR THEN
251: l_lsqv_rec.usage_industry_class := NULL;
252: END IF;
253: IF l_lsqv_rec.usage_industry_code = FND_API.G_MISS_CHAR THEN
254: l_lsqv_rec.usage_industry_code := NULL;
255: END IF;
256: IF l_lsqv_rec.usage_amount = FND_API.G_MISS_NUM THEN
257: l_lsqv_rec.usage_amount := NULL;

Line 256: IF l_lsqv_rec.usage_amount = FND_API.G_MISS_NUM THEN

252: END IF;
253: IF l_lsqv_rec.usage_industry_code = FND_API.G_MISS_CHAR THEN
254: l_lsqv_rec.usage_industry_code := NULL;
255: END IF;
256: IF l_lsqv_rec.usage_amount = FND_API.G_MISS_NUM THEN
257: l_lsqv_rec.usage_amount := NULL;
258: END IF;
259: IF l_lsqv_rec.usage_location_id = FND_API.G_MISS_NUM THEN
260: l_lsqv_rec.usage_location_id := NULL;

Line 259: IF l_lsqv_rec.usage_location_id = FND_API.G_MISS_NUM THEN

255: END IF;
256: IF l_lsqv_rec.usage_amount = FND_API.G_MISS_NUM THEN
257: l_lsqv_rec.usage_amount := NULL;
258: END IF;
259: IF l_lsqv_rec.usage_location_id = FND_API.G_MISS_NUM THEN
260: l_lsqv_rec.usage_location_id := NULL;
261: END IF;
262: IF l_lsqv_rec.property_tax_applicable = FND_API.G_MISS_CHAR THEN
263: l_lsqv_rec.property_tax_applicable := NULL;

Line 262: IF l_lsqv_rec.property_tax_applicable = FND_API.G_MISS_CHAR THEN

258: END IF;
259: IF l_lsqv_rec.usage_location_id = FND_API.G_MISS_NUM THEN
260: l_lsqv_rec.usage_location_id := NULL;
261: END IF;
262: IF l_lsqv_rec.property_tax_applicable = FND_API.G_MISS_CHAR THEN
263: l_lsqv_rec.property_tax_applicable := NULL;
264: END IF;
265: IF l_lsqv_rec.property_tax_billing_type = FND_API.G_MISS_CHAR THEN
266: l_lsqv_rec.property_tax_billing_type := NULL;

Line 265: IF l_lsqv_rec.property_tax_billing_type = FND_API.G_MISS_CHAR THEN

261: END IF;
262: IF l_lsqv_rec.property_tax_applicable = FND_API.G_MISS_CHAR THEN
263: l_lsqv_rec.property_tax_applicable := NULL;
264: END IF;
265: IF l_lsqv_rec.property_tax_billing_type = FND_API.G_MISS_CHAR THEN
266: l_lsqv_rec.property_tax_billing_type := NULL;
267: END IF;
268: IF l_lsqv_rec.upfront_tax_treatment = FND_API.G_MISS_CHAR THEN
269: l_lsqv_rec.upfront_tax_treatment := NULL;

Line 268: IF l_lsqv_rec.upfront_tax_treatment = FND_API.G_MISS_CHAR THEN

264: END IF;
265: IF l_lsqv_rec.property_tax_billing_type = FND_API.G_MISS_CHAR THEN
266: l_lsqv_rec.property_tax_billing_type := NULL;
267: END IF;
268: IF l_lsqv_rec.upfront_tax_treatment = FND_API.G_MISS_CHAR THEN
269: l_lsqv_rec.upfront_tax_treatment := NULL;
270: END IF;
271: IF l_lsqv_rec.upfront_tax_stream_type = FND_API.G_MISS_NUM THEN
272: l_lsqv_rec.upfront_tax_stream_type := NULL;

Line 271: IF l_lsqv_rec.upfront_tax_stream_type = FND_API.G_MISS_NUM THEN

267: END IF;
268: IF l_lsqv_rec.upfront_tax_treatment = FND_API.G_MISS_CHAR THEN
269: l_lsqv_rec.upfront_tax_treatment := NULL;
270: END IF;
271: IF l_lsqv_rec.upfront_tax_stream_type = FND_API.G_MISS_NUM THEN
272: l_lsqv_rec.upfront_tax_stream_type := NULL;
273: END IF;
274: IF l_lsqv_rec.transfer_of_title = FND_API.G_MISS_CHAR THEN
275: l_lsqv_rec.transfer_of_title := NULL;

Line 274: IF l_lsqv_rec.transfer_of_title = FND_API.G_MISS_CHAR THEN

270: END IF;
271: IF l_lsqv_rec.upfront_tax_stream_type = FND_API.G_MISS_NUM THEN
272: l_lsqv_rec.upfront_tax_stream_type := NULL;
273: END IF;
274: IF l_lsqv_rec.transfer_of_title = FND_API.G_MISS_CHAR THEN
275: l_lsqv_rec.transfer_of_title := NULL;
276: END IF;
277: IF l_lsqv_rec.age_of_equipment = FND_API.G_MISS_NUM THEN
278: l_lsqv_rec.age_of_equipment := NULL;

Line 277: IF l_lsqv_rec.age_of_equipment = FND_API.G_MISS_NUM THEN

273: END IF;
274: IF l_lsqv_rec.transfer_of_title = FND_API.G_MISS_CHAR THEN
275: l_lsqv_rec.transfer_of_title := NULL;
276: END IF;
277: IF l_lsqv_rec.age_of_equipment = FND_API.G_MISS_NUM THEN
278: l_lsqv_rec.age_of_equipment := NULL;
279: END IF;
280: IF l_lsqv_rec.purchase_of_lease = FND_API.G_MISS_CHAR THEN
281: l_lsqv_rec.purchase_of_lease := NULL;

Line 280: IF l_lsqv_rec.purchase_of_lease = FND_API.G_MISS_CHAR THEN

276: END IF;
277: IF l_lsqv_rec.age_of_equipment = FND_API.G_MISS_NUM THEN
278: l_lsqv_rec.age_of_equipment := NULL;
279: END IF;
280: IF l_lsqv_rec.purchase_of_lease = FND_API.G_MISS_CHAR THEN
281: l_lsqv_rec.purchase_of_lease := NULL;
282: END IF;
283: IF l_lsqv_rec.sale_and_lease_back = FND_API.G_MISS_CHAR THEN
284: l_lsqv_rec.sale_and_lease_back := NULL;

Line 283: IF l_lsqv_rec.sale_and_lease_back = FND_API.G_MISS_CHAR THEN

279: END IF;
280: IF l_lsqv_rec.purchase_of_lease = FND_API.G_MISS_CHAR THEN
281: l_lsqv_rec.purchase_of_lease := NULL;
282: END IF;
283: IF l_lsqv_rec.sale_and_lease_back = FND_API.G_MISS_CHAR THEN
284: l_lsqv_rec.sale_and_lease_back := NULL;
285: END IF;
286: IF l_lsqv_rec.interest_disclosed = FND_API.G_MISS_CHAR THEN
287: l_lsqv_rec.interest_disclosed := NULL;

Line 286: IF l_lsqv_rec.interest_disclosed = FND_API.G_MISS_CHAR THEN

282: END IF;
283: IF l_lsqv_rec.sale_and_lease_back = FND_API.G_MISS_CHAR THEN
284: l_lsqv_rec.sale_and_lease_back := NULL;
285: END IF;
286: IF l_lsqv_rec.interest_disclosed = FND_API.G_MISS_CHAR THEN
287: l_lsqv_rec.interest_disclosed := NULL;
288: END IF;
289: IF l_lsqv_rec.primary_quote = FND_API.G_MISS_CHAR THEN
290: l_lsqv_rec.primary_quote := NULL;

Line 289: IF l_lsqv_rec.primary_quote = FND_API.G_MISS_CHAR THEN

285: END IF;
286: IF l_lsqv_rec.interest_disclosed = FND_API.G_MISS_CHAR THEN
287: l_lsqv_rec.interest_disclosed := NULL;
288: END IF;
289: IF l_lsqv_rec.primary_quote = FND_API.G_MISS_CHAR THEN
290: l_lsqv_rec.primary_quote := NULL;
291: END IF;
292: --Bug # 5647107
293: IF l_lsqv_rec.legal_entity_id = FND_API.G_MISS_NUM THEN

Line 293: IF l_lsqv_rec.legal_entity_id = FND_API.G_MISS_NUM THEN

289: IF l_lsqv_rec.primary_quote = FND_API.G_MISS_CHAR THEN
290: l_lsqv_rec.primary_quote := NULL;
291: END IF;
292: --Bug # 5647107
293: IF l_lsqv_rec.legal_entity_id = FND_API.G_MISS_NUM THEN
294: l_lsqv_rec.legal_entity_id := NULL;
295: END IF;
296: --Bug # 5647107
297: -- Bug 5908845. eBTax Enhancement Project

Line 298: IF l_lsqv_rec.line_intended_use = FND_API.G_MISS_CHAR THEN

294: l_lsqv_rec.legal_entity_id := NULL;
295: END IF;
296: --Bug # 5647107
297: -- Bug 5908845. eBTax Enhancement Project
298: IF l_lsqv_rec.line_intended_use = FND_API.G_MISS_CHAR THEN
299: l_lsqv_rec.line_intended_use := NULL;
300: END IF;
301: -- End Bug 5908845. eBTax Enhancement Project
302: IF l_lsqv_rec.short_description = FND_API.G_MISS_CHAR THEN

Line 302: IF l_lsqv_rec.short_description = FND_API.G_MISS_CHAR THEN

298: IF l_lsqv_rec.line_intended_use = FND_API.G_MISS_CHAR THEN
299: l_lsqv_rec.line_intended_use := NULL;
300: END IF;
301: -- End Bug 5908845. eBTax Enhancement Project
302: IF l_lsqv_rec.short_description = FND_API.G_MISS_CHAR THEN
303: l_lsqv_rec.short_description := NULL;
304: END IF;
305: IF l_lsqv_rec.description = FND_API.G_MISS_CHAR THEN
306: l_lsqv_rec.description := NULL;

Line 305: IF l_lsqv_rec.description = FND_API.G_MISS_CHAR THEN

301: -- End Bug 5908845. eBTax Enhancement Project
302: IF l_lsqv_rec.short_description = FND_API.G_MISS_CHAR THEN
303: l_lsqv_rec.short_description := NULL;
304: END IF;
305: IF l_lsqv_rec.description = FND_API.G_MISS_CHAR THEN
306: l_lsqv_rec.description := NULL;
307: END IF;
308: IF l_lsqv_rec.comments = FND_API.G_MISS_CHAR THEN
309: l_lsqv_rec.comments := NULL;

Line 308: IF l_lsqv_rec.comments = FND_API.G_MISS_CHAR THEN

304: END IF;
305: IF l_lsqv_rec.description = FND_API.G_MISS_CHAR THEN
306: l_lsqv_rec.description := NULL;
307: END IF;
308: IF l_lsqv_rec.comments = FND_API.G_MISS_CHAR THEN
309: l_lsqv_rec.comments := NULL;
310: END IF;
311:
312: RETURN l_lsqv_rec;

Line 1663: IF x_lsqv_rec.attribute_category = FND_API.G_MISS_CHAR THEN

1659: ELSIF l_return_status = G_RET_STS_ERROR THEN
1660: RAISE OKL_API.G_EXCEPTION_ERROR;
1661: END IF;
1662:
1663: IF x_lsqv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1664: x_lsqv_rec.attribute_category := l_db_lsqv_rec.attribute_category;
1665: END IF;
1666: IF x_lsqv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1667: x_lsqv_rec.attribute1 := l_db_lsqv_rec.attribute1;

Line 1666: IF x_lsqv_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1662:
1663: IF x_lsqv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1664: x_lsqv_rec.attribute_category := l_db_lsqv_rec.attribute_category;
1665: END IF;
1666: IF x_lsqv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1667: x_lsqv_rec.attribute1 := l_db_lsqv_rec.attribute1;
1668: END IF;
1669: IF x_lsqv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1670: x_lsqv_rec.attribute2 := l_db_lsqv_rec.attribute2;

Line 1669: IF x_lsqv_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1665: END IF;
1666: IF x_lsqv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1667: x_lsqv_rec.attribute1 := l_db_lsqv_rec.attribute1;
1668: END IF;
1669: IF x_lsqv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1670: x_lsqv_rec.attribute2 := l_db_lsqv_rec.attribute2;
1671: END IF;
1672: IF x_lsqv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1673: x_lsqv_rec.attribute3 := l_db_lsqv_rec.attribute3;

Line 1672: IF x_lsqv_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1668: END IF;
1669: IF x_lsqv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1670: x_lsqv_rec.attribute2 := l_db_lsqv_rec.attribute2;
1671: END IF;
1672: IF x_lsqv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1673: x_lsqv_rec.attribute3 := l_db_lsqv_rec.attribute3;
1674: END IF;
1675: IF x_lsqv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1676: x_lsqv_rec.attribute4 := l_db_lsqv_rec.attribute4;

Line 1675: IF x_lsqv_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1671: END IF;
1672: IF x_lsqv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1673: x_lsqv_rec.attribute3 := l_db_lsqv_rec.attribute3;
1674: END IF;
1675: IF x_lsqv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1676: x_lsqv_rec.attribute4 := l_db_lsqv_rec.attribute4;
1677: END IF;
1678: IF x_lsqv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1679: x_lsqv_rec.attribute5 := l_db_lsqv_rec.attribute5;

Line 1678: IF x_lsqv_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1674: END IF;
1675: IF x_lsqv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1676: x_lsqv_rec.attribute4 := l_db_lsqv_rec.attribute4;
1677: END IF;
1678: IF x_lsqv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1679: x_lsqv_rec.attribute5 := l_db_lsqv_rec.attribute5;
1680: END IF;
1681: IF x_lsqv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1682: x_lsqv_rec.attribute6 := l_db_lsqv_rec.attribute6;

Line 1681: IF x_lsqv_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1677: END IF;
1678: IF x_lsqv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1679: x_lsqv_rec.attribute5 := l_db_lsqv_rec.attribute5;
1680: END IF;
1681: IF x_lsqv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1682: x_lsqv_rec.attribute6 := l_db_lsqv_rec.attribute6;
1683: END IF;
1684: IF x_lsqv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1685: x_lsqv_rec.attribute7 := l_db_lsqv_rec.attribute7;

Line 1684: IF x_lsqv_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1680: END IF;
1681: IF x_lsqv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1682: x_lsqv_rec.attribute6 := l_db_lsqv_rec.attribute6;
1683: END IF;
1684: IF x_lsqv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1685: x_lsqv_rec.attribute7 := l_db_lsqv_rec.attribute7;
1686: END IF;
1687: IF x_lsqv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1688: x_lsqv_rec.attribute8 := l_db_lsqv_rec.attribute8;

Line 1687: IF x_lsqv_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1683: END IF;
1684: IF x_lsqv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1685: x_lsqv_rec.attribute7 := l_db_lsqv_rec.attribute7;
1686: END IF;
1687: IF x_lsqv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1688: x_lsqv_rec.attribute8 := l_db_lsqv_rec.attribute8;
1689: END IF;
1690: IF x_lsqv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1691: x_lsqv_rec.attribute9 := l_db_lsqv_rec.attribute9;

Line 1690: IF x_lsqv_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1686: END IF;
1687: IF x_lsqv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1688: x_lsqv_rec.attribute8 := l_db_lsqv_rec.attribute8;
1689: END IF;
1690: IF x_lsqv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1691: x_lsqv_rec.attribute9 := l_db_lsqv_rec.attribute9;
1692: END IF;
1693: IF x_lsqv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1694: x_lsqv_rec.attribute10 := l_db_lsqv_rec.attribute10;

Line 1693: IF x_lsqv_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1689: END IF;
1690: IF x_lsqv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1691: x_lsqv_rec.attribute9 := l_db_lsqv_rec.attribute9;
1692: END IF;
1693: IF x_lsqv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1694: x_lsqv_rec.attribute10 := l_db_lsqv_rec.attribute10;
1695: END IF;
1696: IF x_lsqv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1697: x_lsqv_rec.attribute11 := l_db_lsqv_rec.attribute11;

Line 1696: IF x_lsqv_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1692: END IF;
1693: IF x_lsqv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1694: x_lsqv_rec.attribute10 := l_db_lsqv_rec.attribute10;
1695: END IF;
1696: IF x_lsqv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1697: x_lsqv_rec.attribute11 := l_db_lsqv_rec.attribute11;
1698: END IF;
1699: IF x_lsqv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1700: x_lsqv_rec.attribute12 := l_db_lsqv_rec.attribute12;

Line 1699: IF x_lsqv_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1695: END IF;
1696: IF x_lsqv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1697: x_lsqv_rec.attribute11 := l_db_lsqv_rec.attribute11;
1698: END IF;
1699: IF x_lsqv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1700: x_lsqv_rec.attribute12 := l_db_lsqv_rec.attribute12;
1701: END IF;
1702: IF x_lsqv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1703: x_lsqv_rec.attribute13 := l_db_lsqv_rec.attribute13;

Line 1702: IF x_lsqv_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1698: END IF;
1699: IF x_lsqv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1700: x_lsqv_rec.attribute12 := l_db_lsqv_rec.attribute12;
1701: END IF;
1702: IF x_lsqv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1703: x_lsqv_rec.attribute13 := l_db_lsqv_rec.attribute13;
1704: END IF;
1705: IF x_lsqv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1706: x_lsqv_rec.attribute14 := l_db_lsqv_rec.attribute14;

Line 1705: IF x_lsqv_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1701: END IF;
1702: IF x_lsqv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1703: x_lsqv_rec.attribute13 := l_db_lsqv_rec.attribute13;
1704: END IF;
1705: IF x_lsqv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1706: x_lsqv_rec.attribute14 := l_db_lsqv_rec.attribute14;
1707: END IF;
1708: IF x_lsqv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1709: x_lsqv_rec.attribute15 := l_db_lsqv_rec.attribute15;

Line 1708: IF x_lsqv_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1704: END IF;
1705: IF x_lsqv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1706: x_lsqv_rec.attribute14 := l_db_lsqv_rec.attribute14;
1707: END IF;
1708: IF x_lsqv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1709: x_lsqv_rec.attribute15 := l_db_lsqv_rec.attribute15;
1710: END IF;
1711: IF x_lsqv_rec.reference_number = FND_API.G_MISS_CHAR THEN
1712: x_lsqv_rec.reference_number := l_db_lsqv_rec.reference_number;

Line 1711: IF x_lsqv_rec.reference_number = FND_API.G_MISS_CHAR THEN

1707: END IF;
1708: IF x_lsqv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1709: x_lsqv_rec.attribute15 := l_db_lsqv_rec.attribute15;
1710: END IF;
1711: IF x_lsqv_rec.reference_number = FND_API.G_MISS_CHAR THEN
1712: x_lsqv_rec.reference_number := l_db_lsqv_rec.reference_number;
1713: END IF;
1714: IF x_lsqv_rec.status = FND_API.G_MISS_CHAR THEN
1715: x_lsqv_rec.status := l_db_lsqv_rec.status;

Line 1714: IF x_lsqv_rec.status = FND_API.G_MISS_CHAR THEN

1710: END IF;
1711: IF x_lsqv_rec.reference_number = FND_API.G_MISS_CHAR THEN
1712: x_lsqv_rec.reference_number := l_db_lsqv_rec.reference_number;
1713: END IF;
1714: IF x_lsqv_rec.status = FND_API.G_MISS_CHAR THEN
1715: x_lsqv_rec.status := l_db_lsqv_rec.status;
1716: END IF;
1717: IF x_lsqv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN
1718: x_lsqv_rec.parent_object_code := l_db_lsqv_rec.parent_object_code;

Line 1717: IF x_lsqv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN

1713: END IF;
1714: IF x_lsqv_rec.status = FND_API.G_MISS_CHAR THEN
1715: x_lsqv_rec.status := l_db_lsqv_rec.status;
1716: END IF;
1717: IF x_lsqv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN
1718: x_lsqv_rec.parent_object_code := l_db_lsqv_rec.parent_object_code;
1719: END IF;
1720: IF x_lsqv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
1721: x_lsqv_rec.parent_object_id := l_db_lsqv_rec.parent_object_id;

Line 1720: IF x_lsqv_rec.parent_object_id = FND_API.G_MISS_NUM THEN

1716: END IF;
1717: IF x_lsqv_rec.parent_object_code = FND_API.G_MISS_CHAR THEN
1718: x_lsqv_rec.parent_object_code := l_db_lsqv_rec.parent_object_code;
1719: END IF;
1720: IF x_lsqv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
1721: x_lsqv_rec.parent_object_id := l_db_lsqv_rec.parent_object_id;
1722: END IF;
1723: IF x_lsqv_rec.valid_from = FND_API.G_MISS_DATE THEN
1724: x_lsqv_rec.valid_from := l_db_lsqv_rec.valid_from;

Line 1723: IF x_lsqv_rec.valid_from = FND_API.G_MISS_DATE THEN

1719: END IF;
1720: IF x_lsqv_rec.parent_object_id = FND_API.G_MISS_NUM THEN
1721: x_lsqv_rec.parent_object_id := l_db_lsqv_rec.parent_object_id;
1722: END IF;
1723: IF x_lsqv_rec.valid_from = FND_API.G_MISS_DATE THEN
1724: x_lsqv_rec.valid_from := l_db_lsqv_rec.valid_from;
1725: END IF;
1726: IF x_lsqv_rec.valid_to = FND_API.G_MISS_DATE THEN
1727: x_lsqv_rec.valid_to := l_db_lsqv_rec.valid_to;

Line 1726: IF x_lsqv_rec.valid_to = FND_API.G_MISS_DATE THEN

1722: END IF;
1723: IF x_lsqv_rec.valid_from = FND_API.G_MISS_DATE THEN
1724: x_lsqv_rec.valid_from := l_db_lsqv_rec.valid_from;
1725: END IF;
1726: IF x_lsqv_rec.valid_to = FND_API.G_MISS_DATE THEN
1727: x_lsqv_rec.valid_to := l_db_lsqv_rec.valid_to;
1728: END IF;
1729: IF x_lsqv_rec.customer_bookclass = FND_API.G_MISS_CHAR THEN
1730: x_lsqv_rec.customer_bookclass := l_db_lsqv_rec.customer_bookclass;

Line 1729: IF x_lsqv_rec.customer_bookclass = FND_API.G_MISS_CHAR THEN

1725: END IF;
1726: IF x_lsqv_rec.valid_to = FND_API.G_MISS_DATE THEN
1727: x_lsqv_rec.valid_to := l_db_lsqv_rec.valid_to;
1728: END IF;
1729: IF x_lsqv_rec.customer_bookclass = FND_API.G_MISS_CHAR THEN
1730: x_lsqv_rec.customer_bookclass := l_db_lsqv_rec.customer_bookclass;
1731: END IF;
1732: IF x_lsqv_rec.customer_taxowner = FND_API.G_MISS_CHAR THEN
1733: x_lsqv_rec.customer_taxowner := l_db_lsqv_rec.customer_taxowner;

Line 1732: IF x_lsqv_rec.customer_taxowner = FND_API.G_MISS_CHAR THEN

1728: END IF;
1729: IF x_lsqv_rec.customer_bookclass = FND_API.G_MISS_CHAR THEN
1730: x_lsqv_rec.customer_bookclass := l_db_lsqv_rec.customer_bookclass;
1731: END IF;
1732: IF x_lsqv_rec.customer_taxowner = FND_API.G_MISS_CHAR THEN
1733: x_lsqv_rec.customer_taxowner := l_db_lsqv_rec.customer_taxowner;
1734: END IF;
1735: IF x_lsqv_rec.expected_start_date = FND_API.G_MISS_DATE THEN
1736: x_lsqv_rec.expected_start_date := l_db_lsqv_rec.expected_start_date;

Line 1735: IF x_lsqv_rec.expected_start_date = FND_API.G_MISS_DATE THEN

1731: END IF;
1732: IF x_lsqv_rec.customer_taxowner = FND_API.G_MISS_CHAR THEN
1733: x_lsqv_rec.customer_taxowner := l_db_lsqv_rec.customer_taxowner;
1734: END IF;
1735: IF x_lsqv_rec.expected_start_date = FND_API.G_MISS_DATE THEN
1736: x_lsqv_rec.expected_start_date := l_db_lsqv_rec.expected_start_date;
1737: END IF;
1738: IF x_lsqv_rec.expected_funding_date = FND_API.G_MISS_DATE THEN
1739: x_lsqv_rec.expected_funding_date := l_db_lsqv_rec.expected_funding_date;

Line 1738: IF x_lsqv_rec.expected_funding_date = FND_API.G_MISS_DATE THEN

1734: END IF;
1735: IF x_lsqv_rec.expected_start_date = FND_API.G_MISS_DATE THEN
1736: x_lsqv_rec.expected_start_date := l_db_lsqv_rec.expected_start_date;
1737: END IF;
1738: IF x_lsqv_rec.expected_funding_date = FND_API.G_MISS_DATE THEN
1739: x_lsqv_rec.expected_funding_date := l_db_lsqv_rec.expected_funding_date;
1740: END IF;
1741: IF x_lsqv_rec.expected_delivery_date = FND_API.G_MISS_DATE THEN
1742: x_lsqv_rec.expected_delivery_date := l_db_lsqv_rec.expected_delivery_date;

Line 1741: IF x_lsqv_rec.expected_delivery_date = FND_API.G_MISS_DATE THEN

1737: END IF;
1738: IF x_lsqv_rec.expected_funding_date = FND_API.G_MISS_DATE THEN
1739: x_lsqv_rec.expected_funding_date := l_db_lsqv_rec.expected_funding_date;
1740: END IF;
1741: IF x_lsqv_rec.expected_delivery_date = FND_API.G_MISS_DATE THEN
1742: x_lsqv_rec.expected_delivery_date := l_db_lsqv_rec.expected_delivery_date;
1743: END IF;
1744: IF x_lsqv_rec.pricing_method = FND_API.G_MISS_CHAR THEN
1745: x_lsqv_rec.pricing_method := l_db_lsqv_rec.pricing_method;

Line 1744: IF x_lsqv_rec.pricing_method = FND_API.G_MISS_CHAR THEN

1740: END IF;
1741: IF x_lsqv_rec.expected_delivery_date = FND_API.G_MISS_DATE THEN
1742: x_lsqv_rec.expected_delivery_date := l_db_lsqv_rec.expected_delivery_date;
1743: END IF;
1744: IF x_lsqv_rec.pricing_method = FND_API.G_MISS_CHAR THEN
1745: x_lsqv_rec.pricing_method := l_db_lsqv_rec.pricing_method;
1746: END IF;
1747: IF x_lsqv_rec.term = FND_API.G_MISS_NUM THEN
1748: x_lsqv_rec.term := l_db_lsqv_rec.term;

Line 1747: IF x_lsqv_rec.term = FND_API.G_MISS_NUM THEN

1743: END IF;
1744: IF x_lsqv_rec.pricing_method = FND_API.G_MISS_CHAR THEN
1745: x_lsqv_rec.pricing_method := l_db_lsqv_rec.pricing_method;
1746: END IF;
1747: IF x_lsqv_rec.term = FND_API.G_MISS_NUM THEN
1748: x_lsqv_rec.term := l_db_lsqv_rec.term;
1749: END IF;
1750: IF x_lsqv_rec.product_id = FND_API.G_MISS_NUM THEN
1751: x_lsqv_rec.product_id := l_db_lsqv_rec.product_id;

Line 1750: IF x_lsqv_rec.product_id = FND_API.G_MISS_NUM THEN

1746: END IF;
1747: IF x_lsqv_rec.term = FND_API.G_MISS_NUM THEN
1748: x_lsqv_rec.term := l_db_lsqv_rec.term;
1749: END IF;
1750: IF x_lsqv_rec.product_id = FND_API.G_MISS_NUM THEN
1751: x_lsqv_rec.product_id := l_db_lsqv_rec.product_id;
1752: END IF;
1753: IF x_lsqv_rec.end_of_term_option_id = FND_API.G_MISS_NUM THEN
1754: x_lsqv_rec.end_of_term_option_id := l_db_lsqv_rec.end_of_term_option_id;

Line 1753: IF x_lsqv_rec.end_of_term_option_id = FND_API.G_MISS_NUM THEN

1749: END IF;
1750: IF x_lsqv_rec.product_id = FND_API.G_MISS_NUM THEN
1751: x_lsqv_rec.product_id := l_db_lsqv_rec.product_id;
1752: END IF;
1753: IF x_lsqv_rec.end_of_term_option_id = FND_API.G_MISS_NUM THEN
1754: x_lsqv_rec.end_of_term_option_id := l_db_lsqv_rec.end_of_term_option_id;
1755: END IF;
1756: IF x_lsqv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN
1757: x_lsqv_rec.structured_pricing := l_db_lsqv_rec.structured_pricing;

Line 1756: IF x_lsqv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN

1752: END IF;
1753: IF x_lsqv_rec.end_of_term_option_id = FND_API.G_MISS_NUM THEN
1754: x_lsqv_rec.end_of_term_option_id := l_db_lsqv_rec.end_of_term_option_id;
1755: END IF;
1756: IF x_lsqv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN
1757: x_lsqv_rec.structured_pricing := l_db_lsqv_rec.structured_pricing;
1758: END IF;
1759: IF x_lsqv_rec.line_level_pricing = FND_API.G_MISS_CHAR THEN
1760: x_lsqv_rec.line_level_pricing := l_db_lsqv_rec.line_level_pricing;

Line 1759: IF x_lsqv_rec.line_level_pricing = FND_API.G_MISS_CHAR THEN

1755: END IF;
1756: IF x_lsqv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN
1757: x_lsqv_rec.structured_pricing := l_db_lsqv_rec.structured_pricing;
1758: END IF;
1759: IF x_lsqv_rec.line_level_pricing = FND_API.G_MISS_CHAR THEN
1760: x_lsqv_rec.line_level_pricing := l_db_lsqv_rec.line_level_pricing;
1761: END IF;
1762: IF x_lsqv_rec.rate_template_id = FND_API.G_MISS_NUM THEN
1763: x_lsqv_rec.rate_template_id := l_db_lsqv_rec.rate_template_id;

Line 1762: IF x_lsqv_rec.rate_template_id = FND_API.G_MISS_NUM THEN

1758: END IF;
1759: IF x_lsqv_rec.line_level_pricing = FND_API.G_MISS_CHAR THEN
1760: x_lsqv_rec.line_level_pricing := l_db_lsqv_rec.line_level_pricing;
1761: END IF;
1762: IF x_lsqv_rec.rate_template_id = FND_API.G_MISS_NUM THEN
1763: x_lsqv_rec.rate_template_id := l_db_lsqv_rec.rate_template_id;
1764: END IF;
1765: IF x_lsqv_rec.rate_card_id = FND_API.G_MISS_NUM THEN
1766: x_lsqv_rec.rate_card_id := l_db_lsqv_rec.rate_card_id;

Line 1765: IF x_lsqv_rec.rate_card_id = FND_API.G_MISS_NUM THEN

1761: END IF;
1762: IF x_lsqv_rec.rate_template_id = FND_API.G_MISS_NUM THEN
1763: x_lsqv_rec.rate_template_id := l_db_lsqv_rec.rate_template_id;
1764: END IF;
1765: IF x_lsqv_rec.rate_card_id = FND_API.G_MISS_NUM THEN
1766: x_lsqv_rec.rate_card_id := l_db_lsqv_rec.rate_card_id;
1767: END IF;
1768: IF x_lsqv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
1769: x_lsqv_rec.lease_rate_factor := l_db_lsqv_rec.lease_rate_factor;

Line 1768: IF x_lsqv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN

1764: END IF;
1765: IF x_lsqv_rec.rate_card_id = FND_API.G_MISS_NUM THEN
1766: x_lsqv_rec.rate_card_id := l_db_lsqv_rec.rate_card_id;
1767: END IF;
1768: IF x_lsqv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
1769: x_lsqv_rec.lease_rate_factor := l_db_lsqv_rec.lease_rate_factor;
1770: END IF;
1771: IF x_lsqv_rec.target_rate_type = FND_API.G_MISS_CHAR THEN
1772: x_lsqv_rec.target_rate_type := l_db_lsqv_rec.target_rate_type;

Line 1771: IF x_lsqv_rec.target_rate_type = FND_API.G_MISS_CHAR THEN

1767: END IF;
1768: IF x_lsqv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
1769: x_lsqv_rec.lease_rate_factor := l_db_lsqv_rec.lease_rate_factor;
1770: END IF;
1771: IF x_lsqv_rec.target_rate_type = FND_API.G_MISS_CHAR THEN
1772: x_lsqv_rec.target_rate_type := l_db_lsqv_rec.target_rate_type;
1773: END IF;
1774: IF x_lsqv_rec.target_rate = FND_API.G_MISS_NUM THEN
1775: x_lsqv_rec.target_rate := l_db_lsqv_rec.target_rate;

Line 1774: IF x_lsqv_rec.target_rate = FND_API.G_MISS_NUM THEN

1770: END IF;
1771: IF x_lsqv_rec.target_rate_type = FND_API.G_MISS_CHAR THEN
1772: x_lsqv_rec.target_rate_type := l_db_lsqv_rec.target_rate_type;
1773: END IF;
1774: IF x_lsqv_rec.target_rate = FND_API.G_MISS_NUM THEN
1775: x_lsqv_rec.target_rate := l_db_lsqv_rec.target_rate;
1776: END IF;
1777: IF x_lsqv_rec.target_amount = FND_API.G_MISS_NUM THEN
1778: x_lsqv_rec.target_amount := l_db_lsqv_rec.target_amount;

Line 1777: IF x_lsqv_rec.target_amount = FND_API.G_MISS_NUM THEN

1773: END IF;
1774: IF x_lsqv_rec.target_rate = FND_API.G_MISS_NUM THEN
1775: x_lsqv_rec.target_rate := l_db_lsqv_rec.target_rate;
1776: END IF;
1777: IF x_lsqv_rec.target_amount = FND_API.G_MISS_NUM THEN
1778: x_lsqv_rec.target_amount := l_db_lsqv_rec.target_amount;
1779: END IF;
1780: IF x_lsqv_rec.target_frequency = FND_API.G_MISS_CHAR THEN
1781: x_lsqv_rec.target_frequency := l_db_lsqv_rec.target_frequency;

Line 1780: IF x_lsqv_rec.target_frequency = FND_API.G_MISS_CHAR THEN

1776: END IF;
1777: IF x_lsqv_rec.target_amount = FND_API.G_MISS_NUM THEN
1778: x_lsqv_rec.target_amount := l_db_lsqv_rec.target_amount;
1779: END IF;
1780: IF x_lsqv_rec.target_frequency = FND_API.G_MISS_CHAR THEN
1781: x_lsqv_rec.target_frequency := l_db_lsqv_rec.target_frequency;
1782: END IF;
1783: IF x_lsqv_rec.target_arrears_yn = FND_API.G_MISS_CHAR THEN
1784: x_lsqv_rec.target_arrears_yn := l_db_lsqv_rec.target_arrears_yn;

Line 1783: IF x_lsqv_rec.target_arrears_yn = FND_API.G_MISS_CHAR THEN

1779: END IF;
1780: IF x_lsqv_rec.target_frequency = FND_API.G_MISS_CHAR THEN
1781: x_lsqv_rec.target_frequency := l_db_lsqv_rec.target_frequency;
1782: END IF;
1783: IF x_lsqv_rec.target_arrears_yn = FND_API.G_MISS_CHAR THEN
1784: x_lsqv_rec.target_arrears_yn := l_db_lsqv_rec.target_arrears_yn;
1785: END IF;
1786: IF x_lsqv_rec.target_periods = FND_API.G_MISS_NUM THEN
1787: x_lsqv_rec.target_periods := l_db_lsqv_rec.target_periods;

Line 1786: IF x_lsqv_rec.target_periods = FND_API.G_MISS_NUM THEN

1782: END IF;
1783: IF x_lsqv_rec.target_arrears_yn = FND_API.G_MISS_CHAR THEN
1784: x_lsqv_rec.target_arrears_yn := l_db_lsqv_rec.target_arrears_yn;
1785: END IF;
1786: IF x_lsqv_rec.target_periods = FND_API.G_MISS_NUM THEN
1787: x_lsqv_rec.target_periods := l_db_lsqv_rec.target_periods;
1788: END IF;
1789: IF x_lsqv_rec.iir = FND_API.G_MISS_NUM THEN
1790: x_lsqv_rec.iir := l_db_lsqv_rec.iir;

Line 1789: IF x_lsqv_rec.iir = FND_API.G_MISS_NUM THEN

1785: END IF;
1786: IF x_lsqv_rec.target_periods = FND_API.G_MISS_NUM THEN
1787: x_lsqv_rec.target_periods := l_db_lsqv_rec.target_periods;
1788: END IF;
1789: IF x_lsqv_rec.iir = FND_API.G_MISS_NUM THEN
1790: x_lsqv_rec.iir := l_db_lsqv_rec.iir;
1791: END IF;
1792: IF x_lsqv_rec.booking_yield = FND_API.G_MISS_NUM THEN
1793: x_lsqv_rec.booking_yield := l_db_lsqv_rec.booking_yield;

Line 1792: IF x_lsqv_rec.booking_yield = FND_API.G_MISS_NUM THEN

1788: END IF;
1789: IF x_lsqv_rec.iir = FND_API.G_MISS_NUM THEN
1790: x_lsqv_rec.iir := l_db_lsqv_rec.iir;
1791: END IF;
1792: IF x_lsqv_rec.booking_yield = FND_API.G_MISS_NUM THEN
1793: x_lsqv_rec.booking_yield := l_db_lsqv_rec.booking_yield;
1794: END IF;
1795: IF x_lsqv_rec.pirr = FND_API.G_MISS_NUM THEN
1796: x_lsqv_rec.pirr := l_db_lsqv_rec.pirr;

Line 1795: IF x_lsqv_rec.pirr = FND_API.G_MISS_NUM THEN

1791: END IF;
1792: IF x_lsqv_rec.booking_yield = FND_API.G_MISS_NUM THEN
1793: x_lsqv_rec.booking_yield := l_db_lsqv_rec.booking_yield;
1794: END IF;
1795: IF x_lsqv_rec.pirr = FND_API.G_MISS_NUM THEN
1796: x_lsqv_rec.pirr := l_db_lsqv_rec.pirr;
1797: END IF;
1798: IF x_lsqv_rec.airr = FND_API.G_MISS_NUM THEN
1799: x_lsqv_rec.airr := l_db_lsqv_rec.airr;

Line 1798: IF x_lsqv_rec.airr = FND_API.G_MISS_NUM THEN

1794: END IF;
1795: IF x_lsqv_rec.pirr = FND_API.G_MISS_NUM THEN
1796: x_lsqv_rec.pirr := l_db_lsqv_rec.pirr;
1797: END IF;
1798: IF x_lsqv_rec.airr = FND_API.G_MISS_NUM THEN
1799: x_lsqv_rec.airr := l_db_lsqv_rec.airr;
1800: END IF;
1801: IF x_lsqv_rec.sub_iir = FND_API.G_MISS_NUM THEN
1802: x_lsqv_rec.sub_iir := l_db_lsqv_rec.sub_iir;

Line 1801: IF x_lsqv_rec.sub_iir = FND_API.G_MISS_NUM THEN

1797: END IF;
1798: IF x_lsqv_rec.airr = FND_API.G_MISS_NUM THEN
1799: x_lsqv_rec.airr := l_db_lsqv_rec.airr;
1800: END IF;
1801: IF x_lsqv_rec.sub_iir = FND_API.G_MISS_NUM THEN
1802: x_lsqv_rec.sub_iir := l_db_lsqv_rec.sub_iir;
1803: END IF;
1804: IF x_lsqv_rec.sub_booking_yield = FND_API.G_MISS_NUM THEN
1805: x_lsqv_rec.sub_booking_yield := l_db_lsqv_rec.sub_booking_yield;

Line 1804: IF x_lsqv_rec.sub_booking_yield = FND_API.G_MISS_NUM THEN

1800: END IF;
1801: IF x_lsqv_rec.sub_iir = FND_API.G_MISS_NUM THEN
1802: x_lsqv_rec.sub_iir := l_db_lsqv_rec.sub_iir;
1803: END IF;
1804: IF x_lsqv_rec.sub_booking_yield = FND_API.G_MISS_NUM THEN
1805: x_lsqv_rec.sub_booking_yield := l_db_lsqv_rec.sub_booking_yield;
1806: END IF;
1807: IF x_lsqv_rec.sub_pirr = FND_API.G_MISS_NUM THEN
1808: x_lsqv_rec.sub_pirr := l_db_lsqv_rec.sub_pirr;

Line 1807: IF x_lsqv_rec.sub_pirr = FND_API.G_MISS_NUM THEN

1803: END IF;
1804: IF x_lsqv_rec.sub_booking_yield = FND_API.G_MISS_NUM THEN
1805: x_lsqv_rec.sub_booking_yield := l_db_lsqv_rec.sub_booking_yield;
1806: END IF;
1807: IF x_lsqv_rec.sub_pirr = FND_API.G_MISS_NUM THEN
1808: x_lsqv_rec.sub_pirr := l_db_lsqv_rec.sub_pirr;
1809: END IF;
1810: IF x_lsqv_rec.sub_airr = FND_API.G_MISS_NUM THEN
1811: x_lsqv_rec.sub_airr := l_db_lsqv_rec.sub_airr;

Line 1810: IF x_lsqv_rec.sub_airr = FND_API.G_MISS_NUM THEN

1806: END IF;
1807: IF x_lsqv_rec.sub_pirr = FND_API.G_MISS_NUM THEN
1808: x_lsqv_rec.sub_pirr := l_db_lsqv_rec.sub_pirr;
1809: END IF;
1810: IF x_lsqv_rec.sub_airr = FND_API.G_MISS_NUM THEN
1811: x_lsqv_rec.sub_airr := l_db_lsqv_rec.sub_airr;
1812: END IF;
1813: IF x_lsqv_rec.usage_category = FND_API.G_MISS_CHAR THEN
1814: x_lsqv_rec.usage_category := l_db_lsqv_rec.usage_category;

Line 1813: IF x_lsqv_rec.usage_category = FND_API.G_MISS_CHAR THEN

1809: END IF;
1810: IF x_lsqv_rec.sub_airr = FND_API.G_MISS_NUM THEN
1811: x_lsqv_rec.sub_airr := l_db_lsqv_rec.sub_airr;
1812: END IF;
1813: IF x_lsqv_rec.usage_category = FND_API.G_MISS_CHAR THEN
1814: x_lsqv_rec.usage_category := l_db_lsqv_rec.usage_category;
1815: END IF;
1816: IF x_lsqv_rec.usage_industry_class = FND_API.G_MISS_CHAR THEN
1817: x_lsqv_rec.usage_industry_class := l_db_lsqv_rec.usage_industry_class;

Line 1816: IF x_lsqv_rec.usage_industry_class = FND_API.G_MISS_CHAR THEN

1812: END IF;
1813: IF x_lsqv_rec.usage_category = FND_API.G_MISS_CHAR THEN
1814: x_lsqv_rec.usage_category := l_db_lsqv_rec.usage_category;
1815: END IF;
1816: IF x_lsqv_rec.usage_industry_class = FND_API.G_MISS_CHAR THEN
1817: x_lsqv_rec.usage_industry_class := l_db_lsqv_rec.usage_industry_class;
1818: END IF;
1819: IF x_lsqv_rec.usage_industry_code = FND_API.G_MISS_CHAR THEN
1820: x_lsqv_rec.usage_industry_code := l_db_lsqv_rec.usage_industry_code;

Line 1819: IF x_lsqv_rec.usage_industry_code = FND_API.G_MISS_CHAR THEN

1815: END IF;
1816: IF x_lsqv_rec.usage_industry_class = FND_API.G_MISS_CHAR THEN
1817: x_lsqv_rec.usage_industry_class := l_db_lsqv_rec.usage_industry_class;
1818: END IF;
1819: IF x_lsqv_rec.usage_industry_code = FND_API.G_MISS_CHAR THEN
1820: x_lsqv_rec.usage_industry_code := l_db_lsqv_rec.usage_industry_code;
1821: END IF;
1822: IF x_lsqv_rec.usage_amount = FND_API.G_MISS_NUM THEN
1823: x_lsqv_rec.usage_amount := l_db_lsqv_rec.usage_amount;

Line 1822: IF x_lsqv_rec.usage_amount = FND_API.G_MISS_NUM THEN

1818: END IF;
1819: IF x_lsqv_rec.usage_industry_code = FND_API.G_MISS_CHAR THEN
1820: x_lsqv_rec.usage_industry_code := l_db_lsqv_rec.usage_industry_code;
1821: END IF;
1822: IF x_lsqv_rec.usage_amount = FND_API.G_MISS_NUM THEN
1823: x_lsqv_rec.usage_amount := l_db_lsqv_rec.usage_amount;
1824: END IF;
1825: IF x_lsqv_rec.usage_location_id = FND_API.G_MISS_NUM THEN
1826: x_lsqv_rec.usage_location_id := l_db_lsqv_rec.usage_location_id;

Line 1825: IF x_lsqv_rec.usage_location_id = FND_API.G_MISS_NUM THEN

1821: END IF;
1822: IF x_lsqv_rec.usage_amount = FND_API.G_MISS_NUM THEN
1823: x_lsqv_rec.usage_amount := l_db_lsqv_rec.usage_amount;
1824: END IF;
1825: IF x_lsqv_rec.usage_location_id = FND_API.G_MISS_NUM THEN
1826: x_lsqv_rec.usage_location_id := l_db_lsqv_rec.usage_location_id;
1827: END IF;
1828: IF x_lsqv_rec.property_tax_applicable = FND_API.G_MISS_CHAR THEN
1829: x_lsqv_rec.property_tax_applicable := l_db_lsqv_rec.property_tax_applicable;

Line 1828: IF x_lsqv_rec.property_tax_applicable = FND_API.G_MISS_CHAR THEN

1824: END IF;
1825: IF x_lsqv_rec.usage_location_id = FND_API.G_MISS_NUM THEN
1826: x_lsqv_rec.usage_location_id := l_db_lsqv_rec.usage_location_id;
1827: END IF;
1828: IF x_lsqv_rec.property_tax_applicable = FND_API.G_MISS_CHAR THEN
1829: x_lsqv_rec.property_tax_applicable := l_db_lsqv_rec.property_tax_applicable;
1830: END IF;
1831: IF x_lsqv_rec.property_tax_billing_type = FND_API.G_MISS_CHAR THEN
1832: x_lsqv_rec.property_tax_billing_type := l_db_lsqv_rec.property_tax_billing_type;

Line 1831: IF x_lsqv_rec.property_tax_billing_type = FND_API.G_MISS_CHAR THEN

1827: END IF;
1828: IF x_lsqv_rec.property_tax_applicable = FND_API.G_MISS_CHAR THEN
1829: x_lsqv_rec.property_tax_applicable := l_db_lsqv_rec.property_tax_applicable;
1830: END IF;
1831: IF x_lsqv_rec.property_tax_billing_type = FND_API.G_MISS_CHAR THEN
1832: x_lsqv_rec.property_tax_billing_type := l_db_lsqv_rec.property_tax_billing_type;
1833: END IF;
1834: IF x_lsqv_rec.upfront_tax_treatment = FND_API.G_MISS_CHAR THEN
1835: x_lsqv_rec.upfront_tax_treatment := l_db_lsqv_rec.upfront_tax_treatment;

Line 1834: IF x_lsqv_rec.upfront_tax_treatment = FND_API.G_MISS_CHAR THEN

1830: END IF;
1831: IF x_lsqv_rec.property_tax_billing_type = FND_API.G_MISS_CHAR THEN
1832: x_lsqv_rec.property_tax_billing_type := l_db_lsqv_rec.property_tax_billing_type;
1833: END IF;
1834: IF x_lsqv_rec.upfront_tax_treatment = FND_API.G_MISS_CHAR THEN
1835: x_lsqv_rec.upfront_tax_treatment := l_db_lsqv_rec.upfront_tax_treatment;
1836: END IF;
1837: IF x_lsqv_rec.upfront_tax_stream_type = FND_API.G_MISS_NUM THEN
1838: x_lsqv_rec.upfront_tax_stream_type := l_db_lsqv_rec.upfront_tax_stream_type;

Line 1837: IF x_lsqv_rec.upfront_tax_stream_type = FND_API.G_MISS_NUM THEN

1833: END IF;
1834: IF x_lsqv_rec.upfront_tax_treatment = FND_API.G_MISS_CHAR THEN
1835: x_lsqv_rec.upfront_tax_treatment := l_db_lsqv_rec.upfront_tax_treatment;
1836: END IF;
1837: IF x_lsqv_rec.upfront_tax_stream_type = FND_API.G_MISS_NUM THEN
1838: x_lsqv_rec.upfront_tax_stream_type := l_db_lsqv_rec.upfront_tax_stream_type;
1839: END IF;
1840: IF x_lsqv_rec.transfer_of_title = FND_API.G_MISS_CHAR THEN
1841: x_lsqv_rec.transfer_of_title := l_db_lsqv_rec.transfer_of_title;

Line 1840: IF x_lsqv_rec.transfer_of_title = FND_API.G_MISS_CHAR THEN

1836: END IF;
1837: IF x_lsqv_rec.upfront_tax_stream_type = FND_API.G_MISS_NUM THEN
1838: x_lsqv_rec.upfront_tax_stream_type := l_db_lsqv_rec.upfront_tax_stream_type;
1839: END IF;
1840: IF x_lsqv_rec.transfer_of_title = FND_API.G_MISS_CHAR THEN
1841: x_lsqv_rec.transfer_of_title := l_db_lsqv_rec.transfer_of_title;
1842: END IF;
1843: IF x_lsqv_rec.age_of_equipment = FND_API.G_MISS_NUM THEN
1844: x_lsqv_rec.age_of_equipment := l_db_lsqv_rec.age_of_equipment;

Line 1843: IF x_lsqv_rec.age_of_equipment = FND_API.G_MISS_NUM THEN

1839: END IF;
1840: IF x_lsqv_rec.transfer_of_title = FND_API.G_MISS_CHAR THEN
1841: x_lsqv_rec.transfer_of_title := l_db_lsqv_rec.transfer_of_title;
1842: END IF;
1843: IF x_lsqv_rec.age_of_equipment = FND_API.G_MISS_NUM THEN
1844: x_lsqv_rec.age_of_equipment := l_db_lsqv_rec.age_of_equipment;
1845: END IF;
1846: IF x_lsqv_rec.purchase_of_lease = FND_API.G_MISS_CHAR THEN
1847: x_lsqv_rec.purchase_of_lease := l_db_lsqv_rec.purchase_of_lease;

Line 1846: IF x_lsqv_rec.purchase_of_lease = FND_API.G_MISS_CHAR THEN

1842: END IF;
1843: IF x_lsqv_rec.age_of_equipment = FND_API.G_MISS_NUM THEN
1844: x_lsqv_rec.age_of_equipment := l_db_lsqv_rec.age_of_equipment;
1845: END IF;
1846: IF x_lsqv_rec.purchase_of_lease = FND_API.G_MISS_CHAR THEN
1847: x_lsqv_rec.purchase_of_lease := l_db_lsqv_rec.purchase_of_lease;
1848: END IF;
1849: IF x_lsqv_rec.sale_and_lease_back = FND_API.G_MISS_CHAR THEN
1850: x_lsqv_rec.sale_and_lease_back := l_db_lsqv_rec.sale_and_lease_back;

Line 1849: IF x_lsqv_rec.sale_and_lease_back = FND_API.G_MISS_CHAR THEN

1845: END IF;
1846: IF x_lsqv_rec.purchase_of_lease = FND_API.G_MISS_CHAR THEN
1847: x_lsqv_rec.purchase_of_lease := l_db_lsqv_rec.purchase_of_lease;
1848: END IF;
1849: IF x_lsqv_rec.sale_and_lease_back = FND_API.G_MISS_CHAR THEN
1850: x_lsqv_rec.sale_and_lease_back := l_db_lsqv_rec.sale_and_lease_back;
1851: END IF;
1852: IF x_lsqv_rec.interest_disclosed = FND_API.G_MISS_CHAR THEN
1853: x_lsqv_rec.interest_disclosed := l_db_lsqv_rec.interest_disclosed;

Line 1852: IF x_lsqv_rec.interest_disclosed = FND_API.G_MISS_CHAR THEN

1848: END IF;
1849: IF x_lsqv_rec.sale_and_lease_back = FND_API.G_MISS_CHAR THEN
1850: x_lsqv_rec.sale_and_lease_back := l_db_lsqv_rec.sale_and_lease_back;
1851: END IF;
1852: IF x_lsqv_rec.interest_disclosed = FND_API.G_MISS_CHAR THEN
1853: x_lsqv_rec.interest_disclosed := l_db_lsqv_rec.interest_disclosed;
1854: END IF;
1855: IF x_lsqv_rec.primary_quote = FND_API.G_MISS_CHAR THEN
1856: x_lsqv_rec.primary_quote := l_db_lsqv_rec.primary_quote;

Line 1855: IF x_lsqv_rec.primary_quote = FND_API.G_MISS_CHAR THEN

1851: END IF;
1852: IF x_lsqv_rec.interest_disclosed = FND_API.G_MISS_CHAR THEN
1853: x_lsqv_rec.interest_disclosed := l_db_lsqv_rec.interest_disclosed;
1854: END IF;
1855: IF x_lsqv_rec.primary_quote = FND_API.G_MISS_CHAR THEN
1856: x_lsqv_rec.primary_quote := l_db_lsqv_rec.primary_quote;
1857: END IF;
1858: --Bug # 5647107
1859: IF x_lsqv_rec.legal_entity_id = FND_API.G_MISS_NUM THEN

Line 1859: IF x_lsqv_rec.legal_entity_id = FND_API.G_MISS_NUM THEN

1855: IF x_lsqv_rec.primary_quote = FND_API.G_MISS_CHAR THEN
1856: x_lsqv_rec.primary_quote := l_db_lsqv_rec.primary_quote;
1857: END IF;
1858: --Bug # 5647107
1859: IF x_lsqv_rec.legal_entity_id = FND_API.G_MISS_NUM THEN
1860: x_lsqv_rec.legal_entity_id := l_db_lsqv_rec.legal_entity_id;
1861: END IF;
1862: --Bug # 5647107
1863: -- Bug 5908845. eBTax Enhancement Project

Line 1864: IF x_lsqv_rec.line_intended_use = FND_API.G_MISS_CHAR THEN

1860: x_lsqv_rec.legal_entity_id := l_db_lsqv_rec.legal_entity_id;
1861: END IF;
1862: --Bug # 5647107
1863: -- Bug 5908845. eBTax Enhancement Project
1864: IF x_lsqv_rec.line_intended_use = FND_API.G_MISS_CHAR THEN
1865: x_lsqv_rec.line_intended_use := l_db_lsqv_rec.line_intended_use;
1866: END IF;
1867: -- End Bug 5908845. eBTax Enhancement Project
1868: IF x_lsqv_rec.short_description = FND_API.G_MISS_CHAR THEN

Line 1868: IF x_lsqv_rec.short_description = FND_API.G_MISS_CHAR THEN

1864: IF x_lsqv_rec.line_intended_use = FND_API.G_MISS_CHAR THEN
1865: x_lsqv_rec.line_intended_use := l_db_lsqv_rec.line_intended_use;
1866: END IF;
1867: -- End Bug 5908845. eBTax Enhancement Project
1868: IF x_lsqv_rec.short_description = FND_API.G_MISS_CHAR THEN
1869: x_lsqv_rec.short_description := l_db_lsqv_rec.short_description;
1870: END IF;
1871: IF x_lsqv_rec.description = FND_API.G_MISS_CHAR THEN
1872: x_lsqv_rec.description := l_db_lsqv_rec.description;

Line 1871: IF x_lsqv_rec.description = FND_API.G_MISS_CHAR THEN

1867: -- End Bug 5908845. eBTax Enhancement Project
1868: IF x_lsqv_rec.short_description = FND_API.G_MISS_CHAR THEN
1869: x_lsqv_rec.short_description := l_db_lsqv_rec.short_description;
1870: END IF;
1871: IF x_lsqv_rec.description = FND_API.G_MISS_CHAR THEN
1872: x_lsqv_rec.description := l_db_lsqv_rec.description;
1873: END IF;
1874: IF x_lsqv_rec.comments = FND_API.G_MISS_CHAR THEN
1875: x_lsqv_rec.comments := l_db_lsqv_rec.comments;

Line 1874: IF x_lsqv_rec.comments = FND_API.G_MISS_CHAR THEN

1870: END IF;
1871: IF x_lsqv_rec.description = FND_API.G_MISS_CHAR THEN
1872: x_lsqv_rec.description := l_db_lsqv_rec.description;
1873: END IF;
1874: IF x_lsqv_rec.comments = FND_API.G_MISS_CHAR THEN
1875: x_lsqv_rec.comments := l_db_lsqv_rec.comments;
1876: END IF;
1877:
1878: RETURN l_return_status;