APPS.FPA_PROCESS_RST_PVT SQL Statements

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

Line: 9

PROCEDURE Update_Calc_Pjt_Scorecard_Aw
(
    p_api_version           IN              NUMBER,
    p_init_msg_list         IN              VARCHAR2 DEFAULT FND_API.G_FALSE,
    p_commit                IN              VARCHAR2 := FND_API.G_FALSE,
    p_planning_cycle_id     IN              NUMBER,
    p_project_id            IN              NUMBER,
    p_scorecard_tbl         IN              FPA_SCORECARDS_PVT.FPA_SCORECARD_TBL_TYPE,
    x_return_status         OUT NOCOPY      VARCHAR2,
    x_msg_count             OUT NOCOPY      NUMBER,
    x_msg_data              OUT NOCOPY      VARCHAR2
) IS

  l_return_status          VARCHAR2(1);

Line: 23

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

Line: 41

              p_msg_log       => 'Entering Fpa_Process_Pvt.Update_Calc_Pjt_Scorecard_Aw',
              x_return_status => x_return_status);

Line: 64

      FPA_SCORECARDS_PVT.Update_Calc_Pjt_Scorecard_Aw
                        (p_api_version        => p_api_version,
                         p_init_msg_list      => p_init_msg_list,
                         p_commit             => p_commit,
                         p_planning_cycle_id  => p_planning_cycle_id,
                         p_project_id         => p_project_id,
                         p_scorecard_tbl      => p_scorecard_tbl,
                         x_return_status      => x_return_status,
                         x_msg_count          => x_msg_count,
                         x_msg_data           => x_msg_data);

Line: 77

         dbms_aw.execute('UPDATE');

Line: 148

END Update_Calc_Pjt_Scorecard_Aw;

Line: 150

PROCEDURE Update_Calc_Scen_Scorecard_Aw
(
    p_api_version           IN              NUMBER,
    p_init_msg_list         IN              VARCHAR2 DEFAULT FND_API.G_FALSE,
    p_commit                IN              VARCHAR2 := FND_API.G_FALSE,
    p_planning_cycle_id     IN              NUMBER,
    p_scenario_id           IN              NUMBER,
    p_project_id            IN              NUMBER,
    p_scorecard_tbl         IN              FPA_SCORECARDS_PVT.FPA_SCORECARD_TBL_TYPE,
    x_return_status         OUT NOCOPY      VARCHAR2,
    x_msg_count             OUT NOCOPY      NUMBER,
    x_msg_data              OUT NOCOPY      VARCHAR2
) IS

  l_return_status          VARCHAR2(1);

Line: 165

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

Line: 182

              p_msg_log       => 'Entering Fpa_Process_Pvt.Update_Calc_Scen',
              x_return_status => x_return_status);

Line: 206

      FPA_SCORECARDS_PVT.Update_Calc_Scen_Scorecard_Aw
                        (p_api_version        => p_api_version,
                         p_init_msg_list      => p_init_msg_list,
                         p_commit             => p_commit,
                         p_planning_cycle_id  => p_planning_cycle_id,
                         p_scenario_id        => p_scenario_id,
                         p_project_id         => p_project_id,
                         p_scorecard_tbl      => p_scorecard_tbl,
                         x_return_status      => x_return_status,
                         x_msg_count          => x_msg_count,
                         x_msg_data           => x_msg_data);

Line: 220

         dbms_aw.execute('UPDATE');

Line: 292

END Update_Calc_Scen_Scorecard_Aw;