Archives

Saturday, August 15, 2015

HZ API for Party, Party Site, Location, Relationship...

Create Party API (Sample Code)


/* Formatted on 7/10/2014 11:36:13 AM (QP5 v5.240.12305.39446) */
DECLARE
   l_location_id     NUMBER;
   l_return_status   VARCHAR2 (200);
   l_msg_count       NUMBER;
   l_msg_data        VARCHAR2 (200);
   l_location_rec    hz_location_v2pub.location_rec_type;
BEGIN
   l_location_rec.country := 'US';
   l_location_rec.address1 := '12345 E COLORADO AVE';
   l_location_rec.address2 := NULL;
   l_location_rec.address3 := NULL;
   l_location_rec.address4 := NULL;
   l_location_rec.city := 'LOS ANGELES';
   l_location_rec.postal_code := '91101';
   l_location_rec.state := 'CA';
   l_location_rec.province := NULL;
   l_location_rec.county := 'LOS ANGELES';
   l_location_rec.created_by_module := 'TCA_V1_API';

   HZ_LOCATION_V2PUB.CREATE_LOCATION (p_init_msg_list   => FND_API.G_FALSE,
                                      p_location_rec    => l_location_rec,
                                      x_location_id     => l_location_id,
                                      x_return_status   => l_return_status,
                                      x_msg_count       => l_msg_count,
                                      x_msg_data        => l_msg_data);
   DBMS_OUTPUT.put_line ('Status is ' || l_return_status||' - '||l_location_id);

   FOR i IN 1 .. l_msg_count
   LOOP
      fnd_msg_pub.get (p_msg_index       => i,
                       p_encoded         => 'F',
                       p_data            => l_msg_data,
                       p_msg_index_out   => l_msg_count);
      DBMS_OUTPUT.put_line (l_msg_data);
   END LOOP;
END;

Create Party Site API (Sample Code)

DECLARE
   l_party_site_id         NUMBER;
   l_party_site_number     VARCHAR2 (200);
   l_return_status         VARCHAR2 (200);
   l_msg_count             NUMBER;
   l_msg_data              VARCHAR2 (200);
   l_party_site_rec_type   hz_party_site_v2pub.party_site_rec_type;
BEGIN
   l_party_site_rec_type.party_id := 1528477;
   l_party_site_rec_type.location_id := 347705;
   l_party_site_rec_type.orig_system_reference := NULL;
   l_party_site_rec_type.orig_system := NULL;
   l_party_site_rec_type.mailstop := NULL;
   l_party_site_rec_type.identifying_address_flag := NULL;
   l_party_site_rec_type.status := 'A';
   l_party_site_rec_type.attribute_category := NULL;
   l_party_site_rec_type.attribute1 := NULL;
   l_party_site_rec_type.attribute2 := NULL;
   l_party_site_rec_type.attribute3 := NULL;
   l_party_site_rec_type.attribute4 := NULL;
   l_party_site_rec_type.attribute5 := NULL;
   l_party_site_rec_type.attribute6 := NULL;
   l_party_site_rec_type.attribute7 := NULL;
   l_party_site_rec_type.attribute8 := NULL;
   l_party_site_rec_type.attribute9 := NULL;
   l_party_site_rec_type.attribute10 := NULL;
   l_party_site_rec_type.attribute11 := NULL;
   l_party_site_rec_type.attribute12 := NULL;
   l_party_site_rec_type.attribute13 := NULL;
   l_party_site_rec_type.attribute14 := NULL;
   l_party_site_rec_type.attribute15 := NULL;
   l_party_site_rec_type.attribute16 := NULL;
   l_party_site_rec_type.attribute17 := NULL;
   l_party_site_rec_type.attribute18 := NULL;
   l_party_site_rec_type.attribute19 := NULL;
   l_party_site_rec_type.attribute20 := NULL;
   l_party_site_rec_type.language := NULL;
   l_party_site_rec_type.addressee := NULL;
   l_party_site_rec_type.created_by_module := 'TCA_V1_API';
   l_party_site_rec_type.application_id := NULL;
   l_party_site_rec_type.global_location_number := NULL;
   l_party_site_rec_type.duns_number_c := NULL;

   hz_party_site_v2pub.create_party_site (
      p_init_msg_list       => FND_API.G_FALSE,
      p_party_site_rec      => l_party_site_rec_type,
      x_party_site_id       => l_party_site_id,
      x_party_site_number   => l_party_site_number,
      x_return_status       => l_return_status,
      x_msg_count           => l_msg_count,
      x_msg_data            => l_msg_data);
   DBMS_OUTPUT.put_line ('status is ' || l_return_status);
END;


Create Location API (Sample Code)


/* Formatted on 7/10/2014 11:36:13 AM (QP5 v5.240.12305.39446) */
DECLARE
   l_location_id     NUMBER;
   l_return_status   VARCHAR2 (200);
   l_msg_count       NUMBER;
   l_msg_data        VARCHAR2 (200);
   l_location_rec    hz_location_v2pub.location_rec_type;
BEGIN
   l_location_rec.country := 'US';
   l_location_rec.address1 := '12345 E COLORADO AVE';
   l_location_rec.address2 := NULL;
   l_location_rec.address3 := NULL;
   l_location_rec.address4 := NULL;
   l_location_rec.city := 'LOS ANGELES';
   l_location_rec.postal_code := '91101';
   l_location_rec.state := 'CA';
   l_location_rec.province := NULL;
   l_location_rec.county := 'LOS ANGELES';
   l_location_rec.created_by_module := 'TCA_V1_API';

   HZ_LOCATION_V2PUB.CREATE_LOCATION (p_init_msg_list   => FND_API.G_FALSE,
                                      p_location_rec    => l_location_rec,
                                      x_location_id     => l_location_id,
                                      x_return_status   => l_return_status,
                                      x_msg_count       => l_msg_count,
                                      x_msg_data        => l_msg_data);
   DBMS_OUTPUT.put_line ('Status is ' || l_return_status||' - '||l_location_id);

   FOR i IN 1 .. l_msg_count
   LOOP
      fnd_msg_pub.get (p_msg_index       => i,
                       p_encoded         => 'F',
                       p_data            => l_msg_data,
                       p_msg_index_out   => l_msg_count);
      DBMS_OUTPUT.put_line (l_msg_data);
   END LOOP;
END;

 Create/Update Relationship API (Sample Code)

-- create relationship
declare
 l_relationship_id    number;
 l_party_id           number;
 l_party_number       number;
 l_return_status      varchar2(200);
 l_msg_count          number;
 l_msg_data           varchar2(200);
 l_relationship_rec   hz_relationship_V2pub.relationship_rec_type;
 l_party_rec_type      hz_party_v2pub.party_rec_type;
 l_rel_obj_ver_num    number;
 l_par_obj_ver_num    number;
begin
 --l_party_rec_type.party_id := 1528471;
 --l_party_rec_type.object_version_number := 1;

--l_relationship_rec.object_version_number                  := 1;
l_relationship_rec.subject_id                            := 1528475;
l_relationship_rec.subject_type                          := 'ORGANIZATION';
l_relationship_rec.subject_table_name                    := 'HZ_PARTIES';
l_relationship_rec.object_id                             := 1528476; -- CONTACT PARTY_ID
l_relationship_rec.object_type                           := 'PERSON';
l_relationship_rec.object_table_name                     := 'HZ_PARTIES';
l_relationship_rec.relationship_code                     := 'CONTACT';
l_relationship_rec.relationship_type                     := 'CONTACT';
l_relationship_rec.comments                              := 'Party Relationship between Organization and Person '||sysdate;
l_relationship_rec.start_date                            := sysdate;
l_relationship_rec.end_date                              := null;
l_relationship_rec.status                                := 'A';
l_relationship_rec.content_source_type                   := 'USER_ENTERED';
l_relationship_rec.attribute_category                    := null;
l_relationship_rec.attribute1                            := null;
l_relationship_rec.attribute2                            := null;
l_relationship_rec.attribute3                            := null;
l_relationship_rec.attribute4                            := null;
l_relationship_rec.attribute5                            := null;
l_relationship_rec.attribute6                            := null;
l_relationship_rec.attribute7                            := null;
l_relationship_rec.attribute8                            := null;
l_relationship_rec.attribute9                            := null;
l_relationship_rec.attribute10                           := null;
l_relationship_rec.attribute11                           := null;
l_relationship_rec.attribute12                           := null;
l_relationship_rec.attribute13                           := null;
l_relationship_rec.attribute14                           := null;
l_relationship_rec.attribute15                           := null;
l_relationship_rec.attribute16                           := null;
l_relationship_rec.attribute17                           := null;
l_relationship_rec.attribute18                           := null;
l_relationship_rec.attribute19                           := null;
l_relationship_rec.attribute20                           := null;
l_relationship_rec.created_by_module                     := 'TCA_V1_API';
l_relationship_rec.application_id                        := null;
l_relationship_rec.party_rec                             := l_party_rec_type;
l_relationship_rec.additional_information1               := null;
l_relationship_rec.additional_information2               := null;
l_relationship_rec.additional_information3               := null;
l_relationship_rec.additional_information4               := null;
l_relationship_rec.additional_information5               := null;
l_relationship_rec.additional_information6               := null;
l_relationship_rec.additional_information7               := null;
l_relationship_rec.additional_information8               := null;
l_relationship_rec.additional_information9               := null;
l_relationship_rec.additional_information10              := null;
l_relationship_rec.additional_information11              := null;
l_relationship_rec.additional_information12              := null;
l_relationship_rec.additional_information13              := null;
l_relationship_rec.additional_information14              := null;
l_relationship_rec.additional_information15              := null;
l_relationship_rec.additional_information16              := null;
l_relationship_rec.additional_information17              := null;
l_relationship_rec.additional_information18              := null;
l_relationship_rec.additional_information19              := null;
l_relationship_rec.additional_information20              := null;
l_relationship_rec.additional_information21              := null;
l_relationship_rec.additional_information22              := null;
l_relationship_rec.additional_information23              := null;
l_relationship_rec.additional_information24              := null;
l_relationship_rec.additional_information25              := null;
l_relationship_rec.additional_information26              := null;
l_relationship_rec.additional_information27              := null;
l_relationship_rec.additional_information28              := null;
l_relationship_rec.additional_information29              := null;
l_relationship_rec.additional_information30              := null;
l_relationship_rec.percentage_ownership                  := null;
l_relationship_rec.actual_content_source                 := null;

hz_relationship_v2pub.create_relationship (
    p_init_msg_list              => FND_API.G_FALSE
    ,p_relationship_rec          => l_relationship_rec
    ,x_relationship_id           => l_relationship_id
    ,x_party_id                  => l_party_id
    ,x_party_number              => l_party_number
    ,x_return_status             => l_return_status
    ,x_msg_count                 => l_msg_count
    ,x_msg_data                  => l_msg_data
);
/*
 hz_relationship_v2pub.update_relationship (
    p_init_msg_list                => FND_API.G_FALSE
    ,p_relationship_rec            => l_relationship_rec
    ,p_object_version_number       => l_rel_obj_ver_num
    ,p_party_object_version_number => l_par_obj_ver_num
    ,x_return_status               => l_return_status
    ,x_msg_count                   => l_msg_count
    ,x_msg_data                    => l_msg_data
);
*/
dbms_output.put_line ('Relation ship Status is '||l_return_status||' - relationship_id is '||l_relationship_id);
end;

Create Person API (Sample Code)

-- Create person for Organization
DECLARE
   l_return_status           VARCHAR2 (100);
   l_msg_count               NUMBER;
   l_msg_data                VARCHAR2 (100);
   l_party_id                NUMBER;
   l_party_number            VARCHAR2 (100);
   l_profile_id              NUMBER;
   l_ORGANIZATION_REC_TYPE   hz_party_v2pub.PERSON_REC_TYPE;
   L_PARTY_REC_TYPE          HZ_PARTY_V2PUB.PERSON_REC_TYPE;
   L_PARTY_REC_TYPE_X        HZ_PARTY_V2PUB.PARTY_REC_TYPE;
BEGIN
   L_PARTY_REC_TYPE.person_pre_name_adjunct := NULL;
   L_PARTY_REC_TYPE.person_first_name := 'SXJ_SK1_FN';
   L_PARTY_REC_TYPE.person_middle_name := NULL;
   L_PARTY_REC_TYPE.person_last_name := 'JS';
   L_PARTY_REC_TYPE.person_name_suffix := NULL;
   L_PARTY_REC_TYPE.person_title := NULL;
   L_PARTY_REC_TYPE.person_academic_title := NULL;
   L_PARTY_REC_TYPE.person_previous_last_name := NULL;
   L_PARTY_REC_TYPE.person_initials := NULL;
   L_PARTY_REC_TYPE.known_as := NULL;
   L_PARTY_REC_TYPE.known_as2 := NULL;
   L_PARTY_REC_TYPE.known_as3 := NULL;
   L_PARTY_REC_TYPE.known_as4 := NULL;
   L_PARTY_REC_TYPE.known_as5 := NULL;
   L_PARTY_REC_TYPE.person_name_phonetic := NULL;
   L_PARTY_REC_TYPE.person_first_name_phonetic := NULL;
   L_PARTY_REC_TYPE.person_last_name_phonetic := NULL;
   L_PARTY_REC_TYPE.middle_name_phonetic := NULL;
   L_PARTY_REC_TYPE.tax_reference := NULL;
   L_PARTY_REC_TYPE.jgzz_fiscal_code := NULL;
   L_PARTY_REC_TYPE.person_iden_type := NULL;
   L_PARTY_REC_TYPE.person_identifier := NULL;
   L_PARTY_REC_TYPE.date_of_birth := NULL;
   L_PARTY_REC_TYPE.place_of_birth := NULL;
   L_PARTY_REC_TYPE.date_of_death := NULL;
   L_PARTY_REC_TYPE.deceased_flag := NULL;
   L_PARTY_REC_TYPE.gender := NULL;
   L_PARTY_REC_TYPE.declared_ethnicity := NULL;
   L_PARTY_REC_TYPE.marital_status := NULL;
   L_PARTY_REC_TYPE.marital_status_effective_date := NULL;
   L_PARTY_REC_TYPE.personal_income := NULL;
   L_PARTY_REC_TYPE.head_of_household_flag := NULL;
   L_PARTY_REC_TYPE.household_income := NULL;
   L_PARTY_REC_TYPE.household_size := NULL;
   L_PARTY_REC_TYPE.rent_own_ind := NULL;
   L_PARTY_REC_TYPE.last_known_gps := NULL;
   L_PARTY_REC_TYPE.content_source_type := NULL;
   L_PARTY_REC_TYPE.internal_flag := NULL;
   L_PARTY_REC_TYPE.attribute_category := NULL;
   L_PARTY_REC_TYPE.attribute1 := NULL;
   L_PARTY_REC_TYPE.attribute2 := NULL;
   L_PARTY_REC_TYPE.attribute3 := NULL;
   L_PARTY_REC_TYPE.attribute4 := NULL;
   L_PARTY_REC_TYPE.attribute5 := NULL;
   L_PARTY_REC_TYPE.attribute6 := NULL;
   L_PARTY_REC_TYPE.attribute7 := NULL;
   L_PARTY_REC_TYPE.attribute8 := NULL;
   L_PARTY_REC_TYPE.attribute9 := NULL;
   L_PARTY_REC_TYPE.attribute10 := NULL;
   L_PARTY_REC_TYPE.attribute11 := NULL;
   L_PARTY_REC_TYPE.attribute12 := NULL;
   L_PARTY_REC_TYPE.attribute13 := NULL;
   L_PARTY_REC_TYPE.attribute14 := NULL;
   L_PARTY_REC_TYPE.attribute15 := NULL;
   L_PARTY_REC_TYPE.attribute16 := NULL;
   L_PARTY_REC_TYPE.attribute17 := NULL;
   L_PARTY_REC_TYPE.attribute18 := NULL;
   L_PARTY_REC_TYPE.attribute19 := NULL;
   L_PARTY_REC_TYPE.attribute20 := NULL;
   L_PARTY_REC_TYPE.created_by_module := 'TCA_V1_API';
   L_PARTY_REC_TYPE.application_id := NULL;
   L_PARTY_REC_TYPE.actual_content_source := NULL;
   L_PARTY_REC_TYPE.party_rec := L_PARTY_REC_TYPE_X;

   HZ_PARTY_V2PUB.CREATE_PERSON (p_init_msg_list   => FND_API.G_FALSE,
                                 p_person_rec      => L_PARTY_REC_TYPE,
                                 x_party_id        => l_party_id,
                                 x_party_number    => l_party_number,
                                 x_profile_id      => l_profile_id,
                                 x_return_status   => l_return_status,
                                 x_msg_count       => l_msg_count,
                                 x_msg_data        => l_msg_data);
   DBMS_OUTPUT.put_line ('Status is ' || l_return_status||' - PERSON PARTY ID - '||L_PARTY_ID);
END;
COMMIT;

Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)