DBA Data[Home] [Help]

APPS.OKL_LOP_PVT dependencies on FND_API

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 151: IF l_lopv_rec.valid_from = FND_API.G_MISS_DATE THEN

147: END IF;
148: IF l_lopv_rec.status = FND_API.G_MISS_CHAR THEN
149: l_lopv_rec.status := NULL;
150: END IF;
151: IF l_lopv_rec.valid_from = FND_API.G_MISS_DATE THEN
152: l_lopv_rec.valid_from := NULL;
153: END IF;
154: IF l_lopv_rec.expected_start_date = FND_API.G_MISS_DATE THEN
155: l_lopv_rec.expected_start_date := NULL;

Line 154: IF l_lopv_rec.expected_start_date = FND_API.G_MISS_DATE THEN

150: END IF;
151: IF l_lopv_rec.valid_from = FND_API.G_MISS_DATE THEN
152: l_lopv_rec.valid_from := NULL;
153: END IF;
154: IF l_lopv_rec.expected_start_date = FND_API.G_MISS_DATE THEN
155: l_lopv_rec.expected_start_date := NULL;
156: END IF;
157: IF l_lopv_rec.org_id = FND_API.G_MISS_NUM THEN
158: l_lopv_rec.org_id := NULL;

Line 157: IF l_lopv_rec.org_id = FND_API.G_MISS_NUM THEN

153: END IF;
154: IF l_lopv_rec.expected_start_date = FND_API.G_MISS_DATE THEN
155: l_lopv_rec.expected_start_date := NULL;
156: END IF;
157: IF l_lopv_rec.org_id = FND_API.G_MISS_NUM THEN
158: l_lopv_rec.org_id := NULL;
159: END IF;
160: IF l_lopv_rec.inv_org_id = FND_API.G_MISS_NUM THEN
161: l_lopv_rec.inv_org_id := NULL;

Line 160: IF l_lopv_rec.inv_org_id = FND_API.G_MISS_NUM THEN

156: END IF;
157: IF l_lopv_rec.org_id = FND_API.G_MISS_NUM THEN
158: l_lopv_rec.org_id := NULL;
159: END IF;
160: IF l_lopv_rec.inv_org_id = FND_API.G_MISS_NUM THEN
161: l_lopv_rec.inv_org_id := NULL;
162: END IF;
163: IF l_lopv_rec.prospect_id = FND_API.G_MISS_NUM THEN
164: l_lopv_rec.prospect_id := NULL;

Line 163: IF l_lopv_rec.prospect_id = FND_API.G_MISS_NUM THEN

159: END IF;
160: IF l_lopv_rec.inv_org_id = FND_API.G_MISS_NUM THEN
161: l_lopv_rec.inv_org_id := NULL;
162: END IF;
163: IF l_lopv_rec.prospect_id = FND_API.G_MISS_NUM THEN
164: l_lopv_rec.prospect_id := NULL;
165: END IF;
166: IF l_lopv_rec.prospect_address_id = FND_API.G_MISS_NUM THEN
167: l_lopv_rec.prospect_address_id := NULL;

Line 166: IF l_lopv_rec.prospect_address_id = FND_API.G_MISS_NUM THEN

162: END IF;
163: IF l_lopv_rec.prospect_id = FND_API.G_MISS_NUM THEN
164: l_lopv_rec.prospect_id := NULL;
165: END IF;
166: IF l_lopv_rec.prospect_address_id = FND_API.G_MISS_NUM THEN
167: l_lopv_rec.prospect_address_id := NULL;
168: END IF;
169: IF l_lopv_rec.cust_acct_id = FND_API.G_MISS_NUM THEN
170: l_lopv_rec.cust_acct_id := NULL;

Line 169: IF l_lopv_rec.cust_acct_id = FND_API.G_MISS_NUM THEN

165: END IF;
166: IF l_lopv_rec.prospect_address_id = FND_API.G_MISS_NUM THEN
167: l_lopv_rec.prospect_address_id := NULL;
168: END IF;
169: IF l_lopv_rec.cust_acct_id = FND_API.G_MISS_NUM THEN
170: l_lopv_rec.cust_acct_id := NULL;
171: END IF;
172: IF l_lopv_rec.currency_code = FND_API.G_MISS_CHAR THEN
173: l_lopv_rec.currency_code := NULL;

Line 172: IF l_lopv_rec.currency_code = FND_API.G_MISS_CHAR THEN

168: END IF;
169: IF l_lopv_rec.cust_acct_id = FND_API.G_MISS_NUM THEN
170: l_lopv_rec.cust_acct_id := NULL;
171: END IF;
172: IF l_lopv_rec.currency_code = FND_API.G_MISS_CHAR THEN
173: l_lopv_rec.currency_code := NULL;
174: END IF;
175: IF l_lopv_rec.currency_conversion_type = FND_API.G_MISS_CHAR THEN
176: l_lopv_rec.currency_conversion_type := NULL;

Line 175: IF l_lopv_rec.currency_conversion_type = FND_API.G_MISS_CHAR THEN

171: END IF;
172: IF l_lopv_rec.currency_code = FND_API.G_MISS_CHAR THEN
173: l_lopv_rec.currency_code := NULL;
174: END IF;
175: IF l_lopv_rec.currency_conversion_type = FND_API.G_MISS_CHAR THEN
176: l_lopv_rec.currency_conversion_type := NULL;
177: END IF;
178: IF l_lopv_rec.currency_conversion_rate = FND_API.G_MISS_NUM THEN
179: l_lopv_rec.currency_conversion_rate := NULL;

Line 178: IF l_lopv_rec.currency_conversion_rate = FND_API.G_MISS_NUM THEN

174: END IF;
175: IF l_lopv_rec.currency_conversion_type = FND_API.G_MISS_CHAR THEN
176: l_lopv_rec.currency_conversion_type := NULL;
177: END IF;
178: IF l_lopv_rec.currency_conversion_rate = FND_API.G_MISS_NUM THEN
179: l_lopv_rec.currency_conversion_rate := NULL;
180: END IF;
181: IF l_lopv_rec.currency_conversion_date = FND_API.G_MISS_DATE THEN
182: l_lopv_rec.currency_conversion_date := NULL;

Line 181: IF l_lopv_rec.currency_conversion_date = FND_API.G_MISS_DATE THEN

177: END IF;
178: IF l_lopv_rec.currency_conversion_rate = FND_API.G_MISS_NUM THEN
179: l_lopv_rec.currency_conversion_rate := NULL;
180: END IF;
181: IF l_lopv_rec.currency_conversion_date = FND_API.G_MISS_DATE THEN
182: l_lopv_rec.currency_conversion_date := NULL;
183: END IF;
184: IF l_lopv_rec.program_agreement_id = FND_API.G_MISS_NUM THEN
185: l_lopv_rec.program_agreement_id := NULL;

Line 184: IF l_lopv_rec.program_agreement_id = FND_API.G_MISS_NUM THEN

180: END IF;
181: IF l_lopv_rec.currency_conversion_date = FND_API.G_MISS_DATE THEN
182: l_lopv_rec.currency_conversion_date := NULL;
183: END IF;
184: IF l_lopv_rec.program_agreement_id = FND_API.G_MISS_NUM THEN
185: l_lopv_rec.program_agreement_id := NULL;
186: END IF;
187: IF l_lopv_rec.master_lease_id = FND_API.G_MISS_NUM THEN
188: l_lopv_rec.master_lease_id := NULL;

Line 187: IF l_lopv_rec.master_lease_id = FND_API.G_MISS_NUM THEN

183: END IF;
184: IF l_lopv_rec.program_agreement_id = FND_API.G_MISS_NUM THEN
185: l_lopv_rec.program_agreement_id := NULL;
186: END IF;
187: IF l_lopv_rec.master_lease_id = FND_API.G_MISS_NUM THEN
188: l_lopv_rec.master_lease_id := NULL;
189: END IF;
190: IF l_lopv_rec.sales_rep_id = FND_API.G_MISS_NUM THEN
191: l_lopv_rec.sales_rep_id := NULL;

Line 190: IF l_lopv_rec.sales_rep_id = FND_API.G_MISS_NUM THEN

186: END IF;
187: IF l_lopv_rec.master_lease_id = FND_API.G_MISS_NUM THEN
188: l_lopv_rec.master_lease_id := NULL;
189: END IF;
190: IF l_lopv_rec.sales_rep_id = FND_API.G_MISS_NUM THEN
191: l_lopv_rec.sales_rep_id := NULL;
192: END IF;
193: IF l_lopv_rec.sales_territory_id = FND_API.G_MISS_NUM THEN
194: l_lopv_rec.sales_territory_id := NULL;

Line 193: IF l_lopv_rec.sales_territory_id = FND_API.G_MISS_NUM THEN

189: END IF;
190: IF l_lopv_rec.sales_rep_id = FND_API.G_MISS_NUM THEN
191: l_lopv_rec.sales_rep_id := NULL;
192: END IF;
193: IF l_lopv_rec.sales_territory_id = FND_API.G_MISS_NUM THEN
194: l_lopv_rec.sales_territory_id := NULL;
195: END IF;
196: IF l_lopv_rec.supplier_id = FND_API.G_MISS_NUM THEN
197: l_lopv_rec.supplier_id := NULL;

Line 196: IF l_lopv_rec.supplier_id = FND_API.G_MISS_NUM THEN

192: END IF;
193: IF l_lopv_rec.sales_territory_id = FND_API.G_MISS_NUM THEN
194: l_lopv_rec.sales_territory_id := NULL;
195: END IF;
196: IF l_lopv_rec.supplier_id = FND_API.G_MISS_NUM THEN
197: l_lopv_rec.supplier_id := NULL;
198: END IF;
199: IF l_lopv_rec.delivery_date = FND_API.G_MISS_DATE THEN
200: l_lopv_rec.delivery_date := NULL;

Line 199: IF l_lopv_rec.delivery_date = FND_API.G_MISS_DATE THEN

195: END IF;
196: IF l_lopv_rec.supplier_id = FND_API.G_MISS_NUM THEN
197: l_lopv_rec.supplier_id := NULL;
198: END IF;
199: IF l_lopv_rec.delivery_date = FND_API.G_MISS_DATE THEN
200: l_lopv_rec.delivery_date := NULL;
201: END IF;
202: IF l_lopv_rec.funding_date = FND_API.G_MISS_DATE THEN
203: l_lopv_rec.funding_date := NULL;

Line 202: IF l_lopv_rec.funding_date = FND_API.G_MISS_DATE THEN

198: END IF;
199: IF l_lopv_rec.delivery_date = FND_API.G_MISS_DATE THEN
200: l_lopv_rec.delivery_date := NULL;
201: END IF;
202: IF l_lopv_rec.funding_date = FND_API.G_MISS_DATE THEN
203: l_lopv_rec.funding_date := NULL;
204: END IF;
205: IF l_lopv_rec.property_tax_applicable = FND_API.G_MISS_CHAR THEN
206: l_lopv_rec.property_tax_applicable := NULL;

Line 205: IF l_lopv_rec.property_tax_applicable = FND_API.G_MISS_CHAR THEN

201: END IF;
202: IF l_lopv_rec.funding_date = FND_API.G_MISS_DATE THEN
203: l_lopv_rec.funding_date := NULL;
204: END IF;
205: IF l_lopv_rec.property_tax_applicable = FND_API.G_MISS_CHAR THEN
206: l_lopv_rec.property_tax_applicable := NULL;
207: END IF;
208: IF l_lopv_rec.property_tax_billing_type = FND_API.G_MISS_CHAR THEN
209: l_lopv_rec.property_tax_billing_type := NULL;

Line 208: IF l_lopv_rec.property_tax_billing_type = FND_API.G_MISS_CHAR THEN

204: END IF;
205: IF l_lopv_rec.property_tax_applicable = FND_API.G_MISS_CHAR THEN
206: l_lopv_rec.property_tax_applicable := NULL;
207: END IF;
208: IF l_lopv_rec.property_tax_billing_type = FND_API.G_MISS_CHAR THEN
209: l_lopv_rec.property_tax_billing_type := NULL;
210: END IF;
211: IF l_lopv_rec.upfront_tax_treatment = FND_API.G_MISS_CHAR THEN
212: l_lopv_rec.upfront_tax_treatment := NULL;

Line 211: IF l_lopv_rec.upfront_tax_treatment = FND_API.G_MISS_CHAR THEN

207: END IF;
208: IF l_lopv_rec.property_tax_billing_type = FND_API.G_MISS_CHAR THEN
209: l_lopv_rec.property_tax_billing_type := NULL;
210: END IF;
211: IF l_lopv_rec.upfront_tax_treatment = FND_API.G_MISS_CHAR THEN
212: l_lopv_rec.upfront_tax_treatment := NULL;
213: END IF;
214: IF l_lopv_rec.install_site_id = FND_API.G_MISS_NUM THEN
215: l_lopv_rec.install_site_id := NULL;

Line 214: IF l_lopv_rec.install_site_id = FND_API.G_MISS_NUM THEN

210: END IF;
211: IF l_lopv_rec.upfront_tax_treatment = FND_API.G_MISS_CHAR THEN
212: l_lopv_rec.upfront_tax_treatment := NULL;
213: END IF;
214: IF l_lopv_rec.install_site_id = FND_API.G_MISS_NUM THEN
215: l_lopv_rec.install_site_id := NULL;
216: END IF;
217: IF l_lopv_rec.usage_category = FND_API.G_MISS_CHAR THEN
218: l_lopv_rec.usage_category := NULL;

Line 217: IF l_lopv_rec.usage_category = FND_API.G_MISS_CHAR THEN

213: END IF;
214: IF l_lopv_rec.install_site_id = FND_API.G_MISS_NUM THEN
215: l_lopv_rec.install_site_id := NULL;
216: END IF;
217: IF l_lopv_rec.usage_category = FND_API.G_MISS_CHAR THEN
218: l_lopv_rec.usage_category := NULL;
219: END IF;
220: IF l_lopv_rec.usage_industry_class = FND_API.G_MISS_CHAR THEN
221: l_lopv_rec.usage_industry_class := NULL;

Line 220: IF l_lopv_rec.usage_industry_class = FND_API.G_MISS_CHAR THEN

216: END IF;
217: IF l_lopv_rec.usage_category = FND_API.G_MISS_CHAR THEN
218: l_lopv_rec.usage_category := NULL;
219: END IF;
220: IF l_lopv_rec.usage_industry_class = FND_API.G_MISS_CHAR THEN
221: l_lopv_rec.usage_industry_class := NULL;
222: END IF;
223: IF l_lopv_rec.usage_industry_code = FND_API.G_MISS_CHAR THEN
224: l_lopv_rec.usage_industry_code := NULL;

Line 223: IF l_lopv_rec.usage_industry_code = FND_API.G_MISS_CHAR THEN

219: END IF;
220: IF l_lopv_rec.usage_industry_class = FND_API.G_MISS_CHAR THEN
221: l_lopv_rec.usage_industry_class := NULL;
222: END IF;
223: IF l_lopv_rec.usage_industry_code = FND_API.G_MISS_CHAR THEN
224: l_lopv_rec.usage_industry_code := NULL;
225: END IF;
226: IF l_lopv_rec.usage_amount = FND_API.G_MISS_NUM THEN
227: l_lopv_rec.usage_amount := NULL;

Line 226: IF l_lopv_rec.usage_amount = FND_API.G_MISS_NUM THEN

222: END IF;
223: IF l_lopv_rec.usage_industry_code = FND_API.G_MISS_CHAR THEN
224: l_lopv_rec.usage_industry_code := NULL;
225: END IF;
226: IF l_lopv_rec.usage_amount = FND_API.G_MISS_NUM THEN
227: l_lopv_rec.usage_amount := NULL;
228: END IF;
229: IF l_lopv_rec.usage_location_id = FND_API.G_MISS_NUM THEN
230: l_lopv_rec.usage_location_id := NULL;

Line 229: IF l_lopv_rec.usage_location_id = FND_API.G_MISS_NUM THEN

225: END IF;
226: IF l_lopv_rec.usage_amount = FND_API.G_MISS_NUM THEN
227: l_lopv_rec.usage_amount := NULL;
228: END IF;
229: IF l_lopv_rec.usage_location_id = FND_API.G_MISS_NUM THEN
230: l_lopv_rec.usage_location_id := NULL;
231: END IF;
232: IF l_lopv_rec.originating_vendor_id = FND_API.G_MISS_NUM THEN
233: l_lopv_rec.originating_vendor_id := NULL;

Line 232: IF l_lopv_rec.originating_vendor_id = FND_API.G_MISS_NUM THEN

228: END IF;
229: IF l_lopv_rec.usage_location_id = FND_API.G_MISS_NUM THEN
230: l_lopv_rec.usage_location_id := NULL;
231: END IF;
232: IF l_lopv_rec.originating_vendor_id = FND_API.G_MISS_NUM THEN
233: l_lopv_rec.originating_vendor_id := NULL;
234: END IF;
235: --Bug # 5647107
236: IF l_lopv_rec.legal_entity_id = FND_API.G_MISS_NUM THEN

Line 236: IF l_lopv_rec.legal_entity_id = FND_API.G_MISS_NUM THEN

232: IF l_lopv_rec.originating_vendor_id = FND_API.G_MISS_NUM THEN
233: l_lopv_rec.originating_vendor_id := NULL;
234: END IF;
235: --Bug # 5647107
236: IF l_lopv_rec.legal_entity_id = FND_API.G_MISS_NUM THEN
237: l_lopv_rec.legal_entity_id := NULL;
238: END IF;
239: --Bug # 5647107
240: -- Bug 5908845. eBTax Enhancement Project

Line 241: IF l_lopv_rec.line_intended_use = FND_API.G_MISS_CHAR THEN

237: l_lopv_rec.legal_entity_id := NULL;
238: END IF;
239: --Bug # 5647107
240: -- Bug 5908845. eBTax Enhancement Project
241: IF l_lopv_rec.line_intended_use = FND_API.G_MISS_CHAR THEN
242: l_lopv_rec.line_intended_use := NULL;
243: END IF;
244: -- End Bug 5908845. eBTax Enhancement Project
245: IF l_lopv_rec.short_description = FND_API.G_MISS_CHAR THEN

Line 245: IF l_lopv_rec.short_description = FND_API.G_MISS_CHAR THEN

241: IF l_lopv_rec.line_intended_use = FND_API.G_MISS_CHAR THEN
242: l_lopv_rec.line_intended_use := NULL;
243: END IF;
244: -- End Bug 5908845. eBTax Enhancement Project
245: IF l_lopv_rec.short_description = FND_API.G_MISS_CHAR THEN
246: l_lopv_rec.short_description := NULL;
247: END IF;
248: IF l_lopv_rec.description = FND_API.G_MISS_CHAR THEN
249: l_lopv_rec.description := NULL;

Line 248: IF l_lopv_rec.description = FND_API.G_MISS_CHAR THEN

244: -- End Bug 5908845. eBTax Enhancement Project
245: IF l_lopv_rec.short_description = FND_API.G_MISS_CHAR THEN
246: l_lopv_rec.short_description := NULL;
247: END IF;
248: IF l_lopv_rec.description = FND_API.G_MISS_CHAR THEN
249: l_lopv_rec.description := NULL;
250: END IF;
251: IF l_lopv_rec.comments = FND_API.G_MISS_CHAR THEN
252: l_lopv_rec.comments := NULL;

Line 251: IF l_lopv_rec.comments = FND_API.G_MISS_CHAR THEN

247: END IF;
248: IF l_lopv_rec.description = FND_API.G_MISS_CHAR THEN
249: l_lopv_rec.description := NULL;
250: END IF;
251: IF l_lopv_rec.comments = FND_API.G_MISS_CHAR THEN
252: l_lopv_rec.comments := NULL;
253: END IF;
254:
255: RETURN l_lopv_rec;

Line 1496: IF x_lopv_rec.attribute_category = FND_API.G_MISS_CHAR THEN

1492: ELSIF l_return_status = G_RET_STS_ERROR THEN
1493: RAISE OKL_API.G_EXCEPTION_ERROR;
1494: END IF;
1495:
1496: IF x_lopv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1497: x_lopv_rec.attribute_category := l_db_lopv_rec.attribute_category;
1498: END IF;
1499: IF x_lopv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1500: x_lopv_rec.attribute1 := l_db_lopv_rec.attribute1;

Line 1499: IF x_lopv_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1495:
1496: IF x_lopv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1497: x_lopv_rec.attribute_category := l_db_lopv_rec.attribute_category;
1498: END IF;
1499: IF x_lopv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1500: x_lopv_rec.attribute1 := l_db_lopv_rec.attribute1;
1501: END IF;
1502: IF x_lopv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1503: x_lopv_rec.attribute2 := l_db_lopv_rec.attribute2;

Line 1502: IF x_lopv_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1498: END IF;
1499: IF x_lopv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1500: x_lopv_rec.attribute1 := l_db_lopv_rec.attribute1;
1501: END IF;
1502: IF x_lopv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1503: x_lopv_rec.attribute2 := l_db_lopv_rec.attribute2;
1504: END IF;
1505: IF x_lopv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1506: x_lopv_rec.attribute3 := l_db_lopv_rec.attribute3;

Line 1505: IF x_lopv_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1501: END IF;
1502: IF x_lopv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1503: x_lopv_rec.attribute2 := l_db_lopv_rec.attribute2;
1504: END IF;
1505: IF x_lopv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1506: x_lopv_rec.attribute3 := l_db_lopv_rec.attribute3;
1507: END IF;
1508: IF x_lopv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1509: x_lopv_rec.attribute4 := l_db_lopv_rec.attribute4;

Line 1508: IF x_lopv_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1504: END IF;
1505: IF x_lopv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1506: x_lopv_rec.attribute3 := l_db_lopv_rec.attribute3;
1507: END IF;
1508: IF x_lopv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1509: x_lopv_rec.attribute4 := l_db_lopv_rec.attribute4;
1510: END IF;
1511: IF x_lopv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1512: x_lopv_rec.attribute5 := l_db_lopv_rec.attribute5;

Line 1511: IF x_lopv_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1507: END IF;
1508: IF x_lopv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1509: x_lopv_rec.attribute4 := l_db_lopv_rec.attribute4;
1510: END IF;
1511: IF x_lopv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1512: x_lopv_rec.attribute5 := l_db_lopv_rec.attribute5;
1513: END IF;
1514: IF x_lopv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1515: x_lopv_rec.attribute6 := l_db_lopv_rec.attribute6;

Line 1514: IF x_lopv_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1510: END IF;
1511: IF x_lopv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1512: x_lopv_rec.attribute5 := l_db_lopv_rec.attribute5;
1513: END IF;
1514: IF x_lopv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1515: x_lopv_rec.attribute6 := l_db_lopv_rec.attribute6;
1516: END IF;
1517: IF x_lopv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1518: x_lopv_rec.attribute7 := l_db_lopv_rec.attribute7;

Line 1517: IF x_lopv_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1513: END IF;
1514: IF x_lopv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1515: x_lopv_rec.attribute6 := l_db_lopv_rec.attribute6;
1516: END IF;
1517: IF x_lopv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1518: x_lopv_rec.attribute7 := l_db_lopv_rec.attribute7;
1519: END IF;
1520: IF x_lopv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1521: x_lopv_rec.attribute8 := l_db_lopv_rec.attribute8;

Line 1520: IF x_lopv_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1516: END IF;
1517: IF x_lopv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1518: x_lopv_rec.attribute7 := l_db_lopv_rec.attribute7;
1519: END IF;
1520: IF x_lopv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1521: x_lopv_rec.attribute8 := l_db_lopv_rec.attribute8;
1522: END IF;
1523: IF x_lopv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1524: x_lopv_rec.attribute9 := l_db_lopv_rec.attribute9;

Line 1523: IF x_lopv_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1519: END IF;
1520: IF x_lopv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1521: x_lopv_rec.attribute8 := l_db_lopv_rec.attribute8;
1522: END IF;
1523: IF x_lopv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1524: x_lopv_rec.attribute9 := l_db_lopv_rec.attribute9;
1525: END IF;
1526: IF x_lopv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1527: x_lopv_rec.attribute10 := l_db_lopv_rec.attribute10;

Line 1526: IF x_lopv_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1522: END IF;
1523: IF x_lopv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1524: x_lopv_rec.attribute9 := l_db_lopv_rec.attribute9;
1525: END IF;
1526: IF x_lopv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1527: x_lopv_rec.attribute10 := l_db_lopv_rec.attribute10;
1528: END IF;
1529: IF x_lopv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1530: x_lopv_rec.attribute11 := l_db_lopv_rec.attribute11;

Line 1529: IF x_lopv_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1525: END IF;
1526: IF x_lopv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1527: x_lopv_rec.attribute10 := l_db_lopv_rec.attribute10;
1528: END IF;
1529: IF x_lopv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1530: x_lopv_rec.attribute11 := l_db_lopv_rec.attribute11;
1531: END IF;
1532: IF x_lopv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1533: x_lopv_rec.attribute12 := l_db_lopv_rec.attribute12;

Line 1532: IF x_lopv_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1528: END IF;
1529: IF x_lopv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1530: x_lopv_rec.attribute11 := l_db_lopv_rec.attribute11;
1531: END IF;
1532: IF x_lopv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1533: x_lopv_rec.attribute12 := l_db_lopv_rec.attribute12;
1534: END IF;
1535: IF x_lopv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1536: x_lopv_rec.attribute13 := l_db_lopv_rec.attribute13;

Line 1535: IF x_lopv_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1531: END IF;
1532: IF x_lopv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1533: x_lopv_rec.attribute12 := l_db_lopv_rec.attribute12;
1534: END IF;
1535: IF x_lopv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1536: x_lopv_rec.attribute13 := l_db_lopv_rec.attribute13;
1537: END IF;
1538: IF x_lopv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1539: x_lopv_rec.attribute14 := l_db_lopv_rec.attribute14;

Line 1538: IF x_lopv_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1534: END IF;
1535: IF x_lopv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1536: x_lopv_rec.attribute13 := l_db_lopv_rec.attribute13;
1537: END IF;
1538: IF x_lopv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1539: x_lopv_rec.attribute14 := l_db_lopv_rec.attribute14;
1540: END IF;
1541: IF x_lopv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1542: x_lopv_rec.attribute15 := l_db_lopv_rec.attribute15;

Line 1541: IF x_lopv_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1537: END IF;
1538: IF x_lopv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1539: x_lopv_rec.attribute14 := l_db_lopv_rec.attribute14;
1540: END IF;
1541: IF x_lopv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1542: x_lopv_rec.attribute15 := l_db_lopv_rec.attribute15;
1543: END IF;
1544: IF x_lopv_rec.reference_number = FND_API.G_MISS_CHAR THEN
1545: x_lopv_rec.reference_number := l_db_lopv_rec.reference_number;

Line 1544: IF x_lopv_rec.reference_number = FND_API.G_MISS_CHAR THEN

1540: END IF;
1541: IF x_lopv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1542: x_lopv_rec.attribute15 := l_db_lopv_rec.attribute15;
1543: END IF;
1544: IF x_lopv_rec.reference_number = FND_API.G_MISS_CHAR THEN
1545: x_lopv_rec.reference_number := l_db_lopv_rec.reference_number;
1546: END IF;
1547: IF x_lopv_rec.status = FND_API.G_MISS_CHAR THEN
1548: x_lopv_rec.status := l_db_lopv_rec.status;

Line 1547: IF x_lopv_rec.status = FND_API.G_MISS_CHAR THEN

1543: END IF;
1544: IF x_lopv_rec.reference_number = FND_API.G_MISS_CHAR THEN
1545: x_lopv_rec.reference_number := l_db_lopv_rec.reference_number;
1546: END IF;
1547: IF x_lopv_rec.status = FND_API.G_MISS_CHAR THEN
1548: x_lopv_rec.status := l_db_lopv_rec.status;
1549: END IF;
1550: IF x_lopv_rec.valid_from = FND_API.G_MISS_DATE THEN
1551: x_lopv_rec.valid_from := l_db_lopv_rec.valid_from;

Line 1550: IF x_lopv_rec.valid_from = FND_API.G_MISS_DATE THEN

1546: END IF;
1547: IF x_lopv_rec.status = FND_API.G_MISS_CHAR THEN
1548: x_lopv_rec.status := l_db_lopv_rec.status;
1549: END IF;
1550: IF x_lopv_rec.valid_from = FND_API.G_MISS_DATE THEN
1551: x_lopv_rec.valid_from := l_db_lopv_rec.valid_from;
1552: END IF;
1553: IF x_lopv_rec.expected_start_date = FND_API.G_MISS_DATE THEN
1554: x_lopv_rec.expected_start_date := l_db_lopv_rec.expected_start_date;

Line 1553: IF x_lopv_rec.expected_start_date = FND_API.G_MISS_DATE THEN

1549: END IF;
1550: IF x_lopv_rec.valid_from = FND_API.G_MISS_DATE THEN
1551: x_lopv_rec.valid_from := l_db_lopv_rec.valid_from;
1552: END IF;
1553: IF x_lopv_rec.expected_start_date = FND_API.G_MISS_DATE THEN
1554: x_lopv_rec.expected_start_date := l_db_lopv_rec.expected_start_date;
1555: END IF;
1556: IF x_lopv_rec.org_id = FND_API.G_MISS_NUM THEN
1557: x_lopv_rec.org_id := l_db_lopv_rec.org_id;

Line 1556: IF x_lopv_rec.org_id = FND_API.G_MISS_NUM THEN

1552: END IF;
1553: IF x_lopv_rec.expected_start_date = FND_API.G_MISS_DATE THEN
1554: x_lopv_rec.expected_start_date := l_db_lopv_rec.expected_start_date;
1555: END IF;
1556: IF x_lopv_rec.org_id = FND_API.G_MISS_NUM THEN
1557: x_lopv_rec.org_id := l_db_lopv_rec.org_id;
1558: END IF;
1559: IF x_lopv_rec.inv_org_id = FND_API.G_MISS_NUM THEN
1560: x_lopv_rec.inv_org_id := l_db_lopv_rec.inv_org_id;

Line 1559: IF x_lopv_rec.inv_org_id = FND_API.G_MISS_NUM THEN

1555: END IF;
1556: IF x_lopv_rec.org_id = FND_API.G_MISS_NUM THEN
1557: x_lopv_rec.org_id := l_db_lopv_rec.org_id;
1558: END IF;
1559: IF x_lopv_rec.inv_org_id = FND_API.G_MISS_NUM THEN
1560: x_lopv_rec.inv_org_id := l_db_lopv_rec.inv_org_id;
1561: END IF;
1562: IF x_lopv_rec.prospect_id = FND_API.G_MISS_NUM THEN
1563: x_lopv_rec.prospect_id := l_db_lopv_rec.prospect_id;

Line 1562: IF x_lopv_rec.prospect_id = FND_API.G_MISS_NUM THEN

1558: END IF;
1559: IF x_lopv_rec.inv_org_id = FND_API.G_MISS_NUM THEN
1560: x_lopv_rec.inv_org_id := l_db_lopv_rec.inv_org_id;
1561: END IF;
1562: IF x_lopv_rec.prospect_id = FND_API.G_MISS_NUM THEN
1563: x_lopv_rec.prospect_id := l_db_lopv_rec.prospect_id;
1564: END IF;
1565: IF x_lopv_rec.prospect_address_id = FND_API.G_MISS_NUM THEN
1566: x_lopv_rec.prospect_address_id := l_db_lopv_rec.prospect_address_id;

Line 1565: IF x_lopv_rec.prospect_address_id = FND_API.G_MISS_NUM THEN

1561: END IF;
1562: IF x_lopv_rec.prospect_id = FND_API.G_MISS_NUM THEN
1563: x_lopv_rec.prospect_id := l_db_lopv_rec.prospect_id;
1564: END IF;
1565: IF x_lopv_rec.prospect_address_id = FND_API.G_MISS_NUM THEN
1566: x_lopv_rec.prospect_address_id := l_db_lopv_rec.prospect_address_id;
1567: END IF;
1568: IF x_lopv_rec.cust_acct_id = FND_API.G_MISS_NUM THEN
1569: x_lopv_rec.cust_acct_id := l_db_lopv_rec.cust_acct_id;

Line 1568: IF x_lopv_rec.cust_acct_id = FND_API.G_MISS_NUM THEN

1564: END IF;
1565: IF x_lopv_rec.prospect_address_id = FND_API.G_MISS_NUM THEN
1566: x_lopv_rec.prospect_address_id := l_db_lopv_rec.prospect_address_id;
1567: END IF;
1568: IF x_lopv_rec.cust_acct_id = FND_API.G_MISS_NUM THEN
1569: x_lopv_rec.cust_acct_id := l_db_lopv_rec.cust_acct_id;
1570: END IF;
1571: IF x_lopv_rec.currency_code = FND_API.G_MISS_CHAR THEN
1572: x_lopv_rec.currency_code := l_db_lopv_rec.currency_code;

Line 1571: IF x_lopv_rec.currency_code = FND_API.G_MISS_CHAR THEN

1567: END IF;
1568: IF x_lopv_rec.cust_acct_id = FND_API.G_MISS_NUM THEN
1569: x_lopv_rec.cust_acct_id := l_db_lopv_rec.cust_acct_id;
1570: END IF;
1571: IF x_lopv_rec.currency_code = FND_API.G_MISS_CHAR THEN
1572: x_lopv_rec.currency_code := l_db_lopv_rec.currency_code;
1573: END IF;
1574: IF x_lopv_rec.currency_conversion_type = FND_API.G_MISS_CHAR THEN
1575: x_lopv_rec.currency_conversion_type := l_db_lopv_rec.currency_conversion_type;

Line 1574: IF x_lopv_rec.currency_conversion_type = FND_API.G_MISS_CHAR THEN

1570: END IF;
1571: IF x_lopv_rec.currency_code = FND_API.G_MISS_CHAR THEN
1572: x_lopv_rec.currency_code := l_db_lopv_rec.currency_code;
1573: END IF;
1574: IF x_lopv_rec.currency_conversion_type = FND_API.G_MISS_CHAR THEN
1575: x_lopv_rec.currency_conversion_type := l_db_lopv_rec.currency_conversion_type;
1576: END IF;
1577: IF x_lopv_rec.currency_conversion_rate = FND_API.G_MISS_NUM THEN
1578: x_lopv_rec.currency_conversion_rate := l_db_lopv_rec.currency_conversion_rate;

Line 1577: IF x_lopv_rec.currency_conversion_rate = FND_API.G_MISS_NUM THEN

1573: END IF;
1574: IF x_lopv_rec.currency_conversion_type = FND_API.G_MISS_CHAR THEN
1575: x_lopv_rec.currency_conversion_type := l_db_lopv_rec.currency_conversion_type;
1576: END IF;
1577: IF x_lopv_rec.currency_conversion_rate = FND_API.G_MISS_NUM THEN
1578: x_lopv_rec.currency_conversion_rate := l_db_lopv_rec.currency_conversion_rate;
1579: END IF;
1580: IF x_lopv_rec.currency_conversion_date = FND_API.G_MISS_DATE THEN
1581: x_lopv_rec.currency_conversion_date := l_db_lopv_rec.currency_conversion_date;

Line 1580: IF x_lopv_rec.currency_conversion_date = FND_API.G_MISS_DATE THEN

1576: END IF;
1577: IF x_lopv_rec.currency_conversion_rate = FND_API.G_MISS_NUM THEN
1578: x_lopv_rec.currency_conversion_rate := l_db_lopv_rec.currency_conversion_rate;
1579: END IF;
1580: IF x_lopv_rec.currency_conversion_date = FND_API.G_MISS_DATE THEN
1581: x_lopv_rec.currency_conversion_date := l_db_lopv_rec.currency_conversion_date;
1582: END IF;
1583: IF x_lopv_rec.program_agreement_id = FND_API.G_MISS_NUM THEN
1584: x_lopv_rec.program_agreement_id := l_db_lopv_rec.program_agreement_id;

Line 1583: IF x_lopv_rec.program_agreement_id = FND_API.G_MISS_NUM THEN

1579: END IF;
1580: IF x_lopv_rec.currency_conversion_date = FND_API.G_MISS_DATE THEN
1581: x_lopv_rec.currency_conversion_date := l_db_lopv_rec.currency_conversion_date;
1582: END IF;
1583: IF x_lopv_rec.program_agreement_id = FND_API.G_MISS_NUM THEN
1584: x_lopv_rec.program_agreement_id := l_db_lopv_rec.program_agreement_id;
1585: END IF;
1586: IF x_lopv_rec.master_lease_id = FND_API.G_MISS_NUM THEN
1587: x_lopv_rec.master_lease_id := l_db_lopv_rec.master_lease_id;

Line 1586: IF x_lopv_rec.master_lease_id = FND_API.G_MISS_NUM THEN

1582: END IF;
1583: IF x_lopv_rec.program_agreement_id = FND_API.G_MISS_NUM THEN
1584: x_lopv_rec.program_agreement_id := l_db_lopv_rec.program_agreement_id;
1585: END IF;
1586: IF x_lopv_rec.master_lease_id = FND_API.G_MISS_NUM THEN
1587: x_lopv_rec.master_lease_id := l_db_lopv_rec.master_lease_id;
1588: END IF;
1589: IF x_lopv_rec.sales_rep_id = FND_API.G_MISS_NUM THEN
1590: x_lopv_rec.sales_rep_id := l_db_lopv_rec.sales_rep_id;

Line 1589: IF x_lopv_rec.sales_rep_id = FND_API.G_MISS_NUM THEN

1585: END IF;
1586: IF x_lopv_rec.master_lease_id = FND_API.G_MISS_NUM THEN
1587: x_lopv_rec.master_lease_id := l_db_lopv_rec.master_lease_id;
1588: END IF;
1589: IF x_lopv_rec.sales_rep_id = FND_API.G_MISS_NUM THEN
1590: x_lopv_rec.sales_rep_id := l_db_lopv_rec.sales_rep_id;
1591: END IF;
1592: IF x_lopv_rec.sales_territory_id = FND_API.G_MISS_NUM THEN
1593: x_lopv_rec.sales_territory_id := l_db_lopv_rec.sales_territory_id;

Line 1592: IF x_lopv_rec.sales_territory_id = FND_API.G_MISS_NUM THEN

1588: END IF;
1589: IF x_lopv_rec.sales_rep_id = FND_API.G_MISS_NUM THEN
1590: x_lopv_rec.sales_rep_id := l_db_lopv_rec.sales_rep_id;
1591: END IF;
1592: IF x_lopv_rec.sales_territory_id = FND_API.G_MISS_NUM THEN
1593: x_lopv_rec.sales_territory_id := l_db_lopv_rec.sales_territory_id;
1594: END IF;
1595: IF x_lopv_rec.supplier_id = FND_API.G_MISS_NUM THEN
1596: x_lopv_rec.supplier_id := l_db_lopv_rec.supplier_id;

Line 1595: IF x_lopv_rec.supplier_id = FND_API.G_MISS_NUM THEN

1591: END IF;
1592: IF x_lopv_rec.sales_territory_id = FND_API.G_MISS_NUM THEN
1593: x_lopv_rec.sales_territory_id := l_db_lopv_rec.sales_territory_id;
1594: END IF;
1595: IF x_lopv_rec.supplier_id = FND_API.G_MISS_NUM THEN
1596: x_lopv_rec.supplier_id := l_db_lopv_rec.supplier_id;
1597: END IF;
1598: IF x_lopv_rec.delivery_date = FND_API.G_MISS_DATE THEN
1599: x_lopv_rec.delivery_date := l_db_lopv_rec.delivery_date;

Line 1598: IF x_lopv_rec.delivery_date = FND_API.G_MISS_DATE THEN

1594: END IF;
1595: IF x_lopv_rec.supplier_id = FND_API.G_MISS_NUM THEN
1596: x_lopv_rec.supplier_id := l_db_lopv_rec.supplier_id;
1597: END IF;
1598: IF x_lopv_rec.delivery_date = FND_API.G_MISS_DATE THEN
1599: x_lopv_rec.delivery_date := l_db_lopv_rec.delivery_date;
1600: END IF;
1601: IF x_lopv_rec.funding_date = FND_API.G_MISS_DATE THEN
1602: x_lopv_rec.funding_date := l_db_lopv_rec.funding_date;

Line 1601: IF x_lopv_rec.funding_date = FND_API.G_MISS_DATE THEN

1597: END IF;
1598: IF x_lopv_rec.delivery_date = FND_API.G_MISS_DATE THEN
1599: x_lopv_rec.delivery_date := l_db_lopv_rec.delivery_date;
1600: END IF;
1601: IF x_lopv_rec.funding_date = FND_API.G_MISS_DATE THEN
1602: x_lopv_rec.funding_date := l_db_lopv_rec.funding_date;
1603: END IF;
1604: IF x_lopv_rec.property_tax_applicable = FND_API.G_MISS_CHAR THEN
1605: x_lopv_rec.property_tax_applicable := l_db_lopv_rec.property_tax_applicable;

Line 1604: IF x_lopv_rec.property_tax_applicable = FND_API.G_MISS_CHAR THEN

1600: END IF;
1601: IF x_lopv_rec.funding_date = FND_API.G_MISS_DATE THEN
1602: x_lopv_rec.funding_date := l_db_lopv_rec.funding_date;
1603: END IF;
1604: IF x_lopv_rec.property_tax_applicable = FND_API.G_MISS_CHAR THEN
1605: x_lopv_rec.property_tax_applicable := l_db_lopv_rec.property_tax_applicable;
1606: END IF;
1607: IF x_lopv_rec.property_tax_billing_type = FND_API.G_MISS_CHAR THEN
1608: x_lopv_rec.property_tax_billing_type := l_db_lopv_rec.property_tax_billing_type;

Line 1607: IF x_lopv_rec.property_tax_billing_type = FND_API.G_MISS_CHAR THEN

1603: END IF;
1604: IF x_lopv_rec.property_tax_applicable = FND_API.G_MISS_CHAR THEN
1605: x_lopv_rec.property_tax_applicable := l_db_lopv_rec.property_tax_applicable;
1606: END IF;
1607: IF x_lopv_rec.property_tax_billing_type = FND_API.G_MISS_CHAR THEN
1608: x_lopv_rec.property_tax_billing_type := l_db_lopv_rec.property_tax_billing_type;
1609: END IF;
1610: IF x_lopv_rec.upfront_tax_treatment = FND_API.G_MISS_CHAR THEN
1611: x_lopv_rec.upfront_tax_treatment := l_db_lopv_rec.upfront_tax_treatment;

Line 1610: IF x_lopv_rec.upfront_tax_treatment = FND_API.G_MISS_CHAR THEN

1606: END IF;
1607: IF x_lopv_rec.property_tax_billing_type = FND_API.G_MISS_CHAR THEN
1608: x_lopv_rec.property_tax_billing_type := l_db_lopv_rec.property_tax_billing_type;
1609: END IF;
1610: IF x_lopv_rec.upfront_tax_treatment = FND_API.G_MISS_CHAR THEN
1611: x_lopv_rec.upfront_tax_treatment := l_db_lopv_rec.upfront_tax_treatment;
1612: END IF;
1613: IF x_lopv_rec.install_site_id = FND_API.G_MISS_NUM THEN
1614: x_lopv_rec.install_site_id := l_db_lopv_rec.install_site_id;

Line 1613: IF x_lopv_rec.install_site_id = FND_API.G_MISS_NUM THEN

1609: END IF;
1610: IF x_lopv_rec.upfront_tax_treatment = FND_API.G_MISS_CHAR THEN
1611: x_lopv_rec.upfront_tax_treatment := l_db_lopv_rec.upfront_tax_treatment;
1612: END IF;
1613: IF x_lopv_rec.install_site_id = FND_API.G_MISS_NUM THEN
1614: x_lopv_rec.install_site_id := l_db_lopv_rec.install_site_id;
1615: END IF;
1616: IF x_lopv_rec.usage_category = FND_API.G_MISS_CHAR THEN
1617: x_lopv_rec.usage_category := l_db_lopv_rec.usage_category;

Line 1616: IF x_lopv_rec.usage_category = FND_API.G_MISS_CHAR THEN

1612: END IF;
1613: IF x_lopv_rec.install_site_id = FND_API.G_MISS_NUM THEN
1614: x_lopv_rec.install_site_id := l_db_lopv_rec.install_site_id;
1615: END IF;
1616: IF x_lopv_rec.usage_category = FND_API.G_MISS_CHAR THEN
1617: x_lopv_rec.usage_category := l_db_lopv_rec.usage_category;
1618: END IF;
1619: IF x_lopv_rec.usage_industry_class = FND_API.G_MISS_CHAR THEN
1620: x_lopv_rec.usage_industry_class := l_db_lopv_rec.usage_industry_class;

Line 1619: IF x_lopv_rec.usage_industry_class = FND_API.G_MISS_CHAR THEN

1615: END IF;
1616: IF x_lopv_rec.usage_category = FND_API.G_MISS_CHAR THEN
1617: x_lopv_rec.usage_category := l_db_lopv_rec.usage_category;
1618: END IF;
1619: IF x_lopv_rec.usage_industry_class = FND_API.G_MISS_CHAR THEN
1620: x_lopv_rec.usage_industry_class := l_db_lopv_rec.usage_industry_class;
1621: END IF;
1622: IF x_lopv_rec.usage_industry_code = FND_API.G_MISS_CHAR THEN
1623: x_lopv_rec.usage_industry_code := l_db_lopv_rec.usage_industry_code;

Line 1622: IF x_lopv_rec.usage_industry_code = FND_API.G_MISS_CHAR THEN

1618: END IF;
1619: IF x_lopv_rec.usage_industry_class = FND_API.G_MISS_CHAR THEN
1620: x_lopv_rec.usage_industry_class := l_db_lopv_rec.usage_industry_class;
1621: END IF;
1622: IF x_lopv_rec.usage_industry_code = FND_API.G_MISS_CHAR THEN
1623: x_lopv_rec.usage_industry_code := l_db_lopv_rec.usage_industry_code;
1624: END IF;
1625: IF x_lopv_rec.usage_amount = FND_API.G_MISS_NUM THEN
1626: x_lopv_rec.usage_amount := l_db_lopv_rec.usage_amount;

Line 1625: IF x_lopv_rec.usage_amount = FND_API.G_MISS_NUM THEN

1621: END IF;
1622: IF x_lopv_rec.usage_industry_code = FND_API.G_MISS_CHAR THEN
1623: x_lopv_rec.usage_industry_code := l_db_lopv_rec.usage_industry_code;
1624: END IF;
1625: IF x_lopv_rec.usage_amount = FND_API.G_MISS_NUM THEN
1626: x_lopv_rec.usage_amount := l_db_lopv_rec.usage_amount;
1627: END IF;
1628: IF x_lopv_rec.usage_location_id = FND_API.G_MISS_NUM THEN
1629: x_lopv_rec.usage_location_id := l_db_lopv_rec.usage_location_id;

Line 1628: IF x_lopv_rec.usage_location_id = FND_API.G_MISS_NUM THEN

1624: END IF;
1625: IF x_lopv_rec.usage_amount = FND_API.G_MISS_NUM THEN
1626: x_lopv_rec.usage_amount := l_db_lopv_rec.usage_amount;
1627: END IF;
1628: IF x_lopv_rec.usage_location_id = FND_API.G_MISS_NUM THEN
1629: x_lopv_rec.usage_location_id := l_db_lopv_rec.usage_location_id;
1630: END IF;
1631: IF x_lopv_rec.originating_vendor_id = FND_API.G_MISS_NUM THEN
1632: x_lopv_rec.originating_vendor_id := l_db_lopv_rec.originating_vendor_id;

Line 1631: IF x_lopv_rec.originating_vendor_id = FND_API.G_MISS_NUM THEN

1627: END IF;
1628: IF x_lopv_rec.usage_location_id = FND_API.G_MISS_NUM THEN
1629: x_lopv_rec.usage_location_id := l_db_lopv_rec.usage_location_id;
1630: END IF;
1631: IF x_lopv_rec.originating_vendor_id = FND_API.G_MISS_NUM THEN
1632: x_lopv_rec.originating_vendor_id := l_db_lopv_rec.originating_vendor_id;
1633: END IF;
1634: IF x_lopv_rec.legal_entity_id = FND_API.G_MISS_NUM THEN
1635: x_lopv_rec.legal_entity_id := l_db_lopv_rec.legal_entity_id;

Line 1634: IF x_lopv_rec.legal_entity_id = FND_API.G_MISS_NUM THEN

1630: END IF;
1631: IF x_lopv_rec.originating_vendor_id = FND_API.G_MISS_NUM THEN
1632: x_lopv_rec.originating_vendor_id := l_db_lopv_rec.originating_vendor_id;
1633: END IF;
1634: IF x_lopv_rec.legal_entity_id = FND_API.G_MISS_NUM THEN
1635: x_lopv_rec.legal_entity_id := l_db_lopv_rec.legal_entity_id;
1636: END IF;
1637: -- Bug 5908845. eBTax Enhancement Project
1638: IF x_lopv_rec.line_intended_use = FND_API.G_MISS_CHAR THEN

Line 1638: IF x_lopv_rec.line_intended_use = FND_API.G_MISS_CHAR THEN

1634: IF x_lopv_rec.legal_entity_id = FND_API.G_MISS_NUM THEN
1635: x_lopv_rec.legal_entity_id := l_db_lopv_rec.legal_entity_id;
1636: END IF;
1637: -- Bug 5908845. eBTax Enhancement Project
1638: IF x_lopv_rec.line_intended_use = FND_API.G_MISS_CHAR THEN
1639: x_lopv_rec.line_intended_use := l_db_lopv_rec.line_intended_use;
1640: END IF;
1641: -- End Bug 5908845. eBTax Enhancement Project
1642: IF x_lopv_rec.short_description = FND_API.G_MISS_CHAR THEN

Line 1642: IF x_lopv_rec.short_description = FND_API.G_MISS_CHAR THEN

1638: IF x_lopv_rec.line_intended_use = FND_API.G_MISS_CHAR THEN
1639: x_lopv_rec.line_intended_use := l_db_lopv_rec.line_intended_use;
1640: END IF;
1641: -- End Bug 5908845. eBTax Enhancement Project
1642: IF x_lopv_rec.short_description = FND_API.G_MISS_CHAR THEN
1643: x_lopv_rec.short_description := l_db_lopv_rec.short_description;
1644: END IF;
1645: IF x_lopv_rec.description = FND_API.G_MISS_CHAR THEN
1646: x_lopv_rec.description := l_db_lopv_rec.description;

Line 1645: IF x_lopv_rec.description = FND_API.G_MISS_CHAR THEN

1641: -- End Bug 5908845. eBTax Enhancement Project
1642: IF x_lopv_rec.short_description = FND_API.G_MISS_CHAR THEN
1643: x_lopv_rec.short_description := l_db_lopv_rec.short_description;
1644: END IF;
1645: IF x_lopv_rec.description = FND_API.G_MISS_CHAR THEN
1646: x_lopv_rec.description := l_db_lopv_rec.description;
1647: END IF;
1648: IF x_lopv_rec.comments = FND_API.G_MISS_CHAR THEN
1649: x_lopv_rec.comments := l_db_lopv_rec.comments;

Line 1648: IF x_lopv_rec.comments = FND_API.G_MISS_CHAR THEN

1644: END IF;
1645: IF x_lopv_rec.description = FND_API.G_MISS_CHAR THEN
1646: x_lopv_rec.description := l_db_lopv_rec.description;
1647: END IF;
1648: IF x_lopv_rec.comments = FND_API.G_MISS_CHAR THEN
1649: x_lopv_rec.comments := l_db_lopv_rec.comments;
1650: END IF;
1651:
1652: RETURN l_return_status;