APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_PARTY_SITE_USES

Line 3997: HZ_PARTY_SITE_USES_PKG.Select_Row (

3993: END IF;
3994:
3995: x_party_site_use_rec.party_site_use_id := p_party_site_use_id;
3996:
3997: HZ_PARTY_SITE_USES_PKG.Select_Row (
3998: X_PARTY_SITE_USE_ID => x_party_site_use_rec.party_site_use_id,
3999: X_COMMENTS => x_party_site_use_rec.comments,
4000: X_PARTY_SITE_ID => x_party_site_use_rec.party_site_id,
4001: X_SITE_USE_TYPE => x_party_site_use_rec.site_use_type,

Line 4049: | unmark the primary_per_type in hz_party_site_uses

4045: | PROCEDURE
4046: | do_unmark_primary_per_type
4047: |
4048: | DESCRIPTION
4049: | unmark the primary_per_type in hz_party_site_uses
4050: | for those site uses that are not primary for
4051: | each party.
4052: |
4053: | SCOPE - PRIVATE

Line 4081: FROM HZ_PARTY_SITE_USES SU

4077: ) IS
4078:
4079: CURSOR c_party_site_uses IS
4080: SELECT ROWID
4081: FROM HZ_PARTY_SITE_USES SU
4082: WHERE SU.PARTY_SITE_ID IN (
4083: SELECT PS.PARTY_SITE_ID
4084: FROM HZ_PARTY_SITES PS
4085: WHERE PARTY_ID = p_party_id )

Line 4107: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');

4103: CLOSE c_party_site_uses;
4104: EXCEPTION
4105: WHEN OTHERS THEN
4106: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
4107: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
4108: FND_MSG_PUB.ADD;
4109: RAISE FND_API.G_EXC_ERROR;
4110: END;
4111:

Line 4113: UPDATE HZ_PARTY_SITE_USES

4109: RAISE FND_API.G_EXC_ERROR;
4110: END;
4111:
4112: IF l_rowid IS NOT NULL THEN
4113: UPDATE HZ_PARTY_SITE_USES
4114: SET PRIMARY_PER_TYPE = 'N',
4115: last_update_date = hz_utility_v2pub.last_update_date,
4116: last_updated_by = hz_utility_v2pub.last_updated_by,
4117: last_update_login = hz_utility_v2pub.last_update_login,

Line 4187: FROM HZ_PARTY_SITE_USES SU

4183: l_primary_per_type := 'N';
4184: BEGIN
4185: SELECT 'Y'
4186: INTO l_exist
4187: FROM HZ_PARTY_SITE_USES SU
4188: WHERE PARTY_SITE_ID IN (
4189: SELECT PARTY_SITE_ID
4190: FROM HZ_PARTY_SITES PS
4191: WHERE PS.PARTY_ID = l_party_id )

Line 4204: HZ_PARTY_SITE_USES_PKG.Insert_Row (

4200: END;
4201: p_party_site_use_rec.primary_per_type := l_primary_per_type;
4202: END IF;
4203: -- call table-handler.
4204: HZ_PARTY_SITE_USES_PKG.Insert_Row (
4205: X_PARTY_SITE_USE_ID => p_party_site_use_rec.party_site_use_id,
4206: X_COMMENTS => p_party_site_use_rec.comments,
4207: X_PARTY_SITE_ID => p_party_site_use_rec.party_site_id,
4208: X_SITE_USE_TYPE => p_party_site_use_rec.site_use_type,