APPS.HZ_PARTY_INFO_VAL dependencies on HZ_CREDIT_RATINGS

Line 110: | hz_credit_ratings.content_source_type

106: |
107: | MODIFICATION HISTORY
108: | YKONG 26-OCT-1999 Created
109: | 02-AUG-2000 Jianying Huang Fixed Bug 1363124: Validation#2
110: | hz_credit_ratings.content_source_type
111: |
112: | 19-Feb-2002 DNB V3 enhancement base bug 2188696
113: | check obsoleted column suit_judge_ind
114: | validate colums migrated from hz_organization_profiles

Line 146: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;

142: l_judgement_ind VARCHAR2(1);
143: l_bankruptcy_ind VARCHAR2(1);
144: l_no_trade_ind VARCHAR2(1);
145: l_prnt_hq_bkcy_ind VARCHAR2(1);
146: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
147: l_debarment_ind VARCHAR2(1);
148: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
149:
150: db_content_source_type hz_credit_ratings.content_source_type%TYPE;

Line 148: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;

144: l_no_trade_ind VARCHAR2(1);
145: l_prnt_hq_bkcy_ind VARCHAR2(1);
146: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
147: l_debarment_ind VARCHAR2(1);
148: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
149:
150: db_content_source_type hz_credit_ratings.content_source_type%TYPE;
151:
152: -- Bug 2197181: added for mix-n-match

Line 150: db_content_source_type hz_credit_ratings.content_source_type%TYPE;

146: l_credit_score_override_code hz_credit_ratings.credit_score_override_code%TYPE;
147: l_debarment_ind VARCHAR2(1);
148: l_maximum_credit_currency_code hz_credit_ratings.maximum_credit_currency_code%TYPE;
149:
150: db_content_source_type hz_credit_ratings.content_source_type%TYPE;
151:
152: -- Bug 2197181: added for mix-n-match
153: db_actual_content_source hz_credit_ratings.actual_content_source%TYPE;
154: l_debug_prefix VARCHAR2(30) := '';

Line 153: db_actual_content_source hz_credit_ratings.actual_content_source%TYPE;

149:
150: db_content_source_type hz_credit_ratings.content_source_type%TYPE;
151:
152: -- Bug 2197181: added for mix-n-match
153: db_actual_content_source hz_credit_ratings.actual_content_source%TYPE;
154: l_debug_prefix VARCHAR2(30) := '';
155:
156: BEGIN
157:

Line 272: FROM hz_credit_ratings

268: l_credit_score_commentary9,
269: l_credit_score_commentary10,
270: l_maximum_credit_currency_code,
271: db_actual_content_source
272: FROM hz_credit_ratings
273: where credit_rating_id = p_credit_ratings_rec.credit_rating_id;
274:
275: IF (p_credit_ratings_rec.party_id <> FND_API.G_MISS_NUM) AND
276: (p_credit_ratings_rec.party_id <> l_party_id) THEN

Line 1278: -- Passed HZ_CREDIT_RATINGS for newly added paratemer p_entity_name

1274: ----------------------------------------
1275: -- validate content_source_type and actual_content_source_type
1276: ----------------------------------------
1277: -- SSM SST Integration and Extension
1278: -- Passed HZ_CREDIT_RATINGS for newly added paratemer p_entity_name
1279:
1280: HZ_MIXNM_UTILITY.ValidateContentSource (
1281: p_api_version => 'V1',
1282: p_create_update_flag => p_create_update_flag,

Line 1288: p_entity_name => 'HZ_CREDIT_RATINGS',

1284: p_content_source_type => p_credit_ratings_rec.content_source_type,
1285: p_old_content_source_type => db_content_source_type,
1286: p_actual_content_source => p_credit_ratings_rec.actual_content_source,
1287: p_old_actual_content_source => db_actual_content_source,
1288: p_entity_name => 'HZ_CREDIT_RATINGS',
1289: x_return_status => x_return_status );
1290:
1291: --disable_debug;
1292: