138: );
139:
140: ------------------------CONTACT_POINTS------------------------
141:
142: g_miss_edi_rec hz_contact_point_v2pub.edi_rec_type;
143: g_miss_eft_rec hz_contact_point_v2pub.eft_rec_type;
144: g_miss_email_rec hz_contact_point_v2pub.email_rec_type;
145: g_miss_phone_rec hz_contact_point_v2pub.phone_rec_type;
146: g_miss_telex_rec hz_contact_point_v2pub.telex_rec_type;
139:
140: ------------------------CONTACT_POINTS------------------------
141:
142: g_miss_edi_rec hz_contact_point_v2pub.edi_rec_type;
143: g_miss_eft_rec hz_contact_point_v2pub.eft_rec_type;
144: g_miss_email_rec hz_contact_point_v2pub.email_rec_type;
145: g_miss_phone_rec hz_contact_point_v2pub.phone_rec_type;
146: g_miss_telex_rec hz_contact_point_v2pub.telex_rec_type;
147: g_miss_web_rec hz_contact_point_v2pub.web_rec_type;
140: ------------------------CONTACT_POINTS------------------------
141:
142: g_miss_edi_rec hz_contact_point_v2pub.edi_rec_type;
143: g_miss_eft_rec hz_contact_point_v2pub.eft_rec_type;
144: g_miss_email_rec hz_contact_point_v2pub.email_rec_type;
145: g_miss_phone_rec hz_contact_point_v2pub.phone_rec_type;
146: g_miss_telex_rec hz_contact_point_v2pub.telex_rec_type;
147: g_miss_web_rec hz_contact_point_v2pub.web_rec_type;
148:
141:
142: g_miss_edi_rec hz_contact_point_v2pub.edi_rec_type;
143: g_miss_eft_rec hz_contact_point_v2pub.eft_rec_type;
144: g_miss_email_rec hz_contact_point_v2pub.email_rec_type;
145: g_miss_phone_rec hz_contact_point_v2pub.phone_rec_type;
146: g_miss_telex_rec hz_contact_point_v2pub.telex_rec_type;
147: g_miss_web_rec hz_contact_point_v2pub.web_rec_type;
148:
149: PROCEDURE create_contact_point (
142: g_miss_edi_rec hz_contact_point_v2pub.edi_rec_type;
143: g_miss_eft_rec hz_contact_point_v2pub.eft_rec_type;
144: g_miss_email_rec hz_contact_point_v2pub.email_rec_type;
145: g_miss_phone_rec hz_contact_point_v2pub.phone_rec_type;
146: g_miss_telex_rec hz_contact_point_v2pub.telex_rec_type;
147: g_miss_web_rec hz_contact_point_v2pub.web_rec_type;
148:
149: PROCEDURE create_contact_point (
150: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
143: g_miss_eft_rec hz_contact_point_v2pub.eft_rec_type;
144: g_miss_email_rec hz_contact_point_v2pub.email_rec_type;
145: g_miss_phone_rec hz_contact_point_v2pub.phone_rec_type;
146: g_miss_telex_rec hz_contact_point_v2pub.telex_rec_type;
147: g_miss_web_rec hz_contact_point_v2pub.web_rec_type;
148:
149: PROCEDURE create_contact_point (
150: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
151: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
147: g_miss_web_rec hz_contact_point_v2pub.web_rec_type;
148:
149: PROCEDURE create_contact_point (
150: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
151: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
152: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
153: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
154: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
155: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
148:
149: PROCEDURE create_contact_point (
150: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
151: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
152: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
153: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
154: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
155: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
156: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,
149: PROCEDURE create_contact_point (
150: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
151: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
152: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
153: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
154: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
155: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
156: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,
157: p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_rec,
150: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
151: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
152: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
153: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
154: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
155: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
156: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,
157: p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_rec,
158: x_contact_point_id OUT NOCOPY NUMBER,
151: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
152: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
153: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
154: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
155: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
156: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,
157: p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_rec,
158: x_contact_point_id OUT NOCOPY NUMBER,
159: x_return_status OUT NOCOPY VARCHAR2,
152: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
153: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
154: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
155: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
156: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,
157: p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_rec,
158: x_contact_point_id OUT NOCOPY NUMBER,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
153: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
154: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
155: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
156: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,
157: p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_rec,
158: x_contact_point_id OUT NOCOPY NUMBER,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2
163:
164: PROCEDURE get_contact_point_rec (
165: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
166: p_contact_point_id IN NUMBER,
167: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
168: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
169: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
170: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
171: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
164: PROCEDURE get_contact_point_rec (
165: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
166: p_contact_point_id IN NUMBER,
167: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
168: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
169: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
170: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
171: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
172: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
165: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
166: p_contact_point_id IN NUMBER,
167: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
168: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
169: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
170: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
171: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
172: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
173: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
166: p_contact_point_id IN NUMBER,
167: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
168: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
169: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
170: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
171: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
172: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
173: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
174: x_return_status OUT NOCOPY VARCHAR2,
167: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
168: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
169: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
170: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
171: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
172: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
173: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
168: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
169: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
170: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
171: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
172: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
173: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2
169: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
170: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
171: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
172: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
173: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2
177: );