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 4907: party_rec hz_party_v2pub.party_rec_type;

4903: SELECT party_site_id FROM hz_party_sites
4904: WHERE party_id = x_per_party_id
4905: AND location_id = x_location_id;
4906:
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;

Line 4908: org_rec hz_party_v2pub.organization_rec_type;

4904: WHERE party_id = x_per_party_id
4905: AND location_id = x_location_id;
4906:
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;

Line 4909: person_rec hz_party_v2pub.person_rec_type;

4905: AND location_id = x_location_id;
4906:
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;

Line 5170: hz_party_v2pub.update_organization(

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

Line 5207: hz_party_v2pub.update_person(

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

Line 5574: hz_party_v2pub.update_person(

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

Line 16160: party_rec hz_party_v2pub.party_rec_type;

16156: l_pho_element_id NUMBER;
16157: l_ema_element_id NUMBER;
16158: l_rec NUMBER := 1;
16159:
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;

Line 16161: org_rec hz_party_v2pub.organization_rec_type;

16157: l_ema_element_id NUMBER;
16158: l_rec NUMBER := 1;
16159:
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;

Line 16162: person_rec hz_party_v2pub.person_rec_type;

16158: l_rec NUMBER := 1;
16159:
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;

Line 17110: party_rec hz_party_v2pub.party_rec_type;

17106: l_pho_element_id NUMBER;
17107: l_ema_element_id NUMBER;
17108: l_rec NUMBER := 1;
17109:
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;

Line 17111: org_rec hz_party_v2pub.organization_rec_type;

17107: l_ema_element_id NUMBER;
17108: l_rec NUMBER := 1;
17109:
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;

Line 17112: person_rec hz_party_v2pub.person_rec_type;

17108: l_rec NUMBER := 1;
17109:
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;