DBA Data[Home] [Help]

APPS.HZ_EXTRACT_CONT_POINT_BO_PVT dependencies on HZ_EMAIL_CP_BO

Line 643: x_email_objs OUT NOCOPY HZ_EMAIL_CP_BO_TBL,

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

Line 650: SELECT HZ_EMAIL_CP_BO(

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,

Line 796: x_email_objs := HZ_EMAIL_CP_BO_TBL();

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: