The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE do_update_cust_acct_site (
p_cust_acct_site_rec IN OUT NOCOPY CUST_ACCT_SITE_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
);
PROCEDURE do_update_cust_site_use (
p_cust_site_use_rec IN OUT NOCOPY CUST_SITE_USE_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
);
p_create_update_flag IN VARCHAR2,
p_account_site_rec IN cust_acct_site_rec_type,
p_old_account_site_rec IN cust_acct_site_rec_type DEFAULT NULL,
x_return_status IN OUT NOCOPY VARCHAR2
);
* HZ_CUST_ACCT_SITES_PKG.Insert_Row
*
* ARGUMENTS
* IN/OUT:
* p_cust_acct_site_rec Customer account site record.
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* OUT:
* x_cust_acct_site_id Customer account site ID.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Jianying Huang o Created.
*
* 24-JUN-2004 V.Ravichandran o Bug 3714636.Modified do_create_cust_acct_site() and
* to reduce cost of query
* which checks whether the message name in
* FND_NEW_MESSAGES is 'HZ_INACTIVATE_ACCOUNT_SITE_UI'.
* 02-AUG-2004 Rajib Ranjan Borah o Bug 3805019. If status is NULL and the corresponding
* status is 'A', then warning HZ_ACCT_SITE_INHERIT_STATUS
* will not be displayed.
* o Rowid and object_version_number in
* HZ_PARTY_SITES need not be read for synchronizing
* statuses.
* Removed unnecessary variables l_ps_rowid,
* l_ps_object_version_number and l_dummy.
* 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)
*/
PROCEDURE do_create_cust_acct_site (
p_cust_acct_site_rec IN OUT NOCOPY CUST_ACCT_SITE_REC_TYPE,
x_cust_acct_site_id OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_debug_prefix VARCHAR2(30) := ''; --'do_create_cust_acct_site';
select 'Y' from hz_cust_acct_sites_all
where orig_system_reference =
p_cust_acct_site_rec.orig_system_reference
and org_id = p_cust_acct_site_rec.org_id;
SELECT null
FROM hz_cust_acct_sites_all
WHERE cust_account_id = p_cust_account_id
AND org_id = p_org_id
AND status NOT IN ('M', 'D')
AND ROWNUM = 1;
SELECT credit_hold
FROM hz_customer_profiles
WHERE cust_account_id = p_cust_account_id;
SELECT 'X' into g_message_name FROM FND_NEW_MESSAGES
WHERE message_name = 'HZ_INACTIVATE_ACCOUNT_SITE_UI'
AND language_code = userenv('LANG')
AND application_id = 222
AND rownum =1;
SELECT /*ROWID, OBJECT_VERSION_NUMBER,*/status
INTO /*l_ps_rowid, l_ps_object_version_number,*/l_status
FROM HZ_PARTY_SITES
WHERE PARTY_SITE_ID = p_cust_acct_site_rec.party_site_id
FOR UPDATE NOWAIT;
p_create_update_flag => 'C',
p_cust_acct_site_rec => p_cust_acct_site_rec,
p_rowid => NULL,
x_return_status => x_return_status );
hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_CUST_ACCT_SITES_PKG.Insert_Row (
X_CUST_ACCT_SITE_ID => p_cust_acct_site_rec.cust_acct_site_id,
X_CUST_ACCOUNT_ID => p_cust_acct_site_rec.cust_account_id,
X_PARTY_SITE_ID => p_cust_acct_site_rec.party_site_id,
X_ATTRIBUTE_CATEGORY => p_cust_acct_site_rec.attribute_category,
X_ATTRIBUTE1 => p_cust_acct_site_rec.attribute1,
X_ATTRIBUTE2 => p_cust_acct_site_rec.attribute2,
X_ATTRIBUTE3 => p_cust_acct_site_rec.attribute3,
X_ATTRIBUTE4 => p_cust_acct_site_rec.attribute4,
X_ATTRIBUTE5 => p_cust_acct_site_rec.attribute5,
X_ATTRIBUTE6 => p_cust_acct_site_rec.attribute6,
X_ATTRIBUTE7 => p_cust_acct_site_rec.attribute7,
X_ATTRIBUTE8 => p_cust_acct_site_rec.attribute8,
X_ATTRIBUTE9 => p_cust_acct_site_rec.attribute9,
X_ATTRIBUTE10 => p_cust_acct_site_rec.attribute10,
X_ATTRIBUTE11 => p_cust_acct_site_rec.attribute11,
X_ATTRIBUTE12 => p_cust_acct_site_rec.attribute12,
X_ATTRIBUTE13 => p_cust_acct_site_rec.attribute13,
X_ATTRIBUTE14 => p_cust_acct_site_rec.attribute14,
X_ATTRIBUTE15 => p_cust_acct_site_rec.attribute15,
X_ATTRIBUTE16 => p_cust_acct_site_rec.attribute16,
X_ATTRIBUTE17 => p_cust_acct_site_rec.attribute17,
X_ATTRIBUTE18 => p_cust_acct_site_rec.attribute18,
X_ATTRIBUTE19 => p_cust_acct_site_rec.attribute19,
X_ATTRIBUTE20 => p_cust_acct_site_rec.attribute20,
X_GLOBAL_ATTRIBUTE_CATEGORY => p_cust_acct_site_rec.global_attribute_category,
X_GLOBAL_ATTRIBUTE1 => p_cust_acct_site_rec.global_attribute1,
X_GLOBAL_ATTRIBUTE2 => p_cust_acct_site_rec.global_attribute2,
X_GLOBAL_ATTRIBUTE3 => p_cust_acct_site_rec.global_attribute3,
X_GLOBAL_ATTRIBUTE4 => p_cust_acct_site_rec.global_attribute4,
X_GLOBAL_ATTRIBUTE5 => p_cust_acct_site_rec.global_attribute5,
X_GLOBAL_ATTRIBUTE6 => p_cust_acct_site_rec.global_attribute6,
X_GLOBAL_ATTRIBUTE7 => p_cust_acct_site_rec.global_attribute7,
X_GLOBAL_ATTRIBUTE8 => p_cust_acct_site_rec.global_attribute8,
X_GLOBAL_ATTRIBUTE9 => p_cust_acct_site_rec.global_attribute9,
X_GLOBAL_ATTRIBUTE10 => p_cust_acct_site_rec.global_attribute10,
X_GLOBAL_ATTRIBUTE11 => p_cust_acct_site_rec.global_attribute11,
X_GLOBAL_ATTRIBUTE12 => p_cust_acct_site_rec.global_attribute12,
X_GLOBAL_ATTRIBUTE13 => p_cust_acct_site_rec.global_attribute13,
X_GLOBAL_ATTRIBUTE14 => p_cust_acct_site_rec.global_attribute14,
X_GLOBAL_ATTRIBUTE15 => p_cust_acct_site_rec.global_attribute15,
X_GLOBAL_ATTRIBUTE16 => p_cust_acct_site_rec.global_attribute16,
X_GLOBAL_ATTRIBUTE17 => p_cust_acct_site_rec.global_attribute17,
X_GLOBAL_ATTRIBUTE18 => p_cust_acct_site_rec.global_attribute18,
X_GLOBAL_ATTRIBUTE19 => p_cust_acct_site_rec.global_attribute19,
X_GLOBAL_ATTRIBUTE20 => p_cust_acct_site_rec.global_attribute20,
X_ORIG_SYSTEM_REFERENCE => p_cust_acct_site_rec.orig_system_reference,
X_STATUS => p_cust_acct_site_rec.status,
X_CUSTOMER_CATEGORY_CODE => p_cust_acct_site_rec.customer_category_code,
X_LANGUAGE => p_cust_acct_site_rec.language,
X_KEY_ACCOUNT_FLAG => p_cust_acct_site_rec.key_account_flag,
X_TP_HEADER_ID => p_cust_acct_site_rec.tp_header_id,
X_ECE_TP_LOCATION_CODE => p_cust_acct_site_rec.ece_tp_location_code,
X_PRIMARY_SPECIALIST_ID => p_cust_acct_site_rec.primary_specialist_id,
X_SECONDARY_SPECIALIST_ID => p_cust_acct_site_rec.secondary_specialist_id,
X_TERRITORY_ID => p_cust_acct_site_rec.territory_id,
X_TERRITORY => p_cust_acct_site_rec.territory,
X_TRANSLATED_CUSTOMER_NAME => p_cust_acct_site_rec.translated_customer_name,
X_OBJECT_VERSION_NUMBER => 1,
X_CREATED_BY_MODULE => p_cust_acct_site_rec.created_by_module,
X_APPLICATION_ID => p_cust_acct_site_rec.application_id,
X_ORG_ID => p_cust_acct_site_rec.org_id -- Bug 3456489
);
hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Insert_Row (-) ' ||
'x_cust_acct_site_id = ' || p_cust_acct_site_rec.cust_acct_site_id,
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
SELECT LOC.LOCATION_ID INTO l_location_id
FROM HZ_LOCATIONS LOC,
HZ_PARTY_SITES PARTY_SITE,
HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489
WHERE ACCT_SITE.CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
SELECT su.site_use_id,su.cust_acct_site_id
FROM hz_cust_accounts a,
hz_cust_acct_sites_all cas,
hz_cust_site_uses_all su
WHERE a.cust_account_id = l_cust_acct_id
AND l_cust_acct_id = cas.cust_account_id
AND cas.cust_acct_site_id = su.cust_acct_site_id
AND su.site_use_code = p_site_use_code
AND su.status = 'A'
AND su.primary_flag = 'Y'
AND cas.org_id = p_org_id
AND su.org_id = p_org_id;
SELECT cust_account_id into l_cust_acct_id
FROM hz_cust_acct_sites_all -- Bug 3456489
WHERE cust_acct_site_id = p_cust_acct_site_id;
SELECT su.site_use_id,su.cust_acct_site_id
INTO l_site_use_id,l_cust_acct_site_id
FROM hz_cust_accounts a,
hz_cust_acct_sites_all cas, -- Bug 3456489
hz_cust_site_uses_all su -- Bug 3456489
WHERE a.cust_account_id = l_cust_acct_id
AND l_cust_acct_id = cas.cust_account_id
AND cas.cust_acct_site_id = su.cust_acct_site_id
AND su.site_use_code = p_site_use_code
AND su.status = 'A'
AND su.primary_flag = 'Y'
AND cas.org_id = p_org_id -- TCA SSA Uptake (Bug 3456489)
AND su.org_id = p_org_id; -- TCA SSA Uptake (Bug 3456489)
UPDATE hz_cust_site_uses_all -- Bug 3456489
SET primary_flag = 'N',
last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
last_update_date = hz_utility_pub.LAST_UPDATE_DATE
WHERE site_use_id =l_site_use_id;
UPDATE hz_cust_site_uses_all -- Bug 3456489
SET primary_flag = 'N',
last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
last_update_date = hz_utility_pub.LAST_UPDATE_DATE
WHERE site_use_id =r_site.site_use_id;
* PRIVATE PROCEDURE do_update_cust_acct_site
*
* DESCRIPTION
* Private procedure to update customer account site.
*
* EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
* HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_acct_site
* HZ_CUST_ACCT_SITES_PKG.Update_Row
*
* ARGUMENTS
* IN/OUT:
* p_cust_acct_site_rec Customer account site record.
* p_object_version_number Used for locking the being updated record.
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Jianying Huang o Created.
*
* 24-JUN-2004 V.Ravichandran o Bug 3714636.Modified do_update_cust_acct_site()
* to reduce cost of query
* which checks whether the message name in
* FND_NEW_MESSAGES is 'HZ_INACTIVATE_ACCOUNT_SITE_UI'.
* 02-AUG-2004 Rajib Ranjan Borah o Bug 3805019.party_site_id can be null during update.
* Therefore read the value of party_site_id from the
* database instead of using p_cust_acct_site_rec.party_site_id
* for synchronizing the status in HZ_PARTY_SITES.
* o Moreover the cursor does not pick rowid.
* o Removed redundant local variables l_dummy, l_ps_rowid.
* 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)
*/
PROCEDURE do_update_cust_acct_site (
p_cust_acct_site_rec IN OUT NOCOPY CUST_ACCT_SITE_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_debug_prefix VARCHAR2(30) := ''; --'do_update_cust_acct_site';
select 'Y' from hz_cust_acct_sites_all
where orig_system_reference =
p_cust_acct_site_rec.orig_system_reference
and org_id = p_cust_acct_site_rec.org_id;
hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
SELECT ROWID, OBJECT_VERSION_NUMBER,status, PARTY_SITE_ID, org_id
INTO l_rowid, l_object_version_number,l_status, l_party_site_id,
p_cust_acct_site_rec.org_id
FROM HZ_CUST_ACCT_SITES
WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
FOR UPDATE NOWAIT;
p_create_update_flag => 'U',
p_cust_acct_site_rec => p_cust_acct_site_rec,
p_rowid => l_rowid,
x_return_status => x_return_status );
SELECT 'X' into g_message_name FROM FND_NEW_MESSAGES
WHERE message_name = 'HZ_INACTIVATE_ACCOUNT_SITE_UI'
AND language_code = userenv('LANG')
AND application_id = 222
AND rownum =1;
SELECT /*ROWID,*/ OBJECT_VERSION_NUMBER
INTO /*l_ps_rowid,*/ l_ps_object_version_number
FROM HZ_PARTY_SITES
WHERE PARTY_SITE_ID = l_party_site_id /* Bug 3805019: p_cust_acct_site_rec.party_site_id */
FOR UPDATE NOWAIT;
HZ_PARTY_SITE_V2PUB.update_party_site(
p_party_site_rec => l_party_site_rec,
p_object_version_number => l_ps_object_version_number,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data) ;
hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_CUST_ACCT_SITES_PKG.Update_Row (
X_Rowid => l_rowid,
X_CUST_ACCT_SITE_ID => p_cust_acct_site_rec.cust_acct_site_id,
X_CUST_ACCOUNT_ID => p_cust_acct_site_rec.cust_account_id,
X_PARTY_SITE_ID => p_cust_acct_site_rec.party_site_id,
X_ATTRIBUTE_CATEGORY => p_cust_acct_site_rec.attribute_category,
X_ATTRIBUTE1 => p_cust_acct_site_rec.attribute1,
X_ATTRIBUTE2 => p_cust_acct_site_rec.attribute2,
X_ATTRIBUTE3 => p_cust_acct_site_rec.attribute3,
X_ATTRIBUTE4 => p_cust_acct_site_rec.attribute4,
X_ATTRIBUTE5 => p_cust_acct_site_rec.attribute5,
X_ATTRIBUTE6 => p_cust_acct_site_rec.attribute6,
X_ATTRIBUTE7 => p_cust_acct_site_rec.attribute7,
X_ATTRIBUTE8 => p_cust_acct_site_rec.attribute8,
X_ATTRIBUTE9 => p_cust_acct_site_rec.attribute9,
X_ATTRIBUTE10 => p_cust_acct_site_rec.attribute10,
X_ATTRIBUTE11 => p_cust_acct_site_rec.attribute11,
X_ATTRIBUTE12 => p_cust_acct_site_rec.attribute12,
X_ATTRIBUTE13 => p_cust_acct_site_rec.attribute13,
X_ATTRIBUTE14 => p_cust_acct_site_rec.attribute14,
X_ATTRIBUTE15 => p_cust_acct_site_rec.attribute15,
X_ATTRIBUTE16 => p_cust_acct_site_rec.attribute16,
X_ATTRIBUTE17 => p_cust_acct_site_rec.attribute17,
X_ATTRIBUTE18 => p_cust_acct_site_rec.attribute18,
X_ATTRIBUTE19 => p_cust_acct_site_rec.attribute19,
X_ATTRIBUTE20 => p_cust_acct_site_rec.attribute20,
X_GLOBAL_ATTRIBUTE_CATEGORY => p_cust_acct_site_rec.global_attribute_category,
X_GLOBAL_ATTRIBUTE1 => p_cust_acct_site_rec.global_attribute1,
X_GLOBAL_ATTRIBUTE2 => p_cust_acct_site_rec.global_attribute2,
X_GLOBAL_ATTRIBUTE3 => p_cust_acct_site_rec.global_attribute3,
X_GLOBAL_ATTRIBUTE4 => p_cust_acct_site_rec.global_attribute4,
X_GLOBAL_ATTRIBUTE5 => p_cust_acct_site_rec.global_attribute5,
X_GLOBAL_ATTRIBUTE6 => p_cust_acct_site_rec.global_attribute6,
X_GLOBAL_ATTRIBUTE7 => p_cust_acct_site_rec.global_attribute7,
X_GLOBAL_ATTRIBUTE8 => p_cust_acct_site_rec.global_attribute8,
X_GLOBAL_ATTRIBUTE9 => p_cust_acct_site_rec.global_attribute9,
X_GLOBAL_ATTRIBUTE10 => p_cust_acct_site_rec.global_attribute10,
X_GLOBAL_ATTRIBUTE11 => p_cust_acct_site_rec.global_attribute11,
X_GLOBAL_ATTRIBUTE12 => p_cust_acct_site_rec.global_attribute12,
X_GLOBAL_ATTRIBUTE13 => p_cust_acct_site_rec.global_attribute13,
X_GLOBAL_ATTRIBUTE14 => p_cust_acct_site_rec.global_attribute14,
X_GLOBAL_ATTRIBUTE15 => p_cust_acct_site_rec.global_attribute15,
X_GLOBAL_ATTRIBUTE16 => p_cust_acct_site_rec.global_attribute16,
X_GLOBAL_ATTRIBUTE17 => p_cust_acct_site_rec.global_attribute17,
X_GLOBAL_ATTRIBUTE18 => p_cust_acct_site_rec.global_attribute18,
X_GLOBAL_ATTRIBUTE19 => p_cust_acct_site_rec.global_attribute19,
X_GLOBAL_ATTRIBUTE20 => p_cust_acct_site_rec.global_attribute20,
X_ORIG_SYSTEM_REFERENCE => p_cust_acct_site_rec.orig_system_reference,
-- X_STATUS => null, /*p_cust_acct_site_rec.status (bug 3299622)*/
X_STATUS => p_cust_acct_site_rec.status,
X_CUSTOMER_CATEGORY_CODE => p_cust_acct_site_rec.customer_category_code,
X_LANGUAGE => p_cust_acct_site_rec.language,
X_KEY_ACCOUNT_FLAG => p_cust_acct_site_rec.key_account_flag,
X_TP_HEADER_ID => p_cust_acct_site_rec.tp_header_id,
X_ECE_TP_LOCATION_CODE => p_cust_acct_site_rec.ece_tp_location_code,
X_PRIMARY_SPECIALIST_ID => p_cust_acct_site_rec.primary_specialist_id,
X_SECONDARY_SPECIALIST_ID => p_cust_acct_site_rec.secondary_specialist_id,
X_TERRITORY_ID => p_cust_acct_site_rec.territory_id,
X_TERRITORY => p_cust_acct_site_rec.territory,
X_TRANSLATED_CUSTOMER_NAME => p_cust_acct_site_rec.translated_customer_name,
X_OBJECT_VERSION_NUMBER => p_object_version_number,
X_CREATED_BY_MODULE => p_cust_acct_site_rec.created_by_module,
X_APPLICATION_ID => p_cust_acct_site_rec.application_id
);
SELECT LOC.LOCATION_ID INTO l_location_id
FROM HZ_LOCATIONS LOC,
HZ_PARTY_SITES PARTY_SITE,
HZ_CUST_ACCT_SITES_ALL ACCT_SITE -- Bug 3456489
WHERE ACCT_SITE.CUST_ACCT_SITE_ID = p_cust_acct_site_rec.cust_acct_site_id
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
HZ_TAX_ASSIGNMENT_V2PUB.update_loc_assignment (
p_location_id => l_location_id,
p_created_by_module => p_cust_acct_site_rec.created_by_module,
p_application_id => p_cust_acct_site_rec.application_id,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
x_loc_id => l_loc_id
);
hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Update_Row (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
END do_update_cust_acct_site;
* HZ_CUST_SITE_USES_PKG.Insert_Row
*
* ARGUMENTS
* IN:
* p_create_profile If it is set to FND_API.G_TRUE, API create customer
* profile based on the customer profile record passed
* in.
* p_create_profile_amt If it is set to FND_API.G_TRUE, API create customer
* profile amounts by copying corresponding data
* from customer profile class amounts.
* IN/OUT:
* p_cust_site_use_rec Customer account site use record.
* p_customer_profile_rec Customer profile record. One customer account
* must have a customer profile.
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* OUT:
* x_site_use_id Customer account site use ID.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Jianying Huang o Created.
* 12-22-2003 Rajib Ranjan Borah o Bug 3322154.The status field was not considered in the
* check to find out if a party site use record is also to
* be created.
* 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)
* 26-Sep-2007 Sudhir Gokavarapu o Bug 6315081 [FORWARD PORT BUG 6132727] Modified primary site
* use existance check query for performance issues
*/
PROCEDURE do_create_cust_site_use (
p_cust_site_use_rec IN OUT NOCOPY CUST_SITE_USE_REC_TYPE,
p_customer_profile_rec IN OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
p_create_profile IN VARCHAR2 := FND_API.G_TRUE,
p_create_profile_amt IN VARCHAR2 := FND_API.G_TRUE,
x_site_use_id OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_debug_prefix VARCHAR2(30) := ''; --'do_create_cust_site_use'
SELECT hcp.cust_account_profile_id
FROM hz_customer_profiles hcp,
hz_cust_site_uses_all hcsu
WHERE hcsu.cust_acct_site_id = p_cust_site_use_rec.cust_acct_site_id
AND hcp.site_use_id = hcsu.site_use_id
AND hcsu.site_use_code IN ('DUN','STMTS');
SELECT org_id
INTO p_cust_site_use_rec.org_id
FROM HZ_CUST_ACCT_SITES_ALL
WHERE cust_acct_site_id
= p_cust_site_use_rec.cust_acct_site_id;
p_create_update_flag => 'C',
p_cust_site_use_rec => p_cust_site_use_rec,
p_rowid => NULL,
x_return_status => x_return_status );
FND_MSG_PUB.DELETE_MSG( l_message_count + 1 );
SELECT PARTY_SITE_ID INTO l_party_site_id
FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
WHERE CUST_ACCT_SITE_ID = p_cust_site_use_rec.cust_acct_site_id;
SELECT 'Y' INTO l_dummy
FROM HZ_PARTY_SITE_USES
WHERE PARTY_SITE_ID = l_party_site_id
AND SITE_USE_TYPE = p_cust_site_use_rec.site_use_code
AND STATUS = 'A'; --Bug 3322154
hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
SELECT cust_account_id into l_cust_acct_id
FROM hz_cust_acct_sites_all -- Bug 3456489
WHERE cust_acct_site_id = p_cust_site_use_rec.cust_acct_site_id;
SELECT count(*) into l_cnt
FROM hz_cust_accounts a,
hz_cust_acct_sites_all cas,
hz_cust_site_uses_all su
WHERE
a.cust_account_id = l_cust_acct_id
and a.cust_account_id = cas.cust_account_id
and cas.cust_acct_site_id = su.cust_acct_site_id
and su.site_use_code = p_cust_site_use_rec.site_use_code
and su.status = 'A'
and su.primary_flag = 'Y'
and cas.org_id = p_cust_site_use_rec.org_id -- TCA SSA Uptake (Bug 3456489)
and su.org_id = p_cust_site_use_rec.org_id; -- TCA SSA Uptake (Bug 3456489) */
SELECT count(*) into l_cnt
FROM hz_cust_acct_sites_all cas,
hz_cust_site_uses_all su
WHERE
cas.cust_account_id = l_cust_acct_id
and cas.status = 'A'
and cas.cust_acct_site_id = su.cust_acct_site_id
and su.site_use_code = p_cust_site_use_rec.site_use_code
and su.status = 'A'
and su.primary_flag = 'Y'
and cas.org_id = p_cust_site_use_rec.org_id -- TCA SSA Uptake (Bug 3456489)
and su.org_id = p_cust_site_use_rec.org_id -- TCA SSA Uptake (Bug 3456489)
and rownum <=1 ;
HZ_CUST_SITE_USES_PKG.Insert_Row (
X_SITE_USE_ID => p_cust_site_use_rec.site_use_id,
X_CUST_ACCT_SITE_ID => p_cust_site_use_rec.cust_acct_site_id,
X_SITE_USE_CODE => p_cust_site_use_rec.site_use_code,
X_PRIMARY_FLAG => p_cust_site_use_rec.primary_flag,
X_STATUS => p_cust_site_use_rec.status,
X_LOCATION => p_cust_site_use_rec.location,
X_CONTACT_ID => p_cust_site_use_rec.contact_id,
X_BILL_TO_SITE_USE_ID => p_cust_site_use_rec.bill_to_site_use_id,
X_ORIG_SYSTEM_REFERENCE => p_cust_site_use_rec.orig_system_reference,
X_SIC_CODE => p_cust_site_use_rec.sic_code,
X_PAYMENT_TERM_ID => p_cust_site_use_rec.payment_term_id,
X_GSA_INDICATOR => p_cust_site_use_rec.gsa_indicator,
X_SHIP_PARTIAL => p_cust_site_use_rec.ship_partial,
X_SHIP_VIA => p_cust_site_use_rec.ship_via,
X_FOB_POINT => p_cust_site_use_rec.fob_point,
X_ORDER_TYPE_ID => p_cust_site_use_rec.order_type_id,
X_PRICE_LIST_ID => p_cust_site_use_rec.price_list_id,
X_FREIGHT_TERM => p_cust_site_use_rec.freight_term,
X_WAREHOUSE_ID => p_cust_site_use_rec.warehouse_id,
X_TERRITORY_ID => p_cust_site_use_rec.territory_id,
X_ATTRIBUTE_CATEGORY => p_cust_site_use_rec.attribute_category,
X_ATTRIBUTE1 => p_cust_site_use_rec.attribute1,
X_ATTRIBUTE2 => p_cust_site_use_rec.attribute2,
X_ATTRIBUTE3 => p_cust_site_use_rec.attribute3,
X_ATTRIBUTE4 => p_cust_site_use_rec.attribute4,
X_ATTRIBUTE5 => p_cust_site_use_rec.attribute5,
X_ATTRIBUTE6 => p_cust_site_use_rec.attribute6,
X_ATTRIBUTE7 => p_cust_site_use_rec.attribute7,
X_ATTRIBUTE8 => p_cust_site_use_rec.attribute8,
X_ATTRIBUTE9 => p_cust_site_use_rec.attribute9,
X_ATTRIBUTE10 => p_cust_site_use_rec.attribute10,
X_TAX_REFERENCE => p_cust_site_use_rec.tax_reference,
X_SORT_PRIORITY => p_cust_site_use_rec.sort_priority,
X_TAX_CODE => p_cust_site_use_rec.tax_code,
X_ATTRIBUTE11 => p_cust_site_use_rec.attribute11,
X_ATTRIBUTE12 => p_cust_site_use_rec.attribute12,
X_ATTRIBUTE13 => p_cust_site_use_rec.attribute13,
X_ATTRIBUTE14 => p_cust_site_use_rec.attribute14,
X_ATTRIBUTE15 => p_cust_site_use_rec.attribute15,
X_ATTRIBUTE16 => p_cust_site_use_rec.attribute16,
X_ATTRIBUTE17 => p_cust_site_use_rec.attribute17,
X_ATTRIBUTE18 => p_cust_site_use_rec.attribute18,
X_ATTRIBUTE19 => p_cust_site_use_rec.attribute19,
X_ATTRIBUTE20 => p_cust_site_use_rec.attribute20,
X_ATTRIBUTE21 => p_cust_site_use_rec.attribute21,
X_ATTRIBUTE22 => p_cust_site_use_rec.attribute22,
X_ATTRIBUTE23 => p_cust_site_use_rec.attribute23,
X_ATTRIBUTE24 => p_cust_site_use_rec.attribute24,
X_ATTRIBUTE25 => p_cust_site_use_rec.attribute25,
X_DEMAND_CLASS_CODE => p_cust_site_use_rec.demand_class_code,
X_TAX_HEADER_LEVEL_FLAG => p_cust_site_use_rec.tax_header_level_flag,
X_TAX_ROUNDING_RULE => p_cust_site_use_rec.tax_rounding_rule,
X_GLOBAL_ATTRIBUTE1 => p_cust_site_use_rec.global_attribute1,
X_GLOBAL_ATTRIBUTE2 => p_cust_site_use_rec.global_attribute2,
X_GLOBAL_ATTRIBUTE3 => p_cust_site_use_rec.global_attribute3,
X_GLOBAL_ATTRIBUTE4 => p_cust_site_use_rec.global_attribute4,
X_GLOBAL_ATTRIBUTE5 => p_cust_site_use_rec.global_attribute5,
X_GLOBAL_ATTRIBUTE6 => p_cust_site_use_rec.global_attribute6,
X_GLOBAL_ATTRIBUTE7 => p_cust_site_use_rec.global_attribute7,
X_GLOBAL_ATTRIBUTE8 => p_cust_site_use_rec.global_attribute8,
X_GLOBAL_ATTRIBUTE9 => p_cust_site_use_rec.global_attribute9,
X_GLOBAL_ATTRIBUTE10 => p_cust_site_use_rec.global_attribute10,
X_GLOBAL_ATTRIBUTE11 => p_cust_site_use_rec.global_attribute11,
X_GLOBAL_ATTRIBUTE12 => p_cust_site_use_rec.global_attribute12,
X_GLOBAL_ATTRIBUTE13 => p_cust_site_use_rec.global_attribute13,
X_GLOBAL_ATTRIBUTE14 => p_cust_site_use_rec.global_attribute14,
X_GLOBAL_ATTRIBUTE15 => p_cust_site_use_rec.global_attribute15,
X_GLOBAL_ATTRIBUTE16 => p_cust_site_use_rec.global_attribute16,
X_GLOBAL_ATTRIBUTE17 => p_cust_site_use_rec.global_attribute17,
X_GLOBAL_ATTRIBUTE18 => p_cust_site_use_rec.global_attribute18,
X_GLOBAL_ATTRIBUTE19 => p_cust_site_use_rec.global_attribute19,
X_GLOBAL_ATTRIBUTE20 => p_cust_site_use_rec.global_attribute20,
X_GLOBAL_ATTRIBUTE_CATEGORY => p_cust_site_use_rec.global_attribute_category,
X_PRIMARY_SALESREP_ID => p_cust_site_use_rec.primary_salesrep_id,
X_FINCHRG_RECEIVABLES_TRX_ID => p_cust_site_use_rec.finchrg_receivables_trx_id,
X_DATES_NEGATIVE_TOLERANCE => p_cust_site_use_rec.dates_negative_tolerance,
X_DATES_POSITIVE_TOLERANCE => p_cust_site_use_rec.dates_positive_tolerance,
X_DATE_TYPE_PREFERENCE => p_cust_site_use_rec.date_type_preference,
X_OVER_SHIPMENT_TOLERANCE => p_cust_site_use_rec.over_shipment_tolerance,
X_UNDER_SHIPMENT_TOLERANCE => p_cust_site_use_rec.under_shipment_tolerance,
X_ITEM_CROSS_REF_PREF => p_cust_site_use_rec.item_cross_ref_pref,
X_OVER_RETURN_TOLERANCE => p_cust_site_use_rec.over_return_tolerance,
X_UNDER_RETURN_TOLERANCE => p_cust_site_use_rec.under_return_tolerance,
X_SHIP_SETS_INCLUDE_LINES_FLAG => p_cust_site_use_rec.ship_sets_include_lines_flag,
X_ARRIVALSETS_INCLUDE_LINES_FG => p_cust_site_use_rec.arrivalsets_include_lines_flag,
X_SCHED_DATE_PUSH_FLAG => p_cust_site_use_rec.sched_date_push_flag,
X_INVOICE_QUANTITY_RULE => p_cust_site_use_rec.invoice_quantity_rule,
X_PRICING_EVENT => p_cust_site_use_rec.pricing_event,
X_GL_ID_REC => p_cust_site_use_rec.gl_id_rec,
X_GL_ID_REV => p_cust_site_use_rec.gl_id_rev,
X_GL_ID_TAX => p_cust_site_use_rec.gl_id_tax,
X_GL_ID_FREIGHT => p_cust_site_use_rec.gl_id_freight,
X_GL_ID_CLEARING => p_cust_site_use_rec.gl_id_clearing,
X_GL_ID_UNBILLED => p_cust_site_use_rec.gl_id_unbilled,
X_GL_ID_UNEARNED => p_cust_site_use_rec.gl_id_unearned,
X_GL_ID_UNPAID_REC => p_cust_site_use_rec.gl_id_unpaid_rec,
X_GL_ID_REMITTANCE => p_cust_site_use_rec.gl_id_remittance,
X_GL_ID_FACTOR => p_cust_site_use_rec.gl_id_factor,
X_TAX_CLASSIFICATION => p_cust_site_use_rec.tax_classification,
X_OBJECT_VERSION_NUMBER => 1,
X_CREATED_BY_MODULE => p_cust_site_use_rec.created_by_module,
X_APPLICATION_ID => p_cust_site_use_rec.application_id,
X_ORG_ID => p_cust_site_use_rec.org_id -- Bug 3456489
);
hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (-) ' ||
'x_site_use_id = ' || p_cust_site_use_rec.site_use_id,
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
UPDATE hz_customer_profiles
SET site_use_id = p_cust_site_use_rec.site_use_id
WHERE cust_account_profile_id = l_cust_account_profile_id ;
UPDATE hz_cust_profile_amts
SET site_use_id = p_cust_site_use_rec.site_use_id
WHERE cust_account_profile_id = l_cust_account_profile_id ;
hz_utility_v2pub.debug(p_message=>'Updated hz_customer_profiles and hz_cust_profiles/amts with site_use_id of DUNNING or STATEMENTS' ,
p_prefix =>l_debug_prefix,
p_msg_level=>fnd_log.level_statement);
hz_utility_v2pub.debug(p_message=>'Updated Site Use Id '||p_cust_site_use_rec.site_use_id ||' at Profile Id '||l_cust_account_profile_id,
p_prefix =>l_debug_prefix,
p_msg_level=>fnd_log.level_statement);
SELECT CUST_ACCOUNT_ID INTO p_customer_profile_rec.cust_account_id
FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
WHERE CUST_ACCT_SITE_ID = p_cust_site_use_rec.cust_acct_site_id;
* PRIVATE PROCEDURE do_update_cust_site_use
*
* DESCRIPTION
* Private procedure to update customer account site use.
*
* EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
* HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_site_use
* HZ_CUST_SITE_USES_PKG.Update_Row
*
* ARGUMENTS
* IN/OUT:
* p_cust_site_use_rec Customer account site use record.
* p_object_version_number Used for locking the being updated record.
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Jianying Huang o Created.
* 09-08-2003 Rajib Ranjan Borah o Bug 3085557.Site Use flag was earlier not updated
* if the user had modified the STATUS flag.
* 12-08-2003 Rajib Ranjan Borah o Bug 3294182.Site use flags are now updated for scenarios
* introduced by fix 2643624.
* 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)
* 26-Sep-2007 Sudhir Gokavarapu o Bug 6315081 [FORWARD PORT BUG6132727] Changed do_create_cust_site_use
* and do_update_cust_site_use api.
*/
PROCEDURE do_update_cust_site_use (
p_cust_site_use_rec IN OUT NOCOPY CUST_SITE_USE_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_debug_prefix VARCHAR2(30) := ''; --'do_update_cust_site_use'
hz_utility_v2pub.debug(p_message=> 'do_update_cust_site_use (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
SELECT ROWID, OBJECT_VERSION_NUMBER, CUST_ACCT_SITE_ID,
SITE_USE_CODE, PRIMARY_FLAG, STATUS, ORG_ID,CREATED_BY_MODULE,APPLICATION_ID
INTO l_rowid, l_object_version_number,
l_cust_acct_site_id, l_site_use_code, l_primary_flag, l_status,
p_cust_site_use_rec.org_id,l_created_by_module,l_application_id
FROM HZ_CUST_SITE_USES
WHERE SITE_USE_ID = p_cust_site_use_rec.site_use_id
FOR UPDATE NOWAIT;
p_create_update_flag => 'U',
p_cust_site_use_rec => p_cust_site_use_rec,
p_rowid => l_rowid,
x_return_status => x_return_status );
FND_MSG_PUB.DELETE_MSG( l_message_count + 1 );
SELECT PARTY_SITE_ID INTO l_party_site_id
FROM HZ_CUST_ACCT_SITES_ALL
WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
SELECT 'Y' INTO l_dummy
FROM HZ_PARTY_SITE_USES
WHERE PARTY_SITE_ID = l_party_site_id
AND SITE_USE_TYPE = l_site_use_code
AND STATUS = 'A';
hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Insert_Row (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
SELECT cust_account_id into l_cust_acct_id
FROM hz_cust_acct_sites_all -- Bug 3456489
WHERE cust_acct_site_id = l_cust_acct_site_id;
SELECT count(*) into l_cnt
FROM hz_cust_accounts a,
hz_cust_acct_sites_all cas,
hz_cust_site_uses_all su
WHERE
a.cust_account_id = l_cust_acct_id
and a.cust_account_id = cas.cust_account_id
and cas.cust_acct_site_id = su.cust_acct_site_id
and su.site_use_code = l_site_use_code
and su.site_use_id <> p_cust_site_use_rec.site_use_id
and su.status = 'A'
and su.primary_flag = 'Y'
and cas.org_id = p_cust_site_use_rec.org_id -- TCA SSA Uptake (Bug 3456489)
and su.org_id = p_cust_site_use_rec.org_id; -- TCA SSA Uptake (Bug 3456489) */
SELECT count(*) into l_cnt
FROM hz_cust_acct_sites_all cas,
hz_cust_site_uses_all su
WHERE
cas.cust_account_id = l_cust_acct_id
and cas.status = 'A'
and cas.cust_acct_site_id = su.cust_acct_site_id
and su.site_use_code = l_site_use_code
and su.site_use_id <> p_cust_site_use_rec.site_use_id
and su.status = 'A'
and su.primary_flag = 'Y'
and cas.org_id = p_cust_site_use_rec.org_id -- TCA SSA Uptake (Bug 3456489)
and su.org_id = p_cust_site_use_rec.org_id -- TCA SSA Uptake (Bug 3456489)
and rownum <= 1;
SELECT cust_account_id into l_cust_acct_id
FROM hz_cust_acct_sites_all -- Bug 3456489
WHERE cust_acct_site_id = l_cust_acct_site_id;
SELECT min(su.rowid),count(*) into l_minrowid,l_cnt
FROM hz_cust_accounts a,
hz_cust_acct_sites_all cas, -- Bug 3456489
hz_cust_site_uses_all su -- Bug 3456489
WHERE
a.cust_account_id = l_cust_acct_id
and a.cust_account_id = cas.cust_account_id
and cas.cust_acct_site_id = su.cust_acct_site_id
and su.site_use_code = l_site_use_code
and su.site_use_id <> p_cust_site_use_rec.site_use_id
and su.status = 'A'
and su.primary_flag = 'N'
and cas.org_id = p_cust_site_use_rec.org_id -- TCA SSA Uptake (Bug 3456489)
and su.org_id = p_cust_site_use_rec.org_id; -- TCA SSA Uptake (Bug 3456489)
UPDATE hz_cust_site_uses_all -- Bug 3456489
SET primary_flag = 'Y',
last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
last_update_date = hz_utility_pub.LAST_UPDATE_DATE
WHERE rowid = l_minrowid;
select cust_acct_site_id
into l_casid
from hz_cust_site_uses_all -- Bug 3456489
where rowid=l_minrowid;
HZ_CUST_SITE_USES_PKG.Update_Row (
X_Rowid => l_rowid,
X_SITE_USE_ID => p_cust_site_use_rec.site_use_id,
X_CUST_ACCT_SITE_ID => p_cust_site_use_rec.cust_acct_site_id,
X_SITE_USE_CODE => p_cust_site_use_rec.site_use_code,
X_PRIMARY_FLAG => p_cust_site_use_rec.primary_flag,
X_STATUS => p_cust_site_use_rec.status,
X_LOCATION => p_cust_site_use_rec.location,
X_CONTACT_ID => p_cust_site_use_rec.contact_id,
X_BILL_TO_SITE_USE_ID => p_cust_site_use_rec.bill_to_site_use_id,
X_ORIG_SYSTEM_REFERENCE => p_cust_site_use_rec.orig_system_reference,
X_SIC_CODE => p_cust_site_use_rec.sic_code,
X_PAYMENT_TERM_ID => p_cust_site_use_rec.payment_term_id,
X_GSA_INDICATOR => p_cust_site_use_rec.gsa_indicator,
X_SHIP_PARTIAL => p_cust_site_use_rec.ship_partial,
X_SHIP_VIA => p_cust_site_use_rec.ship_via,
X_FOB_POINT => p_cust_site_use_rec.fob_point,
X_ORDER_TYPE_ID => p_cust_site_use_rec.order_type_id,
X_PRICE_LIST_ID => p_cust_site_use_rec.price_list_id,
X_FREIGHT_TERM => p_cust_site_use_rec.freight_term,
X_WAREHOUSE_ID => p_cust_site_use_rec.warehouse_id,
X_TERRITORY_ID => p_cust_site_use_rec.territory_id,
X_ATTRIBUTE_CATEGORY => p_cust_site_use_rec.attribute_category,
X_ATTRIBUTE1 => p_cust_site_use_rec.attribute1,
X_ATTRIBUTE2 => p_cust_site_use_rec.attribute2,
X_ATTRIBUTE3 => p_cust_site_use_rec.attribute3,
X_ATTRIBUTE4 => p_cust_site_use_rec.attribute4,
X_ATTRIBUTE5 => p_cust_site_use_rec.attribute5,
X_ATTRIBUTE6 => p_cust_site_use_rec.attribute6,
X_ATTRIBUTE7 => p_cust_site_use_rec.attribute7,
X_ATTRIBUTE8 => p_cust_site_use_rec.attribute8,
X_ATTRIBUTE9 => p_cust_site_use_rec.attribute9,
X_ATTRIBUTE10 => p_cust_site_use_rec.attribute10,
X_TAX_REFERENCE => p_cust_site_use_rec.tax_reference,
X_SORT_PRIORITY => p_cust_site_use_rec.sort_priority,
X_TAX_CODE => p_cust_site_use_rec.tax_code,
X_ATTRIBUTE11 => p_cust_site_use_rec.attribute11,
X_ATTRIBUTE12 => p_cust_site_use_rec.attribute12,
X_ATTRIBUTE13 => p_cust_site_use_rec.attribute13,
X_ATTRIBUTE14 => p_cust_site_use_rec.attribute14,
X_ATTRIBUTE15 => p_cust_site_use_rec.attribute15,
X_ATTRIBUTE16 => p_cust_site_use_rec.attribute16,
X_ATTRIBUTE17 => p_cust_site_use_rec.attribute17,
X_ATTRIBUTE18 => p_cust_site_use_rec.attribute18,
X_ATTRIBUTE19 => p_cust_site_use_rec.attribute19,
X_ATTRIBUTE20 => p_cust_site_use_rec.attribute20,
X_ATTRIBUTE21 => p_cust_site_use_rec.attribute21,
X_ATTRIBUTE22 => p_cust_site_use_rec.attribute22,
X_ATTRIBUTE23 => p_cust_site_use_rec.attribute23,
X_ATTRIBUTE24 => p_cust_site_use_rec.attribute24,
X_ATTRIBUTE25 => p_cust_site_use_rec.attribute25,
X_DEMAND_CLASS_CODE => p_cust_site_use_rec.demand_class_code,
X_TAX_HEADER_LEVEL_FLAG => p_cust_site_use_rec.tax_header_level_flag,
X_TAX_ROUNDING_RULE => p_cust_site_use_rec.tax_rounding_rule,
X_GLOBAL_ATTRIBUTE1 => p_cust_site_use_rec.global_attribute1,
X_GLOBAL_ATTRIBUTE2 => p_cust_site_use_rec.global_attribute2,
X_GLOBAL_ATTRIBUTE3 => p_cust_site_use_rec.global_attribute3,
X_GLOBAL_ATTRIBUTE4 => p_cust_site_use_rec.global_attribute4,
X_GLOBAL_ATTRIBUTE5 => p_cust_site_use_rec.global_attribute5,
X_GLOBAL_ATTRIBUTE6 => p_cust_site_use_rec.global_attribute6,
X_GLOBAL_ATTRIBUTE7 => p_cust_site_use_rec.global_attribute7,
X_GLOBAL_ATTRIBUTE8 => p_cust_site_use_rec.global_attribute8,
X_GLOBAL_ATTRIBUTE9 => p_cust_site_use_rec.global_attribute9,
X_GLOBAL_ATTRIBUTE10 => p_cust_site_use_rec.global_attribute10,
X_GLOBAL_ATTRIBUTE11 => p_cust_site_use_rec.global_attribute11,
X_GLOBAL_ATTRIBUTE12 => p_cust_site_use_rec.global_attribute12,
X_GLOBAL_ATTRIBUTE13 => p_cust_site_use_rec.global_attribute13,
X_GLOBAL_ATTRIBUTE14 => p_cust_site_use_rec.global_attribute14,
X_GLOBAL_ATTRIBUTE15 => p_cust_site_use_rec.global_attribute15,
X_GLOBAL_ATTRIBUTE16 => p_cust_site_use_rec.global_attribute16,
X_GLOBAL_ATTRIBUTE17 => p_cust_site_use_rec.global_attribute17,
X_GLOBAL_ATTRIBUTE18 => p_cust_site_use_rec.global_attribute18,
X_GLOBAL_ATTRIBUTE19 => p_cust_site_use_rec.global_attribute19,
X_GLOBAL_ATTRIBUTE20 => p_cust_site_use_rec.global_attribute20,
X_GLOBAL_ATTRIBUTE_CATEGORY => p_cust_site_use_rec.global_attribute_category,
X_PRIMARY_SALESREP_ID => p_cust_site_use_rec.primary_salesrep_id,
X_FINCHRG_RECEIVABLES_TRX_ID => p_cust_site_use_rec.finchrg_receivables_trx_id,
X_DATES_NEGATIVE_TOLERANCE => p_cust_site_use_rec.dates_negative_tolerance,
X_DATES_POSITIVE_TOLERANCE => p_cust_site_use_rec.dates_positive_tolerance,
X_DATE_TYPE_PREFERENCE => p_cust_site_use_rec.date_type_preference,
X_OVER_SHIPMENT_TOLERANCE => p_cust_site_use_rec.over_shipment_tolerance,
X_UNDER_SHIPMENT_TOLERANCE => p_cust_site_use_rec.under_shipment_tolerance,
X_ITEM_CROSS_REF_PREF => p_cust_site_use_rec.item_cross_ref_pref,
X_OVER_RETURN_TOLERANCE => p_cust_site_use_rec.over_return_tolerance,
X_UNDER_RETURN_TOLERANCE => p_cust_site_use_rec.under_return_tolerance,
X_SHIP_SETS_INCLUDE_LINES_FLAG => p_cust_site_use_rec.ship_sets_include_lines_flag,
X_ARRIVALSETS_INCLUDE_LINES_FG => p_cust_site_use_rec.arrivalsets_include_lines_flag,
X_SCHED_DATE_PUSH_FLAG => p_cust_site_use_rec.sched_date_push_flag,
X_INVOICE_QUANTITY_RULE => p_cust_site_use_rec.invoice_quantity_rule,
X_PRICING_EVENT => p_cust_site_use_rec.pricing_event,
X_GL_ID_REC => p_cust_site_use_rec.gl_id_rec,
X_GL_ID_REV => p_cust_site_use_rec.gl_id_rev,
X_GL_ID_TAX => p_cust_site_use_rec.gl_id_tax,
X_GL_ID_FREIGHT => p_cust_site_use_rec.gl_id_freight,
X_GL_ID_CLEARING => p_cust_site_use_rec.gl_id_clearing,
X_GL_ID_UNBILLED => p_cust_site_use_rec.gl_id_unbilled,
X_GL_ID_UNEARNED => p_cust_site_use_rec.gl_id_unearned,
X_GL_ID_UNPAID_REC => p_cust_site_use_rec.gl_id_unpaid_rec,
X_GL_ID_REMITTANCE => p_cust_site_use_rec.gl_id_remittance,
X_GL_ID_FACTOR => p_cust_site_use_rec.gl_id_factor,
X_TAX_CLASSIFICATION => p_cust_site_use_rec.tax_classification,
X_OBJECT_VERSION_NUMBER => p_object_version_number,
X_CREATED_BY_MODULE => p_cust_site_use_rec.created_by_module,
X_APPLICATION_ID => p_cust_site_use_rec.application_id
);
hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Update_Row (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'do_update_cust_site_use (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
END do_update_cust_site_use;
* p_flag Flag used to update account site.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Jianying Huang o Created.
* 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)
*
*/
PROCEDURE denormalize_site_use_flag (
p_cust_acct_site_id IN NUMBER,
p_site_use_code IN VARCHAR2,
p_flag IN VARCHAR2
) IS
l_debug_prefix VARCHAR2(30) := ''; --'denormalize_site_use_flag'
UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
SET BILL_TO_FLAG = p_flag,
last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
last_update_date = hz_utility_pub.LAST_UPDATE_DATE
WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
SET SHIP_TO_FLAG = p_flag,
last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
last_update_date = hz_utility_pub.LAST_UPDATE_DATE
WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
UPDATE HZ_CUST_ACCT_SITES_ALL -- Bug 3456489
SET MARKET_FLAG = p_flag,
last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
last_update_date = hz_utility_pub.LAST_UPDATE_DATE
WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
p_create_update_flag => 'C',
p_account_site_rec => l_cust_acct_site_rec,
x_return_status => x_return_status
);
* PROCEDURE update_cust_acct_site
*
* DESCRIPTION
* Updates customer account site.
*
* EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
* HZ_BUSINESS_EVENT_V2PVT.update_cust_acct_site_event
*
* ARGUMENTS
* IN:
* p_init_msg_list Initialize message stack if it is set to
* FND_API.G_TRUE. Default is FND_API.G_FALSE.
* p_cust_acct_site_rec Customer account site record.
* IN/OUT:
* p_object_version_number Used for locking the being updated record.
* OUT:
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* x_msg_count Number of messages in message stack.
* x_msg_data Message text if x_msg_count is 1.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Jianying Huang o Created.
*
*/
PROCEDURE update_cust_acct_site (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_cust_acct_site_rec IN CUST_ACCT_SITE_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_cust_acct_site_rec CUST_ACCT_SITE_REC_TYPE := p_cust_acct_site_rec;
SAVEPOINT update_cust_acct_site;
hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
p_create_update_flag => 'U',
p_account_site_rec => l_cust_acct_site_rec,
p_old_account_site_rec => l_old_cust_acct_site_rec,
x_return_status => x_return_status
);
do_update_cust_acct_site (
l_cust_acct_site_rec,
p_object_version_number,
x_return_status );
HZ_BUSINESS_EVENT_V2PVT.update_cust_acct_site_event (
l_cust_acct_site_rec , l_old_cust_acct_site_rec );
hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_cust_acct_site;
hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_cust_acct_site;
hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_cust_acct_site;
hz_utility_v2pub.debug(p_message=>'update_cust_acct_site (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
END update_cust_acct_site;
* HZ_CUST_ACCT_SITES_PKG.Select_Row
*
* ARGUMENTS
* IN:
* p_init_msg_list Initialize message stack if it is set to
* FND_API.G_TRUE. Default is FND_API.G_FALSE.
* p_cust_acct_site_id Customer account site id.
* IN/OUT:
* OUT:
* x_cust_acct_site_rec Returned customer account site record.
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* x_msg_count Number of messages in message stack.
* x_msg_data Message text if x_msg_count is 1.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Jianying Huang o Created.
*
*/
PROCEDURE get_cust_acct_site_rec (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_cust_acct_site_id IN NUMBER,
x_cust_acct_site_rec OUT NOCOPY CUST_ACCT_SITE_REC_TYPE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_debug_prefix VARCHAR2(30) := '';
hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_SITES_PKG.Select_Row (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_CUST_ACCT_SITES_PKG.Select_Row (
X_CUST_ACCT_SITE_ID => x_cust_acct_site_rec.cust_acct_site_id,
X_CUST_ACCOUNT_ID => x_cust_acct_site_rec.cust_account_id,
X_PARTY_SITE_ID => x_cust_acct_site_rec.party_site_id,
X_ATTRIBUTE_CATEGORY => x_cust_acct_site_rec.attribute_category,
X_ATTRIBUTE1 => x_cust_acct_site_rec.attribute1,
X_ATTRIBUTE2 => x_cust_acct_site_rec.attribute2,
X_ATTRIBUTE3 => x_cust_acct_site_rec.attribute3,
X_ATTRIBUTE4 => x_cust_acct_site_rec.attribute4,
X_ATTRIBUTE5 => x_cust_acct_site_rec.attribute5,
X_ATTRIBUTE6 => x_cust_acct_site_rec.attribute6,
X_ATTRIBUTE7 => x_cust_acct_site_rec.attribute7,
X_ATTRIBUTE8 => x_cust_acct_site_rec.attribute8,
X_ATTRIBUTE9 => x_cust_acct_site_rec.attribute9,
X_ATTRIBUTE10 => x_cust_acct_site_rec.attribute10,
X_ATTRIBUTE11 => x_cust_acct_site_rec.attribute11,
X_ATTRIBUTE12 => x_cust_acct_site_rec.attribute12,
X_ATTRIBUTE13 => x_cust_acct_site_rec.attribute13,
X_ATTRIBUTE14 => x_cust_acct_site_rec.attribute14,
X_ATTRIBUTE15 => x_cust_acct_site_rec.attribute15,
X_ATTRIBUTE16 => x_cust_acct_site_rec.attribute16,
X_ATTRIBUTE17 => x_cust_acct_site_rec.attribute17,
X_ATTRIBUTE18 => x_cust_acct_site_rec.attribute18,
X_ATTRIBUTE19 => x_cust_acct_site_rec.attribute19,
X_ATTRIBUTE20 => x_cust_acct_site_rec.attribute20,
X_GLOBAL_ATTRIBUTE_CATEGORY => x_cust_acct_site_rec.global_attribute_category,
X_GLOBAL_ATTRIBUTE1 => x_cust_acct_site_rec.global_attribute1,
X_GLOBAL_ATTRIBUTE2 => x_cust_acct_site_rec.global_attribute2,
X_GLOBAL_ATTRIBUTE3 => x_cust_acct_site_rec.global_attribute3,
X_GLOBAL_ATTRIBUTE4 => x_cust_acct_site_rec.global_attribute4,
X_GLOBAL_ATTRIBUTE5 => x_cust_acct_site_rec.global_attribute5,
X_GLOBAL_ATTRIBUTE6 => x_cust_acct_site_rec.global_attribute6,
X_GLOBAL_ATTRIBUTE7 => x_cust_acct_site_rec.global_attribute7,
X_GLOBAL_ATTRIBUTE8 => x_cust_acct_site_rec.global_attribute8,
X_GLOBAL_ATTRIBUTE9 => x_cust_acct_site_rec.global_attribute9,
X_GLOBAL_ATTRIBUTE10 => x_cust_acct_site_rec.global_attribute10,
X_GLOBAL_ATTRIBUTE11 => x_cust_acct_site_rec.global_attribute11,
X_GLOBAL_ATTRIBUTE12 => x_cust_acct_site_rec.global_attribute12,
X_GLOBAL_ATTRIBUTE13 => x_cust_acct_site_rec.global_attribute13,
X_GLOBAL_ATTRIBUTE14 => x_cust_acct_site_rec.global_attribute14,
X_GLOBAL_ATTRIBUTE15 => x_cust_acct_site_rec.global_attribute15,
X_GLOBAL_ATTRIBUTE16 => x_cust_acct_site_rec.global_attribute16,
X_GLOBAL_ATTRIBUTE17 => x_cust_acct_site_rec.global_attribute17,
X_GLOBAL_ATTRIBUTE18 => x_cust_acct_site_rec.global_attribute18,
X_GLOBAL_ATTRIBUTE19 => x_cust_acct_site_rec.global_attribute19,
X_GLOBAL_ATTRIBUTE20 => x_cust_acct_site_rec.global_attribute20,
X_ORIG_SYSTEM_REFERENCE => x_cust_acct_site_rec.orig_system_reference,
X_STATUS => x_cust_acct_site_rec.status,
X_CUSTOMER_CATEGORY_CODE => x_cust_acct_site_rec.customer_category_code,
X_LANGUAGE => x_cust_acct_site_rec.language,
X_KEY_ACCOUNT_FLAG => x_cust_acct_site_rec.key_account_flag,
X_TP_HEADER_ID => x_cust_acct_site_rec.tp_header_id,
X_ECE_TP_LOCATION_CODE => x_cust_acct_site_rec.ece_tp_location_code,
X_PRIMARY_SPECIALIST_ID => x_cust_acct_site_rec.primary_specialist_id,
X_SECONDARY_SPECIALIST_ID => x_cust_acct_site_rec.secondary_specialist_id,
X_TERRITORY_ID => x_cust_acct_site_rec.territory_id,
X_TERRITORY => x_cust_acct_site_rec.territory,
X_TRANSLATED_CUSTOMER_NAME => x_cust_acct_site_rec.translated_customer_name,
X_CREATED_BY_MODULE => x_cust_acct_site_rec.created_by_module,
X_APPLICATION_ID => x_cust_acct_site_rec.application_id,
X_ORG_ID => x_cust_acct_site_rec.org_id -- Bug 3456489
);
hz_utility_v2pub.debug(p_message=> 'HZ_CUST_ACCT_SITES_PKG.Select_Row (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
* PROCEDURE update_cust_site_use
*
* DESCRIPTION
* Updates customer account site use.
*
* EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
* HZ_BUSINESS_EVENT_V2PVT.update_cust_site_use_event
*
* ARGUMENTS
* IN:
* p_init_msg_list Initialize message stack if it is set to
* FND_API.G_TRUE. Default is FND_API.G_FALSE.
* p_cust_site_use_rec Customer account site use record.
* IN/OUT:
* p_object_version_number Used for locking the being updated record.
* OUT:
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* x_msg_count Number of messages in message stack.
* x_msg_data Message text if x_msg_count is 1.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Jianying Huang o Created.
*
*/
PROCEDURE update_cust_site_use (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_cust_site_use_rec IN CUST_SITE_USE_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_cust_site_use_rec CUST_SITE_USE_REC_TYPE := p_cust_site_use_rec;
SAVEPOINT update_cust_site_use;
hz_utility_v2pub.debug(p_message=>'update_cust_site_use (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
do_update_cust_site_use (
l_cust_site_use_rec,
p_object_version_number,
x_return_status );
HZ_BUSINESS_EVENT_V2PVT.update_cust_site_use_event (
l_cust_site_use_rec , l_old_cust_site_use_rec);
hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_cust_site_use;
hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_cust_site_use;
hz_utility_v2pub.debug(p_message=>'update_cust_site_use (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_cust_site_use;
hz_utility_v2pub.debug(p_message=> 'update_cust_site_use (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
END update_cust_site_use;
* HZ_CUST_SITE_USES_PKG.Select_Row
*
* ARGUMENTS
* IN:
* p_init_msg_list Initialize message stack if it is set to
* FND_API.G_TRUE. Default is FND_API.G_FALSE.
* p_cust_site_use_id Customer account site use id.
* IN/OUT:
* OUT:
* x_cust_site_use_rec Returned customer account site use record.
* x_customer_profile_rec Returned customer profile record.
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* x_msg_count Number of messages in message stack.
* x_msg_data Message text if x_msg_count is 1.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Jianying Huang o Created.
*
*/
PROCEDURE get_cust_site_use_rec (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_site_use_id IN NUMBER,
x_cust_site_use_rec OUT NOCOPY CUST_SITE_USE_REC_TYPE,
x_customer_profile_rec OUT NOCOPY HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_cust_account_profile_id NUMBER;
hz_utility_v2pub.debug(p_message=>'HZ_CUST_SITE_USES_PKG.Select_Row (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_CUST_SITE_USES_PKG.Select_Row (
X_SITE_USE_ID => x_cust_site_use_rec.site_use_id,
X_CUST_ACCT_SITE_ID => x_cust_site_use_rec.cust_acct_site_id,
X_SITE_USE_CODE => x_cust_site_use_rec.site_use_code,
X_PRIMARY_FLAG => x_cust_site_use_rec.primary_flag,
X_STATUS => x_cust_site_use_rec.status,
X_LOCATION => x_cust_site_use_rec.location,
X_BILL_TO_SITE_USE_ID => x_cust_site_use_rec.bill_to_site_use_id,
X_ORIG_SYSTEM_REFERENCE => x_cust_site_use_rec.orig_system_reference,
X_SIC_CODE => x_cust_site_use_rec.sic_code,
X_PAYMENT_TERM_ID => x_cust_site_use_rec.payment_term_id,
X_GSA_INDICATOR => x_cust_site_use_rec.gsa_indicator,
X_SHIP_PARTIAL => x_cust_site_use_rec.ship_partial,
X_SHIP_VIA => x_cust_site_use_rec.ship_via,
X_FOB_POINT => x_cust_site_use_rec.fob_point,
X_ORDER_TYPE_ID => x_cust_site_use_rec.order_type_id,
X_PRICE_LIST_ID => x_cust_site_use_rec.price_list_id,
X_FREIGHT_TERM => x_cust_site_use_rec.freight_term,
X_WAREHOUSE_ID => x_cust_site_use_rec.warehouse_id,
X_TERRITORY_ID => x_cust_site_use_rec.territory_id,
X_ATTRIBUTE_CATEGORY => x_cust_site_use_rec.attribute_category,
X_ATTRIBUTE1 => x_cust_site_use_rec.attribute1,
X_ATTRIBUTE2 => x_cust_site_use_rec.attribute2,
X_ATTRIBUTE3 => x_cust_site_use_rec.attribute3,
X_ATTRIBUTE4 => x_cust_site_use_rec.attribute4,
X_ATTRIBUTE5 => x_cust_site_use_rec.attribute5,
X_ATTRIBUTE6 => x_cust_site_use_rec.attribute6,
X_ATTRIBUTE7 => x_cust_site_use_rec.attribute7,
X_ATTRIBUTE8 => x_cust_site_use_rec.attribute8,
X_ATTRIBUTE9 => x_cust_site_use_rec.attribute9,
X_ATTRIBUTE10 => x_cust_site_use_rec.attribute10,
X_TAX_REFERENCE => x_cust_site_use_rec.tax_reference,
X_SORT_PRIORITY => x_cust_site_use_rec.sort_priority,
X_TAX_CODE => x_cust_site_use_rec.tax_code,
X_ATTRIBUTE11 => x_cust_site_use_rec.attribute11,
X_ATTRIBUTE12 => x_cust_site_use_rec.attribute12,
X_ATTRIBUTE13 => x_cust_site_use_rec.attribute13,
X_ATTRIBUTE14 => x_cust_site_use_rec.attribute14,
X_ATTRIBUTE15 => x_cust_site_use_rec.attribute15,
X_ATTRIBUTE16 => x_cust_site_use_rec.attribute16,
X_ATTRIBUTE17 => x_cust_site_use_rec.attribute17,
X_ATTRIBUTE18 => x_cust_site_use_rec.attribute18,
X_ATTRIBUTE19 => x_cust_site_use_rec.attribute19,
X_ATTRIBUTE20 => x_cust_site_use_rec.attribute20,
X_ATTRIBUTE21 => x_cust_site_use_rec.attribute21,
X_ATTRIBUTE22 => x_cust_site_use_rec.attribute22,
X_ATTRIBUTE23 => x_cust_site_use_rec.attribute23,
X_ATTRIBUTE24 => x_cust_site_use_rec.attribute24,
X_ATTRIBUTE25 => x_cust_site_use_rec.attribute25,
X_DEMAND_CLASS_CODE => x_cust_site_use_rec.demand_class_code,
X_TAX_HEADER_LEVEL_FLAG => x_cust_site_use_rec.tax_header_level_flag,
X_TAX_ROUNDING_RULE => x_cust_site_use_rec.tax_rounding_rule,
X_GLOBAL_ATTRIBUTE1 => x_cust_site_use_rec.global_attribute1,
X_GLOBAL_ATTRIBUTE2 => x_cust_site_use_rec.global_attribute2,
X_GLOBAL_ATTRIBUTE3 => x_cust_site_use_rec.global_attribute3,
X_GLOBAL_ATTRIBUTE4 => x_cust_site_use_rec.global_attribute4,
X_GLOBAL_ATTRIBUTE5 => x_cust_site_use_rec.global_attribute5,
X_GLOBAL_ATTRIBUTE6 => x_cust_site_use_rec.global_attribute6,
X_GLOBAL_ATTRIBUTE7 => x_cust_site_use_rec.global_attribute7,
X_GLOBAL_ATTRIBUTE8 => x_cust_site_use_rec.global_attribute8,
X_GLOBAL_ATTRIBUTE9 => x_cust_site_use_rec.global_attribute9,
X_GLOBAL_ATTRIBUTE10 => x_cust_site_use_rec.global_attribute10,
X_GLOBAL_ATTRIBUTE11 => x_cust_site_use_rec.global_attribute11,
X_GLOBAL_ATTRIBUTE12 => x_cust_site_use_rec.global_attribute12,
X_GLOBAL_ATTRIBUTE13 => x_cust_site_use_rec.global_attribute13,
X_GLOBAL_ATTRIBUTE14 => x_cust_site_use_rec.global_attribute14,
X_GLOBAL_ATTRIBUTE15 => x_cust_site_use_rec.global_attribute15,
X_GLOBAL_ATTRIBUTE16 => x_cust_site_use_rec.global_attribute16,
X_GLOBAL_ATTRIBUTE17 => x_cust_site_use_rec.global_attribute17,
X_GLOBAL_ATTRIBUTE18 => x_cust_site_use_rec.global_attribute18,
X_GLOBAL_ATTRIBUTE19 => x_cust_site_use_rec.global_attribute19,
X_GLOBAL_ATTRIBUTE20 => x_cust_site_use_rec.global_attribute20,
X_GLOBAL_ATTRIBUTE_CATEGORY => x_cust_site_use_rec.global_attribute_category,
X_PRIMARY_SALESREP_ID => x_cust_site_use_rec.primary_salesrep_id,
X_FINCHRG_RECEIVABLES_TRX_ID => x_cust_site_use_rec.finchrg_receivables_trx_id,
X_DATES_NEGATIVE_TOLERANCE => x_cust_site_use_rec.dates_negative_tolerance,
X_DATES_POSITIVE_TOLERANCE => x_cust_site_use_rec.dates_positive_tolerance,
X_DATE_TYPE_PREFERENCE => x_cust_site_use_rec.date_type_preference,
X_OVER_SHIPMENT_TOLERANCE => x_cust_site_use_rec.over_shipment_tolerance,
X_UNDER_SHIPMENT_TOLERANCE => x_cust_site_use_rec.under_shipment_tolerance,
X_ITEM_CROSS_REF_PREF => x_cust_site_use_rec.item_cross_ref_pref,
X_OVER_RETURN_TOLERANCE => x_cust_site_use_rec.over_return_tolerance,
X_UNDER_RETURN_TOLERANCE => x_cust_site_use_rec.under_return_tolerance,
X_SHIP_SETS_INCLUDE_LINES_FLAG => x_cust_site_use_rec.ship_sets_include_lines_flag,
X_ARRIVALSETS_INCLUDE_LINES_FG => x_cust_site_use_rec.arrivalsets_include_lines_flag,
X_SCHED_DATE_PUSH_FLAG => x_cust_site_use_rec.sched_date_push_flag,
X_INVOICE_QUANTITY_RULE => x_cust_site_use_rec.invoice_quantity_rule,
X_PRICING_EVENT => x_cust_site_use_rec.pricing_event,
X_GL_ID_REC => x_cust_site_use_rec.gl_id_rec,
X_GL_ID_REV => x_cust_site_use_rec.gl_id_rev,
X_GL_ID_TAX => x_cust_site_use_rec.gl_id_tax,
X_GL_ID_FREIGHT => x_cust_site_use_rec.gl_id_freight,
X_GL_ID_CLEARING => x_cust_site_use_rec.gl_id_clearing,
X_GL_ID_UNBILLED => x_cust_site_use_rec.gl_id_unbilled,
X_GL_ID_UNEARNED => x_cust_site_use_rec.gl_id_unearned,
X_GL_ID_UNPAID_REC => x_cust_site_use_rec.gl_id_unpaid_rec,
X_GL_ID_REMITTANCE => x_cust_site_use_rec.gl_id_remittance,
X_GL_ID_FACTOR => x_cust_site_use_rec.gl_id_factor,
X_TAX_CLASSIFICATION => x_cust_site_use_rec.tax_classification,
X_CREATED_BY_MODULE => x_cust_site_use_rec.created_by_module,
X_APPLICATION_ID => x_cust_site_use_rec.application_id,
X_ORG_ID => x_cust_site_use_rec.org_id -- Bug 3456489
);
hz_utility_v2pub.debug(p_message=> 'HZ_CUST_SITE_USES_PKG.Select_Row (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
SELECT CUST_ACCOUNT_PROFILE_ID INTO l_cust_account_profile_id
FROM HZ_CUSTOMER_PROFILES
WHERE SITE_USE_ID = p_site_use_id;
p_create_update_flag IN VARCHAR2,
p_account_site_rec IN cust_acct_site_rec_type,
p_old_account_site_rec IN cust_acct_site_rec_type DEFAULT NULL,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
BEGIN
-- check language
IF (p_create_update_flag = 'C' AND
p_account_site_rec.language IS NOT NULL AND
p_account_site_rec.language <> FND_API.G_MISS_CHAR) OR
(p_create_update_flag = 'U' AND
p_account_site_rec.language IS NOT NULL AND
p_account_site_rec.language <> p_old_account_site_rec.language)
THEN
FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');