eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_CONTACT_POINT_V2PUB

Line 3281: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,

3277: -- declaration of private procedures and functions
3278: --------------------------------------
3279:
3280: PROCEDURE do_create_contact_point (
3281: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3282: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3283: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3284: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3285: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,

Line 3282: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,

3278: --------------------------------------
3279:
3280: PROCEDURE do_create_contact_point (
3281: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3282: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3283: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3284: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3285: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3286: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,

Line 3283: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,

3279:
3280: PROCEDURE do_create_contact_point (
3281: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3282: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3283: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3284: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3285: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3286: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3287: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,

Line 3284: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,

3280: PROCEDURE do_create_contact_point (
3281: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3282: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3283: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3284: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3285: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3286: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3287: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3288: x_contact_point_id OUT NOCOPY NUMBER,

Line 3285: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,

3281: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3282: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3283: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3284: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3285: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3286: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3287: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3288: x_contact_point_id OUT NOCOPY NUMBER,
3289: x_return_status IN OUT NOCOPY VARCHAR2

Line 3286: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,

3282: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3283: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3284: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3285: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3286: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3287: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3288: x_contact_point_id OUT NOCOPY NUMBER,
3289: x_return_status IN OUT NOCOPY VARCHAR2
3290: );

Line 3287: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,

3283: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3284: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3285: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3286: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3287: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3288: x_contact_point_id OUT NOCOPY NUMBER,
3289: x_return_status IN OUT NOCOPY VARCHAR2
3290: );
3291:

Line 3320: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,

3316: --------------------------------------
3317:
3318:
3319: PROCEDURE do_create_contact_point (
3320: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3321: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3322: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3323: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3324: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,

Line 3321: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,

3317:
3318:
3319: PROCEDURE do_create_contact_point (
3320: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3321: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3322: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3323: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3324: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3325: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,

Line 3322: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,

3318:
3319: PROCEDURE do_create_contact_point (
3320: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3321: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3322: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3323: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3324: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3325: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3326: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,

Line 3323: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,

3319: PROCEDURE do_create_contact_point (
3320: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3321: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3322: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3323: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3324: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3325: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3326: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3327: x_contact_point_id OUT NOCOPY NUMBER,

Line 3324: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,

3320: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3321: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3322: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3323: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3324: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3325: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3326: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3327: x_contact_point_id OUT NOCOPY NUMBER,
3328: x_return_status IN OUT NOCOPY VARCHAR2

Line 3325: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,

3321: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3322: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3323: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3324: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3325: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3326: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3327: x_contact_point_id OUT NOCOPY NUMBER,
3328: x_return_status IN OUT NOCOPY VARCHAR2
3329: ) IS

Line 3326: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,

3322: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3323: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3324: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3325: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3326: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3327: x_contact_point_id OUT NOCOPY NUMBER,
3328: x_return_status IN OUT NOCOPY VARCHAR2
3329: ) IS
3330:

Line 3340: l_edi_rec hz_contact_point_v2pub.edi_rec_type;

3336: l_formatted_phone_number VARCHAR2(100);
3337: l_country_code hz_locations.country%TYPE;
3338: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
3339:
3340: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
3341: l_eft_rec hz_contact_point_v2pub.eft_rec_type;
3342: l_email_rec hz_contact_point_v2pub.email_rec_type;
3343: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
3344: l_telex_rec hz_contact_point_v2pub.telex_rec_type;

Line 3341: l_eft_rec hz_contact_point_v2pub.eft_rec_type;

3337: l_country_code hz_locations.country%TYPE;
3338: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
3339:
3340: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
3341: l_eft_rec hz_contact_point_v2pub.eft_rec_type;
3342: l_email_rec hz_contact_point_v2pub.email_rec_type;
3343: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
3344: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
3345: l_web_rec hz_contact_point_v2pub.web_rec_type;

Line 3342: l_email_rec hz_contact_point_v2pub.email_rec_type;

3338: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
3339:
3340: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
3341: l_eft_rec hz_contact_point_v2pub.eft_rec_type;
3342: l_email_rec hz_contact_point_v2pub.email_rec_type;
3343: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
3344: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
3345: l_web_rec hz_contact_point_v2pub.web_rec_type;
3346: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

Line 3343: l_phone_rec hz_contact_point_v2pub.phone_rec_type;

3339:
3340: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
3341: l_eft_rec hz_contact_point_v2pub.eft_rec_type;
3342: l_email_rec hz_contact_point_v2pub.email_rec_type;
3343: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
3344: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
3345: l_web_rec hz_contact_point_v2pub.web_rec_type;
3346: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
3347:

Line 3344: l_telex_rec hz_contact_point_v2pub.telex_rec_type;

3340: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
3341: l_eft_rec hz_contact_point_v2pub.eft_rec_type;
3342: l_email_rec hz_contact_point_v2pub.email_rec_type;
3343: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
3344: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
3345: l_web_rec hz_contact_point_v2pub.web_rec_type;
3346: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
3347:
3348: -- Bug 2197181: added for mix-n-match project: the contact point

Line 3345: l_web_rec hz_contact_point_v2pub.web_rec_type;

3341: l_eft_rec hz_contact_point_v2pub.eft_rec_type;
3342: l_email_rec hz_contact_point_v2pub.email_rec_type;
3343: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
3344: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
3345: l_web_rec hz_contact_point_v2pub.web_rec_type;
3346: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
3347:
3348: -- Bug 2197181: added for mix-n-match project: the contact point
3349: -- must be visible.

Line 3674: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

3670:
3671:
3672: PROCEDURE create_contact_point (
3673: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3674: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
3675: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
3676: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
3677: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
3678: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,

Line 3675: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,

3671:
3672: PROCEDURE create_contact_point (
3673: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3674: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
3675: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
3676: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
3677: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
3678: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
3679: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,

Line 3676: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,

3672: PROCEDURE create_contact_point (
3673: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3674: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
3675: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
3676: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
3677: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
3678: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
3679: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,
3680: p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_rec,

Line 3677: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,

3673: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3674: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
3675: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
3676: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
3677: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
3678: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
3679: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,
3680: p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_rec,
3681: x_contact_point_id OUT NOCOPY NUMBER,

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

3674: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
3675: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
3676: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
3677: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
3678: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
3679: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,
3680: p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_rec,
3681: x_contact_point_id OUT NOCOPY NUMBER,
3682: x_return_status OUT NOCOPY VARCHAR2,

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

3675: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
3676: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
3677: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
3678: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
3679: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,
3680: p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_rec,
3681: x_contact_point_id OUT NOCOPY NUMBER,
3682: x_return_status OUT NOCOPY VARCHAR2,
3683: x_msg_count OUT NOCOPY NUMBER,

Line 3680: p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_rec,

3676: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
3677: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
3678: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
3679: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,
3680: p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_rec,
3681: x_contact_point_id OUT NOCOPY NUMBER,
3682: x_return_status OUT NOCOPY VARCHAR2,
3683: x_msg_count OUT NOCOPY NUMBER,
3684: x_msg_data OUT NOCOPY VARCHAR2

Line 3687: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type :=

3683: x_msg_count OUT NOCOPY NUMBER,
3684: x_msg_data OUT NOCOPY VARCHAR2
3685: ) IS
3686:
3687: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type :=
3688: p_contact_point_rec;
3689: l_edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
3690: l_eft_rec hz_contact_point_v2pub.eft_rec_type := p_eft_rec;
3691: l_email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;

Line 3689: l_edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;

3685: ) IS
3686:
3687: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type :=
3688: p_contact_point_rec;
3689: l_edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
3690: l_eft_rec hz_contact_point_v2pub.eft_rec_type := p_eft_rec;
3691: l_email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
3692: l_phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
3693: l_telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;

Line 3690: l_eft_rec hz_contact_point_v2pub.eft_rec_type := p_eft_rec;

3686:
3687: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type :=
3688: p_contact_point_rec;
3689: l_edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
3690: l_eft_rec hz_contact_point_v2pub.eft_rec_type := p_eft_rec;
3691: l_email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
3692: l_phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
3693: l_telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;
3694: l_web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec;

Line 3691: l_email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;

3687: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type :=
3688: p_contact_point_rec;
3689: l_edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
3690: l_eft_rec hz_contact_point_v2pub.eft_rec_type := p_eft_rec;
3691: l_email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
3692: l_phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
3693: l_telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;
3694: l_web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec;
3695:

Line 3692: l_phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;

3688: p_contact_point_rec;
3689: l_edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
3690: l_eft_rec hz_contact_point_v2pub.eft_rec_type := p_eft_rec;
3691: l_email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
3692: l_phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
3693: l_telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;
3694: l_web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec;
3695:
3696: BEGIN

Line 3693: l_telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;

3689: l_edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
3690: l_eft_rec hz_contact_point_v2pub.eft_rec_type := p_eft_rec;
3691: l_email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
3692: l_phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
3693: l_telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;
3694: l_web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec;
3695:
3696: BEGIN
3697:

Line 3694: l_web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec;

3690: l_eft_rec hz_contact_point_v2pub.eft_rec_type := p_eft_rec;
3691: l_email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
3692: l_phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
3693: l_telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;
3694: l_web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec;
3695:
3696: BEGIN
3697:
3698: -- Standard start of API savepoint

Line 3799: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,

3795:
3796: PROCEDURE get_contact_point_rec (
3797: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3798: p_contact_point_id IN NUMBER,
3799: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3800: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3801: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3802: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3803: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,

Line 3800: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,

3796: PROCEDURE get_contact_point_rec (
3797: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3798: p_contact_point_id IN NUMBER,
3799: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3800: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3801: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3802: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3803: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3804: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,

Line 3801: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,

3797: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3798: p_contact_point_id IN NUMBER,
3799: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3800: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3801: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3802: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3803: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3804: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3805: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,

Line 3802: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,

3798: p_contact_point_id IN NUMBER,
3799: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3800: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3801: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3802: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3803: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3804: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3805: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3806: x_return_status OUT NOCOPY VARCHAR2,

Line 3803: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,

3799: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3800: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3801: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3802: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3803: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3804: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3805: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3806: x_return_status OUT NOCOPY VARCHAR2,
3807: x_msg_count OUT NOCOPY NUMBER,

Line 3804: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,

3800: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3801: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3802: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3803: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3804: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3805: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3806: x_return_status OUT NOCOPY VARCHAR2,
3807: x_msg_count OUT NOCOPY NUMBER,
3808: x_msg_data OUT NOCOPY VARCHAR2

Line 3805: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,

3801: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3802: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3803: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3804: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3805: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3806: x_return_status OUT NOCOPY VARCHAR2,
3807: x_msg_count OUT NOCOPY NUMBER,
3808: x_msg_data OUT NOCOPY VARCHAR2
3809: ) IS