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_PARTY_INFO_V2PUB dependencies on HZ_CREDIT_RATINGS

Line 135: FROM HZ_CREDIT_RATINGS

131: p_credit_rating_rec.credit_rating_id <> FND_API.G_MISS_NUM
132: THEN
133: BEGIN
134: SELECT 'Y' INTO l_dummy
135: FROM HZ_CREDIT_RATINGS
136: WHERE CREDIT_RATING_ID = p_credit_rating_rec.credit_rating_id;
137:
138: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
139: FND_MESSAGE.SET_TOKEN('COLUMN', 'credit_rating_id');

Line 161: HZ_CREDIT_RATINGS_PKG.Insert_Row (

157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: -- call table handler to insert a row
161: HZ_CREDIT_RATINGS_PKG.Insert_Row (
162: x_rowid => l_rowid,
163: x_credit_rating_id => p_credit_rating_rec.credit_rating_id,
164: x_description => p_credit_rating_rec.description,
165: x_party_id => p_credit_rating_rec.party_id,

Line 305: l_description HZ_CREDIT_RATINGS.description%TYPE;

301:
302: l_rowid ROWID := NULL;
303: l_object_version_number NUMBER;
304: l_party_id NUMBER;
305: l_description HZ_CREDIT_RATINGS.description%TYPE;
306: l_rating HZ_CREDIT_RATINGS.rating%TYPE;
307: l_rated_as_of_date HZ_CREDIT_RATINGS.rated_as_of_date%TYPE;
308: l_rating_organization HZ_CREDIT_RATINGS.rating_organization%TYPE;
309: -- Bug 4693719 : Added for local assignment

Line 306: l_rating HZ_CREDIT_RATINGS.rating%TYPE;

302: l_rowid ROWID := NULL;
303: l_object_version_number NUMBER;
304: l_party_id NUMBER;
305: l_description HZ_CREDIT_RATINGS.description%TYPE;
306: l_rating HZ_CREDIT_RATINGS.rating%TYPE;
307: l_rated_as_of_date HZ_CREDIT_RATINGS.rated_as_of_date%TYPE;
308: l_rating_organization HZ_CREDIT_RATINGS.rating_organization%TYPE;
309: -- Bug 4693719 : Added for local assignment
310: db_actual_content_source HZ_CREDIT_RATINGS.actual_content_source%TYPE;

Line 307: l_rated_as_of_date HZ_CREDIT_RATINGS.rated_as_of_date%TYPE;

303: l_object_version_number NUMBER;
304: l_party_id NUMBER;
305: l_description HZ_CREDIT_RATINGS.description%TYPE;
306: l_rating HZ_CREDIT_RATINGS.rating%TYPE;
307: l_rated_as_of_date HZ_CREDIT_RATINGS.rated_as_of_date%TYPE;
308: l_rating_organization HZ_CREDIT_RATINGS.rating_organization%TYPE;
309: -- Bug 4693719 : Added for local assignment
310: db_actual_content_source HZ_CREDIT_RATINGS.actual_content_source%TYPE;
311: l_acs HZ_CREDIT_RATINGS.actual_content_source%TYPE;

Line 308: l_rating_organization HZ_CREDIT_RATINGS.rating_organization%TYPE;

304: l_party_id NUMBER;
305: l_description HZ_CREDIT_RATINGS.description%TYPE;
306: l_rating HZ_CREDIT_RATINGS.rating%TYPE;
307: l_rated_as_of_date HZ_CREDIT_RATINGS.rated_as_of_date%TYPE;
308: l_rating_organization HZ_CREDIT_RATINGS.rating_organization%TYPE;
309: -- Bug 4693719 : Added for local assignment
310: db_actual_content_source HZ_CREDIT_RATINGS.actual_content_source%TYPE;
311: l_acs HZ_CREDIT_RATINGS.actual_content_source%TYPE;
312:

Line 310: db_actual_content_source HZ_CREDIT_RATINGS.actual_content_source%TYPE;

306: l_rating HZ_CREDIT_RATINGS.rating%TYPE;
307: l_rated_as_of_date HZ_CREDIT_RATINGS.rated_as_of_date%TYPE;
308: l_rating_organization HZ_CREDIT_RATINGS.rating_organization%TYPE;
309: -- Bug 4693719 : Added for local assignment
310: db_actual_content_source HZ_CREDIT_RATINGS.actual_content_source%TYPE;
311: l_acs HZ_CREDIT_RATINGS.actual_content_source%TYPE;
312:
313:
314: BEGIN

Line 311: l_acs HZ_CREDIT_RATINGS.actual_content_source%TYPE;

307: l_rated_as_of_date HZ_CREDIT_RATINGS.rated_as_of_date%TYPE;
308: l_rating_organization HZ_CREDIT_RATINGS.rating_organization%TYPE;
309: -- Bug 4693719 : Added for local assignment
310: db_actual_content_source HZ_CREDIT_RATINGS.actual_content_source%TYPE;
311: l_acs HZ_CREDIT_RATINGS.actual_content_source%TYPE;
312:
313:
314: BEGIN
315:

Line 323: FROM HZ_CREDIT_RATINGS

319: SELECT rowid, object_version_number, party_id,
320: description, rating, rated_as_of_date, rating_organization
321: INTO l_rowid, l_object_version_number, l_party_id,
322: l_description, l_rating, l_rated_as_of_date, l_rating_organization
323: FROM HZ_CREDIT_RATINGS
324: WHERE credit_rating_id = p_credit_rating_rec.credit_rating_id
325: FOR UPDATE NOWAIT;
326:
327: IF NOT

Line 338: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CREDIT_RATINGS');

334: )
335: )
336: THEN
337: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
338: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CREDIT_RATINGS');
339: FND_MSG_PUB.ADD;
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;
342:

Line 348: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CREDIT_RATINGS');

344:
345: EXCEPTION
346: WHEN NO_DATA_FOUND THEN
347: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
348: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CREDIT_RATINGS');
349: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_credit_rating_rec.credit_rating_id ), 'null' ) );
350: FND_MSG_PUB.ADD;
351: RAISE FND_API.G_EXC_ERROR;
352: END;

Line 373: HZ_CREDIT_RATINGS_PKG.Update_Row (

369: l_acs := NULL;
370: END IF;
371:
372: -- call table handler to update a row
373: HZ_CREDIT_RATINGS_PKG.Update_Row (
374: x_rowid => l_rowid,
375: x_credit_rating_id => p_credit_rating_rec.credit_rating_id,
376: x_description => p_credit_rating_rec.description,
377: x_party_id => p_credit_rating_rec.party_id,

Line 547: p_entity_name => 'HZ_CREDIT_RATINGS',

543:
544:
545: -- Bug 4222898
546: HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation (
547: p_entity_name => 'HZ_CREDIT_RATINGS',
548: p_entity_attr_id => dummy_entity_attr_id,
549: p_mixnmatch_enabled => NULL,
550: p_selected_datasources => NULL,
551: p_content_source_type => dummy_content_source_type,

Line 573: HZ_POPULATE_BOT_PKG.pop_hz_credit_ratings(

569: END IF;
570:
571: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
572: -- populate function for integration service
573: HZ_POPULATE_BOT_PKG.pop_hz_credit_ratings(
574: p_operation => 'I',
575: p_credit_rating_id => x_credit_rating_id);
576: END IF;
577: END IF;

Line 705: HZ_POPULATE_BOT_PKG.pop_hz_credit_ratings(

701: END IF;
702:
703: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
704: -- populate function for integration service
705: HZ_POPULATE_BOT_PKG.pop_hz_credit_ratings(
706: p_operation => 'U',
707: p_credit_rating_id => l_credit_rating_rec.credit_rating_id);
708: END IF;
709: END IF;

Line 758: * HZ_CREDIT_RATINGS_PKG.Select_Row

754: * DESCRIPTION
755: * Gets credit rating record.
756: *
757: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
758: * HZ_CREDIT_RATINGS_PKG.Select_Row
759: *
760: * ARGUMENTS
761: * IN:
762: * p_init_msg_list Initialize message stack if it is set to

Line 816: HZ_CREDIT_RATINGS_PKG.Select_Row (

812:
813: -- The x_credit_rating_rec.credit_rating_id must be initiated to p_credit_rating_id
814: x_credit_rating_rec.credit_rating_id := p_credit_rating_id;
815:
816: HZ_CREDIT_RATINGS_PKG.Select_Row (
817: x_credit_rating_id => x_credit_rating_rec.credit_rating_id,
818: x_description => x_credit_rating_rec.description,
819: x_party_id => x_credit_rating_rec.party_id,
820: x_rating => x_credit_rating_rec.rating,