APPS.PSB_SUBMIT_REVISION_PVT SQL Statements

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

Line: 90

    Select requestor,user_name
      from psb_budget_revisions pbr,
           fnd_user  fu
     where budget_revision_id = l_budget_revision_id
       and requestor = user_id;

Line: 97

   Select justification
      from psb_budget_revisions
     where budget_revision_id = l_budget_revision_id;

Line: 118

  SELECT worksheet_id INTO l_budget_revision_id
  FROM   psb_workflow_processes
  WHERE  item_key = p_item_key
    AND  document_type = 'BR';

Line: 198

    SELECT comments INTO l_comments
    FROM   psb_ws_submit_comments
    WHERE  operation_id = p_operation_id;

Line: 292

  SELECT budget_group_name
       INTO
         l_budget_group_name
  FROM   psb_budget_revisions_v
  WHERE  budget_revision_id = l_budget_revision_id;

Line: 524

 |                        PROCEDURE Select_Operation                         |
 +===========================================================================*/
--
-- The API selects the operation to be performed on the Revision. The
-- appropriate branch on the process is selected accordingly.
--
PROCEDURE Select_Operation
(
  itemtype                    IN       VARCHAR2,
  itemkey                     IN       VARCHAR2,
  actid                       IN       NUMBER,
  funcmode                    IN       VARCHAR2,
  result                      OUT  NOCOPY      VARCHAR2
)
IS
  --
  l_budget_revision_id       psb_budget_revisions.budget_revision_id%TYPE ;

Line: 598

    wf_core.context('PSBBR',   'Select_Operation',
                     itemtype, itemkey, to_char(actid), funcmode);

Line: 602

END Select_Operation ;

Line: 660

  SELECT budget_group_name INTO g_budgetgroup_name
  FROM   psb_budget_revisions_v
  WHERE  budget_revision_id  = l_budget_revision_id ;

Line: 738

    SELECT NVL(freeze_flag, 'N')  INTO l_current_freeze_flag
    FROM   psb_budget_revisions
    WHERE  budget_revision_id = l_budget_revisions_tab(i) ;

Line: 767

      SELECT budget_group_id   ,
             budget_group_name
        INTO
             l_budget_group_id   ,
             g_budgetgroup_name
      FROM   psb_budget_revisions_v
      WHERE  budget_revision_id = l_budget_revisions_tab(i) ;

Line: 782

         SELECT wf_role_name
         FROM   psb_budget_groups     bg ,
                psb_budget_group_resp resp
         WHERE  resp.responsibility_type  = 'N'
         AND    bg.budget_group_id        = l_budget_group_id
         AND    bg.budget_group_id        = resp.budget_group_id
      )
      LOOP
        --
        l_notification_id :=
                   WF_Notification.SendGroup
                   (  role     => l_role_rec.wf_role_name                 ,
                      msg_type => 'PSBBR'                                 ,
                      msg_name => 'NOTIFY_OF_FREEZE_COMPLETION'           ,
                      context  => itemtype ||':'|| itemkey ||':'|| actid  ,
                      callback => 'PSB_Submit_Revision_PVT.Callback'
                    ) ;

Line: 862

    Select global_budget_revision
      from psb_budget_revisions
     where budget_revision_id = l_budget_revision_id;*/

Line: 988

 |                     PROCEDURE Update_View_Line_Flag                       |
 +===========================================================================*/
--
-- The API updates view_line flag for the parent revisions of the submittted
-- revision.
--
PROCEDURE Update_View_Line_Flag
(
  itemtype                    IN       VARCHAR2,
  itemkey                     IN       VARCHAR2,
  actid                       IN       NUMBER,
  funcmode                    IN       VARCHAR2,
  result                      OUT  NOCOPY      VARCHAR2
)
IS
  --
  l_return_status           VARCHAR2(1) ;

Line: 1059

    UPDATE psb_budget_revision_lines
    SET    view_line_flag =  'Y'
    WHERE  budget_revision_id   =  l_budget_revisions_tab(i) ;

Line: 1063

    UPDATE psb_budget_revision_pos_lines
    SET    view_line_flag     = 'Y'
    WHERE  budget_revision_id = l_budget_revisions_tab(i) ;

Line: 1092

    wf_core.context('PSBBR',   'Update_View_Line_Flag',
                     PSB_Message_S.Get_Error_Stack(l_msg_count) );

Line: 1096

END Update_View_Line_Flag;

Line: 1136

   SELECT br.approval_override_by, wr.name,wr.display_name
          INTO
          l_override_approver    , l_approver_name,l_approver_display_name
   FROM   psb_budget_revisions br,
          wf_roles             wr
   WHERE  br.budget_revision_id    = l_budget_revision_id
   AND    br.approval_orig_system  = orig_system(+)
   AND    br.approval_override_by  = orig_system_id(+) ;

Line: 1263

 |                        PROCEDURE Update_Revisions_Status                 |
 +===========================================================================*/
--
-- The API updates submission related information in the submitted revision
-- and all its lower revisions.
--
PROCEDURE Update_Revisions_Status
(
  itemtype                    IN       VARCHAR2,
  itemkey                     IN       VARCHAR2,
  actid                       IN       NUMBER,
  funcmode                    IN       VARCHAR2,
  result                      OUT  NOCOPY      VARCHAR2
)
IS
  --
  l_return_status           VARCHAR2(1) ;

Line: 1404

    wf_core.context('PSBBR',   'Update_Revisions_Status',
                     PSB_Message_S.Get_Error_Stack(l_msg_count) );

Line: 1408

END Update_Revisions_Status ;

Line: 1413

 |                     PROCEDURE Update_Baseline_Values                      |
 +===========================================================================*/
--
-- This API updates the base value of the position ftes, position costs and
-- position account distributions after the revision is approved.
--

PROCEDURE Update_Baseline_Values
(
  itemtype                    IN       VARCHAR2,
  itemkey                     IN       VARCHAR2,
  actid                       IN       NUMBER,
  funcmode                    IN       VARCHAR2,
  result                      OUT  NOCOPY      VARCHAR2
)
IS
  --
  l_return_status           VARCHAR2(1) ;

Line: 1440

    Select global_budget_revision,
           currency_code  -- Bug 3029168
      from psb_budget_revisions
     where budget_revision_id = l_budget_revision_id;

Line: 1473

    PSB_Budget_Revisions_Pvt.Update_Baseline_Values
    (
       p_api_version                 => 1.0 ,
       p_init_msg_list               => FND_API.G_FALSE,
       p_commit                      => FND_API.G_FALSE,
       p_validation_level            => FND_API.G_VALID_LEVEL_NONE,
       p_return_status               => l_return_status,
       p_msg_count                   => l_msg_count,
       p_msg_data                    => l_msg_data ,
       --
       p_budget_revision_id          => l_budget_revision_id
    );

Line: 1512

    wf_core.context('PSBBR',   'Update_Baseline_Values',
                     PSB_Message_S.Get_Error_Stack(l_msg_count) );

Line: 1516

END Update_Baseline_Values ;

Line: 1519

 |                     PROCEDURE Funds_Reservation_Update                    |
 +===========================================================================*/
--
-- This API does a funds reservation for each of the accounts affected
-- by the current budget revision
--

PROCEDURE Funds_Reservation_Update
(
  itemtype                    IN       VARCHAR2,
  itemkey                     IN       VARCHAR2,
  actid                       IN       NUMBER,
  funcmode                    IN       VARCHAR2,
  result                      OUT  NOCOPY      VARCHAR2
)
IS
  --
  l_return_status           VARCHAR2(1) ;

Line: 1557

  SELECT currency_code INTO l_currency_code
    FROM psb_budget_revisions
   WHERE budget_revision_id = l_budget_revision_id; -- Bug 3029168

Line: 1644

    wf_core.context('PSBBR',   'Funds_Reservation_Update',
                     PSB_Message_S.Get_Error_Stack(l_msg_count) );

Line: 1648

END Funds_Reservation_Update ;

Line: 1651

 |                     PROCEDURE Select_Approvers                            |
 +===========================================================================*/
--
-- The API finds Approvers for the REvision and then sends notifications
-- to them.
--
PROCEDURE Select_Approvers
(
  itemtype                    IN       VARCHAR2,
  itemkey                     IN       VARCHAR2,
  actid                       IN       NUMBER,
  funcmode                    IN       VARCHAR2,
  result                      OUT  NOCOPY      VARCHAR2
)
IS
  --
  l_budget_revision_id        psb_budget_revisions.budget_revision_id%TYPE ;

Line: 1700

  SELECT nvl(bg.parent_budget_group_id,bg.budget_group_id)
      INTO
         l_parent_budget_group_id
  FROM   psb_budget_revisions  br,
         psb_budget_groups bg
  WHERE  br.budget_revision_id    = l_budget_revision_id
  AND    br.budget_group_id = bg.budget_group_id ;

Line: 1712

     SELECT wf_role_name
     FROM   psb_budget_groups     bg ,
            psb_budget_group_resp resp
     WHERE  bg.budget_group_id       = l_parent_budget_group_id
     AND    resp.responsibility_type = 'N'
     AND    bg.budget_group_id       = resp.budget_group_id
  )
  LOOP
    --
    l_notification_group_id :=
                  WF_Notification.SendGroup
                  (
                     role     => l_role_rec.wf_role_name                  ,
                     msg_type => 'PSBBR'                                  ,
                     msg_name => 'NOTIFY_APPROVERS_OF_SUBMISSION'         ,
                     context  => itemtype ||':'|| itemkey || ':'|| actid  ,
                     callback => 'PSB_Submit_Revision_PVT.Callback'
                  ) ;

Line: 1753

    wf_core.context('PSBBR',   'Select_Approvers',
                     itemtype, itemkey, to_char(actid), funcmode);

Line: 1757

END Select_Approvers ;

Line: 1889

  SELECT nvl(bg.parent_budget_group_id,bg.budget_group_id)
      INTO
         l_parent_budget_group_id
  FROM   psb_budget_revisions  br,
         psb_budget_groups bg
  WHERE  br.budget_revision_id    = l_budget_revision_id
  AND    br.budget_group_id = bg.budget_group_id ;

Line: 1901

 SELECT count(*)
   INTO g_num_approvers
   FROM psb_budget_group_resp resp
  WHERE resp.budget_group_id in
       (select budget_group_id from psb_budget_groups bg
         start with bg.budget_group_id = l_parent_budget_group_id
        connect by prior bg.parent_budget_group_id = bg.budget_group_id)
    AND resp.responsibility_type = 'N';

Line: 2004

   SELECT nvl(bg.parent_budget_group_id,bg.budget_group_id)
     INTO l_parent_budget_group_id
     FROM psb_budget_revisions  br,
          psb_budget_groups bg
    WHERE br.budget_revision_id = l_budget_revision_id
      AND br.budget_group_id = bg.budget_group_id;

Line: 2016

     SELECT bg.bglevel                ,
            resp.budget_group_resp_id ,
            resp.wf_role_name         ,
            wfr.name  name            ,
            wfr.display_name display_name
     FROM   psb_budget_group_resp resp,
            wf_roles               wfr,
            ( SELECT level    bglevel,
                     budget_group_id
              FROM   psb_budget_groups
              START WITH budget_group_id              = l_parent_budget_group_id              CONNECT BY PRIOR parent_budget_group_id = budget_group_id
            )                     bg
      WHERE bg.budget_group_id       = resp.budget_group_id
      AND   resp.responsibility_type = 'N'
      AND   wfr.orig_system          = resp.wf_role_orig_system
      AND   wfr.orig_system_id       = resp.wf_role_orig_system_id
      ORDER BY 1,2
   )
  Loop
  g_num_approvers                            := g_num_approvers + 1;

Line: 2180

   SELECT justification
     FROM psb_budget_revisions
    WHERE budget_revision_id = g_budget_revision_id;

Line: 2308

  SELECT worksheet_id INTO l_budget_revision_id
  FROM   psb_workflow_processes
  WHERE  item_key = p_item_key
    AND  document_type  = 'BR';

Line: 2513

  SELECT budget_group_name
    INTO l_budget_group_name
    FROM psb_budget_revisions_v
   WHERE budget_revision_id = l_budget_revision_id;