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

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

Line: 153


      INSERT INTO PA_PROJ_WORKPLAN_ATTR (
        project_id
       ,proj_element_id
       ,wp_approval_reqd_flag
       ,wp_auto_publish_flag
       ,wp_approver_source_id
       ,wp_approver_source_type
       ,wp_default_display_lvl
       ,wp_enable_version_flag
       ,auto_pub_upon_creation_flag
       ,auto_sync_txn_date_flag
       ,txn_date_sync_buf_days
       ,record_version_number
       ,last_update_date
       ,last_updated_by
       ,creation_date
       ,created_by
       ,last_update_login
       ,lifecycle_version_id
       ,current_phase_version_id
       ,schedule_third_party_flag
       ,allow_lowest_tsk_dep_flag
       ,auto_rollup_subproj_flag
       ,third_party_schedule_code
       ,source_object_id
       ,source_object_type)
      VALUES (
        p_project_id
       ,p_proj_element_id
       ,p_approval_reqd_flag
       ,l_auto_publish_flag
       ,l_approver_source_id
       ,l_approver_source_type
       ,p_default_display_lvl
       ,p_enable_wp_version_flag
       ,p_auto_pub_upon_creation_flag
       ,p_auto_sync_txn_date_flag
       ,l_txn_date_sync_buf_days
       ,1
       ,SYSDATE
       ,FND_GLOBAL.USER_ID
       ,SYSDATE
       ,FND_GLOBAL.USER_ID
       ,FND_GLOBAL.LOGIN_ID
       ,l_lifecycle_version_id
       ,l_current_phase_version_id
       ,l_schedule_third_party_flag
       ,l_allow_lowest_tsk_dep_flag
       ,l_auto_rollup_subproj_flag
       ,l_third_party_schedule_code
       ,p_project_id
       ,'PA_PROJECTS');

Line: 272


PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
(
   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 /* Added for Progress impact bug 3420093 */
  ,p_approver_source_type          IN NUMBER     := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
  ,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_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_lifecycle_version_id          IN NUMBER     := FND_API.G_MISS_NUM
  ,p_current_phase_version_id      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
  ,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_return_status                 VARCHAR2(1);

Line: 325


   l_delete_ok			   VARCHAR2(1);

Line: 343


   SELECT display_sequence,proj_element_id
   FROM   pa_proj_element_versions
   WHERE  element_version_id = l_current_phase_version_id;

Line: 349


   SELECT display_sequence,proj_element_id
   FROM   pa_proj_element_versions
   WHERE  element_version_id = p_current_phase_version_id;

Line: 358


   select element_version_id
   from pa_proJ_elem_ver_structure
   where project_id = p_project_id
   AND proj_element_id = p_proj_element_id;

Line: 369


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

Line: 373


      savepoint update_proj_workplan_attrs_pvt;

Line: 385


  SELECT LIFECYCLE_VERSION_ID, CURRENT_PHASE_VERSION_ID,
         schedule_third_party_flag, allow_lowest_tsk_dep_flag,
         auto_rollup_subproj_flag, third_party_schedule_code
         INTO l_lifecycle_version_id, l_current_phase_version_id,
         l_schedule_third_party_flag, l_allow_lowest_tsk_dep_flag,
         l_auto_rollup_subproj_flag, l_third_party_schedule_code
         FROM pa_proj_workplan_attr
         WHERE proj_element_id = p_proj_element_id
         AND record_version_number = p_record_version_number;

Line: 433


         SELECT LIFECYCLE_VERSION_ID, CURRENT_PHASE_VERSION_ID
         INTO l_lifecycle_version_id, l_current_phase_version_id
         FROM pa_proj_workplan_attr
         WHERE proj_element_id = p_proj_element_id
         AND record_version_number = p_record_version_number
         FOR UPDATE OF record_version_number NOWAIT;

Line: 465


         SELECT LIFECYCLE_VERSION_ID, CURRENT_PHASE_VERSION_ID
         INTO l_lifecycle_version_id, l_current_phase_version_id
         FROM pa_proj_workplan_attr
         WHERE proj_element_id = p_proj_element_id
         AND record_version_number = p_record_version_number;

Line: 549


		select proj_element_id into l_lifecycle_id
		from pa_proj_element_versions
		where element_version_id = l_lifecycle_version_id;

Line: 626


     PA_PROJECT_STRUCTURE_PUB1.update_workplan_versioning(
       p_proj_element_id => p_proj_element_id
      ,p_enable_wp_version_flag => p_enable_wp_version_flag
      ,x_return_status => l_return_status
      ,x_msg_count => l_msg_count
      ,x_msg_data => l_msg_data
     );

Line: 684


     update pa_proj_elem_ver_structure
        set SCHEDULE_DIRTY_FLAG = 'N'
      WHERE project_id = p_project_id and proj_element_id = p_proj_element_id;

Line: 701


    Modified this update for task progress bug 3420093. Added decodes with default values in following columns
    wp_approval_reqd_flag,wp_auto_publish_flag,wp_default_display_lvl,wp_enable_version_flag,auto_pub_upon_creation_flag,
    auto_sync_txn_date_flag.
  */
  --bug 3905167: added nvl for p_default_display_lvl.
      UPDATE PA_PROJ_WORKPLAN_ATTR
      SET wp_approval_reqd_flag        = decode( p_approval_reqd_flag, FND_API.G_MISS_CHAR, wp_approval_reqd_flag, p_approval_reqd_flag ),
          wp_auto_publish_flag         = decode( l_auto_publish_flag, FND_API.G_MISS_CHAR, wp_auto_publish_flag, l_auto_publish_flag ),
          wp_approver_source_id        = l_approver_source_id,
          wp_approver_source_type      = l_approver_source_type,
          wp_default_display_lvl       = decode( p_default_display_lvl, FND_API.G_MISS_NUM, wp_default_display_lvl, nvl(p_default_display_lvl,0)),
          wp_enable_version_flag       = decode( p_enable_wp_version_flag, FND_API.G_MISS_CHAR, wp_enable_version_flag, p_enable_wp_version_flag),
          auto_pub_upon_creation_flag  = decode( p_auto_pub_upon_creation_flag, FND_API.G_MISS_CHAR, auto_pub_upon_creation_flag, p_auto_pub_upon_creation_flag ),
          auto_sync_txn_date_flag      = decode( p_auto_sync_txn_date_flag, FND_API.G_MISS_CHAR, auto_sync_txn_date_flag, p_auto_sync_txn_date_flag ),
          txn_date_sync_buf_days       = l_txn_date_sync_buf_days,
          lifecycle_version_id         = l_lifecycle_version_id,
          current_phase_version_id     = l_current_phase_version_id,
          schedule_third_party_flag    = l_schedule_third_party_flag,
          allow_lowest_tsk_dep_flag    = l_allow_lowest_tsk_dep_flag,
          auto_rollup_subproj_flag     = l_auto_rollup_subproj_flag,
          third_party_schedule_code    = l_third_party_schedule_code,
          record_version_number        = p_record_version_number + 1,
          last_update_date             = SYSDATE,
          last_updated_by              = FND_GLOBAL.USER_ID,
          last_update_login            = FND_GLOBAL.LOGIN_ID
      WHERE project_id = p_project_id and proj_element_id = p_proj_element_id;

Line: 762


        UPDATE PA_PROJ_ELEMENTS
        SET phase_version_id = null
        WHERE project_id = p_project_id
	AND phase_version_id IS NOT NULL;

Line: 777


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

Line: 783


         rollback to update_proj_workplan_attrs_pvt;

Line: 788


         rollback to update_proj_workplan_attrs_pvt;

Line: 792


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

Line: 796


         rollback to update_proj_workplan_attrs_pvt;

Line: 800


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

Line: 803


END UPDATE_PROJ_WORKPLAN_ATTRS;

Line: 823


PROCEDURE UPDATE_STRUCTURE_NAME
(  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_return_status                 VARCHAR2(1);

Line: 848


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

Line: 852


      savepoint update_structure_name_pvt;

Line: 857


         SELECT 'x' INTO l_dummy
         FROM pa_proj_elements
         WHERE proj_element_id = p_proj_element_id
         FOR UPDATE OF record_version_number NOWAIT;

Line: 887


         SELECT 'x' INTO l_dummy
         FROM pa_proj_elements
         WHERE proj_element_id = p_proj_element_id;

Line: 916


      UPDATE PA_PROJ_ELEMENTS
      SET name                         = p_structure_name,
          record_version_number        = record_version_number + 1,
          last_update_date             = SYSDATE,
          last_updated_by              = FND_GLOBAL.USER_ID,
          last_update_login            = FND_GLOBAL.LOGIN_ID
      WHERE proj_element_id = p_proj_element_id;

Line: 932


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

Line: 938


         rollback to update_structure_name_pvt;

Line: 943


         rollback to update_structure_name_pvt;

Line: 947


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

Line: 951


         rollback to update_structure_name_pvt;

Line: 955


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

Line: 958


END UPDATE_STRUCTURE_NAME;

Line: 978


PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
(  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_return_status                 VARCHAR2(1);

Line: 1001


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

Line: 1005


      savepoint delete_proj_workplan_attrs_pvt;

Line: 1014


         SELECT 'x' INTO l_dummy
         FROM pa_proj_workplan_attr
         WHERE proj_element_id = p_proj_element_id
         AND record_version_number = p_record_version_number
         FOR UPDATE OF record_version_number NOWAIT;

Line: 1045


         SELECT 'x' INTO l_dummy
         FROM pa_proj_workplan_attr
         WHERE proj_element_id = p_proj_element_id
         AND record_version_number = p_record_version_number;

Line: 1076


      DELETE FROM PA_PROJ_WORKPLAN_ATTR
      WHERE proj_element_id = p_proj_element_id;

Line: 1088


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

Line: 1094


         rollback to delete_proj_workplan_attrs_pvt;

Line: 1099


         rollback to delete_proj_workplan_attrs_pvt;

Line: 1103


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

Line: 1106


END DELETE_PROJ_WORKPLAN_ATTRS;