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.OWNER_TABLE_NAME := 'HZ_PARTIES'; P_CONTACT_POINT_REC.OWNER_TABLE_ID := 150336; ---L_ORG_PARTY_ID; commented by pranay tiwari on 05-Jun-2014 P_CONTACT_POINT_REC.CREATED_BY_MODULE := 'TCA_V2_API'; ----email P_EMAIL_REC_TYPE.EMAIL_FORMAT := 'MAILHTML';