APPS.PO_NOTIF_CONTROLS_SV SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5

  FUNCTION NAME:	delete_notifs()

===========================================================================*/

 FUNCTION delete_notifs(X_po_header_id IN number)
          return boolean is
          X_deleted boolean;

Line: 16

        DELETE FROM po_notification_controls
        WHERE po_header_id = X_po_header_id;

Line: 19

        X_deleted := TRUE;

Line: 20

        return(X_deleted);

Line: 27

             po_message_s.sql_error('delete_notifs', x_progress, sqlcode);

Line: 30

END delete_notifs;

Line: 47

   SELECT  COUNT(1)
     INTO  X_amt_base_notif_cntl_row
     FROM  po_notification_controls
    WHERE  po_header_id                 = X_po_header_id
      AND  notification_condition_code <> 'EXPIRATION';

Line: 80

            SELECT 'date based notification controls exist'
            FROM  po_notification_controls
            WHERE po_header_id                = X_po_header_id
            AND   notification_condition_code = 'EXPIRATION';