APPS.PO_DOCUMENT_ACTION_HOLD SQL Statements

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

Line: 104

      UPDATE po_headers poh
      SET poh.frozen_flag = DECODE(p_action_ctl_rec.action,
                               PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE, 'Y',
                               PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE, 'N')
       ,  poh.last_update_date = SYSDATE
       ,  poh.last_updated_by  = l_user_id
       ,  poh.last_update_login = l_login_id
      WHERE poh.po_header_id = p_action_ctl_rec.document_id;

Line: 118

      UPDATE po_releases por
      SET por.frozen_flag = DECODE(p_action_ctl_rec.action,
                               PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE, 'Y',
                               PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE, 'N')
       ,  por.last_update_date = SYSDATE
       ,  por.last_updated_by  = l_user_id
       ,  por.last_update_login = l_login_id
      WHERE por.po_release_id = p_action_ctl_rec.document_id;

Line: 300

      UPDATE po_headers poh
      SET poh.user_hold_flag = DECODE(p_action_ctl_rec.action,
                                  PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD, 'Y',
                                  PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, 'N')
       ,  poh.approved_flag = DECODE(p_action_ctl_rec.action,
                                  PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
                                    DECODE(poh.approved_flag, 'Y', 'R', poh.approved_flag),
                                  PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poh.approved_flag)
       ,  poh.authorization_status = DECODE(p_action_ctl_rec.action,
                                       PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
                                         DECODE(poh.authorization_status,
                                                  'APPROVED', 'REQUIRES REAPPROVAL',
                                                   poh.authorization_status),
                                       PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poh.authorization_status)
       ,  poh.last_update_date  = sysdate
       ,  poh.last_updated_by   = l_user_id
       ,  poh.last_update_login = l_login_id
      WHERE poh.po_header_id = p_action_ctl_rec.document_id;

Line: 324

        UPDATE po_line_locations poll
        SET poll.approved_flag = DECODE(p_action_ctl_rec.action,
                                   PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
                                     DECODE(poll.approved_flag, 'Y', 'R', poll.approved_flag),
                                   PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poll.approved_flag)
         ,  poll.last_update_date  = SYSDATE
         ,  poll.last_updated_by   = l_user_id
         ,  poll.last_update_login = l_login_id
        WHERE poll.po_header_id      = p_action_ctl_rec.document_id
          -- : Include PREPAYMENT shipment_type
          AND poll.shipment_type in ('STANDARD', 'PLANNED', 'PREPAYMENT');

Line: 343

      UPDATE po_releases por
      SET por.hold_flag = DECODE(p_action_ctl_rec.action,
                             PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD, 'Y',
                             PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, 'N')
       ,  por.approved_flag = DECODE(p_action_ctl_rec.action,
                                  PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
                                    DECODE(por.approved_flag, 'Y', 'R', por.approved_flag),
                                  PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, por.approved_flag)
       ,  por.authorization_status = DECODE(p_action_ctl_rec.action,
                                       PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
                                         DECODE(por.authorization_status,
                                                  'APPROVED', 'REQUIRES REAPPROVAL',
                                                   por.authorization_status),
                                       PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, por.authorization_status)
       ,  por.last_update_date  = sysdate
       ,  por.last_updated_by   = l_user_id
       ,  por.last_update_login = l_login_id
      WHERE por.po_release_id = p_action_ctl_rec.document_id;

Line: 364

      UPDATE po_line_locations poll
      SET poll.approved_flag = DECODE(p_action_ctl_rec.action,
                                 PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD,
                                   DECODE(poll.approved_flag, 'Y', 'R', poll.approved_flag),
                                 PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, poll.approved_flag)
       ,  poll.last_update_date  = SYSDATE
       ,  poll.last_updated_by   = l_user_id
       ,  poll.last_update_login = l_login_id
      WHERE poll.po_release_id      = p_action_ctl_rec.document_id
        AND poll.shipment_type in ('BLANKET', 'SCHEDULED');