APPS.HZ_CREDIT_RATINGS_PKG dependencies on FND_API

Line 229: FND_API.G_MISS_NUM, HZ_CREDIT_RATINGS_S.NEXTVAL,

225: actual_content_source
226: )
227: VALUES (
228: DECODE(x_credit_rating_id,
229: FND_API.G_MISS_NUM, HZ_CREDIT_RATINGS_S.NEXTVAL,
230: NULL, HZ_CREDIT_RATINGS_S.NEXTVAL,
231: x_credit_rating_id),
232: DECODE(x_description,
233: FND_API.G_MISS_CHAR, NULL,

Line 233: FND_API.G_MISS_CHAR, NULL,

229: FND_API.G_MISS_NUM, HZ_CREDIT_RATINGS_S.NEXTVAL,
230: NULL, HZ_CREDIT_RATINGS_S.NEXTVAL,
231: x_credit_rating_id),
232: DECODE(x_description,
233: FND_API.G_MISS_CHAR, NULL,
234: x_description),
235: DECODE(x_party_id,
236: FND_API.G_MISS_NUM, NULL,
237: x_party_id),

Line 236: FND_API.G_MISS_NUM, NULL,

232: DECODE(x_description,
233: FND_API.G_MISS_CHAR, NULL,
234: x_description),
235: DECODE(x_party_id,
236: FND_API.G_MISS_NUM, NULL,
237: x_party_id),
238: DECODE(x_rating,
239: FND_API.G_MISS_CHAR, NULL,
240: x_rating),

Line 239: FND_API.G_MISS_CHAR, NULL,

235: DECODE(x_party_id,
236: FND_API.G_MISS_NUM, NULL,
237: x_party_id),
238: DECODE(x_rating,
239: FND_API.G_MISS_CHAR, NULL,
240: x_rating),
241: --Bug 3090928
242: trunc(DECODE(x_rated_as_of_date,
243: FND_API.G_MISS_DATE, TO_DATE(NULL),

Line 243: FND_API.G_MISS_DATE, TO_DATE(NULL),

239: FND_API.G_MISS_CHAR, NULL,
240: x_rating),
241: --Bug 3090928
242: trunc(DECODE(x_rated_as_of_date,
243: FND_API.G_MISS_DATE, TO_DATE(NULL),
244: x_rated_as_of_date)),
245: DECODE(x_rating_organization,
246: FND_API.G_MISS_CHAR, NULL,
247: x_rating_organization),

Line 246: FND_API.G_MISS_CHAR, NULL,

242: trunc(DECODE(x_rated_as_of_date,
243: FND_API.G_MISS_DATE, TO_DATE(NULL),
244: x_rated_as_of_date)),
245: DECODE(x_rating_organization,
246: FND_API.G_MISS_CHAR, NULL,
247: x_rating_organization),
248: hz_utility_v2pub.created_by,
249: hz_utility_v2pub.creation_date,
250: hz_utility_v2pub.last_update_login,

Line 257: FND_API.G_MISS_DATE,

253: hz_utility_v2pub.request_id,
254: hz_utility_v2pub.program_application_id,
255: hz_utility_v2pub.program_id,
256: hz_utility_v2pub.program_update_date,
257: FND_API.G_MISS_DATE,
258: DECODE(x_comments,
259: FND_API.G_MISS_CHAR, NULL,
260: x_comments),
261: DECODE(x_det_history_ind,

Line 259: FND_API.G_MISS_CHAR, NULL,

255: hz_utility_v2pub.program_id,
256: hz_utility_v2pub.program_update_date,
257: FND_API.G_MISS_DATE,
258: DECODE(x_comments,
259: FND_API.G_MISS_CHAR, NULL,
260: x_comments),
261: DECODE(x_det_history_ind,
262: FND_API.G_MISS_CHAR, NULL,
263: x_det_history_ind),

Line 262: FND_API.G_MISS_CHAR, NULL,

258: DECODE(x_comments,
259: FND_API.G_MISS_CHAR, NULL,
260: x_comments),
261: DECODE(x_det_history_ind,
262: FND_API.G_MISS_CHAR, NULL,
263: x_det_history_ind),
264: DECODE(x_fincl_embt_ind,
265: FND_API.G_MISS_CHAR, NULL,
266: x_fincl_embt_ind),

Line 265: FND_API.G_MISS_CHAR, NULL,

261: DECODE(x_det_history_ind,
262: FND_API.G_MISS_CHAR, NULL,
263: x_det_history_ind),
264: DECODE(x_fincl_embt_ind,
265: FND_API.G_MISS_CHAR, NULL,
266: x_fincl_embt_ind),
267: DECODE(x_criminal_proceeding_ind,
268: FND_API.G_MISS_CHAR, NULL,
269: x_criminal_proceeding_ind),

Line 268: FND_API.G_MISS_CHAR, NULL,

264: DECODE(x_fincl_embt_ind,
265: FND_API.G_MISS_CHAR, NULL,
266: x_fincl_embt_ind),
267: DECODE(x_criminal_proceeding_ind,
268: FND_API.G_MISS_CHAR, NULL,
269: x_criminal_proceeding_ind),
270: DECODE(x_suit_judge_ind,
271: FND_API.G_MISS_CHAR, NULL,
272: x_suit_judge_ind),

Line 271: FND_API.G_MISS_CHAR, NULL,

267: DECODE(x_criminal_proceeding_ind,
268: FND_API.G_MISS_CHAR, NULL,
269: x_criminal_proceeding_ind),
270: DECODE(x_suit_judge_ind,
271: FND_API.G_MISS_CHAR, NULL,
272: x_suit_judge_ind),
273: DECODE(x_claims_ind,
274: FND_API.G_MISS_CHAR, NULL,
275: x_claims_ind),

Line 274: FND_API.G_MISS_CHAR, NULL,

270: DECODE(x_suit_judge_ind,
271: FND_API.G_MISS_CHAR, NULL,
272: x_suit_judge_ind),
273: DECODE(x_claims_ind,
274: FND_API.G_MISS_CHAR, NULL,
275: x_claims_ind),
276: DECODE(x_secured_flng_ind,
277: FND_API.G_MISS_CHAR, NULL,
278: x_secured_flng_ind),

Line 277: FND_API.G_MISS_CHAR, NULL,

273: DECODE(x_claims_ind,
274: FND_API.G_MISS_CHAR, NULL,
275: x_claims_ind),
276: DECODE(x_secured_flng_ind,
277: FND_API.G_MISS_CHAR, NULL,
278: x_secured_flng_ind),
279: DECODE(x_fincl_lgl_event_ind,
280: FND_API.G_MISS_CHAR, NULL,
281: x_fincl_lgl_event_ind),

Line 280: FND_API.G_MISS_CHAR, NULL,

276: DECODE(x_secured_flng_ind,
277: FND_API.G_MISS_CHAR, NULL,
278: x_secured_flng_ind),
279: DECODE(x_fincl_lgl_event_ind,
280: FND_API.G_MISS_CHAR, NULL,
281: x_fincl_lgl_event_ind),
282: DECODE(x_disaster_ind,
283: FND_API.G_MISS_CHAR, NULL,
284: x_disaster_ind),

Line 283: FND_API.G_MISS_CHAR, NULL,

279: DECODE(x_fincl_lgl_event_ind,
280: FND_API.G_MISS_CHAR, NULL,
281: x_fincl_lgl_event_ind),
282: DECODE(x_disaster_ind,
283: FND_API.G_MISS_CHAR, NULL,
284: x_disaster_ind),
285: DECODE(x_oprg_spec_evnt_ind,
286: FND_API.G_MISS_CHAR, NULL,
287: x_oprg_spec_evnt_ind),

Line 286: FND_API.G_MISS_CHAR, NULL,

282: DECODE(x_disaster_ind,
283: FND_API.G_MISS_CHAR, NULL,
284: x_disaster_ind),
285: DECODE(x_oprg_spec_evnt_ind,
286: FND_API.G_MISS_CHAR, NULL,
287: x_oprg_spec_evnt_ind),
288: DECODE(x_other_spec_evnt_ind,
289: FND_API.G_MISS_CHAR, NULL,
290: x_other_spec_evnt_ind),

Line 289: FND_API.G_MISS_CHAR, NULL,

285: DECODE(x_oprg_spec_evnt_ind,
286: FND_API.G_MISS_CHAR, NULL,
287: x_oprg_spec_evnt_ind),
288: DECODE(x_other_spec_evnt_ind,
289: FND_API.G_MISS_CHAR, NULL,
290: x_other_spec_evnt_ind),
291: DECODE(x_content_source_type,
292: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
293: NULL, G_MISS_CONTENT_SOURCE_TYPE,

Line 292: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,

288: DECODE(x_other_spec_evnt_ind,
289: FND_API.G_MISS_CHAR, NULL,
290: x_other_spec_evnt_ind),
291: DECODE(x_content_source_type,
292: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
293: NULL, G_MISS_CONTENT_SOURCE_TYPE,
294: x_content_source_type),
295: DECODE(x_status,
296: FND_API.G_MISS_CHAR, 'A',

Line 296: FND_API.G_MISS_CHAR, 'A',

292: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
293: NULL, G_MISS_CONTENT_SOURCE_TYPE,
294: x_content_source_type),
295: DECODE(x_status,
296: FND_API.G_MISS_CHAR, 'A',
297: NULL, 'A',
298: x_status),
299: DECODE(x_object_version_number,
300: FND_API.G_MISS_NUM, NULL,

Line 300: FND_API.G_MISS_NUM, NULL,

296: FND_API.G_MISS_CHAR, 'A',
297: NULL, 'A',
298: x_status),
299: DECODE(x_object_version_number,
300: FND_API.G_MISS_NUM, NULL,
301: x_object_version_number),
302: DECODE(x_created_by_module,
303: FND_API.G_MISS_CHAR, NULL,
304: x_created_by_module),

Line 303: FND_API.G_MISS_CHAR, NULL,

299: DECODE(x_object_version_number,
300: FND_API.G_MISS_NUM, NULL,
301: x_object_version_number),
302: DECODE(x_created_by_module,
303: FND_API.G_MISS_CHAR, NULL,
304: x_created_by_module),
305: hz_utility_v2pub.application_id,
306: DECODE(x_avg_high_credit,
307: FND_API.G_MISS_NUM, NULL,

Line 307: FND_API.G_MISS_NUM, NULL,

303: FND_API.G_MISS_CHAR, NULL,
304: x_created_by_module),
305: hz_utility_v2pub.application_id,
306: DECODE(x_avg_high_credit,
307: FND_API.G_MISS_NUM, NULL,
308: x_avg_high_credit),
309: DECODE(x_credit_score,
310: FND_API.G_MISS_CHAR, NULL,
311: x_credit_score),

Line 310: FND_API.G_MISS_CHAR, NULL,

306: DECODE(x_avg_high_credit,
307: FND_API.G_MISS_NUM, NULL,
308: x_avg_high_credit),
309: DECODE(x_credit_score,
310: FND_API.G_MISS_CHAR, NULL,
311: x_credit_score),
312: DECODE(x_credit_score_age,
313: FND_API.G_MISS_NUM, NULL,
314: x_credit_score_age),

Line 313: FND_API.G_MISS_NUM, NULL,

309: DECODE(x_credit_score,
310: FND_API.G_MISS_CHAR, NULL,
311: x_credit_score),
312: DECODE(x_credit_score_age,
313: FND_API.G_MISS_NUM, NULL,
314: x_credit_score_age),
315: DECODE(x_credit_score_class,
316: FND_API.G_MISS_NUM, NULL,
317: x_credit_score_class),

Line 316: FND_API.G_MISS_NUM, NULL,

312: DECODE(x_credit_score_age,
313: FND_API.G_MISS_NUM, NULL,
314: x_credit_score_age),
315: DECODE(x_credit_score_class,
316: FND_API.G_MISS_NUM, NULL,
317: x_credit_score_class),
318: DECODE(x_credit_score_commentary,
319: FND_API.G_MISS_CHAR, NULL,
320: x_credit_score_commentary),

Line 319: FND_API.G_MISS_CHAR, NULL,

315: DECODE(x_credit_score_class,
316: FND_API.G_MISS_NUM, NULL,
317: x_credit_score_class),
318: DECODE(x_credit_score_commentary,
319: FND_API.G_MISS_CHAR, NULL,
320: x_credit_score_commentary),
321: DECODE(x_credit_score_commentary2,
322: FND_API.G_MISS_CHAR, NULL,
323: x_credit_score_commentary2),

Line 322: FND_API.G_MISS_CHAR, NULL,

318: DECODE(x_credit_score_commentary,
319: FND_API.G_MISS_CHAR, NULL,
320: x_credit_score_commentary),
321: DECODE(x_credit_score_commentary2,
322: FND_API.G_MISS_CHAR, NULL,
323: x_credit_score_commentary2),
324: DECODE(x_credit_score_commentary3,
325: FND_API.G_MISS_CHAR, NULL,
326: x_credit_score_commentary3),

Line 325: FND_API.G_MISS_CHAR, NULL,

321: DECODE(x_credit_score_commentary2,
322: FND_API.G_MISS_CHAR, NULL,
323: x_credit_score_commentary2),
324: DECODE(x_credit_score_commentary3,
325: FND_API.G_MISS_CHAR, NULL,
326: x_credit_score_commentary3),
327: DECODE(x_credit_score_commentary4,
328: FND_API.G_MISS_CHAR, NULL,
329: x_credit_score_commentary4),

Line 328: FND_API.G_MISS_CHAR, NULL,

324: DECODE(x_credit_score_commentary3,
325: FND_API.G_MISS_CHAR, NULL,
326: x_credit_score_commentary3),
327: DECODE(x_credit_score_commentary4,
328: FND_API.G_MISS_CHAR, NULL,
329: x_credit_score_commentary4),
330: DECODE(x_credit_score_commentary5,
331: FND_API.G_MISS_CHAR, NULL,
332: x_credit_score_commentary5),

Line 331: FND_API.G_MISS_CHAR, NULL,

327: DECODE(x_credit_score_commentary4,
328: FND_API.G_MISS_CHAR, NULL,
329: x_credit_score_commentary4),
330: DECODE(x_credit_score_commentary5,
331: FND_API.G_MISS_CHAR, NULL,
332: x_credit_score_commentary5),
333: DECODE(x_credit_score_commentary6,
334: FND_API.G_MISS_CHAR, NULL,
335: x_credit_score_commentary6),

Line 334: FND_API.G_MISS_CHAR, NULL,

330: DECODE(x_credit_score_commentary5,
331: FND_API.G_MISS_CHAR, NULL,
332: x_credit_score_commentary5),
333: DECODE(x_credit_score_commentary6,
334: FND_API.G_MISS_CHAR, NULL,
335: x_credit_score_commentary6),
336: DECODE(x_credit_score_commentary7,
337: FND_API.G_MISS_CHAR, NULL,
338: x_credit_score_commentary7),

Line 337: FND_API.G_MISS_CHAR, NULL,

333: DECODE(x_credit_score_commentary6,
334: FND_API.G_MISS_CHAR, NULL,
335: x_credit_score_commentary6),
336: DECODE(x_credit_score_commentary7,
337: FND_API.G_MISS_CHAR, NULL,
338: x_credit_score_commentary7),
339: DECODE(x_credit_score_commentary8,
340: FND_API.G_MISS_CHAR, NULL,
341: x_credit_score_commentary8),

Line 340: FND_API.G_MISS_CHAR, NULL,

336: DECODE(x_credit_score_commentary7,
337: FND_API.G_MISS_CHAR, NULL,
338: x_credit_score_commentary7),
339: DECODE(x_credit_score_commentary8,
340: FND_API.G_MISS_CHAR, NULL,
341: x_credit_score_commentary8),
342: DECODE(x_credit_score_commentary9,
343: FND_API.G_MISS_CHAR, NULL,
344: x_credit_score_commentary9),

Line 343: FND_API.G_MISS_CHAR, NULL,

339: DECODE(x_credit_score_commentary8,
340: FND_API.G_MISS_CHAR, NULL,
341: x_credit_score_commentary8),
342: DECODE(x_credit_score_commentary9,
343: FND_API.G_MISS_CHAR, NULL,
344: x_credit_score_commentary9),
345: DECODE(x_credit_score_commentary10,
346: FND_API.G_MISS_CHAR, NULL,
347: x_credit_score_commentary10),

Line 346: FND_API.G_MISS_CHAR, NULL,

342: DECODE(x_credit_score_commentary9,
343: FND_API.G_MISS_CHAR, NULL,
344: x_credit_score_commentary9),
345: DECODE(x_credit_score_commentary10,
346: FND_API.G_MISS_CHAR, NULL,
347: x_credit_score_commentary10),
348: DECODE(x_credit_score_date,
349: FND_API.G_MISS_DATE, TO_DATE(NULL),
350: x_credit_score_date),

Line 349: FND_API.G_MISS_DATE, TO_DATE(NULL),

345: DECODE(x_credit_score_commentary10,
346: FND_API.G_MISS_CHAR, NULL,
347: x_credit_score_commentary10),
348: DECODE(x_credit_score_date,
349: FND_API.G_MISS_DATE, TO_DATE(NULL),
350: x_credit_score_date),
351: DECODE(x_credit_score_incd_default,
352: FND_API.G_MISS_NUM, NULL,
353: x_credit_score_incd_default),

Line 352: FND_API.G_MISS_NUM, NULL,

348: DECODE(x_credit_score_date,
349: FND_API.G_MISS_DATE, TO_DATE(NULL),
350: x_credit_score_date),
351: DECODE(x_credit_score_incd_default,
352: FND_API.G_MISS_NUM, NULL,
353: x_credit_score_incd_default),
354: DECODE(x_credit_score_natl_percentile,
355: FND_API.G_MISS_NUM, NULL,
356: x_credit_score_natl_percentile),

Line 355: FND_API.G_MISS_NUM, NULL,

351: DECODE(x_credit_score_incd_default,
352: FND_API.G_MISS_NUM, NULL,
353: x_credit_score_incd_default),
354: DECODE(x_credit_score_natl_percentile,
355: FND_API.G_MISS_NUM, NULL,
356: x_credit_score_natl_percentile),
357: DECODE(x_debarment_ind,
358: FND_API.G_MISS_CHAR, NULL,
359: x_debarment_ind),

Line 358: FND_API.G_MISS_CHAR, NULL,

354: DECODE(x_credit_score_natl_percentile,
355: FND_API.G_MISS_NUM, NULL,
356: x_credit_score_natl_percentile),
357: DECODE(x_debarment_ind,
358: FND_API.G_MISS_CHAR, NULL,
359: x_debarment_ind),
360: DECODE(x_debarments_count,
361: FND_API.G_MISS_NUM, NULL,
362: x_debarments_count),

Line 361: FND_API.G_MISS_NUM, NULL,

357: DECODE(x_debarment_ind,
358: FND_API.G_MISS_CHAR, NULL,
359: x_debarment_ind),
360: DECODE(x_debarments_count,
361: FND_API.G_MISS_NUM, NULL,
362: x_debarments_count),
363: DECODE(x_debarments_date,
364: FND_API.G_MISS_DATE, TO_DATE(NULL),
365: x_debarments_date),

Line 364: FND_API.G_MISS_DATE, TO_DATE(NULL),

360: DECODE(x_debarments_count,
361: FND_API.G_MISS_NUM, NULL,
362: x_debarments_count),
363: DECODE(x_debarments_date,
364: FND_API.G_MISS_DATE, TO_DATE(NULL),
365: x_debarments_date),
366: DECODE(x_high_credit,
367: FND_API.G_MISS_NUM, NULL,
368: x_high_credit),

Line 367: FND_API.G_MISS_NUM, NULL,

363: DECODE(x_debarments_date,
364: FND_API.G_MISS_DATE, TO_DATE(NULL),
365: x_debarments_date),
366: DECODE(x_high_credit,
367: FND_API.G_MISS_NUM, NULL,
368: x_high_credit),
369: DECODE(x_maximum_credit_currency_code,
370: FND_API.G_MISS_CHAR, NULL,
371: x_maximum_credit_currency_code),

Line 370: FND_API.G_MISS_CHAR, NULL,

366: DECODE(x_high_credit,
367: FND_API.G_MISS_NUM, NULL,
368: x_high_credit),
369: DECODE(x_maximum_credit_currency_code,
370: FND_API.G_MISS_CHAR, NULL,
371: x_maximum_credit_currency_code),
372: DECODE(x_maximum_credit_rcmd,
373: FND_API.G_MISS_NUM, NULL,
374: x_maximum_credit_rcmd),

Line 373: FND_API.G_MISS_NUM, NULL,

369: DECODE(x_maximum_credit_currency_code,
370: FND_API.G_MISS_CHAR, NULL,
371: x_maximum_credit_currency_code),
372: DECODE(x_maximum_credit_rcmd,
373: FND_API.G_MISS_NUM, NULL,
374: x_maximum_credit_rcmd),
375: DECODE(x_paydex_norm,
376: FND_API.G_MISS_CHAR, NULL,
377: x_paydex_norm),

Line 376: FND_API.G_MISS_CHAR, NULL,

372: DECODE(x_maximum_credit_rcmd,
373: FND_API.G_MISS_NUM, NULL,
374: x_maximum_credit_rcmd),
375: DECODE(x_paydex_norm,
376: FND_API.G_MISS_CHAR, NULL,
377: x_paydex_norm),
378: DECODE(x_paydex_score,
379: FND_API.G_MISS_CHAR, NULL,
380: x_paydex_score),

Line 379: FND_API.G_MISS_CHAR, NULL,

375: DECODE(x_paydex_norm,
376: FND_API.G_MISS_CHAR, NULL,
377: x_paydex_norm),
378: DECODE(x_paydex_score,
379: FND_API.G_MISS_CHAR, NULL,
380: x_paydex_score),
381: DECODE(x_paydex_three_months_ago,
382: FND_API.G_MISS_CHAR, NULL,
383: x_paydex_three_months_ago),

Line 382: FND_API.G_MISS_CHAR, NULL,

378: DECODE(x_paydex_score,
379: FND_API.G_MISS_CHAR, NULL,
380: x_paydex_score),
381: DECODE(x_paydex_three_months_ago,
382: FND_API.G_MISS_CHAR, NULL,
383: x_paydex_three_months_ago),
384: DECODE(x_credit_score_override_code,
385: FND_API.G_MISS_CHAR, NULL,
386: x_credit_score_override_code),

Line 385: FND_API.G_MISS_CHAR, NULL,

381: DECODE(x_paydex_three_months_ago,
382: FND_API.G_MISS_CHAR, NULL,
383: x_paydex_three_months_ago),
384: DECODE(x_credit_score_override_code,
385: FND_API.G_MISS_CHAR, NULL,
386: x_credit_score_override_code),
387: DECODE(x_cr_scr_clas_expl,
388: FND_API.G_MISS_CHAR, NULL,
389: x_cr_scr_clas_expl),

Line 388: FND_API.G_MISS_CHAR, NULL,

384: DECODE(x_credit_score_override_code,
385: FND_API.G_MISS_CHAR, NULL,
386: x_credit_score_override_code),
387: DECODE(x_cr_scr_clas_expl,
388: FND_API.G_MISS_CHAR, NULL,
389: x_cr_scr_clas_expl),
390: DECODE(x_low_rng_delq_scr,
391: FND_API.G_MISS_NUM, NULL,
392: x_low_rng_delq_scr),

Line 391: FND_API.G_MISS_NUM, NULL,

387: DECODE(x_cr_scr_clas_expl,
388: FND_API.G_MISS_CHAR, NULL,
389: x_cr_scr_clas_expl),
390: DECODE(x_low_rng_delq_scr,
391: FND_API.G_MISS_NUM, NULL,
392: x_low_rng_delq_scr),
393: DECODE(x_high_rng_delq_scr,
394: FND_API.G_MISS_NUM, NULL,
395: x_high_rng_delq_scr),

Line 394: FND_API.G_MISS_NUM, NULL,

390: DECODE(x_low_rng_delq_scr,
391: FND_API.G_MISS_NUM, NULL,
392: x_low_rng_delq_scr),
393: DECODE(x_high_rng_delq_scr,
394: FND_API.G_MISS_NUM, NULL,
395: x_high_rng_delq_scr),
396: DECODE(x_delq_pmt_rng_prcnt,
397: FND_API.G_MISS_NUM, NULL,
398: x_delq_pmt_rng_prcnt),

Line 397: FND_API.G_MISS_NUM, NULL,

393: DECODE(x_high_rng_delq_scr,
394: FND_API.G_MISS_NUM, NULL,
395: x_high_rng_delq_scr),
396: DECODE(x_delq_pmt_rng_prcnt,
397: FND_API.G_MISS_NUM, NULL,
398: x_delq_pmt_rng_prcnt),
399: DECODE(x_delq_pmt_pctg_for_all_firms,
400: FND_API.G_MISS_NUM, NULL,
401: x_delq_pmt_pctg_for_all_firms),

Line 400: FND_API.G_MISS_NUM, NULL,

396: DECODE(x_delq_pmt_rng_prcnt,
397: FND_API.G_MISS_NUM, NULL,
398: x_delq_pmt_rng_prcnt),
399: DECODE(x_delq_pmt_pctg_for_all_firms,
400: FND_API.G_MISS_NUM, NULL,
401: x_delq_pmt_pctg_for_all_firms),
402: DECODE(x_num_trade_experiences,
403: FND_API.G_MISS_NUM, NULL,
404: x_num_trade_experiences),

Line 403: FND_API.G_MISS_NUM, NULL,

399: DECODE(x_delq_pmt_pctg_for_all_firms,
400: FND_API.G_MISS_NUM, NULL,
401: x_delq_pmt_pctg_for_all_firms),
402: DECODE(x_num_trade_experiences,
403: FND_API.G_MISS_NUM, NULL,
404: x_num_trade_experiences),
405: DECODE(x_paydex_firm_days,
406: FND_API.G_MISS_CHAR, NULL,
407: x_paydex_firm_days),

Line 406: FND_API.G_MISS_CHAR, NULL,

402: DECODE(x_num_trade_experiences,
403: FND_API.G_MISS_NUM, NULL,
404: x_num_trade_experiences),
405: DECODE(x_paydex_firm_days,
406: FND_API.G_MISS_CHAR, NULL,
407: x_paydex_firm_days),
408: DECODE(x_paydex_firm_comment,
409: FND_API.G_MISS_CHAR, NULL,
410: x_paydex_firm_comment),

Line 409: FND_API.G_MISS_CHAR, NULL,

405: DECODE(x_paydex_firm_days,
406: FND_API.G_MISS_CHAR, NULL,
407: x_paydex_firm_days),
408: DECODE(x_paydex_firm_comment,
409: FND_API.G_MISS_CHAR, NULL,
410: x_paydex_firm_comment),
411: DECODE(x_paydex_industry_days,
412: FND_API.G_MISS_CHAR, NULL,
413: x_paydex_industry_days),

Line 412: FND_API.G_MISS_CHAR, NULL,

408: DECODE(x_paydex_firm_comment,
409: FND_API.G_MISS_CHAR, NULL,
410: x_paydex_firm_comment),
411: DECODE(x_paydex_industry_days,
412: FND_API.G_MISS_CHAR, NULL,
413: x_paydex_industry_days),
414: DECODE(x_paydex_industry_comment,
415: FND_API.G_MISS_CHAR, NULL,
416: x_paydex_industry_comment),

Line 415: FND_API.G_MISS_CHAR, NULL,

411: DECODE(x_paydex_industry_days,
412: FND_API.G_MISS_CHAR, NULL,
413: x_paydex_industry_days),
414: DECODE(x_paydex_industry_comment,
415: FND_API.G_MISS_CHAR, NULL,
416: x_paydex_industry_comment),
417: DECODE(x_paydex_comment,
418: FND_API.G_MISS_CHAR, NULL,
419: x_paydex_comment),

Line 418: FND_API.G_MISS_CHAR, NULL,

414: DECODE(x_paydex_industry_comment,
415: FND_API.G_MISS_CHAR, NULL,
416: x_paydex_industry_comment),
417: DECODE(x_paydex_comment,
418: FND_API.G_MISS_CHAR, NULL,
419: x_paydex_comment),
420: DECODE(x_suit_ind,
421: FND_API.G_MISS_CHAR, NULL,
422: x_suit_ind),

Line 421: FND_API.G_MISS_CHAR, NULL,

417: DECODE(x_paydex_comment,
418: FND_API.G_MISS_CHAR, NULL,
419: x_paydex_comment),
420: DECODE(x_suit_ind,
421: FND_API.G_MISS_CHAR, NULL,
422: x_suit_ind),
423: DECODE(x_lien_ind,
424: FND_API.G_MISS_CHAR, NULL,
425: x_lien_ind),

Line 424: FND_API.G_MISS_CHAR, NULL,

420: DECODE(x_suit_ind,
421: FND_API.G_MISS_CHAR, NULL,
422: x_suit_ind),
423: DECODE(x_lien_ind,
424: FND_API.G_MISS_CHAR, NULL,
425: x_lien_ind),
426: DECODE(x_judgement_ind,
427: FND_API.G_MISS_CHAR, NULL,
428: x_judgement_ind),

Line 427: FND_API.G_MISS_CHAR, NULL,

423: DECODE(x_lien_ind,
424: FND_API.G_MISS_CHAR, NULL,
425: x_lien_ind),
426: DECODE(x_judgement_ind,
427: FND_API.G_MISS_CHAR, NULL,
428: x_judgement_ind),
429: DECODE(x_bankruptcy_ind,
430: FND_API.G_MISS_CHAR, NULL,
431: x_bankruptcy_ind),

Line 430: FND_API.G_MISS_CHAR, NULL,

426: DECODE(x_judgement_ind,
427: FND_API.G_MISS_CHAR, NULL,
428: x_judgement_ind),
429: DECODE(x_bankruptcy_ind,
430: FND_API.G_MISS_CHAR, NULL,
431: x_bankruptcy_ind),
432: DECODE(x_no_trade_ind,
433: FND_API.G_MISS_CHAR, NULL,
434: x_no_trade_ind),

Line 433: FND_API.G_MISS_CHAR, NULL,

429: DECODE(x_bankruptcy_ind,
430: FND_API.G_MISS_CHAR, NULL,
431: x_bankruptcy_ind),
432: DECODE(x_no_trade_ind,
433: FND_API.G_MISS_CHAR, NULL,
434: x_no_trade_ind),
435: DECODE(x_prnt_hq_bkcy_ind,
436: FND_API.G_MISS_CHAR, NULL,
437: x_prnt_hq_bkcy_ind),

Line 436: FND_API.G_MISS_CHAR, NULL,

432: DECODE(x_no_trade_ind,
433: FND_API.G_MISS_CHAR, NULL,
434: x_no_trade_ind),
435: DECODE(x_prnt_hq_bkcy_ind,
436: FND_API.G_MISS_CHAR, NULL,
437: x_prnt_hq_bkcy_ind),
438: DECODE(x_num_prnt_bkcy_filing,
439: FND_API.G_MISS_NUM, NULL,
440: x_num_prnt_bkcy_filing),

Line 439: FND_API.G_MISS_NUM, NULL,

435: DECODE(x_prnt_hq_bkcy_ind,
436: FND_API.G_MISS_CHAR, NULL,
437: x_prnt_hq_bkcy_ind),
438: DECODE(x_num_prnt_bkcy_filing,
439: FND_API.G_MISS_NUM, NULL,
440: x_num_prnt_bkcy_filing),
441: DECODE(x_prnt_bkcy_filg_type,
442: FND_API.G_MISS_CHAR, NULL,
443: x_prnt_bkcy_filg_type),

Line 442: FND_API.G_MISS_CHAR, NULL,

438: DECODE(x_num_prnt_bkcy_filing,
439: FND_API.G_MISS_NUM, NULL,
440: x_num_prnt_bkcy_filing),
441: DECODE(x_prnt_bkcy_filg_type,
442: FND_API.G_MISS_CHAR, NULL,
443: x_prnt_bkcy_filg_type),
444: DECODE(x_prnt_bkcy_filg_chapter,
445: FND_API.G_MISS_NUM, NULL,
446: x_prnt_bkcy_filg_chapter),

Line 445: FND_API.G_MISS_NUM, NULL,

441: DECODE(x_prnt_bkcy_filg_type,
442: FND_API.G_MISS_CHAR, NULL,
443: x_prnt_bkcy_filg_type),
444: DECODE(x_prnt_bkcy_filg_chapter,
445: FND_API.G_MISS_NUM, NULL,
446: x_prnt_bkcy_filg_chapter),
447: DECODE(x_prnt_bkcy_filg_date,
448: FND_API.G_MISS_DATE, TO_DATE(NULL),
449: x_prnt_bkcy_filg_date),

Line 448: FND_API.G_MISS_DATE, TO_DATE(NULL),

444: DECODE(x_prnt_bkcy_filg_chapter,
445: FND_API.G_MISS_NUM, NULL,
446: x_prnt_bkcy_filg_chapter),
447: DECODE(x_prnt_bkcy_filg_date,
448: FND_API.G_MISS_DATE, TO_DATE(NULL),
449: x_prnt_bkcy_filg_date),
450: DECODE(x_num_prnt_bkcy_convs,
451: FND_API.G_MISS_NUM, NULL,
452: x_num_prnt_bkcy_convs),

Line 451: FND_API.G_MISS_NUM, NULL,

447: DECODE(x_prnt_bkcy_filg_date,
448: FND_API.G_MISS_DATE, TO_DATE(NULL),
449: x_prnt_bkcy_filg_date),
450: DECODE(x_num_prnt_bkcy_convs,
451: FND_API.G_MISS_NUM, NULL,
452: x_num_prnt_bkcy_convs),
453: DECODE(x_prnt_bkcy_conv_date,
454: FND_API.G_MISS_DATE, TO_DATE(NULL),
455: x_prnt_bkcy_conv_date),

Line 454: FND_API.G_MISS_DATE, TO_DATE(NULL),

450: DECODE(x_num_prnt_bkcy_convs,
451: FND_API.G_MISS_NUM, NULL,
452: x_num_prnt_bkcy_convs),
453: DECODE(x_prnt_bkcy_conv_date,
454: FND_API.G_MISS_DATE, TO_DATE(NULL),
455: x_prnt_bkcy_conv_date),
456: DECODE(x_prnt_bkcy_chapter_conv,
457: FND_API.G_MISS_CHAR, NULL,
458: x_prnt_bkcy_chapter_conv),

Line 457: FND_API.G_MISS_CHAR, NULL,

453: DECODE(x_prnt_bkcy_conv_date,
454: FND_API.G_MISS_DATE, TO_DATE(NULL),
455: x_prnt_bkcy_conv_date),
456: DECODE(x_prnt_bkcy_chapter_conv,
457: FND_API.G_MISS_CHAR, NULL,
458: x_prnt_bkcy_chapter_conv),
459: DECODE(x_slow_trade_expl,
460: FND_API.G_MISS_CHAR, NULL,
461: x_slow_trade_expl),

Line 460: FND_API.G_MISS_CHAR, NULL,

456: DECODE(x_prnt_bkcy_chapter_conv,
457: FND_API.G_MISS_CHAR, NULL,
458: x_prnt_bkcy_chapter_conv),
459: DECODE(x_slow_trade_expl,
460: FND_API.G_MISS_CHAR, NULL,
461: x_slow_trade_expl),
462: DECODE(x_negv_pmt_expl,
463: FND_API.G_MISS_CHAR, NULL,
464: x_negv_pmt_expl),

Line 463: FND_API.G_MISS_CHAR, NULL,

459: DECODE(x_slow_trade_expl,
460: FND_API.G_MISS_CHAR, NULL,
461: x_slow_trade_expl),
462: DECODE(x_negv_pmt_expl,
463: FND_API.G_MISS_CHAR, NULL,
464: x_negv_pmt_expl),
465: DECODE(x_pub_rec_expl,
466: FND_API.G_MISS_CHAR, NULL,
467: x_pub_rec_expl),

Line 466: FND_API.G_MISS_CHAR, NULL,

462: DECODE(x_negv_pmt_expl,
463: FND_API.G_MISS_CHAR, NULL,
464: x_negv_pmt_expl),
465: DECODE(x_pub_rec_expl,
466: FND_API.G_MISS_CHAR, NULL,
467: x_pub_rec_expl),
468: DECODE(x_business_discontinued,
469: FND_API.G_MISS_CHAR, NULL,
470: x_business_discontinued),

Line 469: FND_API.G_MISS_CHAR, NULL,

465: DECODE(x_pub_rec_expl,
466: FND_API.G_MISS_CHAR, NULL,
467: x_pub_rec_expl),
468: DECODE(x_business_discontinued,
469: FND_API.G_MISS_CHAR, NULL,
470: x_business_discontinued),
471: DECODE(x_spcl_event_comment,
472: FND_API.G_MISS_CHAR, NULL,
473: x_spcl_event_comment),

Line 472: FND_API.G_MISS_CHAR, NULL,

468: DECODE(x_business_discontinued,
469: FND_API.G_MISS_CHAR, NULL,
470: x_business_discontinued),
471: DECODE(x_spcl_event_comment,
472: FND_API.G_MISS_CHAR, NULL,
473: x_spcl_event_comment),
474: DECODE(x_num_spcl_event,
475: FND_API.G_MISS_NUM, NULL,
476: x_num_spcl_event),

Line 475: FND_API.G_MISS_NUM, NULL,

471: DECODE(x_spcl_event_comment,
472: FND_API.G_MISS_CHAR, NULL,
473: x_spcl_event_comment),
474: DECODE(x_num_spcl_event,
475: FND_API.G_MISS_NUM, NULL,
476: x_num_spcl_event),
477: DECODE(x_spcl_event_update_date,
478: FND_API.G_MISS_DATE, TO_DATE(NULL),
479: x_spcl_event_update_date),

Line 478: FND_API.G_MISS_DATE, TO_DATE(NULL),

474: DECODE(x_num_spcl_event,
475: FND_API.G_MISS_NUM, NULL,
476: x_num_spcl_event),
477: DECODE(x_spcl_event_update_date,
478: FND_API.G_MISS_DATE, TO_DATE(NULL),
479: x_spcl_event_update_date),
480: DECODE(x_spcl_evnt_txt,
481: FND_API.G_MISS_CHAR, NULL,
482: x_spcl_evnt_txt),

Line 481: FND_API.G_MISS_CHAR, NULL,

477: DECODE(x_spcl_event_update_date,
478: FND_API.G_MISS_DATE, TO_DATE(NULL),
479: x_spcl_event_update_date),
480: DECODE(x_spcl_evnt_txt,
481: FND_API.G_MISS_CHAR, NULL,
482: x_spcl_evnt_txt),
483: DECODE(x_failure_score,
484: FND_API.G_MISS_CHAR, NULL,
485: x_failure_score),

Line 484: FND_API.G_MISS_CHAR, NULL,

480: DECODE(x_spcl_evnt_txt,
481: FND_API.G_MISS_CHAR, NULL,
482: x_spcl_evnt_txt),
483: DECODE(x_failure_score,
484: FND_API.G_MISS_CHAR, NULL,
485: x_failure_score),
486: DECODE(x_failure_score_age,
487: FND_API.G_MISS_NUM, NULL,
488: x_failure_score_age),

Line 487: FND_API.G_MISS_NUM, NULL,

483: DECODE(x_failure_score,
484: FND_API.G_MISS_CHAR, NULL,
485: x_failure_score),
486: DECODE(x_failure_score_age,
487: FND_API.G_MISS_NUM, NULL,
488: x_failure_score_age),
489: DECODE(x_failure_score_class,
490: FND_API.G_MISS_NUM, NULL,
491: x_failure_score_class),

Line 490: FND_API.G_MISS_NUM, NULL,

486: DECODE(x_failure_score_age,
487: FND_API.G_MISS_NUM, NULL,
488: x_failure_score_age),
489: DECODE(x_failure_score_class,
490: FND_API.G_MISS_NUM, NULL,
491: x_failure_score_class),
492: DECODE(x_failure_score_commentary,
493: FND_API.G_MISS_CHAR, NULL,
494: x_failure_score_commentary),

Line 493: FND_API.G_MISS_CHAR, NULL,

489: DECODE(x_failure_score_class,
490: FND_API.G_MISS_NUM, NULL,
491: x_failure_score_class),
492: DECODE(x_failure_score_commentary,
493: FND_API.G_MISS_CHAR, NULL,
494: x_failure_score_commentary),
495: DECODE(x_failure_score_commentary2,
496: FND_API.G_MISS_CHAR, NULL,
497: x_failure_score_commentary2),

Line 496: FND_API.G_MISS_CHAR, NULL,

492: DECODE(x_failure_score_commentary,
493: FND_API.G_MISS_CHAR, NULL,
494: x_failure_score_commentary),
495: DECODE(x_failure_score_commentary2,
496: FND_API.G_MISS_CHAR, NULL,
497: x_failure_score_commentary2),
498: DECODE(x_failure_score_commentary3,
499: FND_API.G_MISS_CHAR, NULL,
500: x_failure_score_commentary3),

Line 499: FND_API.G_MISS_CHAR, NULL,

495: DECODE(x_failure_score_commentary2,
496: FND_API.G_MISS_CHAR, NULL,
497: x_failure_score_commentary2),
498: DECODE(x_failure_score_commentary3,
499: FND_API.G_MISS_CHAR, NULL,
500: x_failure_score_commentary3),
501: DECODE(x_failure_score_commentary4,
502: FND_API.G_MISS_CHAR, NULL,
503: x_failure_score_commentary4),

Line 502: FND_API.G_MISS_CHAR, NULL,

498: DECODE(x_failure_score_commentary3,
499: FND_API.G_MISS_CHAR, NULL,
500: x_failure_score_commentary3),
501: DECODE(x_failure_score_commentary4,
502: FND_API.G_MISS_CHAR, NULL,
503: x_failure_score_commentary4),
504: DECODE(x_failure_score_commentary5,
505: FND_API.G_MISS_CHAR, NULL,
506: x_failure_score_commentary5),

Line 505: FND_API.G_MISS_CHAR, NULL,

501: DECODE(x_failure_score_commentary4,
502: FND_API.G_MISS_CHAR, NULL,
503: x_failure_score_commentary4),
504: DECODE(x_failure_score_commentary5,
505: FND_API.G_MISS_CHAR, NULL,
506: x_failure_score_commentary5),
507: DECODE(x_failure_score_commentary6,
508: FND_API.G_MISS_CHAR, NULL,
509: x_failure_score_commentary6),

Line 508: FND_API.G_MISS_CHAR, NULL,

504: DECODE(x_failure_score_commentary5,
505: FND_API.G_MISS_CHAR, NULL,
506: x_failure_score_commentary5),
507: DECODE(x_failure_score_commentary6,
508: FND_API.G_MISS_CHAR, NULL,
509: x_failure_score_commentary6),
510: DECODE(x_failure_score_commentary7,
511: FND_API.G_MISS_CHAR, NULL,
512: x_failure_score_commentary7),

Line 511: FND_API.G_MISS_CHAR, NULL,

507: DECODE(x_failure_score_commentary6,
508: FND_API.G_MISS_CHAR, NULL,
509: x_failure_score_commentary6),
510: DECODE(x_failure_score_commentary7,
511: FND_API.G_MISS_CHAR, NULL,
512: x_failure_score_commentary7),
513: DECODE(x_failure_score_commentary8,
514: FND_API.G_MISS_CHAR, NULL,
515: x_failure_score_commentary8),

Line 514: FND_API.G_MISS_CHAR, NULL,

510: DECODE(x_failure_score_commentary7,
511: FND_API.G_MISS_CHAR, NULL,
512: x_failure_score_commentary7),
513: DECODE(x_failure_score_commentary8,
514: FND_API.G_MISS_CHAR, NULL,
515: x_failure_score_commentary8),
516: DECODE(x_failure_score_commentary9,
517: FND_API.G_MISS_CHAR, NULL,
518: x_failure_score_commentary9),

Line 517: FND_API.G_MISS_CHAR, NULL,

513: DECODE(x_failure_score_commentary8,
514: FND_API.G_MISS_CHAR, NULL,
515: x_failure_score_commentary8),
516: DECODE(x_failure_score_commentary9,
517: FND_API.G_MISS_CHAR, NULL,
518: x_failure_score_commentary9),
519: DECODE(x_failure_score_commentary10,
520: FND_API.G_MISS_CHAR, NULL,
521: x_failure_score_commentary10),

Line 520: FND_API.G_MISS_CHAR, NULL,

516: DECODE(x_failure_score_commentary9,
517: FND_API.G_MISS_CHAR, NULL,
518: x_failure_score_commentary9),
519: DECODE(x_failure_score_commentary10,
520: FND_API.G_MISS_CHAR, NULL,
521: x_failure_score_commentary10),
522: DECODE(x_failure_score_date,
523: FND_API.G_MISS_DATE, TO_DATE(NULL),
524: x_failure_score_date),

Line 523: FND_API.G_MISS_DATE, TO_DATE(NULL),

519: DECODE(x_failure_score_commentary10,
520: FND_API.G_MISS_CHAR, NULL,
521: x_failure_score_commentary10),
522: DECODE(x_failure_score_date,
523: FND_API.G_MISS_DATE, TO_DATE(NULL),
524: x_failure_score_date),
525: DECODE(x_failure_score_incd_default,
526: FND_API.G_MISS_NUM, NULL,
527: x_failure_score_incd_default),

Line 526: FND_API.G_MISS_NUM, NULL,

522: DECODE(x_failure_score_date,
523: FND_API.G_MISS_DATE, TO_DATE(NULL),
524: x_failure_score_date),
525: DECODE(x_failure_score_incd_default,
526: FND_API.G_MISS_NUM, NULL,
527: x_failure_score_incd_default),
528: DECODE(x_fail_score_natnl_percentile,
529: FND_API.G_MISS_NUM, NULL,
530: x_fail_score_natnl_percentile),

Line 529: FND_API.G_MISS_NUM, NULL,

525: DECODE(x_failure_score_incd_default,
526: FND_API.G_MISS_NUM, NULL,
527: x_failure_score_incd_default),
528: DECODE(x_fail_score_natnl_percentile,
529: FND_API.G_MISS_NUM, NULL,
530: x_fail_score_natnl_percentile),
531: DECODE(x_failure_score_override_code,
532: FND_API.G_MISS_CHAR, NULL,
533: x_failure_score_override_code),

Line 532: FND_API.G_MISS_CHAR, NULL,

528: DECODE(x_fail_score_natnl_percentile,
529: FND_API.G_MISS_NUM, NULL,
530: x_fail_score_natnl_percentile),
531: DECODE(x_failure_score_override_code,
532: FND_API.G_MISS_CHAR, NULL,
533: x_failure_score_override_code),
534: DECODE(x_global_failure_score,
535: FND_API.G_MISS_CHAR, NULL,
536: x_global_failure_score),

Line 535: FND_API.G_MISS_CHAR, NULL,

531: DECODE(x_failure_score_override_code,
532: FND_API.G_MISS_CHAR, NULL,
533: x_failure_score_override_code),
534: DECODE(x_global_failure_score,
535: FND_API.G_MISS_CHAR, NULL,
536: x_global_failure_score),
537: DECODE(x_actual_content_source,
538: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
539: NULL, G_MISS_CONTENT_SOURCE_TYPE,

Line 538: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,

534: DECODE(x_global_failure_score,
535: FND_API.G_MISS_CHAR, NULL,
536: x_global_failure_score),
537: DECODE(x_actual_content_source,
538: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
539: NULL, G_MISS_CONTENT_SOURCE_TYPE,
540: x_actual_content_source)
541: ) RETURNING
542: rowid,

Line 577: RAISE FND_API.G_EXC_ERROR;

573: --Bug 3090928
574: IF INSTR(SQLERRM,'HZ_CREDIT_RATINGS_U2') <> 0 THEN
575: fnd_message.set_name('AR', 'HZ_API_DUP_CREDIT_RATING_REC');
576: fnd_msg_pub.add;
577: RAISE FND_API.G_EXC_ERROR;
578: END IF;
579: END;
580: END LOOP;
581:

Line 693: FND_API.G_MISS_NUM, NULL,

689: SET
690: credit_rating_id =
691: DECODE(x_credit_rating_id,
692: NULL, credit_rating_id,
693: FND_API.G_MISS_NUM, NULL,
694: x_credit_rating_id),
695: description =
696: DECODE(x_description,
697: NULL, description,

Line 698: FND_API.G_MISS_CHAR, NULL,

694: x_credit_rating_id),
695: description =
696: DECODE(x_description,
697: NULL, description,
698: FND_API.G_MISS_CHAR, NULL,
699: x_description),
700: party_id =
701: DECODE(x_party_id,
702: NULL, party_id,

Line 703: FND_API.G_MISS_NUM, NULL,

699: x_description),
700: party_id =
701: DECODE(x_party_id,
702: NULL, party_id,
703: FND_API.G_MISS_NUM, NULL,
704: x_party_id),
705: rating =
706: DECODE(x_rating,
707: NULL, rating,

Line 708: FND_API.G_MISS_CHAR, NULL,

704: x_party_id),
705: rating =
706: DECODE(x_rating,
707: NULL, rating,
708: FND_API.G_MISS_CHAR, NULL,
709: x_rating),
710: rated_as_of_date =
711: --Bug 3090928
712: trunc( DECODE(x_rated_as_of_date,

Line 714: FND_API.G_MISS_DATE, NULL,

710: rated_as_of_date =
711: --Bug 3090928
712: trunc( DECODE(x_rated_as_of_date,
713: NULL, rated_as_of_date,
714: FND_API.G_MISS_DATE, NULL,
715: x_rated_as_of_date)),
716: rating_organization =
717: DECODE(x_rating_organization,
718: NULL, rating_organization,

Line 719: FND_API.G_MISS_CHAR, NULL,

715: x_rated_as_of_date)),
716: rating_organization =
717: DECODE(x_rating_organization,
718: NULL, rating_organization,
719: FND_API.G_MISS_CHAR, NULL,
720: x_rating_organization),
721: created_by = created_by,
722: creation_date = creation_date,
723: last_update_login = hz_utility_v2pub.last_update_login,

Line 729: wh_update_date = FND_API.G_MISS_DATE,

725: last_updated_by = hz_utility_v2pub.last_updated_by,
726: request_id = hz_utility_v2pub.request_id,
727: program_application_id = hz_utility_v2pub.program_application_id,
728: program_id = hz_utility_v2pub.program_id,
729: wh_update_date = FND_API.G_MISS_DATE,
730: comments =
731: DECODE(x_comments,
732: NULL, comments,
733: FND_API.G_MISS_CHAR, NULL,

Line 733: FND_API.G_MISS_CHAR, NULL,

729: wh_update_date = FND_API.G_MISS_DATE,
730: comments =
731: DECODE(x_comments,
732: NULL, comments,
733: FND_API.G_MISS_CHAR, NULL,
734: x_comments),
735: det_history_ind =
736: DECODE(x_det_history_ind,
737: NULL, det_history_ind,

Line 738: FND_API.G_MISS_CHAR, NULL,

734: x_comments),
735: det_history_ind =
736: DECODE(x_det_history_ind,
737: NULL, det_history_ind,
738: FND_API.G_MISS_CHAR, NULL,
739: x_det_history_ind),
740: fincl_embt_ind =
741: DECODE(x_fincl_embt_ind,
742: NULL, fincl_embt_ind,

Line 743: FND_API.G_MISS_CHAR, NULL,

739: x_det_history_ind),
740: fincl_embt_ind =
741: DECODE(x_fincl_embt_ind,
742: NULL, fincl_embt_ind,
743: FND_API.G_MISS_CHAR, NULL,
744: x_fincl_embt_ind),
745: criminal_proceeding_ind =
746: DECODE(x_criminal_proceeding_ind,
747: NULL, criminal_proceeding_ind,

Line 748: FND_API.G_MISS_CHAR, NULL,

744: x_fincl_embt_ind),
745: criminal_proceeding_ind =
746: DECODE(x_criminal_proceeding_ind,
747: NULL, criminal_proceeding_ind,
748: FND_API.G_MISS_CHAR, NULL,
749: x_criminal_proceeding_ind),
750: suit_judge_ind =
751: DECODE(x_suit_judge_ind,
752: NULL, suit_judge_ind,

Line 753: FND_API.G_MISS_CHAR, NULL,

749: x_criminal_proceeding_ind),
750: suit_judge_ind =
751: DECODE(x_suit_judge_ind,
752: NULL, suit_judge_ind,
753: FND_API.G_MISS_CHAR, NULL,
754: x_suit_judge_ind),
755: claims_ind =
756: DECODE(x_claims_ind,
757: NULL, claims_ind,

Line 758: FND_API.G_MISS_CHAR, NULL,

754: x_suit_judge_ind),
755: claims_ind =
756: DECODE(x_claims_ind,
757: NULL, claims_ind,
758: FND_API.G_MISS_CHAR, NULL,
759: x_claims_ind),
760: secured_flng_ind =
761: DECODE(x_secured_flng_ind,
762: NULL, secured_flng_ind,

Line 763: FND_API.G_MISS_CHAR, NULL,

759: x_claims_ind),
760: secured_flng_ind =
761: DECODE(x_secured_flng_ind,
762: NULL, secured_flng_ind,
763: FND_API.G_MISS_CHAR, NULL,
764: x_secured_flng_ind),
765: fincl_lgl_event_ind =
766: DECODE(x_fincl_lgl_event_ind,
767: NULL, fincl_lgl_event_ind,

Line 768: FND_API.G_MISS_CHAR, NULL,

764: x_secured_flng_ind),
765: fincl_lgl_event_ind =
766: DECODE(x_fincl_lgl_event_ind,
767: NULL, fincl_lgl_event_ind,
768: FND_API.G_MISS_CHAR, NULL,
769: x_fincl_lgl_event_ind),
770: disaster_ind =
771: DECODE(x_disaster_ind,
772: NULL, disaster_ind,

Line 773: FND_API.G_MISS_CHAR, NULL,

769: x_fincl_lgl_event_ind),
770: disaster_ind =
771: DECODE(x_disaster_ind,
772: NULL, disaster_ind,
773: FND_API.G_MISS_CHAR, NULL,
774: x_disaster_ind),
775: oprg_spec_evnt_ind =
776: DECODE(x_oprg_spec_evnt_ind,
777: NULL, oprg_spec_evnt_ind,

Line 778: FND_API.G_MISS_CHAR, NULL,

774: x_disaster_ind),
775: oprg_spec_evnt_ind =
776: DECODE(x_oprg_spec_evnt_ind,
777: NULL, oprg_spec_evnt_ind,
778: FND_API.G_MISS_CHAR, NULL,
779: x_oprg_spec_evnt_ind),
780: other_spec_evnt_ind =
781: DECODE(x_other_spec_evnt_ind,
782: NULL, other_spec_evnt_ind,

Line 783: FND_API.G_MISS_CHAR, NULL,

779: x_oprg_spec_evnt_ind),
780: other_spec_evnt_ind =
781: DECODE(x_other_spec_evnt_ind,
782: NULL, other_spec_evnt_ind,
783: FND_API.G_MISS_CHAR, NULL,
784: x_other_spec_evnt_ind),
785: content_source_type =
786: DECODE(x_content_source_type,
787: NULL, G_MISS_CONTENT_SOURCE_TYPE,

Line 788: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,

784: x_other_spec_evnt_ind),
785: content_source_type =
786: DECODE(x_content_source_type,
787: NULL, G_MISS_CONTENT_SOURCE_TYPE,
788: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
789: x_content_source_type),
790: program_update_date = hz_utility_v2pub.program_update_date,
791: status =
792: DECODE(x_status,

Line 794: FND_API.G_MISS_CHAR, NULL,

790: program_update_date = hz_utility_v2pub.program_update_date,
791: status =
792: DECODE(x_status,
793: NULL, status,
794: FND_API.G_MISS_CHAR, NULL,
795: x_status),
796: object_version_number =
797: DECODE(x_object_version_number,
798: NULL, object_version_number,

Line 799: FND_API.G_MISS_NUM, NULL,

795: x_status),
796: object_version_number =
797: DECODE(x_object_version_number,
798: NULL, object_version_number,
799: FND_API.G_MISS_NUM, NULL,
800: x_object_version_number),
801: created_by_module =
802: DECODE(x_created_by_module,
803: NULL, created_by_module,

Line 804: FND_API.G_MISS_CHAR, NULL,

800: x_object_version_number),
801: created_by_module =
802: DECODE(x_created_by_module,
803: NULL, created_by_module,
804: FND_API.G_MISS_CHAR, NULL,
805: x_created_by_module),
806: application_id = hz_utility_v2pub.application_id,
807: avg_high_credit =
808: DECODE(x_avg_high_credit,

Line 810: FND_API.G_MISS_NUM, NULL,

806: application_id = hz_utility_v2pub.application_id,
807: avg_high_credit =
808: DECODE(x_avg_high_credit,
809: NULL, avg_high_credit,
810: FND_API.G_MISS_NUM, NULL,
811: x_avg_high_credit),
812: credit_score =
813: DECODE(x_credit_score,
814: NULL, credit_score,

Line 815: FND_API.G_MISS_CHAR, NULL,

811: x_avg_high_credit),
812: credit_score =
813: DECODE(x_credit_score,
814: NULL, credit_score,
815: FND_API.G_MISS_CHAR, NULL,
816: x_credit_score),
817: credit_score_age =
818: DECODE(x_credit_score_age,
819: NULL, credit_score_age,

Line 820: FND_API.G_MISS_NUM, NULL,

816: x_credit_score),
817: credit_score_age =
818: DECODE(x_credit_score_age,
819: NULL, credit_score_age,
820: FND_API.G_MISS_NUM, NULL,
821: x_credit_score_age),
822: credit_score_class =
823: DECODE(x_credit_score_class,
824: NULL, credit_score_class,

Line 825: FND_API.G_MISS_NUM, NULL,

821: x_credit_score_age),
822: credit_score_class =
823: DECODE(x_credit_score_class,
824: NULL, credit_score_class,
825: FND_API.G_MISS_NUM, NULL,
826: x_credit_score_class),
827: credit_score_commentary =
828: DECODE(x_credit_score_commentary,
829: NULL, credit_score_commentary,

Line 830: FND_API.G_MISS_CHAR, NULL,

826: x_credit_score_class),
827: credit_score_commentary =
828: DECODE(x_credit_score_commentary,
829: NULL, credit_score_commentary,
830: FND_API.G_MISS_CHAR, NULL,
831: x_credit_score_commentary),
832: credit_score_commentary2 =
833: DECODE(x_credit_score_commentary2,
834: NULL, credit_score_commentary2,

Line 835: FND_API.G_MISS_CHAR, NULL,

831: x_credit_score_commentary),
832: credit_score_commentary2 =
833: DECODE(x_credit_score_commentary2,
834: NULL, credit_score_commentary2,
835: FND_API.G_MISS_CHAR, NULL,
836: x_credit_score_commentary2),
837: credit_score_commentary3 =
838: DECODE(x_credit_score_commentary3,
839: NULL, credit_score_commentary3,

Line 840: FND_API.G_MISS_CHAR, NULL,

836: x_credit_score_commentary2),
837: credit_score_commentary3 =
838: DECODE(x_credit_score_commentary3,
839: NULL, credit_score_commentary3,
840: FND_API.G_MISS_CHAR, NULL,
841: x_credit_score_commentary3),
842: credit_score_commentary4 =
843: DECODE(x_credit_score_commentary4,
844: NULL, credit_score_commentary4,

Line 845: FND_API.G_MISS_CHAR, NULL,

841: x_credit_score_commentary3),
842: credit_score_commentary4 =
843: DECODE(x_credit_score_commentary4,
844: NULL, credit_score_commentary4,
845: FND_API.G_MISS_CHAR, NULL,
846: x_credit_score_commentary4),
847: credit_score_commentary5 =
848: DECODE(x_credit_score_commentary5,
849: NULL, credit_score_commentary5,

Line 850: FND_API.G_MISS_CHAR, NULL,

846: x_credit_score_commentary4),
847: credit_score_commentary5 =
848: DECODE(x_credit_score_commentary5,
849: NULL, credit_score_commentary5,
850: FND_API.G_MISS_CHAR, NULL,
851: x_credit_score_commentary5),
852: credit_score_commentary6 =
853: DECODE(x_credit_score_commentary6,
854: NULL, credit_score_commentary6,

Line 855: FND_API.G_MISS_CHAR, NULL,

851: x_credit_score_commentary5),
852: credit_score_commentary6 =
853: DECODE(x_credit_score_commentary6,
854: NULL, credit_score_commentary6,
855: FND_API.G_MISS_CHAR, NULL,
856: x_credit_score_commentary6),
857: credit_score_commentary7 =
858: DECODE(x_credit_score_commentary7,
859: NULL, credit_score_commentary7,

Line 860: FND_API.G_MISS_CHAR, NULL,

856: x_credit_score_commentary6),
857: credit_score_commentary7 =
858: DECODE(x_credit_score_commentary7,
859: NULL, credit_score_commentary7,
860: FND_API.G_MISS_CHAR, NULL,
861: x_credit_score_commentary7),
862: credit_score_commentary8 =
863: DECODE(x_credit_score_commentary8,
864: NULL, credit_score_commentary8,

Line 865: FND_API.G_MISS_CHAR, NULL,

861: x_credit_score_commentary7),
862: credit_score_commentary8 =
863: DECODE(x_credit_score_commentary8,
864: NULL, credit_score_commentary8,
865: FND_API.G_MISS_CHAR, NULL,
866: x_credit_score_commentary8),
867: credit_score_commentary9 =
868: DECODE(x_credit_score_commentary9,
869: NULL, credit_score_commentary9,

Line 870: FND_API.G_MISS_CHAR, NULL,

866: x_credit_score_commentary8),
867: credit_score_commentary9 =
868: DECODE(x_credit_score_commentary9,
869: NULL, credit_score_commentary9,
870: FND_API.G_MISS_CHAR, NULL,
871: x_credit_score_commentary9),
872: credit_score_commentary10 =
873: DECODE(x_credit_score_commentary10,
874: NULL, credit_score_commentary10,

Line 875: FND_API.G_MISS_CHAR, NULL,

871: x_credit_score_commentary9),
872: credit_score_commentary10 =
873: DECODE(x_credit_score_commentary10,
874: NULL, credit_score_commentary10,
875: FND_API.G_MISS_CHAR, NULL,
876: x_credit_score_commentary10),
877: credit_score_date =
878: DECODE(x_credit_score_date,
879: NULL, credit_score_date,

Line 880: FND_API.G_MISS_DATE, NULL,

876: x_credit_score_commentary10),
877: credit_score_date =
878: DECODE(x_credit_score_date,
879: NULL, credit_score_date,
880: FND_API.G_MISS_DATE, NULL,
881: x_credit_score_date),
882: credit_score_incd_default =
883: DECODE(x_credit_score_incd_default,
884: NULL, credit_score_incd_default,

Line 885: FND_API.G_MISS_NUM, NULL,

881: x_credit_score_date),
882: credit_score_incd_default =
883: DECODE(x_credit_score_incd_default,
884: NULL, credit_score_incd_default,
885: FND_API.G_MISS_NUM, NULL,
886: x_credit_score_incd_default),
887: credit_score_natl_percentile =
888: DECODE(x_credit_score_natl_percentile,
889: NULL, credit_score_natl_percentile,

Line 890: FND_API.G_MISS_NUM, NULL,

886: x_credit_score_incd_default),
887: credit_score_natl_percentile =
888: DECODE(x_credit_score_natl_percentile,
889: NULL, credit_score_natl_percentile,
890: FND_API.G_MISS_NUM, NULL,
891: x_credit_score_natl_percentile),
892: debarment_ind =
893: DECODE(x_debarment_ind,
894: NULL, debarment_ind,

Line 895: FND_API.G_MISS_CHAR, NULL,

891: x_credit_score_natl_percentile),
892: debarment_ind =
893: DECODE(x_debarment_ind,
894: NULL, debarment_ind,
895: FND_API.G_MISS_CHAR, NULL,
896: x_debarment_ind),
897: debarments_count =
898: DECODE(x_debarments_count,
899: NULL, debarments_count,

Line 900: FND_API.G_MISS_NUM, NULL,

896: x_debarment_ind),
897: debarments_count =
898: DECODE(x_debarments_count,
899: NULL, debarments_count,
900: FND_API.G_MISS_NUM, NULL,
901: x_debarments_count),
902: debarments_date =
903: DECODE(x_debarments_date,
904: NULL, debarments_date,

Line 905: FND_API.G_MISS_DATE, NULL,

901: x_debarments_count),
902: debarments_date =
903: DECODE(x_debarments_date,
904: NULL, debarments_date,
905: FND_API.G_MISS_DATE, NULL,
906: x_debarments_date),
907: high_credit =
908: DECODE(x_high_credit,
909: NULL, high_credit,

Line 910: FND_API.G_MISS_NUM, NULL,

906: x_debarments_date),
907: high_credit =
908: DECODE(x_high_credit,
909: NULL, high_credit,
910: FND_API.G_MISS_NUM, NULL,
911: x_high_credit),
912: maximum_credit_currency_code =
913: DECODE(x_maximum_credit_currency_code,
914: NULL, maximum_credit_currency_code,

Line 915: FND_API.G_MISS_CHAR, NULL,

911: x_high_credit),
912: maximum_credit_currency_code =
913: DECODE(x_maximum_credit_currency_code,
914: NULL, maximum_credit_currency_code,
915: FND_API.G_MISS_CHAR, NULL,
916: x_maximum_credit_currency_code),
917: maximum_credit_recommendation =
918: DECODE(x_maximum_credit_rcmd,
919: NULL, maximum_credit_recommendation,

Line 920: FND_API.G_MISS_NUM, NULL,

916: x_maximum_credit_currency_code),
917: maximum_credit_recommendation =
918: DECODE(x_maximum_credit_rcmd,
919: NULL, maximum_credit_recommendation,
920: FND_API.G_MISS_NUM, NULL,
921: x_maximum_credit_rcmd),
922: paydex_norm =
923: DECODE(x_paydex_norm,
924: NULL, paydex_norm,

Line 925: FND_API.G_MISS_CHAR, NULL,

921: x_maximum_credit_rcmd),
922: paydex_norm =
923: DECODE(x_paydex_norm,
924: NULL, paydex_norm,
925: FND_API.G_MISS_CHAR, NULL,
926: x_paydex_norm),
927: paydex_score =
928: DECODE(x_paydex_score,
929: NULL, paydex_score,

Line 930: FND_API.G_MISS_CHAR, NULL,

926: x_paydex_norm),
927: paydex_score =
928: DECODE(x_paydex_score,
929: NULL, paydex_score,
930: FND_API.G_MISS_CHAR, NULL,
931: x_paydex_score),
932: paydex_three_months_ago =
933: DECODE(x_paydex_three_months_ago,
934: NULL, paydex_three_months_ago,

Line 935: FND_API.G_MISS_CHAR, NULL,

931: x_paydex_score),
932: paydex_three_months_ago =
933: DECODE(x_paydex_three_months_ago,
934: NULL, paydex_three_months_ago,
935: FND_API.G_MISS_CHAR, NULL,
936: x_paydex_three_months_ago),
937: credit_score_override_code =
938: DECODE(x_credit_score_override_code,
939: NULL, credit_score_override_code,

Line 940: FND_API.G_MISS_CHAR, NULL,

936: x_paydex_three_months_ago),
937: credit_score_override_code =
938: DECODE(x_credit_score_override_code,
939: NULL, credit_score_override_code,
940: FND_API.G_MISS_CHAR, NULL,
941: x_credit_score_override_code),
942: cr_scr_clas_expl =
943: DECODE(x_cr_scr_clas_expl,
944: NULL, cr_scr_clas_expl,

Line 945: FND_API.G_MISS_CHAR, NULL,

941: x_credit_score_override_code),
942: cr_scr_clas_expl =
943: DECODE(x_cr_scr_clas_expl,
944: NULL, cr_scr_clas_expl,
945: FND_API.G_MISS_CHAR, NULL,
946: x_cr_scr_clas_expl),
947: low_rng_delq_scr =
948: DECODE(x_low_rng_delq_scr,
949: NULL, low_rng_delq_scr,

Line 950: FND_API.G_MISS_NUM, NULL,

946: x_cr_scr_clas_expl),
947: low_rng_delq_scr =
948: DECODE(x_low_rng_delq_scr,
949: NULL, low_rng_delq_scr,
950: FND_API.G_MISS_NUM, NULL,
951: x_low_rng_delq_scr),
952: high_rng_delq_scr =
953: DECODE(x_high_rng_delq_scr,
954: NULL, high_rng_delq_scr,

Line 955: FND_API.G_MISS_NUM, NULL,

951: x_low_rng_delq_scr),
952: high_rng_delq_scr =
953: DECODE(x_high_rng_delq_scr,
954: NULL, high_rng_delq_scr,
955: FND_API.G_MISS_NUM, NULL,
956: x_high_rng_delq_scr),
957: delq_pmt_rng_prcnt =
958: DECODE(x_delq_pmt_rng_prcnt,
959: NULL, delq_pmt_rng_prcnt,

Line 960: FND_API.G_MISS_NUM, NULL,

956: x_high_rng_delq_scr),
957: delq_pmt_rng_prcnt =
958: DECODE(x_delq_pmt_rng_prcnt,
959: NULL, delq_pmt_rng_prcnt,
960: FND_API.G_MISS_NUM, NULL,
961: x_delq_pmt_rng_prcnt),
962: delq_pmt_pctg_for_all_firms =
963: DECODE(x_delq_pmt_pctg_for_all_firms,
964: NULL, delq_pmt_pctg_for_all_firms,

Line 965: FND_API.G_MISS_NUM, NULL,

961: x_delq_pmt_rng_prcnt),
962: delq_pmt_pctg_for_all_firms =
963: DECODE(x_delq_pmt_pctg_for_all_firms,
964: NULL, delq_pmt_pctg_for_all_firms,
965: FND_API.G_MISS_NUM, NULL,
966: x_delq_pmt_pctg_for_all_firms),
967: num_trade_experiences =
968: DECODE(x_num_trade_experiences,
969: NULL, num_trade_experiences,

Line 970: FND_API.G_MISS_NUM, NULL,

966: x_delq_pmt_pctg_for_all_firms),
967: num_trade_experiences =
968: DECODE(x_num_trade_experiences,
969: NULL, num_trade_experiences,
970: FND_API.G_MISS_NUM, NULL,
971: x_num_trade_experiences),
972: paydex_firm_days =
973: DECODE(x_paydex_firm_days,
974: NULL, paydex_firm_days,

Line 975: FND_API.G_MISS_CHAR, NULL,

971: x_num_trade_experiences),
972: paydex_firm_days =
973: DECODE(x_paydex_firm_days,
974: NULL, paydex_firm_days,
975: FND_API.G_MISS_CHAR, NULL,
976: x_paydex_firm_days),
977: paydex_firm_comment =
978: DECODE(x_paydex_firm_comment,
979: NULL, paydex_firm_comment,

Line 980: FND_API.G_MISS_CHAR, NULL,

976: x_paydex_firm_days),
977: paydex_firm_comment =
978: DECODE(x_paydex_firm_comment,
979: NULL, paydex_firm_comment,
980: FND_API.G_MISS_CHAR, NULL,
981: x_paydex_firm_comment),
982: paydex_industry_days =
983: DECODE(x_paydex_industry_days,
984: NULL, paydex_industry_days,

Line 985: FND_API.G_MISS_CHAR, NULL,

981: x_paydex_firm_comment),
982: paydex_industry_days =
983: DECODE(x_paydex_industry_days,
984: NULL, paydex_industry_days,
985: FND_API.G_MISS_CHAR, NULL,
986: x_paydex_industry_days),
987: paydex_industry_comment =
988: DECODE(x_paydex_industry_comment,
989: NULL, paydex_industry_comment,

Line 990: FND_API.G_MISS_CHAR, NULL,

986: x_paydex_industry_days),
987: paydex_industry_comment =
988: DECODE(x_paydex_industry_comment,
989: NULL, paydex_industry_comment,
990: FND_API.G_MISS_CHAR, NULL,
991: x_paydex_industry_comment),
992: paydex_comment =
993: DECODE(x_paydex_comment,
994: NULL, paydex_comment,

Line 995: FND_API.G_MISS_CHAR, NULL,

991: x_paydex_industry_comment),
992: paydex_comment =
993: DECODE(x_paydex_comment,
994: NULL, paydex_comment,
995: FND_API.G_MISS_CHAR, NULL,
996: x_paydex_comment),
997: suit_ind =
998: DECODE(x_suit_ind,
999: NULL, suit_ind,

Line 1000: FND_API.G_MISS_CHAR, NULL,

996: x_paydex_comment),
997: suit_ind =
998: DECODE(x_suit_ind,
999: NULL, suit_ind,
1000: FND_API.G_MISS_CHAR, NULL,
1001: x_suit_ind),
1002: lien_ind =
1003: DECODE(x_lien_ind,
1004: NULL, lien_ind,

Line 1005: FND_API.G_MISS_CHAR, NULL,

1001: x_suit_ind),
1002: lien_ind =
1003: DECODE(x_lien_ind,
1004: NULL, lien_ind,
1005: FND_API.G_MISS_CHAR, NULL,
1006: x_lien_ind),
1007: judgement_ind =
1008: DECODE(x_judgement_ind,
1009: NULL, judgement_ind,

Line 1010: FND_API.G_MISS_CHAR, NULL,

1006: x_lien_ind),
1007: judgement_ind =
1008: DECODE(x_judgement_ind,
1009: NULL, judgement_ind,
1010: FND_API.G_MISS_CHAR, NULL,
1011: x_judgement_ind),
1012: bankruptcy_ind =
1013: DECODE(x_bankruptcy_ind,
1014: NULL, bankruptcy_ind,

Line 1015: FND_API.G_MISS_CHAR, NULL,

1011: x_judgement_ind),
1012: bankruptcy_ind =
1013: DECODE(x_bankruptcy_ind,
1014: NULL, bankruptcy_ind,
1015: FND_API.G_MISS_CHAR, NULL,
1016: x_bankruptcy_ind),
1017: no_trade_ind =
1018: DECODE(x_no_trade_ind,
1019: NULL, no_trade_ind,

Line 1020: FND_API.G_MISS_CHAR, NULL,

1016: x_bankruptcy_ind),
1017: no_trade_ind =
1018: DECODE(x_no_trade_ind,
1019: NULL, no_trade_ind,
1020: FND_API.G_MISS_CHAR, NULL,
1021: x_no_trade_ind),
1022: prnt_hq_bkcy_ind =
1023: DECODE(x_prnt_hq_bkcy_ind,
1024: NULL, prnt_hq_bkcy_ind,

Line 1025: FND_API.G_MISS_CHAR, NULL,

1021: x_no_trade_ind),
1022: prnt_hq_bkcy_ind =
1023: DECODE(x_prnt_hq_bkcy_ind,
1024: NULL, prnt_hq_bkcy_ind,
1025: FND_API.G_MISS_CHAR, NULL,
1026: x_prnt_hq_bkcy_ind),
1027: num_prnt_bkcy_filing =
1028: DECODE(x_num_prnt_bkcy_filing,
1029: NULL, num_prnt_bkcy_filing,

Line 1030: FND_API.G_MISS_NUM, NULL,

1026: x_prnt_hq_bkcy_ind),
1027: num_prnt_bkcy_filing =
1028: DECODE(x_num_prnt_bkcy_filing,
1029: NULL, num_prnt_bkcy_filing,
1030: FND_API.G_MISS_NUM, NULL,
1031: x_num_prnt_bkcy_filing),
1032: prnt_bkcy_filg_type =
1033: DECODE(x_prnt_bkcy_filg_type,
1034: NULL, prnt_bkcy_filg_type,

Line 1035: FND_API.G_MISS_CHAR, NULL,

1031: x_num_prnt_bkcy_filing),
1032: prnt_bkcy_filg_type =
1033: DECODE(x_prnt_bkcy_filg_type,
1034: NULL, prnt_bkcy_filg_type,
1035: FND_API.G_MISS_CHAR, NULL,
1036: x_prnt_bkcy_filg_type),
1037: prnt_bkcy_filg_chapter =
1038: DECODE(x_prnt_bkcy_filg_chapter,
1039: NULL, prnt_bkcy_filg_chapter,

Line 1040: FND_API.G_MISS_NUM, NULL,

1036: x_prnt_bkcy_filg_type),
1037: prnt_bkcy_filg_chapter =
1038: DECODE(x_prnt_bkcy_filg_chapter,
1039: NULL, prnt_bkcy_filg_chapter,
1040: FND_API.G_MISS_NUM, NULL,
1041: x_prnt_bkcy_filg_chapter),
1042: prnt_bkcy_filg_date =
1043: DECODE(x_prnt_bkcy_filg_date,
1044: NULL, prnt_bkcy_filg_date,

Line 1045: FND_API.G_MISS_DATE, NULL,

1041: x_prnt_bkcy_filg_chapter),
1042: prnt_bkcy_filg_date =
1043: DECODE(x_prnt_bkcy_filg_date,
1044: NULL, prnt_bkcy_filg_date,
1045: FND_API.G_MISS_DATE, NULL,
1046: x_prnt_bkcy_filg_date),
1047: num_prnt_bkcy_convs =
1048: DECODE(x_num_prnt_bkcy_convs,
1049: NULL, num_prnt_bkcy_convs,

Line 1050: FND_API.G_MISS_NUM, NULL,

1046: x_prnt_bkcy_filg_date),
1047: num_prnt_bkcy_convs =
1048: DECODE(x_num_prnt_bkcy_convs,
1049: NULL, num_prnt_bkcy_convs,
1050: FND_API.G_MISS_NUM, NULL,
1051: x_num_prnt_bkcy_convs),
1052: prnt_bkcy_conv_date =
1053: DECODE(x_prnt_bkcy_conv_date,
1054: NULL, prnt_bkcy_conv_date,

Line 1055: FND_API.G_MISS_DATE, NULL,

1051: x_num_prnt_bkcy_convs),
1052: prnt_bkcy_conv_date =
1053: DECODE(x_prnt_bkcy_conv_date,
1054: NULL, prnt_bkcy_conv_date,
1055: FND_API.G_MISS_DATE, NULL,
1056: x_prnt_bkcy_conv_date),
1057: prnt_bkcy_chapter_conv =
1058: DECODE(x_prnt_bkcy_chapter_conv,
1059: NULL, prnt_bkcy_chapter_conv,

Line 1060: FND_API.G_MISS_CHAR, NULL,

1056: x_prnt_bkcy_conv_date),
1057: prnt_bkcy_chapter_conv =
1058: DECODE(x_prnt_bkcy_chapter_conv,
1059: NULL, prnt_bkcy_chapter_conv,
1060: FND_API.G_MISS_CHAR, NULL,
1061: x_prnt_bkcy_chapter_conv),
1062: slow_trade_expl =
1063: DECODE(x_slow_trade_expl,
1064: NULL, slow_trade_expl,

Line 1065: FND_API.G_MISS_CHAR, NULL,

1061: x_prnt_bkcy_chapter_conv),
1062: slow_trade_expl =
1063: DECODE(x_slow_trade_expl,
1064: NULL, slow_trade_expl,
1065: FND_API.G_MISS_CHAR, NULL,
1066: x_slow_trade_expl),
1067: negv_pmt_expl =
1068: DECODE(x_negv_pmt_expl,
1069: NULL, negv_pmt_expl,

Line 1070: FND_API.G_MISS_CHAR, NULL,

1066: x_slow_trade_expl),
1067: negv_pmt_expl =
1068: DECODE(x_negv_pmt_expl,
1069: NULL, negv_pmt_expl,
1070: FND_API.G_MISS_CHAR, NULL,
1071: x_negv_pmt_expl),
1072: pub_rec_expl =
1073: DECODE(x_pub_rec_expl,
1074: NULL, pub_rec_expl,

Line 1075: FND_API.G_MISS_CHAR, NULL,

1071: x_negv_pmt_expl),
1072: pub_rec_expl =
1073: DECODE(x_pub_rec_expl,
1074: NULL, pub_rec_expl,
1075: FND_API.G_MISS_CHAR, NULL,
1076: x_pub_rec_expl),
1077: business_discontinued =
1078: DECODE(x_business_discontinued,
1079: NULL, business_discontinued,

Line 1080: FND_API.G_MISS_CHAR, NULL,

1076: x_pub_rec_expl),
1077: business_discontinued =
1078: DECODE(x_business_discontinued,
1079: NULL, business_discontinued,
1080: FND_API.G_MISS_CHAR, NULL,
1081: x_business_discontinued),
1082: spcl_event_comment =
1083: DECODE(x_spcl_event_comment,
1084: NULL, spcl_event_comment,

Line 1085: FND_API.G_MISS_CHAR, NULL,

1081: x_business_discontinued),
1082: spcl_event_comment =
1083: DECODE(x_spcl_event_comment,
1084: NULL, spcl_event_comment,
1085: FND_API.G_MISS_CHAR, NULL,
1086: x_spcl_event_comment),
1087: num_spcl_event =
1088: DECODE(x_num_spcl_event,
1089: NULL, num_spcl_event,

Line 1090: FND_API.G_MISS_NUM, NULL,

1086: x_spcl_event_comment),
1087: num_spcl_event =
1088: DECODE(x_num_spcl_event,
1089: NULL, num_spcl_event,
1090: FND_API.G_MISS_NUM, NULL,
1091: x_num_spcl_event),
1092: spcl_event_update_date =
1093: DECODE(x_spcl_event_update_date,
1094: NULL, spcl_event_update_date,

Line 1095: FND_API.G_MISS_DATE, NULL,

1091: x_num_spcl_event),
1092: spcl_event_update_date =
1093: DECODE(x_spcl_event_update_date,
1094: NULL, spcl_event_update_date,
1095: FND_API.G_MISS_DATE, NULL,
1096: x_spcl_event_update_date),
1097: spcl_evnt_txt =
1098: DECODE(x_spcl_evnt_txt,
1099: NULL, spcl_evnt_txt,

Line 1100: FND_API.G_MISS_CHAR, NULL,

1096: x_spcl_event_update_date),
1097: spcl_evnt_txt =
1098: DECODE(x_spcl_evnt_txt,
1099: NULL, spcl_evnt_txt,
1100: FND_API.G_MISS_CHAR, NULL,
1101: x_spcl_evnt_txt),
1102: failure_score =
1103: DECODE(x_failure_score,
1104: NULL, failure_score,

Line 1105: FND_API.G_MISS_CHAR, NULL,

1101: x_spcl_evnt_txt),
1102: failure_score =
1103: DECODE(x_failure_score,
1104: NULL, failure_score,
1105: FND_API.G_MISS_CHAR, NULL,
1106: x_failure_score),
1107: failure_score_age =
1108: DECODE(x_failure_score_age,
1109: NULL, failure_score_age,

Line 1110: FND_API.G_MISS_NUM, NULL,

1106: x_failure_score),
1107: failure_score_age =
1108: DECODE(x_failure_score_age,
1109: NULL, failure_score_age,
1110: FND_API.G_MISS_NUM, NULL,
1111: x_failure_score_age),
1112: failure_score_class =
1113: DECODE(x_failure_score_class,
1114: NULL, failure_score_class,

Line 1115: FND_API.G_MISS_NUM, NULL,

1111: x_failure_score_age),
1112: failure_score_class =
1113: DECODE(x_failure_score_class,
1114: NULL, failure_score_class,
1115: FND_API.G_MISS_NUM, NULL,
1116: x_failure_score_class),
1117: failure_score_commentary =
1118: DECODE(x_failure_score_commentary,
1119: NULL, failure_score_commentary,

Line 1120: FND_API.G_MISS_CHAR, NULL,

1116: x_failure_score_class),
1117: failure_score_commentary =
1118: DECODE(x_failure_score_commentary,
1119: NULL, failure_score_commentary,
1120: FND_API.G_MISS_CHAR, NULL,
1121: x_failure_score_commentary),
1122: failure_score_commentary2 =
1123: DECODE(x_failure_score_commentary2,
1124: NULL, failure_score_commentary2,

Line 1125: FND_API.G_MISS_CHAR, NULL,

1121: x_failure_score_commentary),
1122: failure_score_commentary2 =
1123: DECODE(x_failure_score_commentary2,
1124: NULL, failure_score_commentary2,
1125: FND_API.G_MISS_CHAR, NULL,
1126: x_failure_score_commentary2),
1127: failure_score_commentary3 =
1128: DECODE(x_failure_score_commentary3,
1129: NULL, failure_score_commentary3,

Line 1130: FND_API.G_MISS_CHAR, NULL,

1126: x_failure_score_commentary2),
1127: failure_score_commentary3 =
1128: DECODE(x_failure_score_commentary3,
1129: NULL, failure_score_commentary3,
1130: FND_API.G_MISS_CHAR, NULL,
1131: x_failure_score_commentary3),
1132: failure_score_commentary4 =
1133: DECODE(x_failure_score_commentary4,
1134: NULL, failure_score_commentary4,

Line 1135: FND_API.G_MISS_CHAR, NULL,

1131: x_failure_score_commentary3),
1132: failure_score_commentary4 =
1133: DECODE(x_failure_score_commentary4,
1134: NULL, failure_score_commentary4,
1135: FND_API.G_MISS_CHAR, NULL,
1136: x_failure_score_commentary4),
1137: failure_score_commentary5 =
1138: DECODE(x_failure_score_commentary5,
1139: NULL, failure_score_commentary5,

Line 1140: FND_API.G_MISS_CHAR, NULL,

1136: x_failure_score_commentary4),
1137: failure_score_commentary5 =
1138: DECODE(x_failure_score_commentary5,
1139: NULL, failure_score_commentary5,
1140: FND_API.G_MISS_CHAR, NULL,
1141: x_failure_score_commentary5),
1142: failure_score_commentary6 =
1143: DECODE(x_failure_score_commentary6,
1144: NULL, failure_score_commentary6,

Line 1145: FND_API.G_MISS_CHAR, NULL,

1141: x_failure_score_commentary5),
1142: failure_score_commentary6 =
1143: DECODE(x_failure_score_commentary6,
1144: NULL, failure_score_commentary6,
1145: FND_API.G_MISS_CHAR, NULL,
1146: x_failure_score_commentary6),
1147: failure_score_commentary7 =
1148: DECODE(x_failure_score_commentary7,
1149: NULL, failure_score_commentary7,

Line 1150: FND_API.G_MISS_CHAR, NULL,

1146: x_failure_score_commentary6),
1147: failure_score_commentary7 =
1148: DECODE(x_failure_score_commentary7,
1149: NULL, failure_score_commentary7,
1150: FND_API.G_MISS_CHAR, NULL,
1151: x_failure_score_commentary7),
1152: failure_score_commentary8 =
1153: DECODE(x_failure_score_commentary8,
1154: NULL, failure_score_commentary8,

Line 1155: FND_API.G_MISS_CHAR, NULL,

1151: x_failure_score_commentary7),
1152: failure_score_commentary8 =
1153: DECODE(x_failure_score_commentary8,
1154: NULL, failure_score_commentary8,
1155: FND_API.G_MISS_CHAR, NULL,
1156: x_failure_score_commentary8),
1157: failure_score_commentary9 =
1158: DECODE(x_failure_score_commentary9,
1159: NULL, failure_score_commentary9,

Line 1160: FND_API.G_MISS_CHAR, NULL,

1156: x_failure_score_commentary8),
1157: failure_score_commentary9 =
1158: DECODE(x_failure_score_commentary9,
1159: NULL, failure_score_commentary9,
1160: FND_API.G_MISS_CHAR, NULL,
1161: x_failure_score_commentary9),
1162: failure_score_commentary10 =
1163: DECODE(x_failure_score_commentary10,
1164: NULL, failure_score_commentary10,

Line 1165: FND_API.G_MISS_CHAR, NULL,

1161: x_failure_score_commentary9),
1162: failure_score_commentary10 =
1163: DECODE(x_failure_score_commentary10,
1164: NULL, failure_score_commentary10,
1165: FND_API.G_MISS_CHAR, NULL,
1166: x_failure_score_commentary10),
1167: failure_score_date =
1168: DECODE(x_failure_score_date,
1169: NULL, failure_score_date,

Line 1170: FND_API.G_MISS_DATE, NULL,

1166: x_failure_score_commentary10),
1167: failure_score_date =
1168: DECODE(x_failure_score_date,
1169: NULL, failure_score_date,
1170: FND_API.G_MISS_DATE, NULL,
1171: x_failure_score_date),
1172: failure_score_incd_default =
1173: DECODE(x_failure_score_incd_default,
1174: NULL, failure_score_incd_default,

Line 1175: FND_API.G_MISS_NUM, NULL,

1171: x_failure_score_date),
1172: failure_score_incd_default =
1173: DECODE(x_failure_score_incd_default,
1174: NULL, failure_score_incd_default,
1175: FND_API.G_MISS_NUM, NULL,
1176: x_failure_score_incd_default),
1177: failure_score_natnl_percentile =
1178: DECODE(x_fail_score_natnl_percentile,
1179: NULL, failure_score_natnl_percentile,

Line 1180: FND_API.G_MISS_NUM, NULL,

1176: x_failure_score_incd_default),
1177: failure_score_natnl_percentile =
1178: DECODE(x_fail_score_natnl_percentile,
1179: NULL, failure_score_natnl_percentile,
1180: FND_API.G_MISS_NUM, NULL,
1181: x_fail_score_natnl_percentile),
1182: failure_score_override_code =
1183: DECODE(x_failure_score_override_code,
1184: NULL, failure_score_override_code,

Line 1185: FND_API.G_MISS_CHAR, NULL,

1181: x_fail_score_natnl_percentile),
1182: failure_score_override_code =
1183: DECODE(x_failure_score_override_code,
1184: NULL, failure_score_override_code,
1185: FND_API.G_MISS_CHAR, NULL,
1186: x_failure_score_override_code),
1187: global_failure_score =
1188: DECODE(x_global_failure_score,
1189: NULL, global_failure_score,

Line 1190: FND_API.G_MISS_CHAR, NULL,

1186: x_failure_score_override_code),
1187: global_failure_score =
1188: DECODE(x_global_failure_score,
1189: NULL, global_failure_score,
1190: FND_API.G_MISS_CHAR, NULL,
1191: x_global_failure_score)/*,
1192:
1193: ** SSM SST Integration and Extension
1194: ** actual_content_source will not be updateable for non-SSM enabled entities.

Line 1199: FND_API.G_MISS_CHAR, NULL,

1195:
1196: actual_content_source =
1197: DECODE(x_actual_content_source,
1198: NULL, actual_content_source,
1199: FND_API.G_MISS_CHAR, NULL,
1200: x_actual_content_source) */
1201: WHERE rowid = x_rowid;
1202:
1203: IF ( SQL%NOTFOUND ) THEN

Line 1781: NVL(credit_rating_id, FND_API.G_MISS_NUM),

1777: ) IS
1778: BEGIN
1779:
1780: SELECT
1781: NVL(credit_rating_id, FND_API.G_MISS_NUM),
1782: NVL(description, FND_API.G_MISS_CHAR),
1783: NVL(party_id, FND_API.G_MISS_NUM),
1784: NVL(rating, FND_API.G_MISS_CHAR),
1785: NVL(rated_as_of_date, FND_API.G_MISS_DATE),

Line 1782: NVL(description, FND_API.G_MISS_CHAR),

1778: BEGIN
1779:
1780: SELECT
1781: NVL(credit_rating_id, FND_API.G_MISS_NUM),
1782: NVL(description, FND_API.G_MISS_CHAR),
1783: NVL(party_id, FND_API.G_MISS_NUM),
1784: NVL(rating, FND_API.G_MISS_CHAR),
1785: NVL(rated_as_of_date, FND_API.G_MISS_DATE),
1786: NVL(rating_organization, FND_API.G_MISS_CHAR),

Line 1783: NVL(party_id, FND_API.G_MISS_NUM),

1779:
1780: SELECT
1781: NVL(credit_rating_id, FND_API.G_MISS_NUM),
1782: NVL(description, FND_API.G_MISS_CHAR),
1783: NVL(party_id, FND_API.G_MISS_NUM),
1784: NVL(rating, FND_API.G_MISS_CHAR),
1785: NVL(rated_as_of_date, FND_API.G_MISS_DATE),
1786: NVL(rating_organization, FND_API.G_MISS_CHAR),
1787: NVL(comments, FND_API.G_MISS_CHAR),

Line 1784: NVL(rating, FND_API.G_MISS_CHAR),

1780: SELECT
1781: NVL(credit_rating_id, FND_API.G_MISS_NUM),
1782: NVL(description, FND_API.G_MISS_CHAR),
1783: NVL(party_id, FND_API.G_MISS_NUM),
1784: NVL(rating, FND_API.G_MISS_CHAR),
1785: NVL(rated_as_of_date, FND_API.G_MISS_DATE),
1786: NVL(rating_organization, FND_API.G_MISS_CHAR),
1787: NVL(comments, FND_API.G_MISS_CHAR),
1788: NVL(det_history_ind, FND_API.G_MISS_CHAR),

Line 1785: NVL(rated_as_of_date, FND_API.G_MISS_DATE),

1781: NVL(credit_rating_id, FND_API.G_MISS_NUM),
1782: NVL(description, FND_API.G_MISS_CHAR),
1783: NVL(party_id, FND_API.G_MISS_NUM),
1784: NVL(rating, FND_API.G_MISS_CHAR),
1785: NVL(rated_as_of_date, FND_API.G_MISS_DATE),
1786: NVL(rating_organization, FND_API.G_MISS_CHAR),
1787: NVL(comments, FND_API.G_MISS_CHAR),
1788: NVL(det_history_ind, FND_API.G_MISS_CHAR),
1789: NVL(fincl_embt_ind, FND_API.G_MISS_CHAR),

Line 1786: NVL(rating_organization, FND_API.G_MISS_CHAR),

1782: NVL(description, FND_API.G_MISS_CHAR),
1783: NVL(party_id, FND_API.G_MISS_NUM),
1784: NVL(rating, FND_API.G_MISS_CHAR),
1785: NVL(rated_as_of_date, FND_API.G_MISS_DATE),
1786: NVL(rating_organization, FND_API.G_MISS_CHAR),
1787: NVL(comments, FND_API.G_MISS_CHAR),
1788: NVL(det_history_ind, FND_API.G_MISS_CHAR),
1789: NVL(fincl_embt_ind, FND_API.G_MISS_CHAR),
1790: NVL(criminal_proceeding_ind, FND_API.G_MISS_CHAR),

Line 1787: NVL(comments, FND_API.G_MISS_CHAR),

1783: NVL(party_id, FND_API.G_MISS_NUM),
1784: NVL(rating, FND_API.G_MISS_CHAR),
1785: NVL(rated_as_of_date, FND_API.G_MISS_DATE),
1786: NVL(rating_organization, FND_API.G_MISS_CHAR),
1787: NVL(comments, FND_API.G_MISS_CHAR),
1788: NVL(det_history_ind, FND_API.G_MISS_CHAR),
1789: NVL(fincl_embt_ind, FND_API.G_MISS_CHAR),
1790: NVL(criminal_proceeding_ind, FND_API.G_MISS_CHAR),
1791: NVL(claims_ind, FND_API.G_MISS_CHAR),

Line 1788: NVL(det_history_ind, FND_API.G_MISS_CHAR),

1784: NVL(rating, FND_API.G_MISS_CHAR),
1785: NVL(rated_as_of_date, FND_API.G_MISS_DATE),
1786: NVL(rating_organization, FND_API.G_MISS_CHAR),
1787: NVL(comments, FND_API.G_MISS_CHAR),
1788: NVL(det_history_ind, FND_API.G_MISS_CHAR),
1789: NVL(fincl_embt_ind, FND_API.G_MISS_CHAR),
1790: NVL(criminal_proceeding_ind, FND_API.G_MISS_CHAR),
1791: NVL(claims_ind, FND_API.G_MISS_CHAR),
1792: NVL(secured_flng_ind, FND_API.G_MISS_CHAR),

Line 1789: NVL(fincl_embt_ind, FND_API.G_MISS_CHAR),

1785: NVL(rated_as_of_date, FND_API.G_MISS_DATE),
1786: NVL(rating_organization, FND_API.G_MISS_CHAR),
1787: NVL(comments, FND_API.G_MISS_CHAR),
1788: NVL(det_history_ind, FND_API.G_MISS_CHAR),
1789: NVL(fincl_embt_ind, FND_API.G_MISS_CHAR),
1790: NVL(criminal_proceeding_ind, FND_API.G_MISS_CHAR),
1791: NVL(claims_ind, FND_API.G_MISS_CHAR),
1792: NVL(secured_flng_ind, FND_API.G_MISS_CHAR),
1793: NVL(fincl_lgl_event_ind, FND_API.G_MISS_CHAR),

Line 1790: NVL(criminal_proceeding_ind, FND_API.G_MISS_CHAR),

1786: NVL(rating_organization, FND_API.G_MISS_CHAR),
1787: NVL(comments, FND_API.G_MISS_CHAR),
1788: NVL(det_history_ind, FND_API.G_MISS_CHAR),
1789: NVL(fincl_embt_ind, FND_API.G_MISS_CHAR),
1790: NVL(criminal_proceeding_ind, FND_API.G_MISS_CHAR),
1791: NVL(claims_ind, FND_API.G_MISS_CHAR),
1792: NVL(secured_flng_ind, FND_API.G_MISS_CHAR),
1793: NVL(fincl_lgl_event_ind, FND_API.G_MISS_CHAR),
1794: NVL(disaster_ind, FND_API.G_MISS_CHAR),

Line 1791: NVL(claims_ind, FND_API.G_MISS_CHAR),

1787: NVL(comments, FND_API.G_MISS_CHAR),
1788: NVL(det_history_ind, FND_API.G_MISS_CHAR),
1789: NVL(fincl_embt_ind, FND_API.G_MISS_CHAR),
1790: NVL(criminal_proceeding_ind, FND_API.G_MISS_CHAR),
1791: NVL(claims_ind, FND_API.G_MISS_CHAR),
1792: NVL(secured_flng_ind, FND_API.G_MISS_CHAR),
1793: NVL(fincl_lgl_event_ind, FND_API.G_MISS_CHAR),
1794: NVL(disaster_ind, FND_API.G_MISS_CHAR),
1795: NVL(oprg_spec_evnt_ind, FND_API.G_MISS_CHAR),

Line 1792: NVL(secured_flng_ind, FND_API.G_MISS_CHAR),

1788: NVL(det_history_ind, FND_API.G_MISS_CHAR),
1789: NVL(fincl_embt_ind, FND_API.G_MISS_CHAR),
1790: NVL(criminal_proceeding_ind, FND_API.G_MISS_CHAR),
1791: NVL(claims_ind, FND_API.G_MISS_CHAR),
1792: NVL(secured_flng_ind, FND_API.G_MISS_CHAR),
1793: NVL(fincl_lgl_event_ind, FND_API.G_MISS_CHAR),
1794: NVL(disaster_ind, FND_API.G_MISS_CHAR),
1795: NVL(oprg_spec_evnt_ind, FND_API.G_MISS_CHAR),
1796: NVL(other_spec_evnt_ind, FND_API.G_MISS_CHAR),

Line 1793: NVL(fincl_lgl_event_ind, FND_API.G_MISS_CHAR),

1789: NVL(fincl_embt_ind, FND_API.G_MISS_CHAR),
1790: NVL(criminal_proceeding_ind, FND_API.G_MISS_CHAR),
1791: NVL(claims_ind, FND_API.G_MISS_CHAR),
1792: NVL(secured_flng_ind, FND_API.G_MISS_CHAR),
1793: NVL(fincl_lgl_event_ind, FND_API.G_MISS_CHAR),
1794: NVL(disaster_ind, FND_API.G_MISS_CHAR),
1795: NVL(oprg_spec_evnt_ind, FND_API.G_MISS_CHAR),
1796: NVL(other_spec_evnt_ind, FND_API.G_MISS_CHAR),
1797: NVL(status, FND_API.G_MISS_CHAR),

Line 1794: NVL(disaster_ind, FND_API.G_MISS_CHAR),

1790: NVL(criminal_proceeding_ind, FND_API.G_MISS_CHAR),
1791: NVL(claims_ind, FND_API.G_MISS_CHAR),
1792: NVL(secured_flng_ind, FND_API.G_MISS_CHAR),
1793: NVL(fincl_lgl_event_ind, FND_API.G_MISS_CHAR),
1794: NVL(disaster_ind, FND_API.G_MISS_CHAR),
1795: NVL(oprg_spec_evnt_ind, FND_API.G_MISS_CHAR),
1796: NVL(other_spec_evnt_ind, FND_API.G_MISS_CHAR),
1797: NVL(status, FND_API.G_MISS_CHAR),
1798: NVL(created_by_module, FND_API.G_MISS_CHAR),

Line 1795: NVL(oprg_spec_evnt_ind, FND_API.G_MISS_CHAR),

1791: NVL(claims_ind, FND_API.G_MISS_CHAR),
1792: NVL(secured_flng_ind, FND_API.G_MISS_CHAR),
1793: NVL(fincl_lgl_event_ind, FND_API.G_MISS_CHAR),
1794: NVL(disaster_ind, FND_API.G_MISS_CHAR),
1795: NVL(oprg_spec_evnt_ind, FND_API.G_MISS_CHAR),
1796: NVL(other_spec_evnt_ind, FND_API.G_MISS_CHAR),
1797: NVL(status, FND_API.G_MISS_CHAR),
1798: NVL(created_by_module, FND_API.G_MISS_CHAR),
1799: NVL(avg_high_credit, FND_API.G_MISS_NUM),

Line 1796: NVL(other_spec_evnt_ind, FND_API.G_MISS_CHAR),

1792: NVL(secured_flng_ind, FND_API.G_MISS_CHAR),
1793: NVL(fincl_lgl_event_ind, FND_API.G_MISS_CHAR),
1794: NVL(disaster_ind, FND_API.G_MISS_CHAR),
1795: NVL(oprg_spec_evnt_ind, FND_API.G_MISS_CHAR),
1796: NVL(other_spec_evnt_ind, FND_API.G_MISS_CHAR),
1797: NVL(status, FND_API.G_MISS_CHAR),
1798: NVL(created_by_module, FND_API.G_MISS_CHAR),
1799: NVL(avg_high_credit, FND_API.G_MISS_NUM),
1800: NVL(credit_score, FND_API.G_MISS_CHAR),

Line 1797: NVL(status, FND_API.G_MISS_CHAR),

1793: NVL(fincl_lgl_event_ind, FND_API.G_MISS_CHAR),
1794: NVL(disaster_ind, FND_API.G_MISS_CHAR),
1795: NVL(oprg_spec_evnt_ind, FND_API.G_MISS_CHAR),
1796: NVL(other_spec_evnt_ind, FND_API.G_MISS_CHAR),
1797: NVL(status, FND_API.G_MISS_CHAR),
1798: NVL(created_by_module, FND_API.G_MISS_CHAR),
1799: NVL(avg_high_credit, FND_API.G_MISS_NUM),
1800: NVL(credit_score, FND_API.G_MISS_CHAR),
1801: NVL(credit_score_age, FND_API.G_MISS_NUM),

Line 1798: NVL(created_by_module, FND_API.G_MISS_CHAR),

1794: NVL(disaster_ind, FND_API.G_MISS_CHAR),
1795: NVL(oprg_spec_evnt_ind, FND_API.G_MISS_CHAR),
1796: NVL(other_spec_evnt_ind, FND_API.G_MISS_CHAR),
1797: NVL(status, FND_API.G_MISS_CHAR),
1798: NVL(created_by_module, FND_API.G_MISS_CHAR),
1799: NVL(avg_high_credit, FND_API.G_MISS_NUM),
1800: NVL(credit_score, FND_API.G_MISS_CHAR),
1801: NVL(credit_score_age, FND_API.G_MISS_NUM),
1802: NVL(credit_score_class, FND_API.G_MISS_NUM),

Line 1799: NVL(avg_high_credit, FND_API.G_MISS_NUM),

1795: NVL(oprg_spec_evnt_ind, FND_API.G_MISS_CHAR),
1796: NVL(other_spec_evnt_ind, FND_API.G_MISS_CHAR),
1797: NVL(status, FND_API.G_MISS_CHAR),
1798: NVL(created_by_module, FND_API.G_MISS_CHAR),
1799: NVL(avg_high_credit, FND_API.G_MISS_NUM),
1800: NVL(credit_score, FND_API.G_MISS_CHAR),
1801: NVL(credit_score_age, FND_API.G_MISS_NUM),
1802: NVL(credit_score_class, FND_API.G_MISS_NUM),
1803: NVL(credit_score_commentary, FND_API.G_MISS_CHAR),

Line 1800: NVL(credit_score, FND_API.G_MISS_CHAR),

1796: NVL(other_spec_evnt_ind, FND_API.G_MISS_CHAR),
1797: NVL(status, FND_API.G_MISS_CHAR),
1798: NVL(created_by_module, FND_API.G_MISS_CHAR),
1799: NVL(avg_high_credit, FND_API.G_MISS_NUM),
1800: NVL(credit_score, FND_API.G_MISS_CHAR),
1801: NVL(credit_score_age, FND_API.G_MISS_NUM),
1802: NVL(credit_score_class, FND_API.G_MISS_NUM),
1803: NVL(credit_score_commentary, FND_API.G_MISS_CHAR),
1804: NVL(credit_score_commentary2, FND_API.G_MISS_CHAR),

Line 1801: NVL(credit_score_age, FND_API.G_MISS_NUM),

1797: NVL(status, FND_API.G_MISS_CHAR),
1798: NVL(created_by_module, FND_API.G_MISS_CHAR),
1799: NVL(avg_high_credit, FND_API.G_MISS_NUM),
1800: NVL(credit_score, FND_API.G_MISS_CHAR),
1801: NVL(credit_score_age, FND_API.G_MISS_NUM),
1802: NVL(credit_score_class, FND_API.G_MISS_NUM),
1803: NVL(credit_score_commentary, FND_API.G_MISS_CHAR),
1804: NVL(credit_score_commentary2, FND_API.G_MISS_CHAR),
1805: NVL(credit_score_commentary3, FND_API.G_MISS_CHAR),

Line 1802: NVL(credit_score_class, FND_API.G_MISS_NUM),

1798: NVL(created_by_module, FND_API.G_MISS_CHAR),
1799: NVL(avg_high_credit, FND_API.G_MISS_NUM),
1800: NVL(credit_score, FND_API.G_MISS_CHAR),
1801: NVL(credit_score_age, FND_API.G_MISS_NUM),
1802: NVL(credit_score_class, FND_API.G_MISS_NUM),
1803: NVL(credit_score_commentary, FND_API.G_MISS_CHAR),
1804: NVL(credit_score_commentary2, FND_API.G_MISS_CHAR),
1805: NVL(credit_score_commentary3, FND_API.G_MISS_CHAR),
1806: NVL(credit_score_commentary4, FND_API.G_MISS_CHAR),

Line 1803: NVL(credit_score_commentary, FND_API.G_MISS_CHAR),

1799: NVL(avg_high_credit, FND_API.G_MISS_NUM),
1800: NVL(credit_score, FND_API.G_MISS_CHAR),
1801: NVL(credit_score_age, FND_API.G_MISS_NUM),
1802: NVL(credit_score_class, FND_API.G_MISS_NUM),
1803: NVL(credit_score_commentary, FND_API.G_MISS_CHAR),
1804: NVL(credit_score_commentary2, FND_API.G_MISS_CHAR),
1805: NVL(credit_score_commentary3, FND_API.G_MISS_CHAR),
1806: NVL(credit_score_commentary4, FND_API.G_MISS_CHAR),
1807: NVL(credit_score_commentary5, FND_API.G_MISS_CHAR),

Line 1804: NVL(credit_score_commentary2, FND_API.G_MISS_CHAR),

1800: NVL(credit_score, FND_API.G_MISS_CHAR),
1801: NVL(credit_score_age, FND_API.G_MISS_NUM),
1802: NVL(credit_score_class, FND_API.G_MISS_NUM),
1803: NVL(credit_score_commentary, FND_API.G_MISS_CHAR),
1804: NVL(credit_score_commentary2, FND_API.G_MISS_CHAR),
1805: NVL(credit_score_commentary3, FND_API.G_MISS_CHAR),
1806: NVL(credit_score_commentary4, FND_API.G_MISS_CHAR),
1807: NVL(credit_score_commentary5, FND_API.G_MISS_CHAR),
1808: NVL(credit_score_commentary6, FND_API.G_MISS_CHAR),

Line 1805: NVL(credit_score_commentary3, FND_API.G_MISS_CHAR),

1801: NVL(credit_score_age, FND_API.G_MISS_NUM),
1802: NVL(credit_score_class, FND_API.G_MISS_NUM),
1803: NVL(credit_score_commentary, FND_API.G_MISS_CHAR),
1804: NVL(credit_score_commentary2, FND_API.G_MISS_CHAR),
1805: NVL(credit_score_commentary3, FND_API.G_MISS_CHAR),
1806: NVL(credit_score_commentary4, FND_API.G_MISS_CHAR),
1807: NVL(credit_score_commentary5, FND_API.G_MISS_CHAR),
1808: NVL(credit_score_commentary6, FND_API.G_MISS_CHAR),
1809: NVL(credit_score_commentary7, FND_API.G_MISS_CHAR),

Line 1806: NVL(credit_score_commentary4, FND_API.G_MISS_CHAR),

1802: NVL(credit_score_class, FND_API.G_MISS_NUM),
1803: NVL(credit_score_commentary, FND_API.G_MISS_CHAR),
1804: NVL(credit_score_commentary2, FND_API.G_MISS_CHAR),
1805: NVL(credit_score_commentary3, FND_API.G_MISS_CHAR),
1806: NVL(credit_score_commentary4, FND_API.G_MISS_CHAR),
1807: NVL(credit_score_commentary5, FND_API.G_MISS_CHAR),
1808: NVL(credit_score_commentary6, FND_API.G_MISS_CHAR),
1809: NVL(credit_score_commentary7, FND_API.G_MISS_CHAR),
1810: NVL(credit_score_commentary8, FND_API.G_MISS_CHAR),

Line 1807: NVL(credit_score_commentary5, FND_API.G_MISS_CHAR),

1803: NVL(credit_score_commentary, FND_API.G_MISS_CHAR),
1804: NVL(credit_score_commentary2, FND_API.G_MISS_CHAR),
1805: NVL(credit_score_commentary3, FND_API.G_MISS_CHAR),
1806: NVL(credit_score_commentary4, FND_API.G_MISS_CHAR),
1807: NVL(credit_score_commentary5, FND_API.G_MISS_CHAR),
1808: NVL(credit_score_commentary6, FND_API.G_MISS_CHAR),
1809: NVL(credit_score_commentary7, FND_API.G_MISS_CHAR),
1810: NVL(credit_score_commentary8, FND_API.G_MISS_CHAR),
1811: NVL(credit_score_commentary9, FND_API.G_MISS_CHAR),

Line 1808: NVL(credit_score_commentary6, FND_API.G_MISS_CHAR),

1804: NVL(credit_score_commentary2, FND_API.G_MISS_CHAR),
1805: NVL(credit_score_commentary3, FND_API.G_MISS_CHAR),
1806: NVL(credit_score_commentary4, FND_API.G_MISS_CHAR),
1807: NVL(credit_score_commentary5, FND_API.G_MISS_CHAR),
1808: NVL(credit_score_commentary6, FND_API.G_MISS_CHAR),
1809: NVL(credit_score_commentary7, FND_API.G_MISS_CHAR),
1810: NVL(credit_score_commentary8, FND_API.G_MISS_CHAR),
1811: NVL(credit_score_commentary9, FND_API.G_MISS_CHAR),
1812: NVL(credit_score_commentary10, FND_API.G_MISS_CHAR),

Line 1809: NVL(credit_score_commentary7, FND_API.G_MISS_CHAR),

1805: NVL(credit_score_commentary3, FND_API.G_MISS_CHAR),
1806: NVL(credit_score_commentary4, FND_API.G_MISS_CHAR),
1807: NVL(credit_score_commentary5, FND_API.G_MISS_CHAR),
1808: NVL(credit_score_commentary6, FND_API.G_MISS_CHAR),
1809: NVL(credit_score_commentary7, FND_API.G_MISS_CHAR),
1810: NVL(credit_score_commentary8, FND_API.G_MISS_CHAR),
1811: NVL(credit_score_commentary9, FND_API.G_MISS_CHAR),
1812: NVL(credit_score_commentary10, FND_API.G_MISS_CHAR),
1813: NVL(credit_score_date, FND_API.G_MISS_DATE),

Line 1810: NVL(credit_score_commentary8, FND_API.G_MISS_CHAR),

1806: NVL(credit_score_commentary4, FND_API.G_MISS_CHAR),
1807: NVL(credit_score_commentary5, FND_API.G_MISS_CHAR),
1808: NVL(credit_score_commentary6, FND_API.G_MISS_CHAR),
1809: NVL(credit_score_commentary7, FND_API.G_MISS_CHAR),
1810: NVL(credit_score_commentary8, FND_API.G_MISS_CHAR),
1811: NVL(credit_score_commentary9, FND_API.G_MISS_CHAR),
1812: NVL(credit_score_commentary10, FND_API.G_MISS_CHAR),
1813: NVL(credit_score_date, FND_API.G_MISS_DATE),
1814: NVL(credit_score_incd_default, FND_API.G_MISS_NUM),

Line 1811: NVL(credit_score_commentary9, FND_API.G_MISS_CHAR),

1807: NVL(credit_score_commentary5, FND_API.G_MISS_CHAR),
1808: NVL(credit_score_commentary6, FND_API.G_MISS_CHAR),
1809: NVL(credit_score_commentary7, FND_API.G_MISS_CHAR),
1810: NVL(credit_score_commentary8, FND_API.G_MISS_CHAR),
1811: NVL(credit_score_commentary9, FND_API.G_MISS_CHAR),
1812: NVL(credit_score_commentary10, FND_API.G_MISS_CHAR),
1813: NVL(credit_score_date, FND_API.G_MISS_DATE),
1814: NVL(credit_score_incd_default, FND_API.G_MISS_NUM),
1815: NVL(credit_score_natl_percentile, FND_API.G_MISS_NUM),

Line 1812: NVL(credit_score_commentary10, FND_API.G_MISS_CHAR),

1808: NVL(credit_score_commentary6, FND_API.G_MISS_CHAR),
1809: NVL(credit_score_commentary7, FND_API.G_MISS_CHAR),
1810: NVL(credit_score_commentary8, FND_API.G_MISS_CHAR),
1811: NVL(credit_score_commentary9, FND_API.G_MISS_CHAR),
1812: NVL(credit_score_commentary10, FND_API.G_MISS_CHAR),
1813: NVL(credit_score_date, FND_API.G_MISS_DATE),
1814: NVL(credit_score_incd_default, FND_API.G_MISS_NUM),
1815: NVL(credit_score_natl_percentile, FND_API.G_MISS_NUM),
1816: NVL(debarment_ind, FND_API.G_MISS_CHAR),

Line 1813: NVL(credit_score_date, FND_API.G_MISS_DATE),

1809: NVL(credit_score_commentary7, FND_API.G_MISS_CHAR),
1810: NVL(credit_score_commentary8, FND_API.G_MISS_CHAR),
1811: NVL(credit_score_commentary9, FND_API.G_MISS_CHAR),
1812: NVL(credit_score_commentary10, FND_API.G_MISS_CHAR),
1813: NVL(credit_score_date, FND_API.G_MISS_DATE),
1814: NVL(credit_score_incd_default, FND_API.G_MISS_NUM),
1815: NVL(credit_score_natl_percentile, FND_API.G_MISS_NUM),
1816: NVL(debarment_ind, FND_API.G_MISS_CHAR),
1817: NVL(debarments_count, FND_API.G_MISS_NUM),

Line 1814: NVL(credit_score_incd_default, FND_API.G_MISS_NUM),

1810: NVL(credit_score_commentary8, FND_API.G_MISS_CHAR),
1811: NVL(credit_score_commentary9, FND_API.G_MISS_CHAR),
1812: NVL(credit_score_commentary10, FND_API.G_MISS_CHAR),
1813: NVL(credit_score_date, FND_API.G_MISS_DATE),
1814: NVL(credit_score_incd_default, FND_API.G_MISS_NUM),
1815: NVL(credit_score_natl_percentile, FND_API.G_MISS_NUM),
1816: NVL(debarment_ind, FND_API.G_MISS_CHAR),
1817: NVL(debarments_count, FND_API.G_MISS_NUM),
1818: NVL(debarments_date, FND_API.G_MISS_DATE),

Line 1815: NVL(credit_score_natl_percentile, FND_API.G_MISS_NUM),

1811: NVL(credit_score_commentary9, FND_API.G_MISS_CHAR),
1812: NVL(credit_score_commentary10, FND_API.G_MISS_CHAR),
1813: NVL(credit_score_date, FND_API.G_MISS_DATE),
1814: NVL(credit_score_incd_default, FND_API.G_MISS_NUM),
1815: NVL(credit_score_natl_percentile, FND_API.G_MISS_NUM),
1816: NVL(debarment_ind, FND_API.G_MISS_CHAR),
1817: NVL(debarments_count, FND_API.G_MISS_NUM),
1818: NVL(debarments_date, FND_API.G_MISS_DATE),
1819: NVL(high_credit, FND_API.G_MISS_NUM),

Line 1816: NVL(debarment_ind, FND_API.G_MISS_CHAR),

1812: NVL(credit_score_commentary10, FND_API.G_MISS_CHAR),
1813: NVL(credit_score_date, FND_API.G_MISS_DATE),
1814: NVL(credit_score_incd_default, FND_API.G_MISS_NUM),
1815: NVL(credit_score_natl_percentile, FND_API.G_MISS_NUM),
1816: NVL(debarment_ind, FND_API.G_MISS_CHAR),
1817: NVL(debarments_count, FND_API.G_MISS_NUM),
1818: NVL(debarments_date, FND_API.G_MISS_DATE),
1819: NVL(high_credit, FND_API.G_MISS_NUM),
1820: NVL(maximum_credit_currency_code, FND_API.G_MISS_CHAR),

Line 1817: NVL(debarments_count, FND_API.G_MISS_NUM),

1813: NVL(credit_score_date, FND_API.G_MISS_DATE),
1814: NVL(credit_score_incd_default, FND_API.G_MISS_NUM),
1815: NVL(credit_score_natl_percentile, FND_API.G_MISS_NUM),
1816: NVL(debarment_ind, FND_API.G_MISS_CHAR),
1817: NVL(debarments_count, FND_API.G_MISS_NUM),
1818: NVL(debarments_date, FND_API.G_MISS_DATE),
1819: NVL(high_credit, FND_API.G_MISS_NUM),
1820: NVL(maximum_credit_currency_code, FND_API.G_MISS_CHAR),
1821: NVL(maximum_credit_recommendation, FND_API.G_MISS_NUM),

Line 1818: NVL(debarments_date, FND_API.G_MISS_DATE),

1814: NVL(credit_score_incd_default, FND_API.G_MISS_NUM),
1815: NVL(credit_score_natl_percentile, FND_API.G_MISS_NUM),
1816: NVL(debarment_ind, FND_API.G_MISS_CHAR),
1817: NVL(debarments_count, FND_API.G_MISS_NUM),
1818: NVL(debarments_date, FND_API.G_MISS_DATE),
1819: NVL(high_credit, FND_API.G_MISS_NUM),
1820: NVL(maximum_credit_currency_code, FND_API.G_MISS_CHAR),
1821: NVL(maximum_credit_recommendation, FND_API.G_MISS_NUM),
1822: NVL(paydex_norm, FND_API.G_MISS_CHAR),

Line 1819: NVL(high_credit, FND_API.G_MISS_NUM),

1815: NVL(credit_score_natl_percentile, FND_API.G_MISS_NUM),
1816: NVL(debarment_ind, FND_API.G_MISS_CHAR),
1817: NVL(debarments_count, FND_API.G_MISS_NUM),
1818: NVL(debarments_date, FND_API.G_MISS_DATE),
1819: NVL(high_credit, FND_API.G_MISS_NUM),
1820: NVL(maximum_credit_currency_code, FND_API.G_MISS_CHAR),
1821: NVL(maximum_credit_recommendation, FND_API.G_MISS_NUM),
1822: NVL(paydex_norm, FND_API.G_MISS_CHAR),
1823: NVL(paydex_score, FND_API.G_MISS_CHAR),

Line 1820: NVL(maximum_credit_currency_code, FND_API.G_MISS_CHAR),

1816: NVL(debarment_ind, FND_API.G_MISS_CHAR),
1817: NVL(debarments_count, FND_API.G_MISS_NUM),
1818: NVL(debarments_date, FND_API.G_MISS_DATE),
1819: NVL(high_credit, FND_API.G_MISS_NUM),
1820: NVL(maximum_credit_currency_code, FND_API.G_MISS_CHAR),
1821: NVL(maximum_credit_recommendation, FND_API.G_MISS_NUM),
1822: NVL(paydex_norm, FND_API.G_MISS_CHAR),
1823: NVL(paydex_score, FND_API.G_MISS_CHAR),
1824: NVL(paydex_three_months_ago, FND_API.G_MISS_CHAR),

Line 1821: NVL(maximum_credit_recommendation, FND_API.G_MISS_NUM),

1817: NVL(debarments_count, FND_API.G_MISS_NUM),
1818: NVL(debarments_date, FND_API.G_MISS_DATE),
1819: NVL(high_credit, FND_API.G_MISS_NUM),
1820: NVL(maximum_credit_currency_code, FND_API.G_MISS_CHAR),
1821: NVL(maximum_credit_recommendation, FND_API.G_MISS_NUM),
1822: NVL(paydex_norm, FND_API.G_MISS_CHAR),
1823: NVL(paydex_score, FND_API.G_MISS_CHAR),
1824: NVL(paydex_three_months_ago, FND_API.G_MISS_CHAR),
1825: NVL(credit_score_override_code, FND_API.G_MISS_CHAR),

Line 1822: NVL(paydex_norm, FND_API.G_MISS_CHAR),

1818: NVL(debarments_date, FND_API.G_MISS_DATE),
1819: NVL(high_credit, FND_API.G_MISS_NUM),
1820: NVL(maximum_credit_currency_code, FND_API.G_MISS_CHAR),
1821: NVL(maximum_credit_recommendation, FND_API.G_MISS_NUM),
1822: NVL(paydex_norm, FND_API.G_MISS_CHAR),
1823: NVL(paydex_score, FND_API.G_MISS_CHAR),
1824: NVL(paydex_three_months_ago, FND_API.G_MISS_CHAR),
1825: NVL(credit_score_override_code, FND_API.G_MISS_CHAR),
1826: NVL(cr_scr_clas_expl, FND_API.G_MISS_CHAR),

Line 1823: NVL(paydex_score, FND_API.G_MISS_CHAR),

1819: NVL(high_credit, FND_API.G_MISS_NUM),
1820: NVL(maximum_credit_currency_code, FND_API.G_MISS_CHAR),
1821: NVL(maximum_credit_recommendation, FND_API.G_MISS_NUM),
1822: NVL(paydex_norm, FND_API.G_MISS_CHAR),
1823: NVL(paydex_score, FND_API.G_MISS_CHAR),
1824: NVL(paydex_three_months_ago, FND_API.G_MISS_CHAR),
1825: NVL(credit_score_override_code, FND_API.G_MISS_CHAR),
1826: NVL(cr_scr_clas_expl, FND_API.G_MISS_CHAR),
1827: NVL(low_rng_delq_scr, FND_API.G_MISS_NUM),

Line 1824: NVL(paydex_three_months_ago, FND_API.G_MISS_CHAR),

1820: NVL(maximum_credit_currency_code, FND_API.G_MISS_CHAR),
1821: NVL(maximum_credit_recommendation, FND_API.G_MISS_NUM),
1822: NVL(paydex_norm, FND_API.G_MISS_CHAR),
1823: NVL(paydex_score, FND_API.G_MISS_CHAR),
1824: NVL(paydex_three_months_ago, FND_API.G_MISS_CHAR),
1825: NVL(credit_score_override_code, FND_API.G_MISS_CHAR),
1826: NVL(cr_scr_clas_expl, FND_API.G_MISS_CHAR),
1827: NVL(low_rng_delq_scr, FND_API.G_MISS_NUM),
1828: NVL(high_rng_delq_scr, FND_API.G_MISS_NUM),

Line 1825: NVL(credit_score_override_code, FND_API.G_MISS_CHAR),

1821: NVL(maximum_credit_recommendation, FND_API.G_MISS_NUM),
1822: NVL(paydex_norm, FND_API.G_MISS_CHAR),
1823: NVL(paydex_score, FND_API.G_MISS_CHAR),
1824: NVL(paydex_three_months_ago, FND_API.G_MISS_CHAR),
1825: NVL(credit_score_override_code, FND_API.G_MISS_CHAR),
1826: NVL(cr_scr_clas_expl, FND_API.G_MISS_CHAR),
1827: NVL(low_rng_delq_scr, FND_API.G_MISS_NUM),
1828: NVL(high_rng_delq_scr, FND_API.G_MISS_NUM),
1829: NVL(delq_pmt_rng_prcnt, FND_API.G_MISS_NUM),

Line 1826: NVL(cr_scr_clas_expl, FND_API.G_MISS_CHAR),

1822: NVL(paydex_norm, FND_API.G_MISS_CHAR),
1823: NVL(paydex_score, FND_API.G_MISS_CHAR),
1824: NVL(paydex_three_months_ago, FND_API.G_MISS_CHAR),
1825: NVL(credit_score_override_code, FND_API.G_MISS_CHAR),
1826: NVL(cr_scr_clas_expl, FND_API.G_MISS_CHAR),
1827: NVL(low_rng_delq_scr, FND_API.G_MISS_NUM),
1828: NVL(high_rng_delq_scr, FND_API.G_MISS_NUM),
1829: NVL(delq_pmt_rng_prcnt, FND_API.G_MISS_NUM),
1830: NVL(delq_pmt_pctg_for_all_firms, FND_API.G_MISS_NUM),

Line 1827: NVL(low_rng_delq_scr, FND_API.G_MISS_NUM),

1823: NVL(paydex_score, FND_API.G_MISS_CHAR),
1824: NVL(paydex_three_months_ago, FND_API.G_MISS_CHAR),
1825: NVL(credit_score_override_code, FND_API.G_MISS_CHAR),
1826: NVL(cr_scr_clas_expl, FND_API.G_MISS_CHAR),
1827: NVL(low_rng_delq_scr, FND_API.G_MISS_NUM),
1828: NVL(high_rng_delq_scr, FND_API.G_MISS_NUM),
1829: NVL(delq_pmt_rng_prcnt, FND_API.G_MISS_NUM),
1830: NVL(delq_pmt_pctg_for_all_firms, FND_API.G_MISS_NUM),
1831: NVL(num_trade_experiences, FND_API.G_MISS_NUM),

Line 1828: NVL(high_rng_delq_scr, FND_API.G_MISS_NUM),

1824: NVL(paydex_three_months_ago, FND_API.G_MISS_CHAR),
1825: NVL(credit_score_override_code, FND_API.G_MISS_CHAR),
1826: NVL(cr_scr_clas_expl, FND_API.G_MISS_CHAR),
1827: NVL(low_rng_delq_scr, FND_API.G_MISS_NUM),
1828: NVL(high_rng_delq_scr, FND_API.G_MISS_NUM),
1829: NVL(delq_pmt_rng_prcnt, FND_API.G_MISS_NUM),
1830: NVL(delq_pmt_pctg_for_all_firms, FND_API.G_MISS_NUM),
1831: NVL(num_trade_experiences, FND_API.G_MISS_NUM),
1832: NVL(paydex_firm_days, FND_API.G_MISS_CHAR),

Line 1829: NVL(delq_pmt_rng_prcnt, FND_API.G_MISS_NUM),

1825: NVL(credit_score_override_code, FND_API.G_MISS_CHAR),
1826: NVL(cr_scr_clas_expl, FND_API.G_MISS_CHAR),
1827: NVL(low_rng_delq_scr, FND_API.G_MISS_NUM),
1828: NVL(high_rng_delq_scr, FND_API.G_MISS_NUM),
1829: NVL(delq_pmt_rng_prcnt, FND_API.G_MISS_NUM),
1830: NVL(delq_pmt_pctg_for_all_firms, FND_API.G_MISS_NUM),
1831: NVL(num_trade_experiences, FND_API.G_MISS_NUM),
1832: NVL(paydex_firm_days, FND_API.G_MISS_CHAR),
1833: NVL(paydex_firm_comment, FND_API.G_MISS_CHAR),

Line 1830: NVL(delq_pmt_pctg_for_all_firms, FND_API.G_MISS_NUM),

1826: NVL(cr_scr_clas_expl, FND_API.G_MISS_CHAR),
1827: NVL(low_rng_delq_scr, FND_API.G_MISS_NUM),
1828: NVL(high_rng_delq_scr, FND_API.G_MISS_NUM),
1829: NVL(delq_pmt_rng_prcnt, FND_API.G_MISS_NUM),
1830: NVL(delq_pmt_pctg_for_all_firms, FND_API.G_MISS_NUM),
1831: NVL(num_trade_experiences, FND_API.G_MISS_NUM),
1832: NVL(paydex_firm_days, FND_API.G_MISS_CHAR),
1833: NVL(paydex_firm_comment, FND_API.G_MISS_CHAR),
1834: NVL(paydex_industry_days, FND_API.G_MISS_CHAR),

Line 1831: NVL(num_trade_experiences, FND_API.G_MISS_NUM),

1827: NVL(low_rng_delq_scr, FND_API.G_MISS_NUM),
1828: NVL(high_rng_delq_scr, FND_API.G_MISS_NUM),
1829: NVL(delq_pmt_rng_prcnt, FND_API.G_MISS_NUM),
1830: NVL(delq_pmt_pctg_for_all_firms, FND_API.G_MISS_NUM),
1831: NVL(num_trade_experiences, FND_API.G_MISS_NUM),
1832: NVL(paydex_firm_days, FND_API.G_MISS_CHAR),
1833: NVL(paydex_firm_comment, FND_API.G_MISS_CHAR),
1834: NVL(paydex_industry_days, FND_API.G_MISS_CHAR),
1835: NVL(paydex_industry_comment, FND_API.G_MISS_CHAR),

Line 1832: NVL(paydex_firm_days, FND_API.G_MISS_CHAR),

1828: NVL(high_rng_delq_scr, FND_API.G_MISS_NUM),
1829: NVL(delq_pmt_rng_prcnt, FND_API.G_MISS_NUM),
1830: NVL(delq_pmt_pctg_for_all_firms, FND_API.G_MISS_NUM),
1831: NVL(num_trade_experiences, FND_API.G_MISS_NUM),
1832: NVL(paydex_firm_days, FND_API.G_MISS_CHAR),
1833: NVL(paydex_firm_comment, FND_API.G_MISS_CHAR),
1834: NVL(paydex_industry_days, FND_API.G_MISS_CHAR),
1835: NVL(paydex_industry_comment, FND_API.G_MISS_CHAR),
1836: NVL(paydex_comment, FND_API.G_MISS_CHAR),

Line 1833: NVL(paydex_firm_comment, FND_API.G_MISS_CHAR),

1829: NVL(delq_pmt_rng_prcnt, FND_API.G_MISS_NUM),
1830: NVL(delq_pmt_pctg_for_all_firms, FND_API.G_MISS_NUM),
1831: NVL(num_trade_experiences, FND_API.G_MISS_NUM),
1832: NVL(paydex_firm_days, FND_API.G_MISS_CHAR),
1833: NVL(paydex_firm_comment, FND_API.G_MISS_CHAR),
1834: NVL(paydex_industry_days, FND_API.G_MISS_CHAR),
1835: NVL(paydex_industry_comment, FND_API.G_MISS_CHAR),
1836: NVL(paydex_comment, FND_API.G_MISS_CHAR),
1837: NVL(suit_ind, FND_API.G_MISS_CHAR),

Line 1834: NVL(paydex_industry_days, FND_API.G_MISS_CHAR),

1830: NVL(delq_pmt_pctg_for_all_firms, FND_API.G_MISS_NUM),
1831: NVL(num_trade_experiences, FND_API.G_MISS_NUM),
1832: NVL(paydex_firm_days, FND_API.G_MISS_CHAR),
1833: NVL(paydex_firm_comment, FND_API.G_MISS_CHAR),
1834: NVL(paydex_industry_days, FND_API.G_MISS_CHAR),
1835: NVL(paydex_industry_comment, FND_API.G_MISS_CHAR),
1836: NVL(paydex_comment, FND_API.G_MISS_CHAR),
1837: NVL(suit_ind, FND_API.G_MISS_CHAR),
1838: NVL(lien_ind, FND_API.G_MISS_CHAR),

Line 1835: NVL(paydex_industry_comment, FND_API.G_MISS_CHAR),

1831: NVL(num_trade_experiences, FND_API.G_MISS_NUM),
1832: NVL(paydex_firm_days, FND_API.G_MISS_CHAR),
1833: NVL(paydex_firm_comment, FND_API.G_MISS_CHAR),
1834: NVL(paydex_industry_days, FND_API.G_MISS_CHAR),
1835: NVL(paydex_industry_comment, FND_API.G_MISS_CHAR),
1836: NVL(paydex_comment, FND_API.G_MISS_CHAR),
1837: NVL(suit_ind, FND_API.G_MISS_CHAR),
1838: NVL(lien_ind, FND_API.G_MISS_CHAR),
1839: NVL(judgement_ind, FND_API.G_MISS_CHAR),

Line 1836: NVL(paydex_comment, FND_API.G_MISS_CHAR),

1832: NVL(paydex_firm_days, FND_API.G_MISS_CHAR),
1833: NVL(paydex_firm_comment, FND_API.G_MISS_CHAR),
1834: NVL(paydex_industry_days, FND_API.G_MISS_CHAR),
1835: NVL(paydex_industry_comment, FND_API.G_MISS_CHAR),
1836: NVL(paydex_comment, FND_API.G_MISS_CHAR),
1837: NVL(suit_ind, FND_API.G_MISS_CHAR),
1838: NVL(lien_ind, FND_API.G_MISS_CHAR),
1839: NVL(judgement_ind, FND_API.G_MISS_CHAR),
1840: NVL(bankruptcy_ind, FND_API.G_MISS_CHAR),

Line 1837: NVL(suit_ind, FND_API.G_MISS_CHAR),

1833: NVL(paydex_firm_comment, FND_API.G_MISS_CHAR),
1834: NVL(paydex_industry_days, FND_API.G_MISS_CHAR),
1835: NVL(paydex_industry_comment, FND_API.G_MISS_CHAR),
1836: NVL(paydex_comment, FND_API.G_MISS_CHAR),
1837: NVL(suit_ind, FND_API.G_MISS_CHAR),
1838: NVL(lien_ind, FND_API.G_MISS_CHAR),
1839: NVL(judgement_ind, FND_API.G_MISS_CHAR),
1840: NVL(bankruptcy_ind, FND_API.G_MISS_CHAR),
1841: NVL(no_trade_ind, FND_API.G_MISS_CHAR),

Line 1838: NVL(lien_ind, FND_API.G_MISS_CHAR),

1834: NVL(paydex_industry_days, FND_API.G_MISS_CHAR),
1835: NVL(paydex_industry_comment, FND_API.G_MISS_CHAR),
1836: NVL(paydex_comment, FND_API.G_MISS_CHAR),
1837: NVL(suit_ind, FND_API.G_MISS_CHAR),
1838: NVL(lien_ind, FND_API.G_MISS_CHAR),
1839: NVL(judgement_ind, FND_API.G_MISS_CHAR),
1840: NVL(bankruptcy_ind, FND_API.G_MISS_CHAR),
1841: NVL(no_trade_ind, FND_API.G_MISS_CHAR),
1842: NVL(prnt_hq_bkcy_ind, FND_API.G_MISS_CHAR),

Line 1839: NVL(judgement_ind, FND_API.G_MISS_CHAR),

1835: NVL(paydex_industry_comment, FND_API.G_MISS_CHAR),
1836: NVL(paydex_comment, FND_API.G_MISS_CHAR),
1837: NVL(suit_ind, FND_API.G_MISS_CHAR),
1838: NVL(lien_ind, FND_API.G_MISS_CHAR),
1839: NVL(judgement_ind, FND_API.G_MISS_CHAR),
1840: NVL(bankruptcy_ind, FND_API.G_MISS_CHAR),
1841: NVL(no_trade_ind, FND_API.G_MISS_CHAR),
1842: NVL(prnt_hq_bkcy_ind, FND_API.G_MISS_CHAR),
1843: NVL(num_prnt_bkcy_filing, FND_API.G_MISS_NUM),

Line 1840: NVL(bankruptcy_ind, FND_API.G_MISS_CHAR),

1836: NVL(paydex_comment, FND_API.G_MISS_CHAR),
1837: NVL(suit_ind, FND_API.G_MISS_CHAR),
1838: NVL(lien_ind, FND_API.G_MISS_CHAR),
1839: NVL(judgement_ind, FND_API.G_MISS_CHAR),
1840: NVL(bankruptcy_ind, FND_API.G_MISS_CHAR),
1841: NVL(no_trade_ind, FND_API.G_MISS_CHAR),
1842: NVL(prnt_hq_bkcy_ind, FND_API.G_MISS_CHAR),
1843: NVL(num_prnt_bkcy_filing, FND_API.G_MISS_NUM),
1844: NVL(prnt_bkcy_filg_type, FND_API.G_MISS_CHAR),

Line 1841: NVL(no_trade_ind, FND_API.G_MISS_CHAR),

1837: NVL(suit_ind, FND_API.G_MISS_CHAR),
1838: NVL(lien_ind, FND_API.G_MISS_CHAR),
1839: NVL(judgement_ind, FND_API.G_MISS_CHAR),
1840: NVL(bankruptcy_ind, FND_API.G_MISS_CHAR),
1841: NVL(no_trade_ind, FND_API.G_MISS_CHAR),
1842: NVL(prnt_hq_bkcy_ind, FND_API.G_MISS_CHAR),
1843: NVL(num_prnt_bkcy_filing, FND_API.G_MISS_NUM),
1844: NVL(prnt_bkcy_filg_type, FND_API.G_MISS_CHAR),
1845: NVL(prnt_bkcy_filg_chapter, FND_API.G_MISS_NUM),

Line 1842: NVL(prnt_hq_bkcy_ind, FND_API.G_MISS_CHAR),

1838: NVL(lien_ind, FND_API.G_MISS_CHAR),
1839: NVL(judgement_ind, FND_API.G_MISS_CHAR),
1840: NVL(bankruptcy_ind, FND_API.G_MISS_CHAR),
1841: NVL(no_trade_ind, FND_API.G_MISS_CHAR),
1842: NVL(prnt_hq_bkcy_ind, FND_API.G_MISS_CHAR),
1843: NVL(num_prnt_bkcy_filing, FND_API.G_MISS_NUM),
1844: NVL(prnt_bkcy_filg_type, FND_API.G_MISS_CHAR),
1845: NVL(prnt_bkcy_filg_chapter, FND_API.G_MISS_NUM),
1846: NVL(prnt_bkcy_filg_date, FND_API.G_MISS_DATE),

Line 1843: NVL(num_prnt_bkcy_filing, FND_API.G_MISS_NUM),

1839: NVL(judgement_ind, FND_API.G_MISS_CHAR),
1840: NVL(bankruptcy_ind, FND_API.G_MISS_CHAR),
1841: NVL(no_trade_ind, FND_API.G_MISS_CHAR),
1842: NVL(prnt_hq_bkcy_ind, FND_API.G_MISS_CHAR),
1843: NVL(num_prnt_bkcy_filing, FND_API.G_MISS_NUM),
1844: NVL(prnt_bkcy_filg_type, FND_API.G_MISS_CHAR),
1845: NVL(prnt_bkcy_filg_chapter, FND_API.G_MISS_NUM),
1846: NVL(prnt_bkcy_filg_date, FND_API.G_MISS_DATE),
1847: NVL(num_prnt_bkcy_convs, FND_API.G_MISS_NUM),

Line 1844: NVL(prnt_bkcy_filg_type, FND_API.G_MISS_CHAR),

1840: NVL(bankruptcy_ind, FND_API.G_MISS_CHAR),
1841: NVL(no_trade_ind, FND_API.G_MISS_CHAR),
1842: NVL(prnt_hq_bkcy_ind, FND_API.G_MISS_CHAR),
1843: NVL(num_prnt_bkcy_filing, FND_API.G_MISS_NUM),
1844: NVL(prnt_bkcy_filg_type, FND_API.G_MISS_CHAR),
1845: NVL(prnt_bkcy_filg_chapter, FND_API.G_MISS_NUM),
1846: NVL(prnt_bkcy_filg_date, FND_API.G_MISS_DATE),
1847: NVL(num_prnt_bkcy_convs, FND_API.G_MISS_NUM),
1848: NVL(prnt_bkcy_conv_date, FND_API.G_MISS_DATE),

Line 1845: NVL(prnt_bkcy_filg_chapter, FND_API.G_MISS_NUM),

1841: NVL(no_trade_ind, FND_API.G_MISS_CHAR),
1842: NVL(prnt_hq_bkcy_ind, FND_API.G_MISS_CHAR),
1843: NVL(num_prnt_bkcy_filing, FND_API.G_MISS_NUM),
1844: NVL(prnt_bkcy_filg_type, FND_API.G_MISS_CHAR),
1845: NVL(prnt_bkcy_filg_chapter, FND_API.G_MISS_NUM),
1846: NVL(prnt_bkcy_filg_date, FND_API.G_MISS_DATE),
1847: NVL(num_prnt_bkcy_convs, FND_API.G_MISS_NUM),
1848: NVL(prnt_bkcy_conv_date, FND_API.G_MISS_DATE),
1849: NVL(prnt_bkcy_chapter_conv, FND_API.G_MISS_CHAR),

Line 1846: NVL(prnt_bkcy_filg_date, FND_API.G_MISS_DATE),

1842: NVL(prnt_hq_bkcy_ind, FND_API.G_MISS_CHAR),
1843: NVL(num_prnt_bkcy_filing, FND_API.G_MISS_NUM),
1844: NVL(prnt_bkcy_filg_type, FND_API.G_MISS_CHAR),
1845: NVL(prnt_bkcy_filg_chapter, FND_API.G_MISS_NUM),
1846: NVL(prnt_bkcy_filg_date, FND_API.G_MISS_DATE),
1847: NVL(num_prnt_bkcy_convs, FND_API.G_MISS_NUM),
1848: NVL(prnt_bkcy_conv_date, FND_API.G_MISS_DATE),
1849: NVL(prnt_bkcy_chapter_conv, FND_API.G_MISS_CHAR),
1850: NVL(slow_trade_expl, FND_API.G_MISS_CHAR),

Line 1847: NVL(num_prnt_bkcy_convs, FND_API.G_MISS_NUM),

1843: NVL(num_prnt_bkcy_filing, FND_API.G_MISS_NUM),
1844: NVL(prnt_bkcy_filg_type, FND_API.G_MISS_CHAR),
1845: NVL(prnt_bkcy_filg_chapter, FND_API.G_MISS_NUM),
1846: NVL(prnt_bkcy_filg_date, FND_API.G_MISS_DATE),
1847: NVL(num_prnt_bkcy_convs, FND_API.G_MISS_NUM),
1848: NVL(prnt_bkcy_conv_date, FND_API.G_MISS_DATE),
1849: NVL(prnt_bkcy_chapter_conv, FND_API.G_MISS_CHAR),
1850: NVL(slow_trade_expl, FND_API.G_MISS_CHAR),
1851: NVL(negv_pmt_expl, FND_API.G_MISS_CHAR),

Line 1848: NVL(prnt_bkcy_conv_date, FND_API.G_MISS_DATE),

1844: NVL(prnt_bkcy_filg_type, FND_API.G_MISS_CHAR),
1845: NVL(prnt_bkcy_filg_chapter, FND_API.G_MISS_NUM),
1846: NVL(prnt_bkcy_filg_date, FND_API.G_MISS_DATE),
1847: NVL(num_prnt_bkcy_convs, FND_API.G_MISS_NUM),
1848: NVL(prnt_bkcy_conv_date, FND_API.G_MISS_DATE),
1849: NVL(prnt_bkcy_chapter_conv, FND_API.G_MISS_CHAR),
1850: NVL(slow_trade_expl, FND_API.G_MISS_CHAR),
1851: NVL(negv_pmt_expl, FND_API.G_MISS_CHAR),
1852: NVL(pub_rec_expl, FND_API.G_MISS_CHAR),

Line 1849: NVL(prnt_bkcy_chapter_conv, FND_API.G_MISS_CHAR),

1845: NVL(prnt_bkcy_filg_chapter, FND_API.G_MISS_NUM),
1846: NVL(prnt_bkcy_filg_date, FND_API.G_MISS_DATE),
1847: NVL(num_prnt_bkcy_convs, FND_API.G_MISS_NUM),
1848: NVL(prnt_bkcy_conv_date, FND_API.G_MISS_DATE),
1849: NVL(prnt_bkcy_chapter_conv, FND_API.G_MISS_CHAR),
1850: NVL(slow_trade_expl, FND_API.G_MISS_CHAR),
1851: NVL(negv_pmt_expl, FND_API.G_MISS_CHAR),
1852: NVL(pub_rec_expl, FND_API.G_MISS_CHAR),
1853: NVL(business_discontinued, FND_API.G_MISS_CHAR),

Line 1850: NVL(slow_trade_expl, FND_API.G_MISS_CHAR),

1846: NVL(prnt_bkcy_filg_date, FND_API.G_MISS_DATE),
1847: NVL(num_prnt_bkcy_convs, FND_API.G_MISS_NUM),
1848: NVL(prnt_bkcy_conv_date, FND_API.G_MISS_DATE),
1849: NVL(prnt_bkcy_chapter_conv, FND_API.G_MISS_CHAR),
1850: NVL(slow_trade_expl, FND_API.G_MISS_CHAR),
1851: NVL(negv_pmt_expl, FND_API.G_MISS_CHAR),
1852: NVL(pub_rec_expl, FND_API.G_MISS_CHAR),
1853: NVL(business_discontinued, FND_API.G_MISS_CHAR),
1854: NVL(spcl_event_comment, FND_API.G_MISS_CHAR),

Line 1851: NVL(negv_pmt_expl, FND_API.G_MISS_CHAR),

1847: NVL(num_prnt_bkcy_convs, FND_API.G_MISS_NUM),
1848: NVL(prnt_bkcy_conv_date, FND_API.G_MISS_DATE),
1849: NVL(prnt_bkcy_chapter_conv, FND_API.G_MISS_CHAR),
1850: NVL(slow_trade_expl, FND_API.G_MISS_CHAR),
1851: NVL(negv_pmt_expl, FND_API.G_MISS_CHAR),
1852: NVL(pub_rec_expl, FND_API.G_MISS_CHAR),
1853: NVL(business_discontinued, FND_API.G_MISS_CHAR),
1854: NVL(spcl_event_comment, FND_API.G_MISS_CHAR),
1855: NVL(num_spcl_event, FND_API.G_MISS_NUM),

Line 1852: NVL(pub_rec_expl, FND_API.G_MISS_CHAR),

1848: NVL(prnt_bkcy_conv_date, FND_API.G_MISS_DATE),
1849: NVL(prnt_bkcy_chapter_conv, FND_API.G_MISS_CHAR),
1850: NVL(slow_trade_expl, FND_API.G_MISS_CHAR),
1851: NVL(negv_pmt_expl, FND_API.G_MISS_CHAR),
1852: NVL(pub_rec_expl, FND_API.G_MISS_CHAR),
1853: NVL(business_discontinued, FND_API.G_MISS_CHAR),
1854: NVL(spcl_event_comment, FND_API.G_MISS_CHAR),
1855: NVL(num_spcl_event, FND_API.G_MISS_NUM),
1856: NVL(spcl_event_update_date, FND_API.G_MISS_DATE),

Line 1853: NVL(business_discontinued, FND_API.G_MISS_CHAR),

1849: NVL(prnt_bkcy_chapter_conv, FND_API.G_MISS_CHAR),
1850: NVL(slow_trade_expl, FND_API.G_MISS_CHAR),
1851: NVL(negv_pmt_expl, FND_API.G_MISS_CHAR),
1852: NVL(pub_rec_expl, FND_API.G_MISS_CHAR),
1853: NVL(business_discontinued, FND_API.G_MISS_CHAR),
1854: NVL(spcl_event_comment, FND_API.G_MISS_CHAR),
1855: NVL(num_spcl_event, FND_API.G_MISS_NUM),
1856: NVL(spcl_event_update_date, FND_API.G_MISS_DATE),
1857: NVL(spcl_evnt_txt, FND_API.G_MISS_CHAR),

Line 1854: NVL(spcl_event_comment, FND_API.G_MISS_CHAR),

1850: NVL(slow_trade_expl, FND_API.G_MISS_CHAR),
1851: NVL(negv_pmt_expl, FND_API.G_MISS_CHAR),
1852: NVL(pub_rec_expl, FND_API.G_MISS_CHAR),
1853: NVL(business_discontinued, FND_API.G_MISS_CHAR),
1854: NVL(spcl_event_comment, FND_API.G_MISS_CHAR),
1855: NVL(num_spcl_event, FND_API.G_MISS_NUM),
1856: NVL(spcl_event_update_date, FND_API.G_MISS_DATE),
1857: NVL(spcl_evnt_txt, FND_API.G_MISS_CHAR),
1858: NVL(failure_score, FND_API.G_MISS_CHAR),

Line 1855: NVL(num_spcl_event, FND_API.G_MISS_NUM),

1851: NVL(negv_pmt_expl, FND_API.G_MISS_CHAR),
1852: NVL(pub_rec_expl, FND_API.G_MISS_CHAR),
1853: NVL(business_discontinued, FND_API.G_MISS_CHAR),
1854: NVL(spcl_event_comment, FND_API.G_MISS_CHAR),
1855: NVL(num_spcl_event, FND_API.G_MISS_NUM),
1856: NVL(spcl_event_update_date, FND_API.G_MISS_DATE),
1857: NVL(spcl_evnt_txt, FND_API.G_MISS_CHAR),
1858: NVL(failure_score, FND_API.G_MISS_CHAR),
1859: NVL(failure_score_age, FND_API.G_MISS_NUM),

Line 1856: NVL(spcl_event_update_date, FND_API.G_MISS_DATE),

1852: NVL(pub_rec_expl, FND_API.G_MISS_CHAR),
1853: NVL(business_discontinued, FND_API.G_MISS_CHAR),
1854: NVL(spcl_event_comment, FND_API.G_MISS_CHAR),
1855: NVL(num_spcl_event, FND_API.G_MISS_NUM),
1856: NVL(spcl_event_update_date, FND_API.G_MISS_DATE),
1857: NVL(spcl_evnt_txt, FND_API.G_MISS_CHAR),
1858: NVL(failure_score, FND_API.G_MISS_CHAR),
1859: NVL(failure_score_age, FND_API.G_MISS_NUM),
1860: NVL(failure_score_class, FND_API.G_MISS_NUM),

Line 1857: NVL(spcl_evnt_txt, FND_API.G_MISS_CHAR),

1853: NVL(business_discontinued, FND_API.G_MISS_CHAR),
1854: NVL(spcl_event_comment, FND_API.G_MISS_CHAR),
1855: NVL(num_spcl_event, FND_API.G_MISS_NUM),
1856: NVL(spcl_event_update_date, FND_API.G_MISS_DATE),
1857: NVL(spcl_evnt_txt, FND_API.G_MISS_CHAR),
1858: NVL(failure_score, FND_API.G_MISS_CHAR),
1859: NVL(failure_score_age, FND_API.G_MISS_NUM),
1860: NVL(failure_score_class, FND_API.G_MISS_NUM),
1861: NVL(failure_score_commentary, FND_API.G_MISS_CHAR),

Line 1858: NVL(failure_score, FND_API.G_MISS_CHAR),

1854: NVL(spcl_event_comment, FND_API.G_MISS_CHAR),
1855: NVL(num_spcl_event, FND_API.G_MISS_NUM),
1856: NVL(spcl_event_update_date, FND_API.G_MISS_DATE),
1857: NVL(spcl_evnt_txt, FND_API.G_MISS_CHAR),
1858: NVL(failure_score, FND_API.G_MISS_CHAR),
1859: NVL(failure_score_age, FND_API.G_MISS_NUM),
1860: NVL(failure_score_class, FND_API.G_MISS_NUM),
1861: NVL(failure_score_commentary, FND_API.G_MISS_CHAR),
1862: NVL(failure_score_commentary2, FND_API.G_MISS_CHAR),

Line 1859: NVL(failure_score_age, FND_API.G_MISS_NUM),

1855: NVL(num_spcl_event, FND_API.G_MISS_NUM),
1856: NVL(spcl_event_update_date, FND_API.G_MISS_DATE),
1857: NVL(spcl_evnt_txt, FND_API.G_MISS_CHAR),
1858: NVL(failure_score, FND_API.G_MISS_CHAR),
1859: NVL(failure_score_age, FND_API.G_MISS_NUM),
1860: NVL(failure_score_class, FND_API.G_MISS_NUM),
1861: NVL(failure_score_commentary, FND_API.G_MISS_CHAR),
1862: NVL(failure_score_commentary2, FND_API.G_MISS_CHAR),
1863: NVL(failure_score_commentary3, FND_API.G_MISS_CHAR),

Line 1860: NVL(failure_score_class, FND_API.G_MISS_NUM),

1856: NVL(spcl_event_update_date, FND_API.G_MISS_DATE),
1857: NVL(spcl_evnt_txt, FND_API.G_MISS_CHAR),
1858: NVL(failure_score, FND_API.G_MISS_CHAR),
1859: NVL(failure_score_age, FND_API.G_MISS_NUM),
1860: NVL(failure_score_class, FND_API.G_MISS_NUM),
1861: NVL(failure_score_commentary, FND_API.G_MISS_CHAR),
1862: NVL(failure_score_commentary2, FND_API.G_MISS_CHAR),
1863: NVL(failure_score_commentary3, FND_API.G_MISS_CHAR),
1864: NVL(failure_score_commentary4, FND_API.G_MISS_CHAR),

Line 1861: NVL(failure_score_commentary, FND_API.G_MISS_CHAR),

1857: NVL(spcl_evnt_txt, FND_API.G_MISS_CHAR),
1858: NVL(failure_score, FND_API.G_MISS_CHAR),
1859: NVL(failure_score_age, FND_API.G_MISS_NUM),
1860: NVL(failure_score_class, FND_API.G_MISS_NUM),
1861: NVL(failure_score_commentary, FND_API.G_MISS_CHAR),
1862: NVL(failure_score_commentary2, FND_API.G_MISS_CHAR),
1863: NVL(failure_score_commentary3, FND_API.G_MISS_CHAR),
1864: NVL(failure_score_commentary4, FND_API.G_MISS_CHAR),
1865: NVL(failure_score_commentary5, FND_API.G_MISS_CHAR),

Line 1862: NVL(failure_score_commentary2, FND_API.G_MISS_CHAR),

1858: NVL(failure_score, FND_API.G_MISS_CHAR),
1859: NVL(failure_score_age, FND_API.G_MISS_NUM),
1860: NVL(failure_score_class, FND_API.G_MISS_NUM),
1861: NVL(failure_score_commentary, FND_API.G_MISS_CHAR),
1862: NVL(failure_score_commentary2, FND_API.G_MISS_CHAR),
1863: NVL(failure_score_commentary3, FND_API.G_MISS_CHAR),
1864: NVL(failure_score_commentary4, FND_API.G_MISS_CHAR),
1865: NVL(failure_score_commentary5, FND_API.G_MISS_CHAR),
1866: NVL(failure_score_commentary6, FND_API.G_MISS_CHAR),

Line 1863: NVL(failure_score_commentary3, FND_API.G_MISS_CHAR),

1859: NVL(failure_score_age, FND_API.G_MISS_NUM),
1860: NVL(failure_score_class, FND_API.G_MISS_NUM),
1861: NVL(failure_score_commentary, FND_API.G_MISS_CHAR),
1862: NVL(failure_score_commentary2, FND_API.G_MISS_CHAR),
1863: NVL(failure_score_commentary3, FND_API.G_MISS_CHAR),
1864: NVL(failure_score_commentary4, FND_API.G_MISS_CHAR),
1865: NVL(failure_score_commentary5, FND_API.G_MISS_CHAR),
1866: NVL(failure_score_commentary6, FND_API.G_MISS_CHAR),
1867: NVL(failure_score_commentary7, FND_API.G_MISS_CHAR),

Line 1864: NVL(failure_score_commentary4, FND_API.G_MISS_CHAR),

1860: NVL(failure_score_class, FND_API.G_MISS_NUM),
1861: NVL(failure_score_commentary, FND_API.G_MISS_CHAR),
1862: NVL(failure_score_commentary2, FND_API.G_MISS_CHAR),
1863: NVL(failure_score_commentary3, FND_API.G_MISS_CHAR),
1864: NVL(failure_score_commentary4, FND_API.G_MISS_CHAR),
1865: NVL(failure_score_commentary5, FND_API.G_MISS_CHAR),
1866: NVL(failure_score_commentary6, FND_API.G_MISS_CHAR),
1867: NVL(failure_score_commentary7, FND_API.G_MISS_CHAR),
1868: NVL(failure_score_commentary8, FND_API.G_MISS_CHAR),

Line 1865: NVL(failure_score_commentary5, FND_API.G_MISS_CHAR),

1861: NVL(failure_score_commentary, FND_API.G_MISS_CHAR),
1862: NVL(failure_score_commentary2, FND_API.G_MISS_CHAR),
1863: NVL(failure_score_commentary3, FND_API.G_MISS_CHAR),
1864: NVL(failure_score_commentary4, FND_API.G_MISS_CHAR),
1865: NVL(failure_score_commentary5, FND_API.G_MISS_CHAR),
1866: NVL(failure_score_commentary6, FND_API.G_MISS_CHAR),
1867: NVL(failure_score_commentary7, FND_API.G_MISS_CHAR),
1868: NVL(failure_score_commentary8, FND_API.G_MISS_CHAR),
1869: NVL(failure_score_commentary9, FND_API.G_MISS_CHAR),

Line 1866: NVL(failure_score_commentary6, FND_API.G_MISS_CHAR),

1862: NVL(failure_score_commentary2, FND_API.G_MISS_CHAR),
1863: NVL(failure_score_commentary3, FND_API.G_MISS_CHAR),
1864: NVL(failure_score_commentary4, FND_API.G_MISS_CHAR),
1865: NVL(failure_score_commentary5, FND_API.G_MISS_CHAR),
1866: NVL(failure_score_commentary6, FND_API.G_MISS_CHAR),
1867: NVL(failure_score_commentary7, FND_API.G_MISS_CHAR),
1868: NVL(failure_score_commentary8, FND_API.G_MISS_CHAR),
1869: NVL(failure_score_commentary9, FND_API.G_MISS_CHAR),
1870: NVL(failure_score_commentary10, FND_API.G_MISS_CHAR),

Line 1867: NVL(failure_score_commentary7, FND_API.G_MISS_CHAR),

1863: NVL(failure_score_commentary3, FND_API.G_MISS_CHAR),
1864: NVL(failure_score_commentary4, FND_API.G_MISS_CHAR),
1865: NVL(failure_score_commentary5, FND_API.G_MISS_CHAR),
1866: NVL(failure_score_commentary6, FND_API.G_MISS_CHAR),
1867: NVL(failure_score_commentary7, FND_API.G_MISS_CHAR),
1868: NVL(failure_score_commentary8, FND_API.G_MISS_CHAR),
1869: NVL(failure_score_commentary9, FND_API.G_MISS_CHAR),
1870: NVL(failure_score_commentary10, FND_API.G_MISS_CHAR),
1871: NVL(failure_score_date, FND_API.G_MISS_DATE),

Line 1868: NVL(failure_score_commentary8, FND_API.G_MISS_CHAR),

1864: NVL(failure_score_commentary4, FND_API.G_MISS_CHAR),
1865: NVL(failure_score_commentary5, FND_API.G_MISS_CHAR),
1866: NVL(failure_score_commentary6, FND_API.G_MISS_CHAR),
1867: NVL(failure_score_commentary7, FND_API.G_MISS_CHAR),
1868: NVL(failure_score_commentary8, FND_API.G_MISS_CHAR),
1869: NVL(failure_score_commentary9, FND_API.G_MISS_CHAR),
1870: NVL(failure_score_commentary10, FND_API.G_MISS_CHAR),
1871: NVL(failure_score_date, FND_API.G_MISS_DATE),
1872: NVL(failure_score_incd_default, FND_API.G_MISS_NUM),

Line 1869: NVL(failure_score_commentary9, FND_API.G_MISS_CHAR),

1865: NVL(failure_score_commentary5, FND_API.G_MISS_CHAR),
1866: NVL(failure_score_commentary6, FND_API.G_MISS_CHAR),
1867: NVL(failure_score_commentary7, FND_API.G_MISS_CHAR),
1868: NVL(failure_score_commentary8, FND_API.G_MISS_CHAR),
1869: NVL(failure_score_commentary9, FND_API.G_MISS_CHAR),
1870: NVL(failure_score_commentary10, FND_API.G_MISS_CHAR),
1871: NVL(failure_score_date, FND_API.G_MISS_DATE),
1872: NVL(failure_score_incd_default, FND_API.G_MISS_NUM),
1873: NVL(failure_score_natnl_percentile, FND_API.G_MISS_NUM),

Line 1870: NVL(failure_score_commentary10, FND_API.G_MISS_CHAR),

1866: NVL(failure_score_commentary6, FND_API.G_MISS_CHAR),
1867: NVL(failure_score_commentary7, FND_API.G_MISS_CHAR),
1868: NVL(failure_score_commentary8, FND_API.G_MISS_CHAR),
1869: NVL(failure_score_commentary9, FND_API.G_MISS_CHAR),
1870: NVL(failure_score_commentary10, FND_API.G_MISS_CHAR),
1871: NVL(failure_score_date, FND_API.G_MISS_DATE),
1872: NVL(failure_score_incd_default, FND_API.G_MISS_NUM),
1873: NVL(failure_score_natnl_percentile, FND_API.G_MISS_NUM),
1874: NVL(failure_score_override_code, FND_API.G_MISS_CHAR),

Line 1871: NVL(failure_score_date, FND_API.G_MISS_DATE),

1867: NVL(failure_score_commentary7, FND_API.G_MISS_CHAR),
1868: NVL(failure_score_commentary8, FND_API.G_MISS_CHAR),
1869: NVL(failure_score_commentary9, FND_API.G_MISS_CHAR),
1870: NVL(failure_score_commentary10, FND_API.G_MISS_CHAR),
1871: NVL(failure_score_date, FND_API.G_MISS_DATE),
1872: NVL(failure_score_incd_default, FND_API.G_MISS_NUM),
1873: NVL(failure_score_natnl_percentile, FND_API.G_MISS_NUM),
1874: NVL(failure_score_override_code, FND_API.G_MISS_CHAR),
1875: NVL(global_failure_score, FND_API.G_MISS_CHAR),

Line 1872: NVL(failure_score_incd_default, FND_API.G_MISS_NUM),

1868: NVL(failure_score_commentary8, FND_API.G_MISS_CHAR),
1869: NVL(failure_score_commentary9, FND_API.G_MISS_CHAR),
1870: NVL(failure_score_commentary10, FND_API.G_MISS_CHAR),
1871: NVL(failure_score_date, FND_API.G_MISS_DATE),
1872: NVL(failure_score_incd_default, FND_API.G_MISS_NUM),
1873: NVL(failure_score_natnl_percentile, FND_API.G_MISS_NUM),
1874: NVL(failure_score_override_code, FND_API.G_MISS_CHAR),
1875: NVL(global_failure_score, FND_API.G_MISS_CHAR),
1876: NVL(actual_content_source, FND_API.G_MISS_CHAR)

Line 1873: NVL(failure_score_natnl_percentile, FND_API.G_MISS_NUM),

1869: NVL(failure_score_commentary9, FND_API.G_MISS_CHAR),
1870: NVL(failure_score_commentary10, FND_API.G_MISS_CHAR),
1871: NVL(failure_score_date, FND_API.G_MISS_DATE),
1872: NVL(failure_score_incd_default, FND_API.G_MISS_NUM),
1873: NVL(failure_score_natnl_percentile, FND_API.G_MISS_NUM),
1874: NVL(failure_score_override_code, FND_API.G_MISS_CHAR),
1875: NVL(global_failure_score, FND_API.G_MISS_CHAR),
1876: NVL(actual_content_source, FND_API.G_MISS_CHAR)
1877: INTO

Line 1874: NVL(failure_score_override_code, FND_API.G_MISS_CHAR),

1870: NVL(failure_score_commentary10, FND_API.G_MISS_CHAR),
1871: NVL(failure_score_date, FND_API.G_MISS_DATE),
1872: NVL(failure_score_incd_default, FND_API.G_MISS_NUM),
1873: NVL(failure_score_natnl_percentile, FND_API.G_MISS_NUM),
1874: NVL(failure_score_override_code, FND_API.G_MISS_CHAR),
1875: NVL(global_failure_score, FND_API.G_MISS_CHAR),
1876: NVL(actual_content_source, FND_API.G_MISS_CHAR)
1877: INTO
1878: x_credit_rating_id,

Line 1875: NVL(global_failure_score, FND_API.G_MISS_CHAR),

1871: NVL(failure_score_date, FND_API.G_MISS_DATE),
1872: NVL(failure_score_incd_default, FND_API.G_MISS_NUM),
1873: NVL(failure_score_natnl_percentile, FND_API.G_MISS_NUM),
1874: NVL(failure_score_override_code, FND_API.G_MISS_CHAR),
1875: NVL(global_failure_score, FND_API.G_MISS_CHAR),
1876: NVL(actual_content_source, FND_API.G_MISS_CHAR)
1877: INTO
1878: x_credit_rating_id,
1879: x_description,

Line 1876: NVL(actual_content_source, FND_API.G_MISS_CHAR)

1872: NVL(failure_score_incd_default, FND_API.G_MISS_NUM),
1873: NVL(failure_score_natnl_percentile, FND_API.G_MISS_NUM),
1874: NVL(failure_score_override_code, FND_API.G_MISS_CHAR),
1875: NVL(global_failure_score, FND_API.G_MISS_CHAR),
1876: NVL(actual_content_source, FND_API.G_MISS_CHAR)
1877: INTO
1878: x_credit_rating_id,
1879: x_description,
1880: x_party_id,

Line 1983: RAISE FND_API.G_EXC_ERROR;

1979: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1980: FND_MESSAGE.SET_TOKEN('RECORD', 'credit_rating_rec');
1981: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_credit_rating_id));
1982: FND_MSG_PUB.ADD;
1983: RAISE FND_API.G_EXC_ERROR;
1984:
1985: END Select_Row;
1986:
1987: PROCEDURE Delete_Row (