eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_CREDIT_RATINGS

Line 4627: /* obsolete column. colum migrate to hz_credit_ratings.

4623: p_msg_level=>fnd_log.level_statement);
4624: END IF;
4625: END IF;
4626:
4627: /* obsolete column. colum migrate to hz_credit_ratings.
4628: Validate in HZ_PARTY_INFO_VAL.validate_credit_ratings
4629:
4630: -------------------------
4631: -- validate debarment_ind

Line 4748: /* obsolete column. Column migrate to hz_credit_ratings.

4744: p_msg_level=>fnd_log.level_statement);
4745: END IF;
4746: END IF;
4747:
4748: /* obsolete column. Column migrate to hz_credit_ratings.
4749: Validate in HZ_PARTY_INFO_VAL.validate_credit_ratings
4750:
4751: ------------------------------------
4752: -- validate failure_score_commentary

Line 4783: -- obsolete column. Column migrate to hz_credit_ratings.

4779: p_msg_level=>fnd_log.level_statement);
4780: END IF;
4781: END IF;
4782:
4783: -- obsolete column. Column migrate to hz_credit_ratings.
4784: -- Validate in HZ_PARTY_INFO_VAL.validate_credit_ratings
4785:
4786: -----------------------------------
4787: -- validate credit_score_commentary

Line 5107: /* obsolete column. Column migrate to hz_credit_ratings.

5103: 'x_return_status = ' || x_return_status, l_debug_prefix);
5104: END IF;
5105: **/
5106:
5107: /* obsolete column. Column migrate to hz_credit_ratings.
5108: Validate in HZ_PARTY_INFO_VAL.validate_credit_ratings
5109:
5110: ------------------------------------
5111: -- validate credit_score_commentary2

Line 17336: * handled by the unique index HZ_CREDIT_RATINGS_U2.

17332: * 03-14-2003 Sreedhar Mohan Bug 2843453, modified such that, fincl_embt_ind should
17333: * be validated against YES/NO instead of REGISTRY_STATUS
17334: * 10-09-2003 Rajib R Borah o Bug 3090928.Commented the code to check for uniqueness of
17335: * party_id,rated_as_of_date,rating_organization. This is now
17336: * handled by the unique index HZ_CREDIT_RATINGS_U2.
17337: * 04-05-2004 Rajib R Borah o Bug 3181460. Credit_score_natl_percentile and
17338: * failure_score_natnl_percentile should have a value
17339: * within 0 to 100 only.
17340: * o Added local variables l_credit_score_natl_percentile and

Line 17359: FROM hz_credit_ratings hcr

17355: ) IS
17356:
17357: CURSOR c_dup_credit_rating_id (p_credting_rating_id IN NUMBER) IS
17358: SELECT 'Y'
17359: FROM hz_credit_ratings hcr
17360: WHERE hcr.credit_rating_id = p_credting_rating_id;
17361:
17362: CURSOR c_unique_credit_rating_rec ( p_party_id IN NUMBER,
17363: p_rated_as_of_date IN DATE,

Line 17367: FROM hz_credit_ratings hc

17363: p_rated_as_of_date IN DATE,
17364: p_rating_organization IN VARCHAR2,
17365: p_actual_content_source IN VARCHAR2) IS
17366: SELECT 'Y'
17367: FROM hz_credit_ratings hc
17368: WHERE hc.party_id = p_party_id
17369: AND trunc(nvl(hc.rated_as_of_date, to_date('12/31/4712','MM/DD/YYYY'))) =
17370: trunc(nvl(p_rated_as_of_date, to_date('12/31/4712','MM/DD/YYYY')))
17371: AND nvl(hc.rating_organization, 'XXX') = nvl(p_rating_organization, 'XXX')

Line 17375: l_credit_rating_id hz_credit_ratings.credit_rating_id%TYPE;

17371: AND nvl(hc.rating_organization, 'XXX') = nvl(p_rating_organization, 'XXX')
17372: AND nvl(hc.actual_content_source, hz_party_v2pub.G_MISS_CONTENT_SOURCE_TYPE) =
17373: nvl(p_actual_content_source, hz_party_v2pub.G_MISS_CONTENT_SOURCE_TYPE);
17374:
17375: l_credit_rating_id hz_credit_ratings.credit_rating_id%TYPE;
17376: l_party_id hz_credit_ratings.party_id%TYPE;
17377: l_rating_organization hz_credit_ratings.rating_organization%TYPE;
17378: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;
17379: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;

Line 17376: l_party_id hz_credit_ratings.party_id%TYPE;

17372: AND nvl(hc.actual_content_source, hz_party_v2pub.G_MISS_CONTENT_SOURCE_TYPE) =
17373: nvl(p_actual_content_source, hz_party_v2pub.G_MISS_CONTENT_SOURCE_TYPE);
17374:
17375: l_credit_rating_id hz_credit_ratings.credit_rating_id%TYPE;
17376: l_party_id hz_credit_ratings.party_id%TYPE;
17377: l_rating_organization hz_credit_ratings.rating_organization%TYPE;
17378: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;
17379: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;
17380: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;

Line 17377: l_rating_organization hz_credit_ratings.rating_organization%TYPE;

17373: nvl(p_actual_content_source, hz_party_v2pub.G_MISS_CONTENT_SOURCE_TYPE);
17374:
17375: l_credit_rating_id hz_credit_ratings.credit_rating_id%TYPE;
17376: l_party_id hz_credit_ratings.party_id%TYPE;
17377: l_rating_organization hz_credit_ratings.rating_organization%TYPE;
17378: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;
17379: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;
17380: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;
17381: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;

Line 17378: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;

17374:
17375: l_credit_rating_id hz_credit_ratings.credit_rating_id%TYPE;
17376: l_party_id hz_credit_ratings.party_id%TYPE;
17377: l_rating_organization hz_credit_ratings.rating_organization%TYPE;
17378: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;
17379: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;
17380: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;
17381: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;
17382: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;

Line 17379: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;

17375: l_credit_rating_id hz_credit_ratings.credit_rating_id%TYPE;
17376: l_party_id hz_credit_ratings.party_id%TYPE;
17377: l_rating_organization hz_credit_ratings.rating_organization%TYPE;
17378: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;
17379: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;
17380: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;
17381: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;
17382: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;
17383: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;

Line 17380: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;

17376: l_party_id hz_credit_ratings.party_id%TYPE;
17377: l_rating_organization hz_credit_ratings.rating_organization%TYPE;
17378: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;
17379: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;
17380: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;
17381: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;
17382: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;
17383: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;
17384: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;

Line 17381: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;

17377: l_rating_organization hz_credit_ratings.rating_organization%TYPE;
17378: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;
17379: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;
17380: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;
17381: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;
17382: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;
17383: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;
17384: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;
17385: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;

Line 17382: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;

17378: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;
17379: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;
17380: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;
17381: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;
17382: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;
17383: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;
17384: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;
17385: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;
17386: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;

Line 17383: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;

17379: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;
17380: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;
17381: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;
17382: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;
17383: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;
17384: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;
17385: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;
17386: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;
17387: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;

Line 17384: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;

17380: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;
17381: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;
17382: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;
17383: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;
17384: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;
17385: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;
17386: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;
17387: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;
17388: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;

Line 17385: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;

17381: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;
17382: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;
17383: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;
17384: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;
17385: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;
17386: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;
17387: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;
17388: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;
17389: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;

Line 17386: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;

17382: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;
17383: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;
17384: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;
17385: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;
17386: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;
17387: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;
17388: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;
17389: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;
17390: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;

Line 17387: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;

17383: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;
17384: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;
17385: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;
17386: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;
17387: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;
17388: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;
17389: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;
17390: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;
17391: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;

Line 17388: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;

17384: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;
17385: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;
17386: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;
17387: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;
17388: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;
17389: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;
17390: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;
17391: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;
17392: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;

Line 17389: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;

17385: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;
17386: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;
17387: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;
17388: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;
17389: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;
17390: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;
17391: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;
17392: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;
17393: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;

Line 17390: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;

17386: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;
17387: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;
17388: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;
17389: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;
17390: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;
17391: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;
17392: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;
17393: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;
17394: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;

Line 17391: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;

17387: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;
17388: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;
17389: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;
17390: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;
17391: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;
17392: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;
17393: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;
17394: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;
17395: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;

Line 17392: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;

17388: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;
17389: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;
17390: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;
17391: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;
17392: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;
17393: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;
17394: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;
17395: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;
17396: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;

Line 17393: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;

17389: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;
17390: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;
17391: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;
17392: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;
17393: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;
17394: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;
17395: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;
17396: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;
17397: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;

Line 17394: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;

17390: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;
17391: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;
17392: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;
17393: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;
17394: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;
17395: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;
17396: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;
17397: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;
17398: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;

Line 17395: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;

17391: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;
17392: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;
17393: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;
17394: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;
17395: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;
17396: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;
17397: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;
17398: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;
17399: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;

Line 17396: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;

17392: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;
17393: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;
17394: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;
17395: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;
17396: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;
17397: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;
17398: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;
17399: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;
17400: l_status hz_credit_ratings.status%TYPE;

Line 17397: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;

17393: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;
17394: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;
17395: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;
17396: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;
17397: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;
17398: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;
17399: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;
17400: l_status hz_credit_ratings.status%TYPE;
17401: l_created_by_module hz_credit_ratings.created_by_module%TYPE;

Line 17398: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;

17394: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;
17395: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;
17396: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;
17397: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;
17398: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;
17399: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;
17400: l_status hz_credit_ratings.status%TYPE;
17401: l_created_by_module hz_credit_ratings.created_by_module%TYPE;
17402: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;

Line 17399: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;

17395: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;
17396: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;
17397: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;
17398: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;
17399: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;
17400: l_status hz_credit_ratings.status%TYPE;
17401: l_created_by_module hz_credit_ratings.created_by_module%TYPE;
17402: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;
17403: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;

Line 17400: l_status hz_credit_ratings.status%TYPE;

17396: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;
17397: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;
17398: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;
17399: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;
17400: l_status hz_credit_ratings.status%TYPE;
17401: l_created_by_module hz_credit_ratings.created_by_module%TYPE;
17402: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;
17403: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
17404: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;

Line 17401: l_created_by_module hz_credit_ratings.created_by_module%TYPE;

17397: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;
17398: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;
17399: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;
17400: l_status hz_credit_ratings.status%TYPE;
17401: l_created_by_module hz_credit_ratings.created_by_module%TYPE;
17402: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;
17403: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
17404: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
17405: l_suit_ind hz_credit_ratings.suit_ind%TYPE;

Line 17402: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;

17398: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;
17399: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;
17400: l_status hz_credit_ratings.status%TYPE;
17401: l_created_by_module hz_credit_ratings.created_by_module%TYPE;
17402: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;
17403: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
17404: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
17405: l_suit_ind hz_credit_ratings.suit_ind%TYPE;
17406: l_lien_ind hz_credit_ratings.lien_ind%TYPE;

Line 17403: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;

17399: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;
17400: l_status hz_credit_ratings.status%TYPE;
17401: l_created_by_module hz_credit_ratings.created_by_module%TYPE;
17402: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;
17403: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
17404: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
17405: l_suit_ind hz_credit_ratings.suit_ind%TYPE;
17406: l_lien_ind hz_credit_ratings.lien_ind%TYPE;
17407: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;

Line 17404: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;

17400: l_status hz_credit_ratings.status%TYPE;
17401: l_created_by_module hz_credit_ratings.created_by_module%TYPE;
17402: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;
17403: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
17404: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
17405: l_suit_ind hz_credit_ratings.suit_ind%TYPE;
17406: l_lien_ind hz_credit_ratings.lien_ind%TYPE;
17407: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;
17408: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;

Line 17405: l_suit_ind hz_credit_ratings.suit_ind%TYPE;

17401: l_created_by_module hz_credit_ratings.created_by_module%TYPE;
17402: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;
17403: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
17404: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
17405: l_suit_ind hz_credit_ratings.suit_ind%TYPE;
17406: l_lien_ind hz_credit_ratings.lien_ind%TYPE;
17407: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;
17408: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;
17409: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;

Line 17406: l_lien_ind hz_credit_ratings.lien_ind%TYPE;

17402: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;
17403: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
17404: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
17405: l_suit_ind hz_credit_ratings.suit_ind%TYPE;
17406: l_lien_ind hz_credit_ratings.lien_ind%TYPE;
17407: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;
17408: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;
17409: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;
17410: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;

Line 17407: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;

17403: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
17404: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
17405: l_suit_ind hz_credit_ratings.suit_ind%TYPE;
17406: l_lien_ind hz_credit_ratings.lien_ind%TYPE;
17407: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;
17408: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;
17409: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;
17410: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;
17411: l_actual_content_source hz_credit_ratings.actual_content_source%TYPE;

Line 17408: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;

17404: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
17405: l_suit_ind hz_credit_ratings.suit_ind%TYPE;
17406: l_lien_ind hz_credit_ratings.lien_ind%TYPE;
17407: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;
17408: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;
17409: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;
17410: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;
17411: l_actual_content_source hz_credit_ratings.actual_content_source%TYPE;
17412: l_credit_score_natl_percentile hz_credit_ratings.credit_score_natl_percentile%TYPE;

Line 17409: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;

17405: l_suit_ind hz_credit_ratings.suit_ind%TYPE;
17406: l_lien_ind hz_credit_ratings.lien_ind%TYPE;
17407: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;
17408: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;
17409: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;
17410: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;
17411: l_actual_content_source hz_credit_ratings.actual_content_source%TYPE;
17412: l_credit_score_natl_percentile hz_credit_ratings.credit_score_natl_percentile%TYPE;
17413: l_fail_score_natnl_percentile hz_credit_ratings.failure_score_natnl_percentile%TYPE;

Line 17410: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;

17406: l_lien_ind hz_credit_ratings.lien_ind%TYPE;
17407: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;
17408: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;
17409: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;
17410: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;
17411: l_actual_content_source hz_credit_ratings.actual_content_source%TYPE;
17412: l_credit_score_natl_percentile hz_credit_ratings.credit_score_natl_percentile%TYPE;
17413: l_fail_score_natnl_percentile hz_credit_ratings.failure_score_natnl_percentile%TYPE;
17414: l_dummy VARCHAR2(1);

Line 17411: l_actual_content_source hz_credit_ratings.actual_content_source%TYPE;

17407: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;
17408: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;
17409: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;
17410: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;
17411: l_actual_content_source hz_credit_ratings.actual_content_source%TYPE;
17412: l_credit_score_natl_percentile hz_credit_ratings.credit_score_natl_percentile%TYPE;
17413: l_fail_score_natnl_percentile hz_credit_ratings.failure_score_natnl_percentile%TYPE;
17414: l_dummy VARCHAR2(1);
17415: l_debug_prefix VARCHAR2(30) := '';

Line 17412: l_credit_score_natl_percentile hz_credit_ratings.credit_score_natl_percentile%TYPE;

17408: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;
17409: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;
17410: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;
17411: l_actual_content_source hz_credit_ratings.actual_content_source%TYPE;
17412: l_credit_score_natl_percentile hz_credit_ratings.credit_score_natl_percentile%TYPE;
17413: l_fail_score_natnl_percentile hz_credit_ratings.failure_score_natnl_percentile%TYPE;
17414: l_dummy VARCHAR2(1);
17415: l_debug_prefix VARCHAR2(30) := '';
17416:

Line 17413: l_fail_score_natnl_percentile hz_credit_ratings.failure_score_natnl_percentile%TYPE;

17409: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;
17410: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;
17411: l_actual_content_source hz_credit_ratings.actual_content_source%TYPE;
17412: l_credit_score_natl_percentile hz_credit_ratings.credit_score_natl_percentile%TYPE;
17413: l_fail_score_natnl_percentile hz_credit_ratings.failure_score_natnl_percentile%TYPE;
17414: l_dummy VARCHAR2(1);
17415: l_debug_prefix VARCHAR2(30) := '';
17416:
17417: BEGIN

Line 17512: FROM HZ_CREDIT_RATINGS

17508: l_status,
17509: l_created_by_module,
17510: l_credit_score_natl_percentile,
17511: l_fail_score_natnl_percentile
17512: FROM HZ_CREDIT_RATINGS
17513: WHERE ROWID = p_rowid;
17514: END IF;
17515:
17516: -------------------------------------

Line 17676: Bug Number 3090928:Removed the validation below and used the unique index HZ_CREDIT_RATINGS_U2

17672: END IF;
17673: END IF;
17674:
17675: /**********************************************************************************
17676: Bug Number 3090928:Removed the validation below and used the unique index HZ_CREDIT_RATINGS_U2
17677: on table HZ_CREDIT_RATINGS to check for uniqueness.Now this check is done by handling the
17678: exception DUP_VAL_ON_INDEX for the unique index HZ_CREDIT_RATINGS_U2 in the procedure
17679: HZ_CREDIT_RATINGS_PKG.Insert_Row.
17680: ***********************************************************************************

Line 17677: on table HZ_CREDIT_RATINGS to check for uniqueness.Now this check is done by handling the

17673: END IF;
17674:
17675: /**********************************************************************************
17676: Bug Number 3090928:Removed the validation below and used the unique index HZ_CREDIT_RATINGS_U2
17677: on table HZ_CREDIT_RATINGS to check for uniqueness.Now this check is done by handling the
17678: exception DUP_VAL_ON_INDEX for the unique index HZ_CREDIT_RATINGS_U2 in the procedure
17679: HZ_CREDIT_RATINGS_PKG.Insert_Row.
17680: ***********************************************************************************
17681: |---------------------------------------

Line 17678: exception DUP_VAL_ON_INDEX for the unique index HZ_CREDIT_RATINGS_U2 in the procedure

17674:
17675: /**********************************************************************************
17676: Bug Number 3090928:Removed the validation below and used the unique index HZ_CREDIT_RATINGS_U2
17677: on table HZ_CREDIT_RATINGS to check for uniqueness.Now this check is done by handling the
17678: exception DUP_VAL_ON_INDEX for the unique index HZ_CREDIT_RATINGS_U2 in the procedure
17679: HZ_CREDIT_RATINGS_PKG.Insert_Row.
17680: ***********************************************************************************
17681: |---------------------------------------
17682: |--Bug 2869178: Unique record Validation

Line 17679: HZ_CREDIT_RATINGS_PKG.Insert_Row.

17675: /**********************************************************************************
17676: Bug Number 3090928:Removed the validation below and used the unique index HZ_CREDIT_RATINGS_U2
17677: on table HZ_CREDIT_RATINGS to check for uniqueness.Now this check is done by handling the
17678: exception DUP_VAL_ON_INDEX for the unique index HZ_CREDIT_RATINGS_U2 in the procedure
17679: HZ_CREDIT_RATINGS_PKG.Insert_Row.
17680: ***********************************************************************************
17681: |---------------------------------------
17682: |--Bug 2869178: Unique record Validation
17683: |---------------------------------------

Line 18622: p_entity_name => 'HZ_CREDIT_RATINGS',

18618: p_content_source_type => 'USER_ENTERED',
18619: p_old_content_source_type => 'USER_ENTERED',
18620: p_actual_content_source => p_credit_rating_rec.actual_content_source,
18621: p_old_actual_content_source => l_actual_content_source,
18622: p_entity_name => 'HZ_CREDIT_RATINGS',
18623: x_return_status => x_return_status );
18624:
18625: -- Debug info.
18626: /*IF g_debug THEN