[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
g_pst_selected_datasources VARCHAR2(255);
g_pst_is_datasource_selected VARCHAR2(1) := 'N';
g_cpt_selected_datasources VARCHAR2(255);
g_cpt_is_datasource_selected VARCHAR2(1) := 'N';
g_rel_selected_datasources VARCHAR2(255);
g_rel_is_datasource_selected VARCHAR2(1) := 'N';
hz_parties_pkg.select_row (
X_PARTY_ID => x_party_rec.party_id,
X_PARTY_NUMBER => x_party_rec.party_number,
X_PARTY_NAME => l_party_name,
X_PARTY_TYPE => l_party_type,
X_VALIDATED_FLAG => x_party_rec.validated_flag,
X_ATTRIBUTE_CATEGORY => x_party_rec.attribute_category,
X_ATTRIBUTE1 => x_party_rec.attribute1,
X_ATTRIBUTE2 => x_party_rec.attribute2,
X_ATTRIBUTE3 => x_party_rec.attribute3,
X_ATTRIBUTE4 => x_party_rec.attribute4,
X_ATTRIBUTE5 => x_party_rec.attribute5,
X_ATTRIBUTE6 => x_party_rec.attribute6,
X_ATTRIBUTE7 => x_party_rec.attribute7,
X_ATTRIBUTE8 => x_party_rec.attribute8,
X_ATTRIBUTE9 => x_party_rec.attribute9,
X_ATTRIBUTE10 => x_party_rec.attribute10,
X_ATTRIBUTE11 => x_party_rec.attribute11,
X_ATTRIBUTE12 => x_party_rec.attribute12,
X_ATTRIBUTE13 => x_party_rec.attribute13,
X_ATTRIBUTE14 => x_party_rec.attribute14,
X_ATTRIBUTE15 => x_party_rec.attribute15,
X_ATTRIBUTE16 => x_party_rec.attribute16,
X_ATTRIBUTE17 => x_party_rec.attribute17,
X_ATTRIBUTE18 => x_party_rec.attribute18,
X_ATTRIBUTE19 => x_party_rec.attribute19,
X_ATTRIBUTE20 => x_party_rec.attribute20,
X_ATTRIBUTE21 => x_party_rec.attribute21,
X_ATTRIBUTE22 => x_party_rec.attribute22,
X_ATTRIBUTE23 => x_party_rec.attribute23,
X_ATTRIBUTE24 => x_party_rec.attribute24,
X_ORIG_SYSTEM_REFERENCE => x_party_rec.orig_system_reference,
X_SIC_CODE => x_party_dup_rec.sic_code,
X_HQ_BRANCH_IND => x_party_dup_rec.hq_branch_ind,
X_CUSTOMER_KEY => l_customer_key,
X_TAX_REFERENCE => x_party_dup_rec.tax_reference,
X_JGZZ_FISCAL_CODE => x_party_dup_rec.jgzz_fiscal_code,
X_PERSON_PRE_NAME_ADJUNCT => x_party_dup_rec.pre_name_adjunct,
X_PERSON_FIRST_NAME => x_party_dup_rec.first_name,
X_PERSON_MIDDLE_NAME => x_party_dup_rec.middle_name,
X_PERSON_LAST_NAME => x_party_dup_rec.last_name,
X_PERSON_NAME_SUFFIX => x_party_dup_rec.name_suffix,
X_PERSON_TITLE => x_party_dup_rec.title,
X_PERSON_ACADEMIC_TITLE => x_party_dup_rec.academic_title,
X_PERSON_PREVIOUS_LAST_NAME => x_party_dup_rec.previous_last_name,
X_KNOWN_AS => x_party_dup_rec.known_as,
X_PERSON_IDEN_TYPE => x_party_dup_rec.person_iden_type,
X_PERSON_IDENTIFIER => x_party_dup_rec.person_identifier,
X_GROUP_TYPE => l_group_type,
X_COUNTRY => l_country,
X_ADDRESS1 => l_address1,
X_ADDRESS2 => l_address2,
X_ADDRESS3 => l_address3,
X_ADDRESS4 => l_address4,
X_CITY => l_city,
X_POSTAL_CODE => l_postal_code,
X_STATE => l_state,
X_PROVINCE => l_province,
X_STATUS => x_party_rec.status,
X_COUNTY => l_county,
X_SIC_CODE_TYPE => x_party_dup_rec.sic_code_type,
X_URL => l_url,
X_EMAIL_ADDRESS => l_email_address,
X_ANALYSIS_FY => x_party_dup_rec.analysis_fy,
X_FISCAL_YEAREND_MONTH => x_party_dup_rec.fiscal_yearend_month,
X_EMPLOYEES_TOTAL => x_party_dup_rec.employees_total,
X_CURR_FY_POTENTIAL_REVENUE => x_party_dup_rec.curr_fy_potential_revenue,
X_NEXT_FY_POTENTIAL_REVENUE => x_party_dup_rec.next_fy_potential_revenue,
X_YEAR_ESTABLISHED => x_party_dup_rec.year_established,
X_GSA_INDICATOR_FLAG => x_party_dup_rec.gsa_indicator_flag,
X_MISSION_STATEMENT => x_party_dup_rec.mission_statement,
X_ORGANIZATION_NAME_PHONETIC => x_party_dup_rec.organization_name_phonetic,
X_PERSON_FIRST_NAME_PHONETIC => x_party_dup_rec.person_first_name_phonetic,
X_PERSON_LAST_NAME_PHONETIC => x_party_dup_rec.person_last_name_phonetic,
X_LANGUAGE_NAME => l_language_name,
X_CATEGORY_CODE => x_party_rec.category_code,
X_SALUTATION => x_party_rec.salutation,
X_KNOWN_AS2 => x_party_dup_rec.known_as2,
X_KNOWN_AS3 => x_party_dup_rec.known_as3,
X_KNOWN_AS4 => x_party_dup_rec.known_as4,
X_KNOWN_AS5 => x_party_dup_rec.known_as5,
X_DUNS_NUMBER_C => x_party_dup_rec.duns_number_c,
X_CREATED_BY_MODULE => l_created_by_module,
X_APPLICATION_ID => l_application_id
);
PROCEDURE do_update_party_flags(
p_relationship_rec IN HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,
p_party_id IN NUMBER
);
SELECT RELATIONSHIP_TYPE,
FORWARD_REL_CODE,
BACKWARD_REL_CODE,
CREATE_PARTY_FLAG,
ALLOW_RELATE_TO_SELF_FLAG,
HIERARCHICAL_FLAG,
ALLOW_CIRCULAR_RELATIONSHIPS,
DIRECTION_CODE,
RELATIONSHIP_TYPE_ID,
MULTIPLE_PARENT_ALLOWED
FROM HZ_RELATIONSHIP_TYPES
WHERE RELATIONSHIP_TYPE = p_relationship_rec.relationship_type
AND FORWARD_REL_CODE = p_relationship_rec.relationship_code
AND SUBJECT_TYPE = p_relationship_rec.subject_type
AND OBJECT_TYPE = p_relationship_rec.object_type
AND STATUS = 'A';
SELECT SUBJECT_ID,
SUBJECT_TABLE_NAME,
SUBJECT_TYPE
FROM HZ_RELATIONSHIPS
START WITH OBJECT_ID = p_parent_id
AND OBJECT_TABLE_NAME = p_parent_table_name
AND OBJECT_TYPE = p_parent_object_type
AND DIRECTION_CODE = 'P'
AND RELATIONSHIP_TYPE = p_relationship_rec.relationship_type
AND ( START_DATE BETWEEN NVL(p_relationship_rec.start_date, SYSDATE) AND
NVL(p_relationship_rec.end_date, TO_DATE('31-12-4712 00:00:00','DD-MM-YYYY HH24:MI:SS'))
OR END_DATE BETWEEN NVL(p_relationship_rec.start_date, SYSDATE)
AND NVL(p_relationship_rec.end_date, TO_DATE('31-12-4712 00:00:00', 'DD-MM-YYYY HH24:MI:SS'))
OR
NVL(p_relationship_rec.start_date, SYSDATE) BETWEEN START_DATE AND END_DATE
OR
NVL(p_relationship_rec.end_date, TO_DATE('31-12-4712 00:00:00', 'DD-MM-YYYY HH24:MI:SS')) BETWEEN START_DATE AND END_DATE)
CONNECT BY OBJECT_ID = PRIOR SUBJECT_ID AND OBJECT_TYPE = PRIOR SUBJECT_TYPE AND OBJECT_TABLE_NAME = PRIOR SUBJECT_TABLE_NAME
AND DIRECTION_CODE = 'P' AND RELATIONSHIP_TYPE = p_relationship_rec.relationship_type
AND (START_DATE BETWEEN NVL(p_relationship_rec.start_date, SYSDATE)
AND NVL(p_relationship_rec.end_date, TO_DATE('31-12-4712 00:00:00', 'DD-MM-YYYY HH24:MI:SS'))
OR
END_DATE BETWEEN NVL(p_relationship_rec.start_date, SYSDATE)
AND NVL(p_relationship_rec.end_date, TO_DATE('31-12-4712 00:00:00', 'DD-MM-YYYY HH24:MI:SS'))
OR
NVL(p_relationship_rec.start_date, SYSDATE) BETWEEN START_DATE AND END_DATE
OR
NVL(p_relationship_rec.end_date, TO_DATE('31-12-4712 00:00:00', 'DD-MM-YYYY HH24:MI:SS')) BETWEEN START_DATE AND END_DATE);
SELECT OBJECT_ID,
OBJECT_TABLE_NAME,
OBJECT_TYPE
FROM HZ_RELATIONSHIPS
START WITH SUBJECT_ID = p_child_id
AND SUBJECT_TABLE_NAME = p_child_table_name
AND SUBJECT_TYPE = p_child_object_type
AND DIRECTION_CODE = 'P'
AND RELATIONSHIP_TYPE = p_relationship_rec.relationship_type
AND (START_DATE BETWEEN NVL(p_relationship_rec.start_date, SYSDATE)
AND NVL(p_relationship_rec.end_date, TO_DATE('31-12-4712 00:00:00', 'DD-MM-YYYY HH24:MI:SS'))
OR
END_DATE BETWEEN NVL(p_relationship_rec.start_date, SYSDATE)
AND NVL(p_relationship_rec.end_date, TO_DATE('31-12-4712 00:00:00', 'DD-MM-YYYY HH24:MI:SS'))
OR
NVL(p_relationship_rec.start_date, SYSDATE) BETWEEN START_DATE AND END_DATE
OR
NVL(p_relationship_rec.end_date, TO_DATE('31-12-4712 00:00:00', 'DD-MM-YYYY HH24:MI:SS')) BETWEEN START_DATE AND END_DATE)
CONNECT BY SUBJECT_ID = PRIOR OBJECT_ID AND SUBJECT_TYPE = PRIOR OBJECT_TYPE AND SUBJECT_TABLE_NAME = PRIOR OBJECT_TABLE_NAME
AND DIRECTION_CODE = 'P' AND RELATIONSHIP_TYPE = p_relationship_rec.relationship_type
AND (START_DATE BETWEEN NVL(p_relationship_rec.start_date, SYSDATE)
AND NVL(p_relationship_rec.end_date, TO_DATE('31-12-4712 00:00:00', 'DD-MM-YYYY HH24:MI:SS'))
OR
END_DATE BETWEEN NVL(p_relationship_rec.start_date, SYSDATE)
AND NVL(p_relationship_rec.end_date, TO_DATE('31-12-4712 00:00:00', 'DD-MM-YYYY HH24:MI:SS'))
OR
NVL(p_relationship_rec.start_date, SYSDATE) BETWEEN START_DATE AND END_DATE
OR
NVL(p_relationship_rec.end_date, TO_DATE('31-12-4712 00:00:00', 'DD-MM-YYYY HH24:MI:SS')) BETWEEN START_DATE AND END_DATE);
SELECT HZ_RELATIONSHIPS_S.NEXTVAL
INTO l_relationship_id
FROM DUAL;
SELECT 'Y'
INTO l_dummy
FROM HZ_RELATIONSHIPS
WHERE RELATIONSHIP_ID = l_relationship_id
AND DIRECTIONAL_FLAG = 'F';
SELECT 1 INTO l_count
FROM HZ_RELATIONSHIPS
WHERE OBJECT_ID = l_child_id
AND OBJECT_TABLE_NAME = l_child_table_name
AND OBJECT_TYPE = l_child_object_type
AND RELATIONSHIP_TYPE = p_relationship_rec.relationship_type
AND DIRECTION_CODE = 'P'
AND (START_DATE BETWEEN NVL(p_relationship_rec.start_date, SYSDATE)
AND NVL(p_relationship_rec.end_date, TO_DATE('31-12-4712 00:00:00', 'DD-MM-YYYY HH24:MI:SS'))
OR
END_DATE BETWEEN NVL(p_relationship_rec.start_date, SYSDATE)
AND NVL(p_relationship_rec.end_date, TO_DATE('31-12-4712 00:00:00', 'DD-MM-YYYY HH24:MI:SS'))
OR
NVL(p_relationship_rec.start_date, SYSDATE) BETWEEN START_DATE AND END_DATE
OR
NVL(p_relationship_rec.end_date, TO_DATE('31-12-4712 00:00:00', 'DD-MM-YYYY HH24:MI:SS')) BETWEEN START_DATE AND END_DATE
);
do_update_party_flags(
p_relationship_rec,
p_relationship_rec.subject_id);
HZ_RELATIONSHIPS_PKG.Insert_Row (
X_RELATIONSHIP_ID => p_relationship_rec.relationship_id,
X_SUBJECT_ID => p_relationship_rec.subject_id,
X_SUBJECT_TYPE => p_relationship_rec.subject_type,
X_SUBJECT_TABLE_NAME => p_relationship_rec.subject_table_name,
X_OBJECT_ID => p_relationship_rec.object_id,
X_OBJECT_TYPE => p_relationship_rec.object_type,
X_OBJECT_TABLE_NAME => p_relationship_rec.object_table_name,
X_PARTY_ID => x_party_id,
X_RELATIONSHIP_CODE => p_relationship_rec.relationship_code,
X_DIRECTIONAL_FLAG => 'F',
X_COMMENTS => p_relationship_rec.comments,
X_START_DATE => p_relationship_rec.start_date,
X_END_DATE => l_end_date,
X_STATUS => p_relationship_rec.status,
X_ATTRIBUTE_CATEGORY => p_relationship_rec.attribute_category,
X_ATTRIBUTE1 => p_relationship_rec.attribute1,
X_ATTRIBUTE2 => p_relationship_rec.attribute2,
X_ATTRIBUTE3 => p_relationship_rec.attribute3,
X_ATTRIBUTE4 => p_relationship_rec.attribute4,
X_ATTRIBUTE5 => p_relationship_rec.attribute5,
X_ATTRIBUTE6 => p_relationship_rec.attribute6,
X_ATTRIBUTE7 => p_relationship_rec.attribute7,
X_ATTRIBUTE8 => p_relationship_rec.attribute8,
X_ATTRIBUTE9 => p_relationship_rec.attribute9,
X_ATTRIBUTE10 => p_relationship_rec.attribute10,
X_ATTRIBUTE11 => p_relationship_rec.attribute11,
X_ATTRIBUTE12 => p_relationship_rec.attribute12,
X_ATTRIBUTE13 => p_relationship_rec.attribute13,
X_ATTRIBUTE14 => p_relationship_rec.attribute14,
X_ATTRIBUTE15 => p_relationship_rec.attribute15,
X_ATTRIBUTE16 => p_relationship_rec.attribute16,
X_ATTRIBUTE17 => p_relationship_rec.attribute17,
X_ATTRIBUTE18 => p_relationship_rec.attribute18,
X_ATTRIBUTE19 => p_relationship_rec.attribute19,
X_ATTRIBUTE20 => p_relationship_rec.attribute20,
X_CONTENT_SOURCE_TYPE => p_relationship_rec.content_source_type,
X_RELATIONSHIP_TYPE => p_relationship_rec.relationship_type,
X_OBJECT_VERSION_NUMBER => 1,
X_CREATED_BY_MODULE => p_relationship_rec.created_by_module,
X_APPLICATION_ID => p_relationship_rec.application_id,
X_ADDITIONAL_INFORMATION1 => p_relationship_rec.additional_information1,
X_ADDITIONAL_INFORMATION2 => p_relationship_rec.additional_information2,
X_ADDITIONAL_INFORMATION3 => p_relationship_rec.additional_information3,
X_ADDITIONAL_INFORMATION4 => p_relationship_rec.additional_information4,
X_ADDITIONAL_INFORMATION5 => p_relationship_rec.additional_information5,
X_ADDITIONAL_INFORMATION6 => p_relationship_rec.additional_information6,
X_ADDITIONAL_INFORMATION7 => p_relationship_rec.additional_information7,
X_ADDITIONAL_INFORMATION8 => p_relationship_rec.additional_information8,
X_ADDITIONAL_INFORMATION9 => p_relationship_rec.additional_information9,
X_ADDITIONAL_INFORMATION10 => p_relationship_rec.additional_information10,
X_ADDITIONAL_INFORMATION11 => p_relationship_rec.additional_information11,
X_ADDITIONAL_INFORMATION12 => p_relationship_rec.additional_information12,
X_ADDITIONAL_INFORMATION13 => p_relationship_rec.additional_information13,
X_ADDITIONAL_INFORMATION14 => p_relationship_rec.additional_information14,
X_ADDITIONAL_INFORMATION15 => p_relationship_rec.additional_information15,
X_ADDITIONAL_INFORMATION16 => p_relationship_rec.additional_information16,
X_ADDITIONAL_INFORMATION17 => p_relationship_rec.additional_information17,
X_ADDITIONAL_INFORMATION18 => p_relationship_rec.additional_information18,
X_ADDITIONAL_INFORMATION19 => p_relationship_rec.additional_information19,
X_ADDITIONAL_INFORMATION20 => p_relationship_rec.additional_information20,
X_ADDITIONAL_INFORMATION21 => p_relationship_rec.additional_information21,
X_ADDITIONAL_INFORMATION22 => p_relationship_rec.additional_information22,
X_ADDITIONAL_INFORMATION23 => p_relationship_rec.additional_information23,
X_ADDITIONAL_INFORMATION24 => p_relationship_rec.additional_information24,
X_ADDITIONAL_INFORMATION25 => p_relationship_rec.additional_information25,
X_ADDITIONAL_INFORMATION26 => p_relationship_rec.additional_information26,
X_ADDITIONAL_INFORMATION27 => p_relationship_rec.additional_information27,
X_ADDITIONAL_INFORMATION28 => p_relationship_rec.additional_information28,
X_ADDITIONAL_INFORMATION29 => p_relationship_rec.additional_information29,
X_ADDITIONAL_INFORMATION30 => p_relationship_rec.additional_information30,
X_DIRECTION_CODE => r_rel_type.direction_code,
X_PERCENTAGE_OWNERSHIP => p_relationship_rec.percentage_ownership,
X_ACTUAL_CONTENT_SOURCE => p_relationship_rec.ACTUAL_CONTENT_SOURCE
);
HZ_RELATIONSHIPS_PKG.Insert_Row (
X_RELATIONSHIP_ID => p_relationship_rec.relationship_id,
X_SUBJECT_ID => p_relationship_rec.object_id,
X_SUBJECT_TYPE => p_relationship_rec.object_type,
X_SUBJECT_TABLE_NAME => p_relationship_rec.object_table_name,
X_OBJECT_ID => p_relationship_rec.subject_id,
X_OBJECT_TYPE => p_relationship_rec.subject_type,
X_OBJECT_TABLE_NAME => p_relationship_rec.subject_table_name,
X_PARTY_ID => x_party_id,
X_RELATIONSHIP_CODE => r_rel_type.backward_rel_code,
X_DIRECTIONAL_FLAG => 'B',
X_COMMENTS => p_relationship_rec.comments,
X_START_DATE => p_relationship_rec.start_date,
X_END_DATE => l_end_date,
X_STATUS => p_relationship_rec.status,
X_ATTRIBUTE_CATEGORY => p_relationship_rec.attribute_category,
X_ATTRIBUTE1 => p_relationship_rec.attribute1,
X_ATTRIBUTE2 => p_relationship_rec.attribute2,
X_ATTRIBUTE3 => p_relationship_rec.attribute3,
X_ATTRIBUTE4 => p_relationship_rec.attribute4,
X_ATTRIBUTE5 => p_relationship_rec.attribute5,
X_ATTRIBUTE6 => p_relationship_rec.attribute6,
X_ATTRIBUTE7 => p_relationship_rec.attribute7,
X_ATTRIBUTE8 => p_relationship_rec.attribute8,
X_ATTRIBUTE9 => p_relationship_rec.attribute9,
X_ATTRIBUTE10 => p_relationship_rec.attribute10,
X_ATTRIBUTE11 => p_relationship_rec.attribute11,
X_ATTRIBUTE12 => p_relationship_rec.attribute12,
X_ATTRIBUTE13 => p_relationship_rec.attribute13,
X_ATTRIBUTE14 => p_relationship_rec.attribute14,
X_ATTRIBUTE15 => p_relationship_rec.attribute15,
X_ATTRIBUTE16 => p_relationship_rec.attribute16,
X_ATTRIBUTE17 => p_relationship_rec.attribute17,
X_ATTRIBUTE18 => p_relationship_rec.attribute18,
X_ATTRIBUTE19 => p_relationship_rec.attribute19,
X_ATTRIBUTE20 => p_relationship_rec.attribute20,
X_CONTENT_SOURCE_TYPE => p_relationship_rec.content_source_type,
X_RELATIONSHIP_TYPE => r_rel_type.relationship_type,
X_OBJECT_VERSION_NUMBER => 1,
X_CREATED_BY_MODULE => p_relationship_rec.created_by_module,
X_APPLICATION_ID => p_relationship_rec.application_id,
X_ADDITIONAL_INFORMATION1 => p_relationship_rec.additional_information1,
X_ADDITIONAL_INFORMATION2 => p_relationship_rec.additional_information2,
X_ADDITIONAL_INFORMATION3 => p_relationship_rec.additional_information3,
X_ADDITIONAL_INFORMATION4 => p_relationship_rec.additional_information4,
X_ADDITIONAL_INFORMATION5 => p_relationship_rec.additional_information5,
X_ADDITIONAL_INFORMATION6 => p_relationship_rec.additional_information6,
X_ADDITIONAL_INFORMATION7 => p_relationship_rec.additional_information7,
X_ADDITIONAL_INFORMATION8 => p_relationship_rec.additional_information8,
X_ADDITIONAL_INFORMATION9 => p_relationship_rec.additional_information9,
X_ADDITIONAL_INFORMATION10 => p_relationship_rec.additional_information10,
X_ADDITIONAL_INFORMATION11 => p_relationship_rec.additional_information11,
X_ADDITIONAL_INFORMATION12 => p_relationship_rec.additional_information12,
X_ADDITIONAL_INFORMATION13 => p_relationship_rec.additional_information13,
X_ADDITIONAL_INFORMATION14 => p_relationship_rec.additional_information14,
X_ADDITIONAL_INFORMATION15 => p_relationship_rec.additional_information15,
X_ADDITIONAL_INFORMATION16 => p_relationship_rec.additional_information16,
X_ADDITIONAL_INFORMATION17 => p_relationship_rec.additional_information17,
X_ADDITIONAL_INFORMATION18 => p_relationship_rec.additional_information18,
X_ADDITIONAL_INFORMATION19 => p_relationship_rec.additional_information19,
X_ADDITIONAL_INFORMATION20 => p_relationship_rec.additional_information20,
X_ADDITIONAL_INFORMATION21 => p_relationship_rec.additional_information21,
X_ADDITIONAL_INFORMATION22 => p_relationship_rec.additional_information22,
X_ADDITIONAL_INFORMATION23 => p_relationship_rec.additional_information23,
X_ADDITIONAL_INFORMATION24 => p_relationship_rec.additional_information24,
X_ADDITIONAL_INFORMATION25 => p_relationship_rec.additional_information25,
X_ADDITIONAL_INFORMATION26 => p_relationship_rec.additional_information26,
X_ADDITIONAL_INFORMATION27 => p_relationship_rec.additional_information27,
X_ADDITIONAL_INFORMATION28 => p_relationship_rec.additional_information28,
X_ADDITIONAL_INFORMATION29 => p_relationship_rec.additional_information29,
X_ADDITIONAL_INFORMATION30 => p_relationship_rec.additional_information30,
X_DIRECTION_CODE => l_back_direction,
X_PERCENTAGE_OWNERSHIP => p_relationship_rec.percentage_ownership,
X_ACTUAL_CONTENT_SOURCE => p_relationship_rec.ACTUAL_CONTENT_SOURCE
);
SELECT PARTY_NAME
INTO l_subject_name
FROM hz_parties
WHERE PARTY_ID = p_relationship_rec.subject_id;
SELECT PARTY_NAME
INTO l_object_name
FROM hz_parties
WHERE PARTY_ID = p_relationship_rec.object_id;
hz_parties_PKG.Insert_Row (
X_PARTY_ID => l_party_rec.party_id,
X_PARTY_NUMBER => l_party_rec.party_number,
X_PARTY_NAME => l_party_name,
X_PARTY_TYPE => p_party_type,
X_VALIDATED_FLAG => l_party_rec.validated_flag,
X_ATTRIBUTE_CATEGORY => l_party_rec.attribute_category,
X_ATTRIBUTE1 => l_party_rec.attribute1,
X_ATTRIBUTE2 => l_party_rec.attribute2,
X_ATTRIBUTE3 => l_party_rec.attribute3,
X_ATTRIBUTE4 => l_party_rec.attribute4,
X_ATTRIBUTE5 => l_party_rec.attribute5,
X_ATTRIBUTE6 => l_party_rec.attribute6,
X_ATTRIBUTE7 => l_party_rec.attribute7,
X_ATTRIBUTE8 => l_party_rec.attribute8,
X_ATTRIBUTE9 => l_party_rec.attribute9,
X_ATTRIBUTE10 => l_party_rec.attribute10,
X_ATTRIBUTE11 => l_party_rec.attribute11,
X_ATTRIBUTE12 => l_party_rec.attribute12,
X_ATTRIBUTE13 => l_party_rec.attribute13,
X_ATTRIBUTE14 => l_party_rec.attribute14,
X_ATTRIBUTE15 => l_party_rec.attribute15,
X_ATTRIBUTE16 => l_party_rec.attribute16,
X_ATTRIBUTE17 => l_party_rec.attribute17,
X_ATTRIBUTE18 => l_party_rec.attribute18,
X_ATTRIBUTE19 => l_party_rec.attribute19,
X_ATTRIBUTE20 => l_party_rec.attribute20,
X_ATTRIBUTE21 => l_party_rec.attribute21,
X_ATTRIBUTE22 => l_party_rec.attribute22,
X_ATTRIBUTE23 => l_party_rec.attribute23,
X_ATTRIBUTE24 => l_party_rec.attribute24,
X_ORIG_SYSTEM_REFERENCE => l_party_rec.orig_system_reference,
X_SIC_CODE => null,
X_HQ_BRANCH_IND => null,
X_CUSTOMER_KEY => null,
X_TAX_REFERENCE => null,
X_JGZZ_FISCAL_CODE => null,
X_PERSON_PRE_NAME_ADJUNCT => null,
X_PERSON_FIRST_NAME => null,
X_PERSON_MIDDLE_NAME => null,
X_PERSON_LAST_NAME => null,
X_PERSON_NAME_SUFFIX => null,
X_PERSON_TITLE => null,
X_PERSON_ACADEMIC_TITLE => null,
X_PERSON_PREVIOUS_LAST_NAME => null,
X_KNOWN_AS => null,
X_PERSON_IDEN_TYPE => null,
X_PERSON_IDENTIFIER => null,
X_GROUP_TYPE => null,
X_COUNTRY => NULL,
X_ADDRESS1 => NULL,
X_ADDRESS2 => NULL,
X_ADDRESS3 => NULL,
X_ADDRESS4 => NULL,
X_CITY => NULL,
X_POSTAL_CODE => NULL,
X_STATE => NULL,
X_PROVINCE => NULL,
X_STATUS => l_party_rec.status,
X_COUNTY => NULL,
X_SIC_CODE_TYPE => null,
X_URL => NULL,
X_EMAIL_ADDRESS => NULL,
X_ANALYSIS_FY => null,
X_FISCAL_YEAREND_MONTH => null,
X_EMPLOYEES_TOTAL => null,
X_CURR_FY_POTENTIAL_REVENUE => null,
X_NEXT_FY_POTENTIAL_REVENUE => null,
X_YEAR_ESTABLISHED => null,
X_GSA_INDICATOR_FLAG => null,
X_MISSION_STATEMENT => null,
X_ORGANIZATION_NAME_PHONETIC => null,
X_PERSON_FIRST_NAME_PHONETIC => null,
X_PERSON_LAST_NAME_PHONETIC => null,
X_LANGUAGE_NAME => NULL,
X_CATEGORY_CODE => l_party_rec.category_code,
X_SALUTATION => l_party_rec.salutation,
X_KNOWN_AS2 => null,
X_KNOWN_AS3 => null,
X_KNOWN_AS4 => null,
X_KNOWN_AS5 => null,
X_OBJECT_VERSION_NUMBER => 1,
X_DUNS_NUMBER_C => null,
X_CREATED_BY_MODULE => p_relationship_rec.created_by_module,
X_APPLICATION_ID => p_relationship_rec.application_id
);
UPDATE hz_parties SET PARTY_NAME = l_party_name WHERE PARTY_ID = x_party_id;
PROCEDURE do_update_party_flags(
p_relationship_rec IN HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,
p_party_id IN NUMBER
) IS
l_party_id NUMBER;
SELECT party_id INTO l_party_id
FROM hz_parties
WHERE party_id = p_party_id
FOR UPDATE NOWAIT;
UPDATE HZ_PARTIES
SET COMPETITOR_FLAG = l_competitor_flag
WHERE PARTY_ID = p_party_id;
UPDATE HZ_PARTIES
SET REFERENCE_USE_FLAG = l_reference_use_flag
WHERE PARTY_ID = p_party_id;
UPDATE HZ_PARTIES
SET THIRD_PARTY_FLAG = l_third_party_flag
WHERE PARTY_ID = p_party_id;
END do_update_party_flags;
* For non-profile entities, the concept of select/de-select data-sources is obsoleted.
IF g_rel_mixnmatch_enabled IS NULL THEN
HZ_MIXNM_UTILITY.LoadDataSources(
p_entity_name => 'HZ_RELATIONSHIPS',
p_entity_attr_id => g_rel_entity_attr_id,
p_mixnmatch_enabled => g_rel_mixnmatch_enabled,
p_selected_datasources => g_rel_selected_datasources );
p_selected_datasources => g_rel_selected_datasources,
p_content_source_type => l_rel_rec.content_source_type,
p_actual_content_source => l_rel_rec.actual_content_source,
x_is_datasource_selected => g_rel_is_datasource_selected,
x_return_status => x_return_status );
HZ_RELATIONSHIPS_PKG.Select_Row (
X_RELATIONSHIP_ID => x_rel_rec.relationship_id,
X_DIRECTIONAL_FLAG => l_directional_flag,
X_SUBJECT_ID => x_rel_rec.subject_id,
X_SUBJECT_TYPE => x_rel_rec.subject_type,
X_SUBJECT_TABLE_NAME => x_rel_rec.subject_table_name,
X_OBJECT_ID => x_rel_rec.object_id,
X_OBJECT_TYPE => x_rel_rec.object_type,
X_OBJECT_TABLE_NAME => x_rel_rec.object_table_name,
X_PARTY_ID => l_party_id,
X_RELATIONSHIP_CODE => x_rel_rec.relationship_code,
X_COMMENTS => x_rel_rec.comments,
X_START_DATE => x_rel_rec.start_date,
X_END_DATE => x_rel_rec.end_date,
X_STATUS => x_rel_rec.status,
X_ATTRIBUTE_CATEGORY => x_rel_rec.attribute_category,
X_ATTRIBUTE1 => x_rel_rec.attribute1,
X_ATTRIBUTE2 => x_rel_rec.attribute2,
X_ATTRIBUTE3 => x_rel_rec.attribute3,
X_ATTRIBUTE4 => x_rel_rec.attribute4,
X_ATTRIBUTE5 => x_rel_rec.attribute5,
X_ATTRIBUTE6 => x_rel_rec.attribute6,
X_ATTRIBUTE7 => x_rel_rec.attribute7,
X_ATTRIBUTE8 => x_rel_rec.attribute8,
X_ATTRIBUTE9 => x_rel_rec.attribute9,
X_ATTRIBUTE10 => x_rel_rec.attribute10,
X_ATTRIBUTE11 => x_rel_rec.attribute11,
X_ATTRIBUTE12 => x_rel_rec.attribute12,
X_ATTRIBUTE13 => x_rel_rec.attribute13,
X_ATTRIBUTE14 => x_rel_rec.attribute14,
X_ATTRIBUTE15 => x_rel_rec.attribute15,
X_ATTRIBUTE16 => x_rel_rec.attribute16,
X_ATTRIBUTE17 => x_rel_rec.attribute17,
X_ATTRIBUTE18 => x_rel_rec.attribute18,
X_ATTRIBUTE19 => x_rel_rec.attribute19,
X_ATTRIBUTE20 => x_rel_rec.attribute20,
X_CONTENT_SOURCE_TYPE => x_rel_rec.content_source_type,
X_RELATIONSHIP_TYPE => x_rel_rec.relationship_type,
X_CREATED_BY_MODULE => x_rel_rec.created_by_module,
X_APPLICATION_ID => x_rel_rec.application_id,
X_ADDITIONAL_INFORMATION1 => x_rel_rec.additional_information1,
X_ADDITIONAL_INFORMATION2 => x_rel_rec.additional_information2,
X_ADDITIONAL_INFORMATION3 => x_rel_rec.additional_information3,
X_ADDITIONAL_INFORMATION4 => x_rel_rec.additional_information4,
X_ADDITIONAL_INFORMATION5 => x_rel_rec.additional_information5,
X_ADDITIONAL_INFORMATION6 => x_rel_rec.additional_information6,
X_ADDITIONAL_INFORMATION7 => x_rel_rec.additional_information7,
X_ADDITIONAL_INFORMATION8 => x_rel_rec.additional_information8,
X_ADDITIONAL_INFORMATION9 => x_rel_rec.additional_information9,
X_ADDITIONAL_INFORMATION10 => x_rel_rec.additional_information10,
X_ADDITIONAL_INFORMATION11 => x_rel_rec.additional_information11,
X_ADDITIONAL_INFORMATION12 => x_rel_rec.additional_information12,
X_ADDITIONAL_INFORMATION13 => x_rel_rec.additional_information13,
X_ADDITIONAL_INFORMATION14 => x_rel_rec.additional_information14,
X_ADDITIONAL_INFORMATION15 => x_rel_rec.additional_information15,
X_ADDITIONAL_INFORMATION16 => x_rel_rec.additional_information16,
X_ADDITIONAL_INFORMATION17 => x_rel_rec.additional_information17,
X_ADDITIONAL_INFORMATION18 => x_rel_rec.additional_information18,
X_ADDITIONAL_INFORMATION19 => x_rel_rec.additional_information19,
X_ADDITIONAL_INFORMATION20 => x_rel_rec.additional_information20,
X_ADDITIONAL_INFORMATION21 => x_rel_rec.additional_information21,
X_ADDITIONAL_INFORMATION22 => x_rel_rec.additional_information22,
X_ADDITIONAL_INFORMATION23 => x_rel_rec.additional_information23,
x_ADDITIONAL_INFORMATION24 => x_rel_rec.additional_information24,
X_ADDITIONAL_INFORMATION25 => x_rel_rec.additional_information25,
X_ADDITIONAL_INFORMATION26 => x_rel_rec.additional_information26,
X_ADDITIONAL_INFORMATION27 => x_rel_rec.additional_information27,
X_ADDITIONAL_INFORMATION28 => x_rel_rec.additional_information28,
X_ADDITIONAL_INFORMATION29 => x_rel_rec.additional_information29,
X_ADDITIONAL_INFORMATION30 => x_rel_rec.additional_information30,
X_DIRECTION_CODE => x_direction_code,
X_PERCENTAGE_OWNERSHIP => x_rel_rec.percentage_ownership,
X_ACTUAL_CONTENT_SOURCE => x_rel_rec.ACTUAL_CONTENT_SOURCE
);
HZ_ORG_CONTACTS_PKG.Insert_Row (
X_ORG_CONTACT_ID => p_org_contact_rec.org_contact_id,
X_PARTY_RELATIONSHIP_ID => x_party_rel_id,
X_COMMENTS => p_org_contact_rec.comments,
X_CONTACT_NUMBER => l_contact_number,
X_DEPARTMENT_CODE => p_org_contact_rec.department_code,
X_DEPARTMENT => p_org_contact_rec.department,
X_TITLE => p_org_contact_rec.title,
X_JOB_TITLE => p_org_contact_rec.job_title,
X_DECISION_MAKER_FLAG => p_org_contact_rec.decision_maker_flag,
X_JOB_TITLE_CODE => p_org_contact_rec.job_title_code,
X_REFERENCE_USE_FLAG => p_org_contact_rec.reference_use_flag,
X_RANK => p_org_contact_rec.rank,
X_ORIG_SYSTEM_REFERENCE => p_org_contact_rec.orig_system_reference,
X_ATTRIBUTE_CATEGORY => p_org_contact_rec.attribute_category,
X_ATTRIBUTE1 => p_org_contact_rec.attribute1,
X_ATTRIBUTE2 => p_org_contact_rec.attribute2,
X_ATTRIBUTE3 => p_org_contact_rec.attribute3,
X_ATTRIBUTE4 => p_org_contact_rec.attribute4,
X_ATTRIBUTE5 => p_org_contact_rec.attribute5,
X_ATTRIBUTE6 => p_org_contact_rec.attribute6,
X_ATTRIBUTE7 => p_org_contact_rec.attribute7,
X_ATTRIBUTE8 => p_org_contact_rec.attribute8,
X_ATTRIBUTE9 => p_org_contact_rec.attribute9,
X_ATTRIBUTE10 => p_org_contact_rec.attribute10,
X_ATTRIBUTE11 => p_org_contact_rec.attribute11,
X_ATTRIBUTE12 => p_org_contact_rec.attribute12,
X_ATTRIBUTE13 => p_org_contact_rec.attribute13,
X_ATTRIBUTE14 => p_org_contact_rec.attribute14,
X_ATTRIBUTE15 => p_org_contact_rec.attribute15,
X_ATTRIBUTE16 => p_org_contact_rec.attribute16,
X_ATTRIBUTE17 => p_org_contact_rec.attribute17,
X_ATTRIBUTE18 => p_org_contact_rec.attribute18,
X_ATTRIBUTE19 => p_org_contact_rec.attribute19,
X_ATTRIBUTE20 => p_org_contact_rec.attribute20,
X_ATTRIBUTE21 => p_org_contact_rec.attribute21,
X_ATTRIBUTE22 => p_org_contact_rec.attribute22,
X_ATTRIBUTE23 => p_org_contact_rec.attribute23,
X_ATTRIBUTE24 => p_org_contact_rec.attribute24,
X_PARTY_SITE_ID => p_org_contact_rec.party_site_id,
X_OBJECT_VERSION_NUMBER => 1,
X_CREATED_BY_MODULE => p_org_contact_rec.created_by_module,
X_APPLICATION_ID => p_org_contact_rec.application_id,
X_STATUS => p_org_contact_rec.party_rel_rec.status
);
HZ_ORG_CONTACTS_PKG.Select_Row (
X_ORG_CONTACT_ID => x_org_contact_rec.org_contact_id,
X_PARTY_RELATIONSHIP_ID => l_party_relationship_id,
X_COMMENTS => x_org_contact_rec.comments,
X_CONTACT_NUMBER => x_org_contact_rec.contact_number,
X_DEPARTMENT_CODE => x_org_contact_rec.department_code,
X_DEPARTMENT => x_org_contact_rec.department,
X_TITLE => x_org_contact_rec.title,
X_JOB_TITLE => x_org_contact_rec.job_title,
X_DECISION_MAKER_FLAG => x_org_contact_rec.decision_maker_flag,
X_JOB_TITLE_CODE => x_org_contact_rec.job_title_code,
X_REFERENCE_USE_FLAG => x_org_contact_rec.reference_use_flag,
X_RANK => x_org_contact_rec.rank,
X_ORIG_SYSTEM_REFERENCE => x_org_contact_rec.orig_system_reference,
X_ATTRIBUTE_CATEGORY => x_org_contact_rec.attribute_category,
X_ATTRIBUTE1 => x_org_contact_rec.attribute1,
X_ATTRIBUTE2 => x_org_contact_rec.attribute2,
X_ATTRIBUTE3 => x_org_contact_rec.attribute3,
X_ATTRIBUTE4 => x_org_contact_rec.attribute4,
X_ATTRIBUTE5 => x_org_contact_rec.attribute5,
X_ATTRIBUTE6 => x_org_contact_rec.attribute6,
X_ATTRIBUTE7 => x_org_contact_rec.attribute7,
X_ATTRIBUTE8 => x_org_contact_rec.attribute8,
X_ATTRIBUTE9 => x_org_contact_rec.attribute9,
X_ATTRIBUTE10 => x_org_contact_rec.attribute10,
X_ATTRIBUTE11 => x_org_contact_rec.attribute11,
X_ATTRIBUTE12 => x_org_contact_rec.attribute12,
X_ATTRIBUTE13 => x_org_contact_rec.attribute13,
X_ATTRIBUTE14 => x_org_contact_rec.attribute14,
X_ATTRIBUTE15 => x_org_contact_rec.attribute15,
X_ATTRIBUTE16 => x_org_contact_rec.attribute16,
X_ATTRIBUTE17 => x_org_contact_rec.attribute17,
X_ATTRIBUTE18 => x_org_contact_rec.attribute18,
X_ATTRIBUTE19 => x_org_contact_rec.attribute19,
X_ATTRIBUTE20 => x_org_contact_rec.attribute20,
X_ATTRIBUTE21 => x_org_contact_rec.attribute21,
X_ATTRIBUTE22 => x_org_contact_rec.attribute22,
X_ATTRIBUTE23 => x_org_contact_rec.attribute23,
X_ATTRIBUTE24 => x_org_contact_rec.attribute24,
X_PARTY_SITE_ID => x_org_contact_rec.party_site_id,
X_CREATED_BY_MODULE => x_org_contact_rec.created_by_module,
X_APPLICATION_ID => x_org_contact_rec.application_id
);
PROCEDURE do_update_address(
p_party_id IN NUMBER,
p_location_id IN NUMBER
);
select actual_content_source
into l_loc_actual_content_source
from hz_locations
where location_id = p_party_site_rec.location_id;
* For non-profile entities, the concept of select/de-select data-sources is obsoleted.
* There is no need to check if the data-source is selected.
g_pst_is_datasource_selected :=
HZ_MIXNM_UTILITY.isDataSourceSelected (
p_selected_datasources => g_pst_selected_datasources,
p_actual_content_source => l_loc_actual_content_source );
SELECT 'Y' INTO l_dummy
FROM HZ_PARTY_SITES
WHERE PARTY_ID = p_party_site_rec.party_id
AND STATUS = 'A'
/* AND HZ_MIXNM_UTILITY.isDataSourceSelected (
g_pst_selected_datasources, actual_content_source ) = 'Y'*/
AND ROWNUM = 1;
g_pst_is_datasource_selected = 'Y'*/
THEN
do_unmark_address_flag(p_party_site_rec.party_id);
g_pst_is_datasource_selected = 'Y'*/
THEN
p_party_site_rec.identifying_address_flag := 'Y';
do_update_address(
p_party_site_rec.party_id,
p_party_site_rec.location_id);
HZ_PARTY_SITES_PKG.Insert_Row (
X_PARTY_SITE_ID => p_party_site_rec.party_site_id,
X_PARTY_ID => p_party_site_rec.party_id,
X_LOCATION_ID => p_party_site_rec.location_id,
X_PARTY_SITE_NUMBER => p_party_site_rec.party_site_number,
X_ATTRIBUTE_CATEGORY => p_party_site_rec.attribute_category,
X_ATTRIBUTE1 => p_party_site_rec.attribute1,
X_ATTRIBUTE2 => p_party_site_rec.attribute2,
X_ATTRIBUTE3 => p_party_site_rec.attribute3,
X_ATTRIBUTE4 => p_party_site_rec.attribute4,
X_ATTRIBUTE5 => p_party_site_rec.attribute5,
X_ATTRIBUTE6 => p_party_site_rec.attribute6,
X_ATTRIBUTE7 => p_party_site_rec.attribute7,
X_ATTRIBUTE8 => p_party_site_rec.attribute8,
X_ATTRIBUTE9 => p_party_site_rec.attribute9,
X_ATTRIBUTE10 => p_party_site_rec.attribute10,
X_ATTRIBUTE11 => p_party_site_rec.attribute11,
X_ATTRIBUTE12 => p_party_site_rec.attribute12,
X_ATTRIBUTE13 => p_party_site_rec.attribute13,
X_ATTRIBUTE14 => p_party_site_rec.attribute14,
X_ATTRIBUTE15 => p_party_site_rec.attribute15,
X_ATTRIBUTE16 => p_party_site_rec.attribute16,
X_ATTRIBUTE17 => p_party_site_rec.attribute17,
X_ATTRIBUTE18 => p_party_site_rec.attribute18,
X_ATTRIBUTE19 => p_party_site_rec.attribute19,
X_ATTRIBUTE20 => p_party_site_rec.attribute20,
X_ORIG_SYSTEM_REFERENCE => p_party_site_rec.orig_system_reference,
X_LANGUAGE => p_party_site_rec.language,
X_MAILSTOP => p_party_site_rec.mailstop,
X_IDENTIFYING_ADDRESS_FLAG => p_party_site_rec.identifying_address_flag,
X_STATUS => p_party_site_rec.status,
X_PARTY_SITE_NAME => p_party_site_rec.party_site_name,
X_ADDRESSEE => p_party_site_rec.addressee,
X_OBJECT_VERSION_NUMBER => 1,
X_CREATED_BY_MODULE => p_party_site_rec.created_by_module,
X_APPLICATION_ID => p_party_site_rec.application_id,
X_ACTUAL_CONTENT_SOURCE => p_actual_cont_source,
X_GLOBAL_LOCATION_NUMBER => p_party_site_rec.global_location_number,
X_DUNS_NUMBER_C => p_party_site_rec.duns_number_c
);
procedure do_update_address(
p_party_id IN NUMBER,
p_location_id IN NUMBER
) IS
CURSOR c_loc IS
SELECT * FROM hz_locations
WHERE location_id = p_location_id;
SELECT 'Y'
FROM hz_parties
WHERE party_id = p_party_id
FOR UPDATE NOWAIT;
UPDATE hz_parties
SET country = l_location_rec.country,
address1 = l_location_rec.address1,
address2 = l_location_rec.address2,
address3 = l_location_rec.address3,
address4 = l_location_rec.address4,
city = l_location_rec.city,
postal_code = l_location_rec.postal_code,
state = l_location_rec.state,
province = l_location_rec.province,
county = l_location_rec.county
WHERE party_id = p_party_id;
END do_update_address;
SELECT rowid
FROM hz_party_sites
WHERE party_id = p_party_id
AND party_site_id <> nvl(p_party_site_id,-999)
AND identifying_address_flag = 'Y'
AND rownum = 1
FOR UPDATE NOWAIT;
UPDATE hz_party_sites
SET identifying_address_flag = 'N'
WHERE rowid = l_rowid;
p_selected_datasources => g_pst_selected_datasources );
HZ_PARTY_SITES_PKG.Select_Row (
X_PARTY_SITE_ID => x_party_site_rec.party_site_id,
X_PARTY_ID => x_party_site_rec.party_id,
X_LOCATION_ID => x_party_site_rec.location_id,
X_PARTY_SITE_NUMBER => x_party_site_rec.party_site_number,
X_ATTRIBUTE_CATEGORY => x_party_site_rec.attribute_category,
X_ATTRIBUTE1 => x_party_site_rec.attribute1,
X_ATTRIBUTE2 => x_party_site_rec.attribute2,
X_ATTRIBUTE3 => x_party_site_rec.attribute3,
X_ATTRIBUTE4 => x_party_site_rec.attribute4,
X_ATTRIBUTE5 => x_party_site_rec.attribute5,
X_ATTRIBUTE6 => x_party_site_rec.attribute6,
X_ATTRIBUTE7 => x_party_site_rec.attribute7,
X_ATTRIBUTE8 => x_party_site_rec.attribute8,
X_ATTRIBUTE9 => x_party_site_rec.attribute9,
X_ATTRIBUTE10 => x_party_site_rec.attribute10,
X_ATTRIBUTE11 => x_party_site_rec.attribute11,
X_ATTRIBUTE12 => x_party_site_rec.attribute12,
X_ATTRIBUTE13 => x_party_site_rec.attribute13,
X_ATTRIBUTE14 => x_party_site_rec.attribute14,
X_ATTRIBUTE15 => x_party_site_rec.attribute15,
X_ATTRIBUTE16 => x_party_site_rec.attribute16,
X_ATTRIBUTE17 => x_party_site_rec.attribute17,
X_ATTRIBUTE18 => x_party_site_rec.attribute18,
X_ATTRIBUTE19 => x_party_site_rec.attribute19,
X_ATTRIBUTE20 => x_party_site_rec.attribute20,
X_ORIG_SYSTEM_REFERENCE => x_party_site_rec.orig_system_reference,
X_LANGUAGE => x_party_site_rec.language,
X_MAILSTOP => x_party_site_rec.mailstop,
X_IDENTIFYING_ADDRESS_FLAG => x_party_site_rec.identifying_address_flag,
X_STATUS => x_party_site_rec.status,
X_PARTY_SITE_NAME => x_party_site_rec.party_site_name,
X_ADDRESSEE => x_party_site_rec.addressee,
X_CREATED_BY_MODULE => x_party_site_rec.created_by_module,
X_APPLICATION_ID => x_party_site_rec.application_id,
X_ACTUAL_CONTENT_SOURCE => x_actual_cont_source,
X_GLOBAL_LOCATION_NUMBER => x_party_site_rec.global_location_number,
X_DUNS_NUMBER_C => x_party_site_rec.duns_number_c
);
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_org_id
);
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_org_id
);
SELECT CUST_ACCOUNT_ID INTO p_customer_profile_rec.cust_account_id
FROM HZ_CUST_ACCT_SITES_ALL
WHERE CUST_ACCT_SITE_ID = p_cust_site_use_rec.cust_acct_site_id;
UPDATE HZ_CUST_ACCT_SITES_ALL
SET BILL_TO_FLAG = p_flag
WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
UPDATE HZ_CUST_ACCT_SITES_ALL
SET SHIP_TO_FLAG = p_flag
WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
UPDATE HZ_CUST_ACCT_SITES_ALL
SET MARKET_FLAG = p_flag
WHERE CUST_ACCT_SITE_ID = p_cust_acct_site_id;
HZ_CUSTOMER_PROFILES_PKG.Insert_Row (
X_CUST_ACCOUNT_PROFILE_ID=> p_customer_profile_rec.cust_account_profile_id,
X_CUST_ACCOUNT_ID => p_customer_profile_rec.cust_account_id,
X_STATUS => p_customer_profile_rec.status,
X_COLLECTOR_ID => p_customer_profile_rec.collector_id,
X_CREDIT_ANALYST_ID => p_customer_profile_rec.credit_analyst_id,
X_CREDIT_CHECKING => p_customer_profile_rec.credit_checking,
X_NEXT_CREDIT_REVIEW_DATE=> p_customer_profile_rec.next_credit_review_date,
X_TOLERANCE => p_customer_profile_rec.tolerance,
X_DISCOUNT_TERMS => p_customer_profile_rec.discount_terms,
X_DUNNING_LETTERS => p_customer_profile_rec.dunning_letters,
X_INTEREST_CHARGES => p_customer_profile_rec.interest_charges,
X_SEND_STATEMENTS => p_customer_profile_rec.send_statements,
X_CREDIT_BALANCE_STATEMENTS=> p_customer_profile_rec.credit_balance_statements,
X_CREDIT_HOLD => p_customer_profile_rec.credit_hold,
X_PROFILE_CLASS_ID => p_customer_profile_rec.profile_class_id,
X_SITE_USE_ID => p_customer_profile_rec.site_use_id,
X_CREDIT_RATING => p_customer_profile_rec.credit_rating,
X_RISK_CODE => p_customer_profile_rec.risk_code,
X_STANDARD_TERMS => p_customer_profile_rec.standard_terms,
X_OVERRIDE_TERMS => p_customer_profile_rec.override_terms,
X_DUNNING_LETTER_SET_ID => p_customer_profile_rec.dunning_letter_set_id,
X_INTEREST_PERIOD_DAYS => p_customer_profile_rec.interest_period_days,
X_PAYMENT_GRACE_DAYS => p_customer_profile_rec.payment_grace_days,
X_DISCOUNT_GRACE_DAYS => p_customer_profile_rec.discount_grace_days,
X_STATEMENT_CYCLE_ID => p_customer_profile_rec.statement_cycle_id,
X_ACCOUNT_STATUS => p_customer_profile_rec.account_status,
X_PERCENT_COLLECTABLE => p_customer_profile_rec.percent_collectable,
X_AUTOCASH_HIERARCHY_ID => p_customer_profile_rec.autocash_hierarchy_id,
X_ATTRIBUTE_CATEGORY => p_customer_profile_rec.attribute_category,
X_ATTRIBUTE1 => p_customer_profile_rec.attribute1,
X_ATTRIBUTE2 => p_customer_profile_rec.attribute2,
X_ATTRIBUTE3 => p_customer_profile_rec.attribute3,
X_ATTRIBUTE4 => p_customer_profile_rec.attribute4,
X_ATTRIBUTE5 => p_customer_profile_rec.attribute5,
X_ATTRIBUTE6 => p_customer_profile_rec.attribute6,
X_ATTRIBUTE7 => p_customer_profile_rec.attribute7,
X_ATTRIBUTE8 => p_customer_profile_rec.attribute8,
X_ATTRIBUTE9 => p_customer_profile_rec.attribute9,
X_ATTRIBUTE10 => p_customer_profile_rec.attribute10,
X_ATTRIBUTE11 => p_customer_profile_rec.attribute11,
X_ATTRIBUTE12 => p_customer_profile_rec.attribute12,
X_ATTRIBUTE13 => p_customer_profile_rec.attribute13,
X_ATTRIBUTE14 => p_customer_profile_rec.attribute14,
X_ATTRIBUTE15 => p_customer_profile_rec.attribute15,
X_AUTO_REC_INCL_DISPUTED_FLAG => p_customer_profile_rec.auto_rec_incl_disputed_flag,
X_TAX_PRINTING_OPTION => p_customer_profile_rec.tax_printing_option,
X_CHARGE_ON_FINANCE_CHARGE_FG => p_customer_profile_rec.charge_on_finance_charge_flag,
X_GROUPING_RULE_ID => p_customer_profile_rec.grouping_rule_id,
X_CLEARING_DAYS => p_customer_profile_rec.clearing_days,
X_JGZZ_ATTRIBUTE_CATEGORY=> p_customer_profile_rec.jgzz_attribute_category,
X_JGZZ_ATTRIBUTE1 => p_customer_profile_rec.jgzz_attribute1,
X_JGZZ_ATTRIBUTE2 => p_customer_profile_rec.jgzz_attribute2,
X_JGZZ_ATTRIBUTE3 => p_customer_profile_rec.jgzz_attribute3,
X_JGZZ_ATTRIBUTE4 => p_customer_profile_rec.jgzz_attribute4,
X_JGZZ_ATTRIBUTE5 => p_customer_profile_rec.jgzz_attribute5,
X_JGZZ_ATTRIBUTE6 => p_customer_profile_rec.jgzz_attribute6,
X_JGZZ_ATTRIBUTE7 => p_customer_profile_rec.jgzz_attribute7,
X_JGZZ_ATTRIBUTE8 => p_customer_profile_rec.jgzz_attribute8,
X_JGZZ_ATTRIBUTE9 => p_customer_profile_rec.jgzz_attribute9,
X_JGZZ_ATTRIBUTE10 => p_customer_profile_rec.jgzz_attribute10,
X_JGZZ_ATTRIBUTE11 => p_customer_profile_rec.jgzz_attribute11,
X_JGZZ_ATTRIBUTE12 => p_customer_profile_rec.jgzz_attribute12,
X_JGZZ_ATTRIBUTE13 => p_customer_profile_rec.jgzz_attribute13,
X_JGZZ_ATTRIBUTE14 => p_customer_profile_rec.jgzz_attribute14,
X_JGZZ_ATTRIBUTE15 => p_customer_profile_rec.jgzz_attribute15,
X_GLOBAL_ATTRIBUTE1 => p_customer_profile_rec.global_attribute1,
X_GLOBAL_ATTRIBUTE2 => p_customer_profile_rec.global_attribute2,
X_GLOBAL_ATTRIBUTE3 => p_customer_profile_rec.global_attribute3,
X_GLOBAL_ATTRIBUTE4 => p_customer_profile_rec.global_attribute4,
X_GLOBAL_ATTRIBUTE5 => p_customer_profile_rec.global_attribute5,
X_GLOBAL_ATTRIBUTE6 => p_customer_profile_rec.global_attribute6,
X_GLOBAL_ATTRIBUTE7 => p_customer_profile_rec.global_attribute7,
X_GLOBAL_ATTRIBUTE8 => p_customer_profile_rec.global_attribute8,
X_GLOBAL_ATTRIBUTE9 => p_customer_profile_rec.global_attribute9,
X_GLOBAL_ATTRIBUTE10 => p_customer_profile_rec.global_attribute10,
X_GLOBAL_ATTRIBUTE11 => p_customer_profile_rec.global_attribute11,
X_GLOBAL_ATTRIBUTE12 => p_customer_profile_rec.global_attribute12,
X_GLOBAL_ATTRIBUTE13 => p_customer_profile_rec.global_attribute13,
X_GLOBAL_ATTRIBUTE14 => p_customer_profile_rec.global_attribute14,
X_GLOBAL_ATTRIBUTE15 => p_customer_profile_rec.global_attribute15,
X_GLOBAL_ATTRIBUTE16 => p_customer_profile_rec.global_attribute16,
X_GLOBAL_ATTRIBUTE17 => p_customer_profile_rec.global_attribute17,
X_GLOBAL_ATTRIBUTE18 => p_customer_profile_rec.global_attribute18,
X_GLOBAL_ATTRIBUTE19 => p_customer_profile_rec.global_attribute19,
X_GLOBAL_ATTRIBUTE20 => p_customer_profile_rec.global_attribute20,
X_GLOBAL_ATTRIBUTE_CATEGORY=> p_customer_profile_rec.global_attribute_category,
X_CONS_INV_FLAG => p_customer_profile_rec.cons_inv_flag,
X_CONS_INV_TYPE => p_customer_profile_rec.cons_inv_type,
X_AUTOCASH_HIERARCHY_ID_ADR => p_customer_profile_rec.autocash_hierarchy_id_for_adr,
X_LOCKBOX_MATCHING_OPTION=> p_customer_profile_rec.lockbox_matching_option,
X_OBJECT_VERSION_NUMBER => 1,
X_CREATED_BY_MODULE => p_customer_profile_rec.created_by_module,
X_APPLICATION_ID => p_customer_profile_rec.application_id,
X_REVIEW_CYCLE => p_customer_profile_rec.review_cycle,
X_LAST_CREDIT_REVIEW_DATE=> p_customer_profile_rec.last_credit_review_date,
X_PARTY_ID => p_customer_profile_rec.party_id,
X_CREDIT_CLASSIFICATION => p_customer_profile_rec.credit_classification,
X_CONS_BILL_LEVEL => p_customer_profile_rec.cons_bill_level,
X_LATE_CHARGE_CALCULATION_TRX => p_customer_profile_rec.late_charge_calculation_trx,
X_CREDIT_ITEMS_FLAG => p_customer_profile_rec.credit_items_flag,
X_DISPUTED_TRANSACTIONS_FLAG => p_customer_profile_rec.disputed_transactions_flag,
X_LATE_CHARGE_TYPE => p_customer_profile_rec.late_charge_type,
X_LATE_CHARGE_TERM_ID => p_customer_profile_rec.late_charge_term_id,
X_INTEREST_CALCULATION_PERIOD => p_customer_profile_rec.interest_calculation_period,
X_HOLD_CHARGED_INVOICES_FLAG => p_customer_profile_rec.hold_charged_invoices_flag,
X_MESSAGE_TEXT_ID => p_customer_profile_rec.message_text_id,
X_MULTIPLE_INTEREST_RATES_FLAG => p_customer_profile_rec.multiple_interest_rates_flag,
X_CHARGE_BEGIN_DATE => p_customer_profile_rec.charge_begin_date,
X_AUTOMATCH_SET_ID => p_customer_profile_rec.automatch_set_id
);
HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (
X_CUST_ACCT_PROFILE_AMT_ID=>p_cust_profile_amt_rec.cust_acct_profile_amt_id,
X_CUST_ACCOUNT_PROFILE_ID => p_cust_profile_amt_rec.cust_account_profile_id,
X_CURRENCY_CODE => p_cust_profile_amt_rec.currency_code,
X_TRX_CREDIT_LIMIT => p_cust_profile_amt_rec.trx_credit_limit,
X_OVERALL_CREDIT_LIMIT => p_cust_profile_amt_rec.overall_credit_limit,
X_MIN_DUNNING_AMOUNT => p_cust_profile_amt_rec.min_dunning_amount,
X_MIN_DUNNING_INVOICE_AMOUNT=> p_cust_profile_amt_rec.min_dunning_invoice_amount,
X_MAX_INTEREST_CHARGE => p_cust_profile_amt_rec.max_interest_charge,
X_MIN_STATEMENT_AMOUNT => p_cust_profile_amt_rec.min_statement_amount,
X_AUTO_REC_MIN_RECEIPT_AMOUNT => p_cust_profile_amt_rec.auto_rec_min_receipt_amount,
X_INTEREST_RATE => p_cust_profile_amt_rec.interest_rate,
X_ATTRIBUTE_CATEGORY => p_cust_profile_amt_rec.attribute_category,
X_ATTRIBUTE1 => p_cust_profile_amt_rec.attribute1,
X_ATTRIBUTE2 => p_cust_profile_amt_rec.attribute2,
X_ATTRIBUTE3 => p_cust_profile_amt_rec.attribute3,
X_ATTRIBUTE4 => p_cust_profile_amt_rec.attribute4,
X_ATTRIBUTE5 => p_cust_profile_amt_rec.attribute5,
X_ATTRIBUTE6 => p_cust_profile_amt_rec.attribute6,
X_ATTRIBUTE7 => p_cust_profile_amt_rec.attribute7,
X_ATTRIBUTE8 => p_cust_profile_amt_rec.attribute8,
X_ATTRIBUTE9 => p_cust_profile_amt_rec.attribute9,
X_ATTRIBUTE10 => p_cust_profile_amt_rec.attribute10,
X_ATTRIBUTE11 => p_cust_profile_amt_rec.attribute11,
X_ATTRIBUTE12 => p_cust_profile_amt_rec.attribute12,
X_ATTRIBUTE13 => p_cust_profile_amt_rec.attribute13,
X_ATTRIBUTE14 => p_cust_profile_amt_rec.attribute14,
X_ATTRIBUTE15 => p_cust_profile_amt_rec.attribute15,
X_MIN_FC_BALANCE_AMOUNT => p_cust_profile_amt_rec.min_fc_balance_amount,
X_MIN_FC_INVOICE_AMOUNT => p_cust_profile_amt_rec.min_fc_invoice_amount,
X_CUST_ACCOUNT_ID => p_cust_profile_amt_rec.cust_account_id,
X_SITE_USE_ID => p_cust_profile_amt_rec.site_use_id,
X_EXPIRATION_DATE => p_cust_profile_amt_rec.expiration_date,
X_JGZZ_ATTRIBUTE_CATEGORY=> p_cust_profile_amt_rec.jgzz_attribute_category,
X_JGZZ_ATTRIBUTE1 => p_cust_profile_amt_rec.jgzz_attribute1,
X_JGZZ_ATTRIBUTE2 => p_cust_profile_amt_rec.jgzz_attribute2,
X_JGZZ_ATTRIBUTE3 => p_cust_profile_amt_rec.jgzz_attribute3,
X_JGZZ_ATTRIBUTE4 => p_cust_profile_amt_rec.jgzz_attribute4,
X_JGZZ_ATTRIBUTE5 => p_cust_profile_amt_rec.jgzz_attribute5,
X_JGZZ_ATTRIBUTE6 => p_cust_profile_amt_rec.jgzz_attribute6,
X_JGZZ_ATTRIBUTE7 => p_cust_profile_amt_rec.jgzz_attribute7,
X_JGZZ_ATTRIBUTE8 => p_cust_profile_amt_rec.jgzz_attribute8,
X_JGZZ_ATTRIBUTE9 => p_cust_profile_amt_rec.jgzz_attribute9,
X_JGZZ_ATTRIBUTE10 => p_cust_profile_amt_rec.jgzz_attribute10,
X_JGZZ_ATTRIBUTE11 => p_cust_profile_amt_rec.jgzz_attribute11,
X_JGZZ_ATTRIBUTE12 => p_cust_profile_amt_rec.jgzz_attribute12,
X_JGZZ_ATTRIBUTE13 => p_cust_profile_amt_rec.jgzz_attribute13,
X_JGZZ_ATTRIBUTE14 => p_cust_profile_amt_rec.jgzz_attribute14,
X_JGZZ_ATTRIBUTE15 => p_cust_profile_amt_rec.jgzz_attribute15,
X_GLOBAL_ATTRIBUTE1 => p_cust_profile_amt_rec.global_attribute1,
X_GLOBAL_ATTRIBUTE2 => p_cust_profile_amt_rec.global_attribute2,
X_GLOBAL_ATTRIBUTE3 => p_cust_profile_amt_rec.global_attribute3,
X_GLOBAL_ATTRIBUTE4 => p_cust_profile_amt_rec.global_attribute4,
X_GLOBAL_ATTRIBUTE5 => p_cust_profile_amt_rec.global_attribute5,
X_GLOBAL_ATTRIBUTE6 => p_cust_profile_amt_rec.global_attribute6,
X_GLOBAL_ATTRIBUTE7 => p_cust_profile_amt_rec.global_attribute7,
X_GLOBAL_ATTRIBUTE8 => p_cust_profile_amt_rec.global_attribute8,
X_GLOBAL_ATTRIBUTE9 => p_cust_profile_amt_rec.global_attribute9,
X_GLOBAL_ATTRIBUTE10 => p_cust_profile_amt_rec.global_attribute10,
X_GLOBAL_ATTRIBUTE11 => p_cust_profile_amt_rec.global_attribute11,
X_GLOBAL_ATTRIBUTE12 => p_cust_profile_amt_rec.global_attribute12,
X_GLOBAL_ATTRIBUTE13 => p_cust_profile_amt_rec.global_attribute13,
X_GLOBAL_ATTRIBUTE14 => p_cust_profile_amt_rec.global_attribute14,
X_GLOBAL_ATTRIBUTE15 => p_cust_profile_amt_rec.global_attribute15,
X_GLOBAL_ATTRIBUTE16 => p_cust_profile_amt_rec.global_attribute16,
X_GLOBAL_ATTRIBUTE17 => p_cust_profile_amt_rec.global_attribute17,
X_GLOBAL_ATTRIBUTE18 => p_cust_profile_amt_rec.global_attribute18,
X_GLOBAL_ATTRIBUTE19 => p_cust_profile_amt_rec.global_attribute19,
X_GLOBAL_ATTRIBUTE20 => p_cust_profile_amt_rec.global_attribute20,
X_GLOBAL_ATTRIBUTE_CATEGORY=> p_cust_profile_amt_rec.global_attribute_category,
X_OBJECT_VERSION_NUMBER => 1,
X_CREATED_BY_MODULE => p_cust_profile_amt_rec.created_by_module,
X_APPLICATION_ID => p_cust_profile_amt_rec.application_id,
X_EXCHANGE_RATE_TYPE => p_cust_profile_amt_rec.exchange_rate_type,
X_MIN_FC_INVOICE_OVERDUE_TYPE => p_cust_profile_amt_rec.min_fc_invoice_overdue_type,
X_MIN_FC_INVOICE_PERCENT => p_cust_profile_amt_rec.min_fc_invoice_percent,
X_MIN_FC_BALANCE_OVERDUE_TYPE => p_cust_profile_amt_rec.min_fc_balance_overdue_type,
X_MIN_FC_BALANCE_PERCENT => p_cust_profile_amt_rec.min_fc_balance_percent,
X_INTEREST_TYPE => p_cust_profile_amt_rec.interest_type,
X_INTEREST_FIXED_AMOUNT => p_cust_profile_amt_rec.interest_fixed_amount,
X_INTEREST_SCHEDULE_ID => p_cust_profile_amt_rec.interest_schedule_id,
X_PENALTY_TYPE => p_cust_profile_amt_rec.penalty_type,
X_PENALTY_RATE => p_cust_profile_amt_rec.penalty_rate,
X_MIN_INTEREST_CHARGE => p_cust_profile_amt_rec.min_interest_charge,
X_PENALTY_FIXED_AMOUNT => p_cust_profile_amt_rec.penalty_fixed_amount,
X_PENALTY_SCHEDULE_ID => p_cust_profile_amt_rec.penalty_schedule_id
);
SELECT 'Y'
FROM hz_contact_points
WHERE owner_table_name = p_owner_table_name
AND owner_table_id = p_owner_table_id
AND contact_point_type = p_contact_point_type
/* AND HZ_MIXNM_UTILITY.isDataSourceSelected (
g_cpt_selected_datasources, actual_content_source ) = 'Y'*/
AND status = 'A'
AND rownum = 1;
g_cpt_is_datasource_selected = 'Y'*/
THEN
-- First active and visible contact point per type for this entity
p_contact_point_rec.primary_flag := 'Y';
hz_contact_points_pkg.insert_row (
x_contact_point_id => p_contact_point_rec.contact_point_id,
x_contact_point_type => p_contact_point_rec.contact_point_type,
x_status => p_contact_point_rec.status,
x_owner_table_name => p_contact_point_rec.owner_table_name,
x_owner_table_id => p_contact_point_rec.owner_table_id,
x_primary_flag => p_contact_point_rec.primary_flag,
x_orig_system_reference => p_contact_point_rec.orig_system_reference,
x_attribute_category => p_contact_point_rec.attribute_category,
x_attribute1 => p_contact_point_rec.attribute1,
x_attribute2 => p_contact_point_rec.attribute2,
x_attribute3 => p_contact_point_rec.attribute3,
x_attribute4 => p_contact_point_rec.attribute4,
x_attribute5 => p_contact_point_rec.attribute5,
x_attribute6 => p_contact_point_rec.attribute6,
x_attribute7 => p_contact_point_rec.attribute7,
x_attribute8 => p_contact_point_rec.attribute8,
x_attribute9 => p_contact_point_rec.attribute9,
x_attribute10 => p_contact_point_rec.attribute10,
x_attribute11 => p_contact_point_rec.attribute11,
x_attribute12 => p_contact_point_rec.attribute12,
x_attribute13 => p_contact_point_rec.attribute13,
x_attribute14 => p_contact_point_rec.attribute14,
x_attribute15 => p_contact_point_rec.attribute15,
x_attribute16 => p_contact_point_rec.attribute16,
x_attribute17 => p_contact_point_rec.attribute17,
x_attribute18 => p_contact_point_rec.attribute18,
x_attribute19 => p_contact_point_rec.attribute19,
x_attribute20 => p_contact_point_rec.attribute20,
x_edi_transaction_handling => l_edi_rec.edi_transaction_handling,
x_edi_id_number => l_edi_rec.edi_id_number,
x_edi_payment_method => l_edi_rec.edi_payment_method,
x_edi_payment_format => l_edi_rec.edi_payment_format,
x_edi_remittance_method => l_edi_rec.edi_remittance_method,
x_edi_remittance_instruction => l_edi_rec.edi_remittance_instruction,
x_edi_tp_header_id => l_edi_rec.edi_tp_header_id,
x_edi_ece_tp_location_code => l_edi_rec.edi_ece_tp_location_code,
x_eft_transmission_program_id => l_eft_rec.eft_transmission_program_id,
x_eft_printing_program_id => l_eft_rec.eft_printing_program_id,
x_eft_user_number => l_eft_rec.eft_user_number,
x_eft_swift_code => l_eft_rec.eft_swift_code,
x_email_format => l_email_rec.email_format,
x_email_address => l_email_rec.email_address,
x_phone_calling_calendar => l_phone_rec.phone_calling_calendar,
x_last_contact_dt_time => l_phone_rec.last_contact_dt_time,
x_timezone_id => l_phone_rec.timezone_id,
x_phone_area_code => l_phone_rec.phone_area_code,
x_phone_country_code => l_phone_rec.phone_country_code,
x_phone_number => l_phone_rec.phone_number,
x_phone_extension => l_phone_rec.phone_extension,
x_phone_line_type => l_phone_rec.phone_line_type,
x_telex_number => l_telex_rec.telex_number,
x_web_type => l_web_rec.web_type,
x_url => l_web_rec.url,
x_content_source_type => p_contact_point_rec.content_source_type,
x_raw_phone_number => l_phone_rec.raw_phone_number,
x_object_version_number => 1,
x_contact_point_purpose => p_contact_point_rec.contact_point_purpose,
x_primary_by_purpose => p_contact_point_rec.primary_by_purpose,
x_created_by_module => p_contact_point_rec.created_by_module,
x_application_id => p_contact_point_rec.application_id,
x_transposed_phone_number => l_transposed_phone_number,
x_actual_content_source => p_contact_point_rec.actual_content_source
);
UPDATE hz_contact_points
SET primary_flag = 'N'
WHERE owner_table_name = p_owner_table_name
AND owner_table_id = p_owner_table_id
AND contact_point_type = p_contact_point_type
AND contact_point_id <> l_contact_point_id
-- AND content_source_type = hz_party_v2pub.g_miss_content_source_type
AND primary_flag = 'Y';
UPDATE hz_parties
SET url = p_url
WHERE party_id = p_party_id;
UPDATE hz_parties
SET email_address = p_email_address
WHERE party_id = p_party_id;
UPDATE hz_contact_points
SET primary_by_purpose = 'N'
WHERE owner_table_name = p_owner_table_name
AND owner_table_id = p_owner_table_id
AND contact_point_type = p_contact_point_type
AND contact_point_purpose = p_contact_point_purpose
AND contact_point_id <> l_contact_point_id
-- AND content_source_type = hz_party_v2pub.g_miss_content_source_type
AND primary_by_purpose = 'Y';
* For non-profile entities, the concept of select/de-select data-sources is obsoleted.
IF g_cpt_mixnmatch_enabled IS NULL THEN
HZ_MIXNM_UTILITY.LoadDataSources(
p_entity_name => 'HZ_CONTACT_POINTS',
p_entity_attr_id => g_cpt_entity_attr_id,
p_mixnmatch_enabled => g_cpt_mixnmatch_enabled,
p_selected_datasources => g_cpt_selected_datasources );
p_selected_datasources => g_cpt_selected_datasources,
p_content_source_type => l_contact_point_rec.content_source_type,
p_actual_content_source => l_contact_point_rec.actual_content_source,
x_is_datasource_selected => g_cpt_is_datasource_selected,
x_return_status => x_return_status );
hz_contact_points_pkg.select_row(
x_contact_point_id => x_contact_point_rec.contact_point_id,
x_contact_point_type => x_contact_point_rec.contact_point_type,
x_status => x_contact_point_rec.status,
x_owner_table_name => x_contact_point_rec.owner_table_name,
x_owner_table_id => x_contact_point_rec.owner_table_id,
x_primary_flag => x_contact_point_rec.primary_flag,
x_orig_system_reference => x_contact_point_rec.orig_system_reference,
x_attribute_category => x_contact_point_rec.attribute_category,
x_attribute1 => x_contact_point_rec.attribute1,
x_attribute2 => x_contact_point_rec.attribute2,
x_attribute3 => x_contact_point_rec.attribute3,
x_attribute4 => x_contact_point_rec.attribute4,
x_attribute5 => x_contact_point_rec.attribute5,
x_attribute6 => x_contact_point_rec.attribute6,
x_attribute7 => x_contact_point_rec.attribute7,
x_attribute8 => x_contact_point_rec.attribute8,
x_attribute9 => x_contact_point_rec.attribute9,
x_attribute10 => x_contact_point_rec.attribute10,
x_attribute11 => x_contact_point_rec.attribute11,
x_attribute12 => x_contact_point_rec.attribute12,
x_attribute13 => x_contact_point_rec.attribute13,
x_attribute14 => x_contact_point_rec.attribute14,
x_attribute15 => x_contact_point_rec.attribute15,
x_attribute16 => x_contact_point_rec.attribute16,
x_attribute17 => x_contact_point_rec.attribute17,
x_attribute18 => x_contact_point_rec.attribute18,
x_attribute19 => x_contact_point_rec.attribute19,
x_attribute20 => x_contact_point_rec.attribute20,
x_edi_transaction_handling => x_edi_rec.edi_transaction_handling,
x_edi_id_number => x_edi_rec.edi_id_number,
x_edi_payment_method => x_edi_rec.edi_payment_method,
x_edi_payment_format => x_edi_rec.edi_payment_format,
x_edi_remittance_method => x_edi_rec.edi_remittance_method,
x_edi_remittance_instruction => x_edi_rec.edi_remittance_instruction,
x_edi_tp_header_id => x_edi_rec.edi_tp_header_id,
x_edi_ece_tp_location_code => x_edi_rec.edi_ece_tp_location_code,
x_eft_transmission_program_id => x_eft_rec.eft_transmission_program_id,
x_eft_printing_program_id => x_eft_rec.eft_printing_program_id,
x_eft_user_number => x_eft_rec.eft_user_number,
x_eft_swift_code => x_eft_rec.eft_swift_code,
x_email_format => x_email_rec.email_format,
x_email_address => x_email_rec.email_address,
x_phone_calling_calendar => x_phone_rec.phone_calling_calendar,
x_last_contact_dt_time => x_phone_rec.last_contact_dt_time,
x_timezone_id => x_phone_rec.timezone_id,
x_phone_area_code => x_phone_rec.phone_area_code,
x_phone_country_code => x_phone_rec.phone_country_code,
x_phone_number => x_phone_rec.phone_number,
x_phone_extension => x_phone_rec.phone_extension,
x_phone_line_type => x_phone_rec.phone_line_type,
x_telex_number => x_telex_rec.telex_number,
x_web_type => x_web_rec.web_type,
x_url => x_web_rec.url,
x_content_source_type => x_contact_point_rec.content_source_type,
x_raw_phone_number => x_phone_rec.raw_phone_number,
x_contact_point_purpose => x_contact_point_rec.contact_point_purpose,
x_primary_by_purpose => x_contact_point_rec.primary_by_purpose,
x_created_by_module => x_contact_point_rec.created_by_module,
x_application_id => x_contact_point_rec.application_id,
x_transposed_phone_number => l_transposed_phone_number,
x_actual_content_source => x_contact_point_rec.actual_content_source
);
HZ_PARTY_SITE_USES_PKG.Select_Row (
X_PARTY_SITE_USE_ID => x_party_site_use_rec.party_site_use_id,
X_COMMENTS => x_party_site_use_rec.comments,
X_PARTY_SITE_ID => x_party_site_use_rec.party_site_id,
X_SITE_USE_TYPE => x_party_site_use_rec.site_use_type,
X_PRIMARY_PER_TYPE => x_party_site_use_rec.primary_per_type,
X_STATUS => x_party_site_use_rec.status,
X_CREATED_BY_MODULE => x_party_site_use_rec.created_by_module,
X_APPLICATION_ID => x_party_site_use_rec.application_id
);
SELECT ROWID
FROM HZ_PARTY_SITE_USES SU
WHERE SU.PARTY_SITE_ID IN (
SELECT PS.PARTY_SITE_ID
FROM HZ_PARTY_SITES PS
WHERE PARTY_ID = p_party_id )
AND SU.PARTY_SITE_ID <> p_party_site_id
AND SU.SITE_USE_TYPE = p_site_use_type
AND SU.PRIMARY_PER_TYPE = 'Y'
AND ROWNUM = 1
FOR UPDATE NOWAIT;
UPDATE HZ_PARTY_SITE_USES
SET PRIMARY_PER_TYPE = 'N',
last_update_date = hz_utility_v2pub.last_update_date,
last_updated_by = hz_utility_v2pub.last_updated_by,
last_update_login = hz_utility_v2pub.last_update_login,
request_id = hz_utility_v2pub.request_id,
program_id = hz_utility_v2pub.program_id,
program_application_id = hz_utility_v2pub.program_application_id,
program_update_date = hz_utility_v2pub.program_update_date
WHERE ROWID = l_rowid;
SELECT PARTY_ID
INTO l_party_id
FROM HZ_PARTY_SITES
WHERE PARTY_SITE_ID = p_party_site_use_rec.party_site_id;
SELECT 'Y'
INTO l_exist
FROM HZ_PARTY_SITE_USES SU
WHERE PARTY_SITE_ID IN (
SELECT PARTY_SITE_ID
FROM HZ_PARTY_SITES PS
WHERE PS.PARTY_ID = l_party_id )
AND SU.SITE_USE_TYPE = p_party_site_use_rec.site_use_type
AND ROWNUM = 1;
HZ_PARTY_SITE_USES_PKG.Insert_Row (
X_PARTY_SITE_USE_ID => p_party_site_use_rec.party_site_use_id,
X_COMMENTS => p_party_site_use_rec.comments,
X_PARTY_SITE_ID => p_party_site_use_rec.party_site_id,
X_SITE_USE_TYPE => p_party_site_use_rec.site_use_type,
X_PRIMARY_PER_TYPE => p_party_site_use_rec.primary_per_type,
X_STATUS => p_party_site_use_rec.status,
X_OBJECT_VERSION_NUMBER => 1,
X_CREATED_BY_MODULE => p_party_site_use_rec.created_by_module,
X_APPLICATION_ID => p_party_site_use_rec.application_id
);