APPS.FPA_PROCESS_PVT SQL Statements

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

Line: 12

PROCEDURE create_update_access_list
     ( p_portf_users_tbl IN  FPA_PORTFOLIO_USERS_TBL,
      p_portfolio_id  NUMBER,
       x_return_status      OUT NOCOPY  VARCHAR2,
       x_msg_data           OUT NOCOPY  VARCHAR2,
       x_msg_count          OUT NOCOPY  NUMBER
    );

Line: 62

     SELECT a.strategic_obj
            ,nvl(e.strategic_obj_weight,0)
            ,0 Targetfrom
            ,0 Targetto
       FROM fpa_aw_inv_criteria_v a
            ,fpa_aw_inv_criteria_info_v e
     WHERE a.strategic_obj = e.strategic_obj;

Line: 164

        SELECT p.name INTO l_portfolio_name
        FROM fpa_portfs_vl p
        WHERE portfolio = p_pc_all_obj.pc_info.portfolio;

Line: 333

        SELECT count(strategic_obj)
        INTO l_inv_crit_count
        FROM fpa_aw_inv_criteria_v;

Line: 358

            'Calling FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data for Setup values, when UI did not have any values.'
          );

Line: 361

        FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data
          (
            p_api_version => 1.0,
            p_inv_crit_tbl  => l_inv_criteria_tbl,
            x_return_status  =>  x_return_status,
            x_msg_data   =>  x_msg_data,
            x_msg_count  =>  x_msg_count
          );

Line: 403

            'Calling FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data for setting up default values.'
          );

Line: 406

         FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data
         (
           p_api_version => 1.0,
           p_inv_crit_tbl  => l_inv_criteria_tbl,
           x_return_status  =>  x_return_status,
           x_msg_data   =>  x_msg_data,
           x_msg_count  =>  x_msg_count
         );

Line: 431

          'Calling FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data for UI values.'
        );

Line: 434

      FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data
        (
          p_api_version => 1.0,
          p_inv_crit_tbl  => l_inv_criteria_tbl,
          x_return_status  =>  x_return_status,
          x_msg_data   =>  x_msg_data,
          x_msg_count  =>  x_msg_count
        );

Line: 451

          'Calling FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix.'
        );

Line: 455

          FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix
               (
                p_api_version => 1.0,
                p_inv_matrix  => l_inv_matrix_tbl,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 491

              'Calling FPA_PlanningCycle_Pvt.Update_Pc_Class_Category.'
             );

Line: 495

        FPA_PlanningCycle_Pvt.Update_Pc_Class_Category
             (
                p_api_version => 1.0,
                p_pc_id  => l_new_pc_id,
                p_catg_id => p_pc_all_obj.pc_info.pc_category,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 511

              'Calling FPA_PlanningCycle_Pvt.Update_Pc_Calendar'
            );

Line: 515

          FPA_PlanningCycle_Pvt.Update_Pc_Calendar
             (
                p_api_version => 1.0,
                p_pc_info  => l_pc_info,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 530

              'Calling FPA_PlanningCycle_Pvt.Update_Pc_Currency'
            );

Line: 533

          FPA_PlanningCycle_Pvt.Update_Pc_Currency
             (
                p_api_version => 1.0,
                p_pc_info  =>  l_pc_info,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 548

              'Calling FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date'
            );

Line: 553

          FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date
             (
                p_api_version => 1.0,
                p_pc_info  =>  l_pc_info,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 570

          'CAlling FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds.'
        );

Line: 575

          FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds
               (
                p_api_version => 1.0,
                p_disc_funds  => l_discount_obj,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 590

          'CAlling FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets.'
        );

Line: 594

          FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets
               (
                p_api_version => 1.0,
                p_fin_targets_tbl  => l_fin_targets_tbl,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 610

          'CAlling FPA_PlanningCycle_Pvt.Pa_Distrb_Lists_Insert_Row.'
        );

Line: 614

        FPA_PlanningCycle_Pvt.Pa_Distrb_Lists_Insert_Row
              (
                p_api_version => 1.0,
                p_distr_list =>  l_distr_list,
                p_list_id    =>  l_distr_list_id,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 635

          'Calling FPA_PlanningCycle_Pvt.Pa_Dist_List_Items_Update_Row'
        );

Line: 639

        FPA_PlanningCycle_Pvt.Pa_Dist_List_Items_Update_Row
              (
                p_api_version => 1.0,
                p_distr_list_items_tbl =>  l_distr_list_items_tbl,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 658

      dbms_aw.execute('UPDATE');

Line: 739

 * UPDATE case for Planning Cycle(PC). This API checks for the null values
 * in object types and only updates not null objects.
 * The calling program populates only those objects in fpa_pc_all_obj
 * which needs update.
 */


PROCEDURE Update_Pc
     ( p_api_version        IN NUMBER,
       p_commit             IN VARCHAR2 := FND_API.G_FALSE,
       p_pc_all_obj         IN fpa_pc_all_obj,
       x_return_status      OUT NOCOPY VARCHAR2,
       x_msg_data           OUT NOCOPY VARCHAR2,
       x_msg_count          OUT NOCOPY NUMBER )
IS
l_pc_info fpa_pc_info_obj;

Line: 763

            'fpa.sql.FPA_Process_Pvt.Update_Pc.begin',
            'Entering FPA_Process_Pvt.Update_Pc'
        );

Line: 772

            'fpa.sql.FPA_Process_Pvt.Update_Pc',
            'Initializing l_pc_info with p_pc_all_obj.pc_info'
        );

Line: 784

            'fpa.sql.FPA_Process_Pvt.Update_Pc',
            'Calling Fpa_Utilities_Pvt.attach_AW'
        );

Line: 805

            'fpa.sql.FPA_Process_Pvt.Update_Pc',
            'Calling FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields'
        );

Line: 809

      FPA_PlanningCycle_Pvt.Update_Pc_Desc_Fields
            (
                p_api_version => 1.0,
                p_pc_all_obj => p_pc_all_obj,
                x_return_status  =>  x_return_status,
                x_msg_data  =>  x_msg_data,
                x_msg_count =>  x_msg_count
            );

Line: 825

            'fpa.sql.FPA_Process_Pvt.Update_Pc',
            'Calling FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix'
        );

Line: 829

      FPA_PlanningCycle_Pvt.Update_Pc_Invest_Mix
             (
                p_api_version => 1.0,
                p_inv_matrix  => p_pc_all_obj.pc_investmix,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 846

            'fpa.sql.FPA_Process_Pvt.Update_Pc',
            'Calling FPA_PlanningCycle_Pvt.Update_Pc_Class_Category'
        );

Line: 850

      FPA_PlanningCycle_Pvt.Update_Pc_Class_Category
             (
                p_api_version => 1.0,
                p_pc_id  => p_pc_all_obj.pc_info.planning_cycle,
                p_catg_id => p_pc_all_obj.pc_info.pc_category,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 864

            'fpa.sql.FPA_Process_Pvt.Update_Pc',
            'Calling FPA_PlanningCycle_Pvt.Update_Pc_Calendar'
        );

Line: 868

      FPA_PlanningCycle_Pvt.Update_Pc_Calendar
          (
                p_api_version => 1.0,
                p_pc_info  => l_pc_info,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
           );

Line: 881

            'fpa.sql.FPA_Process_Pvt.Update_Pc',
            'Calling FPA_PlanningCycle_Pvt.Update_Pc_Currency'
        );

Line: 885

      FPA_PlanningCycle_Pvt.Update_Pc_Currency
             (
                p_api_version => 1.0,
                p_pc_info  =>  l_pc_info,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 900

            'fpa.sql.FPA_Process_Pvt.Update_Pc',
            'Calling FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date'
            );

Line: 904

          FPA_PlanningCycle_Pvt.Update_Pc_Sub_Due_Date
             (
                p_api_version => 1.0,
                p_pc_info  =>  l_pc_info,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 921

            'fpa.sql.FPA_Process_Pvt.Update_Pc',
            'Calling FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds'
            );

Line: 925

          FPA_PlanningCycle_Pvt.Update_Pc_Discount_funds
               (
                p_api_version => 1.0,
                p_disc_funds  => p_pc_all_obj.pc_discount,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 941

            'fpa.sql.FPA_Process_Pvt.Update_Pc',
            'Calling FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets'
            );

Line: 945

          FPA_PlanningCycle_Pvt.Update_Pc_Fin_Targets
               (
                p_api_version => 1.0,
                p_fin_targets_tbl  => p_pc_all_obj.pc_targets,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 961

            'fpa.sql.FPA_Process_Pvt.Update_Pc',
            'Calling FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data'
            );

Line: 966

          FPA_PlanningCycle_Pvt.Update_Pc_Inv_Criteria_Data
               (
                p_api_version => 1.0,
                p_inv_crit_tbl  => p_pc_all_obj.pc_invest_criteria,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 983

            'fpa.sql.FPA_Process_Pvt.Update_Pc',
            'Calling FPA_PlanningCycle_Pvt.Pa_Dist_List_Items_Update_Row'
            );

Line: 987

        FPA_PlanningCycle_Pvt.Pa_Dist_List_Items_Update_Row
              (
                p_api_version => 1.0,
                p_distr_list_items_tbl =>  p_pc_all_obj.distr_list_items,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 1004

           'fpa.sql.FPA_Process_Pvt.Update_Pc',
           'Updating AW and committing database.'
           );

Line: 1008

         dbms_aw.execute('UPDATE');

Line: 1017

       'fpa.sql.FPA_Process_Pvt.Update_Pc',
       'Calling Fpa_Utilities_Pvt.detach_AW.'
       );

Line: 1034

            'fpa.sql.FPA_Process_Pvt.Update_Pc.end',
            'Exiting FPA_Process_Pvt.Update_Pc'
        );

Line: 1043

        FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Update_Pc');

Line: 1063

            'fpa.sql.FPA_Process_Pvt.Update_Pc',
            SQLERRM
        );

Line: 1074

END Update_Pc;

Line: 1098

SELECT prevPC.planning_cycle
  FROM FPA_AW_PC_INFO_V prevPC,
       FPA_AW_PC_INFO_V currPC
 WHERE prevPC.portfolio = currPC.portfolio
   AND currPC.planning_cycle = p_pc_id
   AND prevPC.last_flag =  1;

Line: 1146

     SELECT CALENDAR_NAME , PERIOD_TYPE, CAL_PERIOD_TYPE
     INTO l_cal_name, l_period_type, l_cal_period_type
     FROM FPA_AW_PC_INFO_V
     WHERE PLANNING_CYCLE = p_pc_id;

Line: 1258

         dbms_aw.execute('UPDATE');

Line: 1326

 * DELETES the User from Distribution list Subtab in Planning Cycle(PC).
 */

PROCEDURE Pa_Dist_List_Items_Delete_Row (
        p_api_version         IN NUMBER,
        p_commit              IN VARCHAR2 := FND_API.G_FALSE,
        P_LIST_ITEM_ID        IN NUMBER,
        x_return_status       OUT NOCOPY VARCHAR2,
        x_msg_data            OUT NOCOPY VARCHAR2,
        x_msg_count           OUT NOCOPY NUMBER )
IS
BEGIN
    IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
        FND_LOG.String
        (
            FND_LOG.LEVEL_PROCEDURE,
            'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row.begin',
            'Entering FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row'
        );

Line: 1348

     PA_DIST_LIST_ITEMS_PKG.Delete_Row
            (
                P_LIST_ITEM_ID  => P_LIST_ITEM_ID
            );

Line: 1363

            'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row.end',
            'Exiting FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row'
        );

Line: 1372

        FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row');

Line: 1384

            'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row',
            SQLERRM
        );

Line: 1396

END Pa_Dist_List_Items_Delete_Row;

Line: 1504

                create_update_access_list
                ( l_default_portf_user_tbl,
                     portfolio_rec.portfolio_id,
                    x_return_status ,
                    x_msg_data,
                   x_msg_count

                );

Line: 1521

                    create_update_access_list
                    ( p_portfolio_obj.portfolio_users,
                        portfolio_rec.portfolio_id,
                       x_return_status  ,
                       x_msg_data,
                       x_msg_count
                    );

Line: 1539

            dbms_aw.execute('UPDATE');

Line: 1645

    PROCEDURE Delete_Portfolio
     (
       p_api_version        IN          NUMBER,
       p_commit            IN           VARCHAR2 := FND_API.G_FALSE,
       p_portfolio_id       IN          NUMBER,
       x_return_status      OUT NOCOPY  VARCHAR2,
       x_msg_data           OUT NOCOPY  VARCHAR2,
       x_msg_count          OUT NOCOPY  NUMBER
    )
IS
BEGIN
        IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
        fnd_log.string
        (
            FND_LOG.LEVEL_PROCEDURE,
            'fpa_process_pvt.Delete_Portfolio.begin',
            'Entering fpa_process_pvt.Delete_Portfolio'
        );

Line: 1669

                'fpa.sql.fpa_process_pvt.Delete_Portfolio',
                'Attaching OLAP workspace: '
            );

Line: 1685

        FPA_Portfolio_PVT.Delete_Portfolio
                        (
                            p_api_version   => p_api_version,
                            p_portfolio_id  => p_portfolio_id  ,
                            x_return_status => x_return_status,
                            x_msg_data      => x_msg_data,
                            x_msg_count     =>x_msg_count
                        );

Line: 1697

            dbms_aw.execute('UPDATE');

Line: 1706

                'fpa.sql.fpa_process_pvt.Delete_Portfolio',
                'Detaching OLAP workspace: '
            );

Line: 1723

            'fpa.sql.fpa_process_pvt.Delete_Portfolio.end',
            'Exiting fpa_process_pvt.Delete_Portfolio'
        );

Line: 1733

        FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.Delete_Portfolio');

Line: 1753

            'fpa_process_pvt.Delete_Portfolio',
            SQLERRM
        );

Line: 1765

END Delete_Portfolio;

Line: 1775

PROCEDURE Update_Portfolio
     (
        p_api_version       IN      NUMBER,
        p_commit            IN      VARCHAR2 := FND_API.G_FALSE,
        p_portfolio_obj     IN  FPA_PORTFO_ALL_OBJ,
        x_return_status     OUT NOCOPY  VARCHAR2,
        x_msg_data          OUT NOCOPY  VARCHAR2,
        x_msg_count         OUT NOCOPY  NUMBER
    )

IS
BEGIN
    -- clear all previous messages.
        FND_MSG_PUB.Initialize;

Line: 1794

            'fpa.sql.fpa_process_pvt.update_portfolio.begin',
            'Entering fpa_process_pvt.update_portfolio'
        );

Line: 1818

                    'fpa.sql.fpa_process_pvt.update_portfolio',
                    'Duplicate Portfolio Name'
                  );

Line: 1832

                'fpa.sql.fpa_process_pvt.update_portfolio',
                'Attaching OLAP workspace: '
            );

Line: 1879

         FPA_SECURITY_PVT.update_portfolio_owner
         (
          p_api_version => p_api_version,
          p_init_msg_list =>  'F',
          p_portfolio_id => portfolio_rec.portfolio_id,
          p_person_id  =>  portfolio_rec.Portfolio_owner_id,
          x_return_status =>      x_return_status,
          x_msg_count =>          x_msg_count,
          x_msg_data =>           x_msg_data
          );

Line: 1892

             create_update_access_list
                (   p_portfolio_obj.portfolio_users,
                     portfolio_rec.portfolio_id,
                    x_return_status ,
                    x_msg_data,
                   x_msg_count

            );

Line: 1904

            dbms_aw.execute('UPDATE');

Line: 1958

        FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.update_portfolio');

Line: 1978

            'fpa_process_pvt.update_portfolio',
            SQLERRM
        );

Line: 1998

    PROCEDURE delete_Portfolio_user
     (
        p_api_version       IN      NUMBER,
        p_commit            IN      VARCHAR2 := FND_API.G_FALSE,
        p_project_party_id  IN      NUMBER,
        x_return_status     OUT NOCOPY  VARCHAR2,
        x_msg_data          OUT NOCOPY  VARCHAR2,
        x_msg_count         OUT NOCOPY  NUMBER
    ) IS
    BEGIN

      IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
        fnd_log.string
        (
            FND_LOG.LEVEL_PROCEDURE,
            'fpa.sql.fpa_process_pvt.delete_portfolio_user.begin',
            'Entering fpa_process_pvt.delete_portfolio_user'
        );

Line: 2019

      FPA_SECURITY_PVT.Delete_Portfolio_User
            (
                p_api_version => 1,
                p_init_msg_list =>     'F',
                p_portfolio_party_id => p_project_party_id,
                p_instance_set_name=>   'PJP_PORTFOLIO_SET',
                x_return_status =>      x_return_status,
                x_msg_count =>          x_msg_count,
                x_msg_data =>           x_msg_data
            );

Line: 2034

            'fpa.sql.fpa_process_pvt.delete_portfolio_user.end',
            'Exiting fpa_process_pvt.delete_portfolio_user'
        );

Line: 2053

        FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.delete_Portfolio_user');

Line: 2072

            'fpa_process_pvt.delete_Portfolio_user',
            SQLERRM
        );

Line: 2107

PROCEDURE create_update_access_list
     ( p_portf_users_tbl IN  FPA_PORTFOLIO_USERS_TBL,
       p_portfolio_id  NUMBER,
       x_return_status      OUT NOCOPY  VARCHAR2,
       x_msg_data           OUT NOCOPY  VARCHAR2,
       x_msg_count          OUT NOCOPY  NUMBER
    )
IS
l_project_party_id number;

Line: 2119

 l_api_name               CONSTANT VARCHAR2(30) := 'Create_Update_Access_List';

Line: 2130

            'fpa.sql.fpa_process_pvt.create_update_access_list.begin',
            'Entering fpa_process_pvt.create_update_access_list'
        );

Line: 2144

                 p_msg_log       => 'Entering fpa_process_pvt.create_update_access_list.begin',
                 x_return_status => x_return_status);

Line: 2185

                       FPA_SECURITY_PVT.update_portfolio_user(
                                             p_api_version => 1,
                                             p_init_msg_list =>     'F',
                                             p_portfolio_party_id  => p_portf_users_tbl(i).project_party_id,
                                             p_project_role_id =>    p_portf_users_tbl(i).role_id,
                                             p_start_date_active =>  p_portf_users_tbl(i).start_Date,
                                             p_end_date_active =>    p_portf_users_tbl(i).end_Date,
                                             x_return_status =>      x_return_status,
                                             x_msg_count =>          x_msg_count,
                                             x_msg_data =>           x_msg_data
                                           );

Line: 2228

            'fpa.sql.fpa_process_pvt.create_update_access_list.end',
            'Exiting fpa_process_pvt.create_update_access_list'
        );

Line: 2343

        select a.name ,a.description ,b.initiate_date ,b.submission_due_date
          into l_pc_name, l_pc_description, l_pc_date_initiated, l_due_date
          from fpa_pcs_vl a ,fpa_aw_pc_info_v b
         where a.planning_cycle = b.planning_cycle
           and a.planning_cycle = l_pc_id;

Line: 2429

                dbms_aw.execute('UPDATE');

Line: 2525

         select pset.INIT_PROJECT_SET_ID
       from fpa_aw_sce_info_v sc, fpa_aw_pc_info_v pc, fpa_aw_project_sets_v pset
       where sc.planning_cycle = pc.planning_cycle
       and pc.portfolio = pset.portfolio
       and sc.scenario = p_scenario_id;

Line: 2533

         SELECT scenario ,project, scenario_project_valid
       FROM table (CAST(  ( olap_table ('fpa.fpapjp duration query', 'fpa_advanced_search_tbl','',
       'DIMENSION scenario FROM scenario_d DIMENSION project from project_d MEASURE scenario_project_valid from scenario_project_m')) as fpa_advanced_search_tbl))
       WHERE scenario_project_valid = 1 and scenario = p_scenario;

Line: 2570

       select scenario
     into l_init_scenario_id
     from fpa_aw_sce_info_v
     where is_initial_scenario = 1
     and planning_cycle = (select planning_cycle
       from fpa_aw_sces_v
       where scenario = p_scenario_id);

Line: 2735

         'Completed AW Updates for project_set_project_m'
         );

Line: 2970

                p_delete_project_id   => null,
                x_return_status       => x_return_status,
                x_msg_count           => x_msg_count,
                x_msg_data            => x_msg_data);

Line: 3012

        dbms_aw.execute('UPDATE');

Line: 3202

         'Completed AW Updates for project_set_project_m'
         );

Line: 3270

              p_type                  =>  'UPDATE',
              x_return_status         =>  x_return_status,
              x_msg_count             =>  x_msg_count,
              x_msg_data              =>  x_msg_data);

Line: 3289

        dbms_aw.execute('UPDATE');

Line: 3382

     select class_code from fpa_aw_projs_v where project = p_proj_id;

Line: 3456

                p_delete_project_id   => p_proj_id,
                x_return_status       => x_return_status,
                x_msg_count           => x_msg_count,
                x_msg_data            => x_msg_data);

Line: 3516

             'Completed all API calls. Issue UPDATE to AW'
             );

Line: 3522

                dbms_aw.execute('UPDATE');

Line: 3580

PROCEDURE update_strategicobj_weight
( p_api_version        IN NUMBER
 ,p_commit             IN VARCHAR2 := FND_API.G_FALSE
 ,p_strategic_weights_string    IN              varchar2
 ,x_return_status               OUT NOCOPY      varchar2
 ,x_msg_count                   OUT NOCOPY      number
 ,x_msg_data                    OUT NOCOPY      varchar2
)
AS
    investment_rec          fpa_investment_criteria_pvt.investment_rec_type;

Line: 3603

                'fpa.sql.fpa_process_pvt.update_strategicobj_weight',
                'Attaching OLAP workspace: '
            );

Line: 3620

    fpa_investment_criteria_pvt.update_strategicobj_weight_aw
    (
        p_investment_rec_type => investment_rec,
        x_return_status => x_return_status,
        x_msg_count => x_msg_count,
        x_msg_data => x_msg_data
    );

Line: 3640

        dbms_aw.execute('UPDATE');

Line: 3671

            'fpa.sql.FPA_Process_Pvt.Update_Pc',
            SQLERRM
        );

Line: 3687

PROCEDURE update_strategicobj
(   p_api_version        IN NUMBER,
    p_commit                        IN              VARCHAR2 := FND_API.G_FALSE,
    p_strategic_obj_id              IN              NUMBER,
    p_strategic_obj_name        IN      VARCHAR2,
    p_strategic_obj_desc        IN      VARCHAR2,
    x_return_status                 OUT NOCOPY      VARCHAR2,
    x_msg_count                     OUT NOCOPY      NUMBER,
    x_msg_data                      OUT NOCOPY      VARCHAR2
)
AS
    l_investment_rec            fpa_investment_criteria_pvt.investment_rec_type;

Line: 3724

  FPA_Investment_Criteria_PVT.update_strategicobj( p_commit => p_commit
                                                  ,p_investment_rec_type => l_investment_rec
                                                  ,x_return_status => x_return_status
                                                  ,x_msg_count => x_msg_count
                                                  ,x_msg_data => x_msg_data);

Line: 3732

    dbms_aw.execute('UPDATE');

Line: 3753

END update_strategicobj;

Line: 3819

        l_investment_rec.strategic_obj_status := 'DODELETE';

Line: 3821

        FPA_Investment_Criteria_PVT.Update_StrategicObj_Status_AW(
                p_commit => FND_API.G_TRUE,
                p_investment_rec_type => l_investment_rec,
                x_return_status => x_return_status,
                x_msg_count => x_msg_count,
                x_msg_data => x_msg_data
        );

Line: 3829

        FPA_Investment_Criteria_PVT.update_strategicobj_level_aw( p_commit
                                                                 ,l_investment_rec
                                                                 ,x_return_status
                                                                 ,x_msg_count
                                                                 ,x_msg_data);

Line: 3837

        dbms_aw.execute('UPDATE');

Line: 3871

PROCEDURE delete_strategicobj
(   p_api_version       IN      NUMBER,
    p_commit            IN      VARCHAR2 := FND_API.G_FALSE,
    p_strategic_obj_shortname   IN      VARCHAR2,
    x_return_status                 OUT NOCOPY      VARCHAR2,
    x_msg_count                     OUT NOCOPY      NUMBER,
    x_msg_data                      OUT NOCOPY      VARCHAR2
)
AS
    l_investment_rec            fpa_investment_criteria_pvt.investment_rec_type;

Line: 3891

                    'fpa.sql.fpa_process_pvt.delete_strategicobj',
                    'Attaching OLAP workspace: ');

Line: 3901

    fpa_investment_criteria_pvt.delete_strategicobj_aw
    (
        p_api_version => p_api_version,
        p_investment_rec_type => l_investment_rec,
        x_return_status => x_return_status,
        x_msg_count => x_msg_count,
        x_msg_data => x_msg_data
    );

Line: 3912

      dbms_aw.execute('UPDATE');

Line: 3940

            'fpa.sql.FPA_Process_Pvt.Update_Pc',
            SQLERRM
        );

Line: 3952

END delete_strategicobj;

Line: 4097

       'Calling fpa_scenario_pvt.update_scenario_disc_rate.'
    );

Line: 4101

  fpa_scenario_pvt.update_scenario_disc_rate
  (
    p_api_version => 1.0,
    p_scenario_id => x_scenario_id,
    p_discount_rate => p_sce_disc_rate,
    x_return_status => x_return_status,
    x_msg_count => x_msg_count,
    x_msg_data => x_msg_data
  );

Line: 4116

       'Calling fpa_scenario_pvt.update_scenario_funds_avail.'
    );

Line: 4120

  fpa_scenario_pvt.update_scenario_funds_avail
  (
    p_api_version => 1.0,
    p_scenario_id => x_scenario_id,
    p_scenario_funds => p_sce_funds_avail,
    x_return_status => x_return_status,
    x_msg_count => x_msg_count,
    x_msg_data => x_msg_data
  );

Line: 4215

          p_delete_project_id   => null,
          x_return_status       => x_return_status,
          x_msg_count           => x_msg_count,
          x_msg_data            => x_msg_data);

Line: 4269

    dbms_aw.execute('UPDATE');

Line: 4397

    fpa_scenario_pvt.update_scenario_reccom_flag
    (
      p_api_version => 1.0,
      p_scenario_id => p_scenario_id,
      p_scenario_reccom_status => l_scenario_reccom_status,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data => x_msg_data
    );

Line: 4416

    fpa_scenario_pvt.update_scen_approved_flag
    ( p_scenario_id   => p_scenario_id,
      p_approved_flag => l_approved_flag,
      x_return_status => x_return_status,
      x_msg_count     => x_msg_count,
      x_msg_data      => x_msg_data
    );

Line: 4434

    fpa_scenario_pvt.update_scenario_reccom_flag
    (
      p_api_version => 1.0,
      p_scenario_id => p_scenario_id,
      p_scenario_reccom_status => l_scenario_reccom_status,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data => x_msg_data
    );

Line: 4452

    fpa_scenario_pvt.update_scenario_working_flag
    (
       p_api_version => 1.0,
       p_scenario_id => p_scenario_id,
       x_return_status => x_return_status,
       x_msg_count => x_msg_count,
       x_msg_data => x_msg_data
    );

Line: 4473

    dbms_aw.execute('UPDATE');

Line: 4531

procedure update_scenario_reccom_status
(
  p_commit                        IN              VARCHAR2 := FND_API.G_FALSE,
  p_api_version                 IN              NUMBER,
  p_scenario_id                 IN              NUMBER,
  p_project_id                  IN              VARCHAR2,
  p_scenario_reccom_value       IN              VARCHAR2,
  x_return_status               OUT NOCOPY      VARCHAR2,
  x_msg_count                   OUT NOCOPY      NUMBER,
  x_msg_data                    OUT NOCOPY      VARCHAR2
) is

l_api_version               CONSTANT NUMBER := 1.0;

Line: 4555

       'fpa.sql.FPA_Process_Pvt.update_scenario_reccom_status.begin',
       'Entering FPA_Process_Pvt.update_scenario_reccom_status'
    );

Line: 4564

       'fpa.sql.FPA_Process_Pvt.update_scenario_reccom_status',
       'Attaching AW space.'
    );

Line: 4583

       'fpa.sql.FPA_Process_Pvt.update_scenario_reccom_status',
       'Calling procedure fpa_scenario_pvt.update_scenario_reccom_status.'
    );

Line: 4588

  fpa_scenario_pvt.update_scenario_reccom_status
  (
    p_api_version => 1.0,
    p_scenario_id => p_scenario_id,
    p_project_id => p_project_id,
    p_scenario_reccom_value => p_scenario_reccom_value,
    x_return_status => x_return_status,
    x_msg_count => x_msg_count,
    x_msg_data => x_msg_data
  );

Line: 4603

       'fpa.sql.FPA_Process_Pvt.update_scenario_reccom_status',
       'Calling procedure fpa_scenario_pvt.calc_scenario_data for Class Codes.'
    );

Line: 4624

       'fpa.sql.FPA_Process_Pvt.update_scenario_reccom_status',
       'Calling procedure fpa_scenario_pvt.calc_scenario_data for Scenario.'
    );

Line: 4645

       'fpa.sql.FPA_Process_Pvt.update_scenario_reccom_status',
       'Committing changes to database.'
    );

Line: 4652

    dbms_aw.execute('UPDATE');

Line: 4660

       'fpa.sql.FPA_Process_Pvt.update_scenario_reccom_status',
       'Detach AW space.'
    );

Line: 4698

      'fpa.sql.FPA_Process_Pvt.update_scenario_reccom_status',
      SQLERRM
    );

Line: 4708

END update_scenario_reccom_status;

Line: 4727

    SELECT 'T'
    FROM PA_PROJECTS_ALL
    WHERE PROJECT_ID = P_PROJECT_ID
          AND FUNDING_APPROVAL_STATUS_CODE IN
          ('FUNDING_PROPOSED','FUNDING_ONHOLD','FUNDING_APPROVED');

Line: 4916

        dbms_aw.execute('UPDATE');

Line: 5052

      dbms_aw.execute('UPDATE');

Line: 5123

 * Updates user ranks for all projects in the current scenario.
 */

PROCEDURE Update_Scen_Proj_User_Ranks
     ( p_api_version        IN NUMBER,
       p_commit             IN VARCHAR2 := FND_API.G_FALSE,
       p_projs              IN fpa_scen_proj_userrank_all_obj,
       x_return_status      OUT NOCOPY VARCHAR2,
       x_msg_data           OUT NOCOPY VARCHAR2,
       x_msg_count          OUT NOCOPY NUMBER )
IS
BEGIN

  -- clear all previous messages.
    FND_MSG_PUB.Initialize;

Line: 5143

            'fpa.sql.FPA_Process_Pvt.Update_Scen_Proj_User_Ranks.begin',
            'Entering FPA_Process_Pvt.Update_Scen_Proj_User_Ranks'
        );

Line: 5158

     FPA_Scenario_Pvt.Update_Proj_User_Ranks
               (
                p_api_version => 1.0,
                p_proj_metrics => p_projs.user_ranks,
                x_return_status  =>  x_return_status,
                x_msg_data   =>  x_msg_data,
                x_msg_count  =>  x_msg_count
              );

Line: 5169

         dbms_aw.execute('UPDATE');

Line: 5185

            'fpa.sql.FPA_Process_Pvt.Update_Scen_Proj_User_Ranks.end',
            'Exiting FPA_Process_Pvt.Update_Scen_Proj_User_Ranks'
        );

Line: 5194

        FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Update_Scen_Proj_User_Ranks');

Line: 5214

            'fpa.sql.FPA_Process_Pvt.Update_Scen_Proj_User_Ranks',
            SQLERRM
        );

Line: 5225

END Update_Scen_Proj_User_Ranks;

Line: 5229

PROCEDURE update_pjt_proj_funding_status
     (  p_api_version        IN NUMBER,
        p_init_msg_list      IN VARCHAR2,
        p_commit             IN VARCHAR2,
        p_scenario_id        IN NUMBER,
        x_return_status      OUT NOCOPY      VARCHAR2,
        x_msg_count          OUT NOCOPY      NUMBER,
        x_msg_data           OUT NOCOPY      VARCHAR2) IS

BEGIN

     IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
        FND_LOG.String
        (
            FND_LOG.LEVEL_PROCEDURE,
            'fpa.sql.FPA_Process_Pvt.update_pjt_proj_funding_status.Begin',
            'Exiting FPA_Process_Pvt.update_pjt_proj_funding_status'
        );

Line: 5251

     fpa_project_pvt.update_proj_funding_status
           (
                p_api_version => 1.0,
                p_init_msg_list => p_init_msg_list,
                p_commit => FND_API.G_FALSE,
                p_appr_scenario_id => p_scenario_id,
                x_return_status  =>  x_return_status,
                x_msg_count  =>  x_msg_count,
                x_msg_data   =>  x_msg_data
                );

Line: 5276

            'fpa.sql.FPA_Process_Pvt.update_pjt_proj_funding_status.end',
            'Exiting FPA_Process_Pvt.update_pjt_proj_funding_status'
        );

Line: 5293

                            p_procedure_name => 'UPDATE_PJT_PROJ_FUNDING_STATUS',
                            p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 5309

                            p_procedure_name => 'UPDATE_PJT_PROJ_FUNDING_STATUS',
                            p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 5314

END update_pjt_proj_funding_status;

Line: 5331

     select count(a.project) Validpc
       from fpa_aw_projs_v a,
       fpa_aw_pcs_v b,
       fpa_aw_pc_info_v c
       where a.portfolio = b.portfolio
       and b.planning_cycle = c.planning_cycle
       and c.pc_status in ('COLLECTING', 'ANALYSIS')
       and a.project = p_project_id;