APPS.OKL_QQH_PVT dependencies on FND_API

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 148: IF l_qqhv_rec.expected_start_date = FND_API.G_MISS_DATE THEN

144: END IF;
145: IF l_qqhv_rec.reference_number = FND_API.G_MISS_CHAR THEN
146: l_qqhv_rec.reference_number := NULL;
147: END IF;
148: IF l_qqhv_rec.expected_start_date = FND_API.G_MISS_DATE THEN
149: l_qqhv_rec.expected_start_date := NULL;
150: END IF;
151: IF l_qqhv_rec.org_id = FND_API.G_MISS_NUM THEN
152: l_qqhv_rec.org_id := NULL;

Line 151: IF l_qqhv_rec.org_id = FND_API.G_MISS_NUM THEN

147: END IF;
148: IF l_qqhv_rec.expected_start_date = FND_API.G_MISS_DATE THEN
149: l_qqhv_rec.expected_start_date := NULL;
150: END IF;
151: IF l_qqhv_rec.org_id = FND_API.G_MISS_NUM THEN
152: l_qqhv_rec.org_id := NULL;
153: END IF;
154: IF l_qqhv_rec.inv_org_id = FND_API.G_MISS_NUM THEN
155: l_qqhv_rec.inv_org_id := NULL;

Line 154: IF l_qqhv_rec.inv_org_id = FND_API.G_MISS_NUM THEN

150: END IF;
151: IF l_qqhv_rec.org_id = FND_API.G_MISS_NUM THEN
152: l_qqhv_rec.org_id := NULL;
153: END IF;
154: IF l_qqhv_rec.inv_org_id = FND_API.G_MISS_NUM THEN
155: l_qqhv_rec.inv_org_id := NULL;
156: END IF;
157: IF l_qqhv_rec.currency_code = FND_API.G_MISS_CHAR THEN
158: l_qqhv_rec.currency_code := NULL;

Line 157: IF l_qqhv_rec.currency_code = FND_API.G_MISS_CHAR THEN

153: END IF;
154: IF l_qqhv_rec.inv_org_id = FND_API.G_MISS_NUM THEN
155: l_qqhv_rec.inv_org_id := NULL;
156: END IF;
157: IF l_qqhv_rec.currency_code = FND_API.G_MISS_CHAR THEN
158: l_qqhv_rec.currency_code := NULL;
159: END IF;
160: IF l_qqhv_rec.term = FND_API.G_MISS_NUM THEN
161: l_qqhv_rec.term := NULL;

Line 160: IF l_qqhv_rec.term = FND_API.G_MISS_NUM THEN

156: END IF;
157: IF l_qqhv_rec.currency_code = FND_API.G_MISS_CHAR THEN
158: l_qqhv_rec.currency_code := NULL;
159: END IF;
160: IF l_qqhv_rec.term = FND_API.G_MISS_NUM THEN
161: l_qqhv_rec.term := NULL;
162: END IF;
163: IF l_qqhv_rec.end_of_term_option_id = FND_API.G_MISS_NUM THEN
164: l_qqhv_rec.end_of_term_option_id := NULL;

Line 163: IF l_qqhv_rec.end_of_term_option_id = FND_API.G_MISS_NUM THEN

159: END IF;
160: IF l_qqhv_rec.term = FND_API.G_MISS_NUM THEN
161: l_qqhv_rec.term := NULL;
162: END IF;
163: IF l_qqhv_rec.end_of_term_option_id = FND_API.G_MISS_NUM THEN
164: l_qqhv_rec.end_of_term_option_id := NULL;
165: END IF;
166: IF l_qqhv_rec.pricing_method = FND_API.G_MISS_CHAR THEN
167: l_qqhv_rec.pricing_method := NULL;

Line 166: IF l_qqhv_rec.pricing_method = FND_API.G_MISS_CHAR THEN

162: END IF;
163: IF l_qqhv_rec.end_of_term_option_id = FND_API.G_MISS_NUM THEN
164: l_qqhv_rec.end_of_term_option_id := NULL;
165: END IF;
166: IF l_qqhv_rec.pricing_method = FND_API.G_MISS_CHAR THEN
167: l_qqhv_rec.pricing_method := NULL;
168: END IF;
169: IF l_qqhv_rec.lease_opportunity_id = FND_API.G_MISS_NUM THEN
170: l_qqhv_rec.lease_opportunity_id := NULL;

Line 169: IF l_qqhv_rec.lease_opportunity_id = FND_API.G_MISS_NUM THEN

165: END IF;
166: IF l_qqhv_rec.pricing_method = FND_API.G_MISS_CHAR THEN
167: l_qqhv_rec.pricing_method := NULL;
168: END IF;
169: IF l_qqhv_rec.lease_opportunity_id = FND_API.G_MISS_NUM THEN
170: l_qqhv_rec.lease_opportunity_id := NULL;
171: END IF;
172: IF l_qqhv_rec.originating_vendor_id = FND_API.G_MISS_NUM THEN
173: l_qqhv_rec.originating_vendor_id := NULL;

Line 172: IF l_qqhv_rec.originating_vendor_id = FND_API.G_MISS_NUM THEN

168: END IF;
169: IF l_qqhv_rec.lease_opportunity_id = FND_API.G_MISS_NUM THEN
170: l_qqhv_rec.lease_opportunity_id := NULL;
171: END IF;
172: IF l_qqhv_rec.originating_vendor_id = FND_API.G_MISS_NUM THEN
173: l_qqhv_rec.originating_vendor_id := NULL;
174: END IF;
175: IF l_qqhv_rec.program_agreement_id = FND_API.G_MISS_NUM THEN
176: l_qqhv_rec.program_agreement_id := NULL;

Line 175: IF l_qqhv_rec.program_agreement_id = FND_API.G_MISS_NUM THEN

171: END IF;
172: IF l_qqhv_rec.originating_vendor_id = FND_API.G_MISS_NUM THEN
173: l_qqhv_rec.originating_vendor_id := NULL;
174: END IF;
175: IF l_qqhv_rec.program_agreement_id = FND_API.G_MISS_NUM THEN
176: l_qqhv_rec.program_agreement_id := NULL;
177: END IF;
178: IF l_qqhv_rec.sales_rep_id = FND_API.G_MISS_NUM THEN
179: l_qqhv_rec.sales_rep_id := NULL;

Line 178: IF l_qqhv_rec.sales_rep_id = FND_API.G_MISS_NUM THEN

174: END IF;
175: IF l_qqhv_rec.program_agreement_id = FND_API.G_MISS_NUM THEN
176: l_qqhv_rec.program_agreement_id := NULL;
177: END IF;
178: IF l_qqhv_rec.sales_rep_id = FND_API.G_MISS_NUM THEN
179: l_qqhv_rec.sales_rep_id := NULL;
180: END IF;
181: IF l_qqhv_rec.sales_territory_id = FND_API.G_MISS_NUM THEN
182: l_qqhv_rec.sales_territory_id := NULL;

Line 181: IF l_qqhv_rec.sales_territory_id = FND_API.G_MISS_NUM THEN

177: END IF;
178: IF l_qqhv_rec.sales_rep_id = FND_API.G_MISS_NUM THEN
179: l_qqhv_rec.sales_rep_id := NULL;
180: END IF;
181: IF l_qqhv_rec.sales_territory_id = FND_API.G_MISS_NUM THEN
182: l_qqhv_rec.sales_territory_id := NULL;
183: END IF;
184: IF l_qqhv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN
185: l_qqhv_rec.structured_pricing := NULL;

Line 184: IF l_qqhv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN

180: END IF;
181: IF l_qqhv_rec.sales_territory_id = FND_API.G_MISS_NUM THEN
182: l_qqhv_rec.sales_territory_id := NULL;
183: END IF;
184: IF l_qqhv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN
185: l_qqhv_rec.structured_pricing := NULL;
186: END IF;
187: IF l_qqhv_rec.line_level_pricing = FND_API.G_MISS_CHAR THEN
188: l_qqhv_rec.line_level_pricing := NULL;

Line 187: IF l_qqhv_rec.line_level_pricing = FND_API.G_MISS_CHAR THEN

183: END IF;
184: IF l_qqhv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN
185: l_qqhv_rec.structured_pricing := NULL;
186: END IF;
187: IF l_qqhv_rec.line_level_pricing = FND_API.G_MISS_CHAR THEN
188: l_qqhv_rec.line_level_pricing := NULL;
189: END IF;
190: IF l_qqhv_rec.rate_template_id = FND_API.G_MISS_NUM THEN
191: l_qqhv_rec.rate_template_id := NULL;

Line 190: IF l_qqhv_rec.rate_template_id = FND_API.G_MISS_NUM THEN

186: END IF;
187: IF l_qqhv_rec.line_level_pricing = FND_API.G_MISS_CHAR THEN
188: l_qqhv_rec.line_level_pricing := NULL;
189: END IF;
190: IF l_qqhv_rec.rate_template_id = FND_API.G_MISS_NUM THEN
191: l_qqhv_rec.rate_template_id := NULL;
192: END IF;
193: IF l_qqhv_rec.rate_card_id = FND_API.G_MISS_NUM THEN
194: l_qqhv_rec.rate_card_id := NULL;

Line 193: IF l_qqhv_rec.rate_card_id = FND_API.G_MISS_NUM THEN

189: END IF;
190: IF l_qqhv_rec.rate_template_id = FND_API.G_MISS_NUM THEN
191: l_qqhv_rec.rate_template_id := NULL;
192: END IF;
193: IF l_qqhv_rec.rate_card_id = FND_API.G_MISS_NUM THEN
194: l_qqhv_rec.rate_card_id := NULL;
195: END IF;
196: IF l_qqhv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
197: l_qqhv_rec.lease_rate_factor := NULL;

Line 196: IF l_qqhv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN

192: END IF;
193: IF l_qqhv_rec.rate_card_id = FND_API.G_MISS_NUM THEN
194: l_qqhv_rec.rate_card_id := NULL;
195: END IF;
196: IF l_qqhv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
197: l_qqhv_rec.lease_rate_factor := NULL;
198: END IF;
199: IF l_qqhv_rec.target_rate_type = FND_API.G_MISS_CHAR THEN
200: l_qqhv_rec.target_rate_type := NULL;

Line 199: IF l_qqhv_rec.target_rate_type = FND_API.G_MISS_CHAR THEN

195: END IF;
196: IF l_qqhv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
197: l_qqhv_rec.lease_rate_factor := NULL;
198: END IF;
199: IF l_qqhv_rec.target_rate_type = FND_API.G_MISS_CHAR THEN
200: l_qqhv_rec.target_rate_type := NULL;
201: END IF;
202: IF l_qqhv_rec.target_rate = FND_API.G_MISS_NUM THEN
203: l_qqhv_rec.target_rate := NULL;

Line 202: IF l_qqhv_rec.target_rate = FND_API.G_MISS_NUM THEN

198: END IF;
199: IF l_qqhv_rec.target_rate_type = FND_API.G_MISS_CHAR THEN
200: l_qqhv_rec.target_rate_type := NULL;
201: END IF;
202: IF l_qqhv_rec.target_rate = FND_API.G_MISS_NUM THEN
203: l_qqhv_rec.target_rate := NULL;
204: END IF;
205: IF l_qqhv_rec.target_amount = FND_API.G_MISS_NUM THEN
206: l_qqhv_rec.target_amount := NULL;

Line 205: IF l_qqhv_rec.target_amount = FND_API.G_MISS_NUM THEN

201: END IF;
202: IF l_qqhv_rec.target_rate = FND_API.G_MISS_NUM THEN
203: l_qqhv_rec.target_rate := NULL;
204: END IF;
205: IF l_qqhv_rec.target_amount = FND_API.G_MISS_NUM THEN
206: l_qqhv_rec.target_amount := NULL;
207: END IF;
208: IF l_qqhv_rec.target_frequency = FND_API.G_MISS_CHAR THEN
209: l_qqhv_rec.target_frequency := NULL;

Line 208: IF l_qqhv_rec.target_frequency = FND_API.G_MISS_CHAR THEN

204: END IF;
205: IF l_qqhv_rec.target_amount = FND_API.G_MISS_NUM THEN
206: l_qqhv_rec.target_amount := NULL;
207: END IF;
208: IF l_qqhv_rec.target_frequency = FND_API.G_MISS_CHAR THEN
209: l_qqhv_rec.target_frequency := NULL;
210: END IF;
211: IF l_qqhv_rec.target_arrears = FND_API.G_MISS_CHAR THEN
212: l_qqhv_rec.target_arrears := NULL;

Line 211: IF l_qqhv_rec.target_arrears = FND_API.G_MISS_CHAR THEN

207: END IF;
208: IF l_qqhv_rec.target_frequency = FND_API.G_MISS_CHAR THEN
209: l_qqhv_rec.target_frequency := NULL;
210: END IF;
211: IF l_qqhv_rec.target_arrears = FND_API.G_MISS_CHAR THEN
212: l_qqhv_rec.target_arrears := NULL;
213: END IF;
214: IF l_qqhv_rec.target_periods = FND_API.G_MISS_NUM THEN
215: l_qqhv_rec.target_periods := NULL;

Line 214: IF l_qqhv_rec.target_periods = FND_API.G_MISS_NUM THEN

210: END IF;
211: IF l_qqhv_rec.target_arrears = FND_API.G_MISS_CHAR THEN
212: l_qqhv_rec.target_arrears := NULL;
213: END IF;
214: IF l_qqhv_rec.target_periods = FND_API.G_MISS_NUM THEN
215: l_qqhv_rec.target_periods := NULL;
216: END IF;
217: IF l_qqhv_rec.iir = FND_API.G_MISS_NUM THEN
218: l_qqhv_rec.iir := NULL;

Line 217: IF l_qqhv_rec.iir = FND_API.G_MISS_NUM THEN

213: END IF;
214: IF l_qqhv_rec.target_periods = FND_API.G_MISS_NUM THEN
215: l_qqhv_rec.target_periods := NULL;
216: END IF;
217: IF l_qqhv_rec.iir = FND_API.G_MISS_NUM THEN
218: l_qqhv_rec.iir := NULL;
219: END IF;
220: IF l_qqhv_rec.sub_iir = FND_API.G_MISS_NUM THEN
221: l_qqhv_rec.sub_iir := NULL;

Line 220: IF l_qqhv_rec.sub_iir = FND_API.G_MISS_NUM THEN

216: END IF;
217: IF l_qqhv_rec.iir = FND_API.G_MISS_NUM THEN
218: l_qqhv_rec.iir := NULL;
219: END IF;
220: IF l_qqhv_rec.sub_iir = FND_API.G_MISS_NUM THEN
221: l_qqhv_rec.sub_iir := NULL;
222: END IF;
223: IF l_qqhv_rec.booking_yield = FND_API.G_MISS_NUM THEN
224: l_qqhv_rec.booking_yield := NULL;

Line 223: IF l_qqhv_rec.booking_yield = FND_API.G_MISS_NUM THEN

219: END IF;
220: IF l_qqhv_rec.sub_iir = FND_API.G_MISS_NUM THEN
221: l_qqhv_rec.sub_iir := NULL;
222: END IF;
223: IF l_qqhv_rec.booking_yield = FND_API.G_MISS_NUM THEN
224: l_qqhv_rec.booking_yield := NULL;
225: END IF;
226: IF l_qqhv_rec.sub_booking_yield = FND_API.G_MISS_NUM THEN
227: l_qqhv_rec.sub_booking_yield := NULL;

Line 226: IF l_qqhv_rec.sub_booking_yield = FND_API.G_MISS_NUM THEN

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

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

225: END IF;
226: IF l_qqhv_rec.sub_booking_yield = FND_API.G_MISS_NUM THEN
227: l_qqhv_rec.sub_booking_yield := NULL;
228: END IF;
229: IF l_qqhv_rec.pirr = FND_API.G_MISS_NUM THEN
230: l_qqhv_rec.pirr := NULL;
231: END IF;
232: IF l_qqhv_rec.sub_pirr = FND_API.G_MISS_NUM THEN
233: l_qqhv_rec.sub_pirr := NULL;

Line 232: IF l_qqhv_rec.sub_pirr = FND_API.G_MISS_NUM THEN

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

Line 235: IF l_qqhv_rec.airr = FND_API.G_MISS_NUM THEN

231: END IF;
232: IF l_qqhv_rec.sub_pirr = FND_API.G_MISS_NUM THEN
233: l_qqhv_rec.sub_pirr := NULL;
234: END IF;
235: IF l_qqhv_rec.airr = FND_API.G_MISS_NUM THEN
236: l_qqhv_rec.airr := NULL;
237: END IF;
238: IF l_qqhv_rec.sub_airr = FND_API.G_MISS_NUM THEN
239: l_qqhv_rec.sub_airr := NULL;

Line 238: IF l_qqhv_rec.sub_airr = FND_API.G_MISS_NUM THEN

234: END IF;
235: IF l_qqhv_rec.airr = FND_API.G_MISS_NUM THEN
236: l_qqhv_rec.airr := NULL;
237: END IF;
238: IF l_qqhv_rec.sub_airr = FND_API.G_MISS_NUM THEN
239: l_qqhv_rec.sub_airr := NULL;
240: END IF;
241:
242: RETURN l_qqhv_rec;

Line 1552: ELSIF x_qqhv_rec.attribute_category = FND_API.G_MISS_CHAR THEN

1548:
1549: -- smadhava - Modified - G_MISS compliance - Start
1550: IF x_qqhv_rec.attribute_category IS NULL THEN
1551: x_qqhv_rec.attribute_category := l_db_qqhv_rec.attribute_category;
1552: ELSIF x_qqhv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1553: x_qqhv_rec.attribute_category := null;
1554: END IF;
1555:
1556: IF x_qqhv_rec.attribute1 IS NULL THEN

Line 1558: ELSIF x_qqhv_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1554: END IF;
1555:
1556: IF x_qqhv_rec.attribute1 IS NULL THEN
1557: x_qqhv_rec.attribute1 := l_db_qqhv_rec.attribute1;
1558: ELSIF x_qqhv_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1559: x_qqhv_rec.attribute1 := null;
1560: END IF;
1561:
1562: IF x_qqhv_rec.attribute2 IS NULL THEN

Line 1564: ELSIF x_qqhv_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1560: END IF;
1561:
1562: IF x_qqhv_rec.attribute2 IS NULL THEN
1563: x_qqhv_rec.attribute2 := l_db_qqhv_rec.attribute2;
1564: ELSIF x_qqhv_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1565: x_qqhv_rec.attribute2 := null;
1566: END IF;
1567:
1568: IF x_qqhv_rec.attribute3 IS NULL THEN

Line 1570: ELSIF x_qqhv_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1566: END IF;
1567:
1568: IF x_qqhv_rec.attribute3 IS NULL THEN
1569: x_qqhv_rec.attribute3 := l_db_qqhv_rec.attribute3;
1570: ELSIF x_qqhv_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1571: x_qqhv_rec.attribute3 := null;
1572: END IF;
1573:
1574: IF x_qqhv_rec.attribute4 IS NULL THEN

Line 1576: ELSIF x_qqhv_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1572: END IF;
1573:
1574: IF x_qqhv_rec.attribute4 IS NULL THEN
1575: x_qqhv_rec.attribute4 := l_db_qqhv_rec.attribute4;
1576: ELSIF x_qqhv_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1577: x_qqhv_rec.attribute4 := null;
1578: END IF;
1579:
1580: IF x_qqhv_rec.attribute5 IS NULL THEN

Line 1582: ELSIF x_qqhv_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1578: END IF;
1579:
1580: IF x_qqhv_rec.attribute5 IS NULL THEN
1581: x_qqhv_rec.attribute5 := l_db_qqhv_rec.attribute5;
1582: ELSIF x_qqhv_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1583: x_qqhv_rec.attribute5 := null;
1584: END IF;
1585:
1586: IF x_qqhv_rec.attribute6 IS NULL THEN

Line 1588: ELSIF x_qqhv_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1584: END IF;
1585:
1586: IF x_qqhv_rec.attribute6 IS NULL THEN
1587: x_qqhv_rec.attribute6 := l_db_qqhv_rec.attribute6;
1588: ELSIF x_qqhv_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1589: x_qqhv_rec.attribute6 := null;
1590: END IF;
1591:
1592: IF x_qqhv_rec.attribute7 IS NULL THEN

Line 1594: ELSIF x_qqhv_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1590: END IF;
1591:
1592: IF x_qqhv_rec.attribute7 IS NULL THEN
1593: x_qqhv_rec.attribute7 := l_db_qqhv_rec.attribute7;
1594: ELSIF x_qqhv_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1595: x_qqhv_rec.attribute7 := null;
1596: END IF;
1597:
1598: IF x_qqhv_rec.attribute8 IS NULL THEN

Line 1600: ELSIF x_qqhv_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1596: END IF;
1597:
1598: IF x_qqhv_rec.attribute8 IS NULL THEN
1599: x_qqhv_rec.attribute8 := l_db_qqhv_rec.attribute8;
1600: ELSIF x_qqhv_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1601: x_qqhv_rec.attribute8 := null;
1602: END IF;
1603:
1604: IF x_qqhv_rec.attribute9 IS NULL THEN

Line 1606: ELSIF x_qqhv_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1602: END IF;
1603:
1604: IF x_qqhv_rec.attribute9 IS NULL THEN
1605: x_qqhv_rec.attribute9 := l_db_qqhv_rec.attribute9;
1606: ELSIF x_qqhv_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1607: x_qqhv_rec.attribute9 := null;
1608: END IF;
1609:
1610: IF x_qqhv_rec.attribute10 IS NULL THEN

Line 1612: ELSIF x_qqhv_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1608: END IF;
1609:
1610: IF x_qqhv_rec.attribute10 IS NULL THEN
1611: x_qqhv_rec.attribute10 := l_db_qqhv_rec.attribute10;
1612: ELSIF x_qqhv_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1613: x_qqhv_rec.attribute10 := null;
1614: END IF;
1615:
1616: IF x_qqhv_rec.attribute11 IS NULL THEN

Line 1618: ELSIF x_qqhv_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1614: END IF;
1615:
1616: IF x_qqhv_rec.attribute11 IS NULL THEN
1617: x_qqhv_rec.attribute11 := l_db_qqhv_rec.attribute11;
1618: ELSIF x_qqhv_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1619: x_qqhv_rec.attribute11 := null;
1620: END IF;
1621:
1622: IF x_qqhv_rec.attribute12 IS NULL THEN

Line 1624: ELSIF x_qqhv_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1620: END IF;
1621:
1622: IF x_qqhv_rec.attribute12 IS NULL THEN
1623: x_qqhv_rec.attribute12 := l_db_qqhv_rec.attribute12;
1624: ELSIF x_qqhv_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1625: x_qqhv_rec.attribute12 := null;
1626: END IF;
1627:
1628: IF x_qqhv_rec.attribute13 IS NULL THEN

Line 1630: ELSIF x_qqhv_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1626: END IF;
1627:
1628: IF x_qqhv_rec.attribute13 IS NULL THEN
1629: x_qqhv_rec.attribute13 := l_db_qqhv_rec.attribute13;
1630: ELSIF x_qqhv_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1631: x_qqhv_rec.attribute13 := null;
1632: END IF;
1633:
1634: IF x_qqhv_rec.attribute14 IS NULL THEN

Line 1636: ELSIF x_qqhv_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1632: END IF;
1633:
1634: IF x_qqhv_rec.attribute14 IS NULL THEN
1635: x_qqhv_rec.attribute14 := l_db_qqhv_rec.attribute14;
1636: ELSIF x_qqhv_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1637: x_qqhv_rec.attribute14 := null;
1638: END IF;
1639:
1640: IF x_qqhv_rec.attribute15 IS NULL THEN

Line 1642: ELSIF x_qqhv_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1638: END IF;
1639:
1640: IF x_qqhv_rec.attribute15 IS NULL THEN
1641: x_qqhv_rec.attribute15 := l_db_qqhv_rec.attribute15;
1642: ELSIF x_qqhv_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1643: x_qqhv_rec.attribute15 := null;
1644: END IF;
1645:
1646: IF x_qqhv_rec.reference_number IS NULL THEN

Line 1648: ELSIF x_qqhv_rec.reference_number = FND_API.G_MISS_CHAR THEN

1644: END IF;
1645:
1646: IF x_qqhv_rec.reference_number IS NULL THEN
1647: x_qqhv_rec.reference_number := l_db_qqhv_rec.reference_number;
1648: ELSIF x_qqhv_rec.reference_number = FND_API.G_MISS_CHAR THEN
1649: x_qqhv_rec.reference_number := null;
1650: END IF;
1651:
1652: IF x_qqhv_rec.expected_start_date IS NULL THEN

Line 1654: ELSIF x_qqhv_rec.expected_start_date = FND_API.G_MISS_DATE THEN

1650: END IF;
1651:
1652: IF x_qqhv_rec.expected_start_date IS NULL THEN
1653: x_qqhv_rec.expected_start_date := l_db_qqhv_rec.expected_start_date;
1654: ELSIF x_qqhv_rec.expected_start_date = FND_API.G_MISS_DATE THEN
1655: x_qqhv_rec.expected_start_date := null;
1656: END IF;
1657:
1658: IF x_qqhv_rec.org_id IS NULL THEN

Line 1660: ELSIF x_qqhv_rec.org_id = FND_API.G_MISS_NUM THEN

1656: END IF;
1657:
1658: IF x_qqhv_rec.org_id IS NULL THEN
1659: x_qqhv_rec.org_id := l_db_qqhv_rec.org_id;
1660: ELSIF x_qqhv_rec.org_id = FND_API.G_MISS_NUM THEN
1661: x_qqhv_rec.org_id := null;
1662: END IF;
1663:
1664: IF x_qqhv_rec.inv_org_id IS NULL THEN

Line 1666: ELSIF x_qqhv_rec.inv_org_id = FND_API.G_MISS_NUM THEN

1662: END IF;
1663:
1664: IF x_qqhv_rec.inv_org_id IS NULL THEN
1665: x_qqhv_rec.inv_org_id := l_db_qqhv_rec.inv_org_id;
1666: ELSIF x_qqhv_rec.inv_org_id = FND_API.G_MISS_NUM THEN
1667: x_qqhv_rec.inv_org_id := null;
1668: END IF;
1669:
1670: IF x_qqhv_rec.currency_code IS NULL THEN

Line 1672: ELSIF x_qqhv_rec.currency_code = FND_API.G_MISS_CHAR THEN

1668: END IF;
1669:
1670: IF x_qqhv_rec.currency_code IS NULL THEN
1671: x_qqhv_rec.currency_code := l_db_qqhv_rec.currency_code;
1672: ELSIF x_qqhv_rec.currency_code = FND_API.G_MISS_CHAR THEN
1673: x_qqhv_rec.currency_code := null;
1674: END IF;
1675:
1676: IF x_qqhv_rec.term IS NULL THEN

Line 1678: ELSIF x_qqhv_rec.term = FND_API.G_MISS_NUM THEN

1674: END IF;
1675:
1676: IF x_qqhv_rec.term IS NULL THEN
1677: x_qqhv_rec.term := l_db_qqhv_rec.term;
1678: ELSIF x_qqhv_rec.term = FND_API.G_MISS_NUM THEN
1679: x_qqhv_rec.term := null;
1680: END IF;
1681:
1682: IF x_qqhv_rec.end_of_term_option_id IS NULL THEN

Line 1684: ELSIF x_qqhv_rec.end_of_term_option_id = FND_API.G_MISS_NUM THEN

1680: END IF;
1681:
1682: IF x_qqhv_rec.end_of_term_option_id IS NULL THEN
1683: x_qqhv_rec.end_of_term_option_id := l_db_qqhv_rec.end_of_term_option_id;
1684: ELSIF x_qqhv_rec.end_of_term_option_id = FND_API.G_MISS_NUM THEN
1685: x_qqhv_rec.end_of_term_option_id := null;
1686: END IF;
1687:
1688: IF x_qqhv_rec.pricing_method IS NULL THEN

Line 1690: ELSIF x_qqhv_rec.pricing_method = FND_API.G_MISS_CHAR THEN

1686: END IF;
1687:
1688: IF x_qqhv_rec.pricing_method IS NULL THEN
1689: x_qqhv_rec.pricing_method := l_db_qqhv_rec.pricing_method;
1690: ELSIF x_qqhv_rec.pricing_method = FND_API.G_MISS_CHAR THEN
1691: x_qqhv_rec.pricing_method := null;
1692: END IF;
1693:
1694: IF x_qqhv_rec.lease_opportunity_id IS NULL THEN

Line 1696: ELSIF x_qqhv_rec.lease_opportunity_id = FND_API.G_MISS_NUM THEN

1692: END IF;
1693:
1694: IF x_qqhv_rec.lease_opportunity_id IS NULL THEN
1695: x_qqhv_rec.lease_opportunity_id := l_db_qqhv_rec.lease_opportunity_id;
1696: ELSIF x_qqhv_rec.lease_opportunity_id = FND_API.G_MISS_NUM THEN
1697: x_qqhv_rec.lease_opportunity_id := null;
1698: END IF;
1699:
1700: IF x_qqhv_rec.originating_vendor_id IS NULL THEN

Line 1702: ELSIF x_qqhv_rec.originating_vendor_id = FND_API.G_MISS_NUM THEN

1698: END IF;
1699:
1700: IF x_qqhv_rec.originating_vendor_id IS NULL THEN
1701: x_qqhv_rec.originating_vendor_id := l_db_qqhv_rec.originating_vendor_id;
1702: ELSIF x_qqhv_rec.originating_vendor_id = FND_API.G_MISS_NUM THEN
1703: x_qqhv_rec.originating_vendor_id := null;
1704: END IF;
1705:
1706: IF x_qqhv_rec.program_agreement_id IS NULL THEN

Line 1708: ELSIF x_qqhv_rec.program_agreement_id = FND_API.G_MISS_NUM THEN

1704: END IF;
1705:
1706: IF x_qqhv_rec.program_agreement_id IS NULL THEN
1707: x_qqhv_rec.program_agreement_id := l_db_qqhv_rec.program_agreement_id;
1708: ELSIF x_qqhv_rec.program_agreement_id = FND_API.G_MISS_NUM THEN
1709: x_qqhv_rec.program_agreement_id := null;
1710: END IF;
1711:
1712: IF x_qqhv_rec.sales_rep_id IS NULL THEN

Line 1714: ELSIF x_qqhv_rec.sales_rep_id = FND_API.G_MISS_NUM THEN

1710: END IF;
1711:
1712: IF x_qqhv_rec.sales_rep_id IS NULL THEN
1713: x_qqhv_rec.sales_rep_id := l_db_qqhv_rec.sales_rep_id;
1714: ELSIF x_qqhv_rec.sales_rep_id = FND_API.G_MISS_NUM THEN
1715: x_qqhv_rec.sales_rep_id := null;
1716: END IF;
1717:
1718: IF x_qqhv_rec.sales_territory_id IS NULL THEN

Line 1720: ELSIF x_qqhv_rec.sales_territory_id = FND_API.G_MISS_NUM THEN

1716: END IF;
1717:
1718: IF x_qqhv_rec.sales_territory_id IS NULL THEN
1719: x_qqhv_rec.sales_territory_id := l_db_qqhv_rec.sales_territory_id;
1720: ELSIF x_qqhv_rec.sales_territory_id = FND_API.G_MISS_NUM THEN
1721: x_qqhv_rec.sales_territory_id := null;
1722: END IF;
1723:
1724: IF x_qqhv_rec.structured_pricing IS NULL THEN

Line 1726: ELSIF x_qqhv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN

1722: END IF;
1723:
1724: IF x_qqhv_rec.structured_pricing IS NULL THEN
1725: x_qqhv_rec.structured_pricing := l_db_qqhv_rec.structured_pricing;
1726: ELSIF x_qqhv_rec.structured_pricing = FND_API.G_MISS_CHAR THEN
1727: x_qqhv_rec.structured_pricing := null;
1728: END IF;
1729:
1730: IF x_qqhv_rec.line_level_pricing IS NULL THEN

Line 1732: ELSIF x_qqhv_rec.line_level_pricing = FND_API.G_MISS_CHAR THEN

1728: END IF;
1729:
1730: IF x_qqhv_rec.line_level_pricing IS NULL THEN
1731: x_qqhv_rec.line_level_pricing := l_db_qqhv_rec.line_level_pricing;
1732: ELSIF x_qqhv_rec.line_level_pricing = FND_API.G_MISS_CHAR THEN
1733: x_qqhv_rec.line_level_pricing := null;
1734: END IF;
1735:
1736: IF x_qqhv_rec.rate_template_id IS NULL THEN

Line 1738: ELSIF x_qqhv_rec.rate_template_id = FND_API.G_MISS_NUM THEN

1734: END IF;
1735:
1736: IF x_qqhv_rec.rate_template_id IS NULL THEN
1737: x_qqhv_rec.rate_template_id := l_db_qqhv_rec.rate_template_id;
1738: ELSIF x_qqhv_rec.rate_template_id = FND_API.G_MISS_NUM THEN
1739: x_qqhv_rec.rate_template_id := null;
1740: END IF;
1741:
1742: IF x_qqhv_rec.rate_card_id IS NULL THEN

Line 1744: ELSIF x_qqhv_rec.rate_card_id = FND_API.G_MISS_NUM THEN

1740: END IF;
1741:
1742: IF x_qqhv_rec.rate_card_id IS NULL THEN
1743: x_qqhv_rec.rate_card_id := l_db_qqhv_rec.rate_card_id;
1744: ELSIF x_qqhv_rec.rate_card_id = FND_API.G_MISS_NUM THEN
1745: x_qqhv_rec.rate_card_id := null;
1746: END IF;
1747:
1748: IF x_qqhv_rec.lease_rate_factor IS NULL THEN

Line 1750: ELSIF x_qqhv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN

1746: END IF;
1747:
1748: IF x_qqhv_rec.lease_rate_factor IS NULL THEN
1749: x_qqhv_rec.lease_rate_factor := l_db_qqhv_rec.lease_rate_factor;
1750: ELSIF x_qqhv_rec.lease_rate_factor = FND_API.G_MISS_NUM THEN
1751: x_qqhv_rec.lease_rate_factor := null;
1752: END IF;
1753:
1754: IF x_qqhv_rec.target_rate_type IS NULL THEN

Line 1756: ELSIF x_qqhv_rec.target_rate_type = FND_API.G_MISS_CHAR THEN

1752: END IF;
1753:
1754: IF x_qqhv_rec.target_rate_type IS NULL THEN
1755: x_qqhv_rec.target_rate_type := l_db_qqhv_rec.target_rate_type;
1756: ELSIF x_qqhv_rec.target_rate_type = FND_API.G_MISS_CHAR THEN
1757: x_qqhv_rec.target_rate_type := null;
1758: END IF;
1759:
1760: IF x_qqhv_rec.target_rate IS NULL THEN

Line 1762: ELSIF x_qqhv_rec.target_rate = FND_API.G_MISS_NUM THEN

1758: END IF;
1759:
1760: IF x_qqhv_rec.target_rate IS NULL THEN
1761: x_qqhv_rec.target_rate := l_db_qqhv_rec.target_rate;
1762: ELSIF x_qqhv_rec.target_rate = FND_API.G_MISS_NUM THEN
1763: x_qqhv_rec.target_rate := null;
1764: END IF;
1765:
1766: IF x_qqhv_rec.target_amount IS NULL THEN

Line 1768: ELSIF x_qqhv_rec.target_amount = FND_API.G_MISS_NUM THEN

1764: END IF;
1765:
1766: IF x_qqhv_rec.target_amount IS NULL THEN
1767: x_qqhv_rec.target_amount := l_db_qqhv_rec.target_amount;
1768: ELSIF x_qqhv_rec.target_amount = FND_API.G_MISS_NUM THEN
1769: x_qqhv_rec.target_amount := null;
1770: END IF;
1771:
1772: IF x_qqhv_rec.target_frequency IS NULL THEN

Line 1774: ELSIF x_qqhv_rec.target_frequency = FND_API.G_MISS_CHAR THEN

1770: END IF;
1771:
1772: IF x_qqhv_rec.target_frequency IS NULL THEN
1773: x_qqhv_rec.target_frequency := l_db_qqhv_rec.target_frequency;
1774: ELSIF x_qqhv_rec.target_frequency = FND_API.G_MISS_CHAR THEN
1775: x_qqhv_rec.target_frequency := null;
1776: END IF;
1777:
1778: IF x_qqhv_rec.target_arrears IS NULL THEN

Line 1780: ELSIF x_qqhv_rec.target_arrears = FND_API.G_MISS_CHAR THEN

1776: END IF;
1777:
1778: IF x_qqhv_rec.target_arrears IS NULL THEN
1779: x_qqhv_rec.target_arrears := l_db_qqhv_rec.target_arrears;
1780: ELSIF x_qqhv_rec.target_arrears = FND_API.G_MISS_CHAR THEN
1781: x_qqhv_rec.target_arrears := null;
1782: END IF;
1783:
1784: IF x_qqhv_rec.target_periods IS NULL THEN

Line 1786: ELSIF x_qqhv_rec.target_periods = FND_API.G_MISS_NUM THEN

1782: END IF;
1783:
1784: IF x_qqhv_rec.target_periods IS NULL THEN
1785: x_qqhv_rec.target_periods := l_db_qqhv_rec.target_periods;
1786: ELSIF x_qqhv_rec.target_periods = FND_API.G_MISS_NUM THEN
1787: x_qqhv_rec.target_periods := null;
1788: END IF;
1789:
1790: IF x_qqhv_rec.iir IS NULL THEN

Line 1792: ELSIF x_qqhv_rec.iir = FND_API.G_MISS_NUM THEN

1788: END IF;
1789:
1790: IF x_qqhv_rec.iir IS NULL THEN
1791: x_qqhv_rec.iir := l_db_qqhv_rec.iir;
1792: ELSIF x_qqhv_rec.iir = FND_API.G_MISS_NUM THEN
1793: x_qqhv_rec.iir := null;
1794: END IF;
1795:
1796: IF x_qqhv_rec.sub_iir IS NULL THEN

Line 1798: ELSIF x_qqhv_rec.sub_iir = FND_API.G_MISS_NUM THEN

1794: END IF;
1795:
1796: IF x_qqhv_rec.sub_iir IS NULL THEN
1797: x_qqhv_rec.sub_iir := l_db_qqhv_rec.sub_iir;
1798: ELSIF x_qqhv_rec.sub_iir = FND_API.G_MISS_NUM THEN
1799: x_qqhv_rec.sub_iir := null;
1800: END IF;
1801:
1802: IF x_qqhv_rec.booking_yield IS NULL THEN

Line 1804: ELSIF x_qqhv_rec.booking_yield = FND_API.G_MISS_NUM THEN

1800: END IF;
1801:
1802: IF x_qqhv_rec.booking_yield IS NULL THEN
1803: x_qqhv_rec.booking_yield := l_db_qqhv_rec.booking_yield;
1804: ELSIF x_qqhv_rec.booking_yield = FND_API.G_MISS_NUM THEN
1805: x_qqhv_rec.booking_yield := null;
1806: END IF;
1807:
1808: IF x_qqhv_rec.sub_booking_yield IS NULL THEN

Line 1810: ELSIF x_qqhv_rec.sub_booking_yield = FND_API.G_MISS_NUM THEN

1806: END IF;
1807:
1808: IF x_qqhv_rec.sub_booking_yield IS NULL THEN
1809: x_qqhv_rec.sub_booking_yield := l_db_qqhv_rec.sub_booking_yield;
1810: ELSIF x_qqhv_rec.sub_booking_yield = FND_API.G_MISS_NUM THEN
1811: x_qqhv_rec.sub_booking_yield := null;
1812: END IF;
1813:
1814: IF x_qqhv_rec.pirr IS NULL THEN

Line 1816: ELSIF x_qqhv_rec.pirr = FND_API.G_MISS_NUM THEN

1812: END IF;
1813:
1814: IF x_qqhv_rec.pirr IS NULL THEN
1815: x_qqhv_rec.pirr := l_db_qqhv_rec.pirr;
1816: ELSIF x_qqhv_rec.pirr = FND_API.G_MISS_NUM THEN
1817: x_qqhv_rec.pirr := null;
1818: END IF;
1819:
1820: IF x_qqhv_rec.sub_pirr IS NULL THEN

Line 1822: ELSIF x_qqhv_rec.sub_pirr = FND_API.G_MISS_NUM THEN

1818: END IF;
1819:
1820: IF x_qqhv_rec.sub_pirr IS NULL THEN
1821: x_qqhv_rec.sub_pirr := l_db_qqhv_rec.sub_pirr;
1822: ELSIF x_qqhv_rec.sub_pirr = FND_API.G_MISS_NUM THEN
1823: x_qqhv_rec.sub_pirr := null;
1824: END IF;
1825:
1826: IF x_qqhv_rec.airr IS NULL THEN

Line 1828: ELSIF x_qqhv_rec.airr = FND_API.G_MISS_NUM THEN

1824: END IF;
1825:
1826: IF x_qqhv_rec.airr IS NULL THEN
1827: x_qqhv_rec.airr := l_db_qqhv_rec.airr;
1828: ELSIF x_qqhv_rec.airr = FND_API.G_MISS_NUM THEN
1829: x_qqhv_rec.airr := null;
1830: END IF;
1831:
1832: IF x_qqhv_rec.sub_airr IS NULL THEN

Line 1834: ELSIF x_qqhv_rec.sub_airr = FND_API.G_MISS_NUM THEN

1830: END IF;
1831:
1832: IF x_qqhv_rec.sub_airr IS NULL THEN
1833: x_qqhv_rec.sub_airr := l_db_qqhv_rec.sub_airr;
1834: ELSIF x_qqhv_rec.sub_airr = FND_API.G_MISS_NUM THEN
1835: x_qqhv_rec.sub_airr := null;
1836: END IF;
1837:
1838: IF x_qqhv_rec.short_description IS NULL THEN

Line 1840: ELSIF x_qqhv_rec.short_description = FND_API.G_MISS_CHAR THEN

1836: END IF;
1837:
1838: IF x_qqhv_rec.short_description IS NULL THEN
1839: x_qqhv_rec.short_description := l_db_qqhv_rec.short_description;
1840: ELSIF x_qqhv_rec.short_description = FND_API.G_MISS_CHAR THEN
1841: x_qqhv_rec.short_description := null;
1842: END IF;
1843:
1844: IF x_qqhv_rec.description IS NULL THEN

Line 1846: ELSIF x_qqhv_rec.description = FND_API.G_MISS_CHAR THEN

1842: END IF;
1843:
1844: IF x_qqhv_rec.description IS NULL THEN
1845: x_qqhv_rec.description := l_db_qqhv_rec.description;
1846: ELSIF x_qqhv_rec.description = FND_API.G_MISS_CHAR THEN
1847: x_qqhv_rec.description := null;
1848: END IF;
1849:
1850: IF x_qqhv_rec.comments IS NULL THEN

Line 1852: ELSIF x_qqhv_rec.comments = FND_API.G_MISS_CHAR THEN

1848: END IF;
1849:
1850: IF x_qqhv_rec.comments IS NULL THEN
1851: x_qqhv_rec.comments := l_db_qqhv_rec.comments;
1852: ELSIF x_qqhv_rec.comments = FND_API.G_MISS_CHAR THEN
1853: x_qqhv_rec.comments := null;
1854: END IF;
1855:
1856: IF x_qqhv_rec.sts_code IS NULL THEN

Line 1858: ELSIF x_qqhv_rec.sts_code = FND_API.G_MISS_CHAR THEN

1854: END IF;
1855:
1856: IF x_qqhv_rec.sts_code IS NULL THEN
1857: x_qqhv_rec.sts_code := l_db_qqhv_rec.sts_code;
1858: ELSIF x_qqhv_rec.sts_code = FND_API.G_MISS_CHAR THEN
1859: x_qqhv_rec.sts_code := null;
1860: END IF;
1861: -- smadhava - Modified - G_MISS compliance - End
1862: