1780: p_sms_id IN NUMBER,
1781: p_parent_id IN NUMBER,
1782: p_parent_table_name IN VARCHAR2,
1783: p_action_type IN VARCHAR2 := NULL,
1784: x_sms_objs OUT NOCOPY HZ_SMS_CP_BO_TBL,
1785: x_return_status OUT NOCOPY VARCHAR2,
1786: x_msg_count OUT NOCOPY NUMBER,
1787: x_msg_data OUT NOCOPY VARCHAR2
1788: ) is
1788: ) is
1789: l_debug_prefix VARCHAR2(30) := '';
1790:
1791: cursor c1 is
1792: SELECT HZ_SMS_CP_BO(
1793: P_ACTION_TYPE,
1794: NULL, -- COMMON_OBJ_ID
1795: CONTACT_POINT_ID,
1796: NULL, -- ORIG_SYSTEM,
1939: END IF;
1940:
1941:
1942:
1943: x_sms_objs := HZ_SMS_CP_BO_TBL();
1944: open c1;
1945: fetch c1 BULK COLLECT into x_sms_objs;
1946: close c1;
1947: