208: is
209: --- GET ALL certiifcatios for which reminders is due -------
210: cursor Get_Certi_for_Reminders is
211: select certification_id
212: from amw_certification_b
213: where OBJECT_TYPE='PROCESS'
214: and (LAST_REMINDER_DATE is null
215: OR (trunc(LAST_REMINDER_DATE) + CERTIFICATION_REMINDER <= trunc(SYSDATE)))
216: and CERTIFICATION_STATUS = 'ACTIVE';
332: begin
333: fnd_file.put_line(fnd_file.LOG,
334: 'Going to update LAST_REMINDER_DATE for '||p_certificaion_id);
335:
336: update amw_certification_b
337: set LAST_REMINDER_DATE= sysdate
338: where CERTIFICATION_ID = p_certificaion_id;
339:
340: x_return_status := FND_API.G_RET_STS_SUCCESS;