[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE object_version_select
(p_table_name IN VARCHAR2,
p_col_id IN VARCHAR2,
x_rowid IN OUT NOCOPY ROWID,
x_object_version_number IN OUT NOCOPY NUMBER,
x_last_update_date IN OUT NOCOPY DATE,
x_id_value IN OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2,
x_msg_count IN OUT NOCOPY NUMBER,
x_msg_data IN OUT NOCOPY VARCHAR2 )
IS
CURSOR cu_cust_acct_version IS
SELECT ROWID,
OBJECT_VERSION_NUMBER,
LAST_UPDATE_DATE,
NULL
FROM HZ_CUST_ACCOUNTS
WHERE CUST_ACCOUNT_ID = p_col_id;
SELECT ROWID,
OBJECT_VERSION_NUMBER,
LAST_UPDATE_DATE,
CUST_ACCOUNT_ID
FROM HZ_CUSTOMER_PROFILES
WHERE CUST_ACCOUNT_PROFILE_ID = p_col_id;
SELECT ROWID,
OBJECT_VERSION_NUMBER,
LAST_UPDATE_DATE,
NULL
FROM HZ_PARTIES
WHERE PARTY_ID = p_col_id;
l_last_update_date DATE;
l_last_update_date ,
x_id_value;
l_last_update_date ,
x_id_value;
l_last_update_date ,
x_id_value;
IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>
TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
THEN
FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
PROCEDURE update_flag
( p_party_id IN NUMBER,
p_flag_name IN VARCHAR2,
p_flag_value IN VARCHAR2,
x_return_status IN OUT NOCOPY VARCHAR2,
x_msg_data IN OUT NOCOPY VARCHAR2)
IS
CURSOR cu_party_update
IS
SELECT party_id
FROM hz_parties
WHERE party_id = p_party_id
FOR UPDATE OF party_id NOWAIT;
OPEN cu_party_update;
FETCH cu_party_update INTO l_lock;
IF cu_party_update%FOUND THEN
IF p_flag_name = 'REFERENCE_FOR' THEN
UPDATE hz_parties
SET REFERENCE_USE_FLAG = p_flag_value
WHERE party_id = p_party_id;
UPDATE hz_parties
SET THIRD_PARTY_FLAG = p_flag_value
WHERE party_id = p_party_id;
UPDATE hz_parties
SET COMPETITOR_FLAG = p_flag_value
WHERE party_id = p_party_id;
CLOSE cu_party_update;
IF cu_party_update%ISOPEN THEN
CLOSE cu_party_update;
select relationship_id ,
end_date
from hz_relationships
where subject_id = c_party_id
and relationship_code = 'REFERENCE_FOR'
and subject_table_name = 'HZ_PARTIES'
and object_table_name = 'HZ_PARTIES'
and directional_flag = 'F';
select relationship_id ,
end_date
from hz_relationships
where subject_id = c_party_id
and relationship_code = 'PARTNER_OF'
and subject_table_name = 'HZ_PARTIES'
and object_table_name = 'HZ_PARTIES'
and directional_flag = 'F';
select relationship_id,
end_date
from hz_relationships
where subject_id = c_party_id
and relationship_code = 'COMPETITOR_OF'
and subject_table_name = 'HZ_PARTIES'
and object_table_name = 'HZ_PARTIES'
and directional_flag = 'F';
x_party_rel_last_update_date DATE;
x_party_last_update_date DATE;
SELECT relationship_type,
create_party_flag
FROM hz_relationship_types
WHERE forward_rel_code = p_rel_code
AND subject_type = c_party_type
AND object_type = i_internal_party_type
AND status = 'A'
AND rownum = 1;
SELECT last_update_date ,
object_version_number
INTO x_party_rel_last_update_date ,
l_party_rel_object_version
FROM hz_relationships
WHERE relationship_id = x_party_rel_id
AND subject_table_name = 'HZ_PARTIES'
AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F';
SELECT last_update_date,
object_version_number
INTO x_party_last_update_date,
l_party_object_version
FROM hz_parties
WHERE party_id = c_party_id;
x_party_last_update_date := NULL;
HZ_RELATIONSHIP_V2PUB.update_relationship (
p_relationship_rec => prel_rec,
p_object_version_number => l_party_rel_object_version,
p_party_object_version_number => l_party_object_version,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data );
update_flag(
p_party_id => c_party_id,
p_flag_name => p_rel_code,
p_flag_value => C_flag,
x_return_status => x_return_status,
x_msg_data => x_msg_data);
SELECT last_update_date ,
object_version_number
INTO x_party_rel_last_update_date ,
l_party_rel_object_version
FROM hz_relationships
WHERE relationship_id = x_party_rel_id
AND subject_table_name = 'HZ_PARTIES'
AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F';
SELECT last_update_date,
object_version_number
INTO x_party_last_update_date,
l_party_object_version
FROM hz_parties
WHERE party_id = c_party_id;
x_party_last_update_date := NULL;
HZ_RELATIONSHIP_V2PUB.update_relationship (
p_relationship_rec => prel_rec,
p_object_version_number => l_party_rel_object_version,
p_party_object_version_number => l_party_object_version,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data );
update_flag(
p_party_id => c_party_id,
p_flag_name => p_rel_code,
p_flag_value => C_flag,
x_return_status => x_return_status,
x_msg_data => x_msg_data);
SELECT party_type
FROM hz_parties
WHERE party_id = i_internal_party_id;
PROCEDURE insert_row(
c_cust_account_id IN OUT NOCOPY NUMBER ,
c_party_id IN OUT NOCOPY NUMBER,
c_account_number IN OUT NOCOPY VARCHAR2,
c_Attribute_Category IN VARCHAR2,
c_Attribute1 IN VARCHAR2,
c_Attribute2 IN VARCHAR2,
c_Attribute3 IN VARCHAR2,
c_Attribute4 IN VARCHAR2,
c_Attribute5 IN VARCHAR2,
c_Attribute6 IN VARCHAR2,
c_Attribute7 IN VARCHAR2,
c_Attribute8 IN VARCHAR2,
c_Attribute9 IN VARCHAR2,
c_Attribute10 IN VARCHAR2,
c_Attribute11 IN VARCHAR2,
c_Attribute12 IN VARCHAR2,
c_Attribute13 IN VARCHAR2,
c_Attribute14 IN VARCHAR2,
c_Attribute15 IN VARCHAR2,
c_Attribute16 IN VARCHAR2,
c_Attribute17 IN VARCHAR2,
c_Attribute18 IN VARCHAR2,
c_Attribute19 IN VARCHAR2,
c_Attribute20 IN VARCHAR2,
c_global_attribute_category IN VARCHAR2,
c_global_attribute1 IN VARCHAR2,
c_global_attribute2 IN VARCHAR2,
c_global_attribute3 IN VARCHAR2,
c_global_attribute4 IN VARCHAR2,
c_global_attribute5 IN VARCHAR2,
c_global_attribute6 IN VARCHAR2,
c_global_attribute7 IN VARCHAR2,
c_global_attribute8 IN VARCHAR2,
c_global_attribute9 IN VARCHAR2,
c_global_attribute10 IN VARCHAR2,
c_global_attribute11 IN VARCHAR2,
c_global_attribute12 IN VARCHAR2,
c_global_attribute13 IN VARCHAR2,
c_global_attribute14 IN VARCHAR2,
c_global_attribute15 IN VARCHAR2,
c_global_attribute16 IN VARCHAR2,
c_global_attribute17 IN VARCHAR2,
c_global_attribute18 IN VARCHAR2,
c_global_attribute19 IN VARCHAR2,
c_global_attribute20 IN VARCHAR2,
c_orig_system_reference IN VARCHAR2,
c_status IN VARCHAR2,
c_customer_type IN VARCHAR2,
c_customer_class_code IN VARCHAR2,
c_primary_salesrep_id IN NUMBER ,
c_sales_channel_code IN VARCHAR2,
c_order_type_id IN NUMBER,
c_price_list_id IN NUMBER ,
c_category_code IN VARCHAR2,
c_reference_use_flag IN VARCHAR2,
c_tax_code IN VARCHAR2,
c_third_party_flag IN VARCHAR2,
c_competitor_flag IN VARCHAR2,
c_fob_point IN VARCHAR2,
c_tax_header_level_flag IN VARCHAR2,
c_tax_rounding_rule IN VARCHAR2,
c_account_name IN VARCHAR2,
c_freight_term IN VARCHAR2,
c_ship_partial IN VARCHAR2,
c_ship_via IN VARCHAR2,
c_warehouse_id IN NUMBER,
c_payment_term_id IN NUMBER ,
c_DATES_NEGATIVE_TOLERANCE IN NUMBER,
c_DATES_POSITIVE_TOLERANCE IN NUMBER,
c_DATE_TYPE_PREFERENCE IN VARCHAR2,
c_OVER_SHIPMENT_TOLERANCE IN NUMBER,
c_UNDER_SHIPMENT_TOLERANCE IN NUMBER,
c_ITEM_CROSS_REF_PREF IN VARCHAR2,
c_OVER_RETURN_TOLERANCE IN NUMBER,
c_UNDER_RETURN_TOLERANCE IN NUMBER,
c_SHIP_SETS_INCLUDE_LINES_FLAG IN VARCHAR2,
c_ARRIVALSETS_INCL_LINES_FLAG IN VARCHAR2,
c_SCHED_DATE_PUSH_FLAG IN VARCHAR2,
c_INVOICE_QUANTITY_RULE IN VARCHAR2,
t_party_id IN NUMBER ,
t_party_number IN OUT NOCOPY VARCHAR2,
t_customer_key IN VARCHAR2,
t_Attribute_Category IN VARCHAR2,
t_Attribute1 IN VARCHAR2,
t_Attribute2 IN VARCHAR2,
t_Attribute3 IN VARCHAR2,
t_Attribute4 IN VARCHAR2,
t_Attribute5 IN VARCHAR2,
t_Attribute6 IN VARCHAR2,
t_Attribute7 IN VARCHAR2,
t_Attribute8 IN VARCHAR2,
t_Attribute9 IN VARCHAR2,
t_Attribute10 IN VARCHAR2,
t_Attribute11 IN VARCHAR2,
t_Attribute12 IN VARCHAR2,
t_Attribute13 IN VARCHAR2,
t_Attribute14 IN VARCHAR2,
t_Attribute15 IN VARCHAR2,
t_Attribute16 IN VARCHAR2,
t_Attribute17 IN VARCHAR2,
t_Attribute18 IN VARCHAR2,
t_Attribute19 IN VARCHAR2,
t_Attribute20 IN VARCHAR2,
t_global_attribute_category IN VARCHAR2,
t_global_attribute1 IN VARCHAR2,
t_global_attribute2 IN VARCHAR2,
t_global_attribute3 IN VARCHAR2,
t_global_attribute4 IN VARCHAR2,
t_global_attribute5 IN VARCHAR2,
t_global_attribute6 IN VARCHAR2,
t_global_attribute7 IN VARCHAR2,
t_global_attribute8 IN VARCHAR2,
t_global_attribute9 IN VARCHAR2,
t_global_attribute10 IN VARCHAR2,
t_global_attribute11 IN VARCHAR2,
t_global_attribute12 IN VARCHAR2,
t_global_attribute13 IN VARCHAR2,
t_global_attribute14 IN VARCHAR2,
t_global_attribute15 IN VARCHAR2,
t_global_attribute16 IN VARCHAR2,
t_global_attribute17 IN VARCHAR2,
t_global_attribute18 IN VARCHAR2,
t_global_attribute19 IN VARCHAR2,
t_global_attribute20 IN VARCHAR2,
o_party_name IN VARCHAR2,
o_sic_code IN VARCHAR2,
o_sic_code_type IN VARCHAR2,
o_analysis_fy IN VARCHAR2,
o_fiscal_yearend_month IN VARCHAR2,
o_num_of_employees IN NUMBER ,
o_curr_fy_potential_revenue IN NUMBER ,
o_next_fy_potential_revenue IN NUMBER ,
o_tax_reference IN VARCHAR2,
o_year_established IN NUMBER ,
o_gsa_indicator_flag IN VARCHAR2,
o_mission_statement IN VARCHAR2,
o_duns_number IN NUMBER,
o_tax_name IN VARCHAR2,
o_organization_type IN VARCHAR2,
o_taxpayer_id IN VARCHAR2,
o_party_name_phonetic IN VARCHAR2,
p_cust_account_profile_id IN NUMBER ,
p_cust_account_id IN NUMBER ,
p_status IN VARCHAR2,
p_collector_id IN NUMBER ,
p_credit_analyst_id IN NUMBER ,
p_credit_checking IN VARCHAR2,
p_next_credit_review_date DATE ,
p_tolerance IN NUMBER,
p_discount_terms IN VARCHAR2,
p_dunning_letters IN VARCHAR2,
p_interest_charges IN VARCHAR2,
p_send_statements IN VARCHAR2,
p_credit_balance_statements IN VARCHAR2,
p_credit_hold IN VARCHAR2,
p_profile_class_id IN NUMBER ,
p_site_use_id IN NUMBER ,
p_credit_rating IN VARCHAR2,
p_risk_code IN VARCHAR2,
p_standard_terms IN NUMBER ,
p_override_terms IN VARCHAR2,
p_dunning_letter_set_id IN NUMBER,
p_interest_period_days IN NUMBER,
p_payment_grace_days IN NUMBER,
p_discount_grace_days IN NUMBER,
p_statement_cycle_id IN NUMBER ,
p_account_status IN VARCHAR2,
p_percent_collectable IN NUMBER ,
p_autocash_hierarchy_id IN NUMBER,
p_Attribute_Category IN VARCHAR2,
p_Attribute1 IN VARCHAR2,
p_Attribute2 IN VARCHAR2,
p_Attribute3 IN VARCHAR2,
p_Attribute4 IN VARCHAR2,
p_Attribute5 IN VARCHAR2,
p_Attribute6 IN VARCHAR2,
p_Attribute7 IN VARCHAR2,
p_Attribute8 IN VARCHAR2,
p_Attribute9 IN VARCHAR2,
p_Attribute10 IN VARCHAR2,
p_Attribute11 IN VARCHAR2,
p_Attribute12 IN VARCHAR2,
p_Attribute13 IN VARCHAR2,
p_Attribute14 IN VARCHAR2,
p_Attribute15 IN VARCHAR2,
p_auto_rec_incl_disputed_flag IN VARCHAR2,
p_tax_printing_option IN VARCHAR2,
p_charge_on_fin_charge_flag IN VARCHAR2,
p_grouping_rule_id IN NUMBER ,
p_clearing_days IN NUMBER,
p_jgzz_attribute_category IN VARCHAR2,
p_jgzz_attribute1 IN VARCHAR2,
p_jgzz_attribute2 IN VARCHAR2,
p_jgzz_attribute3 IN VARCHAR2,
p_jgzz_attribute4 IN VARCHAR2,
p_jgzz_attribute5 IN VARCHAR2,
p_jgzz_attribute6 IN VARCHAR2,
p_jgzz_attribute7 IN VARCHAR2,
p_jgzz_attribute8 IN VARCHAR2,
p_jgzz_attribute9 IN VARCHAR2,
p_jgzz_attribute10 IN VARCHAR2,
p_jgzz_attribute11 IN VARCHAR2,
p_jgzz_attribute12 IN VARCHAR2,
p_jgzz_attribute13 IN VARCHAR2,
p_jgzz_attribute14 IN VARCHAR2,
p_jgzz_attribute15 IN VARCHAR2,
p_global_attribute_category IN VARCHAR2,
p_global_attribute1 IN VARCHAR2,
p_global_attribute2 IN VARCHAR2,
p_global_attribute3 IN VARCHAR2,
p_global_attribute4 IN VARCHAR2,
p_global_attribute5 IN VARCHAR2,
p_global_attribute6 IN VARCHAR2,
p_global_attribute7 IN VARCHAR2,
p_global_attribute8 IN VARCHAR2,
p_global_attribute9 IN VARCHAR2,
p_global_attribute10 IN VARCHAR2,
p_global_attribute11 IN VARCHAR2,
p_global_attribute12 IN VARCHAR2,
p_global_attribute13 IN VARCHAR2,
p_global_attribute14 IN VARCHAR2,
p_global_attribute15 IN VARCHAR2,
p_global_attribute16 IN VARCHAR2,
p_global_attribute17 IN VARCHAR2,
p_global_attribute18 IN VARCHAR2,
p_global_attribute19 IN VARCHAR2,
p_global_attribute20 IN VARCHAR2,
p_cons_inv_flag IN VARCHAR2,
p_cons_inv_type IN VARCHAR2,
p_autocash_hier_id_for_adr IN NUMBER ,
p_lockbox_matching_option IN VARCHAR2,
--{2310474
p_party_id IN NUMBER DEFAULT NULL,
p_review_cycle IN VARCHAR2 DEFAULT NULL,
p_credit_classification IN VARCHAR2 DEFAULT NULL,
p_last_credit_review_date IN DATE DEFAULT NULL,
--}
o_organization_profile_id IN OUT NOCOPY NUMBER,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY varchar2,
x_return_status OUT NOCOPY VARCHAR2,
o_duns_number_c IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR )
IS
-- acct_rec hz_customer_accounts_pub.account_rec_type;
org_rec_update hz_party_v2pub.organization_rec_type;
l_party_last_update_date DATE;
x_party_last_update_date date;
X_PARTY_REL_LAST_UPDATE_DATE date;
object_version_select (
p_table_name => 'HZ_ORG_PERS',
p_col_id => C_Party_Id,
x_rowid => l_party_rowid,
x_object_version_number => l_party_object_version,
x_last_update_date => l_party_last_update_date,
x_id_value => l_dummy_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
org_rec_update.party_rec.category_code := INIT_SWITCH(C_Category_Code);
org_rec_update.party_rec.party_id := INIT_SWITCH(C_Party_Id);
org_rec_update.organization_name := INIT_SWITCH(o_party_name);
org_rec_update.sic_code := INIT_SWITCH(o_sic_code);
org_rec_update.sic_code_type := INIT_SWITCH(o_sic_code_type);
org_rec_update.analysis_fy := INIT_SWITCH(o_analysis_fy);
org_rec_update.fiscal_yearend_month := INIT_SWITCH(o_fiscal_yearend_month);
org_rec_update.employees_total := INIT_SWITCH(o_num_of_employees);
org_rec_update.curr_fy_potential_revenue := INIT_SWITCH(o_curr_fy_potential_revenue);
org_rec_update.next_fy_potential_revenue := INIT_SWITCH(o_next_fy_potential_revenue);
org_rec_update.year_established := INIT_SWITCH(o_year_established);
org_rec_update.gsa_indicator_flag := INIT_SWITCH(o_gsa_indicator_flag);
org_rec_update.jgzz_fiscal_code := INIT_SWITCH(o_taxpayer_id);
org_rec_update.mission_statement := INIT_SWITCH(o_mission_statement);
org_rec_update.organization_name_phonetic := INIT_SWITCH(o_party_name_phonetic);
org_rec_update.duns_number_c := INIT_SWITCH(o_duns_number_c);
org_rec_update.tax_reference := INIT_SWITCH(o_tax_reference);
org_rec_update.content_source_type := NVL(org_rec_update.content_source_type,'USER_ENTERED');
HZ_PARTY_V2PUB.update_organization (
p_organization_rec => org_rec_update,
p_party_object_version_number => l_party_object_version,
x_profile_id => o_organization_profile_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
END insert_row;
PROCEDURE insert_person_row(
c_cust_account_id IN OUT NOCOPY NUMBER ,
c_party_id IN OUT NOCOPY NUMBER,
c_account_number IN OUT NOCOPY VARCHAR2,
c_Attribute_Category IN VARCHAR2,
c_Attribute1 IN VARCHAR2,
c_Attribute2 IN VARCHAR2,
c_Attribute3 IN VARCHAR2,
c_Attribute4 IN VARCHAR2,
c_Attribute5 IN VARCHAR2,
c_Attribute6 IN VARCHAR2,
c_Attribute7 IN VARCHAR2,
c_Attribute8 IN VARCHAR2,
c_Attribute9 IN VARCHAR2,
c_Attribute10 IN VARCHAR2,
c_Attribute11 IN VARCHAR2,
c_Attribute12 IN VARCHAR2,
c_Attribute13 IN VARCHAR2,
c_Attribute14 IN VARCHAR2,
c_Attribute15 IN VARCHAR2,
c_Attribute16 IN VARCHAR2,
c_Attribute17 IN VARCHAR2,
c_Attribute18 IN VARCHAR2,
c_Attribute19 IN VARCHAR2,
c_Attribute20 IN VARCHAR2,
c_global_attribute_category IN VARCHAR2,
c_global_attribute1 IN VARCHAR2,
c_global_attribute2 IN VARCHAR2,
c_global_attribute3 IN VARCHAR2,
c_global_attribute4 IN VARCHAR2,
c_global_attribute5 IN VARCHAR2,
c_global_attribute6 IN VARCHAR2,
c_global_attribute7 IN VARCHAR2,
c_global_attribute8 IN VARCHAR2,
c_global_attribute9 IN VARCHAR2,
c_global_attribute10 IN VARCHAR2,
c_global_attribute11 IN VARCHAR2,
c_global_attribute12 IN VARCHAR2,
c_global_attribute13 IN VARCHAR2,
c_global_attribute14 IN VARCHAR2,
c_global_attribute15 IN VARCHAR2,
c_global_attribute16 IN VARCHAR2,
c_global_attribute17 IN VARCHAR2,
c_global_attribute18 IN VARCHAR2,
c_global_attribute19 IN VARCHAR2,
c_global_attribute20 IN VARCHAR2,
c_orig_system_reference IN VARCHAR2,
c_status IN VARCHAR2,
c_customer_type IN VARCHAR2,
c_customer_class_code IN VARCHAR2,
c_primary_salesrep_id IN NUMBER ,
c_sales_channel_code IN VARCHAR2,
c_order_type_id IN NUMBER,
c_price_list_id IN NUMBER ,
c_category_code IN VARCHAR2,
c_reference_use_flag IN VARCHAR2,
c_tax_code IN VARCHAR2,
c_third_party_flag IN VARCHAR2,
c_competitor_flag IN VARCHAR2,
c_fob_point IN VARCHAR2,
c_tax_header_level_flag IN VARCHAR2,
c_tax_rounding_rule IN VARCHAR2,
c_account_name IN VARCHAR2,
c_freight_term IN VARCHAR2,
c_ship_partial IN VARCHAR2,
c_ship_via IN VARCHAR2,
c_warehouse_id IN NUMBER,
c_payment_term_id IN NUMBER ,
c_DATES_NEGATIVE_TOLERANCE IN NUMBER,
c_DATES_POSITIVE_TOLERANCE IN NUMBER,
c_DATE_TYPE_PREFERENCE IN VARCHAR2,
c_OVER_SHIPMENT_TOLERANCE IN NUMBER,
c_UNDER_SHIPMENT_TOLERANCE IN NUMBER,
c_ITEM_CROSS_REF_PREF IN VARCHAR2,
c_OVER_RETURN_TOLERANCE IN NUMBER,
c_UNDER_RETURN_TOLERANCE IN NUMBER,
c_SHIP_SETS_INCLUDE_LINES_FLAG IN VARCHAR2,
c_ARRIVALSETS_INCL_LINES_FLAG IN VARCHAR2,
c_SCHED_DATE_PUSH_FLAG IN VARCHAR2,
c_INVOICE_QUANTITY_RULE IN VARCHAR2,
t_party_id IN NUMBER ,
t_party_number IN OUT NOCOPY VARCHAR2,
t_customer_key IN VARCHAR2,
t_Attribute_Category IN VARCHAR2,
t_Attribute1 IN VARCHAR2,
t_Attribute2 IN VARCHAR2,
t_Attribute3 IN VARCHAR2,
t_Attribute4 IN VARCHAR2,
t_Attribute5 IN VARCHAR2,
t_Attribute6 IN VARCHAR2,
t_Attribute7 IN VARCHAR2,
t_Attribute8 IN VARCHAR2,
t_Attribute9 IN VARCHAR2,
t_Attribute10 IN VARCHAR2,
t_Attribute11 IN VARCHAR2,
t_Attribute12 IN VARCHAR2,
t_Attribute13 IN VARCHAR2,
t_Attribute14 IN VARCHAR2,
t_Attribute15 IN VARCHAR2,
t_Attribute16 IN VARCHAR2,
t_Attribute17 IN VARCHAR2,
t_Attribute18 IN VARCHAR2,
t_Attribute19 IN VARCHAR2,
t_Attribute20 IN VARCHAR2,
t_global_attribute_category IN VARCHAR2,
t_global_attribute1 IN VARCHAR2,
t_global_attribute2 IN VARCHAR2,
t_global_attribute3 IN VARCHAR2,
t_global_attribute4 IN VARCHAR2,
t_global_attribute5 IN VARCHAR2,
t_global_attribute6 IN VARCHAR2,
t_global_attribute7 IN VARCHAR2,
t_global_attribute8 IN VARCHAR2,
t_global_attribute9 IN VARCHAR2,
t_global_attribute10 IN VARCHAR2,
t_global_attribute11 IN VARCHAR2,
t_global_attribute12 IN VARCHAR2,
t_global_attribute13 IN VARCHAR2,
t_global_attribute14 IN VARCHAR2,
t_global_attribute15 IN VARCHAR2,
t_global_attribute16 IN VARCHAR2,
t_global_attribute17 IN VARCHAR2,
t_global_attribute18 IN VARCHAR2,
t_global_attribute19 IN VARCHAR2,
t_global_attribute20 IN VARCHAR2,
o_pre_name_adjunct IN VARCHAR2,
o_first_name IN VARCHAR2,
o_middle_name IN VARCHAR2,
o_last_name IN VARCHAR2,
o_name_suffix IN VARCHAR2,
o_tax_reference IN VARCHAR2,
o_taxpayer_id IN VARCHAR2,
o_party_name_phonetic IN VARCHAR2,
p_cust_account_profile_id IN NUMBER ,
p_cust_account_id IN NUMBER ,
p_status IN VARCHAR2,
p_collector_id IN NUMBER ,
p_credit_analyst_id IN NUMBER ,
p_credit_checking IN VARCHAR2,
p_next_credit_review_date DATE ,
p_tolerance IN NUMBER,
p_discount_terms IN VARCHAR2,
p_dunning_letters IN VARCHAR2,
p_interest_charges IN VARCHAR2,
p_send_statements IN VARCHAR2,
p_credit_balance_statements IN VARCHAR2,
p_credit_hold IN VARCHAR2,
p_profile_class_id IN NUMBER ,
p_site_use_id IN NUMBER ,
p_credit_rating IN VARCHAR2,
p_risk_code IN VARCHAR2,
p_standard_terms IN NUMBER ,
p_override_terms IN VARCHAR2,
p_dunning_letter_set_id IN NUMBER,
p_interest_period_days IN NUMBER,
p_payment_grace_days IN NUMBER,
p_discount_grace_days IN NUMBER,
p_statement_cycle_id IN NUMBER ,
p_account_status IN VARCHAR2,
p_percent_collectable IN NUMBER ,
p_autocash_hierarchy_id IN NUMBER,
p_Attribute_Category IN VARCHAR2,
p_Attribute1 IN VARCHAR2,
p_Attribute2 IN VARCHAR2,
p_Attribute3 IN VARCHAR2,
p_Attribute4 IN VARCHAR2,
p_Attribute5 IN VARCHAR2,
p_Attribute6 IN VARCHAR2,
p_Attribute7 IN VARCHAR2,
p_Attribute8 IN VARCHAR2,
p_Attribute9 IN VARCHAR2,
p_Attribute10 IN VARCHAR2,
p_Attribute11 IN VARCHAR2,
p_Attribute12 IN VARCHAR2,
p_Attribute13 IN VARCHAR2,
p_Attribute14 IN VARCHAR2,
p_Attribute15 IN VARCHAR2,
p_auto_rec_incl_disputed_flag IN VARCHAR2,
p_tax_printing_option IN VARCHAR2,
p_charge_on_fin_charge_flag IN VARCHAR2,
p_grouping_rule_id IN NUMBER ,
p_clearing_days IN NUMBER,
p_jgzz_attribute_category IN VARCHAR2,
p_jgzz_attribute1 IN VARCHAR2,
p_jgzz_attribute2 IN VARCHAR2,
p_jgzz_attribute3 IN VARCHAR2,
p_jgzz_attribute4 IN VARCHAR2,
p_jgzz_attribute5 IN VARCHAR2,
p_jgzz_attribute6 IN VARCHAR2,
p_jgzz_attribute7 IN VARCHAR2,
p_jgzz_attribute8 IN VARCHAR2,
p_jgzz_attribute9 IN VARCHAR2,
p_jgzz_attribute10 IN VARCHAR2,
p_jgzz_attribute11 IN VARCHAR2,
p_jgzz_attribute12 IN VARCHAR2,
p_jgzz_attribute13 IN VARCHAR2,
p_jgzz_attribute14 IN VARCHAR2,
p_jgzz_attribute15 IN VARCHAR2,
p_global_attribute_category IN VARCHAR2,
p_global_attribute1 IN VARCHAR2,
p_global_attribute2 IN VARCHAR2,
p_global_attribute3 IN VARCHAR2,
p_global_attribute4 IN VARCHAR2,
p_global_attribute5 IN VARCHAR2,
p_global_attribute6 IN VARCHAR2,
p_global_attribute7 IN VARCHAR2,
p_global_attribute8 IN VARCHAR2,
p_global_attribute9 IN VARCHAR2,
p_global_attribute10 IN VARCHAR2,
p_global_attribute11 IN VARCHAR2,
p_global_attribute12 IN VARCHAR2,
p_global_attribute13 IN VARCHAR2,
p_global_attribute14 IN VARCHAR2,
p_global_attribute15 IN VARCHAR2,
p_global_attribute16 IN VARCHAR2,
p_global_attribute17 IN VARCHAR2,
p_global_attribute18 IN VARCHAR2,
p_global_attribute19 IN VARCHAR2,
p_global_attribute20 IN VARCHAR2,
p_cons_inv_flag IN VARCHAR2,
p_cons_inv_type IN VARCHAR2,
p_autocash_hier_id_for_adr IN NUMBER ,
p_lockbox_matching_option IN VARCHAR2,
--{2310474
p_party_id IN NUMBER DEFAULT NULL,
p_review_cycle IN VARCHAR2 DEFAULT NULL,
p_credit_classification IN VARCHAR2 DEFAULT NULL,
p_last_credit_review_date IN DATE DEFAULT NULL,
-- }
o_person_profile_id IN OUT NOCOPY number,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY varchar2,
x_return_status OUT NOCOPY VARCHAR2)
IS
-- acct_rec hz_customer_accounts_pub.account_rec_type;
person_rec_update hz_party_v2pub.person_rec_type;
x_party_last_update_date date;
X_PARTY_REL_LAST_UPDATE_DATE date;
l_party_last_update_date DATE;
object_version_select (
p_table_name => 'HZ_ORG_PERS',
p_col_id => C_Party_Id,
x_rowid => l_party_rowid,
x_object_version_number => l_party_object_version,
x_last_update_date => l_party_last_update_date,
x_id_value => l_dummy_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
person_rec_update.party_rec.party_id := INIT_SWITCH(C_Party_Id);
person_rec_update.party_rec.category_code := INIT_SWITCH(C_Category_Code);
person_rec_update.person_name_phonetic := INIT_SWITCH(o_party_name_phonetic);
person_rec_update.person_pre_name_adjunct := INIT_SWITCH(o_pre_name_adjunct);
person_rec_update.person_first_name := INIT_SWITCH(o_first_name);
person_rec_update.person_middle_name := INIT_SWITCH(o_middle_name);
person_rec_update.person_last_name := INIT_SWITCH(o_last_name);
person_rec_update.person_name_suffix := INIT_SWITCH(o_name_suffix);
person_rec_update.tax_reference := INIT_SWITCH(o_tax_reference);
person_rec_update.jgzz_fiscal_code := INIT_SWITCH(o_taxpayer_id);
person_rec_update.content_source_type := NVL(person_rec_update.content_source_type,'USER_ENTERED');
HZ_PARTY_V2PUB.update_person (
p_person_rec => person_rec_update,
p_party_object_version_number => l_party_object_version,
x_profile_id => o_person_profile_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
END insert_person_row;
PROCEDURE update_row(
c_cust_account_id IN OUT NOCOPY NUMBER ,
c_party_id IN NUMBER,
c_account_number IN VARCHAR2,
c_Attribute_Category IN VARCHAR2,
c_Attribute1 IN VARCHAR2,
c_Attribute2 IN VARCHAR2,
c_Attribute3 IN VARCHAR2,
c_Attribute4 IN VARCHAR2,
c_Attribute5 IN VARCHAR2,
c_Attribute6 IN VARCHAR2,
c_Attribute7 IN VARCHAR2,
c_Attribute8 IN VARCHAR2,
c_Attribute9 IN VARCHAR2,
c_Attribute10 IN VARCHAR2,
c_Attribute11 IN VARCHAR2,
c_Attribute12 IN VARCHAR2,
c_Attribute13 IN VARCHAR2,
c_Attribute14 IN VARCHAR2,
c_Attribute15 IN VARCHAR2,
c_Attribute16 IN VARCHAR2,
c_Attribute17 IN VARCHAR2,
c_Attribute18 IN VARCHAR2,
c_Attribute19 IN VARCHAR2,
c_Attribute20 IN VARCHAR2,
c_global_attribute_category IN VARCHAR2,
c_global_attribute1 IN VARCHAR2,
c_global_attribute2 IN VARCHAR2,
c_global_attribute3 IN VARCHAR2,
c_global_attribute4 IN VARCHAR2,
c_global_attribute5 IN VARCHAR2,
c_global_attribute6 IN VARCHAR2,
c_global_attribute7 IN VARCHAR2,
c_global_attribute8 IN VARCHAR2,
c_global_attribute9 IN VARCHAR2,
c_global_attribute10 IN VARCHAR2,
c_global_attribute11 IN VARCHAR2,
c_global_attribute12 IN VARCHAR2,
c_global_attribute13 IN VARCHAR2,
c_global_attribute14 IN VARCHAR2,
c_global_attribute15 IN VARCHAR2,
c_global_attribute16 IN VARCHAR2,
c_global_attribute17 IN VARCHAR2,
c_global_attribute18 IN VARCHAR2,
c_global_attribute19 IN VARCHAR2,
c_global_attribute20 IN VARCHAR2,
c_orig_system_reference IN VARCHAR2,
c_status IN VARCHAR2,
c_customer_type IN VARCHAR2,
c_customer_class_code IN VARCHAR2,
c_primary_salesrep_id IN NUMBER ,
c_sales_channel_code IN VARCHAR2,
c_order_type_id IN NUMBER,
c_price_list_id IN NUMBER ,
c_category_code IN VARCHAR2,
c_reference_use_flag IN VARCHAR2,
c_tax_code IN VARCHAR2,
c_third_party_flag IN VARCHAR2,
c_competitor_flag IN VARCHAR2,
c_fob_point IN VARCHAR2,
c_tax_header_level_flag IN VARCHAR2,
c_tax_rounding_rule IN VARCHAR2,
c_account_name IN VARCHAR2,
c_freight_term IN VARCHAR2,
c_ship_partial IN VARCHAR2,
c_ship_via IN VARCHAR2,
c_warehouse_id IN NUMBER,
c_payment_term_id IN NUMBER ,
c_analysis_fy IN VARCHAR2,
c_fiscal_yearend_month IN VARCHAR2,
c_employees_total IN NUMBER,
c_cr_fy_potential_revenue IN NUMBER,
c_next_fy_potential_revenue IN NUMBER,
c_tax_reference IN VARCHAR2,
c_year_established IN NUMBER,
c_gsa_indicator_flag IN VARCHAR2,
c_jgzz_fiscal_code IN VARCHAR2,
c_do_not_mail_flag IN VARCHAR2,
c_mission_statement IN VARCHAR2,
c_org_name_phonetic IN VARCHAR2,
c_url IN VARCHAR2,
c_person_suffix IN VARCHAR2,
c_first_name IN VARCHAR2,
c_middle_name IN VARCHAR2,
c_last_name IN VARCHAR2,
c_person_prefix IN VARCHAR2,
c_sic_code IN VARCHAR2,
c_sic_code_type IN VARCHAR2,
c_duns_number IN NUMBER,
c_DATES_NEGATIVE_TOLERANCE IN NUMBER,
c_DATES_POSITIVE_TOLERANCE IN NUMBER,
c_DATE_TYPE_PREFERENCE IN VARCHAR2,
c_OVER_SHIPMENT_TOLERANCE IN NUMBER,
c_UNDER_SHIPMENT_TOLERANCE IN NUMBER,
c_ITEM_CROSS_REF_PREF IN VARCHAR2,
c_OVER_RETURN_TOLERANCE IN NUMBER,
c_UNDER_RETURN_TOLERANCE IN NUMBER,
c_SHIP_SETS_INCLUDE_LINES_FLAG IN VARCHAR2,
c_ARRIVALSETS_INCL_LINES_FLAG IN VARCHAR2,
c_SCHED_DATE_PUSH_FLAG IN VARCHAR2,
c_INVOICE_QUANTITY_RULE IN VARCHAR2,
c_account_alias IN VARCHAR2 DEFAULT NULL,
p_cust_account_profile_id IN NUMBER ,
p_cust_account_id IN NUMBER ,
p_status IN VARCHAR2,
p_collector_id IN NUMBER ,
p_credit_analyst_id IN NUMBER ,
p_credit_checking IN VARCHAR2,
p_next_credit_review_date DATE ,
p_tolerance IN NUMBER,
p_discount_terms IN VARCHAR2,
p_dunning_letters IN VARCHAR2,
p_interest_charges IN VARCHAR2,
p_send_statements IN VARCHAR2,
p_credit_balance_statements IN VARCHAR2,
p_credit_hold IN VARCHAR2,
p_profile_class_id IN NUMBER ,
p_site_use_id IN NUMBER ,
p_credit_rating IN VARCHAR2,
p_risk_code IN VARCHAR2,
p_standard_terms IN NUMBER ,
p_override_terms IN VARCHAR2,
p_dunning_letter_set_id IN NUMBER,
p_interest_period_days IN NUMBER,
p_payment_grace_days IN NUMBER,
p_discount_grace_days IN NUMBER,
p_statement_cycle_id IN NUMBER ,
p_account_status IN VARCHAR2,
p_percent_collectable IN NUMBER ,
p_autocash_hierarchy_id IN NUMBER,
p_Attribute_Category IN VARCHAR2,
p_Attribute1 IN VARCHAR2,
p_Attribute2 IN VARCHAR2,
p_Attribute3 IN VARCHAR2,
p_Attribute4 IN VARCHAR2,
p_Attribute5 IN VARCHAR2,
p_Attribute6 IN VARCHAR2,
p_Attribute7 IN VARCHAR2,
p_Attribute8 IN VARCHAR2,
p_Attribute9 IN VARCHAR2,
p_Attribute10 IN VARCHAR2,
p_Attribute11 IN VARCHAR2,
p_Attribute12 IN VARCHAR2,
p_Attribute13 IN VARCHAR2,
p_Attribute14 IN VARCHAR2,
p_Attribute15 IN VARCHAR2,
p_auto_rec_incl_disputed_flag IN VARCHAR2,
p_tax_printing_option IN VARCHAR2,
p_charge_on_fin_charge_flag IN VARCHAR2,
p_grouping_rule_id IN NUMBER ,
p_clearing_days IN NUMBER,
p_jgzz_attribute_category IN VARCHAR2,
p_jgzz_attribute1 IN VARCHAR2,
p_jgzz_attribute2 IN VARCHAR2,
p_jgzz_attribute3 IN VARCHAR2,
p_jgzz_attribute4 IN VARCHAR2,
p_jgzz_attribute5 IN VARCHAR2,
p_jgzz_attribute6 IN VARCHAR2,
p_jgzz_attribute7 IN VARCHAR2,
p_jgzz_attribute8 IN VARCHAR2,
p_jgzz_attribute9 IN VARCHAR2,
p_jgzz_attribute10 IN VARCHAR2,
p_jgzz_attribute11 IN VARCHAR2,
p_jgzz_attribute12 IN VARCHAR2,
p_jgzz_attribute13 IN VARCHAR2,
p_jgzz_attribute14 IN VARCHAR2,
p_jgzz_attribute15 IN VARCHAR2,
p_global_attribute_category IN VARCHAR2,
p_global_attribute1 IN VARCHAR2,
p_global_attribute2 IN VARCHAR2,
p_global_attribute3 IN VARCHAR2,
p_global_attribute4 IN VARCHAR2,
p_global_attribute5 IN VARCHAR2,
p_global_attribute6 IN VARCHAR2,
p_global_attribute7 IN VARCHAR2,
p_global_attribute8 IN VARCHAR2,
p_global_attribute9 IN VARCHAR2,
p_global_attribute10 IN VARCHAR2,
p_global_attribute11 IN VARCHAR2,
p_global_attribute12 IN VARCHAR2,
p_global_attribute13 IN VARCHAR2,
p_global_attribute14 IN VARCHAR2,
p_global_attribute15 IN VARCHAR2,
p_global_attribute16 IN VARCHAR2,
p_global_attribute17 IN VARCHAR2,
p_global_attribute18 IN VARCHAR2,
p_global_attribute19 IN VARCHAR2,
p_global_attribute20 IN VARCHAR2,
p_cons_inv_flag IN VARCHAR2,
p_cons_inv_type IN VARCHAR2,
p_autocash_hier_id_for_adr IN NUMBER ,
p_lockbox_matching_option IN VARCHAR2,
--{2310474
p_party_id IN NUMBER DEFAULT NULL,
p_review_cycle IN VARCHAR2 DEFAULT NULL,
p_credit_classification IN VARCHAR2 DEFAULT NULL,
p_last_credit_review_date IN DATE DEFAULT NULL,
--}
a_last_update_date IN OUT NOCOPY DATE,
a_object_version IN OUT NOCOPY NUMBER,
p_last_update_date IN OUT NOCOPY DATE,
x_cr_last_update_date IN OUT NOCOPY DATE,
x_pt_last_update_date IN OUT NOCOPY DATE,
x_cp_last_update_date IN OUT NOCOPY DATE,
x_op_last_update_date IN OUT NOCOPY DATE,
x_pp_last_update_date IN OUT NOCOPY DATE,
x_account_type IN VARCHAR,
o_organization_profile_id in out NOCOPY number,
o_person_profile_id in out NOCOPY number,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY varchar2,
x_return_status OUT NOCOPY VARCHAR2,
c_duns_number_c IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
x_cust_acct_object_version IN NUMBER DEFAULT -1,
x_cust_prof_object_version IN NUMBER DEFAULT -1,
x_party_object_version IN NUMBER DEFAULT -1)
IS
-- acct_rec hz_customer_accounts_pub.account_rec_type;
x_party_rel_last_update_date DATE;
x_party_last_update_date DATE;
select relationship_id
from hz_relationships
where subject_id = c_party_id
and relationship_code = 'REFERENCE_FOR'
and subject_table_name = 'HZ_PARTIES'
and object_table_name = 'HZ_PARTIES'
and directional_flag = 'F';
select relationship_id
from hz_relationships
where subject_id = c_party_id
and relationship_code = 'PARTNER_OF'
and subject_table_name = 'HZ_PARTIES'
and object_table_name = 'HZ_PARTIES'
and directional_flag = 'F';
select relationship_id
from hz_relationships
where subject_id = c_party_id
and relationship_code = 'COMPETITOR_OF'
and subject_table_name = 'HZ_PARTIES'
and object_table_name = 'HZ_PARTIES'
and directional_flag = 'F';
SELECT ROWID,
OBJECT_VERSION_NUMBER,
LAST_UPDATE_DATE
FROM HZ_CUST_ACCOUNTS
WHERE CUST_ACCOUNT_ID = c_cust_account_id;
SELECT ROWID,
OBJECT_VERSION_NUMBER,
LAST_UPDATE_DATE,
CUST_ACCOUNT_ID
FROM HZ_CUSTOMER_PROFILES
WHERE CUST_ACCOUNT_PROFILE_ID = p_cust_account_profile_id;
l_cust_acct_last_update_date DATE;
l_cust_prof_last_update_date DATE;
l_party_last_update_date DATE;
IF (a_last_update_date IS NOT NULL ) THEN
--
l_cust_acct_object_version := x_cust_acct_object_version;
object_version_select (
p_table_name => 'HZ_CUST_ACCOUNTS',
p_col_id => c_cust_account_id,
x_rowid => l_cust_acct_rowid,
x_object_version_number => l_cust_acct_object_version,
x_last_update_date => l_cust_acct_last_update_date,
x_id_value => l_dummy_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
HZ_CUST_ACCOUNT_V2PUB.update_cust_account (
p_cust_account_rec => acct_rec,
p_object_version_number => l_cust_acct_object_version,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
SELECT last_update_date,
object_version_number
INTO a_last_update_date,
a_object_version
FROM hz_cust_accounts
WHERE cust_account_id = c_cust_account_id;
IF (p_last_update_date is not null) THEN
l_cust_prof_object_version := x_cust_prof_object_version;
object_version_select(
p_table_name => 'HZ_CUSTOMER_PROFILES',
p_col_id => p_cust_account_profile_id,
x_rowid => l_cust_prof_rowid,
x_object_version_number => l_cust_prof_object_version,
x_last_update_date => l_cust_prof_last_update_date,
x_id_value => l_cust_acct_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data );
HZ_CUSTOMER_PROFILE_V2PUB.update_customer_profile (
p_customer_profile_rec => prof_rec,
p_object_version_number => l_cust_prof_object_version,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
SELECT last_update_date INTO p_last_update_date
FROM hz_customer_profiles
WHERE cust_account_profile_id = p_cust_account_profile_id;
object_version_select (
p_table_name => 'HZ_ORG_PERS',
p_col_id => C_Party_Id,
x_rowid => l_party_rowid,
x_object_version_number => l_party_object_version,
x_last_update_date => l_party_last_update_date,
x_id_value => l_dummy_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
HZ_PARTY_V2PUB.update_organization (
p_organization_rec => org_rec,
p_party_object_version_number => l_party_object_version,
x_profile_id => o_organization_profile_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
SELECT last_update_date INTO x_op_last_update_date
FROM hz_organization_profiles
WHERE party_id = c_party_id
AND content_source_type = 'USER_ENTERED'
AND organization_profile_id = o_organization_profile_id;
SELECT last_update_date INTO x_pt_last_update_date
FROM hz_parties
WHERE party_id = c_party_id;
HZ_PARTY_V2PUB.update_person (
p_person_rec => person_rec,
p_party_object_version_number => l_party_object_version,
x_profile_id => o_person_profile_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
SELECT last_update_date
INTO x_pp_last_update_date
FROM hz_person_profiles
WHERE party_id = c_party_id
AND content_source_type = 'USER_ENTERED'
AND person_profile_id = o_person_profile_id;
SELECT last_update_date
INTO x_pt_last_update_date
FROM hz_parties
WHERE party_id = c_party_id;
x_party_last_update_date := x_pt_last_update_date;
END update_row;
PROCEDURE update_row(
c_cust_account_id IN OUT NOCOPY NUMBER ,
c_party_id IN NUMBER,
c_account_number IN VARCHAR2,
c_Attribute_Category IN VARCHAR2,
c_Attribute1 IN VARCHAR2,
c_Attribute2 IN VARCHAR2,
c_Attribute3 IN VARCHAR2,
c_Attribute4 IN VARCHAR2,
c_Attribute5 IN VARCHAR2,
c_Attribute6 IN VARCHAR2,
c_Attribute7 IN VARCHAR2,
c_Attribute8 IN VARCHAR2,
c_Attribute9 IN VARCHAR2,
c_Attribute10 IN VARCHAR2,
c_Attribute11 IN VARCHAR2,
c_Attribute12 IN VARCHAR2,
c_Attribute13 IN VARCHAR2,
c_Attribute14 IN VARCHAR2,
c_Attribute15 IN VARCHAR2,
c_Attribute16 IN VARCHAR2,
c_Attribute17 IN VARCHAR2,
c_Attribute18 IN VARCHAR2,
c_Attribute19 IN VARCHAR2,
c_Attribute20 IN VARCHAR2,
c_global_attribute_category IN VARCHAR2,
c_global_attribute1 IN VARCHAR2,
c_global_attribute2 IN VARCHAR2,
c_global_attribute3 IN VARCHAR2,
c_global_attribute4 IN VARCHAR2,
c_global_attribute5 IN VARCHAR2,
c_global_attribute6 IN VARCHAR2,
c_global_attribute7 IN VARCHAR2,
c_global_attribute8 IN VARCHAR2,
c_global_attribute9 IN VARCHAR2,
c_global_attribute10 IN VARCHAR2,
c_global_attribute11 IN VARCHAR2,
c_global_attribute12 IN VARCHAR2,
c_global_attribute13 IN VARCHAR2,
c_global_attribute14 IN VARCHAR2,
c_global_attribute15 IN VARCHAR2,
c_global_attribute16 IN VARCHAR2,
c_global_attribute17 IN VARCHAR2,
c_global_attribute18 IN VARCHAR2,
c_global_attribute19 IN VARCHAR2,
c_global_attribute20 IN VARCHAR2,
c_orig_system_reference IN VARCHAR2,
c_status IN VARCHAR2,
c_customer_type IN VARCHAR2,
c_customer_class_code IN VARCHAR2,
c_primary_salesrep_id IN NUMBER ,
c_sales_channel_code IN VARCHAR2,
c_order_type_id IN NUMBER,
c_price_list_id IN NUMBER ,
c_category_code IN VARCHAR2,
c_reference_use_flag IN VARCHAR2,
c_tax_code IN VARCHAR2,
c_third_party_flag IN VARCHAR2,
c_competitor_flag IN VARCHAR2,
c_fob_point IN VARCHAR2,
c_tax_header_level_flag IN VARCHAR2,
c_tax_rounding_rule IN VARCHAR2,
c_account_name IN VARCHAR2,
c_freight_term IN VARCHAR2,
c_ship_partial IN VARCHAR2,
c_ship_via IN VARCHAR2,
c_warehouse_id IN NUMBER,
c_payment_term_id IN NUMBER ,
c_analysis_fy IN VARCHAR2,
c_fiscal_yearend_month IN VARCHAR2,
c_employees_total IN NUMBER,
c_cr_fy_potential_revenue IN NUMBER,
c_next_fy_potential_revenue IN NUMBER,
c_tax_reference IN VARCHAR2,
c_year_established IN NUMBER,
c_gsa_indicator_flag IN VARCHAR2,
c_jgzz_fiscal_code IN VARCHAR2,
c_do_not_mail_flag IN VARCHAR2,
c_mission_statement IN VARCHAR2,
c_org_name_phonetic IN VARCHAR2,
c_url IN VARCHAR2,
c_person_suffix IN VARCHAR2,
c_first_name IN VARCHAR2,
c_middle_name IN VARCHAR2,
c_last_name IN VARCHAR2,
c_person_prefix IN VARCHAR2,
c_sic_code IN VARCHAR2,
c_sic_code_type IN VARCHAR2,
c_duns_number IN NUMBER,
c_DATES_NEGATIVE_TOLERANCE IN NUMBER,
c_DATES_POSITIVE_TOLERANCE IN NUMBER,
c_DATE_TYPE_PREFERENCE IN VARCHAR2,
c_OVER_SHIPMENT_TOLERANCE IN NUMBER,
c_UNDER_SHIPMENT_TOLERANCE IN NUMBER,
c_ITEM_CROSS_REF_PREF IN VARCHAR2,
c_OVER_RETURN_TOLERANCE IN NUMBER,
c_UNDER_RETURN_TOLERANCE IN NUMBER,
c_SHIP_SETS_INCLUDE_LINES_FLAG IN VARCHAR2,
c_ARRIVALSETS_INCL_LINES_FLAG IN VARCHAR2,
c_SCHED_DATE_PUSH_FLAG IN VARCHAR2,
c_INVOICE_QUANTITY_RULE IN VARCHAR2,
c_account_alias IN VARCHAR2 DEFAULT NULL,
p_cust_account_profile_id IN NUMBER ,
p_cust_account_id IN NUMBER ,
p_status IN VARCHAR2,
p_collector_id IN NUMBER ,
p_credit_analyst_id IN NUMBER ,
p_credit_checking IN VARCHAR2,
p_next_credit_review_date DATE ,
p_tolerance IN NUMBER,
p_discount_terms IN VARCHAR2,
p_dunning_letters IN VARCHAR2,
p_interest_charges IN VARCHAR2,
p_send_statements IN VARCHAR2,
p_credit_balance_statements IN VARCHAR2,
p_credit_hold IN VARCHAR2,
p_profile_class_id IN NUMBER ,
p_site_use_id IN NUMBER ,
p_credit_rating IN VARCHAR2,
p_risk_code IN VARCHAR2,
p_standard_terms IN NUMBER ,
p_override_terms IN VARCHAR2,
p_dunning_letter_set_id IN NUMBER,
p_interest_period_days IN NUMBER,
p_payment_grace_days IN NUMBER,
p_discount_grace_days IN NUMBER,
p_statement_cycle_id IN NUMBER ,
p_account_status IN VARCHAR2,
p_percent_collectable IN NUMBER ,
p_autocash_hierarchy_id IN NUMBER,
p_Attribute_Category IN VARCHAR2,
p_Attribute1 IN VARCHAR2,
p_Attribute2 IN VARCHAR2,
p_Attribute3 IN VARCHAR2,
p_Attribute4 IN VARCHAR2,
p_Attribute5 IN VARCHAR2,
p_Attribute6 IN VARCHAR2,
p_Attribute7 IN VARCHAR2,
p_Attribute8 IN VARCHAR2,
p_Attribute9 IN VARCHAR2,
p_Attribute10 IN VARCHAR2,
p_Attribute11 IN VARCHAR2,
p_Attribute12 IN VARCHAR2,
p_Attribute13 IN VARCHAR2,
p_Attribute14 IN VARCHAR2,
p_Attribute15 IN VARCHAR2,
p_auto_rec_incl_disputed_flag IN VARCHAR2,
p_tax_printing_option IN VARCHAR2,
p_charge_on_fin_charge_flag IN VARCHAR2,
p_grouping_rule_id IN NUMBER ,
p_clearing_days IN NUMBER,
p_jgzz_attribute_category IN VARCHAR2,
p_jgzz_attribute1 IN VARCHAR2,
p_jgzz_attribute2 IN VARCHAR2,
p_jgzz_attribute3 IN VARCHAR2,
p_jgzz_attribute4 IN VARCHAR2,
p_jgzz_attribute5 IN VARCHAR2,
p_jgzz_attribute6 IN VARCHAR2,
p_jgzz_attribute7 IN VARCHAR2,
p_jgzz_attribute8 IN VARCHAR2,
p_jgzz_attribute9 IN VARCHAR2,
p_jgzz_attribute10 IN VARCHAR2,
p_jgzz_attribute11 IN VARCHAR2,
p_jgzz_attribute12 IN VARCHAR2,
p_jgzz_attribute13 IN VARCHAR2,
p_jgzz_attribute14 IN VARCHAR2,
p_jgzz_attribute15 IN VARCHAR2,
p_global_attribute_category IN VARCHAR2,
p_global_attribute1 IN VARCHAR2,
p_global_attribute2 IN VARCHAR2,
p_global_attribute3 IN VARCHAR2,
p_global_attribute4 IN VARCHAR2,
p_global_attribute5 IN VARCHAR2,
p_global_attribute6 IN VARCHAR2,
p_global_attribute7 IN VARCHAR2,
p_global_attribute8 IN VARCHAR2,
p_global_attribute9 IN VARCHAR2,
p_global_attribute10 IN VARCHAR2,
p_global_attribute11 IN VARCHAR2,
p_global_attribute12 IN VARCHAR2,
p_global_attribute13 IN VARCHAR2,
p_global_attribute14 IN VARCHAR2,
p_global_attribute15 IN VARCHAR2,
p_global_attribute16 IN VARCHAR2,
p_global_attribute17 IN VARCHAR2,
p_global_attribute18 IN VARCHAR2,
p_global_attribute19 IN VARCHAR2,
p_global_attribute20 IN VARCHAR2,
p_cons_inv_flag IN VARCHAR2,
p_cons_inv_type IN VARCHAR2,
p_autocash_hier_id_for_adr IN NUMBER ,
p_lockbox_matching_option IN VARCHAR2,
--{2310474
p_party_id IN NUMBER DEFAULT NULL,
p_review_cycle IN VARCHAR2 DEFAULT NULL,
p_credit_classification IN VARCHAR2 DEFAULT NULL,
p_last_credit_review_date IN DATE DEFAULT NULL,
--}
a_last_update_date IN OUT NOCOPY DATE,
p_last_update_date IN OUT NOCOPY DATE,
x_cr_last_update_date IN OUT NOCOPY DATE,
x_pt_last_update_date IN OUT NOCOPY DATE,
x_cp_last_update_date IN OUT NOCOPY DATE,
x_op_last_update_date IN OUT NOCOPY DATE,
x_pp_last_update_date IN OUT NOCOPY DATE,
x_account_type IN VARCHAR,
o_organization_profile_id in out NOCOPY number,
o_person_profile_id in out NOCOPY number,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY varchar2,
x_return_status OUT NOCOPY VARCHAR2,
c_duns_number_c IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
x_cust_acct_object_version IN NUMBER DEFAULT -1,
x_cust_prof_object_version IN NUMBER DEFAULT -1,
x_party_object_version IN NUMBER DEFAULT -1)
IS
l_object_version number;
update_row(
c_cust_account_id ,
c_party_id ,
c_account_number ,
c_Attribute_Category ,
c_Attribute1 ,
c_Attribute2 ,
c_Attribute3 ,
c_Attribute4 ,
c_Attribute5 ,
c_Attribute6 ,
c_Attribute7 ,
c_Attribute8 ,
c_Attribute9 ,
c_Attribute10 ,
c_Attribute11 ,
c_Attribute12 ,
c_Attribute13 ,
c_Attribute14 ,
c_Attribute15 ,
c_Attribute16 ,
c_Attribute17 ,
c_Attribute18 ,
c_Attribute19 ,
c_Attribute20 ,
c_global_attribute_category,
c_global_attribute1 ,
c_global_attribute2 ,
c_global_attribute3 ,
c_global_attribute4 ,
c_global_attribute5 ,
c_global_attribute6 ,
c_global_attribute7 ,
c_global_attribute8 ,
c_global_attribute9 ,
c_global_attribute10 ,
c_global_attribute11 ,
c_global_attribute12 ,
c_global_attribute13 ,
c_global_attribute14 ,
c_global_attribute15 ,
c_global_attribute16 ,
c_global_attribute17 ,
c_global_attribute18 ,
c_global_attribute19 ,
c_global_attribute20 ,
c_orig_system_reference ,
c_status ,
c_customer_type ,
c_customer_class_code,
c_primary_salesrep_id,
c_sales_channel_code ,
c_order_type_id ,
c_price_list_id ,
c_category_code ,
c_reference_use_flag ,
c_tax_code ,
c_third_party_flag ,
c_competitor_flag ,
c_fob_point ,
c_tax_header_level_flag,
c_tax_rounding_rule ,
c_account_name ,
c_freight_term ,
c_ship_partial ,
c_ship_via ,
c_warehouse_id ,
c_payment_term_id ,
c_analysis_fy ,
c_fiscal_yearend_month,
c_employees_total ,
c_cr_fy_potential_revenue,
c_next_fy_potential_revenue,
c_tax_reference ,
c_year_established ,
c_gsa_indicator_flag ,
c_jgzz_fiscal_code ,
c_do_not_mail_flag ,
c_mission_statement ,
c_org_name_phonetic ,
c_url ,
c_person_suffix ,
c_first_name ,
c_middle_name ,
c_last_name ,
c_person_prefix ,
c_sic_code ,
c_sic_code_type ,
c_duns_number ,
c_DATES_NEGATIVE_TOLERANCE,
c_DATES_POSITIVE_TOLERANCE,
c_DATE_TYPE_PREFERENCE,
c_OVER_SHIPMENT_TOLERANCE,
c_UNDER_SHIPMENT_TOLERANCE,
c_ITEM_CROSS_REF_PREF,
c_OVER_RETURN_TOLERANCE,
c_UNDER_RETURN_TOLERANCE,
c_SHIP_SETS_INCLUDE_LINES_FLAG,
c_ARRIVALSETS_INCL_LINES_FLAG,
c_SCHED_DATE_PUSH_FLAG,
c_INVOICE_QUANTITY_RULE,
c_account_alias ,
p_cust_account_profile_id,
p_cust_account_id ,
p_status ,
p_collector_id ,
p_credit_analyst_id ,
p_credit_checking ,
p_next_credit_review_date,
p_tolerance ,
p_discount_terms ,
p_dunning_letters ,
p_interest_charges ,
p_send_statements ,
p_credit_balance_statements,
p_credit_hold ,
p_profile_class_id ,
p_site_use_id ,
p_credit_rating ,
p_risk_code ,
p_standard_terms ,
p_override_terms ,
p_dunning_letter_set_id,
p_interest_period_days,
p_payment_grace_days ,
p_discount_grace_days ,
p_statement_cycle_id ,
p_account_status ,
p_percent_collectable ,
p_autocash_hierarchy_id,
p_Attribute_Category ,
p_Attribute1 ,
p_Attribute2 ,
p_Attribute3 ,
p_Attribute4 ,
p_Attribute5 ,
p_Attribute6 ,
p_Attribute7 ,
p_Attribute8 ,
p_Attribute9 ,
p_Attribute10 ,
p_Attribute11 ,
p_Attribute12 ,
p_Attribute13 ,
p_Attribute14 ,
p_Attribute15 ,
p_auto_rec_incl_disputed_flag,
p_tax_printing_option ,
p_charge_on_fin_charge_flag,
p_grouping_rule_id ,
p_clearing_days ,
p_jgzz_attribute_category,
p_jgzz_attribute1 ,
p_jgzz_attribute2 ,
p_jgzz_attribute3 ,
p_jgzz_attribute4 ,
p_jgzz_attribute5 ,
p_jgzz_attribute6 ,
p_jgzz_attribute7 ,
p_jgzz_attribute8 ,
p_jgzz_attribute9 ,
p_jgzz_attribute10 ,
p_jgzz_attribute11 ,
p_jgzz_attribute12 ,
p_jgzz_attribute13 ,
p_jgzz_attribute14 ,
p_jgzz_attribute15 ,
p_global_attribute_category,
p_global_attribute1 ,
p_global_attribute2 ,
p_global_attribute3 ,
p_global_attribute4 ,
p_global_attribute5 ,
p_global_attribute6 ,
p_global_attribute7 ,
p_global_attribute8 ,
p_global_attribute9 ,
p_global_attribute10 ,
p_global_attribute11 ,
p_global_attribute12 ,
p_global_attribute13 ,
p_global_attribute14 ,
p_global_attribute15 ,
p_global_attribute16 ,
p_global_attribute17 ,
p_global_attribute18 ,
p_global_attribute19 ,
p_global_attribute20 ,
p_cons_inv_flag ,
p_cons_inv_type ,
p_autocash_hier_id_for_adr,
p_lockbox_matching_option ,
--{2310474
p_party_id,
p_review_cycle,
p_credit_classification,
p_last_credit_review_date,
--}
a_last_update_date ,
l_object_version ,
p_last_update_date ,
x_cr_last_update_date ,
x_pt_last_update_date ,
x_cp_last_update_date ,
x_op_last_update_date ,
x_pp_last_update_date ,
x_account_type ,
o_organization_profile_id,
o_person_profile_id ,
x_msg_count ,
x_msg_data ,
x_return_status ,
c_duns_number_c ,
x_cust_acct_object_version,
x_cust_prof_object_version,
x_party_object_version );
select 1
into dummy
from dual
where not exists ( select 1
from hz_parties
where party_number = p_party_number
and ( ( p_rowid is null ) or (rowid <> p_rowid))
);