350: FROM PO_REQUISITION_HEADERS
351: WHERE requisition_header_id = x_req_hdr_id;
352:
353: if ((x_item_type is null) and (x_item_key is null)) then
354: po_approval_reminder_sv.cancel_notif (x_type_lookup_code,
355: x_req_hdr_id);
356: else
357: /*Bug 3047646 : the line below has been added to ensure that
358: po send notification items are deleted.
360: approval workflow and was never approved and also po send notification
361: was also invoked for it,in which case we need to stop the approval
362: workflow as well as the reminder workflow */
363:
364: po_approval_reminder_sv.cancel_notif (x_type_lookup_code,
365: x_req_hdr_id);
366: po_approval_reminder_sv.stop_process(x_item_type,x_item_key);
367: end if;
368: /* Bug 2904413 Need to delete the action history also */
362: workflow as well as the reminder workflow */
363:
364: po_approval_reminder_sv.cancel_notif (x_type_lookup_code,
365: x_req_hdr_id);
366: po_approval_reminder_sv.stop_process(x_item_type,x_item_key);
367: end if;
368: /* Bug 2904413 Need to delete the action history also */
369:
370: Delete po_action_history