APPS.PA_PROJ_OPP_ATTRS_PKG SQL Statements

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

Line: 9

PROCEDURE insert_row
      ( p_project_id                       IN NUMBER,
        p_opportunity_value                IN NUMBER,
        p_opp_value_currency_code          IN VARCHAR2,
        p_projfunc_opp_value               IN NUMBER,
        p_projfunc_opp_rate_type           IN VARCHAR2,
        p_projfunc_opp_rate_date           IN DATE,
        p_project_opp_value               IN NUMBER,
        p_project_opp_rate_type           IN VARCHAR2,
        p_project_opp_rate_date           IN DATE,
        x_return_status              OUT  NOCOPY VARCHAR2                          , --File.Sql.39 bug 4440895
        x_msg_count                  OUT  NOCOPY NUMBER                            , --File.Sql.39 bug 4440895
        x_msg_data                   OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS

BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 27

  INSERT INTO pa_project_opp_attrs
  (    project_id               ,
       opportunity_value        ,
       opp_value_currency_code  ,
       projfunc_opp_value       ,
       projfunc_opp_rate_type   ,
       projfunc_opp_rate_date   ,
       project_opp_value        ,
       project_opp_rate_type    ,
       project_opp_rate_date    ,
       creation_date            ,
       created_by               ,
       last_update_date         ,
       last_updated_by          ,
       last_update_login       )
  VALUES
  (    p_project_id               ,
       p_opportunity_value        ,
       p_opp_value_currency_code  ,
       p_projfunc_opp_value       ,
       p_projfunc_opp_rate_type   ,
       p_projfunc_opp_rate_date   ,
       p_project_opp_value        ,
       p_project_opp_rate_type    ,
       p_project_opp_rate_date    ,
       sysdate                      ,
       fnd_global.user_id           ,
       sysdate                      ,
       fnd_global.user_id           ,
       fnd_global.login_id          );

Line: 62

                          p_procedure_name   => 'insert_row');

Line: 65

END insert_row;

Line: 73

PROCEDURE delete_row
	    ( p_project_id                 IN NUMBER                        ,
        x_return_status              OUT  NOCOPY VARCHAR2                          , --File.Sql.39 bug 4440895
        x_msg_count                  OUT  NOCOPY NUMBER                            , --File.Sql.39 bug 4440895
        x_msg_data                   OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS

BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 83

  DELETE FROM pa_project_opp_attrs
  WHERE project_id = p_project_id;

Line: 90

                          p_procedure_name   => 'delete_row');

Line: 93

END delete_row;

Line: 101

PROCEDURE update_row
	    ( p_project_id                 IN NUMBER                        ,
        p_opportunity_value          IN NUMBER,
        p_opp_value_currency_code    IN VARCHAR2,
        p_projfunc_opp_value         IN NUMBER,
        p_projfunc_opp_rate_type     IN VARCHAR2,
        p_projfunc_opp_rate_date     IN DATE,
        p_project_opp_value          IN NUMBER,
        p_project_opp_rate_type      IN VARCHAR2,
        p_project_opp_rate_date      IN DATE,
        x_return_status              OUT  NOCOPY VARCHAR2                    , --File.Sql.39 bug 4440895
        x_msg_count                  OUT  NOCOPY NUMBER                      , --File.Sql.39 bug 4440895
        x_msg_data                   OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS

BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 119

  UPDATE pa_project_opp_attrs
    SET
        opportunity_value          =  p_opportunity_value,
        opp_value_currency_code    =  p_opp_value_currency_code,
        projfunc_opp_value         =  p_projfunc_opp_value,
        projfunc_opp_rate_type     =  p_projfunc_opp_rate_type,
        projfunc_opp_rate_date     =  p_projfunc_opp_rate_date,
        project_opp_value          =  p_project_opp_value,
        project_opp_rate_type      =  p_project_opp_rate_type,
        project_opp_rate_date      =  p_project_opp_rate_date
    WHERE
        project_id = p_project_id;

Line: 133

  UPDATE PA_PROJECTS_ALL
   SET project_value = p_projfunc_opp_value
   WHERE project_id = p_project_id;

Line: 141

                          p_procedure_name   => 'update_row');

Line: 144

END update_row;