5870: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5871: END CopyService;
5872:
5873:
5874: -- Begin modifications for new HZ_CONTACT_POINTS_V2PUB for TCA uptake, aiyengar 11/20/02
5875:
5876:
5877: PROCEDURE Create_Contact_Points
5878: (
5986: G_ERROR EXCEPTION;
5987:
5988: CURSOR l_cpoint_csr IS
5989: SELECT last_update_date, object_version_number, contact_point_type
5990: FROM HZ_CONTACT_POINTS
5991: WHERE contact_point_id = P_contact_point_rec.contact_point_id;
5992:
5993: l_cpoint_rec l_cpoint_csr%ROWTYPE;
5994:
6052: SQLERRM);
6053:
6054: END Update_Contact_Points;
6055:
6056: -- End modifications for new HZ_CONTACT_POINTS_V2PUB for TCA uptake, aiyengar 11/20/02
6057:
6058: PROCEDURE CreateOperationInstance(p_chr_id IN NUMBER
6059: , p_object1_id1 IN VARCHAR2
6060: , p_object1_id2 IN VARCHAR2