Sample HZ API's script to Create Contacts and Contact Points in Oracle
1. Below Code will create Contact Point in Oracle . DECLARE P_CONTACT_POINT_REC HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE; P_PHONE_REC HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE; P_EDI_REC_TYPE HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE; P_EMAIL_REC_TYPE HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE; P_TELEX_REC_TYPE HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE; P_WEB_REC_TYPE HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE; X_RETURN_STATUS VARCHAR2 (1000); X_CONTACT_POINT_ID NUMBER; X_MSG_COUNT NUMBER; X_MSG_DATA VARCHAR2 (1000); BEGIN P_CONTACT_POINT_REC.CONTACT_POINT_TYPE := 'EMAIL'; P_CONTACT_POINT_REC.OWN...