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 17316: * handled by the unique index HZ_CREDIT_RATINGS_U2.

17312: * 03-14-2003 Sreedhar Mohan Bug 2843453, modified such that, fincl_embt_ind should
17313: * be validated against YES/NO instead of REGISTRY_STATUS
17314: * 10-09-2003 Rajib R Borah o Bug 3090928.Commented the code to check for uniqueness of
17315: * party_id,rated_as_of_date,rating_organization. This is now
17316: * handled by the unique index HZ_CREDIT_RATINGS_U2.
17317: * 04-05-2004 Rajib R Borah o Bug 3181460. Credit_score_natl_percentile and
17318: * failure_score_natnl_percentile should have a value
17319: * within 0 to 100 only.
17320: * o Added local variables l_credit_score_natl_percentile and

Line 17339: FROM hz_credit_ratings hcr

17335: ) IS
17336:
17337: CURSOR c_dup_credit_rating_id (p_credting_rating_id IN NUMBER) IS
17338: SELECT 'Y'
17339: FROM hz_credit_ratings hcr
17340: WHERE hcr.credit_rating_id = p_credting_rating_id;
17341:
17342: CURSOR c_unique_credit_rating_rec ( p_party_id IN NUMBER,
17343: p_rated_as_of_date IN DATE,

Line 17347: FROM hz_credit_ratings hc

17343: p_rated_as_of_date IN DATE,
17344: p_rating_organization IN VARCHAR2,
17345: p_actual_content_source IN VARCHAR2) IS
17346: SELECT 'Y'
17347: FROM hz_credit_ratings hc
17348: WHERE hc.party_id = p_party_id
17349: AND trunc(nvl(hc.rated_as_of_date, to_date('12/31/4712','MM/DD/YYYY'))) =
17350: trunc(nvl(p_rated_as_of_date, to_date('12/31/4712','MM/DD/YYYY')))
17351: AND nvl(hc.rating_organization, 'XXX') = nvl(p_rating_organization, 'XXX')

Line 17355: l_credit_rating_id hz_credit_ratings.credit_rating_id%TYPE;

17351: AND nvl(hc.rating_organization, 'XXX') = nvl(p_rating_organization, 'XXX')
17352: AND nvl(hc.actual_content_source, hz_party_v2pub.G_MISS_CONTENT_SOURCE_TYPE) =
17353: nvl(p_actual_content_source, hz_party_v2pub.G_MISS_CONTENT_SOURCE_TYPE);
17354:
17355: l_credit_rating_id hz_credit_ratings.credit_rating_id%TYPE;
17356: l_party_id hz_credit_ratings.party_id%TYPE;
17357: l_rating_organization hz_credit_ratings.rating_organization%TYPE;
17358: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;
17359: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;

Line 17356: l_party_id hz_credit_ratings.party_id%TYPE;

17352: AND nvl(hc.actual_content_source, hz_party_v2pub.G_MISS_CONTENT_SOURCE_TYPE) =
17353: nvl(p_actual_content_source, hz_party_v2pub.G_MISS_CONTENT_SOURCE_TYPE);
17354:
17355: l_credit_rating_id hz_credit_ratings.credit_rating_id%TYPE;
17356: l_party_id hz_credit_ratings.party_id%TYPE;
17357: l_rating_organization hz_credit_ratings.rating_organization%TYPE;
17358: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;
17359: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;
17360: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;

Line 17357: l_rating_organization hz_credit_ratings.rating_organization%TYPE;

17353: nvl(p_actual_content_source, hz_party_v2pub.G_MISS_CONTENT_SOURCE_TYPE);
17354:
17355: l_credit_rating_id hz_credit_ratings.credit_rating_id%TYPE;
17356: l_party_id hz_credit_ratings.party_id%TYPE;
17357: l_rating_organization hz_credit_ratings.rating_organization%TYPE;
17358: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;
17359: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;
17360: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;
17361: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;

Line 17358: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;

17354:
17355: l_credit_rating_id hz_credit_ratings.credit_rating_id%TYPE;
17356: l_party_id hz_credit_ratings.party_id%TYPE;
17357: l_rating_organization hz_credit_ratings.rating_organization%TYPE;
17358: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;
17359: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;
17360: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;
17361: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;
17362: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;

Line 17359: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;

17355: l_credit_rating_id hz_credit_ratings.credit_rating_id%TYPE;
17356: l_party_id hz_credit_ratings.party_id%TYPE;
17357: l_rating_organization hz_credit_ratings.rating_organization%TYPE;
17358: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;
17359: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;
17360: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;
17361: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;
17362: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;
17363: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;

Line 17360: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;

17356: l_party_id hz_credit_ratings.party_id%TYPE;
17357: l_rating_organization hz_credit_ratings.rating_organization%TYPE;
17358: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;
17359: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;
17360: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;
17361: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;
17362: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;
17363: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;
17364: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;

Line 17361: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;

17357: l_rating_organization hz_credit_ratings.rating_organization%TYPE;
17358: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;
17359: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;
17360: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;
17361: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;
17362: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;
17363: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;
17364: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;
17365: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;

Line 17362: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;

17358: l_rated_as_of_date hz_credit_ratings.rated_as_of_date%TYPE;
17359: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;
17360: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;
17361: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;
17362: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;
17363: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;
17364: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;
17365: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;
17366: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;

Line 17363: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;

17359: l_fincl_embt_ind hz_credit_ratings.fincl_embt_ind%TYPE;
17360: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;
17361: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;
17362: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;
17363: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;
17364: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;
17365: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;
17366: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;
17367: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;

Line 17364: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;

17360: l_credit_score_commentary hz_credit_ratings.credit_score_commentary%TYPE;
17361: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;
17362: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;
17363: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;
17364: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;
17365: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;
17366: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;
17367: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;
17368: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;

Line 17365: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;

17361: l_credit_score_commentary2 hz_credit_ratings.credit_score_commentary2%TYPE;
17362: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;
17363: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;
17364: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;
17365: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;
17366: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;
17367: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;
17368: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;
17369: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;

Line 17366: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;

17362: l_credit_score_commentary3 hz_credit_ratings.credit_score_commentary3%TYPE;
17363: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;
17364: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;
17365: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;
17366: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;
17367: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;
17368: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;
17369: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;
17370: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;

Line 17367: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;

17363: l_credit_score_commentary4 hz_credit_ratings.credit_score_commentary4%TYPE;
17364: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;
17365: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;
17366: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;
17367: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;
17368: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;
17369: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;
17370: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;
17371: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;

Line 17368: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;

17364: l_credit_score_commentary5 hz_credit_ratings.credit_score_commentary5%TYPE;
17365: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;
17366: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;
17367: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;
17368: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;
17369: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;
17370: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;
17371: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;
17372: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;

Line 17369: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;

17365: l_credit_score_commentary6 hz_credit_ratings.credit_score_commentary6%TYPE;
17366: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;
17367: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;
17368: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;
17369: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;
17370: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;
17371: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;
17372: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;
17373: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;

Line 17370: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;

17366: l_credit_score_commentary7 hz_credit_ratings.credit_score_commentary7%TYPE;
17367: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;
17368: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;
17369: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;
17370: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;
17371: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;
17372: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;
17373: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;
17374: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;

Line 17371: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;

17367: l_credit_score_commentary8 hz_credit_ratings.credit_score_commentary8%TYPE;
17368: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;
17369: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;
17370: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;
17371: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;
17372: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;
17373: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;
17374: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;
17375: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;

Line 17372: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;

17368: l_credit_score_commentary9 hz_credit_ratings.credit_score_commentary9%TYPE;
17369: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;
17370: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;
17371: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;
17372: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;
17373: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;
17374: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;
17375: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;
17376: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;

Line 17373: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;

17369: l_credit_score_commentary10 hz_credit_ratings.credit_score_commentary10%TYPE;
17370: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;
17371: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;
17372: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;
17373: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;
17374: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;
17375: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;
17376: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;
17377: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;

Line 17374: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;

17370: l_failure_score_commentary hz_credit_ratings.failure_score_commentary%TYPE;
17371: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;
17372: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;
17373: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;
17374: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;
17375: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;
17376: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;
17377: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;
17378: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;

Line 17375: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;

17371: l_failure_score_commentary2 hz_credit_ratings.failure_score_commentary2%TYPE;
17372: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;
17373: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;
17374: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;
17375: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;
17376: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;
17377: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;
17378: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;
17379: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;

Line 17376: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;

17372: l_failure_score_commentary3 hz_credit_ratings.failure_score_commentary3%TYPE;
17373: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;
17374: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;
17375: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;
17376: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;
17377: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;
17378: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;
17379: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;
17380: l_status hz_credit_ratings.status%TYPE;

Line 17377: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;

17373: l_failure_score_commentary4 hz_credit_ratings.failure_score_commentary4%TYPE;
17374: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;
17375: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;
17376: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;
17377: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;
17378: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;
17379: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;
17380: l_status hz_credit_ratings.status%TYPE;
17381: l_created_by_module hz_credit_ratings.created_by_module%TYPE;

Line 17378: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;

17374: l_failure_score_commentary5 hz_credit_ratings.failure_score_commentary5%TYPE;
17375: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;
17376: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;
17377: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;
17378: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;
17379: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;
17380: l_status hz_credit_ratings.status%TYPE;
17381: l_created_by_module hz_credit_ratings.created_by_module%TYPE;
17382: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;

Line 17379: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;

17375: l_failure_score_commentary6 hz_credit_ratings.failure_score_commentary6%TYPE;
17376: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;
17377: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;
17378: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;
17379: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;
17380: l_status hz_credit_ratings.status%TYPE;
17381: l_created_by_module hz_credit_ratings.created_by_module%TYPE;
17382: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;
17383: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;

Line 17380: l_status hz_credit_ratings.status%TYPE;

17376: l_failure_score_commentary7 hz_credit_ratings.failure_score_commentary7%TYPE;
17377: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;
17378: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;
17379: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;
17380: l_status hz_credit_ratings.status%TYPE;
17381: l_created_by_module hz_credit_ratings.created_by_module%TYPE;
17382: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;
17383: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
17384: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;

Line 17381: l_created_by_module hz_credit_ratings.created_by_module%TYPE;

17377: l_failure_score_commentary8 hz_credit_ratings.failure_score_commentary8%TYPE;
17378: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;
17379: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;
17380: l_status hz_credit_ratings.status%TYPE;
17381: l_created_by_module hz_credit_ratings.created_by_module%TYPE;
17382: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;
17383: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
17384: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
17385: l_suit_ind hz_credit_ratings.suit_ind%TYPE;

Line 17382: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;

17378: l_failure_score_commentary9 hz_credit_ratings.failure_score_commentary9%TYPE;
17379: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;
17380: l_status hz_credit_ratings.status%TYPE;
17381: l_created_by_module hz_credit_ratings.created_by_module%TYPE;
17382: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;
17383: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
17384: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
17385: l_suit_ind hz_credit_ratings.suit_ind%TYPE;
17386: l_lien_ind hz_credit_ratings.lien_ind%TYPE;

Line 17383: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;

17379: l_failure_score_commentary10 hz_credit_ratings.failure_score_commentary10%TYPE;
17380: l_status hz_credit_ratings.status%TYPE;
17381: l_created_by_module hz_credit_ratings.created_by_module%TYPE;
17382: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;
17383: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
17384: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
17385: l_suit_ind hz_credit_ratings.suit_ind%TYPE;
17386: l_lien_ind hz_credit_ratings.lien_ind%TYPE;
17387: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;

Line 17384: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;

17380: l_status hz_credit_ratings.status%TYPE;
17381: l_created_by_module hz_credit_ratings.created_by_module%TYPE;
17382: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;
17383: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
17384: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
17385: l_suit_ind hz_credit_ratings.suit_ind%TYPE;
17386: l_lien_ind hz_credit_ratings.lien_ind%TYPE;
17387: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;
17388: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;

Line 17385: l_suit_ind hz_credit_ratings.suit_ind%TYPE;

17381: l_created_by_module hz_credit_ratings.created_by_module%TYPE;
17382: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;
17383: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
17384: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
17385: l_suit_ind hz_credit_ratings.suit_ind%TYPE;
17386: l_lien_ind hz_credit_ratings.lien_ind%TYPE;
17387: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;
17388: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;
17389: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;

Line 17386: l_lien_ind hz_credit_ratings.lien_ind%TYPE;

17382: l_debarment_ind hz_credit_ratings.debarment_ind%TYPE;
17383: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
17384: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
17385: l_suit_ind hz_credit_ratings.suit_ind%TYPE;
17386: l_lien_ind hz_credit_ratings.lien_ind%TYPE;
17387: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;
17388: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;
17389: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;
17390: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;

Line 17387: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;

17383: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
17384: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
17385: l_suit_ind hz_credit_ratings.suit_ind%TYPE;
17386: l_lien_ind hz_credit_ratings.lien_ind%TYPE;
17387: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;
17388: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;
17389: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;
17390: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;
17391: l_actual_content_source hz_credit_ratings.actual_content_source%TYPE;

Line 17388: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;

17384: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
17385: l_suit_ind hz_credit_ratings.suit_ind%TYPE;
17386: l_lien_ind hz_credit_ratings.lien_ind%TYPE;
17387: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;
17388: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;
17389: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;
17390: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;
17391: l_actual_content_source hz_credit_ratings.actual_content_source%TYPE;
17392: l_credit_score_natl_percentile hz_credit_ratings.credit_score_natl_percentile%TYPE;

Line 17389: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;

17385: l_suit_ind hz_credit_ratings.suit_ind%TYPE;
17386: l_lien_ind hz_credit_ratings.lien_ind%TYPE;
17387: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;
17388: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;
17389: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;
17390: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;
17391: l_actual_content_source hz_credit_ratings.actual_content_source%TYPE;
17392: l_credit_score_natl_percentile hz_credit_ratings.credit_score_natl_percentile%TYPE;
17393: l_fail_score_natnl_percentile hz_credit_ratings.failure_score_natnl_percentile%TYPE;

Line 17390: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;

17386: l_lien_ind hz_credit_ratings.lien_ind%TYPE;
17387: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;
17388: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;
17389: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;
17390: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;
17391: l_actual_content_source hz_credit_ratings.actual_content_source%TYPE;
17392: l_credit_score_natl_percentile hz_credit_ratings.credit_score_natl_percentile%TYPE;
17393: l_fail_score_natnl_percentile hz_credit_ratings.failure_score_natnl_percentile%TYPE;
17394: l_dummy VARCHAR2(1);

Line 17391: l_actual_content_source hz_credit_ratings.actual_content_source%TYPE;

17387: l_judgement_ind hz_credit_ratings.judgement_ind%TYPE;
17388: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;
17389: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;
17390: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;
17391: l_actual_content_source hz_credit_ratings.actual_content_source%TYPE;
17392: l_credit_score_natl_percentile hz_credit_ratings.credit_score_natl_percentile%TYPE;
17393: l_fail_score_natnl_percentile hz_credit_ratings.failure_score_natnl_percentile%TYPE;
17394: l_dummy VARCHAR2(1);
17395: l_debug_prefix VARCHAR2(30) := '';

Line 17392: l_credit_score_natl_percentile hz_credit_ratings.credit_score_natl_percentile%TYPE;

17388: l_bankruptcy_ind hz_credit_ratings.bankruptcy_ind%TYPE;
17389: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;
17390: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;
17391: l_actual_content_source hz_credit_ratings.actual_content_source%TYPE;
17392: l_credit_score_natl_percentile hz_credit_ratings.credit_score_natl_percentile%TYPE;
17393: l_fail_score_natnl_percentile hz_credit_ratings.failure_score_natnl_percentile%TYPE;
17394: l_dummy VARCHAR2(1);
17395: l_debug_prefix VARCHAR2(30) := '';
17396:

Line 17393: l_fail_score_natnl_percentile hz_credit_ratings.failure_score_natnl_percentile%TYPE;

17389: l_no_trade_ind hz_credit_ratings.no_trade_ind%TYPE;
17390: l_prnt_hq_bkcy_ind hz_credit_ratings.prnt_hq_bkcy_ind%TYPE;
17391: l_actual_content_source hz_credit_ratings.actual_content_source%TYPE;
17392: l_credit_score_natl_percentile hz_credit_ratings.credit_score_natl_percentile%TYPE;
17393: l_fail_score_natnl_percentile hz_credit_ratings.failure_score_natnl_percentile%TYPE;
17394: l_dummy VARCHAR2(1);
17395: l_debug_prefix VARCHAR2(30) := '';
17396:
17397: BEGIN

Line 17492: FROM HZ_CREDIT_RATINGS

17488: l_status,
17489: l_created_by_module,
17490: l_credit_score_natl_percentile,
17491: l_fail_score_natnl_percentile
17492: FROM HZ_CREDIT_RATINGS
17493: WHERE ROWID = p_rowid;
17494: END IF;
17495:
17496: -------------------------------------

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

17652: END IF;
17653: END IF;
17654:
17655: /**********************************************************************************
17656: Bug Number 3090928:Removed the validation below and used the unique index HZ_CREDIT_RATINGS_U2
17657: on table HZ_CREDIT_RATINGS to check for uniqueness.Now this check is done by handling the
17658: exception DUP_VAL_ON_INDEX for the unique index HZ_CREDIT_RATINGS_U2 in the procedure
17659: HZ_CREDIT_RATINGS_PKG.Insert_Row.
17660: ***********************************************************************************

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

17653: END IF;
17654:
17655: /**********************************************************************************
17656: Bug Number 3090928:Removed the validation below and used the unique index HZ_CREDIT_RATINGS_U2
17657: on table HZ_CREDIT_RATINGS to check for uniqueness.Now this check is done by handling the
17658: exception DUP_VAL_ON_INDEX for the unique index HZ_CREDIT_RATINGS_U2 in the procedure
17659: HZ_CREDIT_RATINGS_PKG.Insert_Row.
17660: ***********************************************************************************
17661: |---------------------------------------

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

17654:
17655: /**********************************************************************************
17656: Bug Number 3090928:Removed the validation below and used the unique index HZ_CREDIT_RATINGS_U2
17657: on table HZ_CREDIT_RATINGS to check for uniqueness.Now this check is done by handling the
17658: exception DUP_VAL_ON_INDEX for the unique index HZ_CREDIT_RATINGS_U2 in the procedure
17659: HZ_CREDIT_RATINGS_PKG.Insert_Row.
17660: ***********************************************************************************
17661: |---------------------------------------
17662: |--Bug 2869178: Unique record Validation

Line 17659: HZ_CREDIT_RATINGS_PKG.Insert_Row.

17655: /**********************************************************************************
17656: Bug Number 3090928:Removed the validation below and used the unique index HZ_CREDIT_RATINGS_U2
17657: on table HZ_CREDIT_RATINGS to check for uniqueness.Now this check is done by handling the
17658: exception DUP_VAL_ON_INDEX for the unique index HZ_CREDIT_RATINGS_U2 in the procedure
17659: HZ_CREDIT_RATINGS_PKG.Insert_Row.
17660: ***********************************************************************************
17661: |---------------------------------------
17662: |--Bug 2869178: Unique record Validation
17663: |---------------------------------------

Line 18602: p_entity_name => 'HZ_CREDIT_RATINGS',

18598: p_content_source_type => 'USER_ENTERED',
18599: p_old_content_source_type => 'USER_ENTERED',
18600: p_actual_content_source => p_credit_rating_rec.actual_content_source,
18601: p_old_actual_content_source => l_actual_content_source,
18602: p_entity_name => 'HZ_CREDIT_RATINGS',
18603: x_return_status => x_return_status );
18604:
18605: -- Debug info.
18606: /*IF g_debug THEN