[Home] [Help]
935: party_rec hz_party_v2pub.party_rec_type;
936: org_rec hz_party_v2pub.organization_rec_type;
937: person_rec hz_party_v2pub.person_rec_type;
938: location_rec hz_location_v2pub.location_rec_type;
939: psite_rec hz_party_site_v2pub.party_site_rec_type;
940: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
941: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
942: email_rec hz_contact_point_v2pub.email_rec_type;
943: phone_rec hz_contact_point_v2pub.phone_rec_type;
936: org_rec hz_party_v2pub.organization_rec_type;
937: person_rec hz_party_v2pub.person_rec_type;
938: location_rec hz_location_v2pub.location_rec_type;
939: psite_rec hz_party_site_v2pub.party_site_rec_type;
940: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
941: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
942: email_rec hz_contact_point_v2pub.email_rec_type;
943: phone_rec hz_contact_point_v2pub.phone_rec_type;
944: fax_rec hz_contact_point_v2pub.phone_rec_type;
949:
950: org_email_rec hz_contact_point_v2pub.email_rec_type;
951: org_phone_rec hz_contact_point_v2pub.phone_rec_type;
952: org_location_rec hz_location_v2pub.location_rec_type;
953: org_psite_rec hz_party_site_v2pub.party_site_rec_type;
954: language_rec HZ_PERSON_INFO_V2PUB.person_language_rec_type;
955:
956:
957: begin
4907: party_rec hz_party_v2pub.party_rec_type;
4908: org_rec hz_party_v2pub.organization_rec_type;
4909: person_rec hz_party_v2pub.person_rec_type;
4910: location_rec hz_location_v2pub.location_rec_type;
4911: psite_rec hz_party_site_v2pub.party_site_rec_type;
4912: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
4913: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
4914: email_rec hz_contact_point_v2pub.email_rec_type;
4915: phone_rec hz_contact_point_v2pub.phone_rec_type;
4908: org_rec hz_party_v2pub.organization_rec_type;
4909: person_rec hz_party_v2pub.person_rec_type;
4910: location_rec hz_location_v2pub.location_rec_type;
4911: psite_rec hz_party_site_v2pub.party_site_rec_type;
4912: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
4913: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
4914: email_rec hz_contact_point_v2pub.email_rec_type;
4915: phone_rec hz_contact_point_v2pub.phone_rec_type;
4916: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
13558:
13559: -- --------------------------------------------------------
13560:
13561: procedure create_party_site (
13562: p_psite_rec IN hz_party_site_v2pub.party_site_rec_type,
13563: x_return_status OUT NOCOPY VARCHAR2,
13564: x_msg_count OUT NOCOPY NUMBER,
13565: x_msg_data OUT NOCOPY VARCHAR2,
13566: x_party_site_id OUT NOCOPY NUMBER,
13567: x_party_site_number OUT NOCOPY VARCHAR2
13568: ) IS
13569:
13570: x_gen_party_site_number VARCHAR2(1);
13571: psite_rec hz_party_site_v2pub.party_site_rec_type := p_psite_rec;
13572:
13573: begin
13574: x_gen_party_site_number := fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER');
13575: x_party_site_number := null;
13595: x_party_site_id,
13596: x_party_site_number
13597: );
13598: */
13599: hz_party_site_v2pub.create_party_site(
13600: 'F',
13601: psite_rec,
13602: x_party_site_id,
13603: x_party_site_number,
16160: party_rec hz_party_v2pub.party_rec_type;
16161: org_rec hz_party_v2pub.organization_rec_type;
16162: person_rec hz_party_v2pub.person_rec_type;
16163: location_rec hz_location_v2pub.location_rec_type;
16164: psite_rec hz_party_site_v2pub.party_site_rec_type;
16165: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
16166: email_rec hz_contact_point_v2pub.email_rec_type;
16167: phone_rec hz_contact_point_v2pub.phone_rec_type;
16168: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
17110: party_rec hz_party_v2pub.party_rec_type;
17111: org_rec hz_party_v2pub.organization_rec_type;
17112: person_rec hz_party_v2pub.person_rec_type;
17113: location_rec hz_location_v2pub.location_rec_type;
17114: psite_rec hz_party_site_v2pub.party_site_rec_type;
17115: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
17116: email_rec hz_contact_point_v2pub.email_rec_type;
17117: phone_rec hz_contact_point_v2pub.phone_rec_type;
17118: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
18350: -- This procedure is used to create party site use
18351: --
18352:
18353: procedure create_party_site_use (
18354: p_psiteuse_rec IN hz_party_site_v2pub.party_site_use_rec_type,
18355: x_return_status OUT NOCOPY VARCHAR2,
18356: x_msg_count OUT NOCOPY NUMBER,
18357: x_msg_data OUT NOCOPY VARCHAR2,
18358: x_party_site_use_id OUT NOCOPY NUMBER
18357: x_msg_data OUT NOCOPY VARCHAR2,
18358: x_party_site_use_id OUT NOCOPY NUMBER
18359: ) IS
18360:
18361: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type := p_psiteuse_rec;
18362:
18363: begin
18364:
18365: psiteuse_rec.CREATED_BY_MODULE := 'AMS_LIST_IMPORT';
18363: begin
18364:
18365: psiteuse_rec.CREATED_BY_MODULE := 'AMS_LIST_IMPORT';
18366: psiteuse_rec.application_id := 530;
18367: hz_party_site_v2pub.create_party_site_use(
18368: 'F',
18369: psiteuse_rec,
18370: x_party_site_use_id,
18371: x_return_status,