DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PVT dependencies on HZ_CONTACT_POINT_V2PUB

Line 5275: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

5271: x_msg_data OUT NOCOPY VARCHAR2,
5272: x_contact_point_id OUT NOCOPY NUMBER)
5273: IS
5274:
5275: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5276: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5277: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5278: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5279: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;

Line 5276: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;

5272: x_contact_point_id OUT NOCOPY NUMBER)
5273: IS
5274:
5275: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5276: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5277: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5278: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5279: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
5280: l_edi_rec_type HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;

Line 5277: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

5273: IS
5274:
5275: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5276: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5277: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5278: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5279: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
5280: l_edi_rec_type HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
5281:

Line 5278: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;

5274:
5275: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5276: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5277: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5278: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5279: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
5280: l_edi_rec_type HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
5281:
5282: G_ERROR EXCEPTION;

Line 5279: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;

5275: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5276: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5277: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5278: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5279: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
5280: l_edi_rec_type HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
5281:
5282: G_ERROR EXCEPTION;
5283:

Line 5280: l_edi_rec_type HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;

5276: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5277: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5278: l_web_rec_type HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE ;
5279: l_telex_rec_type HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;
5280: l_edi_rec_type HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;
5281:
5282: G_ERROR EXCEPTION;
5283:
5284: BEGIN

Line 5329: HZ_CONTACT_POINT_V2PUB.create_contact_point (

5325: --contact creation end
5326:
5327: END IF;
5328:
5329: HZ_CONTACT_POINT_V2PUB.create_contact_point (
5330: p_init_msg_list => p_init_msg_list,
5331: p_contact_point_rec => l_contact_point_rec,
5332: p_email_rec => l_email_rec_type,
5333: p_phone_rec => l_phone_rec_type,

Line 5369: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

5365: x_msg_count OUT NOCOPY NUMBER,
5366: x_msg_data OUT NOCOPY VARCHAR2)
5367: IS
5368: l_object_Version_number NUMBER := 1 ;
5369: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5370: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5371: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5372: G_ERROR EXCEPTION;
5373:

Line 5370: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;

5366: x_msg_data OUT NOCOPY VARCHAR2)
5367: IS
5368: l_object_Version_number NUMBER := 1 ;
5369: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5370: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5371: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5372: G_ERROR EXCEPTION;
5373:
5374: CURSOR l_cpoint_csr IS

Line 5371: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;

5367: IS
5368: l_object_Version_number NUMBER := 1 ;
5369: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
5370: l_email_rec_type HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
5371: l_phone_rec_type HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
5372: G_ERROR EXCEPTION;
5373:
5374: CURSOR l_cpoint_csr IS
5375: SELECT last_update_date, object_version_number, contact_point_type

Line 5413: HZ_CONTACT_POINT_V2PUB.update_contact_point (

5409:
5410: END IF;
5411: l_object_version_number := l_cpoint_rec.object_Version_number;
5412:
5413: HZ_CONTACT_POINT_V2PUB.update_contact_point (
5414: p_init_msg_list => p_init_msg_list,
5415: p_contact_point_rec => l_contact_point_rec,
5416: p_email_rec => l_email_rec_type,
5417: p_phone_rec => l_phone_rec_type,