639: p_email_id IN NUMBER,
640: p_parent_id IN NUMBER,
641: p_parent_table_name IN VARCHAR2,
642: p_action_type IN VARCHAR2 := NULL,
643: x_email_objs OUT NOCOPY HZ_EMAIL_CP_BO_TBL,
644: x_return_status OUT NOCOPY VARCHAR2,
645: x_msg_count OUT NOCOPY NUMBER,
646: x_msg_data OUT NOCOPY VARCHAR2
647: ) is
646: x_msg_data OUT NOCOPY VARCHAR2
647: ) is
648:
649: cursor c1 is
650: SELECT HZ_EMAIL_CP_BO(
651: P_ACTION_TYPE,
652: NULL, -- COMMON_OBJ_ID
653: CONTACT_POINT_ID,
654: NULL, -- ORIG_SYSTEM,
792: END IF;
793:
794:
795:
796: x_email_objs := HZ_EMAIL_CP_BO_TBL();
797: open c1;
798: fetch c1 BULK COLLECT into x_email_objs;
799: close c1;
800: