39: SET EMAIL_STATUS = 'OPENED'
40: WHERE request_id =p_request_history_id AND
41: party_id = p_customer_id ;
42:
43: UPDATE JTF_FM_EMAIL_STATS
44: SET OPENED = NVL(opened, 0) + 1
45: WHERE request_id = p_request_history_id;
46: END IF;
47:
72: SET EMAIL_STATUS = 'UNSUBSCRIBED'
73: WHERE request_id =p_request_history_id AND
74: party_id = p_customer_id ;
75:
76: UPDATE JTF_FM_EMAIL_STATS
77: SET UNSUBSCRIBED = NVL(UNSUBSCRIBED,0) + 1
78: WHERE request_id = p_request_history_id;
79: END IF;
80:
98: SET EMAIL_STATUS = 'BOUNCED'
99: WHERE request_id =p_request_history_id AND
100: party_id = p_customer_id ;
101:
102: UPDATE JTF_FM_EMAIL_STATS
103: SET BOUNCED = NVL(BOUNCED,0) + 1
104: WHERE request_id = p_request_history_id;
105: COMMIT WORK;
106: END TRACK_BOUNCEBACK;