APPS.JTF_FM_TRACK_PVT dependencies on JTF_FM_EMAIL_STATS

Line 43: UPDATE JTF_FM_EMAIL_STATS

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:

Line 76: UPDATE JTF_FM_EMAIL_STATS

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:

Line 102: UPDATE JTF_FM_EMAIL_STATS

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;