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 3296: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,

3292: -- declaration of private procedures and functions
3293: --------------------------------------
3294:
3295: PROCEDURE do_create_contact_point (
3296: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3297: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3298: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3299: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3300: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,

Line 3297: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,

3293: --------------------------------------
3294:
3295: PROCEDURE do_create_contact_point (
3296: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3297: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3298: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3299: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3300: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3301: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,

Line 3298: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,

3294:
3295: PROCEDURE do_create_contact_point (
3296: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3297: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3298: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3299: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3300: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3301: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3302: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,

Line 3299: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,

3295: PROCEDURE do_create_contact_point (
3296: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3297: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3298: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3299: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3300: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3301: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3302: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3303: x_contact_point_id OUT NOCOPY NUMBER,

Line 3300: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,

3296: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3297: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3298: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3299: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3300: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3301: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3302: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3303: x_contact_point_id OUT NOCOPY NUMBER,
3304: x_return_status IN OUT NOCOPY VARCHAR2

Line 3301: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,

3297: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3298: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3299: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3300: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3301: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3302: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3303: x_contact_point_id OUT NOCOPY NUMBER,
3304: x_return_status IN OUT NOCOPY VARCHAR2
3305: );

Line 3302: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,

3298: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3299: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3300: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3301: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3302: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3303: x_contact_point_id OUT NOCOPY NUMBER,
3304: x_return_status IN OUT NOCOPY VARCHAR2
3305: );
3306:

Line 3335: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,

3331: --------------------------------------
3332:
3333:
3334: PROCEDURE do_create_contact_point (
3335: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3336: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3337: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3338: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3339: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,

Line 3336: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,

3332:
3333:
3334: PROCEDURE do_create_contact_point (
3335: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3336: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3337: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3338: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3339: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3340: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,

Line 3337: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,

3333:
3334: PROCEDURE do_create_contact_point (
3335: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3336: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3337: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3338: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3339: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3340: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3341: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,

Line 3338: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,

3334: PROCEDURE do_create_contact_point (
3335: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3336: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3337: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3338: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3339: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3340: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3341: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3342: x_contact_point_id OUT NOCOPY NUMBER,

Line 3339: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,

3335: p_contact_point_rec IN OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3336: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3337: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3338: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3339: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3340: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3341: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3342: x_contact_point_id OUT NOCOPY NUMBER,
3343: x_return_status IN OUT NOCOPY VARCHAR2

Line 3340: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,

3336: p_edi_rec IN OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3337: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3338: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3339: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3340: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3341: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3342: x_contact_point_id OUT NOCOPY NUMBER,
3343: x_return_status IN OUT NOCOPY VARCHAR2
3344: ) IS

Line 3341: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,

3337: p_eft_rec IN OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3338: p_email_rec IN OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3339: p_phone_rec IN OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3340: p_telex_rec IN OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3341: p_web_rec IN OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3342: x_contact_point_id OUT NOCOPY NUMBER,
3343: x_return_status IN OUT NOCOPY VARCHAR2
3344: ) IS
3345:

Line 3355: l_edi_rec hz_contact_point_v2pub.edi_rec_type;

3351: l_formatted_phone_number VARCHAR2(100);
3352: l_country_code hz_locations.country%TYPE;
3353: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
3354:
3355: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
3356: l_eft_rec hz_contact_point_v2pub.eft_rec_type;
3357: l_email_rec hz_contact_point_v2pub.email_rec_type;
3358: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
3359: l_telex_rec hz_contact_point_v2pub.telex_rec_type;

Line 3356: l_eft_rec hz_contact_point_v2pub.eft_rec_type;

3352: l_country_code hz_locations.country%TYPE;
3353: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
3354:
3355: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
3356: l_eft_rec hz_contact_point_v2pub.eft_rec_type;
3357: l_email_rec hz_contact_point_v2pub.email_rec_type;
3358: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
3359: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
3360: l_web_rec hz_contact_point_v2pub.web_rec_type;

Line 3357: l_email_rec hz_contact_point_v2pub.email_rec_type;

3353: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
3354:
3355: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
3356: l_eft_rec hz_contact_point_v2pub.eft_rec_type;
3357: l_email_rec hz_contact_point_v2pub.email_rec_type;
3358: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
3359: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
3360: l_web_rec hz_contact_point_v2pub.web_rec_type;
3361: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;

Line 3358: l_phone_rec hz_contact_point_v2pub.phone_rec_type;

3354:
3355: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
3356: l_eft_rec hz_contact_point_v2pub.eft_rec_type;
3357: l_email_rec hz_contact_point_v2pub.email_rec_type;
3358: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
3359: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
3360: l_web_rec hz_contact_point_v2pub.web_rec_type;
3361: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
3362:

Line 3359: l_telex_rec hz_contact_point_v2pub.telex_rec_type;

3355: l_edi_rec hz_contact_point_v2pub.edi_rec_type;
3356: l_eft_rec hz_contact_point_v2pub.eft_rec_type;
3357: l_email_rec hz_contact_point_v2pub.email_rec_type;
3358: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
3359: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
3360: l_web_rec hz_contact_point_v2pub.web_rec_type;
3361: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
3362:
3363: -- Bug 2197181: added for mix-n-match project: the contact point

Line 3360: l_web_rec hz_contact_point_v2pub.web_rec_type;

3356: l_eft_rec hz_contact_point_v2pub.eft_rec_type;
3357: l_email_rec hz_contact_point_v2pub.email_rec_type;
3358: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
3359: l_telex_rec hz_contact_point_v2pub.telex_rec_type;
3360: l_web_rec hz_contact_point_v2pub.web_rec_type;
3361: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
3362:
3363: -- Bug 2197181: added for mix-n-match project: the contact point
3364: -- must be visible.

Line 3710: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

3706:
3707:
3708: PROCEDURE create_contact_point (
3709: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3710: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
3711: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
3712: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
3713: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
3714: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,

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

3707:
3708: PROCEDURE create_contact_point (
3709: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3710: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
3711: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
3712: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
3713: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
3714: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
3715: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,

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

3708: PROCEDURE create_contact_point (
3709: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3710: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
3711: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
3712: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
3713: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
3714: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
3715: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,
3716: p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_rec,

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

3709: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3710: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
3711: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
3712: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
3713: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
3714: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
3715: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,
3716: p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_rec,
3717: x_contact_point_id OUT NOCOPY NUMBER,

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

3710: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
3711: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
3712: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
3713: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
3714: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
3715: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,
3716: p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_rec,
3717: x_contact_point_id OUT NOCOPY NUMBER,
3718: x_return_status OUT NOCOPY VARCHAR2,

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

3711: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := g_miss_edi_rec,
3712: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
3713: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
3714: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
3715: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,
3716: p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_rec,
3717: x_contact_point_id OUT NOCOPY NUMBER,
3718: x_return_status OUT NOCOPY VARCHAR2,
3719: x_msg_count OUT NOCOPY NUMBER,

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

3712: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := g_miss_eft_rec,
3713: p_email_rec IN hz_contact_point_v2pub.email_rec_type := g_miss_email_rec,
3714: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := g_miss_phone_rec,
3715: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := g_miss_telex_rec,
3716: p_web_rec IN hz_contact_point_v2pub.web_rec_type := g_miss_web_rec,
3717: x_contact_point_id OUT NOCOPY NUMBER,
3718: x_return_status OUT NOCOPY VARCHAR2,
3719: x_msg_count OUT NOCOPY NUMBER,
3720: x_msg_data OUT NOCOPY VARCHAR2

Line 3723: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type :=

3719: x_msg_count OUT NOCOPY NUMBER,
3720: x_msg_data OUT NOCOPY VARCHAR2
3721: ) IS
3722:
3723: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type :=
3724: p_contact_point_rec;
3725: l_edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
3726: l_eft_rec hz_contact_point_v2pub.eft_rec_type := p_eft_rec;
3727: l_email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;

Line 3725: l_edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;

3721: ) IS
3722:
3723: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type :=
3724: p_contact_point_rec;
3725: l_edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
3726: l_eft_rec hz_contact_point_v2pub.eft_rec_type := p_eft_rec;
3727: l_email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
3728: l_phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
3729: l_telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;

Line 3726: l_eft_rec hz_contact_point_v2pub.eft_rec_type := p_eft_rec;

3722:
3723: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type :=
3724: p_contact_point_rec;
3725: l_edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
3726: l_eft_rec hz_contact_point_v2pub.eft_rec_type := p_eft_rec;
3727: l_email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
3728: l_phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
3729: l_telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;
3730: l_web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec;

Line 3727: l_email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;

3723: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type :=
3724: p_contact_point_rec;
3725: l_edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
3726: l_eft_rec hz_contact_point_v2pub.eft_rec_type := p_eft_rec;
3727: l_email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
3728: l_phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
3729: l_telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;
3730: l_web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec;
3731:

Line 3728: l_phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;

3724: p_contact_point_rec;
3725: l_edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
3726: l_eft_rec hz_contact_point_v2pub.eft_rec_type := p_eft_rec;
3727: l_email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
3728: l_phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
3729: l_telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;
3730: l_web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec;
3731:
3732: BEGIN

Line 3729: l_telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;

3725: l_edi_rec hz_contact_point_v2pub.edi_rec_type := p_edi_rec;
3726: l_eft_rec hz_contact_point_v2pub.eft_rec_type := p_eft_rec;
3727: l_email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
3728: l_phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
3729: l_telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;
3730: l_web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec;
3731:
3732: BEGIN
3733:

Line 3730: l_web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec;

3726: l_eft_rec hz_contact_point_v2pub.eft_rec_type := p_eft_rec;
3727: l_email_rec hz_contact_point_v2pub.email_rec_type := p_email_rec;
3728: l_phone_rec hz_contact_point_v2pub.phone_rec_type := p_phone_rec;
3729: l_telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;
3730: l_web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec;
3731:
3732: BEGIN
3733:
3734: -- Standard start of API savepoint

Line 3837: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,

3833:
3834: PROCEDURE get_contact_point_rec (
3835: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3836: p_contact_point_id IN NUMBER,
3837: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3838: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3839: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3840: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3841: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,

Line 3838: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,

3834: PROCEDURE get_contact_point_rec (
3835: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3836: p_contact_point_id IN NUMBER,
3837: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3838: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3839: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3840: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3841: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3842: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,

Line 3839: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,

3835: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3836: p_contact_point_id IN NUMBER,
3837: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3838: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3839: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3840: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3841: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3842: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3843: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,

Line 3840: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,

3836: p_contact_point_id IN NUMBER,
3837: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3838: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3839: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3840: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3841: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3842: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3843: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3844: x_return_status OUT NOCOPY VARCHAR2,

Line 3841: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,

3837: x_contact_point_rec OUT NOCOPY hz_contact_point_v2pub.contact_point_rec_type,
3838: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3839: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3840: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3841: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3842: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3843: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3844: x_return_status OUT NOCOPY VARCHAR2,
3845: x_msg_count OUT NOCOPY NUMBER,

Line 3842: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,

3838: x_edi_rec OUT NOCOPY hz_contact_point_v2pub.edi_rec_type,
3839: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3840: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3841: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3842: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3843: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3844: x_return_status OUT NOCOPY VARCHAR2,
3845: x_msg_count OUT NOCOPY NUMBER,
3846: x_msg_data OUT NOCOPY VARCHAR2

Line 3843: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,

3839: x_eft_rec OUT NOCOPY hz_contact_point_v2pub.eft_rec_type,
3840: x_email_rec OUT NOCOPY hz_contact_point_v2pub.email_rec_type,
3841: x_phone_rec OUT NOCOPY hz_contact_point_v2pub.phone_rec_type,
3842: x_telex_rec OUT NOCOPY hz_contact_point_v2pub.telex_rec_type,
3843: x_web_rec OUT NOCOPY hz_contact_point_v2pub.web_rec_type,
3844: x_return_status OUT NOCOPY VARCHAR2,
3845: x_msg_count OUT NOCOPY NUMBER,
3846: x_msg_data OUT NOCOPY VARCHAR2
3847: ) IS