APPS.JTF_FM_TRACK_PVT dependencies on JTF_FM_PROCESSED

Line 33: SELECT DISTINCT EMAIL_STATUS INTO l_email_status FROM JTF_FM_PROCESSED WHERE

29:
30: l_email_status VARCHAR2(15);
31: BEGIN
32:
33: SELECT DISTINCT EMAIL_STATUS INTO l_email_status FROM JTF_FM_PROCESSED WHERE
34: REQUEST_ID = p_request_history_id AND PARTY_ID = p_customer_id;
35:
36: IF l_email_status is NULL OR (l_email_status <> 'UNSUBSCRIBED' AND l_email_status <> 'OPENED')
37: THEN

Line 38: UPDATE JTF_FM_PROCESSED

34: REQUEST_ID = p_request_history_id AND PARTY_ID = p_customer_id;
35:
36: IF l_email_status is NULL OR (l_email_status <> 'UNSUBSCRIBED' AND l_email_status <> 'OPENED')
37: THEN
38: UPDATE JTF_FM_PROCESSED
39: SET EMAIL_STATUS = 'OPENED'
40: WHERE request_id =p_request_history_id AND
41: party_id = p_customer_id ;
42:

Line 65: SELECT DISTINCT EMAIL_STATUS INTO l_email_status FROM JTF_FM_PROCESSED WHERE

61: l_email_status VARCHAR2(15);
62:
63: BEGIN
64:
65: SELECT DISTINCT EMAIL_STATUS INTO l_email_status FROM JTF_FM_PROCESSED WHERE
66: REQUEST_ID = p_request_history_id AND PARTY_ID = p_customer_id;
67:
68:
69: IF l_email_Status <> 'UNSUBSCRIBED'

Line 71: UPDATE JTF_FM_PROCESSED

67:
68:
69: IF l_email_Status <> 'UNSUBSCRIBED'
70: THEN
71: UPDATE JTF_FM_PROCESSED
72: SET EMAIL_STATUS = 'UNSUBSCRIBED'
73: WHERE request_id =p_request_history_id AND
74: party_id = p_customer_id ;
75:

Line 97: UPDATE JTF_FM_PROCESSED

93: l_email_status VARCHAR2(15);
94:
95: BEGIN
96:
97: UPDATE JTF_FM_PROCESSED
98: SET EMAIL_STATUS = 'BOUNCED'
99: WHERE request_id =p_request_history_id AND
100: party_id = p_customer_id ;
101: