461: FROM hz_contact_points
462: WHERE contact_point_id = cp_contact_point_id;
463:
464: l_obj_ver hz_contact_points.object_version_number%TYPE;
465: l_org_contacts_obj_ver_num hz_org_contacts.object_version_number%TYPE;
466: l_rel_obj_ver_num hz_org_contacts.object_version_number%TYPE;
467: l_hz_parties_obj_ver_num hz_org_contacts.object_version_number%TYPE;
468:
469: BEGIN
462: WHERE contact_point_id = cp_contact_point_id;
463:
464: l_obj_ver hz_contact_points.object_version_number%TYPE;
465: l_org_contacts_obj_ver_num hz_org_contacts.object_version_number%TYPE;
466: l_rel_obj_ver_num hz_org_contacts.object_version_number%TYPE;
467: l_hz_parties_obj_ver_num hz_org_contacts.object_version_number%TYPE;
468:
469: BEGIN
470:
463:
464: l_obj_ver hz_contact_points.object_version_number%TYPE;
465: l_org_contacts_obj_ver_num hz_org_contacts.object_version_number%TYPE;
466: l_rel_obj_ver_num hz_org_contacts.object_version_number%TYPE;
467: l_hz_parties_obj_ver_num hz_org_contacts.object_version_number%TYPE;
468:
469: BEGIN
470:
471: -- Assign the values to the Org Contact Record