113: l_msg_count number;
114: l_msg_data varchar2(1024);
115:
116: l_server_last_update_date date;
117: CURSOR l_server_last_update_date_csr(p_jtf_note_id jtf_notes_b.jtf_note_id%TYPE)
118: IS
119: select last_update_date from jtf_notes_b
120: where jtf_note_id = p_jtf_note_id;
121:
115:
116: l_server_last_update_date date;
117: CURSOR l_server_last_update_date_csr(p_jtf_note_id jtf_notes_b.jtf_note_id%TYPE)
118: IS
119: select last_update_date from jtf_notes_b
120: where jtf_note_id = p_jtf_note_id;
121:
122: BEGIN
123: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_UPDATE:'
126: FND_LOG.LEVEL_PROCEDURE );
127: --get the last update date of the note
128:
129: --select last_update_date into l_server_last_update_date
130: --from jtf_notes_b
131: --where jtf_note_id = p_record.jtf_note_id;
132:
133: OPEN l_server_last_update_date_csr(p_record.jtf_note_id);
134: FETCH l_server_last_update_date_csr INTO l_server_last_update_date;