APPS.PA_FP_EXCLUDED_ELEMENTS_PKG SQL Statements

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

Line: 7

PROCEDURE Insert_Row
(
 p_proj_fp_options_id           IN pa_fp_excluded_elements.proj_fp_options_id%TYPE
,p_project_id                   IN pa_fp_excluded_elements.project_id%TYPE
,p_fin_plan_type_id             IN pa_fp_excluded_elements.fin_plan_type_id%TYPE
,p_element_type                 IN pa_fp_excluded_elements.element_type%TYPE
,p_fin_plan_version_id          IN pa_fp_excluded_elements.fin_plan_version_id%TYPE
,p_task_id                      IN pa_fp_excluded_elements.task_id%TYPE
,x_row_id                       OUT NOCOPY ROWID --File.Sql.39 bug 4440895
,x_return_status                OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
 IS
BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 21

   INSERT INTO pa_fp_excluded_elements(
    proj_fp_options_id
   ,project_id
   ,fin_plan_type_id
   ,element_type
   ,fin_plan_version_id
   ,task_id
   ,record_version_number
   ,last_update_date
   ,last_updated_by
   ,creation_date
   ,created_by
   ,last_update_login
    ) VALUES (
    p_proj_fp_options_id
   ,p_project_id
   ,p_fin_plan_type_id
   ,p_element_type
   ,p_fin_plan_version_id
   ,p_task_id
   ,1
   ,sysdate
   ,fnd_global.user_id
   ,sysdate
   ,fnd_global.user_id
   ,fnd_global.login_id)
   RETURNING rowid INTO x_row_id;

Line: 54

                                => 'Insert_Row');

Line: 57

END Insert_Row;

Line: 59

PROCEDURE Update_Row
(
 p_proj_fp_options_id           IN pa_fp_excluded_elements.proj_fp_options_id%TYPE
,p_project_id                   IN pa_fp_excluded_elements.project_id%TYPE
,p_fin_plan_type_id             IN pa_fp_excluded_elements.fin_plan_type_id%TYPE
,p_element_type                 IN pa_fp_excluded_elements.element_type%TYPE
,p_fin_plan_version_id          IN pa_fp_excluded_elements.fin_plan_version_id%TYPE
,p_task_id                      IN pa_fp_excluded_elements.task_id%TYPE
,p_record_version_number        IN pa_fp_excluded_elements.record_version_number%TYPE
,p_row_id                       IN ROWID
,x_return_status                OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
 IS
BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 74

   UPDATE pa_fp_excluded_elements
   SET    proj_fp_options_id  = DECODE(p_proj_fp_options_id,
                                        FND_API.G_MISS_NUM, Null,
                                        nvl(p_proj_fp_options_id,proj_fp_options_id))
   ,project_id                = DECODE(p_project_id,
                                        FND_API.G_MISS_NUM, Null,
                                        nvl(p_project_id, project_id))
   ,fin_plan_type_id          = DECODE(p_fin_plan_type_id,
                                        FND_API.G_MISS_NUM, Null,
                                        nvl(p_fin_plan_type_id,fin_plan_type_id))
   ,element_type              = DECODE(p_element_type,
                                        FND_API.G_MISS_CHAR,Null,
                                        nvl(p_element_type,element_type))
   ,fin_plan_version_id       = DECODE(p_fin_plan_version_id,
                                        FND_API.G_MISS_NUM, Null,
                                        nvl(p_fin_plan_version_id, fin_plan_version_id))
   ,task_id                   = DECODE(p_task_id,
                                        FND_API.G_MISS_NUM, Null,
                                        nvl(p_task_id,task_id))
   ,record_version_number     = DECODE(p_record_version_number,
                                        FND_API.G_MISS_NUM, Null,
                                        nvl(p_record_version_number,nvl(record_version_number,0)) + 1)
   ,last_update_date          = SYSDATE
   ,last_updated_by           = FND_GLOBAL.USER_ID
   ,last_update_login         = FND_GLOBAL.LOGIN_ID
   WHERE rowid = p_row_id
   AND   nvl(record_version_number,0) = nvl(p_record_version_number, nvl(record_version_number,0));

Line: 113

                                => 'Update_Row');

Line: 116

END Update_Row;

Line: 118

PROCEDURE Delete_Row
( p_proj_fp_options_id          IN pa_fp_excluded_elements.proj_fp_options_id%TYPE    := Null
 ,p_element_type                IN pa_fp_excluded_elements.element_type%TYPE          := Null
 ,p_task_id                     IN pa_fp_excluded_elements.task_id%TYPE               := Null
 ,p_row_id                      IN ROWID
 ,p_record_version_number       IN NUMBER                                             := Null
 ,x_return_status               OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
IS
BEGIN
    x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 131

         DELETE FROM pa_fp_excluded_elements
         WHERE  rowid = p_row_id
         AND    nvl(record_version_number,0) = nvl(p_record_version_number, nvl(record_version_number,0));

Line: 137

         DELETE FROM pa_fp_excluded_elements
         WHERE  proj_fp_options_id = p_proj_fp_options_id
         AND    element_type       = p_element_type
         AND    task_id            = p_task_id
         AND    nvl(record_version_number,0) = nvl(p_record_version_number, nvl(record_version_number,0));

Line: 156

                                    => 'Delete_Row');

Line: 159

END Delete_Row;

Line: 170

       SELECT  rowid
       INTO    l_row_id
       FROM    pa_fp_excluded_elements
       WHERE   rowid = p_row_id
       AND     nvl(record_version_number,0) = nvl(p_record_version_number, nvl(record_version_number,0))
       FOR     UPDATE NOWAIT;