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.

[Home] [Help]

APPS.PA_WORKPLAN_ATTR_PUB SQL Statements

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

Line: 311


PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
(
   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     := FND_API.G_MISS_NUM
  ,p_project_id                    IN NUMBER     := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
  ,p_proj_element_id               IN NUMBER     := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
  ,p_approval_reqd_flag            IN VARCHAR2   := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
  ,p_auto_publish_flag             IN VARCHAR2   := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
  ,p_approver_source_id            IN NUMBER     := FND_API.G_MISS_NUM
  ,p_approver_source_type          IN NUMBER     := FND_API.G_MISS_NUM
  ,p_approver_name                 IN VARCHAR2   := FND_API.G_MISS_CHAR
  ,p_default_display_lvl           IN NUMBER     := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
  ,p_enable_wp_version_flag        IN VARCHAR2   := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
  ,p_lifecycle_id                  IN NUMBER     := FND_API.G_MISS_NUM
  ,p_lifecycle_name                IN VARCHAR2   := FND_API.G_MISS_CHAR
  ,p_current_lifecycle_phase_id    IN NUMBER     := FND_API.G_MISS_NUM
  ,p_current_lifecycle_phase       IN VARCHAR2   := FND_API.G_MISS_CHAR
  ,p_auto_pub_upon_creation_flag   IN VARCHAR2   := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
  ,p_auto_sync_txn_date_flag       IN VARCHAR2   := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
  ,p_txn_date_sync_buf_days        IN NUMBER     := FND_API.G_MISS_NUM
  ,p_record_version_number         IN NUMBER     := FND_API.G_MISS_NUM
--bug 3325803: FP M
  ,p_allow_lowest_tsk_dep_flag     IN VARCHAR2   := FND_API.G_MISS_CHAR
  ,p_schedule_third_party_flag     IN VARCHAR2   := FND_API.G_MISS_CHAR
  ,p_third_party_schedule_code     IN VARCHAR2   := FND_API.G_MISS_CHAR
  ,p_auto_rollup_subproj_flag      IN VARCHAR2   := FND_API.G_MISS_CHAR
--bug 3325803: FP M
--FP M: Workflow attributes
  -- gboomina Bug 8586393 - start
  ,p_use_task_schedule_flag        IN  VARCHAR2  := FND_API.G_MISS_CHAR
  -- gboomina Bug 8586393 - end
  ,p_enable_wf_flag                IN  VARCHAR2  := 'N'
  ,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_api_name                      CONSTANT VARCHAR(30) := 'Update_Proj_Workplan_Attrs';

Line: 373


   SELECT NVL(template_flag,'N')
     FROM pa_projects_all
    WHERE project_id = p_project_id;

Line: 380


   pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Update_Proj_Workplan_Attrs');

Line: 383


      pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Proj_Workplan_Attrs BEGIN');

Line: 387


      savepoint update_proj_workplan_attrs;

Line: 511


   PA_WORKPLAN_ATTR_PVT.UPDATE_PROJ_WORKPLAN_ATTRS
   ( p_commit                    => FND_API.G_FALSE
    ,p_validate_only             => p_validate_only
    ,p_validation_level          => p_validation_level
    ,p_calling_module            => p_calling_module
    ,p_debug_mode                => p_debug_mode
    ,p_max_msg_count             => p_max_msg_count
    ,p_project_id                => p_project_id
    ,p_proj_element_id           => p_proj_element_id
    ,p_approval_reqd_flag        => p_approval_reqd_flag
    ,p_auto_publish_flag         => p_auto_publish_flag
    ,p_approver_source_id        => l_approver_source_id
    ,p_approver_source_type      => l_approver_source_type
    ,p_default_display_lvl       => p_default_display_lvl
    ,p_enable_wp_version_flag    => p_enable_wp_version_flag
    ,p_auto_pub_upon_creation_flag => p_auto_pub_upon_creation_flag
    ,p_auto_sync_txn_date_flag   => p_auto_sync_txn_date_flag
    ,p_txn_date_sync_buf_days    => p_txn_date_sync_buf_days
    ,p_lifecycle_version_id    	 => l_lifecycle_id
    ,p_current_phase_version_id  => l_current_lifecycle_phase_id
--bug 3325803: FP M
    ,p_allow_lowest_tsk_dep_flag => p_allow_lowest_tsk_dep_flag
    ,p_schedule_third_party_flag => p_schedule_third_party_flag
    ,p_third_party_schedule_code => p_third_party_schedule_code
    ,p_auto_rollup_subproj_flag  => p_auto_rollup_subproj_flag
--bug 3325803: FP M
    -- gboomina Bug 8586393 - start
    ,p_use_task_schedule_flag    => p_use_task_schedule_flag
    -- gboomina Bug 8586393 - end
    ,p_record_version_number     => p_record_version_number
    ,x_return_status             => l_return_status
    ,x_msg_count                 => l_msg_count
    ,x_msg_data                  => l_msg_data );

Line: 546


         update pa_proj_elements
            set enable_wf_flag = p_enable_wf_flag
           where proj_element_id = p_proj_element_id ;

Line: 573


      pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Proj_Workplan_Attrs END');

Line: 579


         rollback to update_proj_workplan_attrs;

Line: 584


         rollback to update_proj_workplan_attrs;

Line: 588


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

Line: 592


         rollback to update_proj_workplan_attrs;

Line: 596


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

Line: 599


END UPDATE_PROJ_WORKPLAN_ATTRS;

Line: 620


PROCEDURE UPDATE_STRUCTURE_NAME
(  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     := FND_API.G_MISS_NUM
  ,p_proj_element_id               IN NUMBER
  ,p_structure_name                IN VARCHAR2
  ,p_record_version_number         IN NUMBER     := FND_API.G_MISS_NUM
  ,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_api_name                      CONSTANT VARCHAR(30) := 'Update_Structure_Name';

Line: 647


   pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Update_Structure_Name');

Line: 650


      pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Structure_Name BEGIN');

Line: 654


      savepoint update_structure_name;

Line: 690


   PA_WORKPLAN_ATTR_PVT.UPDATE_STRUCTURE_NAME
   ( p_commit                    => FND_API.G_FALSE
    ,p_validate_only             => p_validate_only
    ,p_validation_level          => p_validation_level
    ,p_calling_module            => p_calling_module
    ,p_debug_mode                => p_debug_mode
    ,p_max_msg_count             => p_max_msg_count
    ,p_proj_element_id           => p_proj_element_id
    ,p_structure_name            => p_structure_name
    ,p_record_version_number     => p_record_version_number
    ,x_return_status             => l_return_status
    ,x_msg_count                 => l_msg_count
    ,x_msg_data                  => l_msg_data );

Line: 726


      pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Structure_Name END');

Line: 732


         rollback to update_structure_name;

Line: 737


         rollback to update_structure_name;

Line: 741


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

Line: 745


         rollback to update_structure_name;

Line: 749


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

Line: 752


END UPDATE_STRUCTURE_NAME;

Line: 774


PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
(  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     := FND_API.G_MISS_NUM
  ,p_project_id                    IN NUMBER
  ,p_proj_element_id               IN NUMBER
  ,p_record_version_number         IN NUMBER     := FND_API.G_MISS_NUM
  ,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_api_name                      CONSTANT VARCHAR(30) := 'Delete_Proj_Workplan_Attrs';

Line: 800


   pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Delete_Proj_Workplan_Attrs');

Line: 803


      pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Delete_Proj_Workplan_Attrs BEGIN');

Line: 807


      savepoint delete_proj_workplan_attrs;

Line: 818


   PA_WORKPLAN_ATTR_PVT.DELETE_PROJ_WORKPLAN_ATTRS
   ( p_commit                    => FND_API.G_FALSE
    ,p_validate_only             => p_validate_only
    ,p_validation_level          => p_validation_level
    ,p_calling_module            => p_calling_module
    ,p_debug_mode                => p_debug_mode
    ,p_max_msg_count             => p_max_msg_count
    ,p_project_id                => p_project_id
    ,p_proj_element_id           => p_proj_element_id
    ,p_record_version_number     => p_record_version_number
    ,x_return_status             => l_return_status
    ,x_msg_count                 => l_msg_count
    ,x_msg_data                  => l_msg_data);

Line: 854


      pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Delete_Proj_Workplan_Attrs END');

Line: 860


         rollback to delete_proj_workplan_attrs;

Line: 865


         rollback to delete_proj_workplan_attrs;

Line: 869


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

Line: 873


         rollback to delete_proj_workplan_attrs;

Line: 877


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

Line: 880


END DELETE_PROJ_WORKPLAN_ATTRS;