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_WORKPLAN_ATTR_PUB SQL Statements

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

Line: 305


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
  ,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: 360


   pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Update_Proj_Workplan_Attrs');

Line: 363


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

Line: 367


      savepoint update_proj_workplan_attrs;

Line: 473


   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
    ,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: 505


         update pa_proj_elements
            set enable_wf_flag = p_enable_wf_flag
           where proj_element_id = p_proj_element_id ;

Line: 532


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

Line: 538


         rollback to update_proj_workplan_attrs;

Line: 543


         rollback to update_proj_workplan_attrs;

Line: 547


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

Line: 551


         rollback to update_proj_workplan_attrs;

Line: 555


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

Line: 558


END UPDATE_PROJ_WORKPLAN_ATTRS;

Line: 579


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: 606


   pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Update_Structure_Name');

Line: 609


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

Line: 613


      savepoint update_structure_name;

Line: 649


   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: 685


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

Line: 691


         rollback to update_structure_name;

Line: 696


         rollback to update_structure_name;

Line: 700


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

Line: 704


         rollback to update_structure_name;

Line: 708


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

Line: 711


END UPDATE_STRUCTURE_NAME;

Line: 733


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: 759


   pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Delete_Proj_Workplan_Attrs');

Line: 762


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

Line: 766


      savepoint delete_proj_workplan_attrs;

Line: 777


   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: 813


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

Line: 819


         rollback to delete_proj_workplan_attrs;

Line: 824


         rollback to delete_proj_workplan_attrs;

Line: 828


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

Line: 832


         rollback to delete_proj_workplan_attrs;

Line: 836


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

Line: 839


END DELETE_PROJ_WORKPLAN_ATTRS;