APPS.PA_WORKPLAN_AMG_PUB SQL Statements

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

Line: 20

     select record_version_number
      from pa_proj_elem_ver_structure
      where element_version_id = p_structure_version_id
      and project_id           = p_pa_project_id;

Line: 26

      select pev_structure_id
      from pa_proj_elem_ver_structure
      where element_version_id = p_structure_version_id
      and project_id           = p_pa_project_id;

Line: 65

          p_function_name       => 'PA_PM_UPDATE_PROJECT',
          p_msg_count           => p_msg_count,
          p_msg_data            => p_msg_data,
          p_return_status       => p_return_status,
          p_function_allowed    => l_function_allowed );

Line: 209

     select pev_structure_id, record_version_number,name
            from PA_proj_elem_ver_structure
            where element_version_id   = p_structure_version_id
            and   project_id           = p_pa_project_id;

Line: 251

          p_function_name       => 'PA_PM_UPDATE_PROJECT',
          p_msg_count           => p_msg_count,
          p_msg_data            => p_msg_data,
          p_return_status       => p_return_status,
          p_function_allowed    => l_function_allowed );

Line: 280

        PA_PROJECT_STRUCTURE_PUB1.Update_Structure_Version_Attr
            (
            p_api_version                 => p_api_version_number
            ,p_init_msg_list               => p_init_msg_list
            ,p_commit                      => p_commit
            ,p_calling_module              => 'AMG'
        --    ,p_project_id                  => p_project_id
        --    ,p_structure_version_id        => p_structure_version_id
            ,p_pev_structure_id            => l_structure_id
            ,p_baseline_current_flag       => 'Y'
            ,p_structure_version_name      => l_name
            ,p_record_version_number       => l_record_version_number
            ,x_return_status               => p_return_status
            ,x_msg_count                   => p_msg_count
            ,x_msg_data                    => p_msg_data
            );