12964: l_new_party Varchar2(1);
12965: x_tmp_var VARCHAR2(4000);
12966: x_tmp_var1 VARCHAR2(4000);
12967:
12968: party_rec hz_party_v2pub.party_rec_type;
12969: org_rec hz_party_v2pub.organization_rec_type;
12970: person_rec hz_party_v2pub.person_rec_type;
12971: location_rec hz_location_v2pub.location_rec_type;
12972: psite_rec hz_party_site_v2pub.party_site_rec_type;
12965: x_tmp_var VARCHAR2(4000);
12966: x_tmp_var1 VARCHAR2(4000);
12967:
12968: party_rec hz_party_v2pub.party_rec_type;
12969: org_rec hz_party_v2pub.organization_rec_type;
12970: person_rec hz_party_v2pub.person_rec_type;
12971: location_rec hz_location_v2pub.location_rec_type;
12972: psite_rec hz_party_site_v2pub.party_site_rec_type;
12973: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
12966: x_tmp_var1 VARCHAR2(4000);
12967:
12968: party_rec hz_party_v2pub.party_rec_type;
12969: org_rec hz_party_v2pub.organization_rec_type;
12970: person_rec hz_party_v2pub.person_rec_type;
12971: location_rec hz_location_v2pub.location_rec_type;
12972: psite_rec hz_party_site_v2pub.party_site_rec_type;
12973: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
12974: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;