APPS.HZ_PARTY_INFO_PUB dependencies on HZ_CREDIT_RATINGS

Line 126: p_entity_name => 'HZ_CREDIT_RATINGS',

122: * SSM SST Integration and Extension
123: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
124:
125: HZ_MIXNM_UTILITY.LoadDataSources(
126: p_entity_name => 'HZ_CREDIT_RATINGS',
127: p_entity_attr_id => g_cre_entity_attr_id,
128: p_mixnmatch_enabled => g_cre_mixnmatch_enabled,
129: p_selected_datasources => g_cre_selected_datasources );
130:

Line 134: p_entity_name => 'HZ_CREDIT_RATINGS',

130:
131: -- END IF;
132:
133: HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation (
134: p_entity_name => 'HZ_CREDIT_RATINGS',
135: p_entity_attr_id => g_cre_entity_attr_id,
136: p_mixnmatch_enabled => g_cre_mixnmatch_enabled,
137: p_selected_datasources => g_cre_selected_datasources,
138: p_content_source_type => l_credit_ratings_rec.content_source_type,

Line 318: p_entity_name => 'HZ_CREDIT_RATINGS',

314: * There is no need to check if the data-source is selected.
315:
316: -- IF g_cre_mixnmatch_enabled IS NULL THEN
317: HZ_MIXNM_UTILITY.LoadDataSources(
318: p_entity_name => 'HZ_CREDIT_RATINGS',
319: p_entity_attr_id => g_cre_entity_attr_id,
320: p_mixnmatch_enabled => g_cre_mixnmatch_enabled,
321: p_selected_datasources => g_cre_selected_datasources );
322: -- END IF;

Line 826: SELECT hz_credit_ratings_s.nextval

822: l_credit_rating_id = FND_API.G_MISS_NUM
823: THEN
824: l_count := 1;
825: WHILE l_count > 0 LOOP
826: SELECT hz_credit_ratings_s.nextval
827: INTO l_credit_rating_id FROM dual;
828:
829: SELECT count(*)
830: INTO l_count

Line 831: FROM hz_credit_ratings

827: INTO l_credit_rating_id FROM dual;
828:
829: SELECT count(*)
830: INTO l_count
831: FROM hz_credit_ratings
832: WHERE credit_rating_id = l_credit_rating_id;
833: END LOOP;
834: ELSE
835: l_count := 0;

Line 839: FROM hz_credit_ratings

835: l_count := 0;
836:
837: SELECT count(*)
838: INTO l_count
839: FROM hz_credit_ratings
840: WHERE credit_rating_id = l_credit_rating_id;
841:
842: IF l_count > 0 THEN
843: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

Line 881: HZ_CREDIT_RATINGS_PKG.INSERT_ROW(

877:
878: p_credit_ratings_rec.credit_rating_id := l_credit_rating_id;
879: /*
880: -- call table handler to insert a row
881: HZ_CREDIT_RATINGS_PKG.INSERT_ROW(
882: x_rowid => l_rowid,
883: x_credit_rating_id => p_credit_ratings_rec.credit_rating_id,
884: x_description => p_credit_ratings_rec.description,
885: x_party_id => p_credit_ratings_rec.party_id,

Line 1085: FROM HZ_CREDIT_RATINGS

1081: -- Bug 2197181: selecting actual_content_source for mix-n-match project.
1082:
1083: SELECT rowid, last_update_date
1084: INTO l_rowid, l_last_update_date
1085: FROM HZ_CREDIT_RATINGS
1086: WHERE credit_rating_id = p_credit_ratings_rec.credit_rating_id
1087: AND to_char(last_update_date, 'DD-MON-YYYY HH:MI:SS') =
1088: to_char(p_last_update_date, 'DD-MON-YYYY HH:MI:SS')
1089: FOR UPDATE NOWAIT;

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

1090:
1091: EXCEPTION
1092: WHEN NO_DATA_FOUND THEN
1093: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1094: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CREDIT_RATINGS');
1095: FND_MSG_PUB.ADD;
1096: RAISE FND_API.G_EXC_ERROR;
1097: END;
1098:

Line 1160: HZ_CREDIT_RATINGS_PKG.UPDATE_ROW(

1156: -- handler. Need to update p_credit_ratings_rec first.
1157: NULL;
1158: /*
1159: -- call table handler to update a row
1160: HZ_CREDIT_RATINGS_PKG.UPDATE_ROW(
1161: x_rowid => l_rowid,
1162: x_credit_rating_id => p_credit_ratings_rec.credit_rating_id,
1163: x_description => p_credit_ratings_rec.description,
1164: x_party_id => p_credit_ratings_rec.party_id,

Line 1770: FROM hz_credit_ratings

1766: x_credit_ratings_rec.spcl_event_update_date,
1767: x_credit_ratings_rec.spcl_evnt_txt,
1768: x_credit_ratings_rec.actual_content_source
1769:
1770: FROM hz_credit_ratings
1771: WHERE credit_rating_id = p_credit_rating_id;
1772:
1773: EXCEPTION
1774: WHEN NO_DATA_FOUND THEN