DBA Data[Home] [Help]

APPS.AMS_LISTIMPORT_PVT dependencies on HZ_PARTY_V2PUB

Line 935: party_rec hz_party_v2pub.party_rec_type;

931: cursor c_hdr_status is
932: select status_code from ams_imp_list_headers_all
933: where import_list_header_id = p_import_list_header_id;
934:
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;

Line 936: org_rec hz_party_v2pub.organization_rec_type;

932: select status_code from ams_imp_list_headers_all
933: where import_list_header_id = p_import_list_header_id;
934:
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;

Line 937: person_rec hz_party_v2pub.person_rec_type;

933: where import_list_header_id = p_import_list_header_id;
934:
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;

Line 4906: party_rec hz_party_v2pub.party_rec_type;

4902: SELECT party_site_id FROM hz_party_sites
4903: WHERE party_id = x_per_party_id
4904: AND location_id = x_location_id;
4905:
4906: party_rec hz_party_v2pub.party_rec_type;
4907: org_rec hz_party_v2pub.organization_rec_type;
4908: person_rec hz_party_v2pub.person_rec_type;
4909: location_rec hz_location_v2pub.location_rec_type;
4910: psite_rec hz_party_site_v2pub.party_site_rec_type;

Line 4907: org_rec hz_party_v2pub.organization_rec_type;

4903: WHERE party_id = x_per_party_id
4904: AND location_id = x_location_id;
4905:
4906: party_rec hz_party_v2pub.party_rec_type;
4907: org_rec hz_party_v2pub.organization_rec_type;
4908: person_rec hz_party_v2pub.person_rec_type;
4909: location_rec hz_location_v2pub.location_rec_type;
4910: psite_rec hz_party_site_v2pub.party_site_rec_type;
4911: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;

Line 4908: person_rec hz_party_v2pub.person_rec_type;

4904: AND location_id = x_location_id;
4905:
4906: party_rec hz_party_v2pub.party_rec_type;
4907: org_rec hz_party_v2pub.organization_rec_type;
4908: person_rec hz_party_v2pub.person_rec_type;
4909: location_rec hz_location_v2pub.location_rec_type;
4910: psite_rec hz_party_site_v2pub.party_site_rec_type;
4911: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type;
4912: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;

Line 5169: hz_party_v2pub.update_organization(

5165: FROM hz_parties
5166: WHERE party_id= x_org_party_id;
5167: x_date1 := l_last_update_date;
5168: org_rec.party_rec.status := 'A';
5169: hz_party_v2pub.update_organization(
5170: 'F',
5171: org_rec,
5172: l_object_version,
5173: x_profile_id,

Line 5206: hz_party_v2pub.update_person(

5202: person_rec.party_rec.party_id := x_person_id;
5203: person_rec.party_rec.status := 'A';
5204: person_rec.CREATED_BY_MODULE := 'AMS_LIST_IMPORT';
5205: person_rec.application_id := 530;
5206: hz_party_v2pub.update_person(
5207: 'F',
5208: person_rec,
5209: l_object_version,
5210: x_profile_id,

Line 5573: hz_party_v2pub.update_person(

5569: person_rec.party_rec.party_id := p_party_id;
5570: person_rec.party_rec.status := 'A';
5571: person_rec.CREATED_BY_MODULE := 'AMS_LIST_IMPORT';
5572: person_rec.application_id := 530;
5573: hz_party_v2pub.update_person(
5574: 'F',
5575: person_rec,
5576: l_object_version,
5577: x_profile_id,

Line 16159: party_rec hz_party_v2pub.party_rec_type;

16155: l_pho_element_id NUMBER;
16156: l_ema_element_id NUMBER;
16157: l_rec NUMBER := 1;
16158:
16159: party_rec hz_party_v2pub.party_rec_type;
16160: org_rec hz_party_v2pub.organization_rec_type;
16161: person_rec hz_party_v2pub.person_rec_type;
16162: location_rec hz_location_v2pub.location_rec_type;
16163: psite_rec hz_party_site_v2pub.party_site_rec_type;

Line 16160: org_rec hz_party_v2pub.organization_rec_type;

16156: l_ema_element_id NUMBER;
16157: l_rec NUMBER := 1;
16158:
16159: party_rec hz_party_v2pub.party_rec_type;
16160: org_rec hz_party_v2pub.organization_rec_type;
16161: person_rec hz_party_v2pub.person_rec_type;
16162: location_rec hz_location_v2pub.location_rec_type;
16163: psite_rec hz_party_site_v2pub.party_site_rec_type;
16164: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;

Line 16161: person_rec hz_party_v2pub.person_rec_type;

16157: l_rec NUMBER := 1;
16158:
16159: party_rec hz_party_v2pub.party_rec_type;
16160: org_rec hz_party_v2pub.organization_rec_type;
16161: person_rec hz_party_v2pub.person_rec_type;
16162: location_rec hz_location_v2pub.location_rec_type;
16163: psite_rec hz_party_site_v2pub.party_site_rec_type;
16164: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
16165: email_rec hz_contact_point_v2pub.email_rec_type;

Line 17109: party_rec hz_party_v2pub.party_rec_type;

17105: l_pho_element_id NUMBER;
17106: l_ema_element_id NUMBER;
17107: l_rec NUMBER := 1;
17108:
17109: party_rec hz_party_v2pub.party_rec_type;
17110: org_rec hz_party_v2pub.organization_rec_type;
17111: person_rec hz_party_v2pub.person_rec_type;
17112: location_rec hz_location_v2pub.location_rec_type;
17113: psite_rec hz_party_site_v2pub.party_site_rec_type;

Line 17110: org_rec hz_party_v2pub.organization_rec_type;

17106: l_ema_element_id NUMBER;
17107: l_rec NUMBER := 1;
17108:
17109: party_rec hz_party_v2pub.party_rec_type;
17110: org_rec hz_party_v2pub.organization_rec_type;
17111: person_rec hz_party_v2pub.person_rec_type;
17112: location_rec hz_location_v2pub.location_rec_type;
17113: psite_rec hz_party_site_v2pub.party_site_rec_type;
17114: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;

Line 17111: person_rec hz_party_v2pub.person_rec_type;

17107: l_rec NUMBER := 1;
17108:
17109: party_rec hz_party_v2pub.party_rec_type;
17110: org_rec hz_party_v2pub.organization_rec_type;
17111: person_rec hz_party_v2pub.person_rec_type;
17112: location_rec hz_location_v2pub.location_rec_type;
17113: psite_rec hz_party_site_v2pub.party_site_rec_type;
17114: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
17115: email_rec hz_contact_point_v2pub.email_rec_type;