DBA Data[Home] [Help]

APPS.AMS_LIST_IMPORT_PUB dependencies on HZ_CONTACT_POINT_V2PUB

Line 208: p_cpoint_rec IN hz_contact_point_v2pub.contact_point_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,
211: p_fax_rec IN hz_contact_point_v2pub.phone_rec_type,
212: p_ocon_rec IN hz_party_contact_v2pub.org_contact_rec_type,

Line 209: p_email_rec IN hz_contact_point_v2pub.email_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,
211: p_fax_rec IN hz_contact_point_v2pub.phone_rec_type,
212: p_ocon_rec IN hz_party_contact_v2pub.org_contact_rec_type,
213: p_siteuse_rec IN hz_party_site_v2pub.party_site_use_rec_type,

Line 210: p_phone_rec IN hz_contact_point_v2pub.phone_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,
211: p_fax_rec IN hz_contact_point_v2pub.phone_rec_type,
212: p_ocon_rec IN hz_party_contact_v2pub.org_contact_rec_type,
213: p_siteuse_rec IN hz_party_site_v2pub.party_site_use_rec_type,
214: p_web_rec IN hz_contact_point_v2pub.web_rec_type,

Line 211: p_fax_rec IN hz_contact_point_v2pub.phone_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,
211: p_fax_rec IN hz_contact_point_v2pub.phone_rec_type,
212: p_ocon_rec IN hz_party_contact_v2pub.org_contact_rec_type,
213: p_siteuse_rec IN hz_party_site_v2pub.party_site_use_rec_type,
214: p_web_rec IN hz_contact_point_v2pub.web_rec_type,
215: x_new_party OUT NOCOPY VARCHAR2,

Line 214: p_web_rec IN hz_contact_point_v2pub.web_rec_type,

210: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
211: p_fax_rec IN hz_contact_point_v2pub.phone_rec_type,
212: p_ocon_rec IN hz_party_contact_v2pub.org_contact_rec_type,
213: p_siteuse_rec IN hz_party_site_v2pub.party_site_use_rec_type,
214: p_web_rec IN hz_contact_point_v2pub.web_rec_type,
215: x_new_party OUT NOCOPY VARCHAR2,
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,

Line 218: p_org_email_rec IN hz_contact_point_v2pub.email_rec_type default null,

214: p_web_rec IN hz_contact_point_v2pub.web_rec_type,
215: x_new_party OUT NOCOPY VARCHAR2,
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,

Line 219: p_org_phone_rec IN hz_contact_point_v2pub.phone_rec_type default null,

215: x_new_party OUT NOCOPY VARCHAR2,
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

Line 223: p_org_party_site_phone_rec IN hz_contact_point_v2pub.phone_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
225:
226: l_api_name CONSTANT VARCHAR2(30) := 'Create_Customer';
227: l_api_version CONSTANT NUMBER := 1.0;

Line 239: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type := p_cpoint_rec;

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;
241: phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
242: fax_rec hz_contact_point_v2pub.phone_rec_type := p_fax_rec;
243: ocon_rec hz_party_contact_v2pub.org_contact_rec_type := p_ocon_rec;

Line 240: email_rec hz_contact_point_v2pub.email_rec_type := p_email_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;
241: phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
242: fax_rec hz_contact_point_v2pub.phone_rec_type := p_fax_rec;
243: ocon_rec hz_party_contact_v2pub.org_contact_rec_type := p_ocon_rec;
244: edi_rec hz_contact_point_v2pub.edi_rec_type;

Line 241: phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_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;
241: phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
242: fax_rec hz_contact_point_v2pub.phone_rec_type := p_fax_rec;
243: ocon_rec hz_party_contact_v2pub.org_contact_rec_type := p_ocon_rec;
244: edi_rec hz_contact_point_v2pub.edi_rec_type;
245: telex_rec hz_contact_point_v2pub.telex_rec_type;

Line 242: fax_rec hz_contact_point_v2pub.phone_rec_type := p_fax_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;
241: phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
242: fax_rec hz_contact_point_v2pub.phone_rec_type := p_fax_rec;
243: ocon_rec hz_party_contact_v2pub.org_contact_rec_type := p_ocon_rec;
244: edi_rec hz_contact_point_v2pub.edi_rec_type;
245: telex_rec hz_contact_point_v2pub.telex_rec_type;
246: web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec;

Line 244: edi_rec hz_contact_point_v2pub.edi_rec_type;

240: email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
241: phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
242: fax_rec hz_contact_point_v2pub.phone_rec_type := p_fax_rec;
243: ocon_rec hz_party_contact_v2pub.org_contact_rec_type := p_ocon_rec;
244: edi_rec hz_contact_point_v2pub.edi_rec_type;
245: telex_rec hz_contact_point_v2pub.telex_rec_type;
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;

Line 245: telex_rec hz_contact_point_v2pub.telex_rec_type;

241: phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
242: fax_rec hz_contact_point_v2pub.phone_rec_type := p_fax_rec;
243: ocon_rec hz_party_contact_v2pub.org_contact_rec_type := p_ocon_rec;
244: edi_rec hz_contact_point_v2pub.edi_rec_type;
245: telex_rec hz_contact_point_v2pub.telex_rec_type;
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;

Line 246: web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec;

242: fax_rec hz_contact_point_v2pub.phone_rec_type := p_fax_rec;
243: ocon_rec hz_party_contact_v2pub.org_contact_rec_type := p_ocon_rec;
244: edi_rec hz_contact_point_v2pub.edi_rec_type;
245: telex_rec hz_contact_point_v2pub.telex_rec_type;
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;

Line 248: org_email_rec hz_contact_point_v2pub.email_rec_type := p_org_email_rec;

244: edi_rec hz_contact_point_v2pub.edi_rec_type;
245: telex_rec hz_contact_point_v2pub.telex_rec_type;
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;

Line 249: org_phone_rec hz_contact_point_v2pub.phone_rec_type := p_org_phone_rec;

245: telex_rec hz_contact_point_v2pub.telex_rec_type;
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;

Line 253: org_party_site_phone_rec hz_contact_point_v2pub.phone_rec_type := p_org_party_site_phone_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:
255: l_address_key hz_locations.address_key%TYPE ;
256: l_address_key_count NUMBER ;
257:

Line 2099: hz_contact_point_v2pub.update_contact_point(

2095: select OBJECT_VERSION_NUMBER into l_cp_obj_number
2096: from hz_contact_points
2097: where contact_point_id = x_contact_point_id;
2098:
2099: hz_contact_point_v2pub.update_contact_point(
2100: 'F',
2101: cpoint_rec,
2102: edi_rec,
2103: email_rec,

Line 2862: hz_contact_point_v2pub.update_contact_point(

2858: cpoint_rec.contact_point_id := x_contact_point_id;
2859: select OBJECT_VERSION_NUMBER into l_cp_obj_number
2860: from hz_contact_points
2861: where contact_point_id = x_contact_point_id;
2862: hz_contact_point_v2pub.update_contact_point(
2863: 'F',
2864: cpoint_rec,
2865: edi_rec,
2866: email_rec,