DBA Data[Home] [Help]

APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_CONTACT_POINT_V2PUB

Line 142: g_miss_edi_rec hz_contact_point_v2pub.edi_rec_type;

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;

Line 143: g_miss_eft_rec hz_contact_point_v2pub.eft_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;

Line 144: g_miss_email_rec hz_contact_point_v2pub.email_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:

Line 145: g_miss_phone_rec hz_contact_point_v2pub.phone_rec_type;

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 (

Line 146: g_miss_telex_rec hz_contact_point_v2pub.telex_rec_type;

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,

Line 147: g_miss_web_rec hz_contact_point_v2pub.web_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,
151: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

Line 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,

Line 152: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_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,

Line 153: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_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,

Line 154: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_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,

Line 155: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,

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,

Line 156: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,

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,

Line 157: p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_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,
161: x_msg_data OUT NOCOPY VARCHAR2

Line 167: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,

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,

Line 168: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_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,

Line 169: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_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,

Line 170: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_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,

Line 171: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,

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,

Line 172: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_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,
176: x_msg_data OUT NOCOPY VARCHAR2

Line 173: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_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
177: );