APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_PARTY_SITE_USES

Line 4035: HZ_PARTY_SITE_USES_PKG.Select_Row (

4031: END IF;
4032:
4033: x_party_site_use_rec.party_site_use_id := p_party_site_use_id;
4034:
4035: HZ_PARTY_SITE_USES_PKG.Select_Row (
4036: X_PARTY_SITE_USE_ID => x_party_site_use_rec.party_site_use_id,
4037: X_COMMENTS => x_party_site_use_rec.comments,
4038: X_PARTY_SITE_ID => x_party_site_use_rec.party_site_id,
4039: X_SITE_USE_TYPE => x_party_site_use_rec.site_use_type,

Line 4087: | unmark the primary_per_type in hz_party_site_uses

4083: | PROCEDURE
4084: | do_unmark_primary_per_type
4085: |
4086: | DESCRIPTION
4087: | unmark the primary_per_type in hz_party_site_uses
4088: | for those site uses that are not primary for
4089: | each party.
4090: |
4091: | SCOPE - PRIVATE

Line 4119: FROM HZ_PARTY_SITE_USES SU

4115: ) IS
4116:
4117: CURSOR c_party_site_uses IS
4118: SELECT ROWID
4119: FROM HZ_PARTY_SITE_USES SU
4120: WHERE SU.PARTY_SITE_ID IN (
4121: SELECT PS.PARTY_SITE_ID
4122: FROM HZ_PARTY_SITES PS
4123: WHERE PARTY_ID = p_party_id )

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

4141: CLOSE c_party_site_uses;
4142: EXCEPTION
4143: WHEN OTHERS THEN
4144: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
4145: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
4146: FND_MSG_PUB.ADD;
4147: RAISE FND_API.G_EXC_ERROR;
4148: END;
4149:

Line 4151: UPDATE HZ_PARTY_SITE_USES

4147: RAISE FND_API.G_EXC_ERROR;
4148: END;
4149:
4150: IF l_rowid IS NOT NULL THEN
4151: UPDATE HZ_PARTY_SITE_USES
4152: SET PRIMARY_PER_TYPE = 'N',
4153: last_update_date = hz_utility_v2pub.last_update_date,
4154: last_updated_by = hz_utility_v2pub.last_updated_by,
4155: last_update_login = hz_utility_v2pub.last_update_login,

Line 4225: FROM HZ_PARTY_SITE_USES SU

4221: l_primary_per_type := 'N';
4222: BEGIN
4223: SELECT 'Y'
4224: INTO l_exist
4225: FROM HZ_PARTY_SITE_USES SU
4226: WHERE PARTY_SITE_ID IN (
4227: SELECT PARTY_SITE_ID
4228: FROM HZ_PARTY_SITES PS
4229: WHERE PS.PARTY_ID = l_party_id )

Line 4242: HZ_PARTY_SITE_USES_PKG.Insert_Row (

4238: END;
4239: p_party_site_use_rec.primary_per_type := l_primary_per_type;
4240: END IF;
4241: -- call table-handler.
4242: HZ_PARTY_SITE_USES_PKG.Insert_Row (
4243: X_PARTY_SITE_USE_ID => p_party_site_use_rec.party_site_use_id,
4244: X_COMMENTS => p_party_site_use_rec.comments,
4245: X_PARTY_SITE_ID => p_party_site_use_rec.party_site_id,
4246: X_SITE_USE_TYPE => p_party_site_use_rec.site_use_type,