eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASK_TYPE_PVT SQL Statements

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

Line: 68


  PA_TASK_TYPE_PKG.insert_row
          (p_task_type                     => p_task_type
          ,p_start_date_active             => p_start_date_active
          ,p_end_date_active               => p_end_date_active
          ,p_description                   => p_description
          ,p_task_type_class_code          => p_task_type_class_code
          ,p_initial_status_code           => p_initial_status_code
          ,p_prog_entry_enable_flag        => p_prog_entry_enable_flag
          ,p_prog_entry_req_flag           => p_prog_entry_req_flag
          ,p_initial_progress_status_code  => p_initial_progress_status_code
          ,p_task_prog_entry_page_id       => p_task_prog_entry_page_id
          ,p_task_prog_entry_page_name     => p_task_prog_entry_page_name --this parameter was missing ,Hence inserted
          ,p_wq_enable_flag                => p_wq_enable_flag
          ,p_work_item_code                => p_work_item_code
          ,p_uom_code                      => p_uom_code
          ,p_actual_wq_entry_code          => p_actual_wq_entry_code
          ,p_percent_comp_enable_flag      => p_percent_comp_enable_flag
          ,p_base_percent_comp_deriv_code  => p_base_percent_comp_deriv_code
          ,p_task_weighting_deriv_code     => p_task_weighting_deriv_code
          ,p_remain_effort_enable_flag     => p_remain_effort_enable_flag
          ,p_attribute_category     =>   p_attribute_category
          ,p_attribute1             =>   p_attribute1
          ,p_attribute2             =>   p_attribute2
          ,p_attribute3             =>   p_attribute3
          ,p_attribute4             =>   p_attribute4
          ,p_attribute5             =>   p_attribute5
          ,p_attribute6             =>   p_attribute6
          ,p_attribute7             =>   p_attribute7
          ,p_attribute8             =>   p_attribute8
          ,p_attribute9             =>   p_attribute9
          ,p_attribute10            =>   p_attribute10
          ,p_attribute11            =>   p_attribute11
          ,p_attribute12            =>   p_attribute12
          ,p_attribute13            =>   p_attribute13
          ,p_attribute14            =>   p_attribute14
          ,p_attribute15            =>   p_attribute15
          ,p_object_type            =>   p_object_type              -- 3279978 : Added Object Type and Progress Rollup Method
          ,p_wf_item_type           =>   p_wf_item_type
          ,p_wf_process             =>   p_wf_process
          ,p_wf_lead_days           =>   p_wf_lead_days
          ,x_task_type_id           =>   x_task_type_id
          ,x_return_status          =>   x_return_status
          ,x_msg_count              =>   x_msg_count
          ,x_msg_data               =>   x_msg_data);

Line: 125


PROCEDURE Update_Task_Type
( p_task_type_id                  IN    pa_task_types.task_type_id%TYPE
 ,p_task_type                     IN    pa_task_types.task_type%TYPE
 ,p_start_date_active             IN    pa_task_types.start_date_active%TYPE
 ,p_end_date_active               IN    pa_task_types.end_date_active%TYPE          := NULL
 ,p_description                   IN    pa_task_types.description%TYPE              := NULL
 ,p_task_type_class_code          IN    pa_task_types.task_type_class_code%TYPE
 ,p_initial_status_code           IN    pa_task_types.initial_status_code%TYPE      := NULL
 ,p_prog_entry_enable_flag        IN    pa_task_types.prog_entry_enable_flag%TYPE   := NULL
 ,p_prog_entry_req_flag           IN    pa_task_types.prog_entry_req_flag%TYPE      := NULL
 ,p_initial_progress_status_code  IN    pa_task_types.initial_progress_status_code%TYPE  := NULL
 ,p_task_prog_entry_page_id       IN    pa_task_types.task_progress_entry_page_id%TYPE   := NULL
 ,p_task_prog_entry_page_name     IN    pa_page_layouts.page_name%TYPE              := NULL
 ,p_wq_enable_flag                IN    pa_task_types.wq_enable_flag%TYPE           := NULL
 ,p_work_item_code                IN    pa_task_types.work_item_code%TYPE           := NULL
 ,p_uom_code                      IN    pa_task_types.uom_code%TYPE                 := NULL
 ,p_actual_wq_entry_code          IN    pa_task_types.actual_wq_entry_code%TYPE     := NULL
 ,p_percent_comp_enable_flag      IN    pa_task_types.percent_comp_enable_flag%TYPE := NULL
 ,p_base_percent_comp_deriv_code  IN    pa_task_types.base_percent_comp_deriv_code%TYPE  := NULL
 ,p_task_weighting_deriv_code     IN    pa_task_types.task_weighting_deriv_code%TYPE     := NULL
 ,p_remain_effort_enable_flag     IN    pa_task_types.remain_effort_enable_flag%TYPE     := NULL
 ,p_attribute_category     IN    pa_task_types.attribute_category%TYPE       := NULL
 ,p_attribute1             IN    pa_task_types.attribute1%TYPE               := NULL
 ,p_attribute2             IN    pa_task_types.attribute2%TYPE               := NULL
 ,p_attribute3             IN    pa_task_types.attribute3%TYPE               := NULL
 ,p_attribute4             IN    pa_task_types.attribute4%TYPE               := NULL
 ,p_attribute5             IN    pa_task_types.attribute5%TYPE               := NULL
 ,p_attribute6             IN    pa_task_types.attribute6%TYPE               := NULL
 ,p_attribute7             IN    pa_task_types.attribute7%TYPE               := NULL
 ,p_attribute8             IN    pa_task_types.attribute8%TYPE               := NULL
 ,p_attribute9             IN    pa_task_types.attribute9%TYPE               := NULL
 ,p_attribute10            IN    pa_task_types.attribute10%TYPE              := NULL
 ,p_attribute11            IN    pa_task_types.attribute11%TYPE              := NULL
 ,p_attribute12            IN    pa_task_types.attribute12%TYPE              := NULL
 ,p_attribute13            IN    pa_task_types.attribute13%TYPE              := NULL
 ,p_attribute14            IN    pa_task_types.attribute14%TYPE              := NULL
 ,p_attribute15            IN    pa_task_types.attribute15%TYPE              := NULL
 ,p_object_type            IN    pa_task_types.object_type%TYPE              := 'PA_TASKS'    -- 3279978 : Added Object Type and Progress Rollup Method
 ,p_wf_item_type           IN    pa_task_types.wf_item_type%TYPE           :=NULL
 ,p_wf_process             IN    pa_task_types.wf_process%TYPE             :=NULL
 ,p_wf_lead_days           IN    pa_task_types.wf_start_lead_days%TYPE     :=NULL
 ,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

 l_msg_index_out          NUMBER;

Line: 181


  PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_TASK_TYPES_PVT.Update_Task_Type.begin'
                     ,x_msg         => 'Beginning of Update_Task_Type pvt'
                     ,x_log_level   => 5);

Line: 186


  PA_TASK_TYPE_PKG.update_row
          (p_task_type_id                  => p_task_type_id
          ,p_task_type                     => p_task_type
          ,p_start_date_active             => p_start_date_active
          ,p_end_date_active               => p_end_date_active
          ,p_description                   => p_description
          ,p_task_type_class_code          => p_task_type_class_code
          ,p_initial_status_code           => p_initial_status_code
          ,p_prog_entry_enable_flag        => p_prog_entry_enable_flag
          ,p_prog_entry_req_flag           => p_prog_entry_req_flag
          ,p_initial_progress_status_code  => p_initial_progress_status_code
          ,p_task_prog_entry_page_id       => p_task_prog_entry_page_id
          ,p_wq_enable_flag                => p_wq_enable_flag
          ,p_work_item_code                => p_work_item_code
          ,p_uom_code                      => p_uom_code
          ,p_actual_wq_entry_code          => p_actual_wq_entry_code
          ,p_percent_comp_enable_flag      => p_percent_comp_enable_flag
          ,p_base_percent_comp_deriv_code  => p_base_percent_comp_deriv_code
          ,p_task_weighting_deriv_code     => p_task_weighting_deriv_code
          ,p_remain_effort_enable_flag     => p_remain_effort_enable_flag
          ,p_attribute_category     =>   p_attribute_category
          ,p_attribute1             =>   p_attribute1
          ,p_attribute2             =>   p_attribute2
          ,p_attribute3             =>   p_attribute3
          ,p_attribute4             =>   p_attribute4
          ,p_attribute5             =>   p_attribute5
          ,p_attribute6             =>   p_attribute6
          ,p_attribute7             =>   p_attribute7
          ,p_attribute8             =>   p_attribute8
          ,p_attribute9             =>   p_attribute9
          ,p_attribute10            =>   p_attribute10
          ,p_attribute11            =>   p_attribute11
          ,p_attribute12            =>   p_attribute12
          ,p_attribute13            =>   p_attribute13
          ,p_attribute14            =>   p_attribute14
          ,p_attribute15            =>   p_attribute15
          ,p_object_type            =>   p_object_type          -- 3279978 : Added Object Type and Progress Rollup Method
          ,p_wf_item_type           =>   p_wf_item_type
          ,p_wf_process             =>   p_wf_process
          ,p_wf_lead_days           =>   p_wf_lead_days
          ,x_return_status          =>   x_return_status
          ,x_msg_count              =>   x_msg_count
          ,x_msg_data               =>   x_msg_data);

Line: 234


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPE_PVT.Update_Task_Type'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 240


END Update_Task_Type;

Line: 243


PROCEDURE Delete_Task_Type
 (p_Task_Type_id           IN    pa_task_types.Task_Type_id%TYPE           := NULL
 ,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

 l_msg_index_out          NUMBER;

Line: 259


  PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_task_types_PVT.Delete_Task_Type.begin'
                     ,x_msg         => 'Beginning of Delete_Task_Type pvt'
                     ,x_log_level   => 5);

Line: 264


  PA_TASK_TYPE_PKG.delete_row
          (p_task_type_id           =>   p_task_type_id
          ,x_return_status          =>   x_return_status
          ,x_msg_count              =>   x_msg_count
          ,x_msg_data               =>   x_msg_data);

Line: 274


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPE_PVT.Delete_Task_Type'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 279


 END Delete_Task_Type;

Line: 421


     PA_DEBUG.WRITE(g_module_name,'Before Insert',
                                   l_debug_level3);

Line: 424


     PA_TASK_TYPE_PKG.insert_row
     (p_task_type_id               => p_deliverable_type_id
     ,p_task_type                  => p_deliverable_type_name
     ,p_start_date_active          => p_effective_from
     ,p_end_date_active            => p_effective_to
     ,p_description                => p_description
     ,p_task_type_class_code       => p_deliverable_type_class
     ,p_initial_status_code        => p_initial_deliverable_status
     ,p_prog_entry_enable_flag     => p_prog_entry_enable_flag
     ,p_enable_dlvr_actions_flag   => p_enable_dlvr_actions_flag
     ,p_object_type                => 'PA_DLVR_TYPES'
     ,p_record_version_number      => p_record_version_number
     ,x_task_type_id               => l_task_type_id_dummy
     ,x_return_status              => x_return_status
     ,x_msg_count                  => x_msg_count
     ,x_msg_data                   => x_msg_data
     );

Line: 442


      PA_DEBUG.WRITE(g_module_name,'After Insert',
                                     l_debug_level3);

Line: 560


 PROCEDURE UPDATE_DELIVERABLE_TYPE
 (p_api_version                     IN   NUMBER                                      := 1.0
 ,p_init_msg_list                   IN   VARCHAR2                                    := FND_API.G_TRUE
 ,p_commit                          IN   VARCHAR2                                    := FND_API.G_FALSE
 ,p_validate_only                   IN   VARCHAR2                                    := FND_API.G_TRUE
 ,p_validation_level                IN   NUMBER                                      := FND_API.G_VALID_LEVEL_FULL
 ,p_calling_module                  IN   VARCHAR2                                    := 'SELF_SERVICE'
 ,p_debug_mode                      IN   VARCHAR2                                    := 'N'
 ,p_max_msg_count                   IN   NUMBER                                      := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
 ,p_deliverable_type_name           IN   PA_TASK_TYPES.TASK_TYPE%TYPE
 ,p_prog_entry_enable_flag          IN   PA_TASK_TYPES.PROG_ENTRY_ENABLE_FLAG%TYPE   := 'N'
 ,p_initial_deliverable_status      IN   PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE      := 'DLVR_NOT_STARTED'
 ,p_deliverable_type_class          IN   PA_TASK_TYPES.TASK_TYPE_CLASS_CODE%TYPE     := 'ITEM'
 ,p_enable_dlvr_actions_flag        IN   PA_TASK_TYPES.ENABLE_DLVR_ACTIONS_FLAG%TYPE := 'N'
 ,p_effective_from                  IN   PA_TASK_TYPES.START_DATE_ACTIVE%TYPE
 ,p_effective_to                    IN   PA_TASK_TYPES. END_DATE_ACTIVE %TYPE        := NULL
 ,p_description                     IN   PA_TASK_TYPES.DESCRIPTION%TYPE              := NULL
 ,p_deliverable_type_id             IN   PA_TASK_TYPES.TASK_TYPE_ID%TYPE
 ,p_record_version_number           IN   PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
 ,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
 l_msg_index_out                   NUMBER;

Line: 603


 SELECT 'X'
 FROM dual
 WHERE EXISTS
             (SELECT proj_element_id
             FROM pa_proj_elements
             WHERE TYPE_ID=p_deliverable_type_id
             AND OBJECT_TYPE='PA_DELIVERABLES'
             AND 'Y' = (pa_deliverable_utils.IS_DELIVERABLE_HAS_PROGRESS(PROJECT_ID,PROJ_ELEMENT_ID)));

Line: 615


 SELECT TASK_TYPE
      ,START_DATE_ACTIVE
	 ,END_DATE_ACTIVE
	 ,INITIAL_STATUS_CODE
	 ,TASK_TYPE_CLASS_CODE
	 ,ENABLE_DLVR_ACTIONS_FLAG
	 ,PROG_ENTRY_ENABLE_FLAG
 FROM   PA_TASK_TYPES
 WHERE TASK_TYPE_ID = p_deliverable_type_id
 AND   OBJECT_TYPE = 'PA_DLVR_TYPES';

Line: 637


          PA_DEBUG.set_curr_function( p_function   => 'UPDATE_DELIVERABLE_TYPE',
                                      p_debug_mode => l_debug_mode );

Line: 643


          PA_DEBUG.g_err_stage:= 'PA_TASK_TYPES_PVT.UPDATE_DELIVERABLE_TYPE : Printing Input parameters';

Line: 678


          savepoint UPDATE_DELIVERABLE_TYPE;

Line: 681


     PA_DEBUG.WRITE(g_module_name,'After issuing save point in UPDATE_DLV_TYPE :PA_TASK_TYPES_PVT',
                                                                                    l_debug_level3);

Line: 699


               Pa_Debug.g_err_stage:= 'PA_TASK_TYPES_PVT : UPDATE_DELIVERABLE_TYPE : The DeliverableTypeID/NAME/Startdate/RecVersionNumber is null';

Line: 809


               UPDATE PA_PROJ_ELEMENTS SET PROGRESS_WEIGHT = NULL
               WHERE type_id = p_deliverable_type_id
               AND OBJECT_TYPE = 'PA_DELIVERABLES'
               AND PROGRESS_WEIGHT IS NOT NULL ;

Line: 840


               PA_ACTIONS_PUB.DELETE_DLV_ACTIONS_IN_BULK
               (p_api_version      => p_api_version
               ,p_init_msg_list    => FND_API.G_FALSE
               ,p_commit           => p_commit
               ,p_validate_only    => p_validate_only
               ,p_validation_level => p_validation_level
               ,p_calling_module   => p_calling_module
               ,p_debug_mode       => l_debug_mode
               ,p_max_msg_count    => p_max_msg_count
               ,p_object_id        => p_deliverable_type_id
               ,p_object_type      => 'PA_DLVR_TYPES'
               ,x_return_status    => x_return_status
               ,x_msg_data         => x_msg_data
               ,x_msg_count        => x_msg_count);

Line: 869


     PA_TASK_TYPE_PKG.update_row
     (p_task_type_id               => p_deliverable_type_id
     ,p_task_type                  => p_deliverable_type_name
     ,p_start_date_active          => p_effective_from
     ,p_end_date_active            => p_effective_to
     ,p_description                => p_description
     ,p_task_type_class_code       => p_deliverable_type_class
     ,p_initial_status_code        => p_initial_deliverable_status
     ,p_prog_entry_enable_flag     => p_prog_entry_enable_flag
     ,p_enable_dlvr_actions_flag   => p_enable_dlvr_actions_flag
     ,p_object_type                => 'PA_DLVR_TYPES'
     ,p_record_version_number      => p_record_version_number
     ,x_return_status              => x_return_status
     ,x_msg_count                  => x_msg_count
     ,x_msg_data                   => x_msg_data
     );

Line: 898


               ROLLBACK TO UPDATE_DELIVERABLE_TYPE;

Line: 934


          x_msg_data      := 'PA_TASK_TYPE_PVT : UPDATE_DELIVERABLE_TYPE : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';

Line: 938


               ROLLBACK TO UPDATE_DELIVERABLE_TYPE;

Line: 953


          , p_procedure_name  => 'UPDATE_DELIVERABLE_TYPE'
          , p_error_text      => x_msg_data);

Line: 973


               ROLLBACK TO UPDATE_DELIVERABLE_TYPE;

Line: 988


          , p_procedure_name  => 'UPDATE_DELIVERABLE_TYPE'
          , p_error_text      => x_msg_data);

Line: 1000


 END UPDATE_DELIVERABLE_TYPE;

Line: 1015


 PROCEDURE DELETE_DELIVERABLE_TYPE
 (p_api_version                     IN       NUMBER                                      := 1.0
 ,p_init_msg_list                   IN       VARCHAR2                                    := FND_API.G_TRUE
 ,p_commit                          IN       VARCHAR2                                    := FND_API.G_FALSE
 ,p_validate_only                   IN       VARCHAR2                                    := FND_API.G_TRUE
 ,p_validation_level                IN       NUMBER                                      := FND_API.G_VALID_LEVEL_FULL
 ,p_calling_module                  IN       VARCHAR2                                    := 'SELF_SERVICE'
 ,p_debug_mode                      IN       VARCHAR2                                    := 'N'
 ,p_max_msg_count                   IN       NUMBER                                      := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
 ,p_deliverable_type_id             IN       pa_task_types.Task_Type_id%TYPE
 ,p_record_version_number           IN       PA_TASK_TYPES.RECORD_VERSION_NUMBER%TYPE
 ,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
 l_msg_index_out                    NUMBER;

Line: 1052


          PA_DEBUG.set_curr_function( p_function   => 'DELETE_DELIVERABLE_TYPE',
                                      p_debug_mode => l_debug_mode );

Line: 1058


          savepoint DELETE_DELIVERABLE_TYPE;

Line: 1063


          PA_DEBUG.g_err_stage:= 'PA_TASK_TYPE_PVT.DELETE_DELIVERABLE_TYPE : Printing Input parameters';

Line: 1080


          PA_DEBUG.g_err_stage:= 'BEFORE CALLING PA_ACTIONS_PUB.DELETE_DLV_ACTIONS';

Line: 1085


     PA_ACTIONS_PUB.DELETE_DLV_ACTIONS_IN_BULK
     (p_api_version      => p_api_version
     ,p_init_msg_list    => FND_API.G_FALSE
     ,p_commit           => p_commit
     ,p_validate_only    => p_validate_only
     ,p_validation_level => p_validation_level
     ,p_calling_module   => p_calling_module
     ,p_debug_mode       => l_debug_mode
     ,p_max_msg_count    => p_max_msg_count
     ,p_object_id        => p_deliverable_type_id
     ,p_object_type      => 'PA_DLVR_TYPES'
     ,x_return_status    => x_return_status
     ,x_msg_data         => x_msg_data
     ,x_msg_count        => x_msg_count);

Line: 1102


          PA_DEBUG.g_err_stage:= 'AFTER RETURNING FROM PA_ACTIONS_PUB.DELETE_DLV_ACTIONS';

Line: 1113


     PA_TASK_TYPE_PKG.delete_row
     (p_task_type_id  => p_deliverable_type_id
     ,p_record_version_number => p_record_version_number
     ,x_return_status => x_return_status
     ,x_msg_data     => x_msg_data
     ,x_msg_count     => x_msg_count);

Line: 1132


               ROLLBACK TO DELETE_DELIVERABLE_TYPE;

Line: 1163


               ROLLBACK TO DELETE_DELIVERABLE_TYPE;

Line: 1168


          , p_procedure_name  => 'DELETE_DELIVERABLE_TYPE'
          , p_error_text      => x_msg_data);

Line: 1179


 END DELETE_DELIVERABLE_TYPE;