eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOCUMENT_ACTION_UTIL SQL Statements

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

Line: 12


PROCEDURE insert_auth_action_history(
   p_document_id        IN          NUMBER
,  p_revision_num       IN          NUMBER
,  p_document_type      IN          VARCHAR2
,  p_document_subtype   IN          VARCHAR2
,  p_action             IN          VARCHAR2
,  p_employee_id        IN          NUMBER
,  p_offline_code       IN          VARCHAR2
,  p_approval_path_id   IN          NUMBER
,  p_note               IN          VARCHAR2
,  p_user_id            IN          NUMBER
,  p_login_id           IN          NUMBER
,  x_return_status      OUT NOCOPY  VARCHAR2
);

Line: 27


PROCEDURE update_auth_action_history(
   p_document_id        IN          NUMBER
,  p_revision_num       IN          NUMBER
,  p_document_type      IN          VARCHAR2
,  p_action             IN          VARCHAR2
,  p_approval_path_id   IN          NUMBER
,  p_note               IN          VARCHAR2
,  p_user_id            IN          NUMBER
,  x_return_status      OUT NOCOPY  VARCHAR2
);

Line: 55


PROCEDURE update_doc_auth_status(
   p_document_id        IN          NUMBER
,  p_document_type      IN          VARCHAR2
,  p_document_subtype   IN          VARCHAR2
,  p_new_status         IN          VARCHAR2
,  p_user_id            IN          NUMBER
,  p_login_id           IN          NUMBER
,  x_return_status      OUT NOCOPY  VARCHAR2
);

Line: 65


PROCEDURE update_doc_notifications(
   p_document_id        IN         NUMBER
,  p_document_type      IN         VARCHAR2
,  p_document_subtype   IN         VARCHAR2
,  p_notify_action      IN         VARCHAR2
,  p_notify_employee    IN         NUMBER
,  p_doc_creation_date  IN         DATE
,  p_user_id            IN         NUMBER
,  p_login_id           IN         NUMBER
,  x_return_status      OUT NOCOPY VARCHAR2
);

Line: 111


  SELECT nvl(por.authorization_status, 'INCOMPLETE'),
         nvl(por.closed_code, 'OPEN'),
         nvl(por.frozen_flag, 'N'),
         nvl(por.hold_flag, 'N')
  FROM po_releases por
  WHERE por.po_release_id = docid;

Line: 119


  SELECT nvl(poh.authorization_status, 'INCOMPLETE'),
         nvl(poh.closed_code, 'OPEN'),
         nvl(poh.frozen_flag, 'N'),
         nvl(poh.user_hold_flag, 'N')
  FROM po_headers poh
  WHERE poh.po_header_id = docid;

Line: 127


  SELECT nvl(prh.authorization_status, 'INCOMPLETE'),
         nvl(prh.closed_code, 'OPEN')
  FROM po_requisition_headers prh
  WHERE prh.requisition_header_id = docid;

Line: 133


  SELECT nvl(poll.closed_code, 'OPEN')
  FROM po_line_locations poll
  WHERE poll.line_location_id = shipid;

Line: 138


  SELECT nvl(pol.closed_code, 'OPEN')
  FROM po_lines pol
  WHERE pol.po_line_id = lineid;

Line: 514


    SELECT por.agent_id
    INTO x_preparer_id
    FROM po_releases_all por
    WHERE por.po_release_id = p_document_id;

Line: 529


    SELECT poh.agent_id
    INTO x_preparer_id
    FROM po_headers_all poh
    WHERE poh.po_header_id = p_document_id;

Line: 543


    SELECT porh.preparer_id
    INTO x_preparer_id
    FROM po_requisition_headers_all porh
    WHERE porh.requisition_header_id = p_document_id;

Line: 622


    SELECT hr.person_id, hr.full_name, hr.location_id
    INTO x_employee_id, x_employee_name, x_location_id
    FROM FND_USER fnd, PO_WORKFORCE_CURRENT_X hr      -- 
    WHERE fnd.user_id = p_user_id
      AND fnd.employee_id = hr.person_id;

Line: 655


      SELECT hr.location_code
      INTO x_location_code
      FROM HR_LOCATIONS hr,
           FINANCIALS_SYSTEM_PARAMETERS fsp,
           ORG_ORGANIZATION_DEFINITIONS ood
      WHERE hr.location_id = x_location_id
        AND hr.inventory_organization_id = ood.organization_id (+)
        AND nvl(ood.set_of_books_id, fsp.set_of_books_id) = fsp.set_of_books_id;

Line: 682


      SELECT 'X'
      INTO l_temp_var
      FROM po_agents poa
      WHERE poa.agent_id = x_employee_id
        AND SYSDATE between nvl(poa.start_date_active, SYSDATE - 1) and NVL(poa.end_date_active, SYSDATE + 1);

Line: 760


    SELECT hr.person_id
    INTO x_employee_id
    FROM FND_USER fnd, PER_WORKFORCE_CURRENT_X hr   --R12 CWK Enhancement
    WHERE fnd.user_id = p_user_id
      AND fnd.employee_id = hr.person_id;

Line: 904


      SELECT porh.authorization_status, porh.creation_date, 0
      INTO l_old_status, l_creation_date, l_revision_num
      FROM PO_REQUISITION_HEADERS porh
      WHERE porh.requisition_header_id = p_document_id;

Line: 914


      SELECT NVL(poh.authorization_status, PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE),
             poh.creation_date,
             poh.revision_num
      INTO   l_old_status,
             l_creation_date,
             l_revision_num
      FROM   PO_HEADERS poh
      WHERE  poh.po_header_id = p_document_id;

Line: 928


      SELECT NVL(por.authorization_status, PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE),
             por.creation_date,
             por.revision_num
      INTO   l_old_status,
             l_creation_date,
             l_revision_num
      FROM   PO_RELEASES por
      WHERE  por.po_release_id = p_document_id;    --

Line: 983


      update_doc_auth_status(
         p_document_id         => p_document_id
      ,  p_document_type       => p_document_type
      ,  p_document_subtype    => p_document_subtype
      ,  p_new_status          => p_new_status
      ,  p_user_id             => l_user_id
      ,  p_login_id            => l_login_id
      ,  x_return_status       => l_ret_sts
      );

Line: 997


        l_err_msg := 'update_doc_auth_status not successful';

Line: 1127


      UPDATE po_action_history poah
      SET poah.action_code = p_action
        , poah.action_date = SYSDATE
        , poah.offline_code = NULL
        , poah.employee_id = l_emp_id
        , poah.note = DECODE(p_shipment_id, NULL,
                        DECODE(p_line_id, NULL, p_reason, l_rollup_msg),
                        l_rollup_msg)
        , poah.last_updated_by = p_user_id
        , poah.last_update_date = SYSDATE
      WHERE poah.object_id = p_document_id
        AND poah.object_type_code = p_document_type
        AND poah.object_sub_type_code = p_document_subtype
        AND poah.action_code IS NULL;

Line: 1163


      UPDATE po_action_history poah
      SET poah.sequence_num = poah.sequence_num + 1
      WHERE poah.object_id = p_document_id
        AND poah.object_type_code = p_document_type
        AND poah.object_sub_type_code = p_document_subtype
        AND poah.action_code IS NULL;

Line: 1175


      SELECT count(1)
      INTO l_count_hist
      FROM po_action_history poah
      WHERE poah.object_id = p_document_id
        AND poah.object_type_code = p_document_type
        AND poah.object_sub_type_code = p_document_subtype
        AND poah.action_code IS NOT NULL;

Line: 1198


        INSERT INTO po_action_history(
           object_id
        ,  object_type_code
        ,  object_sub_type_code
        ,  sequence_num
        ,  last_update_date
        ,  last_updated_by
        ,  creation_date
        ,  created_by
        ,  action_code
        ,  action_date
        ,  employee_id
        ,  note
        ,  object_revision_num
        ,  last_update_login
        ,  request_id
        ,  program_application_id
        ,  program_id
        ,  program_update_date
        ,  approval_path_id
        ,  offline_code
        )
        SELECT
           poah.object_id
        ,  poah.object_type_code
        ,  poah.object_sub_type_code
        ,  max(poah.sequence_num) + 1
        ,  SYSDATE
        ,  p_user_id
        ,  SYSDATE
        ,  p_user_id
        ,  p_action
        ,  SYSDATE
        ,  l_emp_id
        ,  DECODE(p_shipment_id,
                    NULL, DECODE(p_line_id, NULL, p_reason, l_rollup_msg),
                    l_rollup_msg)
        ,  max(poah.object_revision_num)
        ,  p_login_id
        ,  0
        ,  0
        ,  0
        ,  ''
        ,  0
        ,  ''
        FROM po_action_history poah
        WHERE poah.object_id = p_document_id
          AND poah.object_type_code = p_document_type
          AND poah.object_sub_type_code = p_document_subtype
          AND poah.action_code IS NOT NULL
        GROUP BY poah.object_id
              ,  poah.object_type_code
              ,  poah.object_sub_type_code
        ;

Line: 1260


        SELECT max(poh.revision_num)
        INTO l_revision_num
        FROM po_headers_all poh
        WHERE poh.po_header_id = p_document_id;

Line: 1270


        INSERT INTO po_action_history(
           object_id
        ,  object_type_code
        ,  object_sub_type_code
        ,  sequence_num
        ,  last_update_date
        ,  last_updated_by
        ,  creation_date
        ,  created_by
        ,  action_code
        ,  action_date
        ,  employee_id
        ,  note
        ,  object_revision_num
        ,  last_update_login
        ,  request_id
        ,  program_application_id
        ,  program_id
        ,  program_update_date
        ,  approval_path_id
        ,  offline_code
        ) VALUES (
           p_document_id
        ,  p_document_type
        ,  p_document_subtype
        ,  0                -- Bug 4118145, Issue 3: sequence_num starts at 0
        ,  SYSDATE
        ,  p_user_id
        ,  SYSDATE
        ,  p_user_id
        ,  p_action
        ,  SYSDATE
        ,  l_emp_id
        ,  DECODE(p_shipment_id,
                    NULL, DECODE(p_line_id, NULL, p_reason, l_rollup_msg),
                    l_rollup_msg)
        ,  l_revision_num
        ,  p_login_id
        ,  0
        ,  0
        ,  0
        ,  ''
        ,  0
        ,  ''
        );

Line: 1409


      insert_auth_action_history(
         p_document_id   => p_document_id
      ,  p_revision_num  => p_revision_num
      ,  p_document_type => p_document_type
      ,  p_document_subtype => p_document_subtype
      ,  p_action => 'SUBMIT'
      ,  p_employee_id  => p_employee_id
      ,  p_offline_code => NULL
      ,  p_approval_path_id => p_approval_path_id
      ,  p_note      => p_note
      ,  p_user_id   => p_user_id
      ,  p_login_id  => p_login_id
      ,  x_return_status => l_ret_sts
      );

Line: 1432


        insert_auth_action_history(
           p_document_id   => p_document_id
        ,  p_revision_num  => p_revision_num
        ,  p_document_type => p_document_type
        ,  p_document_subtype => p_document_subtype
        ,  p_action => p_action
        ,  p_employee_id  => p_employee_id
        ,  p_offline_code => NULL
        ,  p_approval_path_id => p_approval_path_id
        ,  p_note      => p_note
        ,  p_user_id   => p_user_id
        ,  p_login_id  => p_login_id
        ,  x_return_status => l_ret_sts
        );

Line: 1458


      update_auth_action_history(
         p_document_id     => p_document_id
      ,  p_revision_num    => p_revision_num
      ,  p_document_type   => p_document_type
      ,  p_action          => p_action
      ,  p_approval_path_id  => p_approval_path_id
      ,  p_note          => p_note
      ,  p_user_id       => p_user_id
      ,  x_return_status => l_ret_sts
      );

Line: 1477


      insert_auth_action_history(
         p_document_id   => p_document_id
      ,  p_revision_num  => p_revision_num
      ,  p_document_type => p_document_type
      ,  p_document_subtype => p_document_subtype
      ,  p_action => p_action
      ,  p_employee_id  => p_employee_id
      ,  p_offline_code => NULL
      ,  p_approval_path_id => p_approval_path_id
      ,  p_note      => p_note
      ,  p_user_id   => p_user_id
      ,  p_login_id  => p_login_id
      ,  x_return_status => l_ret_sts
      );

Line: 1505


      insert_auth_action_history(
         p_document_id   => p_document_id
      ,  p_revision_num  => p_revision_num
      ,  p_document_type => p_document_type
      ,  p_document_subtype => p_document_subtype
      ,  p_action => NULL
      ,  p_employee_id  => p_fwd_to_id
      ,  p_offline_code => p_offline_code
      ,  p_approval_path_id => NULL
      ,  p_note      => NULL
      ,  p_user_id   => p_user_id
      ,  p_login_id  => p_login_id
      ,  x_return_status => l_ret_sts
      );

Line: 1529


        update_auth_action_history(
           p_document_id     => p_document_id
        ,  p_revision_num    => p_revision_num
        ,  p_document_type   => p_document_type
        ,  p_action          => PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE
        ,  p_approval_path_id  => p_approval_path_id
        ,  p_note          => p_note
        ,  p_user_id       => p_user_id
        ,  x_return_status => l_ret_sts
        );

Line: 1555


      insert_auth_action_history(
         p_document_id   => p_document_id
      ,  p_revision_num  => p_revision_num
      ,  p_document_type => p_document_type
      ,  p_document_subtype => p_document_subtype
      ,  p_action => NULL
      ,  p_employee_id  => p_employee_id
      ,  p_offline_code => NULL
      ,  p_approval_path_id => NULL
      ,  p_note      => NULL
      ,  p_user_id   => p_user_id
      ,  p_login_id  => p_login_id
      ,  x_return_status => l_ret_sts
      );

Line: 1582


      PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, 'Insert or update action history not successful');

Line: 1584


          PO_LOG.exc(d_module, d_progress, 'Insert or update action history not successful');

Line: 1614


PROCEDURE update_doc_auth_status(
   p_document_id        IN          NUMBER
,  p_document_type      IN          VARCHAR2
,  p_document_subtype   IN          VARCHAR2
,  p_new_status         IN          VARCHAR2
,  p_user_id            IN          NUMBER
,  p_login_id           IN          NUMBER
,  x_return_status      OUT NOCOPY  VARCHAR2
)
IS

l_conterms_exist        PO_HEADERS.conterms_exist_flag%TYPE;

Line: 1634


d_module          VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.update_doc_auth_status';

Line: 1655


      UPDATE PO_REQUISITION_HEADERS porh
      SET    porh.authorization_status   = p_new_status
      	  ,  porh.approved_date          = DECODE (p_new_status,
	                                   PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,
					   SYSDATE,null)
          ,  porh.last_update_date       = SYSDATE
          ,  porh.last_updated_by        = p_user_id
          ,  porh.last_update_login      = p_login_id
      WHERE porh.requisition_header_id   = p_document_id;

Line: 1668


      PO_REQ_LINES_SV.update_reqs_in_pool_flag(
         x_req_line_id    =>  NULL
      ,  x_req_header_id  =>  p_document_id
      ,  x_return_status  => l_ret_sts
      );

Line: 1677


        l_err_msg := 'update_reqs_in_pool_flag not successful';

Line: 1687


      UPDATE PO_HEADERS poh
      SET    poh.authorization_status   = p_new_status,
             poh.approved_flag = DECODE(p_new_status,
                PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,    'Y',
                PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL,  'R',
                PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED,    'F',
                PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED,    'F',
                PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE,  'N',
                PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS,   'N',
                PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
             poh.approved_date = DECODE(p_new_status,
                PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,  SYSDATE,
                                                       poh.approved_date),
             poh.last_update_date     = SYSDATE,
             poh.last_updated_by      = p_user_id,
             poh.last_update_login   = p_login_id,
             poh.pending_signature_flag = DECODE(p_new_status,
                PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,
                                DECODE(poh.acceptance_required_flag, 'S', 'Y', 'N'),
                                poh.pending_signature_flag)
      WHERE poh.po_header_id = p_document_id;

Line: 1715


        SELECT NVL(poh.pending_signature_flag, 'N'), NVL(poh.conterms_exist_flag, 'N')
        INTO l_pending_signature, l_conterms_exist
        FROM PO_HEADERS poh
        WHERE po_header_id = p_document_id;

Line: 1722


        PO_CONTERMS_WF_PVT.UPDATE_CONTERMS_DATES(
                       p_po_header_id         => p_document_id
                    ,  p_po_doc_type          => p_document_type
                    ,  p_po_doc_subtype       => p_document_subtype
                    ,  p_conterms_exist_flag  => l_conterms_exist
                    ,  x_return_status        => l_ret_sts
                    ,  x_msg_count            => l_msg_count
                    ,  x_msg_data             => l_msg_data
                    );

Line: 1736


          l_err_msg := 'update_conterms_dates not successful';

Line: 1765


          UPDATE PO_HEADERS poh
          SET    poh.authorization_status     = PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED
              ,  poh.approved_flag            = 'N'
              ,  poh.last_update_date         = SYSDATE
              ,  poh.last_updated_by          = p_user_id
              ,  poh.last_update_login        = p_login_id
          WHERE poh.po_header_id = p_document_id;

Line: 1778


        UPDATE PO_LINE_LOCATIONS_ALL poll
        SET    poll.approved_flag             = 'Y'
            ,  poll.approved_date             = SYSDATE
            ,  poll.last_update_date          = SYSDATE
            ,  poll.last_updated_by           = p_user_id
            ,  poll.last_update_login         = p_login_id
        WHERE poll.po_header_id = p_document_id
          AND poll.po_release_id IS NULL
          AND NVL(poll.approved_flag, 'N') <> 'Y'
          AND EXISTS ( SELECT 'PO Does not require signature'
                       FROM PO_HEADERS_ALL poh
                       WHERE poh.po_header_id = poll.po_header_id
                         AND NVL(poh.pending_signature_flag, 'N') <> 'Y');

Line: 1799


        UPDATE PO_LINE_LOCATIONS_ALL poll
        SET    poll.approved_flag             = 'R'
            ,  poll.last_update_date          = SYSDATE
            ,  poll.last_updated_by           = p_user_id
            ,  poll.last_update_login         = p_login_id
        WHERE poll.po_header_id = p_document_id
          AND poll.po_release_id IS NULL
          AND NVL(poll.approved_flag, 'N') = 'Y';

Line: 1815


      UPDATE PO_RELEASES por
      SET    por.authorization_status   = p_new_status,
             por.approved_flag = DECODE(p_new_status,
                PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,    'Y',
                PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL,  'R',
                PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED,    'F',
                PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED,    'F',
                PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE,  'N',
                PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS,   'N',
                PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED, 'N'),
             por.approved_date = DECODE(p_new_status,
                PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED,  SYSDATE,
                                                       por.approved_date),
             por.last_update_date     = SYSDATE,
             por.last_updated_by      = p_user_id,
             por.last_update_login    = p_login_id
      WHERE por.po_release_id = p_document_id;

Line: 1838


        UPDATE PO_LINE_LOCATIONS_ALL poll
        SET    poll.approved_flag             = 'Y'
            ,  poll.approved_date             = SYSDATE
            ,  poll.last_update_date          = SYSDATE
            ,  poll.last_updated_by           = p_user_id
            ,  poll.last_update_login         = p_login_id
        WHERE poll.po_release_id = p_document_id
          AND NVL(poll.approved_flag, 'N') <> 'Y';

Line: 1854


        UPDATE PO_LINE_LOCATIONS_ALL poll
        SET    poll.approved_flag             = 'R'
            ,  poll.last_update_date          = SYSDATE
            ,  poll.last_updated_by           = p_user_id
            ,  poll.last_update_login         = p_login_id
        WHERE poll.po_release_id = p_document_id
          AND NVL(poll.approved_flag, 'N') = 'Y';

Line: 1907


END update_doc_auth_status;

Line: 1913


PROCEDURE update_doc_notifications(
   p_document_id        IN         NUMBER
,  p_document_type      IN         VARCHAR2
,  p_document_subtype   IN         VARCHAR2
,  p_notify_action      IN         VARCHAR2
,  p_notify_employee    IN         NUMBER
,  p_doc_creation_date  IN         DATE
,  p_user_id            IN         NUMBER
,  p_login_id           IN         NUMBER
,  x_return_status      OUT NOCOPY VARCHAR2
)
IS

d_progress        NUMBER;

Line: 1927


d_module          VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.update_doc_notifications';

Line: 1945


  DELETE FROM PO_NOTIFICATIONS pon
  WHERE pon.object_type_lookup_code = DECODE(p_document_type,
                                       'PO', p_document_subtype,
                                       'PA', p_document_subtype,
                                             p_document_type)
    AND pon.object_id = p_document_id
    AND pon.employee_id > -1;

Line: 1959


    INSERT INTO PO_NOTIFICATIONS(
        employee_id
     ,  object_type_lookup_code
     ,  object_id
     ,  last_update_date
     ,  last_updated_by
     ,  last_update_login
     ,  creation_date
     ,  created_by
     ,  object_creation_date
     ,  action_lookup_code
     )
     VALUES(
        p_notify_employee
     ,  DECODE(p_document_type,
                  'PO', p_document_subtype,
                  'PA', p_document_subtype,
                        p_document_type)
     ,  p_document_id
     ,  SYSDATE
     ,  p_user_id
     ,  p_login_id
     ,  SYSDATE
     ,  p_user_id
     ,  SYSDATE
     ,  p_notify_action
     );

Line: 2011


END update_doc_notifications;

Line: 2015


PROCEDURE insert_auth_action_history(
   p_document_id        IN          NUMBER
,  p_revision_num       IN          NUMBER
,  p_document_type      IN          VARCHAR2
,  p_document_subtype   IN          VARCHAR2
,  p_action             IN          VARCHAR2
,  p_employee_id        IN          NUMBER
,  p_offline_code       IN          VARCHAR2
,  p_approval_path_id   IN          NUMBER
,  p_note               IN          VARCHAR2
,  p_user_id            IN          NUMBER
,  p_login_id           IN          NUMBER
,  x_return_status      OUT NOCOPY  VARCHAR2
)
IS

l_sequence_num   PO_ACTION_HISTORY.sequence_num%TYPE;

Line: 2034


d_module          VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.insert_auth_action_history';

Line: 2057


  SELECT max(poah.sequence_num) + 1
  INTO l_sequence_num
  FROM PO_ACTION_HISTORY poah
  WHERE poah.object_type_code = p_document_type
    AND poah.object_id = p_document_id;

Line: 2080


  INSERT INTO PO_ACTION_HISTORY
  (  object_id
  ,  object_type_code
  ,  object_sub_type_code
  ,  sequence_num
  ,  last_update_date
  ,  last_updated_by
  ,  creation_date
  ,  created_by
  ,  action_code
  ,  action_date
  ,  employee_id
  ,  note
  ,  object_revision_num
  ,  last_update_login
  ,  request_id
  ,  program_application_id
  ,  program_id
  ,  program_update_date
  ,  approval_path_id
  ,  offline_code
  )
  VALUES
  (  p_document_id
  ,  p_document_type
  ,  p_document_subtype
  ,  l_sequence_num
  ,  SYSDATE
  ,  p_user_id
  ,  SYSDATE
  ,  p_user_id
  ,  p_action
  ,  DECODE(p_action, '', to_date(NULL), SYSDATE)
  ,  p_employee_id
  ,  p_note
  ,  p_revision_num
  ,  p_login_id
  ,  0
  ,  0
  ,  0
  ,  ''
  ,  p_approval_path_id
  ,  p_offline_code
  );

Line: 2147


END insert_auth_action_history;

Line: 2149


PROCEDURE update_auth_action_history(
   p_document_id        IN          NUMBER
,  p_revision_num       IN          NUMBER
,  p_document_type      IN          VARCHAR2
,  p_action             IN          VARCHAR2
,  p_approval_path_id   IN          NUMBER
,  p_note               IN          VARCHAR2
,  p_user_id            IN          NUMBER
,  x_return_status      OUT NOCOPY  VARCHAR2
)
IS

d_progress        NUMBER;

Line: 2162


d_module          VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.update_auth_action_history';

Line: 2180


  UPDATE PO_ACTION_HISTORY
  SET   action_code           = p_action
      , action_date           = SYSDATE
      , note                  = p_note
      , last_updated_by       = p_user_id
      , last_update_date      = SYSDATE
      , object_revision_num   = p_revision_num
      , approval_path_id      = p_approval_path_id
  WHERE object_id = p_document_id
    AND object_type_code = p_document_type
    AND action_code IS NULL;

Line: 2214


END update_auth_action_history;