DBA Data[Home] [Help]

APPS.AMS_LIST_IMPORT_PUB dependencies on HZ_LOCATION_V2PUB

Line 206: p_location_rec IN hz_location_v2pub.location_rec_type,

202: p_import_list_header_id IN NUMBER,
203: p_party_rec IN hz_party_v2pub.party_rec_type,
204: p_org_rec IN hz_party_v2pub.organization_rec_type,
205: p_person_rec IN hz_party_v2pub.person_rec_type,
206: p_location_rec IN hz_location_v2pub.location_rec_type,
207: p_psite_rec IN hz_party_site_v2pub.party_site_rec_type,
208: p_cpoint_rec IN hz_contact_point_v2pub.contact_point_rec_type,
209: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
210: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,

Line 220: p_org_location_rec IN hz_location_v2pub.location_rec_type default null,

216: p_component_name OUT NOCOPY VARCHAR2,
217: l_import_source_line_id IN NUMBER default null,
218: p_org_email_rec IN hz_contact_point_v2pub.email_rec_type default null,
219: p_org_phone_rec IN hz_contact_point_v2pub.phone_rec_type default null,
220: p_org_location_rec IN hz_location_v2pub.location_rec_type default null,
221: p_org_psite_rec IN hz_party_site_v2pub.party_site_rec_type default NULL,
222: p_language_rec IN hz_person_info_v2pub.person_language_rec_type DEFAULT null,
223: p_org_party_site_phone_rec IN hz_contact_point_v2pub.phone_rec_type default null
224: ) IS

Line 236: location_rec hz_location_v2pub.location_rec_type := p_location_rec;

232: party_rec hz_party_v2pub.party_rec_type := p_party_rec;
233: org_rec hz_party_v2pub.organization_rec_type := p_org_rec;
234: org_rec_null hz_party_v2pub.organization_rec_type := null;
235: person_rec hz_party_v2pub.person_rec_type := p_person_rec;
236: location_rec hz_location_v2pub.location_rec_type := p_location_rec;
237: psite_rec hz_party_site_v2pub.party_site_rec_type := p_psite_rec;
238: psiteuse_rec hz_party_site_v2pub.party_site_use_rec_type := p_siteuse_rec;
239: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type := p_cpoint_rec;
240: email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;

Line 250: org_location_rec hz_location_v2pub.location_rec_type := p_org_location_rec;

246: web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec;
247:
248: org_email_rec hz_contact_point_v2pub.email_rec_type := p_org_email_rec;
249: org_phone_rec hz_contact_point_v2pub.phone_rec_type := p_org_phone_rec;
250: org_location_rec hz_location_v2pub.location_rec_type := p_org_location_rec;
251: org_psite_rec hz_party_site_v2pub.party_site_rec_type := p_org_psite_rec;
252: language_rec hz_person_info_v2pub.person_language_rec_type := p_language_rec;
253: org_party_site_phone_rec hz_contact_point_v2pub.phone_rec_type := p_org_party_site_phone_rec;
254:

Line 1416: hz_location_v2pub.update_location(

1412: select OBJECT_VERSION_NUMBER into l_loc_obj_number
1413: from hz_locations
1414: where location_id = x_org_location_id;
1415: org_location_rec.location_id := x_org_location_id;
1416: hz_location_v2pub.update_location(
1417: 'F',
1418: org_location_rec,
1419: l_loc_obj_number,
1420: x_return_status,

Line 1529: hz_location_v2pub.update_location(

1525: select OBJECT_VERSION_NUMBER into l_loc_obj_number
1526: from hz_locations
1527: where location_id = x_location_id;
1528: location_rec.location_id := x_location_id;
1529: hz_location_v2pub.update_location(
1530: 'F',
1531: location_rec,
1532: l_loc_obj_number,
1533: x_return_status,

Line 2572: hz_location_v2pub.update_location(

2568: select OBJECT_VERSION_NUMBER into l_loc_obj_number
2569: from hz_locations
2570: where location_id = x_location_id;
2571: location_rec.location_id := x_location_id;
2572: hz_location_v2pub.update_location(
2573: 'F',
2574: location_rec,
2575: l_loc_obj_number,
2576: x_return_status,